SUMMARY

• Worked in various roles as Developer, Senior Developer, and Technical Lead.
• Worked in various versions of Oracle Ebiz - 11i, R12 and Oracle Cloud.
• Good Technical development skills in RICEW (Reports, Interfaces, Conversions, Extensions and Workflows) components.
• Good Experience in File Base data loader, HCM Data Loader and Payroll Batch Loader.
• Worked on SOAP based Web services to import and export data to Oracle Cloud.
• Good Experience in developing Extensions using Web ADI.
• Experienced in Developing Technical design documents (MD070), Technical Test documents (TE020), Conversion and Migration documents (MD0120) using Oracle Application implementation methodology (AIM).
• Expertise in Design/Development of Interfaces using Oracle opens Interfaces and Oracle Public API’s.
• Strong experience in Data conversion/integration from Legacy systems and external systems into Oracle Applications using PL/SQL, SQL*Loader, SQL* Plus, UTL FILE, External tables etc.
• Extensive experience in developing and customizing Reports using XML/BI Publisher with xml data template and Oracle Reports 10g/9i/6i data template.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Modifying and developing Reports (6i, 9i, and 10g), Forms Personalization (R11i, R12) and Developing Audit Reports.
• Good Knowledge in the Performance Tuning for the impacted custom components by generating TKPROF and using of the SQL Analyzer and EXPLAIN PLANS.
• Experienced in requirements gathering, system analysis, design, development, testing, implementation, support, documentation and design reviews
• Good Experience in leading & managing the Team with onshore/offshore models with excellent analytical and de-bugging skills.
• Well Experienced on R12 Upgrade Analysis and Presentation.

PROFESSIONAL EXPERIENCE

ERP: Oracle E-biz 11i, R12 and Oracle Cloud Financial and HCM

Application Utilities: AOL, Jdeveloper10g,ADF, BI Publisher, HCM Extracts, OTBI, Web ADI, Audit Reports, Forms & Reports, ETL

Programming Language: Oracle Advance Pl/SQL, Web services, SOAP, XML

Data Base Utilities: SQL, PL/SQL, SQL Developer, TOAD, PL\SQL Developer

Operating Systems: Unix, Windows 9x/2007/XP, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis

Technical Lead | Oracle Cloud Implementation

Responsibilities:

• Managed a team of 8 to complete all RICE components including boundary system integrations
• Solution designing of the RICEW components in selecting the right technology for the development involving design, development, testing and documentation.
• Provided business solutions to client and discussed on all current and future enhancements by setting up daily calls.
• Performed analysis, research and design of all boundary systems to integrate with Oracle Cloud
• Worked extensively in internal cloud conversion tool to perform cloud conversion using file-based and HCM data loader, Web Services, HCM extracts, Business Intelligence (BI) & OTBI reports
• Customized AP check to support dynamic signatures and additional information
• Prepared automation scripts to call Payroll flow process - Time Card
• Prepared scripts to Load data conversion using FBL, HDL and PBL methodologies
• Extensively used SOAP WSDL to perform data integration.
• Customized AP checks for client to support their multi signature requirement.
• Worked to integrate boundary systems SV harbor, Retail Check Register. Time Clock Entry
• Developed BI reports to show Employee earning, Employee Demographic reports
• Developed BI reports to extract Vendor Information/ GL information out of the cloud system to SV Harbor using SOAP Web Services.
• Reviewing of the MD70, MD120 & TE20 to meet the standards.
• Code Review of the RICE components.

Environment: Oracle Cloud release 11

Software & Tool: HCM Extracts, BI Publisher Reports, SOAP Web Services, Oracle PL/SQL 11g.

Confidential

Technical Lead | R12 EBS implementatio

Responsibilities:

• Performed technical development and unit testing for custom reports and ETL Scripts
• Assisted in completing System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Managed DBA team during code migration from one instance to another.
• Managed development team to perform finance conversion which includes Purchase Orders, Receipts, Account Receivables Invoices & AR Receipts, General Ledgers, AP invoices.
• Assisted team to develop Web ADI template for AR Open invoice and AR receipts.
• Developed a streamlined process to perform Data and Code migration from one instance to another
• Managed cloning of all non-production and production instances by interacting DBA, Infrastructure and UNIX team.
• Prepared shell scripts to migrate DBA objects from once instance to another instance.
• Prepare LCT and LDT to migrate data from one form to another.
• Managed a 4-person team to perform Finance conversions which included conversion of AP, PA, PO, CM and GL conversion
• R12 Upgrade Analysis and case presentation to business by doing the R12 Upgrade analysis using the Panaya and Pwc internal tool.
• Performed data migration for Oracle Payable, Fixed Assets, Cash Management and General Ledger Transaction Details.
• Developed custom form using Oracle Forms 11g to map between 11i and R12 setups to support all conversion and retrofitted interfaces.
• Accurately accessed and resolved Production Defect/Problems.
• Timely follow-up, investigation, troubleshooting and resolution of Help Desk Tickets on Oracle E-Business Suite and related hardware and software.
• Worked with Oracle on Demand to support whole Oracle EBS Applications. Raised SR’s and Change Management Tickets with Oracle on Demand to debug/resolve various Issues across all the systems.

Environment: Oracle EBS R12

Software & Tool: BI Publisher Reports, AOL, Web ADI, Audit Report, Form Personalization, Oracle PL/SQL 11g. Panaya Tool for upgrade analysis.

Confidential

Software Engineer | R12 EBS implementation

Responsibilities:

• Developed interfaces, Extensions and reports using BI and Web ADI reports.
• Developed custom interfaces to link together diverse systems and applications across the enterprise, allowing the organization to keep pace with and respond to market changes
• Involved in data extraction and conversion for Oracle Payable, Account Receivables, Fixed Assets, Cash Management, and General Ledger Transaction Details.
• Developed Web ADI report for Project Invoices and AR open invoices.
• Performed PMO activities - conducted weekly status meetings and provided weekly status to the Program PMO and senior management team.
• Performed System Administrator functions such as defining Users, functions, responsibilities, concurrent programs, flex fields, Value Sets, Profile Options, registering forms in AOL and also the post clone tasks
• Attending issue meetings with the business and to make sure with the team mates to strictly follow the corrective action plans for the issues.
• Supported day-to-day execution of production support for Oracle Financial Applications.
• Developed alerts to capture the error transactions and send a report to the user submitting the interface or conversion program.

Environment: Oracle EBS R12

Software & Tool: BI Publisher Reports, AOL, Web ADI, Audit Report, Form Personalization, Oracle PL/SQL 11g. Forma and Reports 10g.

Confidential | Confidential

Senior Software Engineer

Responsibilities:

• Designed and developed Interface architecture for third party integrations- logistic providers, customers and suppliers.
• Developed conversion components for supplier master, customer and Item master and category, GL Balances, Open Invoices, Account Receivables and AP balances, Price lists, Open Purchase Orders, Sales Orders and Inventory.
• Managed AP, PO, AR and Auto Lockbox interfaces
• Developed custom interface using Informatics ETL tool for all GNFR (Goods not for resale) items.
• Maintained interfaces and data-flows, Event-handler and monitoring the success of transactions flow.
• Implemented the business logic by oracle stored procedures/ functions in the backend.
• Responsible for troubleshooting of PL/SQL scripts, as well as validating, processing and supporting of scripts. Researched user needs, code fixes and enhancements in SQL and PL/SQL scripts.
• Coordinated with IT Operations and users for routine data loading operations. Responsible for standardized data loading and data output generation to meet project needs.
• Creation of database objects like tables, views, procedures, packages using oracle tools like SQL and PL/SQL.
• Presenting Project statuses during weekly review call with Clients/ Business.
• Presenting open Issue status during weekly review call with Business SR handling with Oracle and communicating with the Oracle SDM (Support Development Manager) for quick resolution of the SRs
• Attending issue meetings with the business and to make sure with the team mates to strictly follow the corrective action plans for the issues.
• Providing effort estimation to the business for the new enhancement cases and getting sign off for the same.

Environment: Oracle EBS R12

Software & Tool: Incident Management AOL, Form & Report 6i, Oracle PL/SQL 10g.