Data Architect Resume

SUMMARY

12+ yrs of IT experience in analysis, design, development, testing and support of Business Intelligence.
Extensive experience in SQL Server 2012/2014/2016/2017 , Datawarehouse, MSBI (SQL server Integration services, SQL server Analysis services)
Working knowledge of PowerBI, SQL server Reporting services, PL/SQL, C# and VB.net.
Worked on Payroll, HCM and Auto Insurance domain.
Development focused on client/server, web - based applications, and data warehouse design using logical/ physical data modeling, ETL, Reporting and performance tuning and troubleshooting.
Experience in Source Control Systems like Visual Source Safe, TFS Source Control and GitHub.
Worked in Agile based projects. Also used Jira for tracking.
Worked with multiple global stakeholders across geographies to resolve complex issues.

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

Developed Dynamic SQL ETL framework to generate queries on the fly to reduce 70-80% development time.
Delivery was before time and helped in minimizing time in data load from staging to DW.
Appreciated and promoted by the client.

Confidential

Senior ETL Lead

Responsibilities:

Successfully implemented ETL data load for service bureau and payroll client data in a controlled fashion given the complex nature of Firebird’s distributed physical database architecture.
Got awarded by the client for successful delivery of automated cube replication application.
Delivery was before time and application helped client in minimizing time and effort on developing cubes.
Appreciated by client to come up with POC on Tabular Model