Chirag Pandey Email & Phone Number

Bentonville, Arkansas, United States

San Bernardino, California, United States

• Designed an ETL pipeline using Alteryx to migrate user data to SharePoint, improving data accessibility by 30%.
• Established [3] departmental SharePoint sites, creating documentation and conducting user training for efficient communication and collaboration.
• Created a Tableau dashboard to track user adoption rates in SharePoint sites by visualizing key performance metrics like user logins, document uploads, and interaction frequency, delivering critical insights into.
• Conducted hypothesis testing and predictive modeling using R, employing a logistic regression algorithm for research work focused integrating Blockchain in ERP-driven ECM process, achieving 94% accuracy on the test.
• Leveraged Qualtrics, MS Excel and Power BI to manage research survey data, encompassing collection, cleaning, visualization, transformation, and validation, extracting key insights and enhancing storytelling.

Pune, Maharashtra, India

• Performed EDA and root cause analysis using Python and Power BI on customer purchase behavior and sales data, uncovering trends and patterns that led to a 5% reduction in churn rate within [6] months.
• Spearheaded the development and automation of Power BI reports to monitor KPIs like CR, AOV, CAR, and CLTV, using SQL, DAX, and Power Query to deliver actionable insights in retail and e-commerce analytics, improving.
• Applied Agile principles and project management tools to refine models and reports based on ad-hoc requests and feedback from cross-functional stakeholders, meeting evolving business requirements and reducing reporting.
• Implemented robust row-level security for [100+] roles to ensure data confidentiality and integrity, while managing workspace and gateway refreshes within the Power BI service in a large-scale big data environment.
• Optimized data flows using SQL queries on Google cloud platform, efficiently handling large datasets and increasing task efficiency by 25% through reusable data transformations.
• Developed Tableau dashboards for internal resource management, integrating data from CRM tools like Salesforce, to provide insights into role-wise and practice-wise billability, productivity, and bench numbers across.

Indore Area, India

• Led a team of [25] executives for Uber USA support, achieving peak consumer satisfaction of 93% and earning recognition as the best team lead among the [30] teams in the Indian market in May 2017.
• Prepared weekly and monthly performance reports using MS Excel to track KPIs including CSAT and ticket count ensuring effective monitoring and informed decision-making for stakeholders across the organization.

Master Of Science - Ms, Information Systems & Technology (Business Intelligence & Analytics), 3.80

Post Graduate Program,Data Science, Business Analytics, And Big Data, Data Modeling/Warehousing And Database Administration

Bachelor Of Engineering, Civil Engineering