We provide IT Staff Augmentation Services!

Programmer Resume

Wayne, PA

Professional Summary:

  • Overall 12 Years of experience with Oracle products.
  • Around 9 Years in Oracle eBusiness Suite 11i/R12
  • 5 Years of Onsite (US, Australia and Singapore) experience.
  • Insightful experience and understanding of application development, implementation and customization in Financials, Distribution modules and other modules.
  • Extensive technical and significant functional skills encompassing requirement analysis, solution architect, maintenance and enhancement of applications
  • Strong experience in Oracle BI Discoverer and BI Publisher.
  • Possess excellent team leading skills including Delivery Management, Onsite and Offshore Interaction, Strategy Planning etc.

ERP Expertise:

Technical

  • Extensive experience in Reports, Interfaces (Inbound/Outbound) and Customized Extensions (RICE).
  • Data Migration and Data Conversion during project Implementation R12 and lower versions of Oracle Apps.
  • Preparation of technical documentation such as MD10, MD70, CV10, CV40 and CV60.
  • Created Packages and Stored Procedures using API’s for various modules ofFinancials and Supply Chain.
  • Technically expert in Reports, Discoverer, XML Publisher, Forms, XML, PLSQL, WebADI and UNIX programming.
  • Expert skills on DB object creation, triggers, procedures, functions and packages.
  • Tuning of reports, queries and processes.
  • Has been using SQL*Loader, UTL_FILE, UTL_HTTP, XMLGEN Oracle Export and Import utilities.
  • Customizations by Personalization.
  • Experiences in registration/migration of concurrent programs, creation of users, responsibilities, forms, functions, menu, values sets, request sets, request-groups registration in Oracle Applications.
  • Development ofReports using XML Publisher/BI Publisher.
  • Experience in creating programs usingBulk Collectand programming usingcollections.

Functional

  • Data gathering, Solutions Recommendation.
  • Logs service requests (SR)
  • Good in Financials, CRM and SCM modules like Receivables, Payables, General Ledger, Service Contracts, Credit Management, Order Management, Inventory, Procurement.
  • Design of Application Extensions and Integrations.
  • Preparation of functional documentations such as BR100, MD50 and TE40 and user guides.
  • Production Support.
  • Application administration of Oracle Application.
  • Conducted user trainings.

Current Employer:
Confidential, Programmer Analyst Aug 2012 – till date

PROJECT PROFILE:

Project: Oracle eBusiness Suite R12 – CEMLI Mar 2012 – Aug 2012
  • Client: Confidential
  • Modules: Oracle CRM (Service Contracts, Install base), Oracle Receivables, Order Management. Clear Case( Unix based)

Role: Designation & Description
Working as Tech Lead for Confidential project.

Roles and Responsibilities
  • Involved in delegation and co-ordination of Change Requests (Clear Quests) in the team.
  • Compiling the data from the team and Preparing metrics reports for the monthly deliverables.
  • Working with functional analysts in ascertaining the requirements for the CEMLI components to be developed.
  • Worked on Service Contracts, Renewal and Revisions reports
  • Worked on business flow customizations by using APIs in contracts.
  • Worked on a program to zero item prices for tailor made services/contracts.
  • Worked on Renewal Forecasts and Revision Sales Order Error Handling report.
  • Worked on setting up “stage test” environment for CQs, before promoting them to next level.
Project: Oracle eBusiness Suite R12 – Support Jul’10 – Feb 2012.

Client: Confidential.
Modules: Oracle Financials, Oracle Credit Management, Project Accounting.

Role: Designation & Description
Working as Techno/Functional Lead for Confidential project as part of Help Desk and Assurance practice

Roles and Responsibilities
  • Planning and co-ordination of the team in addressing and assigning the issues to the resources to support the activities for resolving the applications functional areas.
  • Work closely with the business functional leads in ascertaining the requirements for the RICE components to be developed
  • Worked on Oracle HRMS(Time and Labor)
  • Worked on Web ADI for PA related invoices
  • Working on Oracle Credit Management
  • Worked on OCM enhancements
  • Working on Month End Close activities
  • Involved in UAT with users and bug analysis process.
  • Received client accolades for my work in OCM module.
Project: Oracle eBusiness Suite R12 – Upgradation May’09 – Jun 2010.

Client: Confidential
Modules: Manufacturing (BOM), Oracle Financials, Oracle Project Accounting and Oracle Distribution

Roles and Responsibilities

Worked as technical consultant

  • Working on Oracle 11i to R12 Upgradation project.
  • Working on gap identification process and custom object identification.
  • Worked on Project Accounting Transaction Item interface.
  • Developed PA custom reports such as Project Cost Tracking report and Budget, Cost Tracking reports at individual project level.
  • Worked on custom “Manufacturing Cost Variance Report”
  • Implemented RBAC – Security model.
  • Designed and developed various types of BI/XML Publisher reports.
  • Customized complex reports such as, Standard PO and Complex PO.
  • Worked on variety of reports across Financials and Distribution (OM) modules.
  • Developed XML Publisher Report for Employee Expenses and AP/AR Netting Reports.
  • Carried out FND object (Users, Responsibilities, and Menus) migration across the instances.
  • Involved in iProcurement Personalization(OAF)
  • Worked on Inventory Aging Report.
  • Worked on Order Management Reports such as Revenue-COGS, Sales Order, Packing List, Material Onhand.
  • Involved in UAT with users and bug analysis process.
Project: Oracle ERP Support Jan’09 – May-09

Client: Confidential.
Modules: Oracle Projects, Oracle Financials and Oracle SCM.

