We provide IT Staff Augmentation Services!

Project Lead/data Lead/etl Lead Resume

Des Moines, IowA

SUMMARY:

  • 12+ years of extensive experience in Data warehousing and Business Intelligence technology (such as Informatica, IICS, SAS, DataStage, Wherescape, Teradata, SQL Server, Sybase) and spanning from Architecture, Solution Design, Implementations of projects and product developments in Enterprise Information Management and Analytics.
  • Designed and delivered large scale Data warehousing Programs and Data Integration Solutions for Major Clients as Project Lead
  • Expertise in providing ETL Solutions for business data warehouse.
  • Extensive hands - on experience in Informatica Intelligent Cloud Services (IICS) & Informatica PowerCenter, Informatica Power Exchange, SAS, Informatica RDM and multiple databases (SQL Server 2014, Sybase, Teradata) and Unix Shell Scripting.
  • Good exposure to Informatica Cloud and AWS (Amazon Web Services)
  • Hands-On experience on Analyzing SAS ETL, Implementation of Data integration in Informatica using XML, Webservices, CDC Power Exchange.
  • Extensive knowledge with Teradata SQL Assistant, TPUMP, Fast Export, Fast Load, Multiload, BTEQ,
  • Expertise in Change Data Capture (CDC), ODS (real-time data), Reference Data Management (RDM), Incremental Extracts
  • Expertise in tuning the DW environment including SQL query tuning, Database tuning and in Informatica Power Center to identify bottlenecks, tune and remove bottlenecks with help of applying Informatica partitions and Push Down Optimization (PDO) etc.
  • Developing several complex mappings in Informatica with variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter.
  • Expertise in developing ETL processes using Informatica, including ETL control tables, error logging, auditing, balancing and control, data quality, data conversion etc.,
  • Developed Informatica Development Standards, Best practices, Solution Accelerators and Re-usable components for design and delivery assurance.
  • Pro-Active to Production Issues, punctuality in Meeting deadlines and always follow First Time Right (FTR) and On Time Delivery (OTD) approach.
  • Team facilitator with good communication and interpersonal skills. Ability to deal with people diplomatically and a team facilitator.
  • Very good in building strong relationships between teams within IT Solutions and between IT Solutions and related business teams and maintains professional relationships with peers in other corporations and outside organizations.
  • Has strong communication and influence skills when interacting with all levels of the organization starting with senior leadership on down to the team members and also having a good understanding of SDLC and Project Management Concepts.
  • Sound analytical and problem-solving skills with a good exposure to the key facets of leading teams to meet set objectives and ability to adapt and learn new technologies.
  • My job responsibilities include Requirement Gathering, Requirement Analysis, Design, Implementation, Testing and UAT/SIT support.
  • Worked in industry verticals like Healthcare and Retail.
  • Experience of Onsite Co-coordinator role and development role (7 years).
  • Experience in creating Technical Architecture Document and Software Architecture Document from the BR/FR provided by the business.
  • Involved in ETL Architecture design and created Value-add Tools for the team (using UNIX and VBA Macros).
  • Done POCs for ETL process improvement, Various System Integration and Data Integration, Data Migration.
  • Knowledge of Informatica Cloud (IICS), Wherescape, Business objects, Qlikview and MSBI (SSRS, SSIS)

TECHNICAL SKILLS:

Domain: Health care, Retail.

ETL Tool: Informatica 8.x, 9x. 10x, Informatica Cloud (IICS), Informatica MDM/RDM, Wherescape 6.x

Scripting: SQL, PL/SQL, Unix Shell Scripting

Databases: TERADATA 13.x, 14.x, MS SQL Server 2014, Sybase

Scheduler Tool: CA7, Maestro

Data Model: Sybase Power Designer

Querying Tools: Teradata SQL Assistant, WinSQL, Workbench, SQL Developer, TOAD

Operating Systems: Unix, Windows, DOS, Linux

BI Reporting Tool: SAS 9.x, Business objects 3.x, Crystal Report XI & 2008, Qlikview, SSRS.

Configuration Management: BMC Remedy, Service Now, IT2B, HP Service Center, ITSM

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, Iowa

Project Lead/Data Lead/ETL Lead

Database : Sybase, Teradata 14, Microsoft SQL Server.

ETL Tool: Informatica Power Center 10.2, IICS Informatica Cloud, Informatica MDM/RDM, SAS Base, Teradata Procedures, UNIX Scripting

