Business Intelligence Data Warehouse

Tatiana Oleynichenko

Director of Analytics, Business Intelligence Data Architect

Phone: 847-***-**** E-mail: *******@*****.*** LinkedIn: www.linkedin.com/in/toley

Address: *** ***** ***** **, *uffalo Grove, IL 60089

Summary:

Experienced Analytics Leader with a strong background in data analysis and business intelligence.

My enthusiasm for innovation and solid understanding of databases and data warehousing support needed for success analysis, modeling, and development. Skilled in transforming complex data into actionable insights to drive strategic decision-making and business growth. Proven ability to develop and implement analytics frameworks, lead cross-functional teams, and foster a data-driven culture. Data is my passion.

Skills:

MPP, Azure Synapse, PDW, AWS (RedShift, S3); Toad Data Modeler, ERWIN, ERStudio, SAP Power Designer; Power BI, SSRS, Crystal Reports, Tableau, WebFocus

Used Sources: API, DB2, Oracle, MS SQL, MS Excel, text files, Fox Pro, Sybase, Teradata, Json, XM, CSV. Microsoft SQL Server, SSIS, Pipeline, Data Factory, T-SQL, Stored Procedure, Idera, TFS, VSTS DEV OPS, Bitbucket, GIT, Jira, BitBucket, Agile, Share Point; Cloud Technology, Data Warehouse, Logical Physical Data Model, 3NF, Start Schema, Vault; Business Analysis, Data Architecture, Team Leadership, Strategic Roadmap, Data Visualization, ETL/ELT, Innovation; Dbeaver, Lucid Chars, Structured, Unstructured data, KPI, Agile, CI/CD

Education:

Master’s Degree in Computer System Engineering

Awards:

Clinical Guidance 2020 Insurtech Initiative of the Year (analytics, compliance, claims, other risk management applications);

CIO Magazine and Drexel University’s Analytics 50 Award for most innovative analytics application, 2016;

Employee of the year – Re-engineering and streamlining process, 2005

Industry Experience:

Retail/Web Sales, Insurance, Telecommunication, IT Services, Travel Services, Finance, Health Care

Work Experience:

Data Architect (Team Lead), Blick Art Materials, Highland Park, IL 08/2020-11/2024

Converted business needs into technical specifications (analysis of minimizing shipping cost and delays, analysis of product recommendation on Web site using Google Analytics, optimizing warehouse pick and pack activities, maximize warehouse activities to boost productivity, space utilization); designed data models for both existing and new data warehouse tables

Conducted a thorough review of the existing data warehouse infrastructure to find errors, problems, needed performance improvements, formulated and implemented an integration strategy to align with business goals, while promoting for best practices in data architecture;

Established practical guidelines and procedures for data management, including database naming conventions (SSIS, tables, fields), standard actionable email notifications, data purging policy, table partitioning, large-scale data updates best practices, and repeatable file processing;

Created methods to guarantee data accuracy and availability, simplifying the collection and analysis of structured and unstructured data;

Developed an Enterprise Data Warehouse (EDW) strategy and execution plan to consolidate data marts into a unified EDW (more than 100 tables);

Evaluated various ETL scheduling tools available on the market, and created a custom workflow orchestration application to manage incremental dependent loading processes.

Researched replication tools across different platforms like As400, Oracle, MS SQL, AWS RedShift, and implemented replication between Microsoft SQL and AWS RedShift;

Outlined plans for data governance initiatives and single source of truth product management system

Recommended enhancements for product feeds to web channels (Google, Amazon, Rhythm, Donor Choose)

Engaged in the strategic planning of a data migration, modernization initiative to transition the existing Data Warehouse to clouds solution - AWS;

Coaching and mentoring developers, Power BI Analysts

Introduced Power BI to business users' self-service to created useful reusable Sales, Vendor Performance, Risky Inventory Dashboards, Out of Stock Products

Planned and monitored Data Warehouse Modernization project

Workflow orchestration, monitoring, data observation; translate, clean, prepare data, insights, metrics, CI/CD, monitoring, improve performance

Business Intelligence Data Architect, Gallagher Bassett, Rolling Meadows, IL 1/2018-8/2020

Partnered with business stakeholders to transform data into a strategic asset for informed decision-making.

Crafted protocols for collecting and recording technical details of business needs, assisted the expansion of the company’s existing Data Warehouse (incorporating both on premises and Azure Data Warehouse solutions).

Created SAP Power Designer Star Schema Models through reverse engineering and data profiling, pinpointing key identifiers and interconnections.

