Blk 55, #0560 Telok Blangah Drive Singapore 100055

Kalyan Samaddar

6598226159 98226159

Blk 55, #0560 Telok Blangah Drive Singapore 100055

Current Location: Singapore

Title: / Abinitio, Data Warehousing Pofessional with 8.0 years of experience.
Work Experience: / 8 years
Skills: / AbInitio, Data Warehousing, Oracle 10g, 9i, Oracle 8i, Oracle 7.3, Developer 2000, Developer 6i, SQ
Current Organization: / NIIT Technologies Pte Ltd.
Industry: / IT/ Computers Software,Retailing
Highest Degree Held: / M.E/M.Tech (Mechanical) ,Mumbai University
Gender: / Male
Date of Birth: / 17th January 1972

Detailed Resume:

Kalyan Samaddar

Blk 55, #05-60, Telok Blangah Dr

Singapore - 100055

HP : +65 9822 6159

Summary

• Around 8+ Years of IT Experience, which includes Interaction with International Clients, Requirement Study, Effort Estimation, Scheduling, Design, Development, Testing, Implementation and Production Support.

• Around 4+ years of Onsite Experience with the international clients like UBS AG (Singapore), Britannia Airways (UK), Capital One Finance (UK), Coles (Australia) and Dairy-Farm (Hong Kong).

• Instrumental in Analysis, Design, Development, Implementation and Production Support of Multiple Client/Server, Oracle Applications (GL, AR, AP, PO, FA and OM) and Data Warehousing Applications from very inception to the final execution following complete Software Development Life Cycle (SDLC)

• Technical skill areas include Oracle 10g/9i/8i/7x, Data Warehousing / ETL, Ab-Initio, Data Stage, Oracle Developer Suite, Forms/Reports 10g/6i/2000, Developer 6i/2000, Web Deployment, Oracle Transparent Gateways (OTG), Oracle Fail Safe with Clustering (OFS), Unix, Shell Scripting, SQL and PL/SQL

• Extensive Domain Knowledge of Banking & Finance, Retail Chain Management and Manufacturing for major MNC clients like Britannia Airways, Capital One, CITIBANK, UBS AG, Coles, Dairy-Farm, Cisco, Terradyne, etc.

• DBA & Performance Tuning expertise. Conversant with SEI CMM Level 5 Development Processes.

• Expertise in working with Configuration Management Software PVCS, VSS and Rational Clearcase.

• Excellent Communication and problem solving skills. Committed Team Player as well as an Independent Worker, able to work with minimum supervision and to manage multiple tasks simultaneously.

Skill Profile

Applications Oracle Applications 11i (GL, AR, AP, FA, PO and OM), Oracle Developer Suite, Web Deployment using Oracle 10g/9i Application Server

Databases Oracle 10g / 9i / 8i / 7.3, OFS / RAC / Gateways and SQL Server 2000

ETL Tool Ab-Initio (V2-8-12, V2-1-17), Data Stage

Front End Tool Forms 10g, Reports 10g, Developer 6i & Developer 2000 Rel-2 (Forms 6i / 5.0/4.5, Reports 6i / 3.0/2.5), Designer 6i, Power Builder V5.0, V6.0 and MS Front Page V3

Languages SQL, PL/SQL, HTML and Shell Scripting

Development Tools OEM, Import/Export, SQL Loader, TOAD and SQL Navigator, Citrix, SSH Secure Shell, Oracle Trace, tkprof and Stats Pack, FTP, Telnet, Control M and Autosys

Data Modeling Database Design using ERWIN, Data Analysis, Data Modeling and Data Migration

Operating Systems Windows NT-4, Windows 95/98/2000/2003/XP and HP-UX 11.2, Sun Solaris

Configuration Tools PVCS, VSS, Kintana / Mercury ITG and Test Director

Projects Summary

Project Organization Client Domain Technology

FMS NIIT Tech

BCA

Oracle Financial Oracle Apps

MIS NIIT Tech

LBBW

Wholesale Banking Oracle/D2K/DW

Risk IT NIIT Tech

UBS AG

Investment Banking Oracle/UNIX/DW

MIS KPIT Cummins

Capital One

Credit Card(Finance) Oracle/D2K/DW

Q2C Satyam Computers Ltd.

Cisco

ERP(AR) (Finance) Oracle Apps

IES Genisys

Britannia Airways

ERP(PO) Oracle/D2K

eSlot Cognizant

Terradyne

ERP(OM) Oracle Apps

LLMS HCL Tech Ltd

Coles Myer Ltd.

Retail Oracle/D2K

HKMS HCL Tech Ltd

Dairy Farm Company Ltd.

Retail Oracle/D2K

TRIMS CITICORP

CITIBANK NA

International Trade Finance Oracle/PB

TRD Mahindra

Mahindra & Mahindra Ltd.

Manufacturing Oracle/D2K

BPS Mahindra

Kotak Mahindra Ltd.

Billing & Payment (Finance) Oracle/D2K

Education

• M. E. : Masters in Mechanical Engineering ( 74%, 2nd Rank, VJTI Mumbai )

• B. E. : Bachelors in Mechanical Engineering (71%, 7th Rank, National Institute of Tech- Surat, Formerly REC-Surat)

Projects Details

FMS Oracle Apps (11i)

Client : Building & Construction Association, Govt. Reg. body for construction Industries.

System Development : Oracle Apps 11i (GL, AR, AP, PO and FA) Maintenance and Enhancement.

Database : Oracle 8i (SQL, PL/SQL, Procedures, Packages, Triggers)

Front End Tool : Developer 2000 (Forms 4.5, Report 2.5)

Application Server : Oracle Application Server

Language : SQL and PL/SQL

Tools : Toad

Operating Systems : Windows NT, Windows Server 2003 and Windows XP.

Duration : Sep 2005 Till Date

Description

Financial Management Systems (FMS) is the consolidated application for financial transactions of BCA. The application is used in different sites along with a Disaster Recovery site.

Role and Responsibility

This project is maintenance and enhancement of various modules of oracle applications such as GL, AR, AP, PO and FA. Primary responsibility is to ensure smooth day to day running of Oracle Applications, response to user queries (100+ user) and interfaces monitoring. Responsibilities includes healthy run of the Application and Database, rectify any production issues and enhance application functionality with new screens, reports and interfaces. Beside normal maintenance, time to time required to manage data migration to and from the application, modify the data for future projections and any ad-hoc requirement.

MIS Oracle10g Migration

Client : LandesBank Baden Wurttemberg, LBBW Banks, Biggest Wholesale German Bank.

System Development : Migration, Standardization and Enhancement.

Database : Oracle 10g (SQL, PL/SQL, Procedures, Packages, Triggers)

DW / ETL Tools : Ab-Initio

Front End Tool : Oracle 10g (Forms6i > Forms 10g, Report 6i > Report 10g)

Application Server : Oracle Application Server 10g

Language : SQL and PL/SQL

Operating Systems : Sun Solaris 9, Windows Server 2003, Windows XP and IBM DB2/AS400.

Duration : July 2005 Till Date (Sept 2005) Currently under production support

Description

Management Information Services (MIS) Application is a Data mart used for Analysis, Decision Support and Reporting. Currently the application is running on Client/Server mode and the project is to migrate the application to Three Tier 10g environment. OS is to migrate to Windows Server 2003, Database to 10g, 10g Application Server is used as middle tier, Forms 10g and report 10g is used for front ends. Beside normal application migration enhancements like Oracle Fail Safe (OFS) with Windows Clustering, Oracle Transparent Gateways (OTG) to Heterogeneous Database like DB2 and MS SQL Server has been added as part of migration.

In Addition, major standardization exercise is carried out to all Ab-initio graphs, which were developed over a period with different flavor.

Role and Responsibility

