We provide IT Staff Augmentation Services!

Senior Consultant Resume

3.00/5 (Submit Your Rating)

Pittsburgh, PA

SUMMARY:

  • 10+ years IT experience in developing Applications Using Informatica, Informatica B2B DX&DT, Data Modelling, Data Analytics, Data Visualization, Informatica IDQ Data Profiling, Unix Scripting, PMCMD, Oracle, Mainframe, Python, PETL,SQOOP and SQL Server
  • Experience in Informatica Power exchange for reading the legacy source system.
  • Worked on different Sources such as Oracle, Teradata, Power Exchange VSAM Files, SQL Server, Hadoop, Salesforce and Flat Files
  • Have been performing Project Lead for past 5 Years
  • Experience in SQOOP. - Oracle to Hadoop Integration, Data Robot -Data visualization tool
  • Experience in Tableau Data visualization
  • Diverse experience in HealthCare & Financial Domains
  • Experience in Estimation, MPP, Technical Interview Panel & Project management Activities
  • Involved in Preparing HLD, LLD, Test cases, Test Plan, Cut over Plan and ETL Estimation
  • Experience in independent team management.
  • Experience in leading offshore team as well as onsite team.
  • Have experience in both Agile & Waterfall Model project environment
  • Experience in EDI platform project
  • Experience on Data exchange file transfer management like Managed File Transfer, Message queue & Java Messaging Service
  • Secured Client Scope Awards for my contribution towards multiple Projects
  • Secured Client Award from Xerox for contribution of project.
  • Designed and developed EDW, Data masking Systems for prestigious clients Xerox & Ameriprise.
  • Involved in detailed Analysis, design, development, maintenance and upgrading systems to support business operations.
  • Very flexible and can work independently as well as in a team environment
  • Involved in migration code into different environments
  • Experienced in Performance and tuning of the ETL,Oracle & Linux
  • Shares learning and coaching experience through knowledge transfers between peers

TECHNICAL SKILLS:

Tools: Informatica Power Center 10.x/9.x/8.5.1/7.x/6.x, Informatica Power Connect & Exchange for Mainframe, Informatica B2B DX & DT, Tableau, SQOOP & IDQ Data Profiling,PETL

DB: Oracle 11i/10g/9.x/8.x, MS SQL Server 2008, Teradata

Design/Application: Microsoft Visio (Visio Soft Diagram), Control-M, CA7 Scheduler, TOAD, SQL Developer.

Languages/Scripting: UNIX, PL/ SQL, UNIX Shell Scripting, Python

Operating System: Sun Solaris, UNIX/LINUX, MS-DOS, Windows 2008/2007/ NT/2000/XP

Other Tools: Sql Developer, Winscp, Putty, Jira, Quality Center, Clear Case, Harvest

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Senior Consultant

Responsibilities:

  • Working as ETL Architect- independent resource supporting architecture design, data modelling & development
  • Working as Data Modeler and DBA support
  • Responsible for creating data pipeline with python to interact with the Risk platform website and check or cleanse the data.
  • Responsible for Design, Coding & support for all ETL & Inbound/Outbound Data.
  • Involved in Estimation and project management activities.
  • Collecting requirements from various business analysts and develop the code based on the Business requirements
  • Involved in ETL design, coding, testing and implementations.
  • Tuned the oracle query to load the huge volume of data.
  • Tuned the performance of complex Informatica mappings and database.
  • Worked with cross functional teams to resolve the issues.
  • Created slowly changing dimensions’ mappings to meet the business requirements.
  • Performed data validations.
  • Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables.
  • Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.
  • Performed Root cause analysis and resolved complex issues.
  • Prepared the recovery process in case of workflow failure due to database issues or network issues.
  • Supported the applications in production on rotation basis and provided solutions for failed jobs.

Confidential, Pittsburgh, PA

Sr ETL Lead /Appl Data Architect

Responsibilities:

  • Responsible for Design, Coding & support for all ETL & Inbound/Outbound Data.
  • Involved in Estimation and project management activities.
  • Collecting requirements from various business analysts and develop the code based on the Business requirements
  • Involved in ETL design, coding, testing and implementations.
  • Created test cases and test scripts to validate data.
  • Tuned the oracle query to load the huge volume of data.
  • Tuned the performance of complex Informatica mappings and database.
  • Worked with cross functional teams to resolve the issues.
  • Created slowly changing dimensions’ mappings to meet the business requirements.
  • Performed data validations.
  • Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables.
  • Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.
  • Performed Root cause analysis and resolved complex issues.
  • Prepared the recovery process in case of workflow failure due to database issues or network issues.
  • Supported the applications in production on rotation basis and provided solutions for failed jobs.
  • Actively attended the production support calls and pagers at all times and answered the business questions.

Confidential, Albany, NY

Project Team Lead

Responsibilities:

  • Leading the team from onsite as well as offshore.
  • Involved in Estimation and project management activities.
  • Collecting requirements from client through concept sessions.
  • Data Profiling on Legacy source.
  • Discussion with various business analysts and
  • Created test cases and test scripts to validate data.
  • Tuned the oracle query to load the huge volume of data.
  • Tuned the performance of complex Informatica mappings and database.
  • Worked with cross functional teams to resolve the issues.
  • Created slowly changing dimensions mappings to meet the business requirements.
  • Performed data validations.
  • Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables.
  • Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.
  • Performed Root cause analysis and resolved complex issues.
  • Prepared the recovery process in case of workflow failure due to database issues or network issues.
  • Supported the applications in production on rotation basis and provided solutions for failed jobs.
  • Actively attended the production support calls and pagers at all times and answered the business questions.

Environment: Informatica 8.6/9.x, Informatica Power Exchange, Informatica B2B, Oracle 10g, Windows, UNIX.

Confidential

Senior Systems Engineer

Responsibilities:

  • Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation.
  • Interpreted and comprehend business/data requirements from upstream processes
  • Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.
  • Created and documented source-to-target mappings and ETL specifications.
  • Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
  • Designed and performed all activities related to migration of ETL components between environments during development and deployment (Eg. Dev to SIT, SIT to UAT and UAT to PROD repositories).
  • Checked for missing data, negatives and consistency and completed field-by-field data verifications for source and target data consistency.
  • Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
  • Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.
  • Handled Salesforce CRM database in ETL.
  • Prepared the error handling document to maintain the error handling process and created test cases for the mappings developed then created the integration testing document.
  • Involved in the defect analysis call for UAT environment along with users
  • Developed workflows using Task Developer, Worklet Designer, and Workflow Designer in Workflow manager and monitored the results using Workflow Monitor.
  • Informatica Mapping Design and Informatica Coding.
  • Oracle Test Scripts Preparation.
  • Handling Production data - Analysis on Client requirement and providing inputs/Suggestions on enhancement or performance which can improve business aspects.
  • Handling New Change request and Defect Fixing.
  • Working with Mainframe and UNIX Shell Scripts preparation.
  • Handling User Acceptance Testing, System Integration Testing and Data Validations.

Environment: Informatica 8.5, Oracle 10g, Windows, Informatica Power Center, UNIX & Mainframe

We'd love your feedback!