ABHIJIT SUNDARARAJAN
Peoria,IL
Summary
Data Analyst with 5+ years of experience providing actionable insights in manufacturing, procurement, and finance. Proficient in Power BI, predictive modeling, and data pipeline development using Python and SQL. Skilled in statistical analysis and data visualization, with a focus on market and economic trend interpretation for global business strategies. Demonstrated success in effectively communicating insights to senior stakeholders.
Overview
10
10
years of professional experience
Work History
Data Analyst
Caterpillar
Peoria, USA
06.2021 - Current
- Built and maintained advanced Power BI dashboards with real-time procurement and pricing data, supporting decision-making in the global steel procurement team.
- Developed predictive data models to forecast steel pricing trends and patterns globally.
- Collected and transformed data to assess market trends using statistical techniques.
- Analyzed large datasets for trend identification and correlation insights, providing data-driven solutions.
- Developed quarterly reports for annual business plans and RBM in Power BI to forecast global steel prices through data storytelling and visual analytics.
- Collaborated with global stakeholders to deliver bi-weekly and monthly reports to monitor KPIs, aiding in steel vendor negotiations.
Data Analyst
Quality Kiosk Pvt Ltd
Mumbai, India
12.2015 - 07.2018
- Company Overview: Quality Kiosk Pvt Ltd specializes in providing quality assurance and testing services for various industries.
- Worked on different Banking, Insurance, Finance, Mutual Funds & E-commerce, payment systems and mobile applications.
- Leveraged PySpark to clean, transform, and aggregate multi-terrabyte datasets, improving data availability for downstream analytics.
- Developed automated scripts in Python and Selenium for 24/7 monitoring of banking and financial applications.
- Utilized SQL for data-driven quality assurance, analyzing transaction data to ensure accuracy and consistency.
- Performed data driven quality assurance on generated results to ensure accuracy, consistency and managed defects.
- Monitored post-production applications using Dynatrace, investigating end-user transaction data to identify trends and correlations in errors.
- Quality Kiosk Pvt Ltd specializes in providing quality assurance and testing services for various industries.
Education
Master - Information technology and Analytics
Rutgers University
Newark, NJ05-2020
Bachelors - Information Technology
University of Mumbai
Mumbai, India05-2015
Skills
- Analytics and visualization: Power BI, Tableau, MS Excel, Python (Pandas, NumPy, SciPy), R
- Data engineering: data modeling, data warehousing, SQL, SQL Server, MySQL, Snowflake, and PySpark
- Statistical analysis and forecasting: regression analysis, time series modeling, predictive and text analytics
- Tools and platforms: SharePoint, MS Office, Jupyter Notebook, GitHub, and Dynatrace
Timeline
Data Analyst
Caterpillar
06.2021 - Current
Data Analyst
Quality Kiosk Pvt Ltd
12.2015 - 07.2018
Master - Information technology and Analytics
Rutgers University
Bachelors - Information Technology
University of Mumbai
Similar Profiles
Mario Nate McCaslineMario Nate McCasline
Operations Supervisor at CaterpillarOperations Supervisor at Caterpillar
Suraj PSuraj P
CRM Order Specialist at CaterpillarCRM Order Specialist at Caterpillar
Daphne DuthiersDaphne Duthiers
Distribution Manager at CaterpillarDistribution Manager at Caterpillar
Melvin BelcherMelvin Belcher
International Packer at CaterpillarInternational Packer at Caterpillar
John GayJohn Gay
Sales & Delivery at ABarr SimpsonSales & Delivery at ABarr Simpson