SUMMARY:

• Over 13+ Years of IT experience and major experience in Oracle Applications (E - Business Suite) with emphasis in manufacturing modules.
• Expertise in Technical and Functional aspects of Oracle Applications R12, 11i Financial, Supply chain, Order to cash and Manufacturing Modules which include Order Management (OM), BOM, General Ledger (GL), Accounts payable (AP), Inventory (INV), Shipping (WSH), Purchasing (PO), AOL, Oracle E Business Suite logistics.
• Have hands on experience in Oracle Release 12 Manufacturing Modules and Order Management.
• Good knowledge in Order to Cash (O2C) business flows.
• Experienced in requirements gathering, system analysis, design, development, testing, implementation, support, documentation and design reviews.
• Developed Interface Programs and Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Extensive experience in Analysis of Database.
• Hands on experience in Oracle Fusion modules such as Core HR, Absence, Profile Management, Goal Management, Talent Review, Succession Management, Performance Management, Payroll, compensation, Benefits.
• Hands on experience in working with Fast formula & HCM Extract to extract fusion data in different formats using database items (DBIs) & extract rules.
• Hands on experience in development of both Inbound & Outbound interfaces using HCM Extract, BI publisher & Data Modelling.
• Good Exposure to Oracle Application implementation methodology (AIM).
• Expertise in creating inbound and outbound feeds, creation of automated processes using Application Program Interfaces (API)
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
• Experienced in Developing Functional design documents (MD50), Technical design documents (MD070), Conversion technical design documents (CV060) and Migration documents (MD0120).
• Comfortable working on SQL*Loader, SQL* Plus, UTL FILE, CONCSUB Utility, Oracle Import/Export utilities and SQL* Navigator.
• Good understanding of Oracle databases, Strong in Inventory, WMS, AR and AP modules. Knowledge in Purchasing and MRP (Materials Requirement Planning).
• Good Expertise in Query and Performance tuning in Oracle. Having working experience in analyzing the Oracle SQL Raw Trace and TKPROOF Trace files in working query and database performance issues.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
• Registering of Custom Applications/Table/Schemas in Oracle Applications.
• Worked on Oracle Alerts and exception handling.
• Excellent analytical, problem solving, communication and inter-personal skills.

TECHNICAL SKILLS:

ERP: Oracle Applications E-Business Suite R12/11i (AP, AR, OM, GL, WIP, BOM, PO, INV, AOL, WMS, Service Contracts, Install Base, CRM), Oracle fusion HCM, Fusion HCM Release 9 to 13

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

Scripting: SQL, PL/SQL, UNIX Shell Scripting

Program Languages: C, C++, Java, JSP, HTML/DHTML, XML, ASP, VB

Operating Systems: MS-DOS, UNIX, Solaris, Linux (Red hat, SUSE 9.2/9.3), Macintosh, WINDOWS 98/2000/NT/XP/VISTA

GUI: Oracle Developer - Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher

Query Tools: TOAD, SQL Navigator, SQL Developer, SQL*PLUS

Other Tools: SQL*Loader, Erwin, Smart Draw, MS Office, MS Excel, MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Oracle EBS Senior / HCM Consultant

Responsibilities:

• Developed the Audit Reports related to Audit tables of Banks, FND USERS, PO Approval, PO approval hierarchy,
• Conducted Workshops to gather the Business Requirements, Validated the requirements and configured the Fusion HCM application. Identified the new requirements from when compared to the existing application and done the fit-gap analysis and implementing/configuring the new changes into Fusion.
• Configured Oracle Fusion HCM with Goal Management, Performance Management, Talent Review & Succession Planning, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Fast Formulas, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration, Benefits Administration, Payroll
• Worked on cross-functionally with IT and HRIS teams to ensure effective execution of Oracle HCM software such as Oracle Fusion HCM
• Person Assignment, Resp Assignments and GL Limits for RIFAN users.
• Customized/Personalization’s to the Oracle receivable batches, invoice, Receipts, and Accounts details forms to restrict the access of invoices and receipts data to different Agencies based on Receipt class and Receipt methods. Created different responsibilities for each Receipt class to achieve the expected functionality. Overcome challenges and successfully implemented the functionality.
• Developed new Report AR Receivables Statement Report
• Developed new Custom reports,
• Modified the PO Contract terms (XSLFO file) on the PO PDF report to exclude the table, include the OU and alignments changes.
• Modified the PO PDF report(XSLFO) for Blankets PO’s to include the condition to restrict the expired lines based on the Include Cancel flag on concurrent Program
• Modified the PO PDF report(XSLFO) for Blankets PO’s to add new fields by using oracle provided hook .
• Customized the Checkout Page to hide standard region and add custom Region
• Modified/personalized /customized Controller’s, fields and VO, CO Extensions in I procurement.
• Developed Audit Transactions page (Custom OAF page insert/update/delete) from scratch for Audit.
• Developed the BI Publishers reports. AR Bucket report, AR Employee Delinquency report, Invoice Statement report.
• Debugged the randomly errored PO Program by enabling the Trace and monitoring the FND LOG MESAGES table to trace the issues.
• Developed new OAF Custom Audit pages create/modify/delete to tracks the Payables hierarchy and assignments .

Environment: Oracle E-business suite R12 Upgrade (AR, Shipping, OTM, GTM, OM, Carrier Integrations) Jdeveloper 10g (OAF), Oracle 12g, Workflow, UNIX, Oracle Fusion HCM, Fusion HCM Release 9 to 13

Confidential, Westlake, TX

Oracle Techno Functional Analyst

Responsibilities:

• Worked as an Oracle Applications Techno-functional consultant responsible for the implementation and roll out of Oracle OM, Inventory, and Shipping, BOM, WIP and MRP modules.
• Involved with Business teams and worked closely with the Oracle Order Management sales Admins, Purchasing Admins and Contract Manufacturers.
• Worked on creating POC Drop Shipment Proposed Plans for a direct shipment process in Oracle from CM’s to the Customers.
• Worked on creating various functional design and requirement gathering documents like A10 Shipment Process-Taiwan (MD50) and design documents like A10 Shipment design Document process Taiwan (MD70).
• Worked on business cases for the current as-is process and the to-be process.
• Worked on risks and merits of the new process to be implemented.
• Worked on creating setup document BR Shipment Setup documents.
• Acted as a functional and technical oracle consultant to understand the business process, create design and implement the project in Oracle R12.1.3.
• Involved in creation of various custom packages XXA10 OM Defaulting RULES PKG, procedures TN SHIP SO N PO PRC, Concurrent Report on Item Availability, Table for Country territory mapping.
• Created migration document A10 TaiwanShipmentMigration to show all the objects to be migrated.
• Customized the standard workflow OEXWFOD.wft for the shipment project.
• Created test plan and test documents A10 TaiwanShipmentTesting Plan.ppt and A10 TaiwanShipment Detail TestCasesdocuments with test scenarios and test cases.
• Worked on unit testing and also UAT testing with the business users.
• Customized standard Pack slip using A10 Packing Slip.xml and A10 Packing slip Template.rtf to add the line level instructions.
• Worked on enhancing various Discoverer reports using Discoverer Administrator, User and Viewer.
• Created discoverer reports, Added new reports, Modified reports, gave access to various reports to the users.
• Worked on the automation/scheduling process of the Discoverer report to run and send the report via email regularly to the required users.
• Involved in Functional setups of items in Inventory for Confidential and PTO Items.
• Created BOM and WIP setups to create sales orders for both Confidential and PTO model items.
• Created BOM and WIP parameter setups, Created item setups, Added On Hand inventory for the items created, Checked for WIP Work order process for Confidential Items.
• Worked on MRP Material Planner module setups to create manual forecasts and check the MRP Workbench for the automatic purchase order suggestions according to lead times.
• Worked on various P1 and P2 issues. Raised SR’s to oracle to resolve various oracle issues.
• Worked on Oracle Quoting module to check for various user issues regarding integration with Sales Force opportunities.
• Resolved Line lock issues in Order management sales order form.
• Resolved various order management and service contracts integration issues like contracts not created in SC modules.
• Worked on ADI and Journal entry integration issues.
• Worked on various java jinititor issues to access Oracle applications R12.

Environment: Oracle Applications: 12.1.3 (OM, INV, Receivables, Service Contracts, Install Base, General Ledger, BOM, WIP, Pricing, Material Planner and Shipping), RDBMS: 11.1.0.7.0, PL/SQL, SQL Developer, TOAD 12.1.0.22, Oracle BI Discoverer Administrator 11.1.1.3.0, Oracle BI Discoverer Desktop 11.1.1.3.0 .

