Paul A. Manning
Projects
- The Standard - Contractor - Data Analyst - 6/2007 - 8/2008 - OLTP design/development: design, develop data structures to support new retirement plans billing system. Model data persistence needs, script deployemnts, author SQL. Introduced SOA concepts to full-time team, used billing system as pilot project. System spanned 200 end-users, batch processes to trading platform and General Ledger.
- Kaiser Permanente - Consultant - 2/2007 - 5/2007 - Data Analysis: Assist in data extracts and analysis for new product rollout. Completed on time, under budget with additional functions performed while in-house. Constructed repeatable and extendable Quality Assurance process for retro-testing and future enhancement validating.
- TransUnion / Qsent, Inc. - Database Architect - 7/2000 - 11/2000 - Web/Phone iCommerce: Designed, developed and implemented a transactional database to support wired and wireless Internet application for taxi, sedan and limousine reservations. Wrote PL/SQL (packages, functions, triggers, etc) to manage primary key assignments, ensure referential integrity, log transactions, set trace fields (last modified by and when) and persist reservation data. Developed custom SQL*Loader scripts to load raw data from external and internal sources. Researched sources for location data and geo-coding. Developed DTD's and XML Schema to support integrated / EDI version of product. Participated in the development of the database handling perl scripts that interacted with the main application code. Ongoing responsibilities included updating location data from external sources, and work with business analysts improving product.
- Integra Telecom / Electric Lightwave, Inc. - Senior Software Consultant - 10/1998 - 5/1999 - ODS/reporting: Designed, developed and implemented an Oracle 8.x datamart for analysis and end-user reporting. Developed custom replication using message queuing to move the data of interest from the production system. Developed PL/SQL standard for the corporation while developing encapsulated business rules for use both by the datamart and by future systems. Used Oracle packages (DBMS_JOBS, DBMS_PIPES, DBMS_UTILITY, DBMS_SNAPSHOT) for underlying architecture. Used Oracle replication for temporary data storage. Managed requirements collection, code development and documentation for business rules.
- TransUnion / Qsent, Inc. - Database Architect - 4/2001 - 12/2006 - Data Warehouse: Designed, developed and implemented a dimensional data warehouse for analysis, reporting and billing usage for pivotal product lines. Designed, developed and implemented new functionality into warehouse without client impact. Participated in the design of reports for internal consumption and client use. Managed Jr. staff to develop and implement reporting suite to user base. Wrote Unix scripts to manipulate indexes and files as part of the finished ETL process. Optimized star-schema queries for greatest performance. Used third party tools, from Quest Software and Embarcadero, to maximize efficiency of executing SQL. Drove the upgrade of the backend storage from NetApp to EMC and Oracle version from 8i to 10g while moving data center from Portland to Chicago with a contracted DBA. Recurring improvements (report additions, added data sources, etc.) throughout lifecycle.
- TransUnion / Qsent, Inc. - Database Architect - 12/2005 - 5/2006 - Automated Data Management: Designed, developed and implemented a process control system for loading, updating and extracting data streams to and from multiple client databases across different vendors (file to Oracle, Oracle to MySQL, MySQL to file). By defining data dependent preconditions for processes, process to process dependencies were eliminated, allowing for increasingly complex data flows without a parallel increase in job structure complexity. Scripted Oracle PL/SQL packages in support of the main controller that directs the client databases as well as the monitoring and controlling applications. Assisted Jr. staff in PL/SQL development and code release processes. Implemented UT PL/SQL to perform recurring unit tests on code base to insure code stability between versions. Tuned SQL for performance.
- TransUnion / Qsent, Inc. - Database Architect - 11/2002 - 6/2003 - High Volume (200M+) OLTP: Designed and participated in the development and implementation of production Directory Assistance (DA) loading and cleansing processes to replace proof of concept effort. Designed, developed and documented proprietary (patent pending) systems to improve findability, usability and accuracy of DA listing data. Designed and developed peripheral systems for monitoring and scheduling loading, cleansing and aggregation processes.
- Healtheon Inc. / WebMD - Senior Software Consultant - 8/1999 - 7/2000 - Data Warehouse: Designed, developed and implemented a large-volume data warehouse (webhouse) of web, membership & transactional data. Using Ralph Kimball principles, star schemas were created for each area of interest. Clickstream, member profile, chatstream, message board threads and contest entries were all built in this manner. Used benchmarking for assessing and selecting tools for extraction transformation and loading. Developed and implemented Informatica usage standards. Ongoing responsibilities included dimensional data modeling, ERD Library maintenance, ETL process dependency matrices, database performance tuning, data extraction, transformation & loading scripting, database programming, Unix scripting, report development, analysis of clickstream, chatstream and message board usage, and technical mentoring.
- TransUnion / Qsent, Inc. - Database Architect - 11/2000 - 4/2001 - Compressed Timeline HiVolume/HiVisibility: Designed, developed and implemented a large-volume data warehouse for processing and cleaning Directory Assistance (DA) data. Designed proof of concept and version 1.x dimensional data models. Analyzed telephone carrier data feeds for ETL processing. Defined field/record cleansing business rules for greatest flexibility and accuracy. Wrote Unix scripts to manipulate indexes and files as part of the finished ETL process. Optimized star-schema queries for greatest performance. Assisted in the research and adjustment of Oracle initialization parameters for improved performance. Participated in the design of indexing schemes for swift retrieval, and supporting larger loads. Implemented Informatica usage standards. Developed and implemented Informatica documentation and session notification standards.
- Integra Telecom / Electric Lightwave, Inc. - Senior Software Consultant - 5/1999 - 8/1999 - web application: Designed and developed the database and data accessors for a web-based application that allows the sales force to quote prices for a customer, and take that quote to an order in the existing order-entry system (TBS 1.x, 3.0). Developed PL/SQL to supply the application with complex data. Ongoing responsibilities included generation of SQL for reporting, technical mentoring, and maintenance to the ERD library.
- K&M Electrical - Consultant - 9/2006 - 9/2006 - Presented with frozen client computer in an office of 4 computers including laptops. Printing was routed through a PC, internet access was spotty and fax was intermittent.
We installed a wireless router and a small print server. This gave printing access to all computers and expanded the network for expected growth. We resolved the frozen computer, gaining access to the spreadsheet programs again.
18521 Waxwing Circle • Lake Oswego, Oregon 97035
• H:503-620-9522 • W:503-358-3849
