PROFESSIONAL OBJECTIVES

• As a senior manager, enterprise data architect, business analyst, project manager and development manager, I have more than twenty years of experience in management, project management, developing and maintaining multiple web, SOA, SAP/BI, enterprise data and business solutions, MDM, enterprises active data warehouse across multiple business areas such as financial banking, healthcare, retail, insurance, pharmaceutical, marketing CRM, merchandizing, logistics and supply chains. I have the innovation:
• To apply my experience in leadership, management, business and technical knowledge, business solutions, MDM, BI and enterprise data architect technology to assist major corporate in architecting, developing and deploying practical business solutions, SOA, SAP BI, NetWeaver, MDM and integrated enterprise data architect, data warehouse and data virtualization solutions.
• To apply my innovative thinking and complex problem solving skills with executives, business users and application development, business solution, data architect, data warehouse technology, business intelligence to define and translate business needs into practical business solutions.
• To apply over 20 years of IT experience in providing high business value solutions, high performance systems, highly stable, reliable and secured business solutions.
• To apply my experience in proposing, budgeting, implementing large projects to manage full life cycle of environment integration, business user requirements, BI solutions, data architect and enterprise active data warehouse projects and processes.

Skills

• Data modeling: ERwin, Power Designer
• Databases: Teradata, Oracle RDBMS , Sqlserver, UDB and DB2
• Software: Web Services, SOA, SAP, NetWeaver, ERP, ETL, SQLserver, SSIS, SSAS, MS Office, BusinessObjects, MicroStategy, SAS Enterprise, Cognos, MS Visio, Java, Jakarta Tomcat, IIS 4.0, Oracle Application Server
• Languages: J2EE, Web Services, SOA, SQL, PL/SQL, UNIX Shell scripting, ABAP, ASP, VB Script, JavaScript, C , HTML, XML
• Operating Systems: Windows, UNIX, Linux, AIX, MVS

Experience

DATA/BI ARCHITECT LEAD and BUSINESS ANALYST

Confidential

• Data and BI solution architect for Legal Compliance, AML and financial crimes.
• Develop solution, data modeling with ERWIN, ETL, Data Quality, BI with Business Objects and Crystal Reports, and Data Virtualization with Informatica Power Center and Data Services.

CONSULTANT PRACTICE

Confidential

• Data Modeler for CRM, ERP, Supply chain using ERwin.
• Support data architect, modeling for both Oracle operational systems and Netezza BI/DW systems.
• Develop a data architecture to rebuild a new ICDW project for the retail banking with Teradata.

MANAGER ENTERPRISE DATA

Confidential

Integration and migration consultant leading the effort to consolidate marketing databases, applications and SAS analysis. Convert an outsource customer system to an in-house system for compliance with the strategic Enterprise Architecture.

DIRECTOR ENTERPRISE DATA ARCHITECT

Confidential

• Responsible for developing the integrated enterprise data and application architecture to:
• Reduce IT cost
• Modernize the business solutions
• Create corporate MDM
• Build the SOA framework
• Build the Enterprise Data Warehouse
• Improve the business processes

ENTERPRISE DATA ARCHITECT

Confidential

• Responsible for proposing and developing the Enterprise Architecture focused on business processes using
• The Open Group Architecture Framework TOGAF
• Business domain partitioning for simplicity.
• Business taxonomy
• Business process modeling with BPM and UML standard
• SOA based web deliverable and collaboration
• Advanced model driven architecture with XML, XMI, and CWM.
• Responsible for the architecture of the enterprise data warehouse and business intelligence
• Develop the business process blueprint by interviewing business users across 12 major business processes
• Model the major and minor processes using BPM tool Visual Paradigm for UML with Event Driven process chain methodology EPC and SAP Archimate meta model.
• Developed the enterprise conformed dimensions across all business process blueprint for Enterprise data warehouse modeling and BI solutions using SAP approaches.
• Build the Enterprise Data Warehouse with the top down business processes and bottom up implementation across applications and organizations.
• Guiding the Business Intelligence approach up the maturity curve using business process improvement, data mining, intelligent dashboard and business performance management.

SENIOR BI DEVELOPMENT MANAGER

Confidential

