Project Test Cases

YUVARAJAN RAMADASS

Mobile: - 920-***-****

E-mail id: - ***********@*****.***

PROFESSIONAL SUMMARY

Over all 7+ Years of experience in Information Technology, involved in Requirement gathering, Business Process Analysis, GAP Analysis, Solution Design, Functional setups, Functional Testing, Development, and Production Support of Oracle Application modules, Oracle PL SQL, XML Publisher Reports in Windows and Unix environment.

Experienced in the implementation, designing customizations and extensions in Oracle Financials, and Supply Chain Modules

Experienced in Data Conversion, Interfaces, Extensions, Customization and new development in Oracle Application including Oracle Payables, Cash Management, iExpense, Oracle Receivables, Fixed Assets, Oracle General Ledger, Purchasing, and Order Management.

Expertise in AOL, System Administration, XML Publisher/BI Publisher, Workflow, Alerts, and Trading Community Architecture (TCA).

Extensive experience in Oracle backend objects like Database Tables, Views, Triggers, Stored Procedures, Functions, and Packages using PL/SQL.

Extensive experience in EDI functional setups and XML Publisher Administrator.

Developed Interfaces in e-Commerce Gateway EDI 850 and 865 to interface AR invoices and Sales Orders.

Experienced in Interfacing with third party systems using ftp, sftp, MFT and TIBCO.

Experienced in managing the service requests (SR) and escalating with Oracle as needed for oracle standard resolution.

Flexible team player with good analytical and problem solving skills.

Working knowledge of SQL, PL/SQL, XML Templates, Shell Script, Forms Personalization and OAF Personalization. Working and Analytical Knowledge on Oracle Reports, Oracle Workflows, SOA and OSB.

EDUCATION: Bachelor of Engineering (ECE), Anna University, CHENNAI, India –2009

TECHNICAL SKILLS:

ERP : Oracle Applications R12/11i.

ERP Technical Modules : XML Publisher, AOL, Alerts, and SYSADMIN

ERP Functional Modules : AP, CM, iExpense, AR, FA, OM, PO, and GL.

Operating Systems : Windows XP/7/8

Languages : Shell Script, SQL, PL/SQL

Databases : Oracle 8i/9i/10g

Tools/Utilities : TOAD, Clearcase, PL/SQL Developer, Kintana, HP Quality Center, Doors, BMC, TFS, MS Office Suite, and BI Publisher

Projects Profile:

Project : Oracle PIM/Prescriber and Finance Migration

Client : CVS - Omnicare Cincinnati, OH

Role : Oracle Techno Functional Consultant

Duration : Jan-2016- till date

Environment : Oracle Apps R12 (12.2.3), PL/SQL, Shell Script, XML Publisher, Inventory, PIM, AP, CM, iExpense, FA and GL

Project description:

Omnicare Inc. has been acquired by CVS in Aug 2015. CVS decided to load financial data from Omnicare Financial systems into CVS Database and secure remediate all existing Omnicare application codes. The purpose of this project is to load financial data to CVS database and facilitate business users with reports for Auditing purposes. As part of security remediation PIM/Prescriber components in oracle application are security remediated.

Utilized plsql, sql loader, OAF personalization, unix shell script for accomplishing Financial Data migration project and Oracle PIM/Prescriber security remediation project.

Highlights:

Actively worked on Finance Migration project, where Finance application data is migrated to different database.

Developed SQL queries and views to extract reports on Invoices, Assets, and Payments from the new database.

Developed Interfaces to load Prescribers and Products from various third party systems into Oracle applications using sql loader.

Converted all ftp interactions with third party systems in sftp connections as part of security changes.

Extensively worked on the RICEW components in Inventory, and PIM modules.

Worked in security remediation project, in which security vulnerabilities were identified and resolved in Oracle PIM/Prescriber modules.

Intensively worked in OAF Personalization and changed PIM and Prescriber pages.

Documented the proof of concept, solution design and reviewed with Business Leads

Prepared Development Requirements Documents and technical design documents

Changed codes based on the technical design documents

Created test plans, Walk through, Integration approach and strategy document, test cases, scenarios. Worked with Testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests

Assisted in creating the End to end Scenarios and scripts for the CAT users

Involved in Production readiness including RRP, Roll-out Plan, IT/Business Certification support

Created and modified MD070 design document for the customization and extensions.

Project : Oracle Financials

Client : Omnicare Inc. Cincinnati, OH

Role : Oracle Techno Functional Consultant

Duration : Jan-2015- Dec-2015

Environment : Oracle Apps R12 (12.2.3), PL/SQL, Shell Script, XML Publisher, AP, CM, iExpense, FA and GL

Project description: Omnicare Inc. a healthcare company decided to implement Oracle Financials R12 and maintain all financial transaction. Omnicare was having Lawson system for its financial transaction and later implemented Oracle Financials. The purpose of this project is to implement Oracle Financials R12 and data conversion from Lawson systems.

Utilized plsql, sql loader, OAF personalization, unix shell script, SOA and OSB for developing Interfaces, Reports, Extensions, and Conversion components.

Highlights:

Analyze business requirements and propose technical solution in Oracle Financials.

Extensively worked on the RICEW components in AP, FA, GL and iExpense

Documented the proof of concept, solution design and reviewed with Business Leads

Prepared Development Requirements Documents and technical design documents

Changed codes based on the technical design documents

Create test plans, Walk through, Integration approach and strategy document, test cases, scenarios. Worked with Testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests

Assisted in creating the End to end Scenarios and scripts for the CAT users

Involved in Production readiness including RRP, Roll-out Plan, IT/Business Certification support

Developed data template based BI Publisher reports

Created and modified MD070 design document for the customization and extensions.

Project : MSI – EMB Zebra Separation Project

Client : Motorola Solutions Inc, Schaumburg, IL

Role : Oracle Techno Functional Consultant

Duration : 07/2014- 12/2014

Environment : Oracle Apps R12 (12.1.3), PL/SQL, Shell Script, PO, AP

Project description: Motorola Solutions Inc. sold part of its business to Zebra in June 2014. As part of the sale Motorola solutions agreed to separate the business data and implement Oracle Applications supply chain for Zebra. Implemented supply chain and financial systems for Zebra and converted data from Motorola solutions Inc.

Utilized plsql, sql loader, OAF personalization, Unix shell script, AOL Objects for developing Interfaces, Reports, Extensions, Conversion components and implemented Purchasing and Accounts Payables.

Highlights:

Functional analysis for Separating and deploying new Org structures, involving configuration for Purchasing Track

Analyze business requirements and segregate them into Use Cases. Created Use case diagrams, activity diagrams using Microsoft Visio, PowerPoint

Documented the proof of concept, Solution design and reviewed with Business Leads

Participated in data modeling, planning, designing, and implementation of the final system. Produced data mapping and data definition documentation

Prepared Development Requirements Documents and technical design documents

Developed plsql codes and shell script programs based on the technical design documents

Create test plans, Walk through, Integration approach and strategy document, test cases, scenarios. Worked with Testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests

Assisted in creating the End to end Scenarios and scripts for the CAT users

Involved in Production readiness including RRP, Roll-out Plan, IT/Business Certification support

Followed BMC Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment

Project : MSI – Finance Steady State Project

Client : Motorola Solutions Inc, Schaumburg, IL

Role : Oracle Techno Functional Consultant

Duration : 05/2013 – 04/2014

Environment : Oracle Apps R12 (12.1.3), PL/SQL, Shell Script, XML Publisher, AP, CM, iExpense, and AR

Project description: Motorola Solutions Inc. implemented Oracle Apps for its supply chain business and financial management in 2013. Motorola solutions Inc. is a global business company and implemented multi org and multicurrency system for the first time. The purpose of this project is to support business and make enhancements to the newly implemented oracle applications.

Utilized EDI concepts in Oracle application and developed EDI interfaces. Utilized plsql, sql loader, OAF personalization, UNIX shell script, AOL Objects for supporting existing and developing new Interfaces, Reports, Workflows and Extensions.

Highlights:

Functional and Technical analysis for enhancements in existing R12 system in Oracle Finance Modules.

Involved in design documentation and functional setups for AR EDI 810 and implemented in an Oracle R12 application.

Coordinated with GXS/FMW team to identify proper EDI mapping based on the business requirements for various MSI customers.

Involved in requirements gathering, design documentation and functional setups for AP Payments for various Operating Units.

