Role listed
Ppl Corporation (Contractor)
AeroLeads people directory · profile
Shawn Mcelwain Email & Phone Number
Data Analyst @PPL Corporation | Data Analysis, Statistical Analysis, Supply-Chain Analyst, Dashboard Developer
at
PPL Corporation (Contractor)
1 work email found
@ferc.gov
1 phone found area 703
LinkedIn matched
✓ Verified May 2026
4 data sources
Profile completeness 100%
Current company
PPL Corporation (Contractor)
Role
Data Analyst @PPL Corporation | Data Analysis, Statistical Analysis, Supply-Chain Analyst, Dashboard Developer
Location
Springfield, Virginia, United States
Who is Shawn Mcelwain? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Shawn Mcelwain is listed as Data Analyst @PPL Corporation | Data Analysis, Statistical Analysis, Supply-Chain Analyst, Dashboard Developer at PPL Corporation (Contractor), based in Springfield, Virginia, United States. AeroLeads shows a work email signal at ferc.gov, phone signal with area code 703, and a matched LinkedIn profile for Shawn Mcelwain.
Shawn Mcelwain previously worked as Data Engineer for Distributed Energy Resource Management Pilot at Ppl Corporation (Contractor) and Senior Energy Industry Analyst -Database Designer/Data Engineer at Federal Energy Regulatory Commission. Shawn Mcelwain holds Bachelor Of Science (Bs), Mechanical Engineering from George Mason University.
Company email context
Email format at PPL Corporation (Contractor)
This section adds company-level context without repeating Shawn Mcelwain's masked contact details.
{first}.{last}@ferc.gov
86% confidence
AeroLeads found 1 current-domain work email signal for Shawn Mcelwain. Compare company email patterns before reaching out.
Profile bio
About Shawn Mcelwain
With over 10 years of experience in the energy industry, I am a data engineer who combines engineering problem solving, data analysis, data visualization, reporting, database design, development, and maintenance skills to support business decisions, industry innovation, and regulatory agencies. I am passionate about creating data-driven solutions to technical challenges within the engineering and technical space, and exploring the application of machine learning and artificial intelligence to optimize performance and identify opportunities.Currently, I work at PPL Corporation as a data engineer for a distributed energy resource management pilot, where I deliver high-quality dashboards, KPIs, and regulatory reports using SQL, Power BI, and ETL tools. I am responsible for tracking pilot finances and assets throughout the supply chain and work order management cycles, and integrating the pilot program's technical and business requirements into robust processes and procedures compatible with the utility's enterprise systems. I also collaborate with multiple departments and stakeholders, and coordinate the pilot program's annual regulatory reporting to the Public Utility Commission, where I leverage my technical writing, interpersonal communication, and project management skills.
Listed skills include Matlab, Microsoft Excel, Microsoft Word, Python, and 13 others.
Current workplace
Shawn Mcelwain's current company
Company context helps verify the profile and gives searchers a useful next step.
Ppl Corporation (Contractor)
10 roles · 15 years
Shawn Mcelwain work experience
A career timeline built from the work history available for this profile.
Data Engineer For Distributed Energy Resource Management Pilot
Current
Ppl Corporation (Contractor)
Created high quality dashboards and KPI reporting for critical pilot metrics and regulatory reportingSuccessfully developed back-end data models for reporting and analytics through reverse engineering PPL's most recently deployed enterprise work management and financial supply chain management database without access to documentation.Responsible for.
Feb 2023 - Present
Senior Energy Industry Analyst -Database Designer/Data Engineer
Perform quantitative and qualitative data analysis, to support development of standards, and to assess current standards effectiveness at preventing reliability eventsLead data projects spanning multiple divisionsRegularly create and present written, visual, and oral reports and executive level briefings to senior leadersDesign, develop, update, maintain.
Jul 2022 - Jan 2023
Energy Industry Analyst- Database Developer/Data Engineer
Led a multi-divisional database redesign and migration to SQL Server that automated 98% of manual manipulation with ETL processes and increased user interface speed by 94%, reducing maintenance time from 3 days to 1 hour.Developed a SQL Server Data Warehouse for GADS-Wind with fully automated custom change tracking and maintenance routinesDeveloped Power.
Sep 2019 - Jul 2022
Quality Control Specialist
- Coordinated team leads to investigate cross-survey discrepancies and complex aggregate level anomalies at the request of the federal client.
- Create Access Applications and SAS programs for report automation and optimized visualization of complex data
- Assist in creation of interactive dashboards for simplifying data analysis of weekly and monthly survey data
- Optimize business processes and procedures for time and client satisfaction
- Prepare technical documentation for developed applications, programs, and business processes
- Document, track, present, and compose written reports on, the status of projects and initiatives for senior management and federal clientele.
Sep 2015 - Sep 2019
Survey Analyst
- Designed a front-end database report application that improved efficiency by 300 % consolidating the capabilities of 3 different Excel validation tools into one automatically updating Access application.
- Designed a SAS application that produces a monthly report of my team’s total work product, proving that my team is exceeding client expectations
- Provided monthly executive briefings summarizing potential issues that affected industry operations across the country.
- Identified, validated, and resolved, all data issues for a group of 200 respondents on a weekly and monthly survey.
- Researched the root causes of statistical anomalies and contacted the survey respondents to validate their data.
Oct 2014 - Sep 2015
Petroleum Supply Data Analyst
Responsible for collection, validation, and analysis of multiple large scale, Petroleum Supply Surveys, on behalf of the Energy Information Administration. These surveys are collected on a weekly, monthly, and annual basis.
Feb 2014 - Oct 2014
Dining Services Associate
Jun 2011 - Oct 2013
Engineering Technician
- Student Internship-Engineering Technician, Under Chief of Energy Resource Management September 2011-March 2012
- Redesigned and implemented an agency wide Excel database for tracking all energy conservation projects to include automatic report generation.
- Transitioned agency to new automated evaluation system which decreased time required to compile monthly reviews from 5 days to 1 hour.
- Served as agency liaison to task force responsible for testing, data entry, and implementation of a compliance tracking database.
- Assessed all inter-agency energy project status reports from field locations and provided feedback to Chief of Energy Resource Management.Student Internship-Engineering Technician, Under Chief of Safety and Health.
- Co-authored safety and health reference manual distributed across entire complex.
2011 - 2012
~1 yr
Engineering Technician-Student Intern
- Studied the effects of a recently developed fuel additive on the lifespan of the fleet’s fuel injectors.
- Performed a validation of the fleet fuel consumption using MS Access queries of a database containing two years of each ship’s monthly fuel purchases. Excel was then used to calculate a baseline of fuel consumption for.
- Performed a cost-analysis simulation analyzing the impact of the fleet operating on ships power rather than electric power while in each of the world-wide ports.
Jun 2009 - Aug 2009
2 education records
Shawn Mcelwain education
Bachelor Of Science (Bs), Mechanical Engineering
George Mason University
Mechanical Engineering
Clemson University
FAQ
Frequently asked questions about Shawn Mcelwain
Quick answers generated from the profile data available on this page.
What company does Shawn Mcelwain work for?
Shawn Mcelwain works for PPL Corporation (Contractor).
What is Shawn Mcelwain's role at PPL Corporation (Contractor)?
Shawn Mcelwain is listed as Data Analyst @PPL Corporation | Data Analysis, Statistical Analysis, Supply-Chain Analyst, Dashboard Developer at PPL Corporation (Contractor).
What is Shawn Mcelwain's email address?
AeroLeads has found 1 work email signal at @ferc.gov for Shawn Mcelwain at PPL Corporation (Contractor).
What is Shawn Mcelwain's phone number?
AeroLeads has found 1 phone signal(s) with area code 703 for Shawn Mcelwain at PPL Corporation (Contractor).
Where is Shawn Mcelwain based?
Shawn Mcelwain is based in Springfield, Virginia, United States while working with PPL Corporation (Contractor).
What companies has Shawn Mcelwain worked for?
Shawn Mcelwain has worked for Ppl Corporation (Contractor), Federal Energy Regulatory Commission, Img-Crown Energy Services, Erickson Living, and Defense Logistics Agency.
How can I contact Shawn Mcelwain?
You can use AeroLeads to view verified contact signals for Shawn Mcelwain at PPL Corporation (Contractor), including work email, phone, and LinkedIn data when available.
What schools did Shawn Mcelwain attend?
Shawn Mcelwain holds Bachelor Of Science (Bs), Mechanical Engineering from George Mason University.
What skills is Shawn Mcelwain known for?
Shawn Mcelwain is listed with skills including Matlab, Microsoft Excel, Microsoft Word, Python, Academic Background, Java, Ms Access, and Sql.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial