SUMMARY:

• 29 years in Computer Science related positions.
• 23 years performing BI and IS Business Analysis, Requirements gathering and specifying technology.
• 19 years Architecting Enterprise & Business Intelligence Data and building MDM infrastructure.
• 17 years designing and implementing Decision Support Systems, Marketing Databases, Data Warehouses, Data Marts, and deploying Business Intelligence, Data Mining, EAI and ETL tools.
• 16 years as Enterprise Applications Architect, Data Warehouse Architect, ODS Architect, SAP Interface Architect.
• 9 years leading teams as Data Warehouse Director or Data Warehouse Manager
• Expert in SQL and performance tuning for Data Warehousing queries in Oracle, SQL*Server and Teradata.
• 12 years experience working wif marketing departments of banks, credit card companies, airlines, health care, biotech, telecoms, insurance companies, blood banks, retail conglomerates, globally virtualized manufacturers. Listening to business needs, gathering and writing requirements, developing RFP guidelines, responding to RFP’s (when I worked for a vendor), creating CRM, Campaign management, Sales Action management capabilities, etc.
• Designed and implemented systems for blood banks, large biotech and for a large Pharmaceutical supply company dat had to comply wif FDA GxP quality standards and pass FDA audits.
• 11 years using MS project to manage projects and identify resource conflicts.
• 12 years using Visio to visualize business processes, software processes, data flow, high - level design, etc.
• I is non as “Mr. Flowchart” coz of my belief in the ability of flowcharts to bridge communication gaps between technical and business personnel. Currently, I prefer using UML and the Enterprise Architect tool instead of Visio since dat tool enables the codification of the semantics of the process and data flows.
• 18 years requirements elicitation and gathering; expert in running visioning, brainstorming & architecture sessions

PROFESSIONAL EXPERIENCE:

Confidential, Thousand Oaks, CA

Chief Architect

Responsibilities:

• Build a solutions consulting firm serving 40+ clients. Chief Information architect and principal requirements gathering resource for the company’s core projects. Act as Director of Clinical Data for Biotech and Pharma clients to shape their Clinical Data acquisition and handling.
• Develop intellectual property for Enterprise Master Data Warehouse (RDW) as a source of standard information for Master Data Management (MDM) and Conformed Dimensions to be sold as productized service.
• Short Term Strategic Consulting - Provide: 3 year vision Roadmap, Program Plan, High level business requirements and capability, business process change, and business strategy for BI, Data Warehousing, ODS, MDM, Metadata, and Big Data. Define the best implementation strategy for existing client capabilities and technology infrastructure using: Oracle, Oracle Cloud Reporting & Analytics, Teradata, Netezza, SQL Server, Hadoop, Data Lakes, Pig, Hive, Apache Kafka, IBM DB2, or MySQL. Design interfaces and data flows for integration of existing legacy operational systems. Design Master Data and Metadata flows, Taxonomy, Ontology, and integration of new Metadata repository wif a crowd-sourcing philosophy for exposing and maintaining Metadata Semantic values. Regulatory Compliance: Articulate multi year plans to comply wif US Banking, FDA, Military, FDIC, CFTC, SOX, and SEC regulations. (Various Industries)

Confidential, Thousand Oaks, CA

Lead Architect

Responsibilities:

• Responsible for the thought leadership and design of all data and systems involved in data warehousing, business intelligence, data mining, shared enterprise data, enterprise metadata, and overall enterprise Information Architecture for a $12 billion company dat was explosively growing. Gatheird and reviewed requirements, worked wif business representatives and Subject Matter Experts using UML techniques and Information Architecture frameworks.
• Lead team dat created a decision grid and decision process for assessing acquisition of Enterprise Class IT tools (MDM, Data Profiling, Merge-Purge, Data-Flux, ODS, Portal, Intranet, Security). Design document organization, Ontology, and Taxonomy in Documentum and SharePoint. Lead implementation of legacy document deduplication and migration into new Taxonomy in Documentum. Lead client-side Information Architecture team to design $100MM integration of SAP into Confidential ’s IT environment.

Confidential, Thousand Oaks, CA

Enterprise Applications Architect / Director

Responsibilities:

• Database engineering for an Internet Media startup company for the Health Care industry - Responsible for database architecture, design & implementation using SQL*Server and DTS for a startup company dat was supposed to explosively grow.
• Successfully produced a Proof of Concept / Feasibility study for a product dat used DICOM format to create an early IoT archive and provide secure access to digital images from MRI, CAT, X-Ray, PET and other medical devices using DataStage to move data.
• Provided an API to extract data from MUMPs healthcare systems; however, the sales never reached expectations and the company folded after initial financing exhausted.

Confidential, San Francisco, CA