Developed new dimensional data models to support Power BI and SSRS reporting, as well as ad-hoc analytical queries for Managed Care, E-Invoicing, Utilization Review, Nurse Triage Calls, Billing, Claim Scoring, and National Medical Codes(ICD-10, NPI, NDC, CPT);

Working with Project managers to define time lines, with business analysts to study business requirements and creating appropriate Star models using Kimball’s, Vault model, Data Lake, Anchor model to support business decisions, creating and guiding source to target mapping document; working with stored procedure, Pipeline, Data Factory developers to create the best practice of loading data;

Partnered with different teams and executed strategy to improve data infrastructure and optimize access to accurate and consistent data;

Provided training for developers and business analysts;

Analyzed, diagnosed and identified bottlenecks in data workflows, suggested improvement that allowed to save one fifth of load time on Azure Synapse server.

Key achievements:

Constructed robotic way of loading history for predictive models that will save $500 thousands for development;

Produced file load process that allows consistently and accurately process files and identify errors;

Created 128 new dimensions and facts; Created a process to identify, report, and fix orphaned records, temp tables, data cleaning of duplicated records in tables.

Sr. System Analyst, BI Architect VBS Trustmark, Lake Forest, IL 7/2014-1/2018

Provided overall leadership for brand new Data Warehousing Solution to measure KPIs using heterogeneous IT environment, including Data Analysis, Data Modeling, ETL Load Architecture, Dashboard Design, DW solution deployment and maintenance.

Defined a strategy of ODS and Dimension/Fact load processes;

Run meetings with users, who can help discovering business events and telling data stories (Mainframe, MS SQL, flat files, other sources);

Profiled the data, analyzing data quality and incorporation problems and suggested technical solutions, standards, governance taking into consideration unified data consistency, re usability and legacy system integration;

Created a dimensional model using Kimball’s methodology (ERStudio); producing Mapping documents for Data Stage ETL developers;

Planned and modeled data integration processes, communicated progress to senior business leaders;

Coordinated weekly QA releases, testing, and monthly production releases; • Influenced executive dashboard design and approach (WebFocus, Tableau, Power BI)

Worked with DBA team to improve performance of data warehouse load (Fog Light). The load performance is continuously improving to reach 6 am SLA. Key achievements:

The data warehouse contains more than 300 tables to support sales, billing, call center, operation, and commission teams;

KPIs that were created allowed to measure success, to monitor efficiency, and to link them to employees’ goals;

2 TB of data now and about 500 reports;

More than 200 users use the dashboard to monitor efficiency and ensure that individual departments are aligned with overall business metrics10+ years of Experience in Information Technology

5+ years' experience in developing, validating, publishing, maintaining Business, Logical & Physical data models

3+ Experience creating and maintaining Enterprise or Corporate Data model

5+ Experience designing application databases, Enterprise Data Warehouse, Data Hub, Delta Lake, Data Vault, Data Analytics Marts

5+ Experience with 3NF, BPMN, data vault, dimensional modeling - star and snowflake

5+ experience with data modeling tools like Erwin, ER/Studio or Archi

3+ experience with data management activities data quality, master data management, data governance, meta data management

2+ experience in establishing data dictionaries, data models and documenting technical requirements

2+ years of development or DBA experience in RDBMS systems

5+ years strong SQL experience

2+ Experience modeling Master/Reference data

2+ Experience with SAP ECC and Salesforce data models

Experience with data migration, data profiling and data mapping to target

Experience in reverse engineering and defining data models based on profiling of legacy or existing applications.

Experience designing database environments

Experience in developing and enforcing data modeling standards and procedures.

Experience with ITSM, Agile methodologies preferred.

Strong interpersonal and communication skills

Strong consulting and customer relationship skills

Proven work ethic with the utmost integrity

Self-awareness, with a desire for constant self-improvement (goal-oriented)

Personality traits for successful individuals may include self-motivated, passionate, empathetic, approachable, energetic

Bachelor's degree from an accredited institution or equivalent industry experience

General Requirements

Exhibit and practice courteous, ethical, and professional behavior while interacting with both internal and external customers

Influence/make technology decisions for the platform at enterprise level

Act in a collaborative, team-oriented environment focused on common goals to achieve mutually beneficial results

Be accountable and responsible for the accuracy and completeness of assigned work and results

Prioritize and manage workload and communicate issues clearly

Exhibit effective verbal and written communication skills

Comply with all laws, regulations, and company policies

Contact this candidate