Project Manager Management

A ndrew T

Business I ntelligence

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

SUM MARY

Business In telligence Professional with 14+ years of experience in various projects and

technologies in Analyst, Developer and Team Lead/BI SME roles in ETL, Data Warehouse,

M aster Data Management, Reporting, KPI/Scorecards and Forecast/Budgeting Projects.

Complex Data and Process models across multiple datasources (local, 3 rd party, Salesforce.com,

H adoop) to unify data and provide consistent and build confidence for data available for

analysis.

Able to work on multiple tasks and handle high level of details and cross-references,

p rovide deliverables on t ime in fast-paced environments, including possible r isks definition and

issues management in real-time environment constraints disposition.

Positive breakthrough-nature enthusiast with passion to solve challenges using proven

approaches and good in building partnership with Business to define requirements scope

definition/development/acceptance details in i terative spiral of Business Intelligence

Solution/Product/Service lifecycle.

S trong team player/mentor with self-starter attitude, wearing different hats, always

keeping in touch with Business to get feedback ASAP on current visible output and arrange

work direction accordingly, detail oriented Project Manager for onshore/offshore and mixed

Teams.

Delivering and supporting strategic targets and overall vision of Business

I n telligence/Performance Management platform to provide linkage of data with Users, internal

Customers and other Stakeholders/Product Owners/Senior Management

Have solid experience on successful lead of multiple simultaneous 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/

K nowledge logic/lineage documenting.

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/Transformer/Planning/TM1, Tableau Desktop/Server, SAP BW BI/Business

Objects/HANA, Oracle OBIEE/Hyperion, Microsoft SQL Analysis / Tabular / In tegration / Reporting

Services / SharePoint / Performance Point / Project Server / (SSAS, SSRS, SSIS), Qlikview Desktop/Server,

I nformatica PowerCenter, Control-M, RoamBI, D3.js, R, JasperReports, MicroStrategy, Excel data analysis

i ncluding Power BI

Databases:

Microsoft SQL Server/Azure SQL, Oracle, HP Vertica, DB2, AMZ Redshift, Google BigQuery, SalesForce.com,

Teradata, Hadoop/Hive/Pig/Sqoop, MongoDB

Languages/Automation/Source control systems:

XML, Ant/NAnt/CPPAnt, JavaScript, C#, VB.NET, Java, ER Studio, PowerDesigner, VBScript, Jenkins,

AccuRev/CVS/SVN/GIT/Perforce, CollabNet, JIRA/Confluence, SQL, T-SQL, PL/SQL, MDX, DAX

Various Industry and Departments Experience, incl. SDLC, Production, Marketing, Retail/Sales,

B udgeting/Forecasting, Treasury, HR, Client Issues management, In ternational Finance Accounting, etc.

EXPER IENCE

EPAM Systems (Chevron/TriZetto/Expedia ) E TL/DWH/B I expert

current Expedia ( Enterprise Data Warehouse) Global Suppliers Operations project.

Create and support processing of various Call data from multiple sources with

p roviding reporting solution thru DataMart and BI components linked to i t.

3.2012 C loud to BigData data processing with cleansing and storage with full changes for

h istory t race back. Team Lead role.

