o Developing BI assets using AWS analytics services: Glue, Redshift, Kinesis, RDS, S3, EC2o Scripting automation of ETL processes with Pythono Administration of AWS analytics services

o Design, development, and implementation for meta-data driven SSIS execution engine—allowing complex routing and sequencing of data extraction across disparate domains via automation.o Developed automated logging, monitoring, and alerting systems for database applicationo Developed training materials, documentation, and diagrams for ETL processes.o Provided leadership in debugging stored procedures, database performance, SQL Agent Jobs

o Lead re-design, development and implementation of database application architecture, ETL processes and reporting infrastructure - resulting in a 30x improvement in database performanceo Re-designed the Development, PPE, and Production database server environments specifically for Azure—implemented Azure Active Directory authenticationo Developed high-performance ETL processes using SSIS, Azure SQL databases, Azure Storage and SQL Server 2016 and consolidated environment-specific ETLs to parameterized SSIS processes configurable at runtime through Agent jobso Created Business Continuity Plan and Failover architecture for Dev, PPE and Production database environments and automated database archive/backup processes with Azure URL backup

o MYSQL data-warehouse design and development, technical documentation for reporting infrastructure for a LAMP based web application with an average of 200k unique users daily conducting nearly 100k transactions a dayo Charged with conducting rapid proof of concept and implementation of Google Compute and Google Big Query platformso High volume OLTP application development running on MySQL/Innodb and Linuxo Implemented Pentaho Carte server framework for remote job and transformation execution and monitoringo MYSQL management, stored-procedure development, indexing and performance tuning

o Lead design and development for new SQL database release features, performance tuning optimization, and ETL processes for Microsoft’s core financial data warehouse and reporting tool, Mercury o Lead migration of on-disk financial systems to In-Memory OLTP (Hekaton), SQL Azure, and Cosmos (Microsoft’s internal Big Data, DFS, platform) o Played SWE lead role for SSAS cube development and implemented role based security featureso Create/ship MSI packages for Mercury releaseso End to end ETL Design and database development for Microsoft Operations Center BI SQL Server data warehouse (server, network, event telemetry)o Integration of heterogeneous data sources e.g. OData, SQL, Blob—into unified data warehouse model for MSTicketing business intelligence customers o Indexing, performance tuning, maintenance operationso Managed SQL Server reliability: Always on High availability, monitoring and on-call resource

o Data Warehouse development and implementation, requirement gathering, and cross group collaboration to define the business logic that provides consistent and accurate data solutions o Quickly established as Database and SQL technology expert for team of financial analysts and play advisor role for troubleshooting and technology educationo Data modeling using DAX, MDX, PowerView and PowerPivot

o Responsible for Extraction, transformation, and loading of marketing lead generation datao Developed SQL server jobs and TSQL queries to be used for automating weekly reportingo Provided data analysis on Lead Generation for global sales constituents to ensure proper implementation of Email and Phone marketing campaign

o Developed and executed complex T-SQL queries within the SQL Server Data Warehouse, and CRM (GSX) environment for the identification and daily tracking of 100m to 1b in sales opportunities for Microsoft Managed Partner Reportingo Mapped and Integrated disparate data sources (GSX, MS Sales & MS Finance) into SQL Server and SSAS (OLAP) data sources while working with clients to define the business requirements for scorecard metrics and KPIso Deployed and refreshed SSAS (OLAP) cubes and provided analytical, technical and customer support for Gold Standard Business Intelligence Cubes (e.g. Managed Partner Reporting Cube). Trained and developed new analysts

o Wrote, edited and presented analysis of financial Intelligence and research—developed hypotheses, analytical points of view for business-critical matterso Provided financial modeling and forecasting to energy industry business unit o Worked with vendors to procure financial research and 10-k information on leading energy industry companies