PROFESSIONAL SUMMARY:

• Around 9 years in years of IT experience in Requirement Analysis, Development, Implementation, Testing and Extensions of Oracle Applications R12, 11i in the Financial and Supply Chain modules.
• Functional and technical expertise in the modules of GL, AP, AR, OM, INV.
• Expertise in Procure to Pay and Order to Cash full life cycle implementation.
• Proficient in interfaces and conversions between modules through interface tables and APIs using SQL*loader, PL/SQL procedures to transfer data from Legacy systems to Oracle base tables.
• Expertise in SQL and PL/SQL programming, proficient in writing stored procedures, functions, packages and triggers.
• Expert in developing and customizing reports using Oracle Reports 10g/6i.
• Extensive experience on Testing on Oracle EBS
• Expert in Customizing the Oracle Application through Form Personalization and Custom.pll.
• Implementation and Customization of Oracle Applications 11i with good Technical Development skills in developing RICE (Reports, Interfaces, Conversions, and Extensions) components in the domain of Oracle Applications E - Business Suite.
• Good experience on Procure-to-Pay, Order-to-Cash
• Expertise on AIM Methodology, TCA and Multi org access control process.
• Good Knowledge on functional and technical knowledge of oracle SOA, BPEL Design and DOO (Distributed Order Orchestration), Shell Scripting.
• Excellent working knowledge in the area of Oracle 10g, Oracle 9i, Oracle 8i, Reports6i, and Developer/2000.
• Knowledge in Oracle Application Framework, Workflow Builder of Oracle Applications.
• Proven ability to conceptualize, design and implement solutions in Performance Tuning.
• Experience in reviewing the Functional Documents and preparing and modifying the Technical Design Document for the development work done like MD50, MD70
• Adaptability to any new business environment. Excellent team player and excellent communication and inter-personal skills.
• Good experience in migration tools - Kintana, Clearcase (Version Controlling).
• Good experience in support tools - HPQC, Remedy, and Bugzilla.
• Extensive IT experience and expertise knowledge in Oracle FINANCIALS&SCM implementations as a techno-functional analyst in AP, AR, GL, PO, OM, INV, BOM, WIP modules
• Skilled in building cross-functional teams/Customer relations, demonstrating exceptional communication skills, and making critical decisions during challenges
• Participated and Involved in several Oracle Financial implementations. Also provided support and solutions during go live critical times and post-production support maintenance phase to different clients.
• Highly knowledgeable and expertise in Oracle Financials &SCM modules setup/configurations.
• Responsible for creating document deliverables such as MD070 and so forth. Familiarity with AIM methodology and working experience with creating these documents
• Strong knowledge and experience with Oracle System Administration and Application Developer functionality such as registering Concurrent Programs, Executables, Form Functions, defining users, administer responsibilities, adding custom reports/processes to request groups and several other related tasks.
• Developed API’s and performed Data Conversions for Suppliers, Customers, Purchase Orders, Sales Orders etc from legacy to Oracle systems.
• Working Experience with Discoverer for modifying/creating views and deploying to users by associating them to responsibilities as well as launching these reports directly from applications.
• Experience in OBIEE, Confidential Tool and Product Development

TECHNICAL SKILLS:

Operating Systems: Linux(Red Hat 7.0,8.0,9.0, Advanced Server 4.0) Sun Solaris 8, Windows 95, 98, 2000 (Pro, Server, ADV Server), XP, 2003 (Standard & Enterprise), Unix

Programming Language: SQL, PL/SQL, XML, Java

Database: Oracle 8i & 9i& 10G

Oracle e: Business Suite 11i & R12 OM, INV, PO, WSH, GL, AP, AR, BOM, WIP, PN

ERP Database: Strong hands on experience in Applying Patches, Back Up, Recovery Manager, Managing the Services and Concurrent Manager, Performance Tuning etc.

Tools: OBIEE, SQL Loader, Toad, SQL Navigator, Data LoaderDiscoverer, Workflow, Developer 2000 (Forms &Reports), Reporting Workbench/Orbit

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr Oracle Apps Techno-Functional)/Architect

Environment: Oracle applications R12.1.3, OM, AR, PO, INV & Costing

Responsibilities:

