SUMMARY:

• An accomplished professional Oracle Techno - Functional consultant with 12 + years of IT experience in user requirement study, analysis, solution design, project planning, Development of Oracle Open Interfaces and Reports implementation, setup, testing, customization, maintenance, support, and migration in Oracle E-Business Suite R12.2/11i.
• Implementation experience and very strong technical expertise in Oracle Planning(ASCP), Order Management, Inventory, BOM, WIP, Purchasing, Oracle SCM, Oracle discrete manufacturing modules, Financial (FA, AP, AR, GL), Oracle Projects, OTL and HRMS Modules
• Experience in streamlining and modifying business processes to be more efficient after new ERP implementation or enhancement in existing systems and reports.
• Specialized in Oracle Applications (Distributions/Manufacturing/SCP/Finance) skills with sound knowledge of their integration.
• Strong Expertise in Design, Development of RICEFW (Reports, Interfaces, Conversions, Extensions and Workflow) components.
• Worked on more than Four full life cycle end - end implementations/ Enhancement of Oracle Application 11i/R12.2.
• Working with cross functional teams to gather requirements, design the process and implement effectively.
• Written Custom Interface programs for importing data from feeder systems to Oracle using SQL*Loader, PL/SQL.
• Designed, developed & customized Open Interfaces, Forms and reports in Oracle Distributions/ Manufacturing applications.
• Strong analytical and technical skills with good programming experience in SQL, Advanced PL/SQL, Advanced Queues, Oracle Developer, Discoverer, XML Reports, SQL*Loader, C, C++, Core Java, Application Frameworks, UNIX Shell Scripting.
• System Analysis, As Is / To Be Process mapping, Requirement gathering and analysis, Specification generation, Solution design, System integration.
• Strong Conceptual, Business, Analytical skills & highly motivated team player.
• Post Production support, bug fixing and enhancement.
• Excellent verbal, written, communication and presentation skills.
• Test cases Preparation, functional / Unit testing, System Integration testing, CRP(s), UAT and Oracle AIM documentation and Client specific documentation
• Well versed with Agile, Waterfall, AIM SDLC methodologies
• Good Knowledge on Winchill and Agile PLM Systems.
• Involved in integration, development and testing end to end processes.
• Strong Knowledge in customizing existing OAF screens, oracle forms and oracle reports.
• Worked on Salesforce CRM cloud applications and integration with Oracle ERP modules.

TECHNICAL SKILLS:

Applications: Oracle Applications R12/11i Enterprises: OM, ASCP, PO, INV, BOM, Costing, Billing, WIP, AP, AR, GL, HRMS, Payroll, OTL, Project Management, Depot Repair, Field Services, Service Contract, Salesforce CRM Cloud Applications

Languages: SQL, PL/SQL, Apex, C, Java, Java Script

Operating System: Windows 9x/NT/ 2000, UNIX, Ubuntu

Software Tools: Oracle EBS, Oracle Reports/Forms 10g/9i/6i, Workflow, XML publisher, SalesForce CRM, Eclipse, Windchill 10, JDeveloper, Web Services, Data Loader, PLSQL Developer, TOAD, Oracle Discoverer, OA Framework(OAF), ADF, SQL * Loader, Unix Shell Scripting, MySQL, Google Big Query, Google Analytics, Zapier, Tableau, WinSCP, Kintana, Putty

Databases: Oracle 8i/9i/10g/11g/12c, MySQL

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, CA

Business Systems Techno Functional Consultant

Responsibilities:

• Executed a role of Techno Functional Analyst with resolution of innovative solution designs, system integration and system enhancement to accomplish a goal of enhanced system solutions for prevailing and improved business processes.
• Systems and tools consisted of Oracle EBS, Oracle ASCP, Google BigQuery data warehouse, Tableau and Java based custom portals.
• Managed system integration design and solution delivery for heavy transactions based operations which included third party logistics and multiple contract manufacturers encompassing end to end transaction integration with planning, logistics and finance.
• Customization and Development of Oracle Interface at Supply Chain Planning, Inventory, Order Management, Purchasing, FA, Receivables, Payable modules.
• Integration of Oracle supply chain planning with various external systems.
• Analyzing critical issues and providing the solutions on the day to day Google logistics and planning activities.
• Expertise in Order to Cash and Procure to Pay cycle, and involved in multiple end to end customizations.
• Oracle Performance analysis and tuning and process improvement for Oracle Financials & Value Chain Planning.
• Customization of Oracle ASCP process, by introducing post collection, preplan and post plan process to accommodate business needs.
• Sourcing Rule Automation at Supply Chain Planning.
• Analyzing existing valuation logic of location match and implementation of solution to decommissioning fixed assets using GPN and serials to improve accuracy of asset match.
• Integrated Oracle-EDI data for various PO Outbound (850/860) and Inbound (855/865) transactions using SOA B2B integration.
• Integrating MES(Aprisco) system with Oracle and established all supply chain inbound and outbound transactions.
• Configuration of Rappy tool used by Google planners at data centers and automated the action level by matching build configuration with TLA search.
• Sidestep Portal Implementation which enable business users to modify item lead times and planning category.
• Automation of Sales order and capitalization process, Project closure in Oracle.
• Customized COGS and OEOL Work flows for specific sales order demand types, derive custom account and capitalize the sales order lines against it
• Customized Advanced supply chain planning process for planning based on it locations and achieved Installer level planning for Google Fiber.
• Created Custom programs to support the material transfer and receipt creation for serial enabled items from the custom mappings and handled all transactions interfaces.
• Created custom reports in Google PLX, Tableau, Oracle Reports, adhoc sql queries. Preparation of design documents and data mapping documentation.

Confidential, Mansfield, Ohio

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved directly with clients in requirement gatherings and discussion, development and testing of RICE elements
• Developed reports, conversion scripts and interfaces from onsite irrespective to all tracks
• Report bug fixing and Developed new interfaces for the Pricing solution
• Coordinating with offshore for the development of all RICE objects and provided technical solutions for implementing as per business purpose.
• Presentation of Technical components during Enterprise Pilot and User instances with clients
• Completed Data Conversion across all modules with proper Error Logs and statistics during CRP, UAT and Go-Live phases

Confidential

Associative Consultant

Responsibilities:

• Involved in CR and Defect fixing in Oracle XML and Discoverer Reports at reports track both at LINK and SIT instances.
• Inventory Inter Org Receiving Receipt Creation; Developed an Interface program to fetch all legacy receipts, then validate it and convert into EBS using standard RCV Interface tables and Receiving Transaction Processor Program.
• Developed FA Sales Tax Audit Report using Oracle Discoverer.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in Creation of Retail OTL Weekly time card upload program using HXC TIMESTORE DEPOSIT timecard API.
• Developed Weekly Timecard Exception report
• Created Time Entry Rules and Fast Formulas as per requirement
• Customized Workflow HXCEMP to avoid user notification

Confidential

Systems Executive

Responsibilities:

• Responsibility to include components involved in Oracle EBS Upgrade from 11.0.3 Instance to 11.5.7
• Customization of RICE components as part of development team.
• Perform unit testing during configuration/ development stages, assist in resolving issues and deployment to CRP, UAT and go-live phases.
• Provide ad-hoc reports and analysis.