Open To Work
Divyen Joshi
Mastercard
Pune,Maharashtra
Work Preference
Job Search Status:
Open to work
Desired start date:
Open to discussion
Desired Job Title
Principal Data EngineerGroup Delivery ManagerSenior ETL Tech LeadETL Project Lead
Work Type
Full Time
Location Preference
Hybrid
Location:
Pune, Maharashtra, CA
Open to relocation:
Yes
1
Certification
29
years of professional experience
Techno-functional Professional with over 24+ years of global IT experience in handling clients from APAC, EUROPE, UK and USA and delivering projects in Data warehousing/Business Intelligence, Application Data Migration and Data Analytics. Have strong Database skills ranging from Data Analysis to Data Analytics.
Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL, Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.
Work History
Principal Data Engineer
3 Years 10 Months- Collaborated with stakeholders to comprehend and document their requirements for informed decision-making.
- Guided team in implementing best practices for database design and management to enhance efficiency.
- Engaged with stakeholders to align capacity planning efforts with organizational goals.
- Clarified and articulated functional requirements to ensure team understanding and effective implementation.
- Architected and maintained robust database solutions, ensuring alignment with overall project objectives.
- Delivered actionable insights through merchant fraud dashboard and fraud insights dashboard to track fraud KPIs effectively. Enhanced understanding of transaction trends related to chargebacks, declines, and fraud through comprehensive analysis. Achieved comparative insights for merchants by benchmarking against industry and regional standards using established metrics.
- Enhanced merchant decision-making through insights into chargebacks, declined transactions, and fraud activities. Identified key patterns in fraud, chargeback, and decline transactions to drive process improvements. Enabled competitive benchmarking against industry, regional, and peer standards to optimize operational performance.
- Enhanced ETL processes by implementing advanced techniques for improved data retrieval.
- Engaged with cross-functional teams to clarify data requirements and implement tailored solutions.
- Designed and implemented data models to facilitate informed decision-making through analytics and reporting.
Group Delivery Manager
10 Years 11 Months- Common GOAL
- ROI – Always aiming to achieve the best possible solution in the minimum sprints
- Priorities – Setting priorities on each & every task based on ROI.
- Requirements Clarifications – Product knowledge and requirements clarifications
- Negotiations – On time and matters meeting
- Escalations – Bringing attention on issues where more visibility/help is required
- Communications – Clear & timely communication on all matters of concerns.
- Vision – Creating a Product Roadmap & constant guidance on meeting the GOAL
- Risk Management – Providing visibility & proactive communications on project plan and any blockers w.r.t resource, subject knowledge, or variables much ahead of time
- Sprint Planning & Backlog Grooming – Managing continuous discussions on requirements till complete clarity
- Backlog Management – Create 2-3 sprint ahead plan based on the priority
- Daily Scrum – Keeping team aligned and removing any roadblocks impacting development.
- Presales tasks - customer technical interaction, proposals and meetings
- Talent - Nurtured talent within the company and recruited BI/Analytics talent
- Practice - Set up a Data Analytics Practice team from scratch
- Web Analytics Reporting: Designed and Developed a Reporting solution which comprised of Data Warehouse and Cube population. This reporting solution helped the customer in identifying the performance of the Web application and also helped in understanding the underlying issues and preferences of customers related to the Web Application.
- ResponseEye – Rewrite in OutSystems: Rewrite of an existing product called ResponseEye to OutSystems platform. This project was about re architecting the product and developing it from scratch in OutSystems Platform (Low Code No Code)
- Metrics Automation: Developed an Azure Cloud based solution. This was about capturing data for different projects from Azure DevOps (ADO) and showcasing the data in Power BI to Management for control and monitoring purpose. This project saved the outflow of £ 2,50,000 revenue of CAPITA. Played the role of Solution Architect with End to End Responsibilities.
- Smart Metering: Developed data warehouse for energy and utility client, with UK Government was a major stakeholder. This project is about Migration of Gas & Electric meter across each household in UK to Next Generation SMART meters (Giving a portability option to End Users). This Data warehouse supported MCC (Migration Command Center) and its operations with near real time data.
- DACA: Developed data warehouse solution for CAPITA client. Client of CAPITA was facing issue with Legacy Reporting System. After Multiple attempts to replace the Legacy Reporting System they approached CAPITA. Worked as a Technical Solution Architect, developed & designed Data warehouse (including Hardware architecture) from scratch. New system replaced Legacy reporting system and provided cross functional reports on the GO which was highly appreciated by the Client Management and CAPITA Management team.
- Unity: This was a multi-year program to migrate Policy Administration System residing in Legacy to ERP system. Instrumental in development of automated process for data reconciliation (Important milestone to get a sign off from End Client)
- Sybase Migration: This was a multi-year program to migrate Policy Administration System residing in Elixir (Third Party Developed) to Sybase (In house developed) system. Instrumental in development of automated process for data reconciliation (Important milestone to get a sign off from End Client)
- Upgrade of Business Object: This was a program to migrate Business Object 3.0 & SAP BI 3.1 to SAP BI 4.1.
Senior ETL Tech Lead
3 Years 5 Months- Responsibilities: Worked on Requirements gathering, ETL designing. Writing SQL, PL/SQL queries for data analysis, testing and performance tuning of ETL batch jobs. Worked on Designing & developing of Data Warehouse & Business Intelligence solutions.
- JDNMQ (New Model Qualifier): Application where Deere Checks the eligibility of its Dealer to sell a Model. Through this application Deere checks the Qualification of Dealer based on Parts Qualification, tools Qualification & Training Qualification.
- JDAim (Sales Aiming): Application the sales team & Dealers can get the sales lead, they can search for the Sales & Servicing contracts of the customer. They can check the Affiliations of the Customer.
- JDScorecard (Dealer Scorecard): Application for tracking dealer performance
- JDQuote (Quotes): Application used by end client for getting quote of John Deere product based on customized configuration
- JDSalesIncentives (Sales Incentives for Dealers): Application to track Incentives of Dealers
- JDGCPR (Complete Goods Processing Report): Application to track and report and generate invoices for complete goods passed to dealer
- MKC (Machine Knowledge Center): Application responsible for tracking Geo location and health of each machine running in field.
ETL Project Lead
2 Years 10 Months- Responsibilities: Worked on Application Support and Enhancement of Enterprise Data Warehouse.
- Unified Asset Portfolio Management: This application was about maintenance of different types of assets and their management
- Financial Services Provider: Cardinal Health moved from Legacy Systems to SAP - FICO. Migrated data into staging area. Used LSMW (Utility provided by SAP) to pump in data into the SAP.
- Customer Reporting & Application Support and Maintenance (AS&M): As per the Service Agreement Cardinal Health needs to send to its client data Sales extract from its Data Warehouse. This Extract were sent on Daily, Bi-weekly, Bi-Monthly, and Monthly Basis to its client
- Equivalent Product List: Cardinal Health had a variety of Product. Each Product has a list of equivalent products. Cardinal required generating some reports to do comparison between the Leader Product item and Brand Product item. There was a Many to Many relationships between the Brand and a Leader. Developed a snowflake schema and loaded the data to the Data Warehouse.
- Customer Inventory Analytics: Reporting solution which provided enhanced analytics to the Inventory Management and used by Internal Sales team and participating clients
Programmer
8 Months- Responsibilities: Worked on Support and Enhancement of Enterprise Data Warehouse.
- PDA Hub Co., Taiwan Brokerage: Application targeted to provide Estate Agents the latest and accurate information of the available Estates and their current status using XTND Connect Server with different operating systems i.e. Win CE & Palm.
Programmer
6 Months- Responsibilities: Worked on Support and Enhancement of Enterprise Data Warehouse.
- Singapore Airlines, Singapore: Phoenix was an application to provide Latest and Accurate information of the Aircraft in the Bay to the Engineer in the Field using a PDA.
- Extended System Pte Ltd., Singapore: PLXSRV was an Intranet web site. The Intranet Web Site contains all the daily need stuffs like Extension numbers, how to access voice mail. It was also providing Online Leave Application Form, Online Subsidiary Application, Online Travel request Application
Programmer
9 Months- Responsibilities: Worked on Support and Enhancement of Enterprise Data Warehouse.
- Healthcare Module: This module was to be a part of the services provided by the Grapewyne Portal. This Module was about information about Doctors, Diagnostics Centers, Blood banks and other medical related information. The unique feature in this site was about its search engine. As the search engine was designed in such a way that the search would be faster and the page would be displayed faster.
Programmer
2 Years 4 Months- Responsibilities: Worked on Support and Enhancement of Enterprise Data Warehouse.
- Invoice & Stock Maintenance: development of Invoicing & Stock Maintenance project for Indiana Tools Syndicate. This Contract involved Installation of hardware, Software and development of Application for Stock Maintenance and Invoicing.
Education
MCM - Master of Computer Management
Bachelor of Science - Statistics
Skills
Worked on multiple projects as a Technical Architect
developed and designed End to End solutions (Snowflake -Azure
Azure Cloud – Data Factory
SQL Server
Power BI)
Hands-on technologist with strong hold of data warehousing concepts
SQL
and relational modeling
Designing & implementing scalable solutions
catering to complex business rules and requirements
Experience of managing medium to large teams
Wrangling data from multiple sources including Master data
Product
and Customer databases to create integrated views that can be used to drive decision making
Having expertise in providing End to End Data warehouse & Reporting solution i.e. from Requirement Gathering
Resource planning
Designing
and proposing Architecture (Software & Hardware)
Deployment
Training End Users and transitioning it to the Support team
Experience in Migrating Application Data from Legacy systems to ERP
Cloud Database: Snowflake
ETL Tool: Azure Data Factory (ADF)
Informatica
SSIS
SSRS
OLAP Tool: Business Objects XI R4.1
Power BI
Data Modeling Tool: Erwin
DBMS/RDBMS (On-Prem): Teradata
DB2
Oracle & SQL Server
Programming Languages: Python
VB 6.0
C & C++
Low code No Code: OutSystems
Accomplishments
- Worked on cost optimization by analyzing performance and identifying bottlenecks, which were successfully implemented, resulting in a savings of approx. $1.5M / year
- Optimized costs and brought efficiency leading the efforts and preparing strategy for data loading of approx. 500+ billion records per month, resulting in bringing the load time from 12 days to 8 hrs, and $0.3M / year savings
- Lead a cross functional team of 14 members for a Platform migration (Policy Administration System) for an Insurance giant, resulting in '0' post migration defects
- Delivered an End to End working solution in 6 week time frame on Low code No code - OutSystems platform
Certification
- Object Oriented C++ from Computer Society of India, Indore Chapter
- Informatica Mapping Designer
- IBM Certified Database Associate – DB2 Fundamentals
Timeline
Principal Data Engineer
Mastercard
08.2022 - CurrentRead More
Group Delivery Manager
CAPITA
09.2011 - 08.2022Read More
Senior ETL Tech Lead
John Deere Technology Center of India
04.2008 - 09.2011Read More
ETL Project Lead
Wipro Technologies, Bangalore
06.2005 - 04.2008Read More
Programmer
iFoundry Systems Pte Ltd, Singapore
06.2001 - 02.2002Read More
Programmer
Frontier Technologies Pte Ltd, Singapore
11.2000 - 05.2001Read More
Programmer
Grapewyne Technologies, India
01.2000 - 10.2000Read More
Programmer
Indiana Tools Syndicate
08.1997 - 12.1999Read More
Devi Ahilya University
MCM from Master of Computer Management
Read More
Devi Ahilya University
Bachelor of Science from Statistics
Read More