• Schedule meetings with all the Business Owners/Stakeholders from various departments to understand the current Business process and provide Oracle suggested best solutions
• Assign the tasks/objects to the offshore Technical team and to work closely with the Functional teams to understand the setups
• Review the code and advise the team to make necessary changes
• Fine tune the queries which are taking long time, so the performance is improved
• Apply patches in the lower environments to support the Project, so the team does not have to wait for the Client DBA for testing the new process.
• I was working with PPC even before the BPR Project has started so I have a good interaction with all the Business leads pertaining to different departments which helped me a lot to plan the Project to deliver in a timely manner.
• As part of the Business Process Reengineering, the below objects have been changed to provide the Oracle best practice solutions instead of using the Custom functionality
• Implement Inventory
• Implement Costing
• Redesign Returns and Replacements Process
• Redesign the Order Orchestration Process
• Implement Inventory:
• PPC does not have physical Inventory and the Logical Inventory was never tracked between the External systems and Oracle EBS. This Project has helped them in many ways by Implementing the Inventory which has provided them an extra feature to track the Inventory between PPC and their Vendors.
• Setups: Defined 3 separate Inventory Organizations to track the Inventory Organizations
• Defined the accounting entries to hold the different types of transactions.
• Designed new process to load the Items# and assign them to the Child Orgs
• Assign the predefined templates to the New Created Items#
• Designed new custom reports to track the Inventory and for exceptional reporting
• Defined the Setups for FIFO Costing
• Define New Cost Groups
• Assign the templates to Items#
• Define Item Organization Hierarchy
• Designed new Drop Ship Process for Returns n Replacements which would address accounting related pain points
• Designed new interface to create Customer Invoice
• Designed new interface to create Revenue Recognition process

Confidential

Sr. Oracle/Architect

Responsibilities:

• Requirement gathering and solution designing for implementing the design of processing Sales Order from Oracle to SAP and final receiving of data from SAP to Oracle after shipment.
• Tested all the scenarios of booking the order in oracle SAP SOA
• Testing the ATO and Non-ATO items
• Testing of orders in different type of holds ( invoicing, shipping, credit check)
• Organized and managed Business user acceptance testing (UAT) and Business Solution Walk-Thru Demo's in coordination with Analysts
• Overlooked the progress of Manual and Automation testing using QTP
• Executed test cases, test scripts, maintained test results and test data, logged and tracked defects in HP Quality center.
• Prepared QA test plans & strategy documents
• Organized and managed Business user acceptance testing (UAT) and Business Solution Walk-Thru Demo's in coordination with Analysts
• Worked on designing and developing a solution for making specific segments of a DFF as read only.
• Developed the interface for cancelling the Sales Order in oracle with the integration to SAP.
• Worked on designing and developing a process for booking a Sales Order in bulk and trigger the information from Oracle to SAP.
• Worked on solution to send a sales order update after changing the ship to address in case of Partial shipment.
• Worked on the designing of Web services for integrating two ERPS (oracle and SAP).
• Worked on the design and development of lock/unlock interface which is used for locking a sales order in SAP before allowing the user to make any change in Oracle.
• Developed workflows in different modules like PO approval, AP Invoices.
• Worked on the process design and development for globally purging data from custom tables.
• Performed End to End testing while delivering Procure to pay cycle during UAT across the modules AP, PO.
• Analyzed the changes in financial custom reports and interfaces for upgrading the same to R12 XML reports such as check printing and Separate Remittance Advice report and sending the same as PDF attachment in email.
• Designed and developed a report on cancelled lines with PO details where such PO has receipts made against any of lines.
• Developed Report on cancelled lines with PO details where such PO has receipts made against any of the lines.
• Wrote control file using Unix Script to load Open AP Invoices into Temporary Table and PL/SQL stored procedure to validate and load into Interface Tables and run Payables Open Interface Import Concurrent Program.
• Worked on personalizing the Oracle Application through Form Personalization and Custom.pll.
• Worked on the designing and developing an approach for handling an issue of deadlocking while processing the response received from SAP in Oracle.
• Developed a Super User form which was used for defining the specific roles to a user with specific period of time.
• Developed a Configuration form for defining the custom configuration in the system.
• Worked with different teams (SOA, SAP) in resolving an issue of handling a sales order having large number of lines.
• Deploying the components in UAT and Production with the help of Clearcase and Kintana.
• Defining the business rules and alerts in the Oracle System.
• Worked on debugging production issues of booking a sales order and shipment.
• Defining concurrent programs, executable, forms, request set, values set.
• Worked on the enhancement of Postal Code changes for splitting the tax code in zip code and populate the tax code in PostalPlus4Code from EBS to SAP.
• Deployment of SOA composites.
• DOO server configuration for deploying the EFF in DOO composites- MDS Sync up, Export and Import of MDS.
• Worked on establishing the connectivity between EBS SOA DOO SOA SAP.

Environment: Oracle Applications 11.5.10 Financials (AP, AR), Purchasing Modules (PO), Supply Chain Modules (OM, INV), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports), Oracle Jdeveloper, SOA Workbench, DOO Workbench.

Confidential, SantaClara

Oracle Techno-Functional Consultant

Responsibilities:

• Worked with the end user and FA's for requirement gathering and solution designing.
• Designed interface for Journal data upload in oracle General Ledger.
• Worked on mapping of account code values for Varian (Agilent's subsidiary) and Agilent's Chart of Accounts for journal data interface.
• Developed customized report for Journal reconciliation and error report for data validation error.
• Prepared the MD070 for all customizations.
• Worked on debugging production issues of importing a Journal data.
• Defining concurrent programs, executable, forms, request set, values set.
• Worked on the design and approach to correct the customer addresses in production environment.
• Developed an interface to load the new customers in Oracle application.

Environment: Oracle Applications 11.5.10 Financials (GL, AR), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Confidential

Sr. Consultant/Architect

Reporting Tools: Oracle Discoverer, RWB

Responsibilities:

• Project to implement Reporting Workbench Tool which would replace Discoverer Tool for Reportingin Nordstrom. Reporting Workbench tool was developed by Polaris Associates, Inc which has morefeatures than Discoverer like Email Bursting, BI Publisher reporting, develop PL/SQL basedreports and many more.
• In the first phase of the project we are converting all the Discoverer reports to RWB reports using the Utility which is available in the Polaris tool and migrated almost 450 reports from the HR modules.
• 2nd phase is to migrate all the FIN reports and to achieve this we need to in corporate theOracle security in all the custom views which we create in-order to fetch the data for multiple Operating Units. currently there are 5 different versions of each report for each operating unit but the same can be achieved with One report in Reporting Workbench.

Confidential

Sr. Consultant/Architect

Environment: Oracle applications R12.1.3, Unix, Report Center

Responsibilities:

• Project to sunset the existing Mainframe jobs and the process to format the Oracle seeded outputs and develop the New Process using Shell scripts.
• Nordstrom uses Control-M to schedule the Oracle concurrent requests and after all the jobs are completed the seeded outputs are placed in a specific folder called a Landing zone in the Unix box where the Mainframe process access these files to modify the output in a specific format where the Report Center can access those modified output files and publish them to the Users.
• I have developedNew Shell scripts which is a replica of the existing process what Mainframe process does but with less maintenance and better performance. As of now Mainframe has at least 5 jobs for each Report but the new shell script is just One Script which takes care of all the existing process to replace the Control characters where the Report Center can understand and also sets the page breaks in order to set the breaks based on the Segments.
• Page breaks are very important in all the Transactional and Expense Journals (GL) where the Oracle Seeded Reports are submitted with all the Segments - Low to High, and based on the Segment values, my script should provide the Page Breaks which would help the Report Center to Publish the output to the Business Users.

Confidential

Sr. Consultant

Environment: Oracle applications R12.1.3, Oracle BI Discoverer 11g (11.1.1.6.0 )

Responsibilities:

• Developed 50+ Discoverer reports as per the Business Needs
• Prepared MD050 and MD070documents to support the new reports which were developed in Discoverer

Confidential, Atlanta, GA

Senior Oracle Functional Consultant/Team Lead 2

Responsibilities:

• Gathering the functional/process requirements from the business users, acted as the link between the business users and the technical team and also between QA and the Technical team. Excellent skills in understanding the requirements from business and using functional documents and client specified documents.
• Used Oracle Developer 2000 (oracle reports 6i/9i & Forms 6i) extensively to modify new changes for exiting applications.
• Developed reports to provide Vendor details, Purchase Order details and Invoice and Payment details for reconciliation purpose.
• Developed Daily, Weekly Progress charts to monitor the Project Progress.
• Involved in Assembly Testing for 2 releases to test the scenarios to identify any defects and enter in Test Director and PROD TEST fixes.
• Involved in Work Flow Diagrams Business (Internal & External), Consumer (Internal & External).
• Customized the PL/SQL script to automate pricing Setups without manual intervention.
• Analyzing the bugs reported by users, fixing and migrating code to production and documenting the changes made to original code.
• Extracted data from existing data source and performed ad - hoc queries by using SQL, PL/SQL.
• Performing in-depth quantitative analysis or data analysis.
• Performed numerous data pulling requests involving SQL scripts, UNIX, TOAD.
• Wrote stored procedures and packages using PL/SQL.
• Optimized SQL statements for better performance using TKPROF Utility and Explain PLAN Method.
• Analysis was demonstrated through entity relationship diagrams and data flow charts that I developed via Designer and Erwin design tools.
• Modified and enhanced database structure when required.
• Using Oracle Explain plan to optimize the queries.
• Writing technical documents using the functional specifications.
• Involved in Custom reports creation.
• Designed & developed various ad hoc reports for the finance (Oracle SQL, PL/SQL, and MS ACCESS).
• Developed the Test Scripts and Assembly and Product testing and uploading them into Test Director.
• Involved in the analysis, and did modifications for existing test plans and test cases.
• Developed test cases using Test director after analyzing the Specification document.
• Involved in Work Flow Diagrams Business (Internal & External), Consumer (Internal & External).
• Writing PL/SQL code using the technical and functional specifications.
• Creating oracle objects like tables, procedures and functions.

Environment: Oracle 8i/9i, Oracle Reports 6i/9i, Oracle Forms6i, SQL Loader, Toad.