SUMMARY:

• Please accept the attached resume in response to your search for an experienced Data Warehousing, ETL or Data Architect Consultant. I have also attached an addendum detailing a portion of my experience. (My salary history and listing is available upon request). Additionally, I have over ten years of strong data warehousing, database management and development (on - prem and cloud) and consulting experience.
• I am currently engaged in a Data Warehousing / ETL project. This position involves enterprise level data warehousing, including logical and physical data modeling as well as business rule translation into ETL mappings/batch and real time jobs. I am seeking a position as a technical consultant or permanent hire at the conclusion of this engagement. I am willing to commit to 100% travel or relocation within North America.

TECHNICAL SKILLS:

Data Modeling: Expertise in designing and implementing conceptual, logical, and physical data models using tools like ERwin, PowerDesigner, or SQL Developer Data Modeler.

ETL Development: Proficient in developing and maintaining ETL processes using tools like Informatica, Talend, or Microsoft SQL Server Integration Services (SSIS).

Database Management: Strong knowledge of relational and NoSQL databases, including Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, and Cassandra.

Big Data Technologies: Experience with Hadoop, Spark, Hive, and HBase for processing and analyzing large datasets.

Data Warehousing: Familiarity with data warehousing concepts and technologies, such as star schema, snowflake schema, and OLAP.

Data Integration: Proficient in integrating data from various sources, including APIs, flat files, and databases.

Programming Languages: Proficient in SQL, Python, and Java for data manipulation and analysis.

Data Visualization: Experience with data visualization tools like Tableau, Power BI, or QlikView for creating interactive dashboards and reports.

PROFESSIONAL EXPERIENCE:

Confidential, Alabama

Data Warehouse Architect Consultant

Responsibilities:

• Created Microstrategy projects, project objects, complex transformations, etc for reports and dossiers.
• Administrator for Microstrategy; Implemented security strategy and EDW BI standards for MSTR schema, dossiers
• Data Modeling; Data Analytics (Python, R); ETL/ELT (SSRS, etc);
• Architecture design within clustered and cloud environments; Integrated smaller Business/Functional requirements into Microsoft Power BI complex reports, data visualizations and dashboards.
• Dimensional and Relational Modeling; SQL Server 2018,2019; Azure Data Factory, Databricks, PySpark
• Microstrategy 2019, 2020, 2021 with MTDI or SuperCube experience in Dossiers; Power BI Datasets & Dataflows; Agile Environment; Tableau; ETL Proj. Mgmt; Azure

Confidential, Southwest Ohio

Data Warehouse Architect Consultant

Responsibilities:

• Created upates to EDW ETL strategy (extraction, data cleansing and staging strategy) and mappings/jobs
• Created Microstrategy, project objects, complex transformations, etc for reports and dashboards.
• Implemented security strategy for BI (Microstrategy) layers; maintained user security management and platform administration and QA cases; Web/report cube construction, Free-form sql reporting (& analyzing and debugging)
• Object Manager, Command Manager, User Manager and Distribution services; Performed Platform upgrades
• Dimensional and Relational Modeling; Teradata 16; SQL Server, Erwin; Power BI; Agile Environment
• Microstrategy 10-11.1; Cognos 11.x; Informatica current; DataStage formerCOTS; Tableau Visualization

Confidential, Enon, 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; Erwin; Microstrategy Narrowcast
• SSRS, SSIS, SSAS Deployment and administration - using SQL Server 2012 and 2014.
• Cognos 11.0.4; Microstrategy 10.4; Informatica 10.2; Teradata and Teradata tools; Erwin; Autosys;
• SAP PI/PO; AWS Architect; Agile Environment; AWS, AWS Glue, later Snowflake

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; Experience with large data sets and design and implementation of ETL/ELT framework for complex warehouses/marts. Relational and Dimensional Modeling and some experience with Modeling of Unstructured Data.
• 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. Teradata Admin Tasks; SQL Server 2005, Erwin
• Microstrategy 8.1; Cognos 8.4 (Separate project); Oracle Warehouse Builder (OWB); Datastage 11.3

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, Ohio

Data Warehousing / ETL Consultant

Responsibilities:

• DataStage Suite (8 version); QualityStage 7.0; ProfileStage; Version Control; MetaStage
• Refined auditing and procedures and standards establishment; Data Mapping
• Dimensional and Relational Modeling;, Oracle9i; SQL Server 2000, Advanced ETL methodology;

Confidential, St. Paul, Minnesota

Data Warehousing / ETL Consultant

Responsibilities:

• DataStage Suite (7.5.1 version); QualityStage 7.0; ProfileStage; Version Control; MetaStageImplemented 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

Data Warehousing / ETL Managerial Consultant

Responsibilities:

• Translated Business Metrics into Microstrategy Reports for customized web desktop deployment - some intensive 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:

• 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

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:

• DataStage Suite (3.6, 4.0-5.1)
• Confidential, Atlanta, Georgia
• Data Warehousing / ETL / eCRM Consultant - RFP Author
• 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

Confidential, Atlanta, Georgia

Data Warehousing / ETL / eCRM Consultant - RFP Author

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

Confidential, Universal City, California

Data Warehouse Architect / ETL / eCRM Consultant

Responsibilities:

• Microstrategy Suite (Full BI/Suite, Version 6.0 and 7.0 - including Narrowcast Server Configuration)
• Dimensional and Relational Modeling; Oracle; DB2 UDB; Providing EAI strategic consulting
• Informatica - Advanced ETL methodology; Essbase; Actuate eReport Designer Pro and eReporting Server

Confidential, San Diego, California

Data Warehouse Architect / eCRM Consultant

Responsibilities:

• Microstrategy Suite (Full BI/Suite, Version 6.0) - /developing with Microstrategy 7.0
• Responsible for the delivery of data warehousing and eCRM solutions to retail and transportation services industry clients.
• Cognos (Impromptu, Impromptu Web Reports, PowerPlay, Upfront, Transformer and DecisionStream)
• Financial Reporting department of major client