PRINCIPAL EXPERTISE:

• 10+ years of Software Quality Assurance (QA) experience with Manual and testing of ETL/Data Warehouse, BI (Business Intelligence) reports, Database, Web and Client - Server Systems and Applications for Energy industries
• 6 years of extensive ETL/Data warehouse, DB (Backend testing) and BI (Business Intelligence) reports testing experience
• Extensive ETL Testing working experience using IBM Datastage 8.7 ( Datastage and Quality stage Designer, Data stage and Quality stage Director, IBM InfoSphere Information server manager)
• Excellent understanding of IBM InfoSphere Information server architecture (IBM Data stage 8.7).
• Extensive ETL testing working experience using Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server).
• Expertise in ETL testing experience using MSBI(SSIS - Sql Server Intergration Services, SSRS - Sql Server Reporting Service)
• Excellent knowledge in extraction, cleansing and modification of data from/to various data sources like flat files and databases.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Strong in BI report validation using Tabluee, Cognos, SSRS, Business Objects
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.
• Very strong understanding of DB Concepts, have worked on Oracle,SQl server
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in UNIX Shell Scripting
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying Data mismatch.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Thorough knowledge on Data ware House concepts of Star Schema, Snow Flake, Dimension and Fact tables
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Work extensively with slowly changing Dimensions Tables.
• Integration Testing was performed on various PO/INV/AP processes such as Quick Source Requisitions, PO Dispatch, Outbound File Publish, Process Receipts, Reservations, Order Release Request, Picking Confirmation, Depletions, Cost Accounting Entries, INV Journal Generate,Voucher post, Payment Post, Matching, and AP Journal Generate
• Strong working knowledge on Web services testing (SOAP UI ), Postman and API
• Excellent experience working on end-to-end Software Testing Life Cycle projects
• Good experience in AGILE delivery process of software using SCRUM
• Very good experience testing client server and web based applications on Windows platform.
• Mock-up the EDI X12 files
• Provided training to onsite & offshore team on EDI X12
• Created the new file transaction 814 14(Mass Acquisition),814 11 Drop Response,810 02 A5 charges,814 22 ISTA enrollment 814 18 CSA Establish,814 19 CSA Delete which are not available in the production.
• Help other project by creating the 814 22,814 18,184 19 files which they used in their project(ISTA migration)
• I am SME for all new functionality implemented in Texas Set 4.0 i.e. Mass Acquisitions, Critical Care, Switch Hold, Advance Meter
• Worked on all market transaction i.e. mock-up the below inbound flat files 814 02, 814 05,867 04,867 03,810 02,867 02,814 06,814 08,814 09,814 12,814 13,814 17,814 25,
• 814 28,650 02,650 04 etc
• Outbound - 814 01,814 16,814 24,650 01 etc
• Extensive experience in System Integration, Regression, Risk-based, Cross Compatibility and User Acceptance Testing. Involved in Requirements Ambiguity Testing, Test Scenarios analysis/identifiecation and build robust test suites. Defect Management, Test Management and Report Management. Gather the detailed requirements that clearly and completely define the project.
• Involved in the activities that include preparation of Test Strategy, Test Approach documents, Test Plans, Project Proposal, Effort Estimates, Resource Estimates, Work Breakdown Structure, Quarterly Update Reports and Project Closure Reports.
• Involved in maintaining continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
• Worked on Web based applications with SQL Server 2005 as backend database and good understanding of Reporting for the same.
• Hands on experience in bug-tracking tools like Bugzilla,Jira, Quality Center and ALM.
• Hands on experience in deploying the Builds using Github
• Extensive knowledge in Energy-Utilities, E-learning and Networking domains.
• Proficient in test case design from Business, Technical, and Functional requirements.
• Communication with client on daily basis to sync-up on work schedules, requirements, and product issues. Sending Daily Status Reports and Weekly reports to clients.
• Preparing Project Metrics and support the management team in analyzing the risks.

TECHNICAL SKILLS:

Tools & Utilities: MTM, ALM, QC 9.5/10, Silk Center, JIRA, Perforce, SharePoint and VSS

DWH Tools: Informatica 9.5, MSBI (SSIS -- SQL server Integration Service & SSRS)

Open source tool: Soap UI 2.5/3.0/4

Testing: Manual testing, ETL Testing, Database Testing, Functional testing, Regression testing, Automation testing, IVP testing, Localization UI Testing

Methodologies: RUP, Agile and Waterfall

Programming languages: SQL, PL/SQL

RDBMS: Oracle 9i and MS SQL Server .

Reports: Crystal Reports, SSRS (Sql Server Reporting Services)

MS-Office: Outlook, Express, Word, Excel and Power point

Operating systems: Windows 7/Xp/Vista/2000 Professional/2003 Server, MS DOS, UNIX

Domain knowledge: Energy, E-Learning, Banking, Health Care, Automobile & Billing,E-Commerce

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

ETL Test Lead

Responsibilities:

• Reviewing the ETL Mapping sheet and identifying the test scenarios
• Written Test Cases for ETL to compare Source and Target database systems.
• Involved in creation/running of high performance jobs through Expertise in ETL testing experience using MSBI(SSIS - Sql Server Intergration Services, SSRS - Sql Server Reporting Service) to generate test data
• Have performed the below activities as part of ETL testing:
• Verify that data transformation from source to destination works as expected
• Verify that expected data is added in target system.
• Verify that all tables and specified fields were loaded from source to staging.
• Verify data for record count match.
• Verify that for rejected data proper error logs are generated with all details.
• Verify NULL value fields.
• Verify data types and formats are as specified in design phase
• Verify that duplicate data is not loaded.
• Verify data integrity.
• Created and executed complex SQL queries to perform source to target testing on SQL server database.
• Validated BI reports using Business Objects SSRS.
• Worked on Oracle Fusion Financials Modules AP,AR, GL, PO, INV
• Tested the Customized the Application Engine process in Purchasing per business rules.
• Developed test scenarios/scripts and data requirements for Consigned Inventory and InterUnit/InterCompany transfers starting from item setup all the way to confirming entries in GL to ascertain that the consigned items have been consumed and costed. Tested cost accounting entries to GL.
• Integration Testing was performed on various PO/INV/AP processes such as Quick Source Requisitions, PO Dispatch, Outbound File Publish, Process Receipts, Reservations, Order Release Request, Picking Confirmation, Depletions, Cost Accounting Entries, INV Journal Generate,Voucher post, Payment Post, Matching, and AP Journal Generate
• Strong working knowledge on Web services testing (Postman )and API
• Extensively written SQL scripts for back-end validations
• Executed and managed test cases and reported bugs in Microsoft Test Management Tool(MTM).
• Executed and managed scenarios using Xmind
• Executed and managed test case, tasks and bugs uing Kanban.
• Deployed the QA build using the Github.
• Involving in the scrum sprint planning, Demo and Retrospectives
• Attending the scrums daily & updating the scrum board and coordinating with team for completion of requirements
• Implement Agile scrum methodology and Perform agile testing & requirements based functional, integration, system, database, regression testing and involve in user acceptance testing related QA activities
• Created understanding documents for each module covered that included
• Screenshots and detailed descriptions which would facilitate smooth knowledge for team member & other teams.
• Attending Business reviews and walkthroughs of flow diagrams along with business users to discuss the various "business-critical" flows
• Preparation of functional test plan, requirement ambiguity reports, requirement traceability matrix, test approach document..
• Design high level test scenarios and send them to client for approval. Involve in review of test case design, test case execution and report the defects and track them to closure in MTM .
• Supporting client team post release for future enhancements, change requests that adds Value to business and end user
• Work closely with development on a day to day basis to communicate issues/observations found during the test execution.
• Participation in the weekly client meetings and Communicating with client about Relative Health of the Application.

Environment: Test Studio R2 2016(v2016.2.62, v2016.2.63), Selenium C# (v2.53.0), NET Frame Work 4.6, Visual Studio 2015, ASP.NET, C#, JavaScript, CSS, ADO.NET, HTML5, IIS 5.1, TFS, Web forms, XML, and SQL Server 2014, Agile Methodology, SCRUM, MTM (Microsoft Test Manager), Visual Studio Team Service, Mind Meister,SSIS,SSRS

Confidential, Houston

ETL QA Lead

Environment: IBM Data Stage 8.7, Business Objects, Microsoft Visual Basic .NET, ASP.NET, DevExpress, Web, Web services API, SQL Server 2008 R2, Unix, Win 7 (32-bit and 64-bit), QC 10, ALM.

• Purchase orders creation and their processing
• Creating Work Orders from successful purchase orders
• Scheduling the Work Orders
• Processing the plant operations based on the schedules
• Generating the Certificates of Analysis

Environment: Asp.Net, Vb.Net, SQL Server 2000, Visual Safe Source 6.0 and Windows 2000.