We provide IT Staff Augmentation Services!

Sr. Technical Consultant Resume

Grand Rapids, MI

PROFESSIONAL SUMMARY:

  • Having 13+ Years of Rich Experience in Oracle Application implementations, testing and support in Oracle e - Biz Suite version 11.5.3 through 12.2.5.
  • Extensive experience in implementation, Migration, Customization and Production support of various modules in Oracle Applications with major focus in General Ledger (GL),Accounts Payables (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management (CM), Purchasing (PO), Inventory (INV), iProcurement, iExpenses, Service Contracts, Order Management (OM), Oracle Process Manufacturing (OPM), OLFM, Projects, EAM, Property Manager (PM), HRMS and Payroll.
  • Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
  • Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
  • Techno-Functional Experience in Order to cash (O2C), Procure to Pay (P2P) life cycle flows.
  • Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA), Agile Methodology and software Development Life Cycle (SDLC).
  • Experienced in Business Process Analysis (BPA), Requirement Analysis (AS-IS), system (TO-BE) mapping, system configuration, CRP testing, Integration testing, UAT, data conversions of master & transactional, Go-live support and production support.
  • Strong technical back ground which enables to work independently and map the business requirements to Oracle Application.
  • Proficient in Performance Tuning SQL statements using Explain Plan, SQL trace and TKPROF.
  • Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type and Bulk Collectors).
  • Map client business requirements to Oracle functionality and setting up application in the Test (CRP), Development (UAT) and Production (PROD) environments.
  • Excellent Communication and Interpersonal skills. Ability to work as an individual and in teams.
  • Developed the Interfaces by using the Oracle Data Integrator 11g (ODI) tool.
  • Knowledge on SOA suite for integrating third party systems with Oracle applications .
  • Worked on more than 4 End to End R12 Implementations and 1 R12 Up-gradation Project along with 11i Implementation & Support Projects.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite

Modules: INV, AP, AR, GL,FA,PO, OM,OPM,Property, iExpenses, CRM, projects, EAM,HRMS,Payroll, AOL, SYSADMIN, Alerts .

Technology: R12 (12.0.6, 12.1.2,12.2.3,12.2.4) and 11i (11.5.10) Oracle 10g/9i/8i, SQL, PL/SQL, Reports 10g/6i, Forms 10g/6i

Tools: BI Publisher /XML Publisher, ADF,Oracle Frame Work (OAF),worklow,WEBADITOAD, SQL * Loader, Putty, Win SCP,PVCS,KINTANA,Oracle Data Integrator(ODI).

Other Skills: Expertise knowledge on Conversions and Interfaces

PROFESSIONAL EXPERIENCE:

Confidential, Grand rapids, MI

Sr. Technical Consultant

Confidential

Responsibilities:

  • Worked on Items Conversion,Suppliers Conversion, AP Open Transactions, AR transactions,Banks and Branches Conversions by Using Oracle Data Integrator(ODI) and Custom PLSQL Programs .
  • Worked on Reconcilation reports between ODI Integrated Data in EBS and 3rd Party systems.
  • Worked on Customer Integration Interface between Magic DMS and EBS.
  • Worked on Automated RMA receipts Interface.
  • Developed custom reports in Oracle General Ledger that gives a listing of all accounts balances according to the financial calendar.
  • Worked on the Item Details Out bound details interface which is required for Hybris system.
  • Worked on Multi Language Outputs and XML Bursting Program using BI Publisher.

Sr. Technical Consultant

Confidential

