Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Deepika Ganesan

Data & Analytics Manager | Power BI | Snowflake | AWS | Azure
Bengaluru

Summary

Accomplished Data & Analytics Manager with a proven track record at EY, specializing in cloud migrations and BI solutions. Expert in Power BI, SQL, and project management have led diverse teams to deliver cutting-edge FinTech and insurance projects. Experienced Strategic approach and technical prowess have driven significant advancements in data management and analytics.

Overview

15
15
years of professional experience
4
4
years of post-secondary education
6
6
Certifications

Work History

Data & Analytics | Manager

EY
09.2019 - Current
  • Managing Data modelling and Power BI reporting teams of an end-to-end Fin-Tech solution cloud migration for a major US WAM client on AWS, Snowflake.
  • Managed a huge BI delivery offshore team for a major US-based Investment Banking client to automate, migrate the US FED Reg reporting solutions to the cloud, and make the reports readily available on the web app portal for the clients to extract.
  • Managed a team of 5 from Offshore engagement for a major UK bank by being an integral part in developing SQL stored procedures and performing ETL in SSIS, data modeling, and delivery of the final outputs from the Reg engine developed by EY to compare results.
  • As a Senior Business Intelligence & Data consultant for a huge Market Intelligence, I worked on an Analytics product that was being built on the Azure platform to cater to all G360 accounts with Audit/Market research/AI Analytics solutions.
  • As the lead Power BI developer for an Advanced Financial Analytics Apps research engagement, I have developed numerous complex Power BI dashboards to meet clients' requirements on various financial aspects on Power BI, Azure Cosmos DB, and Azure SQL Data Warehouse.
  • Have developed multiple suites of BI solutions, holding 600+ key processing metrics in Power BI, and automated huge volumes of data flow from various sources to reporting and optimizing BI solutions.

Senior Guidewire Data Consultant

EY
07.2017 - 09.2019
  • Successfully delivered the Data Migration engagement for a major UK Insurance client by playing various key roles to migrate claims from IFACES, CLASS, and PROGEN systems to Guidewire Claimcenter in 2 Releases (Motor, & Non-Motor).
  • Managed a team of 7 to deliver testing of integrations done with the implemented Guidewire Claimcenter (both upstream and downstream).
  • In the UAT phase of the engagement, I performed the role of a Client Defect Manager, working alongside the UAT testers, who were all Claim Handlers. This involved coordination with the BAs, SMEs from the Scrum teams, SIT team leads, SIT Client Manager, and then the Client Product owners.
  • Played a key Technical Business Analyst role to impart knowledge to the team, and bridged the gap between the BAs and Developers.

Guidewire Business & QA Consultant

EY
08.2013 - 07.2017
  • Policy Center, Claim Center, Billing Center Senior ETL QA Lead. Managed the test team of 14 for a Guidewire suite implementation engagement, along with the integration of 120+ downstream systems for a major US Insurance client.
  • Led the policy rating team during the development sprints and SIT. Implemented Orthogonal Array Testing System to help generate optimum test combinations for complex stories.
  • Performed the role of an offshore Defect Manager and facilitated defect triage meeting on a daily basis with the clients.
  • Developed the test plan, test strategy, and prepared POC for the data migration testing approach.

PL/SQL Developer

Cognizant Technologies Solutions
11.2009 - 08.2013
  • EDI Convertor Tool (EDICON) - To convert Inbound 5010 transactions to 4010 format and Outbound 4010 transactions to 5010 formats, was involved in Requirement analysis, Design, Coding, Deployment, Unit testing, and Maintenance.
  • Established Remediating Extensions using .NET framework 3.5 and Microsoft Visual Studio 2008 for Facets 471 Upgrade changes.
  • Performed the development of interfaces using Oracle 9i PL/SQL statements with Stored Procedures, Functions, Triggers, Materialized views, Dynamic SQL, XML, and ODS Tables.
  • Oracle Migration - Migrating Sybase stored procedures to Oracle as part of EAGLE-UBH.

Education

Bachelor of Engineering - Electrical, Electronics Engineering

Sona College of Technology
Salem, Tamil Nadu
09.2005 - 04.2009

Skills

Power BI Tableau

AWS Microsoft Azure

WAM Banking Insurance

Snowflake

ETL development

SQL Programming

Data Management

Business Intelligence

Data Modelling

Project Management

Guidewire Claimcenter Policycenter Billingcenter

Certification

Tableau 10 Desktop Specialist

Timeline

Data & Analytics | Manager

EY
09.2019 - Current

Senior Guidewire Data Consultant

EY
07.2017 - 09.2019

Guidewire Business & QA Consultant

EY
08.2013 - 07.2017

PL/SQL Developer

Cognizant Technologies Solutions
11.2009 - 08.2013

Bachelor of Engineering - Electrical, Electronics Engineering

Sona College of Technology
09.2005 - 04.2009

Similar Profiles

CREATE PROFILE
Deepika GanesanData & Analytics Manager | Power BI | Snowflake | AWS | Azure