Data Analytics

Project Title: Data Management and Automation for Enhanced Reporting

Description: I managed large datasets using MS Excel, Google Sheets, SharePoint, SQL, and Google Script to automate data processing. By leveraging pivot tables, advanced formulas like VLOOKUP, IF, and INDEX-MATCH, along with SQL queries, I ensured data accuracy and streamlined reporting processes. Additionally, I automated workflows in Google Sheets using Google Script, reducing manual tasks and improving data analysis efficiency. Reports and dashboards were shared with the team, enhancing collaboration and accelerating decision-making.

Roles:

Data Management Specialist

Automation Engineer

Reporting Lead

Tools Used:

MS Excel

Google Sheets

SQL

Google Script

SharePoint