Amritpal Singh Email & Phone Number

Chandigarh, India

Indore, Madhya Pradesh, India

OPEN FOR FRANCHISE !!!Balaaz Café is a fast-growing vegetarian brand specializing in creative burgers, pizzas, mocktails, and unique flavors. Known for quality, affordability, and innovation, we aim to redefine fast food and create memorable dining experiences. We are now Open For Franchise opportunities—join us in expanding Balaaz Café to food lovers everywhere!

This is my latest updated Resume. Recruiters can reach out to me related to BI Analyst/ Developer, Data Engineer/Analyst or similar roles. Open to interviews.

Panchkula, Haryana, India

Development/Operations Projects (Power BI):• Established SQL Server Data warehouse with logical and physical Data modeling.• Designed dimensional modeling (Star/Snowflake) with SCD and Role playing dimensions.• Created Sales dashboard with Net Sales, Order Intakes, Order Invoices, and KPIs for Budget, Business performance, and Customer complaints.• Implemented 20+ KPIs across dashboards for strategic decision making.• Utilized DAX for complex data analytics and modifications.• Developed robust Data Quality Management (DQM) framework, reducing data errors by 20%.Product Development Project (Infor Birst):• Designed new scripts and queries for CRM and Sales data movement, reducing processing time by 40%.• Developed 50+ reports and 10+ dashboards, including Delivery Performance dashboard.• Established strategic data pathways to handle 50% more customer invoice correction requests.• Managed Support, resolving 50+ client tickets with timely solutions.Process Automation Project (UiPath Insights):• Achieved 33% process time reduction by automating manual data screening.• Orchestrated creation of 15+ client dashboards, providing actionable insights.• Contributed to RPA initiatives, aligning processes with client needs.Data Migration Projects (Cloud-based):• Implemented 2 data migration projects, reducing processing times by 25% and 30%.• Executed migrations with 98% accuracy, enhancing system performance.• Applied ETL expertise for a 30% boost in data accessibility.

New Delhi, Delhi, India

• Engaged in 3 comprehensive courses featuring live lectures, tutorials, quizzes, assignments, and projects• Explored MySQL and its applications in the first course, gaining valuable insights into database management• Mastered Power BI desktop and service in the second course, and delved into Azure Data Factory basics in the final course

New Delhi, Delhi, India

Reinforcement of Acoustic Sheets for NVH blocking • Performed EDA on datasets, providing generalized solutions for diverse reinforcement combinations• Forecasted flash and plotted µ-wave graphs for compression molding of acoustic sheets

New Delhi, Delhi, India

Barnala Area, India

• Analyzed the breakdowns and eliminated 8 bottleneck areas in the MCA and IBB chemical plants and reduced the overall production losses by 14%• Supervised the engineering team of 40+ members and accomplished a 90% PM (Preventive Maintenance) goal of 8 chemical and 2 pharma plants on time• Spearheaded the in-house expansion project of Ethyl chemical plant and enhanced its production capacity by 40% (from 150 MT to 210 MT)

Powai, Maharashtra

• Performed ABC analysis on the inventory of pressure vessels in the HED department • Cracked the case study of brass mounting defects and detected the root cause of cracks using Crack Propagation Statistical analysis• Programmed the CNC code and designed the optimized nesting of 1000+ sheet metal parts on MOST 2D software and improved productivity by 10%

Masters, Production Engineering, 8.822 Cgpa

Activities and Societies: Published my debut novel in English. Participated in Urdu poetry and charcoal painting competitions at IIT.

Bachelor'S Degree, Mechanical Engineering, 8.66 Cgpa

Activities and Societies: Member of the NGO- Punarkriti and participated in many clothes collection drives in Chandigarh. Member.