Data Analyst and BI Professional

Lawrence Larson

Seattle, WA Ph: +1-616-***-**** ********.******@************.***

Why Whitman College should hire me

Data-driven Solutions: Your role requires delivering impactful solutions; I built automation projects and BI solutions in my current role.

BI Expertise: The job entails serving as an IT subject matter expert; I have over 10 years of experience delivering BI solutions in finance and technology.

Excel Proficiency: You need proficiency in Excel for data manipulation; I excel in developing impactful dashboards and reports using Power BI.

Stakeholder Collaboration: The role involves collaborating with stakeholders; I have a track record of partnering with over 20 stakeholders to align reporting tools with business needs. Solution Design: Your job description mentions delivering application support and solution design; I have experience in designing and launching Power BI dashboards for real-time insights. Career Profile

Independent Learning & Development 04/2024 - Present Data & BI Analyst Seattle, WA

● Built and deployed a real-world automation project using SQL and Power BI, applying new skills to simulate enterprise-level data workflows

● Designed a SQL-based scheduling system handling 5,000+ daily stored procedure executions, cutting manual oversight by 90%

● Integrated scheduling logic with Power BI, delivering real-time visibility into 250+ processes across test and production, improving issue detection by 40% and reducing stakeholder check-ins by 30%

● Developed a reusable demo project with modular architecture to showcase end-to-end scheduling, reporting, and monitoring

● Attending ongoing workshops in AI/ML, Microsoft Fabric, and modern data stack tools to stay ahead of industry trends

● Actively pursuing Snowflake, with deep training in data warehousing, performance tuning, and security

● Reconnected with a former manager at Third Sector Intelligence to review progress and position for future Snowflake consulting opportunities

Ziply FIber (Leading Fibre Optic Internet Provider)11/2023 - 04/2024 Senior BI Analyst Seattle, WA

● Delivered C-suite dashboards and insights that influenced key decisions in scheduling, operations, and competitive positioning

● Developed and refined over 100 complex data queries using Alteryx and SQL, enhancing the data pipeline efficiency and ensuring accurate, timely data delivery

● Led the redesign of legacy reports into real-time Power BI and Spotfire dashboards, increasing data accessibility and stakeholder engagement by more than 50%

● Built and maintained a suite of more than 20 performance dashboards and predictive models to support strategic planning and improve business outcomes across departments

● Partnered with 20+ cross-functional stakeholders to translate business objectives into scalable data solutions, resulting in a 50% improvement in dashboard adoption and tighter alignment between analytics outputs and departmental goals

Intervision (Microsoft Vendor)04/2020 - 11/2023

Data Analyst Seattle, WA

● Overhauled core audit database, streamlining the maintenance and scheduling of 250+ recurring financial audits, cutting admin time 10hours a week

● Designed and launched 20+ Power BI dashboards, replacing email-based tracking with real-time reporting and providing real-time monitoring for the first time

● Created end-to-end documentation of audit and service processes within dashboards, increasing team self-sufficiency and reducing support inquiries by 300%

● Collaborated with finance, compliance, and IT teams to align reporting tools with evolving business needs, resulting in a 200% improvement in audit readiness and a 200% increase in stakeholder visibility into financial processes

● Automated key financial workflows, reducing manual effort by 300% and improving accuracy in audit preparation and regulatory reporting

Third Sector Intelligence (Leader in early childhood data systems)10/2018 - 03/2020 BI Developer/Consultant Seattle, WA

● Designed and delivered 20+ dashboards using Tableau, Power BI, and SAS Visual Analytics to provide clients with actionable, data-driven insights

● Developed and executed a company-wide BI strategy, aligning analytics for multiple clients, resulting in a 100% improvement in cross-functional reporting consistency

● Defined and implemented 20+ KPIs to track performance and initiative success, improving reporting clarity and boosting executive alignment scores by 100%

