Resume

Sign in

Developer Oracle

Location:
Hyderabad, Telangana, India
Posted:
March 19, 2020

Contact this candidate

Resume:

SUDHEER KUMAR

adcdfa@r.postjobfree.com

740-***-****

Around 10 years of experience as Oracle Applications Finance/SCM/Manufacturing consultant with Technical and Functional Knowledge on Procure to Pay, Order to Cash, Receipt to Issue Cycles.

Extensive experience in different phases of SDLC like analyzing & Planning, designing, implementation and support for Oracle Supply Chain Management, Order Management (OM), Bills of Material (BOM), Work in Process (WIP), Manufacturing Scheduling /MRP, Warehouse Management (WMS).Purchasing (PO) along with iProcurement, Inventory (INV), Shipping Execution(WSH) and Pricing(QP).

Comprehensive experience in Customizing, Modification & developing of Forms, Reports using Oracle Form builder 6i & 10g, Oracle Report builder 6i & 10g and XML/Business Intelligence(BI) Publisher, Interfaces and Conversions. Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite R12/11i, Oracle 11g/10g, Oracle Forms 6i/10g, Oracle Reports 6i/10g, XML Publisher 5.6, Work Flow Builder 2.6, JDeveloper10g/11g OA Framework.

Good experience in handling different Application Object Library (AOL), sys admin & TCA Architecture.

Good experience in routing information according to user defined business rules using Oracle Workflow Builder.

Proficient working in onsite-offshore model with different teams like business users, developers, project managers, quality assurance, DBAs and Business Analysts.

Good Experience in preparing Technical Specification (MD70) Documents, SMTD (System maintenance & Technical Design Document), BR100, User Training Documents.

Strong analytical skill and problem-solving ability coupled with excellent written, verbal and inter-personnel communication skills and client facing skills.

Technical Functional Skills:

ERP: Oracle Applications 11i (11.5.9, 11.5.10, 11.5.10.2), Release 12.

Supply Chain Management modules like Inventory (INV), Purchasing (PO), Bills of Material (BOM), Work in Process (WIP),, Order Management (OM)

Tools: SQL*Plus, SQL*Loader, Business Intelligence(BI)/XML Publisher, Workflow Builder 2.6.x, Form Builder Operating System: Windows NT/XP/98/2000/2003/VISTA, UNIX

Work Experience

Senior Oracle APPS Techno Functional Chicago, Illinois

United Airlines Oct 2018 to Till Date

Project Type: Oracle ERP R12 Enhancement and Upgrade

Role Description:

Worked with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.

Gathering new requirements analyzing the existing business requirements and interacted with business users for the methodologies.

Worked on planplus projects,tasks and Budgets.

Worked on labor integrations

Worked on AR conversions.

Worked on AP integrations from c2fo source.

Worked on cash management process to create bank statements.

Worked on the integrations on Financials modules (Cash Management,AP,PA,GL).

Handling application deployments into DEV, Test, Performance and Production Environments.

Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.

Advanced PL/SQL Developer. Extensively worked on Advanced PL/SQL Concepts, PL/SQL Tables and Record types, Collections, Bulk Collects and Bulk Binds.

Well versed in creating Materialized Views. Tuning and Optimizing current and new applications

utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes

Creation of views and a clear understanding in using Cursors for processing of data.

Environment: Oracle Applications 12.1.3 OM, PO, iProcurement, BOM, WIP, INV, ASCP, WSH, WMS, AP, AR, GL, Oracle Database 10g, Workflows, Forms10g, Reports 10g, UNIX, Appworx, XML Publisher, EDI 850, SQL*PLUS, PL/SQL Developer

Oracle Apps Developer Washington, DC

Child and Family Service Agency - May 2017 to Sept 2018

Project Type: Oracle ERP R12

Role Description:

Handling application deployments into DEV, Test, Performance and Production Environments.

Worked on SAP crystal reports .

Worked with the Business team to baseline the 'As Is' Process and derive 'To Be' flow.

Worked on the entire integration strategy to update it into the current AS_IS system.

Flow Testing for SCM Modules (Oracle OM, Shipping, Advance Pricing, Quoting, AR) to make sure flow is working without any issues.

Worked on plsql complex scripts materialized view /ref cursors /external tables.

Explicit understanding in writing Packages, Stored procedures, Functions and Database Triggers using

SQL and PL/SQL in Real Time Experience in Performance Tuning using Explain plan and hints and Query Optimization procedures.

Advanced PL/SQL Developer. Extensively worked on Advanced PL/SQL Concepts, PL/SQL Tables and Record types, Collections, Bulk Collects and Bulk Binds.

Well versed in creating Materialized Views. Tuning and Optimizing current and new applications

utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes

Creation of views and a clear understanding in using Cursors for processing of data.

Environment: Oracle Applications 12.2.2 OM, PO, iProcurement, BOM, WIP, INV, ASCP, WSH, WMS, AP, AR, GL, Oracle Database 10g, Workflows, Forms10g, Reports 10g, UNIX, Appworx, XML Publisher, EDI 850, SQL*PLUS, PL/SQL Developer

Oracle SCM Technical Consultant Hyderabad-India

BioMarin Pharmceticals - Oct 2014 to Dec 2015

Project Type: Oracle Application 12.2.2 Support and Enhancements for Transportation Business

Role Description:

