Uploaded File
Michael
michaelfortuna696@hotmail.com
727-776-2250
Tampa, FL 33601
Independant Solutions Architect
29 years experience W2
0
Recommendations
Average rating
105
Profile views
Summary

  • I am an ETL Consultant with 23+ years of progressive design and implementation experience in Large Scale Data Warehouse, Traditional Structured Business Intelligence, Social Intelligence and unstructured media, ETL application development and Data Warehouse appliances.
  • Formed the Center of Excellence in Datastage ETL under Ascential and provided expert services implementing Datastage ETL tool throughout the integration of Torrent and Mercator. Authored several documents and lectured at user conferences on best practices and case studies.
  • Certified MSDN partner, Microstrategy Report Developer, Project Developer and Mobile and Dashboard design certification with excellent references and successful delivery track record. Result orientated for time and budget sensitive projects.

Specialties:

  • Data Warehouse Architecture
  • ETL Architecture
  • Business Intelligence Architecture
  • Social Intelligence Architecture
  • Data Warehouse Appliances (Neteeza, Greenplum)
  • IBM DataStage ETL
  • SQL Server and SSIS
  • Oracle, Teradata and DB2 Databases
  • Hadoop, Map Reduce and Incubator Technologies
  • Columnar Databases
  • Autonomy and index based searching algorithms

Experience
Independant Subject Matter Expert
Information Technology
Jul 2014 - present
  • Provide independent, unbiased business related technology assessments to new or existing enterprise clients. Core objective is to target realistic and practical solutions for critical pain points working under any financial or time based constraints uniquely in a collaborative, panel based and consensus driven approach.
  • Trained and certified across multiple platforms including traditional relational systems (T-SQL/SSIS, Information Server, DB2/Cognos, Microstrategy, Oracle, Teradata), Multivalued platforms (Universe, Unidata, D3), columnar Store (Vertica, Par Accel) and analytic appliances (Greenplum, Neteeza, Exadata, SAP HANA)
SSIS T-SQL Cognos MicroStrategy Teradata Oracle UniVerse Netezza Exadata SAP HANA
Remove Skill
Business Consultant
Information Technology
Jul 2011 - Jul 2014
  • Business Consultant for Worldwide Enterprise Services. Provide Architecture and Business Expertise throughout the Americas.
No skills were added
Remove Skill
Solutions Architect
Information Technology
Jun 2011 - Jul 2014
  • Lead Remediation for visible red projects world wide with TCV > $10M
  • Focus in Operations Efficiency improvements and better Stability and Accuracy of Data across all Lines of Business
  • Improve Cross Channel reporting by integrating Big Data with Unstructured Data Analytics
  • Defined Connected Intelligence through Social Intelligence combined with traditional Business Intelligence Analytics
Solutions Architecture Big Data Business Intelligence Analytics
Remove Skill
Datastage ETL Subject Matter Expert
Healthcare
Jan 2011 - Jul 2011
  • Short term (3-6 week) assignment to diagnose and resolve specific multi-threading performance issues across a data warehouse application built by a team of over 200+ ETL Developers and operates in North America and Asia Pacific.
  • Also built and deployed a performance monitoring utility to service all 200+ ETL Developers and provide near real time operational statistics for over 12 ETL servers and 70 ETL projects.
ETL DataStage ETL Developer Data Warehousing
Remove Skill
Senior Analyst - Financial Services
Banking/Financial
Sep 2010 - Mar 2011
  • Senior Analyst, trending and forecasting in the Financial Services Industry for mergers and aquisitions
No skills were added
Remove Skill
Sr. Architectural Specialist
Information Technology
Apr 2009 - Oct 2010
  • ETL Architectural Specialist for large clients across several vertical markets.
  • Focus on Performance and Data Quality in both Business Intelligence and Data Warehouse environments.
ETL
Remove Skill
Datastage ETL SME
Information Technology
Jun 2009 - Jun 2009

Datastage ETL SME

