Data Analytics Intern
Demonstrated experience with Power BI.
Demonstrated experience with Microsoft Excel.
Demonstrated experience with SQL.
Demonstrated experience with Google Apps Script.
Demonstrated experience with 10-key.
Data Analytics Intern open to new opportunities
Conducted data analysis to identify trends and generate actionable insights.. Performed AI-assisted research to gather, analyze and summarize information for business and project needs.. Utilized AI tools to improve research efficiency, data interpretation and reporting accuracy.. Collected, cleaned and organized datasets to support analysis and decision-making.. Prepared reports and presented findings in a clear and concise manner.. Collaborated with team members on research and analytical projects while meeting project deadlines.
Built a multi-sheet Excel workbook analyzing an e-commerce dataset, including interactive dashboards, descriptive statistics and charts to surface sales and channel performance trends.. Wrote and documented 15 SQL queries to analyze sales, customer and channel-level data, presenting results in a clear, formatted report for stakeholder review.. Identified a high order cancellation and return rate and flagged it as a business risk requiring further investigation.. Determined Instagram as the top-performing revenue channel and identified peak revenue in mid-2024, informing marketing and inventory discussion points.. Produced a professional research report on AI as a research and analytical tool, combining Python-generated visualizations with a formatted written deliverable and an accompanying LinkedIn summary.
Founded and operate a professional swimming club offering beginner through competitive-level programs, managing operations independently from concept to launch.. Designed a Word-based registration form with terms and conditions and an Excel-based membership tracker to manage member records and payments.. Built an end-to-end digital registration system using Google Forms, Google Sheets and Apps Script, documented in a comprehensive setup guide for ongoing use.. Applied a data-driven, process-oriented approach to running a small organization, from member intake through record-keeping.
Identified and prospected potential property owners to join company's portfolio and prepared contracts, agreements and closing documents.. Supported and implemented marketing strategies to promote property rentals and office spaces.. Marketed available rental units to attract prospective customers/tenants, engage leads and close deals.. Touched base with CEO on procurement of items for staging and decoration as well as operational workers.. Managed relationships with contractors, vendors and suppliers to ensure quality workmanship and cost-effectiveness.. Prepared periodic monthly, quarterly and operational reports, uploaded and updated tasks on CRM platform.. Conducted and managed timely check-ins and check-outs through booking.com and Airbnb.. Performed walkthroughs to inspect unit cleanliness and ensured adherence to quality standards.. Ensured all properties remained in excellent condition exceeding client expectations.. Ensured efficiency in recordkeeping by transcribing running costs and revenue items unto database and completing reconciliations with the Accounts Team.. Performed other administrative tasks as directed by management.
Played a hands-on role in managing a busy Airbnb property, ensuring that every guest felt welcomed from the first inquiry to the final check-out.. Built strong rapport with guests through timely communication, local recommendations and thoughtful touches that led to great reviews and repeat stays.. Took ownership of daily operations including bookings, check-ins, issue resolution and coordinating cleaning schedules to maintain a high standard of hospitality.. Promoted the property through engaging social media content and timely updates on Airbnb, Instagram and WhatsApp, helping increase visibility and drive bookings.. Worked closely with cleaners, handymen and vendors to keep the facility guests ready while staying within budget and ensuring top-notch service quality.. Kept clear records of expenses and income, assisted with monthly reconciliation reports and making prompt payment of legal fees.
Organizing and maintaining office files, records, and documentation.. Handling incoming and outgoing correspondence, including emails and phone calls.. Managing calendars, scheduling meetings, and coordinating appointments.. Inputting and managing data in databases and spreadsheets.. Preparing reports, presentations, and other documents as needed.. Assisting team members with various administrative tasks and projects.. Interacting with clients or visitors and providing information or assistance.. Ordering and managing office supplies and inventory.. Coordinating travel plans and itineraries for staff.. Assisting in planning and organizing company events or meetings.
Assisted in preparing accurate, timely and reliable reconciliation statements.. Assisted in ensuring statutory payment are made on timely basis.. Maintained confidential records and files.. Performing general clerical duties.. Carrying out banking activities.. Receipt of allowance claims, conducted daily audit and dispatch of allowance claims.. Issuing of payment slips to respective officers.
Performed other related duties as required by the accountant.. Basic filing duties in the chronological orders.. Drawing weekly budget.. Receipt of cash and issuance of receipt to respective customers.. Working with payment and receipt vouchers both cash and cheque.. Capturing daily sales returns using Tally ERP.. Performing data entry work and other works of clerical nature.
Oversaw daily office operations and ensured smooth workflow.. Maintained accurate financial records, including ledgers and journals.. Prepared and issued invoices, managed accounts payable and receivable, and processed payments.. Assisted in preparing financial statements and reports, contributing to budget preparation and monitoring expenditures.. Inputted and manage financial and administrative data in accounting software and other systems.. Organized and maintained company records, files and documentation.. Served as a point of contact for internal and external communications, liaising with clients, vendors and team members.. Managed calendars, appointments and meeting arrangements for staff.. Reconciled bank statements with internal financial records.. Assisted in planning and organizing company events, meetings and conferences.. Tracked and ordered office supplies as needed.. Helped develop and enforced company policies and procedures.. Updated business social media - websites, Facebook etc.. Engaged in Human Resource - planning, organizing, team leader and recruiting of new staffs.
Accurately entered information into databases and software applications.. Reviewed and verified data for accuracy and completeness before entry.. Updated and maintained existing data records, ensuring they were current and correct.. Generated reports from entered data as requested by management or other departments.. Organized and maintained digital and physical files for easy retrieval.. Conducted regular checks on data accuracy and performed audits to ensure compliance with standards.