Mukul Varshney
Manager - Data Analytics & Insights
Bengaluru
Summary
With 12+ years of experience in data analytics and a diverse background across Telecom, Health Care, Retail, Investment Banking/Payments, Finance Services, and Manufacturing, expertise lies in delivering Business Intelligence and Data Warehousing solutions. Successfully led and collaborated on cross-site and cross-team projects, designing insightful BI solutions/portfolios. Motivated by data-driven results, possess deep expertise in database management, SQL, ETL/ELT, and visualization tools. Proficient in managing complex projects involving Big Data and OLAP on both on-premises and cloud platforms. Prioritizes data governance to improve data delivery efficiency by 25%.
Overview
14
14
years of professional experience
2
2
Certifications
2
2
Languages
6
6
years of post-secondary education
Timeline
Financial Systems Re-Engineering (Senior)
Hewlett-Packard Enterprise (HPE)
01.2024 - Current
Data Analytics Manager
Ernst & Young (EY)
05.2023 - 09.2023
Senior Technical Lead
Thought Focus
02.2019 - 02.2023
Implementation Lead
Majorel (Former Ramyam Intelligence Lab)
10.2017 - 12.2018
Technology Consultant
Hewlett-Packard
03.2013 - 09.2017
Master of Computer Applications -
Janardan Rai Nagar Rajasthan Vidyapeeth University
01.2013 - 12.2016
Technology Consultant
Jnet Technologies Pt Ltd.
10.2011 - 01.2013
Software Developer
Nvish Solutions
05.2011 - 10.2011
Bachelor of Computer Applications -
Vinayaka Missions Universiy
01.2011 - 12.2012
Work History
Financial Systems Re-Engineering (Senior)
Hewlett-Packard Enterprise (HPE)
01.2024 - Current
- Directed the Enterprise Data Warehousing and Analytics infrastructure for Financial Systems in Product and Services units, boosting data processing efficiency by 20%.
- Implemented SAP Embedded Analytics (SAP HANA, S4, B4P) to streamline data integration and reporting processes, resulting in a significant increase in operational efficiency for the Financial Planning & Analytics team
- Drive joint projects between FP&A team, IT vendors, and CXO users ensuring ethical data practices.
- Created efficient ETL pipelines and robust data models utilizing Hadoop, Spark, Python and machine learning frameworks (Prophet, XGboost).
Data Analytics Manager
Ernst & Young (EY)
05.2023 - 09.2023
- Managed the Data Engineering vertical, collaborating with data architects, engineers, and modelers to design Data Lakes, Data Warehouses, and Data Marts for public sector organizations
- Implemented BI dashboards and reports
- Designed and implemented a data governance solution supporting data management, data lineage, and increased team velocity, using Microsoft Purview
- Assisted in migrating Oracle Apps to Oracle Cloud - Fusion ERP by designing the data model and creating an extraction process for data migration, aligning with technical leadership and project priorities
- Worked closely with Partners, Team Leads/Managers and Technical Program Managers to align on the deliverables and priorities by defining KPIs and metrics to help us deliver the best possible results for the clients
Senior Technical Lead
Thought Focus
02.2019 - 02.2023
- Led the Data Analytics team in creating analytical reports and dashboards in Tableau & Power BI, using source datasets from SAP, Oracle, Snowflake, REST APIs, DBT and flat files in cloud and on-premises environments
- Proficiently gathered requirements from business owners and translated them for the design, development, and testing teams, aligning with project priorities and schedules
- Contributed to BRD, FSD, Use Cases, and modeling techniques
- Designed dashboards and data summaries for technical and non-technical audiences, facilitating the implementation of business strategies and missions, contributing to team scaling and success
- Built analytical models for descriptive and predictive analysis and created ETL pipelines in PL/SQL, Python, and Azure Data Factory, aligning with operational processes and project needs
- Developed DAX Measures, Parameterized Queries, and various reports, including Tabular reports and Paginated reports, emphasizing interactive and insightful dashboards and reports
Implementation Lead
Majorel (Former Ramyam Intelligence Lab)
10.2017 - 12.2018
- I oversaw the complete execution of Proof of Concept (POC) and program management, collaborating with global companies, product and implementation teams
- My focus was on achieving project success, addressing project complexity, and prioritizing key team objectives, aligning with the job's requirements
- Enhanced the CUBE analytics-based BI Module of the CEM/CRM Product, aligning with innovative solutions and product development
- Successfully delivered the Employee Engagement Solution with complex analytical Dashboards and Timeline components within a short span of time, reflecting operational efficiency
- Utilized prominent big data technologies, including Google Cloud Platform (GCP), Apache Spark, Hadoop HDFS, NoSQL databases (MongoDB), Drill, Python, and R, to excel in Sentiment & Intent Analytics and data modeling, highlighting proficiency in leveraging GCP for big data solutions
Technology Consultant
Hewlett-Packard
03.2013 - 09.2017
- Technical/Solution Lead with team of Oracle Data Warehousing developers specialized in various domains like Telecom, Banking and HealthCare
- Migration of the existing banking applications and Implantation of Operational Data Store (ODS) and Enterprise Data Warehouse (EDW), further followed by analyzing day to day business performance for productive banking operations
- Worked on data modeling, ETL workflow design, and BI Dashboard/Reports development using Microsoft Power BI, supporting high and low-level decision-making, emphasizing strong SQL analytics
- Set up Azure infrastructure, including Virtual Networking, Network Security Group, DNS Zone configuration, VM Assignments/Adjustments, aligning with technical and project priorities
- Followed Agile Methodologies in Product development for Innovative Health Care software (US Govt.), emphasizing agile methodologies and project alignment
Technology Consultant
Jnet Technologies Pt Ltd.
10.2011 - 01.2013
- Designed, implemented, and supported the DSS Data Warehouse for Bharat Sanchar Nigam Limited (BSNL) to analyze and generate reports for profits and loss, churn rates, and New Connections, demonstrating data quality and governance
- Utilized Mediation Tools, ETL Resource Informatica Power Center, and Business Intelligence Tool (IBM Cognos BI Tool), reflecting expertise in data analytics and insights
Software Developer
Nvish Solutions
05.2011 - 10.2011
- Implemented, administered, and tuned databases for website and CMS portal, including web-based reporting and automated email features, resulting in improved processes and data-driven decision-making
Education
Master of Computer Applications -
Janardan Rai Nagar Rajasthan Vidyapeeth University
Udaipur, India 01.2013 - 12.2016
Bachelor of Computer Applications -
Vinayaka Missions Universiy
Salem, India 01.2011 - 12.2012
Certification
Microsoft Azure Fundamentals, AZ-900, Microsoft, 04/01/22
Awards
- Technology Champion Award, ThoughtFocus, 04/01/22
- Superstar, Hewlett-Packard, 04/01/15
Skills
Data Engineering (ETL) & Analysis (Modeling)
undefinedLanguages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Similar Profiles
Gaurav ShewaramaniGaurav Shewaramani
North America Channel Sales Director - Compute at HEWLETT PACKARD ENTERPRISE (HPE)North America Channel Sales Director - Compute at HEWLETT PACKARD ENTERPRISE (HPE)
Anmol DhankharAnmol Dhankhar
Machine Learning Engineer at Hewlett Packard Enterprise (HPE)Machine Learning Engineer at Hewlett Packard Enterprise (HPE)
Aiten Garnita-TosumAiten Garnita-Tosum
Team Leader, Operation Coordinator at Hewlett Packard Enterprise, HPETeam Leader, Operation Coordinator at Hewlett Packard Enterprise, HPE
Soumya Saraswat SahooSoumya Saraswat Sahoo
Network Protocol Test Engineer at Hewlett Packard Enterprise (HPE)Network Protocol Test Engineer at Hewlett Packard Enterprise (HPE)
Hemendu JoshiHemendu Joshi
Lead Technology Manager – Creative Technology & Innovation Management at UnileverLead Technology Manager – Creative Technology & Innovation Management at Unilever