We provide IT Staff Augmentation Services!

Project Lead Resume

New, YorK

SUMMARY:

  • Around 9 years of strong experience in BI and Data Warehousing, specialized in Data Warehouse Expert, ETL design & development, ETL Testing, OLAP design and development
  • Extensive experience in different domains like Insurance, Credit Cards, Financial, Banking and Retails as ETL programmer analyst and ETL tools like Informatica .
  • 8+ years of Project Lead, Technical & Functional Lead experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 9.5/8.6/7.1.3/6.2
  • Expert in Dimensional Data Modeling, using Data modeling, Star-join Snowflake Schema modeling, FACT & Dimensions tables, Logical & Physical data modeling using ERWIN and Oracle Designer.
  • Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.
  • Experience in Master Data Management (MDM) architectures and business processes.
  • Experience in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
  • Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation.
  • Experience with Informatica Data Quality for Data Validation.
  • Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis, Impact Analysis Documents.
  • Experience in Dimensional Data Modeling experience on Data modeling, ERwin 4.5, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, DataMarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
  • Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer Warehouse Designer, Workflow Manager, Repository Manager and Workflow Monitor
  • Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
  • Experience on Cloudera framework, Hive, sqoop.
  • Experience in Database architecture for OLTP and OLAP applications.
  • Hands on database experience using Oracle, SQL,My SQL, PL/SQL, SQL *Loader, SQL *Plus TOAD and Teradata.
  • Experience with Enterprise Data Integration Products like Tallend
  • Experienced in Full Life Cycle Development of building a Software or Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation
  • Experience in handling performance related issues and techniques to improve the performance
  • Experience of working on proposals, proof of concepts and customer presentations
  • Strong Analytical Skills, Self-motivated and Team oriented and Exceptional communication, presentation and interpersonal skills
  • Good experience of working with clients.

SKILLS AND COMPETENCIES:

Tools: Informatica 9x,8x,7x,6x, MDM Informatica,Power Exchange, MSTR, Tableau

Methodologies: Waterfall, Agile

Database: Oracle, DB2 9.1,My SQL, SQL server 2000,Netezza,Teradata

Operating System: Windows XP, Windows 7, AIX

Domains: Banking & financial, Insurance, Retail

Others: MS Project, Uml, Micro soft Visio, Toad

PROFESSIONAL EXPERIENCE:

Confidential, New York

Project Lead

Responsibilities:

  • Work with Business Analysts team in translating business requirements into Functional Requirements Document and to Detailed Design Documents
  • Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization, Analyze impact on Enterprise DWH
  • Prepare Detail Estimates and Planning. Estimation for new Development after analyzing the changes
  • Present and defend product designs and architecture to clients
  • Utilize in-depth knowledge of functional and Technical experience in Data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer
  • Assessing the ETL sizing for multiple projects/applications and assigned the resources for project executions.
  • Managing the ETL timelines and project implementation schedule for ETL activities for the Confidential application.
  • Assisting Business Analyst with drafting the requirements, implementing design and development of various components of ETL for Relationship Care application.
  • Executing/Maintaining daily/monthly ETL jobs that process customer Data and entries from the origin till Data warehouse/Data Mart load.
  • Leading the Offshore team and transitioning the business and technical functionalities for the design/development of various Applications.
  • Conducting Design reviews with Lead Technical Architect created and maintained design documents.

Environment: Informatica Power Center 9.5, Mainframe File System,Talend, UNIX Shell Programming

Confidential, Phoenix, AZ

Project Lead

Responsibilities:

  • Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
  • Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization, Analyze impact on Enterprise DWH
  • Prepare Detail Estimates and Planning. Estimation for new Development after analyzing the changes
  • Present and defend product designs and architecture to clients
  • Utilize in-depth knowledge of functional and Technical experience in Data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer
  • Assessing the ETL sizing for multiple projects/applications and assigned the resources for project executions.
  • Managing the ETL timelines and project implementation schedule for ETL activities for the Global Payment options application.
  • Assisting Business Analyst with drafting the requirements, implementing design and development of various components of ETL for Relationship Care application.
  • Executing/Maintaining daily/monthly ETL jobs that process customer transactions and entries from the origin till Datawarehouse/Data Mart load.
  • Leading the Offshore team and transitioning the business and technical functionalities for the design/development of various Applications.
  • Conducting Design reviews with Lead Technical Architect, created and maintained design documents: T100, T-120, High Level Design, Transformation mapping Design, File acquisition, Process flow diagrams, Traceability matrix and Automation docs.

