Swarup Nandi

[acy6gn@r.postjobfree.com +1-732-***-**** (M) Greensboro, NC]

Executive Summary

** ***** ** ********** ** Technical consultant in Oracle Apps (10.5+, 11i and R12) Finance and Procurement modules [Payables, Receivables, General Ledger, Sub-Ledger Accounting, Cash Management, Payments, Purchasing, iProcurement, iExpense, Advanced Pricing, Order Management, Shipping, Inventory, AOL, EBTax etc].

Excellent understanding of Finance and Procure to Pay (P2P) Business processes.

Experience in customization of WRICEP components - 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, Custom Forms & OAF Personalization, Bursting with XML/BI Publisher, Workflow, Alert and Discoverer reports.

Hands-on with latest features used in r12 – MOAC, AME, TCA (Customer, Supplier, Bank), SLA, Business Events.

Extremely skilled in PL/SQL Packages, Procedures, Functions, Triggers,, SQL*Loader, Shell script, UTL_FILE, FNDLOAD/WFLOAD/XDOLOAD, Oracle Forms/ Reports, Workflow Builder, Discoverer, BI Publisher, TOAD, MS Office, WinSCP, DataLoader, webADI, SVN, PVCS, JIRA, Kintana, STAT, Panaya.

Experience with all phases of SDLC and worked with Project Management methodologies – Agile, Scrum, AIM, Waterfall and written Functional and/or Technical design documents.

Experience in performance 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

Certification

Oracle Certified Professional (Application Developer) in 2000;

Oracle Programmer and Oracle Developer 2000 Programmer from Brainbench

Professional Training/Courses

Year

Title

Location

Organized By

2001

Software Testing

Bangalore, India

QAI & Ushacomm India Ltd

2001

Advanced Course on Unix

Kolkata, India

Ushacomm India Ltd & B.E College, Shibpur, Howrah

2004

11i Financial Functional Foundation

Kolkata, India

IBM & Oracle University

2006

11i Advanced Supply Chain Planning Foundation

Kolkata, India

TCS & Oracle University

2009

AMDOCS Billing System - Ensemble

Mexico City, Mexico

TCS Mexico & Amdocs

Recognition

Alcoa YES (Your Example Shines) Award as Offshore Technical Lead - "for outstanding contribution and efforts carried out in establishing and coordinating Europe RICE Development team in 2005". [Feb, 2006, Kolkata, India]

Alcoa YES Award as Onsite Technical Lead - for "contribution and efforts done to deliver EBS RICE components in Europe". [Oct, 2008, Szekesfehervar, Hungary]

Professional Experience

A.With RJT Compuquest Inc [Oct 2012 to Till date]

Client : Herbalife, Winston-Salem, NC Apr 2016 – Feb 2017

Project : R12 Upgrade Project

Role : Oracle Financials Technical Consultant

Responsibilities

Upgrading existing 11i components – Database Package or Oracle Reports concurrent programs from Payables, EBTax, General Ledger modules…mainly in regards to MOAC, Obsoleted tables in r12, Editioned view and Grant related constraints.

Build new BI Publisher based reports using seeded ‘Account Analysis Reports’ and ‘Third Party Balance Reports’ for existing Account Ledger by Account/AFF or Supplier Balance Report by Account/AFF.

EFT and Check Payment Process Profile customization with Template to include new xml tag elements for EMEA and LatAm countries

Change and Configuration Management scripting activities during inter-instance migration during CRP using FNDLOAD, XDOLOAD.

Upgrade several custom forms for r12 and develop a couple e.g Invoice Interface Correction, Receipt Error Correction, iExpense Employee Setup Details

Generate FND Debug Log Messages for EBTax Issue Diagnostics. Upgrade existing EBtax related various reports and interfaces.

Client : Regal Beloit Corporation, Grafton, WI Dec 2014 – Mar 2016

Project : QAD Project and Production Support

Role : Oracle Financials and Sourcing Technical Consultant

Responsibilities

Production Support :

-Analyze techno-functional Support JIRAs mainly from AR, AP and SLA area…Regular month-end closing issues like fixing Accounting errors in AR; tweaking existing AutoAccounting setup to derive different Receivable Account for different IC Customers at Salesperson level; AR Invoice Print issues; IR-ISO and Dropship process related Issues

Development/Enhancement Support

-Supplier Pricelist Interface: Upload new item price and push new price in all relevant Blanket Purchase Agreement and Quotation documents using Pricing APIs.

-Personalize Employee Termination screen to validate existence of active Buyer and association of it with any item in the Buyer page

-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