ETL
Remove Skill
BI - QA Analyst
Healthcare
Jan 2008 - Apr 2009
  • Review Requirements and Technical Specifications
  • Author and design Test Plans and evaluate performance and Data Quality.
  • Provide Consultation to Development team regarding Best Practices, Optimization techniques and Data Stage ETL Design Considerations.
Technical Specifications ETL DataStage Test Planning Quality Assurance
Remove Skill
Senior Business Intelligence Architect
Information Technology
Oct 2008 - Jan 2009

Working on BI Solutions for clients in the Tampa Area. Some travel. Main responsibilities include Solution Architecture and implementation around Business Intelligence Systems, DataStage ETL tool, Oracle, Teradata, SQL Server, Analysis Services and Reporting Services.

DataStage Solutions Architecture Business Intelligence ETL Teradata SQL Server SSIS Oracle SQL
Remove Skill
ETL SME
Healthcare
Jun 2008 - Jun 2008
  • ETL SME
ETL
Remove Skill
Data Warehouse Consultant
Insurance
Jun 2007 - Jun 2007
  • 6 month ETL Architecture Effort, evaluating a migration from Ab-Initio based ETL processes to an enterprise standard using Datastage.
  • Responsibilities were to provide gap analysis between existing Ab-Initio graphs, and design an architecture around templated, reusable Datastage ETL jobs. Volumes of data transactions were in the billions of records.
Ab Initio ETL DataStage Gap Analysis Data Warehousing
Remove Skill
BI / ETL Architect
Retail
Jun 2007 - Jun 2007
  • BI/ETL Architect
ETL Business Intelligence ETL Architect
Remove Skill
BI Architect
Hospitality and Entertainment
Jun 2006 - Jun 2007
  • Designed and Developed an ETL, BI and reporting system to track reservations, booked nights and revenue. Solution utilized SQL Server 2000 and DTS, with a ProClarity front end built on an Analysis Services Cube.
  • Designed Dimensions and hierarchies for reports and drill down capabilities, focusing on optiization and performance over time. Cube size approximately 60 GB.
  • Designed and Implemented an Process Control Architecture utilizing my own design that provided realtime auditing of job status and performance metrics.
ETL SQL Server Business Intelligence BI Architect SQL Database Design
Remove Skill
ETL SME
Retail
Jun 2006 - Jun 2007

ETL SME

ETL
Remove Skill
ETL Architect and Data Warehouse SME
Manufacturing
Aug 2006 - Mar 2007
  • Brought in as a catalyst to enhance productivity for a major SAP R/3 Conversion from ASI on a 3 month contract, extended to 7 months.
  • Used SAP R/3 ABAP and Standard load Programs in R/3 to enforce Referential Integrity across legacy data.
  • Minimized dependencies on external Type 4 data files by building a process flow which pulled reference data from R/3.
  • Designed and Developed Data Stage jobs to process Material Master data, including BOMs, Routes, Sales BOMs, Work Centers, Production Supply Areas and Production Versions.
  • Provided Best Practices and Naming Conventions to maximize efficiency and maintenance of ETL processes, External Source Files, and Staging Data.
  • Created Views and simplify ETL processes through implementation of a SQL Server staging database.
  • Wrote Complex Queries for reporting and Data Quality testing by utilizing TSQL on data extracted from R/3.
ETL SAP DataStage T-SQL SQL Server ETL Architect SQL Data Warehousing ABAP Database Design SAP TR
Remove Skill
Consultant
Information Technology
Jun 2005 - Jun 2006
  • Solutions Architect leading independant development for repeatable processes for Audit, Balance and Control.
  • Created Datastage job templates and automation scripts to implement processes originally designed with Ab Initio and Informatica.
  • Solution Architect for all Datastage clients requiring Massively Parallel Processing in the ETL job flow.
