Sundar has extensive knowledge in data processing, data modeling, and data visualization technologies. As a lead developer, he has delivered multiple key projects using Snowflake, Azure, Wherescape, Tableau, MSBI, PowerBI, SQL, Oracle Database, and TSQL.
Some of his certifications include being an Azure Data Engineer, AWS Solution Architect, and Oracle Certified Professional. He also uses Lean Six Sigma and Design Thinking methodology, in addition to being a Professional Scrum Master.Hire 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.