Tatyana Shkolnik

**** ****** **, ********* ** *1209

Tel. 410-***-****, E-mail: abm4pd@r.postjobfree.com

Career Summary: 6+ years of BW/BI backend and frontend and integrated

planning development. I supported 2 end to end solutions with

successful go lives.

Relevant Experience:

4/2007 - Present iLuMinA Solutions Inc., Annapolis, MD

BI/BW Analyst

Integrated Business management system included Sales and Distribution,

Material Management, Purchasing as well as a Complex Forecasting solution

to be used in Buy / Repair plan by US NAVY. Development was done in

Netweaver 2004s - BI 7.0 as well as SCM 5.1 systems.

Architect and a developer for Repair turnaround time solutions that

involved legacy conversion file, ECC extracts and BW solutions with

Integrated Planning to allow for user interaction.

. Produce High Level Design and Technical Design specifications from

functional requirements

. Enhance standard (LO Cockpit) and create custom datasources.

. Create and modify transformations, including start and end routines BI

7.0

. Modify communication structures, Transfer Rules and Update Rules using BW

3.5

. Created cubes, DSOs, Multiproviders and Infosets.

. Develop input ready queries and reports using Business Explorer 7.0

. Implement User Interactive Web templates using BeX Queries and Planning

Functions

. Develop Function modules and classes using ABAP

. Used Visual Composer to display reports, value help and call function

module to process results

. Execute Unit test and complete all of the required documentation

. Provide support to the testers during Cycle testing and User Acceptance

testing phases

. Analyze and Resolve defects using Mercury tracking system

. Monitor Daily BW loads and resolve any issues in support of Cycle and UTA

testing

7/2002- 4/2007 Accenture Technology Solutions, Philadelphia, PA

Senior Software Engineer

Projects included:

BI- IP Designer / Developer

End-to-End Integrated Forecast Solution for Accenture Inc includes

integration between Revenue and Resource Planning modules. This will allow

users to plan for 5 quarters into the future. Project includes complex data

model that contains DSOs, Basic-cubes, multiproviders as well as Front End

development of IP objects, input ready queries and reports.

. Created technical design documentation from functional requirements

. Responsible for creating and updating infocubes and multiproviders

. Developed Aggregation levels, filters, planning functions, and planning

sequences in BI-IP 7.0

. Created input ready queries and reports using Business Explorer 7.0

. Linked queries and planning functions into the web templates

. Developed and Executed Component testing

. Analyzed and Resolved defects Tracked by MDM (Multiple Document

Management)

. Trained personnel in BW back end as well as IP

BW - BPS Developer

Financial integration system was designed for Large Financial Institution

and enabled forecasting ability for 30 months into the future. Data model

included ODSes, Basic Cube, and 3 transactional cubes that were used for

areas of Asset and Revenue, Borrowing, and Finding.

. Created and updated infocubes and multiproviders using BW 3.1

. Modified update rules and function modules and start routines

. Responsible for development and testing of 30 + planning folders in SEM-

BPS 3.1

. Implemented 100 + layouts and parameter groups

. Provided Break fix support for test team

. Created process chains for loads from ODS and Datastages

. Facilitated and presented Knowledge Transfer Workshops to the new

production support provider

BW Front End Developer

Front-End development of Major SAP Integration that allowed AstraZeneca to

combine Separate systems used by Astra and Zeneca. This included building

reports for SD, MM and FI areas.

. Created BW queries using SAP BW BEx 3.1

. Created Workbooks using BEx Analyzer

. Created and execute Unit test procedure and scripts

. Completed all required documentation

ABAP/4 Software Developer

Development and modifications of Reports, Interfaces, and Smartforms for

Diageo SAP R/3 system

. Provided Production support

. Implemented modifications to existing RICEF development

objects (Reports and Interfaces)

. Created new and modified existing Smartforms

. Maintained Technical Specification

. Performed Code Reviews

. Supported the Project team via defect maintenance

. Provided "System Cutover" and "Warranty" support

Education: Brooklyn College, Brooklyn, NY - Bachelor of Science in

Computer and Information Science and Minor in Economics

Software Skills: SAP BW 7.0/3.5, BEx Analyzer 7.0, BW-BPS, BI-IP 7.0,

Netweaver 2004S, ABAP, ECC 6.0, Web Application

Designer, Visual Composer.

Clearance: Active secret clearance

References: Furnished Upon Request

Contact this candidate