• Managing the Business Intelligence department to deliver BI solutions using
• SAS BI Enterprise
• Oracle data base
• The responsibility included
• Development of business requirements
• Performance metrics and dashboard with business users and executives.
• Development, proposing and managing the department budget.
• Development and executes the compliance reports to various government agencies.
• Responsible for the management, development, maintenance and support of BI systems, business processes and provided environment security, system high level of performance, stability and availability, standardization of the enterprise BI environment.
• Managed and trained a group of technical and business specialists and led the development and the architecture of the BI platform, data warehouse solution, ETL process and the data quality for Enterprise Data Warehouse and Master Data Management and BI solutions and reports.
• Managed the relationship with consultants and software vendors, including software and technology evaluation, contract negotiation and management.

Confidential

CONSULTANT IN SAP NETWEAVER INTEGRATION

• Responsible for the project management and development of the project tasks:
• Budgeting
• Integration of the real-time data solutions Clean, Recognize, Enrichment and Protection with the MDM - Customer Relationship Management from SAP NetWeaver and Oracle CRM
• Integration of J2EE, SOA, SOAP architecture, Web Services and JBOSS server.
• Installed and configured an Oracle server, Microsoft SQL server, Red Hat Linux and SAP NetWeaver integration lab at my location in Columbus with Oracle, NetWeaver Application Server ABAP AS-ABAP and Application Server JAVA AS-JAVA for the NetWeaver-XI implementation.
• Managed, architected and designed the integration solution with
• Microsoft and Linux Application platform
• SAP NetWeaver and Oracle using web services and SOAP messages with the internal SOA, Java. JBOSS and Oracle RDBMS environment.
• Provision of WSDLs for various company data products into SAP Netweaver and Oracle CRM downstream applications.
• Building an integration lab with Web services .Net and J2EE JBOSS to test the integration.

BI ARCHITECT AND DATA WAREHOUSE CONSULTANTS

SENIOR BUSINESS INTELLIGENCE AND BW ARCHITECT

Confidential

• Assisted in developing a very large UDB data base for HSBC Bank in Chicago.
• Managed and improved a business enablement environment for
• SAP r/3
• SAP/BW business intelligence
• DataStage ETL tool.
• The BW data warehouse consisted of ODS and Cubes which are assembled with BW and DataStage tools.
• Managing and leading the DataStage ETL and SAP/BW daily and weekly data load to BW ODS and Cubes from retail customers using DataStage and BW interfaces. Reviewed the BW model architecture and designed for the SAP Business Information Warehouse.
• The primary responsibility was to support and to improve a production environment which was outsourced. The goal was to regain the in-house technical data warehouse capability that was lost due to an outsource effort to an offshore organization.
• Responsible for supporting multiple internal business areas:
• Marketing, finance and merchandizing, logistics.
• Supply chains with retail customers such as Walmart, Kmart, Home Depot, Lowe's and Smith and Hawken furniture supplier.

PROJECT MANAGER, DATA ARCHITECT, DATABASE DEVELOPMENT AND TUNING

Confidential

This project consisted of two phases:

Phase 1: Assisted the company to

• Develop an ASP organization to provide services for Healthcare and Insurance Blue Cross around the country with a Healthcare Information Gateway HIG application using OLAP technology and Teradata database.
• Develop the model for Teradata Healthcare services for Claim and Disease management consisting of membership, providers, claims, episodes, medical, patient, geography and time.
• Use Phoenix Healthcare Intelligence for analytics data services in the areas of informatics strategy, claim management, case and disease management and the application for financial and actuarial management, care management, claim analysis, utilization management, provider analysis, fraud and abuse detection and predictive modeling.
• Extract and load the membership, claim and provider files into to Teradata models.
• Review the application reports and monitor the performance of the Teradata server.
• Present and discuss the healthcare architectural to executives, management and developers.
• Develop the short term and long term application features and the recommendation to the executives.

Phase 2: Tearadata database design and tuning:

