SANDHYA RANI M
BRAMPTON,Ontario
Summary
Analytical and insightful Data Analyst known for productivity and efficiency in task completion. Specialize in data visualization, statistical analysis, and predictive modeling. Excel in problem-solving, critical thinking, and communication, ensuring successful project outcomes and team collaboration.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Data Analyst
Pardean IT solutions
Brampton, Ontario
05.2024 - Current
- Performed the analysis on the retailer supply chain data to measure and report the key business indicators (KPIs) of on-hand inventory across stores, thus improving the on-shelf availability using Power BI dashboards.
- Performed an analysis of the manual touches during transportation planning and optimization. Provided the insights and visualization using Power BI on cost variance, carrier changes, and areas to reduce the manual interventions in planning.
- Performed a comprehensive analysis on production batch run times to determine the variances in runtimes, and generated heat maps and time series graphs to identify the problematic jobs required for tuning.
- Utilized advanced analytics tools such as POWER BI and Excel PowerPivot to manipulate large volumes of structured and unstructured data sets.
- Generated reports and obtained data to develop analytics on key performance and operational metrics.
- Provided technical support for existing reports, dashboards or other tools.
- Built visualizations that enabled users to quickly interpret results from complex analyses.
Data Analyst
Shri Technologies India
Hyderabad, Telangana
10.2013 - 03.2019
- Worked on strategic planning and estimations on skill development projects.
- Maintained the Personal identifiable information database for the trainees, trainers, and batches, and schedule information.
- Tracking the batch-wise training progress, total trained, target status, and inventory status.
- Built a Power BI dashboard to visualize the training progress, assessment completion, and trainer placements, placements within the batch.
- Analysis of current company performance and forecasting future projects.
- Generation of daily, weekly, and monthly MIS reports.
- Processing the invoices and reconciliation of the payments.
Costing Analyst
ITC Paper board Ltd
BHADRACHALAM, TELANGANA, INDIA
05.2008 - 06.2013
- Conducted requirements gathering with stakeholders to elicit and document the business requirements.
- Analyzed existing business processes and systems to identify inefficiencies and areas for improvement.
- Gathered and analyzed the data from the production, supply chain, and sales departments for the variance analysis.
- Automation of daily/monthly reports by cleansing the raw data and visualizing it in Excel graphs.
- Performed master data validations and was involved in the migration from Oracle to the SAP CO module.
- Performed user acceptance testing (UAT) to validate that the solutions met business needs.
- Performed various Excel data analyses and audits on cost comparisons, product, activity-based costing, and net sales realization.
- Coordinating with various teams in the organization to gather the required details and prepare the pulp furnish, inventory valuation, MIS reports, and relevant presentations to senior leadership.
- Used Excel macros to automate the daily and monthly inventory, sales reports.
- Writing queries using SQL to fetch the data from Oracle and MS Access databases.
Education
MBA - FINANCE AND HR
KAKATIYA UNIVERSITY
TELANGANA , INDIA06-2008
Bachelor of Science - COMPUTERS
KAKATIYA UNIVERSITY
TELANGANA,INDIA06-2006
Skills
- Advanced Excel (Pivot Tables, VLOOKUP, Macros)
- Data cleaning and transformation using SQL, Python, and R
- Statistical Analysis and Modeling
- Microsoft Power BI
- Python (Jupyter Notebook, Pandas, Django)
- SQL (queries, joins)
- PL/SQL (Views, Functions, and Procedures)
- Tableau and Power BI are used for data visualization
- MIS reports preparation
- GitHub, Confluence, Jira
- Data profiling
Certification
- Cisco Certification in Data Analytics Essentials
- Cisco Certifications in Python Essentials
Timeline
Data Analyst
Pardean IT solutions
05.2024 - Current
Data Analyst
Shri Technologies India
10.2013 - 03.2019
Costing Analyst
ITC Paper board Ltd
05.2008 - 06.2013
MBA - FINANCE AND HR
KAKATIYA UNIVERSITY
Bachelor of Science - COMPUTERS
KAKATIYA UNIVERSITY
Similar Profiles
KIRUBAKARAN NKIRUBAKARAN N
Deputy Sales Manager at Blue Mach Solutions (Godrej Storage Solutions)Deputy Sales Manager at Blue Mach Solutions (Godrej Storage Solutions)
CRYSTAL HOLLOWAYCRYSTAL HOLLOWAY
New York Life at Customer Solutions III, Life SolutionsNew York Life at Customer Solutions III, Life Solutions
Jarrod HullJarrod Hull
Tyre Shop Manager at Tyre and Wheel Solutions (Automotive Solutions)Tyre Shop Manager at Tyre and Wheel Solutions (Automotive Solutions)