Bellevue, WA *****
Business Intelligence Developer, Data Engineer, SQL 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. Currently studying on my own time for a SCRUM (MSC) Certification.
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:
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 Azure Scripting, Power BI & Tableau Desktop
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
Business Intelligence Developer 05/2018 – 07/2019
Microsoft Contractor Redmond, WA
Created Kusto-Azure code through Lens Explorer for extracting, parsed aggregating data and analyzed criteria-based data on a Kusto Azure data lakes through M-Query scripts and an Information Customer Management (MASICM) system, validated using Visual Studio online SQL database (RDBMS) that is also used for system checks / balances while creating CTE’s and Views using T-SQL. Solved performance problems on SQL data structures for Dev-Ops.
Transformed data into Power BI directly and extracted from Kusto for modifying creations. Worked on five different Azure data lakes having to do with multiple projects, which included Kusto-Azure related concepts with three different teams (MASICM, MASCI Dev-Ops, and MAS Management). Changed dynamic SQL directly into joins and complex T-SQL queries for security purposes. Utilized Microsoft Visual Studio during validation and coding implementations.
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 Professional (including using DAX functionality) and handled automated, targeted communication channels for products and solutions from many sources. Created search functions, filters, calculated columns and derived columns with while using DAX in Power BI. Modeled similar data structures to validate using T-SQL scripts.
Internship Management – Tutoring a student on an FPGA project and C Sharp. 03/2019 – 07/2019
Bellevue College Bellevue, WA
Tutoring – Freelance student help partially while in college 04/2015 – 05/2018
Bellevue College, (Bellevue, WA)
T-SQL: Complex query - Stored Procedures, Functions, Triggers, and Indexing
Data Visualization: Tableau Desktop, Power BI Desktop, 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.).
Implemented Generative Shape Design to achieve engineering problems on drawings with CATIA. Modeled CATIA documents for coordinates of bends and distances for manufacturing.
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.
Manipulated drawings / models between CAD software’s, encrypt, import / export file type conversions using PGP Symantec. Converted CATIA V4 to V5 CATIA Products (Assembly) and CATIA Part Documents.
Installed and configured application software, including CATIA, CATIA Companion, Microsoft office, printer/plotter device and Adobe Acrobat Professional, Symantec PGP File Encryption to un-encryption of BOEING and BF GOODRICH files for documentation, analysis, revision(s), processing.
Business Customer Computer Technical Support 03/1999 – 04/2010
Costco Corporation (Business Center) Lynnwood, WA
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