We provide IT Staff Augmentation Services!

Senior Consultant Resume

Richmond, VA

SUMMARY:

Senior ETL Developer/Consultant with 8.6 years of Data warehousing (DWBI) insight and flawless experience in preparing Informatica v9.5.1, v10.1 workflows and mappings and maintaining the utmost ETL Standards for client satisfaction. Expertise in UNIX, Talend and Pentaho tools alongside Informatica.

SKILLS:

  • Expert in Unix Shell Scripting
  • Knowledge of Pentaho and Talend Tools
  • Exposed to Scheduling Tools like Maestro, OEM, JP1 (Beginner)
  • Worked on DB2, MYSQL, ORACLE 10g/12c databases
  • Worked on INUX, WINDOWS 8/7/XP Operating System platforms
  • Versed in English, Telugu, Hindi languages
  • Web and tech savvy, require little to no
  • Committed as a Team Player towards attaining the set goals
  • Excellent Team Coordination and Leadership Skills

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior Consultant

Responsibilities:

  • Analyze business requirements and prepare flowcharts of existing and new business processes using tools like MS Visio.
  • Data mart design and development using ETL tools such as Informatica Powercenter, Greenplum, Oracle & UNIX Shell Scripting, related tools such as Erwin for database modelling and SQL Developer for creation of database objects.
  • Developed mappings for extracting, transforming and loading data into staging from source database.
  • Implemented SCD Type 1 and Type 2 in mappings to maintain history while populating Dimensions.
  • Responsible for Accepting and implementing Incident Requests (IRs) for direct fixes in production and Service Requests (SRs) for Application related changes, submitted by Business Analysts in Service Catalog/Service Now and tracking tickets on Genworth Helpdesk portal.
  • Co - ordinate with the testing team/QA for system and integration testing. Provide technical inputs during testing.
  • Identify and implement value innovation ideas for bringing improvement in Genworth’s business processes.
  • Creating unit test cases and executing test scenarios using in-house validation tool for coding standards, syntax, naming conventions, etc. Handling QA defects using HP Quality Centre. Correcting and validating errors identified by QA. Solve technical errors reported by users during UAT (User Acceptance Testing) phase and production deployment.
  • Developing code for building reusable framework to accomplish re-start ability within ETL using Shell Scripting, and PMCMD utility on UNIX for Decision Support systems using Business Intelligence techniques like Online Analytical Processing (OLAP)
  • Provide post-deployment production support to IT support and business end-users.

Confidential

Senior Consultant

Responsibilities:

  • Gather and analyse user Requirements to design ETL specification for each load.
  • Responsible for converting the Functional designs into Technical Specs.
  • Involve in High Level Design (HLD) and Low Level Design (LLD) of application with Informatica.
  • Attend business meetings for gathering business requirements, daily and weekly status calls.
  • Document and implement ETL model practices for the benefit of application development team.
  • Create Informatica Mappings and workflows as per requirement.
  • Mentor junior resources and troubleshoot any bottlenecks.

Confidential

Senior Consultant

Responsibilities:

  • Involved in creation of Proposals (RFP), for various opportunities.
  • Gather and analyse user Requirements to design ETL specification for each load.
  • Responsible for converting the Functional designs into Technical Specs.
  • Provide estimation for requirements at different levels for all modules and get Client approval.
  • Involve in High Level Design (HLD) and Low Level Design (LLD) of application with Informatica.
  • Attend business meetings for gathering business requirements, weekly status calls.
  • Document and implement ETL model practices for the benefit of application development team.

Confidential

Project Lead

Responsibilities:

  • Mentored, monitored the team and provided technical as well as process related solutions to ensure consistent progress.
  • Ensured on-time and efficient delivery of all 23 modules including those which were at critical stages and nearing SLA breach.
  • Prepared process related UNIX scripts which are being used across all modules in the project. These Shell scripts were used to execute workflows in different environments (QA and INT), appending & Renaming files, report reconciliation etc.
  • Documented all the best ETL model practices for the benefit of application development team.
  • Gathered and analysed user Requirements to design ETL specification for each load. Responsible for converting the Functional designs into Technical Designs using Informatica and suggested an optimized code to avoid Bottlenecks.
  • Estimated requirements at different levels for all modules and got approved from the Client.
  • Co-ordinated with different teams like DB Support, Unix, Mainframe etc. to ensues ETL Deliverables.
  • Co-ordinated with the testing team/QA for system and integration testing.
  • Involved in Production support activities and ensured Batch trail meets SLA.
  • Prepared schedule documents and submitted and monitored on Maestro console.
  • Attended business meetings for gathering business requirements, weekly status calls and troubleshooting any issues.

Confidential

Technical Lead

Responsibilities:

  • Studied all the dimensions and facts and know the relationships and hierarchies involved.
  • Designed ETL specification for each load.
  • Prepared detailed project execution document.
  • Identified each of the jobs scheduled for the process.
  • Coded and tested the individual modules against the Unit Test Cases.
  • Worked on Powercenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Used ETL to extract and load data from Flat files to DB2 UDB.
  • Documented HLDs, LLDs and UTCs, Load Analysis, Remediation document, Internal Tracker, VISIO document.
  • Built Generic code for quick implementation.
  • Built Generic shell scripts for quick implementation

Confidential

Senior Software Engineer

Responsibilities:

  • Involved in requirements gathering & requirements understanding.
  • Involved in Dimensional modelling.
  • Designed the ETL processes using Informatica tool to load data from sources to the target database.
  • Coding and testing the individual modules against the Unit Test Cases.
  • Designed a Framework / template for iReports that can be used to create reports, thus reducing the extra development efforts.
  • Created reports with parameters, Variables features.
  • Designed reports that exports to excel, pdf, html, csv without any external formatting.

Hire Now