![Photo of Pranav Gupta](/_next/image?url=https%3A%2F%2Fprod-outdefine-resume.s3.amazonaws.com%2F3dcc05f7-859b-4d8a-ab0a-0190a3c47e75.png&w=320&q=100)
![trusted member badge](/_next/image?url=%2F_next%2Fstatic%2Fmedia%2Ftrusted_badge.249fc485.png&w=128&q=75)
Pranav Gupta
Data Analyst
Pune, Maharashtra, India
1
Followers1
FollowingA commercially astute Data analyst with knowledge in data analysis, warehousing, creating and running ETL jobs, AWS Redshift and data visualization using BI tools and developing AWS Cloud-based applications. My peers,clients, and business partners alike recognize me as an relationship builder and fast learner.
Careers
Business Technology Solution Associate
ZS Associates
Full time contract12/2021 - 09/2023
- Collaborated on an ongoing 10+ year project for global pharmaceutical leader Merck Co., focusing on Sales Force Alignment and Sales Crediting.
- • Worked on designing and developing systems for processing of Rx(Prescription Sales data), DDDMD, IQVIA, VEEVA Vaccines sales using Unix shell scripting and SQL by leveraging AWS Redshift , AWS EC2 and AWS Collaborated on an ongoing 10+ year project for global pharmaceutical leader Merck Co., focusing on Sales Force Alignment and Sales Crediting.
- • Worked on designing and developing systems for processing of Rx(Prescription Sales data), DDDMD, IQVIA, VEEVA Vaccines sales using Unix shell scripting and SQL by leveraging AWS Redshift , AWS EC2 and AWS S3
- • Utilized Python, along with libraries such as Pandas, NumPy, and Matplotlib, to generate valuable sales insights. Implemented automation for manual quality checks, leveraging these tools for improved efficiency and accuracy.
- • Optimized AWS costs by utilizing multiple services, including CloudWatch, to monitor and manage resource usage effectively. Achieved cost savings while maintaining performance and scalability.
- • Collaborated in a lift and shift project involving the migration of an existing system to an upgraded version, ensuring a seamless transition with minimal disruptions.
Education
Institute of Engineering and Technology,DAVV,Indore
Electronic and Telecommunications engineering
05/2018 - 05/2022Bachelor's DegreeClass of 2022
Collections
Assessment badge
Completed assessment
09/15/2023
![Skill Verification](/_next/image?url=%2F_next%2Fstatic%2Fmedia%2Fbadge-blue.ae788d24.png&w=320&q=100)
Skills
PythonData analyticalSQLAWSUnixPower BIProblem-solvingWorking with dataData pipelineMicrosoft Excel
ExperienceMid-level1-3 years
Hourly rate$23/hr
Open to
remotehybridonsite
Welcome to Outdefine
A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!
Join for free