Muhammad Sami Ullah Khan

Experience

• 

  Oil & Gas Development Company Ltd. Pakistan

  Aug 2019 - Aug 2019

  Internship Trainee

  -Coordinated with a service company in order to develop a work plan for 24 hours operation of Re-perforation and learned how it is performed.-Actively participated in reverse-out activity and also learned the mechanism of Jet Pump. -Invested a significant amount of time at the processing plant in order to get insights on how it works.-Assessed 5 years dispatch oil data using excel in order to get it matched with the distribution company receiving data in production head office.

• 

  Student Energy

  Sept 2019 - Oct 2020

  Finance Lead

  Leadership: Managed events expenditures and supervising my team members, generating and maintaining records of all expenses and recovered it from either Head office or Sponsorship

• 

  Amal Academy

  Feb 2020 - May 2020

  Career-Prep Fellow

  Communication Skills: Proposed a competitive written application and interview process to be selected from over 4500 applicants for intensive 3-month Fellowship funded by Stanford UniversitySkills development: Managed 150 hours in order to develop business skills (e.g., communication, leadership, problem solving, teamwork, etc.) that will help me make a deeper impact on the job

• 

  PepsiCo

  Aug 2020 - Sept 2020

  Supply Chain Intern

  Adaptability: Collaborated with a team of 8 diversified people from all over Pakistan and achieved all the KPI’s of the project successfully. Teamwork: Invested more than 100 hours in working with the team to accomplish the goals of the project. Interpersonal Skills: Proposed a competitive video regarding achievements, success and failures and got selected in more than 500 applicants across Pakistan.

• 

  Data ConnecXion

  Dec 2021 - Jun 2024

  Data Analyst

  Utilized Microsoft Excel 360 to track and analyze logistics data.Develop and maintain analytical tools and reports using PowerBi andother relevant software. Understand business needs and translate theminto actionable strategies. Analyze performance data to identify opportunities and proposesolutions. Synthesize data and conduct operational and financial analysis toimprove overall performance. Recommend improvements to supply chain metrics and performancestandards. Update and maintain master data in relevant systems.Employ ADP software to ensure the correct payment of hourly wages todrivers and employees of the company in a timely manner. Show less

• 

  Pakistan Petroleum Limited

  Jul 2024 - now

  Data Management Engineer

  SQL & SSRS Reporting: Designed and customized SQL views to facilitate data visualization in Oil Field Manager (OFM), improving accessibility and insights. Developed SSRS (SQL Server Reporting Services) reports for both internal and external reporting needs, particularly for PPL (Production Performance Logging).Data Views Customization: Created tailored database views using SQL to enhance data accessibility and visualization, helping streamline reporting workflows.Centralized Data Modeling: Modeled fields, plants, wells, and completions in Avocet Data Manager (AVM), establishing a centralized repository for production and sales data.Report Development & Publishing: Developed, tested, and published customized reports to the reporting server, improving efficiency and accuracy in data dissemination.CP Automation Project: Designed and developed interactive, secure, and scalable web applications using Flask, HTML, CSS, and JavaScript to create customizable web-based templates and visualizations. These applications were tailored to streamline data collection processes, allowing field staff to efficiently and directly submit data to an SQL Server database. The solution was optimized for ease of use, ensuring seamless data entry from remote locations while maintaining robust security measures to protect sensitive information. Show less