SUMMARY:

• Over 25 years experience working in fast - paced start up and software environments demanding strong organizational, analytical and time management skills as well as exceptional development and problem solving skills.
• Extensive background in data architecture design, data management, project management, data migration and integration with emphasis on both high end OLTP and Business Intelligence solutions.
• Special skills in efficient and effective data storage designs (data warehouses, data marts, operational data stores, and database platforms) with data quality (profiling and cleansing considerations.
• Quickly grasps complex concepts, analyzes and interprets business concepts and ideas into strategy.
• Over 20 years of CASE tools development technology and success with implementation of data management standards, company standards, and data/business process analysis.

PROFESSIONAL EXPERIENCE:

Greenplum Data Architect

Confidential

Responsibilities:

• Greenplum 4.2 GPFDIST readable and writable external tables
• Developed New Greenplum Functions
• Optimized existing Greenplum Functions
• Developed Data Models using Toad Data Modeler

Greenplum Data Architect

Confidential

Responsibilities:

• Conducted a Greenplum Architecture Review and optimized Greenplum ELT functions called by
• Pentaho.Also optimized teh teh dimensional schema using Toad Data Modeler.

Data Warehouse Architect

Confidential

Responsibilities:

• Developed Greenplum 4.2 GPFDIST readable and writable external tables
• Developed logical and physical Greenplum Dimensional Data Warehouse Design
• Developed Several Complex Data transformation and loading Greenplum Functions

Data Warehouse Developer

Confidential

Responsibilities:

• Developed database code using SQL Server 2008 and Stored Procedures
• Developed Date Range Partition Design and Scripts For SQL Server Data Source
• Developed Real Time Summary Tables using SQL Server Materialized Views And Indexes

Data Architect ETL Developer

Confidential

Responsibilities:

• Developed database code using PostgreSQL 9.2 and PL/pgSQL.
• Created Stored Procedures and Functions
• Developed over 50 reports using Jasper Reports

Database Developer/Architect

Confidential

Responsibilities:

• Developed distributed database code using PL/Proxy, PostgreSQL 9.0 and PL/pgSQL.
• Created Stored Procedures and Functions deployed on 32 PostgreSQL databases using Londiste Replication and executing thousands of transactions per second.
• Some of teh tools used include PostgreSQL 9.0, PL/pgSQL, PL/Proxy and Londiste.

Database Architect/ETL Developer

Confidential

Responsibilities:

• Developed ETL code using Oracle 10.2.3, PL/SQL stored procedures and functions to filter and migrate an entire operating companies Data Warehouse. Over 200 tables and 500 gigabytes of data were migrated including Partitioned Tables as large as 50 Gigabytes.
• Created Stored Procedures and Functions as well SQL Scripts to filter and load this Data Warehouse.
• Some of teh tools used include Oracle 10.2.3, Toad, and Erwin

Data Architect/ETL Developer

Confidential

Responsibilities:

• Developed ETL code using Java, Talend and MySQL stored procedures to track page views for a large web company. Teh delivered code was very fast and scalable.
• Creating Data models, ETL, stored procedures, and technical specifications and documentation. Creating conceptual, logical, and physical models for IT and business users.
• Some of teh tools used include Erwin, Talend, MySQL 5.1, Excel, and Visio.

Data Architect/Engineer

Confidential

Responsibilities:

• Extended teh Markdown Data Model using ER/Studio, developed DB2 functions and stored procedures. I also converted DB2 data and stored procedures to Enterprise DB and Postgres and ran part of teh Markdown application against teh converted databases.
• Creation of Enterprise Data Warehouse reports using DB2 9.5 and DB2 Stored Procedures.
• Data Architecture technical vision was geared towards Java Development and was to support Data Distribution and Data Migration to various areas and platforms including Linux, over 160 DB2 Databases, a web farm and various data marts. All systems were classified as high availability and 24/7 support.
• Some of teh tools used include Oracle Admin tools, ER Studio, Word, Toad SQL developer for DB2, Excel, Visio and Oracle 10.2.3.
• Developing high level and detail design documents in an agile fast 1 month release cycle.

Sr. Data Warehouse Architect

Confidential

Responsibilities:

• Developed ETL Facts and Dimension transformation and loading code using PL/SQL packages. I extended an already existing star schema Data Warehouse. I developed logical and physical database design for teh Bulk Vehicles Vertical using ER/Studio. I designed an Oracle function and procedure generator which I used to generate code for teh Avis Bulk Vehicle Vertical. Developed automated code generator dat dynamically generates a pin trigger for each instance in teh RAC cluster and pins all application procedures, functions and packages. Developed log parsing tracking application using Perl and MySQL.
• Creation of Enterprise Data Warehouse reports using Oracle 10.2.3 and Oracle Stored Procedures.
• Some of teh tools used include Oracle Admin tools, ER Studio, Oracle Materialized Views, Toad SQL developer for Oracle, Oracle RAC, Excel, Visio and Oracle 10.2.3.

Sr. Data Warehouse Architect

Confidential

Responsibilities:

• I developed all teh ETL transformation code to build an Oracle Warehouse Builder analytical Data Warehouse in PL/SQL. Defined teh transformation rules, aggregations and cleaning rules as well. Used Erwin to develop teh logical and physical Data Model for teh JMEWS Application which tracked injured soldiers in Iraq in real-time. I played a key role in architecting and delivering a multi-tier Solaris EMC CX300 SAN solution. This solution includes built in fail-over for teh database server, map server and application server. Advanced performance features included multi-path I/O, asynchronous I/O, raw partitions and database code pinning.
• Creation of Enterprise Data Warehouse reports using Oracle 10.2.3 and OWB.
• Duties and responsibilities included developing data models and Leading teh design and development of Databases, Data marts, Data warehouses and ODS data storage areas.
• Some of teh tools used include Oracle Admin tools, Erwin, Word, Toad SQL developer for Oracle, OWB, Visio and Oracle 10.2.3.

Sr. Database Consultant/Architect

Confidential

Responsibilities:

• Worked as a DBA and Database consultant/Data Modeler/Architect using Erwin to develop conceptual, logical, and business process models.
• Designed and developed Java Stored Procedures to do XML Parsing and send XML Messages using Oracle Advanced Queuing. This system supports XML Document exchange of diverse documents up to 300K in size.
• All packages are highly optimized and take advantage of bulk operations, array processing and SAX Parsing. This system exchanges XML Documents throughout Asia, Europe and Latin America.
• I played a key role in reverse engineering and cleaning up teh logical and physical Data Model. Developed key Materialized Views, Stored Packages and Data clustering which dramatically improved customer performance of teh ServSmart Service Contract Application Software.
• Developed complex Materialized Views dat provide near real time analytics.
• Some of teh tools used include Oracle 9.1.6, Erwin, Oracle AQ, Oracle XML and Materialized Views.

Founding Database Architect

Confidential

Responsibilities:

• I designed and implemented teh Confidential 1.0 Data Architecture for teh Airline, Hotel and Car Rental verticals. I implemented a stored procedure Data Service API for key airline search queries. I designed teh Confidential 2.0 Data Architecture using JDO’s, Object Caching, Oracle Advanced Queuing and Oracle Object Types. I managed a team of five Java Engineers. Teh application uses a stored Java API for all application finder methods. Architected coded and tested a highly scalable Oracle AQ Application which tracks partner referral purchases. This application is capable of propagating 200 transactions per second per queue.
• Responsibilities included developing data models in Erwin, developing complex stored procedures returning ref cursors and developing O/R Mapping code in Toplink.
• Designed, coded and delivered a reporting solution using Oracle AQ, Crystal reports and Oracle PL/SQL.
• Some of teh tools used included Erwin, Oracle tools, Crystal Reports, Visio, Word, Excel and Microsoft Project.

Founding Database Architect

Confidential

Responsibilities:

• Designed, developed and helped implement Confidential Web site. This site provides free MP3 streaming for mostly alternative music DJ's. Teh first release of teh site was developed in less than two months. I performed all of teh logical and physical database design as well as developing teh music directory. Teh first release uses Oracle 8, Perl DBI and Apache. This release can support up to 10,000 concurrent listeners.
• Database logical and physical design.
• Some of teh tools used included Erwin, Perl DBI, Java, PL/SQL, Word and Excel.

Founding Database Architect

Confidential

Responsibilities:

• I researched and designed teh logical and physical data architecture for Confidential . I was primarily responsible for teh use of Oracle 8, Tuxedo and Oracle Parallel Server. These technologies provided unparalleled scalability and availability. These component choices were very rare and radical for teh Internet space. I also was fully responsible for all of teh logical and physical database design. Teh data architecture uses both vertical and horizontal data partitioning for scalability. Data dependent routing of Tuxedo/PRO*C transactions is used to increase teh performance of Oracle Parallel Server. Case tools were used to develop teh data model. Referential integrity constraints are enforced within each Oracle Schema. In addition to these duties, I designed and coded teh search backend for Confidential . Tuxedo, Verity and C were used to develop teh search service. Confidential is processing 3 billion messages per month, which represents about 2 percent of all email traffic on teh Internet.
• Developed Verity/Tuxedo C search code.
• Installed and configured Oracle Parallel Server version 8.0 on a 2 node Sun Cluster.
• Some of teh tools used included Erwin, Verity, Oracle Parallel Server, Tuxedo, and C.

Oracle Applications Architect

Confidential

Responsibilities:

• I assisted multiple fortune 500 companies with Oracle 10.7 Applications architecture issues. These customers are running Oracle Applications with concurrent users on multiple domain SUN E10000’s.
• I conducted application design reviews. I participated in teh development of an Oracle 11- benchmark kit for teh Java Enabled Oracle Applications for teh web. I wrote two white papers. I worked on developing a data mining benchmark for Oracle Manufacturing.
• I have extensive experience with developing and configuring Oracle 10.7 and Oracle 11 code for all of teh major financial and manufacturing models. I also have experience configuring concurrent manager processes.
• Conducted Oracle Applications Architect reviews for customers in Singapore and South Korea.
• Some of teh tools used were Oracle Applications, Sun Solaris and Power Point.