Other Tools : Putty, WinScp, AWS CLI

O/s: UNIX

Responsibilities:

  • Work with business analyst or data analyst in understanding the business and functional requirements.
  • Based on Business requirement, Understand the technical requirements from the mapping documents and then create the ETL design (High level and Detailed level), Process Flow diagram and Data Flow diagrams.
  • Involve in the Project RFP and estimation process.
  • Design and creation of Informatica Mappings or Mapping task (IICS), Informatica Power Center Mapping, Informatica Power Exchange CDC Mappings, Informatica MDM/RDM mappings, tasks through Informatica Developer, Teradata Scripts, SQL Queries and UNIX shell scripts.
  • Performance tuning of Informatica workflows or Task flows.
  • Establishing ETL and Database Governance standards and best practices.
  • Analyze the existing Informatica Workflows or Task flows for Impact Analysis before updating the same based on new requirement.
  • Analyzed Complex ETL and SQL Jobs to solve different business problems with Effective and Efficient solution.
  • Follow the Client Process of Check-in the code to TFS, Create the label using the Azure Devops, Code Review Process with Enterprise Architecture Team, Creating Change request using BMC Remedy/Smart IT for Pre-PROD and PROD Deployments.
  • Focuses on First Time Right (FTR) and On Time Delivery (OTD) Approach all times which earned Customer Appreciation many times.

Confidential, Minnesota

ETL Lead

Database : Teradata 14

ETL Tool: Informatica Power Center 9.5.1, Wherescape, Teradata procedures, UNIX Scripting

Other Tools : Putty, Winscp

O/s: UNIX

Responsibilities:

  • Involved in discussion with architects and contributed suggestion on creating the Software Architecture Diagram for the outbound submissions.
  • Involved in Source Data Analysis & Data Profiling and prepared Mapping Specification based on Data Analysis & Profiling results.
  • Merged the Migrated data and Non-Migrated data and send the submission reports to the external vendors.
  • Prepared Design Document based on the business Requirements and Mapping Specifications.
  • Developed Informatica & Wherescape code to generate the extracts as per the business requirements.
  • Fine-tuned transformations and Wherescape RED procedures for better performance.
  • Prepared unit test plan & cases and done testing using plan.

Confidential, Minnesota

ETL Lead

Database : Teradata 14

ETL Tool: Informatica Power Center 9.5.1, Wherescape, Teradata procedures, UNIX Scripting

Other Tools : Putty, Winscp

O/s: UNIX

Responsibilities:

  • Involved in Source Data Analysis & Data Profiling and prepared Mapping Specification based on Data Analysis & Profiling results.
  • Prepared Design Document based on Mapping Specification and HLD.
  • Developed Informatica & Wherescape code to load the data into the inbound tables as per the business requirements.
  • Fine-tuned transformations, mappings, sessions and Wherescape RED procedures for better performance.
  • Prepared unit test plan & cases and done testing using plan.

Confidential

ETL Lead

Database : Teradata 14

ETL Tool : Informatica Power Center 9.5.1, Wherescape, Teradata procedures, UNIX Scripting

O/S: UNIX

Responsibility:

  • Participated in project technical solution sessions with clients and business analysts to analyze business requirements and outline the proposed solution.
  • Provide the Innovative ideas and tech solutions for project.
  • Implement the ETL components independently for project, which includes the preparation of Design, Mapping Specification based on BR/FR, Coding, Testing and Post-delivery support.
  • Communication with the client for daily/weekly status report.
  • Providing SIT and UAT support for the delivered work items.
  • Performed Code deployment activities across the DEV/UAT environments.

Confidential

ETL Lead/ Onsite Coordinator

Database : Teradata, Oracle

ETL Tool: Informatica 9.5.1, BTEQ, SAS, UNIX Scripting

O/s: UNIX

Responsibility:

  • Involved in Source Data Analysis & Data Profiling and prepared Mapping Specification based on Data Analysis & Profiling results.
  • Involved in discussion with data modelers and clients for preparing the data model for the project.
  • Prepared Design Document based on Mapping Specification and HLD.
  • Developed Informatica code to extract data (from Flat files, Oracle), transform data and load the dimension/fact tables.
  • Developed SAS code to extract data from the SAS data set to load the data to Teradata tables.
  • Fine-tuned transformations, mappings and sessions for better performance.
  • Prepared unit test plan and done testing using plan.
  • Involved in System Integration Testing.
  • Performed deployment activities across the different environments like DEV, UAT and PROD using Build forge.
  • Communicate the requirements to offshore and provide proper guidance to the team.