Environment: Informatica Power Center 9.5, Mainframe File System, Linux

Confidential, Phoenix, AZ

Project Lead

Responsibilities:

  • Used ETL tool Informatica to develop different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
  • Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
  • Maintained ETL Shared Folder for the Source and Target Definitions, Reusable transformations and Mapplets.
  • As part of ETL process, Extracted data from Flat files, MS SQL, Oracle, Heterogeneous Database tables and Excel spreadsheet into target DB2 database and applied Business Logic on Transformation Mapping for inserting and updating records when loaded.
  • Using ETL process to Extract, Transform and Load the data into stage area and data warehouse (Mart).
  • Played technical lead role and executed the projects with no issues as per business expectations

Environment: Informatica Power Center 9.5, Netezza, Mainframe File System, UNIX Shell Programming

Confidential, Phoenix

Technical & Functional Lead

Responsibilities:

  • Working with the business analysts for requirements gathering, business analysis, metrics and project coordination.
  • Study of the existing “Business T” tool process and procedure to understand the existing report logic and format.
  • Designing the dimensional model of the data warehouse and designing the business process, grain of the data representation, dimensions and fact tables with measured facts.
  • Identifying all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
  • Improve the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases.
  • Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
  • Performed error handing using session logs
  • Tuned performance of Informatica session for large data files by increasing block size, Data cache size and target based commit interval.
  • Implementing various integrity constraints for data integrity like Referential integrity using PK and FK relationships
  • Used task developer in the Workflow manager to define sessions.
  • Created reusable worklets and mapplets and transformations.
  • Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.

Environment: Informatica Power Center 8.X, SQL, DB2, UNIX Shell scripting, Power change Sources

Confidential

Technical & Functional Lead

Responsibilities:

  • I performed analysis, design and delegation and development of work.
  • Prepared Test Plans, Test Requirement for Data/Business Analysts to verify and validate the code.
  • Performed performance issues such as query optimization, query plans and security related issues.
  • Responsible for Deployment from Development Server to QA Server and QA Server to Production Servers thru Visual Source Safe 6.0.
  • Involved in Production and Post production validation and verification
  • On-Call Support for production and resolved time constraint issues to meet the SLA deadlines.

Environment: Informatica Power Center 8.X, SQL, DB2, UNIX Shell scripting, Power Exchange, Flat files

Confidential

Technical & Functional Lead

Responsibilities:

  • Gathering user requirement, analysis and design of the project.
  • Developed ad-hoc Business Queries on multiple servers to deliver integrated and conditional data to Data/Business Analysts
  • Involved in Stage, Dimension and Fact loading mappings.
  • Involved in parameter files generation for all the staging mappings.
  • Extensively worked with SQL, Lookup, Expression and Normalizer transformation
  • Involved in Unit test case preparation
  • Involved in data verification and testing methods for the data warehouse to ensure data accuracy.

Environment: Informatica Power Center 7.X, SQL, DB2, Flat files, oracle

Confidential

Technical & Functional Lead

Responsibilities:

  • Created High level design documents, low level documents and designed the ETL processes.
  • Prepare Central repository of exposure data to monitor risk associated with invested amount for Business
  • Involved in tuning the mappings to achieve performance.
  • Involved in review code and scheduling measures.
  • Created Reusable Transformations, mapplets using Designer Tool of Informatica.
  • Performed system integration testing and refreshing activities for SIT and UAT
  • Done Unit Testing for the developed mappings
  • Designed SQL Jobs to implement logic for daily loads of data into the Production database, from disparate servers / data files.
  • Implemented SQL Mail in Stored Procedures / Nightly Production Jobs to report failed / cancelled jobs.

Environment: Informatica Power Center 7.X, SQL, DB2, Flat files, Oracle

Hire Now