Hamza Jamil

HAMZA JAMIL - |-EDUCATION LAHORE UNIVERSITY OFMANAGEMENT SCIENCES September 2015-June 2019 BSc (Honors) in Accounting & Finance (Math Focused) - CGPA: 3.43/4.00 RELEVANT COURSES: CS 100 & 200, Advanced Stochastic Process, Statistics, Probability, Calculus I & II, Differential Equation, Linear Algebra with Differential Equations, Computer and Problem Solving, Intro to Management Sciences, Strategic Management, Supply Chain CERTIFICATIONS: The Data Scientist’s Toolbox, R Programming, Getting and Cleaning Data, Exploratory Data Analysis, Reproducible Research, Statistical Inference, Regression Models, Practical Machine Learning, Developing Data Products, Data Science Capstone, Advanced Relational Database and SQL, Data Wrangling, Analysis and AB Testing with SQL, Distributed Computing with Spark SQL PROFESSIONAL EXPERIENCES AFINITI July 2020-Present Analyst Software Engineer Liaise with client stakeholders, including senior and executive level client staff, to communicate data requirements and help secure data assets from clients as well as offline data sources Building and managing automated machine learning data pipelines and systems Able to drive successful completion of deliverables and analytic deliverables Ensures quality and reliability of data obtained from client sources and offline data sources (ensuring that data contains required information for analytics and modeling) Responsible for performance reporting aspects on concurrent new installations (or expansions) and for existing billing accounts Respond to requests for performance results (at levels other than provided on production reports or to confirm results on production reports) Drill down on results (problem solving analysis) and conduct custom analysis Validate monthly billing, reconcile data (internally and with the client) Define data joining procedures for new installations and expansions. Document and get client to agree to procedure. (Well written document with flowchart) Break down and audit join production join procedures Confirm that call outcomes can be determined from data being offered Ensure data integrity on review of historical data Confirm that AI team is able to optimize the performance metric desired by the client and that the data provided by the client is sufficient (completeness and usability) Define data validation reports to be shared with client Show client how to look at the data and give them comfort around the procedure and the various checks that are part of validation. (Present results and SQL procedures to client via web session) Perform other duties as assigned – prepare succinct, clear, and easy to follow documents that summarize findings and insights TECHLOGIX February 2020-June2020 Executive Sales Coordinator/ Data Analyst Sourced, tracked and prepared monthly report and statistics to gauge performance metrics of various digital marketing activities on LinkedIn, Twitter and Facebook Worked on costing and pricing schedule for quotas, promotions and negotiations with prospective clients Carried out market research for competitive analysis Automated and streamlined the entire process of email campaign, social media marketing and lead generation workflow for Vicenna, AlmusNet and FSI, three subsidiaries under Techlogix Inc, reducing manual work hours by over 40% Designed excel algorithm based on average search, competition index and Cost-Per-Click for optimal Google Adwords optimization Streamlined social media marketing statistics generation for prudent analysis NESTLE PAKISTAN LIMITED September 2019-Novermber 2019 Intern-Supply Chain Gathered and cleansed data pertaining to transport and procurement operations at Nestle factories in Kabirwala and Sheikhpura Identified optimal trading routes and cost saving opportunities for development of new supply line of biscuits PRICEWATERHOUSECOOPERS (PwC) July 2017-September 2017 Intern–Assurance & Business Advisory Service Conducted audit of Pakistan Rural Support Program (PRSP) covering over 2800 Basic Health Units (BHUs) and Rural Health Centers (RHCs) Improved the accuracy and transparency of Rs.329 billion of budgetary allocation through investigation of cash-flow channels of cash and bank balances Determined the condition and extant of inventory and physical assets worth Rs.1 trillion through forensic research Identified loopholes in internal controls through analysis and made recommendations to supplant them PROJECTS SENIOR YEAR PROJECT: DATA ANALYSIS OF PUNJAB HEALTH DEPARTMENT Reduced wastage and increased capacity utilization of medicine of over 2800 Basic Health Units (BHUs) and Rural Health Units (RHUs), through identification of redundant facilities and consumption trends CS: BATTLESHIP Developed the game BattleShip ADVANCED STOCHASTIC PROCESS Developed simulation of Smart Grid Electricity Consumption using Gaussian Markov Model COMPUTER AND PROBLEM SOLVING Developed an optimization models for modeling the operations of a shipyard INTRODUCTION TO MANAGEMENT SCIENCES Developed a mathematical linear programming models for scheduling classes at LUMS EXTRACURRICULAR ACTIVITIES LAW & POLITICS SOCIETY AT LUMS October 2015-November 2017 Led the Law and Politics Society at LUMS as Assistant Director Organized and led over 10 seminars and talks each year having guests of over 100 people in each Managed and organized Pakistan’s Biggest Moot Court Competition with over 120 Participants from 5 cities all over Pakistan HONORS AND AWARDS Placed on Deans Honors’ List in Freshman Year 2015-16 at LUMS Received Full Academic Scholarship A level’s. Received Best Team Member Award among 20 team members in LPS Received Top in Accounting & Economics Award among 80 students in O level’s. Received Second in Law Award among 20 students in A Level’s ADDITIONAL SKILLS AND INTERESTS Proficient in: R, MySQL, PostgreSQL, Talend, MS Office, Lingo, Macros, Power BI, MATLAB Hobbies: Fitness Training, Travelling and Reading (Non-Fiction)