Information System Lead Resume

SUMMARY:

13 years in Microsoft Technology stack which include C,Python,C#,ASP.net, SSIS,Talend, SSRS, SSAS, SQL Server,Microsoft Azure SQL, ADF, Datalake and visualization using Powe BI

PROFESSIONAL EXPERIENCE:

Confidential

Information System Lead

Responsibilities:

Worked in Creating SSIS package for DWH load
Experience indeploying SQL Databases in AZURE.
Moving Data in and out of Azure SQL Databases, Blob Storage and Data Factory (ADF)
Migration legacy report to Power BI and Tableau
Maintenance of SQL server 2016 and its replication job.
Azure Blob storage and Data Factory for ETL.
Backup and restore of databases
Performance tuning
Replication / SQL profiler and query tuning, Maintenance plan monitoring, Backup and Restore of databases

Confidential

SQL LEAD

Responsibilities:

Designed, Developed and Deployed ETL package in MSSQL Serverenvironment using SSIS
Created SSRS report for Both operation and business reporting
Experience in developing C# script wif OOPs Concepts
Managed performance tunning SQL execution plan \Profiler and SQL tuning Advisor
Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change TEMPeffectively in rapidly evolving global business environments.
Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS, SSAS
Guided teams in the development of relational database management systems (RDBMS) for clients
Reports developed using both Power BI /SSRS .

Senior System Engineer

Confidential

Responsibilities:

Designed, Developed and Deployed ETL package in MSSQL Serverenvironment using SSIS and Talend.
Created SSAS cube for Both operation and business reporting
Managed performance tuning SQL execution plan, Profiler and SQL tuning Advisor
Enhancing and deploying the SSIS Packages from development server to production server.
Creation of SSAS cube for forecast and data mining and reporting using EXCEL and Pivot table.
Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
Involved in complete Software development life cycle (SDLC) of the project including Analysis, design, develop, deployment, test, implement and production.
Azure SQL and websites.

Senior System Engineer

Confidential

Responsibilities:

Highly experienced knowledge in C language.
Support the overall process of software production in ASP.NET web application and reporting. Major duties consisted of the following:
Developed Web application using APS.net 2.0/3.5.Performace tuning of web pages
Implementation of OOPS using C#, 3 tier Architecture /MVC pattern
Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS, SSAS
Guided teams in the development of relational database management systems (RDBMS) for clients
And ETL process using SSIS.
Developed report using tableau, SSRS, Oracle BIP reporting and Tableau.
Coding experience wif Python .
Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals