Jaeson Cardaño

Jaeson T. Cardaño Certified Excel Expert • Data Analyst • Excel Reports Specialist Age: 39 years old Civil Status: Married Languages Spoken: Ilocano, Filipino & English Religion: Iglesia Ni Cristo (Church of Christ) Contact, Additional Info and Certification: Mobile#: - | LinkedIn Profile: Excel Specialist Creator/Admin: E-mail :-/-https://www.linkedin.com/in/jcardano https://www.facebook.com/groups/ExcelSpecialist Certified Excel Specialist - Expert Level: https://www.credly.com/badges/51eaf637-b412-443a-b986-b4c802b0d7c0 Certified Six Sigma Yellow Belt (Six Sigma Philippines): CSSYB- Address: B45 L3, Bulaon Resettlement, City of San Fernando, Pampanga, Philippines, 2000 Skills: Notable Skill in Excel and Googlesheet: 1) 2) 3) 1) Data Manipulations / Data Organization: I can turn a messed dataset into proper format using complex formula like combination of LOOKUP,INDEX+MATCH, SUMIFS, COUNTIFS, TEXT Functions, ARRAY Functions like FILTER & SORTBY, Macro/VBA, etc. 2) Reporting / Dashboarding: I love transforming raw data into an Interactive Dashboard with meaningful graphs, tables and buttons. Example of raw data are from CRM, Database, from Digital Marketing like from FB, Twitter, Amazon, Google Adwords, Shopify, eBay, etc) 3) Automation: Using Complex formula and VBA/Macro I can automate or semi-automate manual steps for preparing the data or the reports to limit human errors and increase productivity. Additional Skills/with knowledge: 1) Databases like MS Access and Oracle SQL 2) Other Google Office Apps like, GoogleSlide, GoogleDocs, Google Form 3) Power BI, SharePoint, Salesforce, Monday.com, Facebook Power Editor, Google Analytics Education (College): 2003 to 2005 Diploma in Computer Studies - System Technology Institute (STI) Pasay Work Experience: ➢ Freelance MS Excel Specialist (July 2023 – Present) • Work from end-to-end tasks, from Data Entry to High-End Reporting for the Company. ➢ Coherent (October 2020 – July 2023) Makati City, Philippines ✓ Business Analyst: • Working on Excel Files that will be use as Engine for Website. • Make sure all tickets requested by the client will be accomplished in the Excel file. • Work with the Business Analyst and other Representatives of the Client for the requirements. ➢ Freelance MS Excel Specialist (February 2017 – October 2020) • Work from end-to-end tasks, from Data Entry to High-End Reporting for the Company. ➢ VXI Global Holdings (March 2015 – February 2017) SM CyberTwoBldg (Sen. Gil Puyat Ave), 1200 Makati City, Makati City, Philippines ✓ MIS & Business Analyst Lead: American Express • Working with the MIS & Workforce. • Maintaining High Level Reports like daily and monthly Site Performance for Clients and Executives. • Providing Weekly Presentation deck for operations for Site and Group level. • Prepare/Monitor Invoices such as Billings and Bonuses. ✓ Reports Specialist: Google Adwords ANZ / American Express • Maintaining all Department Reports such as Attendance, Team & Individual Performance, etc. (Daily, Weekly, Monthly and Quarterly). • Tracking all Sales in Salesforce if all are captured by the Google Business Object. (Google) • Providing Weekly Business Review Deck into a PowerPoint. • Providing Billing Reports (Estimated and Final) – which I work with Finance team on how much the Billing for the current Month and ensure those will be properly delivered. ➢ Straight Arrow Corporation (December 2013 –April 2015) Unit 302C Silver City, Frontera Verde Drive, Pasig City ✓ Social Media Analyst (TBG Digital / Sprinklr): • Managing & optimizing all handled Facebook & Twitter Ads to meet or ahead from the target KPIs (CPC and CPO). • Preparing all Social Media reports for the Clients - must be able to present clearly in each report which Campaigns are profiting (breakdown by Date, Week, Month, Gender, Age and Creative/Image). ➢ TREC Pacific Corporation (October 2012 - December 2013) 6th Floor Raffles Bldg. F.Ortigas, Jr. Ave., Ortigas Center, Pasig City, ✓ Data Analyst: Cisco / Linksys Belkin • Providing all Reports, Metrics and Data for the clients to see if all TACs (Call Centers) and any Support Groups were meeting the SLAs. • Maintaining the SQL Database - Collate and analyze all Call Centers/Vendors’ data before uploading it in the database. ➢ American Data Exchange (December 2005 - October 2012) Alabang-Zapote Road, Las Piñas City ✓ 3rd Position: Project Admin/Data Analyst (July 2011 - October 2012) • Directly reports and works to the Clients to maintain the proper processing procedure of all orders. • Monitor & consolidate all Tickets/Issues from SharePoint/Mail submitted by the production representative if there are any issue how to obtain property information, then discuss it to the Clients how to resolve it. • Create a Weekly and Monthly Quality & Turn Around Time Report for the Clients. ✓ 2nd Position: Department Administrative Assistant (March 2009 - July 2011) • • • • • • • ✓ Provide daily, weekly, monthly & yearly report of Manpower’s Attendance, Productivity & Quality. Provide daily, weekly, monthly & yearly Order Summary Report (Received, Completed & Rejected) Prepare monthly Billing Reports. Keep administrative records such as Leave, OT Forms, Manual Entry Forms & other pertinent records. Records monthly inventory of supplies requested & availability. Record all the numbers of available resources such as machines, equipment, workplace & manpower. Perform other task that may be assigned by the Managers and Supervisors from time to time. 1st Position: Data Control Clerk (December 2005 - March 2009) • Log & monitor all the daily Orders in Spreadsheet & monitor it till completion. • Collect the completed orders from production area. Scan the Searched information from each order like Property Tax, Assessment, General Index, Property Index & Documents (Deeds & Mortgages) related to the Properties. Then saved the image into database.