Project Developer

KALYANARAMAN DANDAPANI

*** ******* ***** * South Plainfield, NJ 07080 * Mobile: 732-***-**** *

Email: ************.****@*****.***

Oracle Applications Sr. Tech/Functional - Consultant/EDI Designer

Career Highlights:

. 12+ years of Information Technology experience and management

expertise in the bio-phamachetical, banking, insurance, and retail

industries. Works well with both team and individual environments.

. Enabled EDI for over 90% of US commercial customers and suppliers

transactions including Inbound 850/855/856/844 and outbound

810/812/820/850/855/856/849. Solely responsible for extended

implementation for inbound and outbound transactions for Japan and

Spain.

. Managed communications between business, global project IT team,

customers, suppliers, translators (Sterling Commerce in US, Mythos in

Japan, and EDICOM in Spain), etc to meet tight project deadline with

100% satisfaction.

. Managed off-shore team, defined SOP's for change request, development

standards to be used by on-site and offshore team

. Designed and developed interface to legacy system and operational

reports to management for improving process efficiency at GAIC.

. Implemented batch processing for flat file report generation to be

sent to government agencies for Civil Service Motor Association

(CSMA), UK.

. Provided backup Oracle DBA support for build deployment and developed

scripts for generation of flat file reports for Standard and Poor's

bond system.

. Lead two teams on different shifts at offshore for Lutech, UK to

develop their Customer Management Software for their call center.

. Managed end to end 2 phase delivery for appropriation calculator

application for ICICI Bank, the largest private bank in India.

. Formed a global technology core support team for production support of

banking payments solutions product supporting major banks like ICICI,

HDFC, Kotak, etc at AurionPro Solutions

. Worked with CEO and Leadership team to define the primary and

secondary responsibility matrix across the organisation for AurionPro

Solutions

. Executed Concept to Delivery for a custom web browser product

development for Dishnet DSL, India. The browser supported conducting

on polls and display advertisements on part of the screen.

Core Competencies:

Oracle EBS 12.0.6 EDI Inbound 850/855/856/844 Project

Coordination

outbound Project Management Process

810/812/820/850/855/856/849 Management

Oracle SQL / PL-SQL / Forms / Formulating SOP / Managing

Reports Work-practice offshore team

Professional Experience:

Celgene Corporation, NJ, USA

Sr Consultant to Systems Analyst Oct 06 - Till Date

Celgene Corporation is a multinational bio-pharmaceutical company committed

to improving the lives of patients worldwide. I have implemented Oracle 12R

EBS applications using Multi-Org functionality. Worked as a consultant for

6 months before being absorbed as a full-time systems analyst. :

. Number of trading partners implemented:

No of Trading USA Japan Spain

Partners

Wholesalers / 7 2 200

Customers

Suppliers 6 0 5

. Requirements gathering for initial implementation from customers and

suppliers for USA, Japan, and Spain

. Designed and implemented customer conversion from legacy system COMS

. Defined the infrastructure for all EDI transactions

. Documented functional design, technical design, implementation setups

in MD050, MD070, BR100 based on AIM documentation methodology followed

in the project.

. Worked on Oracle sales orders for risk managed Items verification

process integration with SOA BPEL services.

. Worked with Sterling Commerce GIS connect direct.

. Designed and developed trade management EDI 844(Claim creation)

Inbound and 849(claim reconciliation) Outbound transactions

. Setup trading partners and Code conversion in Oracle e-Commerce

Gateway.

. Developed Extensible Architecture in INO-810,POO-850 Transactions and

configured process rules and column rules for inbound transactions

. Build custom 855 inbound asterisk separated file EDI interface

. Provide end to end solution for EDI from analysis to post go-live

support

. Analysis, Design, Implement and Support the following EDI

transactions:

. Customer 850 Inbound Purchase Order

. Customer 855 Outbound Purchase Order Acknowledgement

. Customer 856 Outbound Delivery Shipment Notice (DSN / ASN)

. Customer 810 Outbound Invoices

. Customer 820 Remittance Advice Outbound

. Customer 812 Outbound Credit / Debit Memo

. Cusotmer 844 Chargeback Claim Inbound

. Customer 849 Chargeback Claim Acceptance Outbound

. Supplier 850 Outbound Purchase Orders

. Supplier 855 Acknowledgement

. Supplier 856 Advanced Shipment Notice (ASN)

. Monitor Batch Processes for Oracle EBS application.

. Performed Enhancement, Development, Testing and Bug Fixing activities

for USA, Japan, Spain operating units.

. Developed ad-hoc reporting through queries for Management and

Business Needs.

Environment: Oracle Applications (12.0.6) (Oracle e-Commerce gateway, Order

Management, Shipping, AR, Trade Management, Purchasing, Receiving, Oracle

Alerts, System Admin., AOL,SOA,BPEL) Linux and Gentran Integration Server).

GAIC, Cincinnati, OH Apr 06 - Sep 06

Role: Sr Developer

Worked as a Developer with Great American Insurance Company (GAIC) for

implementing the Insurance Product Suite applications for Policy, Billing,

and Claims. GAIC, is a premium Insurance Company in the USA, and a part of

American Financial Group based in Cincinnati, OH.

Responsibilities:

. Analyze the data structures and processing methodologies of the old

system, technical specifications and ERD of the old system to

understand the transactions performed.

. Map the data into staging tables, and translate old coded values to

new ones.

. Involved in Design Phase, created staging tables as an exact replica

of the database structure of the Sybase system.

. Developed scripts for data upload using the SQL * Loader utility. Data

from the legacy system was given in a character delimited flat files.

. Develop conversion routines in PL/SQL, manage and monitor the process

of moving the data into the actual Renaissance transaction tables, to

track and test the volume and quality of the data.

. Enhanced Unix Shell Scripts to control execution of the conversion

routines.

. Functional testing and spot checking of converted data in various test

cycles.

. Implemented dynamic SQL, Ref Cursors, bulk collection features in

PL/SQL programs.

. Designed scripts for data upload using the SQL * Loader utility.

. Developed operational reports using Reports 6i

. Developed programs in PL/SQL to be used in customized balancing

reports to validate the data and numbers given by the existing vendor.

Environment: Oracle D2K (Forms 4.5/6 & Reports 2.5/6),SQL,PL/SQL,Oracle 6i,

Oracle 9i on E4000 SUN UNIX HA.

CSMA, UK May 05 - Apr 06

Role: Sr. Developer

Worked as Developer with Capgemini India Pvt. Ltd. at Manchester, UK for

TARDIS application of UK client Civil Service Motor Association (CSMA)

engaged in Road Accident Insurance and Break down services. Responsible for

multiple Use Cases package development including batch processing and

reporting in ASCII flat file format using CMM quality processes.

Responsibilities:

. Developed application for new and change requirements.

. Involved in testing and QA activities for new and change requirements.

. Prepared test data and performed Unit Test Plan and Unit Test Report

for the new / change requests.

. Completed development of batch processing for flat file report

generation.

. Developed scripts for data upload using the SQL * Loader utility. Data

from the legacy system was given in a character delimited flat files.

. Carried out defect tracking using Rational Clear Quest.

. Developed conversion routines in PL/SQL, manage and monitor the

process of moving the data.

Environment: Oracle D2K (Forms 4.5 & Reports 2.5), SQL, PL/SQL, Oracle8i on

Windows NT.

S&P, NY Jan 04 - Apr 05

Role: Sr Developer

Worked as Developer and backup DBA with Capgemini India Pvt. Ltd. for

TARDIS application of USA client Standard and Poor's involved in Credit

Rating. The Maintain Bonds application involved maintaining data relating

to various municipal bonds and their ratings. Responsible for PL/SQL

development, unit testing, and DBA support activities for weekly version /

build release using CMM quality processes.

Responsibilities:

. Developed the system using PL/SQL Collections and Records for

implementing complex business functionality.

. Provided backup DBA support for build deployment.

. Maintained version control for build deployment using Visual

SourceSafe.

. Prepared Unit Test Plan and Unit Test Report for the new / change

requests.

. Implemented change / new requirement & prepared test data.

. Implemented Transaction Processing using Autonomous Transactions in

PL/SQL

. Developed application programs in the stored programs.

. Incorporated the use of PL/SQL standard packages UTL_FILE,

DBMS_ALERTS.

Environment: Java, SQL, PL/SQL, Oracle8i, Visual SourceSafe on Windows

Client and SCO UNIX Server.

Lutech, UK Jun 03 - Dec 04

Role: Developer/Tech Lead

Worked as Tech Lead for customized Customer Management Software on behalf

of Lutech, UK. The customized application managed customer information for

an insurance company. As a Project Lead the responsibilities involved

