EXECUTIVE SUMMARY:

• Out of overall 18 years of Professional experience (as of Oct, 2014), initial 2 years worked in Process Manufacturing industry as Chemical Engineer and remaining 16 years in IT industry in the field of Oracle Technologies.
• Out of 16 years in IT, initial 2 years worked as Oracle Application Developer, next 2 years as Oracle DBA (7.x, 8i, 9i) and remaining 12 years as Technical Consultant / Technical Lead / Project Manager in 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.
• Project Management / Tech Lead activities like 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.
• Extensively worked on application modules like General Ledger, Account Receivables, Account Payables, Cash Management, Payments, Purchasing, Order Management, iExpense, iProcurement, Shipping Execution, Inventory, Pricing, Bill Of Materials, Service Contracts, Install Base, AOL (Flexfields, Profile Options, Lookups etc).
• 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, AGIS, new TCA architecture (with respect to Supplier, Bank etc), Ledger/Ledger Sets, Business Events.
• Excellent understanding of the techno-functional flow in Oracle Applications on Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Extensive Hands-On experience in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers with 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 of related 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 Hints in queries after Analyze, Explain Plan, interpret trace files with TKPROF.
• 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

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

PROFESSIONAL EXPERIENCE:

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 on 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 fix bug in the "Oracle's seeded” code/functionalities. Also providing requested extract to Oracle by running the diagnostic scripts, 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.

Confidential, Redmond, WA

Oracle Workflow Consultant

Responsibilities:

• To work on the customizations related to Oracle Workflow. Nintendo was scheduled to Go-Live in UAT in the last week of January with a dozen of Workflows in the areas of Oracle Purchasing (Purchase Order and Requisition approval, Requisition and PO Account Generator), Payables (Payable Invoice approval), Order Management (COGS related and OE-Line) which were very critical for the business and were in real bad shape.
• My contribution was expected over a brief period, but it was highly challenging and demanded extended hours of work to meet the timeline.
• I had to quickly understand the functionalities and bridge the gap between intended functionality and things coded till that point in time when I took over, make necessary changes, first time right, so that these workflows don’t fail itself during UAT phase and various interfaces that were built upon these workflows should not be also failing due to malfunctioning of any of these workflows.

Confidential, Davidson, NC

Onsite Technical Lead

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
• Generate Drilldown details for Payables Journals and send as email attachment,
• Intercompany Recharge Process (AGIS) Interface
• Netting of AR Invoices,
• Tavant Payment 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 with Bursting using BI Publisher,
• Automatic Receipt Creation from Bank Statement,
• ACS Loopback interface
• Gather requirements, provide Data Mapping for the import interfaces from legacy systems and 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.
• Perform code 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 Lead - Interface Team

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 implement AQ/MQ methodology 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.
• Work on conversion/interface deliverables related to AP, GL, OM, AR, OKS 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
• Develop interface programs to get all suppliers information into Oracle applications from legacy system using Open Interface as well as API’s to create Suppliers.
• Work on 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 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 Carnival and Offshore team in Chennai, India.
• Resolve high severity tickets for failed interfaces in AP, AR, OM, PO 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 Requisition Workflows failed with notifications, resubmit and reprocess.
• Support during 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:

• Plan team ramp-up and resource on-boarding
• Generate detail Task Breakdown matrix and set Project Milestones
• Perform AS-IS analysis of the existing custom components and suggest how they can be handled in future with the implementation of OIC
• Build consensus on 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 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 develop and test/tune and document
• Deutsche Bank Payment Process Interface
• GL Fiscal Detail Drilldown Report
• GL Balance Extract
• AP Invoice Aging Report
• Commercial Invoice 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 ZOOM functionality using Forms 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 develop and 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
• Provided support and fixing of production issues related enhancement and customization of various inbound and outbound interfaces, reports and forms personalization that were migrated from US instance.
• Design and develop following 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 DD package 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 Register Report, 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 Report to 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:

• In the Production Support team issues for reports and interfaces were assigned to the team and work had to be finished within agreed time-frame based on severity. If the reported issue was not a bug rather a change request or enhancement and estimated to be an effort of more than two days then the issue/ticket was delegated to Job Jar team. Once a ticket was assigned we had to quickly locate the bug/problem area in the code from the issue details logged by the customer in the internal support portal of GE.
• 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
• Inventory Material Transaction Report (Discoverer)
• Inventory Material Issue Report
• China Blanket PO Release Report
• Pick Slip Report for Canada
• Proforma Invoice report for Norway
• Loading FAD Customer for Europe
• Bank Statement Loader Interface
• Item Master Detail Extract for CSI
• Creating Drop Ship Extract
• Order Import Interface for Canada
• ASN Import
• Item and Categories Interface
• PO Requisition 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

Confidential

Oracle9i DBA

Responsibilities:

• Backup, Tuning, LogMining, Resource Mgmt Plan, Space Mgmt.
• Maintenance activities of creating User and their Access privileges
• Design and Generate database schema for Analyst - De-normalization. Consolidate business data from all sources/systems across the enterprise for the most realistic insight of the business
• Extract hidden and 'meaningful' data from the tables of the master schema applying Data Warehousing concepts (how to build & deploy STAR schema, what are the Fact and Dimension tables etc). Tune codes using ANALYZE, EXPLAIN PLAN, OPTIMIZER HINTS, TKPROF etc
• Implemented Oracle 9i DataMining Features in Business Intelligence module of the above product based on 'Naïve Bayes' and 'Association Rules' algorithms for the predictions, classifications and finding patterns and analyzing co-occurring events.
• Implemented Transparent Gateway Heterogeneous Services Connectivity feature of Oracle 9i to pull application data from non-Oracle databases. Also used 9i’s External table feature for data import from Legacy.