SUMMARY:

• In 13 years of expertise in Software Quality Assurance testing & Support -
• Eight plus years of ETL testing using ODI, Informatica, Talend studio
• Four plus years of hands-on automation testing with HP UFT, Selenium (Python)
• Three plus years of Oracle Financials(EBS) testing
• Six years of Web Services(SOA)/API testing using Postman, SOA Console, JMeter and SOAP UI
• Five plus years of testing expertise in AS/400 applications
• Excellent database skills in Oracle 12i, SQL, DB2/400, DB Visualizer, TOAD
• Tested SCDs (Slowly Changing Dimension) and performed Drill down and Drill Through approaches
• Tested Active & Passive transformations, and Connected & Un-Connected transformations
• Perform Data Profiling, Assessment, and Data Cleansing to meet data migration goals
• Validate source/staging/target tables, data reconciliations and various ETL transformations
• Oracle Financials- Reports, Interfaces, Conversion, Customizations and Workflow (RICEW)
• P2P (Procure to Pay), O2C(Order to Cash) flow in Oracle Financials
• Oracle Order Management(OM), Account Payables(AP), Account Receivables(AR), Fixed Assets(FA), General Ledger(GL)
• Exposure to testing web services with IBM MQs, JMS, BPEL Queues, Tokens, Subscriptions and Publisher
• Emphasis in Point of Sale (POS) testing, reporting and application support
• JDA trained and Solid understanding of JDA Point of Sale modules: Fulfillment, Master Planning
• Experience in Defect management and Continuous Integration(CI) tools - JIRA, HP ALM, TFS, TestRail, Rally Tool, TTP, Foot Prints, Confluence, TeamCity
• Agile/Scrum/Kanban experience in Development, Testing and Implementation
• Worked in Keyword-driven, Data-driven and Hybrid test automation frameworks
• Familiar with Test driven and Behavior driven agile development
• Experience in Health care EDIs, Claim Engines, Claims Adjudication, EoBs, RAs, and Reports
• Exposure on Corporate Actions, Stock-Split, Stocks/Fund Merger, Stock Acquisitions, Allocations, Rebalances and Restrictions
• Prepared test plans, test strategy, Requirements Traceability, Trend reports
• Performed Smoke/Regression Testing, supported UAT Testing, Performance/Load testing, Penetration testing
• Experience as level-I/level-II production support analyst
• Worked in onsite-offshore model

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.0/10.0, QTP 9.0/10.0, HP ALM, HP UFT 12.02, RIDE, Selenium 3.x, JIRA, TestRail, Rally Test Case Management

Databases: Oracle 8i/9i/10g/11g, DB2/400, DB2 7.0, SQL Server 2005/2008, MS Access

Utility Tools: Oracle SQL Developer, SQL Plus, DB Visualizer 6.x, TOAD, SQL Assistant, Oracle EBS (Oracle Financials), API Wizard, Point of Sale (POS), ROBOT/400, Scheduler/400, SQL/400, Turnover, Hawkeye, DBU 60/70, Citrix, SQL Server Management Studio 2008, Visio, Visual Studio, TFS, SVN, GITHub, Teamcity, FileZilla, WINScp, PUTTY, WS-FTP, Alliance FTP Manager

ETL Tools: Informatica 8.1, Talend Studio, ODI

Web services: SoapUI, Apache JMeter, SOA Console, Postman

Operation Systems: Windows XP/2000/2007, UNIX, AS/400, OS/400

Programming: Python 2.7/3.0, VB Script, PL/SQL, RPGLE, RPG ILE, CL/400

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Quality Assurance Analyst

Responsibilities:

• Agile Development, Testing, Defect reporting and Release management using JIRA
• Identified smoke, regression and functional scenarios for manual & test automation
• Tested P2P (Procure to Pay) and O2C (Order to Cash) flows
• Account Payables, Account Receivables, Fixed Assets, General Ledger and Cash Management
• Automated Oracle Forms using HP UFT 12.02
• Test Asset Groups, Asset Numbers during Oracle eAM, FA, Inventory and Install Base Sync
• Test Reports, Interfaces, Conversion, Customization and Workflow (RICEW) in EBS
• Data Profiling, Data Cleansing and ETL testing for all Conversions involved in implementation
• Validate & deploy SQL packages using SVN
• Schedule and monitor ETL jobs using ODI
• Testing various SCD (Slowly Changing Dimension) types, Surrogate keys
• Develop & execute complex SQL queries during testing
• Participate and Test Data Profiling, Data Cleansing, run ETLs for data migration
• Validate Master and Transactional data for Initial load, Incremental load & Delta loads in ETL processes
• Run concurrent jobs and validate reports
• Involved in EBS-MDM(EBX) Integration testing
• Uploaded invoice batches, asset groups/asset numbers, Pos using API Wizard
• Test Quality/Collection plans, EDI Mappings, Licensing & Titling, Tariff Plan, Remac & Refurb history
• Test Suppliers, Contacts, Quality, Assets, Locations, Invoice Workbench, Inventory and Sub-Inventory transfers
• Test User Profiles, User Roles & Responsibilities, Test AR Lockbox, Accounting entries and DFFs (Descriptive Flex Fields)
• Used Postman/JMeter to perform Web service and Mobile API testing for ROADSTAR mobile app
• Worked on web services testing and familiar with GET, PUT, POST, DELETE methods, Tokens, Authentications, end point URLs
• Worked on testing web services with BPEL Queues and JMS
• Assist users for UAT/Pre-Go-Live/Post-Go-Live support

Environment: Oracle EBS (Oracle Financials), Oracle eAM, Oracle SQL Developer, SQL Plus, PL/SQL, Oracle Data Integrator (ODI), API Wizard, Oracle SQL Navigator, HP UFT 12.02, HP ALM, JIRA, UNIX, SVN, FileZilla, Postman, JMS, JDeveloper, JMeter, Soap UI

Confidential, NJ

QA Analyst & Support

Responsibilities:

• Design, develop, test and implement AS400 enhancements
• Identify smoke and functional scenarios, and automate using RIDE/Python 2.7/Selenium
• Developed and executed test cases for various ETL transformations
• Worked in Agile methodology for all Sprint deliverables
• Programmatic execution of - Corporate Actions, Stock-Split, Stocks/Fund Merger, Stock Acquisitions, Allocations, Rebalances and Restrictions
• Analyze the issues and identify bottle necks
• Used Alliance FTP Manager/WINSCP for data exchange between Host and home systems
• Used TFS for Agile development and defect reporting
• Support for Month end, Quarter end and year end Jobs and billing jobs
• Prepare Traceability Matrices, Metrics and send Trend reports to management
• Worked as level 1/ level 2 production support

Environment: AS400, RPGLE, CL400, DB2/400, Talend Studio, PUTTY, WS-FTP, Alliance FTP Manager, DB Visualizer 6.x, Foot Prints, File Zilla, Python, QTP, Team City, Robot framework/RIDE, Selenium, Visual Studio, TFS, SQL Server Management Studio 2008, SQL Server 2008, C#, Confluence, JMeter, GITHub

Confidential, MN

ETL Test Lead

Responsibilities:

