SKILLS:

• C#/.net
• SQL
• MDX/DAX
• SSIS/ADF (Azure Data Factory)
• Java
• Data Warehouse (ETL)
• USQL/Scope (MapReduce)
• C++/C
• Azure Data Lake (Cosmos/Hadoop)
• Azure Data Warehouse
• Azure Data Factory
• .NET Framework
• SQL Server
• Confidential BI Stack (Anaysis Services)
• Spark
• Entity Framework

EXPERIENCE:

Confidential, Redmond, WA

Data Engineer OneDrive/Sharepoint Data and Analytics

Responsibilities:

• Organized and lead the redesign of existing OLAP datamarts to drastically improve response time: average time to answer dropped by 2 orders of magnitude.
• Worked with business owners to identify data catalog design and drove the end to end implementation from cloud to presentation layer.
• Restructured all of the business group's cubes to have appropriate partitioning schemes based on data.
• Redesigned existing cubes to answer more questions while simultaneously reducing average time to answer from 15 minutes to 10 seconds.
• While also moving the data warehouse from a PDW appliance to ADW (Azure Data Warehouse).
• Created numerous data pipelines (Structured Streams) from raw logs.
• This was done using a generic text extractor that implement a schema defined from the source.
• Built and implemented an Analysis Service Router or Cube Router.
• This router can load balance or fault tolerant connections to cubes supplying an evergreen connection for reports.
• This was written completely c# and uses the Confidential connection to SSAS and can route connections based on geo and/or availability of the cube.
• Tagged stream for Confidential compliance for personal data to be removed if requested.
• This required all scripts that extract data from logs to flag private consumer data columns within Cosmos(Hadoop) cluster.
• Architect clients side telemetry data integration into data model for a more concise user count. This consisted of designing pipelines to flow the data for raw binary data to stuctured data within our NoSql data store(Cosmos)
• Built pipelines in ADF to push data to Interana for analysis by data science team.

Confidential, Bellevue, WA

Data Architect

Responsibilities:

• Update current db to accept new feature. i.e. Created tables and underling procedures to allow “Device Designs” associations with new device coming to the market place.
• Bug fix current systems ETL process that moves data between Azure and on premise servers.
• Manage data team members rewriting the ETL for moving data to the Azure db.
• Create BI report for field usage on DeviceDashboard and FeatureDevice.
• Manage deployment of bug fixes and feature releases for data team.
• DX team analytics project to acquire and process from multiple 3rd party sources of data into a single datamart.
• Building ETL using SSIS, WF4, AppFabric and Azure.
• Sangam WF for submitting Cosmos jobs and processing outputs.
• Building Scope scripts for sourcing Tableau reports on Edge adoption and retention.
• Working with the Confidential Team on Confidential cube and Lifecycle cube to determine better long term solution for reporting needs.
• General maintenance on the Confidential and Lifecycle cubes/ETL when it breaks.

Confidential, Redmond, WA

Senior BI SDE Office365

Responsibilities:

• Designed and implemented OLAP cubes for O365 commercial subscription reporting.
• This cube implemented a standard star schema and MOLAP configuration.
• Implemented a cube partition tool to build and purge partitions based on fact data.
• Created 30+ metrics for a MGX report in a short amount of time.

Confidential, Bellevue, WA

Senior BI SDE Bing Ads

Responsibilities:

• BI development using SQL Server/Analysis Services. Developed a cube builder in C# using the AMO and Confidential libraries.
• This new component builds an offline cube from historical data stored in a streaming file system.
• This project utilized WCF, MVC, WF4 and AppFabric for long running process.
• The site would submit a request through the web service to the workflow which then would pull metadata through another web service on the structure of the cube while concurrently submitting the query to the streaming file system to pull the fact data. Once the fact data was gathered it would notify the workflow to finish building the offline cube. After cube was built and email was sent to the user with a link to view the offline cube.
• Created new dimensions in a cube used for partner reporting and worked on ETL package to load value into dimensions and fact using BIDS.
• Developed a utility in C# that help manage cube(s) for the operations team. Gives them the ability to process and purge partition based on a user’s criteria. This was a command prompt utility that utilized the AMO library.
• Developed utility to create partitions on cube deployment then after deployment process partitions.
• This command line utility was written in C# made a connection to SQL server to pull metadata for the cube and determine what partitions to create. Used the AMO library to create the partitions at that point.
• Developed WF3 process for coping very large files concurrently and restartable from Cosmos to a 3rd party for analysis.
• Maintained a WF3 workflow that pulls click data from a Yahoo service for partner reporting.
• Created in C# a command line utility that converted XMLA scripts into AMO object.

Confidential, Shreveport, LA

Software Engineer

Responsibilities:

• Lead Developer on the accounting team.
• Wrote software for an accounting package for an alternate care facility. General Ledger, Payroll, Billing, AR/AP.

Confidential, Shreveport, LA

Software Engineer

Responsibilities:

• Lead Developer on the Mobile development team.
• Wrote customized software for the compact framework utilizing C# and SQLCE also worked with Oracle Lite on the PDA.
• Developed a software package that tracked chemical usage on foliage treatment in right of way areas.