Resume of SOMA Updated on 4 April 2002 Page

3

Resume of SOMA Updated on 4 April 2002 Page #

SOMASUNDARAM

H: 732-651-7701 C: 908-331-0541

Summary:

Soma has over 19 years (5 years in USA) of IT Experience in the area of Project Management, Design, Development and implementation of large systems providing business analysis and solutions in Engineering, Manufacturing, Constructions, Financial (Trading, Mortgage Insurance), Telecom and Market Research Sectors.

Soma’s experience also includes:

·  Strong Functional and Technical Experience on Oracle Inventory, Fixed Assets, Mfg. Applications

·  Large-scale migration of Legacy data from VAX RMS / RDB Files to ORACLE Databases

·  Scope Documentations, Operations Analysis, Gap Analysis, Cost Benefit Analysis

·  Successful completion of several Migration Projects with high volume Data

·  Good Exposure to BPR (business process re-engineering) and ERP (enterprise resource planning)

·  Conduct Training Programs for the End users

Technical Skill:

Soma’s work experience on Hardware used includes Digital’s Micro VAX-3300, 3400, Alpha Servers 1000, 800, Data General MV 20000, Sun Solaris 2.x. The Operating Systems he had worked with during his several projects includes VAX VMS/ OPEN VMS, CP/M, MS-DOS & Windows 95/98, Windows NT, UNIX, AOS, SUN OS 5.8. His rich experience on Computer languages includes DCL, BASIC, COBOL, and FORTRAN 77 & C on DEC machines. He has good working knowledge on various RDBMS which includes DEC RDB, ORACLE, SYBASE, MS Access, FoxPro, Dbase. He also has experience in the Package Applications like ORACLE INVENTORY Version10.7, Fixed Assets, Manufacturing from ORACLE, SAS from SAS Institute, Quancept, Quantum, Quanvert, SMS from SPSS MR. His exposure to Development Tools are Visual Basic 6.0, VISUALFOXPRO 6.0, Power Builder 5.0, Developer / Discover 2000. His working level knowledge on Other Products includes MS Project 4.0, MS Focus, Windows Help Compiler, Oracle SQL Loader, Path works & CMS on DEC Machines. His web development experience includes HTML 4.0 VB Script & Java Script can be seen in http://www.geocities.com/dsomasundaram/usa

Training:

·  VAX COBOL from Digital (India) Limited, Madras for 15 Days

·  VAX Architecture from Digital (India) Limited, Madras for 5 Days

·  VAX PATHWORKS for DOS & Windows from Digital (India) Limited, Madras for 2 Days

·  ODISSY Document Management System from SRA Systems, Madras for 2 Days

·  ORACLE DBA from Oracle (India) Limited, Madras for 5 Days

·  Oracle Inventory from Oracle (India) Limited, Madras for 10 days

Education:

·  1995 - Integrated Professional Software Programme in Client Server Computing

(Sybase TSQL with Visual Basic and Power Builder)

·  1991 - Post Graduate Diploma in Materials Management

Purchasing, Production, stores Control & Inventory Management

Physical Distribution & Transportation Management

·  1983 - Certificate in Computer Programming and Systems Design

BASIC, COBOL, FORTRAN, PL1 and System Designs

·  1981 - Bachelor Degree in Commerce

Advanced Corporate Accounting and Management Accounting

Project Experience:

Consultant, Apr 2002 to till date (24 Months)

Radian Guaranty inc., Philadelphia, PA, USA

Involved in Maintenance / Enhancement and Production Support of LEGACY systems for Radian Insurance Inc., a subsidiary of Radian Guaranty, provides non-traditional mortgage insurance and credit enhancements on mortgage assets, including manufactured housing loans, home equity lines of credit (HELOC), second mortgages and residential first mortgages with loan-to-value ratios greater than 100%.

Responsibilities includes:

·  Production Support

·  Help Desk Tickets

·  Writing Application Software using VAX C, COBOL Codes for ALPHA OPEN VMS

