Eugene Medlev's Email Addresses & Phone Numbers

📖 Summary

Hands-on Data Architect and Data Engineer with 18+ years of experience in Data / Information Modelling, BI / DW & Analytics Solution Architecture / Development, Big Data & NoSQL Architecture / Development, Data Science / Data Mining / Machine Learning, Cloud Architecture Broad experience in Architecture, Development, Delivery & Operations, leading mid-size software development teams and working with offshore resources. Technology stack: Data Management Systems: • Relational: Microsoft SQL Server, Azure, Oracle, MySQL, Sybase, DB2 • NoSQL: MongoDB, HBase, Cassandra • Hadoop Distributions: Cloudera, Hortonworks, Amazon EMR • Hadoop Ecosystem: Apache Hive, Apache Pig, Apache HBase, Apache Oozie BI / DW Methodologies: EDW R. Kimball, BEAM, EDW B. Inmon, Informatica Velocity, DAMA, TOGAF Business Intelligence: • MicroStrategy (Architect, Transaction Services, Mobile BI), SAP Business Objects, Tableau • Microsoft BI stack: SQL Server, SQL Azure, SSIS, SSAS, HD Insight Data Mining: R Cloud computing: Amazon AWS, Microsoft Azure ETL: Microsoft SSIS, Informatica, SAP BO Data Services, Talend, hand coded MDM: Informatica, MS SQL Server MDM, Ataccama Data Quality: SAP BO Data Quality, Informatica Data Quality, MS SQL Server DQ, Ataccama, OpenRefine Programming: T-SQL, PL/SQL, XML (XSD, XSLT, WSDL), JSON, MDX, DMX, XMLA, RDL, C#, .Net, Java Process / Data Modeling (CASE): CA ERwin/BPwin, Embarcadero ER Studio, Sybase PowerDesignerFounder / Principal Software Development Engineer @ Boutique IT consulting company specializing in: DW (Data Warehouse), BI (Business Intelligence), ETL, Analytics, Data Science, DI (Data Integration), Data Architecture, DQ (Data Quality), MDM (Master Data Management), Big Data, HADOOP, NoSQL, MPP (Massively Parallel Processing). Extensive expertise in: • Microstrategy Architecture / Development – by Microstrategy Certified Engineering Principal (MCEP) • Microsoft BI/DW/ETL/Data Architecture and Development – by Microsoft MCITP, MCDBA, MCP • Vendor neutral BI/DW/ETL/Data Architecture and Development – by TDWI Certified Business Intelligence Professional (CBIP) Past projects successfully delivered to: Kinross Gold, Hewlett-Packard, CIBC, TD, D+H, Workplace Safety & Prevention Services, Penson Financial From 2009 to Present (6 years) Toronto, Canada AreaBI/DW Architect / Developer @ Technologies: Microsoft SQL Server 2014, MS SSIS, MS SSAS, MS SSRS, MS MDM, MS DQ, MicroStrategy 9.5, Oracle, MS CRM, MS AX Dynamics, CA ErWin, C# • Architecture, design and development for: o “360-degree view of the Customer”, campaign management and customer loyalty o Market and customer segmentation o Revenue assurance and dynamic pricing o Operational Efficiency and Human Capital Availability / Utilization From August 2014 to Present (1 year 5 months) Toronto, Canada AreaData Architect (BI / DW / ETL, IoT) @ Technologies: MicroStrategy 9.4 (Architect, Transaction Services, Mobile BI), MS SQL Server 2012, MS SSIS, MS MDM, MS DQ, SAP BO Data Services, Ataccama Suite, Oracle, JDE, DB2, CA ErWin Big Data, Data Science: Cloudera CDH, Hadoop, HDFS, Sqoop, Pig, Impala, Hive, R, Splunk, Tableau Mining Technologies: OSIsoft PI, Dispatch (Devex, CAT), Minestar Health, VIMS, CAT • Architect, Design and Development of BI/DW solutions for Kinross Gold Mining Operations for Corporate and Regional needs following R.Kimball methodology. • Accountable for overall BI/DW architecture/design/development (Data, ETL, Semantical Layer) working with BI consultants from MicroStrategy, Adastra & Deloitte on delivering corporate BI dashboards, scorecards, reports including MicroStrategy Transaction Services write-back and Mobile BI capabilities. • Solution Architecture, Design and Development of ODS marts for Regional offices based on data sources from Dispatch, Smart Meters, Smart Equipment, combing with ERP data (Oracle JDE). • Solution Architecture, Design and Development of Operation Reporting solution collecting key operational metrics across Kinross (with delivery on mobile BI (iPad), extensively used by senior management across Kinross). • Data Quality Management implementation and integration with the existing solutions based on Ataccama to measure data quality issues over time and trending information • Leading a POC project as Big Data Architect with a goal of combining semi-structured and non-structured data collected by variety of Smart Equipment / Smart Meters (Performance and Health Data) across Kinross operations around the globe with other relational sources of data (Dispatch, ERP, geological systems) into coherent Enterprise Data Architecture. • Leading Predictive Maintenance project with the goal to alert employees for early identification of machine failures From July 2012 to August 2014 (2 years 2 months) Toronto, Canada AreaBI/DW Architect / Developer (BI / DW / Analytics) @ Technologies: SAP Business Objects Enterprise XI 3.1, MS SQL Server 2008R2, MS SSIS 2008R2, MKS, MS Visio 2010 • Responsible for end-to-end implementation of Business Intelligence analytical solution for Prime Brokerage (combining data from variety of sources: Stock Lending (Loanet), Settlement (ISM), Margin & Risk (Softek, Algo)). • Architecture, design and implementation of all parts of the solution including Data Layer (SQL Server), Semantical Layer (BO Universe) and Business Analytics (Reports, Scorecards and Dashboards) From June 2011 to July 2012 (1 year 2 months) Toronto, Canada AreaETL Architect / Developer @ Technologies: Informatica 8.6, Informatica B2BDT 8.6, COBOL, IBM DB2, MS SQL Server 2008/2008R2, MS SSIS, MS SSRS, MicroStrategy 9R2, ActiveBatch, ERWin, SVN • Oversee, architect, design and development of Data Management (Data Integration & BI) portion of the Broadridge PFSC conversion project. • Subject matter expert for unstructured data transformations with implementation in Informatica B2BDT. From December 2009 to June 2011 (1 year 7 months) Toronto, Canada AreaData Architect / Development Team Lead @ Technologies: Microstrategy 9, MS SQL Server 2005/2008 on Windows, MS SSIS, MS MOSS, MS SCOM, ERWin, ER Studio, SVN, various tools to support SDLC using .Net, XML & database / data development. • Lead redesign effort to build new generation of Business Intelligence (BI) & Advanced Reporting platform in SaaS environment (B2B with more than 600 clients) leveraging MicroStrategy 9 as DSS platform. From June 2008 to November 2009 (1 year 6 months) Toronto, Canada AreaData Architect @ Technologies: MS SQL Server 2000/2005 on Windows, Oracle 8i/10g on Solaris, MS DTS / SSIS, MS SSRS, MS SSAS, MS MOSS, MS TFS, ERWin • Lead the project to build new generation of company data models for Asset \ Portfolio management. From May 2007 to May 2008 (1 year 1 month) Toronto, Canada AreaSenior Database Engineer @ Technologies: MS SQL Server 2000/2005, MS DTS / SSIS, MS SSRS, MS SSAS, MS MOSS, MKS, ERWin, ER Studio • Performed general technical troubleshooting including query tuning, database and system performance optimization. Using re-factoring (re-engineering) patterns Dramatically improved level of performance / throughput for several crucial sub-systems in 1,000 – 1,000,000 times; • Performed comprehensive evaluation of Database Development Lifecycle at the company. Incorporated automated toolset (DBGhost) in order to automate / simplify Database Change Management (as a part of SCM). From January 2006 to May 2007 (1 year 5 months) Ottawa, Canada AreaData Architect / Senior Database Engineer @ Technologies: MS SQL Server 2000/2005 on Windows, Sybase, Clipper, MS DTS / SSIS, MS SSRS, MS SSAS, MS MOSS, MS WSS, VSS, ERWin • Delivered full range of assistance for deploying business analytical solutions – from project definitions, design and management, to spot expertise in a phase of an on-going project, to knowledge transfer for solution maintenance; • Was responsible for building and maintaining proprietary and third-party feed handlers; • Implemented data models and database design, data access and table maintenance codes From 2001 to 2006 (5 years) Greater New York City AreaSenior Database Engineer @ Technologies: MS SQL Server 2000, MS DTS, VSS, ERWin, various tools to support SDLC using .Net, XML, database / data development From 2001 to 2003 (2 years) Greater New York City AreaSenior Software Engineer @ Technologies: Oracle 8.x/7.x, MS SQL Server 7.0/6.x, Clipper, ERWin, Oracle Designer, various tools to support SDLC using C++, FoxPro, Delphi & database development Technical team lead for several projects: Sales force automation (SFA), Enterprise Performance Management (EPM), Human Resources Information System (eHR). From 1996 to 2001 (5 years) M.S.C.S., Information Technology @ Belarusian State University of Informatics and Radioelectronics From 1991 to 1997 Eugene Medlev is skilled in: ETL, Business Intelligence, Data Integration, Databases, Database Design, Oracle, Data Management, Microsoft SQL Server, Analysis Services, Business Objects, SDLC, Visio, Dashboard, Informatica, Microstrategy