SUMMARY:

• More than 5 Years of IT experience in the area of Oracle Payables, Oracle Purchasing, Web Center, General Ledger, iExpense and Concur Expense Report/Data Analysis/QA Testing/ Batch Testing/Functional/ETL/DWH/BI - Reports Testing & Testing of Software systems in Data Warehouse/ Business Intelligence/ Client-Server/Oracle and Web-based environments in Windows.
• Extensively worked in entire QA Life Cycle, which includes developing and execution of the entire QA Process.
• Reviewed functional Requirement documents including BR100 and MD050 with the Business Analyst
• Reviewed functional Requirement documents including MD070 with the Development Team
• Experience of setup and configuration of I Expense module.
• Experienced on Project go-live and post-implementation support.
• Well experienced in testing all the Custom objects i.e. RICE objects along with the other systems
• Strong Knowledge of Concur Expense Report System.
• Strong knowledge of Software Development Life Cycle (SDLC), and QA Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensive experience in writing complex SQL Queries and PL/SQL scripts.
• Have tested several complex reports generated by Business Intelligence tools Business Objects BOXI, Micro Strategy, Cognos including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in test management using HP Quality Center.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Have experience in testing reconcile (initial) and delta (daily) ETL loads.
• Have good experience in Data Migration testing and Web Interface testing.
• Have good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.
• Extensively worked on Batch Scheduling and monitor ETL jobs.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHINICAL SKILLS:

Version control tools: SharePoint, Box

Packages: Oracle e-Business Suite (11i / R12).

Business Process Flows: Procure to Pay (P2P), Web Center

Oracle ERP Primary Skills: Accounts Receivable, Purchasing (PO), Accounts Payables (AP)

Requirement tools: User stories, Mingle, Version One, Lean kit

Query Tools: SQL Developer, SQL PLUS, Teradata, Squirrel SQL Client, TOAD

BI/Reporting tools: SAP Business Objects 14.1.4

ETL tools: Informatica Power Center 9.5.1, Data Stage

Programming Language: PL/SQL, C+

Scripting language: SQL Scripts, UNIX Shell Scripts

Operating system: Microsoft Windows Family, UNIX

MS office: MS Word, Excel, PowerPoint, One Note, MS Outlook

Other tools: Text Pad, Notepad, Notepad++, Greenshot

WORK EXPERIENCE:

Oracle EBS Consultant/ Quality Analyst

Confidential, Atlanta, GA

Responsibilities:

• Created Test cases from scratch by using Business Functional Requirement Specs including MD050 and BR 100
• Involved in writing Test Scenarios using Functional and Technical design documents and mapped the test scripts to the requirement traceability matrix
• Involved in SIT Planning and Scrum/Daily Stand up meetings
• Played team role in application set-ups, implementation, conversions, interface development, testing and end-user training.
• Extensively worked in Oracle application modules Procure to Pay, iExpenses, Payables and Web Center
• Creating Test data for Testing purpose as per requirements
• Involved in filing bugs and verifying fixes and solved them using Quality center
• Validated the data by using SQL extensively
• Worked in Concur Expense Report Implementation with Oracle
• Create test cases to Test Concur implementation
• Interacting with development team for bugs' closure.
• Reporting status of testing progress, issues to team lead on a daily basis.
• Conducted functional, integration, regression testing.
• Worked closely with the business users during BAU test phase

ETL Quality Engineer

Confidential, Atlanta, GA

Responsibilities:

• Analyze business requirements to create test cases, and verify bug fixes.
• Performed QA processes collaborating with the development team for ensuring high quality releases to the business.
• Involved in scrum meetings with product owners.
• Validated, updated and reported bugs statuses using Mingle and HP ALM
• Followed business requirements and technical specifications to create test strategies following lean Agile software development processes
• Interacting with development team for bugs' closure.
• Reporting status of testing progress, issues to team lead on a daily basis.
• Conducted functional, integration, regression testing.
• Analyzed, documented and maintained test results and test logs.
• Involved in Data Validation using SQL queries.
• Created Test scripts for data validation and data analysis
• Test case management, Test Execution and defect tracking was done by using HP ALM.
• Validated the Business Object test scenarios for functional and integration testing
• Validated the cardinality of joins and data integrity on the business objects universe.
• Extensively tested several Business Objects reports for data quality, fonts, headers, footers, and cosmetics.
• Validated cloud based data from backend to front end
• Written Test Cases for ETL to compare Source and Target database systems
• Interacted with design/development/DBA team to decide on the various dimensions and facts to test the application.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA's.
• Written several complex SQL queries for data verification and data quality checks.
• Used Informatica Workflow Manager to execute Informatica mappings and Workflow Monitor to monitor ETL execution and logs.
• Validated the data between source and target by using Informatica data validation option

ETL Quality Engineer/ Data Analyst

Confidential, Buffalo, NY

Responsibilities:

• Performed functional and automation tests
• Enforce industry best practices
• Designed, developed, and executed reusable and maintainable automated scripts; plans and executes functional and system level testing of products across all platforms to test various features
• Developed data migration plan
• Maintained existing data migration program with upgrades and enhancements.
• Performed data migration enforcement tasks.
• Conducted data structures and movement evaluations.
• Executed data migration in coordination with management and technical services personnel.
• Identify, analyze, establish and maintain accurate document relating to the defects
• Log all defects and perform re-testing when defects corrections are provided
• Develop functional specs based on business requirement
• Write test scripts in Teradata and as per needs
• Provide support in coordinating offshore testing activities
• Validate the report generated for the CCAR schedule which will be submitted to Federal Reserve General Ledger balance report checks
• Execute GAP analysis when necessary and provided astute remediation plans to follow up with the analysis.
• Review validation deliverables such as Validation Master Plan (VMP) system validation summary report

Quality Engineer

Confidential, Fort Lauderdale, FL

Responsibilities:

• Analyzed Business Requirements Document and Functional Specification document and analyzed the project needs.
• Performed data validation testing after the ETL
• Designed, Developed, Executed and Analyzed Test plan, test cases, test scripts for use in Integration, System, and Regression Testing.
• Used Soap UI to perform testing which includes functional testing, load testing and data driven testing.
• Reviewed business requirements and added requirements into the Quality Center, and wrote test cases and Functionality testing based on Requirements.
• Extensively used Quality Center as defect-tracking system to log, close and generate reports and tracked through to resolution.
• Performed system testing, Integration testing, and Regression testing.
• Performed Inbound and Outbound Data Validation.
• Validated the Micro Strategy reports for the data and the lay out.
• Used Informatica Workflow Manager to schedule and run Informatica mappings and Workflow Monitor to monitor ETL execution and logs.
• Involved in preparation of test data to test the functionality of the sources.
• Used SQL queries to extract data from the target tables to prove the data mapping.
• Involved in understanding of the Specifications for Data Warehouse ETL Process and interacted with the designers and the end users for informational requirements.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager

IMPACT Retail Service Merchandiser

Confidential, Baltimore, MD

Responsibilities:

• Deliver Sales Fundamentals (Distribution, Shelving, and Merchandising) goals in assigned territory
• Coordinate and maintain all merchandising events in assigned territory and follow Company policy in Execution of work
• Develop and execute personal Performance Agreement
• Perform special projects, communicating customer needs, objectives as assigned by Unit or Sales Manager
• Maintain full distribution and display of products in assigned accounts
• Rotate stock, clean and stock display and price merchandise as appropriate
• Perform such duties as checking date codes, ensuring adherence to approved plan-o-gram
• Report observations to Unit manager regarding outdated products, unbalanced stock, out-of-stock situations, and point of purchase requirements