We provide IT Staff Augmentation Services!

Senior Etl Tech Lead\architect Resume

Wilmington, DE

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

Hire Now