PERSONAL:

• Experience: 20 years in I/T with specialized skills in Data Warehousing, Business Intelligence, Application Development, Infrastructure, I/T Management, and Project Management.
• Technologies: COBOL, JES, JCL, DB2 z/OS, DB2 LUW, CICS, SQL/DS, OS/390, z/OS, VM, AS/400, UNIX, AIX, WINDOWS, IMS/DB/DC, VSAM, TSO/ISPF, RACF, Oracle, SQL Server, Cognos, Business Objects, DataStage, Quality Stage, Erwin, Informatica, MS Project, HTML, XML, MS Office, QuickBooks, SharePoint, DataFlux, Linux, MS SSIS, SSAS, SSRS, VMware, PostgreSQL, MySQL, Oracle Exadata, Cassandra, Mongo DB, SAP BODS, Oracle Advanced Security, Oracle Redaction, Oracle Encryption, Active Directory, Power Designer, Guidewire Insurance Suite.

Professional Positions:

• Project Manager I/T Manager Data Base Specialist DW/BI Consultant Senior Systems Engineer Large Systems Specialist Enterprise Data Architect Business Intelligence Architect Internet Business Consultant
• IBM Data Management Pre-Sales Tech
• Cognos Business Intelligence Pre-Sales Tech

WORK HISTORY:

Confidential

Enterprise Solutions/Data Architect

• My role as the enterprise solutions/data architect involves the creation of the architectural best practices addressing data and technology in the context of business processes across AMIG. The position provides leadership and direction for strategic data management and business intelligence initiatives and enterprise information governance. As the solutions architect, I am responsible for developing the strategy and framework to address all aspects of the data life cycle including the implementation strategies for master data management, metadata management, unstructured data, tactical, strategic, predictive and text analytics.
• I lead the selection process for data management technologies and provide consultation to complex projects within the enterprise to ensure compliance with the data management architecture strategy, principles and standards. I lead the design and implementation of the enterprise data warehouse based upon a combination of an Inmon enterprise data model architecture and a Kimball data warehouse bus architecture running on two Oracle Exadata data warehouse appliances.
• Technologies: SQL Server 2008, DB2 z/OS, DB2 LUW, Oracle, Exadata, Linux, z/OS, Active Directory, IIS,
• Java, HTML, Cognos, XML, IBM WebSphere, Agile, Waterfall, SAP BODS, DataStage,
• IBM Business Glossary, Power Designer, Guidewire Property and Casualty Insurance Suite.

Confidential

Project Architect Consulting Contract

• Project architect assigned to multiple Agile, internet, customer facing application development projects related to the Kroger digital customer loyalty program. This program's objective is to enhance the loyalty customer shopping experience by targeting the individual and household with digital ads and coupons personalized to their shopping behavior and buying preferences. My duties include the definition of the business requirements, coordination of the high level functional design and the creation of the reference architecture to the physical level. My responsibilities also include the design of all application program interfaces and candidate services within the SOA environment. In the case of a buy vs. build scenario, I assist with the software requirements definition and vendor product selection process. I am responsible for the implementation of all security requirements and participate in all quality assurance programs. As part of the product development life cycle and toll gate process, I present all architecture and application designs to the technology review board to ensure compliance with the enterprise standards and fulfillment of the overall
• software implementation strategy.
• Technologies: SQL Server 2008, DB2 Z/OS, Oracle V10, DB2 LUW, Cassandra, Mongo DB, Hadoop,
• Linux, UNIX, z/OS, Active Directory, IIS, Java, HTML, XML, IBM WebSphere, Agile,
• Waterfall.

Confidential

Enterprise Data Warehouse Architect Consulting Contract

• Enterprise data warehouse architect responsible for the design and delivery of OLAP cubes, logical and physical data models, data base design, implementation, tuning, dashboards and reporting services in response to defined business requirements. The data warehouse reference architecture was comprised of a SAP ERP OLTP data repository extracted and loaded into an enterprise star schema data model and operational data store then propagated into a series of departmental data marts for reporting and analysis services. The enterprise metadata repository was constructed utilizing a combination of the SAP data dictionary and domain expert knowledge and was used as input to a master data management model.
• Technologies: SQL Server 2008, Cognos 10, DB2 LUW, Unix, Windows Server 2008,
• Informatica Power Center 9.5

Confidential

Data Base Architect Consulting Contract

