EXPERIENCE SUMMARY:

• Microsoft Certified IT Professional (MCTS, MCIT) and IBM Big Data Certified engineer with 14 years of IT experience.
• I have worked primarily in the domain of Manufacturing/Retail/Banking for the clients Microsoft/ Confidential as a Developer/Senior Developer/Scrum Member/Technology Analyst/Technical lead/Technical Architect. My Current Role in Cognizant is Technical Architect/Senior ETL Tech Lead.
• Strong experience in SQL Server with Business Intelligence (SQL Server Integration Services (SSIS ETL), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)).
• SSIS ETL: 13+ years’ experience in design and development of SSIS (ETL) packages
• SSAS and SSRS: 7+ years’ experience in design and development of SSAS Cubes and SSRS Reports.
• SQL Server: 13+ years’ experience in designing database objects and data modelling (tables, views, stored procedures, triggers, indexes, functions and so on)
• POWER BI: 3+ years’ experience in designing complex and innovative dashboards
• More than 11 years’ experience in ETL performance tuning, database query tuning.
• Created numerous SSIS packages to load various Dimensions and Fact tables (dimensional model) based on complex business requirements.
• Strong understanding of Data Warehouse Concepts .
• Proficient experience working on SSAS cubes and MDX.
• Highly proficient in translating business requirements to technical requirements.
• Excellent knowledge of database design, SQL, data warehousing concepts.
• Proficient experience working with dimensional modeling , aggregate tables, transactional source systems.
• Experience in SSIS script task using C sharp, look up transformations and data flow tasks.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.
• Proficient Experience with SQL Server & SSIS version 2012,2014,2016
• Expertise in writing complex SQL queries, creating complex Stored Procedures
• Expertise in generating tabular reports, Matrix reports, Ad hoc reports, Drill - down reports, Cascaded reports, List reports, Parameterized reports, Sub reports using SSRS.
• Created SSRS subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Deployed reports in the Testing, Staging Server, and Production Servers.
• Proficient Experience with dashboard solutions
• Designed Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Rules and Defaults
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Configured Send Mail Task for sending automatic emails when a SSIS package is failed or succeed.
• Thorough Knowledge of Various SSIS objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor .
• Deployed SSIS Packages in the Testing, Staging Server, Production Servers.
• Updated existing SSIS packages according to business requirement changes.
• Extensively worked on performance tuning of the ETL process.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in Performance tuning of Queries.
• Extensive experience in Data Integration and Data Architecture and Modelling.
• Extensive experience in Relational Data modelling, creation of logical and physical design for databases and proficient in creating E-R diagram using Erwin and Visio.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers
• Involved in troubleshooting issues in Production and UAT environments from WW users
• Proficient in extraction, transformation, cleansing, and loading data from heterogeneous data sources of Oracle, MS Access and flat files
• Executed few projects in agile methodology and possess detailed information about agile and scrum working model.
• Adapt to new tools and technologies in traditional BI space, Microsoft Azure and Hadoop ecosystem
• Ability to convey issues/solutions to the client based on nature of issue and provide workaround in a timely manner.
• Proactively contribute to add value to the project. created Azure Data Lake Analytics accounts
• Defined jobs in U-SQL and submit the jobs to the Data Analytics service.
• Managed Azure Data Analytics accounts, data sources, users and jobs using Azure Portal.
• Managed Role-Based access control.
• Add users or Security Groups to data analytics account. Monitored jobs
• Created U-SQL Scripts, Running U-SQL Scripts.
• Performed Joins, set operations, file handling using SQL.
• Extensively used Azure SQL.
• Created and supported executive dashboard in POWER BI .
• Provided solutions to critical business requirements with POWER BI Parameters, Filters & Sets
• Worked on different domain and handled different data sources from SQL Server, TERADATA, DB2, ORACLE, Hadoop, excel
• Deployed the Dashboards into POWER BI Service

KEY STRENGTHS:

• Strong analytical ability
• Strong knowledge in SQL server and MSBI (SSIS, SSRS, SSAS) technologies
• Good Communication and Interpersonal skills
• Mentor developers

TECHNICAL EXPERTISE:

ETL Tool: SSIS (SQL Server Integration Services), Azure Data Factory

REPORTING Tools: SSRS (SQL Server Reporting Service

DATA ANALYTICAL TOOL: SSAS (SQL Server Analysis Services)

VISUALIZATION TOOL: Power BI, TABLEAU

Databases: SQL Server, MySQL, Oracle, Teradata, Azure Data Lake

Cloud: SQL Azure, Azure Data Factory, Azure Data Bricks, Mariadb

Big Data / Hadoop: Hive, Sqoop, Oozie, HDFS, PIG, MapReduce, SPARK

Data Wrangling Tools: Alteryx

Data Modelling Tool: Erwin

Programming Languages: C sharp.net, Python, R, Java

System Development: Requirements analysis, Design, Analysis; Coding and Testing

Scheduling Tool: Control-M, SQL Server Agent

Methodologies: Agile, Waterfall

Tools: / Utilities: SQL Server Management Studio, Visual Studio - Team foundation Server, GITHUB, HIPCHAT, QC, VISIO

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Senior ETL Tech Lead\Architect

Responsibilities:

• Created more than 300 SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Updated existing SSIS packages according to business requirement changes.
• Deployed SSIS Packages in the Testing, Staging Server, Production Servers.
• Extensively worked on performance tuning of the ETL process.
• Created conceptual, logical and physical data models using best practices.
• Performed ETL performance tuning, database query tuning.
• Design and developed SSAS Cubes.
• Wrote complex SQL queries & complex Stored Procedures
• Expert in Data Visualization development using POWER BI to create complex, intuitive, and innovative dashboards.
• Created and supported executive dashboard in POWER BI.
• Provided solutions to critical business requirements with POWER BI Parameters, Filters & Sets
• Worked on different domain and handle different data sources like SQL Server, Hadoop, excel, t using Joining and Data Blending
• Deployed the Dashboards into POWER BI Service
• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins
• Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2014.
• Created complex dashboards using Power BI created Azure Data Lake Analytics accounts
• Performed Joins, set operations, file handling using SQL.
• Extensively used Azure SQL.

Technology: SQL Server 2012, SSIS, SSRS, SSAS, POWER BI, Azure, Azure Data Lake, USQL, Python

Confidential, Minneapolis, MN

Technical Architect / Senior Tech Lead

Responsibilities:

• Involved in design and development of SSIS (ETL) packages.
• Extensively worked on performance tuning of the ETL process.
• Analysis of Project Requirements and functional specifications of the project.
• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins
• Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2014.
• Understand customer requirement and translate it into appropriate solution.
• Creation and delivery of detailed technical presentations.
• Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Created new reports and modified existing reports in SSRS based on Business requirement.
• Created complex dashboards using Power BI
• Deployed SSIS Packages in the Testing, Staging Server, Production Servers.
• Updated existing SSIS packages according to business requirement changes.
• Managed Azure Data Analytics accounts, data-sources, users and jobs using Azure Portal.
• Managed Role-Based access control.
• Add users or Security Groups to data analytics account.
• Monitored jobs
• Created U-SQL Scripts, Running U-SQL Scripts.
• Performed Joins, Set operations, file handling using SQL.
• Extensively used Azure SQL.

Technology: SQL Server 2012, SSIS, SSRS, POWER BI, AZURE, Azure Data Lake, USQL, Python

Confidential, Minneapolis MN

Technical Lead

Responsibilities:

• Involved in discussions and meetings with customers for finalizing the scope of the project.
• Involved in analysis and design phase of the project.
• Understand customer requirement and translate it into appropriate solution.
• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins
• Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2014.
• Updated existing SSIS packages according to business requirement changes.
• Deployed SSIS Packages in the Testing, Staging Server, Production Servers.
• Created SSRS subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Involved in preparing Design documents.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles
• Establish design\coding guidelines and best practices.
• Analyzed long running queries and tuned the same to optimize application and system performance.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Coordinated with Offshore development team for successful implementation.
• Assisted the project manager in estimate in project costs and efforts
• Created SAS ADHOC jobs and Reports.
• Expert in Data Visualization development using POWER BI to create complex, intuitive, and innovative dashboards.
• Created and supported executive dashboard in POWER BI.
• Provided solutions to critical business requirements with POWER BI Parameters, Filters & Sets
• Worked on different domain and handle different data sources like SQL Server, Hadoop, excel, t using Joining and Data Blending
• Deployed the Dashboards into POWER BI Service

Technology: SQL Server 2012, SSIS, SSRS, SAS, Teradata, Control-M, QC, VISIO, ERWIN, POWER BI, AZURE

Confidential, Minneapolis, MN

Technical Lead

Responsibilities:

• Involved in design and development of SSRS Reports
• Designed and Developed SSIS packages for ETL
• Involved in discussions and meetings with customers for finalizing the scope of the project.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used SSIS script task using C sharp, look up transformations and data flow tasks.
• Involved in preparing Design documents.
• Involved in coding and testing.
• Involved in Control-M job scheduler design flow.
• Involved in generating summary reports like Tabular, Matrix using SSRS.
• Created SSRS subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Prepared daily and Weekly Status Reports and shared with the customers.
• Coordinated with Offshore development team for successful implementation
• Providing the regular updates on status of project and Monitoring the Production jobs.

Technology: SQL Server 2012, SSIS, SSRS, Oracle, Teradata, Control-M, VISIO, POWER BI, AZURE

Confidential

Technical Lead

Responsibilities:

• Involved in exhaustive discussions with onsite coordinator as well as offshore team regarding the requirement and converted the same into Design by coordinating with offshore team.
• Developed the SSIS packages which are adhered to coding standards and delivered the same with no deviation from requirements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations.
• Coordinated with onsite coordinator during the User Acceptance Test to make it success.
• Wrote unit test cases for the SSIS packages and performed thorough Unit testing and also involved in peer review.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Understood the complete requirement of the client and designed perfect solution for ORS project.
• Analyzed long running queries and tuned the same to optimize application and system performance.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Ensured content and structure of all project related documents like HLD and
• LLD adhered to quality and standards
• Created SSRS subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).

Technology: SQL Server 2012, SSIS, SSRS, SSAS, Oracle, Control-M, QC, VISIO, POWER BI

Confidential

Module Lead

Responsibilities:

• Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Experience in SSIS script task using C sharp, look up transformations and data flow tasks.
• Engaged in design and development of SSIS packages for data migration.
• Involved in troubleshooting issues in Production and UAT environments
• Provided the estimation details for enhancement related activities.
• Communication with Onsite to bridge the gap between them and Offshore.
• Leading the team.
• Communication with Onsite to bridge the gap between them and Offshore.
• Involved in Design, Coding and Testing of Quarterly release CRs.
• Engaged in design and development of SSIS packages for data migration.
• Involved in troubleshooting issues in Production and UAT environmentsests from WW users
• Prepared Low-Level Design Documents for more than 20 packages
• Analyzed the RMM production Hourly, Weekly and Daily job failures8) Engaged in enhancement of RMM UPS related jobs

Technology: SQL Server 2008, SSIS, Control-M, VISIO

Confidential

Module Lead

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Experience in SSIS script task using C sharp, look up transformations and data flow tasks.
• Provided the estimation details for enhancement related activities.
• Communication with Onsite to bridge the gap between them and Offshore.
• Prepared Low-Level Design Documents for more than 20 packages
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.
• Migration of data from Excel, Flat file, to Microsoft SQL Server.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Analyzed the RMM production Hourly, Weekly and Daily job.
• Involved in generating summary reports like Tabular, Matrix using SSRS.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Analyzed long running queries and tuned the same to optimize application and system performance.

Technology: SQL Server 2008, SSIS, SSRS, Control-M, QC, VISIO

Confidential

Technology Analyst

Responsibilities:

• Designed and Developed SSIS packages for ETL
• Involved in design and development of SSRS Reports
• Experience in SSIS script task using C sharp, look up transformations and data flow tasks.
• Involved in troubleshooting issues in Production and UAT environments.
• Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Updated existing SSIS packages according to business requirement changes.
• Communication with Onsite to bridge the gap between them and Offshore.
• Involved in generating summary reports like Tabular, Matrix using SSRS.
• Analyzed long running queries and tuned the same to optimize application and system performance.
• Involved in the design of Dimensions and Facts to support reporting.
• Developed Cubes and Dimensions using SQL Server Analysis Services (SSAS).

Technology: SQL server 2008, SSIS, SSRS, SSAS