Owner | Principal Consultant. July 2002 – Present
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 Redshift; Kafka 0.8.1; Spark 2.1; Scala; Python; SQL
[Reporting and Analytics - Verizon Go90]
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: SQL Azure; MS SQL Server 2008; SSIS 2008; SSRS 2008; ASP.NET 4.0; 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]
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]
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.]
Solution Architect. September 2019 – June 2022
Provided guidance and direction to engineering resources, and leadership on data architecture implementation of IoT solutions and IoT analytics capabilities. Served as SME engaging in technology/industry forums, client pursuits, presales support, workshop/proposal, and project mobilization. Collaborated with partner providers on business development, GTM strategy, solutioning, and consulting services delivery. Designed and developed showcase and POC solutions, and helped enabling IoT and edge computing collateral.
[Cross Industry Solutions]
Manager | Solution Architect. March 2017 – August 2019
Architected and implemented data ingestion, warehousing, and analytic platform in NIPRNet and SIPRNet that integrates disparate data sources and powers dynamic leadership dashboard. Provided cloud solution strategy, modern data architecture, technology roadmap, cost evaluation, system topology, continuous delivery management, security assessment and controls, data modeling and store design.
Technology: AWS GovCloud; AWS Secret; Azure SQLDW; MS SQL Server 2017; Azure Data Factory; Databricks 4.2; Spark 2.4.0; C#; Python; SQL
[US Army]
Develop showcase solutions and partner with client pursuits on creating POC’s and presentations on cloud architecture, data analytics platform, facial recognition experience and entity management graph.
Technology: Azure App Services; Azure Cognitive Services; Azure CosmosDB; Azure SQLDW; Azure Data Factory; Databricks 4.2; Neo4j; Spark 2.3.0; ASP.NET; C#; Scala; Python; Cypher; SQL
[EY Wavespace]
Designed and implemented pipeline workflows and data models to drive analytics around inventory management, targeted market growth and direct-to-consumer engagement.
Technology: AWS EMR; AWS Lambda; AWS Athena; AWS Redshift; Snowflake; Airflow 1.7; Spark 2.1.0; Hadoop 2.6.0; Hive 1.0.0; Python; SQL
[Marketplace Analytics – Nike]
Senior Consultant. January 2013 – September 2016
Designed and developed pipeline workflows that produce telemetry and other enrichments in data lake implementation and warehouse store.
Technology: 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 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: MS SQL Server 2014; SSIS 2014; C#; T-SQL
[Dynamics CRM Online Marketing – Microsoft]
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 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]
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: AWS 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 Solutions Architect. December 2008 - April 2009
Drove business intelligence and data warehouse solutions to meet customer needs. Responsibilities included: 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 included: 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]
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]
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]
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]
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]
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]
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]
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]
Development Lead. March 1999 – June 2000
Responsible for architecture, development, operation, and administration of AR 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 AR data warehouse.
Technology: MS SQL Server 6.5; T-SQL; VB 6.0
[MS Credit - Microsoft]
Developed web-based analytical and reporting applications for corporate AR intranet.
Technology: MS SQL Server 7.0 and 6.5; DHTML; ASP 2.0
[MS Credit - Microsoft]
Implemented a team web portal to facilitate online system and production support documentation.
Technology: DHTML; ASP 2.0
[MS Credit - Microsoft]
Developer | Consultant. July 1997 - July 1998
Re-engineered 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 email 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 2 cities; developed and deployed 13 legacy front-end applications - providing phone agents enhanced terminal-computing and report generation capabilities.
Technology: VB 4.0; Seagate Crystal Reports 3.0
[SkyMiles]