SUMMARY:

Data and ETL Architect and Data Warehouse professional. Extensive experience in management consulting to improve operations and decision making through the use of Information Technology and process improvement. International, off - shore development, and client facing activity experience in Australia, China, India, Holland, Germany, and Spain.

COMPUTER SKILLS:

Data Architecture: Zachman, DoDAF, TOGAF

ETL Architecture Data Warehouse design: Kimball (Dimensional Modeling), Immon (3NF), ODS, Application repositories

Wherescape Red Infosphere 11.5: DataStage(4.1 - 11.5), Quality Stage, Information Analyzer, Business Glossary, MetaData Workbench, FastTrack

Big Data / Hadoop Architecture: (Advanced), Development Scoop, Cloudera, Flume, Hive MDM / Initiate, Netezza

Oracle 9i,10g,11g: SQL SVR 7 - 2008R2 SSIS,SSAS, SSRS (2005,2008)

Web Services: Tasks, SCD, LookUp, Cube Development, KPIs, Incremental Processing, Operational reporting.

DB2: Teradata

Languages: T-SQL, PL/SQL, MDX, XML, .Net, C#, Java, C, C++

Support of Database and ETL development: MS Project, Visio Budget Control, EVA, Scheduling, Variance Analysis; As-Is / To Be modeling

PROFESSIONAL EXPERIENCE:

Data and ETL Architect / Data Integration Lead

Confidential, Costa Mesa, CA

Responsibilities:

• Perform full SDLC activities on various manufacturing, bio-technology, and banking projects.
• Manage and act as subject matter expert for off-shore delivery teams. Lead daily status calls.
• Installation and administration of Infosphere Information Server (DataStage) 8.7 - 11.5 in Windows and Unix environments.
• Architect the Information Server suite, including Business Glossary, Metadata Workbench, and operational reporting.
• Connectivity and CDC technology configuration to heterogeneous data sources including DB2, Oracle, SQL SVR.
• Write DDL, DML, DCL for various query and migration scenarios.
• ETL Development using DataStage, Microsoft BI Stack, and other database technologies.
• Provide training on and mentor junior ETL Developers.

Environment: Ecology: DataStage, Wherescape Red evaluation, Netezza, Oracle, SQL SVR, DB2, Teradata, Microsoft BI Stack, UNIX, Business Glossary, Metadata Workbench, FastTrack Quality Stage, Information Analyzer

Confidential, Hattiesburg, MS

Lead Developer

Responsibilities:

• Responsible for the mentoring of junior developers.
• Develop standards, practices, technical and design specifications for ETL development using Infosphere and Microsoft BI stack product suites.
• Develop data warehouse architectures for Navy On-Shore systems.
• Administration and development using Infosphere (DataStage) and Microsoft SSIS products.
• Developed the first dual Key Store (client and server) credential verification between DataStage and a Web Service.

Environment: Ecology: Infosphere/DataStage, Wherescape Red evaluation, Microsoft BI Stack, Web Services, SOAP, SQL SVR, Windows 2008, JIRA, Sharepoint

Data and ETL Architect / Data Integration Lead

Confidential, Las Vegas, NV

Responsibilities:

• Installation and administration of Infosphere (DataStage) in Windows and Unix environments.
• Connectivity and CDC technology configuration to heterogeneous data sources including DB2, Oracle, SQL SVR.
• Write custom routines, Unix scripts, Windows procedures to process data.
• ETL Development using DataStage, Microsoft BI Stack, and other database technologies.
• Responsible for gathering business requirements, design, programming, testing, implementing, and documentation of technical solutions/application programs according to approved standards/procedures.
• Work with analysts and if required, end users, to understand and document ETL requirements.
• Develop detailed ETL design documents, specifications and data mappings.
• Develop user acceptance and QA Test plans.
• Ensure efficient transform, extract, load of data sets, and be able to clearly interpret business requirement specifications into detailed ETL data mappings.
• Technical expert and mentor less experienced colleagues in addressing data-related problems of systems integration and compatibility.