• Data Architect responsible for the design and deployment of corporate data warehouse and business intelligence solutions and services within the corporate private cloud utilizing unstructured data technologies NoSQL and Hadoop to support 'Big Data' implementations. The standard RDMS technologies of Microsoft SQL Server, Oracle, Postgres and MySQL were also included in the technology stack running within the SOA virtualized environment under the control of VMware's VMotion and utilizing high performance data management VFabric products SQL Fire and GemFire. This effort supported the corporate directive to provide lower infrastructure cost of shared resources, deploy products faster, scale resources as needed, lower maintenance costs of hardware and power, provide resiliency and redundancy with automatic failover to another data center to support highly available products and services.
• Technologies: VMware, VMotion, Cognos, Oracle 11g, Windows 2008, SQL Server 2008, SSIS,
• SSRS, SSAS, MySQL, Informatica, PostgreSQL, Linux, JBoss, Hyperic.

Confidential

Integration/Data Architect Consulting Contract

• Data Architect responsible for the design and implementation of a data warehouse and a sales data mart for a medical instruments manufacturing company. The data integration ETL mapping components were implemented with SSIS while BI reporting and analysis was accomplished with multidimensional cubes built with SSAS. All ad hoc reports were built using the self serve model by end users utilizing SSIS.
• Technologies: Windows 2008, SQL Server 2008, SSIS, SSAS, SSRS, Data Vault, Normalized Design, Agile.

Confidential

Cognos BI Architect Consulting Contract

• Cognos BI architect responsible for the implementation of Single Sign on SSO using Active Directory for user authentication across multiple domains. This project also involved the merging of multiple data marts and Cognos content stores into a single image as part of a larger server consolidation effort to reduce the footprint size and maximize the utilization of the existing hardware and software.
• Technologies: Cognos 8.3 Report Studio, Framework Manager, Active Directory, IIS, Windows Server
• 2003,SQL Server

Confidential

Data Architect Consulting Contract

• Data Warehouse/Business Intelligence Architect responsible for the design and implementation of a Treasury Management Data Mart for 5th/3rd Bank. The mart functions as the single source for performance reporting and analysis of the Treasury core products sold and managed by the various officers. The mart consolidated data from 4 different systems within the 5th/3rd enterprise to deliver a conformed and standardized format, a star schema within IBM DB2, and populated via ETL mappings utilizing IBM's DataStage product. Standard reporting, and data analysis utilized a combination of Business Objects Web based products and SAP BO Web Intelligence Products.
• Technologies: AIX, DB2 LUW, Business Objects, Consensus for OLAP design.

Confidential

Solutions Architect Consulting Contract

• Architect/consultant responsible for the migration of the eCommerce website, operational support and ongoing application development for Coach Handbags Inc. from the current I/T services provider to the Accenture centers in Cleveland, Cincinnati and India. I was responsible for all design and implementation tasks supporting the data stores associated with the IBM WebSphere Ecommerce software suite used to create the customer facing websites for the United States, China and Japan. My role also included the training of over 30 data base architects and administrators in the processes and procedures, best practices and latest trends for supporting eCommerce OLTP application systems.
• Technologies: Linux, DB2 LUW V8.2, HTML, XML, IBM WebSphere eCommerce

Confidential

eCommerce - Sports Life Franchise Consultant

• This challenge involved the creation of an eCommerce Internet Business Solution for a local sporting goods and apparel startup company. The company had no store front and wanted to concentrate only on Internet traffic. The effort began with the creation of a marketing plan, product, supplier and software selection, domain registration, web hosting, website design and implementation including the loading of the eCommerce product data base. I implemented the architecture to support both business-to-business and business-to-consumer transaction processing including the use of Secure Socket Layer security technology during the checkout process utilizing PayPal software. I functioned in the role as Web Master in order to gain visibility with the leading search engines including, but not limited to, Google and Bing. The goal was to make the eCommerce site search engine friendly and in turn increase its ranking and visibility by utilizing 'natural' search results rather than paid inclusion. I created all supply chain management processes and procedures with the selected suppliers and incorporated the use of the QuickBooks software by Intuit for small business accounting and inventory management. The results achieved came in the form of being recognized by Google as one of the most popular websites based upon search 'hit' counts. As a result of the visibility on Google and the numerous links created on other internet directories and search engines a steady stream of customers found and purchased the products directly from the newly created eCommerce website.
• Technologies: Unix, Oracle, HTML, XML, MS Office, QuickBooks.

Confidential

Senior Infrastructure Architect Advisor

