We provide IT Staff Augmentation Services!

Business Intelligence (bi) Analyst Resume

Seattle, WA

TECHNICAL SKILLS:

Microsoft SQL Server, Excel, SQL, PowerBi, Azure DevOps, Google Cloud Platform, BigQuery, C#, Azure, Microsoft Visual Studio IDE, VSTS, SSIS, SQL Server Management Studio, GitHub, Kusto, Plx, Big Data, SharePoint, Python, Java, Data Mining, NetSuite (CRM), JavaScript, HTML, CSS, R, Microsoft Office Suite, Google products (Docs, Sheets, Presentation, Forms, etc.) OpenStreetMap (OSM), ArcGIS, ArcGIS Online, ArcGIS Server, TileMill, NeatLine, QGIS, PostGres, OpenGeo

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Business Intelligence (BI) Analyst

  • Review current reports and present recommendations on alternative and/or incremental automated reports to improve visibility, efficiency, cost improvement, and communication.
  • Produce PowerBI based monthly operating review across key channels using Google Cloud Platform sourced BigQuery database consolidating multiple reporting platforms.
  • Create reports and metrics dashboards on a recurring or ad - hoc basis to improve measurement and visibility of Key Performance Indicators (KPI)

Confidential, Redmond, WA

Data Analyst

  • Support engineering team by creating SQL queries and Kusto scripts to identify any discrepancies in data.
  • Use problem solving skills to improve and maintain data accuracy in production and development environments, oversaw deprecation process of dated reports.
  • Prioritize work tasks by creating pull request (VSTS) that need to be added to project repository and validate existing reports while creating documentation for each component of reports in Azure DevOps.

Confidential, Seattle, WA - SQL

Data Analyst

  • Transitioned major sales report from solely Excel based to SQL sourced resulting in 90% time savings to generate daily report.
  • Write queries using Microsoft SQL Server Management Studio, automating CSV imports using SQL Server Agent (SSIS) with jobs scheduled.
  • Implement mass data updates to 20,000+ records, develop reports, dashboards and searches to keep records accurate using Oracle NetSuite (CRM).
  • Creating SQL database views and manage database relationships. Supporting 30+ users with access to database.
  • Create AD-HOC reports for finance, sales, and warehouse teams providing metrics for operations using Excel incorporating pivot tables, formulas and data manipulation.
  • Assist with projecting $100+ million-dollar revenue stream and rate of growth over sales team, assisting with providing insights to improve performance.

Confidential, Seattle, WA

Operations Data Analyst

  • Developed training documents for 3 data analyst and coordinate work for analyst with direction from Program Manager; coordinated work through project charters.
  • Spearheaded Quality Control efforts of 150,000 data entries.
  • Maintain policy consistency across global efforts (15+ countries, 5 continents), provide analytical needs for global operations team of over 400 members.
  • Gather and analyze massive amounts of information (2 million+ entries) with reports.
  • Develop and automate reports, build and prototype (30+) dashboards to provide insights at scale.
  • In-depth understanding of queries, functions, manipulation of data, server interactions, database types, and field types.

Confidential, Seattle, WA

Field Operations Associate

  • Performed field data collections and information gathering/sorting and traveling on assignment for Google. Working 50+ hours weekly across the continental US.

Hire Now