Expert Details
Financial Modeling For Infrastructure Projects (Transportations, Power, Facilities)
ID: 733929
Maryland, USA
He has directed financial, risk and demand modeling to determine feasibility (using metrics and tools such as discounted cash flow modeling, IRR, coverage ratios, scenario analysis, Monte Carlo simulations, etc.)
Representative projects include:
-Due diligence of an engineering firm in South America (transaction value: $100M+)
-Due diligence of a logistics firm in the Middle East for a private equity firm
-Due diligence of Northwest Parkway in Denver metro area (transaction value: $543M)
-Due diligence for lenders for two toll highways in Dominican Republic (transaction value: over $300M)
-Financial analysis and cost modeling of the Justice Prisoner and Alien Transportation System, USA
-Project finance and project delivery options for multiple community corrections centers in Hawaii, USA
-Lead author of “Financing Detention Facilities” handbook for Department of Justice, USA.
-Financial models for several service processing centers of Department of Homeland Security, USA
-Financial models for 160 port terminals, Brazil (investment value: $5+ billion)
-Financial model and debt placement for a power facility in Cayman Islands (investment value: $150 million)
-Financial model and debt placement for a solar power facility in Western Samoa (investment value: $5+ million)
-Financial model for a solar power facility in Kuwait (investment value: $5+ million)
-Financial model for a Commuter Rail Line in Mexico (investment value: $1+ billion)
-Financial modeling and privatization plan for Cairo and 18 other airports, Egypt (investment value: $1.6+ billion)
-Financial and economic analysis of wind power projects, Port of Paulsboro, NJ
-Economic cost benefit analysis for Highway System 5 (Red Vial 5), Peru
-Financial model for Enfidha Industrial and Logistics Zone, Tunisia (investment value: $1+ billion)
-Pricing models for utility services for Port Lekki, Nigeria (investment value: $1+ billion)
-Pricing models for several passenger rail services for Amtrak, USA
Develop financial models for a variety of industries.
Provide data analytics / statistical analyses and modeling services.
Education
Year | Degree | Subject | Institution |
---|---|---|---|
Year: 2002 | Degree: MBA | Subject: Finance, Economics and International Business | Institution: University of Chicago |
Year: 1994 | Degree: MS | Subject: Transport Systems Analyses and Planning | Institution: Northwestern University |
Year: 1992 | Degree: B Tech | Subject: Civil Engineering | Institution: Indian Institute of Technology, Varanasi |
Work History
Years | Employer | Title | Department |
---|---|---|---|
Years: 2017 to Present | Employer: Undisclosed | Title: Principal | Department: |
Responsibilities:Independent consultant focusing on data analytics, financing modeling, demand modeling, statistical analysis and web-based tools.Representative Projects: Private client: Financial modeling for real estate investment funds IBM: Data analytics for a federal government agency (toolset: Python, R, ArcGIS, Netezza, Tableau). Private client: Financial analysis for debt financing of a solar power plant. Private client: Financial model for a new port in the Caribbean. Private client: Technical due diligence of an M&A transaction of a regional construction company. Private client: Assistance to the Lender's Independent Engineer for two toll roads in Dominican Republic. |
|||
Years | Employer | Title | Department |
Years: 2005 to 2017 | Employer: Louis Berger | Title: Vice President | Department: |
Responsibilities:Responsible for managing Louis Berger’s practice in supporting infrastructure finance and planning efforts. Lead a team of PhD analysts, economists, engineers and MBAsKey Professional Skills - Financial and economic analysis (discounted cash flow modeling, NPV and IRR calculations, coverage ratios) - Risk analysis (risk matrix, uncertainty analysis, scenario analysis, Monte Carlo simulations). See presentation: http://tinyurl.com/ondebjz - Business intelligence tools: Qlik, Power BI, Watson Analytics, Cognos TM1, Deltek CPx - Econometric software: SPSS, Limdep, GRETL, R - Programming: Python, Visual Basic. See site: www.MyFinModel.com Representative Projects: • Transaction Advisory Services for the Ports Investment Program, Brazil • Financial Modeling for Commercial Power Projects, Worldwide • Project Management Consultant for Port Lekki, Nigeria • Analytical Cost Modeling and Financial Analysis of Justice Prisoner and Alien Transportation System (JPATS), USA • Traffic Due-Diligence Analysis for the Rt. 460 Highway, Virginia, USA • Independent Engineering Services for Autopista del Nordeste, Dominican Republic • Traffic and Technical Advisory Services for the Indiana Toll Road, US • Project Finance/Project Delivery Options and EA Support for Maui Community Corrections Center (Hawaii), USA • Financial and Technical Review of a Commuter Rail Line in Mexico - Financial models for 160 port terminals, Brazil (investment value: $5+ billion) - Financial model and debt placement discussions for power facility in Cayman Islands (investment value: $150 million) - Financial and economic analysis of wind power projects, Port of Paulsboro, NJ - Financial model for Enfidha Industrial and Logistics Zone, Tunisia (Investment value: $1+ billion) - Financial modeling and privatization plan for Cairo and 18 additional airports, Egypt (investment value: $1.6+ billion) - Lead author of “Financing Detention Facilities” handbook for Department of Justice, USA. |
|||
Years | Employer | Title | Department |
Years: 2003 to 2005 | Employer: Monitor Deloitte | Title: Consultant | Department: |
Responsibilities:Consultant to senior executives at Fortune 500 companies on issues relating to growth strategy, business strategy and corporate re-structuringClients include leaders in financial services, beverage, chemicals, pharmaceuticals and retail industry: - Led a multinational team to develop business turnaround strategy for one of world’s largest insurance companies - Led development of mid-long term growth strategy for a beverage major in a major African country - Planned and executed market trials, conducted channel analyses, developed market segmentation and Customer Portraits®, forecasted future demand, designed and implemented surveys for various clients |
|||
Years | Employer | Title | Department |
Years: 1996 to 2003 | Employer: Louis Berger | Title: Director | Department: |
Responsibilities:- Advised national / local governments and private clients in several countries (North and South America, Eastern Europe, Asia) on issues related to demand/revenue forecasting, financial and economic analysis, infrastructure privatization and institutional restructuring- Developed programs (user surveys and statistical analyses) to measure consumer behavior and reaction to pricing of transport facilities in a number of developed and developing countries |
|||
Years | Employer | Title | Department |
Years: 1995 to 1996 | Employer: KPMG Peat Marwick | Title: Program Analyst | Department: |
Responsibilities:Designed surveys, developed advanced pricing models, and forecasted traffic/revenue for various US rail corridors |
Government Experience
Years | Agency | Role | Description |
---|---|---|---|
Years: 2005 to 2017 | Agency: US/ Department of Justice | Role: Technical Consultant | Description: Several assignments with the Office of Federal Detention Trustee |
Years: 2005 to 2010 | Agency: US/ Department of Homeland Security | Role: Technical Consultant | Description: Several assignments with the Immigration and Customs Enforcement |
Years: 2017 to 2017 | Agency: US/ Department of Homeland Security | Role: Lead Data Analyst | Description: Analysis of insurance claims and policy data for FEMA |
International Experience
Years | Country / Region | Summary |
---|---|---|
Years: 2012 to 2016 | Country / Region: France | Summary: Resident in France overseeing consulting assignments in Africa, Middle East and Latin America |
Years: 2012 to 2016 | Country / Region: UK | Summary: Resident in UK overseeing assignments in Croatia and Turkey |
Years: 2012 to 2016 | Country / Region: Ecuador, Argentina | Summary: Resident in Ecuador and Argentina focusing on projects in Latin America |
Career Accomplishments
Awards / Recognition |
---|
Awarded the Berger Group Excellence Award for “anchoring LBG’s international traffic and revenue forecasting practice” |
Language Skills
Language | Proficiency |
---|---|
Spanish | Fluent |
Hindi | Fluent |
French | Basic |