Hafiz Muhammad Usman
Data Engineer at Data Pilot- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Data Pilot
-
Pakistan
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Engineer
-
Feb 2023 - Present
-
-
Data Science Intern
-
Aug 2022 - Mar 2023
• Implemented end-to-end data science process, including building data pipelines to collect data from various sources, storing data, transforming data and creating visualizations and dashboards to provide insights into marketing funnel trends, website traffic behavior and marketing campaign performance.• Developed and implemented data pipelines to collect data from various sources, including LinkedIn, Hubspot, LinkedIn Ads, Google Ads, and Google Analytics and stored in Google BigQuery using connectors such as Fivetran and Skyvia.• Utilized dbt to perform data transformation using Google BigQuery as connection and Github as code repository.• Utilized Trello for project management and tracking.• Helped improve marketing campaigns by identifying best performing months for each source and researching their insights to implement improvements in marketing campaigns.• Impacted the business by providing insights into various KPI's such as trends of data sources, CPC, CTR, CPM, leads, marketing funnel behavior (leads, SQL, MQL, opportunities and conversions), website traffic behavior, bounce rate, landing page, and average time spent on each page. Show less
-
-
-
-
Assistant Manager Business Development
-
Jan 2022 - Mar 2023
-
-
PV Engineer
-
Aug 2020 - May 2022
- Designing solar Photovoltaic systems ( 100 kW to 5 MW ) with the optimized yield for industrial andcommercial clients and performing energy assessments including statistical analysis of data, solar modeling, loss evaluation, and uncertainty analysis. - Perform material takeoffs from layouts, general arrangement, to prepare Bill of Quantities (BOQ) for alldisciplines (Civil, Electrical, Mechanical). Liaising with vendors for technical information and competitive pricing of the Balance of system. - Analyze costs and benefits of proposed designs or projects. - Work with, leading where appropriate, multifunctional engineering teams in the development of conceptual solutions, technical work scope & specifications for project applications. - Assist in project management duties and responsibilities. - Performing Economic feasibility analysis including Levelized cost of electricity (LCOE) calculation, netpresent value analysis, IRR, WACC, solar tariffs for PPAs and payback period. - Development of value-added propositions and translating solutions into effective business proposals. - Review specifications and recommend engineering or manufacturing changes to achieve solar design objectives. - Develop new engineering concepts and products based on feedback from market exposure. Show less
-
-
-
ZED Solar
-
Pakistan
-
Renewable Energy Semiconductor Manufacturing
-
1 - 100 Employee
-
Techno Commercial Engineer
-
Feb 2018 - Aug 2020
- Working with sales team to professionally represent the company at a client and understand its processes, gather structural, electrical and useful site data and ask the right questions to define a project.- Designing solar Photo voltaic systems with optimized yield for industrial and commercial clients and performing energy assessments including statistical analysis of data, solar modeling, loss evaluation, and uncertainty analysis.- Working with cross-functional teams to develop optimized structural and electrical designs and quote technically sound and cost effective solutions. - Planning and implementing the PV system layout plans to achieve the target project objectives.- Identifying areas of improvements and presenting solutions to improve performance. -Performing Economic feasibility analysis including levelized cost of electricity (LCOE) calculation, netpresent value analysis and payback period. -Development of value-added propositions and proposal writing. Show less
-
-
Trainee Engineer
-
Aug 2017 - Jan 2018
• Responsible for carrying out Front End Engineering Design Analysis according to client demandsand for improving the Thermal Model of the Solar Dish.• Developed System Level Thermal Model in EBSILON Professional Software ensuring it to beeye-catching for the clients.• Interpreted MS Excel Thermal Analysis sheet and updated it.• Analyzed Thermal Mathematical Model of OTSSG (Once Through Solar Steam Generator) in MATLAB and updated to calculate its maximum Total Efficiency.
-
-
-
3W Systems (Pvt) Ltd
-
Lahore, Pakistan
-
Intern (Mechanical)
-
Jul 2016 - Aug 2016
• Designed Solar Panel System for 3W systems main office and optimized the system according to load and area available. • Designed Centrally Air Conditioned System for 3W systems main office and reduced 2 tonnes refrigeration load from previous design. • Designed Solar Panel System for 3W systems main office and optimized the system according to load and area available. • Designed Centrally Air Conditioned System for 3W systems main office and reduced 2 tonnes refrigeration load from previous design.
-
-
Education
-
Lahore University of Management Sciences
Master of Science - MS, Accounting and Analytics -
Ghulam Ishaq Khan Institute of Engineering Sciences and Technology
Bachelor of Science (BS), Mechanical Engineering -
Government College University, Lahore
Higher Secondary School Certificate, engineering -
Crescent model higher secondary school lahore pakistan
Secondary School Certificate, Sciences