SUMMARY

• Over 14+ years of experience as Lead, System Design, Development and Support of Oracle ERP /Custom applications.
• Expertise in different phases of the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, and production support.
• Proficient working in modules which include Accounts Receivables, Accounts Payables, General Ledger, Fixed Assets, HRMS, Grants Accounting, Purchasing, Inventory, Order management, Project Accounting, WIP, BOM, Oracle IPM, ASCP, Demantra, B2B and Claims Management.
• Strong conceptual noledge on business processes in Finance domain, Inbound and Outbound Logistics, Operations and Supply Chain Management.
• Expertise in database programming with regard to creating Procedures, APIs, Packages, Functions, Triggers views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Worked on RICE components involved in creation of Reports that are not available as standard reports, creation of the Interfaces to external systems, creation of Conversion programs to transfer data from a legacy system to the new system and Extensions to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system.
• Hands on experience using various tools TOAD, SQL Developer, Putty, Oracle Developer suite (Forms, Report, Workflow) and Oracle APEX.
• Good Experience in Data warehouse, Data Marts and ETL processes.
• Good Experience Oracle Web services and XML
• Good Experience in Agile and Waterfall Methodologies.
• Worked on different source code repositories such Flexdeploy, PVCS, CVS, Clearcase.
• Good Experience in performance tuning, troubleshooting, debugging and fixing the codes/scripts.
• Ability to work individually as well as in a team with excellent problem solving skills, troubleshooting capabilities and learn new tools.
• Involved in preparing the functional specification, technical documentation, test cases, flow charts, and production support and user support documents using AIM methodologies.
• Strong communication Skills

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i Multi Org.

ERP Modules: GL, AP, AR, OM, PO, CM, FA, INV, BOM, WIP, ASCP

Operating Systems: Ms-Dos, Windows 95/98, Windows NT, UNIX, Windows XP/Windows 7

Languages: C, HTML, XML, Java, SQL, PL/SQL, Shell scripting, T-SQL

Databases: Oracle 12/11g/10g/9i/8.x/7.x

Tools: /Utilities TOAD 10.5/10.6, CVS, SVN, PVCS, SQL*Loader, Export, Import, Developer 2000/6i, Discoverer 10g/9i,BI Publisher4.5.6,SQL*PLUS, MS Visio, IBM Clear Case 7.0/7.1.1, Putty, SQL Developer, SharePoint, Remedy, Windows Host Script, Hyperion, SNAGIT, Reports 10g/6i/6/2.5, Forms 10g/6i/6/4.5,Project Tracking System (PTS), Citrix, Servicenow, More4Apps, Web ADI, Oracle APEX.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle EBS Consultant

Responsibilities:

• Key member involved in the successful implementation of integration of Oracle Advanced Pricing and External Pricing Application (PROS Cloud).
• Collaborated closely with the business to ensure that business needs are well understood and are designed into the provided solutions.
• Coordinated with third party vendor application team (PROS) with regard to integration/support efforts.
• Responsible for planning, estimation, monitoring and reporting of JIRA activities during the integration project.
• Conducted the Daily Standup and Integration team meetings with the Confidential and PROS IT teams.
• Collaborated with the QA team to define test cases, metrics, and resolve questions about test results
• Worked closely with the QA team to identify and implement appropriate manual and automated functional tests
• Ensures all appropriate technical documentation is completed and up-to-date (program, system, change management, etc).

Environment: Oracle Applications R12, Oracle Advanced Pricing, PROS Cloud, Oracle 11g2/10g, SQL*PLUS, TOAD, UNIX, Jira, Flexdeploy, Source Tree.

Confidential, Dallas, TX

Oracle EBS Techno Functional Consultant/ Application Developer

Responsibilities:

• Handled multiple projects such R12 upgrade, Responsibility Revamp, RFQ Supplier Automation, Bond Dashboard, and Purchasing Category Code project.
• Key member in R12 upgrade and played a significant role in stabilization of the application.
• Designed, developed and implemented various interfaces, enhancements and reports in Grants Accounting Suite.
• Lead developer involved in design, development and deployment of forms/reports/applications across multiple versions of Oracle Application express.
• Extensively worked on reconciliation process between General Ledger and Projects Accounting.
• Involved in iExpense project costing, integration and configuration setups related to project accounting for expenditures types, expenditure classes and categories.
• Responsible for analyzing, developing and providing production support for different APEX applications used by the business users.
• Involved in the upgrade of multiple APEX applications from Oracle Apex version 5 to Apex Version 19.2.
• Expertise in designing and building interactive reports/classic reports/interactive grids with different download options.
• Handled production support issues related GL, AR & AP reconciliation - created ad-hoc financial queries to reconcile Purchase Order Receipts to AP Payments, Order Management to AR & GL to Sub ledger Modules AR & AP. Created data correction scripts & API for various financial data correction/reconciliation issues.
• Involved in Database design, System availability and Disaster Recovery discussion with regard to different applications involving multiple enterprise application teams.
• Led automation of different business process (Budget Transfer, CIP interface to Fixed Assets) and handled multiple enhancements within Grants Accounting with regard to interfaces, reports and user screens which helped the bond office to efficiently support the data requests of construction project managers, directors and division heads.
• Involved in iExpense project costing, integration and configuration setups related to project accounting for expenditures types, expenditure classes and categories.
• Identified and managed different issues across the project life cycle.
• Responsible for analyzing, developing and providing production support for different APEX applications used by the business users.
• Handled the adhoc requests from the users with regard to reconciliation issues between the Oracle modules during month end closing and supported integration questions between Oracle modules with regard to production support issues and enhancement requests.
• Handled Data Migration/Data conversion requests from the Legacy/3rd party systems to Oracle Applications/custom web applications.
• Worked and reviewed Technical Documents, Test Scripts, Test Scenarios, managing defects, testing estimations for the upgrade project to ensure proper functionality, data accuracy, and that modifications has no adverse Impact on integrated system environment.

Environment: Oracle Applications 12.2.8/11.5.10 , General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Purchasing, Order Management, Oracle Application Express, Oracle 12/11g, Reports10g/6i, Forms 10g/6i, SQL*PLUS, SQL*Loader, Servicenow, UNIX, BI Publisher.

Confidential, Chicago, IL

Oracle EBS Consultant/ System Designer

Responsibilities:

