Andrii Taranov

big data analytics data processing visualization

Bellevue, WA adi5oj@r.postjobfree.com 872-***-****

SUMMARY

Data backend and visualization Professional with 16+ years of experience in various projects and technologies at Developer and Team Lead/BI Architect roles in ETL, Data Warehouse, Master Data Management, Reporting, KPI/Scorecards and Forecast/Budgeting Projects. Complex Data and Process models developed across variety of datasource types (local, 3rd party, Salesforce.com, Hadoop, cloud, web API) to unify data to provide consistent and manageable datasets and process frameworks to deliver flexible techniques into analytics hands.

Able to multitask and can handle high level of details and complexity of environment, provide deliverables on time in fast-paced environments, including possible risks assessment and issues predicting during work planning in real-time environment constraints disposition.

Positive breakthrough-nature enthusiast with passion to solve useful challenges using proven approaches or building proof-of-concepts for same, good in building partnership with Business to define requirements scope definition/development/acceptance details in iterative spiral up of Business Intelligence Solution/Product/Service lifecycle.

Strong team player/mentor with self-starter attitude, wearing different hats, keeping in touch with Business real feel and need to get feedback ASAP on current visible output and arrange work direction accordingly, detail oriented Project/Feature Manager for onshore/offshore and mixed location Teams.

Delivering and supporting strategic targets and overall vision of Business Intelligence/Performance Management platform to provide linkage of data with Users, internal Customers and other Stakeholders/Product Owners/Senior Management

Have solid experience on successful of multiple Product lifecycle stages – re/pro-active Business Requirements mining, Architect/Design of Data/Multidimensional models and deliver PoC/Demo, BRD preparation/verification, Development, QA/UAT, Production support/health check, implemented automated Metadata/ Knowledge logic/lineage documenting.

Education

National Technical University of Ukraine 'Kyiv Polytechnic Institute', Master's degree, Information Systems and Technologies, 1997-2002

SKILLS

Specific domains:

Complex Data Visualization, What-If Analysis, Business/Data Analysis, Relational and Multidimensional Databases Design, Data Processing Design, Information Architecture, Project Management.

Software Development Methodologies: SCRUM/Agile, Waterfall, PMBOK/PMP

Business Intelligence/ETL Tools:

IBM Cognos BI/Framework Manager/Transformer/Planning/TM1, Tableau Desktop/Server, SAP BW BI/Business Objects/HANA, Oracle OBIEE/Hyperion, Microsoft SQL Analysis / Tabular / Integration / Reporting Services / SharePoint / Performance Point / Project Server / (SSAS, SSRS, SSIS), Qlikview Desktop/Server/iPad, Informatica PowerCenter, Control-M, RoamBI, D3.js, R, JasperReports, MicroStrategy, Excel data analysis including Power BI

Databases:

Microsoft SQL Server, Oracle, HP Vertica, DB2, AMZ Redshift, Google BigQuery, SalesForce.com, Teradata, Hadoop/Hive/Pig/Sqoop, MongoDB, Cosmos

Azure: Azure SQL/Pools/Cross DB linkeage, Azure Datawarehouse, Azure HDInsight/Hive, Azure Analysis Services/PowerBI, Azure Data Factory v1/v2, Kusto, hybrid analytics in the cloud for multi-source and cold/warm/hot data availability approach, end-2-end development experience for sustainable.manageable.self-recovering data frameworks

11.2017 - now

MS Minecraft/Oulook/Teams Data Engineering

Support and development of existing and new data workflows, data processing automation, alerting, Analysis Services in Azure, PowerBI dashboards support and development, HDInsight Hive, ADF v1/v2, Azure SQL/Datawarehouse hybrid solution, DWH in Kusto development, data lineage and investigations . Build Data processing framework to support auto extraction and processing for 20~ different databases with schema and data gradual and full replication scenarios support. Creating 100% covering data changes audit to support decision making and audits (such as GDPR).Automating data assets catalog and business related calculations changes in one place with automated push of changes to the code. Full CI/CD for databases, processes and data validations.

Unify Square ETL/DWH/BI Senior Developer

2.2015 - 11.2017

Working as a full-stack developer for PaaS in Azure. Working with Cube, Databases, WebServices, Data Factories, Data Lakes/Analytics, Hive@HAdoop, AngularJS, Entity Framework, U-SQL/T-SQL, Blob/DocumentDB storage. Developing 1st class web experience around Skype for Business data analysis and guided way to increase performance. PowerBI/Tableau as ad-hoc analysis tools for the data. Azure Data Factory v1 and v2 for data processing and management

4.2014 – 2.2015

Wicresoft (Microsoft) ETL/DWH/BI Senior Developer

Microsoft – (Commerce Platform) Financial Reporting Services project.

Support successful run of data ETL 24/7 processes, closing week and month end. About 1000 ETL processes running thru ETL Framework over 15 MS SQL Servers within more than 150 databases. Managing bugs tracing, automation of monitoring, alerts messaging on exceptions and environment issues. Review and optimize current processes. Support Cubes refresh with recon of data results. Reverse back and visualize system processes for easy data issues trace back thru all system parts and components – ETL Framework, C# modules, t-SQL stored procedures, and Cubes structures. Setup and manage Cubes access from MS Power BI and Tableau. Participate in new system version development thru usage of Cosmos (internal MS Hadoop) and SOA architecture. Participation in new system architecture and working on automated data/logic transition

3.2012-4.2014

