SUMMARY

Senior system professional with over 20 years (9 years in USA) of IT Experience in the area of Project Management, Design, Development and implementation of large systems providing business analysis and solutions. Effective problem solver and multi tasker, consistent timely deliverable, focused on Customer Satisfaction and ability to interact with all levels of management to accomplish goals.

• Complete understating of SDLC (System development life cycle)
• Large-scale Migration of Legacy System data to SQL Server 2000 and SYBASE servers
• Cross platform application development & deployment and Level 1 Production Support
• Strong PL/SQL programming using DEC RDB,ORACLE RDB, Sybase and SQL Server
• Participation in Disaster Recovery Plans Documents and Testing
• Good understanding client/server and OO technologies and used VB .NET, C#
• Successful completion of several Migration Projects with high volume Data

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 and Windows. The Operating Systems he had worked includes UNIX, VAX VMS/ OPEN VMS, CP/M, MS-DOS & Windows 2000,XP,2003 Servers, AOS, SUN OS 5.8. His rich experience on Computer languages includes Visual Basic Version 6.0, VB.NET, C#, DCL, BASIC, COBOL, and FORTRAN 77 & C, Shell Scripts and Perl. He has good working knowledge on various RDBMS which includes SQL Server 2000, Sybase ASE systems, DEC RDB, ORACLE, MS Access, FoxPro, Dbase. His experience on Package Applications ORACLE INVENTORY Version10.7, ORACLE, SAS from SAS Institute, Quancept, Quantum, Quanvert, SMS from SPSS MR and Remedy ARS Version 7. His exposures to Development Tools are Visual Studio 2005, Visual Basic 6.0 and Crystal Reports, VISUALFOXPRO 6.0, XML, 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 and he also used Utilities KERMIT, FTP, WINZIP, PKZIP , SNAGIT

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

PROFESSIONAL EXPERIENCE - FINANCIALS

Confidential,
Philadelphia, PA Apr 2002 to Sep 2004 Oct 2008 to Till Date

System: Design, Develop and support Financial System (financial guaranty insurance and reinsurance)
Role: Production Support of LEGACY systems and migrate to Web application.

• Maintenance / Enhancement and Production Support
• Solve Help desk tickets for system problems
• Develop/Modify Application Software for Govt Regulations (HMDA) / FNM & FRE
• Update and Track Change management Requests
• Maintain / Update Pricing Table ,Develop Web Service Calls to Biztalk Server
• Debug Java Code for the Web service calls using WSDL
• Co-ordinate J-Rule pricing Engine production Support issues on UNIX Box
• Manage External Data Feeds via EDI and FTP servers
• Design user interface for Data extract and do ETL legacy data into SQL Server database

Environment: Visual Studio .NET, C#, SQL Server, Rapid SQL, VAX VMS Cobol, Web Servers, Java, Unix Script

Confidential,
New York, NY Jul 2005 to Sep 2008

Role: Sr. IT Support Analyst (Level 1 and 2 Production Support) for Global Index Trading Desk.
System: Design, Develop and support Order Management system for Equity Trades using Sybase Database and VB6 Front End. Automate Trade List Generation and Index Re-balance, Attribution and Performance Data handling using Legacy FORTRAN System. Northern uses Legacy OMS - TPM (Sybase, VB 6) and ITG Triton and Goldman Sachs RediPlus as their EMS and Index and models system with Oracle 10 and .net C# Front End.
Responsibilities:

• Check Logs of Daily Unix Job runs (Shell scripts) for data feed to Legacy OMS from Charles River system for Asset Data , Position Data , Account Data and Broker Data
• Maintain Unix Scripts and Stored Procedures for Market Data Load for Index Trading from various providers such as Barra (Risk Model), Bloomberg, S&P , Russell (REDI) , FTSE, Wilshire, MSCI, FACTSET and Index Builder in a Dot Net C# Windows Forms Application Index & Models
• Scripts to automate to build Daily Workspace XML using DAO objects (A/c Holdings, Benchmark Holdings, Barra USE3L (domestic) GEMM (Global) Risk Model Data, Security Pricing, Security Master, Restrictions and Strategies) for AXIOMA Optimizer
• Production Database Support for Back office and Trading Desk on Trade Data / Commission Reports / Broker Execution Files including the matching process and Compliance Reporting
• Provide Production Support on Market Data Feed for pricing , corporate actions , security information from various providers such as Telekurs, IDC (FT Interactive Data), JJ Kenney
• Used ODBC Database connections for preparing Cash Projections , Overdrafts and Cash Comparison reports every morning for the trading desk before the market opens – Data source from EAGLE Accounting System
• Work with DBA team to refresh UAT database for user sign off
• Do ETL and VBA Scripts and build Transaction Database for Traders to analyse Post Trade Transactions
• Work closely with Compliance Team for Transaction/commission Report requirements and internal / SEC Auditing
• Prepare / Update DR plans for Production systems and Testing
• Active participation in Quarterly / Monthly Re-balance and Yearly Russell Recon
• Performance Tunning on Legacy OMS database

Environment: Visual Studio .NET, C#, Sybase, ORACLE, Rapid SQL, MS Data Access Page, HTML, Visual FOXPRO, VAX VMS Fortran, Web Servers, Charles River, Unix Script, Perl

Confidential,
New York, NY Jan 2000 to Mar 2001

Role: Migrate/Convert DB’s Trading, Portfolio and Performance Management System.
System: 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 UNIX servers.
Responsibilities:

• Migrating Application software to ALPHA Open VMS
• Data Analysis, Data Manipulation and Working with VAX RDB, Sybase Databases
• Co-ordinate with UAT Group for Software changes Signoffs
• Setup / Maintain External Brokers accounts to access trade details
• Design UI for data extraction for XAMIN and Global Data Hub (Data warehouse)
• Monitor Overnight Feed from various data sources (FX Rates, Broker’s Trade Details, Pricing Feed, Corporate Actions Feed )

Environment: Alpha OPEN VMS, VAX FORTRAN, C, Sybase, ORACLE, VAX RDB, UNIX, XAMIN, XML, HTML

PROFESSIONAL EXPERIENCE – NON FINANCIALS

Confidential,
New York, NY Oct 2004 to June 2005

Migration/Conversion of Legacy Accounts Data from Cobol system to SQL Server 2000 Enterprise Manager. NFL uses VAX VMS legacy systems for Accounts, P&L and Balance Sheet Data for 16 years and retired the system in 2004. The legacy financial data were required for various audit and legal departments and wanted to build intranet web site with reporting facility using Crystal Report and migrate all the data in SQL server 2000 using SQL Server 2000 enterprise manager.

Confidential,
Parsippany, NJ Apr 2001, Nov 2001

Migration and Integration of AT&T’s Legacy Billing Systems, Systems runs on AMDAHL System (IBM Mainframe) and GMS (Global Mail System) on ALPHA servers.

• Migration of IBM Cobol Programs to VAX Cobol Programs
• Analysis of SAS Module Functionality on Billing Cycles and migrate to COBOL
• SAS codes for extracting Financial Data for Oracle Financials
• Developed VAX FMS Screens and VAX DCL Procedures to run the Job
• Validation of Switch Data, Billing Cycle Processed Data, Invoice Results

Confidential,
Chennai, India Jun 1986 to Dec 1999

Lead a Team of Programmers in an in-house System development, implementation and Maintenance and End User Training.
Systems: Oracle Apps (Financials and Inventory), Supply Chain Management, Billing Systems and Project Management Software, Engineering Design Calculations, Contract Management
Responsibilities:

• System Analysis and Designs, mentor programmers
• Configuration Management, Software Upgrades
• Physical and Logical design of Databases and Tables in ORACLE RDB
• Develop lot of PL/SQL Codes , Triggers , Views and Indexes
• Work with Visual Basic, ODBC drivers to access data from various sources including VAX RDB, ORACLE RDB, FOXPRO
• Build Help systems using MS Help Compiler for all in-house systems
• Prepare Test Plans , Data Migration , Conduct End User Training

Environment: Alpha Open VMS, VAX COBOL, VAX Basic, VAX FORTRAN, Visual Studio, Visual Basic, Visual FOXPRO, MSDOS, VAX RDB, ORACLE Applications