Confidential

ETL Lead/ Onsite Coordinator

Database : Teradata, Oracle

ETL Tool : Informatica 9.5.1, BTEQ, SAS, UNIX Scripting

O/s: UNIX

Responsibilities:

  • Managing communication with Client and offshore team for their questions.
  • Handled offshore team by assigning work and providing technical support to them.
  • Discussions with Business analyst in the preparation of the Mapping Specification and HLD based on BR/FR
  • Modified existing SAS code to extract data from IDW in order to modify ICD9 format to ICD10 format.
  • Fine-tuned transformations, mappings and sessions for better performance.
  • Prepared unit test plan and done testing using plan.
  • Involved in System Integration Testing.
  • Performed peer review
  • Code migration across all the environments using Build forge.

Confidential

ETL Lead/ Onsite Coordinator

Database : Teradata, Oracle

ETL Tool: Informatica 9.5.1, BTEQ, SAS, UNIX Scripting

O/s: UNIX

Responsibilities:

  • Managing communication with Client and offshore team for their questions.
  • Handled offshore team by assigning work and providing technical support to them.
  • Discussions with Business analyst in the preparation of the Mapping Specification and HLD based on BR/FR
  • Created Informatica code to extract data from IDW in order to provide the details to Front end application team.
  • Fine-tuned transformations, mappings and sessions for better performance.
  • Prepared unit test plan and done testing using plan.
  • Involved in System Integration Testing.
  • Performed peer review
  • Code migration across all the environments using Build forge.

Confidential

ETL Offshore Lead

Database : Teradata, Oracle

ETL Tool: Informatica 9.0.1, SAS, UNIX Scripting

O/s: UNIX

Responsibilities:

  • Managing communication with Onsite lead and offshore team for their day to day activities.
  • Execute this project in Agile Methodology.
  • Handled offshore team by assigning work and providing technical support to them for every sprint.
  • Discussions with Business analyst in the preparation of the Mapping Specification and HLD based on BR/FR
  • Created Informatica code to load data into IDW for Inbound work
  • Created SAS code to extract data from IDW for Outbound work
  • Fine-tuned transformations, mappings and sessions for better performance.
  • Prepared unit test plan and done testing using plan.
  • Involved in System Integration Testing.
  • Performed peer review

Confidential

ETL Offshore Lead

Database : Teradata, DB2

ETL Tool: Informatica 9.0.1, BTEQ, UNIX Scripting

O/s: UNIX

Responsibilities:

  • Gather requirements for the project by interacting with business and technology stake holders and analyze the requirements and prepare the technical specification documents.
  • Design the software solution in accordance with the requirement specifications.
  • Created and modified Informatica code for this migration activities.
  • Involved in Re-hook process and fork-lifting process.
  • Prepared unit test plan and done testing using plan.
  • Involved in System Integration Testing support.
  • Performed peer review.
  • Provided warranty support.

Confidential

BI Offshore developer

Database : Teradata 12

ETL Tool: Informatica 8.6.1, BTEQ, UNIX Scripting

BI Tool: Crystal Reports XI, Business objects 3.1

O/s: Windows, UNIX

Responsibilities:

  • Created and modified Reports for this project.
  • Prepared Design documents, Unit test plan and done testing using plan.
  • Involved in System Integration Testing and BAT support.
  • Performed peer review.

Confidential

BI-DW Offshore developer

Database : SQL Server (2000, 2005)

ETL Tool: DTS, SSIS

BI Tool: Crystal Reports (XI, 2008), Business objects XI (R2, R3.1), SSRS, Qlikview.

O/s: Windows

Responsibilities:

  • Creating New Reports.
  • Report Enhancements.
  • Database Enhancement like Creating Complex ETL Scripts, DTS & SSIS Package,
  • Production Support.
  • Building Universes and creating Web-I reports.
  • Creating Qlikview Applications.

Confidential

Offshore developer

Database : Oracle 9i

ETL Tool: PL/SQL scripting

BI Tool: Crystal Reports XI

O/s: Windows

Responsibilities:

  • Database Maintenance activities
  • Scripting (Procedures, Views and Triggers).
  • Report Creation.

Hire Now