Virtual Assistant | Data Analyst

"I have a solid understanding of Excel's built-in functions such as COUNT, VLOOKUP, HLOOKUP, XLOOKUP, SUM, IF, and IFS. I am familiar with using MACROs and have a working knowledge of VBA, which I use to create custom functions with the help of AI tools like ChatGPT. I can create PivotTables, perform data analysis, build dynamic dashboards for data visualization, and handle data cleaning and manipulation efficiently."

"I have experience entering accurate information into various databases, including spreadsheets, servers, RDBs, and software systems. I pay close attention to detail to ensure data accuracy and sometimes use automation to improve efficiency. I always cross-check data against files or documents to ensure its accuracy."

Able to do basic queries, nested queries, subqueries, CTEs. ca do DDL, DML, DQL

"I have experience handling inbound calls, providing effective solutions to customer inquiries, and connecting callers to the appropriate department or person when necessary. I offer direct support for issues I can resolve, ensuring customers receive timely and accurate assistance. My role also includes documenting call details and maintaining professionalism in all customer interactions."

"I am proficient with Photoshop's basic tools and commonly use the software for tasks like removing backgrounds from complex subjects. I can perform color correction and grading, as well as handle straightforward tasks such as creating photo collages, posters, and mockups."

I have experience cutting, trimming, and merging video clips to create a compelling narrative for the audience. I can remove unnecessary footage, add music or sound to enhance the emotional impact of the video, and incorporate elements that improve the overall story and message.

I have experience designing webpages using Elementor's free tools and am familiar with uploading content and navigating WordPress. I can create landing pages, import ready-made templates, and understand the basic functionalities of the WordPress platform.

I have a foundational understanding of SQL, particularly PostgreSQL, which I learned through FreeCodeCamp. My knowledge includes writing basic queries, managing databases, and understanding data manipulation, though I have not yet applied these skills in a professional setting.

I regularly query data from databases, software, and websites, extracting information into CSV files. I clean and organize the data into structured tables, create schemas to understand data relationships, and manipulate the data as needed. Using MS Excel, I generate PivotTables and create visual dashboards to provide insights. My analysis is compiled into weekly reports for better decision-making and performance tracking.