RAJAT SHARMA
DATA ANALYST
BHOPAL
Summary
Detail-focused Data Analyst with 6+ years career in knowledge in data analysis, process validation ,business needs analysis as well as in other IT sector. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
Work History
Data Analyst
Grant Thornton Bharat LLP
JAIPUR
2022.10 - 2023.10
- Develop operational reports using Power BI. (STARS PROJECT, WORLD BANK)
- Monitor and analysed data collected from Google forms & various other mediums for Rajasthan Council of School Education (RCScE). (UDISE as well as Prabandh portal)
- Analysis and cleaning of the data for Independent Verification Agency (IIM, Indore) query.
- Analysis the data for making Annual Work Plan and Budget for Samagra Shiksha, Rajasthan 2023-24 ,2024-25 Plan for RCScE.
- Interpret data, analyzing results and trends, using statistical techniques where appropriate.
- Generate high quality formal analytical reports on key program delivery outcomes such as Enrolment, Retention and Learning, as per defined calendar.
- Develop Dashboards for Rajasthan Civil Cell through Google Sheets for various schemes (NABARD RIDF, PAB)
- Conduct periodic data quality assessments through pattern and outlier analysis.
- Develop SQL queries to obtain complex data from tables in on-site and remote databases.
- Developed Automated generated Google sheets for the Rajasthan government to monitor the progress of the Civil department.
- Added new features and functionalities to web-based system to improve performance and increase security (Civil portal) [Module Under Shala-Darpan,Rajasthan].
- Applied advanced-excel skills to manage data using pivot-table, VLOOKUPS, SUMIFS, and index match.
- Assisted in circulating the e-content application (Step-app) to across Rajasthan.
- Develop Charts-Graphs and analyze the data for Ministry of Education, Government of India.
- Produced monthly reports using advanced Excel spreadsheet functions.
Data Analyst
Sea Asia Shipping Services LLP
BHOPAL
2021.10 - 2022.02
- Gather data from various sources within the logistics company, such as transportation management systems (TMS), warehouse management systems (WMS), GPS tracking, and inventory databases.
- Define and monitor key performance indicators (KPIs) for logistics operations, such as on-time delivery, order accuracy, and transportation cost per unit.
- Optimize transportation routes to minimize fuel consumption, reduce transit times,and enhance delivery efficiency.
- To identify KPIs with clear objectives and monitor them.
- To prepare communications reports, presentations, and reports by operating Microsoft Office.
- Work in Python packages like NumPy, Beautiful Soup, and MatPlotlib.
Server Administrator/Data Analyst
Livia Pvt India Ltd
MUMBAI ,BHOPAL
2016.02 - 2021.10
- Maintained network hardware and software and monitored network to support network availability to end users.
- Installed, configured and supported local area network (LAN), wide area network (WAN) and Internet system.
- Managed computer operation scheduling, backup, storage and retrieval functions.
- Identified and immediately resolved issues with network devices.
- Performed day-to-day LAN and WAN administration, maintenance, and support.
- Verified continuity of computer and telephone system services for users..
- Managed data backups and disaster recovery operations to comply with business continuity initiatives.
- Assisted IT staff on troubleshooting issues and closing calls.
Education
B. Tech - Computer Science Engineering
Rajasthan Technical University,Kota
KOTA, RAJASTHAN 2011.05 - 2015.06
Intermediate - PCM
Lawrence And Mayo Sr Sec School
KOTA 2010.05 - 2011.04
High School - Overrall
St. Mary' Co-Ed School,Harda
Harda 2009.04 - 2010.05
Skills
General and graphic application: Microsoft Power BI
Timeline
Data Analyst
Grant Thornton Bharat LLP
2022.10 - 2023.10
Data Analyst
Sea Asia Shipping Services LLP
2021.10 - 2022.02
Server Administrator/Data Analyst
Livia Pvt India Ltd
2016.02 - 2021.10
B. Tech - Computer Science Engineering
Rajasthan Technical University,Kota
2011.05 - 2015.06
Intermediate - PCM
Lawrence And Mayo Sr Sec School
2010.05 - 2011.04
High School - Overrall
St. Mary' Co-Ed School,Harda
2009.04 - 2010.05
Similar Profiles
Zainul AttarwalaZainul Attarwala
Assistant Tax Manager at Grant Thornton Bharat LLP (Walker Chandiok & Co. LLP- Member firm)Assistant Tax Manager at Grant Thornton Bharat LLP (Walker Chandiok & Co. LLP- Member firm)
Nimit M DaveyNimit M Davey
Director at Grant Thornton Bharat LLPDirector at Grant Thornton Bharat LLP
Raju KumarRaju Kumar
SOC Manger at Grant Thornton Bharat LlpSOC Manger at Grant Thornton Bharat Llp