Data Architect

Suhas Dere 201-***-****

*********@*****.***

Plano, TX

Objective

SEEKING AN OPPORTUNITY TO PROVIDE TECHNICAL GUIDANCE IN DEFINING THE DATA

ARCHITECTURE STRATEGY FOR THE BUSINESS

PROFESSIONAL SUMMARY

. MORE THAN 17 YEARS OF EXPERIENCE IN IT FIELD.

. Worked for 2 large Investment Banks for 9 years providing IT Solutions

for Trading Systems

. Data Architect for 6 years. Delivered Data Management vision, goals,

priorities, design principles and operating policies as per the

business goals of the organization

. Management and implementation of database models, data flow diagrams,

database schemas, db scripts, DTD schemas, structures and data

standards to support a robust data management infrastructure

. Experienced in translating Business Requirements into Conceptual,

Logical and Physical data models.

. Database auditing for access and privileges and remedial action

. Designed and implemented Metadata for mapping FIX and XML tags to

tables and columns between Sybase and DB2 databases.

. Implemented best practices and methodologies in Data Analysis, design

and modeling

. Experience in Extraction, Transformation and Loading (ETL) using both

scripts and tools like Informatica.

. Adept at both homogenous as well as heterogeneous Data migration

. Have lead large teams and trained newcomers

. Complete SDLC experience using Iterative development processes like

RUP, Agile and Waterfall models, Object Oriented development

techniques and Service Oriented Architecture (SOA).

. Handled database and query performance issues while migrating from

Sybase to SQL Server.

. Have working knowledge of Hibernate, Websphere, Weblogic, JBoss,

TIBCO, Tivoli etc.

. Seasoned professional, with outstanding project planning, execution,

monitoring and resource balancing skills with ability to support

multiple simultaneous projects in a matrix organizational structure.

TECHNICAL EXPERTISE

. PROJECT MANAGEMENT TOOLS AND TECHNIQUES

Software Development Life Cycle Methodology (SDLC), Six Sigma, CMMI,

Waterfall, VersionOne for Agile and Scrum, MS Project, MS Visio, MS

Excel, Clarty PPM

. Languages/Technologies

Service Oriented Architecture (SOA), C/C++, Java, JavaScript, XML,

Perl, Shell, VC++, PL/SQL, HTML, Message Queues like MS MQ and TIBCO,

JBOSS

. Design Tools/Methodology

OOP/OOAD, IBM Rational Unified Modeling Language (UML), Use Cases,

Rational Unified Process(RUP), ITUP, Rational Clear Case, Microsoft

Visio, ERWin Data Modeler

. Development Tools

SSMS, SSIS, SSMA (SQL Server Migration Assistant), DBArtisan, TOAD,

Sun Workshop, VisualStudio, Eclipse, SQL-Programmer

. Databases

Sybase 12.5/15, Sybase IQ, DB2UDB, Oracle, SQL Server 2005/2008/2012

. Quality Assurance and Change Management

Jira, Netcool, Service Now, HPSC, Subversion, Teamcity, VSS, CVS, RCS

. Operating Systems

Windows XP/NT, DOS, Sun Solaris, Linux, HP-UX, SGI Unix, SCO Unix

employment history

CLIENT: ERICSSON, PLANO TX

JUL 2013 - SEP 2013

Domain: Database and Platform Migration

Role : Database Design and Migration Architect

Project: Unix2Linux migration

Ericsson is building a Migration Utility to migrate thousands of their

client applications from Unix to Linux platforms and Sybase to Oracle

Database. I am hired as consultant as Solution Architect, Data Architect

and Program Manager.

Responsibilities:

. Identifying client requirements and Application scope, technologies

and versions

. Study of competitive products in the market, their suitability for our

needs

. Study of known issues and strategies to find them in the Applications

. Collating all U2L migration issues and designing the Data Model - LDM

and PDM

. Making the data self-learning using iterative processing

. Keyword replacement and environment changes to the code by using

database tables

. Utilities for analyzing the modified code and automated testing.

. Making the application run at a single button click and do end to end

processing

Environment: MS Project, Visio, PL/SQL, PowerBuilder, Sybase ASE 15, SQL-

