Data Analyst Power Bi
Resume:
Ingmar Lopez
Phone: 240-***-**** Email: ***********@*****.*** Location: Maryland, USA
OBJECTIVE/PORTFOLIO
Results-driven Data Analyst with a proven track record of designing and deploying end-to-end Business Intelligence (BI) solutions using Power BI, SQL, and the Microsoft BI stack. Skilled at transforming raw data into actionable dashboards, optimizing workflows, and collaborating with cross-functional teams to drive innovation and strategic decision-making. Experience includes data warehousing, Azure services, DevOps best practices, and machine learning principles. Adept at creating scalable data pipelines, automating manual processes, and delivering insights that boost efficiency and reduce costs. CORE SKILLS & TECHNOLOGIES
● Business Intelligence & Analytics:
Power BI (Desktop & Service), Tableau, IBM
Cognos, Snowflake
● Data Warehousing & ETL:
SQL, Data Modeling, Data Cleansing, Toad,
Manhattan WMS
● Microsoft Power Platform:
Power Apps, Power Automate, SharePoint
● Programming & Scripting:
Python, R, Java, C++, HTML, CSS, JavaScript
● Cloud & Big Data:
Azure Open AI, Azure Data Gateway,
Self-Service Data Preparation
● Methodologies & Collaboration:
Agile/Scrum, Jira, Confluence, Git, CI/CD,
DevOps Concepts
EXPERIENCE
Acquisitions Manager April 2025 – Present
Offer Prop Rockville, MD
● Sales Team Leadership: Led acquisitions sales team, significantly improving lead-to-contract conversion rates through strategic pipeline management.
● CRM Automation & Integration: Developed automated CRM processes within Monday.com, streamlining lead outreach, follow-up workflows, and enhancing team efficiency.
● Sales Performance Analytics: Analyzed sales performance data to identify bottlenecks and implemented targeted solutions, increasing overall sales productivity.
● Investor Relations: Managed direct collaboration with investors, maintaining relationships and ensuring successful contract completions.
● Lead Generation Optimization: Provided all vetted leads through a targeted cold-calling system focusing on distressed properties within investor-concentrated areas of the DMV, optimizing hot leads to ensure successful acquisition and sale.
Data Analyst & Power BI Development March 2023 – April 2025 LCG Bethesda, Maryland
● Multi-Source Power BI Development: Created and published Power BI reports combining data from Excel, SharePoint, and SQL, enabling leadership to make data-driven decisions.
● Microsoft Power Platform Integration: Developed multiple Power Apps (including a reservation tool and an NCI JPQ application), automating manual processes by 60% and increasing data accuracy.
● Workflow Automation: Deployed Power Automate workflows, reducing repetitive tasks for scheduling, approvals, and data entry by 45%.
● SQL & ETL Optimization: Built relational data models in SQL Server and refined ETL pipelines, achieving a 20% improvement in data refresh times.
● AI-Driven Enhancements: Collaborated on AI workflows for grant processing, decreasing approval cycles by 30% and boosting overall operational accuracy.
● Cross-Functional Collaboration: Provided on-demand analytics and strategic advice, ensuring consistent data practices across multiple departments.
● UAT: Led and coordinated UAT sessions with business units, developing test cases and validating Power BI reports, Power Apps, and Power Automates against stakeholder requirements.
● REST API Integration: Integrated REST APIs into Power Apps and automated flows, streamlining external data ingestion and improving system interoperability.
Senior Logistics Analyst (2nd Shift) February 2024 – January 2025 GXO Logistics Hagerstown, Maryland
● Power BI Reporting & Analytics: Developed dynamic dashboards to monitor key KPIs (inventory accuracy, throughput), reducing manual reporting by 35%.
● Data Modeling & Integration: Utilized SQL, Snowflake, and Excel to build robust data pipelines, boosting data reliability and availability for real-time decision-making.
● WMS Optimization: Managed Manhattan WMS for high-volume transfers, collaborating with cross-functional teams to maintain near real-time inventory updates.
● Process Efficiency: Identified and eliminated operational bottlenecks through IBM Cognos insights, cutting transfer timelines by 18%.
● Stakeholder Alignment: Supported executive leadership by standardizing dashboards and reports for Amazon, Costco, and other strategic partners.
● UAT Execution: Coordinated UAT efforts with business and warehouse teams to ensure new data solutions met operational requirements and client expectations.
● REST API: Worked with REST APIs to enhance data connectivity across systems and support integrated dashboard development.
Communications Analyst September 2022 – March 2023 DMI Bethesda, Maryland
● Workflow Optimization: Simplified referral and appointment processes for military personnel, reducing scheduling times by 25% and improving service accessibility.
● Data Tracking & Reporting: Monitored referral volumes, generating performance dashboards that informed leadership of bottlenecks and potential improvements.
● Stakeholder Management: Collaborated with medical teams to enhance clinic workflows, elevating overall patient satisfaction scores.
Data Consultant December 2022 – May 2023
UMD College Park, Maryland
● Data Warehouse & Visualization: Architected a traffic-data repository unifying federal, state, and local datasets; presented findings via Power BI and geo-based heatmaps.
● Security & Scalability: Enabled continuous updates and controlled access, allowing non-technical users to easily view real-time analytics.
● Stakeholder Engagement: Prepared clear documentation and trained city officials, fostering data-driven approaches to traffic management and safety.
Data Analyst June 2020 – September 2022
Adam Medical Frederick, Maryland
● Market & Trend Analysis: Investigated emerging healthcare patterns, supporting expansion into pediatric nebulizer markets and increasing product line revenue by 15%.
● Data-Driven Operations: Deployed analytics to streamline operations, reinforcing data security protocols and cutting operational costs by 10%.
● Digital Presence Enhancement: Improved website UX and social media engagement through targeted data insights, boosting online traffic by 25%.
EDUCATION
B.S. in Information Science
University of Maryland – College Park, Maryland August 2019 – May 2023 Concentration: Data Science
Relevant Coursework: Database Management, Data Visualization, Big Data Analytics, Machine Learning KEY ACHIEVEMENTS & HIGHLIGHTS
● Reduced manual reporting by 35% through integrated Power BI dashboards and data pipelines.
● Cut warehouse transfer timelines by 18%, leveraging real-time analytics and optimized workflows.
● Launched multiple Power Apps and Power Automate workflows, automating up to 60% of manual tasks.
● Improved data refresh times by 20% in SQL-based pipelines, enhancing reporting accuracy and speed.
● Boosted grants-processing efficiency by 30% with AI-driven solutions, significantly reducing approval wait times.
Contact this candidate