Environment: Ecology: WhereScape Red, DataStage GRID, Oracle, SQL SVR, Teradata, DB2, TM1, EPM, Microsoft BI Stack, UNIX, Quality Stage, Information Analyzer

Confidential

Enterprise Data Architect, Warren, MI

Responsibilities:

• Create and maintain Enterprise Data Architecture Requirements and Implementation.
• Establish enterprise data architecture vision, roadmap and implementation strategy.
• Document the existing data architecture environment to produce and maintain an accurate "as is" view of current data environment.
• Work with other identified U.S. Amy Systems to provide common access for all the application databases and enterprise data repositories.
• Develop standards and guidelines for the design of data architectures, data models, tools and databases, and organization, structure, and definition of data elements.
• Develop and design Decision Support Systems, Data warehouse and Data marts.
• Analyze and assess the impact of production system changes to existing analytics and implement changes to the warehouse components to ensure consistent and accurate reporting.

Environment: Ecology: Embarcadero, Data Modeling, UML, RUP, Agile, Microsoft BI Stack Microsoft Visio, ProVision, COBOL, JCL, M.S. Project

Independent Contractor

Confidential, Troy, MI

Responsibilities:

• Performed independent consultant activities on Data Warehousing development and integration
• Performed start-up activities for an off-shore Russian business venture.

Environment: Ecology: Crystal Reports, DataStage ETL, SAP R/3 BW, Cognos, Hyperion, Business Objects, Data Modeling, UML, SQL Server, Microsoft Visio, DB2, Informix, Redbrick, Oracle, SYBASE, Teradata, COBOL, JCL, Java, Visual Basic, C, C++, IIS, HTML, COBOL, JCL

Confidential, Troy, MI

Responsibilities:

• Responsible for customer contact, business development, and technical presentations for clients in district area.
• Develop data warehouses, insure data quality, and drive business intelligence initiatives.
• Provide management consulting to executive level decision makers on ensuring target ROI achievement for IT projects and that profit centers are fully enabled by IT initiatives.
• Gather requirements, develop test scripts, and perform validation of development work.

Environment: Ecology: IBM Mainframe, RS/6000, HPUX, SUN, SAP R/3 BW, Cognos, Hyperion, Business Objects, MicroStrategy, Data Modeling, UML, Quality Manager, Torrent, Vality, DB2 Connect, Warehouse Manager, IBI Gateways, SQL Server, Microsoft Visio.DB2, Informix, Redbrick, Oracle, SYBASE, Teradata, COBOL, JCL, Java, Visual Basic, C, C++, SQL, IIS, JDBC, XML, SOAP, .Net, HTML, CGI, Perl, Cold Fusion

Confidential

Business Strategy and Process Consultant, Troy, MI

Responsibilities:

• Performed process and data mapping, architecture review, and program management consulting.
• Consult executive management and their direct reports to bridge between Strategy and Operations.
• Responsible for developing the Information Management practice.
• Conducted customer contact activities including presentations and proposals.
• Responsible for developing the Information Management practice.

Environment: Ecology: RS/6000, SUN, Various proprietary warehouse management systems, SQL SVR, Unix, Dimensional Modeling

Confidential

Senior Consultant, Troy, MI

Responsibilities:

• Financial and Manufacturing module configuration, implementation, and modeling.
• Supply Chain and distribution modeling.
• Business Process/ERP Implementation Senior Consultant.

Environment: Ecology: RS/6000, SUN, Teradata, Oracle, Data Modeling, SQL SVR, Unix

Confidential

Senior Program Analyst, Southfield, MI

Responsibilities:

• Developed an OEM-Supplier Integration Process which is used to integrate Tier 1 Supplier operations into the OEM product design and launch process thereby reducing costs associated with mis-communication and improper revision level product delivery.
• Identified Business Critical Success Factors, Cost Drivers, and in-efficiencies through Business Process Re-engineering with accompanying cycle time and cost reduction
• Developed a fully integrated Product Research and Development through Product Launch program and schedule for new products with associated metrics and Key Operating Parameters improving management oversight and establishing and communicating program targets.

Environment Ecology: SQL SVR, Oracle, Data Modeling, Unix