Solutions Architecture ETL Ab Initio Informatica
Remove Skill
EDW Subject Matter Expert - Datastage ETL
Information Technology
Aug 2004 - Jan 2005
  • 3 month Assessment extended to 6 months
  • Subject Matter Expert to Load a Teradata 3rd Normal Form Data Model for the Enterprise Data Warehouse for the Packaging Line Management System
  • Delivery Responsibilities included most complex business transformations and data volumes, including the Activity, Sales and Product Subject Areas.
  • Identified areas of opportunity in Development, Process Automation and Production Support.
  • Integrated corrective actions with current development guidelines.
  • Resolved existing ETL stability and performance issues in the incumbent Oracle DW.
  • Built Translation Tables to Convert Dimensional Data Model and hierarchical structures in Oracle to a 3NF in Teradata
Teradata Data Warehousing ETL Oracle
Remove Skill
TORO RDW Load and Conversion Team Lead
Banking/Financial
Mar 2004 - Nov 2004
  • Assignment through Knightsbridge as Principal Consultant
  • Project lead for the design of two separate threads of development for the TORO Recoveries Data Mart.
  • Consult as an architect for issue resolution and baseline Data Movement strategies, leveraging both the DMD and Data Movement Best Practices documents as specified by Capital One.
  • Facilitated cross team communications and provided documentation and tracking of key action items, including escalation for schedule impact.
No skills were added
Remove Skill
Datastage ETL SME
Information Technology
Dec 2003 - May 2004
  • Production Quality High Level Design and Proof of Concept in Data Warehousing for a large Terabyte Data Mart.
  • Improve on Process Flow Diagrams and High Level Design to schedule daily load within limited time frame.
  • Integrate alert mechanism with BMC Patrol, Data Stage ETL, Oracle Knowledge Module, SMTP mail server and Paragrine Tracking.
  • Facilitate communications between business and practice managers with the technical team.
  • Prototype and measure inefficiencies with hash algorithms, indices, Direct and in-Direct loading.
Data Warehousing Data Marts ETL DataStage Oracle Project Management
Remove Skill
DW Architect and ETL SME
Information Technology
Jan 2003 - Jan 2004
  • Review and approve the Conceptual and Logical Models for feasibility, scalability and performance issues in the Data Warehouse.
  • Design of the DW Physical Data Model
  • Architect and implement an integrated, parameter driven process control data structure.
  • Responsible for design and implementation of application processes and hierarchical structures.
  • Design of all primary and foreign key constraints and validations through a data type-less staging database.
  • Responsible for a data extraction and load process that is maintenance-free and minimizes administrative overhead.
  • Design and Manage Surrogate Key structure and de-normalized data integrity (3rd normal form)
  • Create workarounds for limitations in ETL and Reporting tools
Data Warehousing Data Integrity Physical Modeling ETL Database Design
Remove Skill
Director of Professional Services
Information Technology
Jun 2002 - Jun 2003
  • Director of Professional Services
Project Management
Remove Skill
BI Architect
Information Technology
Jun 2002 - Jun 2003
  • BI Architect
BI Architect
Remove Skill
Datastage ETL Principal Architect
Information Technology
Jun 1998 - Jun 2002
  • As a member of the Datastage ETL Professional Services, I became the first member in the Center of Excelence where I was a primary firefighter for customers who struggled through design and implementation of ETL practices.
  • I worked directly with customers and partners alike, resolving performance, operational and functional issues. Many implementations were taken back to marketing and support and eventually evolved into enhancements which are available in the latest releases of the product today.
  • I worked in this capacity through earlier versions of Datastage, and helped implementation during the many aquisitions of Vmark, Unidata, Prism, Informix, Torrent, Mercator and eventually now IBM.
  • I can provide insight on not only how to use the tool, but the reason behind which functions are currently available, as well as how and when they should be utilized (or avoided).
ETL Database Design
Remove Skill
PrincipalConsultant
Information Technology
Jun 1998 - Jun 2001
  • PrincipalConsultant
