Summary:
Expert of Database Architecture and Datawarehouse development with substantial financial sector experience with a track record of successfully leading multiple projects. This includes Trading Systems, Real-time replication of Exchange data and Financial Feeds in high paced environments. Experience managing full project life cycle from requirements gathering to final implementation and customer training. Focused on Information Technology Strategy, Application and Data Lifecycle Management. Lead projects dealing with business process change, as well as design, development and implementation of information systems with organizations in the Financial Services and Telecommunications industries.

Recent Career Accomplishments:

• 173 projects while at the CBOE. Example projects include:
• CBOE C2 Launch: C2 is second securities exchange operated under CBOE. It employs “market-maker” fee schedule and price/time matching algorithm. During this project, we leveraged the existing CBOE exchange for common data, such as OPRA, Reuters, etc., and build this new exchange using existing standards and procedures established for the CBOE exchange. As a result, the cost was fraction of what it would have been if build from scratch. My team was responsible for creating the following:
• Design interfaces to various systems including CBOE C1
• Setting up the security infrastructure
• Performance tuning of datawarehouse and particular surveillance applications, which involved tuning over nested database links
• Creating multiple schemas with database objects for all Datawarehouse, Surveillance, Membership, Trading and Clearing application
• On a high-profile project, we created the ability for the CBOE to trade FLEX options (customized options) through the CBOEdirect system, a function that could represent as much as 15% of the daily revenue. Previously, trading FLEX options involved employing a service provider at a substantial annual cost. This project eliminated that cost and realized a two year ROI.
• Variance Strips Managed development of a project to trade a new product type called Variance Strips, which was decomposed into a series of S& P500 options. This allowed the CBOE to offer a new product type, very useful for huge institutions and hedge funds. This work spanned across seven different databases: Trading, Product, Consolidated, Datawarehouse, Surveillance, Membership and Clearing. Through efficient design, even with the additional complexity placed on the trading engine, it still achieved a targeted 30,000 orders per second throughput rate.

Core Competencies:

• Enterprise Information and Data Architecture
• Data Warehouse ETL Architecture, Development, Governance and Best Practices
• Data lifecycle management: Load, Access, Quality and Retention.
• Database capacity planning, Performance Tuning and Database Security
• Information System Design, development and implementation
• Industry Sectors: Financial Services, Telecommunications, Technical Consulting.

Technical Skills:

Entity Relational and Dimensional Modeling, Hierarchies, Normalization

Modeling:

ErWin 3.5.1, 4.4.1, 7.2.3, ER Studio, Star and ODS schemas

RDBMS:

Oracle up to 11g, Sybase, PL/SQL, Toad, Dbartisan, Transact SQL

Tools:

SQL*Plus, PL/SQL, SQL*Loader, Quest 5.x, 6.x., TOAD. Performance, Analysis, SQL Optimizer

ETL:

Informatica up to 8.x, PowerCenter, PowerMart, SQL*Loader

Languages:

PL/SQL, Unix/AIX Korn Shell Scripting, Perl.

OS:

UNIX, IBM AIX, MS Windows XP/NT.

Education:
MS Physics, Confidential,University
MS Financial Mathematics, University of Confidential, Chicago, IL

Training/Certification:

• Solaris 2.X System Administration, Sun Systems, Chicago, IL, 1998
• Java Developer Program, DePaul University, Chicago, IL, 1998
• Enterprise DBA Architecture and Administration, Oracle Corporation, Chicago IL, 2000
• Introduction to Perl, Perl Consultancy, Boulder, CO, 2000
• System and Database Administration: Adaptive Server Enterprise 12.0, Sybase Inc, Chicago, IL, 2000
• Performance & Tuning: ASE Query Optimizer, Sybase Inc., Chicago, IL, 2001
• Oracle Database 10g: Performance Tuning, Oracle University, Chicago, IL, 2010

Experience:

Confidential, Chicago IL 2010/02 2011/06
Manager Database Architecture

• Managing a team of 8 Database Architects.
• 173 projects completed.
• Numerous applications to introduce new financial-related surveillance processes. The projects involved changes to about 40 Subject Areas, involved about 500 tables, remote views and materialized views. Different tuning techniques were utilized during these projects, including the following:
• Parallelizing processes
• Using special Partitioning schemes
• Compression
• Oracle hints
• Enhance Security Triggers: To satisfy security for various applications we used a “LOGON” trigger which ensured unix users were properly authorized to login as a specific database user from specific server. This was implemented in such a way that could be maintained at anytime, while before it would have been coordinated with users needing to log off, etc. This improved operational simplicity and made it transparent for business users.
• Provided technical leadership and direction in architecting and designing data models for various systems.
• Provided guidance for Performance tuning and ultimate implementation.
• Responsibilities include: projects planning, monitoring projects execution and providing proper mentoring.
• Conducted weekly planning and evaluation meetings.
• Developed projects strategies.
• Helped with project escalation or communication improvement.
• Responsible for trading system, enterprise wide Datawarehouse, consolidated database, surveillance, membership and product databases.
• Ensure that data model was developed according to relational database design, DDL produced and performance tuned according to database architect standards.
• Supported various financial projects: timely options data submission to OPRA, loading OCC, Reuters, OPRA, Bloomberg and other data sources into Enterprise Data Warehouse.
• Managed development and data modeling of new financial products and services, which included CBOE C2 Exchange, VIX products, SPX options expiring weekly, Permit Bandwidth Allocations.
• Responsible for proposals justification and performed general project management: ensured that project is on schedule, all correct parties involved, issues resolved in timely fashion. Some of the maintenance projects included: Partition Maintenance (utility which maintained partitions in Development and Assurance Environments), Trading Systems Snapshots Setup, Utilities for developers, which allowed disable index partition, truncate partition, perform gathering statistics.
• Managed various phases of migration from Oracle 9i to 10G and from 10G to 11G on multiple database servers.
• Introduced standard procedures for Production Implementations, which included standard way of creating, storing and providing implementations to DBA’s for rollout
• Standardized the process of DDL generation using Erwin and macros
• Created and maintained support schedule for Database Architects on-call. Enforced procedure to create and maintain daily performance reports for production database to ensure proactive system monitoring. Ensured that all Production issues were resolved immediately without impact to the business.
• Was involved in hiring process. Created list of questions to gauge candidates technical, cognitive, communication and personal skills
• Trained new employees to follow existing standards and procedures for Database Architecture Team.

Confidential,Chicago IL 2009/02 2010/02
Database Architect / Financial Database Engineer

• Proposed, developed and implemented the concept of unified snapshots approach to creating, refreshing, analyzing and implementing snapshots in production systems to ensure timely data availability to trading, surveillance and Datawarehouse applications. Performed snapshots installation and refresh jobs across multiple database environments.
• Proposed an idea of Security Trigger and was involved in development, implementation and documentation of the functionality and rollout procedures
• Served as a Database Architect resource for OSI (Options Industry Symbology) project. Working across multiple development teams provided modeling, DDL scripts for various database objects and performance tuning expertise.
• During on-call support efficiently handled data access, database availability and performance issues. Developed various monitoring scripts to facilitate database system monitoring.
• Assisted developers with SQL performance tuning utilizing autotrace, EXPLAIN PLAN, Statspack, AWR and Performance Analysis tools. Using wait analysis and access paths data was able to provide suggestions on using indexing, partitioning, use of hints, analytical functions and other techniques.
• Set up various schemas in development databases.
• Documented standard procedures for using ClearCase by Database Architecture Team.
• Conducted Technical Interviews for hiring candidates

Confidential,Chicago IL 2002/06 2009/02
Software Developer

• Developed Real-Time application to feed Equity Descriptive Data Service. Feed included various financial instruments (Equities, Warrants, Convertible bonds, etc.) Implementation leveraged Informatica, Oracle Stored procedures, triggers and various scripts written in Perl. The system had concepts of master feeds (feeds which create new securities, like Bloomberg ) and enhancing feeds( which just update various attributes like Compliance, Dow Jones, Reuters )
• Developed application using Perl and SCP copy to download various files from external vendors, like (Reuters, Nikkei, Bloomberg, etc…), based on arrival pattern. Files were checked for correct size, completeness and upon passing all checks were loaded into ARRIVALS table. This table was accessed by continuous workflows, which loaded files into database.
• Using Perl developed monitoring system to report data loading problems as well as problems with Source Data.
• Converted Sybase to Oracle database. Rewrote all stored procedures and triggers, and developed scripts for different object creation, redesigned existing database and improved its performance by extensive use of partitioned tables and materialized views.
• Developed and implemented Database Monitoring System for Oracle databases to ensure system reliability and availability. Created tools, which allowed viewing graphic information of the database performance.
• Developed and implemented various data load programs using Informatica and Perl. These programs loaded RIC information, yield curves, partner/account, corporate actions, various financial instruments and other financial data. Monitoring scripts were developed and implemented which ensured data integrity and accuracy.
• Created various database objects as well as modified existing ones. Was constantly involved in stored procedures and triggers development.
• Developed various monitoring scripts to ensure data accuracy on disaster recovery server as well as data consistency between replicated servers.
• Implemented various data checks to flag any data problems or inconsistencies and report to the business in a timely fashion.
• Provided ongoing data support. Performed SQL tuning for API.
• Created detailed documentation and projects release notes.

