summary

• Dedicated IT professional with excellent problem solving, communication, organizational skills, and work ethic.
• Over 20 years of professional experience in Oracle database design and development.
• Over 11 years of professional experience in leading Oracle development teams to rapidly deliver high quality solutions.
• Expert PL/SQL skills with proficiency in both OLTP and data warehouse environments.
• Expert in ETL using PL/SQL and techniques for maximizing performance with no downtime.
• Experience with ETL tools.
• Experience with shell scripting.
• Experience with SQL Server, Transact-SQL, Netezza, and Teradata.

technical skills

Database Development: Oracle 7,8i,9i,10g,11g , RAC, Dataguard, OLTP, data warehousing, PL/SQL, ETL, SQL tuning, PL/SQL tuning, normalized and multidimensional data modeling, star schema, star transformation, slowly changing dimensions SCD , packages, procedures, functions, triggers, views, collections, bulk collect, forall, pipelined table functions, materialized views, query rewrite, dynamic SQL, external tables, index organized tables, CLOBs, BLOBs, object types, Oracle Advanced Queuing, partitioning, partition exchange, parallelism, direct path insert, merge, update joins, multi table insert, autonomous transactions, instrumentation, Oracle built in packages, data dictionary, sys context, database security, roles, privileges, external procedures, Java stored procedures, flashback, restore points, export, import, data pump, database links, Oracle Database Gateway for ODBC, Oracle Heterogeneous Services, Data Masker, ER diagrams, ERwin, Oracle Enterprise Manager, SQL Loader, SQL scripts, Oracle Warehouse Builder. Limited experience with SQL Server, TSQL, Teradata, and Netezza.

Additional Languages: C, bash and korn shell scripting

experience

Confidential

Lead Database Architect/Lead Oracle Developer

• Solely responsible for designing and developing the Oracle backend of a real-time data warehouse from the ground up with minimal requirements. The warehouse, known as a swap data repository, was built to satisfy regulations mandated by the Dodd-Frank Wall Street Reform and Consumer Protection Act. Design and development was extremely rapid in order to meet tight government deadlines and required 60-80 hours per week for 16 months to complete on time. Mentored and led a team of Oracle developers hired after the production deployment to assist with support and ongoing development. Oracle 11g RAC.
• Designed and developed a flexible, resilient data model using a multidimensional star schema design for fact and dimension data received from multiple jurisdictions with differing requirements, and a normalized model to support other functions such as administrative product set up and management, maintenance of data mappings, login and permissions, staging for ETL, and storage of valuation data received from various sources. Dimensions included a mix of SCD type 1 and SCD type 2 attributes.
• Designed and developed PL/SQL batch processes to load reference data from multiple source systems including product related data, holiday data, customer data and settlement prices. Depending on the source, the data was either accessed via database link or via external table.
• Designed and developed a nightly PL/SQL batch process for generating long, short, and net end of day position aggregates, weighted averages, and option deltas, and for applying marks and settlement prices and calculating mark to market and total position valuations.
• Designed and developed an end of month PL/SQL batch process for shifting the grain of power deals using a rolling 2 month window. The result is that the current and prompt current 1 calendar months have power deals broken out into hourly components and all other months, past and future, have power deals broken out into monthly components.
• Designed and developed PL/SQL to maintain real-time top day position aggregates.
• Set up Oracle queues and AQ propagation to move selected changes to source reference data to the data warehouse.
• Designed and developed PL/SQL packages, triggers, and views for real-time ETL of reference and dimension data.
• Designed and developed tables, views and PL/SQL packages needed for internal and external reporting.
• Designed and developed PL/SQL utility packages to accomplish common repeatable ETL and DBA tasks dynamically such as table truncation, table deletion, loading a target table from a source table or view, merging into a target table from a source table or view, partition truncation, partition exchange, statistics gathering, marking indexes as unusable, rebuilding indexes, moving objects between tablespaces, etc.
• Utilized other miscellaneous Oracle features such as SQL analytics, partition exchange, parallelism, table compression, bitmap indexes, function based indexes, star transformation, merge operations, function result caching, views with instead of triggers, composite triggers, dynamic SQL, and Oracle jobs.
• Utilized dbms application info for instrumentation of all PL/SQL processes.
• Designed and developed a subsystem for message logging with fully configurable logging depth that could be changed on the fly.
• Tuned batch processes and top SQL.
• Conducted team meetings and code review.
• Created documentation for complex PL/SQL processes, data transformations, mappings, data models, naming conventions, etc.
• Designed and developed enhancements to an application for matching post trade swap confirmation data from the buyers, sellers, and brokers of bilateral swaps. The core business logic for trade validation and matching is written in PL/SQL and makes extensive use of object types, collections, and Oracle Advanced Queuing to manage the workflow and marshal trades through the matching process. Oracle 10g.
• Provided ongoing development of PL/SQL packages, procedures, functions, triggers, and views.
• Designed and developed PL/SQL modifications to support conditional matching.
• Designed and developed enhancements to the invoice process and invoice reports.
• Designed and developed functionality to capture data changes to support ETL into a warehouse mandated by the Dodd-Frank Act.
• Conducted performance analysis and tuning of the trade validation and matching engine using dbms profiler.
• Tuned top SQL identified by AWR reports.
• Conducted extensive data cleanup and de-duplication and added indexes and constraints to prevent future occurrences.
• Designed and developed PL/SQL and external tables to automate product creation and modification, and to migrate product changes across environments greatly reducing the time spent on support.
• Designed and developed a PL/SQL package to manage customer data and to migrate changes across environments.
• Mentored and assisted team members with new development.
• Conducted team meetings and code review.
• Created documentation for complex PL/SQL processes.

Confidential

Lead Database Architect/Lead Oracle Developer

• Led design and development of an enterprise data warehouse to support business intelligence and strategic decision making at the executive level, and to satisfy customer reporting requirements. Team included PL/SQL, Oracle Warehouse Builder OWB , and reports developers. Metrics included both overall and milestone turnaround times for services rendered, product and channel transaction volumes, forecasted and actual revenue, invoicing and account receivables, customer support call volumes, and scoring for customer ranking and to identify at risk customers to name a few. Oracle 10g.
• Fulfilled multiple roles on the project including chief architect, technical lead and development team manager, business analyst, Development DBA, and lead ETL developer.
• Gathered business requirements from executives throughout the enterprise.
• Developed the project roadmap and detailed plan based on prioritized business requirements, ROI, and technical considerations.
• Conducted a thorough review of legacy systems to translate the business requirements into technical specifications and identify opportunities to cleanse, conform, and enhance the data. The overall data quality in the source systems was extremely poor.
• Designed a multidimensional data model using star schema and Ralph Kimball's Data Warehouse Bus Architecture, consisting of multiple partitioned fact tables for each subject area and conformed type 1 and type 2 slowly changing dimension attributes.
• Designed and developed schemas for source data staging, ETL processes, and presentation.
• Designed and developed a PL/SQL package to support common ETL tasks such as the loading of full historical or incremental data into the staging area, partition exchange, index status changing, and index rebuilding.
• Used OWB to develop ETL process flows and mappings which could be run in either full historical or incremental mode.
• Integrated data from multiple, disparate source systems including 11 Oracle databases, 1 SQL Server database, Salesforce, and flat files. Utilized Oracle heterogeneous services, Castiron, and external tables.
• Utilized miscellaneous Oracle features including SQL analytics, partition exchange, parallelism, table compression, bitmap indexes, star transformation, direct path inserts, merge operations, and multi-table inserts.
• Utilized Oracle materialized views for query rewrite to speed performance on queries of aggregated data.
• Utilized PL/SQL pipelined table function to normalize data that was stored as a delimited string in the source system.
• Designed a PL/SQL process to rebuild only the particular index partitions affected by direct path loads.
• Created fully masked clones of production data to be used for data profiling and ETL development. Sensitive Personally Identifiable Information SPII was fully masked using Data Masker software and custom PL/SQL to ensure integrity.
• Guided front end developers in the presentation of data for executives using Hyperion System 9 and for customers via integration into existing online applications.
• Conducted team meetings and code review.
• Created documentation for complex batch processes, data transformations and mappings, data models, naming conventions, etc.
• Led development of a consolidated Oracle 10g database to take the place of 6 local Oracle 8.0.6 databases in different areas of the country so that business workload could be shared and balanced among the 6 individual employment centers.
• Developed SQL scripts to create all of the database objects for 7 Oracle 10g instances to support the consolidation effort.
• Aided production DBAs with tuning of export/import process and character set conversion errors encountered during data migration from the legacy databases to the new instances.
• Utilized a Dataguard standby database to reduce the impact of operational reporting on the primary transactional database.
• Utilized Oracle partitioning to aid with query performance and to facilitate archiving of transactional data using transportable tablespaces as it accumulated in the new consolidated database.
• Analyzed and synchronized differences in the 6 legacy local databases as part of the consolidation effort. This synchronization corrected years of divergence and greatly simplified the promotion of PL/SQL code to the production instances. All other environments were upgraded to 10g and synchronized as well including development, QA, staging, and UAT.
• Developed a set of set of dictionary driven utilities to aid with database synchronization and maintenance.
• Established and led a data architecture team to set up and enforce consistent development standards and review database changes.
• Established and implemented roles and privileges for development and QA teams to enforce security and aid with the change control process.
• Established and implemented a new release process using SQL scripts for promoting database changes across environments.

