Christopher Singleton
Bellevue, WA *****
***********@*****.***
www.linkedin.com/in/christophersingleton
Christopher Singleton Resume Website
Business Intelligence Developer / BI Analyst, Data Engineer, SQL Database Developer
Proficient using advanced T-SQL, Kusto aggregation Azure Integrations directly into Power BI using M-Query (including DAX for report dashboard developments), SQL Server Analysis Services (SSAS), building data marts with DAX in Tabular mode or Multidimensional MDX, ETL using T-SQL Scripts, SQL Server Integration Services (SSIS) with advanced C Sharp techniques and database modeling.
Over 8 plus years in Information Technology in the Fortune 100 sector, including Microsoft Corporation, Costco Corporation, and smaller companies. Associates of Applied Science degree in Information Sciences with the following relevant technical proficiencies: Please contact: Email - willing to relocate.
T-SQL, Joins, Subqueries, Unions, Cross Apply
Views, CTE’s, Stored Procedures, Functions
BI Full Stack (SSIS, SSAS, SSRS) Development
Indexing, Triggers, Partitioning, Optimizing
Kusto Lens Explorer, Azure, Power BI & Tableau
ASP.Net, C Sharp, JS, HTML, CSS, AJAX
C# objects, Inheritance, Polymorphism, Delegates
Extract, Transform & Load, SQL, C# (ETL)
Cube: Hierarchical/Relationship Configuration
Scripting: Tabular DAX /Multidimensional MDX
Normalized OLTP/De-Normalized OLAP Modeling
Star / Snowflake Schema Design, Data Mart
SSRS, Tableau, Excel Pivot Table Reporting
Visual Basic Scripting, VBA, DOS Scripting
Network/VPN Configuration: Microsoft Azure, Linux
Data Mining (SSAS) Cube structures, Flat Files
Agile/SCRUM/XP Software Engineering
Data: Validation (Regex), Integrity, Cleaning
Experience
Sr. Business Intelligence Developer 02/2020 – 08/2020
Logic 20/20 Seattle, WA (Microsoft Unmanaged Project Contractor v-chrs).
Data Warehouse Architecture, creating Data Marts, Tabular Models with Data Analysis Expression (DAX), Multidimensional Cubes with MDX scripting in SQL Analysis Services.
Advanced T-SQL using Triggers, Stored Procedures, Common Table Expressions (CTE's), OLAP and OLTP databases on Big Data structures in Azure and AWS near real-time cloud systems.
Data Integrations with SQL Server Integration Services in Visual Studio.Net (SSDT BI Tool Set) programming with C Sharp (C#) and T-SQL scripting. Knowledge of working with Power Apps.
Reporting Services (SSRS), Tableau Desktop, Power BI dashboard building on VOC Team.
Business Intelligence Developer / Analyst 05/2018 – 07/2019
Terawe Corporation (Microsoft Contractor v-sichri)
Created Kusto-Azure scripting through Lens Explorer for extracting, parsed aggregating near real-time UTC (2011-08-12T20:17:46.384Z) Spark Hadoop (HDFS) Big Cloud storage data, analyzed criteria-based data on Kusto Azure data lakes, integrated tables into Power BI through Power M-Query scripts and an Incident Customer Management (ICM) system for validation using Visual Studio Online (VSO) and SQL databases (RDBMS) that is also used for system checks / balances while creating CTE’s and Views using T-SQL. Solved performance / security problems on SQL data structures for CI DevOps, including T-SQL queries and DAX scripting.
Worked on five different Azure Spark data lakes (Multiple Blob Data Bricks) having to do with multiple projects, which included Kusto Azure related concepts with three different teams (ICM, CI Dev-Ops, and Management Telemetry). Changed dynamic SQL directly into joins and complex T-SQL queries for security purposes and validation. Troubleshooted DAX/back-end T-SQL code applied to Power BI knowledge of data science, analytics to identify performance issues while developing and modifying complex queries. Developed analytical dashboards with Power BI. Transferred data using SQL scripts and SQL Server Integration Services (SSIS).
Produced Data Modeling techniques by creating Data Marts for SQL Server Analysis Services (SSAS) in Tabular using DAX for building dashboards while also creating calculated and/or derived columns. Worked closely with team members and participated in SCRUM meetings with daily standups. Implemented work through merging branches to master using GitHub code in the CI team. Provided results in a timely fashion and consulted based on these findings for deliverables. Worked with modifying complex Power BI dashboards that had multiple matrix KPI’s with graphs, bar charts with drill down capabilities displaying date analytics using DAX.
Internship Management – Tutoring a student on an FPGA project and C Sharp. 03/2019 – 07/2019
Bellevue College Bellevue, WA (Tutoring/Managing an intern student while also working at Microsoft)
Tutoring – working on projects 04/2015 – 05/2018
Bellevue College, (Bellevue, WA) Worked on multiple projects including data architecture:
T-SQL: Complex query - Stored Procedures, Functions, Triggers, and Indexing
Data Visualization: Tableau Desktop (MDX), Power BI Desktop (DAX), SSRS, Excel Pivot
Data Warehouse Design: (OLAP) Data Marts, Star, and Snow Flake Schema’s
SSAS: Tabular DAX model design, Multidimensional MDX cube, Data Mining, and Analysis
SSIS: ETL Package creation, data integrations/cleaning with various sources and destinations
.NET: Polymorphism, Inheritance, Encapsulation, Abstraction, C# Object Oriented Programming
Document Control Specialist CATIA Aerospace Engineering Design 07/2011 – 04/2015
L & E Tubing (Lafarge & Egge Inc.) Lynnwood, WA
Controlled documents, part number system and revision control using the SQL database (add, modify, and delete the information in the database).
Proficiently wrote VB, VBA scripts with XML formatting and VB scripts to extract coordinate values of BOEING, BF GOODRICH model files into text files using various programming techniques, File System Operation programming (FSO), attributes and other geometrical information for production control and analysis. Worked with many different aerospace companies while solving technical related issues having to do with the revision in the design of drawings, models and inconsistent documentation.
Analyzed blueprints, CATIA Models and all documents, consulted with team members on various problems and how to fix such problems while staying within the guidelines of creating the best solutions. Proficiently designed tubes, sheet metal Parts, fixtures and jigs using CATIA V5 to manufacture specifications, including Geometric Dimensioning & Tolerances (G. D. & T.).
Collaborated with Quality Control management as a team to insure AS9100c manufacturing quality and implemented A.S.M.E. design standards while designing with CATIA V5. Completed assignments on time energetically while taking note of upcoming assignments for future preparations.
Business Customer Computer Technical Support 03/1999 – 04/2010
Costco Corporation (Business Center) Lynnwood, WA
Education
Bellevue College (Bellevue, WA): Information Systems - Business Intelligence:
Major: Associate’s in Applied Science Degree of Information Systems (AAS-T Completed)
Business Intelligence Database Developer Certificate
Business Intelligence Data Analyst Certificate
.Net Programming Certificate
Lake Washington Institute of Technology (Kirkland, WA)
Engineering Graphics Design: CATIA Certificate
Automotive Technician Certificate
Structural Steel Detailer Certificate