Darshana C G
Bangalore
Summary
A dynamic professional with over 7 years of experience in managing and analyzing business data. Expert in MS Excel, adept at leveraging advanced features such as Charts, Pivot Tables, Slicers, and complex formulas to extract actionable insights. Proficient in developing interactive dashboards and creating Excel-based applications, with a solid understanding of relational database concepts and advanced expertise in SQL. Skilled in data modeling and visualization using PowerPivot and Power BI, seamlessly integrating diverse data sources for in-depth analysis. Highly effective in collaborating with cross-functional teams to understand business requirements and deliver tailored solutions with minimal supervision. Known for strong analytical and interpersonal skills, fostering seamless teamwork and client collaboration.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Team Lead – DATA & MIS
Focus Edumatics Pvt Ltd
04.2023 - Current
- Team leadership: Developed strategies for problem-solving, conflict resolution, and coordinated team activities to ensure efficient project completion.
- Performance Management: Conducted regular performance reviews, provided coaching, and encouraged professional development.
- Training and Development: Created training materials, and conducted group training on new processes and procedures.
- Workflow Monitoring: Ensured adherence to established policies and procedures while monitoring daily operations.
- Customer Satisfaction: Reviewed customer service surveys, resolved complaints effectively, and implemented strategies to improve satisfaction ratings.
- System Development: Designed and implemented database systems to streamline data storage and retrieval processes.
- Process Improvement: Analyzed business processes, identified areas for improvement, and recommended solutions to management.
- Data Analysis and Reporting: Performed data set analysis, built relationships, referenced dashboards, and generated reports using tools like Excel and Power BI.
- Stakeholder Collaboration: Worked with stakeholders to understand needs, develop solutions, and implement changes, including Salesforce-related updates.
- Data Management: Maintained the integrity and backup of databases and transaction logs, while ensuring data validity.
- Reporting Integrity: Configured report templates, safeguarded historical records, and maintained data consistency.
- Operational Oversight: Managed day-to-day operations, assigned tasks, and monitored team progress against deadlines.
- Configuration Management: Set up alerts, privileges, and profile information while managing synchronization processes for single sign-on.
- Performance Monitoring: Tracked team performance against targets, identifying, and implementing corrective actions when necessary.
- Routine Coordination: Deployed team members for data collection, and ensured processed logs were maintained accurately.
MIS Executive
Focus Edumatics Pvt Ltd
Bangalore
12.2019 - 03.2023
- Tracking student information for districts and schools, and generating performance-based reports.
- Editing and updating student data in the Client Portal.
- Keeping the project manager apprised of task progress, issues, and status.
- Providing feedback on the implementation of client-provided manuscripts.
- Conducting statistical analysis for student performance and attendance growth.
- Creating templates for other departments based on their specific needs.
- Develop a proactive checklist for database maintenance to prevent future downtime.
- Composing and forwarding emails to the project manager.
- Regularly updating the Data Tracker and MIS Dashboard on a daily and weekly basis.
- Generating and maintaining productivity reports for agents in the Dashboard, and sharing the MIS Dashboard with senior personnel.
- Ensuring the timely preparation of deliverables, including daily, weekly, and monthly MIS reports, and dashboards, to meet project requirements within budget and schedule.
- Demonstrating proficiency in MS Excel, including HLOOKUP, VLOOKUP, LOOKUP, Pivot Table and Pivot Table Chart, charts, forms, data validation, and scenarios.
- Creating Microsoft PowerPoint presentations for clients as needed by the manager.
MIS Executive
OLA cabs Pvt. Ltd
Bangalore
07.2017 - 12.2019
- Reporting and managing reports of hourly, daily, and weekly auto and cab attachment details of the team.
- Reporting weekly and monthly defects and feedback reports in an Excel matrix.
- Reporting the daily booking status of cabs and auto trackers.
- Identifying initial payments analysis and initial payments cash pending of leasing cab bookings.
- Updating the driver's phone files every week.
- Reporting hourly and daily basis reports of the reactivation project.
- Identifying and reporting Ola points bookings data.
- Updating cash loss balance data every week and every month, active base.
- Monitoring the performance of the team to ensure efficiency in the process, and meeting individual and group targets.
- Reporting the MIP file (Monthly Incentives Plan) of the team on an MTD and YTD basis to the manager.
- Maintaining the employee attendance details, such as authorized leaves, LOP leaves, sick leaves, and maternity leaves.
- Good hands-on experience with V-Lookup, H-Lookup, pivot charts, and graphs in MS PowerPoint.
Education
Bachelor of Commerce - Business Management
Gov’t First Grade College
Hassan05-2017
Some College (No Degree) - PUC
SGR Pre University College
Hassan03-2014
Some College (No Degree) - SSLC
Hoysala High School
Hassan04-2012
Skills
- Microsoft Excel
- Power BI proficiency
- SQL expertise
- VBA
- Dashboard creation
- Adaptability
- Team collaboration
- Documentation and reporting
- Coaching and mentoring
- People management
- Problem solving
- Key Performance Indicators
- Analytical thinking
- Quality Improvement
- Problem resolution
- Database management
- Data analysis and visualization
- Process improvement
- Performance evaluations
- Client communication
Accomplishments
Awarded for best Employee of the year Ola Cabs Pvt Ltd.
Received R & R award twice in Focus Edumatics.
Promoted as Team lead at Focus Edumatics
Certification
- Power BI Certified from Udemy
- SQL Certified from Udemy
Languages
Kannada
First Language
English
Advanced (C1)
C1
Hindi
Upper Intermediate (B2)
B2
Telugu
Elementary (A2)
A2
Timeline
Team Lead – DATA & MIS
Focus Edumatics Pvt Ltd
04.2023 - Current
MIS Executive
Focus Edumatics Pvt Ltd
12.2019 - 03.2023
MIS Executive
OLA cabs Pvt. Ltd
07.2017 - 12.2019
- Power BI Certified from Udemy
- SQL Certified from Udemy
Bachelor of Commerce - Business Management
Gov’t First Grade College
Some College (No Degree) - PUC
SGR Pre University College
Some College (No Degree) - SSLC
Hoysala High School
Similar Profiles
Kiruthiga KKiruthiga K
Online Trainer at Focus Edumatics Pvt LtdOnline Trainer at Focus Edumatics Pvt Ltd
Abhishek KumarAbhishek Kumar
IT Analyst at Focus Edumatics PVT LTDIT Analyst at Focus Edumatics PVT LTD
N. SOWMIYAN. SOWMIYA
Team Leader at Focus Edumatics Pvt LtdTeam Leader at Focus Edumatics Pvt Ltd