This project is mainly migration but in addition there are few new technical areas we are (ad)venturing into. Specially to mention are Oracle Transparent Gateways for DB2 and Oracle Fail Safe with Windows Clustering. Beside, a massive standardization is carried out to offset all the different flavors added by the historic and gradual development cycle and to ease maintenance. In addition to migration, I was the architect to define file systems for Ab-initio, separating application and data stores, standardization of application codes into multiple stages with heavy utilization of wrapper scripts.

RISK IT RRW Migration

Client : UBS AG, Biggest Investment Bank.

System Development : Migration of existing Data Warehouse ETL in to Ab-initio.

DW / ETL Tools : Ab-Initio

Database : Oracle 9i (SQL, PL/SQL, Procedures, Packages, Triggers)

Front End Tool : Developer 6i (Forms 6i, Report 6i)

Language : SQL, PL/SQL, UNIX, Shell Scripting

Tools : Toad, SSH Secure Shell, Test Director, DB Artisian, Cust Q and Autosys.

Operating Systems : Windows NT 4, Windows 98 and Sun Solaris 8/9.

Duration : Jan 2005 July 2005

Description

RISK IT is a cluster of 28 different systems used for Risk Exposure management of all trades and transactions carried out by UBS Bank worldwide. Credit Risk, Settlement Risk, Market Risk and Collateral Risk of every trade are measured and very closely monitored. Core of the application is RRW (Risk Reporting Warehouse), where all trade and customer data needs to be archived for Statistical Analysis, Management as well as Regulatory Reporting. Current project is to migrate all existing SQL*LOADER, SQL and PL/SQL data load scripts into Ab-initio. Team was responsible for re-engineering the existing ETL scripts for a much better performance and resource utilization. Time to time RISK IT team is responsible for adhoc report generation, UAT and Release Implementation.

Role and Responsibility

This project is re-engineering with enhancement and I was working as a Team Lead, managing a team of 5-6 team members. Responsibilities include Inventory Management, Plan and Schedule delivery, Team Management, Delivery and Release Management. Co-ordinate with all stake holders and align deliverable as per expectation, Client Management, Issue Tracking, Resolution and Escalation. And not the least, develop few complex transformation logic using XFR (Programming language for Ab-initio), define and utilization Multi-Files

MIS Production Support & Bug Fixing

Client : Capital One, 5th Largest Credit Card Company in the UK.

System Development : Production Support & Bug Fixing.

DW / ETL Tools : Ab-Initio, Data Satge

Database : Oracle 8.0.6.3.0 (SQL, PL/SQL, Procedures, Packages, Triggers)

Front End Tool : Developer 6i (Forms 6i)

Language : SQL, PL/SQL, Shell Scripting

Tools : Toad, SSH Secure Shell, Test Director, Rational Clearcase

Operating Systems : Windows NT 4, Windows 98 and HP-UX 11.2

Duration : Sept 2004 Jan 2005

Description

Capital One is 5th largest Credit Card Company in the UK. MIS system is a Data Warehousing system, which pulls data from many related systems like BAAS, VECTUS, SAALSA, CAAP/CQ etc. MIS data is used extensively by the Senior Management, Marketing & Analysis department as well as Call Centre Associates. Production Support & Bug Fixing project is to keep the current MIS system running and resolve all the outstanding defects in MIS system. MIS team develops new projects to monitor and analyze performance of new schemes introduced by Capital One.

Role and Responsibility

This project was purely an enhancement project. I was leading a team of 6 team members. I was responsible for understanding the Requirements from end user and prepare a design for the same. Once the design is verified with other stake holders, we were ready for Development, Testing and System Documentation. Beside development I was responsible for Scheduling, Client Management and co-ordination with stake holders.

CISCO Quote 2 Cash

Client : Cisco, The Largest Networking company in the world.

System Development : Migration and implementation Oracle Apps 11i.

Duration : May 2004 Aug 2004

Applications : Oracle Apps 11i (11.5.9)

Database : Oracle 9.2.0.5.0(SQL, PL/SQL, Procedures, Packages, Triggers)