Confidential, Overland Park, KS

Oracle Techno Functional Consultant

Responsibilities:

• Worked on Order Management, Supply Chain (using Rosetta-Net), customer relationship management and Finance modules.
• Collaborated with business users to analyze and understand business problems and needs. Lead process configuration design activities.
• Created current business process documents BRD for the enhancement projects of Oracle Cisco Services system.
• Worked on documentation of depot repair enhancement project for repair partners and planners to send and receive B2B messages.
• Reviewed UAT (User Acceptance Testing) test plans, executing test cycles, documenting results, and created sign-off documentation.
• Coordinated and provided input to design, and development of User Acceptance Test Strategy, User Acceptance Test Plans for Oracle services project enhancement on depot repair services.
• Developed data requirements for Business Users.
• Ensured current procedures are in compliance with established processes, standards and tools.
• Verifies and ensures test plan, scripts support testing objectives are executed properly.
• Participates in defect management strategy and coordinate with project team to ensure timely resolution of defects.
• Work collaboratively with IT developers to provide and act as a liaison between the business users and the project team.
• Perform gap analysis: as is vs. to be

Environment: Oracle E-Business Suite 11i, R12 (INV, OM, Depot Repair, Field Service Management, Service contracts and Install Base), Oracle 9i, RDBMS: 11.2.0.2.0, SQL, PL/SQL, Reports 6i, SQL Developer, TOAD, BI reporting tool.

Confidential, MO

Oracle Techno Functional Consultant

Responsibilities:

• Worked as an Oracle Applications Techno-functional consultant responsible for the implementation of Oracle Warehouse Management Systems, OM and Inventory Modules: INV, OM, WMS and AR.
• Involved with Business teams and worked closely with the Oracle Order Management, Warehouse Management Systems (WMS) Inventory and Quote to Cash Cycle.
• Developed business processes and used cases using MS Visio and created BRD’s.
• Worked on creating various functional design and requirement gathering to create documents (MD50) and design documents (MD70).
• Worked on gap analysis for moving from legacy system IBM Alice to Oracle Apps.
• Acted a liaison between the Business users and Technical team to understand the business requirements to implement WMS in Oracle R12.1.3.
• Involved in the implementation of pick position conversions on Functional side.
• Involved in creating various sales orders with different pricelists, different order types for different business units of BULK, KCN and SecurePak.
• Worked on Confidential manufacturing process.
• Involved in creating sales orders with different ship methods, ship dates, pricelists and order types, creating LPN’s, pick releasing and ship confirmation processes.
• Conversion of Sales orders from Legacy to Oracle 11i
• This involved the API OE ORDER PUB.PROCESS ORDER
• Conversion of BOM and Routings from Legacy to Oracle 11i,
• This involved standard interface methodology
• The APIs involved are BOM BO PUB.PROCESS BOM and BOM RTG PUB.PROCESS RTG
• Worked on setting up Concurrent programs, executables, valuesets, lookups, menus, functions and user profile options.
• Knowledge on various base tables on Oracle R12 in WMS, INV, Accounts Receivable and Order Management.
• Customized and designed various reports in INV and OM like Pick Slip Reports, Pack Slip Reports, Bill Of Lading Reports.
• Worked on BOL to customize the weights of the pallet by adding the pallet weight to the weight of the items.
• Analyzed and functionally designed Custom forms for ATP and On hand Quantity aspick position maintenance form.

Environment: Oracle Applications: 12.1.3 (WMS, INV, and OM), RDBMS: 11.2.0.2.0, SQL, PL/SQL, Reports 6i, SQL Developer, TOAD, BI reporting tool, Data loader.

Confidential, Chicago, IL

Oracle Techno Functional Developer

Responsibilities:

• Involved with Business Services team and worked closely with the Oracle ASCP, Accounts Receivables, Order Management and Quote to Cash Oracle systems.
• Interacted with all Business users and Technical team to understand the right approach and Information to implement the implementation of OM and Demantra in Oracle R12.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports.
• Imported Legacy Journals data into GL using Journal import interface
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Worked on Pick release public API and used WSH PICKING BATCHES PUB package for creating and releasing batches.
• Worked on Freight costs public application program and used WSH FREIGHT COSTS PUB package for updating, validating and deleting freight cost records.
• Developed conversion program to import PO Requisitions from flat file to PO Interface table using different validations like verifying vendor Id, charge account, code combination Id, Unit of Measure.
• Worked on Auto lock box open interface to outsource the accounts receivable payment processing and for automatic generation of receipts.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Designed and developed the Functional Docs (MD.020), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
• Created concurrent programs, collections in ASCP to run and import safety stock data into the Oracle DB from PeopleSoft.