Responsibilities:

  • Worked on the Automatic Generation of the Confidential Payment and Invoice Files in a Shared Folder using PLSQL Interface Program and Unix Shell Scripting.
  • Worked on the Interfaces(Purchase Orders,GRN Data) Between Oracle Application and the other legacy system like FMC to maintain the same data by using the ORACLE DATA INTEGRATOR (ODI )Tool.
  • Worked with knowledge modules like LKM, IKM and CKM.
  • Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
  • Developed AP Check Printing Report to produce check file in the Oracle Accounts Payables to complete the correct formatting for checks processed from Oracle payables through check printing software.
  • Worked on GL Open interface and GL Daily Rates Interface packages.
  • Worked on Physical architecture, Logical Architecture and Contexts Creation.
  • Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
  • Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
  • FIN Reports: Supplier ageing Report, Applied and Unapplied Receipts report, Journal Voucher Report, GL Account Balance in Functional and Foreign Currency etc.
  • Worked on Trade Custom Promotion screens and deduction Grid Custom Forms developments.
  • Developed custom Allocation processes by using PLSQL Programming with advanced concepts.
  • Worked on Requsition Approval Workflow Customization by Using AME in iProcurement as per client Requirment.
  • Worked on Projects Data migration codes such as Projects, Project Tasks,Projects Revenues,Budjets, project Costing, Actuals,Agreements and Events.
  • Worked on Custom reports and Custom Alerts.
  • Developed customized Accounts Payable Trial Balance Report using BI Publisher and EText tools.

Technical Lead

Confidential

Responsibilities:

  • Understanding the client requirements in the new scenario, requirements gathering and mapping documents.
  • Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
  • Worked on the Opera GL Daily Consumption interface program Between Oracle Application and the other legacy system like Opera and MICROS to maintain the same data by using the ORACLE DATA INTEGRATOR (ODI )Tool.
  • Created master & work repositories and configured ODI connections for source and target systems in topology.
  • Good knowledge in creating File to DB and DB to DB related interfaces.
  • Used ODI commands like OdiFileMove, odiFileAppend,odiFilecopy etc.
  • Reviewing day to day activities of team members via weekly / monthly review discussions and reports and also followed SOX compliance.
  • Worked on Inventory Items, Onhand Data, Purchase Orders, AP suppliers, Supplier Invoices Loading scripts.
  • Developed interface program to upload Bills of materials (BOM) Details.
  • Worked on Project Status Report in PA.
  • Worked on EAM Data Migration Activities.
  • Developed Active suppliers Listing Report, Purchasing Invoice Detaisl report, Supplier aging Report, Supplier wise Purchases report, Prepayment Balance Report and Invoice Aging Report.
  • Invloved in Drop Shipment and Back to Back sales Order process.
  • Worked on the design to automate the Ship Confirm process using the shipping APIs WSH DELIVERY DETAILS PUB.Update Shipping Attributes and Delivery Action PUB .
  • Worked on Data Migration codes in Inventory,OPM, PO, AP, GL,Projects,Cash Management, EAM,OM,AR, HRMS, Payroll Modules.
  • Designed and Developed the Integration between Oracle EBS and AMDOCS using SOA.
  • Involved in Customization of Standard Trail balance Report usingReports builder as per the businessRequirements.
  • Worked on Mediator, FTP and FIle Adapter for processing invoices using OCR.
  • Worked on design and construction of Web Services, SOAP and REST services.
  • Invloved in the SCM setups required for the Data Migration activities.
  • Worked on Purchase Order workflow customizations.
  • Worked on custom forms like Budget Utilization form, LC- BG Form, Alert Distributions form etc based on client requirement.
  • FIN Reports: Payment voucher report, Invoice Ageing Report, Supplier wise Purchases report, Receipt Voucher Report and Customer statement Report.
  • SCM Reports: Print Requisitions Report, Print Purchase Order - Singapore, Print Purchase Order, Standard PO.
  • Developed a conversion program to convert Fixed Assets from legacy system to oracle Fixed Assets (FA).
  • Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module.
  • Invloved Cash Management(CM) Bank and Bank branches loading and Bank reconciliation activities during Month end.
  • Worked on CUSTOM.pll customization for calling a custom form from Service Contracts main form.
  • Worked on reconciliation reports between Service Contracts and Receivables.
  • Worked on Alert Notifications requirements and OAF Personalizations.
  • Involved in Conversion and Open transactions Data activities.
  • Preparation of the Technical documentation like. MD.70, MD.065, C.V.60,TE.20 etc.

Techno Funtional Consultant

Confidential

