SUMMARY:

• Over all 15+ years of experience in Information and Technology industry and 8 years of experience in Oracle EBS Applications as Functional and Techno - Functional Consultant in Oracle Financials and Supply Chain modules.
• Expertise in Oracle Supply Chain Modules Order Management (OM), Shipping (WSH), Purchasing (PO), Inventory (INV), and Financial Modules General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets (FA), iExpense (OIE)
• Proficient in a wide variety of areas such as Gap Analysis, Module Setup, Business Analysis, Application Design, Conversion and Interface Design, System Administration, Documentation using AIM3.0, Full life cycle implementation going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT) and Production, User Training, go-live and post go-live Support in complex Multi-Org Environment.
• Experience in working on cross functional modules in the environment of Order-to-Cash (O2C), Procure-to-Pay (P2P) and supply chain business cycles
• Technical expertise in Implementation and Support of Oracle EBS using SQL, PL/SQL, Oracle Reports, BI/XML Publisher Reports, Oracle Form Personalization, Oracle Application Framework(OAF), Oracle Workflow, SQL Loader and Shell scripting
• Extensive experience in developing multiple RICEW(Reports, Interfaces, Conversions, Extensions, Workflow) components tied to SCM/FIN modules
• Good Experience in personalization and customization of OAF screens using JDeveloper
• Experience in customizing Oracle Workflows such as the PO approval process, AP Invoice approval to send user notifications based on the business requirement.
• Expertise on designing and implementing Oracle Alerts and Lookups
• Experience in Application module testing(end to end) in supply chain modules and troubleshooting various issues
• A motivated and resourceful professional with extensive experience in the setup, support and customization of the Oracle E-Business Suite. Offering strong functional and technical knowledge, coupled with an analytical and problem-solving aptitude to provide end-to-end custom solutions for business applications.
• Well versed in working with business to gather requirements. Strong programming, debugging and problem solving skills and ability to translate customer requirements into technical solutions
• Worked with oracle support to resolve seeded application issues .Created service requests SRs with oracle support and tracking them to closure.

TECHNICAL SKILLS:

Oracle Applications: R12 Purchasing (PO), Order Management (OM), Shipping (WSH), Inventory (INV), Field Service (FS), General Ledger (GL), Accounts Payable (AP), Cash Management (CE), Receivables (AR), Fixed Assets (FA), Field Service (CSF), Spares Management (CSP).

Other Components: Workflow/Workflow Builder, RICE Components, Alerts (ALR), Application Object Library (AOL/FND), Concurrent Manager (CM), Flexfields, OAF, New Module Implementations.

RDBMS: Oracle 9i/ 10g/11g

Development Tools: SQL*Plus, Toad, SQL Developer, SQL*Loader, Oracle Reports 6i/9i/10g, BI Publisher (XML Publisher), Oracle Workflow Builder 2.6 and Jdeveloper, Oracle JET, Oracle ADF

Application Servers: Oracle WebLogic Server

Languages: SQL & PL/SQL, UNIX Shell Scripting, C, Java

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Oracle EBS Sr. IT Consultant

Responsibilities:

• Performed functional setups and developed various technical components based on business requirements.
• Customized Item Part search functionality to support alternative parts and implemented the logic to select available parts and display ETA based on shipping networks and custom delays.
• Enhance the Automation Backorder process to source alternative parts, implement multi-hop and tie break logic to source parts with earliest ETA, shortest distance.
• Implemented compliance projects Restricted of Hazardous (RoHS) and intrastat reporting for European Union for Indirect countries.
• Extensively worked on Integration of B2B Request Shipping Order (3B12), Advance shipment Notices (3B2), Shipment receipt (4B2) and Distribute Inventory (4C1) messages.
• Created Inventory sync reports between EBS and third party systems to identify the discrepancies between two systems.
• Developed and modified various custom controllers in Oracle Application Framework (OAF) pages using Jdeveloper.
• Worked on Item Conversion to load items into Inventory by creating staging tables and performing validations through custom packages and finally loading them into Inventory base tables using APIs
• Worked on inventory item update Business event subscriptions to send email notifications to business users when item got updated.
• Developed Packing Slip reports using XML Publisher Report technology.
• Participated in UAT sessions with users for B2B Integration, Inventory and OM module testing
• Conducted Technical design document review, code reviews and Project handoff to production support team meetings.
• Performed production support and maintenance of SCM and Field service modules.
• Interaction with Users, Super users to understand the issues/enhancements and provided solutions
• Trained on Oracle cloud technologies Oracle ADF and Oracle JET

