Application Developer Data Integration ETL/ Test Automation

Summary

Over ** Years Experience in Information Technology Industry Software Development Life Cycle(SDLC) implementation (Gathering Business Requirements, Analysis, Design, Data Modeling, Application Development, Implementation, Debugging and Testing, code reviews and production support) of various functionalities of Business Intelligence, Data Warehouse and business applications using Agile and Waterfall Methodology.

Proficient in Informatica power center Designer Components: Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer and other power center client tools like workflow Manager, Workflow Monitor and Repository manager.

Extensively worked on Data Integration framework using Perl, Linux, Informatica Power Center, Oracle Job Control Tables, TERADATA, DB2,XML, IBM MDM

Experience with creating Db2 extracts for Business Partners with ETL using Informatica Power center

Automated, Redesigned and tuned several ETL Process for optimal utilization of Time and resources.

Extensively used complex transformations like router, lookup, joiner, expression, sorter, XML Generators and Parser, Update strategy, union, aggregator, normalizer.

Over 6 years Expertise test automation in an agile development environment implementing ATDD with Ruby and Cucumber.

Expert level experience in using test automation tools such as Quick Test Professional, SoupUI.

Working knowledge on Selenium as test Automation Tool.

Experience working closely with the project team in user story planning, user story development using Gherkin, and participating in retrospective meetings

Excellent communication skills, an energetic and positive attitude, strong team skills and an ability to mentor and coach people in Informatica Power Center, Cucumber, and Gherkin

Experienced in Functional testing, System testing, Application testing, Integration testing, Regression testing, Black Box testing, Smoke testing, UAT and GUI testing.

Expertise in writing Test Plans, Test Strategy, Test cases, Test scripts, Defect status reports, Test Summary report, Requirement Traceability Matrix.

Experience identifying areas for testing improvement and working with the teams to implement appropriate agile QA practices

Experience facilitating communication between developers, Business Analysts and QA Test Automation resources, driving a shared understanding of the domain

Good knowledge of Application Lifecycle Management Tools and Defect Tracking Tools like HP Quality Center (ALM), Rational Test Manager

Extensive interaction with developers, configuration management teams while handling production issues with development and business analyst teams.

Expertise in applying sound software testing techniques and principles to reduce number of defects, improve quality and enhance business success.

Self-starter, versatile team player, proactive and extremely detail-oriented with a proven capability of working under high pressure.

Confident and comfortable with both independent and team work.

Always keen to learn new technologies and look for advancement.

Professional Education

Currently undergoing Big Data Hadoop Developer Training and Certification Course

Post Graduate Diploma in Advanced Computing

Bachelor's degree in Electronics and Telecommunication Engineering.

INS21 Property and Liability Insurance Principles conducted by American Institute for CPCU. Insurance Institute of America

Key Skills

ETL : Informatica Power Center 9.5/9.6, Designer,

Repository Manager, Workflow Manager & Workflow Monitor, Informatica Developer (IDQ)

Testing Tool : QTP 10/9.5, RubyMine, SoapUI, Rational Robot 2003.06

Scripting Languages : VBS, SQA Basic, Ruby 1.9,Perl,PL/SQL

Database : Teradata, Oracle, SQL server, DB2, Denodo

Test Management Tools : HP-ALM (Quality Center), Rational Test Manager

Software life cycle management: Rational Team Concert and Rational Requirements Composer, HP-ALM

Work Experience

June 2011 till date Collabera Inc. USA

May 2007 to June 2011 Larsen & Toubro InfoTech, Pune India

September 2005 to May 2007 SQS India (Then known as Verisoft Info system Pvt. Ltd) Pune India

Client Details

CLIENT : NATIONWIDE INSURANCE (COLUMBUS,OH)

DURATION : OCT 2011 TO MAY 2017

ROLE : APPLICATION DEVELOPER ETL/TEST AUTOMATION

ENVIRONMENT : IBM MDM, DB2, INFORMATICA, LINUX, TERADATA, ORACLE, PERL, COBOL MICROFOCUS, MAINFRAME

TOOLS : INFORMATICA POWER CENTER, IDQ, RUBYMINE 8, RUBY, CUCUMBER/ RSPEC, QTP

CODE MIGRATION : SVN

SCHEDULER : Workload Automation ESP

CONTINEOUS INTEGRATION : Jenkins Server

ROLES AND RESPONSIBILITIES:

Extensively developed Low Level Designs (Mapping Documents) by understanding different source systems.

Designed complex mappings in Informatica to interact with IBM MDM.

Designed complex Business rules in IDQ.

Implemented Change Data Capture through XML comparison.

Created DB2 Extracts for loading in TERADATA

Created DB2 Extracts for Business partners for reporting, Data Analysis.

Developed complex Informatica mappings, sessions and workflows.

Developed complex IDQ rules which can be used in Informatica and as well in Online

Extensively used transformations like router, lookup, source qualifier, joiner, expression, sorter, XML, Update strategy, union, aggregator, normalizer and sequence generator.

Created reusable mapplets and reusable transformations.

Responsible to use existing and Modify or Add Perl Modules for Data Integration as per requirement.

Created and maintained and Run Events through CA Workload Automation ESP for Daily and Monthly or Adhoc Cycles.

