JUAN GONZALEZ
Miami FL ***** *************@*******.*** Cell: 305-***-****
Summary
Applicant is an accomplished and versatile MS Excel Power-User and Analyst who in recent years has applied his skills successfully in varied industries as a contractor, specialist, or consultant. His blend of data manipulation skills, technical expertise plus bilingual skills has opened recent opportunities in duties such as Data Risk Analyst, Data Entry & Reporting, Ad-Hoc Analyst, Data QA, Excel Specialist, Data Auditor, Application Tester, Database QA, Inventory Coordinator, and Text & Data Editor.
Job Skills / Certifications
MS Excel Spreadsheet Customization, Pivot Tables/Charts, 3-D Summary, Data Validation, Data Consolidation, Advanced Filters, VLOOKUP’s, Financial Formulas and Functions, Amortization Tables, What-if analysis, Macros, Pivot Slicer (dashboards), File and Data Cleanup, Data Linking. Excel for overall business needs and analysis
Highly proficient with EXCEL, WORD, ACCESS, PowerPoint, Outlook, ADOBE, QuickBooks and other office productivity apps
Thorough understanding of relational database design, table relationships, queries, object development and SQL basic
Skillful and Accurate Typist, Data Entry, Document Editor, Spreadsheet and Database Creator/Editor, Data Manipulator
Bilingual - English/Spanish
CompTIA A+ and Network+ Certifications (ID: COMP001005490909) Microsoft Office Specialist (MOS)
Experienced in Helpdesk duties, IT research as well as managing IT Support Tickets
Tech savvy, Open-minded, analytical driven, resourceful, responsive, adaptable and winner persona in all undertakings
Work profile (abridged)
Contractor / Consultant / Temp
VARIED EMPLOYERS, South FL Jul 2013 - Mar 2020
2020 NEXTWAVE FUNDING SILVA GROUP
2019 BULLTICK (Wealth Management/Brokerage) CARNIVAL CORPORATION USI INSURANCE SERVICES
2018 HYPERTEXT BOOK & JOURNAL SERVICES
2017 GOBE.com (Div. of Royal Caribbean Cruises) BANKUNITED HYPERTEXT BOOK & JOURNAL SERVICES
2016 BBC WORLDWIDE LATAM GOBE.com (Div. of Royal Caribbean Cruises)
2015 NBC UNIVERSAL OPKO LAB CONCACAF AMATHEON PHARMACEUTICALS
2014 LEAGUE AGAINST CANCER MIAMI-DADE COUNTY PUBLIC SCHOOLS
2013 UNIVISION COMMUNICATIONS LEAGUE AGAINST CANCER
Data Center Technician / Inventory Analyst
GLOBALWEB DATA SERVICES, Miami FL Mar 2012 - Jul 2013
Inclusive duties comprised of:
Network server or device installation, cabling, and testing
Onsite security, server and network monitoring, maintenance and troubleshooting (quick fixes)
24/7 on call customer support for immediate resolution of device or network failure or performance issues
Performed basic network server configuration, device and cabling upgrades, memory updates or swaps when needed
Supported Miami Operations Manager and other technical staff (Brazil) with special requests, projects, reports, visuals and
real-time updates
Created, modified, clarified or updated database lists and device profiles
Provided business and technical research for all Globalweb network managed devices
oproduction servers, data storage devices (SAS, DAS, NAS, iSCSI, tape library, external drives) - security appliances and supporting equipment
Database Specialist / Business Support
TRAMMEL CROW COMPANY, Miami FL Jan 2006 - Oct 2006
Executed business research and data mining of hundreds of South Florida commercial structures and construction projects.
Database and Data research included strip malls, parking Lots, theaters, parks and lakes, office condominiums, abandoned bridges, warehouses and multi-level garages.
Queried for any substantive issues affecting or enhancing a target property's overall potential, profitability and current status.
Data mining and research were performed in large part with the aid of real estate web searches, state, county or municipal records, subscription web portals, real estate journals, state incorporation or LLC records, and other creative avenues.
All meaningful data inputted to a proprietary database for analysis and query by company VP and Principals.
This task also required a modicum of tactful direct contact to initiate communication or acquire additional facts.
Computer Technician / Database / IT Procurement-Help Desk
TEKSYSTEMS, INC. South Florida & International Projects 2002 - 2005
Highly recruited during this 4-year span to work medium to large-scale IT implementation projects (rollouts) as a hands-on Device Troubleshooter or Database/Data Entry Specialist. All technology jobs performed in South Florida region or internationally (MEXICO, ECUADOR, PERU, BOLIVIA, ARGENTINA) differed in scope, complexity and duration.
2005 CORDIS CORPORATION (Miami/Mexico) RYDER SYSTEMS
2004 CARNIVAL CORP HEWLETT PACKARD NORTHWESTERN MUTUAL BANKUNITED
2003 BAPTIST HEALTH
2002 SCHLUMBERGER (South & Central America) CARNIVAL CORP HEWLETT PACKARD NORTHWESTERN MUTUAL
CSC/DYNCORP BAPTIST HEALTH
Education
COMPUTER AND NETWORK TECHNOLOGY The Academy Computer Training Center Miami FL
PERFORMANCE ARTS MAJOR WITH LIBERAL ARTS Peabody Institute of the JHU Baltimore MD
CERTIFICATE OF COMPLETION IN BROKERAGE OPERATIONS AND BUSINESS MATH Newark Skills Center Newark NJ
HIGH SCHOOL DIPLOMA Arts High School Newark NJ
Professional development / on-line training ( completed)
CERTIFICATE OF AWARD FOR ADVANCED MS WORD FOR WINDOWS AND TYPING/KEYBOARDING Dade County Public Schools Adult Education
CERTIFICATE OF COMPLETION FOR MS WINDOWS ORIENTATION AND MS WORD LEVEL I Creative Staffing Learning Centers
CERTIFICATE OF ACCOMPLISHMENT H&R Block Basic Income Tax Preparation
THE ULTIMATE MICROSOFT EXCEL 2010/2013 TRAINING BUNDLE
MS EXCEL - JUMPSTART TO ANALYST
RELATIONAL DATABASE DESIGN
MICROSOFT SQL SERVER 2012 CERTIFICATION TRAINING EXAM 70-461
SQL SERVER FOR BEGINNERS
POWERPOINT 2013 MICROSOFT OFFICE SPECIALIST CERTIFICATION
PIVOTPAL EXCELCAMPUS.COM
EXCEL PRO TIPS: 75+ TIPS TO GO FROM EXCEL BEGINNER TO PRO
MICROSOFT EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONS (in progress)
Awards
EMPLOYEE OF THE MONTH – Staffing Agency
CERTIFICATE OF RECOGNITION – Healthcare/Insurance