SUMMARY

• Over 10+ years of strong experience in the IT Industry on Oracle Development Tools Technology, Oracle E - Business Suite (Oracle Applications) and RICEW (Reports, Interfaces, Conversions, Extensions & Workflow) components ranging the different versions of oracle applications from version 10.7 to R12.1.3.
• Experienced Oracle E-Business Suite Professional wif focus on: Sell Side- Quote to Cash, Order to Cash and Supply Chain and Distribution - Procure to Pay and Self-Service Applications.
• Provided 24/7 Production support in modules include GL, AP, AR, PO, OM, INV, FA and CE.
• Expertise in design, development and support of workflow, interfaces, conversions, extensions and reports in the Financials and have a good exposure in Manufacturing and Distribution modules in the Oracle Applications R12 environment
• Experienced in configuration, gathering business requirements, conduct meetings & workshops to capture user's requirements.
• Experienced in working wif super users and end-users for training, support during go-live activities and post production support.
• Strong experience in application configuration, gathering business requirements, write functional documents (MD050), (BR030), (BP080), technical documents (MD070), (BR100) and provide recommendations to Business.
• Good knowledge in documenting business requirements, Data design and process re-engineering to fit wif the Oracle system Prototype new business processes.
• Strong experience in designing functional documents for extensions, conversions, requirements and configuration documents.
• Ability to understand business goals and implement best practices to improve the efficiency and productivity.
• Experienced in conducting design sessions to evolve system specifications and test plans wif the ability to handle training sessions and documentation using AIM Methodology.
• Strong experience in handling the development teams by collaborating at each and every stage of development process and halp translating business requirements.
• Proficient in handling Service Requests and Enhancement requests wif Oracle.
• TEMPEffective communication & experience in various projects using MS Office and MS Visio.
• Expertise in designing/authoring user training documents and providing end user training after the acceptance of the application.
• Experienced in leading small teams of users and super users.
• Technically proficient in Implementation, Interfacing and Data Conversions.
• Experienced in PL/SQL, forms and reports, data migration, customization.
• Extensively worked in Oracle Front-end programming and Back-end development using tools like SQL*Loader, PL/SQL, SQL*Plus, Oracle Discoverer 4i/10g, Reports 6i/10g, Oracle Workflow and XML Publisher.
• Expert in Oracle Applications Personalization’s, Framework Customizations, XML Publisher, XML Gateway.
• Strong working knowledge of development tools such as PL/SQL, Oracle Developer (Forms 6i/9i and Reports 6i/9i), Workflow Builder, XML Publisher, Java and JSP, JDeveloper, and Oracle ADF in Oracle 12 environment.
• Experience includes coding Interface Programs using SQL * Loader and PL/SQL procedures to load data into the interface tables from legacy systems.
• Good understanding of all phases of SDLC by working extensively in each phase.

TECHNICAL SKILLS

Oracle Applications (ERP): Versions: R12 - R12.1.2, R12.1.3, R12.2 ; 11i - 11.5.10, 11.5.10.2

Modules: General Ledger, Accounts Payable, Inventory Management, Order Management, Advanced Pricing, Shipping Execution, Purchasing, Sourcing, Oracle Procurement Contracts, Oracle Alerts, Oracle Quoting, Oracle Service Contracts and SYSADMIN

Self Service Applications: iProcurement, iSupplier and iExpense

Languages: SQL, PL/SQL, UNIX Scripts, HTML, XML,C, C++

Oracle SQL Tools: Toad, Oracle SQL Developer, SQL*Plus, SQL*Loader, Reports 10g/6i/2.5, Forms 10g/6i/4.5, XML Publisher.

Document Control & Management Tools: IBM Clear Case, IBM Clear Quest, HP Project and Portfolio Management (PPM), Microsoft Share Point, CVS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2000 and MS Access

Microsoft Packages: MS Office, MS Excel, MS Visio.

Operating Systems: Windows 7/XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Provided 24x7 production support for all the financial modules wif primary focus on Procurement, Accounts Payable and General Ledger.
• Working daily to resolve the issues in Oracle Purchasing, Accounts Payable and General Ledger modules by closely following up wif the business and raising SR’s wif Oracle Support.
• Identifying the missing setups and configurations and resolve issues in Purchasing and Financials modules.
• Participated in the implementation of EBS application upgrade from 12.0.6 to 12.1.3 and support handoff by the development teams.
• Guided users in validating the test scenarios as part of this upgrade and received the UAT sign off.
• Interact wif the business users through regular meetings and provided updates on all open issues.
• Performed root cause analysis of repeated issues and its rectification.
• Worked on IPM imaging tool to store and retrieve the invoice images.
• As part of recent PCI compliance change worked on resolving more than 300 Severity 2 tickets due to network segmentation.
• Resolved the challenges and complications faced by end users due to network segmentation as CORP and TRANS
• Invoice approvals and viewing the invoice images has become the major challenge which we have accomplished wif the halp of security teams.
• Extensively worked on tools such as WINSCP, PUTTY, PPM and CA WA workstation which holds all oracle jobs that are scheduled as part of business needs.
• Helped business in running the concurrent jobs manually due to non-availability of ESP job scheduler.
• Worked on fixing the payroll GL files to load in to GL by converting the files from DOS format to UNIX.
• Worked on resolving the issues that are related to IPM tool access issues and invoice scanning and upload issues.
• Providing business the ad-hoc reports on need basis from the production. Eg: Settlement Report, HR Locations details, User Responsibilities, active supplier contracts extract etc.
• Monitoring the monthly EBS off releases that are part of implementing the enhancements and patches by production support team in different modules.
• Working on ESP Job scheduler to identify the failed and overdue oracle jobs and taking necessary steps to fix them.
• Attending daily cab approval meetings for approval of changes that need to go into production as part of enhancements and or migrating patches.
• Working wif business users, developers and Oracle support to resolve Oracle system issues.
• Working wif oracle support team to resolve the issues that are related to bugs in the system by applying the patches suggested.
• Perform the patch analysis and thorough regression testing in dev instances before registering the patch for release.
• Working closely wif transmission team to check and confirm critical payment file transfers and other files transfers to business.
• Helped business in running the concurrent jobs manually due to non-availability of ESP job scheduler.

Environment: UNIX, Windows, Oracle Applications 12.0.6, 12.1.3 (GL, AP, AR, FA, CE, iProcurement, Purchasing, Sourcing, Contracts), Oracle 11g, SQL, PL/SQL, WEB ADI, CVS, Share point, HP PPM.

Confidential, Pittsburgh, PA

Senior Oracle Applications Functional Analyst

Responsibilities:

• Worked on the global ERP releases across US Steel facilities at Pittsburgh, Mon-Valley, Gary, Houston, Granite City and Great Lakes.
• Worked as a Liaison between the ERP Team, and other PTP (Procure to Pay) and OTC (Order to Cash) business units to support the data conversions for the Team.
• Conducted business process review workshops wif the participation of key business contacts and ERP team members.
• Identified and developed functional design specifications for Report, Interface, Conversion and Extension (RICE) work.
• Defined data conversion requirements of Procurement, Order Management, Inventory and Accounts Payable modules.
• Participated in the testing process for deployments including definition of test scenarios, execution of test scenarios, summarizing results, and taking corrective action as required
• Participated in validation of data conversions during deployments
• Participated in the post production support of data conversion deployments
• Design and develop conversion Functional Design documents for Invoice, Payments, Suppliers, Employee Suppliers, Expense Reports, Procurement Card(P-Card), Suppliers Bank and Bank Branches for AP module.
• Conduct meetings wif Legacy system (passport) users and Oracle Process leads towards Functional document review and approvals.
• Working wif the Business people and the development teams to design and implement system modifications and document their requirements.
• Performing Data Validations on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions.
• Involved in the Data mapping, conversion and loading of the data from the external database system (Passport) to Oracle R12 system
• Worked wif development teams (Data Team)in resolution of defects logged in HP Quality Center
• Conducted CRP/UAT sessions wif the users to validate the objects developed and promote the same to Production.
• Worked at Granite City Works plant site for the go-live activities and post production support. Helping the users at the central receiving perform first step and second step of receiving of different types of materials (Indirect, Direct, Repairs, Punch Outs, Service Receipt).
• Participated in the super user training at Houston facility. Heavily involved in inventory and advanced procurement modules (iProcurement, iSupplier, Purchasing, Sourcing) training and testing.
• Involved in conversions of PO’s and Vendor details from external systems.
• Also worked at the hot rolling side line to halp users perform picks and deliver the material and stock them at the right locators. Also halping the users to create Re-Buildable work orders (RBWO’s) for repairs.
• Designing Functional Design Documents AP356 for Financial modules (AP, INV, OM and PO).
• Performed setup steps, defined various Key flex fields, Descriptive flex fields.
• Created various purchasing, UOM, payment, organization lookups, Value sets, user defined tables.
• Working wif business customers, developers and Oracle support to research document and resolve Oracle system issues.
• Performed Data Validation on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions.
• Responsible for implementation and customization of INV, AP, OM and Purchasing.
• Comparing the loaded data wif the legacy data using TOAD to validate data.