T r iZetto (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

– t o provide unlimited number of systems being process in one time for unified

data mart solution with reporting and exchange for 3 rd Party tools available.

Technical Lead role.

Chevron (Shelf of Mexico)/ HR and Projects Management Planning/Reporting

p roject.

Developed and delivered in t ime report for 5 areas of business using pixel-perfect

t echnique with complex KPI’s logics included and used. Team Lead role for BI

t eam.

Luxoft (Deutsche Bank ODC) i nvestment banking E TL/DWH/BI expert

3.2012 Deutsche Bank (Investment Banking Operations IT)/ OPAL M IS project.

Team lead and data model architect, manage activities/tasks/communications

5.2009 across Hong Kong/Singapore/London/New York/Cary businesses locations.

M anagement up to 4 developers of project team (>100 members) in 2 Ukraine

locations.

Domains: Client Issues, Trades, Trades Control, KPI, Capacity Management,

F inance, Costs Analysis, BI System User Activity Analysis, Risk Management

design/development/support activities with self-documenting of system,

automation. Data quality and metadata management.

W icom (comScore ) Telecommunications Senior Support Engineer I I I

(secondary)

3.2013 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 til l new

9.2011

requirements development as L3 Support Lead. On daily basis th ru 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.

F reelance Consulting

SaaS/manufacturing/agriculture/beverages/telecommunications P M/TL/Senior

p rogrammer

5.2009 Fi re I ntelligence - Q likview SaaS September 2013 – October 2013

Supporting new product generation development using Cloud and BI platforms

for Fire departments reporting automation.

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

- Developed set of reports and dashboards using latest IBM Cognos version

f unctionalityto deliver information about all running and planned Project

i ni tiatives 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 from old to new logic

- A utomated impact analysis and documentation generator

Philadelphia I nsurance 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

- A utomated documentation and graph refreshment for any future changes in MS

SQL Server and MS In tegration Services

- Delivered full parsing of any t-SQL code changes for CRUD (create, read,

u pdate, 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 G roup ' (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 1S 8.1 ERP system including IBM Cognos Planning integration with billing

data for daily based rolling budgeting process. Company ' I TC' ( telecommunications

company)

M icrotest consulting company MFCG/insurance/trading/manufacturing

P M/TL/Senior programmer

5.2009 Kimberly-Clark Russia /Enterprise people resource planning system. Conduct

t raining and background support for the int roduction of self-implementing of IBM

Cognos Planning & BI.

Sibirsky Bereg/Enterprise resource Planning System. The system was designed

t o automate the planning of the entire enterprise-from forecast sales of up to the

10.2007 p rojection of production and procurement of essential commodities.

I mplementation of the system has reduced the t ime and labor costs of annual and

year-round monitoring and review’s budget figures. As a result, the project

i nvolved in the ongoing process to 120 users in IBM Cognos Planning.

Oriflame Russia /planning for multinational companies. the automation of data

collection and consolidation of data on the two models is the world and Russia

business in IB M Cognos Planning. In teraction with the working groups based in

B russels and Prague.

T ask leader Cognos Planning in M icrotest /Preselling, Management,

M arketing, Training activities for IBM Cognos Planning on daily basis. PoC's for

t he insurance/automotive/food manufacturing/development companies

Brig-Retail, SAP-partner company

M FCG/banking/car rier/oil/manufacturing/telco Consultant on SAP BI

SEM/BPS/IP modules

11.2006 Kviza T rade, Fu rshet /Conduct t raining and background support for the

i nt roduction of self-implementing of SAP BI.

VikOil /Conduct t raining and background support for the int roduction of self-

5.2006 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

U MC (MTS Uk raine) /Consulting on project migration to the latest SAP BI BW

version

Arterium p harmaceutical I ndependent consultant for implement ERP

system

5.2006 The development model, project and guide the int roduction of IFS ERP in

conjunction with 1S ERP. Accounting, honeycomb warehouse, web portal for

10.2005 dealers, production planning and sales design/management of development.

Redesign of ERP processes and Payroll system to the new platform.

Development and management M FCG/oil/pharmaceutical/ P roject

M anagement & Developer

11.2006 In short:

Osnova - P ulp & Paper company, Project Manager for implementing of new ERP

1S 8.0 in >30 subsidiaries, M icrosoft BI+Cognos Planning implementation

11.1997 TNK Uk raine (TNK-BP) - Oil company, developer of ERP/BI subsystems

Remote developer team establishment and involving in big ERP development

p rojects for A konit

Color Union - Paint company, developer of ERP, head of IT

other IT specialties'/activities

Contact this candidate