fbpx Sundarraman Venkat | DevReady
Sundarraman Venkat
HireSundarraman

Sundarraman

Halifax, England --:--:--

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
Skills
Years
1
2
3
4
5
6
7
8
9
10+
Python
Azure
Power BI
SQL Server
Tableau
PL/SQL
PostgreSQL
Oracle
AWS
MySQL
PySpark
Snowflake
Skills

2+ Years

3+ Years

8+ Years

10+ Years

Developer Personality

Independent

Collabrativer

Trailblazer

Conservative

Generalist

Specialist

Planner

Doer

Idealist

Pragmatist

Abstraction

Control

100
50
0
50
100
Feature Experience

Shell Scripting

Data Analytics

Automation

Dashboards

Data Transformation

MODERATE
EXTENSIVE
EXPERT
Cultural Experience

Banking and Insurance

Scrum

Lean Six Sigma

Consultant

Enterprise

MODERATE
EXTENSIVE
EXPERT
Portfolio

Legal & General

Data Engineer

Work Experience : 2021 - Present

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%.

More

Tata Consultancy Services - Client: Lloyds Bank Plc

Data Engineer

Work Experience : 2020 - 2021

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.

More

Tata Consultancy Services - Client: Nationwide Building Society

Data Engineer

Work Experience : 2018 - 2020

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.

More

Tata Consultancy Services - Client: The Hartford

Sr. Business Intelligence Developer

Work Experience : 2011 - 2018

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.

More

Hire Sundarraman Venkat