Confidential,Chicago IL 2000/03 2002/01
Database Administrator

• Designed, developed and implemented Enterprise Real Time P& L Monitor, which provided up-to minute P& L information for different investment and trading instruments. This tool led to huge return from trading.
• Developed and implemented Perl module, which allowed loading of various type of files into database.
• Designed and developed logical data models for various trading tools and converted them into physical database designs using ERWIN.
• Created and maintained repository of entity relational diagrams for various schemas using Model Mart.
• Converted C++ program for calculating debt service information into Perl script.
• Created jobs to load FAME database information into SYBASE database.
• Performed SQL portion tuning for different applications.
• Developed, designed and implemented stored procedures, functions and triggers to maintain and enforce various business rules.
• Designed, developed and automated jobs, which loaded data from different vendors, such as NIKKEI, S& P, Morgan Stanley, LPC, DTC etc.
• Designed E/R models and performed physical implementation for different financial and trading tools.
• Created multiple reports addressing different business needs.
• Developed various routine DBA and DA tasks, created different monitoring and archiving utilities using Perl and Sybase.

Confidential,Chicago IL 1998/01 2000/03
Data Administrator/Database Administrator

• Provided ongoing support for sales automation tools to ensure data availability for reducing competitive losses providing results of customer Winback and retention programs. Designed, developed and supported data load process for updating Account Assignment, Total Billed Revenue and Total Combined Revenue databases using Korn Shell Scripting language.
• Improved performance, availability, and reliability of production GBS sales and compensation applications and data load processes to supply GBS sales force with better means to increase the effectiveness of sales channels to sell GBS products and services. Improved data load stability and increase reliability through proactive problem analysis and on-time auditing features. Designed, developed and implemented automated process to load data into CORE corporate database.
• Developed and converted logical data models for Total Combined Revenue and Account Assignment application and converted them into physical design using ERWIN.
• Created various Oracle Objects.
• Performed various database tasks (Oracle installations, backup /recovery, administering user privileges and roles, database security, auditing and some other database activity using Oracle Enterprise Manager). Provided less expensive effective database solutions by migrating key data load processes to Windows NT platform. Performed data modeling and created backup procedures. Developed and implemented schema backup on SAM and full backups on various Windows NT servers.
• Developed and maintained CPNI complimentary system that provides data blocking compliant to FCC regulations.
• Worked as a subject matter expert for ad-hoc team assisting in providing information in accurate and timely fashion.

Confidential,Chicago IL 1996/11 1997/12
Technical Consultant

• Participated in logical design and conversion it to physical, estimation of system requirements, development and implementation of different parts of ODS system for LMPS Motorola.
• Performed Oracle Object Creation (tables, views, stored procedures, etc.)
• Assisted in converting of corporate application from TeraData to the Client-Server environment (AIX, Oracle).
• Enhanced data load processes with functionality improving effectiveness of sales, using PL/SQL, Dynamic PL/SQL and Pro*C
• Developed reporting solutions for Sales group using SQL*PLUS, functions, HTML, Bourne & Korn Shell scripts.
• Developed automated process with logging and paging capabilities.
• Created various management, forecasting and user reports using SQL* PLUS
• and PL/SQL accessible through the Intranet.

Confidential,Lincolnwood IL 1995/11 1996/11
Consultant

• Developed, designed and implemented Order Processing System for a surgical supplies distribution company involving database design, implementation of user interfaces, archiving and retrieval features.
• Analyzed user requirements, designed and developed software
• Personally involved in client server application partitioning and design of fully normalized logical model according to company’s business process
• Created applications for Sales Marketing Department (ORACLE7 Database)
• Used ORACLE Forms 4.5 to develop user interfaces for invoicing modules
• Converted databrowsing utilities from PowerBuilder 4.0 to ORACLE Forms 4.5
• System was implemented using server based ORACLE7 database
• Utilized ORACLE Reports 2.5 to create various management and user reports
• Analyzed, designed and tested Customer / Order Invoice System