·  Data Analysis, Data Manipulation and Working with VAX RDB

·  Change Management Controls using CMS

·  Test plans / Test Data Preparation

·  Designed the Interfaces for data extracts for downstream applications / Data Warehouse

·  Unit Testing, Baseline Testing and Parallel Testing and Production Releases

·  Technical / User Documentation

Consultant, Feb 2002 to Mar 2002 (2 Months)

Knowledge Networks – SRI , West Field, New Jersey, USA

http://www.geocities.com/dsomasundaram/Soma-Main-RefLtr0004.jpg

Involved in Migration of Statistical Research Inc. CATI system from Data General to SUN Solaris. Project work involved study of Legacy mathematical Application system in FORTRAN in DG system and do the data map with SPSS products SMS, Quancept, Quantum, Quanvert. CATI is Computer Assisted Telephone Interviewing System for sampling, Survey data, Tabulation and statistical analysis.

Responsibilities includes:

·  Scope Documentation

·  Operation Analysis (Data Analysis, Data access, Data Manipulation, Data Structures) of Legacy CATI system on Data General

·  Develop Migration Tool for Data Extraction

·  Data Mapping for SPSS files to run QPARSE, QTIP, QCSET, QCTUM

·  Generate Banners/Tabulations in Quancept/Quantum and compare results with Legacy System

·  Unit Testing, Baseline Testing and Parallel Testing and Production Releases

·  Co-ordinate with End Users in UAT for sign off for Production

·  Technical / User Documentation

Consultant, Apr 2001 to Nov 2001 (8 Months)

AT&T – Easylink Services, Parsippany, New Jersey, USA

http://www.geocities.com/dsomasundaram/Soma-Main-RefLtr0003.jpg

Involved in Migration / Integration of AT&T’s Billing Systems, AMS (Area Mechanization System) / IMS (Instant Mail System) runs on AMDAHL System (IBM) and GMS (Global Mail System) on ALPHA Open VMS. The Billing Systems is for the AT&T’s various services like EDI, FAX, Telex, Mail, Mailgram and Priority Letters for their domestic and international customers. The System has the Front End Rating, Admin, Collection, Discounting (Promotions) and Invoicing, Imaging and Magnetic Tapes Modules.

Responsibilities includes:

·  Actively participated in User Context Meetings on Test Plans, Data Migration

·  Analysis of SAS Module Functionality on Billing Cycles

·  Designed and Developed COBOL Programs migrating SAS Functionality

·  SAS codes for extracting Financial Data for Oracle Financials

·  Migration of IBM Cobol Programs to VAX Cobol Programs

·  Unit Testing, Baseline Testing and Parallel Testing and Production Releases

·  Validation of Switch Data, Billing Cycle Processed Data, Invoice Results

·  Co-ordinate with End Users in UAT for sign off for Production

·  Technical / User Documentation

Consultant, Jan 2000 to Mar 2001 (15 Months)

Deutsche Bank, New York, NY, USA

http://www.geocities.com/dsomasundaram/Soma-Main-RefLtr0002.jpg

Participated in Migration/Conversion of DEUTSCHE Bank’s GLOBEMAN Application from VAX/VMS to ALPHA OPEN VMS. GLOBEMAN, an integrated System caters Deutsche Bank ‘s Trading, Portfolio and Performance Management system. The applications are based on Financial Models Company Inc.’s PACER, VERTEX and PERSYS packages. The application consists of approximately 3 million lines of code in 300/350 modules. The application is written primarily in Fortran. The application use RMS and Oracle’s RDB and SYBASE TSQL on Digital Machines. It uses Smart Star from B2 Systems.

Responsibilities includes:

·  Writing Application Software using VAX FORTRAN and C Codes for ALPHA OPEN VMS

·  Data Analysis, Data Manipulation and Working with VAX RDB, Sybase Databases

·  Change Management Controls using CMS

·  Test plans / Test Data Preparation

·  Co-ordinate with End Users in UAT for sign off for Production

