Amritpal Singh

About Amritpal Singh

A BI Analyst/ Developer, whose favorite dish is Data visualizations sprinkled with SQL queries. After more than 1 year of experience in Data Analytics, I can confidently say that I have created hundreds of reports and multiple dashboards in ETL tools like Power BI, Infor Birst, UiPath Insights etc. I love it when data speaks to me through graphs and tables. I have done development project in Power BI, through SQL queries, and have been handling operations and support work on Infor Birst Software which is still going on. I have handled support also and solved numerous client tickets which required backtracking, ETL expertise, SQL queries and data cleaning. I have been applying my smart working techniques learnt in IIT Delhi to my real life experiences which if simply put, means that I am always in the \"Learning mode\". In 2024, my New Year resolution is to bring this ETL and Data analytics expertise to overcome new challenges. I am open to exploring new opportunities that align with my passion for data driven decision making. If you have reached up to here, Let\'s connect and shape success together!

Experience

1. Bi Analyst Developer

   Centelli

   Dec 2022 — Present · Panchkula, IN

   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.

Education

• PEC University of Technology, Chandigarh

  Bachelor's degree, Mechanical Engineering

• Indian Institute of Technology, Delhi

  Masters , Production Engineering

  2019