Oleksandr Aleksandruk Email and Phone Number

Customer: Google LLC. Software & Hi-TechProject Role: Business Intelligence AnalystBI development services provided to Enterprise Data Foundation group at GoogleTasks performed:• Performed data analysis and developed Technical Design Documentation (TDD)• Provided solutions for CI/CD deployment and implemented them• Aggregated the hardware, procurement, and revenue data in the one place for full 360 view trade balance analysis• Developed a series of reporting solutions in PLX dashboards, including key metrics and KPIs, investigated data gaps and anomalies, participated in a troubleshooting process• Performed raw data analysis for data loading and transformations from heterogeneous data sources, using Google SQL and Dremel SQL

Customer: Google LLC. Software & Hi-TechProject Role: Business Intelligence AnalystBI development services provided to Cloud Platform Technical Solutions group at GoogleTasks performed:• Performed data analysis for data loading and transformations from heterogeneous data sources• Developed a solution for historical data backfill and reprocessing• Participated in a large-scale data migration and its post-migratory optimization• Implemented automated data extraction and processing• Developed a series of reporting solutions (dashboards and email) for the customer's users• Investigated data gaps and anomalies, participated in a troubleshooting processDatabase: Google Cloud, Colossus (CNS), Placer, DatascapeTools: PLX Scripts, PLX Workflows, PLX Dashboards, DataSites, Cider, Critique, DasNAVTechnologies: DremelSQL, GoogleSQL, Python, Lua

Customer: Google LLC. Software & Hi-TechProject Role: Business Intelligence AnalystBusiness Intelligence Analysis for Google for WorkTasks performed:• Analyzed data and requirements, and developed implementation plans• Developed ETL processes: linked pipelines, scheduling, circular relationships, deduplication, workflows separation, etc.• Developed dashboards, key metrics and KPIs• Ad hoc investigation and developmentDatabase: Google Cloud, Colossus (CNS), PlacerTools: PLX Scripts, PLX Workflows, PLX Dashboards, Cider, Critique, DasNAVTechnologies: DremelSQL, GoogleSQL

Customer: PNC Bank Corp., Financial Services Project: Engineering for flow of funds dataProject Role: BI Apps Software EngineerTasks performed:• Analyzed project limitations and capabilities, performance requirements and interfaces• Reviewed existing reports and workbooks and made recommendations for improvement and optimization• Provided recommendations for the new analytics platform design• Created technical documentation• Contributed to development of the new platform implementation plan and backlog• Developed reports mock-ups and prototypesEnvironment: Hue, Hadoop, Hive, Impala, Cloudera, Tableau Desktop 2018.2.5 , Tableau Server 2018.2.5

Customer: Chevron U.S.A. Inc., EnergyProject: upstream reporting implementation (Business Analysis, Development, Deployment, Training, and Support). Decommissioning older reporting platformProject Role: Senior BI Developer, Front-end Team LeadTasks performed:• Task management for a team of 6• Knowledge sharing and mentoring for team members• Created and implemented the release strategy• Prepared the proof of concept for reporting• Wrote the scripts (Python, JavaScript) to extend basic functionality• Designed the reports templates• Developed the reports by requirements from different sourcesEnvironment: MS SQL OLAP, TIBCO Spotfire 7, TIBCO Spotfire 7.6, TIBCO Spotfire 7.8

Customer: Canadian multinational mass media and information firmProject: Upgrade non-production and production environments in EMEA and US from Business Objects 3.x to the latest Business Objects version 4.xTasks performed:• Prepared the migration strategy and plan• Restored the broken reports and universes on SAP BOE 3.1• Installed SAP BI 4.1 on 6 servers• Configured Active Directory Authentication and SSO for new servers• Migrated development, test and production servers from SAP BOE 3.1 to SAP BI 4.1 for US and EMEA• Basic testing after migration• Setup auditing and monitoring• Prepared recommendations for support teamEnvironment: Oracle, SAP Business Objects Enterprise XI 3.1, SAP Business Objects Business Intelligenceplatform 4.1

Customer: Hyperion Insurance. Hyperion is an international insurance intermediary group with insurance broking and underwriting agency armsProject: Accelerator 1.1 Data warehouse design and data source integrationProject Role: Senior BI DeveloperTasks performed:• Developed reports and dashboards on customer requirementsEnvironment: MS SQL Server 2014, Dundas Dashboard 5.