·  Setup of Interface for External Brokers and Clients to access the Trade Details

·  Designed the Interfaces for data extracts for downstream applications / Data Warehouse

·  Technical and User Documentation

Data Warehouse Project of DEUTSCHE Bank’s Financial Data, designed on UNIX ORACLE which is intended to act as GLOBAL Data Hub and to provide Front End Information to the End Users on various business transactions of all the legacy source systems. It also designed Interface to provide data mapping /Data manipulate/ Data Extract thru a nightly Batch Job to the downstream application XAMIN – A Performance Measurement System from SUNGARD System.

Responsibilities includes:

·  Designed the Interfaces for data manipulation and extracts from Legacy Data from VAX RDB for Global Data Hub

·  Actively participated in User Context Meetings on Database Designs / Design Changes

·  Setup of Automated Data Feed to GDH from GLOBEMAN on daily basis

·  Design Batch Job for Data Mapping/manipulate and Feed to XAMIN from GLOBEMAN on daily basis

·  Co-ordinate with End Users in UAT for sign off for Production

·  Technical / User Documentation

Junior / Sr. Programmer, Systems Analyst, Project Leader, Application Implementation consultant

Full time Employee: Jun 1984 to Dec 1999 (186 months)

Larsen & Toubro Limited, India

http://www.geocities.com/dsomasundaram/Soma-Main-RefLtr0001.jpg

Application Implementation Consultant, Jan 1999 to Dec 1999 (12 months)

Had undergone 5 full days training program on Oracle Inventory Application and played a Team Leader role in Implementation of Application. Fully involved in the implementation work plan phases like Project Definition, Operation Analysis, Solution Design, Build, Transition and Production.

Responsible includes:

·  Application Setup of Project Code, Account Code, Sub Account Code

·  Defined the 3 C (Calendar, Currency, Cost Center)

·  Defined Organization, sub-inventory

·  Defined Items, UOM and upload legacy data

·  Created Template for Easy Data Entry

·  Defined Category, Catalog, Manufacturer’s Drawing

·  PL/SQL Codes to update Open interface for Legacy Data

·  Involved in Test Data Preparation

·  Conducted End User Training

Project Leader, Jan 1997 to Dec 1998 (24 months)

Managed the Migration/Conversion Project from VAX COBOL, VAX C, DEC RDB to ORACLE on OPENVMS. System to Register and maintain Material Requests, Authorisation with Budget Comparison, Process and Generate Purchase Orders. This system takes care all inventory activities from purchase request till it is been issued to the required department or jobs. Purchase Order, Material Receipt Notes and Delivery Challans are generated out of this system. The system has the provision to maintain sub inventories. Designed the Material Purchase Price Query Module using Visual Basic Front End Screens with MS Access as Back End Database for the materials Managers Desk - a Business Analysis Tool for the Approval of Purchase Orders.

Responsible includes:

·  Project Management

·  Designed Oracle Tables

·  Creation of Tables Spaces / Tables / Indexes

·  Developed Table level Triggers, Stored Procedures

·  PL/SQL Codes for updating Stock Registers, Various on line status of Purchase Requests, Data Transfer indicator to downstream applications

·  Developed RMU Script for loading Legacy Data into Oracle Database

·  Conducted End User Training Program

·  Performance Tuning on Oracle

·  Prepared Technical / User Manuals

Systems Analyst, Aug 1996 to Dec 1996 (5 months)

Engineering Design Calculation for In-door and Out-door Lights. System maintains FLUX Utilance Table, Fitting Catalogue and does Analysis and Designs and Calculation of Number of Fittings. The Various parameters considered for design calculations are: Mounting Height, Room Index, Cavity Factor, Ceiling Factor, Lower Flux Utilance, Upper Flux Utilance, Number of Fittings.

·  Designed and developed using VAX VMS DCL / FORTRAN

·  Produce Design calculation reports for client’s approval on various industrial electrification projects.