Worked on OM interfaces like Creating Promotion in Oracle, Item Creation, Validation & adding it to Price list, Outbound interface to send Salespersons data from Oracle, Order Management Defaulting Dependencies Extension.

Worked on the XML Publisher reports to send Configurator Model Report in xls Format

Major role in developing MD70, core development and preparation of MD120 for several modules

Involved in analysis and development of major conversions and interfaces

Used SQL*Loader, UTL_FILE package and External Table concepts for loading data into the database tables through an automated process.

Involved in Optimizing SQL queries involving large tables.

Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P) cycle, Fixed Asset to GL and Account Generator Workflow.

Functional responsibilities include: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.

Technical responsibilities include: interfacing the Modules, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, scheduling, producing, documentation and providing production support.

Perform technical analysis and development on multiple moderate to large projects concurrently

Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs etc.

Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).

Strong in Performance Tuning, UNIX shell scripting.

Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.

Interacted with users, fixed the bugs, developed test plans and provides daily production support.

Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS.

Excel in team collaboration, quick adaptation and problem solving with good communication skills.

Worked on Key Enhancements which included development of custom objects like packages, Triggers, new custom forms, modification of reports, creation of new custom Functions and creation of various new Oracle Alerts.

Key activities involved sizing of various enhancements from time to time.

Environment: Oracle Applications 12.2.2 OM, PO, iProcurement, BOM, WIP, INV, ASCP, WSH, WMS, AP, AR, GL, Oracle Database 10g, Workflows, Forms10g, Reports 10g, UNIX, Appworx, XML Publisher, EDI 850, SQL*PLUS, PL/SQL Developer

Oracle SCM Technical Consultant Hyderabad-India

GE Jenbacher Gas Engines Aug 2012 to Oct 2014

Project Type: Oracle R12 Upgrade

Role Description:

Requirements gathering for enhancements from Business Managers for R12 components. Worked with solution architects to understand the current system and impact of R12 on existing custom objects.

Wrote scripts for creating tables, Indexes, Grants and Synonyms and made modifications for the existing tables as per business

Involved in Design Reviews, Code Reviews, Coding, and Testing. Involved in the Oracle AIM methodology throughout the project.

Developed the Triggers for implementing the complex business rules.

Used Custom PL/SQL API'S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open Purchase Orders from legacy system (Mainframe) to Oracle Applications.

Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.

Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.

Worked on Item Conversion in the INV Module.

Design functional specification documents for gaps identified during fit-gap analysis.

Coordinate with Onsite and Offshore resources to Development of Reports in BI Environment

Development of new Objects that includes Triggers, APIs, & subprograms for migration Project specifically for BOM, WIP, PO & INV.

Involved in writing registration Scripts for Application Object Library objects, also used FND_LOAD to migrate object from one instance to another.

Create technical design specifications based on functional requirements as received from Business Analyst. Complete all technical development tasks for any programs, forms or reports as required by the functional user community.

Responsible for designing, (MD70), coding, testing, debug and documentation to ensure artifact can be maintained in the future.

Responsible for complete unit testing, like writing test scripts and record the results for each test.

Environment: Oracle Applications 11.5.8, Oracle Database R12 ERP, GL, SLA, AR, PO, BOM, WIP and AP, SQL, PL/SQL, SQL*Plus, SQL*Loader, Putty, Forms 6i & 10g, Jira system, Reports 6i & 10g, UNIX, Windows XP, Workflow 2.6.3.

Oracle SCM Technical Consultant Hyderabad-India

GE Power and Water Nov 2011 to Aug 2012

Project Type: Oracle Support and Enhancements 11i.

Role Description:

Worked as an Onsite Application Project lead for a custom application right from the beginning, responsible for receiving the Knowledge Transition and switching over to the main support from the previous vendor.

Extensively worked on PL/QL, Oracle 11g Upgrade, Server Upgrades, worked on SQL Loader, concurrent programs.

Worked on many Oracle Forms customizations and personalization’s.

Worked on scripts for creating Triggers, Indexes and other PL/SQL objects.

Handling Post Deployment meetings and operations to ensure that all Post Deployment issues were

handled and resolved quickly.

Worked on creating MD70s and MD50s as per client requirements.

Environment: Oracle Applications 11i, Oracle Database 9i & 10g later, OM, BOM, Inventory, PL/SQL, SQL * PLUS, PL/SQL Developer, Toad, Citrix Server, Forms 6i, Reports 6i

Oracle SCM Technical Consultant Hyderabad-India

GE MyPlant Interfaces Nov2010 to Nov2011

Project Type: Oracle Application 11.5.10.2 Implementation Project

Role Description:

Preparation of Technical Design Documents for interfaces.

Worked on Service Contracts, Install Base, Field Service interfaces .

Implementing the solution for the interfaces team.

Worked on creating Custom Packages to cater to the Pricing requirements and OM requirements.

Worked on Workflow issues extensively.

Worked on SOA and Web methods integration

Worked on Install Base Scripts.

Worked on creating Custom Forms 6i in the client applications.

Preparing test cases and Execution of test cases at Unit testing Level.

Assisting in preparing test cases and Execution of test cases at System Integration Testing Level

Environment: Oracle Database 9i, Oracle Applications 11.5.10, OM, Inventory, BOM, CRM, IB, Workflows, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, TOAD, UNIX, Windows XP.

Education

Masters in Computer Information System at UCM, USA May 2017

Bachelors in Information Technology at JNTUH,India May 2010



Contact this candidate