ELLEN MASHKOVICH

acqzt8@r.postjobfree.com

847-***-****

PROFESSIONAL PROFILE:

Senior MS SQL BI Architect/Developer with more than 10 years experience in Relational Database and Data Warehouse design, development, implementation that is capable to handle reporting and marketing initiatives.

Business Analysis, data analysis, database modeling and implementation of Data Warehouse: Dimensional, Stat Schema technique;

Business Analysis, data analysis, database modeling and implementation of normalize database;

Report modeling and implemetation using: SSRS, Power Pivot, Power View, DAX

Writing and maintaining complex T-SQL queries including stored procedures, CTEs

Building queries and views, recommending performance improvements and researching data anomalies;

Database design and administration of Microsoft SQL Server 2012;

Database modeling tools: ERwin, ER studio, PowerDesigner;

Ability and willingness to convey concepts and solutions to both technical and non-technical team members;

Experience on technical projects with limited supervision and with strong attention to details;

Proven capability of working with project managers, business analysts, data warehouse architects, and application developers to help define the data requirements and structure for needed applications

TECHNICAL EXPERTISE

Microsoft SQL BI Stack (2008, 2012)

T-SQL - 12+ years

SSIS - 12 years

MS POWER PIVOT - 2 years

SSRS - 8 years

SSAS - 2 year

MS POWER VIEW - 2 years

Methodologies: Object oriented analysis and design, Object oriented programming, relational and multidimensional OLAP methodologies, Kimball, Quality Assurance Project planning, SDLC, Waterfall and Agile software development methodologies

WORK EXPERIENCE:

Oasis Legal Finance Ltd, Northbrook, IL December 2013 – March 2015

Senior BI developer, Architect

Develop project plans, including timelines, project documentation, and performance benchmarks for the development of new dimensions, facts or measures.

Develop conceptual, logical, and physical data models for Oasis Data Warehouse

Modeling and creating star schema, design and develop new datasets, data feeds, reports, ETLs .

Reviews and analyzes on-going customer requests for new data elements to be brought into the new/existing model, for customizations or cross-walking of existing data elements, for computation of new fields based on customer-provided business logic, combinations of existing data elements.

Supporting an existing operational database, Ad hoc, reports and specific to the Financial, Marketing or Servicing department’s data requests.

Company reporting structure design. Proficiency of delivery and quality of requested reports.

Using: SQL server 2012 MS, Visual Studio, SSRS, SSAS, SSIS, MS Excel Power Pivot.

CDW, Vernon Hills, IL May 2011– July 2013

BI developer

Used BI strategy for internal business management and cross-organizational, customer-facing projects.

Designed, developed, and implemented custom ETL scripts for complex and large size data applications.

SUPPLIER PERFORMANCE SCORECARD

Identified and collected measures, KPIs, attributes and aggregations for supplier performance forecast and scorecard using the existing Finance cube, AS400 and PeopleSoft data.

Interacted with all facets and levels of the organization to define requirements.

Assisted in definition of logical and physical models of dimensions and fact tables for the business.

Used T-SQL scripts and ETL to accommodate the appropriate data into MS SQL 2008 R2 Server database.

CISCO VIP PROGRAM - Volume Incentives Rebate Program

Database Architecure: create table structure based on business requirements and coordinate with existing data warehouse model using ERwin and ER Studio.

Design process, Coding using T-SQL, Stored Procedures, validate the result create SSIS and SSRS report.

Manage part of the project as a Project manager, including coordination communication with client IT resources and internal management, Using: SQL, SQL Server 2008, SSIS SSRS

ABBOTT LABORATORIES, Abbott Park, IL August 2005–May 2011

Consultant

Promotional Management Tracking Tool (Version 1.0 -2.1-2.3-3.0) Tracking spendings for promotion products campaign

Database Architecure: create relational database structure based on business requirements

Work with hierarchies.

Design database, table normalization, diagramms, store procedure, functions, SSIS, Reports

Manage part of the project as a Project manager, including coordination communication with client IT resources and internal management, Timeline requirements and QA test plans negotiation with QA team, communication with technical, QA and DBA teams.

Using: SQL, SQL Server 2005/2008, Reporting Services, SSIS, ASP.NET 2.0

Staging data repository database Storage of ODS and Keystone data in one repository for the RAD and PPD department use.

Full-cycle Database Architecure: Logical and physical database design and implementation: create relational database structure based on business requirements, maintenance, promotion to QA, production and support

Design database, table normalization, diagramms, store procedure, CTE, Hierarchy, functions, SSIS, SSRS

Using: SQL, SQL Server 2005/2008, MS SQL Server 2005/2008 integration Services (SSIS)

Affiliation report and territory crossover databases Multiple tracking system for pharmaceutical business for financial and geographical activities.

Full-cycle Database Architecure: Logical and physical database design and implementation: create relational database structure based on business requirements, maintenance, promotion to QA, production and support

Design database, table normalization, diagramms, store procedure, CTE, Hierarchy, functions, SSIS, SSRS

Using: SQL, SQL Server 2005/2008, MS SQL Server 2005/2008 integration Services (SSIS), Reporting Services (SSRS)

Contract Sales Force Tracking Tracking Call and Sample Activities for products promotion

Database Architecure: create relational database structure based on business requirements

Design database, table normalization, diagramms, store procedure, functions, SSIS and Reports

Using: SQL, SQL Server 2005, MS SQL Server 2005 integration Services (SSIS)

WALGREENS HEALTH INITIATIVES, Bannockburn, IL October 2000–August 2005

Programmer/Analyst

NCPDP data load Monthly Pharmacy load to PBS and Pharmacy Locator databases

Manage detailed plan and load pharmacy data including validation, reporting, verification, updates, inserts and deletes pharmacy information and pharmacy network details to Provider Relations department

Using: SQL, PL/SQL, UNIX, MS Access, SQL Server 2000, Oracle

Mapping Enrollment data files Read client’s enrollment data into preloaded output specific format prior load into PBS for Eligibility department

Redesign existing and create new code, improve scalability and performance solving unique client requirements, technical support and maintenance

Using: SQL, PL/SQL, UNIX, Visual Basic 6.0, MS Excel

EDUCATION:

State University Ukraine: Master's degree, Engineering and Management (Minor in Computer Science)

Contact this candidate