Mission Viejo, California, United States
I'm a problem-solver: I'm happiest when I get a chance to dive into a new challenge and figure out solutions for people's problems. Ideally, I'd like to work somewhere where I'd be exposed to new technologies on a fairly consistent basis.
*Developed Python scripts for data uploads to Snowflake. *Built tables, views, and stored procedures in Snowflake for reporting and data warehouses.
• Prototyping and developing stored procedures and models in Azure Data Warehouse and Snowflake. • Building and maintaining data pipelines and ETL automation using SSIS and Python.
• Developed PowerBI and Excel reporting for T-Mobile For Business. • Prototyped and developed reporting tables and ETL processes in Azure Data Warehouse. • Built data pipelines into Azure Data Warehouse using SSIS and Python. • Won Winner's Circle Q2 2022 and Q1 2023.
• Migrated Excel reporting into PowerBI • Migrated and streamlined SQL queries and stored procedures
• Developed tabular model, DAX measures, and PowerBI reports for Office365 FastTrack team • Domain SME and ad hoc reporting for Enterprise Services Business Intelligence • Created SQL database in Windows Azure VM and built Excel reporting using DAX and tabular modeling in Excel PowerPivot for Microsoft Consulting Services Global Practices team • Updated and created documentation for XML-based Enterprise Services Risk Management tool • Temporary Microsoft Consulting Services BI Reporting Lead; acted as project manager and ad-hoc reporting analyst for Microsoft Consulting Services • Created SQL database for MS Services Sales Model Configurator. Built reporting workbook for Configurator using custom VBA • Maintained SQL database, as well as building Excel reports and workbooks for Microsoft Services Workforce Planning. Converted existing Excel reports to PowerPivot tabular model, removing slicer VBA and reducing file size • Created and updated Excel reports for Exact Target/Expedia using Excel PivotTables and PivotCharts • Updated monthly scorecard for Microsoft Technical Audience Marketing using Excel and SSRS • Built v1 of Microsoft GPF Services Growth Planning workbook in Excel • Built SharePoint site for Microsoft Customer Online Support Services team • Updated, filtered, and analyzed product data for Microsoft Small Business in preparation for Windows 8 compatibility testing
• Edited and updated articles and tables for Microsoft Encarta • Coordinated update content with European Encarta teams • Supervised monthly update builds for both DVD and online products • Tested monthly builds for editorial errors and software bugs
• Proofed, edited, and updated articles, tables, and charts for Encarta • Contributed articles to special projects, including Windows Mobile Total Access • Supervised monthly content updates for both DVD and online products • Coordinated monthly update builds for DVD and online products with Microsoft • Distributed proofreading assignments to proofing staff • Tracked and assigned bugs via Microsoft Product Studio • Tracked and reported monthly office expenditures • Responsible for tracking Encarta contributor contracts and collecting necessary tax data for accounting
• Responsible for maintaining and upgrading office computers and internal network