Career Summary

Distinguished technology change leader with a proven 18 year history delivering highest quality of Data Architecture; to include Big Data integration and business intelligence projects. Many MDM / technical data management deployments with successful leadership in a diverse range of technologies. Proven leadership in technical project management and software full life cycle development.

Selected as Hortonworks Integration Partner in 2014!

Experienced in large scale projects such as, business process re-engineering, Big Data Analytics, MDM Architect, Business Intelligence, Data Warehouse and IT Strategy. Over 12 years’ experience managing with Agile project control methods to gain predictive project objectives and deliverables. Leadership style is “lead by example”; by developing team builder and team leader core objectives.

Experienced with Big Data tools, HDFS 2.1, Hive, Spark/Spark SQL Hbase, NoSQL, Falcon, Yarn and Oozie with BI reporting and analytics consumed by data visualization tools such as: Business Objects Enterprise 4, MicroStrategy and Tableau.

Performance based HDFS2.2 and Cassandra data processing architecture derived from innovation in performance metrics algorithms design supported by data research. Data mining skills include research and development for foundational requirements plans aligned with Business Use Case methodologies.

Architecture design values are foundational for building quality operational, technical, and executive level solutions. Expert results derived from proven organizational, communication, presentation, and facilitation skills.

Key Accomplishments

Architected Big data, ERP Conversions and BI systems for five corporations and US Navy. Managed and Architect more than 15 projects as Lead Architect and Technical Program Manager. Style of leadership as team builder and lead by example. New development of Big Data MDM / Metadata Management System that adds machine learning to segments and categorized data within clusters to minimize search whole data cluster.

Experience with Hadoop HDFS and use of MapReduce, YARN, Hive, implementations in cloud.

Requirements analysis, blue printing, estimating and project planning deployed three Hadoop and Hortonworks HDFS 2.2 Apache Open Source big data tools deployed via cloud environments for prototype testing and data migration to include cluster development, master data management and data architecture designs.

Foundational approach in data quality processes and data analysis profile definitions and metrics developed to ensure best data sources for Hortonworks and Big Data source to target mapping. Technical Team leader for many large scale Big Data projects. Manage and architect data migration requirements; to include complete data analysis, quality assurance of data and profiling data for migration to new ERP system for large corporations.

Architecture Style and Approach:

Strategy: Use of detailed data quality and data profile processes to provide clean data sets as source to target processing in ETL stage, that ensures the logical and systematic conversion of business, customer or product requirements into total systems solutions with acknowledgement to information management and technical architecture. Performs functional analysis, timeline analysis, trade, and benchmark and interface definition studies to formalize customer requirements into systems architecture specifications. Scale processing of data in layers is required to effectively migrate data from source to target systems in batches that can be cleansed and profiled correctly.

Agile Approach: Use of Agile Stories and Sprints i.e.: overlapping processes to manage development teams and delivery. Conduct Scrum meetings as leader. Agile project plans developed and tracked.

Best Practices: Drives technology solutions and standards through the organization; interacts and communicates effectively with internal and external customers as needed to clarify business, operational, or technical requirements to include: Serves as a mentor within the Company facilitating the transfer of technical knowledge and an evangelist for adopting new standards, techniques, products, and methodologies within the Company. Assess industry standards for information models, and where appropriate incorporate them into our information architecture standards. Assist in the definition the governance architecture necessary to allow data stewardship to truly be owned by our business partners.

Project Leadership: Ensures that IT projects adhere to the principles, guidelines and standards established by Enterprise Architecture by Maintaining ongoing communication with project teams, verifying what was designed was built and adjusting the solution architecture as appropriate throughout the project.

Ensuring the semantics of project level definitions and schemas are mapped to the enterprise viewpoint taking into account permissible variation across business units, addressing gaps, security, and regulatory compliance and mitigating risk. Serving as advisor for “in trouble” projects that need technical help delivering pragmatic results that contribute actual and perceived value to projects.

Continuous Learning: Deliberate in the process of learning new technologies and how they apply to the business. Actively participates in industry related technical communities and standards bodies. Capable of representing the technical interests of the company in external forums.

Technical Highlights:

Big Data and Data warehouse Architecture:

•Hadoop tools: HDFS 2.1: Yarn, Falcon, Flume, Ambari, Sqoop, Zookeeper, Storm, Spark, >1 to 3 yrs

•Hbase, Hive and Cassandra dbs development: 3.5 yr.

Database Designs:

Distributed Data Cluster Schemes with Hadoop, running with Hbase, Cassandra and Hive. Also developed many traditional Star Scheme DW with Teradata, SAP BW, Neteeza and Oracle

MDM and Data Governance

•Ten years of experience in the construction of highly transactional, mission critical applications in heterogeneous environments/architectures for multi-user systems from an application, data, or infrastructure perspective.

•Traditional MDM tools developed: SAP MDM 4 yrs. and IBM MDM 1 yr.

•New Big Data MDM development: Working with Hortonworks Open Sources: Developing Metadata Management System that adds machine learning to segments and categorized data within Cassandra DBS and Hive DBS to minimize search whole data cluster to pull research data based on extended data mapping attributed added to data when data is stored and synch by Falcon and ZooKeeper in HDFS clusters.

Business Intelligence Architecture Experience:

•16+ years experience developing analytical reports, kpi’s, dimensions, facts, data models, and data marts with BusinessObjects and other metrics reporting tools and dashboards as listed.

•BI developer and Architect 16 years: BI Tools: SAP BusinessObjects 4.1 stack, SAP Explorer 4, SAP Data Steward 4, SAP Dashboards, SAP Web-Intelligence 4.1, MicroStrategy Analytics Desktop 9.4,

•SAP BusinessObjects 4.0 > 5 yrs, SAP BusinessObjects ADMIN, Developer, Dashboards, Configuration

•SAP BI- 4.0 to 4.1 (6) implementations: BO Enterprise 4.1, BO Data Steward, 3 Implementations, BO Data Services, 5 implementations. ElasticSearch and Kirbana BI tools used on Cassandra and Hive / HDFS.

Create Business Requirements, POC and Technical Project Plans:

•Previous experience and solid understanding of business requirements and the process of translating them into well-engineered and integrated technical solutions using Service Oriented Architecture (SOA) and reusable components; such as Kafka, and MQ, Json Sub/ Pub Brokers

Business Models and Data Modeling Development:

•Knowledge of Unified Modeling Language (UML) and Business Process Modeling Notation (BPMN)

•ERWIN Data Modeling 12 yrs, with UML CASE Tools, VISIO Diagrams, Data Dictionaries

•SAP HANA data sources processing To include: Design Data structures with metrics analysis of multi-dimensional data cubes. Hana Studio 1 yrs.

