EXECUTIVE SUMMARY:

• Out of overall 19 yearsof Professional experience (as of Dec, 2015), initial 2 years worked in Process Manufacturing industry as Chemical Engineer and remaining 17 years in IT industry in the field of Oracle Technologies.
• Out of 17 yearsin IT, initial 2 years worked as Oracle Application Developer, next 2 years as Oracle DBA (7.x, 8i, 9i) and remaining 13years as Technical Consultant, Techno - functional consultant and TechnicalTeam Leadin various Oracle Apps (10.5+, 11i and R12) Financial and Manufacturing projects with big MNCs.
• Experience with all phases of SDLC - Requirement Gathering, Fit/Gap Analysis, Solution Design, Application Development, Performance Tuning, Testing (Unit, Integration, User Acceptance), Deployment and Production Support.
• As Technical/Team Lead was responsible for planning to meet delivery deadlines, identifying road blockers, mitigation plan, Business Process modeling, Client-handling, Offshore-Onsite coordination, Resource Management, Organize Status Calls with stake-holders etc.
• Excellent understanding of the functional process flow in Oracle Applications on Order to Cash (O2C)and Procure to Pay (P2P) Business Cycles.
• Extensively worked onapplication modules like General Ledger, Account Receivables, Account Payables, Cash Management, Payments, Purchasing, Order Management,iExpense, iProcurement, Shipping Execution, Inventory, Pricing, Bill OfMaterials, Service Contracts, Install Base, AOL (Flexfields, Profile Options, Lookups etc), Sourcing.
• Experience in customization of WRICEP(Workflow, Reports, Interfaces, Conversions, Extensions and Personalization) components in regard to Inbound/Outbound Interface design using Open Interfaces and APIs for data integration and conversion between Oracle Application modules and various Legacy systems, design/develop custom Oracle Reports, Oracle Forms, Forms Personalization, custom.pll, Bursting with XML/BI Publisher, Workflow Customization, Oracle Alert Customization, Discoverer report modification etc.
• Hands-on experience with the major changes of Oracle Apps r12 - MOAC, SLA, Confidential, newTCA architecture (with respect to Supplier, Banketc), Ledger/Ledger Sets, Business Events.
• Extensive Hands-On experience in writing PL/SQLPackages, Stored Procedures, Functions, Database Triggerswith related tools used during customization using TOAD/SQL Developer, Oracle Forms, Oracle Reports, Workflow Builder 2.6 with AQ and BES, XML/BI Publisher, SQL*Loader, Unix shell script, UTL FILE, FNDLOAD, WFLOAD, Kintana/ITG, HP Quality Center, HP PPM, DataLoader, AppWorx.
• Recent experience of working with EAI (Enterprise Application Integration) team while integration various legacy systems with Oracle Apps through AQ/MQ methodology using XML payload subscription as most secured way of exchanging data.
• Familiarity with Project Management methodologies - Agile, Scrum, AIM, Waterfall etc. and Preparation and review ofrelated documentation templates like BP40, BP80, BR10, RD20, BR30, BR100s, MD50, MD70, CR60, CV10, PT120, RD50, TE20 etc)
• Experience in performance and tuning (PL/SQL) using Cursor Variable, Bulk Collect/Bind, Apply Index and Hintsin queries after Analyze, Explain Plan, interpret trace files withTKPROF.
• Oracle Certified Professional (OCP) - Application Developer
• Strong Interpersonal and Communication skill
• Self-motivated, excellent team player with proven leadership skills (won many client awards)
• Strong perseverance and diligence towards attaining challenging goals

TECHNICAL SKILLS:

Programming: PL/SQL, Shell scripting, SQL

ERP: Oracle Applications R12 (12.1.3), 11i(11.5.10.2, 11.5.8, 11.5.4)

APPS Modules: Oracle payables (AP), Oracle Receivables (AR), General Ledger (GL), Cash Management (CM), Payments (IBY), Purchase Order (PO), Order Management (OM), Oracle Inventory (INV), Shipping Execution (WSH), Bills Of Material(BOM), Routing, Work In Process(WIP),AOL, System and Workflow Administration, iExpense, iProcurement, Sourcing

Databases: Oracle 10g/9i/8i/7.x, Sybase

Tools: Developer 2000, TOAD, SQL*Loader, XML/BI Publisher, AppWorx, DataLoader, MS Project, Visio, ISIX, Workflow Builder 2.6.3

Issue Log Applications: Issue Tracker, Remedy 7.0

Change Management: MS VSS, Dimension Xpress, PVCS (Serena), SVN

Operating Systems: MS Windows 7/XP/2003/NT, SCO Unix, Solaris, AIX

Migration: Kintana/IT Governance, HP Project and Portfolio Management, FNDLOAD, WFLOAD, STAT

PROFESSIONAL EXPERIENCE:

Confidential, Grafton, WI

Oracle Financials and Sourcing Techno-Functional Consultant

Responsibilities:

• Production Support:
• Analyze techno-functional issues for Production Support JIRAs mainly from AR, AP, GL and SLA area….to mention a few….include Regular month-end closing issues like fixing Accounting errors due to customized SLA rules in AR; tweaking existing AutoAccounting setup to derive different Receivable Account for different IC Customers by changing setup at Salesperson level;analyze root cause of failure of AR Invoice Print for invoices being generated against certain CONFIG Sales Order lines; Suggest way to reverse multimillion dollar intercompany AR invoice generated wrongly and became showstopper for month-end closing; Troubleshoot Autoinvoicing errors for Credit Memo against Returns where returns were ‘rejected’ during receiving back at inventory; credit-check for customers and apply hold at the time of booking if required; Budget amount couldn’t be entered for new budget organization; Integration Issue with custom Claims Application and AR;
• Development/Enhancement Support
• Personalize Employee Termination screen to check and stop if they are still defined as active Buyer and in the Buyer page to check if any item is associated with them at that moment
• Modify existing EFT Payment Extract file for HSBC as per modified bank requirements in the Payables Payment Process Requests for existing Mexico operating units
• AR Transaction Consolidation Report modification
• Supplier Pricelist Interface: Upload new item price and push new price in all relevant Blanket Purchase Agreement and Quotation documents
• Interface to update existing Employee Approval Group and Assignments using api
• Build EFT and Check payment format process for Banorte Bank for a new Mexican OU and integrate with Payment Process Profile
• Build Snapshot program for on-hand and in-transit quantities and then generate Report with standard costs in different Inventory Organization of different OU for all those items to show Inventory Valuation during Closing.

Confidential, NYC, NY

Oracle P2P Techno-Functional Consultant

Responsibilities:

