Career Overview

Over 21 years of experience in IT including business requirements gathering and analysis, data modeling, solution architecture, application design and development, implementation and maintenance.
Over 12 years of experience in management with more than 6 years in IT projects and operations.
Over 17 years of experience in data warehousing, business intelligence and portal/dashboard development.
Domain experience includes airline reservations, B2G, clinical research, commercial software, financial services, IT consulting, mobile media and state government.
LANGUAGES
Scala
Python
HTML/CSS
XML/XSLT
SQL
SERVICES
AWS EC2
AWS SWF
MS SQL Server 2014 Integration Services
Tableau 7.0
Kibana 3.1.1
BIG DATA
Spark 2.x
Hadoop 0.20
AWS EMR
AWS Redshift
Cassandra 2.x
Elasticsearch 1.3.4
Kafka 0.8.1
DATABASES
PostgreSQL 9.0
MySQL 5.x
MS SQL Server 2014
MS SQL Server 2008 Analysis Services
Oracle 10g DBMS
TOOLS
Eclipse 4.x
MS Visual Studio 2013
CA ERwin Data Modeler 7.1
Git
AWS CloudWatch

Work Experience

EY Society, Bellevue, WA
Manager | Solution Architect. March 2017 – Present
Design and implement distributed pipeline workflows and data store to drive analytics around targeted market growth and consumer engagement. Technology: AWS EC2; AWS S3; AWS EMR; AWS Redshift; Snowflake; Airflow 1.7; Spark 2.1.0; Hadoop 2.6.0; Hive 1.0.0; Python; SQL [Direct To Consumer Analytics – Nike]
Senior Consultant. January 2013 – September 2016
Designed and developed distributed batch pipeline workflows that produce telemetry and other enrichments in data lake implementation and warehouse store. Technology: AWS EC2; AWS S3; AWS EMR; AWS Redshift; MySQL 5.6; Databricks 2.25; Spark 1.6.1; Hive 1.0.0; Python; SQL [Product Intelligence – Smartsheet]
Designed and implemented distributed data ingestion, warehousing and analytic platform that drives audience, content, customer experience and QOS reporting and metrics. Contributed to technology stack architecture, system topology, continuous delivery management, monitoring, data model and store design. Developed and operated real-time and batch pipeline workflows. Technology: AWS EC2; AWS S3; AWS SWF; AWS EMR; AWS Redshift; Cassandra 2.2; MySQL 5.6; Elasticsearch 1.3.4; Kibana 3.1.1; Kafka 0.8.1; Spark 1.6.0; Hadoop 0.20; Pig 0.11.0; Scala; Python; SQL [Reporting and Analytics - Verizon Go90]
Designed and implemented data warehouse and marketing analytics solution that consolidates vast data sources, streamlines reporting and surfaces key online health metrics. Technology: Azure Compute; MS SQL Server 2014; SSIS 2014; C#; T-SQL [Dynamics CRM Online Marketing – Microsoft Corp.]
Developed and implemented pipeline web service that pushes incremental updates of data entities onto message queues for digital identity graphing and downstream consumers. Technology: AWS S3; AWS Redshift; Scala; SQL; Chef 11.4.0; Grafana 1.8.0 [Engineering Data – Whitepages]
Designed, developed and maintained web log data pipelines for property intelligence, campaign reporting, and segmentation and scoring analysis. Technology: MS SQL Server 2012; Cosmos; SCOPE; Hive 0.7.1; C#; SQL [Central Marketing Group Data & Analytics – Microsoft Corp.]
Metaligence, LLC, Renton, WA
Owner | Principal Consultant. July 2002 – Present
Designed, implemented and maintained data infrastructure, reporting components, and internal web services which power the SaaS offerings that automate exchange of cash and financial data for corporate clients. Technology: GoGrid; SQL Azure; MS SQL Server 2008; SSIS 2008; SSRS 2008; XML/XSLT; ASP.NET 4.0; WCF; LINQ; C#; T-SQL [Trellis Integration Partners]
Designed, implemented and operated end-to-end data warehouse and BI solution that drives loss development analysis, exposure monitoring, and historical premiums and reserves trending of personal insurance products. Technology: MS SQL Server 2008; SSIS 2008; SSRS 2008; C#; T-SQL [Mutual of Enumclaw Insurance]
Designed, implemented and operated end-to-end data warehouse and BI solution that facilitates book-of-business and premium analyses of personal insurance products. Support financial reporting and provide ongoing integration of new product lines. Technology: Oracle 10g DBMS; MS SQL Server 2008; SSIS 2008; SSAS 2008; SSRS 2008; C#; PL/SQL; T-SQL [Mutual of Enumclaw Insurance]
Designed, implemented and supported data warehouse and BI solution that bolsters pricing/rating model analysis and quote efforts of multivariate insurance products. Technology: MySQL 5.1; MS SQL Server 2005; SSIS 2005; SSAS 2005; SSRS 2008; VB.NET; T-SQL [Mutual of Enumclaw Insurance]
Designed and developed restaurant chain’s online recruitment site featured self-service job postings, management, search and application. Technology: MS SQL Server 2000; MS SQL Server 2000 DTS; MySQL 3.23; PHP; Perl; ASP.NET 1.1; C#; T-SQL [Restaurant Recruit, Inc.]
Pinnacle Group, Dallas, TX
Data Engineer. September 2016 – March 2017
Designed and implemented distributed data ingestion, warehousing and analytic platform that drives audience, content, customer experience and QOS reporting and metrics. Contributed to technology stack architecture, monitoring, data model and store design. Develop and operate real-time and batch pipeline workflows. Technology: AWS EC2; AWS S3; AWS Redshift; Kafka 0.8.1; Spark 2.1; Scala; Python; SQL [Reporting and Analytics - Verizon Go90]
AudienceScience Inc., Bellevue, WA
Business Intelligence Engineer. June 2012 – December 2012
Designed and implemented distributed data warehousing and processing infrastructure that supports prototype reporting requirements, synthesis, and mining over web logs, user profiles and application dimensions. Deliverables included technology stack selection, system architecture, data restructure, data store design, ingestion and map-reduce transformation development. Technology: Amazon EC2; Amazon S3; Amazon EMR; MySQL 5.1; Hadoop 0.20; Hive 0.7.1; Pig 0.8.1; HBase 0.90.6; Sqoop 1.3; Oozie 2.3.2; ZooKeeper 3.3.5; Whirr 0.5; Java; SQL [Business Intelligence]
Operated data warehouse and BI solution that drives campaign performance metrics, advertiser bid and publisher payout analysis, and financial management reporting in online advertising space. Technology: PostgreSQL 9.0; MySQL 5.0; Hadoop 0.20; Pig 0.8.1; Pentaho DI 4.2; Tableau 7.0; SQL [Business Intelligence]
Business Intelligence Consultant. April 2009 - November 2009
Developed enhancements for financial data warehouse that supports claim management and billing reports. Technology: IBM DB2; Oracle 10g DBMS; MS SQL Server 2005; SSIS 2005; SSRS 2005; VB.NET; PL/SQL; T-SQL [Mutual of Enumclaw Insurance]
Business Intelligence Solutions Architect. December 2008 - April 2009
Drove business intelligence and data warehouse solutions to meet customer needs. Responsibilities include: project management, recruitment and business development.
Designed and implemented ETL and data mart solution to facilitate systems integration and data quality management efforts. Technology: Oracle 10g DBMS; MS SQL Server 2005; BO Data Integrator XI R2; PL/SQL; T-SQL [Data Quality Management – AT&T Mobility]
Business Intelligence Solutions Architect. March 2005 – December 2008
Drove business intelligence and data warehouse solutions to meet customer needs. Responsibilities include: project management, recruitment, business development, technical and sales support.
Developed analytical and reporting solutions to drive marketing resource planning and forecast, and to better customer and opportunity targets. Technology: MS SQL Server 2005; SSAS 2005; SSIS 2005; C#; T-SQL; MDX [SMS&P Market Intelligence - Microsoft Corp.]
Led support and enhancements of financial planning and budget forecasting systems. Technology: MS SQL Server 2005; SSAS 2005; SSIS 2005; MS PerformancePoint Server 2007; T-SQL; MDX [Finance Solution Delivery - Microsoft Corp.]
Designed, implemented and operated multi-terabyte data warehouse and OLAP reporting solutions to improve asset management, incident management, data center services, system events support, and to facilitate click-stream analyses and inter-departmental billing. Managed portfolio consists of more than 25 systems and 100 servers. Technology: MS SQL Server 2005; SSAS 2005; MS SQL Server 2000; SSAS 2000; SSIS 2005; MS SQL Server 2000 DTS; SSRS 2005; ProClarity 6.2; T-SQL; MDX [Windows Live Operation Intelligence - Microsoft Corp.]
Designed and developed database and processing engine for a billing application that improves the accuracy and efficiency of invoicing process. Technology: MS SQL Server 2000; T-SQL [LexisNexis Applied Discovery Inc.]
Implemented ETL, data marts and scorecard portal solution to improve field productivity, operational cost factors and customer service performance. Technology: MS SQL Server 2005; SSAS 2005; SSIS 2005; SSRS 2005; MS SharePoint Portal Server 2003; MS Business Scorecards Manager 2005; MS MapPoint 2004; T-SQL [SMSG Communications - Microsoft Corp.]
Designed content and publishing framework and prototyped installable for an SDK providing single source of guidance for deploying sites on Microsoft.com. Technology: MS Help 2.0; MS Visual Studio .NET Help Integration Kit; DHTML; XML/XSLT [MSCOM – Microsoft Corp.]
Enterprise Data Services Manager. February 2002 – March 2005
Oversaw day-to-day operation of a team of database administrators and engineers responsible for the design, implementation, administration, and support of enterprise-wide database systems and data warehouse. Responsibilities included: strategic business planning, policy and guidelines, personnel administration, project management, procurement, vendor relations, service continuity planning and security compliance. [Information Services]
Implemented and managed $1.2-million data warehouse and BI solution to facilitate tax revenue discovery, reduce recovery costs, and improve compliance – generated $13 millions in revenue to date. Technology: MS SQL Server 2000; SSAS 2000; MS SQL Server 2000 DTS; BO 6.1; BO WebIntelligence 6.1; C#; T-SQL [Information Services]
Implemented and administered portal workspaces and operation analytics to improve customer support and to streamline operation. Technology: MS Windows SharePoint Services 2.0; MS SQL Server 2000; XML/XSLT; ASP.NET 1.1; C#; VB.NET; T-SQL [Information Services]
Information Technology Application Specialist Level 5. December 2001 – February 2002
Designed and deployed an intranet application enabling finance office to conduct expenditure and budget management - achieved 405-hour reduction in annual processing time. Technology: MS SQL Server 2000; Oracle Developer/2000 Reports 2.5; DHTML; ASP 3.0; T-SQL; Seagate Crystal Reports 8.0 [Information Services]
Software Database Engineer II / Consultant. February 2001 – December 2001
Architected and deployed division intranet portal allowing project teams to collaborate on marketing efforts and to centralize content management. Technology: MS SharePoint Portal Server 2001, MS SQL Server 2000; DHTML; XML/XSLT; ASP 3.0; T-SQL [Windows .NET Server Marketing - Microsoft Corp.]
Designed and built a customer intelligence intranet application that manages marketing reference leads collection process. Technology: MS SQL Server 2000; MS SQL Server 2000 DTS; DHTML; XML/XSLT; ASP 3.0; T-SQL; Seagate Crystal Reports 8.0 [Windows .NET Server Marketing - Microsoft Corp.]
Onvia.com, Seattle, WA
Senior Software Engineer. June 2000 – February 2001
Integrated and implemented a syndication system to streamline subscription and distribution of online contents. Technology: Oracle8i DBMS; Kinecta Interact 3.1; XML; PL/SQL [News, Tools & Community]
Integrated and implemented an online community to facilitate site stickiness and user-created content. Technology: Oracle8i DBMS; Allaire ColdFusion Server 4.5; O'Reilly WebBoard 4.2; CFML; DHTML; XML; ASP 2.0; PL/SQL [News, Tools & Community]
Acting Development Lead. March 1999 – June 2000
Responsible for architecture, development, operation and administration of A/R data warehouse providing financial intelligence to 2,200 corporate users worldwide. [MS Credit]
Designed and deployed a 12-GB data factory that processes billing data and business metrics from the FI-AR module of SAP data warehouse. Technology: MS SQL Server 7.0; T-SQL [MS Credit]
Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis. Technology: MS SQL Server 7.0 and 6.5; T-SQL [MS Credit]
Meridian Partners Limited, Bellevue, WA
Software Database Engineer I / Consultant. July 1998 – March 1999
Implemented subject areas, functional enhancements and system upgrades for a 15-GB A/R data warehouse. Technology: MS SQL Server 6.5; T-SQL; VB 6.0 [MS Credit - Microsoft Corp.]
Developed web-based analytical and reporting applications for corporate A/R intranet. Technology: MS SQL Server 7.0 and 6.5; DHTML; ASP 2.0 [MS Credit - Microsoft Corp.]
Implemented a team web portal to facilitate online system and production support documentation. Technology: DHTML; ASP 2.0; Adobe PhotoShop [MS Credit - Microsoft Corp.]
Mastech, Inc., Atlanta, GA
Developer / Consultant. July 1997 - July 1998
Reengineered the benefit fulfillment workflow to improve management control and completion time; Implemented a file tracking/messaging system that manages the request resolution process for all of State employee retirement systems. Technology: Lotus Notes 4.6; LotusScript [Employees’ Retirement System of Georgia]
Designed and implemented a database application enabling work group to manage daily research requests. Technology: MS SQL Server 6.5; T-SQL; VB 5.0 [Georgia State Senate’s Research Office]
Implemented spreadsheet solutions that monitor clinical trial studies and provide management and research teams with summary views and graphical analyses. Technology: MS Excel 95; MS VBA [WorldWide Clinical Trials Inc.]
Re-designed and built a database application that allows users to import and manage corporate fax-listings. Technology: MS Access 2.0; VB 4.0; Seagate Crystal Reports 4.0 [Western Union Fax Services Inc.]
Software Engineer / Technical Lead. July 1996 - July 1997
Developed and implemented a membership marketing decision-support tool that generates business reports for electronic-mail distribution. Technology: MS SQL Server 6.5; SQL; VB 4.0; Seagate Crystal Reports 5.0 [SkyMiles]
Designed and developed an ActiveX DLL that extends the middle-ware functionality of an existing set of C APIs -- providing client-side projects an enhanced object-oriented interface to the mainframe. Technology: VB 5.0 [SkyMiles]
Designed and developed a CTI module that provides agents real-time customer information retrieval over a transaction-processing system. Technology: Platinum Paradigm Plus 3.5; Borland C++ 4.5 [SkyMiles]
Led Windows migration project consisting of 300 workstations located in two cities; developed and deployed thirteen legacy front-end applications -- providing phone agents enhanced terminal-computing and report generation capabilities. Technology: VB 4.0; Seagate Crystal Reports 3.0 [SkyMiles]
Ion Design Co., Seattle, WA
Application Developer. December 1995 - June 1996
Implemented a marketing database application that provides users views and reports on customer, contact and product information. Technology: MS Access 2.0; VB 3.0; Seagate Crystal Reports 3.0

Recognitions & Awards

DataStax Certified Developer on Apache Cassandra.
Cloudera Certified Administrator for Apache Hadoop (CCAH): CDH4.
Cloudera Certified Developer for Apache Hadoop (CCDH): CDH3.
ITIL V3 Foundation in IT Service Management.
Washington State Department of Revenue Exceptional Employee Recognition 2003.
Washington State Department of Revenue Quality Improvement Award for Financial Information System Re-write 2002.

Education

Bachelor of Arts in Business Administration, June 1995
Management Information Systems and Corporate Finance
Bachelor of Arts in Economics, June 1995
International Economic & Reform Development
Cassandra Developer
Business Intelligence Developer
SQL Server 2005 Business Intelligence