Summary
Overview
Work History
Education
Skills
LANGUAGES
Timeline
AdministrativeAssistant
Lourdes Hernandez

Lourdes Hernandez

Coral Gables,USA

Summary

Experienced in high-volume office environments, I excel at providing clerical and operational support with minimal oversight. Known for my professionalism, adaptability, and strong work ethic, I handle diverse tasks efficiently and navigate complex situations with sound judgment. Quick to learn and eager to take on new challenges, I deliver results independently or as part of a team. I possess a strong background in technology, bilingual (English/Spanish), holding an Associate in Arts degree in Computer Science and an Associate in Science degree in Business Data Processing.

Overview

17
17
years of professional experience

Work History

Data Systems Analyst - Information Technology

Gulliver Schools
03.2018 - 07.2018
  • Assisted principals, teachers and staff with any reporting requirements
  • Met with users to translate their report requirements into technological specifications to develop and create their reports
  • Extracted the data from the server/s and formatted the reports as per the users' specifications to assist them in making senior management decisions

Business Intelligence Developer

Our Kids of Miami-Dade and Monroe, Inc.
09.2017 - 11.2017
  • Worked with 'Safehaven', the company's Microsoft Dynamics ERP and CRM software application system
  • Generated reports, performed inquiries, updated dashboards and researched information
  • Downloaded files from the state's FSFN system using Download Manager
  • Worked closely with internal departments to examine and analyze data flows, reporting requirements and business models
  • Identified and resolved problems in a timely manner and gathered and analyzed information in a skillful manner to display KPI information for management decision making
  • Updated and refreshed company's financial reports and departmental dashboards
  • Successfully worked on multiple projects simultaneously and was able to interface with cross-functional teams in a professional and personable manner

Data Systems Analyst - Information Technology

Gulliver Schools
01.2017 - 08.2017
  • Served as liaison between senior management, teachers, parents and students and IT to translate their report requests and generate a final report using SQL and Crystal Reports
  • Worked with the frevvo software to quickly design various online forms and approval workflows
  • Create and present statistical reports to senior management to assist in strategic planning and decision making
  • Research historical salary ranges by department/position and project position/department increases and/or decreases in expenditures and their effects on the fiscal year proposed budget
  • Worked with senior management developing various financial reports for budget, payroll and compensation

Senior Information Analyst

City Of Miami Beach
06.2015 - 10.2016
  • Extracted Human Resources and Payroll data from EDEN by Tyler Software and/or ENERGOV using SQL Server Management Studio
  • Ran Ad Hoc reports and extracted data to display in different visual formats for more accurate and decision making of the problem in question
  • Served as liaison between senior management and individual department directors in the implementation and execution of various simultaneous projects including the police and fire departments
  • Completed several budget, compensation and payroll reports for the Miami Beach Police Department and the Miami Beach Fire Department requests
  • Formatted and displayed report output using different visualizations for clearer and more accurate ad hoc decision making by management

QNXT Analyst/Report Developer

Independent Living Systems
02.2014 - 05.2015
  • Simultaneously supports/updates various projects to ensure deadlines are constantly met
  • Attends meetings and seminars as requested
  • Plans, budgets, and documents all aspects of the various projects assigned
  • Create reports that summarize my findings and recommendations, to senior management
  • Maintains user confidence and protects operations by keeping information confidential
  • Prepares technical reports by collecting, analyzing, and summarizing information and trends of data
  • Worked with senior management to develop various financial reports for budget, payroll and compensation
  • Worked as liaison between IT and users/directors to translate/interpret their report requests into projects/reports into Microsoft Structured Query Language (SQL) language and format them to look as they requested using Crystal Reports
  • Maintain clear and detailed documentation of the current reporting architecture, reports, report maintenance, and query repository
  • Create and run ad hoc queries and reports to support information requests of the business
  • Reports created from ECARE and QNXT Systems

Report Writer Specialist

Florida Healthcare Plus
01.2012 - 01.2014
  • Developed and maintained a portfolio of reports from multiple enterprise applications including QNXT
  • Worked with representatives from the lines of business to develop report specifications, implement those requests in SSRS using SQL server views, stored procedures and functions
  • Worked with managers to understand and resolve data issues and provide technical knowledge data and documentation for development of 'Smart Decision-Making'
  • Worked as liaison between IT and users/directors to translate their report requests and data issues to technical specifications and report creation
  • Wrote various queries using SQL to extract large amounts of data from the QNXT database and created/formatted requested reports using SSRS, Crystal Reports and/or Excel
  • Worked with senior management developing various financial reports for budget, payroll and compensation
  • Liaison between senior management and IT for development of financial reports
  • Constructs and manages multidimensional financial models to analyze company cash flows over near and long term

Computer Services Manager/Stats and Reporting Group

Miami Dade County Courts
01.2002 - 01.2011
  • Coordinated, monitored, supervised, documents and work on multiple tasks and projects simultaneously
  • Maintain, create, debugged various requests for end-user from various IDMS systems including Criminal Justice
  • Provide supervision and assistance to three programmer analysts
  • In addition, assisted in organizing meetings with staff, end-users, department directors and judges regarding report requests, report changes, judge changes etc
  • Programming/Reporting/Support from the Odyssey Family system using Microsoft SQL Server Reporting Services (SSRS), Database Warehouses
  • Developed numerous statistical reports using SAS, SQL, and Excel to extract Payroll information and created various visual statistical reports, charts and summaries for accurate and data-driven decision making by Senior staff
  • Worked on the 'Data Warehousing Team' to extract/convert/upload/model mainframe data into relational databases and warehouses

Education

Associate in Arts - Computer Science

Miami Dade College
Miami, FL

Associate in Science - Business Data Processing

Miami Dade College
Miami, FL

Skills

  • Database Management
  • Relationship building
  • Customer and client relations
  • Travel coordination
  • Report analysis
  • Statistical data gathering
  • Documentation and reporting
  • Technical Support
  • Event calendar management

LANGUAGES

Spanish, Native or Bilingual
English, Full Professional

Timeline

Data Systems Analyst - Information Technology

Gulliver Schools
03.2018 - 07.2018

Business Intelligence Developer

Our Kids of Miami-Dade and Monroe, Inc.
09.2017 - 11.2017

Data Systems Analyst - Information Technology

Gulliver Schools
01.2017 - 08.2017

Senior Information Analyst

City Of Miami Beach
06.2015 - 10.2016

QNXT Analyst/Report Developer

Independent Living Systems
02.2014 - 05.2015

Report Writer Specialist

Florida Healthcare Plus
01.2012 - 01.2014

Computer Services Manager/Stats and Reporting Group

Miami Dade County Courts
01.2002 - 01.2011

Associate in Science - Business Data Processing

Miami Dade College

Associate in Arts - Computer Science

Miami Dade College