• Understood and interpreted POS requirements created by external vendors and transformed them in to Use cases and Test cases
• Responsible for reviewing Functional specs, Technical specs, test artifacts
• Prepared test cases using ETL data dictionary/mapping documents
• Reviewed and validated Mappings, Mapplets, Work flows, Tasks, Sessions with developers
• Validated meta data, constraints, data integrity, duplicates and reconciliation counts
• Tested various Active & Passive transformations, and Connected & Un-Connected transformations
• Testing various systems involving SCD (Slowly Changing Dimension) types, Surrogate keys
• Ability to develop & execute complex SQL queries during testing
• Validate between source to target tables in staging areas, Data Marts, Data Mining, ODS, EDW
• Execute & monitor scheduled ETL jobs using Informatica 8.6
• Participate in Data Profiling, Data Cleansing, Extraction, Transformation and Loading for data migration
• Validated Master and Transactional data for Initial load, Incremental load & Delta loads in ETL processes
• Involved in Fact and Dimensional analysis with Data Architectural team for design of DataMart/EDW
• Exposure in SQL performance tuning and familiar to Cache mechanism
• Exported test cases from MS Excel to HP Quality Center
• Report analysis using Drill down, Drill Through & Data Centric approaches
• Executed test cases, created & tracked defects in HP ALM/QC
• Point of Sale (POS) and Mobile POS API Web-services testing with SOA Console, SOAP UI
• JDA trained and Solid understanding of JDA Point of Sale modules: Fulfillment, Master Planning
• Developed and executed test cases for service layers, APIs for both Web and Mobile applications
• Validate POS Transactions, Order Fulfillment, Inventory Reports, Sale-Trend reports
• Supported test activities associated with Product Point of Sales
• Identify, design & execute Smoke/Regression Test suite, support User Acceptance Testing(UAT)
• Lead multiple applications, worked in onsite and offshore model
• Immense involvement in Agile development and sprint ceremonies
• Prepare traceability matrix, log defects, support releases and Go-Live activities

Environment: Informatica 8.6, TOAD, DB2, HP Quality Center 10.0, HP QTP, Business Objects, SQL Server 2008, Java/J2EE, Agile Methodology, UNIX, UDB, Point of Sale (POS), Customer MDM, Soap UI, SOA Console

Confidential, VT

Sr. Software Engineer/Sr. Quality Assurance Analyst

Responsibilities:

• Effort Estimation and Planning for work requests
• Design automation framework using QTP, execute and test Claims module
• Coding enhancements in RPG, RPGLE, ILE RPG, CLP and perform Unit testing
• Responsible for enhancement and Development, Primary POC for FEP claims.
• Worked on embedded SQLs, triggers, Store Procedures and Cursors in SQLRPGLE programming
• Sound knowledge on MQ Console, Queue Managers, Channels, Queues, Tokens and JMS messaging
• Consumed IBM MQ messages, Data Areas, Data Queues and tested web services
• Work with third party vendors for project specific activities
• Preparation of Unit Test Plans, Test cases, Code peer reviews and documenting test results
• Perform testing on Blue Exchange web pages and replicate customer issues
• Power MHS claims validation and adjudication
• Sending Release Notes (RN), Software Migration Report (SMR)
• Validate EDI 837, 834, BX 277, 278 transactions
• Validating SSRS reports - Canned and Custom
• Analyze the issues and identify bottle necks

Environment: AS/400, RPG/400, CL/400, DB2/400, RPGLE, TURNOVER, HAWKEYE, XML, HP Quality Center, QTP, Load Runner, EXTOL EDI Integrator, IBM MQ Series, Data Area, Data Queue, JAVA/J2EE, JAVA SCRIPT, CITRIX, Power MHS 7.x, Business Objects, SSRS, SQL Server Management Studio, SQL Server 2005/2008, C#, MS Visual Studio, HP Results Viewer

Confidential, NY

Software Engineer/Tester

Responsibilities:

• Analyzed, fixed and tested change requests and bug fixes in RPGLE, CL/400
• Installed PTFs and configurations
• Performed impact analysis using HAWKEYE and prepared documentation
• Responsible for unit and system testing
• Responsible for Black Box and White box testing
• Track and report defects in MS ACCESS
• Send daily status reports

Environment: AS/400, RPG/400, CL/400, DB2/400, RPGLE, FTP CMD, SCHEDULER/400, HAWKEYE, TURNOVER, JAVA/J2EE, MS-Excel, SQL SERVER 2000/2005, Crystal Reports, Manual Testing, MS ACCESS