Front End Tool : Developer 6i (Forms 6i and Report 6i), OEM

Language : SQL, PL/SQL, Shell Scripting

Tools : Citrix, Toad, Sabrix Tax Engine, SSH Secure Shell, Test Director

Operating Systems : Windows NT 4, Windows 98 and Sun Solaris

Description

Migration to Oracle Apps 11i was one of the largest integration projects in Cisco history. This included Upgrade 10.7 systems to 11i, Add new applications, Consolidate databases, Reduce customization, Standardize and globalize system usage. One of the business domain for migration is Cisco Quote to Cash (Cisco Q2C), talks about Quoting, Pricing and Discounting, Order Management and Accounts Receivable. Account Receivable module talks about Generation and Printing of Invoices/Credit Memo/Debit Memo, Sending it through FTP, Image it, Calculate Tax, handle duty reclaim.

Role and Responsibility

This one is a complete development project, following complete Software Development Life Cycle (SDLC). I was leading a team of 26 peoples (so far largest in my life). This was purely Project Management work. I was responsible for Project Plan development and very closely monitor the schedule on day to day basis. I was responsible for Team Management, Resource Allocation and Utilization. I was responsible for all deliverables including design document, test plan and cases, codes on schedule. I was responsible for Issue Management, Resolution and escalation. I was the key person for project daily monitor meeting with the key user, onsite and offshore management. This project was on a very tight schedule and was very visible and hence dynamic planning and monitoring was the key.

IES (Integrated Engineering Service)

Client : Britannia Airways, The Best Charter Airline in the UK.

System Development : Transition, Production Support and Enhancement.

Duration : Jan 2004 to April 2004

Database : Oracle 8.1.7(SQL, PL/SQL, Procedures, Packages, Triggers)

Front End Tool : Developer 6i / 2000 (Forms 6i / 4.5 and Report 6i / 2.5), OEM

Language : SQL, PL/SQL, Shell Scripting

Operating Systems : Windows NT 4, Windows 98 and HP UNIX -11

Description

Britannia Airways is one popular domestic airline based at Londons Luton Airport and operates throughout Europe. IES, Integrated Engineering Service is a consolidated ERP Application developed in-house to cater Aircraft Maintenance, T&A, WIP, Inventory Management and Procurements. IES has 11 different applications, which interacts with 23 external applications.

Role and Responsibility

It was an Application Support Transition project. I was working as a Project Lead, managing 6 team members. I was responsible for Application Support Transition, System Documentation, Production Support and Enhancement. In addition I was responsible for Team Management, Client Management, Service Level Agreement (SLA) definition and monitoring Schedule.

eSlot

Client : Terradyne, largest fortune 500 Manufacturing co in the US.

System Development : Development, Implementation and Post Production Support.

Duration : Apr 2003 to Dec 2003

Applications : Oracle Apps 11i

Database : Oracle 8.1.7(SQL, PL/SQL, Procedures, Packages, Triggers)

Front End Tool : Developer 6i (Forms 6i and Report 6i), OEM

Language : SQL, PL/SQL, Shell Scripting

Operating Systems : Windows NT 4, Windows 98 and HP-UX 11.2

Description

Terradyne is one of the largest manufacturing company in the US producing multiple products including specialized IC Testing equipments. IC Testing equipments are very customized and specialized products, which are all build to order. eSlot, is a custom module used to plan, schedule and utilize production line time slot to optimize planned shipment and line utilization. eSlot gathers Sales Order information from Order Management and plan/allocate production Line Slot to Sales Order.

Role and Responsibility

This one is a complete development project, following complete Software Development Life Cycle (SDLC). I was working as a Project Lead managing 14 team members. I was responsible for System Documentation, Development, Testing, Implementation and Post Production Support of a new module in Oracle Apps 11i. Beside normal development work I was responsible for Project Plan, Resource and Team Management, Schedule and Delivery Management, Co-ordination with User, On-site team members, and all other stake holders.