Amandeep Sachdeva

Experience

• 

  Kimball Midwest

  Jun 2017 - Aug 2017

  IT Data Analytics Intern

  • Extracted historical data using SQL to create data models using power pivot and review trends in sales, customer and sales rep records • Created reports and dashboards in Excel and R showing trends to help devise strategies and make critical business decisions • Compared sales of successful and unsuccessful sales reps and found patterns which helped train new reps to become more efficient • Predicted growth in sales by using regression analysis and variable dependence to ascertain factors affecting sales Show less

• 

  INFICON

  Feb 2018 - May 2018

  Quality Assurance Intern

  • Led a 4-member cross-functional team to automate the collection of data and optimize the processing of pending customer complaints tickets saving $20,000 in labor cost• Applied the DMAIC six sigma methodology to improve the existing, outdated and tedious quality discrepancy report system

• 

  ZS

  Jul 2018 - now

  • Defined the vision and Product Strategy including new features, enhancements that align with the customer needs• Gathered feedback from customers and internal users to maintain an actionable product backlog• Created go-to market strategy for expanding to broader use cases and customers• Worked with stakeholders to understand priorities and translated those to a measurable, actionable product roadmap• Collaborate with legal to ensure data privacy and compliance are followed and implemented• Collaborated with cross-functional teams like Engineering, Data Science, UX and Business Development to scale the Product Show less • Led a team for the end-to-end delivery of a SaaS solution identifying Industry Experts across 10 major pharmaceutical and emerging Pharma clients• Spearheaded the project kickoff, requirements gathering, design, client communication with different client teams and identifying and mitigating risks and delays to the project timeline along with the project rollout including conducting user training• Designed the data model and key metrics that served as an input to the Machine Learning model for prediction of experts• Engaged with the UX team to translate the business needs into a seamless web application experience for end users• Created actionable personalized insights and summaries from the data to provide engagement strategy for the users Show less • Set up AWS infrastructure services like EC2, EMR, ECS, Redshift, Athena in client cloud environment to host the business solution making it scalable and cost effective with the proper IAM policies in place for security and governance• Provided technical insights including creating user requirements, solution mockup, technical architecture and design• Created intuitive dashboards depicting critical KPI’s for sales and marketing teams involving 25+ users in Qlik Sense • Worked with different teams to deploy a custom UI application to optimize Clinical Trial design for a major Pharmaceutical client which involved combining Clinical Trial data from 5 different data sources Show less

  • Business Technology Solutions Consultant

    Jun 2023 - now

  • Business Technology Solutions Associate Consultant

    Dec 2020 - Jun 2023

  • Business Technology Analyst

    Jul 2018 - Dec 2020