Sanjeev Kumar Ekkaluri

Oracle Apps Techno-Functional Consultant

Professional Summary:

12.7 years of IT experience with last 10.7 years working as Oracle Techno/Functional in Oracle Applications E-Business Suite SCM/Financials/Manufacturing modules Release R12 (12.1.3,12.2.4), 11i (11.5.10.2) can work independently as well as in a Team Environments.

Strong Techno Functional Consultant in implementing, customizing, supporting and maintaining Oracle Applications /Oracle e-Business Suite R11i/R12 .The main concentration being in modules: Order Management (OM), Inventory (INV), WSH, WMS, MSCA(Mobile Supply Chain Application), BOM, WIP, ASCP, OTM, GTM, Oracle Customer Data Hub (CDH), Oracle Supplier Data Hub(SDH), MRP/MPS, Oracle Account Payables (AP), Oracle General Ledger (GL), Fixed Assets (FA), Oracle Cash Management (CM), Oracle Purchasing (PO), Project Accounting, Time and Labor, Trading Community Architecture (TCA), Application Object Library (AOL), System Administration and Workflow.

Responsible for Requirements gathering, Systems and Gap Analysis, Designing, Development, Implementation, Customization, Enhancements, Testing and Implementation of Oracle SCM/Financials/Manufacturing R12, 11i (11.5.10.2) Standard Applications Modules and Customized Applications in Oracle Applications Environment. Complete understanding of Software Development Life Cycle Processes.

Proficient in implementing, supporting and maintaining Procure to pay (P2P) process and Quote to Cash (Q2C) cycles, Supply Chain, Financial, Manufacturing and Distribution Modules.

Implementation and Support Experience in Oracle Customer Data Hub (CDH) and Trading Community Architecture (TCA).

Competent in full understanding of the functionality of core Oracle Financial Modules (GL, AP, AR, CM, FA, I-Proc, I-Exp) and their interplay in the application set-ups and overall accounting structure of an organization with its sub organizations.

Experience in analysis, design, build and test of Oracle Application Framework (OAF).

Expertise in using Oracle 8i/9i/10g and 11g databases.

Experience in designing web pages through Oracle Application Framework (OAF) using Jdeveloper 9i, 10g, 11g and 12c.

Experience in designing and developing Mobile applications using Application Development Framework (ADF) using Jdeveloper 11g and 12c.

Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.

Hands-on experience with Oracle APEX 3.2/4.0/4.1 (Oracle Application Express).

Expertise in SQL and PL/SQL programming to develop stored procedures, functions, packages and triggers.

Extensive experience in Design, Development and Testing of Oracle Reports/Oracle Forms.

Very good experience on Oracle Service Oriented Architecture (SOA) and Business Process Execution Language (BPEL).

Study of current business processes, future business flows, connectivity with 3rd party applications if any and identification of gaps and workarounds.

Business requirement mappings for INV, OM, WSH, WMS and MSCA

Designing Oracle Applications Inventory and operating structure of client organization (multi-org structure)

Setup of Inventory, Order Management, Warehouse Management Systems and Mobile Supply Chain Application

Data migration from legacy systems using APIs and Open Interfaces.

Worked in multiple Integrations using Oracle Advanced Queuing.

Implementation and Support Experience in OTM/GTM Modules integration with Oracle Application Modules.

Worked in SOA Integration Project, where SOA integration replacing the existing TIBCO integration.

Strong experience and expertise in OBI/XML and BI Publisher and Form Personalization's

Worked with Concurrent programs, PL/SQL API's.

Expertise in Code Migrations using KINTANA tool.

Experience in supporting Sabrix/Vertex/EBTax Tax Engines.

Experience in Java Programming (Servlets, JDBC, JSP, Web Services)

Well versed with AIM Methodology and documenting the work done in a well-fashioned manner.

Worked with Oracle Utilities like SQL*Loader, UTL File, Toad, Putty and other utilities like SQL developer and data Studio.

Ability to manage time spent on multiple projects to meet deadlines. Ability to work independently and as part of a team.

Excellent analytical, presentation, and communication skills. Strong logic, solid business acumen, Strong leadership, facilitation and organizational skills

Technical leadership with responsibility for delivering technical services and delivery of Quality data on time. Act as a technical liaison with project team members and managers to drive the Technical aspects of project delivery.

Writing and maintaining Technical Specification document MD70 and Functional Specification document MD50.

