Developer Oracle

SUDHEER KUMAR

************@*****.*** cell: 901-***-****

Around 10 years of experience as Oracle EBS 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),HR.

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.

Expert in ETL in data transformations.

Implemented Oracle EDI interfaces

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 Developer 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.

Development experience includes working with various EDI standards such as 850, 855, 856, 810, 846, 832, 210, ANSI X12 and EDIFACT standards. Good experience with code lists, resource management for import/export of resources for migration and configured public and private keys for trading partners such as Bank of America for extracting check images from SFTP server

Extensive experience creating maps for various file formats such as flat files, XML, cXML, CSV, positional files

Involves changes on service contract header and line attributes, WEBADI creation for serial number upload on contracts on Global ERP R12 system called as Greenfield system.

Developed code using service contracts API’s to update header and line attributes.

Developed BI publisher report which shows service contracts for specific operating units.

Created XML bursting file to send the output created by report in email.

Created values set flexi fields. Changed QA check rules package.

Worked on WEBADI to create serial number upload on service contracts.

Created Approval groups and rules in Oracle Approvals Management AME for service contract approval workflow.

Worked on HR,planplus projects,tasks and Budgets Interfaces .

Worked on COUPA for creating suppliers.

Worked on COUPA Invoices,payments,COA,projects interface in Oracle EBS .

Worked on labor integrations and developed accounting rules on PA.

Worked on AR conversions and BI reports .

Worked on AP integrations from c2fo source and COUPA,Concur,PEOPLE SOFT,Sceptre.

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,Finance Modules (Oracle OM, PO,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.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 SCM Technical Consultant Hyderabad-India

BioMarin Pharmceticals - Oct 2014 to Dec 2015

Project Type: Oracle Application 12.1.3 Support and Enhancements

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.

Developed Interfaces in OPM.

Supplier Capacity and constraints implementation

Generation of Discrete Jobs

Collaborative planning, Interface with other applications

Scheduling, Schedule Date and Receiving Date Implementation

Resource Planning and Fulfillment Planning

Preparation of Baseline Statistical Forecast and Adjustment Series

Demand Planning Workbench and Collaboration Work Bench

BR100 Setups for ASCP, MRP, MPS plan

Worked with Key Planners and Senior Buyers to streamline and update the sourcing rules, ASLs, Sourcing Assignments, Purchasing, sourcing and procurement set ups.

Worked on a customization for a Key Buyer for a custom Manual requisitions Form.

Worked on a customization and Performance improvement for a custom object over the seeded Create Releases Package.

Worked on Concepts like Processing Constraints, Defaulting Rules, OM Transaction Types, ATP, Scheduling and Reservations.

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.1.3,Fusion --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 ERP 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

Performed monthly subcontractor invoice payment disbursements, ensuring proper accounting allocations while further increasing standards for appropriate cash disbursements to ensure timely job and project completion with respect to accounts payables.

Developed job cost reports in coordination with subcontractors' invoices and project engineers for accurate billing, presented for monthly reporting to project director.

Implemented BOM,WIP,INV,WMS and shipping interfaces .

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

Implemented setups on O2C modules for pricing .

Assisted project director with financial budget preparations for all upcoming projects and jobs.

Collaborated in internal team meetings to discuss progress on active projects as they mature to accurately issue bi-weekly payments.

Researched account transactions to identify and resolve discrepancies.

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 EDI Integrations and cloud services.

Performed review and analysis of budget vs. actual variance in the monthly financial package and presented recommendations on critical balance sheet and income statement line items.

Worked directly with Asset Managers, Project Managers, and Financial institutions in conducting monthly draw process, monitoring project budget and forecasting future expenses

Managed all aspects of project monitoring including detailed journal entries, expense accruals, GL accounting, and account analysis as part of monthly close

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 CRM modules Service Contracts, Install Base, Field Service interfaces .

Developed Interfaces using api’s for Projects,tasks and Budgets.

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