Server 2012, Oracle, ERWin, SSMS, SQL-Programmer, MS Visual Studio, SSMA,

SSIS-SSRS

Client: Oppenheimer Funds Inc

Feb 2013 - Jul-2013

Domain: Asset Management

Role : Solution Architect and Program Manager

Project: HP-UX/Sybase Exit

Oppenheimer Funds is moving their HP-UX servers to Linux and the Sybase

databases to SQL Server and a few to Oracle. I am hired as consultant as

Solution Architect, Data Architect and Program Manager for the migration of

over 35 applications.

Responsibilities:

. Solution Design to migrate Sybase ASE 15 Database to SQL server 2012

keeping the look and feel of the Application intact.

. Using SSMA (SQL Server Migration Assistant) for migration and testing

. Designed and implemented Solution for Windows Authentication

. Generating the current Data Model and database design diagrams - LDM

and PDM

. Creating a Data model for sharing common data (funds and accounts)

across the whole firm

. Central repository for Change Documentation and Knowledge Transfer

. Utilities for analyzing data validation and automated testing.

. Query and sproc performance tuning of Sybase, SQL Server and Oracle

. Generating Data Model for future development

. Using SSIS for migrating large data

Environment: MS Project, Visio, PL/SQL, PowerBuilder, Sybase ASE 15, SQL-

Server 2012, Oracle, ERWin, SSMS, SQL-Programmer, MS Visual Studio, SSMA,

SSIS-SSRS

Employer: TCS

Client: Barclays Capital

July 2011 - Dec 2012

Domain: Investment Banking

Role : Project Lead and Data Architect

Project: Cash Equities Middle Office

The takeover of Lehman Brothers operations by Barclays Capital resulted in

many duplicate systems, one of them being Post Trading Operation

Applications. A study for merging or migrating these was conducted and

solution was designed.

Responsibilities:

. Database redesign merge or move Lehman and Barclays Capital

applications so that the applications are not affected

. Finding areas of improvement, new Exchange/broker implementation,

. Redesigned Logical and Physical databases and defined metadata to map

old and new tables and columns so that minimal code changes are needed

. Designed and implemented Solution for Access Control eg Database admin

rights were given to dev team members or those who were no longer in

the project.

. Central repository for Change Documentation and Knowledge Transfer

. Query and sproc performance tuning of Sybase, DB2 and SQL Server.

. Batch and report rescheduling for Oracle database performance issues

. Moving users to LDAP/Active Directory Authentication

. Replacing XML based Data Exchange to JSON scripts

Environment: MS Project, Visio, PL/SQL, Perl, Shell, Asset Control, JDK

1.6, JSP, Servlets, JDBC with Eclipse as IDE, IBM WAS as app-server, JUnit,

PowerBuilder, DB2-UDB, Sybase, SQL-Server 2008, Oracle with SQL, MySQL

Employer: TCS

Client: Barclays Capital

Aug 2010 - July 2011

Domain: Investment Banking

Role : Solution and Data Architect

Project: Sybase Exit

During 1999, Barclays Capital decided to move away from Sybase applications

and a large Sybase Exit program was initiated. This required an analysis of

the Sybase spread in the organization, estimating the efforts, running

Proof Of Concepts, finalizing the new database, Migration Solution

Architecture, customer and Application owner buy-in and then executing it.

It was decided to give the owner an option of moving to either SQL Server

2008 or Oracle.

Responsibilites:

As Sybase Exit Solution and Data Architect, I was responsible for

. Providing technical expertise for Design and Development of the Sybase

Database Migration Program.

. Building tools to help Migration of Database Schema and data,

verification of data, testing the application etc

. Estimating cost, effort, manpower, resources for database migration

. Contacting the Application owners and convincing them to undertake

migration

. Conducting Proof of Concepts (PoC) for database selection, bulk data

migration, performance and ETL speed. Some of them are:

o PoC for Sybase IQ Replacement by comparing SQL Server

performance, developing tools for extraction of data

o PoC SSMA (Sql Server Migration Assistant) for migration to SQL

Server.

o PoC for SSIS for bulk data migration to Sql Server

o PoC for SQL Ways for any source and target database

o PoC for SQL Developer for any source and Oracle target database

o PoC for iWatch for database process monitoring