Responsibilities:

  • Conducted CRP, Trainings and UAT for Targeted users
  • Prepare the end user training materials, for the client for the standard as well as the custom functionalities.
  • Providing the production support for the issues which occur after the go live in oracle application EBS.
  • Designed, developed and loaded data using FA MASS ADDITIONS Interface from Legacy systems.
  • Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
  • Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL Budget Interface table using SQL*Loader.
  • Resolve the issues with help of Tar’s and workarounds.
  • Worked on Catalog Extract and Bulk Load Requests in order to import the items into iProcurement.
  • Worked on the Financial, SCM, HRMS and Properity Modules support issues.
  • Worked on the Data Conversions (Suppliers,Customers,AP Invoices, AR Invoices,TB Upload) for the Roll outs.
  • SCM Reports: Active suppliers Listing Report, Planned Purchase Order Report, Purchasing Invoice Details report etc.
  • Worked on Cash Management Reconcilation Activities.
  • Developed custom forms for PDA custom Module.
  • Worked PDA Integration between Oracle EBS and PDA using Web services.
  • Involved in the issues Related to APEX Pages.
  • Developed the OAF Pages as per the requirement.
  • Developed the Finance,HRMS and Payroll reports.
  • Developed the reports using Reports10g, XML Publisher.
  • Preparation of the Technical documentation like. MD.70, MD.065, C.V.60,TE.20 etc.

Onsite Team Lead

Confidential

Responsibilities:

  • Conducting/participating in project review meetings for evaluating project progress.
  • Spearheading the operations progress to meet the committed timelines on regular basis.
  • Managing team of 8 members and responsible for implementation activities.
  • Helping the team members to deliver the Objects with adequate quality.
  • Involved in design, development in Reports, Interfaces and Conversions Track.
  • Involved in QA testing for different Objects.
  • Timely resolution of incidents based on the estimate and agreed date/ time and Delivering Objects with High Quality.
  • Worked on the Integrations Between Oracle Application and the other legacy system to maintain the same data like Active Retail and Ability Interfaces.
  • Worked iExpenses OAF extentions based on Client Requirement.
  • Developed the Items conversion,Supplier Conversion and Customer conversion API’s.
  • Involved in issues related to forms.
  • Created WEBADI spreadsheets to upload new assets (FA) and journal entries.
  • Worked on workflow customization using AME.
  • Developed the reports using Reports10g, XML Publisher.
  • Worked on Open Transactions for AP Invoices,AR Invoices and Onhand Quantity and Open PO’s.
  • Preparation of the Technical documentation like. MD.70, MD.065, C.V.60,TE.20 etc.

Offshore Team Member

Confidential

Responsibilities:

  • Developed the small OAF Pages as per the Client requirement.
  • Involved in discussion for solutions as a part of Technical Architecture.
  • Developed Interfaces using PL/SQL and Forms for Bolton’s like Common Payment Platform (CPP), HRMS to Payables (Supplier Creation), Payables Invoice Interface.
  • Worked on Supplier Conversion, Customer conversion, ULO Invoices Conversion, AR Invoices Data Conversion by migrating the data from Legacy system after doing all necessary validations.
  • Developed reports using XML Publisher according to the client requirement.
  • Involved Receipt outbound Permanent interface.
  • Involved in developing custom folders, complex folders, joins, hierarchies and summaries using Discoverer admin.
  • Involved in rectifying the errors and fixing the bugs during Unit testing.
  • Hands on experience on PVCS and KINTANA, IT Goverance.
  • Preparation of the Technical documentation like. MD.70, MD.065, TE.20, UTC, Delivery Check list etc.

Team Member

Confidential

Responsibilities:
  • Worked on Onhand quantity conversion.
  • Item Revision Conversion.
  • Report to display PO details with supplier, org, dates, total amount, matched with Invoice amount, yet to be matched amount, etc. for a range of PO-s by operating unit.
  • Trigger to update the PO DFF with Manufacturer Part number.
  • Alert to OM manager whenever an order is for items that have quantity more than the quantity on hand.
  • Report to show the rejected quantity and returned quantity and the days between the rejected and returned quantity.

Developer

Confidential

Responsibilities:
  • Involved in design and development of the application.
  • Designed and Developed Amendment Form to maintain the fields to be amended during the upload of data.
  • Developed PLSQL Packages for validating the table fields to be amended in PO module .
  • Involved in rectifying the errors and fixing the bugs during Unit testing.
  • Created packages/procedures for the generic application.
  • Involved in testing of the application.
  • Developed Various SQL * Loader Control Files for uploading Data from Flat Files to oracle Data Base Tables.

Hire Now