Juan Manuel Vasquez Lopez

JUAN VÁSQUEZ LÓPEZ 113 365 Bridge Lake DR, Winnipeg MB R3Y 1Z4 ▪- ▪- FINANCIAL/ADMINISTRATIVE MOST RELEVANT ACCOMPLISHMENTS: EXPERIENCE: Results-producing professional with more than Ten-year experience of A/R accounting and day to day office duties. Proven record of accomplishments in the finance and accounting areas. Efficient skills in developing accounting and financial reports. Experience as a data analyst and project management targeted to support the business goals and objectives. Exceptional enthusiasm in the implementation of new processes and procedures that leads to efficient decision making. - Improve reporting efficiency on the A/R process. In my previous job, I was able to reduce a process time by more than 50%. In my actual position, I am trying to implement IT sources into the AR process and reporting to reduce the processing time considerably. - As a Data Analyst I was able to create, maintain and improve reports for different departments with high accuracy and excellent timing, for upper management to make decisions on Corporate investments. - Reduced debt from 5% to 1% in one year due to the effectiveness applied on the collection method at the A/R Dpt. In Diamond Resorts International from a $18 million portfolio commercial receivables accounts. - Achieved a 90% completion level in our principal goal PTO (Permit to Operate) in the Solar Systems at SolarCity. Core Competencies |Customer Service |Team Leader |Management | A/R Accounting| Data Analyst| Hyperion | Macros Programing | Microsoft Office | Problem Solving| Blackline |GAAP| Oracle |Minitab | Atlas| Access| Acrobat 9 Adobe |SQL Server 2008| Oracle Hyperion |Clarity |Harland | SQL Studio |A/R Collections | PROFESSIONAL EXPERIENCE Dufresne, Winnipeg, MB, Canada Accounts Receivables Analyst 10/2021 – Present ● As an Accounts Receivable Analyst, I was able to provide accurate systems reports and the update and maintenance of the clients data and balances. ● I was able to Maintain all accounts receivable records, and Prepare and analyze statements and aging reports. Identify and research delinquent accounts. ● Prepare and send out invoices to customers with critical balances and adjust the accounts, when relevant. ● Research account discrepancies and Prepare all related entries to be posted to the accounts, as necessary. ● Audited and resolved payment documentation discrepancies, analyzing and researching records to recover shortages. 1 JUAN VÁSQUEZ LÓPEZ 113 365 Bridge Lake DR, Winnipeg MB R3Y 1Z4 ▪- ▪- ● Provided prompt and professional communication to both internal and external customers regarding billing inquiries, past due account status, disputes, complaints, inquiries and other questions. Tank Traders, La Salle, MB, Canada Accounts Receivables Specialist 12/2020 – 10/2021 ● As an Accounts Receivable Specialist I was able to monitor the complete organization’s collection processes. ● Audited and resolved payment documentation discrepancies, analyzing and researching records to recover shortages. ● Prepared accurate customer invoices, credits and rebills while making sure the billing system is up-to-date. ● Assisted in the month-end closing process by posting revenue accruals and collect data to prepare monthly reports. ● Reviewed accounts receivable aging report to ensure compliance as well as research and resolve any payment discrepancies. ● Follow-up with customers seeking payment status on outstanding invoices and work with customers to explain balance due. ● Applied customer payments into the system on a daily basis. Deloitte, Winnipeg, MB, Canada Workflow Coordinator 03/2019 - 10/2019 ● My role as Workflow Coordinator possesses good administrative knowledge and a strong analytical skill set that is applied in the coordination and delivery of administrative support. ● Prioritize incoming service requests, assign work to assistants of managers and ensure that processes are followed in compliance with firm standards. TESLA ENERGY (SOLAR CITY), Las Vegas, NV PROJECT MANAGEMENT SPECIALIST ON SOLAR SYSTEMS 10/2015 -11/2016 ● Achieved a 90% completion level in our principal goal PTO (Permit to Operate) which allows the solar system to begin operating and the company to start creating revenue. ● Contact clients to collect and create data for new projects to establish service level objectives. ● Address and manage a high volume of concerns and/or source answers regarding system performance, maintenance. ● Work with clients to review site plans and changes to the contract or design from the original sale. ● Encourage clients and resolve obstacles to ensure return of paperwork in a timely manner. ● Identify common issues and develop suitable solutions to handle inquiries in a timely manner. ● Use different tools and techniques to help moving projects timely. Six Sigma, Pareto analysis and fishbone analysis. DIAMOND RESORTS INTERNATIONAL, Las Vegas, NV DATA ANALYST I-RESORT OPERATIONS ACCOUNTING,A/R, STAFF ACCOUNTANT 10/2005 - 06/2015 ● I was responsible for the creation of upper-level management reports for the accounting and finance departments. 2 JUAN VÁSQUEZ LÓPEZ 113 365 Bridge Lake DR, Winnipeg MB R3Y 1Z4 ▪- ▪- ● ● ● ● ● ● ● ● ● ● User administrator for Harland and Hyperion software, to include system management and analysis. Monitored user activities on different loan software, as well as system auditing and security compliance. Generate reports using different programs including Hyperion (desktop and online), SQL, Excel, etc. Performed system testing and created related documentation software updates and portfolio conversions audit data entry performed by other departments to ensure accuracy and compliance with established guidelines. Responsible for A/R accounting for several resorts, managing an $18 million portfolio commercial receivables accounts. Reduced debt from 5% to 1% in one year due to the effectiveness applied on the collection. Reconciled assigned balance sheet accounts in Blackline. Run reports, prepare journal entries (daily and month-end procedures) to support the accounting department. Effectively coordinated and communicated with internal and external operations or clients to research and resolve discrepancies, out-of-balances, disputes, chargebacks, etc. Prepared monthly financial fluctuation analysis. Aviacsa Airlines, Los Angeles, CA, USA Northern California Sales Manager 02/2004 - 02/2005 ● Contributed to the marketing & sales growth of Aviacsa Airlines as well as increased their client portfolio by 20% in one year. ● Implemented new sales techniques for the CA/NV region. EDUCATION & RECOGNITIONS College of Southern Nevada-Las Vegas, NV Associate of Applied Science Degree. Accounting, 2014 Associate of Applied Science Degree. Finance, 2009 - 2014 ➢ High Honor Graduation Roll, College of Southern Nevada- Las Vegas, NV Humboldt State University- Arcata, California Master of Business Administration-Coursework (MBA), Marketing Emphasis,- Universidad Autonoma De Occidente, Cali, Colombia Bachelor of Science - Industrial Engineering, 1998 People & Language Skills: Strong verbal and written communication. Proven ability to develop rapport and maintain strong working relationships with co-workers and external clients alike. Fluent in English, Spanish, and Basic Portuguese. Key Strengths & Abilities: University and college graduate with over 20 years’ experience in customer service, accounting, collections and technical analysis. Highly organized with the ability to multitask and prioritize various projects. Ability to work under tight deadlines. Competent social organizational and planning skills. 3