BI lead
Resume:
ALEKSEY ODESSKIY
ad5xlz@r.postjobfree.com
OBJECTIVE
SUMMARY
Sr. Business Intelligence Architect / Sr. Data Warehouse Specialist / Microstrategy, Tableau, Looker / Team lead position with professional growth opportunities
Over 20 years of experience in business analysis across different industries.
Working knowledge of various platforms and software (Microstrategy, Tableau, Looker, IBM AS/400, DB2/UDB, MS SQL Server, Oracle, Teradata, Netezza, Amazon Redshift).
20+ years of experience in data warehousing and ETL processing.
20+ years of extensive work with all components of MicroStrategy.
EXPERIENCE
Mar 2020-Apr 2024
Des 2019-Feb 2020
July 2004-Oct 2019
FOX Corporation, Beverly Hills, CA
Position: Associate Director, BI Engineer, FOX Digital & Technology Group.
Environment: Amazon Redshift, MEM SQL, Google Looker, Tableau.
Responsibilities:
Design and Developed multiple Artificial Intelligence Analytics tools for FOX Ad Sales, Finance, Digital, and Pricing and Planning Teams to track impressions and revenue earned and owed to Advertisers:
Manage a team of onsite and offshore datawarehouse developers
Design and Develop multiple applications
NBC Universal, Los Angeles, CA
Position: Sr. BI Architect/Datawarehouse.
Environment: Teradata, SQL Server, Microsoft Azure, Microsoft Power BI, MicroStrategy.
Design and Develop “GL SAP Data Mart” datawarehouse project (Microsoft Azure, Microsoft Power BI).
Architecture and model improvement “TV Distribution Royalty” datawarehouse project (Teradata, SQL Server, MicroStrategy.).
20th Century FOX Home Entertainment, Beverly Hills, CA
Position: Sr. BI Architect/Datawarehouse.
Environment: Amazon Redshift, Netezza, Oracle, Teradata, SQL Server, Tableau, MicroStrategy.
Responsibilities:
Manage a team of onsite and offshore datawarehouse developers.
Design and Develop “Movies Anywhere” datawarehouse project (Microstrategy, Tableau, Amazon Redshift, Informatica).
Design and Develop “FOX Fast” datawarehouse project (Microstrategy, Amazon Redshift).
Design and Develop “Digital” datawarehouse project (Microstrategy, Amazon Redshift).
Datawarehouse Modeler, Microstrategy architect, Microstregy team lead, Microstrategy developer roles - migration from Netezza to Amazon Redshift.
Design and Develop Category Management and Competitor Intelligence Analysis projects for multiple retailers, ……
Instrumental in architecting the retailer POS forecast project.
Install and configure complete MicroStrategy Business Intelligence Suite of products (Desktop, IS, Web, Narrowcast)
Design a data model, create a project, and define complex objects containing custom sub-queries.
Create and validate advanced reports covering sales, inventory, shipments and AC Neilson analysis.
Define users and user groups with a custom-level data access.
Organize and conduct user training.
Responsible for the MicroStrategy project architecture, Projects administration and advance reports creation.
May 2004-July 2004
Edmunds.com, Santa Monica, CA
Position: Sr. Data Warehouse Developer
Environment: Oracle 9i, MicroStrategy 7.5.1 (Desktop, Web, Administrator)
Responsibilities:
Performed complete MicroStrategy software installation and configuration (Desktop, Server, and Web).
Designed a data model, created a project, defined complex objects containing custom sub-queries.
Create and validate advanced reports covering sales and labor analysis.
Define users and user groups with a custom-level data access.
Organize and perform user training.
Responsible for the MicroStrategy project architecture, metadata cleanup and recovery.
May 2002-May 2004
AmerisourceBergen Corp., Orange, CA
Position: System Specialist
Environment: DB2/UDB, MS SQL Server 7, MicroStrategy 7.1-7.2 (Desktop, Web, Administrator, Narrowcast Server)
Responsibilities:
Analyze and document user requirements, create advanced analytics and reports.
Alter the existing database structure and schema objects in order to support complex rules and dependencies required by business model.
Resolve numerous data issues that occur in the process of merging data from multiple sources.
Design a multi-level security system.
Ensure accuracy of the information and a high level of system performance.
Responsible for data warehouse architecture, metadata cleanup and recovery.
Sep 1998-Jan 2002
Nov 2001-Jan 2002
Systech Solutions, Inc., Glendale, CA
Position: Sr. Data Warehouse Consultant
Client: Systech Solutions, Inc.
Project: Design and implementation of a sophisticated analytical tool aimed to identify financial transactions companies can audit for recovery. This web-based solution also provides clients with insights into financial opportunities and allows better financial risks handling.
Environment: MS Access 2000, Oracle 8i, MicroStrategy 7.1.2 (Desktop, Web, Administrator, Narrowcast Server)
Responsibilities:
Performed a research on analytics in audit and financial opportunities areas.
Created and formatted metrics and reports designed to simplify process management, identify overpayments, under-deductions, financial opportunities, etc.
Configured the system for the web access.
Prepared and delivered a final presentation to the client.
Apr 2001-Oct 2001
Client: Ingram Micro, Inc.
Project: Implementation of decision support systems focused on Cost-Override and Sell-Thru analysis
Environment: MS SQL Server 2000, MicroStrategy 7.1.1 (Desktop, Administrator, Narrowcast Server)
Responsibilities:
Was a primary contact between the technical team and management executives.
Analyzed and documented business requirements.
Provided the optimal database design to support complex reports requested by user.
Configured the system for the web access.
Jan 2001-Mar 2001
Client: MicroStrategy Inc.
Project: Design and development of an analytical extraction solution to extract, transform and load data from Siebel to MicroStrategy CRM Staging tables using Informatica.
Environment: MS SQL Server 2000, Oracle 8, Siebel 2000, Informatica
Responsibilities:
Defined data mapping, source and target configuration, data load batches.
Designed a multi-level security system.
Performed product testing and demonstration.
Jun 2000-Dec 2000
Client: Systech Solutions, Inc.
Project: Building of ready-made data warehousing solutions for the apparel industry.
Environment: MS SQL Server 7, MicroStrategy 7.1.1 (Desktop, Web, Administrator, Narrowcast Server).
Responsibilities:
Played a business and report analyst role.
Was in charge of analyzing and validating existing reports as well as creating the additional reports in order to cover all aspects of the apparel business.
Provided recommendations on the database structure.
Organized and regrouped the final set of the reports according to their specifics.
Provided a detailed description for main groups and individual reports.
Sep 1998-May 2000
Client: Authentic Fitness Corp.
Project: Design and implementation of the data warehouse for Speedo and Designer divisions.
Environment: DB2/400, MS SQL Server 7.0, Microstrategy Suite 5.x-7.x (Agent, Architect, Web, Administrator), Island Pacific, ACS.
Responsibilities:
Built three projects covering merchandising, retail and wholesale businesses.
Configured Microstrategy tools for both client and server sides.
Validated and corrected ETL scripts, performed data modeling and optimization.
Obtained user requirements and translated them into valuable reports, ensured accuracy and timeliness of the information, organized and performed user training.
Jul 1996 – Dec 1997
OASIS Corp, Odessa, Ukraine
Position: Business Analyst
Led a team performing the development of a large application for the State Revenue Services of Ukraine. The product maintained a database of all taxpayers and combined both reporting and “write-back” functionalities.
Analyzed user requirements and process flow.
Performed data modeling and provided recommendations on the database structure.
Optimized report contents, ensured data accuracy and a high level of system performance.
EDUCATION
Dec 2020
Oct 2019
Des 2017
Aug 2007
Aug 2007
Aug 2002
Jun 1998-Jan 2002
June 1995
Advanced Looker Developer Virtual Bootcamp
Looker Developer Bootcamp
Looker Certificates of Completion: Getting Started with Looker, Building Reports in Looker, LookML, Training Business Users, Designing Great Dashboards.
Tableau Certificate of Completion D1, D2, D3
MicroStrategy Certified Report Developer, MicroStrategy Institute.
MicroStrategy Certified Architect: Project Design, MicroStrategy Institute.
MicroStrategy Narrowcast Server 7.2.1, MicroStrategy Institute, Washington, D.C.
Systech Solutions, Inc., Glendale, CA
Informatica
Business Objects 5.1.2
MS SQL Server 7-2000
DB2/UDB
AS/400
Oracle 8i
Advanced Data warehousing
MicroStrategy Suite 5.x-7.x
Odessa State Polytechnic University, Ukraine
MS in Mechanical Engineering
REFERENCES
Available upon request
Contact this candidate