Sap Data

MAXIM GORELIK

**** * ****** ****** * Denver, Colorado 80237

Tel: 303-***-**** * E-mail: *****.*.*******@*****.***

PROFILE

Over 8 years of IT industry and BA experience of which 7 years in SQL, Teradata, Data Mining and

Analysis and SAP BW (3.x, 3.5, BI 7.0 to 7.3), SAP R/3 in SD/MM/FI/CO/HR modules and in SAP

ERP. 2 years of experience in extracting data from non-SAP Sources into BI using Business Objects

Data Services.

SUMMARY

Having 2 Years of SAP BW/BI experience including in design and development which are done using

ASAP methodologies, interacting with business users, and provided hands-on technical expertise in the

development, implementation and configuration of SAP BI 7.0 to 7.3 based on LSA (Layered Scalable

Architecture).

SAP BI EXPERTISE

Created the Info cubes, DSO(Standard Write optimized, Direct updated DSO objects), Multiproviders,

Info Sets, Info Sources, New Transformations, Info Objects Catalogs, Info Objects as Data Targets,

Characteristics and Key figures Info Objects, Data Sources, Info Packages, DTP, Error DTP, Process

chains, Meta chains. Knowledge of pulling data from SAP BW using Open Hub Service using Info

spokes and transferring the data to non-SAP systems.

Configured Flat file Extraction, R/3 Extraction. Implemented Business. Involved in Data Loading

(Full/Initial/Delta Up-Load/ Master, Transaction data) for, Scheduling, Monitoring Process Chains, Open

Hub Services. Extracted data from various sources by using Business content data sources (Enhancing

Data sources) and Generic data sources (with views, info set queries, and function modules) on the R/3

side. Experience in various BEx Suite Components (Reporting)– Created Queries, Calculated Key

figures, restricted Key figures, Structures, Ad-Hoc Queries, Conceptual Knowledge in designing SAP

Web Application-based Dashboards.

PROFESSIONAL EXPERIENCE

Company: Charter Communications, Denver, CO

Role: Senior Business Analyst

Period: 09/11 – Present

Job Description: Charter Communications assumes the role of Business Reporting team in Cable

Television, high-speed Internet, and telephone services to more than 5.8 million customers in 29 states.

Responsibilities: Enhanced business reporting process with extracting the data from Micro strategy,

Teradata and Sales Force for multiple channels in multiple locations. Created Queries and Data Modeling

Objects using the delivered technical specifications. Directed the creation of new gift card and tablet

reward programs - one of the most powerful strategies in marketing campaign. Developed integrated

business plan with multiple revenue streams, producing close to a $1 million annually.

Company: Keystone, Chicago, IL/Denver, CO

Role: Consultant

Period: 10/09 – 09/11

Job Description: Keystone Consulting assumes the role of consultant for well-known corporations such as

Blue Cross Blue Shield, Weatherford International and Medtronic.

Responsibilities: Configured Flat File Extractions and ERP Packages: SAP R/3 version 4.7E, ECC 6.0.

Processed ETL (Extract Transform Load) with various hardware and software license data.

MAXIM GORELIK Page 2

Worked on OLAP Universe Design and Development. Collaborated IT financing proposals with brand

managers, credit advisors and asset recovery analysts.

Company: Merit Health Systems, Chicago, IL

Role: Financial Analyst

Period: 01/07 – 10/09

Job Description: Merit Health Systems assumes the role of Financial Analyst in financial investments and

cash flow into midsize and small hospitals.

Responsibilities: Performed Tuning of sources, targets, mappings and SQL queries in transformations.

Created transition by mapping between ICD-9-CM and SNOMED CT with Equivalent Concepts

in Both Systems using one to one, one to many and many to one relationship. Over sawed

company’s transition to automated ordering system, that eliminated redundancies and warehouse

downtime.

Company: Skyway Concession Company, Chicago, IL

Role: Financial Analyst

Period: 08/05 – 01/07

Job Description: Skyway Concession Company assumes the role of Financial Analyst in toll road and

bridges construction under the umbrella of global Ferrovial Corporation.

Responsibilities: Participated in integration from Great Plains Dynamics to SAP. Recommended and

issued reports that played key role in renegotiation of company’s warehousing costs, resulted in cost

savings.

EDUCATION

Bachelor of Science, Concentration: Finance and Business Administration (05/2005).

OTHER

Languages: English, Russian.

Status: US Citizen.

Open to relocation.

References available upon request.

Contact this candidate