Environment: Oracle E-Business Suite R12 (ASCP, INV, AP, PO, AR, OM, Demantra), Oracle 9i, PL/SQL, Reports 6i, Demantra, AIX,Apache TomCat,OC4J, J.D.Edwards, People Soft, Jdev, Java, OA Framework OAF, Benthec, SQL Navigator, SQL Developer, TOAD.

Confidential, Parsippany, NJ

Oracle Techno Functional Developer

Responsibilities:

• Involved with Business Services team and worked closely with the Oracle Accounts Receivables, Order Management and Quote to Cash Oracle systems.
• Interacted with all Business users and Technical team to understand the right approach and Information to implement the integration between the Symantec and Verisign Oracle ERPs.
• Developed the Hierarchy and design for creating all the Interfaces using Oracle Pl/sql.
• Gathered business requirements and then translated business needs into functional specifications and technical documents MD 50 VeriSign UA Bookings and VeriSign QTC integration.
• Prepared project-initialization documents, Mapping Information Guides and functional specifications.
• Designed and developed the Functional Docs (MD.020), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
• Worked on the issues of Orders with Pick release, Ship Confirm processes, and Order status.
• Worked on custom stored procedures using PL/SQL. Writing SQL scripts for identifying the issues related to Orders, Deliveries in the database.
• Registered custom tables on Oracle 11i (Accounts Payable, Accounts Receivable and Order Management, Service Contracts and Install base).
• This involved the API OE ORDER PUB.PROCESS ORDER
• Conversion of BOM and Routings from Legacy to Oracle 11i,
• This involved standard interface methodology
• The APIs involved are BOM BO PUB.PROCESS BOM and BOM RTG PUB.PROCESS RTG

Environment: Oracle E-Business Suite 11.5.10 (INV, AP, PO, AR, OM, Service Contracts and Install base), Oracle 9i, PL/SQL, Reports 6i, Perforce, SharePlex, Hyperion, SQL Navigator, TOAD.

Confidential, San Mateo, CA

Oracle Techno Functional Developer

Responsibilities:

• Involved with Business Services team and worked closely with the Oracle Accounts Payables, Project accounting and financial systems team supporting Oracle’s R12 ERP.
• Involved in the implementation of OM Shipping on Technical side
• Worked on Conversions to import orders and invoices from legacy system
• Wrote interfaces between OM and Shipping by using Shipping APIs
• Customized various reports in OM, Shipping Reports (Bar Code used), Pre Pick LPN Detail Report, and Customer Sales Representative
• Customized Discrete Jobs Dispatch report, Discrete Job Pick List Report, Discrete Job Routing Sheet report
• Customized the Packing slip, Pick Slip and sales order Acknowledgement report
• Developed Custom forms to modify License Plate information.
• Customized Commercial Invoice and Bill of Lading reports
• Worked on HP Quality center to upload the test scripts and work on test cases.
• Worked with the Oracle middleware system i.e SOA and Oracle Fusion during the processing of invoices from the source (Oracle) to the target systems (Counsel Link).
• Worked on creating MD50 Clinical Trial Data for Complete Spend and design documents.

Environment: Oracle E-Business Suite R12, 11.5.10 (INV, AP, PO, AR, PA), JDE, People soft, Oracle FusionSOA, Counsel Link, Sandbox, Oracle 9i, PL/SQL, Reports 6i, TOAD

Confidential, Portland, OR

Oracle Developer

Responsibilities:

• Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, documentation and implementation.
• Worked on the development of Data Migration, Interfaces Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash and Procure to Pay Cycles touching various modules such as PO, AR, AP, GL and FA.
• Worked on Cisco Order to Quote cycle with Smart care systems.
• Worked on various custom tables and custom API’s.
• Interacted with various business users to get the data migration information on various tables to be fixed.
• Worked on CDETs and Kintana Clear case to get most of the bugs resolved.
• Developed Migration programs to convert data fix various numbers and location ids, names and party site ids etc.
• Worked on various GUI’s working on Java with database backend using Oracle Plsql.