• Understanding of AS-IS business process required for providing support by way of troubleshooting, bug-fixing, explaining the business process to the users, generate custom extracts, design reports, provide techno-functional resolution to support tickets in the areas of Payables, Purchasing, iExpense, iProcurement as raised in the support portal of NYSE.…in a timely manner, within prevailing SLA. Also address ad-hoc queries and requests for extracts from users, provide extensive support during month-end, quarter-end.
• Working with Enhancement requests of existing component OR completely New Development involves discussion of technical and functional aspects of the change request with the Functional / Business people, analysis of the Gap, design implementation of related work/changes, estimate complexity and effort, develop and deploy, get sign-off etc.
• Follow Change and Configuration Management activities as needed by Quality and Audit purpose at NYSE while migrating modified /new programs across instances till PROD…involving coordination with users, DBA team, QA Team and NYSE Managers.
• Testing and Performance Tuning of custom components on their way to the Production instance, as per the suggestion from QA Review team.
• Participating in regular Status Call with the client Manager and offshore team members and various stake holders (managers and directors) at NYSE side on-demand basis.
• Coordinating with Oracle on the Service Requests (SRs) for any patches needed from them to get patches for data corruption issues after providing them detail diagnostic data for the related process, coordinating with DBA team for applying patches, testing in lower instances, invite user to test on the same in UAT, getting approval from user, following up DBA to migrate it to the production environment etc.
• ResolvingiExpense issues with Approval Routingwrt Project/non-Project based expenses and Emp/Supervisor hierarchy, Approval Limits, Policy/Schedule setup, Cost-center related issues, Access Authorization issues / Vacation Rule etc, Expense Reports Currency Issue, Issues with Credit Card Transactions
• Resolving iProcurement Approval issues in regard to Approval Group and Hierarchy. Debug Punchout issues with Exchange server and coordinate with supplier side Oracle Support and local DBA for fixing the issue. Rebuild Charge Account for iProcurement. Doing minor cosmetic changes with OAF personalization.
• Familiarity with Period Close issues in Payables and related Accounting and Reconciliation Reports, Addressing Issues with Invoice Approval and analysis against workflow, Invoice Hold, Matching issues against PO-based invoices.
• Experience withAP, PO and REQ Approval Workflows.
• Resolving Closing issues(Close for Receiving, Close for Invoicing) in Purchasingwith Purchase Order shipments in regard to Matching Option and Tolerance Limits sete.g. explaining why closed PO lines re-opened after Invoice Matching and Validation.
• Modifying workflow for Account Generation Process for Project Expense Report Account Generator and Project Supplier Invoice Account Generator.

Confidential, Redmond, WA

Oracle Workflow Consultant

Responsibilities:

• Understand AS-IS 11i business process, discuss to finalize TO-BE approach, identify the Gap, analyze the technical complexity of the suggested design, provide estimate.
• Design and develop new custom WRICEP components as well as retrofit 11i custom components as lift-n-shift into r12 environment, in Finance Tower.
• Hands-on development of new and/or critical customizations e.g.
• GL Journal Import Interface,
• AP Invoice Inbound Interface from various Legacy systems,
• Sales Order Import using API
• Loading Sourcing Rule using API and attaching to Assignment Set at Item Level
• Generate Drilldown details for Payables Journals and send as email attachment,
• Intercompany Recharge Process ( Confidential ) Interface in addition to few lift-n-shift components from 11i instances e.g.
• Netting of AR Invoices,
• TavantPayment Outbound Extract,
• Sales Order Acknowledgement and Commercial Invoice Report using BIP
• Send Payment data to Bank of America(BoA),
• Customer Credit Balance Aging Report,
• Customer Balance Statement Report withBurstingusing BI Publisher,
• Automatic Receipt Creation from Bank Statement,
• Designing Inbound Import Interfaces in Purchasing through Requisition Import, Purchasing Document Open Interface, and Receivables Open Interface (ROI).
• API usage with respect to update/cancel/close of Purchase Requisition, Requisition Import followed by PO creation using api, Customize AutoCreateDoc workflow APIs, cancel/update/close/final-close of PO using APIs, API to check status of a PO, Approval of Requisition and PO thru API by starting corresponding Workflow process, Receiving of PO and Return to Vendor using ROI, Process ASN and Receiving Transactions thru ROI and Receiving Transaction Processor (RTP)
• Also Generation as XML payload information about ASN from RCV Interface tables
• Gather requirements, provide Data Mapping for the import interfaces from legacy systemsand get those verified by business analysts before design freezing.
• Designed RTF templates to meet the layout design for BI Publisher reports. Also in corporate Bursting feature for some reports.
• Performcode review, review MD70 and TE20, suggest code tuning, and participate in integration testing for components developed by team members.
• Coordinate with webMethods and Apps DBA team for data transmission policy and setup activities related to inbound and outbound interfaces
• Coordinate with offshore team and guide and align the team with the client expectation and delivery timeline and resolve internal issues at the first level, follow up, discuss and close the clarification issues raised by offshore developers with the client side analysts to ensure no slippage in terms of delivery.
• Use Dimension Xpress and HP Quality Center for migration of code across instances.
• Project Management activities - Conduct team meeting with offshore team, Knowledge sharing sessions, Prepare status report, Share various Performance matrices in meeting with the client

