We provide IT Staff Augmentation Services!

Sr. Oracle Ebs Techno Functional Consultant Resume

Woodcliff Lake, NJ

SUMMARY

  • Experienced IT professional with extensive experience in Oracle Applications Assignments (Implementations, Production Support, Enhancements, Development and Customizations).
  • Over 18 years of experience in IT industry that includes Techno - Functional in Oracle ERP for over 14 years. Worked in various roles such as Business Analyst, Project Manager, Project Lead, Team lead, Release Manager, Config Manager, Consultant and as Developer.
  • Extensive experience in P2P, Supply chain, Financials, Order to Cash & Manufacturing Modules (PO, INV, WIP, BOM, OM, AP, AR, GL, CE, iSupplier, iProcurement and Services (CRM).
  • Extensive knowledge project life cycle in Implementation, support, Migrations, Upgrade, Maintenance and Testing of Oracle Applications.
  • Strong experience in Oracle Database, Oracle Tools like Discoverer, SQL* Loader, PL/SQL and adequate exposure to Reports & Forms. Proficient in using utilities like Data-load etc which are used in system setup
  • Extensive experience in Oracle open interface tables. Held positions where major responsibilities included coding and unit testing reports, interfaces, conversions and Extensions (RICE) of programs in an Oracle Applications environment
  • Extensively worked on AIM documents like BR100, MD050, MD070 and CV40.
  • Expert level knowledge on User Management, AOL objects, Approval Management (AME).
  • Experienced in developing and customizing various workflows and well versed using components like Workflow Builder and Workflow administrator.
  • Performed numerous designs and developed Conversions and interfaces from legacy systems/third party systems into Oracle Applications.
  • Extensive experience in identifying product gaps coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored SR/TARs.
  • Expertise in planning, estimation, presentation and developing design documentation using the AIM Methodology, MS Visio, MS Project, etc
  • Extensively worked in conversions and interfaces, using standard interfaces and APIs.
  • Expertise in Customizing Oracle reports and developing custom reports.
  • Involved in 4 implementations, which includes full-cycle implementations. As well provided support during go live critical times and post-production maintenance phase to different clients.
  • Extensive experience in PL/SQL procedures, functions, packages, triggers, UTL File, UNIX and Shell scripting
  • Understanding the Oracle Applications base Tables, Views and Workflows for the Troubleshooting and resolution of Production issues.
  • Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
  • Experience in System Administration activities like creation and maintenance of users, creating & assigning responsibilities, changing profile options, Setting up vacation rules, Alerts etc.,
  • Expert in coordinating with various teams that includes legacy systems, users, DBA team, clients and app-leads enabling competent production support
  • Ensured all Project deliverables are of high quality before implementing them to the production environment. Adhering to SLAs. FTR(First Time Right) and OND(On Time Delivery)
  • Very good exposure in working at various geographical locations via USA, Europe and India
  • Extensive experience in Conducting CRP’s and provided wide range of functional training to multiple business user groups and co-ordinate UAT sessions.
  • Proficient in authoring documentation of AIM methodology such as BR100, MD50, MD70, CV4, TE40 and others.
  • Strong problem solving, Analytical skills & ability to work in a time-constrained and team-oriented environment.
  • Ability to perform as an individual and in team environments with proven communication and interpersonal skills.
  • Oracle R12 Financials and Supply Chain (SCM)
  • Extensive Experience in System Development Life Cycle
  • Expert in Application Object Library and AME
  • AIM Methodology and documentation
  • 11i Support and Upgrade Experience
  • Implementing and developing integrations using FAH.
  • Expert in various Reporting Tools Including BI Publisher, Discoverer, OBIEE and Crystal Reports

TECHNICAL SKILLS

ERP Systems: Oracle Applications 10.7/11.0.3/11 i/R12 (PO, INV, WIP, BOM, OM, AP, AR, GL, CE and Services (CRM))

Oracle Database: Oracle 7.x/8.i/9i/10g/11g

Database Tools: Developer 2k, Forms 6i/10g, Reports 6i/ 10g, Oracle Work Flow, TOAD, TORAVB, OPO, SQR, Crystal Reports

Programming Languages: C, COBOL, HTML, SQL/PLSQL

Operating Systems: SCO UNIX, Linux Windows NT, Windows 98/95/3.1

ETL Tools: Informatica, Abinitio, Teradata

Application knowledge: Financials, Manufacturing, Supply Chain & P2P.

PROFESSIONAL EXPERIENCE

Confidential, Woodcliff Lake,NJ

Sr. Oracle EBS Techno Functional Consultant

Responsibilities:

  • Interacting with Client IT and core application system users and development & teams to finalize schedules plans, solution and requirements.
  • Take the ownership of tickets logged by users and responsible for closing them on time.
  • Lead a team of developers to deliver and support RICE components related OE, AR, PO, AP, i-Procurement, GL & INV modules.
  • Taken care of admin activities like setting up the users, assigning responsibilities and profiles.
  • Extensively involved in creating setting up employee and end dating them when they were terminated.
  • Depending on the workload I was involved in code fixes, for interfaces and reports.
  • Identified various reporting needs and converted various standard oracle reports to Excel version using XML Publisher Administrator, including Accounts Payable Trail Balance, Cash In Transit, Invoices on Hold, Invoice Register etc.,
  • Developed various OAF custom forms for Black box mapping tables in query and update mode.
  • Designed and developed workflow extensions for Invoice holds in case of overbilled PO to reroute action required notifications to Buyers and AP processing groups.
  • Resolved various issues with 1099 reporting around duplicate TIN, Missing TIN, and Missing address component etc., of supplier master, working closely with business. Obtained the Oracle standard 1099 comma delimited file for further processing.
  • Working closely with business users resolved various issues with Supplier Master Data. Mainly focused on cleaning up unused sites, merging wrong sites, merging suppliers, cleaning up addresses, provisioning EFTs by enabling bank details at site level.
  • Developed various integrations into oracle P2P for invoice interface and requisition import.
  • Developed various reports for reconciliation and error correction for AP, GL Interfaces at summary and detail level. Developed scripts to circulate the reports on a regular basis using email.
  • Experience in accounting open and close period which are part of month end activities.
  • Worked closely with business users for setting up custom Order types and also there vacation rules to be forwarded for approvals.
  • Involved in system improvements processes & troubleshooting workflow mainly related to approvals for requisitions and purchase orders.
  • Involved in release activities like collecting objects, smoke testing and releasing to DBA’s.

Environment: Oracle Applications 11.5.10.2 (AP, PO, AR, GL, OE, INV, AOL, iProcurement, iExpense), Oracle Database 10g, SQL/PLSQL, Forms Builder 10g, Reports Builder 10g, Discoverer 4i, XML Publisher, Workflow Builder, SQL*Loader, UNIX Shell Scripting, Rational Clear Case, Mercury Service Center.

Confidential, Horsham, PA

Oracle EBS Techno Functional Consultant

Responsibilities:

  • Interacting with Client IT and Functional teams to finalize schedules plans, solution and requirements.
  • Led process improvement focus groups as part of performance improvements in the area of regular interfaces and reports.
  • Managed a team of developers to deliver the RICE components related to AP, AR, GL, OE, PO, INV and HRMS on multiple oracle applications 11i/R12.
  • Taken ownership of tickets logged by users and responsible for closing them before expected time.
  • Involved in release activities like collecting objects, smoke testing and releasing to DBA’s.
  • Lead system enhancement projects with activities like planning, distribution/ assigning work to enhancement team.
  • Created various documentation and training material using User Productivity Kit (UPK)
  • Involved in Training of various user groups on the new functionality and process changes from 11i to R12.
  • Resolved various issues with 1099 reporting around duplicate TIN, Missing TIN, and Missing address component etc., of supplier master, working closely with business. Obtained the Oracle standard 1099 comma delimited file for further processing.
  • Working closely with business users resolved various issues with Supplier Master Data. Mainly focused on cleaning up unused sites, merging wrong sites, merging suppliers, cleaning up addresses, provisioning EFTs by enabling bank details at site level.
  • Actively worked in collaboration with oracle support team and Development team. Coordinated activities for resolving various bugs, opening Service Requests, working 24/7 on production critical issues, participating in OWC sessions and analyzing patches.

Environment: Oracle Applications 11i/R12.1.3 (AP, PO, AR, GL, OM, INV, AOL, iProcurement, iExpense), Oracle Database 10g/11g, SQL/PLSQL, XML Publisher, HP Quality Center, Service Manager, Kintana, MS Projects, UPK.

Confidential

Project Lead/Principal Consultant

Responsibilities:

  • Involved in various design and decision making meetings with Global Process Owners, Financial System Optimization, Data Governance, Controllership and Transformation teams.
  • Played a major role in implementing major releases (R1, R2, R2.5 & R3) on oracle Applications R12 Financials modules AP, GL, CE.
  • Authored various Technical specification documents and designed custom interfaces and extensions as required for the DAY1 Go live.
  • Interacting with Client IT and Functional teams to finalize schedules plans, solution and requirements.
  • Involved in Requirements Gathering, Functional Design, Gap Analysis, Data Mapping, Resourcing, Design & Modeling, business process re-engineering using AIM methodology.
  • Analyzed Control, Technical, Audit reports and customizations to be taken forward in the scope.
  • Involved in work allocation as identified in project plan.
  • Lead multiple teams (Build, Functional, Testing and UAT) and took charge of billing and OT activities for more than 50 resources.
  • Work with Management Team to identify process improvements, impact assessments and to provide impacts.
  • Managed incidents rose with testing/UAT phases, validate a defect and assign it to the appropriate team for the fix.
  • Lead a team of developers to deliver the RICE objects.
  • As and when required was involved in patch released as per project plan.
  • Depending on the resource utilization and workload, I used to get involved in development/defect fix for most of the RICE components defects that were found in testing phases.
  • Extensively was involved in functional config activities for the weekend releases.
  • Updated & maintain Configurations documents BR100 when functional resources were unavailable.
  • Involved in release activities like collecting objects, code configuration in star teams, smoke testing and releasing to DBA’s.
  • Mentoring the team mates for support day to day activities.
  • Interacted and worked with the functional team to solve various code bugs and develop new functionality enhancements required as part of the go-live.
  • Redesigned automatic reversal process to accommodate FAH reversals during month end and processing.
  • Extensively tested various OBIEE reports and designed them to work as per client business needs.
  • Developed various forms custom extensions for Journal approval.
  • Developed Journal Approval workflow customizations as per client requirement.
  • Actively worked in collaboration with oracle support team for resolving various bugs, opening Service Requests, working 24/7 on production critical issues, participating in OWC sessions and analyzing patches.

Environment: Oracle Applications R12.1.3 (AP, PO, AR, GL, iProcurement, iExpense, FAH, CE), IBM AIX, Start Team, AIM Documentation, Oracle Database 11g, OBIEE, SQL/PLSQL, HP Quality Center

Confidential, Denver, CO

Project Lead

Responsibilities:

  • Interacting with Client IT and Functional teams to finalize schedules plans, solution and requirements.
  • Involved in recruiting offshore team of 15 techno functional Resources.
  • Involved in Requirements Gathering, Functional Design, Gap Analysis, Data Mapping, Design &Modeling, business process re-engineering using AIM methodology.
  • Attended OA Framework (OAF) training for designing new pages and customizing existing pages.
  • Involved in pre-implementation and support activities related to financial modules (AP, AR, i-supplier, GL, and CE).
  • Mentoring the Onsite and offshore team for completing the tasks assigned to them.
  • Providing solutions for the GAPS identified in the post Go live system.
  • Worked on post implementation interfaces such as Scrambling (Banks, Customers, Suppliers).
  • Supported VIGO AP, AR, GL and PO modules as part of take over integration with WU instances.
  • Interacting with the On-Site coordinator for finalization the change requests, fixing bugs/issue resolutions.
  • Working on support for Incident management using Digital Workflow/ Ticket Tracker.
  • Worked extensively for the enhancements for new developments for inbound outbound and reports.
  • Involved in release activities like collecting objects, code configuring, smoke testing and releasing to DBA’s.
  • Coordinating with the DBA for migrating the fixes/ new objects.
  • Supporting for defect/bug fixes in the current system.
  • Giving Knowledge Transfer to Peers.

Environment: Oracle Applications R12.1.1, 11.5.10 (AP, PO, AR, GL, isupplier, iExpense, CE), SUN Solaris, AIM Documentation, Oracle Database, 9i, 10g,, SQL/PLSQL, HP Quality Center, Start Teams

Confidential

Team Lead Oracle EBS Techno Functional Consultant.

Responsibilities:

  • Extensively involved in all phases implementation of oracle applications 11i in SCM & P2P modules.
  • Prepared requirement documents and assisted the build team in working with technical documents and build of conversions, Interfaces and Reports.
  • Involved in Setups of multiple environments (DEV,PUAT, BUAT, PRE-PROD, PROD, MASTER )
  • Involved in Setups of Multiple environments of Data migration (DR5, DR6, CUTOVER, PROD).
  • Supported Data migration team for completing the process tasks related to technical & functional areas.
  • Provided solutions for the GAPS identified in the post Go Live system.
  • Assist with design of solutions for change requests and the development there after.
  • Provided functional support for Confidential Testing Team & Users after Go Live.
  • Resolution of incidents with in stated SLA’s.
  • Managed incidents rose with oracle support for issues that required a TAR to be raised.
  • Mentoring the team mates for support.
  • Provided functional & technical support to Ascension Supply chain (Oracle SCM) Solution Confidential Users.
  • Assist with design of solutions for change requests.
  • Assist with development and testing solutions for supply chain.
  • Managed incidents rose with oracle support for issues that required a TAR to be raised.
  • Maintenance of reference data on the system namely Items, Projects, Users & people Records.
  • Managed interface between supply chain and PFC legacy system.
  • Mentoring the team mates for support.
  • Lead Role to manage the customization project at offshore.
  • Responsible for timely deliveries of RICE objects.
  • Drafting Technical Specifications on the basis of Functional Specs for Project Accounting, PO, INV, BOM & work flow.
  • Functional help in Checking Setups & test data and supporting the team in all phases.
  • Testing
  • Responsible for the interfaces, conversions, Routine Loaders, Workflow, Reports and working with SCM form customizations.

Environment: Oracle Applications 11.5.9 (AP, PO, AR, GL, FA, FSG, CE), AIM Documentation, Oracle Database, 9i, SQL/PLSQL, SUN Solaris, SCCS.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

  • The Project involved in the Implementation of Oracle applications 11i (11.5.6) modules like GL, AR, AP, OM, BOM, INV, PO, Services (CRM) .
  • Exclusive interaction with client & Functional for acceptance and freezing Functional specifications.
  • Responsible for the interfaces, conversions, Routine Loaders, Workflow, Reports and working with CRM form customizations.
  • As an offshore coordinator for Confidential, Involved in Analysis and Designing the Technical Specifications for interfaces, conversion programs, Reports and routine loaders. Also involved in the discussion with client for language conversion.
  • Responsible for providing product solutions for developing quickupgrade tool.
  • Supported the custom CRM form development in the Bug fixings.
  • Responsible for the releases into CRP3 to Production.
  • Environment: Oracle Applications 11.5.6 (GL, AR, AP, OM, BOM, INV, PO, Services (CRM)), AIM Documentation, SUN Solaris, Oracle Database, 9i, SQL/PLSQL, SCCS.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

  • Responsible for providing production support, creation of HLD, LLD, Construction, UTP preparation for Confidential project.
  • The project involves providing production support and taking up maintenance requests for Confidential after sales order management system.
  • As an Offshore Coordinator / Developer for Confidential project, was responsible for migration their current reports in Oracle applications 10.7 to Oracle Applications 11i enhancing the application with latest features of Reports 6i and Oracle Applications 11i according to business rules of the current application. Development of new reports in 6i as per the specifications and Registration of the same in Oracle Applications 11i.
  • The Migration of Reports involves preparation of Mapping Documents (Finding the Corresponding Tables in 11i). Was involved in the migration of many reports successfully in various modules. Also responsible for Registration of the reports in Apps and preparing exhaustive test cases.
  • Changing the packages referenced or adding additional parameters or value sets. Registering these reports in 11i programs and testing the output against the output of 10.7 reports. Queries were needed to be modified and layouts modified wherever required. The queries were modified in SQL and re-tested before being compiled and used in the reports to ensure the report’s functionality is maintained as in 10.7.
  • Was Involved in GEAE. As it’s a development, maintenance and production support for Oracle Applications, it involves most of the manufacturing modules of Oracle Applications 11.0.3.

Environment: Oracle Applications 10.7, 11.0.3, 11i (INV, PO, OE, BOM, WIP), SCO UNIX, AIM Documentation, Oracle Database 8i, SQL/PLSQL.

Confidential

Technical Consultant

Responsibilities:

  • Developed custom reports using Oracle reports 6i to summarize the buyer (employee) details that hold a procurement card and the details like the card vendor, expiration date of the procurement card, Amount limit, procurement card program currency etc...
  • Developed custom reports to summarize the procurement card transactions based on the supplier, based on the buyer, based on the procurement card vendor etc...
  • Developed a custom workflow to notify the expiration date of a procurement card before ONE month of its expiry to the concerned authorities with in the organization and also to the procurement card vendor via e-mail.
  • Customized the Purchasing Account Generator workflow.
  • Designed and developed pre-interface tables and scripts to upload Purchase Order from legacy to Oracle application system.
  • Developed a report, which List all the receiving details, which are direct.
  • Customized a report which provides List of all the PO’s where Due date is gone beyond.
  • List of inventory items, already received and there receiving status, available and on hand Quantity present in various sub inventories.
  • Training the end users to use the application and standard workflows.
  • Testing the developed Forms and Reports.
  • Creation of new value sets and lookup codes in various modules of the applications.

Environment: Oracle Applications 11i PO, Oracle Database, 7i,D2K forms, Reports, SCO UNIX.

Hire Now