Rèsumè. Dec 2007. I have done a horrible job of keeping my personal site up to date. With all of my years at Deloitte, I have been on more projects than I can list here. To make things simple, I have updated my resume and thinned the listing down to some of the more fun and relevant projects. I have dropped off some of the obsolete experience which is not relevant anymore and tried to focus on my current skills. After all who uses a Wang VS100 with Oracle 5.1a (beta) anymore?

Just to clarify, I am a very technical manager, not a junior programmer. I use to program with ETL tools (Informatica, Data Stage (Ascential), PL/SQL, Pro*C, etc), do Unix and Oracle database administration (Sun Solaris, Oracle RDBMS 5.1a on up, etc), and configure and implement reporting/BI tools (Cognos, Business Objects, Microstrategy). However, those days are a bit behind me. Yes, there are times I long to be more hands on with the tools, but then I remember how stubborn and frustrating some of the development tools have been (especially right after a new major release) and I realize how I enjoy working more on the architecture, data and management side of things...

So, for the recruiters looking for hard core DBAs and ETL developers: sorry that's not me anymore. That said, I still roll up my sleeves and do some of the development with my team beacuse I can't stay current if I don't use the tools too!

Click here for a MS Word or Adobe PDF based copy of my rèsumè.

Raymond Bowers
Alexandria, VA
ray@bowers.com

Summary:

Extremely qualified in Data Warehousing with over 17 years experience DW strategy, architecture, data migration, business intelligence, ETL development, and data management. Designed and developed numerous global and functional warehouses and marts, supporting multiple languages, currencies and topologies. Substantial experience with many DW tools such as: Oracle, Informatica, IBM Data Stage (Ascential), MicroStrategy, Cognos and Business Objects. Past experience include Public Sector (DOD, Federal and State agencies), Communications, Cable & Media, Insurance, Financial Services, Consumer Package Goods, Healthcare and Pharmaceutical industries.

Experience:

March 2007 - Present, Raytheon

• Principle IT Architect: Lead a team developing a functional data mart to replace legacy batch processes, denormalized tables/files and thousands of crystal reports analyzing work flow data for thousands of workers and products. Created a single star schema with complex analytic capabilities populated via PL/SQL for ETL in Oracle 10g RAC on Linux to reduce cost. Developed the Business Objects XIR2 Universe for ad hoc and 508 reporting with a dashboard in Xcelsius for a flashy user interface
 

September 1997 - March 2007, Deloitte Consulting, Manager (sample projects)

• Data Lead / Requirements, Design & Implementation, 15 months: Lead the Data team through requirements, design and development for a complete overhaul of the financial asset management systems at a major federal client. Responsibilities throughout the full life cycle included data architecture design, logical and physical data model creation, requirements gathering and analysis for reporting and operational capabilities, developing the Business Objects XIR2 Universe and reports, data and feed analysis, tool evaluation, data team lead and task planning.
 
• Data Warehouse Lead / Scoping and Planning, 6 months: Lead the DW team to develop the roadmap and charters for a 2 year Financial Transformation initiative at a major insurance company. Conducted an as-is analysis of existing IT systems, developed findings and recommendations, and planned the strategy to complete the effort, coordinating with core financials, process, management reporting and other teams. Planned for $20M+ (of $65M total) over 2 years for all warehouse infrastructure, data migration, interfaces, BI tools and data cleansing.
 
• Data Warehouse Assessment Lead, 4 months: Manager for an assessment of a DW system for the securities branch of a large financial services firm. Interviewed staff, evaluated existing systems, feeds, data, process, technology and future needs. Identified new strategic plan to accommodate future growth and created a road map maintaining current performance while developing a new vision over multiple phases.
 
• Data Warehouse Assessment Lead, 1 month: Performed a technical assessment of a POS DW tracking all sales through Wal*Mart for a large Consumer Packaged Goods firm. Identified organizational, process and technical problems, including more efficient aggregation routines and the lack of validated system backups. Proposed short term solutions for system and data quality improvement, as well as mapped out needs for migrating to a longer term solution.
 
• Data Warehouse Technical Team Lead, 9 months: Team lead for a corporate Data Warehouse project at a large Cable & Media firm. Conducted a Proof of Concept with Oracle, Informatica and Microstrategy for the client in the first phase. Follow-on work included designing and implementing the technical and application infrastructure with standards and load templates for the system in preparation for full development. Included Trillium for name and address cleansing and Platinum for metadata management. Managed a team of developers, lead planning activities, system design, deliverable reviews and quality assurance.
 
• Data Warehouse Technical Team Lead, 13 months: Team lead for a corporate Data Warehouse project from requirements through deployment for a voice and data services provider. Managed the technical team handling ETL, DB and BI. Lead development planning activities, conducted tool selection, application infrastructure and system design, deliverable reviews and quality assurance. Designed and implemented a hub & spoke system supporting a centralized warehouse with multiple marts on Oracle, Microstrategy, Informatica, 3 IBM S80s and 2 TB HDS storage.
 
• Operational Risk Management Lead, 5 months: Managed risk mitigation activities for a leading credit card company around unauthorized or erroneous changes to production data without adequate process documentation, controls, or audit trails. This included a review of business processes, data usage and security across multiple business lines, and development of a risk mitigation strategy.
 
• Data Warehouse Technical Team Lead, 6 months: Designed and implemented a global Data Warehouse for an international wireless telecommunication firm collecting customer, usage, revenue, churn and trouble ticket data from multiple countries in different languages and currencies. Designed the application infrastructure and ELT processes in PL/SQL to pull data billing and trouble ticket system data in each country while translating and maintaining exchange rates. Reporting through Oracle Discoverer was required to allow users at the global and local market levels to view reports in English with US dollars as well as a market’s local language and currency. Initial deployment called for independent servers for each country until the WAN was in place to support a centralized approach.
 
• Data Warehouse Developer & Admin, 14 months: Served as a developer and DBA for two separate data warehouse projects that accessed Oracle 7.3 & 8.0 under Sun Solaris on E4000 and E4500 systems. Participated in system design, logical data modeling, ETL development, SQL and process design and tuning. Acted as the development team admin for Unix (Sun hardware selection, Solaris administration, configuration, disk array layout, user management, backups) and Database (database installation, sizing, physical data modeling, configuration, performance monitoring and tuning, maintenance) systems. Data included: Customers, Voice CDRs, revenue, margin, usage, geography, demographics and churn data. Largest production instance managed: 200GB, >300 tables, >30 millions records.
 

1990 - 1997, Computer Sciences Corporation (CSC), Senior Programmer

 

Data Warehouse Technical Team Lead: Served as lead technical architect, designing and implementing the architecture for several data marts for the US Navy. Responsibilities included data modeling, warehouse performance and tuning activities, front end development using Delphi C/S with Cognos Impromptu and PowerPlay, management of back-end ETL development activities for Oracle and all tool selections.

 

Summer 1988, Perot Systems, Summer Associate

 

Testing and Data Analysis: Tested and reviewed data for a custom billing and information system for a construction information provider.

System Experience:

Databases and Data Modeling:

ErWin, Oracle 5.1a thru 10g

Reporting:

Business Objects XIR2, Xcelsius, Cognos, Microstrategy, Oracle Discoverer

ETL:

PL/SQL, Informatica, IBM Data Stage (Ascential), Business Objects Data Integrator

Education:

B.S. Radford University, Computer Science and Statistics, 1990

Oracle, Informatica, Microstrategy, Cognos, Business Objects and Unix training