EPAM Systems (Shevron/TriZetto/Expedia) ETL/DWH/BI expert

Expedia (Enterprise Data Warehouse) Global Suppliers Operations project.

Create and support processing of various Call data from multiple sources with providing reporting solution thru DataMart and BI components linked to it. Cloud to BigData data processing with cleansing and storage with full changes for history trace back. Team Lead role.

TriZetto (Clinical Analytics) Data-Hub BI project.

Creating and support rules and processes in existing system (extend capabilities and functionality) of data coming from wide range of TriZetto developed products – to provide unlimited number of systems being process in one time for unified data mart solution with reporting and exchange for 3rd Party tools available. Technical Lead role.

Shevron (Shelf of Mexico)/ HR and Projects Management Planning/Reporting project.

Developed and delivered in time report for 5 areas of business using pixel-perfect technique with complex KPI’s logics included and used. Team Lead role for BI team.

5.2009 -3.2012

Luxoft (Deutsche Bank ODC) investment banking ETL/DWH/BI Lead/Architect

Deutsche Bank (Investment Banking Operations IT)/ OPAL MIS project.

Team lead and data model architect, manage activities/tasks/communications across Hong Kong/Singapore/London/New York/Cary businesses locations. Management up to 4 developers of project team (>100 members) in 2 Ukraine locations.

Domains: Client Issues, Trades, Trades Control, KPI, Capacity Management, Finance, Costs Analysis, BI System User Activity Analysis, Risk Management design/development/support activities with self-documenting of system, automation. Data quality and metadata management.

9.2011 - 3.2013

Wicom (comScore) Telecommunications Senior Support Engineer III (part-time)

xPlore platform support and development for Performance Optimization and Data Comprehensive Forecast Tool for Verizon, Mobinil, Mobilink, Banglalink, T-Mobile, TRA, Orange clients

Was involved in full cycle client support activities from Prod support till new requirements development as L3 Support Lead. On daily basis thru SCRUM and Agile processes was delivered lot of patches and release of customized Customer systems configurations. Many workaround and new approaches was found and delivered in time for gather specific SLA requirements. Participation in the new system versions/abilities design.

Remote part-time

2009-2014

Consulting SaaS/manufacturing/agriculture/beverages/telecommunications PM/TL/Senior programmer

Fire Intelligence - Qlikview SaaS September 2013 – October 2013

Supporting new product generation development using Cloud and BI platforms for Fire departments reporting and performance analysis automation.

Abbott - reports/dashboards and framework development April 2013 – July 2013

- Developed set of reports and dashboards using latest IBM Cognos and RoamBI functionality to deliver information about all running and planned Project initiatives in Abbot by sourcing data from Planview Project Portfolio Management system

- Supported new Cognos Framework Model development and migration Active Reports (incl optimization for iPad), Widgets and Reports alignment from old to new schema logic

- Automated impact analysis and documentation generator

Philadelphia Insurance Companies - MS SQL Server project reverse engineering and documenting October 2012 – March 2013

- Reorganized and fully updated graph of dependencies of all MS SQL Server objects (more than 35 000 objects in total) for dependencies and architectural analysis usage

- Automated documentation and graph refreshment for any future changes in MS SQL Server and MS Integration Services

- Delivered full parsing of any t-SQL code changes for CRUD (create, read, update, delete) list of actions for code review and impact analysis

Implementation of 1S 8.1 ERP systems including integration with SAP BO Xcelsius. Company 'Lafarge Gypsum' (building materials).

Design and implementation IBM Cognos Planning 8.4 in 'AllSeeds Group' (grain company).Project initiating and creation of Planning and Metrics in IBM Cognos model based upon whole multi-branches company structure. Company 'Olimp' (alcoholic beverages).

Implemented of ERP system including IBM Cognos Planning integration with daily billing data based rolling budgeting process. Company 'ITC' (telecommunications company)

10.2007-5.2009

Microtest consulting company MFCG/insurance/trading/manufacturing PM/TL/Senior programmer

Kimberly-Clark Russia/Enterprise people resource planning system. Conduct training and background support for the introduction of self-implementing of IBM Cognos Planning & BI.

Sibirsky Bereg/Enterprise resource Planning System. The system was designed to automate the planning of the entire enterprise-from forecast sales of up to the projection of production and procurement of essential commodities. Implementation of the system has reduced the time and labor costs of annual and year-round monitoring and review’s budget figures. As a result, the project involved in the ongoing process to 120 users in IBM Cognos Planning.

Oriflame Russia/planning for multinational companies. Automation of data collection and consolidation on the two budgeting models – one is for the world and another Russia business in IBM Cognos Planning. Interaction with the working groups based in Brussels and Prague.

Task leader Cognos Planning in Microtest/Preselling, Management, Marketing, Training activities for IBM Cognos Planning on daily basis. PoC's for the insurance/automotive/food manufacturing/development companies

5.2006-11.2006

Brig-Retail, SAP-partner company MFCG/banking/carrier/oil/manufacturing/telco Consultant on SAP BI SEM/BPS/IP modules

Kviza Trade, Furshet/Conduct training and background support for the introduction of self-implementing of SAP BI.

VikOil/Conduct training and background support for the introduction of self-implementing of SAP BI. Design of architectural solution for the project targets achievement.

National Bank Of Ukraine/Consulting on project migration to the latest SAP BI BPS version

UMC (MTS Ukraine)/Consulting on project migration to the latest SAP BI BW version

Contact this candidate