Pushpen Joshi
HYDERABAD
Summary
Data analysis and modern data engineering professional with 3.5 years of strong corporate experience. Proven problem-solving abilities, task-driven approach, and attention to detail. Two-time GCP Certified Professional with a track record of generating business-critical insights through cross-functional collaboration. Effective communicator, adept at working in Agile Methodologies.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Analyst
Novartis
Hyderabad
08.2023 - Current
- Working as an analyst in ensuring incentive processing of Field Force Operations in the APMA region.
- Optimized the data model and processing flows for Incentive calculation in Javelin Incentive Manager and Alteryx using ETL and SQL knowledge.
- Processed and successfully delivered the incentives for four countries every quarter, benefiting a field force of 2,500 to date, with 100% accuracy and timeliness.
- Generated and provided insights based on the data to support business development.
- Technology Used: SQL, Javelin Incentive Manager, Advanced Excel, SharePoint, Alteryx, Power BI.
System Engineer
Tata Consultancy Services Ltd
Ahmedabad
03.2021 - 07.2023
- Extracted, transformed, and migrated data from a large inventory data of volume 1 million in the Data Migration Project.
- Managed customer interactions, facilitated cross-functional communication, and provided regular progress reports for timely solution delivery.
- Created efficient SQL queries for data validation and migration, and implemented the flow using Pentaho transformation.
- Enhanced query performance by 30%, and reduced the execution time for data pipelines by 50% for ETL pipelines.
- Extensive experience with databases like PostgreSQL, MySQL, and MariaDB in stored procedures, views, functions, and query optimization.
- Have hands-on experience in data analysis using Python.
- Experience in Git/GitHub.
- Have a good understanding and hands-on experience with Google Cloud Platform and tools such as BigQuery, Looker Studio, DataPrep, Cloud Storage, Cloud SQL, Dataflow, etc.
End to End Modern Data Engineering Project
Individual Project
05.2023 - 07.2023
- Designed and implemented an end-to-end data pipeline for NYC Trip Record Data, involving data extraction, transformation, modeling, and visualization.
- Optimized the modeling and transformation using fact and dimensional modeling concepts.
- Enhanced data-driven decision-making capabilities by providing actionable insights and visual representations of the data.
- Technology Used: SQL, Python (Pandas), Lucidchart, GCP Cloud Storage, Google BigQuery, Mage, Looker Studio.
Education
B. Tech - Electronics & Comm. Engineering
G.B. Pant Institute of Engineering
Pauri, Uttarakhand11-2020
Skills
- SQL and Databases
- Power BI
- Data Warehousing
- Advance Excel
- Google Cloud
- BigQuery
- ETL tools Pentaho, Alteryx
- Data Modeling
- Azure Cloud
- Javelin Incentive Manager
- Analytical Thinking
Certification
- Google Cloud certified - Professional Data Engineer
- Google Cloud certified - Associate Cloud Engineer
- Microsoft Certified - Azure Fundamentals AZ-900
- Python - Udemy
- Tableau A-Z Learning Course - Udemy
- SQL essential training - LinkedIn Learning
Accomplishments
- Received three client appreciations and two team appreciations for excellent performance and timely delivery of projects in Novartis.
- Recognized and awarded as ‘Most Promising New Comer’ by the President and Global Head of TCS Interactive.
- Received ‘On the Spot Award’ for sheer dedication towards to Go-Live for project (TCS).
- Received ‘Appreciation Certificate’ from Delivery Manager for single-handedly handling Network Inventory Data Migration.
Timeline
Analyst
Novartis
08.2023 - Current
End to End Modern Data Engineering Project
Individual Project
05.2023 - 07.2023
System Engineer
Tata Consultancy Services Ltd
03.2021 - 07.2023
B. Tech - Electronics & Comm. Engineering
G.B. Pant Institute of Engineering
Similar Profiles
Ganesh TsavatapalliGanesh Tsavatapalli
Compliance Expert at NOVARTISCompliance Expert at NOVARTIS
Gustavo Caetano CostaGustavo Caetano Costa
Cell Processing Specialist 2 at NovartisCell Processing Specialist 2 at Novartis
Nancy JasgurNancy Jasgur
Executive Territory Account Specialist at NOVARTISExecutive Territory Account Specialist at NOVARTIS