Sneh Bhat

EY Insights Data Platform (Markets Engine) – Data Engineering Lead

• Architected & Modernized Cloud Data Platform: Led the migration of EY’s Survey Intelligence Platform from legacy Alteryx+R to Azure Databricks Lakehouse, implementing medallion (Bronze/Silver/Gold) architecture, Delta Lake optimization, and automated ADF & Logic Apps pipelines, achieving 60% performance improvement and 40% cost reduction.
• Advanced Analytics & AI Integration: Designed and integrated AI-driven analytics including C-suite survey sentiment analysis, earnings call NLP processing, energy & automotive forecasting models, and the EY Future Consumer Index; connected Gold layer datasets to EYQ for automated insights.
• Team Leadership & Client Engagement: Managed a cross-functional team of 5–7 data engineers and 5 visualization developers, translating client business requirements into actionable analytics and dashboards; prepared executive-level visualizations and delivered data storytelling for EY thought leadership projects.
• Impact & Recognition: Delivered over 500 interactive visualizations for 70+ projects across multiple sectors (Consumer, Tax, Energy, Automotive); achieved Data Visualization GOLD badge for advanced analytics storytelling driving executive engagement.

• Senior BI/Data Warehouse Developer: Worked on the 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 the 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 the migration and 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, and 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.

• Client – Encore Capital Group: Developed over 20 SSIS packages for daily production operations processes with severity-1 on production. The data was key for Dialers to summarize mortgaged financials.
• Used complex ETL techniques, like Change Data Capture, pulling data from heterogeneous sources, such as REST APIs, Elasticsearch database, and JSON parsing in MS SQL 2016.
• Client - Midland Credit Management: Developed an Operation Analysis dashboard using Power BI. The tool was used to analyze ServiceNow ticket volumes from 30+ different support teams, which helped leadership manage capacity and Service Level Agreements. The process required to pull data from the ServiceNow cloud database using ETL.

• Worked on the Futures Data dashboard requirement from end to end, which included data cleaning, and the development of complex five ETL solutions using SSIS. The ETL packages used advanced tasks like look-up, CDC, script tasks, file handling, re-run ability, check pointing, and scheduling using SQL Agent. Complex report development, 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 the catalog deployment model to migrate the file system SSIS packages process to an automated one, using MS BI. The trade settlement data infrastructure was key to trade settlement reports used by front- and back-office investment banking units of RBS.

• EasyJet Airlines client: Was involved in the full lifecycle, starting from requirement gathering and analysis. Prepared technical design specs (LLD and HLD), and other supporting documents, such as the Requirement Traceability Matrix and Release Control Document.
• Developed more than 80 complex SSIS packages. Worked on a high-quality ETL framework built for logging and re-run ability.
• Developed SSRS reports for the different projects—Finance Reconciliation, easyJet holidays—that required extensive financial system-based complex calculations and transformations.
• HRIS migration project: Migration of the HR system from PeopleSoft to Workday.