Summary
Overview
Work History
Education
Skills
Certification
Timeline
CustomerServiceRepresentative
Sneh Bhat

Sneh Bhat

Greater Noida West

Summary

Experienced Data Analytics Professional with 10.8 years of expertise in building Cloud Data Engineering and Visualization Solutions. Skilled in leading team of Data engineers, BI & Data warehouse/lakehouse developers, dashboard developers. Experienced in preparing low level and high level technical design specification for developers. Worked on solutions leveraging AI /GenAI/Agents/ML capabilities for generating Insights from large datasets. Recognized for delivering impactful data storytelling to senior business stakeholders.

Overview

11
11
years of professional experience
4
4

Certifications in Data Engineering

Work History

Data Engineering and Visualization Manager

EY (Ernst & Young) GDS
02.2021 - Current
  • Data Engineering Lead for EY Insights Data Platform (Markets Engine): Leading on design and implementation of cloud data engineering platform for EY Markets Engine Product which is Enterprise Level Cloud Data Platform to generate Insights for Senior EY Partners across different sectors like Consumer, Tax, Energy etc. The Markets Engine is key for EY to help win Clients and has different areas to generate Insights like Survey Intelligence Platform (EY flagship Tier-1 surveys which has opinions of C-suite, Board members and Senior firm leaders of top companies),with data insights capabilities using AI agents), Earnings call transcript analysis, Forecasting models for energy and automotive Sector, EY Future Consumer Index etc. My role was to lead on Data Engineering components and handling a team of 5-7 data engineers. The skills and tools we use Azure SQL, Blob Storage, Azure, Databricks, Python, SQL, Alteryx to build data pipelines and data infrastructure. The data was semi structured and structured.
  • Data Visualization SMR for EY Insights Clients Engagement Channel: Leading a team of 5 data visualization for Data visualization pillar as SMR. The role was to independently handle client conversations, understand and gather data visualization requirement. Prepare dashboard mock-ups and lead development team from delivery perspective. In my tenure in EY, successfully delivered advanced 30+ Power BI dashboards for different clients.
  • Data Storytelling for EY Though Leadership on ey.com: Data visualization is a key for EY to tell compelling stories in their flagship Though Leadership articles hosted on ey.com. In my tenure in EY -developed 500+ interactive data visuals for Tier-1 publications on ey.com for 70+ thought leadership projects using flourish/D3.js for different sectors and service lines like Consumer, Tax, Energy, Consulting, Automotive and Manufacturing. This helped me to achieve Data visualization GOLD badge in EY.

Senior BI Developer

Clifford Chance
02.2019 - 02.2021
  • Senior BI/Data Warehouse developer: Worked on Azure Cloud migration project for Clifford Chance’s Enterprise level Data warehouse solution (CCDW) which is a source for 30+ financial and operations reports and dashboards for Senior Partners and Business Leaders.
  • As a Senior BI/Data Warehouse Developer, my role was to work in Agile SAFe process and use my technical skills to help migrate/new developments of over 100 Complex SSIS Packages on Azure Data factory, 500 Database objects such as facts, dimensions, stored procedures, and views to Azure SQL and Synapse. Also handled migration/fresh development of 20 SSRS reports 10 Power BI dashboards, and 5 Tableau dashboards. Migration of 20+ SSAS cubes to Azure AAS.
  • Power BI dashboard developments: Time recording and compliance dashboard, Profitability dashboard for Billing Partners. The dashboards developed were advanced level with high technical complexity in DAX, RLS, Drill-through, Data Optimization
  • Managed Power Bi dashboards/ workspaces, access for 600+ Billing Partners/Equity partners, 3000+ Managing Associates and 5000+ Fee earners of the firm.
  • Worked on Tableau refresh automation, automated deployment (CI/CD), automated backups, and business requirements development. Worked in Agile SAFe (Scrum) framework.

Senior Software Engineer

Pure software Pvt. Ltd.
04.2018 - 02.2019
  • Client – Encore Capital Group: Developed 20+ SSIS packages for Daily Production Operations process with Severity-1 on Production. The data was a key for Dialer's to summarize mortgaged financials
  • Used complex ETL techniques like Change Data Capture, pulling data from heterogeneous sources like REST APIs, Elasticsearch database, JSON parsing in MS SQL 2016.
  • Client - Midland Credit Management: Developed Operation Analysis dashboard using Power BI. The tool was used to analyze Service now tickets volumes of 30+ different support team which helped leadership to manage capacity, Service Level Agreement. The process required to pull data from Service now cloud database using ETL

Senior Data Analyst

Royal bank of Scotland
09.2017 - 04.2018
  • Worked on Futures Data dashboard requirement from end-to-end, which included data cleaning, development of complex 5 ETL solutions using SSIS. The ETL packages used advanced tasks like look up, CDC, Script tasks, file handling, re-run ability and check pointing and scheduling using SQL agent. Complex report development, and complex calculations in MS SSRS and integration of SSRS in Web applications.
  • Migration of Trade Settlements Data process from MS SQL 2008 R2 to MS SQL 2016. Used Catalog deployment model to migrate file system SSIS packages process to an automated one, using MS BI. The trade settlement data infrastructure was key to Trade settlements reports used by Front and back-office investment banking units of RBS

Senior Software Engineer

Sopra Steria
07.2014 - 09.2017
  • EasyJet Airlines Client: Was involved in full lifecycle starting from requirement gathering and Analysis. Prepared technical design specs (LLD & HLD), other supporting documents like Requirement traceability matrix, Release control document.
  • Developed more than 80+ complex SSIS Packages. Worked on high-quality ETL framework built for logging, re-run ability.
  • Developed SSRS reports for the different projects - Finance Reconciliation, easyJet holidays, that required extensive financial system-based complex calculations and transformation.
  • HRIS migration project: Migration of HR system from people soft to Workday.

Education

Bachelor of Engineering - Computer Engineering

University of Pune
Maharashtra
07.2014

Skills

  • Data Engineering using Azure SQL, Azure Data Factory, Azure Databricks, Workflows, DLT, Python, Azure Synapse Analytics, Stream analytics, Event hubs, Azure data lake, SSIS, SSAS, Azure analysis services
  • Data Visualization : Power BI, Flourish, D3js, Tableau
  • Data Warehouse and Lakehouse : Kimball and Medallion
  • Data Storytelling, Stakeholder management and presentation skills

Certification

Azure Data Engineer

Power BI Data Analyst

Databricks data engineer associate

Microsoft certified solutions associate - Data Warehouse and Data Modelling using SQL

Timeline

Data Engineering and Visualization Manager

EY (Ernst & Young) GDS
02.2021 - Current

Senior BI Developer

Clifford Chance
02.2019 - 02.2021

Senior Software Engineer

Pure software Pvt. Ltd.
04.2018 - 02.2019

Senior Data Analyst

Royal bank of Scotland
09.2017 - 04.2018

Senior Software Engineer

Sopra Steria
07.2014 - 09.2017

Bachelor of Engineering - Computer Engineering

University of Pune

Similar Profiles

CREATE PROFILE
Sneh Bhat