App Sheet
VASANTHKUMAR SIVALINGAM
DATA ANALYST
Coimbatore,TN
Summary
Experienced professional with over 6 years of expertise in data analysis, reporting automation, and process enhancement. Proficient in Advanced Excel, VBA Macros, Power Query, PowerPoint, and basic Power BI. Skilled in developing custom business applications using AppSheet and creating interactive dashboards in Looker Studio. Expert at optimizing reporting workflows and providing valuable insights through data visualization and automation tools.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
4
4
Languages
Work History
Data Analyst
Stylcove Modulars Pvt Ltd
10.2024 - Current
- Streamlined and automated key operational data flows across departments including installation, procurement, cost tracking, and vendor management.
- Designed and implemented multiple custom business applications using Google AppSheet to digitize and optimize field operations and reporting workflows.
- Implemented email automation using VBA scripting and AppSheet automation to trigger real-time notifications, alerts, and report sharing.
- Developed interactive and real-time dashboards using Looker Studio for leadership to monitor project timelines, cost performance, and vendor payment statuses.
- Built Excel-based dashboards for tracking installation progress, cost control, and time management, improving visibility and decision-making across project teams.
- Collaborated with cross-functional teams to translate operational challenges into data-driven solutions and app-based workflows.
- Tracked ongoing projects to ensure timely execution, enabling effective time management and on-time delivery of interior execution phases.
- Ensured timely and accurate monitoring of vendor payments, enhancing financial control and transparency.
- Collaborated with cross-functional teams to translate operational needs into automated reports, data models, and app workflows.
- Ensured timely and accurate monitoring of vendor payments, improving financial visibility and compliance.
MIS Executive
Careernet
07.2022 - Current
- Company Overview: India's leading talent solutions provider.
- Proficient in developing reports and dashboards using Advanced Excel, VBA Macros, Power Query, PowerPoint, and Power BI (Basic), incorporating various visualizations such as Bar charts, Pie charts, Line charts, Maps, and Bubble charts.
- Completed an end-to-end VBA Automation project titled 'HR Payroll,' leveraging VBA macros and integrating ChatGPT to enhance functionality and efficiency.
- Collaborated with Operations Managers and teams across various locations for data collation and analysis to achieve targets, while ensuring data cleaning and validation for accurate analysis.
- Efficiently managed the entire billing process, including invoicing, payment tracking, and resolution of billing discrepancies, while cultivating positive client relationships and demonstrating proficiency in ChatGPT.
- India's leading talent solutions provider.
MIS Executive
CMS Info Systems
08.2021 - 07.2022
- Company Overview: Cash management, ATM, currency, retail, enterprise, and card solutions in India.
- Managed financial data encompassing cash flow, liquidity, and banking transactions, utilizing Advanced Excel for generating regular reports on cash positions and financial performance.
- Led financial account management and strategic planning, leveraging Advanced Excel for customized reporting and efficient cash flow management. Maintained high customer satisfaction and adherence to procedures.
- Customized reports tailored to diverse stakeholder needs within the organization, leveraging Advanced Excel functions, formulas, and pivot tables for effective financial data analysis.
- Monitored banking activities, ensuring smooth cash management operations, and promptly resolving issues to maintain financial efficiency.
- Provided prompt and effective resolution to customer inquiries, earning positive feedback for exceptional service delivery and issue resolution.
- Cash management, ATM, currency, retail, enterprise, and card solutions in India.
Junior Executive
Cafe Coffee Day
09.2017 - 11.2019
- Company Overview: Hospitality Industry.
- Managed front desk operations at a café, ensuring a friendly atmosphere and overseeing customer interactions.
- Managed order processing, food preparation, and customer inquiries, focusing on enhancing the dining experience.
- Provided exceptional customer service, promptly addressing needs and concerns with courtesy.
- Implemented effective stock control measures, monitored inventory levels, and managed end-of-day procedures with meticulous attention to detail.
- Hospitality Industry.
Education
B.Com - Computer Applications
Annamalai University
01.2016 - 01.2019
Diploma - Business Hotel Management
Alagappa University
01.2014 - 01.2017
Skills
Skilled in Microsoft Office tools
Strong skills in advanced Excel analysis
VBA development
Skilled in document creation using Word
Presentation design
Power BI proficiency
Data transformation expertise (Power Query)
Automation using VBA tools
Skilled in data management using Google Sheets
Process optimization expertise
SQL database management
Streamlined dashboard processes
Efficient report automation techniques
Analytical report development
Data analysis proficiency
Experience in developing AppSheet applications
Data visualization with Looker Studio
Analytical decision making
Invoice processing
Operational management
Project execution management
Cost Management
Quality control expertise
Negotiation skills
Effective time management
Accomplishments
- Project Management, Successfully completed an end-to-end VBA Automation project titled 'HR Payroll,' enhancing functionality and efficiency.
- Financial Management, Proficiently managed financial data to ensure smooth operations, demonstrating expertise in enhancing efficiency, ensuring customer satisfaction, successful project management, and effective financial management.
- Customer Satisfaction, Received 95% positive feedback for leading a team that consistently delivered exceptional service and resolved issues promptly.
Software
Looker Studio
Power bi
Canva
SAP
Jotform
Glide
Interests
App Development using No-Code Platforms (AppSheet, Power Apps)
Business Intelligence & Dashboarding (Power BI, Looker Studio)
Process Optimization & Workflow Automation
MIS & Operations Analytics
Visualization of Business KPIs
Work Preference
Work Type
Part TimeFull TimeLocation Preference
On-SiteRemoteHybridImportant To Me
Work-life balanceCompany CultureFlexible work hoursCareer advancementPersonal development programsPaid sick leavePaid time offHealthcare benefitsWork from home optionWork Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Advanced (C1)
Tamil
Bilingual or Proficient (C2)
kannada
Intermediate (B1)
Hindi
Beginner (A1)
Timeline
Data Analyst
Stylcove Modulars Pvt Ltd
10.2024 - Current
MIS Executive
Careernet
07.2022 - Current
MIS Executive
CMS Info Systems
08.2021 - 07.2022
Junior Executive
Cafe Coffee Day
09.2017 - 11.2019
B.Com - Computer Applications
Annamalai University
01.2016 - 01.2019
Diploma - Business Hotel Management
Alagappa University
01.2014 - 01.2017