Environment: UNIX, Windows, Oracle Applications 11i, 12.0.6, 12.1.3 (PO, OM, Shipping Execution, Advanced Pricing, Service Contracts, iProcurement, Sourcing, Contracts, and Inventory), Oracle 11g, SQL, PL/SQL, WEB ADI, CVS, Share point, HP PPM, Clear Case and Clear Quest.

Confidential, San Antonio, Texas

Oracle Applications Functional Analyst

Responsibilities:

• Design and development of Custom BI Publisher and RDF Reports in Purchasing and in Account Payables modules.
• Developed and customized Forms and Reports, created flex fields, concurrent manager, cross validations, value sets and task flows.
• Built Conversion Programs in PO and AP, developed and customized Reports in AR and AP.
• Provided production support and functionality enhancements to improve GL and OM efficiencies.
• Analyzed the business requirements to develop programs for OM and AR.
• Defined various requirement document (RD020), Configuration document (BR100), System administration, Functional specs (MD050).
• Performed setup steps, defined various Key flex fields, Descriptive flex fields.
• Created various lookups, Value sets, user defined tables.
• Involved in conversions of PO’s and Vendor details from external systems.
• Converted standard AR customer invoice report and print statement reports into xml templates using BI publisher
• Developed (code) required interface between legacy systems and Oracle Apps 11.5.10.2 and 12.0.4.
• Development of GL interfaces to load Journals and balances to Oracle from Legacy system.
• Development and maintenance of Oracle custom code and interfaces to Oracle Forms-based applications in accordance wif business requirement in Procurement-to-Pay model and Order-to-cash models.
• Design and development of PO and Receipt interfaces from Legacy system to Oracle.
• Performed database Performance Tuning by implementing parallel execution, materialized views wif query rewriting, creating appropriate indexes, rebuilding indexes and also using the Explain Plan and SQL Tracing.
• Design and development of Form personalization’s and customizations.
• Developed several PL/SQL packages, procedures, and functions, triggered from UI events or database triggers, to implement complex business logic
• Extensively worked on customization of modules using Forms 6i, Reports 6i.
• Developed PL/SQL packages for Items conversion in Inventory Module and developed several other reports in Inventory and AR.
• Implemented debugging for PL/SQL procedures using FND LOG.string API.
• Developed custom Purchase Order Report, Pack Slip reports using XML Publisher.
• Extensively worked wif concurrent request scheduling automation using FND SUBMIT, FND REQUEST and FND SET.
• Developed Custom Messages and called custom messages from forms using FND MESSAGE
• Transferred Custom Concurrent programs, executables, and workflow definitions using FND API's and FNDLOAD and WFLOAD.
• Used Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• Developed Conversion Programs to Load AP Invoices to AP.
• Optimized the performance using PL/SQL by restructuring the extraction and summarization routines.
• Worked wif business teams to analyze system and process requirements.
• Translating and design of functional requirements into technical designs wifin the Oracle system. Documenting all technical designs and actual development product (code) according to the company's IT documentation standards.
• Developed UNIX shell scripts for file transmission and to automate the FTP process for B2B transactions.
• Extensively Used DBMS, UTL packages and collections to develop PL/SQL code.
• Participated in code management process, including use of source-code control utilities and facilitation of migration of code across multiple Oracle instances.
• Developed interfaces for Supplier conversion to Oracle AP.
• Design and development of credit card transactions and credit card data.
• Provided end user training and reconciliation activities for the interfaces and interface Reports.
• Extensively used FND GLOBAL, FND CLIENT INFO, MO GLOBAL, FND FILE and FND PROFILE for initializing and calling custom values through profiles.
• Extensively worked wif Multi-Org, MRC, MLS, MOAC models wif 11i and R12.
• Developed Test Scripts, Training Documentation, MD, CV documents using AIM, Oracle Tutor.
• Involved in User acceptance testing and other levels of testing, resolving the defects and in cut over activities.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Implemented several custom logic using forms personalization and AK Developer.

Environment: UNIX, Windows, Oracle Applications 11.5.10.2 12.0.4 (GL, AP, INV, iExpense, PO, Order Management), Oracle 10g, SQL, PL/SQL, HTML Forms 6i,9i Reports 6i,9i Track Record, PVCS.

