SUMMARY:

• Enterprise Solutions Developer/Architect with 20+ years experience
• Expert level Database skills in Oracle and Microsoft SQL Server
• Significant experience with mySQL, Sybase, Informix, and Postgres
• Expert level skills with Data Warehousing technologies including Multi Dimensional Modeling and analysis against multi - dimensional models (MOLAP/ROLAP).
• Expert level skills in Extract-Transform-Load (ETL) processing
• Expert level experience with Oracle Standby (DataGuard) and other Oracle High Availability options
• Expert level skills supporting Microsoft SQL Server mirroring high availability
• Expert level programming skills in Java, C, Perl, and Unix shell
• Expert level Unix skills
• Expert level Data Modeling skills
• Expert level SQL skills
• Expert level skills with Oracle Application Express (HTMLDB) web development environment
• Expert level skills in TOPLink for Java object relational persistence framework
• Significant experience with Microsoft SSIS ETL development environment
• Significant experience with Open Source ETL development tools (Pentaho, Talend, etc)
• Significant experience with Microsoft SQL Server Always On Availability Group environments
• Significant experience with handling Security used in the financial trading markets
• Significant software application design experience on a variety of platforms including Unix, Windows, and Java
• Fluent in several full life cycle software development methodologies including UML and Waterfall
• Significant experience with BEA WebLogic application server and Tomcat JSP container
• Significant Server Side web application development experience (J2EE)
• Familiar with XML programming and DTD modeling
• Familiar with Microsoft SSRS and SSAS

TECHNICAL SKILLS:

Databases: - Oracle version 7.3 - 11G, Microsoft SQL Server 7.0-2012, mySQL version 5, Postgres version 7-8, Informix version 4.1 - 7.2, Interbase versions 3-4, Sybase version 11-12.5.3, mySQL, Versant ODBMS, Microsoft Access

Hardware: - HP 9000, Sun Sparc, IBM RS6000, Confidential VME 68000/88000, Compaq 5500

Software/Tools: - HTML-DB(Application Express), Eclipse, Oracle Enterprise Manager, StarTeam, Together, Clearcase, Toplink, PVCS, SVN, CVS, ErWin, TOAD, Squirrel, DB Artisan, Rational Rose, Net Dynamics, Visibroker, BEA WebLogic, Alexandria Tape Backup Management, ODBC, Builder Xcessory, Purify/Quantify, Roguewave class libraries, Object Center, Cadre Teamwork, Frame Maker, Think C, Think Pascal, Microsoft Office

Programming Languages: - Java, Perl, C, C++, SQL, PL/SQL, HTML, Javascript, Python, Oracle OCI, Informix ESQL/C, Visual Basic, X Windows/Motif, UNIX Shell, awk, Informix 4GL, Pascal, Prolog.

Operating Systems/Environments: - Solaris, HP/UX, Linux, Microsoft Windows XP/2000/NT/95/3.1, DOS, Apple Macintosh, SNMP, Lantastic NOS

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Architect/Developer for custom research database for the Quant Trading group. Developed interfaces to Factset, Bloomberg, and other various financial data providers to acquire terms and conditions, pricing and other market data items. Developed processes to link the “Security Master” with data purchased from data vendors and broker provided research. Developed interfaces to efficiently extract and transform the data to suit the Quant research environment (Matlab). Equity Universe contains 20,000+ securities with over 25 years of history. Securities mapped to various vendor datasets ( Confidential, Confidential, Gradient, Confidential, Confidential, Confidential Confidential, Confidential, etc). The system involves over 80 database load processes that were implemented. Built custom monitoring system to monitor and manage the system.
• The database environment is a 1.3TB Oracle 11G running on Windows. Full RMAN implementation in place using backupset and datafile copies. Rsync file synchronization is in place to transport backup files to network drives in an efficient manner. Significant development done using Oracle Application Express to allow visualization and maintenance of the data. Extensive toolset developed to ensure data quality and analysis.
• While at Confidential /O’Connor also served as Architect/Developer for various Trading teams to assist in various data acquisition and analysis activities including a PNL reporting application and development of an Index Composition time series database. The PNL reporting application is built on Sybase with custom web front end constructed with the Tapestry java framework. The Index Composition database is also built on Sybase with a JDBC interface that extracts data from an Oracle source that is managed by another organization within Confidential .

Confidential

Responsibilities:

• Working in a remote database administration role to support Vibes production SQL Server database environment. The Vibes database environment is over 1 TB in size. The backup implementation is based on the SQL Litespeed product. SQL Server mirroring is in place to support high availability. Constructed ETL process for Operational Data Store to support Vibes Data Warehousing initiative. Monitoring the environment daily, making performance recommendations, and mentoring development team on best practices for database development.
• Working with Vibes to upgrade the production environment to SQL Server 2012 (from 2005). Migration to include Always On Availability Group setup. Setting up log shipping on databases from in order to cutover with minimal downtime.
• To ensure coverage of the Vibes environment brought in on demand staff to assist in day to day management. Managing the day to day work and direction and of this staff.

Confidential

Responsibilities:

• Supporting of Calumet’s eCommerce integration between hosted eCommerce web and internal ERP systems. Calumet has presence in four countries with separate each ERP systems for each country division. The integration has been implemented using Microsoft SSIS with several SSIS plugin’s to support Secure FTP, XML transformations, and file transformations. In addition to supporting Calumet’s eCommerce platform also providing operational support for all of Calumet’s internal SQL Server databases.

Confidential

Responsibilities:

• Working in a remote database administration role to support the Confidential production Oracle database environment. Confidential was a previous client and resumed support after losing their full time DBA. The Firm 58 database environment is over 8 TB in size. The backup implementation is based on Oracle RMAN. Deployed proprietary ORAMON scripting suite to monitor the Confidential Oracle instances. Monitoring the environment daily, making performance recommendations, and mentoring development team on best practices for database development.
• To ensure coverage of the Confidential environment brought in on demand staff to assist in day to day management. Managing the day to day work and direction and of this staff.

Confidential

Responsibilities:

• Working in a remote database administration role to support Oracle 11G databases. Regularly applying Oracle Critical Patch updates. Implemented “poor mans” warm standby database using automated export import between the primary and warm standby machines. Completed several IT initiative projects to assist in consolidation of the RCM environment including Intranet migration to IIS, Big Brother roll out, database migrations, database retirements, and CVS repository migrations.
• Also assisting Confidential with technology needs for companies that they have private equity investments. Implemented offsite backups to JungleDisk/Rackspace for Oracle database datapump exports.

Confidential

Responsibilities:

• Worked in a remote database administration role to support SQL Server 2008 database environment for an end client of Confidential . Tasks included installing SQL Server, applying updates, setting up backups for SQL Server and Analysis Server databases, performance tuning, and deployment management for SSIS and SSAS packages. Mentored Sagence staff on Data Modeling best practices.
• Also currently supporting daily prime broker upload interfaces to back up RCM staff.

Confidential

Responsibilities:

• Worked in remote database administration role to support Oracle database production databases. Migrated database backups from SQL Backtrack to RMAN resulting in significant license savings for the company. Supported security access changes to Oracle databases. Provided extensive performance tuning and analysis for high throughput environment using Oracle AWR.
• To ensure coverage of the Confidential environment brought in on demand staff to assist in day to day management. Managing the day to day work and direction and of staff.

Confidential

Responsibilities:

• Implemented Enterprise Backup for production environment on Oracle 10G platform. Provided templates for Confidential to use for future databases that move into production. Mentored Confidential staff on RMAN recovery techniques. Documented numerous recovery scenarios for Firm 58 to work from.
• In July 2008 Firm 58 decided to hire a full time DBA to support the environment. Assisted Firm 58 in the interview process to help them make a sound choice in hiring their new DBA.

Confidential

Responsibilities:

• Worked in remote support and development role to support Confidential .com infrastructure running on Amazon EC2 infrastructure and ElasticPath eCommerce engine. The Confidential .com database used mySQL technology with mySQL replication setup for high availability. In this environment the Rightscale cloud infrastructure was also leveraged to support the environment.

Confidential

Responsibilities:

• Implemented Enterprise Backup for production system on SQL Server 2005 platform
• Performed analysis and tuning exercise for the database adding indexes and modifying stored procedures as needed to achieve acceptable performance.
• Constructed various rollup structures for reporting purposes and developed processes to manage the rollups.
• Mentored application developers on proper database development techniques.