• As a Senior architect advisor on the Infrastructure Architecture team reporting to the Chief Technology Office
• I was responsible for all IBM Information Management Systems IMS and DB2 strategies, architecture, designs and implementations for the WellPoint enterprise. I was responsible for future strategic directions and implementations of IMS and DB2 in a Service Oriented Architecture SOA within the IBM z/OS environments. I completed several projects to consolidate many of the application and web servers using IBM's virtualization technology incorporating the use of IBM's Virtual Machine VM software and z/Linux operating systems. I completed the infrastructure architecture requirements and design for the hardware and software needed to support a large data warehouse project that consolidated four major IMS member claim and enrollments systems into a DB2 operational data store to support query and analysis of member claims data. I supported the middle ware architectures including the WebSphere WAS application servers hosting the Informatica and event publisher applications supporting the ETL and master data management processes into the data warehouse. The data warehouse resided on IBM mainframe Z Series processors and utilized the ZIPP specialty engines for MIPS offload from the general purpose processors.
• Technologies: IBM z Series Mainframes, z/OS, WebSphere, DB2 z/OS, IMS DB/DC V9, FileNet,z/Linux, IBM VM, Informatica V8, CICS

Confidential

Data Warehouse Architect Consulting Contract

• Information/Data Warehouse architect responsible for the design and implementation of an equipment lease data warehouse and business intelligence environment for the Great American Insurance Company in Cincinnati, Ohio. The design consolidated and standardized data from 6 separate disparate data sources into a dimensional model capturing 15 years of history for reporting and analysis..
• Technologies: Oracle 10G, Informatica V8, Linux, SQL Server, z/OS, DB2 z/OS ,CICS, VSAM, Excel,Cognos V8.3, SharePoint MS Project.

Confidential

Information Technology Manager

• I functioned as the I/T manager for a chemical manufacturing company with Headquarters in Cincinnati, OH with manufacturing facilities in Fresno CA, Belgium, Luxembourg and Singapore. My responsibilities included the following:
• Manage project teams to implement JD Edwards One World ERP systems Manufacturing, Accounting, Finance, CRM and HR , Oracle applications, customized Java and VB.Net business applications. Design and implement the Data Warehouse and Business Intelligence solutions for the entire enterprise using Oracle 10G and Oracle Discoverer and SQL Server. Design, plan, test and implement software maintenance and release upgrades to the existing business application software and hardware. Implement network security as established by corporate security policies. Oversee all disaster recovery and business continuity methods, procedures and policies. Troubleshoot, system backups, archiving, disaster recovery, application outages, network security breaches and provide expert support as necessary. Build and maintain vendor relationships and manage the purchase of hardware and software products.
• Technologies: Oracle 10G, SQL Server, Discoverer, JD Edwards 8.0

Confidential

Systems Development Manager Business Intelligence Team Leader

• My responsibilities as the Business Intelligence Team Leader and Manager consisted of the management of all project related tasks, schedules, deliverables, budgets, staff, architectural designs, standards and processes during the systems development life cycle for the construction of delivery of the Marketing Data Mart and enterprise data warehouse supporting 7 business units with an estimated 13,000 users. I was responsible for the Business Intelligence reporting, analytics, dashboard solutions utilizing Enterprise Business Objects Xi product suite. I managed all hardware and software products that comprised the infrastructure supporting these environments including the vendor product selection and management, installation, configuration and maintenance. I also managed all capital expense appropriations and budgets associated with data warehouse and business Intelligence projects. My responsibilities also included the management of all application development and support of the company Intranet. I managed a staff of 7 direct reports and a team of 6 consultants.
• Technologies: Oracle 10G, Business Objects XI, Cognos Series 7, UNIX, Linux, DataFlux, MS Project.
• Certifications: Six Sigma Green Belt-Lean Six Sigma

Confidential

Enterprise Data Architect

• Enterprise Architect for the Investment Advisors Division responsible for the design, implementation and total
• integration of legacy data from over 15 OLTP systems into an operational data store and data mart to support the new generation of financial investment systems incorporating real time Straight Through Processing STP . This project took 3 years and involved the creation of an operational data store to consolidate 13 legacy business systems into a single repository for trade reconciliation and transmission of cleansed trade data to the Bank of New York. I was responsible for all hardware and software identification, acquisition and deployment in support of a 3 tier clustered fail over environment utilizing IBM high end enterprise P690 processors to provide 24 x 7 continuous availability. My team consisted of a combination of data analysts and data architects responsible for the network, database, and application architectures in support of the long and short term business strategy and processing requirements while 2 offshore teams were utilized for the actual construction and production support during the build and maintenance phases of the full SDLC project life cycle.
• Technologies: IBM P-Series Processors, AIX, Business Objects, Cognos Impromptu, IBM WebSphere,
• DataStage, Quality Stage, Seibel CRM, IBM z/OS, Erwin, DB2 UDB, DB2 z/OS, CICS, VSAM.

Confidential

Enterprise Business Intelligence Architect/Project Manager

