SUMMARY

• Having over 10 Years of Experience in Oracle EBS/Oracle Cloud SCM/Financials/HCM Modules with experience in OTBI, OBIEE, HCM Extracts, HDL, BI Publisher and Financial Reporting Center Tool (Smart View).
• Involved in implementations of Oracle Applications R12 & Fusion Cloud Financials/HCM Applications.
• Experience working in full implementation projects, Upgrade and post - production support projects.
• Hands on experience in creating reports, conversions using FBDI and interfaces in oracle cloud.
• Excellent skills in OTBI and BI publisher reports.
• Knowledge in FRS and smart views reporting.
• Good knowledge in Procure to pay, order to cash cycles.
• Lead and manage Oracle Cloud ERP development efforts in support of client delivery projects.
• Worked in Order management, Purchasing, Finance modules AP, AR, GL and Channel revenue management modules. Experience working in payroll, benefits and core HR modules in HCM cloud.
• Expertise in RICEW components i.e., Reports, Interfaces, Conversions, Extensions and workflows in Oracle apps R12 and Oracle Cloud versions.
• Estimate development effort based on both high level and detailed requirements for extensions, reports, conversions, interfaces and workflows.
• Involved in Complex SQL Queries and writing PL/SQL programs (Packages, Functions, Triggers, procedures).
• Well versed in using tools such as HP ALM, HP Kintana, HP QC, IBM Lotus notes and JIRA ticketing system.
• Well versed in leading a team and handling cross-track status calls, client reporting besides technical components.
• Excellent knowledge in JAVA, JavaScript, Web Services, REST/SOAP, XML, JSON.
• Good written and verbal communication skills.
• Experience in SQL* Loader, Oracle API’s and UTL FILE Packages for data conversion and interfaces.
• Good knowledge in designing technical documents using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Experience in Application System Administration activities like managing concurrent managers, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Developed Interface/Conversion (inbound and outbound) Programs using Open Interfaces and API's. Also developed Extensions to add additional validations and functionality to seeded oracle processes to meet the client's requirements.
• Worked on Design and Development of Interfaces and Data migration using SQL Loader, Oracle open interfaces.
• Creation of users, responsibilities, menus and request groups.
• Expert knowledge on Sub-Ledger Accounting (SLA) for managing accounting across Sub ledger transactions to generate accounting entries and customization of derivation rules as per the requirements.
• Experience in Multi-Org and Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Experience in query optimization, Performance Tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Expert level experience in advance PL/SQL that includes developing and using cursors, Ref-Cursors, Procedures, Stored Procedures Function, Packages, Oracle Supplied Packages, Objects, Collections, Partitions Tables, Triggers, Views, Materialized Views, Indexing, Performance Tuning, Nested Tables and Oracle Objects.
• Extensively used UTL FILE package to write the data from oracle tables to a flat file
• Used Putty, SSH, Telnet for UNIX login to check the server logs.
• Good Knowledge in WORKDAY integrations.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve client requirements.
• Ability to learn new technologies quickly.
• Possess excellent analytical and leadership skills and Strong ability to multi task and prioritize work load.
• Excellent verbal and communication skills with ability to work in a team and as well as individually.

TECHNICAL SKILLS

Oracle EBS and Oracle Fusion Cloud Applications: Financials, SCM and HRMS Modules (AOL, General Ledger, Accounts Payables, Payments, Cash Management, Fixed Assets, EB-Tax, Purchasing, Accounts Receivables, Inventory, Order Management, User Management, Service Contracts, Shipping, Advanced Pricing, iExpenses, iProcurement, iSupplier, Sourcing, Sub-ledger Accounting, Core HR, Payroll)

Databases: Oracle Database 12c/11g/10g/9i, SQL Server 2005/2009, DB2

Languages: SQL, PL/SQL, Pro*C, C/C++, JAVA, XML, UNIX Shell Scripting, Perl Script.

Oracle Tools/ GUI: Oracle Reports 10g, Soup UI, SQL Developer, SOABPM, ADF DI, OTBI, BI Publisher, FRS, SmartView, OIC

Database Tools: TOAD, PLSQL Developer, SQL*DEVELOPER, SQL*Plus, SQL Navigator

Web Technologies: HTML, HTML5, XML, CSS, JavaScript

Other Tools: Secure Shell, Putty, WINSCP, File Zilla, Beyond Compare, Compare it, DOS Prompt

Oracle Utilities: SQL Loader, UTL FILE, TRACE, TKPROF, DBMS Utilities

Operating Systems: Windows Family, HP Unix, Sun Solaris, Linux

Version Control Tools: GIT Hub, Source Tree, Stash, WinCVS

Ticketing Systems: Service Now, Track Studio, HP Service Center, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Kalamazoo, Michigan

Lead ERP Oracle Cloud Techno Functional Consultant

Responsibilities:

• Worked in development of reports such as BI Publisher, smart views and FRS.
• Unit testing of the developed code.
• Built Oracle BIP reports, Answers, Analysis reports and Reports using data models.
• Providing status and issue reports to the project manager/client on a regular basis.
• Worked on FBDI for inbound integrations in Financials, SCM Cloud system.
• Worked on Procurement (P2P) and Financials cloud.
• Developed OTBI reports for to view and validate employee data using existing subject areas.
• Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports.
• Supported client in Oracle Cloud customizations for end users.
• Configured custom security and data roles as per business.
• Worked on HCM Extracts and HCM Data Loader in HCM Modules.
• Strong integration experience in integrating with Oracle Cloud ERP both inbound and outbound.
• Proficient in managing Cloud Sandbox for personalization.
• Worked on Integrations in OIC for SaaS to SaaS, and SaaS to On-Premises integration.
• Code reviews, document reviews of peers.

Confidential, RTP, NC

Lead ERP Oracle Cloud Techno Functional Consultant

Responsibilities:

• Implementation of Oracle Cloud ERP for Financials, SCM and HCM applications.
• Customization of seeded reports, payment formats for OTBI Subject Areas.
• Development of new custom reports with OTBI and BI Publisher for Financials and Procurement modules.
• Configure the Fusion Cloud Applications to meet client requirements and document application setups.
• Developed OTBI reports for to view and validate employee data using existing subject areas.
• Created reports using Financial Reporting Studio (FRS), Smart View, and Oracle Transactional Business Intelligence (OTBI).
• Developed outbound interfaces using BI publisher approach.
• Worked on Inbound and Outbound Integrations in Cloud Financials Modules.
• Worked on Oracle Cloud Financials, P2P, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, Accounts Receivables, Accounts Payables.
• Created outlines, calculation scripts, member formula and business rules, Data forms, reporting with Smart View.
• Unit testing of the developed code for Reports and Data integrations.
• Code reviews, document reviews of peers.

Confidential, Webster, NY

ERP Oracle EBS/Cloud Developer

Responsibilities:

• Production application services - The services include maintenance to production applications to correct faults (fix when broken), performance monitoring, and problem support.
• Production database services - The services include database administration, maintenance to production databases to correct faults (fix when broken), performance and data growth monitoring, and purging and archiving of data. Provide ERP Application support by handling day-to-day issues
• Provide bug fixes to resolve these issues by performing detailed issue analysis and providing root cause fixes.
• Developed many custom reports.
• Worked on Data Migration from oracle EBS into Oracle ERP Cloud
• Worked on Oracle ERP Cloud Soap Services and REST APIs.
• Worked on FBDI Templates for Financials modules
• Worked on HCM extracts and HCM Data Loader.
• Developed BI Publisher Reports.
• Developed and Customized OTBI Reports as per business requirements.
• Unit testing of the developed code.
• Provide support for the objects during SIT, UAT.
• Code reviews, document reviews of peers.
• Involved in FS review, fit-gap analysis process.
• Lead outbound interfaces track, monitor timelines and closely work with on-site counterpart.
• Created custom tables, views and materialized views and developed various PL/SQL packages, procedures and functions to meet the client business requirements for reporting, interfaces and custom extensions.
• Design and Developed Custom Check format for the new operating unit.
• Design and developed Supplier Remittance Advice Email in Payables.
• Designed and Developed the Item Import, Item Assignment and used the Standard Interface Program to import.
• Design and Developed Contract’s Expiration Report to send to email of Resource Managers using XML Bursting technique in BI Publisher
• Developed new programs to integrate the data from Oracle to BO system to generate reports.
• Customized Reports in Account Receivables using XML/BI Publisher.
• Working with the users and fixing the issues related to SIT testing.
• Worked on Resolving Tickets, databases to fix issues and data growth monitoring.

Confidential

ERP Oracle Apps EBS Developer

Responsibilities:

• Attended Review calls, team meetings and knowledge sharing meetings.
• Worked on UNIX to upload the data into database tables.
• Worked BRSD rejection reason Interface to upload all the rejected orders.
• Developed PLSQL code for OAF forms and extensively worked on OAF custom extensions as per the business requirements.
• Worked on developing Customer Account update, Customer Profile Updates Conversion in AR.
• Developed SQL Loader program to import PO Receipts data file into staging table from third party system.
• Worked on Technical Document and development of Sales Contract Conversion.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Customized AR Aging 4 and 7 Bucket reports in Account Receivables AR, Chart of Account Detail Listing Report using XML/BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Report Builder.
• Developed Receivable label report which included barcode designing in it using XML/BI Publisher.
• Order Details screen - Created an Order detail report in XML Publisher and integrated the Report in OAF. Worked on objects of OAF extension based on the small changes required by the client.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Developed OAF forms to view the manager details, user details.
• Preparing End user manuals to all the developed pages.
• Worked on Monthly calculation run, and Quarterly calculation run for EBU Reseller.

Environment: Oracle E-Business Suite R12(12.2.2), SCM, Inventory (INV), Purchasing (PO), Account Payables (AP), AR, General Ledger (GL), HCM, XML/BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, OA Framework(OAF).

Confidential

Oracle EBS Developer

Responsibilities:

• Built various complex SQL Queries for reporting. Worked on customization and personalization of Oracle forms.
• Performed requirement Study in detail. Interacted with client/end users & updating the status.
• Worked on various third party tools for integrations.
• Worked on Customization of forms, reports, XML/BI publisher reports.
• Worked on Interfaces & Conversions.
• Customized Incomplete Invoice Report.
• Developed Prepayment Receipt Report using XML Publisher.
• Worked on PO Interface to upload the Headers, Lines and Distributions Details from the legacy to PO.
• Imported the Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in General Ledger (GL) using Journal import.
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Developed Sales Order conversion in Order Management (OM) to import Sales Orders from Legacy system using SQL * Loader.
• Worked on Shipping APIs for updating base tables when shipping is done by third party shipping.
• Imported the data from legacy systems into the temporary tables in Account Receivables (AR).
• Designed and developed the Account Receivables (AR) extension called Balance Forward Billing process for preferred customers wishing consolidated bills at site level based on the predefined payment terms on the Bill to Locations.
• Worked on Supplier Interface.
• Developed Outbound interface to extract data from Base tables to Flat file using the UTL FILE utility in HRMS/Financials module.
• Customized GL Search Form by enabling existing DFF to store tax details.
• Customized PO Workflow to populate the Charge account in PO distributions.

Environment: Oracle EBS R12 Inventory (INV), Purchasing (PO), Account Payables (AP), AR, General Ledger (GL), Fixed Assets (FA), HRMS, Payroll, OTL, PA, CM, XML/BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, Workflow, SQL * Loader, UNIX.

Confidential

ERP Oracle Apps Developer

Responsibilities:

• Tested various technical components and business process flows in P2P and O2C cycles.
• Worked on customization of Query find Forms.
• Customized Invoice History Report.
• Design and Developed a Sales Order Report - XML Report.
• Created a report on Projects, AR, OM, PO, INV and GL modules, using Reports 10 g, XML/BI Publisher and Custom Packages.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Worked on Formula Columns, Summary Columns and Placeholder Columns for developing the reports using Reports 10g.
• Created complex templates and dynamic parameters to produce the output in EXCEL formats.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.
• Modified Functional Specification (MD050), Created Technical design document (MD070) and created Installation document (MD120).
• Worked on Item Interface to upload items including Categories and revisions.
• Worked on Daily Rates Interface to upload exchange rate dates from legacy systems to GL Base Tables.
• Worked on Forms Personalization.

Environment: Oracle EBS 11i/R12, inventory (INV), Purchasing (PO), Order Management (OM), Account Payables (AP), AR, General Ledger (GL), HCM, XML/BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, Workflow, SQL * Loader, UNIX.

Confidential

Oracle Apps Developer

Responsibilities:

• Designed and developed customized reports.
• Involved in unit testing and performance testing for reports.
• Interaction with the client to analyse the business requirements and perform fit gap analysis.
• Involved in Implementation of complete solution at client and providing post production support.
• Creation of purchase requisitions into oracle applications using PO interface.
• Handling version control system for maintaining the versions.
• Testing all the components and P2P cycles.
• Developed forms using ZOOM functionality that pops up appropriate form.
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements like implementing the calendar feature, WHO columns, defining DFFs etc.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various developed custom PL/SQL Packages.
• Design of custom flex fields to map the business requirements.
• Customization of oracle forms and development of new custom forms.
• Customization of oracle Applications reports.
• Created Tables to store Levelling Field Survey Book Information and designed Forms to enter Levelling Field Survey Book Information
• Design the Data modal and creation of tables, views, indexes

Environment: Oracle Applications R11.5.10, Oracle 10g, Sun Solaris 5.8, Windows 2000/XP/NT, Forms 6i, Reports 6i, TOAD, SQL *Loader.