-Interface to update existing Employee Approval Group and Assignments using api

-Setup EFT and Check Payment Process Profile for Banorte Bank for new Mexican OU and include customization.

-Build Perpetual Accrual Snapshot program for on-hand and in-transit quantities and based on Snapshot develop Inventory Valuation Report across different Inventory Organization of different OU for use during Closing.

-Concur vendor extract

Client : New York Stock Exchange, NYC, NY Feb 2013 – Nov 2014

Project : Oracle Financials Support Project

Role : Oracle P2P Technical Consultant

Responsibilities

Understanding of AS-IS business process required for providing support, resolve techno-functional resolution to support tickets in the areas of Payables, Purchasing, iExpense, iProcurement. Also address requests for ad-hoc queries and various extracts from Business users especially during month-end, quarter-end.

Resolving iExpense issues with Approval Routing in Project/non-Project based expenses and AME, Approval Limits, Policy/Schedule setup, Vacation Rule, Issues with Amex Credit Card Transactions. Develop iExpense setup details check form.

For Renewal of Punchout Certification with Oracle Exchange, coordinate with supplier side Oracle Support and local DBA for fixing the issue. Cosmetic changes with OAF personalization in iProcurement page.

Working with AP, PO and REQ AME-driven Approval Workflows and Project Expense Report Account Generator workflow

Resolving Period Closing and Regular issues with matching and hold in Purchasing / iProcurement and Payables.

Client : Nintendo of America, Redmond, WA Oct 2012 - Jan 2013

Project : R12 Project

Role : Oracle Workflow Developer

Responsibilities

-Account Generator (COGS) Workflow in OM

-AP Invoice Approval workflows using AME – OU specific, Pre-chain-of-authority, Absolute job level / position hierarchy based, FYI rule

-Requisition Approval, CREATEPO and Account Generator Workflow in Purchasing

B.With Tata Consultancy Services Limited [Jul 2005 to Oct 2012]

Client : Ingersoll-Rand, Davidson, NC Mar 2012 - Oct 2012

Project : SMARTransformation Project

Role : Onsite Technical Lead

Responsibilities

Hands-on development of new and/or critical customizations e.g.

GL Journal Import Interface

AP Invoice Inbound Interface from LAWTRAC, CONCUR, CINCOM etc Legacy systems

Customize FUN_WEBADI_PKG for upload of additional attribute column and integrating AME with AGIS

Use AME in AP and iExpense

Send Payment data to Bank of America (BoA), Tavant Payment Outbound Extract

Customer Balance Statement Report with Bursting using BI Publisher

Bank Statement Loader Interface and Automatic Receipt Creation from Bank Statement

Working with Requisition Import. AutoCreate Doc workflow APIs, Receiving of PO and Return to Vendor using ROI, Process ASN and Receiving Transactions using ROI and Receiving Transaction Processor (RTP)

Develop custom form for review of Staged Invoice Interface data before submitting Custom Payables Invoice Import program

Gather requirements, Data Mapping for the import interfaces, Write MD70 and TE20

Client : Johnson Controls Inc, Milwaukee, WI Jul 2011 – Feb 2012

Project : G12 Interface Development Project

Role : Onsite Technical/Team Lead – Interface Team

As a part of that Global Deployment initiative, the Interface Team was responsible for integration of Oracle r12 EBS and various Legacy systems (not point-to-point) through EAI AQ/MQ methodology in middleware layer. A superset of requirements covering all legacy applications was designed and then deployed to generate XML payloads, transformed in EAI layer per given data mapping and then subscribe to XML data bus to send/receive data in a pre-defined format.

Responsibilities

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.

Integrate Business Events (replacing Database triggers) with Workflow to trigger generation of XML payload for outbound extract to Legacy systems.

AME implementation with iProcurement and experience in implementing complex Approval rules and generate Approver List

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 Interface

Develop Supplier Conversion interface program to get all suppliers information into Oracle applications from legacy system.

Client : Carnival Corporation, Miami, FL Feb 2010 – Jun 2011

Project : Oracle eBiz 11i Production Support

Role : Technical/Team Lead

Responsibilities

Document & Perform Playback of understanding of existing critical business processes and demonstrate increased support acumen at successive Quality Gates.

Resolve high severity tickets for failed interfaces in AP, PO and Cash Management

Perform iExpense setup activities using DataLoader.

Administer PO and Requisition Workflows failed with notifications, resubmit and reprocess.

Disable Menu Item for a Responsibility thru Personalization, Making a field mandatory etc

Generate Alert extract and email

Raise, Monitor, Conduct OWC session with Oracle and coordinate with internal DBA team