Customer: EveryMatrix. An independent software development company providing sports book solution, which can be integrated into existing gambling operators or can be offered as a standalone productProject: research and development of Big Data solutions for the customerProject Role: Senior BI DeveloperTasks performed:• Provided the solutions and implementations for PoC and MVP phase of project• Created data structure in according to project documents• Prepared BI environment on the development servers• Investigated selected tools (Sisense and MicroStrategy) and prepared demo reports• Investigated and setup High Availability• Proposed the solutions for internationalization and integration between front-end site and the report toolsEnvironment: Cassandra, Sisense, MicroStrategy

Customer: Skelia Ukraine (proprietary corporate needs) and corporate customersTasks performed:- Finance reports for CEO and accounts department: implemented data loading from different sources (as .csv files, MS Excel sheets, etc.), data transformation, provided existing data analysis and created reports according to requirements using QlikView 11- Served as a DB Architect / Key DB Developer for Digital Platform based on Microsoft SQL Server 2012, Windows Azure SQL Databases, SSIS, SSRS and Assembla (for Postbuzz, Belgium startup):-- Delivered DB architecture in accordance with the project description-- Created necessary tables, indexes, stored procedures and functions-- Developed and maintained ETL process comprising geo location transformation-- Conducted productivity analysis of DB and their optimization-- Created samples of queries-- Provided assistance to other team members-- Created the reports to show statistic of application usage- Contributed to enterprise scale solutions based on Oracle DWH and SAP Business Objects Web Intelligence (for Thomas Cook) using Oracle 11g, MS SQL Server 2010, SAP Business Objects XI, Business Objects 6.5, Oracle Enterprise Manager 11g, Oracle Warehouse Builder:-- Worked in a distributed team as an extension of the client's development team-- Analyzed and prepared project documentation (specifications, instructions)-- Created and maintained reports according to client requirements-- Monitored and analyzed reports performance on the production servers.

Customer: cVidya (Israel company)Project: Global provider of Revenue Analytics, Revenue Assurance, Telecoms Fraud Management, Sales Performance Management and Marketing AnalyticsTasks performed:- Created reports according to clients requirements - using Business Objects Web Intelligence (WEBI) and Desktop Intelligence (DESKI) and Crystal Reports with multiple sub reports and drill-down features and conditional suppression formulas- Ensured effective use of parameters to create flexible reports. Investigated and optimizedperformance- Created and updated dashboard according to clients requirements- Implemented and supported security features for Business Objects like row level, object level and report level to make the data secure. Provided security access management by creating users/groups and folders- Developed Universe end users documentation- Provided trainings for end users for complex reports generating- Set up and administered SAP softwareEnvironment: Oracle, SAP Crystal Reports XI, 2008; SAP Business Objects XI, 2008; Dundas Dashboard v2.5,

Customer: American company (Graphic applications and data management domain)Project: Network Media Player Software is a component of embedded digital home entertainment solution. The solution is designed to DLNA guidelines to help consumer electronics manufacturers develop products that can stream digital music, photos and video throughout the home. Tasks performed: - Prepared and maintained test environments - Planned and estimated tests, reviewed test cases - Conducted integration and regression testing - Provided trainings and mentoring for junior staff - Developed automated tests using Python Environment: Bugzilla, Python.

Client: American company (Global leader in providing security, storage and systems management solutions.)Project: Localized versions of antivirus and firewall software. Tasks performed: - Prepared and maintained test environment - Contributed to manual functional testing, GUI testing - Prepared and delivered trainings for junior staff - Reported on test status Environment: IBM Lotus Notes/Domino, VMWare, Norton Ghost.

Tasks performed: - Ensured payment cards support - Managed (assigned shifts, supervised the work flows, prepared and delivered reports) processes of ATMs and POS terminal administration and monitoring - Provided information support on payment cards technology for all bank staff (prepared and delivered trainings for business users, updated documentation). Environment: dBase

Tasks performed: - Administered Windows, Netware and SunOS servers - Administered bank operation system ProFIX/BANK - Developed and supported FoxPro application for payment offices - Developed and maintained various reports as requested by power business users - Set up and administered the local network Environment: Informix, dBase, FoxPro; Crystal Reports 6; JavaScript, Visual Basic.