Oracle Applications EBS Techno-Functional Consultant

Srinivasan Rengarajan

**** **** *** *

APT NO.***

Minneapolis, MN 55423

Cell: 612-***-****

Email: **********.**********@*****.***

Oracle Applications EBS Techno-Functional Consultant

Creating innovative solutions in the area of Oracle EBS to scale up efficiency and business process

Top 5 Strengths: Ideation, Achiever, Futuristic, Strategic, Self-Assurance

PROFESSIONAL SUMMARY

Polished Oracle EBS 11i/R12 techno-functional consultant with 9 years of experience with demonstrated success and proven technical and functional skills in developing/delivering solutions in Implementation, Support, Upgrade and Roll-out projects for various clients by following SDLC methodologies. Recognized as an innovator and Team Player - Poised in high-pressure, fast-paced business environments with greater ability in mapping clients’ business requirements and translating it into functional & technical specifications and ensuring end-to-end delivery with maximum quality. Collaborates effectively with business partners, vendors and support staffs to plan and execute tasks. An enthusiastic and a quick learner to adapt new technologies. Powerful verbal and written communicator with strong inter-personal skills.

Reduced annual cost by $40,000 and manual business effort by 80% by implementing Web Application Desktop Integrator(WebADI) solutions

Reduced employee expenses auditing risk by 90% by creating a new custom auditing solution in Oracle iExpenses by creating OAF pages.

Streamlined business process and increased the business process efficiency by 100% by providing and delivering an end-to-end custom solution in the business platforms of iProcurement, Purchasing, Project Accounting and Account Payables by customizing Workflows, OAF Pages and creating new reports using Oracle Reports.

Created single custom reconciliation report to reconcile transaction level data between GL and other modules which saved 75% effort during month end, quarter end, half year-end and Year end close in Oracle XML Publisher reports.

Setup Audit Trails and created custom Audit Trail report to achieve 100% data accuracy while performing Third-party Audits at client company.

Effectively worked with vendor and applied patches to keep the environment up-to-date and fixed over 10,000+ known bugs in Oracle Financials, iProcurement, Purchasing and Projects modules

Trained over 50 fresh graduates to work effectively in Oracle e-Business space.

Won the most coveted award under the individual performer category “Accenture Celebrating Excellence” award for number one performer

Won the most prestigious award "The Biggest Impact" for delivering innovative solutions to client

Won “Accenture Stellar” award for client value creation

Won other project specific awards for delivering quality work

SKILLS

Oracle Reports 10g

Oracle Forms 10g

Oracle Workflow 2.6.3.5

Oracle Web Applications Desktop Integrator (WebADI)

Oracle Application Framework (OAF)

Unix Shell Scripting

SQL Loader

PLSQL/Advanced PLSQL programming

BI Publisher, XML Bursting

Interfaces, Conversions

Oracle Jdeveloper 10g

SQL

Java

Toad

SQL Developer

MS Office (Excel, Word, Power point)

Oracle Database 9i/10g/11g

HTML

Java Script

WScript

XML

Windows 7/8.1/10

Oracle iProcurement

Oracle Purchasing(P2P)

Oracle iSupplier

Oracle Account Payables

Oracle iExpenses

Oracle Project Management

Oracle Project Costing

Oracle Supplier Network (OSN)

Oracle XML Gateway

Oracle Approval Management Engine (AME)

Oracle Workflow Manager configurations

Oracle Application Object Libraries

Oracle Sub-Ledger Accounting

XML Message Designer

Oracle Sourcing

Account Receivables

Fixed Assets

Oracle Inventory

Oracle Asset Tracking

B2B

Move Orders

Order Management

HRMS

Oracle Application Express(APEX)

PROFESSIONAL HISTORY

Accenture LLP, Minneapolis, MN 06/17/2010 – Present

Oracle TechnoFunctional Consultant

Client: Best Buy, (~2 years)

Highly responsible position supporting entire Best Buy’s Oracle Financials and Procurement systems. Managed and delivered entire Oracle R12 EBS patching project. Utilized the expertise and clear decision making skills in handling multiple business areas for Best Buy. Ensured seamless business activities by timely coordinating with different teams and vendor teams. Ensured smooth period close activities and general ledger close for month, quarter and year-end. Trained all the team members in Oracle EBS procurement area to work independently. Increased the business efficiency significantly by providing and delivering innovative solutions

Successfully coordinated and delivered the patching projects and fixed over 10000+ bugs in Oracle EBS space and improved the period close process performance up to 75%

Provided innovative solution for email communication changes customization in Oracle iExpenses and increased the auditing efficiency by 60% by customizing iExpenses workflows

Provided custom solution to add terminated employees to the supervisor and claim expenses on behalf of the termed employee, the custom solution WebADI solution reduced the wait time by 100%

Provided innovative solution for Audit functionality for all the expense claims done in best buy by deploying a complete custom solution by creating new OAF pages.

Enhanced and implemented WebADI in PA module which saved more4Apps licensing cost by $40,000 annually.

Configured OSN and XML Gateway to send POs and receive invoices from suppliers, delivered custom maps using XML message designer to include one-time ship to addresses in the Trading partner XML data.

Ensured internal Accenture successful team management by defining new process towards support work.

Ensured successful period close of modules AP, PO, PA, FA and GL and provided necessary support to business

Successfully enhanced custom.pll in Account Payables (AP) forms to handle custom invoice holds.

Configured AME for iProcurement Requisition Transactions and iExpenses Transactions.

Worked on CSV, XML Publisher reports to report Open purchase orders by cost center, buyer and un-invoiced receipts.

Enhanced host program in UNIX shell scripts which kicks off programs from external job scheduling tools.

Client: AT&T (5 Months)

An R12 EBS Techno-functional position with higher responsibility of reviewing functional design and identifying the gaps and bridging it by providing expert advise and deliver it with optimum quality. Delivered high-quality OAF developments in Inventory and purchasing module. Recognized for people developer activities – provided constant training and assisted individuals on their complex deliveries to meet project deadlines.

Delivered a complex OAF customization to handle stocks in Inventory module with supreme quality

Delivered a vital interface customization for AT&T in Inventory Module

Developed a robust UNIX shell script to automate the migration process of all EBS deliverables

Achieved 60% better performance in an important AP Interface program by doing SQL Tuning

Client: NBN Co (4 Years 1 Month)

An all-rounder Oracle EBS R12 techno-functional position with supreme responsibility of delivery, Support, Enhancement Management and Technical Team Management. Delivered over 60 major enhancements and 2 full implementations in a stringent timeline by playing a role as a techno-functional consultant. Often recognized as Innovator, Team Player, Value Creator, People Developer and Business Operator. Won multiple prestigious awards for major contribution in the project. Ensured smooth delivery with stupendous quality and often received credit from the client. Created RFPs, conducted CRP, UAT sessions, presented innovative solutions to client.

Delivered an entire release for PA implementation by playing a techno-functional role in Sydney Australia

Delivered an entire release for Oracle Sourcing implementation by playing a technical role at offshore

Delivered a major customization to connect iProcurement, PO, PA and AP business by customizing PO workflows and iProcurement OAF pages which helped business to fasten the P2P operations as per their process

Delivered a custom PA Expenditure WebADI that mimics the subsequent validation programs and displays the error to the user, this helped business to rectify all the errors at first point and ensured smooth GL posting. 85% effort reduction was achieved by providing this innovative solution.

Achieved a major performance breakthrough for HR Interface, Audit Trail, AP Trail Balance by doing performance tuning.

Delivered an innovative report to reconcile between GL and the other modules which fastened up the period process by 75%

Configured AME to prevent Contingent workers from approving expense report and it was widely recognized by NBN Finance operations.

Configured sub-ledger accounting by creating new custom sources which helped to modify project related transactions at the sub-ledger level.

Delivered a complex OAF customization to accommodate changes pertaining to contingent worker process

Delivered complex customizations in PO Approval, Requisition Approval, PO Auto Create, Project Status Approval, Project Budget Approval, PO Work Confirmation approval, HR Self-Service Approval, PO and Requisition Change Order approval workflows in an innovative fashion

Provided a simple and innovative solution to integrate Oracle Projects with Primavera via web-services and delivered the same with optimum quality

Delivered a complex Fixed Asset Register report at granular level by combining PO, AP, PA, Inventory and OAT data which helped business to speed up their reconciliation activities in FA by 75%

Delivered interfaces, WebADIs, BI Publisher Reports, XML Bursting, SQL Loader, Form personalization in supply chain area.

Delivered a complex transaction reports Accounts Receivable in a short span of time

Delivered a complex migration script in UNIX shell scripting to migrate all the components including SLA configurations.

Delivered an innovative solution which helped business to successfully complete their external audit with 100% data accuracy by setting up Audit Trail and delivering dynamic single custom Audit trail reports for different modules.

Provided solution and created complex forms personalization to achieve SOD for Move Order forms

Achieved 0 incident tickets mark along with the inflow in 2 months after taking the lead role in PA functional team, provided solutions related to various project costing, asset capitalization, mass addition issues and also built various reports using BI(XML) Publisher, PL/SQL, SQL Loader and Host type executables.

Delivered complex OAF personalization in PA module to follow Segregation of duties(SOD) as per the client’s business process.

Trained over 50 individuals to independently work in Oracle EBS technical space and functional space

Won the most coveted award under the individual performer category “Accenture Celebrating Excellence” award for number one performer

Won the most prestigious award "The Biggest Impact" for delivering innovative solutions to client

Won “Accenture Stellar” award for client value creation

Won other project specific awards for delivering high quality work.

Infosys Technologies Ltd., (Mangalore, India) 12/24/2007 – 06/04/2010

Developer, Client: Ricoh (1 year)

Developer role mainly involved in Oracle EBS 11i CRM Service and Lease Contracts conversions and reconciliation development. Handled the entire conversion reconciliation single handedly as 80% of the client’s business was on Service and Lease contracts. Delivered 2 complete end to end reconciliation logic successfully for the 2 new companies acquired by Ricoh (InfoTech, IKON). Configured Oracle Application Express to show the reconciliation data to client.

Delivered robust reconciliation logic with 100% accuracy using Advanced PLSQL techniques for CRM service and lease contract modules single handedly to reconcile over 100 mn records

Delivered data validation and automation scripts for data conversions for Install base, field service, Service Contracts and Lease contracts

Improvised conversion and reconciliation runtime by performing tuning activities.

Developed dashboards in APEX to display the reconciliation data for Service Contracts and Field Service modules.

Developed automations to move DDL statements particular to a program across instances

Client: Exterran (1 year 6 months)

Developer role mainly involved in fixing issues and delivering minor enhancement in Oracle EBS 11i. Ensured the daily tasks are completed well before time. Constantly had discussions with supervisor on innovations and learning. Ensured all the onshore tasks are prioritized and completed on time with high level of accuracy.

Delivered a complex Quote approval workflow to follow client’s business process in Order Management

Delivered a new workflow to obtain approvals for credit card transactions

Delivered enhancements in COGS report in Order Management using Oracle Reports 6i with XML publisher

Delivered a major customization in custom.pll to change behaviors in OM form

Delivered OAF personalization which were critical to business process.

EDUCATIONAL QUALIFICATION

Bachelor of Engineering (B.E) in Electronics and Communication Engineering (2003-2007) from Anna University

Chennai, India

WORK AUTHORIZATION

H1B Visa

Contact this candidate