Confidential, Milwaukee, WI

Onsite Technical/Team Lead

Responsibilities:

• Discuss with Business Analysts and Legacy system owners and EAI Middleware team to discuss and finalize the design of TO-BE design approach and develop schematic diagram for the business process flow of the integration with various Legacy systems.
• Support to implementAQ/MQmethodology of data transformation and transmission with legacy subsystems through middleware layer using DBMS AQADM package to create queue table and queue, add subscriber to the queue, use dbms transform to create transformation and then how to enqueue/dequeue the messages.
• Understand Data Mapping elements and build EI Mapping templates for inbound and outbound interfaces.
• Design and review technical MD70s for all the new integrations.
• Use seeded and custom Business Events (replacing Database triggers) and use that to trigger generation of XML payload for outbound extract to Legacy systems.
• AME implementation with iProcurement and experience in implementing complex AME rules.
• Work on conversion/interface deliverables related to AP, GL, OM, AR, PON and INV e.g. Supplier and Payment extract in AP, GL journal extract for Hyperion system, INV Item Import Interface, Drop-ship Interface, Customer Creation thru APIs, Sales Order Extract, Sales Order Hold Extract, AR Invoice Import Interface, Service Contract Migration thru APIs, Pick Release and Ship Confirm Interface using APIs, Change Item of InstallBase instance thru API
• DevelopSupplier Conversion interface program to get all suppliers information into Oracle applications from legacy system.
• Workon interfaces of Accounts Payables import invoices data into Oracle applications.
• Coordinate and Track progress of deliverables from offshore, participate in smoke and integration testing with all concerned parties and get client sign-off.
• Working with Oracle Approval Management Engine (AME) and to set up RBAC(Role Based Access Control) for various Transaction Types to trigger Approval Rules and generate Approver List.
• Project Management activities - Conduct team meeting with offshore team, Knowledge sharing sessions, Prepare status report, Share various Performance matrices in meeting with the client

Confidential, Miami, FL

Technical/Team Lead

Responsibilities:

• Document &Perform Playback of understanding of existing critical business processes and demonstrate increased maturity and support acumen at successive Quality Gates. Coordinate Plan and Monitor Production Support activities with Confidential and Offshore team in Chennai, India.
• Resolve high severity tickets for failed interfaces in AP, AR, OM, PO, PON and INV, debug the issue, communicate with user and third parties and get corrected datafile for reprocessing or coordinate with DBA and Unix administrator members when outbound interface fails to reach legacy system having payment or check details, for example.
• Perform iExpense setup activities using DataLoader.
• Investigate and report Interface issues with data import in Oracle Apps for PO, AP application modules using ISIX.
• Administer PO and RequisitionWorkflows failed with notifications, resubmit and reprocess.
• Supportduring Month-End close activities.
• Raise, Monitor, Conduct OWC session with Oracle Engineers and also coordinate with internal DBA team to apply any required patch as suggested by Oracle against the Service Requests raised in Metalink.
• Work on CRs and review design, check performance and finally plan to deliver on time by coordinating with offshore team.
• Fix the reported issues in Development instance, migrate to the Prod instance after successfully completing the UAT, through IT Governance.
• Perform root-cause analysis (RCA). Prepare RCA document, Discuss remediation with the client manager to ensure non-repetition of same issues happening again, educate all involved parties/users for alternate better approach to be followed to avoid issues.
• Project Management activities - Conduct team meeting with offshore team, Knowledge sharing sessions, Prepare status report, Share various Performance matrices in meeting with the client

Confidential

Project Manager

Responsibilities:

• Planteam ramp-up and resource on-boarding
• Generate detail Task Breakdown matrix and set Project Milestones
• PerformAS-IS analysis of the existing custom components and suggest how they can be handled in future with the implementation of OIC
• Build consensuson Risk Mitigation Plan, Disaster Recovery Strategy
• Define and setup escalation channels
• Discussion with end users and business architects to gather and understand business requirements
• Freeze the requirement and get ‘sign off’ from business to start development
• Business Process Modeling, Fit-Gap Analysis

Confidential

Senior Developer, Technical/Team Lead, Project Manager

Responsibilities:

• Resource Management, Task Allocation&conduct Internal Training,
• Communicate routinely to the team, offshore and onsite, discuss issues, identify deliverables getting into Critical Path and mitigation plan for underlying Road Blockers.
• Escalation Management.
• Gap Analysis for new roll-out related components.
• Monitoring Delivery progress as per delivery deadline.
• Performance appraisal of Team.
• Build PoC(Proof of Concept) documents, brief Technical capabilities to bid for new in-house projects in several autonomous business units under Confidential Europe.
• Involved in discussions with Business’ Functional team to understand Business Requirements, prepare High-level process design document. Get the design approach approved from vertical track team and discuss Technical design from the Tech Review committee, perform Impact Analysis and explain the technical aspects of the RICE component to the team.
• Design and developand test/tune and document
• Deutsche Bank Payment Process Interface
• GL Fiscal Detail Drilldown Report
• GL Balance Extract
• AP Invoice Aging Report
• Commercial Invoice Report
• Blanket PO Validation Package
• PO Outbound Package
• Supplier Remittance Details Report
• Customize OM COGS Account Generator workflow function to assign a new value to Accounting Flexfield.
• Ensuring adherence to coding standards as per TCS & Confidential Internal Quality standards
• Preparing Unit Test Plan and Review Unit Test Execution before migration to higher instance.
• Review Performance and suggest tuning of the code, if required.
• Coordinate with other support team - Apps DBA, Unix Administration, Change Control group
• Implement ZOOMfunctionality usingForms Personalization from Order Organizer form to shipping transactions form and also populate order number dynamically in destination form.
• Conversant with different stages of OtC cycle activities - Order Entry, Booking, Pick Release, Ship Confirm, Autocreate Deliveries, Generating invoice through Standard AutoInvoice and Custom Invoice Import, Fulfillment, Integration of OM with Service Contracts and Install Base, Pricing Modifies/Qualifiers, Drop Shipment, Internal Sales Order, Customer Creation, Item setup in Inventory, Processing Cash Receipts, Defaulting Rule in OM, Invoicing and Accounting Rule, Customer Agreements, Credit Checking for Customer, Backorder, Processing Constraint, Back-to-back Order, Hold and Release of SO
• Use custom.pll to personalize forms to alter the Record Group (query for LOV), take user input via message and take action accordingly, modify underlying pl/sql function as per requirement.
• Implement Bill Presentment Architecture for AR invoices - define data source, design primary and detail pages in the Template, Assign Templates using Template Rules and matching criteria, setup prints
• Design and developand test/tune and document
• AR Invoice report customization for various countries
• Packing Slip Report
• Delivery Note Report
• Sales Order Acknowledgement Report
• Sales Order Extract and interface design using OE ORDER PUB API
• Check Printing Report using XML Publisher
• Create Workflow Notification whenever new item added in Inventory
• Design and developfollowing reports for different business units in different countries in Confidential Europe
• Proforma Invoice Report
• Min-Max Planning Report
• AP Invoice on Hold Report
• Purchase Orders with Invoice Details Report
• Develop Custom Auto Invoice program and Customer Import program
• Used Data Loader to load inventory locators’ information into the Oracle Applications.
• Modify queries to enhance performance for some Discoverer reports in PO (like Purchase Price Variance Report) and AR.
• Find solution for problems in Oracle Metalink as well as raise and monitor TAR for resolution.
• Experienced different levels of Order-to-Cash and Procure-to-Pay processes from creating requisition, approving requisition, auto-creating purchase order, approving purchase order, sending PO to vendor, receiving goods, creating Invoice, matching the invoice against PO, Paying the supplier and Transferring payment information to GL.
• Register executables, concurrent programs, creating parameters, registering to request group be done through a script programmatically using FND PROGRAM package. Register custom table and columns using AD DDpackage in custom apps schema.
• Migrate the codes/scripts/executables using IT Governance tool across different instances.

