YURI MARKOVICH Solon, Ohio
****@*********.***
EXPERIENCE SUMMARY
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.
PROFESSIONAL EXPERIENCE
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