Coordinated with GXS/FMW and Real time Bank IT team to identify proper fields required for payment files that needs to be sent to make payments to MSI suppliers.

Interfaced the Payment files and AR Invoice EDI files to third party systems using sftp connection.

Review the codes developed by developers and provide comments if any changes needed. Developed codes and Helped developers to complete development on time.

Assisted in creating the End to end Scenarios and scripts for the CAT users

Involved in Production readiness including RRP, Role-out Plan, IT/Business Certification support

Followed BMC Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment

Worked with oracle support team through Oracle SR’s to release patches and upgrades in R12.

Project : MSI – Finance Transformation Project

Client : Motorola Solutions Inc, Chennai, India

Role : Oracle Applications - Developer

Duration : 05/2011 – 04/2013

Environment : Oracle Apps R12 (12.1.3), PL/SQL, Shell Script, XML Publisher, AR, AP and iExpense

Project description: Motorola Solutions Inc. decided to upgrade its Oracle Financial Application from 11i to R12 in 2011. The purpose of this project is to implement oracle applications R12 and convert financial data from 11i systems to R12. As part of this project implemented Accounts Payables, Accounts Receivables, iExpenses, Fixed Assets, and General Ledger modules.

Utilized plsql, sql loader, OAF personalization, UNIX shell script, AOL Objects, XML Publisher, Oracle Reports for developing new Reports, Interfaces, Conversions, Extensions and Workflows.

Highlights:

Technical analysis for Implementing Finance Transformation project in Oracle R12.

Involved in design documentation and technical documentation for various Finance modules interfaces and extensions

Involved in Proof of Concepts and identified technical solutions for various business requirements

Involved in SQL/PLSQL, UNIX Shell Script coding to deliver RICEW components based on customer requirements in Accounts Payables, Accounts Receivables, Purchasing and Order Management.

Developed XML Publisher Reports for various customer facing reports

Involved in customising Oracle Invoice Printing and Statement Printing using XML Publisher

Created unit test documents, executed unit testing and documented test results.

Provided Knowledge Transfer to End Users and Support Team

Involved in Production readiness including, Role-out Plan, IT/Business Certification support

Followed BMC Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment

Project : MSI – OMAR System Integration Testing

Client : Motorola Solutions Inc, Chennai, India

Role : Oracle Applications – Functional Tester

Duration : 03/2010 – 04/2011

Environment : Oracle Apps R12 (12.0.1), PL/SQL, HP Quality Centre, OM, and AR

Project description: Motorola solutions have business all across the world and it has four main regions for its business. Out of four regions US is the biggest business region. In 2010, Motorola solutions planned to implement Oracle Applications R12 for US business region. As part of this project Motorola solutions implemented Order Management and Accounts Receivables modules.

Prepared test cases and maintained in HP Quality Center. Raised and reported defects in HP Quality Center. Prepared sql queries and tested reports, interfaces.

Highlights:

Interacted with clients and BSA’s to understand the custom requirements

Prepared test cases and scenarios based on custom requirements

Prepared Standalone and End to End test scenarios to test standard OM and AR functionalities

Executed test cases, test scenarios and reported the defects in HP Quality Centre

Organized war room meetings between implementation team and testing team and discussed issues identified and possible functional solutions

Project : Finance System Integration Testing

Client : Qualcomm Inc, Chennai, India

Role : Oracle Applications –Tester

Duration : 07/2009 – 03/2010

Environment : Oracle Apps 11i, PL/SQL, HP Quality Centre, OM, and AR

Project description: Qualcomm Inc. implemented Oracle Apps 11i for maintaining financial data in 2009. As part of this project Qualcomm implemented Financial modules Account Payables, iExpenses, Accounts Receivables and GL modules.

Prepared test cases and maintained in HP Quality Center. Raised and reported defects in HP Quality Center. Prepared sql queries and tested reports, interfaces.

Highlights:

Prepared test cases and scenarios based on custom requirements

Prepared Standalone and End to End test scenarios to test standard AP, iExpenses, AR and GL functionalities

Executed test cases, test scenarios and reported the defects in HP Quality Centre

Tested end to end scenarios for Procure to Pay functionalities

Tested end to end scenarios for Order to Cash functionalities.

Involved in Regression testing.

Contact this candidate