Team Size 5
Role: Designation & Description
Working as Technical Consultant

Roles and Responsibilities
  • Providing production/customer support by resolving client’s day to day issues.
  • Worked on Transaction Import interface(Oracle Projects)
  • Worked on Datacom Projects CIP Transaction Report
  • Worked on Datacom Project Issue Slip
  • Worked on AIM documentation for custom objects.
  • Involved in UAT process with clients.
Project: Oracle ERP Support Mar’08 - Dec\'08

Client: Confidential
Modules: PO, AP, GL

Team Size 7
Role: Designation & Description
Onsite Tech Lead.

Roles and Responsibilities
  • Involving in business meetings to understand business requirements.
  • Having good knowledge on SSS custom processes.
  • As a tech lead - exercised activities like resource, work planning, and deliverables management.
  • Involving in system design.
  • Designed ISTL/XML Invoice inbound interface.
  • Worked on AP and GL inbound and outbound interfaces.
  • Involved in UAT process with clients.
  • Attended BPEL seminars and involved in developing proof of concepts using BPEL for evaluation purpose.
Project: Oracle ERP Support Apr’07 – Mar’08

Client: Confidential, Wayne, PA
Modules: Oracle Inventory, Order-to-Cash (OM, AR), PO.

Roles and Responsibilities
  • Worked as a technical consultant at client (Onsite) place
  • Worked on Order Import interface to import orders (Import, Validate and Load).
  • Created reports for Order Import process.
  • Involved in Receivables transaction (Auto Invoice), Cash Receipt related setups.
  • Worked on AR open interface to deal with Receivables transactions (invoices, Credit Memos) and customer’s data.
  • Worked in AR open interface for Cash Receipts data conversion from legacy system.
  • Implemented Change Requests and documenting the changes.
  • Designing specifications for customisations and implementing the customisations.
  • Involved in testing process during data migration.
Project Name: Oracle eBusiness Suite (Apollo) Nov’06 - Mar’07

ClientConfidential
EnvironmentOracle ERP 11.5.9

Role: Designation & Description
Worked as a technical consultant(OBIEE) at Confidential

Responsibilities:

  • Involved in proposing suitable topology which suites to client requirements
  • Developed rollout strategy for complete project
  • Provided Installation and configuration document for Application Server in consultation with DBAs
  • Developed EUL migration strategies and assisted developers for smoother execution of project
  • Proposed and implemented Materialized Views, where it had lot of summaries and pre-computations were involved.
  • Provided end user training, material and hands-on sessions on new discoverer tools
  • Organized UAT
  • Creating Application Users and assigning various responsibilities.
  • Resolving the issues raised by the client requests for ad-hoc queries and reporting.
  • Designed and certain AP/PO related reports such as “Contract Savings”, “Pos raised in the period”, “Position Hierarchy report”, “Receipts Analysis”, “Analysis of Orders Invoiced”, “Canon BISG Unpaid Invoices”
Project Name: Compass- Coventry Group Limited Mar’06 – Sep’06

ClientConfidential
EnvironmentOracle ERP 11.5.10, XML Publisher 5.6

Role: Designation & Description
Worked as a technical consultant at Confidential

Responsibilities:

  • Customized Discoverer reports to suite for the new Org. structure.
  • Implemented Materialized views as a measure of performance improvements in sales specific reports.
  • Worked on developing Slow Moving Stock sub module to calculate provision for the slow moving stock products.
  • Developed PL/SQL objects for slow moving stock.
  • Successfully converted many text reports to XML Publisher reports to produce rich PDF reports as output.
  • Designed and developed many XML publisher based reports.
  • Developed Tax Invoice reports AR and deployed.
Project Name: Launchpad – Bunnings Dec’05 – Mar’06

ClientConfidential
EnvironmentOracle ERP 11.5.10, BI Discoverer 6i
Role: Designation & Description
Worked as a consultant at Confidential

Responsibilities:

  • Did EUL setups in various environments (UAT, Prod, and Dev etc) at client’s place.
  • Worked with the Floor Managers to analyze specifications for Discoverer BI Reports.
  • Defined BI Discoverer administration, controlled system access policy to developers and end users.
  • Involved in Discoverer reports design and validations.
  • Delivered documentation and held Technology transfer sessions to BI Discoverer developers.
Project Name: GE CFS Europe Jan’05 - Oct’05

ClientConfidential
EnvironmentOracle ERP 11.5.8(GL, AP and PO), Forms 6i, Reports 6i, Discoverer 6i, TOAD

Role: Designation & Description
Working as a technical SPOC for Confidential

Involved in PO and AP rollout process.
Team Size 15

Responsibilities:

  • Possessed good understanding of the entire Procure to Pay Process from Requisition to RFQ to Purchase Order
  • Involved in defining PO setups like Financials, PO options and Receiving options.
  • Involved in creation of Suppliers, Payment terms, Distribution set.
  • Involved in Defining Buyers, Approved Suppliers list, Sourcing rules and Assignments.
  • Developed custom Invoice interface and Suppliers Interface for AP /PO.
  • Developing/customization of Reports such as EFTs, PO conversion error.
  • Designing Technical specifications for Customizations.
  • Designed and Developed in automation of Cross charge in GL
  • Worked on Discoverer reports migration (from Discoverer 3 to 4i).
  • Implemented Auto Reconciliation program for GL module.

Education:

  • B.Tech
  • Oracle 9i Certified Associate
  • Certified Oracle e-Business Suite Technical Integration Champion

Hire Now