Ability to effectively gather and refine report requirements from Users and Management and give appropriate attention to details. Proficient troubleshooting skills.

Professional Certifications:

Oracle PL/SQL Developer Certified Associate (OCA)

Oracle Forms Developer Certified Professional (OCP)

Diploma in NIIT (National Institute of Information Technology)

Technical Skills:

ERP : Oracle modules like OM, INV, BOM, WIP, ASCP, WSH, WMS, Quoting, AP, PO, FA, GL, CM, OPA, T&L, TCA, CDH, SDH, MRP/MPS, MSCA, Oracle Applied Technologies like Workflow, AOL, System Administrator, Oracle Applications 10.7, 11.0.3, Oracle Apps 11i (Versions 11.5.7, 11.5.9, 11.5.10, 11.5.10.2, R12)

RDBMS : Oracle 8i/9i/10g/11g

Tools &

Technologies : Oracle Application Framework (OAF), Demantra 7.1.1, Jdeveloper 9i/10g/11g/12c, Oracle Developer (Forms 6i/9i, Reports 6i/9i), Java, HTML, XML, Brio, Optio, Oracle Workflow 2.5/2.6, Toad, Putty, SQL Loader, SQL Developer, KINTANA, SOA Suite, BPEL Process, Application Development Framework (ADF), ADF Mobile, XML/BI Publisher, Oracle APEX

Operating System : Solaris, MS Windows (9x, NT, 2K, XP, 7, 8x), Linux and UNIX.

Languages : SQL, PL/SQL, UNIX Shell Programming, JAVA

Other Software : CVS, ARCS, KINTANA, StarTeam.

Educational Qualification:

Master of Computer Applications (MCA) from University of Madras

Professional Experience:

Client : Ciena Corporation, Hanover, MD, USA

Duration : Oct’15 – Jul’16

Project : CORE IT R12 Migration

Role : Oracle Apps Techno - Functional Consultant

Description:

Ciena Corporation is a United States-based global supplier of telecommunications networking equipment, software and services that support the delivery and transport of voice, video and data service. Its products are used in telecommunications networks operated by telecommunications service providers, cable operators, governments and enterprises.

Ciena sells products and services across four segments: Converged Packet Optical, Packet Networking, Optical Transport, and Software & Services. Key current platforms include the 6500 Packet-Optical Platform, 5430 Reconfigurable Switching System, CoreDirector Multiservice Optical Switch, 3000 family of service delivery switches, and the 4200 Advanced Services Platform. It also offers the Ciena One integrated network and service management software suite, consulting and support services, deployment services, maintenance and support services, spares and logistics management.

Responsibilities:

Extended the OAF page functionality for Customer and Supplier Forms Address Validation according to the client requirements.

Integrated Address Validation functionality with Trillium Software.

Developed Sales Order Conversion PL/SQL programs to update the Sales Orders for R12 Use.

Customizations, personalization and Extensions on Customers Online pages using Oracle Application Framework as per client requirement.

Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention

Design and maintain the business process in integration of Multiple Source Systems into CDH & SDH.

Involvement in Integration of Oracle R12 (CDH) system with outside vendors.

Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention

Used JDeveloper IDE for coding OAF Page Customizations for Address Validations.

Created Procedures, Functions and other database objects using SQL and PL/SQL.

Setups for Tax Validations and Geography Validations.

OTM/GTM Configurations, Agent Automations, Interface Programs, ITM Configurations.

Defining Concurrent Programs, Executables and Setups.

Writing Unit Test cases and testing after completion of the Object.

Supported all go-live activities and post-production troubleshooting.

Preparation of MD070 Technical specification documents based on Functional Specifications.

Preparation of BR100 and MD050 for the Business Requirements.

Environment: Oracle E-Business Suite R12, Oracle CDH, SDH, DQM, SCM modules like Quoting, OM, INV, BOM, WIP and WMS, OTM, GTM, Oracle Application framework, Oracle SOA, Jdeveloper11g, Solaris, Workflow Builder, Oracle11g, Developer Suite 10g, UNIX, Toad, SQL Developer.

Client : Move Inc., Westlake Village, CA, USA

Duration : Apr’15 – Oct’15

Project : Leapfrog

Role : Oracle Apps Techno - Functional Consultant

Description:

Move, Inc., a subsidiary of News Corp, is a leading provider of online real estate services and operates the Move network of real estate websites and mobile experiences for consumers and real estate professionals. The Move network reaches more than 40 million people per month and includes: realtor.com®, Moving.com™, SeniorHousingNet.comSM, Doorsteps®, ListHub™, Top Producer® Systems, TigerLead®, FiveStreetSM and others. The Move network also includes mobile experiences through its realtor.com® mobile real estate search applications for iPhone, iPad, Windows Phone 8, and Android, as well as the m.realtor.com website.

The Move network provides resources and tools for consumers and real estate professionals to help navigate all stages of the home-buying cycle. These tools give consumers access to the most comprehensive selection of existing homes for sale, property records, rentals, mortgage resources, senior housing options, moving resources and more.

Responsibilities:

Extended the OAF page functionality according to the client requirements.

Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.

Customizations, personalization and Extensions on Customers Online pages using Oracle Application Framework as per client requirement.

Created custom user interfaces to maintain Party, Location, Party sites, Party site extensions, Contact, Contact Points, Account, Account Sites, Customer profiles.

Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention

Design and maintain the business process in integration of Multiple Source Systems into CDH like Salesforce.com

Design and maintain the data cleansing process in CDH

Design and maintain the data enrichment process in CDH

Design the Word Replacements to standardize the Customer Master Data

Design, Fine Tune and maintain the Match Rules in CDH for De-duplication of Customer Master Data within Source systems and across source systems

Design multiple hierarchies for customer master data based on source systems and also based on DUNS Hierarchy

Architect the SST and survivorship rules in the merge process of the CDH de-duplication

Involvement in Integration of Oracle R12 (CDH) system with outside vendors.

Formulated SQL queries, functions and processes as per customization requirement for APEX.

Supported APEX applications and conducted performance tuning for PLSQL.

Contributed with database designs and assisted in increasing response time for APEX reports.

Designed application framework and developed Oracle APEX Application.

Provided APEX guidance and support to technical staff on application maintenance and SDLC process.

Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention

Used JDeveloper IDE for coding BPEL Process Models.

Developed different SOAP services and Web Services using WSDL, SOAP, AXIS, and Oracle JDeveloper

Involved in design and implementation of Oracle BPEL.

Involved in design and implementation of Web Services.

Configured E-Mail Notifications for a BPEL Process.

Experience with Oracle environment using JDeveloper, and SOA suite.

Loaded workflows, replace seeded workflows, ran workflow maintenance scripts against database

Customized MSCA Label Bar Code for Multi language Environment and Developed Scripts using PL/SQL.

Created Procedures, Functions and other database objects using SQL and PL/SQL.

Defining Concurrent Programs, Executables and Setups.

Writing Unit Test cases and testing after completion of the Object.

Supported all go-live activities and post-production troubleshooting.

Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite R12, Oracle CDH, DQM, SCM modules like Quoting, OM, INV, BOM, WIP and WMS, OTM, GTM, Oracle Application framework, Oracle SOA, Jdeveloper9i/10g/11g, Solaris, Workflow Builder, Oracle9i/10g/11g, Oracle APEX, Developer 2000, UNIX, Toad, SQL Developer.

Client : Beckman Coulter, Brea, CA, USA

Duration : Jan’11 – Mar’15

Project : Beckman Coulter

Role : Oracle Apps SCM Techno - Functional Consultant

Description:

Beckman Coulter, Inc. (BCI), based in Fullerton, California, develops, manufactures and markets instruments that simplify, automate and innovate complex biomedical tests. More than 200,000 Beckman Coulter systems operate in laboratories around the world, supplying critical information for improving patient health and reducing the cost of care.

From integrated laboratory automation solutions to centrifuges and blood analyzers to diagnostic rapid-test kits, the Company's instruments and reagents are used throughout the world in all phases of the battle against disease. Beckman Coulters for our systems include pharmaceutical and biotechnology companies, universities, medical schools and research institutions, hospitals, physicians’ offices and diagnostic reference laboratories throughout the world.

Responsibilities:

Team Lead of Managing a team of 10 members in the Offshore to lead development of formalized solution methodologies.

Onsite coordination with Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.

Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)

Extended the OAF page functionality according to the client requirements.

Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.

Involved in end to end testing from Quote Creation to Order and Order to Cash.

Customizations, personalization and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.

Created custom user interfaces to maintain Party, Location, Party sites, Party site extensions, Contact, Contact Points, Account, Account Sites, Customer profiles.

Designed and Developed asset tracking application using Oracle Application Express (APEX).

Worked on Oracle APEX for development of functional capability

