SUMMARY:

• I’ve been solving problems for companies for over 25 years in the business intelligence space enabling you to gain the maximum business value from one of your most valuable assets, data.
• Less than half that time with all SAP technologies including HANA, BW on HANA, Lumeria, and the Business Objects suite of tools in the areas of SD, PP, MM, FI, demand planning.
• Half BI solutions using tools like Hadoop, Snowflake, Attunity, Tableau, Click View, and the Microsoft stack Azure/SQL Server/Power BI, Oracle, Teradata, etc.
• I have learned many programming languages over my career including SQL, JAVA, Python, ABAP, VB, VBA, .NET, SAS, Shell Scripting and more.
• I pick up new languages/technologies very quickly.
• I’m very adept at listening to a organizations needs and designing and implementing full end to end BI solutions.
• From data acquisition to quality control to MDM to Data Lakes/EDW’s/Hadoop Clusters. On to BI end tools like Tableau and Business Objects.
• Cloud, hybrid cloud based solutions like AWS, Azure and platforms from Oracle, Microsoft, and Teradata.
• Titles I’ve held over the past 25 years include Data Engineer, Enterprise Data Architect, BI Solution Architect, Tableau Architect, Program Manager, and more.

EXPERIENCE:

Confidential, Houston, TX

Data Engineer

Responsibilities:

• Work with end users to create fictional then technical specs.
• Enhance HANA costing models (SAP Purchasing/Order Management).
• Troubleshoot data issues in HANA and Tableau reports.
• Develop and train on Tableau reports.
• Enhance some legacy ETL processes in Develop initial BI self service strategy by HP end user personas.
• Review data governance organizations and asses current technologies and processes.
• Review data lakes’ structures for optimal Tableau.
• Responsible for creating a Snowflake pilot.
• Moving 10 million records from HANA to S3 then into Snowflake.
• Rung tests on data streaming, Snowflake delta capabilities as well as SCD’s and Time Travel.

Confidential, Salem, OR

Enterprise Data Architect

Responsibilities:

• Develop enterprise data models for various state Microsoft based applications.
• Support application developers with SQL development.
• Develop very complex sql statements and procedures to support applications.
• Develop enterprise data models using several different modeling practices to expand code reusability and data model flexibility.
• Standardization to improve master data management and other very common data management issues.

Confidential, Phoenix, AZ

HANA Contractor

Responsibilities:

• Develop, troubleshoot data and performance issues, and QA Analytical Views, Query Views, and Analytical Privileges as per requirements.
• Fully fluent in HANA objects and SQL. Migrate items between different systems.
• Provide US based citizen access to production and QA data for department of defense requirements on data restrictions.
• Extensive work creating, modifying, and debugging models for Sales, manufacturing, material movements, and finance Work done in a pure agile environment.
• Develop jobs, scripts, and metadata in BODS to enable data movement to BW on HANA.
• Demo Snowflake capabilities for possible replacement of HANA.

Confidential, Minneapolis, MN

BI Solution Architect

Responsibilities:

• Architect data lake and new data warehouse using cloud based Snowflake data warehouse, Warescpae ETL tool, and Attunity data movement tool.
• Develop strategies for what data goes where, use cases around data usage, and design access strategies to Hadoop and sales force dot com.
• Set data security standards for all sensitive patient data being stored in the cloud.
• Run master data management program for 5 key attributes.
• Develop enterprise data model.
• Created redesign architecture proposal for small existing Hadoop environment to handle the new data lakes, other raw large datasets.
• Design initial data governance strategy by starting conversations with senior management on data quality issues.
• Work out initial stakeholder list for key bone marrow transplant donor’s genetic indicators used in matching patients.
• Start initial meetings to educate participants, get buy in, and identify specific resources in each area that could be engaged to work out the process, definitions and organization.

Confidential, Mounds View, MN

Senior Data Architect

Responsibilities:

• Project involves converting 3 years of sales history form 4 different ERP platforms.
• Review meetings with stakeholders to identify field mapping and business scenario mapping.
• Responsible for functional specification creation and overall delivery for the project.
• Review data models for accuracy and support of this project.
• BW on Hana and SAP Hana. Responsible for model designs as well as implementation details.
• Responsible for architecting overall data migration strategy of legacy system data to SAP Hana.
• Designed new data flows to Hadoop environments.

Confidential, St Paul, MN

Principle Architect

Responsibilities:

• Work with cross divisional C - suite individuals to design a process to identify and inventory reporting and systems that would potentially break during their upcoming multiyear SAP deployment.
• Create decision tree matrix, initial data model, and multiple mitigation options for the project with associated costs.
• Review each of the 20k+ reports and systems to determine break points and mitigation options with business users across the organization.
• Work with existing, but new, MDM team reviewing their purposed data governance organization offering suggestions, based on experience, to help identify and get the business units to find resources to participate.
• Create and socialize final proposals to Confidential leadership with the ultimate goal of asking for funding to start the project.
• Responsible for final data model for this project.
• Work with Erwin to review and create final data model.
• Used Microsoft Viso for preliminary model designs.
• Architect on BW to HANA upgrade.
• Provide architecture guidance on using Suite on HANA.
• Work with BI team on post optimization of data structures in newly upgraded BW system.
• Rewrite bad ABAP code causing system issues.
• Development on HANA platform using SQL.
• Rework ETL processes to support new platform.
• Work directly with SAP on solving various technical issues.
• Design new security models for supporting sales representative reporting.
• Support Confidential on technical issues relating to stability of the system.
• Evaluate Microsoft Power BI as potential analytics tool for newly updated BI platform.
• Evaluate SAP data services (formally Business Objects tool) for use in data provisioning to up and downstream systems.
• All projects worked were with Agile development methodology.
• Responsible for architecting data migration strategy of SAP data to legacy reporting systems including the choosing of SAP Hana and Informatica as the data migration tools.
• Create MDM standards and identify stakeholders for customer and product information.
• Used Informatica IDQ for data quality.
• Evaluate existing Cloudera Hadoop environments for compatibility with new data streams as well as design proper data structures as well as developing map reduces in Java.
• SSIS, SSRS, SSAS package development.
• Stored procedure and trigger development.
• SQL Database tuning and data cleaning activities.
• Develop jobs, scripts, and metadata in BODS to enable data movement to BW on HANA.
• Update data lake incoming pipelines to new SAP data sources.

Confidential, Chicago, IL

BI Architecture Lead

Responsibilities:

• Develop go to market strategy for SAP BI products and services serving the logistics areas of Track and Trace, Mobility, Production, and Material Movements.
• Presales consulting engagements for clients such as AHT GMB, Lidl GMB, Energizer Batteries
• Development of BI prototypes using SAP Business Objects, BW, HANA, and Lumira.
• Support a WM implementation project on the floor focusing on stabilization.
• Create MDM strategies for clients based off of client needs.

Confidential, GOLDEN VALLEY, MN

SAP BI & Pricing COE PMO and Architecture Lead (Program Manager)

Responsibilities:

• Run concurrent cross functional BI projects recent projects include a heavy focus on delivering self-service BI to business users utilizing tools like SAP Lumira, Tableau, and SAP HANA.
• Learning and integrating ongoing SAP BI business unit deployments and internal BI team improvement initiatives for quality, performance, and reliability.
• Learning Hadoop and working on big data strategies.
• PMO responsibilities include managing and planning team wide resources, senior level business mentoring, offshore staff retention and risk reduction planning, monitoring and providing assistance to all running BI projects to ensure success, and promoting BI adoption at the senior executive level.
• Architecture responsibilities include monitoring emerging technologies, ongoing product improvement with SAP, technical mentoring, and ensuring the best level of service for our business clients in a heavily matrix and outsourced environment while constantly reducing IT overhead costs.
• Senior level BI management position reporting to the VP of BI & Pricing COE on the BI leadership council.
• Responsible for Business Objects deployment at Confidential .
• This included installation, testing, training of staff, and overall project responsibilities.
• Run project to evaluate Suite on Hana as an augment to current by system.
• Fully versed in system and development.
• Work on all aspects of ETL development and data services to support projects.
• Responsible for leading data model reviews and supporting all projects across the landscape.
• Custom Java development experience using SAP Design studio.
• Used Viso for management presentations.
• Implemented projects working with an Agile development methodology.
• XML development for SAP portal applications.
• Responsible for several data migration strategies moving data from and to SAP BW.
• Chose the integration tool Informatica
• Extensive use of ABAP coding in BW transformations and SAP extractors to denormolilze information, preform complex calculations, and pull data from SAP ECC tables into BW. Main developer for highly complex work requiring advanced ABAP skills.
• Created sophisticated program to generate all levels of a bill of material and cache data for reporting as well as data conversion.
• Also, main person who reviewed others code for performance, standards, and maintainability.
• Wrote custom programs in BW to improve lookup performance in ETL operations, security lookups from specialized tables, and interfaces to other systems.
• Create MDM processes for customer, product, plant, and vendor. Identify stakeholders, create business processes, and lead teams.
• Develop jobs, scripts, and metadata in BODS to enable data movement to BW. Architect and implement data lakes for Data Scientists consumption.

SAP Business Intelligence Senior Lead

Confidential

Responsibilities:

• Manage concurrent BI projects utilizing virtual teams comprised of business representatives from 4 sub-business units and an offshore co-source partner located in over 40 sites on five continents.
• Responsibilities include leading business requirements analysis, developing and executing project and resource plans, developing and implementing quality control plans, overseeing BI architecture, and conducting training to achieve project results defined by the sub-business units on a global, single instance SAP Business Warehouse.
• Integrated supply chain lead with extensive experience in SAP modules PP, MM, and APO.
• Responsible for championing the use of BI, driving commonality on information use and consumption, and increasing adoption of the tools so Confidential will realize the full benefit of its investment and drive more accurate decision making.
• Responsible for developing data models and ETL processes. XML development for SAP portal applications.