Varaha Narasimha Kiran Kumar

Mobile:732-***-****

E-mail: adwced@r.postjobfree.com

Summary:

Experienced Oracle EBS Techno Functional Lead, with 15+ years of cumulative experience in enterprise software development, with most recent in the design, implementation, customization,Upgrades and management of Oracle ERP applications. Well versed in managing the lifecycle of Oracle ERP implementations, (10.7/11i,R12) complemented by deep functional knowledge of various EBS modules, and Oracle Application architecture. Proficient in software development methodologies and enterprise change management processes. Known for strong business skills and for balancing the big picture with detailed implementation plans.

Having excellent experience in development & maintenance of Oracle Applications R12, 11i & Oracle Financials, SCM as Techno Functional consultant involving in implementations and support in the BI reports/XML reports

Expertise in Data Conversions in Financials and SCM Modules.

Experience in Web Services, SOAP, WSDL and Integration with RESTFUL services, SOA Gateway and EDI.

Involved troubleshoot Financials/Procurement functional issues in Production and provide quick resolution guide the users for any navigational and training issues in Oracle Financials/Procurement .

Excellent Knowledge on defining ESS jobs for custom BI Publisher Reports in various modules

Good Technical skills in developing RICE Components in the domain of Oracle Applications E-Business Suite.

Areas of expertise include technical developments in Order Management,Inventory,Procurement,Accounts Receivable, Accounts Payable, Payments, Cash Management, Fixed Assets, General Ledger, iExpenses, Sub-Ledger Accounting, Tax of ERP modules

Good functional knowledge in Order to Cash(O2C) and Procure to Pay(P2P) cycles

Having two full life cycle implementation experience with exposure to implementation methodologies-AIM

Having good knowledge on MD and CV documents for various components, good experience in development of functional/technical design documents.

Experience in Implementation, Migration and Support Projects

Rich experience in registration/migration of RICE components (Forms, Reports, Conversion, Extensions), PLSQL programs, Oracle Discoverer and BI/XML Publisher bursting Reports

Expertise with Oracle Workflow, Workflow and Notification administration, Workflow Builder

Good Experience in registration of Menus, Functions, Value Sets and Concurrent programs

Having good knowledge on form personalization and customizing the forms using CUSTOM.pll

Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs

Well conversant in creation of database objects: Tables, Constraints, Packages, Stored procedures, Functions, triggers and Indexes using Oracle tools to bring business requirements to completion

Involved in performance tuning of several objects using hints and several other processes, analyzing Tkprof files and Explain Plan

Having good expertise in Preparing Technical Documents, Code Review Checklist (CRC), Test Plan and Test Results documents based on the user/customer requirements

Participate in Class Room Prototype (CRP) meetings for gap analysis

Good thorough understanding of system development process, from initial planning

Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the technical issues

Experience engaging Oracle Support(TAR) to research and resolve issues

Analytical and problem solving skills with ability to work independently when needed.

Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management and team building

Team Player with Excellent Technical, Communication, Interpersonal skills and Leadership abilities

Adopting new technologies, Very flexible and perform tasks are ad-hoc basis

Technical Skills:

PL/SQL, SQL, SQL Loader, iLoad,Oracle Reports, Oracle Forms, Forms Personalization,Discoverer,XML/BI Publisher,Oracle Oracle Workflows,XML/BI Publisher Reports,OAF

Cloud : Oracle Cloud (FBDI,OTBI,BI Publisher), AWS

ETL Tools: Cognos,Informatica

Modules Worked On: Financials –GL, AP, AR, CM, FA, E-Biz Tax, SLA,TCA, iExpenses.

SCM - PO, OM, INV, WSH, BOM, WIP, iProcurement,Costing.

OPM

Concepts - OTC,P2P.

Certifications:

AWS Certified Solutions Architect – Associate.

Work History

02/22 to Oracle EBS Techno Functional Lead Consultant

Till Date Equifax Inc.

Responsibilities:

Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team.

Involved in developing the objects/enhancements.

Developed Customer,Revrec,AR Transactions Interfaces,BCI Vertex Tax Integration programs.

Worked on Accounts Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.

Worked on Payables integration with Expenses module.