Systems Analyst, Apr 1995 to Jul 1996 (16 months)

MATERIAL REQUIREMENT PLANNING SYSTEM, Integrated System developed using EXPLOTION Logic for Railway Electrification Projects for effective material planning/handling.

·  Designed and developed using VAX Cobol, VAX Basic, Dec Forms, DEC RDB under VAX VMS

·  Provides Material Requirement Section / Kilometre wise

·  Ability to produce Activity / Section / Km wise material shortage comparing the Existing stock levels

·  Material follow-up actions for next three months

·  Cater as a basis for Assessment of materials for the Upcoming Projects based on as erected Qty

Senior Programmer, Mar 1994 to Mar 1995 (13 months)

TENDERING SYSTEM, System used to update Site Investigation Report and preparation of cost estimates for the various work items of a Tender. Cost break-up for labour, material, plant, overheads and profit margin are computed. Item-wise sales price report is generated as per the client’s format specified in the Tender document.

·  Worked as a Team Leader in Designing the System

·  Developed various modules using VAX VMS COBOL, DEC RDB

·  Helped the team in implementing and trouble shooting

Senior Programmer, Mar 1993 to Feb 1994 (12 months)

SHORT CIRCUIT DESIGN, Calculation of Short Circuit withstands capacities of ACSR Conductors. The Various parameters considered for design calculations are: Specific heat of Aluminium, Density of Aluminium, and Temperature Coeff. Of Resistance, Conductivity of Aluminium, Resistively of Aluminium, Final Temperature, Initial Temperature and Fault Duration.

·  Played a Team Member Role

·  Designed and Developed using VAX DCL, Fortran

·  Produce Design calculation reports for client’s approval on various industrial electrification projects

Senior Programmer, Nov 1991 to Feb 1993 (16 months)

CLIENT BILLING SYSTEM, to generate quantity schedules for the work executed and the respective invoices for the work items as per the contract terms. It also generated reports on quantity billed, work done but unbilled and collection details.

·  Played a Team Leader Role

·  Designed and Developed using VAX VMS COBOL, DEC RDB

·  Produce Billing formats for client’s approval on various projects

·  Ability to provide data for preparing Cash flow statements

Programmer, Nov 1990 to Oct 1991 (12 months)

CUTTING SCHEDULE, designed to calculate and minimise the wastage in cutting the required pieces from a large steel sheet for small parts steel works for railway electrification and transmission tower member manufacturing. System uses NORTHWEST CORNER METHOD for optimality. These cutting schedule output are being used for the floor shop to manufacture the required components in the factory.

·  Designed and Developed using VAX DCL, VAX C, VAX Fortran

·  Ability to produce exception reports on end bits size wise along with weight.

Programmer, Nov 1988 to Oct 1990 (24 months)

Project Management Software for project Offices. This system is based on CPM / PERT Network Techniques and it has the facility of preparation of the following schedules and monitoring reports: SCHEDULES: (S0) Construction Program (Network), (S1) Invoicing, (S2) Milestone events, (S3) Plant & Machinery, (S4) Staff requirement, (S5) Labour requirement, (S6) of Material requirement, (S7) Special Agency requirement, (S8) Direct Cost, (S9) Indirect Cost, (S10) Liquidity forecast MONITORING: (M1) Monthly physical progress report, (M2) Job cost report, (M3) Project performance

·  Played a Team Member role

·  Designed and Developed using FoxPro, Auto Lisp, TURBO C, AutoCAD on MS-DOS

·  Ability to handshake with standard Project Management Software MS Project, ARTMIS 7000

·  Installed in Various Project Offices and Conducted End User Training

Junior Programmer, Mar 1988 to Sep 1988 (7 months)

PC system PURCHASE ORDER MONITORING, designed to Update purchase orders issued by Regional Office / Head Office. This system helps the site planning engineers to monitor the order status. This generates reports like Vendor wise order pending, Region wise order status, Reconciliation of raw materials issued to various vendors, Follow-up letters for the vendors.