No skills were added
Remove Skill
Member of Technical Staff
Banking/Financial
Dec 1997 - Dec 1998
  • Application written in HTML/ASP, client side JavaScript, server side VBScript. Database connectivity established through a VB DLL using RDO to connect to SQL Server, and ODBC (MBFoster) to connect to Allbase (HP3000).
  • code modifications to open IPC socket connections and change stored procedure calls executed in batch jobs to local function calls within the trading system.
  • SQL rewrite to improve performance, reliability and accuracy.
  • Application written in VB using Crystal Reports and RDO to connect to SQL Server, and ODBC on a HP3000.
  • Modified trading system to support international trading.
  • Multithreaded NT service routine, which allowed clients to retrieve Reuters real time price data
  • Designed Entitlement and production control.
  • Modified trading software on the HP3000 to allow trades to be conducted with different currencies.
  • Developed Pearl scripts to search for noncompliant code and generate reports to estimate the amount of effort required for remediation.
No skills were added
Remove Skill
Software Engineer
Aerospace/Defense
Dec 1995 - Oct 1996
  • Hardware redesign of an existing prototype upgrading two 286 single board computers to a 486 with a Smart I/O slaves processor to allow for expansion as well as increased data acquisition rates.
  • Software developed in C++ using Interrupt Service Routines, taking advantage of multitasking and eliminating the need for a target Operating System. Use of a 32-bit environment increases accuracy and data resolution.
  • Host development on a WindowsNT/95 client-server using Intersolve PVCS, Borland C++, Visual C++, Metaware High C++ and Macro Assembler.
  • Responsible for conception of system requirements and software design, including development plan and Interface Control Document. Coordinating the use of Automated Test Equipment to assure 100% coverage analysis and tractability, as specified in RTCA/DO 178B.
  • Used in-house and vendor support to solve issues integrating COTS hardware and device drivers into application.
  • Product delivery and on site support of system integration.
Software Engineer Database Design Assembler C++ Windows
Remove Skill
Data Warehouse Consultant
Information Technology
Jun 1995 - Jun 1996
  • Improve Data Quality and reduce process times to cross reference D&B and Axiom Data sources with traditional Customer based data bases.
Data Warehousing
Remove Skill
Software Design Engineer
Aerospace/Defense
Aug 1992 - Dec 1995
  • Software Team Leader responsible for the design, code, test and integration of two Low Level Computer Software Components with a Digital Signal Processing Team.
  • Developed Software using Rational Apex, Verdix, SunOS, Telesoft, Tartan Ada, and C utilizing COTS (VADS/ARTX) software to provide board support.
  • Life Cycle development of a High Level Computer Software Configuration Item using Cadre Teamwork on a Sun/Vads Verdix Ada Platform.
  • Designed, coded and unit tested Low Level Computer Software Components.
  • Prepared documentation for and participated in Engineering Technical Reviews to assure compliance with SRS and standards defined in MIL-STD 2167A.
  • Wrote and maintained Display Format Files for static graphics on a VAX Workstation.
  • Integrated Software using the Verdix Debugger and Test Design Language to simulate message traffic in an isolated environment. Messages were analyzed using the Data Recording Debugger (DRDB).
Database Design C Signal Processing
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Attended in Computer Science
Syracuse University, 1987 - 1992
Skills
Database Design
2007
11
ETL
2011
11
Oracle
2021
5
T-SQL
2021
5
Teradata
2021
5
Business Intelligence
2014
4
Cognos
2021
4
Exadata
2021
4
MicroStrategy
2021
4
Netezza
2021
4
SAP HANA
2021
4
Solutions Architecture
2014
4
SSIS
2021
4
UniVerse
2021
4
Analytics
2014
3
Big Data
2014
3
C
1995
3
Data Warehousing
2011
3
Signal Processing
1995
3
BI Architect
2007
2
DataStage
2011
2
Project Management
2004
2
Ab Initio
2007
1
ABAP
2007
1
Assembler
1996
1
C++
1996
1
Data Integrity
2004
1
Informatica
2006
1
Physical Modeling
2004
1
Quality Assurance
2009
1
SAP TR
2007
1
SQL
2009
1
SQL Server
2009
1
Technical Specifications
2009
1
Test Planning
2009
1
Windows
1996
1
Data Integration
0
1
Data Marts
2004
1
DB2
0
1
ETL Architect
2007
1
ETL Developer
2011
1
Gap Analysis
2007
1
Hadoop
0
1
MapReduce
0
1
SAP
2007
1
Software Engineer
1996
1