We provide IT Staff Augmentation Services!

Project Lead Resume

PROFESSIONAL SUMMARY:

  • 13 years of total IT experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, Development, Implementations and Testing of Data Warehousing and Database business systems for Insurance and Finance domains.
  • Expertise in Data Warehousing and ETL using Informatica Power Center 10.1.1/9.x/8.x/, Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and IDQ.
  • Expertise in Informatica Axon, Enterprise Data Catalog (EDC) and IDQ.
  • Expertise in Database front using Microsoft SQL Server 2008/2012/2014 , Netezza and Oracle.
  • Expertise in developing Informatica Mappings by using transformations like Source Qualifier, Lookup, Aggregator, Router, XML parser, SQL.
  • Expertise in using Address Doctor, Data processor transformations in Informatica Developer 10.1.1/9.6.1 for cleaning\validation of data.
  • Experience in creating Reports using IBM Cognos Report Studio.
  • Expertise in using Statistica, a Data mining and Predictive Modeling Tool.
  • Extensive usage of Informatica DVO in creating the test cases for unit, scenario and regression testing.
  • Experienced in working with Senior management during requirement gathering, understanding business requirements and demonstration of the products.
  • Expertise in creating the Mapping Design documents - both high level and low level design documents.
  • Expertise in helping business in solving data issues and providing long term solutions.
  • Experienced in all the phases of Data warehouse life cycle (SDLC) in both Waterfall and Agile Methodologies and well versed with Scrum Master Responsibilities.
  • Expertise in identifying performance bottlenecks and tuning of Informatica sources, targets, mappings, Transformations, and sessions for better performance.
  • Experience in implementing update strategies, incremental loads, incremental aggregation and change Data capture.
  • Experience in using Schedulers like Zena, Tivoli & Autosys.
  • Experience in working with different phases of testing such as unit testing, Integration Testing, Quality assurance testing and User acceptance testing.
  • A self-starter with the ability to quickly recognize and resolve issues under pressure and ability to work in a challenging and fast-paced environment.
  • Excellent team player with problem-solving and trouble-shooting capabilities.
  • Knowledge of Unix Shell script, BIG DATA and Hadoop.
  • Knowledge of AWS Lambda concepts, JSON.
  • Have knowledge of Oracle & Sql server DBA Activities.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/XP/Vista/7/8/10, UNIX

ETL Tools: Informatica PowerCenter 10.1.1/9.5/9.1.0/9.0/8. x, Informatica Developer 9.6.1, MSBI(SSIS)

Reporting Tools: Cognos 10.1.1\CA

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling

Change Management and Version Control Tools: Share point, CVS

Statistical Tools: Statistica

Data Bases: MS SQL server 2008/2012/2014 , Netezza, Oracle

Languages: SQL, Pl/SQL, Unix Shell Scripting

Data Governance and Testing: Informatica AXON, EDC (Enterprise Data Catalog) and Informatica DVO

Scheduling Tools: Zena, Tivoli & Autosys

Data Quality: Informatica Data Quality (IDQ) Developer 9.6.1,10.1.1

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead

Responsibilities:

  • Involved in gathering, analyzing and documenting business requirements and functional requirements and data specifications from users and transformed them into technical specifications.
  • Extensively worked on Enterprise Data Catalog Administrator to create different resources to connect to different types of sources.
  • Extensively worked on loading the EDC resources and exporting them to create the Data Catalog.
  • Extensively worked on Informatica AXON tool to create the Data Glossary of Metadata.
  • Worked on creating Bulk upload templates in Axon for Systems, Sub-Systems and Attributes
  • Responsibility of project role outs and implementations within the specified SLAs
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

Confidential

Project Lead

Responsibilities:

  • Involved in gathering, analyzing and documenting business requirements and functional requirements and data specifications from users and transformed them into technical specifications.
  • Extensively worked on data extraction, Transformation and loading data from various sources like SQL Server, Flat files, XML files, CSV files.
  • Responsibility of project role outs and implementations within the specified SLAs.
  • Developed the Informatica Mappings by using transformations like Xml Generator, Xml Parser, Aggregator, sorter, expression, Joiner, Union, SQL overrides usage in Lookups (both connected as well as unconnected), source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Extensive usage of Informatica DVO in creating the re-usable test cases for testing purpose.
  • Used IDQ in cleaning the data by using Address Doctor, Parser, Standardizer Transformations.
  • Created Stored Procedures in PL/SQL.
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
  • Extensive use of statistical tool Statistica for setting up Monitoring and Alerting system and Integration of data feeds in the workspaces.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Created prompt, list and chart reports using IBM Cognos Report Studio.
  • Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
  • 24 X 7 production support for all the security master central applications and provide solutions to the production failure jobs
  • As a Scrum Master - set up the agile board, involve in Sprint planning, breakdown the tasks, identify the impediments and track the progress

Confidential

Project Lead

Responsibilities:

  • Involved in gathering, analyzing and documenting business requirements and functional requirements and data specifications from users and transformed them into technical specifications.
  • Extensively worked on data extraction, Transformation and loading data from various sources like SQL Server, NETEZZA, Flat files, XML files, CSV files.
  • Responsibility of project role outs and implementations within the specified SLAs.
  • Used IDQ in cleaning the data by using Address Doctor, Parser, Standardizer Transformations and Profiling the data
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
  • Extensive use of Statistical tool Statistica for Text mining and scoring.
  • Created prompt, list and chart reports using IBM Cognos Report Studio.
  • Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
  • 24 X 7 production support for all the security master central applications and provide solutions to the production failure jobs

Confidential

Project Lead

Responsibilities:

  • Interaction with business users in discussing the approach and doing gap analysis for the varying functionality.
  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Extracted data from Oracle, Sql server and flat files and created complex queries to build Analytical model
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters and parameter files.
  • Created workspace for data mining and scoring using Statistica Tool.
  • Extensively worked on Error handling and fall out strategizing.
  • Created complex mappings which involved Slowly Changing Dimensions implementation of Business Logic.
  • Created packages using SSIS tool to do fuzzy lookup on data.
  • Extensively implemented sessions to perform initial load, Incremental load and Constraint based Load ordering.
  • Involved in peer reviews.
  • Created workflows by following best practices and scheduling them using Zena Scheduler.
  • Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
  • Extensively did testing for the application developed.
  • It includes Unit Testing, Regression Testing, Integration Testing and User Acceptance Testing.
  • Handled the additional responsibility of coordination and reviews for the team.

Confidential

Sr Application Developer

Responsibilities:

  • Gathered requirement from the client and translated the business details into Technical design.
  • Created mappings, mapplets, session and workflows.
  • Performed unit testing and prepared documentation.
  • Used the functional document to design application logical and the physical design using PL/SQL and Shell Scripting.
  • Prepared Test Plans for various modules.
  • Attend weekly project meeting and provide status on each task assigned.

Confidential

Informatica developer

Responsibilities:

  • Gathered requirement from the client and translated the business details into Technical design.
  • Used technical document to design the database tables.
  • Created mappings, mapplets, session and workflows as part of the POC.
  • Performed unit testing and prepared documentation.
  • Used the functional document to design application logical and the physical design using PL/SQL and Shell Scripting.
  • Prepared Test Plans for various modules.
  • Attend weekly project meeting and provide status on each task assigned

Confidential

Techno-Functional Consultant

Responsibilities:

  • Creation of Info Packages, info package groups and Process chain maintenance
  • As part of Quality management standards to deliver the objects in quality performed Unit testing and recorded the test results in unit test cases documents in Quality Center Tool
  • Extensively worked on ETL from Customer generated application specific generic extractors LIS, LO, CO-PA and SAP BW/BI 7.0 content.
  • Experience in process chain management, Monitoring and scheduling the batch jobs
  • Created Process Chains to automate the data load and data target administration and monitored the processes
  • Prepared test script documents for BW reports and tested Various BW reports defects raised in Quality Centre
  • Prepared Test Plans for various modules.
  • Prepared user manual and technical support manual.
  • Attend weekly project meeting and provide status on each task assigned

Environment: SAP BI 7.0, Oracle DB

Confidential

Application Developer

Responsibilities:

  • Gathered requirement from the client and translated the business details into Technical design.
  • Used technical document to design the database tables.
  • Created mappings, mapplets, session and workflows
  • Created database triggers for data security.
  • Created Stored Procedures and Functions.
  • Used the functional document to design application logical and the physical design using PL/SQL and Shell Scripting.
  • Prepared Test Plans for various modules.
  • Prepared user manual and technical support manual.
  • Attend weekly project meeting and provide status on each task assigned

Environment: Informatica, Oracle, PL/SQL, Shell Scripting,.

Hire Now