Sign in

Data Manager

Cleveland, OH
March 05, 2019

Contact this candidate





Over 20 years of experience in the software industry: Data Architecture, Business Analytics, Database and Application Design and Development, Team Leadership

Areas of experience: Logical and physical Data Modeling, Gathering business requirements, Data Governance, Project management, Design and development, Data Analysis and Presentation

Application areas: Business Intelligence, Data Warehousing, ETL, Data Integration, Operational Data Store, Data Lake, Application Interfaces, ERP, Master Data Management

Technical skills: MS SQL Server, Oracle, Informatica Cloud, Tableau, Salesforce, NetSuite, OBI Applications, ODI, Oracle Applications, Business Objects, Cognos

Ability to transform complex corporate business tasks into elegant technical solutions with a robust and scalable design. Excellent analytical and decision-making skills; attention to detail. History of learning new technologies quickly. Efficient leadership.


2013 – 2018 Verizon Connect / Fleetmatics, Cleveland

Manager - Data Architect

Built and lead the Data Architecture/Business Intelligence team of business analysts, data scientist, and developers

Created a Business Intelligence strategy

Lead application and database selection effort for the BI/DW

Mentored and coached team members to ensure their professional development

Together with PMO executed large-scale projects

Identified Data Quality issues and proposed a resolutions mechanism

Developed multiple Data Models for Analytical solution

Owned and delivered KPIs for various lines of business

Improved delivery mechanism of consistent and reliable information to executives

Architectured end-to-end BI solution including ETL, corporate Operational Data Store, Data Warehouse, and Visualization layer using Tableau dashboards

Introduced concept of self-adjusted ETL processes

Defined a security model for DW/BI

Optimized SQL queries

Implemented a roadmap for BI from a short-term reporting solution for disconnected business systems to a robust corporate solution

Designed the move of corporate DW and BI solution to the AWS environment

2012 – 2013 Arrow Electronics, Cleveland

BI Architect

Extended Corporate Financial Data Mart: new star schemas, ETL processes

Reviewed and optimized corporate Data Warehouse

-Implemented a new security model for Data Warehouse

-Proposed new database structure to streamline design and improve performance

-Introduced Data Warehouse documentation approach

2012 Safeguard Properties, Cleveland

ETL Lead

Re-architectured Company Data Warehouse and BI solution

Established Data Warehouse and ETL standards

1997 – 2012 Agilysys, Cleveland

Manager - Data Architect

Business Intelligence, Data Warehouse, and Data Marts, Database design and development, Project management, including coordination of off-shore development, Senior-level programming, and technology evaluation.

Major projects and responsibilities:

OBIEE Implementation

-Created implementation strategy for OBIEE Analytics

-Led the team through the implementation of custom Financial Sales Analytic (based on AR, GL, and Order Management Analytics) and Project Analytics

-Worked with business leaders to ensure a successful BI implementation

-Designed ETL processes, RPD, and Dashboard strategy

-Worked with business and Oracle ERP teams to perform data cleansing

-Presented Agilysys OBIEE solution at Oracle Open World

Oracle Applications Implementation

-Evaluated ERP alternatives

-Defined technical standards, naming convention and conversion/interface strategy

-Performed data analysis to optimize setup and conversion processes

-Participated in Master Data Management and Data Governance initiatives

-Designed conversions/interfaces and led the team through the development cycle

-Lead EDI implementation for vendor feeds

Operational Data Store (ODS) and Corporate Data Warehouse

-Made logical and physical design for ODS and Data Warehouse including gathering and analyzing business requirement, data modeling, creating Oracle objects, data mining

-ETL: Transformed and loaded data into Oracle ODS using DataStage and SQL Loader; developed reusable ETL job template for the legacy system

-Designed and built Data Marts

-Developed security model for ODS and Data Warehouse

Corporate reporting system

-Delivered business reports to end-users using Brio and Oracle Discoverer

-Developed Metadata / Data Dictionary including corporate naming convention

-Designed Data Models for power users

Data interfaces among heterogeneous corporate applications such as ODS, Order System, Siebel, Oracle Financial, Compensation, Adaytum budgeting system, Vendor feeds

1985 – 1997 Telecommunications Research Institute, Odessa, Ukraine

Senior Development Analyst / Software Engineer

Analysis, design, logical and physical data modeling, coding, testing, documenting, maintenance, and customer training. Led the team through projects’ full life cycle.

Mayor projects:

Parameter-driven accounting system easily adaptable to frequently changing accounting rules

Bank application that allowed a company to control its bank accounts in the real-time (similar to Online Banking), including security and communication systems

EDUCATION MS in Telecommunication Engineering, Institute of Telecommunication, Odessa, Ukraine

Contact this candidate