Paulo Fajardo

Paulo Fajardo

$15/hr
Excel expert - Web scraping, Analytics, & Dashboards
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
41 years old
Location:
Las Pinas, Metro Manila, Philippines
Experience:
13 years
Paulo Angelo H. Fajardo 125-B Daisy Rd. Pilar Village, Las Pinas Cell phone no.: - Email Address / Skype / LinkedIn: ph.linkedin.com/in/paw2fajardo Background: Has been in the industry for more than 12 years. With strong background in providing business insights through data analysis. Currently performing in a supervisory role which oversee business operations for a data analytic company. Skills: Advanced knowledge in Microsoft Excel (VBA & Macros) Advanced knowledge in Microsoft Word Advanced knowledge in Microsoft Access Knowledgeable in NoSQL (MongoDB) Understand the concept of RDMS Confluence Jira Power BI Six Sigma Yellow Belt Trained SQL Coding Qlikview Programming Strong background with ETL Knowledgeable with the following Business Intelligence Tools: SSIS SSAS SSRS Microsoft Visual Studio Web Intelligence Knowledgeable in Real Time Analysis Knowledgeable in CCPulse Flowchart Knowledgeable in IEX Able to work efficiently under pressure Understand the concept of database system Able to work with less supervision Work Experience: June 2016 – Present Bolton International 12/F Trade and Financial Building 32nd cor 7th BGC, Taguig City, Philippines Data Operations Lead Manage a team of analysts which handle operation data Build reports for the management team Handle the day-to-day pipeline of the operations Use SQL via AWS console & PostgreSQL Updates process documentation December 2015 – April 2016 TCG Consulting 18/F Robinsons Summit Centre 6783 Ayala Avenue Makati City, Philippines Business Analyst Part of the global business solutions centre assisting US counterparts in consulting projects. Creates AdHoc reports for the team. Extract and analyse data given and create reports with the given data. August 2014 –December 2015 Altisource Business Solutions, Inc. Two E-Comm Center, Harbor Drive Mall of Asia Complex Lead Business Analyst Handle a team of analysts which are all assigned to different BU’s Ensure accuracy and timeliness of operational reports. Create tools for operations Join cross department meetings Work with other departments to identify process gap February 2014 – July 2014 UMS Group Phil INC Alpha Bldg. UP Technohub, Commonwealth, Quezon City Benchmarking and Performance Analyst December 2013 – February 2014 SinglePoint Call Center Training and Quality Paseo de Roxas, Makati City Trainer August 2013 – October 2013 Verizon Philippines Vendor Management Buendia, Makati City Senior Vendor Analyst Duties & Responsibilities: Create action plans to ensure that the vendors are on the right direction Gives feedback to the Vendor Management Act as a bridge between the Vendor and the Client side (Verizon) Ensure that the Vendor is compliant with the standards set by Verizon Ensure that the Vendor methodology is in line with Verizon July 2007 – May 2013 Firstsource Solutions LTD Verizon Business Plaza D Northgate Cyberzone Alabang Muntinlupa WFM Team Lead (Calls) Duties & Responsibilities: Oversees the Real Time Adherence Team's creation of reports to meet requirement of Operations/ Management / other departments Responsible for preparing and maintaining statistical reports used by the management in the Operations Supervises daily activities and deliverables of RTAs Communicate effectively with team regarding business and operation demands Senior MIS Executive (Backoffice Account) Duties & Responsibilities: Manage the overall performance of the team. Ensuring that all reports are delivered in a timely manner. Ensures that reports published are 100% accurate. Drive the team to perform at their best. Coaching sessions with the team members. Ensure that the team adhere to all company policies. Prepare reports and maintain records of work accomplishments and administrative information, as required, and coordinate the preparation, presentation, and communication of work-related information to the Manager. Report to the manager periodically on team and individual work accomplishments, problems, progress in mastering tasks and work processes, and individual and team training needs. Intercede on behalf of the team to inform the manager of performance management issues/problems and to recommend/request related actions, such as assignments, reassignments, tour of duty changes, peer reviews, and performance appraisals. Coach, facilitate, solve work problems, and participate in the work of the team MIS Executive Duties & Responsibilities: Analyze data and generate those data into comprehensive reports. Create tools for operations and support to make work more efficient. Create tables and graphs for presentations. Ensures data are synchronized with Clients Maintains database for Operations. Maintains headcount files Create tools for Operations and Support (VBA Excel Programming) April 2006 – May 2007 Advance Contact Solutions (Verizon Online-DSL) Cor Gil Puyat and Tordesillas ave., Makati City Technical Support Representative (inbound) Duties & Responsibilities: Receive inbound calls from clients Assist clients on installation of their DSL services Perform troubleshooting with clients who’s having difficulties on using their DSL service Provides customers world class service and make sure that each customer that calls in are satisfied with the service that was provided to them. Provides information to client about the settings of email clients, status of the DSL service that they ordered and best solutions about the trouble that they are have with their DSL service. Served as an Escalation agent and do floor support. February 2005 - April 2006 First Orient Securities Inc. 12/F Tower 1 Ayala Triangle, Makati City Assistant IT Duties & Responsibilities: Maintain in-house system. Troubleshoot local network Create server backups Provide tools to help employees to do work more efficient. Educational Background: College AMA University 2000 – 2004 Las Pinas City B.S. Computer Engineering
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.