Hamzah Jamal

Experience

• 

  Cenotech India Pvt. Ltd.

  Aug 2019 - Feb 2021

  Mechanical Engineer

  - Analyze production schedule, collected historical data and built a manufacturing predictivemodel in form of a project report using basic mathematical tools.- Expedited the manufacturing by automating the working of a mechanical component usingPLC.- Prepared perpetual inventory system using excel for different raw materials, tools and finalproduct to provide accurate daily/monthly inventory level and unit sales data.- Chaired a team of 6 individuals as Site Engineer for the installation of SPD's on differentrailway stations as a part of railway tender.- Designed components on AutoCAD & performed quality tests on products as per RDSO andUL standards and specifications. Show less

• 

  Tata Insights and Quants - A Division of Tata Industries Limited

  Nov 2021 - now

  Assistant Manager - Analytics Services

  𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐖𝐞𝐛 𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭: Seamlessly integrated Node.js web apps with Python scripts for robust data handling and analytics. Orchestrated migration to new production servers, enhancing security and facilitating client training. Led cross-functional teams to ensure efficient communication and successful project delivery.𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐒𝐞𝐠𝐦𝐞𝐧𝐭𝐚𝐭𝐢𝐨𝐧: Developed PySpark-based data pipelines on Azure Databricks for diverse customer segments, automated daily data refresh processes, and implemented quality assurance checks for efficient data flow and database feeding. Applied business rules and clustering analysis to generate Customer Dimensions for targeted campaign strategies, resulting in improved business outcomes at a retailer. 𝐃𝐚𝐭𝐚𝐛𝐫𝐢𝐜𝐤𝐬 𝐎𝐫𝐜𝐡𝐞𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧: Utilized Azure Databricks for distributed computation, extracting and transforming data from the data lake. Applied advanced database management and optimization skills, automated workflows for efficiency, and crafted Power BI reports for impactful data visualization.𝐃𝐚𝐭𝐚 𝐏𝐢𝐩𝐞𝐥𝐢𝐧𝐞 𝐄𝐧𝐡𝐚𝐧𝐜𝐞𝐦𝐞𝐧𝐭: Implemented best practices to maintain and revamp data pipelines for multiple clients in retail, Energy & Utilities and E - Commerce. Ensured modular and scalable implementations, integrated robust data governance checks, and optimized data management. These efforts resulted in improved system efficiency, minimized the need for human intervention, and effectively prevented escalations from end users.𝐖𝐞𝐛 𝐒𝐜𝐫𝐚𝐩𝐢𝐧𝐠 𝐃𝐚𝐭𝐚 𝐏𝐢𝐩𝐞𝐥𝐢𝐧𝐞: Executed a data pipeline incorporating web scraping for multiple URL data extraction, establishing a database for an internal search engine. Managed database operations, ensuring integrity and performance. Implemented data integration for a unified view and automated processes to enhance efficiency. Ensured data quality through comprehensive quality assurance measures. Show less