Data Scientist, Power Bi Developer
Resume:
Brian Magley, PMP
*****.*.******@*****.***
Engineer with ACTIVE SECRET CLEARANCE with 10 years’ experience seeking a challenging Business Intelligence position that leverages my analytical skills, experience in data modelling and data visualization, and ability to communicate insights to drive business decisions.
EDUCATION
VIRGINIA TECH
Bachelor of Science in Engineering
Blacksburg, VA
May 2015
PROJECT MANAGEMENT INSTITUTE
Project Management Professional (PMP)
Virginia Beach, VA
Nov 2021
PROFESSIONAL EXPERIENCE
ADVANCED MANAGEMENT STRATEGIES GROUP (AMSG)
Data Engineer
Sep 2024 - Present
• Served as the subject matter expert in data engineering, supporting analytics and reporting initiatives for U.S. Army TRADOC.
• Developed Predictive Models: Build machine learning models using python to analyse historical data and predict future trends, leveraging regression techniques for accurate forecasting.
• Applied Quadradic Regression: Extended predictive capabilities by implementing polynomial regression (quadratic models) to capture non-linear relationships in complex datasets
• Data Processing & Feature Engineering: Cleaned, transformed, and engineered features using pandas and NumPy to enhance model accuracy and reliability.
• Visualization of Insights: Used Matplotlib to create data visualizations, showcasing regression trends, residual plots, and predictive insights for stakeholders.
• Designed and implemented performance management systems using Power BI and SharePoint Online.
• Created Data models and pipelines to integrate, transform, and store structured and unstructured data for discission-making platforms (Vantage, Advana)
• Collaborated within an Agile Scrum development team to deliver iterative, high-impact data solutions and performance metrics dashboards.
• Applied low-code/no-code tools (Power Apps, Power Automate) to streamline business processes and enhance operational efficiency.
• Collaborated with cross-functional teams to define KPIs, performance metrics, and dashboard solutions for strategic insights.
• Developed a workload capacity dashboard and an automated reporting dashboard that drove efficiency by eliminating the need for PowerPoint slides.
GENERAL DYNAMICS INFORMATION TECHNOLOGY (GDIT)
Senior Engineer
Mar 2020 – Sep 2024
• Employed Power BI, to develop a KPI dashboard, using Data Analysis Expressions (DAX) to assess both on- time delivery and quality performance.
• Developed a Power BI dashboard with visualizations monitoring our quotation performance. Measures included win rate %, # quotes per month, lost opportunity reason codes.
• Efficient in Extract Transfer Load (ETL) and Data Modelling in Power BI and Microsoft power query. Proficient in connecting and shaping data, creating relational data models, adding calculated fields using DAX, row level security, star schema Kimball method, and dashboarding and visualizations.
• Implemented ETL processes and utilized Microsoft Power Queries to develop automated reports for program management to evaluate job progress in terms of percentage completion.
• Automated reporting processes using Power Bi and power query, reducing manual effort and increasing the timeliness and accuracy of data insights.
• Developed automated reporting using Microsoft SQL Query for program management to evaluate job progress and KPIs.
• Extracted financial data using pivot tables to generate status reports tracking project progress against budget for all shop orders. Provided daily communication of progress and results to customers.
• Developed and executed SQL queries to extract, manipulate, and analyse data, supporting ad-hoc reporting and data exploration.
• Created comprehensive scheduling Plans of Action and Milestones (POAMs) using MS project for large scale projects within the fabrication shop.
• Developed a SharePoint site for resource management that tracks resource requests.
• Developed PDF fillable forms for Operations to standardize processes.
• Directly communicated with customers regarding scheduling or engineering change orders, maintaining clear and proactive dialog to address their needs effectively.
• Offered technical support to the SSTD group participating in weekly status meetings and quarterly review meetings.
BUSCH VACUUM SOLUTIONS
Engineer/Scrum Master
Mar 2018 – Mar 2020
• Designed and developed interactive Power Bi dashboards, reports, and visualizations to provide actionable insights and drive data-driven decision-making across the organization.
• Created and maintained data models in Power BI, ensuring data accuracy, consistency, and scalability for future reporting needs.
• Led end-to-end Power Bi projects, from requirements gathering and data sourcing to dashboard development and deployment.
• Worked closely with executive leadership to develop and present visual data narratives that influenced strategic decision making.
• Performed as Project Manager to the PMO, Engineering, Quoting, and Purchasing teams supporting their daily tasks. Led daily scrum meetings, managed risk registers and led retrospectives.
• Agile Scrum Master and Internal consultant for change leadership initiatives throughout the organization.
• Implementation of systems production departmental KPIs.
• Assisted engineering and production to resolve issues during system and pump assembly and made recommendations for process improvements.
MASSIMO ZANETTI BEVERAGE USA
Supply Chain Engineer
Sep 2015 – Mar 2018
• Analysed large datasets to identify key metrics and deliver insights that informed business strategy and optimized performance
• Conducted data analysis and created visual reports to identify trends, patterns and anomalies, supporting strategic planning and operational improvements.
• Collaborated with stakeholders to gather requirements and translate business needs into effective BI solutions, ensuring alignment with organizational goals.
• Developed a KPI dashboard that tracked and monitored operational performance and was used as the basis for employee quarterly bonuses.
• Used excel to create a warehouse capacity dashboard used to monitor storage utilization in various warehouses.
• Led project management for the accounts receivable, billing, logistics and marketing teams, driving improvements in the quote-to-cash workflow.
• Responsible for analysis of internal and external business and operational processes.
• Utilization of Six Sigma, Lean, DMAIC, and value stream mapping to improve order-to-cash, new product development (NPD), and quote-to-order processes.
ADDITIONAL SKILLS/AWARDS
• Proficient in MS Office (Word, Excel, PowerPoint, Outlook, MS Project, MS Visio, SharePoint).
• Growing knowledge and experience using Python for data analysis, predictive analytics, and machine learning techniques such as linear and quadratic regression.
• Experience using Jupyter Notebooks for data analysis, visualization, and machine learning, leveraging python libraries like pandas, scikit-learn, and Matplotlib.
• Proficient in business intelligence software such as MS Power BI (DAX) and MS Power Query.
• Completion of Microsoft Power Bi Desktop for Business Intelligence and Power BI DAX Masterclass training courses.
• Knowledgeable in a variety of ERP systems such as JD Edwards E1, Infor LN, JobBoss, Unipoint QMS.
• Familiar with Agile Project Management tools such as Jira, Confluence and Slack, MS Project.
• Eagle Scout Award (2010).
Contact this candidate