o PoC of Sybase Replication Server for cross-RDBMS replications

. Utilities to compare the Application Performance before and after

Database migration.

. Adhoc technical issues in Migration eg slow queries, incorrect

resultset, resultset order not being the same etc

. Testing and approvals of Third Party Tools used for migration,

database monitoring etc eg Freebcp, freeTDS, iWatch

. Liasing with SQL Server and Oracle teams for Advanced Migration

solutions as their migration utilities were in infant stage

. Setting up Authentication using LDAP/Active Directory on the new

systems and migrating the users to them

Environment: MS Project, Visio, Sun Solaris, Linux, Java/J2EE (JDK 1.6,

JSP, Servlets, JDBC), Sybase, Sybase IQ, Oracle, SQL Server, C/C++, Perl,

Shell, Autosys, TIBCO, MQ, SSIS, SSMA, SQL Ways, SQL Advantage, Crystal

Reports, PowerBuilder, Informatica, SAS, Microstrategy, BOXI, FreeTDS,

Freebcp etc, SQL Developer, SQL Ways, iWatch

Employer: TCS

Client: Morgan Stanley

Jul 2009 - Jul 2010

Domain: Investment Banking

Role: Database Audit Architect and Project Lead

Project: Segregation of Duties (SoD) AKA Entitlements

In view of the SEC security compliance, Morgan Stanley decided to setup a

firm wide database access auditing Architecture which will send out alerts

to database owners on the Well being of their databases. This came to us as

a single mission statement and the entire Solution was designed by a few

people including me.

Responsibilities: As Data Architect and Project Lead, I successfully:

. Designed SoD solution suite for over 75000 databases - Sybase and

DB2UDB

. Provided technical expertise for data extraction like logins and

users, last access, permission etc.

. Designed and got approved criteria to classify a database into 'Well

Maintained" or not

. Got approved special considerations with senior management like common

login to all databases for data extraction

. Designed LDM and create the PDM database to store this data from where

reports are generated

. Suggested remedial action to the database owners

. Trained Team members on the SoD aspects, Prioritization, distribution

and followup of tasks

. Provided senior management with automated weekly reports of non-

compliant databases

Environment: PPM,Visio, Linux, Sybase, DB2, Perl, Shell scripts, ERWin,

Autosys, MySQL, T-sql, isql, fsql, wsql

Client: Morgan Stanley

Apr 2008 - June 2009

Doman: Investment Banking

Role: Data Architect

Project: Athena ETSDB

Athena is the next generation DB2-UDB Equity Trading Database, replacing

the present one in Sybase. This stores large amount of data - over 100

million rows coming in daily and reports and Confirmations are sent from

this. Redesigning the Database Architecture, creating metadata for old to

new column mapping, utilities to reconcile the Sybase and DB2 data were

some of the tasks.

Responsibilites: As Data Architect, I was responsible for

. Providing technical expertise for re-designing of the existing ETSDB.

. Designing Metadata Architecture to map columns from old Sybase and the

new DB2 database.

. Parallel flow setup so that both Sybase and DB2 databases received the

trading messages

. Design scripts to reconcile data between the Sybase and DB2 databases.

. Testing replication and performance optimization techniques for this

high availability database eg runtime archiving

. Comparison of XML and FIX messages for speed and space.

. Mapping FIX message fields to proper table and columns

. Perl scripts and DB2 sprocs for matching between the Orders and Trades

coming from Front Office and Exchange

. Conducted PoC for DB2 vs Oracle 11g database for similar load.

. The whole Oracle setup was done in 2 weeks under extreme programming.

. Environment: MS Project, Visio, Linux, Sybase, DB2, Perl, Shell scripts,

ERWin, Oracle 11g, Autosys, Microsoft MQ

Morgan Stanley

May 2007 - Mar 2008

Domain: Investment Banking

Role: Project Lead and Data Architect

Project: ERisk Reconciliation

This was a Equities Risk Reconciliation project. Risks emanating from

various trading systems were collected and the firm wide risk was arrived

at, which was used to hedge the position. Data collection and storage

design, risk calculation and reporting tools were setup for this

application.

Responsibilities: As Solution Architect, I was responsible for

