Aleksey Odesskiy

Environment: Amazon Redshift, MEM SQL, Google Looker, Tableau.

Responsibilities:

Oversee and lead a team of onsite and offshore Business Intelligence developers

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:

• “Executive Digital Dashboard”. (Redshift, Looker).
• “FOX NOW”. (Redshift, Looker, Microstrategy).
• “CREDIBLE”. (Redshift, Looker).
• “Stewardship & Liability Dashboard” (Snowflake, Tableau)

Data platform migration from MEM SQL to Amazon Redshift:

• Database Evaluation
• Migration strategy, Project plan, resource allocation
• Participated in actual migration as hands on resource.
• In partnership with data engineering team, I was involved in BI tool SQL adaption to the new database and database performance tuning.
• Initiated UAT

Business Intelligence platform migration - Microstratgy to Google Looker and from Google Looker to Tableau:

• Evaluated existing reporting systems
• Provided recommendations of the future BI platform.
• Finding reports/Dashboards to be migrated and get users confirmation.
• Designed Migration strategy, planning, resource allocation
• Organized demo and training.
• Participated in actual migration as hands on resource.
• Initiated UAT

Environment: Teradata, SQL Server, Microsoft Azure, Microsoft Power BI, MicroStrategy.

Responsibilities:

• 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.).

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.

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.

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.

• 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
• 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.

• Project: Implementation of decision support systems focused on Cost-Override and Sell-Thru analysis
• 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.

• Project: Design and development of an analytical extraction solution to extract, transform and load data from Siebel to MicroStrategy CRM Staging tables using Informatica
• Defined data mapping, source and target configuration, data load batches
• Designed a multi-level security system
• Performed product testing and demonstration.

• Project: Building of ready-made data warehousing solutions for the apparel industry
• 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.