SUMMARY:

• Winner of prestigious Confidential Management Award for my consulting work.
• Good at giving Technical Solutions and Automation.
• Over 15 years of Oracle based business application Design, Development, Conversion, Customization, Interfacing, Forms, Reports and Extensions (RICE)
• Very strong Techno Functional skills (80/20)
• Team player with team leadership experience
• Strong interpersonal skills, ability to interact with people at all levels, good communication and presentation skills.
• Worked in Oracle Applications R12, 11i and 10.7 SC consisting of:
• Hadoop, HDFS, MapReduce
• PIG, HIVE, JAVA
• AIM Methodology
• Application Object Library (AOL)
• General Ledger (GL)
• Accounts Receivable (AR)
• Accounts Payables (AP)
• Order Management (OE/OM)
• Project Accounting (PA)
• Inventory (INV)
• Work In Process (WIP)
• Bill of Materials (BOM)
• Purchasing (PO)
• Customer Care and Billing (CCB)
• FLUME, SQOOP
• HBASE
• OBIEE/BI Publisher
• Oracle Service Contracts (CRM)
• HRMS
• Order to Cash (O2C)
• Procure to Pay (P2P)
• Workflow
• TCA Architecture
• BPEL
• Supply Chain
• OAF
• SOA
• Work Asset Management (WAM)

TECHNICAL SKILLS:

Hardware: DEC Alpha, IBM PC AT x86 and Sun Workstations

Operating Systems: Windows, Sun Solaris, HP - Unix, AIX, Linux (SuSE SLES7,Red Hat AS 2.1), Ubuntu, CentOS, Linux

RDBMS: Oracle 10g, 9i, 8i, 8.x, 7.1,6.0, FoxPro, MS-Access

Oracle Utilities: SQL * Plus, Pro*C, Toad, SQL*Loader PLSQL

Tools: Oracle Forms, Oracle Reports, JDeveloper, XML Publisher

Oracle Applications Modules: Financials, Manufacturing, Supply Chain, HRMS, O2C, TCA, OAF, P2P SOA/BPEL

HADOOP Eco System: HDFS, MapReduce, Pig Script, Hive, Hbase, SQOOP, Flume, Java, Ubuntu, CentOS, Linux

EXPERIENCE:

Confidential, St. Louis, MO

Responsibilities:

• Worked as developer involved in modifying GL interfaces for R12 upgrade.
• Developed a solution for 11i and R12 data merge for upgrade to work on reports.
• Developed a solution for GL categories to split up as headers for Budget Levels.
• Working as developer involved in modifying workflow for OM for CashNCarry.
• Written a PLSQL function to findout CashNCarry.
• Written PLSQL Workflow stored Procedure to insert custom tables with details from GL Lines and AR Revenue in R12 in OM.
• Written a BI Publisher report which summarizes the GL Lines from Custom Table according to accounting date, order number and debit amount.

Confidential, Fayetteville, NC

Solution Architect/Developer

Responsibilities:

• involved in designing, developing solutions, reports and PLSQL packages for R12 in CCB and WAM and GIS.
• Developed BI Publisher reports in CCB, WAM.
• Given solution to directly interface asset data, Synergen ID from GIS to WAM.
• Did research on how to populate extra attributes from GIS to WAM thru Multi version and Single Versionviews.
• Did personalization on Oracle Iprocurement.
• Worked on packages to interface leave data, craft and crew, employee data, time sheets data between HRMS to WAM thru SOA via Advanced queues
• Worked as developer involved in developing reports and packages for 11i.
• Developed several BI Publisher reports in GL, AR, INV, BOM, WIP, OM and AP modules.
• Developed BI publisher report to burst warehouse payments to distributors according to the aging.
• Did Documentation and Customer Ageing Report in PLSQL and XML Publisher.

Environment: Multi Org, Multi Currency, Oracle Apps Rel. 11.5.10 (AP GL AR INV OM BOM WIP), RDBMS 10g

Confidential, New Hartford, NY

Responsibilities:

• Modified complex custom PL/SQL package to calculate variances for financial, standard and work order COSTING for WIP jobs and their related BOM and INV components.
• Wrote an update process to in corporate those values in the custom tables according to the requirements.
• Developed and modified BI publisher reports
• Solved support issues reports and packages.

Environment: Oracle Apps Rel.11i (CST, INV, BOM, WIP), RDBMS 10g

Confidential, Irvine, CA

Responsibilities:

• Written MD50 functional and MD70 technical document for the Custom Report.
• Developed a custom BI Publisher Report in Advanced Pricing to calculate price lists and price breaks along with costing for items in a price list.
• Modified code in GL Balances conversion from 11i to R12 upgrade
• Modified changes to OECOGS Workflow PLSQL package to accommodate the COGS accounts depending on the Order Type.
• Developed BI publisher reports and translations
• Modified Post update Item Template package to update item attributes.
• Modified the PLSQL package for OEOL lines Workflow to re-price the line.

Environment: Multi Org, Oracle Apps Rel.12.1.3 (GL, INV, OM, AR), RDBMS 10g

Confidential, Rocky Mount, NC

Responsibilities:

• Developed a customPLSQL Package in ASCP to update the MSC ST SALES ORDERS staging table to sync up with the schedule ship date and quantity and split lines from OM after the Data Pull and before ODS load using MSC CL CLEANSE the Oracle supplied hook.
• Modified Expected ASN receipts report in XML publisher in OM.
• Developed Derived Scheduled Ship status report in XML Publisher in OM for processed orders.

Environment: Multi Org, Oracle Apps Rel.11i, 12.1.2 (PO, INV, OM, ASCP, INV), RDBMS 10g

Confidential, Grand Rapids, MI

Responsibilities:

• Modified Package in Service Contracts which is called by business event to check the credit status of membership.
• Developed Order Import Interface thru OE ORDER PUB.Process order PLSQL API for importing orders in OM.
• Developed report to compare qualifiers and modifiers or an order to a custom qualifiers and modifiers in OM Advanced Pricing.
• Developed plsql function to send notification message to the calling SOA program thru business event.
• Developed several BPEL processes in SOA to migrate data using file adaptor from legacy system.
• Knowledge in developing and deploying BPEL Processes using technology adapters (Oracle Applications, JMS, MQ, AQ, DB, File and FTP Adapter) Using Web logic Server knowledge in Human work flow and good experience with XML,XSLT, XPATH, XQUERY, JQUERY & WSDL

Environment: Multi Org, Oracle Apps Rel. 12.1.2 (CRM,INV, OM), RDBMS 10g, SOA, BPEL

Confidential, Houston, TX

Responsibilities:

• Developed PLSQL Package for finding Material Variances in INV, BOM, WIP and COSTING
• Developed SQL for Material Transaction in INV, WIP and BOM and COSTING.
• Developed reports in 6i in INV, WIP, COSTING and BOM.
• Did Documentation according to the client templates.

Environment: Multi Org, Oracle Apps Rel. 11.5.10 (BOM, INV, WIP, COSTING), RDBMS 10g

Confidential, Milwaukee, WI

Responsibilities:

• Involved in production support of BI Publisher/OBIEE reporting.
• Fixed various reports in BI Publisher.
• Developed queries for BI publisher and modified templates.
• Developed utility in java to transform XLST translation tags for two different languages.
• Developed Java function to get the images to load into database.
• Integrated reports in Siebel Analytics with Web Services.
• Written Technical Documentation.
• Developed BPEL process in SOA to read and write data from a text file into Siebel database using file adapter and db adapters.
• Designed, developed, deployed, managed and tuned asynchronous/synchronous, batch/real-time running SOA Patterns in ESB/OSB processes using adapters

Environment: Siebel Analytics XML Publisher, BPEL, SOA, RDBMS 10g

Confidential, New York, NY

Responsibilities:

• Involved in production support of R12 migration.
• Fixed reports in R12 which were migrated from 11i.
• Developed new reports in R12 using XML publisher.
• Interacted with users and solved problems in Functional set ups.
• Found solutions to problems in profile option setups.
• Modified PLSQL package to track migrated 11i checks to R12 in AR.

Environment: Oracle Apps Rel. 11.5.10 and 12.1.0 (AP AR), RDBMS 10g

Confidential, Dallas, TX

Responsibilities:

• Developed PLSQL package for applying zero balance receipts automatically using API's in AR.
• Developed XML Publisher several Reports like AR Refunds, Service Write Off, Potential Service Contract Write Off, DSO calculation, in AR, Service contracts.
• Developed Migration Scripts using FNDLOAD.
• Done OA Framework Personalization for attaching documents on a custom form.
• Developed an update form for customer profiles in OA Framework.
• Enabled and disabled fields thru OA Framework Personalization.
• Developed Data Definition files for XML Publisher Reports.
• Developed RTF Templates for XML publisher Reports.
• Modified zero balance billing report.

Environment: Oracle Apps Rel. 12.1.0 (AR), Service Contracts RDBMS 10g

Confidential, Boston, MA

Responsibilities:

• Gathered requirements for Automatic GL Account Generation personalization in AP.
• Written Functional MD50 and Technical MD70 and documents.
• Worked as Sr. Technical Developer mostly involved in designing and developing an automatic GL account generation solution, which will take input from a descriptive flex field and generates and populates the distribution account thru Form Personalization for Oracle Payables (AP) distribution Account.
• Developed PLSQL functions which are called thru personalization in Oracle Payables (AP) and General Ledger (GL)
• Overall simulating GL account generation thru heavy personalization in AP.

Environment: Oracle Apps Rel. 12.1.1 (GL,AP), RDBMS 10.2.0.3.0 , Forms Personalization

Confidential, Minneapolis, MN

Sr. Technical Developer

Responsibilities:

• Developed Estimated Dispatches Report.
• Developed Accrual Analysis Report.
• Developed Accrual Calculation Report.
• Developed CN55 template and Report.
• Developed CN56 template and Report.
• Developed Accrual Maintenance Report.
• Developed custom form in Forms 6i.
• Modified a custom PLSQL package.

Environment: 11.5.10.2 (GL, AP, AR, Custom application), Forms/Reports6i, XML Publisher

Confidential, Detroit, MI

Sr. Technical Developer

Responsibilities:

• Developed AR invoice Print Report using XML publisher.
• Developed Custom Template for the Invoice Report.
• Developed Technical Design Document for Invoice print report.
• Personalized OAF page to display tips in a region.
• Personalized OAF page to display additional button to navigate into a website.
• Personalized OAF page to reorder the columns in a table in a region.
• Personalized iexpenses report page to display additional column.
• Personalized OAF page to display the DFF.
• Personalized iexpenses reports page to create new views as per user requirements.

Environment: Release12 (12.0.4), OAF/J Developer, Forms, XML Publisher

Confidential

Principal Consultant

Responsibilities:

• Worked with functional consultants to get the specifics of the requirements.
• Developed a procedure to unapply from Invoice any credit memo or cash receipts using AR APIs.
• Developed a procedure to create adjustments using AR APIs.
• Developed plsql package for canceling AR transactions.
• Developed a plsql package for inserting or updating the custom table and call a workflow business event.
• Mapped the legacy system columns to client’s custom table columns.
• Worked with other team members to get the adjustment package integrated in calling package.
• Developed MD070, MD120 Documentation.

Environment: Oracle 10g, Oracle Release 12, PL/SQL, Windows

Confidential

Principal Consultant

Responsibilities:

• Developed Plsql program to call the XML publisher report.
• Modified the Check printing RDF file to call the XML publisher report.
• Done the registration of Templates.
• Got requirements and changed the conversion of words in Spanish language.
• Developed check printing templates and reports using BI publisher on a preprinted format.
• Worked with offshore people to get the setups done right for the XML publisher report.
• Worked as Principal Consultant in release 12 in PLM, OA Framework and PL/SQL
• Developed plsql package for creating intelligent numbering system which is called from an OA framework page in PLM.

Environment: Oracle 10g, Oracle 12, PL/SQL, OA Framework, JDeveloper, PLSQL, UNIX, SOA, BPEL

Confidential, TX

Sr. Technical Developer

Responsibilities:

• Developed plsql package for creating, updating and deleting Batch Entries thru pay batch element entry api API’s
• Developed plsql package for creating, updating Element Entries thru pay element entry api API’s
• Developed custom Gift Enrollment form using Self Service plsql web form
• Developed custom program to generate employees, locations, phones and address and certificate information files which are loaded to Schools.
• This enables employees to register online for various professional learning activities.
• Conversion strategies and manipulation of API’s to be used for HR/Payroll Conversion efforts.
• Support including Open Enrollment, Troubleshooting Time Card, Employee Creation, Termination, Rehire, and Reverse Termination issues etc.
• BEE & OTL to BEE Transfer related issues.
• Customized OTL Project & Payroll timecard Layouts and Hours Explosion Process.
• Configured Time categories, Preferences, Approval styles, Time Entry rules, OTL Approval Rules.
• Customized Payroll, Accrual & Standard Benefits Fast formulas to meet client’s business needs.
• Developed various complex reports using XML publisher.
• Given a solution for dependant value set flex-field problem
• Developed XXXM Crosswalk data Interface
• Developed Dell GL JPMorgan Interface Request Set
• Worked closely with functional consultants for unit testing the components
• Worked on critical analyzing and bug fixing in CRP3 Testing for GL, AP modules

Environment: Oracle 8i, Oracle Financials 11i (11.5.5), Oracle Forms, Oracle Reports, PL/SQLENRICH IT (GA, USA)

Confidential, TX

Senior Technical Developer

Responsibilities:

• Worked on AP Open Invoice conversions and interfaces to and from legacy systems
• Developed positive pay feed from FIMS/ECenter to Oracle
• Developed AP invoice XLS, XMS and EDI conversions
• Developed AP to DIMS, AP Expense to PeopleSoft outbound interface and AP CTX Remittance Advice Interface for Payment Batches
• Developed 1099 Vendor Update Program
• Developed reports like AP aging Summary, Detail Duplicate MICR, PO Variance Report and AP-PO Accrual Invoices Report
• Set up the Descriptive Flex fields in AP
• Developed GL Matching and Post GL Report
• Customized payables to accept long text for EDI invoices
• Developed Vendor Conversion from FIMS in AP and Customer Conversion in AR using TCA Architecture
• Analyzed and designed and developed automated AP Rejected invoice process
• Developed PeopleSoft Employee expense update outbound interface from AP
• Used Loader Scripts and UNIX Shell Scripts

Environment: Oracle 8i, Oracle Financials 11i (11.5.5), Oracle Forms 6i, Oracle Reports 6i, PL/SQL, Sun Solaris Unix

Confidential, AL

Sr. Technical Analyst

Responsibilities:

• Developed personalization thru custom PLL in CRM
• Developed Order Import Interface in OM
• Customized Workflow Notifications
• Modified service contract forms 6i
• Developed Plsql Package to get the Notes in CRM
• Developed WIP schedule date update Interface

Environment: Oracle 8i, Oracle Financials 11i (11.5.3), Oracle Forms 6i, Oracle Reports 6i, PL/SQL, Windows NT 4.0, Sun Solaris Unix, Lotus Notes

Confidential, FL

Responsibilities:

• Evaluated the feasibility planned and estimated time and resources for the project.
• Worked with CFO and CTO in designing the architecture and implemented the project and lead the team from scratch to finish and managed to finish with in the deliverable time there by getting a high ROI
• Successfully did complete Architecture and lead the team for the Web based Financial Digital Cockpit application, which combines data from GL, AP, OM and PO modules
• Involved in Payroll Interface into GL Project
• Developed more than 100 Reports in GL, AP, PO/iprocurement, INV and OM
• Developed Pcard interface scripts.
• Developed scripts to pull data to interface with iprocurement.
• Modified the Pick Slip, Pack Slip Report in OM
• Involved in customizing the PO Requisition Approval Workflow

Environment: Oracle 8i, Oracle Financials 11i (11.5.3), Oracle Forms 6i, Oracle Reports 6i, PL/SQL, Windows NT 4.0, Sun Solaris Unix, Lotus Notes