• Led the redesign and tuning of a 7.7 terabyte active third normal form Teradata Enterprise data warehouse for Health Care of one of the largest healthcare insurance companies in the country.
• Developed a Teradata third normal form active data base model for the consolidation of multiple data sources from the legacy system, multiple operational systems and an older star schema model.
• Loaded the Teradata database using Informatica and taking advantage of the load features of Teradata and the availability and concurrency natures of the active data warehouse.
• Developed an active data warehouse with an enterprise data model which included financial, care management and claims data from various providers.
• Provided recommendation of the data base structure to improve the query performance for different type of applications.
• Recommended a fine grained security model.
• Reviewed and evaluated the healthcare model to make the recommendation toward a Healthcare industry standard model.
• Migrated an enterprise Marketing/CRM Data Warehouse from:
• An Oracle 8 to Oracle 10G RAC using Oracle Warehouse Builder and PL/SQL on a Linux platform.
• The business intelligence from Business Object to Cognos Reportnet and Cognos PowerPlay.
• Data Quality from First Logic to DataFlux of SAS.
• Hardware from a DG and AIX platform to Linux.
• Worked with marketing/CRM business users, analysts and ETL/database developers to develop the requirements and project plan for the migration.
• Managed the migration project with the following tasks:
• Conducted day to day project design and progress.
• Provided business application guidance to the marketing business users, installation and performance tuning guidance to DBA
• Developed approach and design criteria for ETL process, data quality requirements, ABI match code and House Holding process to the Data Quality team.
• Conducted meeting with vendors such as Oracle, Cognos and DataFlux to ensure that the migration and development conform to the best practice for the products and platform.
• Conducted daily meetings with the development team and weekly meetings with business users to track the process and collect the BI report generation and validation.
• Reported progress to executive to obtain approval and sign off

SENIOR BUSINESS AND TECHNICAL DATA ARCHITECT

Confidential

The responsibility consisted of:

• Coordinating the development of an Essbase implementation.
• Developing and teaching Business Intelligence report class to business users and MIS staffs.
• Migrating a dated internal system using UNIX scripts, Delphi, COBOL and HP3000 to a system using Informatica, Oracle PL/SQL and Business Objects to grow functionalities and business values.
• Developing ETL process to load data sources into a SAP financial solution and to extract the SAP processed data to be used by the distribution and logistics applications.
• Leading the project management and re-architecture effort to redefine the business process flow, system data flow, data architect, business solution and provide the business users with solutions for their business analysis and business decision processes
• Leading the solution architecture and management, installation, design and development of the new processes and applications using Informatica and Oracle with extensive hands-on development and testing.
• Developing the interfaces and mappings between the operational data base and corporate master data bases with the Enterprise data warehouse and the SAP financial system.
• Developing the Enterprise logical and physical data warehouse model using the ERWIN development tool and the PowerDesigner Enterprise suite for Metadata modeling.

SENIOR BUSINESS TECHNICAL ARCHITECT

Confidential

The responsibility consisted of:

• Promoting and conducting an Essbase proof of concept solution to compliment the business intelligence MicroStrategy and Business Objects.
• Developing the best practice business user application of the Business Intelligence platform with MicroStrategy and Business Objects.
• Evaluating and developing a Teradata solution to replace an AS/400 enterprise data warehouse.
• Assisting in evaluation of the Informatica as ETL tool.
• Providing the Teradata training, performance, tuning and business development guidance for converting old AS/400 applications to the Teradata solution.
• Proposing and creating the justification and benchmarks to acquire the Business Objects OLAP tools for reporting and ad hoc queries.
• Gathering and documenting business user requirements to develop the hybrid data warehouse and web OLTP-reports benchmark between Teradata and Oracle.
• Developing and conducting in-house training classes for all AS/400 developers on Teradata concept, basic and advanced Teradata SQL.
• Developing and conducting in-house Business Objects and Informatica training for developers and users.
• Developing the SMNP monitor system for the Teradata database to insure a consistent system performance and to monitor the system capacity.
• Developed and built the Enterprise XML Metadata in compliance with OMG architecture of Model Driven Architecture MDA , Common Warehouse Model CWM and XML metadata interchange XMI . Integrated the entire business system data flow from data sources such as flat file, Excel, MS SQL server and Oracle to data transformation ETL tools such as Informatica, target databases such as Oracle and Teradata, and report tools such as Business Objects and Microstrategy.
• Conducted and documented the user requirements in order to develop a proof of concept for the selection and implementation of OLAP tools. Responsible for proposing, developing criteria and benchmarking the database for Cardinal's next generation data warehouse, in addition to tuning the application in Cardinal.com for optimization in the new Teradata environment.

