EXECUTIVE SUMMARY:

• Overall 16 years of Professional experience; initial 2 years in Process Manufacturing industry as Chemical Engineer, then later 14 years in IT industry in the field of Oracle Technologies.
• Out of 14 years in IT, initial 2 years as Oracle Application Developer, next 2 years as Oracle DBA (7.x, 8i, 9i) and remaining 10 years as Technical Consultant / Technical Lead in various Oracle Apps (11i, 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.
• Extensively worked on application modules like General Ledger, Account Receivables, Account Payables, Cash Management, Payments, Purchasing, Inventory, Order Management, Shipping Execution, Bill Of Materials, Work in Process, AOL (Flexfields, Profile Options, Lookups etc)
• Experience in customization of WRICEP 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 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.
• Good understanding of the functional flow in Oracle Applications on Procure to Pay (P2P) and Order to Cash (O2C) Cycle.
• Extensive Hands-On experience with related tools used during customization - TOAD/SQL Developer, Oracle Forms, Oracle Reports, Workflow Builder 2.6, XML/BI Publisher, SQL*Loader, Unix shell script, UTL FILE, FNDLOAD, Kintana/ITG, HP Quality Center, HP PPM, DataLoader, AppWorx.
• Used Bill Presentment Architecture in Account Receivables.
• 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, AIM, Waterfall etc. and related documentation templates like BP40, BP80, BR10, RD20, BR30, BR100s, MD50, MD70, CR60, CV10, PT120, RD50, TE20 etc)
• Preparation of documents related to customizations as per AIM (MD070, TE20, MD120)
• 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
• Strong Interpersonal and Communication skill
• Self-motivated, excellent team player with proven leadership skills (own client awards
• Strong perseverance and diligence towards attaining challenging goals

TECHNICAL SKILLS:

Programming: PL/SQL, Shell scripting, SQL

ERP: Oracle Applications R12, 11i (11.5.10, 11.5.9, 11.5.8)

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

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

Tools: Developer 2000, TOAD, SQL*Loader, XML/BI Publisher, AppWorx, DataLoader

Issue Log Applications: Issue Tracker, Remedy 7.0

Change Management: MS VSS, Dimension Xpress

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, Davidson, NC

Finance 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 critical deliveries e.g.
• GL Journal Import Interface,
• AP Invoice Inbound Interface from various Legacy systems,
• Generate Drilldown details for Payables Journals and send as email attachment,
• AR Invoice Import Interface,
• Intercompany Recharge Process (AGIS) Interface
• Netting of AR Invoices,
• Tavant Payment Outbound Extract,
• Send Payment data to Bank of America (BoA),
• Customer Credit Balance Aging Report,
• Customer Balance Statement Report with Bursting,
• 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.

Confidential, Milwaukee, WI

Onsite Technical 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.
• 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, PO and INV e.g. Supplier and Payment extract in AP, GL journal extract for Hyperion system, INV Item Import
• 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 knowledge of Oracle Approval Management Engine (AME) and its components and how it’s driven by Workflow, how RBAC is implemented with AME.

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 Confidential and Offshore team in Chennai, India.
• Resolve high severity tickets for failed interfaces in AP, 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.

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 to prepare
• Freeze the requirement and get ‘sign off’ from business to start development.

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, plan for mitigation.
• 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 Purchasing 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 through Forms Personalization from Order Organizer form to Shipping transactions form and also populate the order number dynamically in destination form.
• 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
• Ship Confirm Extracts
• Packing Slip Report
• Delivery Note Report
• Sales Order Acknowledgement Report
• 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
• 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 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
• 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 Confidential .
• 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.