Database/Data Warehouse Expert

KAMAL TAPARIA

*, ******** **

East Brunswick, NJ-08816

Phone: 732-***-****

E-mail: ********@*****.***

SUMMARY

• A Database Technologist with 15+ years of IT experience in database design, implementation and administration and software application development and maintenance.

• Expert in data warehouse design and implementation.

• Designed the architecture of various Database Information Systems in Sybase 10.x/11.x/12.x, UDB v8/9 and Oracle 9i/10g under different operating systems.

• Excellent financial industry experience (Brokerage, Fixed Income, Investments, Equities and Trading applications).

• Extensive experience in user interaction, system analysis, system design, coding, testing, implementation and troubleshooting.

• Managing a team of 3-5 persons – on-shore and off-shore.

• Experience in team building, team consensus, developing project scope (timelines and delivery dates), resource leveling (sharing resources), resource loading (recruiting), client relationship, continuous design improvement and conducting status review meetings.

• Expert in system analysis, design and development using Sybase, UDB, SQL Server Analysis Services, Unix, Perl, C/C++, Informatica.

• Good experience in disaster recovery, performance tuning and backend development.

• Experience in Planning and implementing the Replication of Databases.

• Demonstrates exceptional problem solving, strategic thinking and job completion under tight schedule.

TECHNICAL SKILLS

Hardware : SUN Enterprise 250/450/3500/6500/10000, ICL DRS 6000, Pentium

Operating Systems : Solaris 2.5.1/2.6/8, UNIX SVR4, WINDOWS-95/NT 4.0

Software Languages : C/C++, PASCAL, Perl, SAS

RDBMS : UDB v8/9, Oracle 9i/10g, Sybase System 10.x/11.5, ASE 11.9.2/12.0/12.5, Sybase IQ, Replication Server 11.5/12.x

DATA Modeling : Erwin

GUI : Power Builder 5.0, JAM, JSP, Java, JavaScripts, DBArtisan, IBM WebSphere

Business Intelligence : Microsoft SQL Server Analysis Services(SSAS) 2005, Proclarity, AlphaBlox

ETL Tools : Informatica

Scheduling Tools : AUTOSYS

Familiar with : Unix Shell Programming, K-shell, C-shell, COBOL,

MQSeries-5.1 (IBM), SQL Server

PROFESSIONAL EXPERIENCE

Lehman Brothers (Barclays Capital) New York, NY 2006 to present

VP – Fixed Income Technology & Analytics

• Design and develop data warehouse and business intelligence (OLAP cube) for US non-Agency residential mortgage using UDB, MS Analysis Services(SSAS 2005) to provide performance and characteristics at different levels. The cube is 350GB+ with 1.3B+ records of 30+ dimensions and 100+ measures. It uses data from Loan Performance. This project received Microsoft’s Best Innovation award in 2007. (http://www.windowsfs.com/TheMag/tabid/54/articleType/ArticleView/articleId/2091/The-Innovator-Awards.aspx).

• Data modeling (both logical and physical) using Erwin, DBArtisan.

• Lead a group of 3-5 developers (including off-shore team) to design, develop and analyze residential loan origination, performance and characteristics of securitized products (MBS).

• Work closely with business groups – Mortgage Research, Modeling and Trading groups to understand requirements, design and develop applications for both internal and external clients.

• Designed and installed cluster for UDB with terabytes of storage USING DPF for mortgage related data.

• Used SAS (Statistical Analysis package) to develop analytical tools used by various business groups.

• Use Sybase IQ for other data storage and query application.

• Developed prototype data warehouse using Oracle database.

• Other Achievements:

o Credit Risk Tool: Developed data warehouse for surveillance and risk aggregation of Lehman-owned securitized products.

o Lehman Servicing MBS Analyzer: Developed data warehouse for performance of Lehman-issued and serviced securitized products using UDB and SSAS 2005.

o Origination & Pipeline: Developed multiple reports to provide mortgage origination volume, trends and pipeline information. These reports are used by both internal and external clients to understand market trends and hedging purpose.

UBS Financial Services Inc Secaucus, NJ 2003 to 2006

Lead Associate

Corporate Employee Financial Services (CEFS)

• CEFS maintains 80+ corporate clients’ employee information related to stock option, stock purchase and restricted stock. The participants can exercise options or trade long share positions in their account through the internet application.

• Involve in every phase of software development life cycle. Analyze business requirement, design technical specification, data modeling, development, testing and leading a group of developers.

• Meeting with business group, gathering business requirement.

• Delivered series of projects in time and working on multiple projects simultaneously, in Sybase, Oracle as backend and Java for the front end.

• Meeting with other groups within UBS and outside UBS to accomplish projects requiring involvement of other groups.

• Project planning, managing resources in multiple projects, status updates.

• Leading a group of 3-7 people with offshore group working from India.

BISYS Retirement Services Philadelphia, PA 2003

Sr Performance Analyst

• Bisys Retirement Services maintains 401k etc. plan of large institution using client-server technology. Participants can log into the system to check their account or make changes in various aspects of the retirement plans.

• Performance of the system was increased to multiple folds while number of engines has been reduced to 10 from 16.

• Leading an off-shore team working on optimization and development. Work involves requirement analysis, data modeling, code review of new projects.

• Present report to the management on the progress on weekly basis.

UBS PaineWebber Secaucus, NJ 2002 to 2003

Corporate Employee Financial Services Division

Sybase Performance Analyst

• The CEFS division takes care of the clients’ employee stock option, stock purchase and restricted stock award plans. The Checks & Journal Application handles all stock movements and produces confirms and checks for the employees of the different clients.

• The performance of the system is very slow and cannot handle a large volume which is required due to a new client(70000 employees will be vesting stocks on the same day).

• Almost 70% of the application has been reworked to increase the performance of the batch jobs and online processing functions as well.

ADP (Automatic Data Processing) New York, NY 1998 to 2002

ADP Brokerage Services Group Jersey City, NJ 2001-2002

Description: Analyze client requirements, specifications, design and development of new functionality and interfaces, Sybase Performance & Tuning, Implementation, Communication Services with SWIFT, TRAX, EuroClear, ClearStream etc.

Application Development:

• Gloss Bureau Global Settlement System :

Gloss Bureau of ADP provides trade and settlement processing for clients. Gloss (Global Settlement System) is a multi-currency global trade and settlement processing engine providing accounting and ledger processing. It has multiple communication products to transfer messages with the various settlement agencies like SWIFT, TRAX, EuroClear, ClearStream etc.

• Swift ISO15022 Implementation: Developed and implemented new Swift ISO 15022 standard message types for securities market using Sybase stored procedures, C/C++, Perl.

Goldman Sachs New York, NY

Investment Management Division 2000-2001

Software Engineer

Asset Management & Reconciliation System (AMR)

Goldman Sachs DOTCOM (GS DOTCOM)

Private Wealth Management (PWM)

Custody Technology in Investment Management Division uses GLOSS architecture for Asset Management & Reconciliation (AMR). The followings were achieved during this period:

• Sybase Performance & Tuning: The AMR system is heavily database oriented, and query performance is a major issue to make the system run smoothly. Sybase queries used in different stored proc were revisited to fix performance issues.

• Application Development

• End of Day Processing & Reconciliation:

• Revamped existing jobs for End of Day processing that resulted in the reduction of processing time by 25%.

• Developed and implemented new reconciliation jobs using Sybase, Perl, Unix.

• GS DotCom Implementation:

• Involved in the development and implementation of GS DotCom using Sybase, C/C++, Perl.

• Developed and implemented new SnapShot application (a frozen view of transaction data related to a specific business period).

• PWM Rollout: Private Wealth Management – PWM AMR system, altogether six offices, is used by Goldman Sachs sales representatives to manage high net-worth clients assets.

• Designed system which could speed up processing by correctly identifying only transactions needed for a specific period of time.

Prime Brokerage Division 1999

Software Engineer

The PRIMEVIEW application in the Prime Brokerage Division of Goldman Sachs, earlier running on Sybase 4.9.2, was upgraded to Sybase 11.9.2. The major issues were to check all types of upgrade issues between the oldest and newest Sybase version.

Wilco International Ltd. London, UK 1998-1999

Performance Testing of Gloss HV4.0

Performance testing was done for Gloss HV4.0 with Sybase 11.5 as back end. During the testing the stored procedures were tuned using showplan, statistics io, statistics time, dbcc tools to optimize the trade processing and enhance the trade throughput of the system as a whole.

Assisted in performance testing of Gloss HV4.0 in SQL Server.

Indian Oil Corporation Mumbai, India 1993 to 1998

IndianOil, India’s only Fortune 500 company, is involved in refining and marketing of Petroleum products.

Assistant Manager(Systems)

Developed various projects using Sybase, PowerBuilder to support finance, marketing and operation.

EDUCATION

Bachelor of Engineering (Computer Science & Technology)

Bengal Engineering College (University of Calcutta), Calcutta, India

Brokerage Operations

New York Institute of Finance, New York

Contact this candidate