Confidential

Responsibilities:

• Reviewed object relational mapping implementation built with Oracle TOPLink. Submitted recommendations and documented the current state of the object mappings using a template that could be used as the application evolves.

Confidential

Responsibilities:

• Implemented RMAN and database exports in Oracle 10G environments. Oracle 10G and RMAN were new to the organization and outside help was needed in order to get Data Warehouse environments backed up. Laidlaw is using the SQL Backtrack product to backup Oracle 9i (and earlier) versions, however they und that they were not licensed for the 10G version of SQL backtrack and decided on a long term strategy to use RMAN which is provided free with all versions that they are running. Also provided general Oracle infrastructure/architecture advice as needed.

Confidential

Responsibilities:

• Worked in remote support role for all Oracle environments with the purpose of ensuring overall health of the database systems and provide domain consulting expertise due to intimate familiarity with the Confidential systems. Databases are monitored by ORAMON scripts and EM Grid control and alerts are monitored via Blackberry. Also continued development of various database web based interfaces to streamline internal processing being done by operations and support personal.

Confidential

Responsibilities:

• Lead Data Modeler/Data Architect for the firm. Developed Data models for a variety of application types including OLTP and Data Warehouse type applications, (i.e. traditional ER schemas as well as multi-dimensional star schema topologies). Responsible for application of database schema life cycle changes on all databases. Acted as SQL query guru for the organization for novice and experienced developers.
• Constructed data loading platform for Bloomberg back office data (terms and conditions for financial instruments as well as corporate actions) into “Security Master” database. Components included functionality wrapper for SQL-Loader, staging/target database tables, functionality wrapper for Bloomberg Transformer software, and transform load logic built with PL/SQL packages. Supported Development, Test, QA, and Staging database environments complete with data synchronization from production environment.
• Responsible for high availability operational Oracle environment used to support trading and PNL systems. Implemented Standby warm failover (.i.e. Dataguard) for all production Oracle instances. The environment also includes a full RMAN backup implementation with backups being performed on Standby servers to reduce load on production instances.
• Constructed and maintained mid sized data warehouse with various market data time series data elements (prices, volume, market capitalization, betas, etc). Utilized Oracle partitioning address scalability to ease maintenance on very large tables.
• Constructed various database maintenance and monitoring tools to both monitor the health of the database systems and keep systems running at high performance levels. For details see: http://www.serverside-ts.com/Docs/oramon.html.
• Deployed Oracle Enterprise Manager 10G Grid Control to monitor and manage all Oracle databases in the environment.
• Constructed web applications used to maintain terms and conditions for security data. These applications are used by the Data Content group to maintain “Security Master” and provide various reporting functions. Applications were constructed using a combination of Oracle HTML-DB and a reporting framework using Apache Tomcat with JSP tag libraries.
• Constructed Accounting interface from Murex trading system into Solomon Accounting system. This interface transforms a data extract from Murex into the format required by the Accounting system. The interface includes a full workflow user interface (using Oracle HTML-DB) so that the operator has full control and visibility into the process.
• Constructed audit processing to verify data quality within trading and PNL. Examples include verifying that splits and dividends were being applied to positions held in the PNL system.
• Wrote various utilities in java to publish data to java based PNL system via a java based API.
• Designed messaging architecture utilizing Oracle Advanced Queuing to enable communication between data loading processes and J2EE application server. Load processes (written in Perl) were disconnected from Java based application servers. Advanced Queuing allowed for us to publish various security change type events to queues that the J2EE application servers could listen for as a trigger to update their local cache.

Server Side Technology Solutions (Independent Consultant)

Confidential

Responsibilities:

• Designed and developed multi dimensional database model, loading processes, and operations monitoring for historical equity and bond volatility/risk data generated by the organizations’ proprietary financial models. Development accomplished with Oracle 9i and the data model maintained with ErWin. Developed interfaces to support daily loads from flat files and also developed an Oracle package API that researchers could call direct from their financial model processes. Gathered statistics on all loads so that metrics of data volumes could be assessed over time. Used Oracle Materialized Views to summarize data distributions and assess data quality over time. Developed operations monitoring modules to gather data from statistical metrics and materialized views and display data to JSP pages using Apache Tomcat and PopCharts graphing package. Developed Auditing processes to access data quality at random for specific stock symbols. Developed indexing strategies to match user access patterns for time series data. Utilized Oracle compressed indexing to save several GB of storage and significantly enhance index scan performance. Utilized Oracle Analytic query SQL extensions for analytics involving calculations that occur between rows within the result set.
• Developed data model and associated loading processes to capture institution position data from Edgar Online 13F holding reports. Complemented EDGAR data with instrument details from Bloomberg data source for the purposes of linking this data model with the historical equity and bond model mentioned above. Also processed raw 13F reports from a secondary source to add information not included with Edgar Online data product offering.
• Developed data model and associated load processes that interfaced with the Profit and Loss operational system. This model was also integrated into the overall enterprise model and allows management to view profit and loss information at the position level along side associated risk metrics for the positions.
• Migrated several Sybase databases to Oracle 9i to support management in their effort to consolidate and upgrade the data platform for existing applications. Performance improvements of up to 10 times were observed.
• Developed Oracle developer tip seminars to assist the organization in transition to Oracle (from Sybase).

Server Side Technology Solutions (continued)

Confidential

Responsibilities:

• Worked on migration for catalog data provider for Confidential website ( http://www. Confidential .com). Designed and implemented the entire conversion process. Constructed alternate Oracle environment to process new catalog data. Implemented database schema modifications required by data provider change.
• Performed analysis of ATG Dynamo database schema to identify tables and columns to be involved in the conversion. Modified PL/SQL stored procedures for catalog load to accommodate data changes resulting from provider switch. Wrote PL/SQL conversion routines to convert product and sku id's from old provider to new. Also acted as operational DBA during this time period for the site. Other responsibilities included backup and recovery of Staging and Production databases, performance tuning, application SQL analysis, and enhancements to operational data store extracts, design and implementation of all database schema changes, and migration of schema changes throughout the environments.

Principal

Confidential, Chicago, IL

Responsibilities:

• Worked in hands on technology leadership role in server side technologies including databases, application servers, and operating systems. Participated in more than a ten projects while at DiamondCluster. Full time engagements are outlined below. Most of the implementations involved deployment to a third party hosting service. In these cases, acted as interface to hosting company in providing specifications for the hardware and software that needed to be deployed.

Confidential

Responsibilities:

• Worked as Oracle DBA/Data Architect for Confidential .com. Primary responsibility involved design and implementation of Catalog load process. Confidential (For Your Entertainment) is a retail web site which offers 400,000 entertainment products with 600,000 associated skus. Wrote PL/SQL to process data feeds for 50+ tables into ATG Dynamo commerce server data model with TWEC specific extensions. Data was loaded into a staging area before being transferred to the ATG catalog. ATG supports the concept of multiple versions of a catalog so updates can be applied to one version while the other is online. Data updates are applied daily from a master product catalog. The process was completely automated with the use of UNIX shell scripting and various UNIX utilities to perform actions such as file transfer, unzip, md5 integrity check, sql loader invocation, process logging, alert notification, and stored procedure invocation.
• The Confidential database is a high availability Oracle environment that leverages Veritas clustering technology. Worked with Veritas clustering experts so that Oracle database could failover seamlessly in the event of a machine failure.

Confidential

Responsibilities:

• Participated as a Technical Architect in an IT Strategy effort. The strategy project identified several initiatives, two of which were a Data Warehouse and Enterprise Application Integration design. Gathered requirements from senior and middle management for an enterprise wide data warehouse. Drafted a multi-dimensional enterprise logical data model for domestic portion of EGL's business and wrote a Request for Proposal to be sent to Data Warehouse implementation firms. Designed an Enterprise Application Integration (EAI) model to be used to distribute data throughout the enterprise (including the data warehouse). Applications would distribute data using JMS middleware infrastructure and publish/subscribe. Adapters would be written for legacy applications to interface with the JMS infrastructure. Specifications would be developed for all new applications to adhere to the new EAI strategy. workzone360.com/Square D
• Designed application data model and performed rollout into physical environments. Constructed the build and deployment processes for and EJB application using Weblogic. The application deployed several J2EE components including session beans, entity beans, servlets, and Java Server Pages. Developed several partner interfaces to enable single sign on and seamless data transfer to partner sites. Integrations were developed using HTTP, XML, and java security. Acted in leadership role mentoring application developers in merging object and data models with the TOPLink Object-Relational persistence framework.
• Phase 2 of the project involved extending the Calico Market Maker commerce engine. Our team added modules for Accounting, Returns, Line of Credit, and Account Adjustments. Extensions were written using Calico's java extensions framework. Integration with internal and external modules was accomplished using the Java Message Service (JMS) API. These extensions were rolled into the common code base of Market Maker and will be included in the base product in a coming release.
• After the application was deployed our team worked with Square D operations to examine ways to leverage the architecture within their internal e-commerce applications. Also evaluated several other e-commerce products and frameworks in coming up with a recommendation for their future state architecture.

Confidential

Responsibilities:

• Designed application data model and performed rollout into physical environments. Created and maintained Microsoft SQL Server 7.0 development, test, staging and production environments. Developed a data loading program in Perl to import company financial reporting information into the target application database. Also developed the administration interface for DistressDebt that allows Web site administrators to maintain financial information in the database after it has been loaded. The administration interface was developed with ASP with a backend COM object (ASP-DB). theSauce.com
• Designed application data model performed rollout into the physical high availability environments. Created and maintained Oracle 8i development, test, staging and production environments. The production environment included an Oracle Standby (DataGuard) environment for high availability. Also worked with application developers to merge the object and data models with the TOPLink Object-Relational persistence framework. Developed and deployed utilities to monitor critical aspects of Oracle including the operation of the Standby (DataGuard) database. Also developed data loading programs to populate the database with food product catalog information.

Senior Database Administrator

Confidential, Chicago, IL.

Responsibilities:

• Responsibilities involved administering high availability databases used for online banking application ” Confidential Direct”, workflow applications, intranet applications, and derivative trading applications. Tasks include Oracle/Interbase software installation and setup, data modeling, backup and recovery, contingency planning and implementation, providing assistance to application developers, JDBC driver installation and support, and development of database monitoring scripts for Oracle and Sybase. The scripts (ORAMON) monitor critical aspects of Oracle and have built in notification capabilities in the event of any detected problem. Also supporting Object Relational Mapping Tool “Toplink”. Also constructed and maintained Oracle Standby (DataGuard) environment for Confidential Direct Database.

Confidential

Responsibilities:

• While at Confidential worked independently to begin fostering web development skills. Worked on a small business website (equipmentconnections.com). Gathered the requirements for the site, found a web host, wrote application with a very limited set of tools, budget, and time to implement the site. The site contains administrator functionality to maintain its inventory so that no HTML knowledge is required (a requirement). Wrote nightly backup scripts that transfer files to an independent machine nightly. The site was created using Perl, DBI, mySQL, and HTML.

Senior Software Engineer

Confidential, Chicago, IL

Responsibilities:

• Member of database performance engineering team. Projects involved database tuning as well as performance improvements to database runtime libraries which focused on improving generated SQL, loading database description information into shared memory, gathering database distribution information, and a construction of a database central process to service database operations from multiple program sources. Served as liaison in corporate partner relationship with Informix Software. Also created and provided instruction for an SQL class for application developers along with developing intranet applications to support the class (online quiz and information resources). Also involved designing transaction processing enhancements to the BPCS application.

Senior Software Engineer

Confidential, Schaumburg, IL

Responsibilities:

• Developed custom in house software for field technicians. Applications were developed in Informix 4GL and C-ISAM with an Informix SE engine (version 2.1). Projects included maintenance of an existing problem ticket application and development of an alarm receptor (via modem) that serviced alarms from field equipment, logged to a database, and paged responsible personnel. Also worked in project organization in April ‘92 to enhance custom report generator for SIMS II product. Worked from August ‘92 January ‘96 on Configuration Management software for iDEN (customer Nextel) system. “Genesis” software is used to install/maintain a digital communication system capable of voice, data, paging, and short message service.
• Worked on all aspects of this application including user interface, business logic, database programming, and information packaging for transfer to cell site. Also performed as Database Administrator where tasks included performance tuning, system sizing, and repartitioning of data for several systems.