We provide IT Staff Augmentation Services!

Oracle Apps Techno-functional Consultant Resume

0/5 (Submit Your Rating)

San Francisco, CA

SUMMARY:

  • Experienced professional offering 14 years of success leading all phases of diverse technology projects.
  • Results - driven project-management professional(Satyam project-management certified ) with 3+ years of Project Management experience in managing multiple Oracle Applications ERP and CRM projects and proven track record in managing productivity, quality, customer satisfaction and geographically dispersed teams.
  • Business strategist; Ability to manage technical aspects, architect tailor-made customer solutions, and communicate solution strategy and product offerings.
  • Excellent communicator; leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.
  • Expert in agile, waterfall& SDLC project management methodologies. Able to manage small to Medium project teams and known for high-quality deliverables that meet or exceed timeline and budgetary targets.
  • Expert Techno FunctionalAnalyst in Oracle Applications;10years of strong technical experience relating to Oracle Applications including Configurations and Setups, Design, Development, testing and deployment of RICE components, Support and Maintenance .Majorly worked on finance: Payables,Receivables,General Ledger, Fixed Assets, and having good exposure to Oracle Purchasing, Oracle Inventory and Oracle HRMS.
  • Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Workflows, XML Publisher, Forms and Customizations.
  • Experience in working for CMM Level5 Organization. Expert knowledge in the deployment of processes and tools to support the SEI Capability Maturity Model, Statistical Process Control, and the Project Management Maturity Model, Quality Management, Quality Processes and Tools

TECHNICAL SKILLS:

Skills: Project Management: ERP Custom Development ERP Migrations/Integrations/ Conversions ERP/CRM Support and Maintenance GRC Asset Building Domain Exp: Manufacturing Retail Finance IT Project Lifecycle: Requirements Analysis ROI Analysis Costing &Budgeting Project Scheduling Testing/Support Quality Audits Tools/Technology Oracle Sql/Plsql Forms Reports Discoverer MS Projects Oracle EBS 11i,R12 Visio Toad Pl/sql Devloper Value - Added Leadership: Cross-Functional Supervision Team Building & Mentoring Client Relations &Presentations

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Requirements gathering to develop custom packages for Inbound/outbound interfaces like Auto Invoice interface, Payables Open Interface, Journal Import, Customer, PO, AR Receipts and Vendor Interfaces.
  • Responsible for Creating Database Objects like Packages, Functions, Procedures, Tables, Views, Materialized Views, Constraints, Indexes, Synonyms, Triggers to implement business requirements.
  • Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
  • Writing custom interface programs and working on Oracle Open Interfaces to integrate Oracle Applications with other packaged and custom Applications, which includes Payables Open Interface, Bank Statement and Reconciliation, Auto Invoice and GL Interface.
  • Developed the AP Invoice Aging Report by customizing the standard oracle report, to display the Future Payments and Prepayments in the report.
  • Worked on optimizing the custom views SQL for performance.
  • Was involved in Design, Unit Test Plan and Code Reviews.
  • Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
  • Performing onsite requirement analysis and developed functional specifications for the modules AP, AR, GL, CM, PO, INV for customizing processes by conducting Business Process Review (BPR) and Confidential analysis to fulfil business requirements.
  • Raising Service Requests with Oracle to fix the issues encountered after upgrade like invoicing and accounting issues in AP and AR Sub ledgers, E Business Tax, MOAC, Transferring journals to GL, etc.
  • Created Descriptive Flex Fields, registered Concurrent Programs, Value Sets, Values, Report parameters, new functions, new menus, new responsibilities, new users and System Administration.
  • Preparing Ad hoc queries for the end business users.
  • Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
  • Developing several RDF, Discoverer, and XML reports in various modules of AP, GL, AR, and PO using Reports and Discoverer.
  • Providing and conducting workshops to train end users on the new functionality of R12.
  • Preparing various documents required under the AIM methodology like BRD100, MD50, MD70, TE50 etc., Test Scripts, Test Cases and End user material.

Confidential, Chicago, IL

Oracle Applications Technical Consultant

Responsibilities:

  • Worked on AR Receipts and Cash Book forms using Forms Builder.
  • Worked on Purchasing PO data conversion from legacy to Oracle.
  • Worked on Purchasing API’s for various business requirements.
  • Used Payables AP API’s for creating Suppliers and checking Invoice status.
  • Worked on Suppliers Conversion in Payables AP.
  • Developed Customer Conversion in AR to load historical data into Oracle.
  • Worked on Payables AP Invoice Interface.
  • Converted Oracle 11i Reports by adding R12 MOAC features and R12 Tables.
  • Created Setups in PO, INV and AP modules as per business requirements.
  • Worked on Change Management and production tickets.
  • Developed Custom Interfaces between legacy systems and Oracle using SQL Loader and UTL FILE package.
  • Worked on development of PLSQL Queries, Procedures, Functions and Packages as per business requirement.
  • Troubleshooted Technical and Functional issues in PO, INV, AP and OM modules.
  • Preparing various documents required under the AIM methodology like BRD100, MD50, MD70, TE50 etc., Test Scripts, Test Cases and End user material.

Confidential, Milwaukee, WI

Techno-Functional Consultant/Technical Lead

Responsibilities:

  • Integration between Quantum to Oracle GL and balance extract to HFM (using sql/plsql and UNIX shell scripting)
  • Responsible for supporting month-end and year end process.
  • Resolving, providing support on Revaluation, RE balance issues and reconciliation issues with external applications.
  • Interface expense reports from Infor(Expense Management System) to Oracle Payables
  • Interface legal invoices (LITE) to Oracle Payables and update payment information in LITE database after payment is processed
  • Preparing Ad hoc queries for the end business users.
  • Developed inbound interface for Invoice Data from PSFT - Process to load all invoice related data into Oracle. Import and validation were performed using PL/SQL package.
  • Developed, implemented and tested Vendor interface to import vendor information from legacy system into Oracle Application tables. This involved importing data from legacy system into staging tables using SQL*Loader and using the PL/SQL procedure validating the data and inserting into oracle standard tables.
  • Worked on AP to FA Interface to transfer AP Invoices to Fixed Assets.
  • Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.

Confidential

Project Manager

Responsibilities:

  • I was responsible for team setup, status and progress Reporting, Risk management and mitigation, Customer coordination and reporting, providing technical roadmap to the team in the respective areas, performance appraisal for the associates.System Integrations/Migrations,Conversion for Age Consulting, Italy

Confidential

Project Manager

Responsibilities:

  • Unison Industries, a subsidiary of GE Aviation business, is a leading manufacturer of aircraft engines. They have mechanical (U1) and electrical (U2) sites. Two different systems Confidential and Confidential were running in their two sites U1 and U2.They planned to centralize their system by sun setting their legacy system and implementing Oracle ERP system. We were part of the technical development team where onsite team was involved in low level and high level designs and deployment of components developed and tested by offshore team. My responsibilities included project management, on time deliveries high CSI and managing a team size of 22 in India and China.

Confidential

Project Lead

Responsibilities:

  • Understand the support dynamics
  • Validate the input data provided by Confidential
  • Identify the gaps in the scope defined - Formalize the Scope
  • Validate transition and Support effort estimate
  • Understand Functional and IT Interfacing requirements for TO-BE support model
  • Validate assumptions and Risks
  • Rial Global Initiatives ( Confidential ) for Confidential, USA

We'd love your feedback!