Confidential

Senior Technical Consultant

Responsibilities:

• Write Technical Specification (MD70) from Functional Specification (MD50)
• Development and Enhancement of custom Reports and Interfaces in Accounts Receivables and Order Management
• Custom AR Invoices Report for Organization and Person
• AR Consolidated Billing Report,
• Netting interface of Open Customer Invoices in AR against Receipts and Credit Memos
• Sales Order Extract using UTL FILE
• Import Order creation for customer using TCA APIs: In this object, populated the data into interface table of order and customer. Created the new customer using TCA APIs e.g.hz cust account v2pub, hz location v2pub etc. Then run the order import to put the data into oracle base tables.
• Prepare Unit Test specifications and documenting Executed Unit Test Plans.
• Performance Tuning of the code before delivery
• Programmatically RegisterReport, Interface concurrent programs

Confidential

Senior Technical Consultant

Responsibilities:

• Write Technical Specification (MD70) from Functional Specification (MD50)
• Enhancement of custom Reports and Interfaces in AP, AR, OM, OPM, INV in 11i
• Agent Commission Distribution Report
• Shipment Schedule / Summary of non-moving stock
• Resource Variance Report
• Item Reservations Report
• Pick Slip report
• Margin Analysis Reportto pull all the sales orders that are ship confirmed and Invoices that are created manually and created through Auto Invoice
• Modified Payment Batch Formatting program
• Involved in Auto Lockbox interface program to import receipts from banks.
• Prepare Unit Test plans, test cases and documenting Executed Unit Test Plans.
• Registering all AOL components from tables to Reports/Custom Procedures/Value Sets into Oracle Applications
• Performance Tuning of the code before delivery
• Programmatically Register Report, Interface concurrent programs

Confidential

Apps Manufacturing Technical Consultant

Responsibilities:

• Assign the ticket in my name, get the latest MD70 and code version, reproduce the error in lower instance (DEV or TEST), clarify with the user about issue, migrate the fix to a latest cloned instance, get it tested by user and migrate to higher instance using Kintana upon user approval.
• For some major changes like global interfaces/reports, we were to represent the approach and solution to the Technical Review committee with Impact Analysis and get the ‘go-ahead’ before deploy the fix in TEST instance before migrating to PROD.
• Used to monitor several routine inbound / outbound interfaces, through controlled sequential execution of scripts, via AppWorx scheduler, notify failure of the chain and take corrective action as needed from analysis.
• Some of the important and critical reports/interfaces I used to take care across OM, PO, INV, GL, WSH, WIP applications were
• GEMS AR Invoice printing report for New Zealand,
• GEYMS Inventory Summary Report for Japan
• Workflow package related to Requisition Approval
• Cancelled PO Releases Report
• PO Receipt Error Report
• PO Requisition Interface
• PO Conversion
• Dropship ASN Re-Processing RCV Transactions Interface
• ASN Extract using UTL FILE
• ASN Import
• China Blanket PO Release Report
• Purchase Requisition Import
• Inventory Material Issue Report
• Pick Slip Report for Canada
• Proforma Invoice report for Norway
• Bank Statement Loader Interface
• Item Master Detail Extract for CSI
• Creating Drop Ship Extract
• Order Import Interface for Canada
• Item and Categories Interface
• GL Daily Rates Interface
• AP Trial balance Report
• Working with Unix Shell Scripts, SQL Loader and UTL FILE package
• Modify Oracle Alerts query and Messaging
• Auto invoice Interface for AR Invoice Loading from External systems