Environment: Oracle E-Business Suite 11.5.10 (INV, OM, PO, PA, BOM, Routings), Oracle 8i, PL/SQL, Forms 4.5, Reports 2.5, ANT, UNIX, Apache Tomcat, TOAD.

Confidential, Schaumburg, Illinois

Oracle Apps Consultant

Responsibilities:

• Worked as a Oracle Applications Techno-functional consultant responsible for the implementation of Oracle Shipping, OM and MFG Modules: INV, PA, AR, OM and WMS.
• Worked on creating requirement document and design documents.
• Worked on gap analysis.
• Involved in the implementation of Sales order Delivery Information on Technical side
• Involved in creating various sales orders for domestic and international customers.
• Involved in pick releasing and ship confirmation processes.
• Worked on setting up various responsibilities requested for third party logistics team.
• Worked on setting up menus, functions and user profile options for each responsibility accordingly.
• Knowledge on various tables on Oracle R12 in TCA, Accounts Payable, Accounts Receivable and Order Management).
• Worked on Documentation for the upgradation from Oracle 11i to R12.
• Created various UNIX Shell Scripts for loading process. Maintained the batch processes using Unix Shell Scripts.
• Created UNIX Shell Scripts during data conversion process.

Environment: Oracle Application 11.5.10, R12, Oracle Manufacturing (INV, BOM, WIP, PA, OTC, P2P, Shipping, Order Management, PO), Kintana and clear case,, SMS DWH, VB.net, Informatica and Yantra.

Confidential, Peoria, Illinois

Oracle Apps Consultant

Responsibilities:

• Worked as a Senior Oracle Applications Techno-functional consultant responsible for the implementation of Oracle Shipping, OM and MFG Modules: INV, Cost Management, BOM, WIP OM and WMS
• Developed custom reports like PO returns report and Bin replenishment report.
• Involved in attaching new BOM components to the existing BOM structure according to the rules provided by the Business.
• Involved in the technical design and coding for conversions, interfaces and custom application development. Several inbound tables, snapshots, views, procedures and packages were built during the application development. Was involved with BOM, INV, WIP, OE-OM, MRP, CRM, PO, FA and HR modules. The core part of the application development was in sql, sql-plus, and command shell scripting.
• Designed and developed strategy to capture the legacy data and API to ORACLE database. Bom bill of mtls interface and bom inventory components interface were populated during conversion and API inserts the information to Oracle base tables.

Environment: Oracle Application 11.5.10 Oracle Manufacturing (INV, BOM, WIP, OTC, Shipping, Order Management, TOAD 7.6.0.11, Visio 2000, Shell Script.

Confidential, Jacksonville, FL

Oracle Apps Consultant

Responsibilities:

• Involved in Customization of whole end-to-end process from Order to Cash.
• Designed and developed the Functional Docs (MD.020), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
• Created Alerts which send mails to the support teams when any concurrent request runs for more than an hour.
• Worked on the issues of Orders with Pick release, Ship Confirm processes, and Order status.
• Registered custom tables on Oracle 11i (Accounts Payable, Accounts Receivable and Order Management).
• Created Bills of Materials (BOMs) from front end using applications.
• Worked on Performance Tuning using tools TOAD, HINTS, EXPLAIN PLAN and Auto trace.

Environment: Oracle Apps 11i (11.5.10), OE, OM, WSH, AP, AR, GL, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, TOAD, Discoverer 9i, Windows XP, UNIX.

Confidential, Illinois

Oracle Technical Consultant

Responsibilities:

• Documented functional features and behavior of required customizations using AIM methodology. Prepared and involved in analyzing conversion documents CV 40, CV 60 and MD70.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.

Environment: Oracle E-Business Suite 11.5.9(INV, OM, PO, AP, AR and GL), Oracle 9i, PL/SQL, Forms 6i, Reports 6i, Work Flow 2.6, Discoverer 9i, UNIX, Apache Tomcat, TOAD.

Confidential, CO

Oracle Developer

Responsibilities:

• Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
• Created Sets of Books in GL by defining Key Flex Fields, segments, value sets, accounting calendars, currencies.

Environment: Oracle E-Business Suite 11.5.10 (INV, OM, PO, BOM, Routings), Oracle 8i, PL/SQL, Forms 4.5, Reports 2.5, ANT, UNIX, Apache Tomcat, TOAD.