SUMMARY:

• An ETL or Data Warehouse Architect Consultant position
• Data Warehousing, ETL Architecture and Project Management
• Informatica Power Tools (PowerCenter and PowerMart) versions 4.0.1 through 9.5.1
• 10 years total experience PowerChannel; PowerConnect aka "Detail" components;
• Metadata Reporter with Apache Server; Data Profiling Component; Power Analyzer
• Also INFA exp. with Peoplesoft, Tibco and SAP via plug - ins
• IBM Infosphere Information Server 9.1 (fka Ascential Datastage)
• (past experience using Universe with Perl, KSH, etc. as needed)
• Currently using Designer, Developer, Administrator, Director, Bulk LoaderMetaStage 2.3.2 - 7.5, Parallel Extender pre 7.5 now known as Enterprise Edition or PX/EEDataStageXE/390 7.5, QualityStage with SOA (formerly RTI)
• DataStage TX 8.1 (WTX) (formerly "Mercator"), DataStage TX Management Console v8.1, Partner Manager v7.7, ProfileStage 8, Version Control; SAP Plugin (BAPI, ABAP and IDoc stages)
• Additional Integration with Peoplesoft and Tibco
• DATA WAREHOUSING (OLAP / ROLAP / MOLAP TOOLS):
• MicroStrategy ROLAP Suite (Full BI/Suite, Vers. 5.0 through 9.4.1.6)
• 14 years' experience (Architect and Administrator)
• Developer, Architect and Administrator Experience (Command Manager, etc)
• Experience with Microstrategy Architect, Web, Administrator, Narrowcast Server, Olap Services, Report Services,SAP ServicesMicrostrategy Office and SDK. Used Microstrategy Data Mining Services with Predictive Modeling/Analytics
• Business Objects (from version 5 through SAP, SAP PI 7.4, BusinessObjects BI 4.3.5
• Designer SDK, Supervisor, Auditor, Developer, Migration, Installation and Administration
• InfoView, Dashboard Manager, Performance Manager (Integrated with SAP and Peoplesoft)
• ZABO (Zero Admin Business Objects) and Broadcast Agent 5.5; Data Integrator (BODI) 6.1, 6.5, XIr3, 11.7.3.4 - ETL Tool;
• Application Foundation; Crystal Reports 8.5,Crystal Enterprise 9.0, 10, XI r3 Business Objects integration with Crystal Reports.
• Netezza HCA (4 years exp.) Data Warehouse, ETL and Analytics (NPS 6); NPS Twinfin 12
• Hyperion System / Oracle (Enterprise) Essbase (3.2 through 9.3.1);
• Hyperion Planning 4.0.1-11.1.1.2 ; Brio 3.x - 7.1; Analyzer and Enterprise
• Cognos BI TM1 8.4 - 9.1; 11 yrs exp from vers. 5 to present version
• HOLOS 5.0-9; ErWin; PowerDesigner 9.5; Oracle Designer 6;
• Oracle Express (Analyzer, Sales Analyzer, Objects); Oracle Discoverer; E Piphany Analytics 6.5;
• Control-M and Autosys - configuration and development in ETL and BI layers
• Full Configuration, Development, Maintenance and Administration of all above toolsets-

TECHNICAL SKILLS:

DATABASES: Sybase; Informix; Teradata version 13, Unix/BTEQ/Fastload/Multiload/Fastexport.(Certified); DB2 7-9.5; DB2 UDB 9.1; DB2 for AIX 4.3; DB2 for AS/400; DB2 OS/390; DB2 UDB ESE; z/OS Oracle 11gR2; MS/SQL Server 2000/7.0/6.5 ; MS Access 2003, XP, 98, 97

ADDITIONAL: OOA/OOD, Teradata SQL; CA (formerly Cybermation) ESP Workstation version 4.5; ORCL SQL, PL/SQL, Unix shell scripts, ASP, XML, PHP, HTML, DHTML, C++; BEA Weblogic, Sun ONE, IBM Websphere, IIS, Tomcat 4.0; NetBeans, Websphere Studio App Dev Korn Shell, awk; SQL Plus, SQL Navigator; SyncSort, AutoSys, SQL Loader; PERLTibco Rendezvous TX; Data Modeling, Data Mapping; Data Mining; Supply Chain Solutions; OLAP, ROLAP, MOLAP, OLTP, Large EDWs Physical/logical design and architecture skills (indexing, partitioning, performance tuning, and aggregation) Data Profiling, Kimball & Inmon Methodologies, Data Warehouse Best Practices; Data Federation Best Practices Java, Ruby, Python, PHP MS Project 98 - 2013 (Sharepoint); Visual SourceSafe 4.0-8.0; TOAD 7.6; Erwin 3.5-7.2; Rational Rose 7.6ClearCase v.7, ClearQuest, RequisitePro RapidDeveloper 2002, v.6

EXPERIENCE:

Confidential, Ohio

Data Warehouse Architect Consultant

Responsibilities:

• Data modeling and logical database design translate business needs into long - term architecture solutions.
• Refined ETL strategy (extraction, data cleansing and staging strategy) and physical mappings/jobs
• Gathered requirements from various units, created a timeline for implementation within the business intelligence reports, dashboards (mobile and standard), etc.
• Created new BI (Microstrategy) projects, project objects, complex transformations, etc for reports and dashboards.
• Evaluated re-usability of current data objects for additional analyses; Defined, designed, and built dimensional data structures
• Used HTML5, AJAX, CSS3 & JQuery, Canvas for mobile MSTR projects (new project) and other browser apps
• Administered separate ROLAP server (MSTR iServer) for confidential project
• Created Integrity Manager test cases and application support documents
• Built environment from bare server to functioning Microstrategy instance for separately funded project
• Reviewed object and data models and the metadata repository to structure the data for better management and more efficient access.
• Streamlined solution architecture activities to support overall EDW company long range goals.
• Dimensional and Relational Modeling; Oracle 11gR2; SQL Server 2012, Erwin; Microstrategy Narrowcast
• Cognos; Microstrategy 9.4.1.6; Informatica 9.5.1; Teradata 14.1 and Teradata tools; Erwin ; Autosys; SAP PI 7.4

Confidential, Grand Rapids, Michigan

Data Warehouse Architect Consultant

Responsibilities:

• Data modeling (logical and physical database design) to support the additions to the Enterprise Data Warehouse.
• Architected the strategy for Enterprise Data Warehouse additions
• Delivered accurate and complete project documentation as defined by company standards
• Gathered requirements from various units, created a timeline for implementation within the business intelligence reports, dashboards, etc.
• Created legacy to EDW ETL strategy (extraction, data cleansing and staging strategy) and physical mappings/jobs
• Created Microstrategy, project elements, complex transformations, etc for reports and dashboards.
• Implemented security strategy for BI (Microstrategy) layers; maintained user security management and platform administration and QA cases.
• Dimensional and Relational Modeling; Teradata Admin Tasks; SQL Server 2005, Erwin
• Microstrategy 8.1; Cognos8.4 (Separate project); Oracle Warehouse Builder (OWB); Informatica 9.1

Confidential, Ann Arbor, Michigan

Data Warehouse Architect Consultant

Responsibilities:

• Data modeling and logical database design to support the creation of an Enterprise Data Warehouse.
• Architected the strategy for the creation of the Enterprise Data Warehouse
• Created ETL strategy (extraction, data cleansing and staging strategy) and physical mappings/jobs
• Gathered requirements from various units, created a timeline for implementation within the business intelligence reports, dashboards, etc.
• Used loosely defined business needs to translate them into clearly defined technical/data specifications
• Created the BI (Microstrategy) project, project elements, complex transformations, etc for reports and dashboards.
• Created/Updated MicroStrategy schema as per requirements
• Dimensional and Relational Modeling;,Oracle 10g; SQL Server 2005, Erwin
• Cognos; Microstrategy 8.0.2; Oracle Warehouse Builder (OWB);

Confidential, Southfield, Michigan

Data Warehousing / ETL Consultant

Responsibilities:

• DataStage Suite (7.5.1 version); QualityStage 7.0; ProfileStage; Version Control; MetaStage
• Implemented business rules into multi-transformations, XML routines and loads to Epiphany
• Built appropriate data views and data marts and their corresponding BI tools reporting objects
• Refined auditing and procedures and standards establishment; Data Mapping
• Dimensional and Relational Modeling;, Oracle9i; SQL Server 2000, Advanced ETL methodology; Epiphany 6.5

Confidential, Honolulu, Hawaii

Data Warehousing / ETL Managerial Consultant

Responsibilities:

• Oracle Warehouse Builder; Microstrategy Suite 7.5
• Translated Business Metrics into Microstrategy Reports for customized web desktop deployment - some intensive training on the advanced aspects of the suite when needed by the business customers)
• Dimensional and Relational Modeling; DB2; Microstrategy conversion and 7i; Crystal Reports; Weblogic

Confidential, Grand Rapids, Michigan

Data Warehousing / Lead ETL Consultant

Responsibilities:

• DataStage Suite (4.7 ver.)
• Dimensional and Relational Modeling; Oracle8i, Oracle9i; MetaStage; DataStage - Advanced ETL methodology; Business Objects - with Webi (5.1 - 6 beta);

Confidential, Southfield, Michigan

Data Warehousing / ETL Managerial Consultant - RFP Author

Responsibilities:

• Analyzed RFPs and developed time efficient project estimates for EDW (enterprise data warehouse) projects
• Authored RFP EDW system requirements
• DataStage Parallel Extender (PX); Microstrategy 7.2.2; Hyperion Essbase 6.5; Hyperion Planning
• Unix (Sun Solaris 8); BEA Weblogic 7, 8; Togethersoft; Savvion Business Manager 4; Clearcase

Confidential, Birmingham, Alabama

Data Warehousing / ETL Consultant

Responsibilities:

• Built, and documented ETL (Informatica PowerMart) mappings
• DataMining; E - Business Strategy, Planning and Implementation;
• Dimensional and Relational Modeling; Oracle; AbInitio; DB2 UDB; Providing EAI strategic consulting