managing a large team offshore, billing and account management for onsite

candidates, constantly communication with the front office, Lutech for

Business Understanding, Project Management, Work Allocation, and Team

Meetings.

Responsibilities:

. Analyzed the data structures and processing methodologies of the old

system, technical specifications and ERD of the old system to

understand the existing transactions performed.

. Mapped the data into staging tables, and translated old coded values

to new ones.

. Involved in Design Phase, created staging tables as an exact replica

of the database structure of the Oracle system.

. Managed Billing and Accounting for onsite and offshore team with

Lutech, UK.

. Day-to-day work allocation and management of team based on regular

interaction with Lutech counterparts.

Environment: Java, SQL, PL/SQL, Oracle8i, Visual SourceSafe on Window 2000.

ICICI Bank, Mumbai, India Nov 02 - May 03

Role: Sr Developer/Tech Lead

Worked as Project Lead for Appropriation Calculator of ICICI bank's term

loan management solution. This project was developed in 2 phases for Indian

Rupees (Phase I) and Foreign Currency (Enhancement - Phase II).

Responsibilities as a Lead include managing a team of 4 members, Business

Understanding, Analysis, Project Management, Work Allocation, Client and

Team Meetings.

Responsibilities:

. Analyzed the existing system to understand the business logic and

transaction processing methodologies of the legacy system.

. Mapped the data into staging tables, and translate old coded values to

new ones.

. Involved in Business Understanding, Design & Analysis Phase of the

system.

. Worked as a Project Lead and Senior Developer for complete life cycle

implementation of the project phase I and Project Lead for phase II.

. Have been involved in the understanding the functional requirements of

each phase and mapping the development to the same keeping in track

with the schedule.

. The Developer 2000 application was under development on version 4.5

with Oracle 8i during Sep 02 to Mar 03 and under maintenance and

enhancement during Apr 03 to Dec 03.

. Reviewed development and integration of PL/SQL packages, procedures

and functions in the existing system.

. Prepared functional and systems test plans and co-coordinated with

Quality Control team for end-to-end testing.

. Prepared installation documents for the System.

. Handled the release management for the project.

Environment: Oracle D2K (Forms 4.5, Reports 2.5), SQL, PL/SQL, Oracle8i, MS

Project, Visual SourceSafe on Window 2000.

Nexus Software, Mumbai, India May 02 - Oct 02

Role: Sr. Programmer

Worked as programmer with Nexus Software for Web TV Navigator being

developed for Dishnet DSL.

Responsibilities:

. Developer for the multimedia enabled web browser that allows the end-

user to watch Multimedia rich programs & surf the Internet, on a

single interface.

. The application also allows online polls management.

. The application was developed on Oracle and Visual Basic along with

use of windows API.

. Developed test plans.

. Delivered user training and onsite assistance post production.

Environment: MS Access, Visual Basic, Windows API on Windows 2000.

SoftTech Systems, Mumbai, India Feb 01 - Apr 02

Role: Sr. Programmer

Worked as a Programmer with SoftTech Systems for developing their MIS

product for Retailers of Textile and Ready-mades. Responsibilities include

screen designing and development of various forms of reports.

Responsibilities:

. Developed screen design and various reports for the MIS application.

. Prepared reports on various formats viz., Flat File, VB Data Reports,

Oracle Reports.

. Worked extensively on Flat File reporting using UTL_FILE package.

. Developed testing documentation and user manuals.

. Delivered user training and onsite assistance post production.

Environment: Oracle D2K (Forms 4.5, Reports 2.5), SQL, PL/SQL, Oracle7.3,

Visual SourceSafe, MS-Access, Visual Basic, Crystal Reports on Window NT.

Mamta Trading Company, Mumbai, India

Sep 99 - Dec 00

Role : Programmer

Worked as a Programmer with SoftTech Systems for Order Management System of

Mamta Trading Company, and exporter of Sea-seam Seeds. Responsibilities

involved Analysis of business information, Designing, Development,

Implementation and Support.

Responsibilities:

. Analyzed of Business Requirements and Designing the system.

. Developed in accordance with the specification, perform unit testing

and bug fixing.

. Created various reports (including but not limiting to Tabular, Matrix

Reports) for Order, Products, and Trading Modules.

Environment: Oracle D2K (Forms 4.5, Reports 2.5), SQL, PL/SQL, Oracle7.3,

Visual SourceSafe on Window NT.

Contact this candidate