SUMMARY:

• Overall 9+ years of experience in Information Technology in software development and testing in Data warehousing/ETL with AbInitio and UNIX.
• 1+ Years of experience with Web automation testing using Selenium and trained on Big Data technologies.
• Looking forward to aspire to a challenging career, wherein enhancing my technical and domain knowledge and work immensely towards the growth of the organization.
• 9+ years of Solid testing experience in ETL,Data Warehousing, Business Intelligence and 1+ years of experience in Web/Mobile application testing.
• Trained on Big Data Technologies.
• Extensively used ETL methodology for testing ETL Solutions developed using Ab Initio and Informatica.
• Excellent understanding of the Software Development Life Cycle (SDLC) and Testing Life Cycle (STLC) Process.
• Good understanding of Salesforce Marketing Cloud.
• Expert in test scripts development, Test execution and bug reporting.
• Worked with design and development teams in bug fixing discussions.
• Worked in all sorts of Testing Black box, Functional testing, system Integration testing, Regression testing and User Acceptance testing.
• Extensive work experience in Waterfall and Agile/Scrum structure.
• Experience in working with large scale Enterprise Data Warehouse, Data Integration, Data Migration and Performance Improvement projects.
• Experience in coordinating testing activities, working with project team.Was a Test coordinator for more than 5 releases leading testing track and client reporting.
• Strong in STLC process, Test Strategy/Plan,Test exit reports, Test Estimation.
• Expertise In Telecom and Retail domain.Working experience with global vendors like British Telecom, Orange UK and Everything everywhere.
• Expertise in resource management.
• Solid understanding of Dimensional Data Modeling using Star Schema and Snowflake.
• Extensive experience in database testing on Linux/Unix platform and Extensive use of SQL to perform data validations and Report Validations.
• Exposure to OBIEE and Microstrategy.
• Experience with utilization of appropriate test methodologies and use of test management tools like Quality Center and JIRA.
• Experience in Web testing using Selenium.Performed Cross - Browser testing using BrowserStack.
• Highly motivated team player with analytical, organizational and technical skills can work independently and with the team.
• Unique ability to adapt quickly to challenges and changing environment.
• Excellent interpersonal skills, proven team player with an analytical and problem solving under stress environment.
• Effective Project & People Management Skills, exposure to Knowledge Management. Solid time management and prioritization skills.
• Trained on BigData and Informatica.
• Experience with conducting and running defect triage meetings with project teams.

TECHNICAL SKILLS:

ETL Tools: Ab Initio 2.8, 3.1.2.2,Informatica 9.x

Operating System: Windows, Unix

Programming Languages: Java, Bash Scripting,SQL

Databases: Oracle,Netezza,Microsoft SQL Server

Bug Tracker: Jira, Bugzilla,HP Quality Center,qTest Manager

Test Management Tools: Selenium webdriver, Maven, Jenkins, Ant, git,Jmeter

BigData: Hive,Hadoop,HDFC

Database and Reporting Tools: Toad,MySql,SQL Server Studio

SDLC Methodology: AGILE, Waterfall

MicroSoft Technologies: RTI,BizTalk,SSIS

BI Tools: Microstrategy

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

BI QA

Responsibilities:

• Developed and implemented test cases for functional,System,Integration and regression test phases
• Performed report validations with respect to Microstrategy Upgrade regression testing both UI and data validations
• Created SQL in SQL server studio for the backend table validations as part of new product Launch in JAPAN
• Worked closely with the Business Analysts and Users to understand the requirements and to address UAT issues
• Being part of the Design storm and Grooming sessions responsible to plan the test activities and communicating offshore about the requirement
• As an onsite coordinator handled ETL and SFMC (Salesforce Marketing Cloud) projects
• Responsible to prepare the test data requirements to satisfy the integrity for End to End data flow worked closely with the management team to bring Process in place.
• Handled a team of Offshore to get the project updates daily
• Provided inputs on automating the regression tasks and are well accepted.Planned to implement the same using Jmeter

Environment: SQL Server Management,SSIS,Microstrategy,qTest Manager,JIRA

Confidential, Pittsburgh

Test Engineer

Responsibilities:

• Develop and execute test cases.
• Wrote SQL to validate data based on requirements.
• Validated ETL Transformation logic and data cleansing rules.
• Used Informatica to create maps for data validations.
• Validated data mapping, selection criteria, transformations and data loads.
• Performed Data validations for different scenarios like update and deletion
• Validated source to target mappings,data mismatch,Integrity constraints.
• Developed and implemented test cases for functional,system,integration and regression test phases.
• Created test data to validate all the required scenarios when there is no source data available.
• Performed Source data validations to make sure the Business requirements are satisfied.
• Performed data cleansing validations.
• Provided daily test updates to the stakeholders.

Environment: Informatica,Unix,putty,SQL,Oracle,JIRA

Confidential, Atlanta

Quality Engineer

Responsibilities:

• Develop and execute test cases.
• Wrote SQLs to validate the transformation and data cleansing rules.
• Validated data mapping, selection criteria, transformations and data loads.
• Performed different ETL validations like Data validation on source and target tables.
• Validated source to target mappings,data mismatch,Integrity constraints.
• Used Ab initio to create graphs for test data generation and Regression validations
• Performed duplicate, count, CDC(Change Data Capture) data checks on source and target.
• Run/Validated ETL jobs using scripts
• Provided daily test updates to the stakeholders.

Environment: Ab initio,HP Quality Center,Unix,Oracle,putty,Jira.

Confidential, Sunnyvale, CA

Test Engineer

Responsibilities:

• Involved in design discussions,Use case preparation
• Developed Test Cases and Test Scenarios for functional and Integration testing.
• Participated in meetings, Reviews, walkthroughs and test design reviews.
• Performed Functional and Integration manual testing.
• Used BrowserStack for Compatibility and cross browser testing

Environment: Browserstack,Selenium WebDriver, JAVA,TestNG, HTML

Confidential

Senior Software Engineer/Offshore Test Coordinator

Responsibilities:

• Involved in discussions with clients, Product Owners, Design and Development teams to understand the requirements, scope & milestones
• Provided test estimates for the projects and involved in resource allocation.
• Prepared Test strategy,Test plan,Test exit reports for the project releases and was involved in test artifact review meetings.
• Represented test team in project discussions and Provided signoff for test exit reports.
• Involved in End to End testing of complex ETL projects,
• Developed Ab Initio graphs for some of the data validations, test data generation and for Regression validations.
• Developed and implemented test cases for system,integration,regression and UAT testing
• Trained the partner resources on Test process,domain & functionality.
• Prepared Templates for the test plan, test execution and test reports.
• Prepared reusable test case documentation for the functional,data validation,regression scenarios.
• Defined Test entry and exit level Criteria for the quality deliverables.
• Test Technical coordinator for the team, client reporting.
• Handled escalations in a pleasant environment.
• Performed RCA for the production failures.
• Played a major role in providing L1 and L2 support for the Tesco Finance Feeds.
• Responsible for handling all the data feeds coming to Finance from the UK,US and group countries.
• Communicating with different teams to have smooth data flow of Tesco finance feeds from the Integration Layer to the down Streams.
• Performed report validations using OBIEE.
• Addressing the tickets raised by end users on time without SLA breach.

Environment: Ab initio,Unix,putty,Oracle,Jira,RTI,BizTalk,SSIS,Toad,OBIEE.

Confidential

Software Test Engineer

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications to identify the gaps and bridge those to ensure coverage.
• Provided test estimates for the projects.
• Responsible for documenting functional requirements in QC.
• Developed Ab Initio graphs for the ETL process.
• Developed and implemented test cases for functional, system,integration,regression and User acceptance testing.
• Worked with the development teams to have a build plan and bug fixing strategy.
• Tested Data Migration and performance improvement projects.
• Involved in developing detailed test plans and exit reports for all the test types.
• Test lead for Harlequins project.
• Tested Complex ETL Mappings based on business user requirements and business rules to load data from source flat files to target tables and done End to End testing including Source file validations.
• Worked with Testing Data Extraction, Transformation and Loading (ETL).
• Documented all findings and assigned pass/fail statuses in QC.
• Logged many defects and followed on the Defect Life Cycle using JIRA.
• Analyzed issues and provided feedback to the development team.
• Communicated with clients to ensure functional requirements are met.

Environment: HP Quality Center,Unix,putty,Netezza DB,AbInitio Plan It, CVS,JIRA, Windows, Oracle 10G,and Toad .

Confidential

Software Engineer

Responsibilities:

• Research and analysis of the ETL- tool Oracle Warehouse Builder
• Research and analysis of BTGS applications in the BENELUX Region creation of DDL and DML
• Designed and developed various PL/SQL packages, procedures and functions.
• Understanding High Level Design and participating in the detailed design.
• Involved in creating AbInitio graphs, for various ETL processes.
• Written cron jobs to run AbInitio graphs.