• Lead member involved in various activities including requirement specifications, system design specifications, testing, configuration setup, implementation, support and maintenance of the Manufacturing Execution system (MPDV Hydra MES) integration across multiple Confidential plants/products/line.
• Responsible for leading automation effort for MES projects and enhancements based on user demands and business requirements.
• Worked on application issue resolution and system interface troubleshooting of both software and hardware problems, reporting and tracking feature defects for continuous improvement of the manufacturing execution system.
• Worked on master data creation and database configuration for integration of both Oracle and MES.
• Expertise of integrated processes surrounding line scheduling, bill of materials, production orders, product costing, scrap/yield reporting, production planning/scheduling, inventory management, quality management, and quality data collection.
• Perform and/or oversee promotion of configuration/ development changes through environment (i.e., write functional specifications, create test plans/scripts, perform and/or coordinate testing with plant personnel and/or development team, and retain supporting documentation in adherence with project lifecycle compliance.
• Designed new, complex business processes and/or extensions or additions to MES application environment that has a high impact on business results.
• Designed and documented technical architecture, configuration setup and interface information for plant users.
• Responsible for Cut-over plan for the change Requests, Validation of Test scripts and Documentation.
• Liaised with business users to support/resolve MES system issues to ensure availability and performance.

Environment: Oracle Applications R12, Hydra MES, Oracle Inventory, Advanced Supply Chain Planning (ASCP), Oracle 11g2/10g, SQL*PLUS, TOAD, UNIX.

Confidential, Houston, TX

Senior Oracle Applications Techno-Functional Consultant

Responsibilities:

• Creating punch out catalogues and configuration of iProcurement
• Performed category and supplier mapping for the iProcurement module
• Configuring and setting up iProcurement for online catalog management (Punch-out)
• Setup iProcurement Browsing and Shopping Categories, Content Zones (local, Informational, Punchouts), Stores, Base Descriptors, Item Category Descriptors, Supplier Catalog. Further created Oracle hub and Code Conversion in Oracle XML Gateway module.
• Troubleshooting issues related to approval issues/holds in iProcurement, Oracle Supplier Network (OSN) and I Expense Modules raised by business users.
• Coordinated with sourcing specialist for managing Supply base, Create Approval Groups and Approval Hierarchies, processing requisitions, Creating purchase orders. Receive goods against various purchase order documents, inspect, transfer and deliver goods.
• Maintained the Approval hierarchy levels and Approval Groups for different business units for approving documents, Approval Limits, processing requisitions, creating RFQs and entering Quotations, Creating purchase orders.
• Developed custom data extraction / uploading interface utilities in PL/SQL for sending and receiving data from outside vendors, according to business needs.
• Worked on issues in oracle application modules involving ADP Employee Interfaces, Histrorical Data imports, Purchase Order Requistions, Auto Invoices, Employee Hierarchy.
• Resolved issues related to Expense Reports, Invoices, Recurring Invoices, Approval Limits, Position Hierarchy, Spreadsheet server, More4Apps, Check Printing.
• Service request Management with Oracle Support.

Environment: Oracle Applications 11.5.10, General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Purchasing, Workflows, HRMS, Oracle 11g2/10g, Reports 6i, Forms 6i, SQL*PLUS.

Confidential, Raleigh, NC

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved with study of existing system, preparing the Functional (MD50) to extract data from legacy system into Oracle Applications open interface tables. Documenting the mapping and requirements for the interfaces and conversions between the source systems and Oracle Applications.
• Developed upload and download scripts using FNDLOAD to move entity data types including Printer, Lookups, Descriptive Flex field with all of specific Contexts, Key Flex field Structures, Concurrent Programs, Value Sets, Value Sets with values, Profile Options, Request Groups, Request Sets, Responsibilities, Menus and Forms Personalization.
• Working on Enhancements (like new reports, concurrent program etc.) - designing, documenting, testing, maintenance and production support issues to ASCP.
• ASCP - Constrained Capacity Planning and Unconstrained planning, Demantra-Demand Management, Service Parts Planning, MRP
• Setup ASCP based on global forecast from demand planner at Product family level and tan blowing it down to component level and doing forecast Consumption at item level.
• Worked on ASCP Planner’s workbench, Sourcing rule form, assign sourcing rule form and ATP Inquiry form.
• Involved in the global sourcing roll-out.
• Process performance Improvements for ASCP, Demantra jobs, Collection process and Demantra forecast job by doing sql tuning using SQL Trace, Explain Plan, TkProf, AWR report, Indexing and Hints.
• Experienced and noledgeable in Series, Data Model, Forecast Tree, Business Modeler, System Parameter, Integration interface (Workflow Manager), Analytical Engine (Simulation/Batch) and Collaborator Workbench functionalities.
• Experience andnoledgeable in Demantra/EBS/APS Integration data model
• Participated and contributed in discussions about database issues, performed applications tuning by analyzing trace files and explain plans.
• Involved in multiple semiannual upgrade projects to bring patch levels to current versions. Extensive internal testing and test scripts were required to ensure user testing was smooth and sign off was received.
• Developed a patching strategy and testing plans to bring our environment current versions.

Environment: Oracle Applications 11.5.10, Advanced Supply Chain Planning (ASCP), Inventory Optimization, Demantra, General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Report Manager, Fixed Assets, Purchasing, Sourcing, HRMS, Oracle 11g2/10g/9/8i, Reports10g/6i, Forms 10g/6i, SQL*PLUS, SQL Developer, CVS, TOAD, UNIX.

Confidential, Middlebury, CT

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Part of the team involved in development, testing and upgrade of the (OM/INV/BOM) Application technical objects from Oracle EBS release 12.0.5 to 12.1.2 (Global Single Instance) involving multiple locations (US, UK, CEBU, Curacao, Canada, India)
• Developed code for custom min-max planning and transfer of items from source inventory to multiple sub inventories between different inventory organizations in the company.
• Lead developer for setting up item reservation/safety stock maintenance, on hand inventory calculations and vendor managed inventories for multiple E-Commerce/B2B customers like Wal-Mart, Target, Jcpenney, Kohl’s, Confidential .com and other online retailers.
• Worked on setup of TCA customers and other setups in e-Commerce Gateway module.
• Worked on different customizations to support B2B message flow in sales order cycle.
• Worked on Conversion activities to import data from legacy system includes Items Conversion, Customer Conversion, and BOM Conversion.
• Designed and developed custom PL/SQL programs to assign categories, cross references, sourcing rules and locations to items.
• Developed the EDI 870 feed to be sent to multiple customers
• Extensively used DAC, to configure, monitor and schedule ETL routines.
• Extensive Experience in Data Warehouse Administration Console - DAC Importing Subject Areas, Creating Execution plans, registering the informatica Work flows, Metadata management, monitoring and Scheduling of ETL jobs.
• Maintaining the Full and Incremental loads throughDACon different environments like Development and Test environment.
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Involved in the integration of OBIEE with Oracle Applications E-Business suite data.
• Worked with ETL Team for enhancement to Facts / Dimensions tables in developing the Initial and Incremental ETL process.
• Developed database objects using PL/SQL packages, stored procedures, collections, object types, tables, views, database links and triggers used for the data warehousing process.
• Developed sales order extracts for international and domestic sellers from Oracle applications utilized for demand planning and forecasting.

Environment: Oracle Applications R12 (12.1.2/12.0.5 ), Order Management, Inventory, MRP, BOM, B2B, Shipping, Oracle 11g2, 10g/9i, Reports10g/6i, Forms 10g/6i, SQL Developer, SVN, Oracle Business Intelligence.

Confidential, Louisville, KY

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in ResCare Oracle EBS Implementations and customizations for General Ledger, Payables, Accounts Payable, Receivables, Fixed Assets, and Cash Management.
• Played a key role in analysis, design and development of the ResCare Automated Invoice Processing (Oracle Financials Image Processing Solution Accelerator (AXF, V11.x.) and Capital Expenditure Request projects.
• Implemented the custom single sign-on for the Automated Invoice Processing project through live interface between the Microsoft Active Directory and Oracle E-Business Suite (Oracle IPM).
• Configured/Installed the Oracle E-Business Suite portion of the Accelerator, which involves configuring AXF, EBS Plugins, and related E-Business Suite Tables
• Modified the custom.pll to enable zoom functionality for AP Invoices and AP Suppliers screen to allow IPM to process invoice documents.
• Developed interface to cross validate invoice information, apply new invoice holds and load invoices automatically into invoice interface tables from Oracle IPM.
• Lead role in the design, development and implementation for upgrade of the Budgeting and Forecasting applications due to the change in company structure.
• Designed and developed integration between ResCare Pharmacy Application (SQL SERVER) and Oracle Accounts Receivable module using SSIS.
• Worked on RICE (Report, Interface, Conversions and Extensions) components for both custom and oracle applications.
• Worked closely with the DBA to improve the performance of Budget Upload Program by studying the explain plan, and modifying the indexes, database parameters, restructuring PL/SQL program units for optimum performance.
• Development of new reports and customized reports like company income statement, Income and Expense Reports, Account Summary, balance income statement, and trial balance reports for GL module using FSG (Financial Statement generator). Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
• Developed/Converted various custom or standard reports to PDF/Excel format using XML Publisher and registered them in the applications.
• Developed UNIX shell scripts to FTP, process EDI files, automate backend jobs, batch processing, file monitoring scripts, data manipulation scripts and load data into the database using SQL* Loader.

Environment: Oracle Applications 11.5.10, General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Purchasing, Oracle 11g,10g/9i, Reports10g/6i, Forms 10g/6i, BI Publisher 10.1.3.2.

Confidential, Terre Haute,IN

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Developed and implemented custom interfaces using oracle tools and API for system integration between internal and external systems.
• Data Conversion (Cleaning up and doing necessary modifications to the data) between the legacy system and Oracle Applications.
• Developed concurrent programs to validate and update the item details in Configurator.
• Worked on setup of TCA customers and other setups in e-Commerce Gateway module.
• Developed EDI interfaces to automate the edge label creation for different business units.
• Experienced in developing Functional design documents (MD050), Technical design documents (MD070), Application Setup Documents (BR.100), System Test Scripts (TE.040), Migration documents (MD0120), user guides and other technical documents using AIM Methodology.
• Follow tickets from Lotus Notes TPR System, fix application issues and document the issues.

Environment: Oracle E-business suite R12, Order Management, Work in Process, Bill of Materials, Purchasing, Inventory, Media Management System, Configurator, Oracle 10g/9i, Discoverer 10g, Reports10g/6i,Forms 10g/6i, TOAD.

Confidential, Cleveland,OH

Oracle Apps Consultant

Responsibilities:

• Responsible for analyzing, designing, developing and providing test and production support for business functionality of the Claim Management web application.
• Designed and developed State interface, HR interface and Workers Compensation Interface for secure transfer of data between the third party application and client data base using web services.
• Designed and developed an interface for GL extract for the Encore application system.
• Developed code for data retrieval from the application through the use of multiple web service requests, parsing of the SOAP response and tan loading to the custom tables.
• Extensively used inbuilt Oracle PL/SQL packages like UTL FILE, XMLGEN, UTL SMTP in application development
• Used XML functions in queries for manipulating XML documents like XML ELEMENT, DBMS XML GEN.CONVERT, XML CONCAT, and XML AGG.
• Developed code for efficient data mining, data validation and data cleanup for all the interface processes to ensure that the sensitive data mapped into the system is consistent and accurate.
• Responsible for extracting, transforming and loading data using UTL FILE utilities.
• Hands on experience with Web Services/SOAP calls over HTTP/SOAP from with Oracle Database
• Written UNIX shell scripts to create flat files in oracle directory and transferring of files from database directory to the third party vendor’s servers (Sedgewick/Fidelity).
• Created UNIX Shell Scripts for automating programs, data loading and interface process in Custom and Oracle Applications.

Enviroment: Oracle Applications R12/11.5.10, GL, AP, AR, Remedy,IBM ClearCase 7.0/7.1.1, PL/SQL Developer,Putty,Kintana,Windows Host Scrpiting, Oracle 11g/10g, Perl Scripting, Web development, WinScp,XML.

Confidential, Terre Haute,IN

Oracle Apps Consultant

Responsibilities:

• Experience in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications.
• Involved in improving the functionality and performance of different Ecommerce Applications used by the business user.
• Involved in writing validations for BOM Interface to import BOM and BOM components into Oracle Applications from the legacy system.

Environment: Oracle E-business suite R12, Order Management, Work in Process, Bill of Materials, Purchasing, Inventory, Oracle 10g/9i, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*Loader, Forms 10g6i,Reports 10g/6i.

Confidential, San Jose, CA

Oracle Apps Developer

Responsibilities:

• Involved in Development, Customization of the iStore Interface Applications
• Used XML Publisher to load catalog data in iStore module.
• Created new custom folders and value lists in discoverer admin layer.

Environment: Oracle E-business Suite11i, Account Payables, Accounts Receivable, Inventory, Order Management, WIP, Oracle 10g/9i (9.2.0), XML/BI Publisher 5.6.3, Discoverer 10g, Forms 10g/6i, Reports 10g/6i

Confidential, Atlanta, GA

Oracle Apps Developer

Responsibilities:

• Validated data using PL/SQL by loading into interface tables and running import programs to load them into main tables from legacy systems.
• Developed and customized many reports like Pick Slip, packing Slip, and Mailing Label for shipping
• Developed conversion scripts for address imports to existing parties using TCA API’s

Environment: Oracle E-business Suite11.5.10, General Ledger, Order Management, Bill of Materials, Purchase Order, Oracle 10g/9i (9.2.0), XML Publisher, 10g, Forms 6i, Reports 6i.

Confidential

Oracle Apps Developer

Responsibilities:

• Successfully designed and implemented the Payables Open Interface. Activities involved creation of Loader File, porting Invoices into the interface tables using SQL*Loader and tan using Payables Open Interface to port the data into the actual tables.
• Developed control files for SQL*Loader and PL/SQL scripts for loading and validating data into interface tables from legacy system.

Environment: Oracle E-business Suite11.5.9,General Ledger, Account Payables, Accounts Receivable, Order Management, Window NT, Oracle 8i, Forms 6i, Reports 6i.

Confidential

Oracle Developer

Responsibilities:

• Used different modelling techniques like Physical, Logical and Data Modeling for enhanced data management
• Key responsibilities include data conversions, customizations, implementing applications, customizing workflow processes, creating alerts, implementing some of the administrator responsibilities.
• Involved in customizing the workflow process for PO Approvals, OE order headers, OE order lines.

Environment: Oracle7.X/8i, PL/SQL, SQL* Plus, Developer 2000/6i, TOAD.