Building the SQL Queries. Worked on custom and customization of forms.

Developed PL/SQL Stored Procedures, Functions and Packages in Applications and Monitoring Modules.

Liaise between vendors and internal Project teams for business/Technical requirements.

Understands and assist with the diversity of user requests including flexibility with work assignments.

Strong internal-consulting relationships with managers and end-users in functional and technical areas

Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), and Conversion Test Plans (CV70).

Customized Invoice Form (AP) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.

Developed complex PL/SQL Procedures, Interfaces,Conversions using Apis,Functions, Packages and Database Triggers.

Written efficient, complex queries against very large data sets good knowledge of tuning of queries.

Reverse engineering of legacy systems and mapping it with Oracle EBS application

Providing post-production support to the end users on standard Oracle Application modules along with the customized Oracle Apps.

Worked on the Gl, AP, AR, PO, OM, Shipping process in order to streamline the business process and improve performance and efficiency.

Involved in developing/reviewing Data Conversions, Data Mapping, Data Extraction and Open interfaces related to Financials and SCM modules.

Developed BI reports for AP, AR, PO, OM Modules.

Developed adhoc queries,custom DB objects and AOL objects for the project.

Environment: Oracle EBS R12 (Accounts Receivables, Accounts Payables, Purchasing, Procurement, Expenses), BI Publisher, Workflow, SOA, Web Services, P2P Cycle, O2C Cycle, Unix, OAF.

10/20 to Oracle EBS Techno Functional Lead Consultant

02/2022 ATC Towers

Responsibilities:

Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team.

Involved in developing the objects/enhancements.

Liaise between vendors and internal Project teams for business/Technical requirements.

Understands and assist with the diversity of user requests including flexibility with work assignments.

Strong internal-consulting relationships with managers and end-users in functional and technical areas

Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), and Conversion Test Plans (CV70).

Developed complex PL/SQL Procedures, Interfaces,Conversions using Apis,Functions, Packages and Database Triggers.

Written efficient, complex queries against very large data sets good knowledge of tuning of queries.

Reverse engineering of legacy systems and mapping it with Oracle EBS application

Providing post-production support to the end users on standard Oracle Application modules along with the customized Oracle Apps.

Worked on the GL, AP, PO, AR, Advance Pricing, Shipping process in order to streamline the business process and improve performance and efficiency.

Involved in developing/reviewing Data Conversions, Data Mapping, Data Extraction and Open interfaces related to Financials modules.

Developed BI reports for stuck records in OM and INV tables and notify the same by sending email whoever submitted the request

Developed a custom AR monetization/factoring program in AR for the sales invoices to generate invoice file and repayment files.

Worked on OAF Personalization’s & OAF Extensions for iProcurement.

Developed custom DB objects and AOL objects for the project.

Supported production and non-production instances and coordinated with DBA's and other tech team for on time solutionProvided daily user support for financial modules and applied patches as and when required to resolve the application issues.

Environment: Oracle EBS –(GL,AP,AR,PO,FA, INV,PO,OM), PL/SQL, SQL,TOAD,EDI, Forms, OAF, Reports, Workflow, BI Publisher, SOA Gateway, SOAP/REST Web services.

06/19 to Oracle EBS Techno Functional Consultant

09/20 Marsh & McLennan Companies, Inc, NY

Responsibilities:

Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team

Involved in developing the objects/enhancements

Liaise between vendors and internal Project teams for business/Technical requirements.

Leading solution design for Financial modules

Involved in month end and year end closure activities

Build appropriate timelines and coordinate cross-functional teams and preparing high level and detail design document.

Actively participate and work with business analysts and business teams to understand and document technical requirements for projects, enhancements/ features and integrations.

Design and develop XML/BI Publisher Reports having Barcode and Bursting Functionality..

Design,Built,Test & Support Interfaces,Conversions and customization of workflows.

Engineered Autolockbox Interface and implemented the Line Level customization of payment receipts.

Involved in development of custom automated reports integrated between Oracle Ebs and Brio for the entire user population (15000+ users).

Oversees resource allocations and develop work plans. Managing projects, providing technical direction to all team members, and ensuring on-time delivery of all projects.

Provides timely feedback to Leadership on open issues and provide quick resolution

Understands and assist with the diversity of user requests including flexibility with work assignments.

Strong internal-consulting relationships with managers and end-users in functional and technical areas

Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), and Conversion Test Plans (CV70)

Developed complex PL/SQL Procedures, Interfaces,Conversions using Apis,Functions, Packages and Database Triggers

Written efficient, complex queries against very large data sets good knowledge of tuning of queries.

Reverse engineering of legacy systems and mapping it with Oracle EBS application

Providing post-production support to the end users on standard Oracle Application modules along with the customized Oracle Apps

Supported production and non-production instances and coordinated with DBA's and other tech team for on time solutionProvided daily user support for financial modules and applied patches as and when required to resolve the application issues

Experience in interacting with client/business and building the business requirements. Proficient in analyzing and translating business requirements to technical requirements and architecture the solution.

Environment: Oracle EBS –(GL,AP,AR,PO,FA, INV,PO,OM), PL/SQL, SQL,TOAD,EDI, Workflow, OAF, BI Publisher, JDeveloper, SOA Gateway, SOAP/REST Web services..

01/17 to Oracle EBS Techno Functional Consultant

03/19 Minerals Technologies Inc.,NY

Responsibilities:

Analysed, designed, documented and Integrated 3rd party system(Coupa) GL and AP modules

Determined business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.

Design,Built,Test & Support Interfaces,Conversions .

Outbound Interfaces - Designed and developed various PLSQL programs and registered them as concurrent programs to fetch the data and write to Comma Separated files in the predefined Server location for the extraction of files like Users, Chart of accounts, suppliers, Supplier sites and Payments

Inbound Interface: designed and developed AP Invoice creation in Oracle using batches and sending details to users with an alert using email bursting program Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables

Worked with integrated Oracle Application and their impacts on the General Ledger Sub-ledger Accounting. Worked with a multi-ledger Release R12 Applications configuration support multiple accounting treatments in a Global Oracle Applications instance

Reconciliation Reports for invoice details of loaded invoices and 3rd party system(Coupa) invoices

Developed Error handling Programs and sending alerts to respective business users

Inbound Interface: designed and developed Suppliers interface in Oracle from 3rd party system

Utilized UTL_FILE Utility for writing data to the file in middle tier

Utilized FND_LOAD for data migration of various system administration objects, between various instances such as Menus, Custom Responsibilities and Programs, Value Sets and others

Documented BR100, Functional Design(MD50), Technical Design(MD70), Testing Specification (TE40)

Involved in requirement gathering and analysis and design of the application

Worked with the client team to understand the current Business Process

Developed test plans and scripts and conducted testing for quality assurance

Integrated with 3rd Party Systems GL, AP modules in R12 Environment

Extensively worked on Migration and Testing of the Deliverables in different instances

Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location

Developed a program to import Purchase accruals and reversed accruals in the beginning of the next open period in General Ledger.

Developed OPM conversions like Formula,recipe,Recipe Validation Rules.

Environment: Oracle Financials (GL,AP,PO,OM and SLA, R12,OPM, Oracle 11g), PL/SQL, SQL,Forms, Reports, RICE, Workflow, OAF, Rest Web services.

07/13 to Oracle EBS Techno Functional Consultant

12/16 Clopay Corporation

Responsibilities:

Analyzed, designed and documented GL, OM, AR, AP, FA, SLA modules and Oracle Cloud (OIC)

Documented MD50, MD70 and configured applications

Closely worked and coordinated with the technical teams to deliver the solutions as per the functional designs and customizations

Developing the Test suite cases on SOAP UI

Involved in Migration from Dev environment to Test and UAT environments

To provide the best solutions for integrations did most of the proof of concepts and got approval from architecture team

Prepared functional design document OM Sales Order from legacy system

Developed BI Publisher Reports as per the client requirements

Designed customer conversion strategy, data mapping and development using APIs

Customized several standard oracle reports (Pick Slip Report, Invoice Print Selected Invoice) and developed custom reports we later converted into XML templates

Developed outbound interface to transfer the data from base tables to external System.

Developed an interface program to bring AR Receipts from Legacy system into AR interface table

Involved in Post Production Support for Oracle Financials Modules

Demonstrated solid problem-solving ability with unique combination of strong technical and functional skills and provided fast, efficient and accurate services

Managed team work from production support to implementation conversion activities and functional design on emerged business-needed enhancements (configuration or customizations)

Played instrumental role as Functional Lead in multiple multi-phased R12 projects successfully implemented Oracle Financials

Trained key functional users through multiple training sessions on all financial modules in both corporate office and international locations such as US, Mexico, Trinidad and Canada

Documented Business process JOB Aids

Presented solid and unique problem-solving ability of fulfilling client's large complicated business requirements by utilizing both functional and technical tools/skills

Environment: GL, OM, AR, AP, FA and SLA, R12.2.2, Oracle 11g, PL/SQL, SQL,EDI, PL/SQL, SQL,Forms, Reports, RICE, Workflow, OAF, Rest Web services.

08/10 to Oracle EBS Technical Consultant.

06/13 AHI Carriers.

Responsibilities:

Involved in the Customization and Development of Reports in XML Publisher which involves Bar Code Implementation.

Writing sql loader scripts and PL/SQL packages, procedures, functions for data conversion and interfaces for AP, OM,INV,AR,GL modules .

Development of Conversions,Outbound Interfaces.

Extensively developed XML Publisher(Oracle BI Publisher) reports in AP, Inv, OM modules.

Preparation of Unit Test Plan Document and performing test cases

Fixing issues while in conversion and interfaces in testing phase and after go-live Communicating with Users.

Implemented Financials (GL, AP, AR, CM) and SCM ( INV,PO,OM) as per business requirements.

Environment: Oracle EBS R12.2.0.1, Oracle10g, SQL Developer, SQL*Loader, UNIX, Unix Shell Script, SQL, PL/SQL, Forms 10g, Reports 10g, OAF, Jdeveloper11g, Workflow Builder 2.6, BI Publisher, Putty, WinSCP.

07/09 to Oracle EBS Technical Consultant.

07/10 Flowserve

Responsibilities:

Reviewed and approved any configuration change documentation for General Ledger (GL), Cash Management (CM), Accounting Receivables (AR) and Accounting Payables (AP).

Implementation of Oracle Property Manager including setup of Lease, space assignment, define Properties, Payment approvals, Export payments, payment options, payment terms, distribution set, payment format and banks

Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and packages for Oracle R12 Application extensions

Establish data conversion routines and executed scripts to convert GL, AP and FA data from legacy systems

Involved in code review, code migration and code testing

Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.

Coordinated with end users at all stages of implementation - CRPs, UAT, Go-Live, Support

Provide training and documentation to Oracle-ERP end users

Plan, develop and implement new Oracle-ERP related projects for improved, future system operation and enhancement.

Extensive experience engaging Oracle Support to research and resolve issues

Environment: Oracle Applications 11i/R12, Oracle 9i, Oracle 9i, Toad, SQL*Loader, UNIX, SQL, PL/SQL, Forms 6i, Reports 6i,Putty Oracle Discoverer,XML Publisher Reports

07/07 to Oracle Consultant.

10/08 CISCO

Responsibilities:

•Project involves the development of interfaces to import Cost Budget and Planned

•Cost from ASPT to Oracle Projects.

•Testing the Interfaces to import Cost Budget and planned Cost from ASPT to Oracle Projects in C3/Synergy and to baseline the cost budget.

•Worked on Support Tickets assigned, related to SCM Modules – OM, AP, PO, BOM, on priority basis.

•Performed the Code Change required to implement the Change Requests/Enhancements.

•Interacted with Functional Consultant and Business Users during Root Cause Analysis.

•Documenting the changes to the Technical Design Documents (MD 70, MD 120 etc.)

•Perform Unit Testing specific to the Changes performed on RICE objects.

Environment: Oracle Applications 11i, Oracle 9i, Oracle 9i,Toad, SQL*Loader, UNIX, SQL, PL/SQL, Reports 6i,Putty, Win SCP, SVN.

Education

Master Of Computer Applications from Andhra University,India.

Contact this candidate