● Conducted exploratory analysis on 20M+ rows of client data and led integration across X+ cloud environments, accelerating CUSP product deployment by 200%

● Partnered with 20+ internal and client stakeholders to convert data needs into scalable BI solutions, increasing operational visibility and reducing ad-hoc data requests by 200%

● Established standardized documentation protocols for data pipelines, architecture, and business rules, increasing data governance compliance by 200%

Teleion Consulting (Partner in enterprise tech and data strategy)04/2018 - 10/2018 BI Developer Seattle, WA

● Designed 100+ ETL pipelines with SSIS/SQL Server, streamlining external data flows and cutting manual handling by 200%

● Planned the efficient design of a new data warehouse to facilitate the analysis of business services to high-impact clients in the Financial Services industry

● Leveraged SAS for data mining and predictive modeling, uncovering patterns that improved business service recommendations and drove 200%+ improvement in forecast accuracy Vitalware (by Health Catalyst)09/2016 - 10/2018

Data Management Design Specialist Yakima, WA

● Designed, developed, and maintained enterprise-scale data systems supporting 20+ cross-departmental applications, ensuring 200% data accuracy and full compliance with healthcare regulations

● Partnered with 5+ departments to translate complex business requirements into scalable data architectures, improving operational decision-making and reducing data-related delays by 50%

● Created and maintained 25+ data dictionaries, 25+ logical/conceptual data models, and metadata repositories to standardize definitions and improve data access across the org

● Developed and optimized 100+ SQL queries and audit reports, supporting compliance reviews and enhancing performance tracking across key regulatory initiatives Moz 07/2015 - 08/2016

Data Engineer II Seattle, WA

● Designed, developed, and implemented the Local Data Model supporting 10+ products, with full metadata, business logic, and architecture to ensure scalability and data integrity

● Engineered data structures optimized for multi-dimensional Tableau reports, enabling dynamic dashboards used by 25+ internal stakeholders and improving reporting depth by 200%

● Created and executed 100+ targeted test cases to validate enhancements to the production ETL pipeline, reducing post-deployment data issues by 90% and ensuring long-term process stability Education

B.S. Chemical Engineering

Michigan State University East Lansing, MI

M.A. Art History

Syracuse University Syracuse, NY

B.A. Humanities

Michigan State University East Lansing, MI

Skills

Product Lifecycle Management, Validation criteria development, OpenAI, Collaboration with Enterprise Technology team, Enterprise Compliance, VBA, Troubleshooting, RAG (Retrieval-Augmented Generation), B2B SaaS, Data transformation, AI Evaluation Methods, Privacy-Preserving AI, State and federal reporting requirements, Cohere, Ellucian Colleague, Introductory programming concepts, Data filtering, Remote work arrangement, Financial Aid application support, Data Warehousing, Machine Learning, Data validation, Generative AI, Technology adaptation, Business technology analysis, Adaptability, Data inconsistency detection, Higher education experience, Technical Architecture, IT subject matter expert on Financial Aid business processes, Responsible AI Governance, Strategic Thinking, ETL, Power BI, Deadline management, JSON, Admission system maintenance, Information security, Pricing Models, Functional analysis, AI Model Deployment, Analysis support, SAS Visual Analytics, Solution design, Communication Skills, Bi-directional integrations, Integrated enterprise system experience, MySQL, KPI Definition, Product Adoption Strategies, Artificial Intelligence, C#, Alteryx, Business Acumen, NLP (Natural Language Processing), R, LLM-driven Products, Relationship building, Data Modeling, Product Development, PostgreSQL, Mistral, Excel proficiency, LangChain, Prompt Design, Python, SQL Server, MS Sales, Legal Tech, Deadline adherence, Collaboration Skills, Requirements gathering, Testing, Functional requirements translation, Anthropic, Data Profiling, Tableau, Spotfire, Curiosity for learning, Relationship management, Testing criteria development, Information security principles, Student information system processes, Pinecone, System emergency response, Documentation

Contact this candidate