BUSINESS AND APPLICATION DEVELOPMENT MANAGER

Confidential

• Consultant in development and tuning of SAP/Teradata BI systems at major Pharmaceutical corporation.
• Responsible for a complete business cycle in marketing, sales, management, project management, and development of complex data integration for financial banking and health care industry such as Banc One, SouthTrust Bank, NetBank and City Holding Corporation of West Virginia and Charleston West Virginia Medical Center.
• Sold a major project to develop an Internet Banking, Bill Payment and Presentment, and Remittance Solution with Web, XML technology and XML IFX banking standard for City Holding Corporation. Gathered business requirements to develop an architectural foundation platform for these applications using Service- Oriented Architecture SOA concept with XML and WEB technology. Conducted interviewing, hiring, training and managing a premier software development group for e-business application using XML technology for the application development effort.
• Developed and proposed architecture for business processes using XML standards such as IFX, OASIS, and ACORD with BizTalk server, including a security layer to meet regulation requirements such as HIPAA.
• Developed and conducted a MicroStrategy CRM application to replace an in-house CRM application for Coca- Cola national distribution in Atlanta.

SENIOR CONSULTANT

Confidential

• Lead architect for data warehouse projects for various industries, such as Financial Banking, Retail, Securities and Exchange, and Communication. Developed, trained and managed a special team Proof of Concept to develop and deliver complete business applications and complex database environment using major RDBMS such as Teradata, Oracle, Oracle Parallel Server, DB2 and Informix, and OLAP tools such as Business Objects and Micro Strategy for major corporations such as Coca Cola, SouthTrust Bank and ICG.
• Developed, trained and managed a swat team to work with business users in developing rapid applications by integrating existing complex data structures into a consolidated database system.
• Developed a curriculum and trained Oracle Masters to operate and tune large Oracle databases.
• Developed a presentation to recommend the pros and cons of using Oracle Parallel server, DB2 or Teradata for different resource intense applications. This presentation was presented in front of a large combined group of database and application developers of major customers, such as American Airlines.
• Responsible for the consultant services on application development, client/server application, large database development and support. The projects consisted of Banc One 3600-Teradata and conducting, developing and project management for benchmarking very large Oracle databases 200GB to 1 TB database with Oracle Parallel server for ROADWAY Distribution and Fidelity Investment Securities and Exchange. Conducted performance benchmarking on a very large database for USAir with Teradata, Oracle Parallel server and Informix. Developed a strategy and implementation plan to port mainframe applications to a client/server platform for Super Kmart.

PRESIDENT

Confidential

• Responsible for Sales and support of IBM AIX Unix systems running various databases such as Oracle and DB2.
• Responsible for sale and training of the IBM Unix SNMP Netview 6000 at Banc One.
• Responsible for business and technical development, product development, marketing and project implementation for the businesses of client/server, open system integration and downsizing.
• Responsible for Unix, networking, network management system, databases and applications for client/server and distributed environment. Developed and conducted customized training. Provided the application consultant services to the BasiComputer businesses.

DIRECTOR

Confidential

• Responsible for developing business opportunities in the area of Unix operating systems and associated application and networking with a special emphasis in the RS/6000 and SUN Microsystems products.
• Provided the engineering design and images products and consultant services to engineering and manufacturing accounts.
• Fully responsible for the distributing or downsizing customers and accounts from mainframe to Unix or client/server environment. Responsible for developing marketing and product relationships with Unix vendors such as IBM RS/6000 , SUN Microsystems and Oracle.

Confidential

• Provided support and tuning for the largest DB2 system at Honda.
• Provided technical marketing and support for major engineering, manufacturing and utilities companies in central Ohio such as HONDA, AEP, etc.
• Supported and implemented a wide range of operating systems consisting of MVS, VM, AIX, WINDOWS and DOS and databases such as DB2, IMS, and VSAM. Responsible for various software and services in engineering applications CADAM, CATIA, CAEDS , RDBMS, networking and image applications