Senior Applications Architect / Database Team Lead

Responsibilities:

• Activities include: Lead a team of 4 Senior Data Warehouse Engineers in developing, enhancing and maintaining 23 existing data marts. Create a strategic plan for technology convergence and merging of multiple data marts into a single enterprise-wide data warehouse.
• Re-engineer existing products and implement a more streamlined Informatica data mappings flow and DW physical data model. Interview business and analytic users and write requirements.
• Design, implement & performance tune principal database and data flow for OLAP addition (actually a HOLAP hybrid ROLAP and MOLAP solution) to a major product using SQL*Server. Implement a company-wide development project prioritization & workload organization scheme.
• Responsible for primary DB vendor relationship. Provide company-wide on data warehousing concepts, possibilities, and strategies. Use ERwin to re-design and re-architect existing products in Oracle, Teradata, MicroStrategy and clustered SQL Server ODS environments. Acquire, hire, mentor and train database team.

Confidential, Thousand Oaks, CA

Enterprise Architect / Director

Responsibilities:

• Predictive Technologies for a conglomerate of Internet Media companies. Totally responsible for Data Warehousing vision, strategy and implementation wif a goal of understanding the business and creating competitive advantage. Activities include: using my sales experience to continually sell the project (public relations support) to internal sponsors, hire and lead a team of 8 developers, 2 QA, 3 production personnel, and a project manager, build a centralized reporting infrastructure; cost-justify, budget, acquire, design, implement and roll out a 2 TB ODS and data warehouse on NCR Teradata platform, migrate existing reports from SQL*Server and implement Teradata’s CRM tool.
• Responsible for vendor tool choices and creating & maintaining vendor relationships. Confidential ’s projects included nightly data acquisition onto a NetApp (Network Appliance) Storage Solution, homegrown rapid ETL using PERL, a massive Internet Logical Data Model (LDM), basic reporting, OLAP, cubes, the beginnings of Data Mining and Statistical Analysis. Instrumental in project prioritization, dashboard and database design (using third normal form, star-schema dimensional modeling, and RFM modeling), functional design and process flow (including data mappings), installing MicroStrategy OLAP, Crystal reports, NCR’s eBusiness Logical Data Model, report prioritization, building the team, managing expectations, negotiating strategic alliances, etc.
• Projects included: OLAP rollout, website optimization, internet ad inventory forecasting, ad placement analysis, traditional media (TV, Radio, Billboard, print) ad response analysis, EIS dashboard creation, evaluation and rejection of Omniture and WebTrends, etc. Interfaced wif source systems and secondary data marts using Microsoft SQL Server extract, MDX functions, SQL load tools and DTS packages.

Confidential, Lisle, IL

Business Technologist / Applications Architect / Technical Evangelist

Responsibilities:

• Speak to CEO’s and CIO’s of large (billion dollar plus) companies and convince them of, or educate them in, the business value of CA’s Applications and Data Warehousing solutions. Perform analysis of existing Data Warehouse systems, recommend enhancements and process solutions using Computer Associate’s software and consulting services. Trained in the use of Platinum Metadata Repository and Decision Base ETL.
• Provided custom services to Blue Cross / Blue Shield of Illinois and Texas (healthcare industry) to enable Fraud detection and prevention. Trained in architecture and use of Erwin. Sold Erwin to clients as a data modeling tool and as a foot-in-the-door to create sales of other CA products and services.

Confidential

Responsibilities:

• Confidential specialized in providing services for direct database marketing purposes and driving revenue from high impact analytical data models. Our databases ranged from 20 GB to 1200 GB (at a time when the largest disk drive available was 2 GB in size) usually in ORACLE on Sun platforms, but also including: DB2 PE and an 8TB Teradata solution) using client-server techniques.
• Services included: Solicitation, Segmentation, Scoring, Churn/Attrition, Acquisition, Response, Cross-selling Fraud, Bankruptcy and other Predictive modeling for marketing purposes. CRM, Campaign management, and Sales Action management capabilities were often provided. Clients included the largest companies in the telecommunications, financial, credit card, cable and insurance industries. As prelude to our work we often built the marketing database.
• Director of Business Unit - Latin American Sales and Implementation Responsible for: initial client contacts, RFP responses, full sales cycle management, contract negotiations, pricing, budgeting, resource allocations, P&L, project specifications, design, momentum, development, implementation, testing,, rollout, long term maintenance, technology transfer and day-to-day management. Up to 15 subordinates of 12 developers and 4 Oracle DBA’s reporting to me. Presentations at national database marketing conferences.
• Successfully sold and deployed a $3.5 million 14-country Data Warehouse system for the regional and local marketing departments of a large international bank for purposes of building a World-wide Enterprise class custom CRM system including: