Sap Bi Data Visualization

Steven Otto

Thornton, CO

******.****.*****@*******.*** 720-***-**** www.linkedin.com/in/steve-otto-80031

SAP BI / BW / HANA / ABAP / SQL / Snowflake / Developer

Extensive knowledge of SAP HANA ABAP and BW. Adept at application design, development, testing, and optimization. Dedicated to constantly improving tools and quickly respond to the changing needs of the business.

Expertise in:

ETL RICEFW Application Design Integrating Data Communicating Technical Information Programming Troubleshooting Testing Debugging Data Visualization

Technical Skills

SAP Platforms:

HANA / BW on HANA / BW/4HANA S/4HANA / BW / BI / ERP / EWM / ECC / CRM / APO / GTS / BPC / TPM / DSIM / Integrated Planning / Pulse / Solman

Programming Languages:

ABAP / SQL / Snowflake SQL / Java / Javascript / XML / HTML / Python / JSON

Reporting/Modeling Applications

Eclipse/ Snowflake / XS Classic / XS Advanced (XSA) / Power BI / Analysis for Office / BOBJ / Web Intelligence / Lumira / Design Studio / IDT / UDT / Fiori / Bex Query Designer / Bex Analyser / BODS

SAP Modules

SD / IM / WM / MM / PP / MRP / FICO / COPA / SNP / DP

Experience Summary

Over 20 years of experience as a developer/ analyst in the SAP environment

Over 10 years of experience in the Hana

Extensive experience in gathering requirements, developing, testing & implementing

Developed several custom reports using multiple applications

Extensive experience developing interfaces to transfer data to & from various systems & platforms.

Managed several projects involving upgrades or conversions to new systems & applications.

Excellent communication and interpersonal skills with strong analytical ability and problem-solving capabilities. Good team player, self-motivated, quick learner, and strong work ethic.

Proficient in analyzing and translating business requirements to functional and technical requirements.

Well-experienced in documenting existing process, analyzing client requirements, re-engineering and design business processes.

Process Design, Hands on SAP Configuration, Testing and implementation of business requirements, taking responsibility to understand key business requirements across business units.

Professional Experience

JBS Greeley, CO June 2018-December 2018, January 2022 – Present

SAP BI/BW SR. Analyst/Developer

Extensive experience in Hana 2.0 Data modeling creating complex calculated views, analytical views, attribute views and CDS views that joined multiple tables across several different SAP modules and transitioned those views to S/4HANA.

Fine tuned & streamlined several processes by finding bottlenecks & improving any inefficient that was inefficient & remove bottlenecks.

Built a user-friendly secure interface that empowered users with running and maintaining data updates including an easy way to load files from their desktop. The interface also had an automated notification to inform the user of successful completion or if there were any issues.

Created several custom classes & methods including a process chain method that allowed for various job scheduling need including the ability to automatically put jobs on hold during flexible time periods or to check for dependencies in other jobs. Streamlined processes to be more efficient.

Developed several custom variables that including a date variable that allowed for flexibility to run any possible date range in the background.

Implemented major projects including a budget project that enabled to allow users to have much more autonomy & control over the data.

Responsible for production support & system monitoring including being on-call to troubleshoot & solve any system issues that come up.

Extensive report development using BOBJ tools including Analysis for Office, Webi & Lumira.

Designed several dashboards using multiple applications to help users in having their own ways to visualize data.

Developed multiple complex custom views in Snowflake using SQL that joined many tables together & gave access to data from multiple areas in S/4.

Developed custom processes in Snowflake using SQL to allow users to input variables & pull data from the database.

Developed multiple complex CDS views using SQL including one that joined 50 different tables with complex selection criteria from each table.

Created QA enhancements & reports involving production orders, material inspection & recall prevention.

Developed & Maintained a Vendor Invoice Management (VIM) interface.

Zimmer Biomet Westminster, CO January 2019 – November 2021

IT Lead Analyst, SAP/ABAP Developer

Managed the ABAP development team including coordinating between onsite developers & off shore developers and making sure coding standards were followed.

Implemented GTS into our system in order to help regulate international trade & make sure the company was compliant with international legal requirements.

Coordinated system upgrades & working with Basis Team & the users to make sure the upgrade occurred seamlessly without causing any issues for users.

Coordinated the client copies for getting production data into our development environment and also coordinated the client refresh to get production & application data into our staging environment.

Implemented BAPI function modules & enhanced BADI customer exits

Enhanced and maintained our EWM system & the EWM interfaces with ECC.

Developed several LSMW processes for transferring data from legacy systems into the ECC environment.

Custom development to enhance Idoc structures & interfaces. Also debugged and resolved issues with Idocs.

Developed custom program changes including ALV reports, customer exits BADI's, BAPI's & adding custom data fields to table extensions.

Helped in setting up all ECC batch scheduled jobs to run using Redwood.

DANONE (previously White Wave Foods), Broomfield, CO February 2007 – April 2018

SAP BI/BW SR. Analyst/Developer

Designed, developed, and implemented cross-platform applications, including ECC, BW, APO, and CRM systems, supporting data analysis and reporting.

Managed and Implemented project to bring Nielsen Data into SAP using SAP Demand Signal Management (DSIM)

Enhanced and maintained the CRM & EDI interfaces

Created several custom applications that facilitated mass distribution of data, including web intelligence application that sent out daily sales reports to sales team mobile devices and portal broadcasting reports to email distribution lists.

Built a user-friendly secure interface that empowered users with running and maintaining data updates and viewing status.

Assisted in several system upgrades including testing, integration and successful implementation of Hana, improving report process and allowing users to access data more rapidly.

Converted & loaded massive amounts of data from acquired companies into database. Also converted & loaded massive amounts of data to companies we merged with.

Designed & maintained several process chains that loaded data from multiple data sources into BW system.

Created data sources that combined data from multiple applications & systems.

Developed a monitoring program that sent immediate notification of critical process failures & notification during business hours if a non-critical process failed.

Coded user exits in SAP standard programs.

JavaScript developer for custom user interface website.

DOUBLE DIAMOND CONSULTING, Broomfield, CO June 2005 – January 2007

SAP Lead BI / ABAP Developer

Implemented ABAP & BW solutions at multiple companies with varied business types.

Trained users in converting to new solutions & platforms.

Trained users in how to use BW reporting applications

STORAGETEK, Louisville, CO January 2000 – May 2005

SAP Senior ABAP Developer

Developed custom program changes including ALV reports, customer exits BADI's, BAPI's & adding custom data fields to table extensions.

Responsible for production support & system monitoring including being on-call to troubleshoot & solve any system issues that come up.

Worked at a help desk to aid users in all issues. Helped them fixed the issue or directed the issue & assigned a request to the right group.

Lead JavaScript developer for SAP implementation website.

Education and Training

Bachelor of Science (BS), Information Systems, Iowa State University, Ames, IA,

-Major Information Technology, Minor Business Management

Activities and Awards

ASUG presentation of system monitoring application I had created

ASUG presentation of data update application I had developed

SAP Teched conference & SAP Innojam Participant

Chairman’s Quality Award winner for leading print reduction project, StorageTek

Contact this candidate