Relationship Manager Data Analytics

MASHREF UL HOQUE

**/* *********** ****, ***# * East, Shantinagar, Ramna, Dhaka-1217

Phone: +880********** • Email: ***********@*****.*** QUALIFICATION SUMMARY

Corporate Banking, Project Finance, Transaction Advisory and Data Analytics:

• Proficient in syndicate financing for large-scale projects, including Renewable Energy, Energy Efficiency, and Public Infrastructure.

• Skilled in originating, structuring, and closing financial deals, handling various financial products like senior and subordinated debt, bonds, and preference shares.

• Experienced in collaborating with diverse stakeholders in project finance, including legal counsels, environmental experts, and auditors.

• Extensive experience in Public-Private Partnership (PPP) project management across various sectors like Power, Health, and Telecom.

• Extensive experience in data analytics and machine learning using different business intelligence tools like SQL, Tableau, Tableau Prep Flow, Python etc.

KEY PROFESSIONAL ACHIEVEMENTS

• Relationship Manager for the term loan facility and preference share for Summit Communications Limited amounting BDT 1,200 million.

• Relationship Manager for the term loan facility for Sandor Dialysis Services Bangladesh Pvt Ltd amounting BDT 90 million, the first ever PPP project in health sector of Bangladesh.

• Relationship Manager for the syndicated term loan facility for Bangladesh Petrochemical Company Limited (BPCL), a PET bottle recycling plant, amounting BDT 800 million.

• Advisory services to the Power Cell of Bangladesh for establishing a solar hybrid renewable energy facility in Rangabali, Patuakhali, Bangladesh.

• Advisory services to the Bangladesh Power Development Board (BPDB) for OHSAS 18001:2007 Certification from Bureau Veritas.

• Relationship Manager for the syndicated term loan facility for Infinity Data and Power Limited, a power cable manufacturing company, amounting to BDT 435 million and Working Capital Facilities BDT 210 million.

WORK EXPERIENCE

Consultant, Finance and Investment

Bangladesh Petrochemical Company Limited (BPCL), Dhaka, Bangladesh 02/2024 –Present

Key Responsibilities and Accomplishments:

• Leading financial restructuring initiatives to optimize resources and streamline debt repayment for the PET Recycling project.

• Developing comprehensive information memorandums and pitch decks to attract potential investors and secure funding for the project.

• Developing and maintaining strong relationships with foreign investors, ensuring effective communication and alignment with project goals.

• Managing the project with a total cost of BDT 1,400 million+, implementing financial strategies to support project objectives and ensure successful outcomes. Business Analyst II

Systems Intelligence & Data Analytics Division, University of Nebraska at Omaha, Nebraska, USA

11/2022 –05/2023

Key Responsibilities and Accomplishments:

• Led the development and implementation of data governance policies at the university level, achieving a 50% improvement in data integrity, security, and access.

• Improved report efficiency by optimizing SQL queries and developing over 10 KPI Tableau dashboards, aiding in quicker decision-making for senior management.

• Contributed to a 25% increase in reporting and planning efficiency by supporting data warehouse maintenance and managing over 20 key internal and external surveys. Environment: Python, Excel, Tableau, Microsoft SQL Server Management Studio (SSMS), SQL Server Analysis Services (SSAS), IPEDS etc.

Business Intelligence and Reporting Analyst

Division of Student Affairs, Weber State University, Ogden, Utah, USA 06/2020 – 11/2022

Key Responsibilities and Accomplishments:

• Collected and gathered data from various data tracking tools used by Student Affairs (SA) departments and prepared them for data warehouse transfer.

• Worked closely with data warehouse developers, IT and other stakeholders for selecting, extracting, cleaning, transforming and validating data and permanently transferring to data warehouse.

• Provided expertise in creating and optimizing complex SQL necessary to facilitate the retrieval of data from banner, data warehouse and other sources (e.g., IPEDS, USHE etc.) to fulfill stakeholders’ requirements.

• Prepared reports and dashboards on key metrics (e.g., demographics, admission, retention, persistence, graduation, student engagement, and learning outcomes etc.) to help SA with strategic initiatives. Environment: Python, Excel, STATA, Oracle SQL, Tableau, Toad, Argos, Ellucian Banner, Starfish, Qualtrics, Qlik AutoML, IPEDS, USHE etc.

Graduate Research Assistant

Center for Regional Development, Bowling Green State University, Bowling Green, Ohio, USA

09/2018 - 05/2019

Key Responsibilities and Accomplishments:

• Collected and maintained database from various sources such as Bureau of Labor Statistics (BLS), Bloomberg, Capital IQ, United States Census Bureau, Federal Reserve etc. related to labor and economy in Northwest Ohio region.

• Performed economic, demographic and industry analysis on the collected data using data analysis and visualization tools Excel, STATA, SAS, Tableau, ArcGIS etc. for county level economic and workforce development.

• Successfully organized State of the Region conference for 300+ professionals focusing on global trade and investment and their impact on economic development in Northwest Ohio region. Manager, Investment and Advisory

Infrastructure Development Company Limited (IDCOL), Dhaka Bangladesh 08/2013 - 09/2018

Key Responsibilities and Accomplishments:

• Successfully executed major investments, including an BDT 1,200 million preferred stock investment in Summit Communications Ltd., a $ 10 million term loan for a utility scale solar power project, and a BDT 90 million investment in Sandor Ltd (a PPP project)., marking significant contributions in fiber optics, renewable energy, and healthcare sectors in Bangladesh.

• Provided expert advisory services for significant government projects, such as the electrification of a remote island with renewable energy and the OHSAS 18001:2007 Certification Project for the Bangladesh Power Development Board.

• Led the origination, structuring, and analysis of private sector infrastructure projects, focusing on PPPs, Renewable Energy, and Energy Efficient Projects, showcasing a strategic approach in identifying and evaluating investment opportunities.

• Conducted due diligence, financial modeling, and risk assessments, and played a key role in developing and negotiating financial deals and agreements, such as loans, equity investments, guarantees, and Power Purchase Agreements (PPAs) for various infrastructure projects.

• Managed a diverse investment portfolio exceeding $100 million across power, energy, healthcare, and ICT sectors, effectively coordinating with bilateral and multilateral agencies, and played a pivotal role in team leadership, training, and development.

Assistant Manager, Structured Finance

IIDFC Limited, Dhaka Bangladesh

12/2010 - 08/2013

Key Responsibilities and Accomplishments:

• Successfully led the issue management of a BDT 2,000 million + Zero Coupon and Coupon Bond, fulfilling Basel-II capital requirements for major private commercial banks in Bangladesh.

• Initiated and conducted in-depth IPO & RPO research processes, including financial modeling, forecasting, and valuation, contributing to informed investment strategies.

• Developed comprehensive information memoranda, pitchbooks, presentations, and marketing materials, effectively communicating investment opportunities to potential investors.

• Played a key role in structuring multiple deals using debt and equity instruments, demonstrating versatility and expertise in various financial instruments.

• Reviewed and analyzed financial and legal documents in collaboration with common legal counsel, ensuring accuracy and compliance in all transactions.

EDUCATION

Bowling Green State University, Bowling Green, Ohio, USA Master of Arts in Financial Economics

2018 - 2019

IBA, University of Dhaka, Bangladesh

MBA in Finance

2009 - 2011

North South University, Dhaka, Bangladesh

BBA in Finance

2004 - 2008

SKILLS

• Over nine years of experience in Project Management, Syndicate Financing, Financial Modeling, Public Private Partnership, Renewable Energy and Energy Efficient financing.

• Highly proficient in Microsoft Office Suite: Advanced MS Excel (VBA, MACROS), MS Word, MS PowerPoint.

• Advanced knowledge in Financial Restructuring, Due Diligence, Risk Analysis, M&A, Fixed Income Securities, Equities, Valuation (FCFE, FCFF etc.), Foreign Exchange, Derivatives, Mortgage, Commercial Real Estate, Private Equity, Leveraged Finance (LBO, BO) etc.

• Proficient in data analysis and visualization tools such as Python (NumPy, Pandas, Matplotlib, Seaborn etc.), SQL, STATA, MATLAB, SAS, Rstudio, Tableau, Power BI etc.

• Strong leadership, interpersonal, analytical, attention to detail and problem-solving skills. PROFESSIONAL TRAINING AND DEVELOPMENT

• Tableau Desktop Specialist by Tableau 08/2022

• Programming for Everybody (Getting Started with Python) by University of Michigan on Coursera (09/2019).

• Build a Machine Learning Web App with Streamlit and Python

• Python for Data Science and Machine Learning Bootcamp by Udemy.

• The Complete SQL Bootcamp by Udemy.

• Hands on Learning Tableau 2018

• Tableau 2020 A-Z: Hands-on Tableau Training for Data Science

• Special course on “Social Enterprise for Sustainable Development” (10/2014) by The Energy and Resource Institute (TERI), India.

• Training on Project Finance (01/2013) by Infrastructure Development Company Limited (IDCOL), Dhaka, Bangladesh.

• Training on Financial Modeling (02/2011) by Infrastructure Development Company Limited (IDCOL), Dhaka, Bangladesh.

Contact this candidate