SUMMARY

• 11 years of experience in Software Quality Assurance and Testing of Stand Alone, Front & Back End Web Based applications, Data Warehousing, BI, ETL Testing & Hadoop in Finance/ Payment, Telecom and Marketing Domain.
• Expertise in Business Requirement gathering through walkthroughs, workshops and main concentration in Business Process Flow and Business modeling tools as a Business analyst
• In depth, technical knowledge and understanding of Data Warehousing, Data Validations, DB2, UNIX, ETL, Micro Strategy & Datorama.
• Well versed with various types Software Development methodologies - Water fall, Agile and Iterative.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Expert in Develop Test Plans, Test Designs, Specifications, Test Cases and Scenarios as well as creating Test Cases in Gerkein format and review it.
• Experienced in DW projects ETL testing against DW testing with AbInitio tool.
• Developed AbInitio test environment for UAT testing and used all AbInitio components while testing the graphs and ran the jobs on back ground
• Proficient in testing Ab Initio continuous graphs which interact with Federated Query layer via XML.
• Setup Hadoop environment and test data loading into Hadoop tables after creating into the database and validating those data using Hue from Hive database.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
• Good technical Knowledge of UNIX Utilities.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Extensively involved in UAT by supporting Testing and implement QA Process.
• Extensively Used Quality Center, Rational Clear Quest for Test Case and defect tracking management.
• Tested the ETL AbInitio graphs and other ETL Processes (Data Warehouse Testing)
• Extensive experience in writing SQL to validate the database systems and for backend database testing
• Expert in working with various cross geo teams across the world with various time zones.
• Excellent interpersonal and communication skills with good learning curve in short span of time.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules
• Experienced in leading teams to ensure quality and defect free deliverables.
• Exposure to GitHub, Cucumber, Amazon Web Services (AWS) and QuerySurge

TECHNICAL SKILLS

Operating Systems: Windows XP/ 2000 Professional /98/NT, Unix, MVS

Languages: PL/SQL, Shell Scripting, SQL

Open source: Hadoop, PIG, HIVE, AWS

Database: ORACLE, DB2, Teradata

Testing Tools: Rational Clear Quest, Quality Center, Hue, ALM, TestRail, Query Surge

ETL Tools: AbInitio GDE 3.1.7.3, AbInitio CO>OP 3.2.1.4, Datorama

BI Tools: Micro strategy 9.4.1

Agile Tool: Rally, Jira, CSM Certified

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Lead Test Engineer

Responsibilities:

• Coordinate and Lead Offshore Quality Engineer team and actively participate in ensuring the smooth business operations for the different markets.
• Write Testcases in Gerkein format and review it.
• Testing of Payment, Marketing Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations using AWS.
• Testing action filters, parameters and calculated sets for preparing dashboards and worksheets in Datorama.
• Work extensively with Advance analysis Actions, Calculations, Parameters, Background Images and Maps.
• Analyse stored procedure to re-create Reports and Dashboards in Datorama.
• Involve with Data Integration team to understand Data Mapping used to create data streams in Datorama.
• Create Ad server, Ad Verification, Daily Billing, 3rd Party Vendor Data Streams along with Data Load Rules into Datorama.
• Furthermore, create parent-child relationship between ad server and billing data streams.
• Create Filtered Measurements, Calculated Measurements and Dimensions, defined Highlighted Rules for Goal for preparing Dashboards and reports in Datorama.
• Responsible for creating Data Stream Templates, Dashboards, Page and Reports Template to share with other accounts and brands.
• Create data streams, dashboards and reports schedules in Datorama.
• Responsible to check log for data stream on daily basis and do pivot table for the data stream to validate the data has been processed for that day.
• Responsible to re-process Ad Server Data Stream, if any data stream has been failed to process last 7 days of data.
• Create/Update detailed (step by step procedure) documents for dashboards and reports using Datorama, SSRS.
• Involve in maintaining GitHub, which includes internal web scripts, other.

Environment: Datorama, GitHub, AWS, JIRA, Test Rail, Flat Files, Excel, MS PowerPoint, UNIX

Confidential, Foster City, CA

ETL Test Lead and End-to-End Tester

Responsibilities:

• Holding regular meetings with implementation team members, client staff project team to monitor tasks, update plan activities and issues until the client’s “Go Live” date.
• Reviewed business requirements, technical requirements, use cases, database architecture diagram and star schema model metadata requirements for application quality assurance purpose.
• Identified mistakes, missing information, gaps in the business requirement documents and suggested changes for the same.
• Coordinated with business users and conducted brain storming sessions to derive business scenarios to test Java web interfaces (Application) and data warehouse application.
• Worked in different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Prepared test plan and reviewed with stakeholder’s project management team and data base developer.
• Prepared test data requirement, coordinated with DBA’s to migrate production data into test environment.
• Created quality assurance readiness review document and reviewed with stakeholders and project management teams before and after test execution.
• Created test cases for Smoke testing, System testing, Functional testing, Load/Stress testing, Regression testing and User Acceptance Testing.
• Stored and managed test cases in Quality Center for multiple releases, baselined and used for Regression testing and System testing.
• Created Regression test sets in ALM Test Lab module and executed the same for Regression testing.
• Regression tested the changes in the Java based User Interfaces and application business process
• Worked as ETL QA lead to test Ab initio graphs for data migration using extraction transformation loading.
• Used effectively SQL queries for the better performance of the data base.
• Unit testing of applications and business processes using SQL.
• Executed UNIX shell scripts using Putty for extraction transformation loading.
• Validated reports generated by Reporting Tool Micro Strategy.
• Created test status reports throughout the testing life cycle Quality Center, reports and graphs, test case execution data and communicated to stake holder project management team.
• Interacted with business users on daily basis to resolve any data related issues and supported in the issue resolution process.
• Supported and coordinated with DBA’s to resolve missing data.
• Worked closely with portal leads and architects to provide and implement best practice solutions.
• Trained business users in various occasions about application enhancement quality assurance tools such as rational clear quest, quality center and QA industry best practices.
• Logged and drove defects to resolution using rational clear quest for multiple releases.
• Conducted UAT testing on the applications. Involved in training end users on the application.
• Involved in discussions with business team on Business requirements, UAT, BAU and change controls.

Environment: AbInitio CO>OP 3.1, GDE 3.1, EME, JIRA, HP Quality Center 10.0, Flat Files, Excel, MS PowerPoint, UNIX, IBM AIX 6.1, Shell Scripting, Micro strategy 9.4.1

Confidential, Foster City CA

ETL Test Lead

Responsibilities:

• Effort estimation of the forecasted work based on High level scope.
• Managing effort and task distribution between team Members.
• Mentoring Team members.
• Participate and provide views in the preliminary and detail design reviews.
• Played an effective role in end to end SDLC and STLC
• Successfully managed a group of Quality analysts.
• Reviewed and analyzed Business Requirements, system and data requirements and clarified with Business Analyst.
• Developed Test Plan, Test strategy, Test scenarios and test scripts as per the requirements and design
• Coordinated Offshore and onsite team and delivered the services on time effectively to accommodate the release time lines.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using AbInitio
• Experience in testing systems interacting with open source technology like Hadoop (PIG and HIVE)
• Reviewed High Level and Lows Level Design docs and clarified design solutions with Developers
• Developed the ETL and BI testing strategy
• Performed Sanity, system, Integration, Regression Testing
• Supported Performance, Load and UAT testing
• Created requirements traceability matrix for the test cases developed
• Reviewed Test plan and Test cases with the team
• Used Quality center for documenting the test cases
• Executed the Test cases in Test lab and Logged the defects and linked the same with the respective Test cases
• Effectively communicated the Defect status within the team for clear idea on issues affecting the release timeline
• Developed Shell scripts and successfully executed the scripts
• Performed Positive and negative Testing for all the data fields
• Testes various Load jobs to load the data into tables
• Reviewed and tested the Tables for their DML’S and Load properties
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested complex Transformations in ETL process
• Had good command on Unix scripting & SQL queries
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Reported bugs and tracked defects using Rational Clear Quest
• Used SQL in extensively querying the Teradata database in Unix environment
• Presented the Test results to team to review and get approval
• Created Gold regression suites for use in Future enhancements and defect fixes
• Created and Maintained Master run books for future use
• Conducted inter and intra domain Knowledge sharing sessions to effectively manage Resources effectively
• Preparation of various test documents for ETL process in Quality Center.
• Effectively provided the Testing documents like Test plan, Performance assessment document (PAA), Test cases and Test results to the Project management team for Pre-and post-release Documentation
• Reviewed the test entrance and exit criteria’s with in the Software testing life cycle for smooth delivery of the testing services
• Communicate with Developers and DBA
• Proved as an excellent team leader

Environment: AbInitio CO>OP 3.1, GDE 3.1, EME, JIRA, HP Quality Center 10.0, Flat Files, Excel, MS PowerPoint, UNIX, IBM AIX 6.1, Shell Scripting

Confidential

ETL Test Lead

Responsibilities:

• Played an effective role in end to end SDLC and STLC
• Successfully managed a group of Quality analysts.
• Reviewed and analyzed Business Requirements, system and data requirements and clarified with Business Analyst.
• Developed Test Plan, Test strategy, Test scenarios and test scripts as per the requirements and design
• Coordinated Offshore and onsite team and delivered the services on time effectively to accommodate the release time lines.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using AbInitio
• Tested many AbInitio graphs and worked with all kinds of Components including Transform and Continuous Flow Components.
• Worked with all kinds of components with AbInitio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine Format, Sort, Join, FBE, Partition Components.
• Reviewed High Level and Low-Level Design docs and clarified design solutions with Developers
• Developed the ETL and BI testing strategy
• Integration, Verification and Validation testing
• Maintain the Applications & Investigation & Hot-Fix testing
• Performed Sanity, system, Integration, Regression Testing
• Supported Performance, Load and UAT testing
• Created requirements traceability matrix for the test cases developed
• Reviewed Test plan and Test cases with the team
• Used Quality center for documenting the test cases
• Executed the Test cases in Test lab and Logged the defects and linked the same with the respective Test cases
• Effectively communicated the Defect status within the team for clear idea on issues affecting the release timeline
• Developed Shell scripts and successfully executed the scripts
• Performed Positive and negative Testing for all the data fields
• Testes various Load jobs to load the data into tables
• Reviewed and tested the Tables for their DML’S and Load properties
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested complex Transformations in ETL process
• Had good command on Unix scripting & SQL queries
• Reported bugs and tracked defects using Rational Clear Quest
• Used SQL in extensively querying the Teradata database in Unix environment
• Presented the Test results to team to review and get approval
• Created Gold regression suites for use in Future enhancements and defect fixes
• Created and Maintained Master run books for future use
• Conducted inter and intra domain Knowledge sharing sessions to effectively manage Resources effectively
• Preparation of various test documents for ETL process in Quality Center.
• Effectively provided the Testing documents like Test plan, Performance assessment document (PAA), Test cases and Test results to the Project management team for Pre & post release Documentation
• Reviewed the test entrance and exit criteria’s with in the Software testing life cycle for smooth delivery of the testing services
• Communicate with Developers and DBA
• Proved as an excellent team leader

Environment: AbInitio CO>OP 1.14, GDE 2.14, EME, HP Quality Center 9.0, Flat Files, Excel, MS PowerPoint, UNIX, IBM AIX 6.1, JCL, Shell Scripting Oracle 10g, SQL, PL/SQL, QTP 9.0, DB2 8.x, IBM AIX 5.5, Flat Files, Shell Scripting, UNIX, TOAD

Confidential

ETL Tester

Responsibilities:

• Played an effective role in end to end SDLC and STLC
• Reviewed and analyzed Business Requirements, system and data requirements and clarified with Business Analyst.
• Developed Test Plan, Test strategy, Test scenarios and test scripts as per the requirements and design
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using AbInitio
• Tested many AbInitio graphs and worked with all kinds of Components including Transform and Continuous Flow Components.
• Worked with all kinds of components with AbInitio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine Format, Sort, Join, FBE, Partition Components.
• Reviewed High Level and Lows Level Design docs and clarified design solutions with Developers
• Developed the ETL and BI testing strategy
• Integration, Verification and Validation testing
• Maintain the Applications & Investigation & Hot-Fix testing
• Performed Sanity, system, Integration, Regression Testing
• Supported Performance, Load and UAT testing
• Created requirements traceability matrix for the test cases developed
• Reviewed Test plan and Test cases with the team
• Used Quality center for documenting the test cases
• Executed the Test cases in Test lab and Logged the defects and linked the same with the respective Test cases
• Developed Shell scripts and successfully executed the scripts
• Performed Positive and negative Testing for all the data fields
• Testes various Load jobs to load the data into tables
• Reviewed and tested the Tables for their DML’S and Load properties
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested complex Transformations in ETL process
• Had good command on Unix scripting & SQL queries
• Reported bugs and tracked defects using Rational Clear Quest
• Used SQL in extensively querying the Teradata database in Unix environment
• Presented the Test results to team to review and get approval
• Created and Maintained Master run books for future use
• Conducted inter and intra domain Knowledge sharing sessions to effectively manage Resources effectively
• Preparation of various test documents for ETL process in Quality Center.
• Communicate with Developers and DBA

Environment: AbInitio CO>OP 1.14, GDE 2.14, EME, HP Quality Center 9.0, Flat Files, Excel, MS PowerPoint, UNIX, IBM AIX 6.1, JCL, Shell Scripting Oracle 10g, SQL, PL/SQL, QTP 9.0, DB2 8.x, IBM AIX 5.5, Flat Files, Shell Scripting, UNIX, TOAD