Confidential

Director, IT Infrastructure and Application Development

Chief Database Architect/Lead Oracle Developer

• Designed, developed, and supported hosted data warehouse and analytics solutions for multiple customers. Oracle solutions included data marts to support analysis of worldwide sales transactions, membership enrollment, marketing campaigns and retention, order reconciliation, and electronic coupon interest and redemptions. Transactional systems included an electronic coupon messaging system, an order reconciliation management system, and an integrated customer request and issues tracking system. Oracle 10g RAC.
• Transformed a startup with 2 developers and 2 customer programs, only a production environment, no change control, and no source code repository, into a more mature software company specializing in hosted data warehousing, business intelligence and managed analytics supporting 12 customer programs with a team of 14 IT professionals in a 24-by-7 environmet.
• Recruited managed and led an entire IT team including DBAs, PL/SQL developers, Java developers, reports developers, systems engineers, and help desk analysts.
• Improved performance, stability and availability of systems by implementing development and test environments, change control processes, a source code repository, a data backup and recovery strategy, a file movement strategy, complete redundancy across all systems, network area storage, fiber drives, RAID 10, 64 bit processors, ASM, RMAN, Oracle grid control, enhanced security, improved process logging, end-to-end system monitoring and alerts, stress testing, and standardized, reusable code.
• Provided IT leadership instrumental in growing the company from 1.5 MM/yr to over 8 MM/yr in a little over a year.
• Daily responsibilities included a mix of application and database design, data modeling, ETL design, IT resource allocation, project management, and hands on PL/SQL, shell script, and OWB development.
• Oracle 10g RAC environment running on Red Hat AS with databases ranging in size from 100 gigabytes to 3 terabytes. Large tables had several hundred million to over a billion rows.
• Improved ETL performance on new and existing loads by implementing OWB or custom PL/SQL set based ETL when appropriate, and advanced Oracle features including SQL analytics, partition exchange, parallelism, direct path inserts, merge statements or update joins, multi-table inserts, and more. Modified ETL to rebuild only the particular index partitions affected by direct path inserts. Utilized manual workarea size policy to adjust sort area size and hash area size as needed. Removed row by row processing from existing ETL and replaced it with set based operations whenever possible. When complete conversion to OWB or rewrite using custom set based processing was not feasible given the ROI and competing priorities, other methods were utilized such as bulk collect, forall, and pipelined table functions.
• Dramatically reduced load times by orders of magnitude including 9 hours to 15 minutes, and 4 hours to 25 minutes, as examples.
• Designed and developed ETL processes to load data marts from flat files and database links to transactional databases.
• Designed and developed data warehouses using multi-dimensional star schemas and Kimball's Data Warehouse Bus Architecture, consisting of multiple fact tables and conformed type 1 and type 2 slowly changing dimensions.
• Standardized then replaced aging shell script and SQL Loader based enterprise ETL framework for flat file loading with external tables and Oracle jobs.
• Designed and developed PL/SQL packages containing dynamic procedures for repetitive tasks such as for table loading, table merging, partition exchanging, index status changing and index rebuilding.
• Tuned and optimized performance of end-user queries and reports by rewriting SQL, implementing materialized views for query rewrite, improving indexing or utilizing parallelism, or by partitioning tables when appropriate and possible.
• Provided leadership in the decision making process for all infrastructure changes hardware, software, networks , third-party product selection, capacity planning, data availability, standards, and security procedures.
• Traveled to customer sites for requirements gathering and high-level design meetings.
• Involved in the process for creating statements of work and service level agreements.
• Conducted team meetings and code review.
• Created documentation for load processes, data transformations and mappings, data models, naming conventions, etc.

Confidential

Senior Database Architect/Senior Oracle Developer

• Designed, developed, and supported a web based trading platform for debt securities including municipal bonds, corporate bonds, Treasury bonds, zero coupon bonds, and certificates of deposit. Oracle 9i, 10g.
• Designed and developed PL/SQL packages, procedures, functions, and triggers containing the business logic of the application.
• Designed and developed tables, views, materialized views, and indexes to support the application.
• Designed and developed all PL/SQL, C programs, and shell scripts necessary to support the trading of certificates of deposit.
• Designed and developed PL/SQL utilities to aid the QA team with comparison of yield calculations across applications.
• Managed users, roles, privileges, and tablespaces.
• Tuned SQL and PL/SQL.
• Created SQL scripts to manage change across all SDLC environments.
• Published Java stored procedures.
• Designed and developed an Oracle interface to the TechHackers financial calculator's C objects.
• Designed and developed a C shared library containing external procedures that could be called from PL/SQL to facilitate financial calculations for the application via interface with the TechHackers calculator.
• Created an Oracle library to act as a local alias for the external procedures.
• Designed and developed feeds and interfaces into and out of the system.
• Designed and developed PL/SQL packages for moving live data from one transactional database to another via input from a standalone Java process.
• Designed and developed PL/SQL packages and procedures to load live treasury feed data from Zions bank via a TCP/IP socket.
• Developed C programs to calculate price, yield, and accrued interest for exported offering data.
• Designed and developed a process to extract, calculate, and export offering data for customers. PL/SQL, C, shell script.
• Developed a process to extract, calculate, and export composite interest rate data for customers. PL/SQL, C, shell script.
• Designed and developed a PL/SQL package for importing data from customer files using external tables.

Confidential

Oracle Developer/Reports Developer

• Designed and developed a data mart for customer application and account information for a variety of bank products including first and second mortgages, lines of credit, and loans collateralized by securities.
• Designed and developed the data model.
• Designed and developed SQL Loader imports to staging tables and PL/SQL for transforming and loading data into target tables.
• Designed and developed complex views and PL/SQL procedures for cross-product reporting.
• Designed, developed, and deployed complex reports for sales and marketing, accounting, and operations utilizing multiple drill down layers and sub-reports with Crystal Reports 9 and Crystal Enterprise.
• Trained bank employees in methods and techniques required for report development.

Confidential

• Designed and developed managerial and customer reports for the home inspection business.
• Designed and developed reports using Crystal Reports 8.5.
• Trained company employees in methods and techniques required for report development.

• Designed and developed a data warehouse for customer, order, and shipment information to support online reporting for clients of fulfillment services. Oracle 8i.
• Designed and developed the data model.
• Designed and developed SQL Loader imports to staging tables and PL/SQL for transforming and loading data into target tables.
• Designed and developed complex views and PL/SQL procedures to support online reporting.
• Designed, developed, and deployed complex online reports utilizing drill downs, sub-reports, and stored procedures with Crystal Reports 8.5 and Crystal Enterprise.

Confidential

Oracle Developer/Software Engineer

• Developed an application for automotive services and roadside assistance servicing over 12 million members and dozens of clients including Confidential.
• Designed, developed, and tuned complex PL/SQL packages and procedures to generate invoice data.
• Designed, developed, and tuned a nightly routine for importing data from customer files. PL/SQL, SQL Loader, shell scripting.
• Designed and developed triggers, views to support application.
• Designed and developed complex financial, operational, managerial, and customer reports using Crystal Reports 8.5.
• Analyzed business needs with customer to develop specifications and supporting documentation.
• Developed a contract management, billing, and accounts receivable system servicing over 3 million customers. ADT, Inc.
• Designed and developed tables and a PL/SQL package to extract and transform data needed by Oracle Applications General Ledger, Assets, and Receivables.
• Designed and developed PL/SQL packages, procedures, functions, triggers, and views containing the business logic.
• Designed and developed a PL/SQL batch process to manage contract escalation.
• Designed and developed financial, operational, and administrative reports using Oracle Reports.
• Analyzed business needs with customer and developed specifications and supporting documentation.
• Developed a vehicle monitoring application. Our proprietary in-vehicle unit was the first to combine cellular technology with GPS. Clients included Pepsico and the United States Postal Service. Mobile Securities, Inc.
• Designed and developed the GUI for managing subscriber and contract information, in-vehicle unit settings, and call center operator management using Visual Basic.
• Designed and developed PL/SQL packages, procedures, functions, triggers and views to support the application.
• Designed and developed managerial and operational reports using Crystal Reports.
• Developed a deduction management application used to track, control, and report sales incentives taken by retail customers. Borden Foods, Inc. SQL Server
• Designed and developed the GUI using Visual Basic.
• Designed and developed TSQL procedures to support the application.

Confidential

Oracle Developer/Software Engineer

• Developed an application for generating parent item and bill of material part numbers and quantities based on part descriptions to streamline order entry and inventory management for a manufacturing system.
• Developed the GUI using Visual Basic.
• Designed and developed a PL/SQL package to generate part numbers and descriptions for all parent items and the associated entries for each bill of material.
• Designed and developed PL/SQL packages, procedures, functions, triggers, and views to support the application.