SUMMARY:

• Team Lead/Senior Developer/Data architect with over fifteen years of experience in the analysis, design, development and performance tuning of client/server, object oriented and web based applications using SQLServer/DB2/Oracle/Sybase, C#, C/C++ on Unix/Linux/Windows platforms.
• Has substantial business experience in Market Data and Reference Data, Risk, P&L and Fixed Income Mortgages and Whole Loan data.
• Experienced in the full life cycle of project development and particularly enjoys the technical aspects.
• Exceptional expertise in designing high volume, high available distributed system and performance tuning.
• Experienced working under pressure and to tight deadlines.
• Business Knowledge in Whole Loan, TRS Loan, Mortgages, Bond, Equities, FX, P&L calculation and GL (General ledger), CDO (Cash and Synthetic), CDS, ABX, ABS
• Designed and implemented performant Large Scale Data Warehousing (ETL, ODS, Datamart) in Oracle/SQL Server/DB2/Sybase on E2E development life cycle
• Implemented multiple Data Migration efforts On - premises as well as AWS Cloud
• Designed Enterprise level Global Distributed well architected with features like High Availability, Scalable, Fault tolerant Application
• Extensive hands on experience in Performance/Volume/Stress Testing, Scalability Testing, Disaster Recovery System
• Strong Skills in using Case Tools like Rogue Wave, Object Space, Control M, Git
• Possesses strong problem analysis skills with ability to follow project standards
• Ability to quickly master new concepts and is a team player

TECHNICAL SKILLS:

Operating Systems: UNIX, LINUX, Windows

Languages: SQL/NoSQL, Perl, Python, Shell Scripting, R, C#,C/C++ (Rogue Wave, STL)

Databases: SQLServer 2012-17,DB2 11.1, Oracle11G/12c, Sybase, Sybase IQ, Vertica, PostgreSQL, MySQL, MongoDb

Tools: Erwin, Power Designer, UML, Toad, DB Artisan, Spot Light, Solar winds, SQL*Loader, dbx, PVCS Tracker, Git, Rational Purify, Autosys, Exceed

Systems: TCP/IP sockets, Interrupts and Signals, process controls

Messaging: MQ Series, Kafka, Oracle AQ, Talarian Smart Socket, JMS

ETL/OLAP: Informatica Powermart, SSIS, Cognos Powerplay

Cloud: AWS RDS/DMS/S3, MS Azure SQL Server

Project Management: Agile Methodology, MS Project, Visio, Excel, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Data Architect/Engineer (Consultant)

Responsibilities:

• Designed and implemented the Data warehouse of New product approval (NPA) system. This high visible system is used for due diligence, impact analysis, risk & market analysis, legal & compliance analysis for approving the New Product of Confidential . Mutiple data marts are designed to gather all NPA analysis real time and historical data, checklist coverage and support the data mining and NPA reporting infrastructure.
• Designed and implemented the entitlement provision and revocation process to access to the new product approval (NPA) system, maintaining entitlement profile and coverage and integrate with firms employee data warehouse.
• Support and interact with off-shore India team.
• Data warehouse design based on dimensional star schema, Query Design and optimization, writing Stored Procedures/triggers to accommodate all complex business rules, impact/performance analysis and day to day production support activities, users requirements gathering and analysis and giving outlines of team needs to the system people.

Environment: Linux, DB2/Oracle, SQLServer 2016/2017, Python, Unix Shell scripting, Power Designer, Solarwind and git.

Confidential, NY

Sr. Data Architect/Engineer (Consultant)

Responsibilities:

• Designed and implemented Data warehouse for Corporate Security Master to provide timely and healthy security master data to different applications. It involves data gathering, data cleansing, data mapping of multiple sources and data presentation to end user. Primarily Bloomberg back office, CAX file, on demand real time data, MarkIT security master data are collected.
• Designed the data container for high frequency trading systems involving equity, fixed income, options and derivative products.
• It also acts as a data adaptor between different trading systems like FLEX, Front Arena etc.
• It involves designing the corporate data warehouse for trading, position and P&L data.
• SQL Server 2016’s query store, temporal, column store index, memory optimized features are used to deal with high demand tables to make data operation smooth and able to capture the versioning data in the underlying history container of the temporal tables. Also, SQL Server Failover Clustering and Always on Availability Group features are used to enhance the system's HA and DR process.
• Designed and developed the real/almost real stress/volume testing environment to produce 1x to 10x of live trading data. The result can give confidence to Management to increase the trading volume accordingly. Live production data is collected from read only asynchronous secondary node without disturbing the live trading environment.
• Designed data archival process seamlessly move more than one year old data from on-premise database to MS Azure stretched database and keep recent one year data in on-premises MS SQL server databases.
• Responsible for architectural design and implementation for migrating on premises data to Cloud using AWS RDS/DMS/S3.
• Database Design, Query Design and optimization, writing Stored Procedures/triggers to accommodate all complex business rules, impact/performance analysis and day to day production support activities, users requirements gathering and analysis and giving outlines of team needs to the system people.

Environment: Windows 2016, Linux, SQLServer 2016/2017, PostgreSQL, Python, Unix Shell scripting, C#, Kafka, AWS RDS/DMS/S3, MS Azure stretched database, Erwin, Solarwind.

Confidential, NY

Sr. Data Architect/Engineer (Sr. Vice President)

Responsibilities:

• Designed and implemented Data warehouse to hold research, trading, pricing and analytical data.
• It involves data gathering and data mining tools to facilitate all Front Office and Mid Office user to have easy access to current and historical market data, trading and position data and calculated P&L data.
• The system also gathers the administrator data to reconcile calculated P&L.
• Project was on budget and on schedule. It makes a significant $$ and time savings for Traders, Researchers and Management.
• Designed and implemented Whole Loan(NPL, BPL, RPL) monitoring system It involves various servicer
• Monthly data points, REO and pricing data collection, data loading to the data warehouse based on mapping rules and calculate and Loan data Reporting. It allows the whole loan desk to analyze the loan data, enable them to make the decision to buy/sale or hold the loan and tracking the different cycle of the loans (current, delinquent, modification, foreclosure, bankruptcy, reo and liquidation)
• Designed Data collection/Loading procedure for Agencys((FNMA, GNMA, Freddie) Monthly data point, Intex, Bloomberg, CoreLogic Analytics, Loan performance (Non Agencies Loan level data), Markit(ABX, CMBX, CDX, Primax), Trepp (CMBS data), SolveQuote (Pricing data), FINRA TRACE pricing data, Alexandria (Equity and news), 1010 Level-1 and Level-2 data.
• Database Design, Query Design, writing Stored Procedures/triggers to accommodate all complex business rules, impact analysis, Production support and Day to day Database administration (backup, restore, performance tuning) and database maintenance jobs (dbcc, cleaning & archiving, running profiler, monitoring lock and database activities and audit operational database and alerting the database activities)
• Created Oracle Packages including Triggers, Stored Procedures, Ref cursors and Functions.
• Built a Hive data repository from a raw Agency's dataset stored in HDFS and present the data in relational structure so that users can query the data.

Environment: Windows 2012, Linux, Oracle 12c, SQLServer 2012/2016, MongoDB, Python, Unix Shell scripting, Perl, R

Confidential, New York, NY

Sr. Data Architect

Responsibilities:

• Data Analysis of the current legacy system deal with Confidential and CMBS business
• GAP Analysis of user requirements and current legacy systems
• Database Design, Query Design, writing Stored Procedures/triggers to accommodate all complex business rules, impact analysis and Production support.

Environment: Linux Advance Server and Windows 2003, SQLServer 2008, Sybase, Vertica, Oracle 11G, Perl, Python and Unix Scripting.

Confidential, CT

Senior Front Office Data Architect

Responsibilities:

• Designed and implemented Confidential ’s Market Data Server including data gathering and data mining tools to facilitate all Front Office and Mid Office user to have easy access to current and historical market data.
• This centralized market data warehouse maintained multiple market data point as well as official version of data.
• Project was on budget and on schedule. It makes a significant $$ and time savings to have the reliable market data.
• Designed and implemented CMBS database (Data includes Trepp CMBS data, PPR data and Traders internal data). This database facilitate CMBS investors, traders and researchers a single source of data for maintaining a historical CMBS database
• Designed and implemented Data ware house to hold Residential Mortgage Loan level (Agency and Non-agency) data of multiple sources like Loan performance, McDash, Freddie Mac, Equifax, Case-Shiller and Intex to facilitate researchers/traders easy access to the loan data for trading decision. It covers 40 million US generated loans.
• Database Design, Query Design, writing Stored Procedures/triggers to accommodate all complex business rules, impact analysis and 7 X 24 Database support (Backup, Data Consistency Check, Database restore, Index maintenance, Data Mirroring for High availability, user security maintenance and monitoring batch jobs)

Environment: Linux Advance Server and Windows 2003, SQLServer 2008, Sybase, Sybase IQ, Oracle 11G, Perl, Python and Unix Scripting.

Confidential, NY

Senior Data Architect/Management Consultant

Responsibilities:

• Design Scotia specific contextual data model
• Analyze WSO components (WSO Administrator, WSO Accounting, WSO Compliance, WSO Reporting, WSO Security)
• Reverse engineering WSO data model
• Data grain analysis of Scotia and WSO data model
• Gap analysis between Scotia and WSO data model
• Data Capacity analysis of Scotia’s current and future need
• Outline Recommendations for data requirements and process flow of Scotia’s TRS Loan business
• Database Design, Query Design, writing Stored Procedures/triggers, impact analysis

Environment: Linux Advance Server on Egenera and Windows 2003, ASE 15, SQLServer 2005, C#

Confidential, NY

Senior Data and Application Architect

Responsibilities:

• Designed and replaced the Data Warehouse of Confidential Structured Products Position Management System.
• It covers the business of CDS, ABX, ABS SUBS, ABS FLOW and EDF.
• It replaced the spreadsheet used primarily by the trader to mark positions, calculate analytics and create offerings to customer.
• The database gives the connectivity to the Middle office, Market Risk, Credit Risk and other finance group.
• It gives the traders the ability to widen their business, activity times drops from 3 hours to a min and meet all the regulatory audit requirements.

Senior Data and Application Architect

Confidential

Responsibilities:

• To draw and implement the plan of conversion from ASE 12.5 to ASE 15
• Setup the loan performance database (using Sybase IQ) to analyze all US loans (approx. 850 millions data points of residential loans). It gives the trader and analyst to make their decision promptly and reliably
• Database Design, Query Design, writing Stored Procedures/triggers to accommodate complex business rules, impact analysis

Environment: Linux Advance Server on Egenera, Sybase ASE 15, Sybase IQ, Oracle 10G RAC, C# and MS SQL Server Integrated services.

Confidential, New York, NY

Vice President/Team Lead/Data and Application Architect

Responsibilities:

• Designed the CDO (cash and synthetic) Risk Management Database to analyze pricing and calculate CDO Default Risk using Marginal and Running VOD approach. The probability distribution of VOD is via a Monte-Carlo simulation and Market Risk (Credit spread risk using CS01 and Interest rate risk DV01).
• The database is designed to capture all information to report static as well as provide enough structure and scope to supply pricing models.
• The system captures the information from front office spread sheets, access databases, and trade and market data server of the firm.
• High volume data is stored in an Oracle 10G partitioned database. Metadata concept is used to make it scaleable and easy to use. Also responsible for Database Design, Query Design, writing Stored Procedures/triggers, impact analysis.

Environment: Linux Advance Server on Egenra, Oracle 10G RAC, Sun Enterprise servers, Perl, Unix Scripting, C++, C# and Java/J2EE.