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

TECHNICAL SKILLS:

SKILLS: Develop full cycle project plans, Versioning, Batch control/scheduling, Modularity, Restartability, Security, Notifcation, Auditing. Lead kick - off, design sessions, and handover activities. Data Warehouse design: Kimball (Dimensional Modeling), Immon (3NF), ODS, Application repositories Designed robust data warehouses with the following architectural components to meet business requirements: ODS, Staging, Auditing, Quality Screens, Trending, performance stats, Data Marts, EDW, archival, notification Wherescape Red Utilize product functionality in the creation of financial warehouse. Evaluate for use in various client engagements. Infosphere 11.3: DataStage(4.1 - 11.3), Quality Stage, Information Analyzer, Business Glossary, MetaData Workbench, FastTrack Installation, configuration, administration, development, Grid, Web Services, CDC, Parallel, XML, Data Profiling, Cleaning, Standardization, Matching, Custom Routines development. Big Data / Hadoop Architecture (Advanced), Development: Scoop, Cloudera, Flume, Hive Initial configuration and load of single domain. Interface via web calls. Used in the creation of manufacturing datawarehouse. Oracle 9i,10g,11g Procedures, Triggers, Functions, CDC, CRUD, Indexing, Partitioning; 5-10 Terabytes SQL SVR 7 - 2008R2 SSIS,SSAS, SSRS (2005,2008) Procedures, Triggers, Functions, CDC, CRUD, Indexing, Partitioning 1-2 Terabytes Web Services Tasks, SCD, LookUp, Cube Development, KPIs, Incremental Processing, Operational reporting. Procedures, Triggers, Functions, CDC, CRUD, Indexing, Partitioning 2-5 Terabytes Teradata Procedures, Triggers, Functions, CDC, CRUD, Indexing, Partitioning: 1 Terabyte Languages: T-SQL, PL/SQL, MDX, XML, .Net, C#, Java, C, C++ Support of Database and ETL development MS Project, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Data and ETL Architect / Data Integration Lead

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.3 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 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

Associate Level

Responsibilities:

• Lead Developer of Confidential Delivery Center.
• 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

Confidential, Los Angeles, CA

Data and ETL Architect / Data Integration Lead

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, Warren, MI

Enterprise Data Architect

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

Confidential, Troy, MI

Business Intelligence and Data Warehousing

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

Business Intelligence and Data Warehousing

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 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, Troy, MI

Business Strategy and Process Consultant

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, Troy, MI

Senior Consultant

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, Southfield, MI

Senior Program Analyst

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

Confidential, Fraser, MI

Profit Center Manager

Responsibilities:

• Directed $10 million Canadian operation with customer interface responsibility.
• Responsible for the Project Management Office (PMO) and the integration of sales, service, manufacturing, and implementation of associated projects.
• Responsible for integration of internal business processes, including project scheduling, development and implementation of cost control methods, cycle time reduction, customer billing and payroll
• Implemented shop floor reporting system which provided timely information for informed business decisions.

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

Confidential, Rochester, MI

Director of Engineering and Technical Center Manager

Responsibilities:

• Responsible for facility maintenance and services of 24hr machining, prototype, and servicing facility.
• Directed product development, packaging, engineering, and technical center management of 13-plant complex.
• Responsible for product development from inception to manufacture.
• Implemented Project Management Office and established project management systems for the enterprise.
• Developed and implemented programs including cost containment, work control and utilization systems.

Environment: Ecology: SQL SVR, Oracle, Unix, Data Modeling, Desktop Databases, AUTOCAD

Confidential, Paducah, KY

Systems Engineer, Facility Manager, Production Engineer

Responsibilities:

• Responsible for production systems, personnel management of 20+, budgeting, and process control.
• Performed technology feasibility studies, analysis, and equipment cost justification.
• Process data modeling and reporting.

Environment: Ecology: SQL SVR, Oracle, Unix, Data Modeling, Desktop Databases, AUTOCAD, VAX, ModComp