SUMMARY

• 20+ years experience in systems integration designing and implementing e-commerce, OLTP, data warehouse and datamart solutions for a variety of clients. Strong SQL development, query and database tuning skills. Very strong communication skills with ability to work with a team or independently.

TECHNICAL SKILLS

• DATABASES: Netezza TwinFin, Striper, Mako
• Redshift on AWS: Oracle 11g, 10g, 9i, 8.x/7 NT & UNIX
• Sybase System: 7.3/10/11/21.5 on UNIX Microsoft SQL Server 6.5, 7.0, 2000 Informix online and XPS on UNIX.
• DESIGN AND DEVELOPMENT TOOLS: SQLPlus, SQLDeveloper, ERWin, PowerDesigner, ERStudio, ANT, Emacs for windows, Cygwin, Eclipse, TOAD, Beanshell, Junit, UTPLSQL
• PROGRAMMING LANGUAGES: SQL, PL/SQL, Java, XML, KSH, CSH
• OPERATING SYSTEMS: Windows NT/2000, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Member of Database Engineering Team

Responsibilities:

• Led database development effort to migrate from Netezza to Redshift AWS.
• Authored Erwin FET for deploying Netezza and Redshift DDL from the same model.
• Architected the birth of Netezza for the enterprise from 2013 until present.
• Championed Kimball’s teaching as we built the 2nd generation Data Warehouse platform for SSgA.
• Designed the centralized shared Database of Common Enterprise Dimensions.
• Designed the “Risk Datamart”
• This design included Datamart specific Dimensions while also keying to the Common dimensions.
• Taught Kimball to multiple developers.
• Designed all naming standards for databases, objects, privileges across the appliance.
• Coded centralized package of scripts for Deployment and Account Administration (21 Version releases)
• Managed 3 developers supporting the enterprise Netezza Platform.
• Table and API Design, Code Reviews, code mentoring
• Refactoring estimates and implementations.
• Tracking to estimates.
• Supported all projects as they came on-board to Netezza.
• Oversaw migrations from Twin Fin to Striper and finally to Makos.
• Championed Team Streams for our Source Control work within Clearcase.
• Migrated DBE Team from Clearcase to Bitbucket.
• Migrated major project from Netezza to AWS Redshift.
• Designed first phase of TradePortal 2.0 on Oracle.
• Deep dive performance analysis and tuning of the code from the project team.
• Consistently was available for questions, debugging and coding which involved our OR Mapping layer, called JPUB as well as the connection pooling and JBOSS application server. I was sort of the team java guy, although, java was not something I had coded in for years before joining the team.
• As a DBE member, was involved in many design discussions, performance tuning exercises and production emergency calls.

Confidential

Principal IT Developer

Responsibilities:

• Championed the Kimball methodology of data warehouse design for all our team’s designs.
• Designed the Labor Star schema, which was all timesheet data dating back from 2006. Programmed the ETL of all history and deltas for labor from the Time system. Technologies were Business Objects Data Integrator and PLSQL.
• Designed and populated the Employee Dimension from historic source and ongoing delta loads.
• Took over and maintained all employee data in our ODS.
• Built a PLSQL based validation framework for ETL loads.
• Championed the team’s acceptance and follow-on usage of SVN for all of our day-to-day work.
• Created a branch-based scripting framework for deployments of database code to all environments inclusive of common plsql code.
• Used Oracle’s object oriented PLSQL extensively for creation of teamwide common PLSQL objects for logging as well as dynamic sql execution.

Confidential

Database Consultant

Responsibilities:

• Coded a common toolset for binding literals found throughout the existing dynamic sql driven reporting backend. Extensively utilized Oracle Object Oriented programming constructs. Modified all existing reporting plsql to take advantage of this toolset.
• Researched serious reporting performance issues. This involved a two-tier architecture of an open source reporting tool (BIRT) and client coded plsql support. Recommended and then implemented a new architecture for the database backend support of BIRT for all existing eighteen reports. An example of the performance metrics were a report taking 15 minutes executed in under 30 seconds.
• Investigated and solved an outstanding connection pooling bug caused by the longest running report. The error being thrown was “ORA-01000 maximum open cursors exceeded”. The researched involved using Eclipse to step through open-source java code combined with querying the database v$ tables.

Confidential

Database Consultant

Responsibilities:

• Architected and subsequently coded a completely new datastore and PLSQL supporting the enterprise’s new application for Admission Events and the on-going tracking of those events.
• Architected the first phase of the new enterprise data-warehouse which was a reporting mart for the before mentioned admission datastore. This is a dimensional model following Ralph Kimball’s teachings with type1 and type2 dimensions supported. The ETL design included a capturing of history of all sources, implementation of Referential Integrity not implemented by sources and an almost real-time delivery of data.
• Designed and implemented an enterprise logging and error capturing PLSQL application for use by all PLSQL processing going forward. With autonomous transactions, the start/end times and errors plus common logging were all captured and subsequently reportable.

Confidential

Database Consultant

Responsibilities:

• Performed low-level research on existing database processes and communicated findings through all layers of the business unit. The research was needed because of the extensive employee turnover suffered by webstats.
• Worked on two major projects for building reporting datamarts. Participated to the fullest extent in Confidential ’s FSDM documentation life-cycle for both of these projects.
• Designed a metadata schema to store URLs.
• Designed aggregate tables supporting the reporting needs defined by the business.
• Authored PLSQL code for support of loading and maintaining these datastores.
• Coded PLSQL procedures for loading these aggregate tables on a nightly basis.
• Participated fully in the FSDM documentation lifecycle, SRA, SDS, TSD and TPD.

Confidential

Database Consultant

Responsibilities:

• Worked extensively on an internal application supporting the enterprise’s push toward tying the initial sales opportunities to the performance of the acquired business.
• Prototyped and then implemented all facets of the conversion application used to convert the internal portfolios from the historic data structures to the new schema design.
• Guided the team toward source control management of all database code. Built suite of shell scripts affording the database team capabilities of delivering the codebase to all environments, local development, integrated development, QA, UAT and then production.
• Re-architected the existing database design to correct a major flaw of losing downstream primary keys as the data moved from different phases of a portfolio’s life-cycle.
• Built a generic Batch Processing suite scheduled by autosys to interact with the BEA Weblogic server executing explicitly named actions. Designed and delivered all database code called by these processes. The processes funded and liquidated portfolios and replicated products to the new opportunity application’s datastore. (ONYX)
• I and the java architect, designed and implemented the 2nd release of functionality allowing for portfolios to be created and updated from the application, replacing the current production VB application. Coded all java access objects to the authored database code. Mimic’d Oracle’s connection context for use within a Sybase instance. Authored all procedures called by the java layer.

Confidential

Database Architect and Senior Programmer

Responsibilities:

• Designed and deployed all schemas supporting the five staging environments supporting the Informatica ETL solution.
• Designed the ODS to support easy backout of loads as well as future OLTP access.
• Rearchitected many aspects of the Datawarehouse to support enterprise’s view of the loan’s life cycle.
• Designed and authored the complete PL/SQL Auditing solution.
• Authored numerous packages and views to support Informatica through its stages of ETL.
• Authored a complete deployment solution focusing the project on Source Control based on the open source ant distribution taking advantage of its OO features and also the ant-contrib distribution.