We provide IT Staff Augmentation Services!

Data Warehouse Architect Consultant Resume

OhiO

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

Hire Now