•DBS Integration: Oracle 11/`12g, IBM DB2, Neteeza, SAS, SAP BW with Hadoop, HIVE, Cassandra and Hbase

•DBS Structures: OLTP, ODS, Star Schema, Snow Flake, party, ROLAP, MOLAP, OLAP, RAPID MARTS

•Hadoop.and Hive DBS: #3.5 yrs

•Cassandra; #2 years

•Teradata 8 /9 # 4 yrs,

•SAP BW 7.3 DBS #5 Years

•SQL 2008 R2, and MS SQL 2012R2 #7yrs and Oracle 11g, 12g DBS #7 years

•Code skills : No SQL, SQL, MS T SQL,HiveQL, Java Class Objects, JavaScript, MS Visual Studio 2010

•Big Data APIs; Rest API for Strom and Splunk, Kafka(Java Class) API for Kafka Messaging

•Analytics and Data Visualization: R Analytics Mahout Libraries, BI tools such as: Tableau, BusinessOBjects, MicroStrategy ; To include Mobility BI deployments.

•Data Search - Queries:, Cassandra Search Engine Custom build on key value pairs grouped in object sets,

•ETL Transforms and Data Analysis Tools: HiveCL, ElasticSearch, Pig, Oozie, T SQL, SQL, Informatica Big Data

•API: Applications Developed: REST, SOAP, SOA, Jboss, MQ Brokers, J2EE, Python, ESB

• Infrastructure Architect: Worked as Network Engineer in 90's (Cisco, NetApp, EMC, Brocade, Bay Networks, Nortel) Design many Telecom WAN 3 tired systems with CISCO Routers and Switches. Frame Relay, ATM, OSP.

•Developed Telecom Data Centers and Networks, (1995 to 2001)GSM Cellular networks infrastructures for Sprint, US Cellular, Nokia and Motorola based technologies. US Cellular I billion Dollar Startup (Aerial) was launched in 1997 and I was Lead Application Architect and Program manager for 8 development teams and 150 supporting engineers.

•

•Developed Systems Infrastructure for Global Data Storage and Global Data Warehouse: Bp Oil Co and ATT, Sprint. Idaho Power, Navy, Wells Fargo Bank, and many other companies.

•Network Monitoring: Design Global Telecom Monitoring Systems: Ameritch, ATT, Sprint< AON Insurance, BP Oil Co, Motorola ( Monitoring Software Tools: HP OpenView, Cisco Works, Nortel/ Bay Networks, Juniper Infrastructure / Cloud Clients: Google, Amazon, AT&T,

•Education

Marquette University, Milwaukee, WI-1980-1983, BSCS - Computer Science Major, Business Minor

Moraine Valley College, Palos Hills IL 1981-1982 – Computer Science Major

Training Classes: Hadoop, Hive, Flume, Oozie, Yarn 2.1, Hbase, Speak and Stream (2011,2012,2013 to 2014)

Professional Experience

Please note that 75% of these projects have been contracts through my company EnlightenTechWorld.com.

Hortonworks Integrator, Phoenix AZ July. 2014 to Present

New development of Big Data MDM / Metadata Management System that adds machine learning (Mahout) to segments and categorized data within Cassandra using NoSQL to retrieve data from Hive (within Hadoop clusters) to minimize search of data clusters. Design criteria is to pull research data based on extended data mapping attributed added to data when data is stored and synch by Falcon and ZooKeeper in HDFS clusters. Advanced metadata processes managed in Hive Stinger synchronously. This new MDM design includes Implementation of Falcon data governance via Zookeeper regional data cluster organizations and managed by Ambari and Yarn 2.2 Future state to included machine learning to automatically categorize data more quickly and add multiple data attributes. End goal is to make data research algorithms much faster than currently available processes for use with Tez in data mining. Data that is unstructured becomes highly structured and categorized in a multitude of definitions, which shortens cluster query times.

Introducing Apache Tez for the fastest Hive ever! Apache Tez re-imagines the original MapReduce for interactive query capabilities to meet the needs of users of the most widely-used data access engine for Hadoop: Apache Hive.

Data Governance with Apache Falcon a framework for simplifying data management and pipeline processing in Apache Hadoop®. It enables users to automate the movement and processing of datasets for ingest, pipelines, disaster recovery and data retention use cases. Instead of hard-coding complex dataset and pipeline processing logic, users can now rely on Apache Falcon for these functions

Stream Processing with Apache Storm is a distributed real-time computation system for processing fast, large streams of data. Storm adds reliable real-time data processing capabilities to HDP 2.1. Storm in Hadoop helps capture new business opportunities with low-latency dashboards, security alerts, and operational enhancements

Operations with Apache Ambari: HDFS 2.1 includes the very latest version of Apache Ambari and which now supports Apache Storm, Apache Falcon and Apache Tez, provides extensibility and rolling restarts, as well as other significant operational improvements.

Wells Fargo Bank, Phoenix AZ and Des Moines IA (*Contactor 8/13 to 7/14

Develop ELT, Reporting Metrics and analysis for SOA based messaging via custom brokers and Operational Data Marts, Design BO Universe and data modeling for 4 sub projects. Develop ELT models with BODS 4.1, ETL POC, Universe POC, Data Merge (CDC) delta, define source and target data tables to joins for aggregate data structures to base reporting for CRM and operational data applications supporting residential and commercial electrical services.

Review and make improvements for Servers. Databases. SOA systems, Data Models, integration points and analytics to support robust mortgage loan processing systems platforms within Wells Fargo CORE Systems. Analysis of best practices for COBIT IT audit standards, risk analysis and application of design patterns. BI reporting performance metrics collected in data mart, from various monitoring tools and developed in MicroStrategy Analytics Desktop 4.9 Dashboards. Audit scored rated in Excel and added to Dashboard reports.

US Navy Logistics, Mechanicsburg, PA (Contractor) 1/2013-to 6/2013

•Roles: Big Data Solutions Architect: SAP HANA Administration, POC with Hadoop HDFS Data warehouse and related technologies to include: Business Objects Enterprise 4. Hadoop and BI

•Developed HIVE and Map-reduce tools to design and manage HDFS data blocks and data distribution methods. Multiple Data Sources: Teradata, Oracle and SAP BW, DB2 integrated (ETL feeds) to HIve DBS running on Hadoop HDFS foundation.

•Stand up new Hadoop HDFS cluster environment for Navy Logistics program.

•Deployed HIVE, PIG and H-catalog tools for data management on Hadoop HDFS clusters

•Developed 5 ( 2.5 terabyte x 5) data clusters with multi-sources databases

•Design and test new MapReduce processes for data analysis feeds (Sqoop and Flume) into BI reporting tools BusinessObjects 4 and Tableau.

•SAP HANA data architect with cube processing and

•SAP BOE 4.0 administration and analysis development

•BI Report designed with SAP BO Web-Intelligence Reporting, Sap BI Dashboards 4, and SSPS.

•Dashboards 4 to Universe IDT integration. Data Services Configuration and installation

•BusinessObjects 4 Installation and Configuration, Administration Training

•Install and implement SAP MDM Tools and configure with Hadoop and Neteeza DW.

•Design Architecture plan for MDM: Multi-Sources DBS as listed:

•Sqoop data import to HDFS: Data sources integrated from Oracle, Neteeza, Teradata and feeding Hadoop clusters developed on Hive DW Structure.

Avent, Chandler, AZ (Contactor-/ Remote Part Time) 10/12 to 3/2013

Role: Architect MicroStrategy BI-Client Server deployment. Re-developed dashboard reports from BusinessObjects 3.3 to MicroStrategy 9. Implemented MicroStrategy Server and Client and setup security, roles, administration and report deployment procedures. Implemented new financial Metrics and designed new data mart for BI reporting

Florida Power and Light: Juno Beach FL. (Contractor) 7/2012 to 1/2013

Role: Data Architect: Connectivity to Hive and Cassandra Platforms for data analysis used SQL and NoSQL integrated with multi-data sources. Data cluster design and deployment.

Other Role: SAP BI Architect: SAP BO Data Steward Implementation, Cassandra, Hive /Hadoop data analysis. SAP Business Objects 4 report performance metrics developed .-

•Manage technical and business rules issues for Big Data design blueprint (Cassandra and Hive)

•Design, Develop and Implement: Cassandra, and HIVE, ( Hive running on Hadoop)

•Hadoop and Hive database modeling and ETL schemes developed and tested.

•Data sizing metrics developed Cassandra (NoSQL) analysis from migrated OLTP database.

•Development and administration ETL cube processes with Oozie and Informatica Data Exchange

•Cassandra sourced multiple data schemes such as SAP BW, Teradata DBS.

•ETL processes designed and deployed for Production, QA and Development landscapes

•MDM Architecture Deployment Plan and Blueprint recommendations (SAP MDM)

•BO 4.5 Upgrade and Installation Production Cluster Windows 2008 Server

•Setup and Debug CTS+ BW Promotion Management Tools and Override Functions

• Size and best Practices for MDM with Oracle, Teradata DW and SAP BW

Idaho Power Company, Boise ID (Contractor) 02/2012 to 7/2012

Roles: Sr. SAP Business Objects DW/BI Architect, BO Data Steward;- Data Archive Teradata

•Designed 2012 SAP MDM and SAP BI strategy and architecture to move client Big Data BI analysis. Used Data Services to move data in to HIVE and Hadoop Clusters.

•Deployed SAP BI /Data Warehouse with Data archives and Teradata DW data models for BI DB design.

•Developed INFORMAICA PowerCenter and Data Exchange ETL architecture for Data loads

•To Teradata DW and Data Mart Prototype Data Models

•And Analytics DBS for distributed HDFS DB models.

•Data Modeling for both Teradata and new DW

•Designed new BI Databases with Erwin v9 - Star Scheme, 3 n form

•MDM POC for Hadoop architecture design and implement

•Business Objects 4.0 Enterprise Web-Intelligence Reports developed for POC

•Business Objects Data Services XI 4.2 Admin, Installation, Training, Development

•Design BO analytics and KPIs, and BOE XI 4 Universes, facts, and dimensions tables:

•Design BOE Universe methods to increase reporting speed

•Design Analytics Database Models in ERWIN-OLAP / Star Scheme database Models for Analytics with Teradata methods

•Installed and configured BOE XI 4 Premium, Crystal 2011, Dashboards 4, Data Federator, Explorer, BOE XI 4Mobile

DAWN Foods, Jackson MI (Contractor) 07/2011 to 11/2011

Role: Sr. Data Services Lead 3.2 / 4.0, Data Analysis. ETL Architect Lead and BI Reporting Lead for SAP Hana deployment and Administration, SAP ECC 7.3 installation assist, SAP BW configuration Roles: SAP Hana Admin, SAP Data Services 4.0 Lead, SAP Data Reporting, SAP ECC Data Migration, Metrics Analysis, Data Analysis, MDM

•Blueprint Roadmap for SAP MDM, BI and BW architecture

•SAP HANA deployment and administration

•SAP BO Data Steward implementation

•Data Mapping and Blueprinting steps team effort (Team leader for 10 ETL developers)

•Core project Duties: SAP Data Services ETL processes designed and team lead to migrate complete ERP data source JBA tor SAP ECC 7 (with Sap All In One solution deployment of IDOCS in data Services 3.2).

•Direct Report to PMO Team for Corporate Data Migration (Project Falcon )

•Content BI reporting : SAP SCM, SRM, Vertex, MM

•Managed team of 6 DS developers

•Report to Director and PMO (Project Management Operations Board )

•Manage technical and business rules issues

•Architect JDA Legacy ERP to Sap ECC cut over and deployment processes

•Business Objects 4.0 Installed and sample report developed in WEBI ( Five reports)

•Data Services 4.0 Platform installed and developed 4 Web Intelligence reports

•Design Data Migration processes with SAP Data Services XI 4.0 tools and SAP BOE XI 4.0 Metadata Analysis, SAP BO Rapid Marts Sales, AR, MM

•Develop MDM Plan for legacy Data and move cleansed data into new MDM structure

•Data Cleansing Processes developed with Data Services QA Module

•Data Mapping and Blueprinting steps for SAP IDOC for SCM, SRM, for SAP ECC 7

•Data Services IDOCs input of legacy data to SAP ECC 6 and BW 7.3

Bechtel Corporation, Glendale AZ (Contractor) (Project overlap with INSIGHT) 04/2011 to 07/2011

Role: Data Metrics Analysis project to support Performance enhancement of terabyte Sap Info-cubes.

Re-design BW cubes and increase Business Objects reporting speeds with deployment of SAP HANA Appliance.

•Design of SAP BW Info cubes, Info Objects, info-sets, info-objects optimization in BW:

•BI reporting Content: SAP DSOs, BW cube Aggregates, and Design Loading of Data Delta Points

•Optimized SAP BW Info cubes and DSO for SAP Hana and SAP BusinessObjects 4

•BWA appliance configuration with BO Explorer, migrated to SAP HANA landscape

•Optimized SAP BOE Reports WEBI with BW info-cubes and SAP HANA appliance

•Design BOE reporting queries, data aggregates and BEX Queries

•Design BO analytics and KPIs develop and modified for performance data processing

•Design BOE Universe methods to increase reporting speed

Insight Inc., Tempe, AZ (Contractor) 11/2010 to 7/2011

Role: SAP MDM Architect, Lead Data Services 3.2 and BI 4.0 and Data Architect for Insight USA. SAP Rapid Marts Installed, and Customized, Blue Print for BI and BW Architecture and hands on implementer

•SAP HANA deployment and configuration, POC for dimensional data analysis (Cubes)

•MDM Architecture for DBS Sources: Teradata, oracle 10g, MS SQL 2008 for HANA processing

•BI Content Reporting SAP SCM, SRM, MM, AP/AR, FICO with Data Governance standards

•SAP Basis Admin support Architect for Security roles and

•Configure Transports configuration, new ECC Upgrade from 5 to 6.

•Other ETL Tools used Informatica Power Center 9 and SQL SSIS

•BusinessObjects 4.0 Enterprise Web-Intelligence Reports developed for POC

•BusinessObjects Data Services XI 3.3 (ETL Tools) Admin, Installation, Training, Development

•Data Services Xi 3.2 Training and Admin, - Expert; LSMW 3 months

•SAP BW with BEX to Business Objects XI integration and architecture

•BOE XI 3.3 Sp2 and SAP BW Integration kit with BEX info-objects and Sap cube data.

•BOE XI 3.3 CMS on MS SQL 2008, BOE XI Reporting and Universe Design

•Global BI architecture and design details confidential

•Xcelsius 3.3 installation and reporting with BW BEX queries integration

•Xcelsius/ Dashboards 4.0 Beta test with Universe, Install LCM v1

•Design criteria for BusinessObjects Explorer Blade and BWA Blade Deployment Architecture

•Integration Data Services Xi Data Migration with Sap ECC via IDOCS interface

MRG- Marine Resources Group., Seattle WA (Contractor) 9/2011 to 11/2011

•Evaluate SAP BOE XI 3.2 Upgrades and Hardware to SAP BusinessObjects 4.0

•Evaluate BOE LCM tool to move BO reports

•Develop new BO reports in BO 4.0 IDT tools

•Universe design data elements, metrics and hierarchies BI content reporting SAP

•Create BOE XI / Web-Intelligence Reporting Development

•BI Requirements score cards, detailed functional and technical documents

•SAP BW Data Modeling for Infobjects, Info cubes and Info sets, Info Spaces

Coca-Cola Corp., Atlanta GA- (Contractor) 6/09 to 8/2010

Role: Sr. SAP BI and BW Data Architect for Coke Global Distributors MDM Project SAP BW

Architect for MDM plans and transformations for BI ETL for Global BI reporting of Coke International Bottling Corp.

•BOE XI 3.1 Sp2 and SAP BW Integration kit with BEX info-objects and Sap cube data. BI reporting Content: SAP SCM/ SRM/ MM/ ECC / FICO / CRM

•BOE XI 3.1 CMS Cluster with Oracle 11i RAC.

•Global BI architecture and design details confidential

•Teradata Data Source for reporting trends

•Informatica PowerCenter 8 used to develop ETL processes for data migrations globally.

•Xcelsius installation and reporting with BW BEX queries integration

•SAP Business Objects DS 3.2 Lead, Implemented, designed ETL

•Teradata 9 Data Migrations to Oracle and SAP BW

•Informatica Power Center ETL Architect for BI data marts

•SAP BO Web-Intelligence Implemented, SAP SSO implemented

•SAP BO Explorer Blade Implemented and Architected Design Criteria

•SAP BW Data Modeling for Infobjects, Infocubes and info sets, Info Spaces

SAP America : (Contractor) 10/2009 to 6/2010

Role: Business Objects Team Leader and Sr. BI Architect for multiple SAP BO projects

Role: DS Lead 3.1 - Implemented SAP DS Rapid marts BI & ETL Architect: SAP & Informatica

•QA Process to fixed, test and deploy Voyager latest build 3.2

•Architected many new BOE XI 3.1 systems and designed Universes

•BusinessObjects Data Services (ETL) used for data migration schemes

•BusinessObjects Upgrades from XIr2 to XI 3.2

•BusinessObjects Universe Design and Report Design/ Development

•Crystal Reports 2008 Development, Xcelsius 2008 Reports Development

•SAP Business Objects BI 3.2 (Like BOE 3.1 XI) Implemented

•SAP Business Objects Data Services 3.2 Implemented

•Integration to BW Data Sources ( Info sets)

•Informatica Power Center 8 Implemented

PhoenixFirst.org - Phoenix, AZ (Contractor) 4/2008 to 9/2009

Role: ISMS Server 2008 Architect, Admin, Data Admin, Systems Architect, (See list of managed projects) Repaired Fiber Optical Network and Infrastructure with Wireless Point to Point Internet Feeds to Campus. Upgraded Infrastructure, BI reporting, Oracle Dbs 10g and Windows Servers to WIN 2008 Server R2 X64 ( Ten WIN servers). Upgraded MS Windows Exchange to 2007.Redesign Campus Fiber distribution and WEB firewalls with new Firewall appliances. Corrected AD security access, RAS, and Backup schemes for applications and servers. Data migration from legacy servers to Win 2008 servers used SQL SSIS tools.

FreeScale Semi-Conductor: Tempe AZ (Contractor 9/08 to 3/09

Role: Sr. Lead off shore team, Lead BI, ETL and Data Modeling Architect for Teradata DW

•Data Modeling Architect with ERWIN 7.2 Data Modeler on Teradata DW

•Oracle 10 G Database, migrated to Teradata Data-warehouse.

•Developed Informatica 8 ETL processes to move data from Oracle 10G to Teradata DW.BI content reporting SAP SRM/ MM / CRM/ Sales

•WEB portal logistics management applications.

•Managed Off-Shore team in India and local team in Tempe AZ.

Chase Bank, Columbus, Ohio (Contractor) 11/07 to 1/08

Role: Sr. SOA and BI Architect and Developer with Data Security

Role: Sr. BI / BW Architect and Enterprise Capacity Data management consultant

•Architect Storage Capacity Management Enterprise Solution

•ETL Processes Designed with Informatica Power Center

•Collected statistical data from Teradata DW and Falcon Store EMC DB clusters

•Informatics ETL processes developed for multiple Databases.

•Reporting on 66 data centers and 150,000 VTL, EMC Cluster DBS

•Business Objects reporting for forecasting database, utilization with data mapping

•Teradata ETL and Date warehouse models and more

•Architect Storage Capacity Management Enterprise Solution

•ETL Processes Designed with Informatica Power Center

•Collected statistical data from Teradata DW and Falcon Store EMC DB clusters

•Business Objects XI r2/3 Universe and WEBI Reports

•Business Objects XI 3 / CMS Cluster on Oracle 10 G RAC Cluster

•Informatics ETL processes developed for multiple Databases.

•Reporting on 66 data centers and 150,000 VTL, NAS, DAS devices; and EMC cluster servers.

•Symantec / Veritas Net-backup reporter and Command Center pilot.

•Business Objects reporting for forecasting database, utilization with data mapping source

•Oracle 10G, and XML databases in 500 TB cluster data storage (EMC)

Sears Holdings, Hoffman Estates IL 3/07 to 10/25/07

Role: Technical BI and BW Architect: Managed 4 technical teams

•Design web portals for B2B and C2B customers biding on home improvements services & fleet logistics

•Designed Multiple web portals with Oracle Portal Server and

•Bpel integration with Oracle SOA Integrated Oracle SOA and SAP ERP (mySAP),

•SAP/BW data source management for REMEDY CRM and SAP Fleet Management via DB2/MQ series,

Allstate Insurance Co. – Lake Forest IL 12-05 to 8-06

Role: Sr. BI Architect and BW ETL designer

•First prototypes NI reports in IBM Cognos and Crystal reports

•Migrated reports and data sources to develop Business Objects Universe

•Data analysis in JDE CRM for Marketing Managers for branch office data and related CRM data

•Various migrations to Crystal Xcelsius from legacy Cognos reports.

Windsor Mortgage Company – (11/05 to 12/06) Oceanside. CA (Part Time remote project)

Role: Lead Data Architect and .NET and Metrics BI Developer

•BI Metrics and data mart system designs with Business Objects,

•Act 2007 CRM, and various loan processing applications.

•Designed Data Marts to analyze trending metrics for various loan types

•VPN Network Server to Calyx Software Mortgage Processor.

Veritas Software, Sunnyvale CA 5/04-10/04

Role: DW Architect and BO Universe Designer with ERP Integration to include ETL

•Informatica Power Center ETL processes designed for data loads

•BO reports based on business requirements support for sales, PSO and accounting

•Designed new BO Universe to support current and future business requirements.

•(Dimensions and Measures) for various integrated report development.

•Siebel database reporting metrics with Siebel Analytics

•BO Web intelligence, BO Designer 6.1 and BO reporter 5.1.

•BO development processes established, test environments and

•requirements analysis processes.

•DW processes designed with ETL methodologies.

•Oracle Financials Data integrated

BP Oil Company: IL, TX. OK, London- UK, ASIA, Global 2/01 to 5/03

Role: Primary Global BI and DW systems Architect, Project Manager

•Designed and developed Dashboard site for BP to monitor and report 48 countries 4 DW databases, 2000 servers, Checkpoint firewalls, Proxy Servers, IIS Webs Servers, Websense.

•BO Application Foundation Builder and SDK Integration with Business Objects

•SAP Business Query, DW OLAP Design, and MS SQL Databases integrated to DW.

•Global ETL data management with custom SQL and Data-stage ETL

•BI reporting with Business Objects Enterprise and Web-intelligence.

•Auditor, Designer, and Developer of six global BusinessObjects Universes.

•Informatica Power Center and Microsoft DTS used for ETL for two data warehouses designed for global data collection

•Environments managed by the Dashboard: AIX, Solaris, WIN 2000 Clusters, HP/UX.

GE Capital-AFC - IL, NJ 9/00 – 2/01

Role: Project Lead develop for implementation of Support WEB Enabled Data-Mart Security

•Oracle ERP, Oracle Fleet, Oracle 8 Databases and Web Site portals constructed

•Designed Metrics Tools to measure performance on WEB sites using

•Oracle CRM schemes developed.

•Monitoring of daily WEB Server Health and Performance.

•Code developed in Java Script and JAVA Brokersfor Apache web portals. .

•ETL Migration and data integration from Informatica DW to Oracle DWB.

Motorola Center, Scottsdale, AZ, Schaumberg, IL 04-00 to 09-00 and 02-01-to 06-01

Role: Project Leader, Global Web Security manager

•Joint Venture Motorola DB security projects in global regions (EU, Asia, SA, NA, England, Israel)

•Business Objects universes designs and performance metrics tracking systems for enterprise corporate business systems management Refined network security standards and implementation of Network Security.

•WEB Firewall Security designer for Global Moto Sites

Sprint ION Project: Overland Park, KS Dallas, TX 2/99 to 5/00

Role: Infrastructure Architect: Project team to deploy Operations Provisioning and 11 distributed databases

•Sprint ION Project- $175 million dollar project.

•Design of New customer ordering system with provisioning interfaces to legacy systems.

•Extremely Complex JAVA / J2EE EJB Portals with JAVA Beans and J2ee SDKs.

•Multiple EBJ Sun Solaris Servers with XML message queuing processes.

•Business Objects and Application Foundation Builder SDK tools used to design seven distributed Managed security and QA/QC processes and Change management design processes

SBS/ Ameritech Corporate: MI. IL. IN, OH, WI 1/99- 6/99 (SBS owned in 2000)

Role: Infrastructure Architect and Project Manager and developer (Managed 5 teams)

•Complex Web Portal and Integration Environment for Telecom Call Center:

•Development of Application Servers: fail-over processes, to include DEC/ UNIX

•Database Clustering utilities and TUXEDO connection manager.

•Production support response for “system outages” with 98% up time.

•Oracle WEB Server 3.1 and ICAS / JAVA and Tomcat EJB (Java Beans).

•Designed Intranet Dashboards. Perl 5 script used to deploy code modifications.

AON Insurance Co., Chicago IL, UK and global 0/97- 5/98

Role: Infrastructure Architect Technical Manager and Lead Architect for enterprise database ERP (PeopleSoft) management system and WAN architecture for a global insurance company.

•Global WAN System Design: manageable distributed databases and saleable network systems and special applications solutions adaptable to extreme growth of AON.

•$250 million dollar Systems Upgrades and server upgrades. with complete WAN re-design to add system fault tolerance and disaster recovery.

US Cellular/Aerial Communications: IL, WI, FL 8/96 to 7/97

Role: IT Director I billion dollar start up project- Promoted to Technical Director in charge of Systems and Application development.

•Other duties: Managed operations deployment Group.

•Managed and acted as Lead Design Architect for eight software development projects and Network Operation Center applications with only 28 people on my core development team.

•More skills on BI tools and Web Portal Servers not all listed due to space limitations!

Contact this candidate