Worked on TCA and Supplier integration.

Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention

Design, development and deployment of Web Services was done using Oracle BPEL, JAVA, and XML (WSDLs)Created a Human Task in BPEL, defined users, worked on Notification Services.

Used JDeveloper IDE for coding BPEL Process Models.

Implemented Exception Handling for the BPEL Process models to handle System, Business exceptions and used Compensation handlers to handle the transaction if an exception occurs.

Developed middle ware solution for interfaces using BPEL Process Manager and Jdeveloper.

Developed WSDL for BPEL process, partner links and BPEL process templates.

Implement old processes into new modules and make sure all the business needs are addressed.

Extended the MSCA page functionality according to the requirement.

Worked in implementation of OTM/GTM to Client

Configuring OTM, transportation planning and Modeled OTM scenarios.

Configuring GTM, including trade item classification, restricted party screening, license and document determination and management.

Kewill Interface, EDI Interfaces through TIBCO.

Worked on multiple Carrier Integrations using Oracle Advanced Queuing.

Created Concurrent Programs to move/place Files from One server to other Servers through FTP.

Created Procedures, Functions and other database objects using SQL and PL/SQL.

Defining Concurrent Programs, Executables.

Writing Unit Test cases and testing after completion of the Object.

Supported all go-live activities and post-production troubleshooting.

Preparation of MD070 Technical specification documents based on Functional Specifications.

Worked in the integration Project, where SOA integration replacing the existing TIBCO integration.

Environment: Oracle E-Business Suite [11.5.10]/R12, Oracle modules like Quoting, OM, INV, BOM, WIP and WMS, OTM, GTM, CDH, TCA, Oracle Application framework, Oracle SOA, Jdeveloper9i/10g/11g, Solaris, Workflow Builder, Demantra 7.1.1, Oracle9i/10g/11g, Oracle APEX, Developer 2000, UNIX, Toad, SQL Developer.

Client : Oracle, Redwood Shores, CA, USA

Duration : Jul ’10 - Dec ’10

Project : Oracle SCM

Role : Oracle Apps Techno - Functional Consultant

Description:

Oracle SCM – Quoting Hardware Functionality Implementation is done for Internal Oracle after the Sun acquisition by Oracle Corporation. Quoting Hardware Configuration is the first time where Oracle is implementing for its own systems.

Responsibilities:

Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walk through.

Extended the OAF page functionality according to the client requirements.

Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects).

Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.

Collecting Oracle’s Business requirement and Leveraging with Oracle Applications

Involved in end to end testing from Quote Creation to Order.

Customizations, personalizations and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.

Created Procedures, Functions and other database objects using SQL and PL/SQL.

Defining Concurrent Programs, Executables.

Writing Unit Test cases and testing after completion of the Object.

Supported all go-live activities and post-production troubleshooting.

Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite [R12 (12.1.3)], Oracle SCM modules like Quoting, OM and OIP, Oracle Application framework, Jdeveloper9i/10g, Solaris, Workflow Builder, Oracle9i/10g, Developer 2000, UNIX, Toad, SQL Developer.

Client : Sun Microsystems Inc, Santa Clara, CA, USA

Duration : Nov'07- Jun’10

Project : Integrated Business Information System (IBIS)

Role : Oracle Apps Techno - Functional Consultant

Description:

World’s Biggest Integration Project Integrated Business Information System aimed towards Integrating 800+ applications into 50 applications using Oracle Applications. IBIS is the Modern view of Sun’s Business

Responsibilities:

Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs.

Developing custom interfaces between various Applications for integration.

Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.

Created Concurrent Programs to move/place Files from One server to other Servers through FTP

Collecting Sun’s Business requirement and Leveraging with Oracle Applications

Created setups for Oracle SCM & Financial Modules like OM, INV, AP, FA, PO, GL, iExpenses and iProcurement.

Customizing iExpenses and iProcurement web pages using Oracle Application Framework as per client requirement.

Created Procedures, Functions and other database objects using SQL and PL/SQL.

Defining Concurrent Programs, Executables.

Customization and development Reports as per client requirements.

Writing Unit Test cases and testing after completion of the Object.

Supported all go-live activities and post-production troubleshooting.

Provided support to the users on the regular basis regarding their financial 11i systems. The issues covered GL, AP, PO, GL, FA, AR and System Administration modules.

Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite [R11i (11.5.10)], Oracle SCM & Financial Modules like OM, INV, AP, FA, GL, CM, PO, iExpenses, iProcurement and OPA, Oracle Application framework, Jdeveloper9i/10g, Solaris, Workflow Builder, Oracle9i/10g, Developer 2000, UNIX and Toad.

Client : Sun Microsystems Inc, Santa Clara, CA, USA

Duration : Aug ’05- Nov ’07

Project : Sun Business Production Support

Role : Sr. Application Developer

Description:

Project Aimed towards providing Sun Microsystems with solutions to a wide range of long and short term accounting system issues. Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting need. Let’s run to process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payment. Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.

Responsibilities

Technical and Functional support for Period close and Quarter close for Sun Microsystems business

Defining Concurrent Programs, Executables into Oracle financials through AOL and System Administration.

Customization and development of Reports.

Customization and development of Forms.

PL/SQL method of submitting Concurrent programs.

Working with business to resolve the critical issues

Writing Unit Test cases and testing after completion of the Object.

Created Concurrent Programs to move/place Files from One server to other Servers through FTP

Developing scripts to provide adhoc reporting to business using Brio.

Modified workflows to make the required changes as per business requirements.

Providing production support as needed, and tracking of end user’s business issues.

Configuring AOL setup in Oracle Applications 11i, registering Executables, Concurrent programs, assigning in Request Groups.

Supported Sun Applications like POLAR, SOLAR, SUNTEA etc.

Preparation of MD070 Technical specification documents based on Functional Specifications.

Understanding the Report functionality, Analysis and Review of High Level documents mainly MD050 Functional Specification.

Analysis of the GL/FA/PO Processes and Resolving of the various defects discovered through analysis.

Environment: Oracle Applications 10.7, 11.0.3, Oracle E-Business Suite [R11i (11.5.9)], Oracle Modules like OM, TCA, INV, AP, GL, FA, PO, CM, Solaris, Workflow Builder, Developer 2000, Oracle8i/9i, Toad and UNIX.

Company : Cicil Technologies

Duration : Oct ’04- Aug ’05

Project : Oracle Financial Applications Support

Role : Oracle Developer

Description:

Project Aimed towards providing Cicil Technologies, support for Oracle Apps Financial Modules like AP, GL, PO, FA, CM, AR etc.

Responsibilities:

Providing production support as needed, and tracking of end user’s business issues.

Working with business to resolve the critical issues

Work with Oracle Tar (SR’s) Support to resolve issues affecting Business process

Streamlining issue handling process.

Getting involved in crisis call/tech calls and driving the issues to resolution

Analysis of the GL/FA/PO Processes and Resolving of the various defects discovered through analysis

Supporting Period close for Account Payables, General Ledger and also Quarter close.

Environment: Windows 2000, SQL, PL/SQL, Oracle E-Business Suite [R11i (11.5.9)], Oracle Financial Modules like AP, GL, PO, FA, CM, AR

Company : Zap InfoTech

Duration : Dec ’03- Sep ’04

Project : People Data Project

Role : Oracle Developer

Description:

Financial Reporting – PDP (People Data Project) is a web-based decision support system for data mart for HR, FLAG, Corporate Planning, ENS and WR for core people data, with its central purpose being reporting head count and people count by charge-to department, primary location, and sales categories for employees.

Responsibilities:

Registration of tables, columns, schema objects etc.

Designed and developed of GUI Screens according to sample forms and register the forms

Creation of key flex fields and descriptive flex fields

Developing database stored procedures, functions and packages

Oracle General Ledger Journal import using an utl_file and SQL*Loader.

Form Customization:

Experience in Customization of Oracle Applications Form

Adding the triggers in the Form level, Block level and Item level

Attached Descriptive Flex Field

Attached Calendar to the Data fields

Experience in customizing forms using Libraries Custom.pll, Appcore.pll, Appdaypk.pll, Fndsqf.pll

Created Query Find Window for Existing Window

Involved in other activities like:

Registration of Tables and Forms for custom applications.

Executing concurrent programs from PL/SQL.

Creation of Value sets in various Modules of the application.

Defining Menu and Reports.

Defining Concurrent Programs, Executables.

Concurrent Programming:

Used SQL * Loader utility to load data from legacy system to interface table to upload resource data in PO Module.

Developed various Package Procedures and Host programs.

Environment: Windows, SQL, PL/SQL, UNIX shell scripting, HTML, Oracle7.3/8i, Oracle Applications 11.5.7

Reference:

Furnished upon request

Contact this candidate