Confidential, Hagerstown, Maryland

Oracle Applications Techno-Functional Analyst

Responsibilities:

• Designed and Developed Concurrent Programs using Oracle API’s.
• Worked extensively wif customizations in Order to Cash and Procure to Pay life cycles.
• Involved in Oracle AP Invoice interface from legacy system.
• Customized Reports Open order report, Customer Detail listing report, Item definition Summary Report, Item detail listing report.
• Involved in data preparation, preparation of setup documents and in White Box Testing and Black box Testing.
• Created custom built forms wif Oracle applications and in using custom.pll and template.fmb
• Extensively worked wif CUSTOM.pll and event based triggers in forms.
• Converted oracle reports to BI Publisher reports using rwconverter and data template generator
• Expertise in Oracle Applications Framework Customizations and Workflow Customizations which includes COGS customization and PO Approval workflow.
• Developed custom reports using reports 6i and 9i and used SRW.USER EXIT SRWINIT, SRWEXIT, SRW.MESSAGE triggers for setting org units and setting custom messages in reports.
• Extensively used data templates wif XML publisher to develop custom reports.
• Used XML gateway for data conversions, created data mappings, elements and loaded them into database using Loadmap java API’s.
• Involved in implementing AR, GL, AP, FA, PO, OM modules including writing interface programs according to user and business requirements and developing several reports using oracle reports 6i, 9i according to the functional specifications provided.
• Extensively worked wif sysadmin transaction monitor for XML message monitoring tool, XML gateway transaction developer.
• Responsible for Oracle Applications Customizations and report development.
• Developed SQL (DML) scripts for checking data in the database for customized import processes.
• Provided database maintenance, resolved technical problems in respect to performance of the database.
• Developed Custom Reports in Inventory for audit purposes.
• Developed UNIX shell scripts for file transmission and to automate the FTP process.
• Developed PL/SQL Procedures, Packages, Functions and Triggers.
• Developed interfaces to load location based taxes into Oracle AR.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements in AP, AR, GL.
• Writing conversion scripts invoking APIs to convert and write legacy data into Oracle tables.
• Used PL/SQL to develop customized packages, stored procedures, functions and database triggers.
• Customizations Oracle COGS workflow to meet the custom business requirements.
• Provided support to the existing implementation.
• Worked extensively wif tools such as EXPLAIN PLAN, SQLTRACE, and Oracle Diagnostics for troubleshooting application and SQL issues.

Environment: UNIX, Oracle Applications 11.5.10.2, Oracle 10g, SQL, PL/SQL, HTML Forms 6i, Reports 6i, Clear Case.

Confidential, Dallas, Texas

Oracle Applications Technical Analyst

Responsibilities:

• Involved in developing Custom Forms for Order Entry, Customer Referral Process and enhanced the functionality of existing custom forms.
• Developed new Custom Form which extends the existing functionality of e-Business Center Form.
• Developed new custom PL/SQL, and SQL Reports in OM, AR, AP, and PO.
• Enhanced Existing custom code for AR interface to fit the new business requirements.
• Extensively Used DBMS, UTL packages and collections to develop PL/SQL code.
• Involved in Customer Conversion as part of new company acquisition.
• Developed SQL*Loader scripts.
• Used PL/SQL to develop customized packages, stored procedures, functions and database triggers.
• Loading data using SQL*Loader (both conventional and direct path loading) and Stored procedures.
• Developed Interfaces to Load Budgets and Journals to oracle General Ledger.
• Wrote database PL/SQL triggers and procedures, Function, Packages to provide Backend security and data Consistency.
• Extensively Used DBMS, UTL packages and collections to develop PL/SQL code.
• Upgraded objects from 11i version to R12 which involved testing the custom code in R12 Environment, upgraded custom forms and PLL’s from 6i to 10g version.
• Developed PL/SQL Packages using API’s to Create Orders in Order Management and to raise Task in CRM Foundation.
• Identified and fine tuned several SQL queries.
• Developed Packages, Procedures and Functions to enhance the existing IVR functionality.
• Developed documentation for SOX Process.
• Developed host based concurrent programs using FNDCPESR.
• Prepared technical specifications for interfacing requirements.
• Developed Unix Scripts to migrate code from Legacy system to QVCS.

Environment: UNIX/Linux, Windows 2000/XP, Oracle Applications 11.5.8/R12i (12.0.3), SQL, PL/SQL, Oracle 10g, Reports 6i/10g, XML Publisher, Forms 6i/10g, SQL*Loader.