. Getting the Business requirements from the Users

. Collecting the raw data for evaluating Greeks from various trading

systems like Fidessa, Summit, Passport and excel based tools.

. Design the reconciliation Applications, planning and executing

. Designing the database to collect risk parameters from various trading

systems and storing them

. Prioritization and distribution of the tasks

. Perl scripts to reconcile Risk between various Trading systems

. Performance monitoring and tuning of the queries and sprocs

. Prepared project plan to move to Informatica as ETL

Environment: MS Project, Visio, Linux, Sybase, Perl, Shell scripts,

Autosys, Informatica, T-sql, isql, fsql, wsql

Client: Morgan Stanley

Jan 2007 - Apr 2007

Domain: Investment Banking

Role: Solution Architect

Project: DB Migration Proof of Concept (PoC)

Morgan Stanley moved their Data Center from London to Croydon and while

doing so, moved the infrastructure from Solaris to Linux servers and all

Sybase databases to ASE 12.5 version. The PoC was to determine the Server

and version of all Sybase databases in London and design the migration

alongwith server and /or database upgrade. One of the major task was to

find the owner(s) of the database. For this a team of 12 people was

assembled, web tool using CGI-Perl was developed to conduct a survey of all

the application owners. Also tools using Perl and Shell scripts were

implemented to extract the Server type and database version. We also

involved TCS R&D center to develop a Scheduling package which optimized the

database migration for minimal testing. All this knowledge we got from this

PoC was utilized in the proposal and implementation.

Responsibilites: As a Solution Architect for DB Migration, my

responsibilities were:

. Planning the Datacenter movement for over 3000 databases

. As the ownership of many databases was not clear, a survey across the

firm was taken for which Web Survey tool was developed. The feedback

was taken from hundreds of Application owners.

. A crack team of 12 people was setup and tasks were prioritized,

distributed and followed up. All activities were completed within 3

months.

. Designed and Deployed the architecture to collect Server and database

parameters like type and version. Database was designed to store all

this data and reporting infrastructure deployed so that the senior

management had all the figures at their fingertips.

. Keeping the progress of all 12 team members well coordinated as time

was critical

. Designed framework for Performance optimization techniques during the

migration,

. Designed the framework for Quality Testing and release

. Environment: MS Project, Visio, Linux, Sybase, Perl CGI, Shell scripts,

Autosys, Sybmon, T-sql, isql, fsql, wsql

Client: Morgan Stanley

Jun 2005 - Dec 2006

Domain : Investment Banking

Role: Tech and Domain Lead

Project: Quantum P&L

Quantum was a Profit and Loss calculating Application. All the trades from

various trading systems was collated and then firm wide trading P&L

calculated. Various tools to monitor the batches, data quality, database

performance were built and deployed.

Responsibilites: As a Tech and Domain Lead, my responsibilities were:

. Design, build and deploying tools to monitor batch jobs which loaded

the data into Quantum Database

. Monitoring mechanism using Perl scripts for batch jobs

. Built and deployed Sybase utilities to monitor the database health

like tempdb space usage.

. Provided improvement suggestions to the dev teams

. Conducted adhoc tasks like server migration or upgrade

. Release coordination

. Environment: Visio, Linux, Sybase, Perl, Shell scripts, MQ, Autosys, T-

sql, isql, fsql, wsql

Client: Morgan Stanley

Nov 2003 - Jun 2005

Domain: Investment Banking

Role: Business Analyst

Project: B&C

Responsibilites:

Brokerage and Clearing was a transaction charges calculating application

where the Trading data was coming directly from Vendors for exchanges like

NYSE, CME, OCC etc. Morgan Stanley was able to save millions of dollars in

brokerage by making optimal use of the Brokerage contracts using this tool.

Responsibilities: As a Business Analysts, my responsibilities were:

. With inputs from Business users, design, build and deploy utilities

load feeds coming from new exchanges, brokers or Clearing Corps into

the database.

. Design and implement infrastructure using Perl scripts to monitor the

batch jobs and their status

. Sybase utilities to process loaded data and monitor the database

health

. Find areas of improvement, plan and implement the enhancements

. Design and deploy Reporting Architecture

. Build and Release coordination