Perform root-cause analysis (RCA) for month-end issues. Prepare RCA document, Discuss remediation with the client manager.

Client : Puerto Rico Telecom, Mexico City, Mexico Sep 2009 – Jan 2010

Project : Oracle Incentive Compensation Implementation Project

Role : Technical 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

Business Process Modeling, Fit-Gap Analysis

Client : Alcoa Inc, Netherlands / Hungary Jul 2005 – Aug 2009

Project : Oracle EBS 11i Rollout in Europe

Role : Multiple (Technical/Team Lead)

Responsibilities

As Onsite Technical/Team Lead:

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

PO Outbound Extract

Resource Management, Task Allocation & conduct Internal Training,

Monitoring Delivery progress, Identify deliverables getting into Critical Path and mitigation plan for underlying Road Blockers with offshore counterpart

Escalation Management.

Gap Analysis for new roll-out components.

Performance appraisal of Team – onsite and offshore both

As Offshore Technical/Team Lead:

Create Workflow Notification whenever new item added in Inventory

Purchase Orders with Invoice Details Extract Report

Fix issues with AutoInvoice 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, AP and AR.

Using custom.pll made attachments read-only for certain responsibility login, hide a particular tab page upon entry etc.

Working with Production issues in P2P processes on requisition import, requisition approval issues, Invoice matching with PO, Payment interface process to Bank.

Develop reports in O2C area e.g. Packing Slip Report, Delivery Note Report, Sales Order Acknowledgement Report, Proforma Invoice Report, Working with COGS Account Generator, Form Personalization with Order Organizer and Shipping Transaction form

Development of Interfaces – Customer Master Create using TCA APIs, OE Order Pub and Update/Cancel/Reserve/Hold/Pick Release and Ship Confirm related WSH Delivery Pub APIs

Migrate the codes/scripts/executables using IT Governance tool across different instances.

C.With IBM Global Services India Limited [Feb 2004 to Jul 2005]

Client : Denmark Radio, Denmark Oct 2004 - Jul 2005

Project : Denmark Radio Licensing Project

Role : 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, Sales Order Extract using UTL_FILE

Netting interface of Open Customer Invoices in AR against Receipts and Credit Memos

using AR Receipt APIs

Programmatically Register Report, Interface concurrent programs

Client : Petrochemical Industries Company, Kuwait Feb 2004 - Sep 2004

Project : PIC Project

Role : Senior Technical Consultant

Responsibilities

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

Margin Analysis Report to pull all the sales orders that are ship confirmed and Invoices that are created manually and created through Auto Invoice

Working with Auto Lockbox interface program to import AR receipts from bank.

Prepare Unit Test plans, test cases and documenting Executed Unit Test Plans.

Performance Tuning of the code before delivery

D.With Tata Consultancy Services [Nov 2002 to Feb 2004]

Client : GE Medical Systems, Offshore, India Nov 2002 - Feb 2004

Project : GEMS Job Jar Team, Production Support Team

Role : Apps Manufacturing Technical Consultant

Responsibilities

Some of the important and critical reports/interfaces to highlight in many P2P and O2C modules (e.g. OM, WSH, INV, PO, AP, AR, GL, WSH) were:

GEMS AR Invoice printing report for New Zealand, GEYMS Inventory Summary Report for Japan, Workflow package fixes related to Requisition Approval, PO Receipt Error Report, Requisition Interface, PO Conversion, Dropship ASN Re-Processing RCV Transactions Interface, ASN Import, China Blanket PO Release Report, Purchase Requisition Import, Inventory Material Issue Report, Pick Slip Report for Canada, Creating Drop Ship Extract, GL Daily Rates Interface, AP Trial balance Report

Working with Unix Shell Scripts, SQL Loader and UTL_FILE package

E.With Ushacomm India Limited [Aug 2000 to Jul 2002]

Client : In-House Aug 2000 - Jul 2002

Project : Analyst 1.1 and 2.0 Project

Role : Oracle DBA

Responsibilities

PL/SQL Code Tuning using ANALYZE, EXPLAIN PLAN, OPTIMIZER HINTS, TKPROF etc,

Maintenance activities of creating User and their Access privileges

LogMining, Resource Management, Space Management, Backup/Recovery

Implemented Oracle 9i Data Mining 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.

Schema design for all database tables and procedures and for Data Mapping and migration to new Oracle 8i DB from existing Sybase DB.

Education

M.Tech in Petrochemical & Petroleum Refinery Engineering, University of Calcutta, Kolkata, India

B.Tech in Chemical, University of Calcutta, Kolkata, India

Contact this candidate