Rasell Redolosa

 Blue IT Group Project Data Analyst (Tableau Reports Developer) Project Based Country : Canada June 2019 – June 2020 Develops Tableau Report for all IT based projects SAP programs, issues and defects. Interprets data, analyzing result using statistical techniques. Creates data visualization using Tableau application. Collects Daily Data from different smartsheet logs. Acquiring data from primary or secondary data sources and maintaining databases. Responsible in communicating with PMO regarding the daily logs in smartsheet. Prepares Daily, Monthly Report for CRH (City of Richill), CoP (City of Peterborough) Issue Log Reports. Southern Cross Sailing Adventures Bookkeeping (Part Time/On call) 3-4hrs Week Country : Australia March 2019 – March 2020 Helps client to maintain the daily transaction. Upload invoices in Xero and MYOB Essentials. Monthly reconciliation in the Bank Statement and process all missing transaction in Xero in MYOB Essentials. Create AR Invoices and send out to client Monitor and Organize email from the client Bespoke Advisory Bookkeeping Support Country : Australia March 2018 – December 2019 Individual contributor that provides administrative and bookkeeping task from different clients in Australia. Handles Account Receivables and Accounts Payables. Day to day Bookkeeping task. Bank Reconciliations. Process Weekly/Monthly Payroll. Prepare and send out invoices to the clients directly, keeping them informed regarding the details of each incoming payment and give you customary reporting so you can see where things are constantly at. Assist with reminder emails and follow up calls to the people that owe you money to ensure get paid on time. Take in more about our Debtor Management services. REMOTESTAFF (Think Innovations Pty Ltd Australia) Data Entry Specialist (Part Time) / 4hrs/day Client : Business Accountancy www.businessaccountacy.com.au August 2017 – October 2019 Develops the system to account for financial transactions by establishing a chart of accounts; defining bookkeeping policies and procedures. Maintains subsidiary accounts by verifying, allocating, and posting transactions using MAS and Cashbook application. Make sure the accuracy of data by checking the Trial Balance and General Ledger. Verify the closing and opening balance from the bank statement to make sure it matches the figures in Cashbook and MAS file. Maintains historical records by filing documents. Prepares draft report for Dividend Summary, Member Statement, and Income Distribution and submit to Supervisor. Prepares Closing Stocks Report by compiling the data from portfolio summary, re-evaluate stock market from last year, filing reports; advising management on needed actions. DIT Holdings (Lucky Universe) Data Analyst / Tableau Reports Homebased Freelancer Country : Barcelona, Spain June 2017 – January 2019 Setup data sheets and do analysis and reporting on several datasets. Interprets data, analyzing result using statistical techniques. Creates data visualization using Tableau application. Collects Daily Data from different affiliated partners and compile in google sheet. Acquiring data from primary or secondary data sources and maintaining databases. Reports and analysis on daily/weekly/monthly basis. Assist in analytical projects aiming to spot usage and traffic trend across digital platforms. Adhoc Task: Responsible for product management and structure by providing quality data for the new products. Contacts Affiliate Managers for the Metadata, creative reference for the product content. Manage campaigns and links in Clickmeter. Upload metadata in backend software. Upwork Global Inc. Position/Client Duties and Responsibilities Data Mining Specialist (One-time Project) Country : USA January 2019 – January 2019 Go to a website directory and collect contact information from the website consolidate into a spreadsheet. Ensure to collect quality data. Tableau Reports Developer (One-time Project) Client : Tetrus Tech Country : USA November 2018 – January 2019 An Individual contributor creates Tableau dashboard report based on the client requirements. Perform complete quality assurance of the data, from source system to Tableau and engaging users as necessary. Assist in evaluating and prioritizing the delivery of new functionality and change requests for existing dashboards and reports. Facilitate the maintenance, optimization and consolidation of reports and dashboards Serve as lead developer in building large-scale public facing, high volume-based dashboards. Ensure that the Reporting & Analytics team maintains a keen focus towards the needs of our customers and goes above and beyond to deliver superior dashboards and reports by project deadlines. Tableau Reports Developer (Project Based) Client : MarksLab Country : USA May 2018 – November 2018 An Individual contributor creates Tableau dashboard report based on the client requirements. Perform complete quality assurance of the data, from source system to Tableau and engaging users as necessary. Assist in evaluating and prioritizing the delivery of new functionality and change requests for existing dashboards and reports. Facilitate the maintenance, optimization and consolidation of reports and dashboards Serve as lead developer in building large-scale public facing, high volume-based dashboards. Ensure that the Reporting & Analytics team maintains a keen focus towards the needs of our customers and goes above and beyond to deliver superior dashboards and reports by project deadlines. Researcher (Project Based) Country : USA July 2018 – September 2018 Scan and evaluate various data of product in Scanpower. Sort all products based on ranking and category and to report to the management. Create/Update Tableau report to all evaluated products and report to the Management Data Mining Specialist (Project Based) Client : Automated Tracker Country : USA May 2018 – August 2018 Go to a website directory and collect contact information from the website consolidate into a spreadsheet. Ensure to collect quality data. Store and manage all data in CRM. Manage invoices, purchase order in CRM. Other task assigned by Client. BSB OUTSOURCING LTD. CORP 2nd Flr Unit 2F Business Center 11, Philexcel Business Park, Clark Free Port Zone, Mabalacat, Pampanga , Philippines 2023, Reports Developer IT Department Mar 2017 – September 2017 Expert in evaluating, building and designing Tableau reports based on customers' needs and requirements. Responsible for checking the obtaining request queues from the ticketing tool Review data for processing in the timesheets Review report request and check any discrepancies in figures. Communicate with customer and check POS tools if verification is required. Setting up of reports into the server. Support the development of the new service metrics and reporting for using the measurement that drive organizational performance and fall within a standard framework Collaborate with the co-developers for reports visualization enhancement. Conduct quality assurance measurement on own teammates' generated reports. Other duties and task as assigned by the immediate superior and/or the Operations Management. Data Management and Reconciliation Staff Dec 2015 – Mar 2017 Responsible for Weekly Remittances. Download, format, and upload all remittance in ClickPOS system. Reconcile weekly remittances sent by Store Client. Responsible for sending Weekly Outstanding Report. Responsible for sending Monthly Outstanding Report. Responsible for sending Records not in ClickPOS. Responsible for creating Reporting Template. Responsible for creating Daily and Weekly Sales Report. Responsible for updating Daily Survey for NPS Tracker. Other task assigned by POCs BEEPO INC. 2nd floor and Unit 1F Business Center 9, Philexcel Business Park, Clark Free Port Zone, Mabalacat, Pampanga , Philippines 2023, Data Entry / Reconciliation Staff Outsource IT June 2015 – Nov 2015 Responsible for Weekly Remittances. Download, format, and upload all remittance in ClickPOS system. Reconcile weekly remittances sent by Store Client. Responsible for sending Weekly Outstanding Report. Responsible for sending Monthly Outstanding Report. Responsible for sending Records not in ClickPOS. Responsible for creating Reporting Template. Responsible for creating Daily and Weekly Sales Report. Responsible for updating Daily Survey for NPS Tracker. Other task assigned by POCs. ISLAND ENTERPRISES PLAQUES AND MODELS INC. #1 DeGuzman Bldg Madeira Str. Friendship Angeles – 2009 Pampanga, Philippines Production Assistant Production October 2014 – June 2015 Assist Production Manager in planning and performing production related activities. Prioritize, plan, schedule and manage production activities to meet manufacturing objectives in timely and cost-effective manner. Identify production issues, analyze root causes and derive resolutions. Responsible for updating Daily Order Status Report and sending to management. Responsible for updating Daily Order Status Report and for monthly customers. Responsible for creating proposed shipment for the whole week. Encodes all incoming and outgoing orders in FileMaker. Develop production plan and schedule to ensure continuous operations. Perform inventory management and report warehouse status to Manager. Develop logistic strategy to avoid downtime and delays. Develop process improvements to improve workflow efficiency. Ensure that manufactured product meets customer specifications. Communicate production updates and errors to Manager on regular basis. Communicate complex issues to Manager for immediate resolution. Admin Supervisor Admin Office October 2011 – 2014 Perform general clerical duties to include encoding daily transaction, HR related works, answering e-mails and telephones and transfer to appropriate staff member. Prepares Vouchers and Check Payments. Prepares Fund Requests for the next day’s payment and projected expenses for the week. File and retrieve organizational documents, records, and reports. Create and modify documents such as invoices, reports, memos, letters, and financial statements using word processing, spreadsheet, database and/or other presentation software such as Microsoft Office. Sends Attendance report both Manual and Biometric copies to Managements. Ensure management is informed of any financial or accounting problems. Prepares Monthly Book of Accounts such as Sales Journal, Sub-purchase, and Cash Disbursement. Prepares Sales invoices and receipts for all sold items. Prepares Monthly reports to include VAT report, MAP, Monthly Remittance and Monthly Factory Expense Report. Calculate employee time and prepare weekly employee payroll. Create report for Management showing employee’s tardiness and absences and send to management every week. Maintain and file all forms and documents for employee payrolls, benefits, SSS, PhilHealth, Pag-ibig for the current year. Uploads monthly SSS Payment (Contribution and Loan) thru online. Prepares Quit Claim Letter for resigned employees; back pay and Tax Refund. Calculate 13th Month and Sick Leave for all Employees. Prepares New Employment contract for the newly hired. Maintain confidentiality in all aspects of client, staff and agency information. Assist with overall maintenance of the organization and its offices. Perform general clerical duties to include encoding daily transaction, HR related works, answering e-mails and telephones and transfer to appropriate staff member. ADVANPOINT INC. 7B Philexcel Business Park, Clark Freeport Zone, Pampanga, Philippines Data Researcher May 2011 – August 2011 Responsible for providing quality data and information(s) derived from publication, research, and previously held and organized events history. Responsible in the prompt research, retrievals, analysis, and publication of sales leads. Maintains documents and data an official and designated template files categorized per event for proper recording and monitoring. Copy and paste to official templates for submission and review by the Team lead on regular basis before end of shift. Ensure accuracy of all details saved in the designated events file folder for future sales references and research viewing. Performs email blasting regularly to ensure that designated prospective clients/participants receive the updates and details of the forthcoming events. Ensures that effective and contains links with external organizations is initiated and maintained using effective keywords assigned by the Team lead.   IQOR PHIL. INC., Bldg. 36 & 37, Berthaphil 2, Jose Abad Santos Ave., Clark Freeport Zone, Pampanga, Philippines MIS / Report Analyst GE Money Bank March 2008 - December 2010 Responsible for Credit balance and Contest file monthly reports. Encodes incomplete data gathered. Consolidates all daily accounts collected every team into one file. Audits delinquent accounts (30 – 180 days Delinquent accounts) Check NSF payments using Speed Pay. Manually verifies agents’ transactions based on credit policy. Report and submit the Credit Balances file for the month to AVPs. Checks all agent’s disputes and make resolutions.   FAR EAST COLLEGE of IT (COMPWIZARD) Magalang Pampanga, Philippines Computer Teacher Dau Central Elementary School November 2008 – March 2010 Assigned in Public School as a Computer Teacher. Teach Basic Computer Literacy. Performs daily lectures and hands-on activities. Prepares manual books, written examinations, and activities for each level. Prepares lesson plans every week. Sending reports to adviser every period. Handled Pre-elementary and Grade School (SPED). BS in Electronics and Communication Engineering Holy Angel University 2010 – 2011 (Undergraduate) Angeles City, Pampanga, Philippines - Associate in Computer Technology Asian Institute of Computer Studies 2005 – 2007 Dau Mabalacat, Pampanga, Philippines - - ON-JOB-TRAINING Comclark Network and Technology Corp. Finance Department Manuel Roxas h-way, CSEZ, Clarkfield, Pampanga, Philppines -,-,- December 2006 – March 2007 (300 hrs.) ACHIEVEMENTS: Secondary: Academic Excellence - Academic Excellence - C.A.T. Officer Cdtte. 1st Lt. - College: Deans Lister 2nd year 1st - 2nd Semester -) WEBINARS COURSES: DIPLOMA IN MICROSOFT EXCEL SHAW ACADEMY Course completed: August 25, 2016 DIPLOMA IN WEB DEVELOPER SHAW ACADEMY Course completed: July 2017 GOOGLE ANALYTICS FOR BEGINNERS Issued : August 2018 TRAININGS AND CERTIFICATION: XERO CERTIFIED Issued : January 2019 HUBDOC CERTIFIED ADVANCED PARTNERS Issued: January2019 HUBDOC CERTIFIED PARTNER Issued: January2019 RECEIPT BANK EXTRACT TRAINING COURSES Issued : August 2019 PERSONAL INFORMATION Date of Birth:September 05, 1987 Place of Birth:Angeles City, Pampanga, Philippines Language Spoken:English, Tagalog and Kapampangan **Upon request** I hereby certify that the above information is true and correct to the best of my knowledge and belief