. Environment: MS Project, Linux, Sybase, Perl, Shell scripts, Autosys, T-

sql, isql, fsql, wsql

Client: Parametric Technologies Corp (PTC)

June 1999 - Mar 2003

Domain: CAD/CAM

Role: Senior Developer

Project: Pro-E

PTC is a leader in CAD-CAM solutions. Their flagship modeler was undergoing

GUI redesign and I redesigned the UI for "Hole" feature.

Responsibilities: As a Senior Developer, my responsibilities were:

. Conversion of the old UI to the dashboard UI using the Dashboard Layer

. Researching for all possible scenarios to define a hole.

. Collate Hole related Bugs reported by users all over the world,

prioritize them and then provide release dates to Sales people.

. Implement the enhancements and fixes

. Run regression tests on all test cases

. Release the changes

. Environment: Sun Solaris, C, Fortran, Workshop

Client: Parametric Technologies Corp (PTC)

June 1999 - Mar 2003

Domain: CAD/CAM

Role: Developer and Release Coordinator

Project: ICEMDDN

ICEMDDN was acquired by PTC and they wanted to bring all the Development

work to India. We spent 3 months in Minneapolis, USA for Knowledge Transfer

and took all the Dev and testing work to India.

As a DXF to DDN file conversion Developer and Release Coordinator, my

responsibilities were:

. Coordinating the Release with all the 10 team members and keeping the

Senior Management and Sales people updated on the progress

. Comparing the AutoCAD and DDN Solid Models and identify areas of

improvement.

. Move the systems from Cisco to Solaris Networks

. Prioritize the requirements/bugs and schedule the release

. Implement the enhancements and fixes

. Regression tests on all test cases

. Release the changes, Cut the CD and ship it to US office.

. Environment: Sun Solaris, HP, SGI, C, Fortran, Workshop

Client: Datamatics Ltd

Oct 1998 - Jun 1999

Domain: R&D

Role: Project Leader

Project: Legacy Script Conversion and Migration

Datamatics was developing an Infrastructure to convert legacy scripts into

Open Systems based ones using a B-tree structure. I led a team of 12

people, who were not from IT field, trained them on SDLC.

Responsibilities: As a Project Leader, my responsibilities were:

. Design the script conversion application

. Training 12 non-IT people on Software Development.

. Find language specific issues and Customize it for that language

. Prioritize the tasks, distribute them in the team members and

implement them

. Test the applications with live scripts

. Testing the feasibility of moving from proprietary network to Cisco

network

. Release the application

. Environment: Windows 95, VB, C++

Client: Sungrace Computers, Pune

July 1997 - Sep 1998

Domain: CAD/CAM

Role: Module Leader

Project: Structure Works

Sungrace was developing an application Structure Works for CADSi, USA. This

was Windows based application using Solidworks framework. This application

simulated the stresses produced in a Solid under various forces. We

travelled to Iowa City, USA and gained knowledge of the application.

Responsibilities: As a Module Leader, my responsibilities were:

. Identify areas of improvements by comparing with Unix based

application.

. Design, plan and execute the enhancements.

. Run the regression tests

. Release to the US team.

. Environment: Windows NT, VC++, MFC

Client: Geometric Software, Mumbai

Feb 1996 - Jul 1997

Domain: CAD/CAM

Role: Developer

Project: NESTLIB

NESTLIB is patented nesting software used in sheet metal manufacturing

developed by Geometric Software and renowned for its performance and

accurancy. Liaised with IIT Bombay professors for finding innovative

solution for Nestlib.

Responsibilities: As a Developer, my responsibilities included:

. Identify areas of improvements.

. Design, plan and execute the enhancements.

. Setting up the regression test environment with thousand of test

cases.

. Run the regression tests and release

. Environment: Windows NT, C++, MFC, COM, OLE, Windows SDK

Education / Training / Certifications

. DIPLOMA IN BUSINESS FINANCE, ICFAI

. Master of Technology (Mechanical Engineering) Jun-1994 - Jan 1996, IIT

Chennai

. Bachelor of Engineering (Production), Fr. C. R. C. E., University of

Bombay, India, May 1993.

. NCFM certifications on Capital Markets, India

MISCELLANEOUS

References: Available upon request

Contact this candidate