SUMMARY:

• 20+ years of techno - functional experience in IT / ERP / ORACLE E-Business Suite.
• Extensive experience of customizing vanilla ORACLE code and developing custom code to seamlessly integrate with ORACLE vanilla code / functionality.
• Extensive hand-on experience of designing, coding, testing, migrating and documenting custom interfaces using PL/SQL, SQL*Plus, Stage Tables, Flat Files, SQL*Loader Scripts.
• Extensive experience with Q2C (quote to cash), Revenue-Recognition, Export Compliance, P2P (procure to pay)
• Extensive experience creating: BRDs, Gap Analysis, Functional/Technical Specifications, Process Diagrams, Test Scripts / UAT/CRP Testing Incident Reporting / Post Production Support / Trouble-shooting Document
• Extensive experience of collaborating with: Business Stake Holder / End Users / Auditors / 3rd Party Vendors / BAs, Developers, DBAs and Release Engineers
• Constant interaction with user/business community to understand the user/business requirements/issues and to provide them functional/technical solutions.

SKILL SET:

• ORACLE Applications
• Versions: R12, 11i , 10.7
• Modules:
• RevPro, Vastera, TradeBeam. TradeSphere, Model N.
• ORACLE Tools
• SQL*Plus, PL/SQL ( Procedures, Functions, Triggers etc. )
• ORACLE Developer Suite 10g. Forms 10g/ 6i, Reports 10g/6i
• API s and Custom API (ORACLE 11i)
• WorkFlow Builder, Message Designer, BI Publisher
• SQL*Loader, Forms Personalization
• Databases
• ORACLE 11g, 10g, 9i 8I, 8, mySQL
• Languages
• PL/SQL, Perl, VBA (Excel )
• Other Tools
• TOAD, ANT, Shell, Kintana, awk/sed/grep, Perforce
• ClearCase, CVS, Word/PowerPoint/Visio, AutoSys, $U, cron
• Jira, GIT, HP - PPM (Kintana)
• Data Visualization/Manipulation
• Model / Design / Document
• Excel: Pivot Tables, Vlookup, Array, List, Charts, Filter, VBA
• Tableau, AIM (3.0) Visio, Power Point,

PROFESSIONAL EXPERIENCE

EBS Consultant

Responsibilities:

• Reports customization for the Yahoo “Display” Customer Statements
• Analysis + Remediation of various PO reports in Discoverer
• Customizing the “Auto Receipt” in Purchasing for ‘expense’ items
• XML Bursting for mailing ‘Rebate Statements’ to customers of Yahoo
• Conversion of RTF templates into XLS templates for BI Publisher
• Forms enhancement for the “Invoice Workbench”.
• PO form personalization for India’s GST (goods and services tax)
• Bug fix for the “Search” Gemini data push to DMZ
• Lockbox files customization to fetch the files using SFTP protocol from Citibank
• Remediation of various CEMLIs for R12 upgrade
• Created Purchase Orders, Sales Orders Inventory extracts for analysis by software “AnaPlan”.

Environment: ORACLE 11i/R12:, Purchasing, Accounts Payable/Receivable, SQL, PL/SQL,

Confidential

ORACLE Developer

Responsibilities:

• Developed custom modules to perform (a) Party Merge, and (b) Customer Merge.
• Worked on interface to extract Transactions (TRX) from ORACLE AR to RevPro Stage table.
• Developed API to allow RevPro to get daily currency conversion rates from EBS.
• Developed “Waterfall” report give summary of revenue from RevPro and AR into a single report. (This is a by Account, by Product and by Period.)
• Developed Reconciliation Report to reconcile among 'Order Management', 'Accounts Receivable' and 'RevPro'
• Created interface for transmitting Invoices to Taiwan Tax Authority.
• Worked on Forms Personalization for Transaction Form
• Developed “Escheatment” report for detailing the unapplied payments to the Government.

Environment: ORACLE R12, 11i , REVPRO, PL/SQL, Unix, HP PPM

Confidential

Milpitas , CA 

Sr ORACLE Analyst

Responsibilities:

• Worked on requirement gathering, functional specification, technical design, UAT for B2B integration for Contract Manufacturer Flextronics and 3 rd Party Logistics Flex. This B2B integration allowed FireEye to place Orders and have those shipped by using the Contract Manufacturer and supply the Spares to various Subinventories. ORACLE Business events were used to send the EDI signals and process the ASN.
• Worked on Personalizing the Forms to permit PO account generation.
• Worked on requirement gathering to send Shipment Notifications via Business Events.
• Requirement gathering for the Purchase Order Print for global usage.
• Check Printing for India OU
• Implement the policy “after-the-fact” for Purchasing

Environment: ORACLE AIM, ORACLE R12 , PL/SQL, Message Designer, WorkFlow , BI Publisher

Confidential

Sunnyvale , CA

Sr ORACLE Programmer

Responsibilities:

• Worked with Scotia Bank / Payable Clark for implementing the “Positive Pay” functionality. Created BRD and Functional Specification for implementing the process.
• Worked with the Business Users to understand the matrices to report the “Cycle Time” for the orders from their Booked status to Shipped status. Created Functional Specification for the new report “Book 2 Ship Cycle Time”.
• Worked with the Business Stakeholder for the reporting requirements for (a) Bookings (b) Revenue (c) Deferred Revenue across different Regions (Operating Units)
• Worked in Tableau dashboard generation using ORACLE EBS details. Order Analysis dashboard was the primary focus.

Environment: ORACLE R12 , ORACLE Report 10g , BI Publisher, Tableau, Shell.

Confidential

Santa Clara , CA F

Tech Lead 

Responsibilities:

• Understanding the FASB standards as they are applied for the Revenue Recognition.
• Making recommendations for the product development / upgrade
• Upgraded the RevPro implementation at Blue Coat, for E-Business Suite 11.5.10
• Implemented a Job Scheduling system for RevPro

Confidential

San Francisco , CA

Analyst / Architect

Responsibilities:

• Interviewed various Business Stakeholder / SMEs to understand the Regulation E, and determine the ultimate aim to get the Bill Pay to comply.
• Analyzed the 4 types of Bill Pay occurring at Wells Fargo and the corresponding processing.
• Documented the findings in the BRD, and Flow Diagram.
• Architected the changes in the "Batch" processing necessary to make the Bill Pay flow the Online Banking Station details thru various systems. Prepared the FSD.

Environment: ORACLE 11i (11.5.10), ORACLE Forms (6i), Discoverer, BI Publisher, PL/SQL, PL/SQL, SQL, PERL, Shell.

Confidential

San Francisco , CA 

Sr. Analyst 

Responsibilities:

• Designing / developing / testing / documenting and supporting changes/improvements in the code for Credit Management operations, with focus on CMO (Commercial Mortgage Operations).
• Designed / coded “Health-check” that is used to monitor the health of database.
• Designed / developed Autosys jobs to achieve/improve automation.
• Production support for failover / failback

Environment: ORACLE 10g, PL/SQL, SQL, PERL, C-Shell, ERwin, AIM.

Confidential

San Francisco , CA

Sr. Analyst

Responsibilities:

• Integrating the pipelines and customers from various CRMs into aggregator CRM.
• GAP Analysis and Designing / coding the mapping for data-import from Wachovia into Wells Fargo for the Wholesale Banking for customers, and products.
• ORACLE 10g upgrade for ETL system WICS and HUB.
• Designing / developing / testing / documenting and supporting changes/improvements in the code for HUB data-bus.
• Performing “ ETL ” for various datafeeds that are in form of flat-files, staging tables, SOAP requests.

Environment: ORACLE 10g, PL/SQL, SQL, PERL, C-Shell, AIM.

Confidential

Santa Clara , CA

Sr Analyst/Programmer

Responsibilities:

• Designed/developed interfaces to integrate 3rd Party package “Model N” with ORACLE Apps for ‘Prices’, ‘Items’, ‘Customers’ and ‘Orders’ using PL/SQL Packages and SQL*Loader scripts. Used ERwin to model the interface.
• ORACLE GL: Setup GL for a new set-of-books / currency for Hong-Kong
• ORACLE Payables: Set Up Manual Check Payments
• ORACLE WIP: Change the Account Generator to have custom Charge Account
• ORACLE Order Management: Customization of WorkFlow for a new Order Type
• Coded several Forms (6i), CUSTOM.pll, and Reports(6i) customizations
• Coded several interfaces to upload Excel generated CSV files to perform updates in ORACLE database using PL/SQL “UTIL FILE” and Application Express (APEX)
• Coded shell scripts for data extraction, data load