Environment: Oracle R12 (OE, INV, WSH, CSP, CSF modules), OAF, Oracle SQL developer, Windows 7 Professional

Confidential, Morrisville, NC

Oracle Financial Functional Analyst

Responsibilities:

• Prepared Module Design Documents (Integrated Business Requirement & Functional specification document), BR100 (setups requirement), Test plan and Test case documents.
• Experience in complete software product development life cycle (SDLC): System Analysis, Design, Development, Testing and Deployment
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
• Setup new Accounting calendar in GL module
• Extensively worked on iExpense production issues and trained users to understand the system better to avoid future user errors.
• Fixed and modified the existing setup of Prorate convention in FA to reduce lot of manual effort of journal entry for each period
• Used SLA to derive different revenue accounts for different transaction items
• Customized Company code segment value for Inventory item in cost management based on operating unit through SLA
• Design and implemented new interface for AR invoice transactions through Desktop Application Integrator
• Conducted functional review meetings with project team on new setups and functionalities before implementing in production
• Set up new instances and performed SIT (system integration testing) on them.
• Trained business users to understand the newly implemented functionalities for different scenarios.
• Developed end-user training protocols, raised SRs and worked with Oracle for final issue resolution.
• Provided FND logs and Diagnosis logs to Oracle support to help resolving application bugs

Environment: Oracle R12 (AP, AR, FA, iExpense, SLA, CE and GL modules), WebADI, Oracle SQL developer, Windows 7 Professional

Confidential, Cincinnati, OH

Oracle Support Analyst

Responsibilities:

• Set up new instances and performed SIT (system integration testing) on financial modules.
• Below Set-up tasks were executed in UAT and tested for all the new Operating Units:
• Defining Ledgers with Chart of Accounts, Accounting Calendar and Currency
• Creating value sets, flex fields and Cross-validation rules
• Operating Unit and Inventory Organization setups
• All the Purchasing Setups like Jobs, approval assignments, approval groups, defining approval hierarchies
• Defining financial, purchasing and receiving options and other setups
• Created Suppliers, Customers, Payment terms, Distribution set
• Inventory setups like Items, Category sets, Categories, Sub inventories, Stock Locators, Locations
• Attended the Functional and Technical specifications review meetings and raise the gap issues of system requirements.
• Interaction with end users for issue resolution
• Worked on Sales order transaction and shipment issues
• Trained the customer (Super users) and IT teams on the functionality of different scenarios.
• Played as a mentor role in troubleshooting and fix complex Productions issues in Inventory, O2C & P2P modules as and when required for the support team
• Month end closure process - As part of month end process, cleared all the transactions stuck in interfaces
• Helped business in closing Year/Quarter & Month end process.
• Performed production support and maintenance of Financial and Supply Chain Modules
• Worked with Oracle support to diagnose problems, identify bug fixes and implement the solution provided by oracle.

Environment: Oracle R12 (AP, AR, FA, CE, PO, OM and GL modules), Quality Central 10.0, Oracle, SQL developer, Web Services, Windows XP Professional

Confidential

Sr. Test Engineer

Responsibilities:

• Developed and implement manual and automated test management process using Silk Central Test Manager
• Created custom components and attributes in Silk Central to track the testing coverage and progress.
• Involved in creating QA standards and practice documents to maintain the consistency across the team for writing test cases and reporting defects.
• Attended Requirement review, Test case review and Defect Review meetings and raise the risks and/or concerns on product functionality
• Involved in creating Regression planning, monitoring the execution progress on daily basis and send the final regression report to the management at the end.
• Implemented and maintained the Traceability process for test cases vs requirements and failed test cases vs defects
• Created test automation frame work and developed automation test cases for Clinical Portal web based application using Silk Test
• Lead the offshore team and assign the work to the team members and send the work progress to the manager on daily/weekly basis
• Write custom test management and defect reports using complex SQL queries from Silk Central data base.
• Tested inbound and outbound application processes by upload and generating HL7 messages in QA environment.

Environment: Silk Test 10.0/Silk Central 9.0, SOA Test 5.5, Oracle 10g/SQL Server 2005, Toad8.6, Web Services, Perforce, HL7 V2/V3, Windows XP Professional

Confidential, Miamisburg, OH