• Enterprise Business Intelligence Architect directly responsible for the Design and implementation of the infrastructure supporting business intelligence and decision support functions for the GE Aircraft Engine Services Division. Business Intelligence OLAP processing for engine overhaul analysis and tracking was accomplished with the construction of multi-dimensional cubes with drill through into managed cross tab and list reports. The management dashboards, and cockpits were constructed within the presentation layer using specially designed Cognos products for use with the 6 Sigma processes. Project manager responsible for the MTW data warehouse providing engine maintenance services and component tracking. I was responsible for all phases of the SDLC life cycle utilizing a combination of on shore and offshore GTS and Mascot consultants. The management dashboards provided executive management the ability to track the overall progress of the engine overhaul and rebuilt process and eliminate or reduce bottlenecks. The Six Sigma DMAIC principles were employed using these dashboards to improve and control the re-designed processes.
• Technologies: UNIX, Sun Solaris, Windows, Cognos Report Studio, Cognos Analysis Studio, LDAP, Erwin
• Certifications: Six Sigma Green Belt

Confidential

Marketing BI Architect/Project Manager/Pre Sales Technical Marketing Specialist

• Business Intelligence architect directly responsible for the marketing, and installation of the Cognos Business Intelligence products. This position included responsibility for customer satisfaction and support for all Cognos products installed at the customer site. As a project manager, I was responsible for all project deliverables and the technical architecture supporting the Business Intelligence environments including all aspects of data warehouse construction. Additionally, this role included the architecture design strategy for the B/I infrastructure, network interfaces and data security.
• Technologies: Cognos Impromptu, Cognos PowerPlay, Cognos Upfront, UNIX, Windows.

Confidential

AVP- Data Management/Data Architect

• AVP responsible for all I/T Data Warehouse/Modeling, data administration and business intelligence functions with over 24 direct reports in 3 locations. The hardware/software environments consisted of IBM mainframes running OS/390, OS/400 supporting traditional OLTP applications interfacing to client server networks supporting multiple data marts and a centralized data warehouse for departmental/company-wide business intelligence query and analysis. My role included the management of all aspects of data warehousing and business intelligence I/T projects including definition and implementation of the hardware/software infrastructure required to support both Internet and Intranet user access.
• Technologies: OS/390, OS/400, OLTP, OLAP, Cognos PowerPlay, Cognos Impromptu, Windows NT,
• DB2, ERWIN, Oracle 8, SQL Server, PL/SQL, CICS, VSAM

Confidential

Product Manager /Project Manager

• Product Manager directly responsible for the marketing and installation of all business Intelligence and Data Warehouse products utilizing direct customer marketing including road shows, customized product demonstrations and proof of concept' installations in partnership with IBM strategic product marketing. Managed the Business Intelligence and Data Warehousing consulting practices within the Mid-West Region of the United States.
• Technologies: DB2 UDB, Oracle and SQL Server, Windows NT, UNIX, OS/2, OS/390, AIX, OS/400,
• C , Visual Basic, Java, HTML/XML, CICS, RACF, TSO/ISPF

Confidential

Project Manager/Senior Systems Engineer/Data Base Large Systems Specialist

Pre-Sales Marketing Specialist

• Senior Project Manager responsible for management of consulting engagements for the Global Services Division. The projects consisted of management through all phases of the application development life cycle using IBM's Managing the Application Development Projects MADP SDLC life cycle methodology and processes. Projects ranged from 6 months to 3 years in duration with teams ranging from five to fifty consultants. Many projects were multi million dollar efforts involving large international companies including P G, AT T, Nippon Telephone and Telegraph Japan . The NTT project, for example, involved the installation of over 10 data centers, over 30,000 users, took 3 years to complete resulting in the consolidation of all local phone processing centers into 10 regional hubs. As a Senior Systems Engineer I specialized in the DB2 and IMS Data Base products and OLTP application architectures installed on OS/390 mainframe platforms. I assisted customers in the design and implementation of business applications, Data Warehouse and Business Intelligence projects, OLAP and OLTP design and implementation projects, and the installation and customization of operating systems software. I functioned as a large systems specialist and provided 24x7 support to all the customers within the Ohio and Kentucky regions. Customers included Kroger, P G, Duke Energy, Gibson Greeting Cards, Convergys, Cincinnati Bell Telephone, Cincinnati Financial, Great American, Champion Paper, Becket Paper, Mead Data Central, Dayton Power and Light and Lexus Nexus.
• Certifications: Senior Project Manager
• Technologies: DB2, DB2 UDB, OS/390, CICS, JES, RACF, SMP/E, AS/400, OS2, MQ Series, AIX, CSP,
• IMS/DB, IMS/DC, ASM, JCL, TSO, ISPF, BMS IMS/ADF, MFS, COBOL, COBOL II,
• IBM Mainframe.