SUMMARY

• 13+ years of IT experience in the areas of Software Testing, Oracle & Data warehouse development and Business Intelligence
• More than 9 years of experience in Software Testing life cycle (STLC), including analysis, design, coding, testing and implementation in Retail, Airline, Supply Chain, Life Sciences and MRDL domains
• Thorough experience in unit testing, system integration testing, UAT, implementation, maintenance and performance tuning
• Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling
• Strong working knowledge on Agile/Scrum principles like User stories, Acceptance criteria, grooming, planning, Retrospective, etc.
• Proficient in testing Applications/Dashboards developed for iPads, tablets and Mobile phones
• Exposure and knowledge of using ETL tools Informatica, DataStage with Oracle, Teradata environments
• Report development experience in BO tools such as WebI, DeskI, Universe designer, Import Wizard & Publishing Wizard (BO XI R3)
• Proficient in Informatica workflow scheduling, testing and dataflow
• Validating API - WSDLs with SOAP UI and JSON requests with RESTful Web service
• Strong understanding of Oracle 8i/9i/10g database and RDBMS concepts
• Proficient in Application Performance Tuning and Query Optimization
• Experience in Optimizing (Tuning) SQL Queries using Explain Plans, SQL Trace and utilities to pinpoint time consuming SQL’s and tuned them by using partitions and indexes
• Proficiency in using tools such as SQL*plus, TOAD, SQL developer
• Well versed experience and exposure to UNIX and Shell scripting
• Configuring & monitoring Load Testing environment using HP SiteScope
• Defect logging, assigning, tracking using HP Quality Center(formerly Mercury Test Director), JIRA & ClearQuest
• Proven track record of handling Automation projects using Performance Center LoadRunner, Quality Center, SOAP UI and SOA Test
• Worked with Customers for requirement gathering, effective analysis, design, implementation and support
• Well versed in documentation of Design Document, Traceability Matrix, Unit Test and SIT scripts, Implementation Plan, Production Run books, Production Schedule Checklists and Warranty Document.
• Well versed with multi-vendor multi-sourcing models, onsite-offshore-near shore models. Was instrumental in guiding, educating and motivating the team across geographies

TECHNICAL SKILLS

Domain: Airline, Retail, Services, Supply Chain Management, Data Warehousing/ETL/BI

Automation Tools: HP QuickTest Pro (QTP) 10, SOAP UI, SOA Test, HP LoadRunner 11.5

Performance Monitor: HP SiteScope 11.2

Agile: VersionOne, AgileCraft, JIRA

Mobile Deployment: AirWatch MDM

ETL Tools: Informatica 7/8.x/9.x, DataStage 8.1

Defect Tracker: TestManager, HP Test Director/Quality Center/ALM, JIRA, ClearQuest

Service Tool: HP OpenView, OEM (Oracle Enterprise Manager)

Databases: Oracle 9i/10g, Teradata 12, MS-Access 2000, UniVerse

Languages: SQL, PL/SQL, VBScript, UNIX Shell script

Database Tools: TOAD, SQL* Plus, SQL Developer

Versioning: MS Visual Source Safe (VSS), MKS Integrity client, Tortoise SVN

Environment: s: Windows 98/XP/2000/7/8, IBM Mainframe, UNIX, iOS 4 - 9, Windows RT

Scheduling: Appworx, CRONTAB

Reporting: Business Objects XI R3, MicroStrategy

PROFESSIONAL EXPERIENCE

Confidential, IRVING, TX

SR QUALITY ASSURANCE LEAD

Responsibilities:

• Gathering requirements, preparing test plan & test scenarios for various business functions
• Overseeing the testing carried out by test engineers, on the various application streams
• Functional and integration testing of Supply Chain applications (Order Mgmnt, Fulfillment, WMS, Shipping, etc.)
• Document any variance (defects, etc.) according to the protocol
• Interface with developers, project management and management in the development, execution and reporting project test results
• Issue resolution, status tracking and status reporting to Testing Manager and issue resolution co-ordination amongst various teams to ensure business continuity
• Testing the solution, including assisting the Confidential business users in Integration & user testing
• QA, UAT, Go-Live and Post Go-Live support

Confidential, PLANO, TX

SR QUALITY ASSURANCE LEAD

Responsibilities:

• Overseeing the testing carried out by test engineers, on the various enterprise applications
• Create test data for batch, front-end and End-to-end testing needs
• Configure & assign the iPads for the functional & performance testing requirements
• Deploy new iOS application(s)/changes to iPads in Test environments
• Generating defect reports out of HP Quality Center and report/share with respective teams
• Perform data validations during parallel environment phase and fixed issues
• Conduct daily/weekly scrum meets to check the task progress
• Validate the functions of SIMS (Point Of Sale) system with VAN
• Verify & validate that the item/merchandise sale is closed and can be scheduled for delivery/pick-up
• Working closely with teams involved in design, development, implementation, functional testing development process to plan activities for functional test team
• Timely status update of current task status to Product Owner/Business Analyst
• Coordinate with development/test/implementation teams for demo at the end of each sprint
• Working with implementation/release management team to get the expected version of code deployed and made available for test teams
• Ensures all processes are documented, followed and efficient

Confidential, DALLAS, TX

SR QUALITY ASSURANCE ANALYST

Responsibilities:

• Develop and maintain Test plan, Test data, Test Cases and System test execution plan for various applications being developed/planned within the organization
• Perform data validations at end of each development sprint for QA move, UAT and production implementation for all the ETL mappings (transformations/sessions)
• Assist Business Intelligence team for all their testing needs prior to any implementation
• Test and validate iPad dashboards for Parking, Concessions and CCA
• Liaison between the Project Manager and the user community for Infrastructure PoC projects
• Develop and maintain the QA Service Portfolio which lays out the governance standards and metrics with supporting templates, forms, and checklists
• Participate in daily/weekly scrum meetings to update the progress of the project
• Manage the user stories, backlogs and task completion on VersionOne
• Install and Configure SiteScope monitors for various server status monitoring
• Setup alerts on HP SiteScope server for incident reporting
• Prepare and share weekly/monthly status reports

Confidential, PLANO, TX

SR QUALITY ASSURANCE LEAD

Responsibilities:

• Overseeing the testing carried out by Performance test engineers, on the enterprise applications
• Create test data for batch, front-end and End-to-end performance testing needs
• Performed the load/stress testing of web/network traffic with support of LoadRunner
• Support the LoadRunner testers with their test data needs and Load test data on load generators
• Monitor performance tests (HP SiteScope), collect performance data, review test results and analyze data
• Generating defect reports out of HP Quality Center and report/share with respective teams
• Validate the functions of SIMS (Point Of Sale) system
• Verify & validate that the item/merchandise sale is closed and can be scheduled for delivery/pick-up
• Perform data validations during parallel environment phase and fixed issues
• Working closely with teams involved in design, development, implementation, functional testing development process to plan activities for performance test team
• ExecutingAutomation Scripts (VBScript)and have them stored in theTest-Planmodule of HP QualityCenter
• Timely status update of current task status to Product Owner/Business Analyst
• Conduct daily/weekly scrum meets to check the task progress
• Partner with Product Owner/Business Analyst to define Acceptance Criteria and plan grooming sessions for the team
• Coordinate with development/test/implementation teams for demo at the end of each sprint
• Working with implementation/release management team to get the expected version of code deployed and made available for test teams
• Ensures all processes are documented, followed and efficient

Confidential, DALLAS, TX

SR QUALITY ASSURANCE LEAD

Responsibilities:

• BI - Data Warehouse
• Oracle Applications
• Web Applications
• Pricing
• Managing a team of 9 testers working at US and India
• Develop and maintain Test plan, Test data, Test condition and Test Case preparation, System test execution and defect reporting
• Validate KPI scorecards and dashboards
• Conduct weekly meeting with application teams to prioritize the completed code for testing
• Worked with Product owner to get the user stories (along with acceptance criteria) ready for QA team to verify and test
• Conduct bi-weekly sprint retrospective meetings
• Involved in System, Integration, performance and Functional testing
• Validate ETL loads executed with various tools (PL/SQL, Informatica, DataStage)
• Enhancing the QTP scripts by doingunit testingon the scripts before creating scenario based tests inTest-Lab moduleof Quality Center
• Creating thestandard libraryfor functions and sub-procedures in QTP
• Defect recording and tracking using HP Quality Center
• Provided user training and documentation
• Responsible for preparing weekly and monthly status reports
• Present QA best practices with senior management team

Confidential, AUSTIN, TX

ONSHORE QA LEAD

Responsibilities:

• Sales Analysis and Trending
• Pricing and Market share assessment
• Inventory Analysis
• Implant/Procedure Analysis
• Develop and maintain Test plan, Test data, Test condition and Test Case preparation and defect reporting
• Working with Business Analysts/Developers to understand/brainstorm the requirements
• Preparing test plan based on the business requirement for different modules
• Prepare test data for data validation for ETL loads from multiple sources to targets
• Verify and Validate the dashboards (KPI Scorecards)/reports developed for iPads and tablets
• Performed Regression, System, Integration, Functional Testing, and Database Testing & Random Testing for different modules
• Responsible for addressing client concerns and queries related to the project
• Interact with Client Marketing VP, Client Test Manager & Client Divisional Leads for program status
• Manage resource, staffing, billing, metrics reporting, status reporting, issues/concerns
• Coordinate with System Administrators for code/report migration from QA to PROD
• Conduct UAT with business team and obtaining sign-offs for Production migration
• Coordinating with offshore team (7 offshore resources) for various testing activities
• Status reporting to client and query resolution
• Maintaining testing materials and documents during UAT
• Post GO live support for 2 weeks along with DEV team

Confidential, ATLANTA, GA

SR QUALITY ANALYST

Responsibilities:

• Understand the business requirement by analyzing convoluted scripts in Unix and SQL
• Understanding the Functional requirements of the application
• Analysed the System Requirement Specifications and Developed Test Plans, Test Cases
• Writing test cases based on the system requirements of the application that uses various ETL loads
• Execute and validate the ETL mappings created for data loads
• Creating Test Cycles, performing Manual Testing, Defect/Bug Tracking
• Defect logging and coordination with development team to resolve defects
• Documentation - Prepared test cases document and software service specifications documents

Confidential - CINCINNATI, OH

QUALITY ANALYST

Responsibilities:

• Develop and maintain Test plan, Test data, Test condition and Test Case preparation, System test execution
• Requirement analysis and prepare test strategy
• Brainstorm/Discuss test strategy with development team
• Validate ASN (Adv Shipment Notification), AP (Accounts Payable) & Invoice details transferred via EDI
• Performed Regression, System, Integration, Functional Testing, Database Testing & Random Testing for different modules
• Defect logging and reporting in HP Quality Center/Test Director
• Execute and validate the ETL mappings created for data loads
• Worked with various stake holders to address defects and reports
• Conduct UAT with business and application stake holders
• Status Reporting on Daily/Weekly/Monthly basis to APL/Users
• Mentoring Junior/offshore Team members & guiding them

Confidential - CINCINNATI, OH

QUALITY ANALYST

Responsibilities:

• Meeting with APL (GE Application Leader)/IM leads every week to discuss the Production issues/tickets
• Ensuring system’s availability is 100%
• Analyzing & Providing permanent solutions
• Status Reporting on Daily/Weekly/Monthly basis to APL/Users
• Preparation of Test Scenarios, Test script, Test execution plan
• Creating Test Cycles, performing Manual Testing
• Documented and managed all the test cases
• Assisting in Physical Inventory reporting and Balancing
• Mentoring Junior/offshore Team members & supporting their tasks

Confidential - CINCINNATI, OH

TEST ENGINEER

Responsibilities:

• Understanding the Functional requirements of the application
• Preparation of Test Scenarios, Test script, Test execution plan
• Creating Test Cycles, performing Manual Testing
• Involved in peer reviews within the team
• Documented and managed all the test cases
• Sharing best practices with the team
• Meeting APL /other Onsite Coordinators every week to discuss about the project plan & execution

Confidential

SR ETL DEVELOPER

Responsibilities:

• Production Monitoring & Ensuring continuous Job Flow
• Fixing of Job aborts
• Analyzing & Providing Solution for Production Issues raised by Users (Solving Tickets) & Onsite coordinators
• Status Reporting on Daily/Weekly/Monthly basis to APL/Users
• Bug Fixing/Abend Solving
• Writing Special Codes (one time)
• Job Scheduling
• Meeting with APL (GE Application Leader)/Onsite Coordinators every week for the Production issues/tickets
• Year-end processing
• Contacting users to guide them in solving their problems
• Carrying out major ‘Critical to Business’ issues on day to day basis with Clients
• Mentoring Team members & supporting their tasks in the following core applications. i2 Demand Planner, i2 Demand Analyzer, i2 RDA
• Forecasting Datawarehouse
• Supporting other Onshore coordinators in terms of Requirements Gathering & Estimations for the upcoming Fixed Price Projects

Confidential

SR DEVELOPER

Responsibilities:

• Requirement Analysis
• Coding using PL/SQL with procedures, cursors
• Creating packages and encapsulate the similar function procedures
• Performed thorough developer testing and peer review
• Interacting with the OSC on various forums to clarify any queries regarding the functionality etc.
• Configure and backup the source code in MS Visual Source Safe
• Documenting the process flow along with the analysis, unit testing, peer review & release information