umashankar vasanthakumar

• ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server. •Created Build definition and Release definition for Continuous Integration and Continuous Deployment in Azure SQL server DB deployment. • Coordinate all build and release activities, ensure release processes is well documented, source control repositories including branching and tagging.

• Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio. • Development of Informatica mapping using complex transformation including Lookup, Normalizer, Aggregator, Router, Rank, Web Services, HTTP. • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. • Educate Scum metholodgy and agile framework to team.

• Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions. • Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS). • Designed, developed, tested, and maintained Tableau functional reports based on user requirements. • Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.

•Designed and developed database tables, triggers, cursors, procedures, functions and packages. • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace. • Designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, MYSQL, flatfile) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all.

• Developed and supported software for company needs. Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements. • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines. • Created and maintained developer-level and user-level artifacts that included software version or requirement documentation, deployment guides and user manuals

MSC(SOFTWARE SCIENCE) Intergrated course

Intergrated Course