Oracle Project Manager
Resume:
Stirling S Newberry
Boston, MA 02114
********.********@*****.***
HSSP at MIT
Teacher
Taught courses on the Theory of Relational Datadase Design, including Gödel, Turing, and Nash.
Contracting
Senior Project Manager
2/2013 – 6/2013
Vendor Management on BI projects to replace legacy system and produce mission critical reporting system. Implemented RUP methodology to manage requirements and testing. Wrote budgets, and Statements of Work, and oversaw requirements generation process.
Project Lead
9/2012-1/2013
Designed API for MySQL to Hadoop synchronization of data as part of Datawarehousing initiative. Utilized C and MySQL Replication based binlogger middleware layer to extract and load into Hadoop for a national gift carding analytics solution. Coded reporting solution using Python and Django against MySQL back end.
Best practices and disaster recovery consulting for Oracle systems, implementing Golden Gate, HA/MAA, Dataguard and RMAN based backup. Migrated clients from Oracle to PostgreSQL for SaaS support.
PegaSystems
Principal Software Architect
05/2012-09/2012
Designed and implemented port of commercial software application, PegaRules ProcessCommander to pure PostgreSQL backend, lead team to design and test release under aggressive schedule. Application written in java for Cloud and SAAS. Re-architected database layer API to be used by Engineering for database calls to Oracle, DB2, and MS SQL as well as PostgreSQL.
NStar
Principal Technical Project Manager
12/2011 –04/2012
PMO duties for data warehousing and BI projects for external clients. Tracked resources, managed issues, handled customer facing issues, analyzed client needs to put seriously at risk projects back on track. Delivered two BI projects in 6 months with little existing infrastructure under tight deadlines and budget constraints.
Technology platform consisted of Oracle 11g on AIX, with Informatica to OBIEE, and OBIA 7.9.6, specifically Financial Analytics, for Revenue Assurance and Project Management. With MS SQL Server 2008 onWindowsServer 2008 with Sharepoint 2010 SP1 extracting from PeopleSoft for HR.
Completed milestone deliverable documents including Business Requirements Document for Revenue Assurance system, as well as project plans in MS Project. Coordinated resources, performed PM duties, including billing and hours management.
Designed and built custom virtual linux cluster for revenue assurance system. Design and implementation of billing data warehouse ETL process using PL/SQL and SQL*Loader. Designed star schema and queries for billing database, technical specification for Informatica implementation, trained Data Analyst to use SQL to accomplish data profiling milestones.
Experience Inc.
Principal Database Architect
10/2010 – 11/2011
Lead on performance improvement project, to convert obsolete database systems to current technology. Implementing conversion to 64 Oracle 11g, including implementation of Dataguard, OWB, and OEM. Brought Agile development methodology to database group. Query tuning and database performance increase project to produce a four fold increase in Business Intelligence Responsiveness using Jquery..
Re-architected Cloud ecommerce offerings in preparation for moving hosted to SaaS business model.
Responsible for tuning and upgrading physical and logical performance of Oracle, Postgres, and MySQL databases. Oversaw improvements to production methodologies including fail over and disaster recovery.
Designed mappings in OWB and Informatica PowerCenter to be implemented under Oracle EDI. Streaming of external job and applicant feeds into datawarehouse and OLTP.
Implemented Business Objects Reporting interface on MSSQl Server 2008.
Architected OBIEE replacement for hetrogenous reporting environment, replacing Open Reports and Pentaho backed by, custom SQL, and shell scripts with OAF driven java based reports served from an Oracle 11g backend using with BI Server/Publisher, APEX injection, Oracle Reports, Oracle Forms, and Oracle Portal.
Martin-Dawes Analytics
Senior Developer
4/2010 – 8/2010
Designed and coded Datawarehouse integrity module for real time telecom analytics engine data warehouse. Wrote functional and design specifications, coded and tested modules in a high pressure rapid development environment using server side PL/SQL, C/OCI, Java and Pro*C connecting to Delphi and Oracle Forms on Oracle 11g. Importing SAS feeds into batch processing system using custom ETL engine.
Conservation Services Group
Database Architect
11/2009 – 3/2010
Architected, designed, coded and delivered reporting datawarehouse for Tennessee Valley Project business intelligence and operations using C#/.NET, Oracle 11g on Linux and Windows, including Java Webservices from Oracle, Oracle Warehouse Builder, PL/SQL, Toad, SQL Developer, WSDL, JSON, XML and Crystal Reports. Oracle Forms injection to XML around OAF under OBIEE with APEX and Oracle Portal. Managed report and database developers in an Agile development process environment. Star and snowflake schema architecture, ETL and TEL process design including exporting and importing of test and legacy feeds into DW, developed OWB and Informatica mappings for production and publication. Developed client deployable datamarts using Oracle Forms and Oracle reports under Oracle 11g. Managed staff and project plans.
Neo Modern Entertainment
Lead Architect
2/2007-11/2008
Lead responsible for implementing streaming VR to database using Jdeveloper to Oracle, PostgreSQL and Sybase Anywhere under Windows and Linux. Object, network, and data modeling, architecture, and design for streaming application. Capacity planning for database and network capacity to handle over 1TB of throughput daily. Tools included ERWin, OWB, Jdeveloper, gcc, Python.
Created NOSQL based tracking and synchronization in Hypertable with Python API to serve midi data against Hadoop database.
Private Contractor
4/2006-1/2007
PL/SQL, Informatica Powercenter and OWB port and upgrade of ETL data warehouse system to Oracle 10g/9i from Oracle 8i running on Solaris 10. Upgraded CRM integration to use Siperion Hub. Designed, coded and tested replacement system which cut run time from 72 hours to 1 hour for mission critical data delivery that took feeds from Siebel and merged them into Oracle prescription database for CRM. Responsible for maintaining 7x24x365 system on Windows 2000 cluster and then on Solaris cluster, managing a group of 5. Datawarehouse ETL using OWB, PL/SQL and Informatica Powercenter on Oracle 9i, and Microsoft SQL Server.
Blogging of the President
Founder/COO
9/2003-11/2006
Founded, along with Matt Stoller, Jay Rosen, and Christopher Lydon blog/pod cast to cover the American society through the lens of the 2004 Presidential Race. Responsible for day to day operations, content, hiring, advertising and promotion of top 100 political blog. Covered by Esquire, the Washington Post, and other national outlets, broke stories and provided leading edge analytics. Writers included Marcy Wheeler, Ian Welsh, and Barry Ritholtz. Wrote on economcis including meso-inflationary dynamics. Guest blogged at TPM, Truthout and the DailyKos.
Private Oracle Contractor
6/2000 – 7/2003
System components included maintenance and troubleshooting of EJB, PL/SQL, Oracle 8i, Oracle Applications 11i (ERP: Workflow, Assets), Standby Database, RM, AQ, AR, Parallel Server. Development efforts with Oracle Portal, WebDB, PL/SQL and Oracle Parallel Server. Responsibilities include automating system monitoring and maintenance, training new staff, troubleshooting, aiding developers with OCI implementation and datawarehousing. Delivered Web Portal database control using WebDB, APEX, OAF and C++ around a UML design environment.
Training for Oracle tools including PL/SQL, Reports, Forms and Oracle Express. Selected for presentation at Oracle OpenWorld: "Desktop DataWarehousing: A Rapid Deployment Approach", “Extreme Programming and Deployment in Asia”. Programming projects including RAC on Open Unix, WebServices to LDAP connectivity in Java, Oracle Applications 11i (Financials, Grants), query tuning and BC4J.
Oracle/Windows 2000 best practices DBA consulting and performance tuning.
Oracle 9i implementation in a Weblogic environment, upgrade and backup/recovery strategies, code optimization for GIS and EJB based queries. ETL of GIS data using Oracle DWB, Oracle Pro*C and PL/SQL. MS SQL Server/Sybase compatibility coding and administration. DBA for Oracle Applications including GL, OE/OM and Assets.
Desktop datawarehousing projects for the purpose of videostreaming and searching, using Java, DataJunction, Informatica Powercenter and Oracle 9i/8i and Linux.
Oracle Corporation
Senior Principal Consultant
9/1999 - 5/2000
Technical manager in the core technology consulting team to telecom clients. Expert with Advanced Replication, Advanced Queues, SQL, OE/OM, 11i CRM, Oci and Pro *C for Oracle on Solaris and Windows NT. Delivered Pro*C version of Informix port in C++, high performance versions of production utilities in C with Pro*C and PL/SQL. Designed datawarehousing architecture for long term replacement of OE/OM system to interface with Oracle Applications, using Oracle’s ETL tools and dimensional analysis with Oracle Express.
Managed staff and project plans, PM duties including risk management, deliverables, and staffing including MS Project.
TAC Engineering
Contractor
4/1998 - 8/1999
Took senior and manager level contracts in database design and administration. Assignments included Thomson and Thomson, IRI Incorporated and TopLayer Networks. Responsibilities included leading a design team for a high performance datawarehouse architecture, porting a system from Sybase to Oracle, and ERP database design. Delivered porting libraries to join Oracle and Sybase databases, ELT utility for IRI using SQL, Oracle Express and C++.
Open Market
Principal Software Engineer
5/1996-1/1998
C and C++ programming for internet commerce and databases. Wrote reporting module for Transact, OpenMarket's internet commerce solution, allowing Commerce Service Providers to create reporting against ORACLE and SYBASE databases which their customers can load into MS Access databases. Converted data from internal format to MSAccess format using RogueWave's database library on the server side and DAO SDK on the PC side. Designed and implemented Server side reporting schemas in Sybase and Oracle, and Customer Database in Access. Wrote mini SQL engine in VB used to translate files. Designed reporting macro language for reporting. Delivered reporting module in C++.
Aided other employees with Oracle and Sybase design and programming issues. Managed staff and project plans.
Other C projects include Datablade work for INFORMIX server and installation code in C for ACDb.
Consultant – The Automation Group, TAC Engineering
9/1993-3/1996
Database design and administration with Sybase, DB2 and Oracle. Oracle Forms and Reports for Oracle Applications 10.x. Macintosh/Windows Client Server, including Powerbuilder, C, C++ and 4oD.
Contact this candidate