Responsible for code migration during deployments.

Created and performed Unit tests over Informatica code.

Responsible for providing daily status report for all Informatica applications to customer.

Responsible for Monitoring and tracking the critical daily applications.

Worked on Performance tuning of Informatica designs and mappings.

Develop functional/regression automated testing solutions using RubyMine, Cucumber and data driven techniques.

Design and Architect modular and reusable automated testing solutions that satisfy testing requirements.

Responsible for closing user tickets and incidents.

Assist in estimating testing efforts and providing status updates

Lead teams - Direct and assist junior developers in their work

Created or updated, and reviewed business and technical requirements, functional specifications, and test cases to understand application solution requirements in order to test the application and verify successful implementation

Participated in writing structured test plans, create test strategy documents for manual and automated testing

Worked with development team to insure test coverage for all functionality plus analyzed and resolved defects. Worked with project teams to insure test coverage for all functionality.

Develop detailed documentation to support the development and testing effort.

Execute Acceptance/ Unit test script, report detailed defects description through defect tracking tool.

Worked with application development team to participate in solution design to ensure testability of functions and applications. Identified areas for improving efficiency, shortening of test cycles, and automation of test scripts.

Facilitated implementation of automated test scripts with significant interaction with internal customers.

Continually review and improve processes followed by teams and effectively implement them.

Assist in estimating work efforts and providing resource requirements.

Train/mentor junior developers and test automation end users, Run team counter parts.

CLIENT : CITI BANK (NYC,NY)

DURATION : MARCH 2011 TO JUNE, 2011

ROLE : LEAD CSA ANALYST

PROJECT : GDOS-CURRENT STATE ASSESSMENT

ROLES AND RESPONSIBILITIES:

Analyze Productivity of key business processes.

Utilization of appropriate Performance Metrics.

Validate Effectiveness of resource allocations.

Verify Synergy between core processes and organizational goals.

Identify Ability of IT to enable operational efficiencies.

Recommendations and Prioritization of processes to Operational ability to deliver more customer value.

Efficiency of inter-departmental hand-offs.

Remodel Existing Stakeholder Management if required.

RAG Chart Report

Provide Client with Implementation Strategy and Roadmap at application level

CLIENT : LEXISNEXIS / INSURITY (DALLAS TX, PUNE INDIA)

DURATION : JAN 2010 TO MARCH 2011

ROLE : ONSITE CO-ORDINATOR/ TEST LEAD

ENVIRONMENT : SQL SERVER 2000, VB.NET, ASP.NET

AUTOMATION TOOL : QTP 9.5, FITNESS, SOAPUI

ROLES AND RESPONSIBILITIES:

Understand application solution requirements in order to test the application and verify successful implementation

Write structured test plans for manual and automated testing

Develop functional/regression automated testing solutions using QTP, and data driven techniques.

Design and Architect modular and reusable automated testing solutions that satisfy testing requirements.

Develop detailed documentation to support the automation effort.

Execute test script, report detailed defects description through defect tracking tool.

Perform Web service testing using SoapUI

Performance and Load testing using Load Runner on need basis.

Continually review and improve testing process and implementation.

Assist in estimating testing efforts and providing status updates

Lead teams - Direct and assist junior automation developers in their work.

To resolve and troubleshoot problems based on analysis.

Participate in Internal Process compliance through Work Product audit, Work Process Audit, SMR etc.

CLIENT : TRAVELERS INSURANCE (PUNE, INDIA)

DURATION : MAY 2007 TO DECEMBER 2009

ROLE : LEAD TEST AUTOMATION DEVELOPER

ENVIRONMENT : LOTUS NOTES, VB.NET, ASP.NET.

AUTOMATION TOOL : QTP 9.2

ROLES AND RESPONSIBILITIES:

Prepare Estimation and plan for automation.

Prepared automated test scripts and maintained regression test suite using QTP (VBScript) according to application requirements

Developed automated tests using script modularity framework.

Prepared Bi-weekly test status reports for higher management and development team.

Help developers with writing unit test cases, ad-hoc manual testing to verify bug fixes

Identification of the test cases for automation and prepare Estimation and plan for automation.

Streamlined the automation process and enhanced the performance by creating modular reusable scripts which were called by other scripts.

Developed data driven tests including importing data using SQL

Created the Requirements traceability matrix, Functionality coverage matrix

Help developers with writing unit test cases, ad-hoc manual testing to verify bug fixes

CLIENT : SCANDENT SOLUTIONS-CAMBRIDGE INTEGRATED SERVICES GROUP INC (PUNE, INDIA)

DURATION : NOVEMBER 2005 TO MAY 2007

ROLE : TEST AUTOMATION DEVELOPER

ENVIRONMENT : JAVA, ORACLE 10G

AUTOMATION TOOL : QTP 8.2

ROLES AND RESPONSIBILITIES:

Study of the application.

Identification of the test cases for automation.

Recording and Enhancement of the scripts.

Written utility functions whenever required for the application.

Execution of the scripts and reporting bugs & verifying fixes.

Prepared weekly/monthly test status reports for the client management and development team.

Reporting & Verifying Bugs through Defect Tracking System on Intranet.

Interaction with client, transferring project as well as technical knowledge to team members.

Contact this candidate