Sundarraman

Build Data Analytics landscape by setting up and maintaining 12+ data pipelines for daily batch process. Automate reporting capabilities to 70% by designing 15+ Facts & Dimensions in Snowflake and developing components using Wherescape ETL. Increase operation efficiency by 4% QoQ by developing and managing 10+ lean Power BI dashboards in the PowerBI app. Improved user adoption to automated/self-service BI reports using customer feedback thereby reducing ad hoc reporting efforts by 30%.

Reduced data ingestion timings by 60% by designing and developing ETL framework in Microsoft toolkit to migrate c.80m colleague records to multiple target systems. Improved code base for 99% success rate by creating PowerBI dashboard to identify the root cause. Enhanced data integrity and governance by setting up 20+ data encryption and column masking policies in line with GDPR.

Increased revenue savings to $320k annually by designing and developing in-house tooling for data profiling for 17m accounts using Dynamic SQL. Optimized migration process by 30% by using PowerBI for Product portfolio & Customer segmentation analysis. Reduced data analysis timelines (75%) by centralizing the data warehousing and reporting across different functional teams. Developed an End to End Dev-ops solution for the overall data profiling activity leading to savings of 6 FTE using Design Thinking framework.

Built 20+ Tableau reports using advanced concepts like Level of Detail, Data Blending, Row-level Security, Context filters, and Lean Reports to support a major migration project. This helped the program to save c.$2.5m annually. Created a metadata repository for storing metadata information using SQL procedures and macros. It helped the program save $60k per year. Developed reusable stored procedures using DynamicSQL to calculate various monthly & yearly metrics to replace existing SAS modules. Debugged long-running MSBI report and performed runtime optimizations by reviewing explain plans, using Common Table Expressions, building partitions in the cube, creating non clustered indexes, and some design adjustments. Managed a team of 7 members across different geographies, like USA and India, using distributed AGILE to support a major migration project.