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.
• Certified Scrum Master (CertificantID:000728827)
• 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.
• Act as a Scrum Master.
• 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:

• Currently working as a Lead gathering and analyzing the requirements from the client, sizing the Dev and QA effort for the Projects, Preparing the Design doc, Test Plan, leading the test execution, work distribution and coordination.
• Act as a Scrum Master.
• 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
• Tested many AbInitio graphs and worked with all kinds of Components including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine Format, Sort, Join, FBE, Partition Components, Transform and Continuous Flow Components.
• 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
• 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 & 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
• 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 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
• 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