Divya Malhotra
Project Manager
Gurugram,haryana
Summary
14 Years of IT experience with expertise in data analytics along with business intelligence. Strong knowledge on Commercial and digital marketing data in Healthcare industry. Skilled in Client relationship, Data Analytics using SQL, presenting data in Power BI and business analysis. Leading a team of 30+, delegating tasks and providing guidance for the deliverables. Collaborate with stakeholders to define data requirements and prioritize projects based on business needs. Collaborative leader partners with coworkers to promote engaged, empowering work culture. Documented strengths in building and maintaining relationships with diverse range of stakeholders in dynamic, fast-paced settings.
Overview
14
14
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
Work History
Manager
Indegene
Gurgaon
2022.11 - Current
- Lead a team of20 data engineers in the development, deployment, and maintenance of robust data pipelines and ETL processes to ensure data accuracy, reliability, and availability
- Collaborate with stakeholders to define data requirements and prioritize projects based on business needs
- Implement best practices for data governance, data quality assurance, and data security to ensure compliance with industry regulations
- Designed and implemented data models in Snowflake for our project, ensuring data integrity and performance
- Collaborated with cross-functional teams to gather requirements and define data structures to support business needs
- Optimized database schemas and queries for improved efficiency and performance
- Developed and maintained ETL processes to load data into azure data lake from various sources
- Conducted performance tuning and troubleshooting to address issues and optimize query performance
- Documented data models, schema designs, and ETL processes for reference and knowledge sharing
- Mentor and coach team members, conduct performance evaluations, and provide ongoing feedback to foster professional growth and development.
Senior Consultant
Deloitte Consulting
Gurgaon
2015.01 - 2022.10
- The role is part of the Health Care Organization and supporting data quality work for commercial data
- Data quality team drives data analysis, automation of complex business checks and issue reporting of identified issues for various data sources across 90+ countries
- Managing the Data integration work for LMS system across EDB layers
- Managing a team of 30+ people to guide them for the business rules and checks to be implemented as part of data quality work for commercial data
- Responsible for bringing innovative solutions in the team for complex problems
- Assisting data stewards to improve the process related to their business
- Driving requirements gathering and identifying scope for each sprint
- Doing effort estimation using demand management tracker to ensure the project follow a structured delivery approach within the set tolerances
- Leading team of developers to create a platform, which will replace all manual reporting
- Resolving high level conflicts by making broad decisions or negotiating with affected senior management.
Associate
Mphasis
Bangalore
2012.09 - 2014.10
- The applications cater to provide data to various marketing groups of a major pharmaceutical company
- The data is received from an external vendor, is processed and then loaded in various databases and supplied to the respective business owners for further analysis and processing
- Understanding the Business Requirements and Develop an ETL process to load data from source to target.
Analyst
Mphasis
Bangalore
2010.04 - 2012.08
- Gathering the requirement for cleaning the data from client
- Develop Mappings to clean the data based on the rules and doing unit testing
- Create reports based on requirement and send to MDM team
- Motivating the team members to develop and deliver effective defect free solutions
- Developing and delivering the solutions within the timeframe
- Extensively used Informatica power center for loading the data from sources involving flat files to target as relational table
- Mainly involved in ETL developing to Extract, Transform and Load the data into stage area and data mart
- Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, Normalizer, and Sequence Generator to develop Data Mart from staging area
- Creation of sessions for mapping and validate the session
- Schedule and monitor the sessions workflows using Informatica workflow manager and workflow monitor, daily basis
- Used technologies like Informatica Cloud, Salesforce platforms shared in the process
- Worked as a Data analyst to understand the data application
- Received accolades from the client for various out developed.
Education
Bachelor of Science - Computer Science
Amity University
Noida 2005.04 - 2009.10
Skills
Data Modelling
Business Intelligence
JIRA
Agile
Informatica
Python
SQL
Snowflake
ETL
Reporting
Analytical Skills
Project Management
Strategic Planning
Certification
Effective Visualization in Tableau
Projectshighlights
- Pfizer: Developed in Tableau/SQL Dashboard highlights the data quality issues and brings out any outlier information. Also connects engineering teams across various platforms for regular health check of data. Saves overall 1hr daily for the commercial desk in connecting all the dots.
- Eli lilly: Developed various components in informatica and salesforce to implement integration with other system.
- Avnet Data Cleansing: Created reports based on requirement and send to MDM team and developed mappings in informatica to cleanse the data.
- Presbyterian Health Care System: Developed in ETL to streamline the data coming from several system fix the data gaps, introduce additional checks. Reduce the dependency on the technology team for reporting and fixing data gaps.
- Novartis: Developed re-usable snowflake dashboard to analyse the difference between sources like Datorama and N2.
Rewardsandrecognition
- Deloitte: Applause Award – Excellent Client Delivery (2021), Outstanding Award 2019, Applause Award – SME for Sales and HCP data (2018)
- Mphasis: Quarterly Award 2011
Currentlocation
Gurugram
Personal Information
- Date of Birth: 06/02/87
- Marital Status: Married
Timeline
Manager
Indegene
2022.11 - Current
Senior Consultant
Deloitte Consulting
2015.01 - 2022.10
Associate
Mphasis
2012.09 - 2014.10
Analyst
Mphasis
2010.04 - 2012.08
Bachelor of Science - Computer Science
Amity University
2005.04 - 2009.10
Effective Visualization in Tableau
Completed Big Data Analytics Training
Completed Training on: Tableau, Life Sciences and Health Care, Informatica Cloud (CDQ), Data Science tool (DataIKU)
Similar Profiles
Preetam PandaPreetam Panda
Junior Drupal Developer at IndegeneJunior Drupal Developer at Indegene
KOLAKALURI SESHU KUMARKOLAKALURI SESHU KUMAR
Account Manager at IndegeneAccount Manager at Indegene
MAMATHA MMAMATHA M
WEB DEVELOPER at IndegeneWEB DEVELOPER at Indegene