Sr. QA Analyst

Responsibilities:

• Developed test requirements, test plans and documented manual test cases using QualityCenter.
• Identified the business process and separated test scripts into multiple actions, including setting several actions reusable and calling actions among scripts.
• Parameterized checkpoints using environment variables and regular expressions.
• Developed user-defined functions and created a library of functions from which functions could be called directly and efficiently
• Captured Text Output values during test run and exported them into excels for future use.
• Used descriptive programming to identify objects whose properties have dynamic values.
• A ssociated Test Scripts with Test Case s for Automated Tests in QualityCenter and played back Quick Test Pro scripts directly from the QualityCenter, i.e. Scheduling, Interacting and Invoking the Quick Test Pro Scripts.
• Created and developed SOA Tests using wsdls
• Verified request and responses of web services using SOA Test.
• Created regression control for SOA Test scripts for future regression test verification.
• Reported bugs through Quality Center and categorized bugs based on the severity and interfaced with developers to resolve them.

Environment: Mercury/HP Quality Center 9.2, Mercury/HP Quick Test Pro 9.2, SOA Test 5.5, Oracle 10g, Toad8.6,Galileo Web Services, Stylus Studio 6.1, Putty, Unix, Windows XP Professional

Confidential, Sharonville, OH

QA Analyst

Responsibilities:

• Wrote Test Cases for Testing various EDI maps and Accounts payable functions in mainframe.
• Extensively worked on CARS Workbench for creating test cases and Test Scripts.
• Used CARS Changes Point for bug tracing management.
• Performed Smoke testing, system testing and integration testing for MC9090 device to test the additional functionality of Price lookup and Carton lookup functionalities.
• Validate and verified EDI maps for 810,214 and 856 of inbound/outbound documents.
• Created and completed Testing section in SDLC Document for HST Project.
• Conducted meetings with team to review Test plans and test cases.
• Did web testing on Macysnet when name changes from Federated to Confidential .
• Conducted Automation regression testing using CARS.

Environment: Bug Tracker, CARS Workbench and Change Point, Mainframe, Oracle 9.2.0Visual Basic 6.0, Windows XP Professional

Confidential, Milford, OH

Oracle Support Analyst

Responsibilities:

• Wrote Test Cases for Testing various PL/SQL Programs and Oracle Forms.
• Extensively worked on Change Request / Enhancements for different clients.
• Modified and executed various shell scripts to run processes in Test environment
• Performed Functional, Unit, and Integration and Regression tests as per the specifications.
• Did Backend data analysis using SQL, TOAD for executing and monitoring SQL.
• Testing various API’s through XML using HTTP Client.
• Verified and analyzed the control files and log files in Unix
• Modified, compiled and executed oracle packages for testing purpose
• Wrote queries to analyze the data on staging tables, suspense tables, log tables and master tables
• Verified outbound interface files against the file layout in functional specification.
• Involved in End to end testing & UAT support.

Environment: Oracle 9.2.0, Developer 2000 (Forms/Reports) Windows XP Professional, Visual Source safe 6.0, TOAD 8.0, SQL Developer, UNIX, Test Track Pro 4.7, XML

Confidential, Hartford, CT

Support Analyst

Responsibilities:

• Worked on Account payable module of PeopleSoft.
• Extensively worked on data conversion project loading legacy system invoices and payments into AP module
• Analyzed complex and critical issues with project team.
• Tested defect fix in SIT and UAT environment before promoting into production.
• Participated in Feature Design review meetings and presented test case review, strategy and feature functionality.
• Executed test scripts for Functionality, Security and Regression Testing.
• Positive, Negative and Boundary Testing was performed for defect fixes
• Attended reviews and walkthroughs to better understand the requirement documents
• Documented all the events of defect fix till it goes to production

Environment: PeopleSoft AP module, Test Director, Oracle 9i, Toad 7.6, Sql, Windows NT.

Confidential, Lawrenceville, NJ

Support Analyst

Responsibilities:

• Worked as a production support Engineer
• Extensively supported Purchasing and Payable modules
• Prepared Test cases for new functionality of customizations
• Analyzed the production issues and log them as defect with complete analysis report.
• Extensively executed SQL queries on Oracle DB in order to view interface transactional data.
• Used Test Director for defect reporting and communicating between developers, product support and test team members.

Environment: Oracle ERP 11i, Windows XP, Internet Explorer 5.0,Toad, Test Director.