Candidates About

John Dangov 

Owner/Sr. Consultant - Streamlined Solutions                                                                                                          2006 – Present

Results-driven senior BI/Big Data/Data Warehouse consultant having extensive experience producing multi-tiered, multi-terabyte, distributed deliverables across a diverse set of industries.  Vendor specific implementations are optimized from platform independent architectures and designs.

Technologies: Big Data/Relational/Dimensional Models. Tableau/PowerBI. Agile/Waterfall/Iterative methodologies.

Strengths

Technologies/Methodologies

PROFESSIONAL EXPERIENCE

·         Kaiser Permanente: Sr. Consultant (Contract – Streamlined Solutions)                                           Oct. 2017 – Present

Productionalizing Teradata, MPP, Data/BI projects.  ETL, DW, Data Vault Design, WhereScape Modeling.  Partitioning strategies now scale at table and job level.  Reduced processing window by factor of 3.

·         T-Mobile: Sr. Lead Architect/Manager (Contract)                                                                                       May – Sept. 2017

Convert existing adaptors from Oracle to Big data based Perl/Java ETL and reporting layers.  Introduced Agile steps into their Waterfall methodology and Test Harness.  Finished phase one a month ahead of schedule,

·         Microsoft: Principal Big Data/BI Consultant (Contract)                                                                           Nov 2016 - Feb 2017

Responsible for Cosmos ETL and Code Migration layers for Executive Power BI application for Azure cloud

·         Leeds: Sr. Data/BI Architect (Contract)                                                                                                       Sept 2016 – Nov 2016

Implemented a solution for consolidating 100 remote legacy SQL instances into a scalable centralized Power BI driven analytic layer.  Introduced Excel UI layer which enabled two-way ETL communication.

·         Disney: Sr. BI Architect/Data Engineer (Contract)                                                                                  Nov 2015 – Sept 2015

Assisted with executive level company reorg.  Identified suitable software, hardware, BI/Big Data/ETL platforms. Executive level Tableau/Redshift/Netezza financial reporting.  Implemented ETL framework written in Python and Test Harness. Defined new technical direction.  Was offered an in house position.

·         Farmers Insurance: Sr. Information Architect (In-House)                                                                   June 2015 – Nov 2015

Aligned IT Data Vision with Zurich's Big Data, BI, Data Governance and MDM strategies, IT Data Technologies and Future Solutions.  Oversaw outsourcing of $20 million data foundation projects

·         T-Mobile: Sr. Data/BI Architect (Contract)                                                                                              Mar 2015 – June 2015

Refactored big data layer. Eliminated bottlenecks for Tableau/Micro Strategy/Pentaho BI Layers.  Lead java BI and ETL development efforts.  Captured data models for existing systems.

·         Microsoft: Sr. Program Manager (Contract)                                                                                             Nov 2014 – Mar 2015

Supported transition of teams aligning with new Hadoop roles for Microsoft’s multi-year azure roadmap

·         Edifecs: Sr. BI/Data Architect (Streamlined Solutions)                                                                         July 2014 – Nov 2014

Reengineered Tableau BI/Big Data Platform for a meta data driven Medical Systems Integrator. Technologies include Pentaho ETL scripting, Tableau BI, SQL Server and Oracle backend.  Was offered an in house position.

PROFESSIONAL EXPERIENCE

·         Getty Images: Sr. Data/BI Consultant (In-House)                                                                                   Mar 2014 – July 2014

Reengineered a digital Power BI financial reporting layer from Oracle, MySQL, Cognos, Micro Strategy, and SSRS.  Mentored junior bi developers.

·         Premera: Sr. Data Modeler/Architect (Contract)                                                                                    Aug 2013 – Feb 2014

Responsible for dimensional and 3NF Health Care enterprise data models.  Projects include Medicare Advantage, Obamacare, and Tableau BI data mining.  Technologies include Netezza, Tableau, and Erwin.

·         Corbis: Sr Big Data/BI Consultant (Contract)                                                                                               Jan 2013 - Aug 2013

Architected and implemented BI and Big Data ETL layers for a new digital product.  The custom Java reporting layer ran on top of MongoDB.  The enterprise data warehouse and test harness ran on SQL Server

·         AT&T: Sr. BI/Data Consultant (Streamlined Solutions)                                                                           Oct 2012 – Jan 2013

Converted a PhP product managing multi-million dollar financial transactions. Refactored the data, ETL, test harness, and BI layers to MySQL and Inetsoft’s proprietary data and BI formats.

·         Microsoft: Sr. Data Architect (In-House)                                                                                                      Oct 2011 - Oct 2012

Architected and implemented a metadata driven ETL and Schema migration engine and test harness.  Enabled zero-downtime, future-dated release activations from heterogeneous terabyte sized CRM sources.  System detects and automates schema and record deltas.  Oversaw a log-shipping BCDR effort.

·         Microsoft: Sr. Technical Program Manager (Streamlined Solutions)                                            May 2011 – Sept 2011

Managed remote teams developing a BI Portal Offering and an enterprise level Data Quality framework.

·         Ernst & Young: Sr. Consultant (Contract)                                                                                                   Jan 2011 – May 2011

Oversaw phase one for a global scalability effort consolidating E&Y’s BI/Data/ETL layers for 145 offices.  The Microsoft BI/DW Stack was converted from an Oracle platform.

·         Net Motion: Sr. Data/BI Architect (In-House)                                                                                          May 2008 – Nov 2010

Responsible for the data and BI architecture of a new 2-terabyte real-time product. A QlikView and Tableau reporting layer ran on top of a MySQL Data Warehouse.  The meta-data driven installations are stand-alone, self-maintaining, configurable and customizable.  Introduced automated test harness.

·         Expedia: Dev Manager/Architect (In-House)                                                                                           Jan 2006 to May 2008

Responsible and accountable for development and management of 9 corporate financial enterprise systems. Came in as the only in-house senior database engineer.  Built a new team of high-caliber, in-house staff while replacing existing contract positions.  Technologies include SQL Server, DB2, Informatica ETL, Business Objects, .Net UI layers, and SQL Server test harness.

·         Microsoft: Sr. Data Architect (Contract)                                                                                                       Oct 2005 – Jan 2006

Responsibilities include data modeling, coding, ETL, test harness, and data conversion procedures of distributed SQL Server layers for the Vista Digital Licensing system.  Was offered an in-house position.

·         Tamarac: CTO/Dev Manager (In-House & Streamlined Solutions)                                                  May 2000 – Oct 2005

Responsible for all tiers of web based equities/financial portfolio optimization system.  Joined startup as a Principal C++ Engineer (employee 1).  Left as CTO.  Automated installs and test harness.  Sold for 55 Million

·         State of Nebraska: Sr. Program Manager (1 Year Visa Contract)                                                    Mar 1999 – April 2000

Managed the re-architecture of a Health and Human Services expert system.  40 business and technical areas were addressed.  Technologies include: AION, DB2, automated test harness.

EDUCATION

York University

M.Sc. – Computer Science: Object Oriented Design/Artificial Intelligence (50% Complete) A+ Average

B.Sc. – Specialized Honors Computer Science: Graduated top of class