Environment: ORACLE Apps 11i (11.5.6, 11.5.10) , PL/SQL, Application Express, WorkFlow, Forms 6i, CUSTOM.pll, Reports 6i, Shell/PERL, AIM.

Confidential

Santa Clara , CA

Sr Analyst/Programmer

Responsibilities:

• Export Compliance Upgrade (Vastera to TradeSphere). Conducted GAP Analysis, coding, testing - Intergation+UAT.
• Coded several Web Pages using Application Express to give users intelligence and conducted UAT for the Web Pages developed
• Tax Code change automation
• Data-Warehouse development/support for GSA Price List, Pay-roll Extract.
• Coded shell scripts for data extraction, data migration, data load
• Data-Warehouse development/support/maintenance GARP, MARS, SRU, ORION (Home-grown data warehouses of SGI for billing/booking/backlog data).
• Forms Customization for Export Compliance using Forms 6i (Customer Entry form, Order Entry Form.)
• Coded Web Pages using Application Express (ApEx) to give users quick ad-hoc data.
• SOX testing - ASIM1B, ASIM1C
• Helped Business Stake-holder with creating charts (Bar, Line) using extracts from ORACLE Apps. This was performed using Tableau.

Environment: ORACLE Apps 11i (11.5.7, 11.5.10) , PL/SQL, Application Express, Forms 6i, Reports 6i, Shell / PERL, AIM, Tableau .

Confidential

Cupertino,  CA

Sr Analyst/Programmer

Responsibilities:

• Extensive testing of LiveArchive on Unix / Linux / Windows operating systems.
• Making Build/Deploy using ANT.
• Design of front-end tool “Compatibility Matrix” that is used for “Deploy”.
• Vendor-management. Work-allocation / Status-check / Code-review.

Environment:  ORACLE Apps 11i (11, 11.5.6, 11.5.7, 11.5.9. 11.5.10 ), PeopleSoft Applications, ANT, Unix Shell, AIM.

Confidential

Santa Clara, CA

Contractor

Responsibilities:

• Use of the API's in MRP (CALL ATP) and OM (PROCESS ORDER)
• Use of Library 'CUSTOM.pll'
• Forms 6i features and the Zoom functionality
• PL/SQL libraries for Concurrent Job
• SQL*Loader script and PL/SQL procedure to load/process the on-hand-quantity in the Material Transaction Interface.

Environment: Solaris, ORACLE 11i (OM), FORMS 6i, Reports 6i

Confidential

Sun Microsystems., Newark, CA

Software Engineer 

Responsibilities:

• Pilot of ORACLE 11i OM/AR modules
• Gap Analysis of Advaced Pricing with special focus of ‘Buyback’ type of Modifier
• Analysis of Trading Community Architecture in AR
• Customization for Sun’s Upgrade Allowance Program, which allowed Sun to buy-back old hardware and to offer new at a discount. (In essence this allowed ORACLE 10.7 OM to handle regular and return lines within the same order.)
• Customization for ‘iPlanet’ Orders (via Zoom)
• Order Import Customization
• Customization of ‘Enter Orders’ for to handle different type of TAX entries
• Analysis of storing ‘extra’ pieces of information for ORDERs that resulted in creation of additional tables (called Extension tables) for Order Headers and Lines. Created DFFs to handle different requirements for different Organizations for data capture.
• Invoice Import Customization
• Various flavors of ‘Age Trial Balance’ reports

Environment: SOLARIS, ORACLE Financials 7.8, AOL, FORMS 2.3, PL/SQL, Reports 2.5, ORACLE Financials 11i (OM/AR/INV)

Confidential

San Jose, CA

Team Lead 

Responsibilities:

• Created the main one page report which captured the whole of Sales / Revenue picture for Novell. This report was a complex Cross-Tab report
• Created various ‘views’ that facilitated creation of reports for AR for the Team
• Created the coding standards for the reports

Environment: Sun, HP-9000, Sun Solaris, HP-UX, ORACLE Financials 11 (OM/AR), AOL, ORACLE 8.0, PL/SQL, Reports 2.5