David Lehman, MPA
Program Manager at ConnectLA- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Portuguese Limited working proficiency
-
Spanish Limited working proficiency
Topline Score
Bio
Credentials
-
Data Visualization with Tableau
Coursera -
Finance & Quantitative Modeling for Analysts
Coursera -
U.S. Public Policy: Social, Economic, and Foreign Policies
Harvard University
Experience
-
ConnectLA
-
United States
-
Government Administration
-
1 - 100 Employee
-
Program Manager
-
Aug 2022 - Present
• Lead strategy and writing of comprehensive broadband policies, action plan, and administrative grant regulations that carry legal weight, while collaborating with federal government and key stakeholders. • Spearhead research on infrastructure trends, forecast issues, and recommend solutions to advance project milestones, such as technology improvement and labor force development. • Oversee federal grant compliance, budgeting, spending, and reporting of $200 million annual state… Show more • Lead strategy and writing of comprehensive broadband policies, action plan, and administrative grant regulations that carry legal weight, while collaborating with federal government and key stakeholders. • Spearhead research on infrastructure trends, forecast issues, and recommend solutions to advance project milestones, such as technology improvement and labor force development. • Oversee federal grant compliance, budgeting, spending, and reporting of $200 million annual state broadband infrastructure budget. • Synthesize and deliver concise reports to key legislators on policy outcomes, based on construction progress and grant administration. • Conduct robust coordination with local governments, nonprofits, industry, and citizens to educate on grant applications, mapping challenges, workforce development, and permitting. • Identify and strategize solutions to digital inclusion and equity challenges with an emphasis on affordability, digital skills training, technology adoption, and cybersecurity. • Build and maintain Excel database to track project execution and identify problem areas for resolution, while enhancing Tableau maps and dashboards. • Coach consultants on project and federal reporting requirements, while leading interns on drafting weekly communications releases. Show less • Lead strategy and writing of comprehensive broadband policies, action plan, and administrative grant regulations that carry legal weight, while collaborating with federal government and key stakeholders. • Spearhead research on infrastructure trends, forecast issues, and recommend solutions to advance project milestones, such as technology improvement and labor force development. • Oversee federal grant compliance, budgeting, spending, and reporting of $200 million annual state… Show more • Lead strategy and writing of comprehensive broadband policies, action plan, and administrative grant regulations that carry legal weight, while collaborating with federal government and key stakeholders. • Spearhead research on infrastructure trends, forecast issues, and recommend solutions to advance project milestones, such as technology improvement and labor force development. • Oversee federal grant compliance, budgeting, spending, and reporting of $200 million annual state broadband infrastructure budget. • Synthesize and deliver concise reports to key legislators on policy outcomes, based on construction progress and grant administration. • Conduct robust coordination with local governments, nonprofits, industry, and citizens to educate on grant applications, mapping challenges, workforce development, and permitting. • Identify and strategize solutions to digital inclusion and equity challenges with an emphasis on affordability, digital skills training, technology adoption, and cybersecurity. • Build and maintain Excel database to track project execution and identify problem areas for resolution, while enhancing Tableau maps and dashboards. • Coach consultants on project and federal reporting requirements, while leading interns on drafting weekly communications releases. Show less
-
-
-
Louisiana House of Representatives
-
United States
-
Government Administration
-
100 - 200 Employee
-
Statewide Budget Analyst
-
Mar 2020 - Aug 2022
• Oversaw and analyzed over $500 million in operating revenue and expenses with SAP BusinessObjects and SAP ECC for six statewide departments including Workforce Commission and Economic Development. • Modeled, forecasted, and reported on ongoing issues including the $1 billion depletion and $800 million replenishing of the unemployment insurance fund, pandemic revenue loss, and wildlife conservation fund. • Created data visualizations such as spending maps, Sankey, and treemaps in Excel… Show more • Oversaw and analyzed over $500 million in operating revenue and expenses with SAP BusinessObjects and SAP ECC for six statewide departments including Workforce Commission and Economic Development. • Modeled, forecasted, and reported on ongoing issues including the $1 billion depletion and $800 million replenishing of the unemployment insurance fund, pandemic revenue loss, and wildlife conservation fund. • Created data visualizations such as spending maps, Sankey, and treemaps in Excel and Tableau to concisely inform legislators on spending patterns and trends, assisting in fast-paced decision making. • Performed variance analysis in SAP BusinessObjects and Excel to discover budget solutions and efficiently utilize existing funding on new expenditure priorities. • Ensured legal compliance by studying statutory dedications, federal legislation, and guidance, then writing briefs on eligible uses and restrictions, such as the $3 billion in American Rescue Plan Act funds. • Testifed at appropriations committee meetings, presenting timely, accurate, and detailed financial information to the Legislature, then drafted budget amendments that became law. Show less • Oversaw and analyzed over $500 million in operating revenue and expenses with SAP BusinessObjects and SAP ECC for six statewide departments including Workforce Commission and Economic Development. • Modeled, forecasted, and reported on ongoing issues including the $1 billion depletion and $800 million replenishing of the unemployment insurance fund, pandemic revenue loss, and wildlife conservation fund. • Created data visualizations such as spending maps, Sankey, and treemaps in Excel… Show more • Oversaw and analyzed over $500 million in operating revenue and expenses with SAP BusinessObjects and SAP ECC for six statewide departments including Workforce Commission and Economic Development. • Modeled, forecasted, and reported on ongoing issues including the $1 billion depletion and $800 million replenishing of the unemployment insurance fund, pandemic revenue loss, and wildlife conservation fund. • Created data visualizations such as spending maps, Sankey, and treemaps in Excel and Tableau to concisely inform legislators on spending patterns and trends, assisting in fast-paced decision making. • Performed variance analysis in SAP BusinessObjects and Excel to discover budget solutions and efficiently utilize existing funding on new expenditure priorities. • Ensured legal compliance by studying statutory dedications, federal legislation, and guidance, then writing briefs on eligible uses and restrictions, such as the $3 billion in American Rescue Plan Act funds. • Testifed at appropriations committee meetings, presenting timely, accurate, and detailed financial information to the Legislature, then drafted budget amendments that became law. Show less
-
-
-
Louisiana State University
-
United States
-
Higher Education
-
700 & Above Employee
-
Research Assistant
-
Aug 2018 - May 2020
• Created a detailed outline of the 2018 federal infrastructure tax plan and discussed its ineffectiveness in creating the necessary incentives to promote infrastructure investment. • Conducted literature reviews on the economic impact of public school systems and the result of third-grade literacy in predicting future student success for the Livingston Parish Public School System. • Aggregated state parish data in Excel then reviewed code in R and Stata to ensure proper statistical… Show more • Created a detailed outline of the 2018 federal infrastructure tax plan and discussed its ineffectiveness in creating the necessary incentives to promote infrastructure investment. • Conducted literature reviews on the economic impact of public school systems and the result of third-grade literacy in predicting future student success for the Livingston Parish Public School System. • Aggregated state parish data in Excel then reviewed code in R and Stata to ensure proper statistical analysis. Show less • Created a detailed outline of the 2018 federal infrastructure tax plan and discussed its ineffectiveness in creating the necessary incentives to promote infrastructure investment. • Conducted literature reviews on the economic impact of public school systems and the result of third-grade literacy in predicting future student success for the Livingston Parish Public School System. • Aggregated state parish data in Excel then reviewed code in R and Stata to ensure proper statistical… Show more • Created a detailed outline of the 2018 federal infrastructure tax plan and discussed its ineffectiveness in creating the necessary incentives to promote infrastructure investment. • Conducted literature reviews on the economic impact of public school systems and the result of third-grade literacy in predicting future student success for the Livingston Parish Public School System. • Aggregated state parish data in Excel then reviewed code in R and Stata to ensure proper statistical analysis. Show less
-
-
-
Louisiana Economic Development
-
United States
-
Government Administration
-
1 - 100 Employee
-
Governor's Fellow
-
May 2019 - Aug 2019
• Appointed by Governor and his staff to work directly with Secretary of Economic Development on statewide policy initiatives. • Produced strategic plan and effectively utilized the federal Opportunity Zone program at the state level by creating an online exchange portal and coordinating with local economic development organizations and community stakeholders across Louisiana to populate the site with high quality projects available to investors, producing long-term investments in… Show more • Appointed by Governor and his staff to work directly with Secretary of Economic Development on statewide policy initiatives. • Produced strategic plan and effectively utilized the federal Opportunity Zone program at the state level by creating an online exchange portal and coordinating with local economic development organizations and community stakeholders across Louisiana to populate the site with high quality projects available to investors, producing long-term investments in low-income communities. • Wrote brief on butadiene production and the challenges and opportunities therein, to educate developers while negotiating deals to retain and expand a competitive petrochemical industry in Louisiana. • Strategized and outlined the challenges, practicality, and implementation of Veterans First initiative and network for Louisiana veteran-owned businesses. • Attended and took notes at top-level executive meetings, maintaining the highest degree of confidentiality on project proposals and initiatives before public announcement. Show less • Appointed by Governor and his staff to work directly with Secretary of Economic Development on statewide policy initiatives. • Produced strategic plan and effectively utilized the federal Opportunity Zone program at the state level by creating an online exchange portal and coordinating with local economic development organizations and community stakeholders across Louisiana to populate the site with high quality projects available to investors, producing long-term investments in… Show more • Appointed by Governor and his staff to work directly with Secretary of Economic Development on statewide policy initiatives. • Produced strategic plan and effectively utilized the federal Opportunity Zone program at the state level by creating an online exchange portal and coordinating with local economic development organizations and community stakeholders across Louisiana to populate the site with high quality projects available to investors, producing long-term investments in low-income communities. • Wrote brief on butadiene production and the challenges and opportunities therein, to educate developers while negotiating deals to retain and expand a competitive petrochemical industry in Louisiana. • Strategized and outlined the challenges, practicality, and implementation of Veterans First initiative and network for Louisiana veteran-owned businesses. • Attended and took notes at top-level executive meetings, maintaining the highest degree of confidentiality on project proposals and initiatives before public announcement. Show less
-
-
-
The Adecco Group
-
Switzerland
-
Human Resources Services
-
700 & Above Employee
-
Analyst
-
Feb 2018 - Aug 2018
• Aggregated revenue data in Excel and created an easy-to-read presentation which secured a multimillion dollar bank loan for an ecommerce startup. • Updated and merged two datasets to streamline the payroll process for a national production company. • Tracked and updated online orders for an international legal translation services company. • Utilized an online database to simplify job applicant screenings and maintain an active talent pool. • Aggregated revenue data in Excel and created an easy-to-read presentation which secured a multimillion dollar bank loan for an ecommerce startup. • Updated and merged two datasets to streamline the payroll process for a national production company. • Tracked and updated online orders for an international legal translation services company. • Utilized an online database to simplify job applicant screenings and maintain an active talent pool.
-
-
-
North American Mission Board
-
United States
-
Religious Institutions
-
300 - 400 Employee
-
Research Intern
-
Jun 2016 - Jul 2016
• Utilized surveys and census data to analyze income and demographics of a local neighborhood. • Conversed daily with Canadians to gain insight on their neighborhood and community needs. • Wrote, developed, and presented a team prospectus on the community needs, including how the North American Mission Board can build a local nonprofit that meets said needs. • Utilized surveys and census data to analyze income and demographics of a local neighborhood. • Conversed daily with Canadians to gain insight on their neighborhood and community needs. • Wrote, developed, and presented a team prospectus on the community needs, including how the North American Mission Board can build a local nonprofit that meets said needs.
-
-
-
Happy Hour Language School
-
Fortaleza Area, Brazil
-
Guest Speaker
-
Jun 2015 - Jul 2015
• Educated English students on Louisianian culture by interacting in a conversational Q&A setting. • Served as American representative during the school Fourth of July cultural exchange. • Educated English students on Louisianian culture by interacting in a conversational Q&A setting. • Served as American representative during the school Fourth of July cultural exchange.
-
-
Education
-
Louisiana State University
Master of Public Administration - MPA, Public Finance and Budgeting -
Louisiana State University
Bachelor of Science - BS, Economics, Honors College, Upper Division Honors
Community
