*

LOURDES M. HERNANDEZ

Coral Gables, FL. *****

Email:adzejn@r.postjobfree.com

786-***-****

Display LINKEDLN Profile

Seeking a Part-Time, Remote position as a Report Writer using Crystal Reports, SSRS Microsoft, Excel and/or SQL.

Education

Associate in Arts in Computer Science

Miami Dade College - Miami, FL

Associate in Science in Information Technology

Miami Dade College - Miami, FL

Strengths

Very detail oriented and a quick learner. Excellent communication and writing skills in English and Spanish. Responsible, hard-working and reliable individual, a team player who works well with others and is also very productive under minimal supervision. Proficient in Microsoft Suite.

● Experienced T-SQL, data warehouses Business Intelligence systems development, Relational Databases

● Worked closely with users/directors to understand business requirements and translate to appropriate technical solutions

● Meets with report consumers to understand their reporting needs and is able to translate into meaningful and accurate reports

● Skilled in relational database systems such as Microsoft SQL Server

● Experienced understanding of the Software Development Life cycle

● Experienced extracting financial data for budget, payroll and compensation to present to senior management in Power Point presentations

● Experienced using Microsoft SQL Server (2008, 2012, 2014)

● Experienced using SQL Server Integration Services (SSIS)

● Experienced using SQL Server Reporting Services (SSRS)

● Excellent analytical, problem-solving, and decision-making skills

● Proficient with SQL databases, SQL ETL (Extract, Transform, Load)

● Excellent written and oral communication skills

● Self-motivated and detail oriented, strong analytical and problem solving skills, proven track record in client service

● Proven track record of delivering work/projects on time

● Experienced in QNXT, EDEN and ENERGOV reporting and statistics

● Create reports and report templates, Design, code, extract, manipulate, and load into a data model/data warehouse

● Handles projects from beginning to end including data extract, formatting user testing, quality assurance, documentation, etc.

● Provides excellent customer service at all times and acts as liaison between IT and other departments

● Developed numerous statistical reports using SAS, SQL, SSRS, Crystal Reports and Excel to extract payroll information and create statistics reports and financial charts. Extracted, manipulated and loaded data into data models/data warehouses

• Knowledge of relational database management, data warehousing and modeling. Experienced creating multi- dimensional report results to support more “eye-friendly” and more accurate business decision making. 2

Technical Skills/Qualifications

Microsoft Suite, Crystal Reports 9.0/2013, XI Release 2.Crystal Reports CR Professional ver. 11.0.0, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), IBM OnDemand, IBM Mainframe, SQL Server Management Studio 2008/2014, MS SQL Server (2008, 2012, 2014) 2016, Microsoft SQL Reporting Services, Microsoft SQL Server Report Builder, QNXT by TriZetto, Powerpoint, Microsoft Suite Microsoft Excel (including V lookup, pivot tables) SAS (Statistical Analysis Software), Microsoft VISIO, ODYSSEY,REXX, MVS JCL, IBM VSAM TSO/ISPF,JIRA,ENERGOV,EDEN by Tyler Technologies, SHAREPOINT, TLMS, Business Objects, frevvo Forms, Oracle Database, FINALSITE, HTML, SENIOR SYSTEMS, CRYSTAL REPORTS, SQL, EXCEL, MICROSOFT SSRS, SSIS, MS WORD, frevvo workflow forms,TLMS,JIRA, etc. Work Experience

Contractor-Self Employed

Coral Gables, Florida

August 2018 – Present

• Creating reports and statistics

• Updating software

• Reviewing and updating existing reports

Data Systems Analyst - Information Technology

Gulliver Schools - Coral Gables, FL

March 2018 to July 2018

• Developed several electronic forms using the Frevvo Automated Forms tool.

• 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. - Miami, FL September 2017 to November 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 using Microsoft Power BI. Presented summaries and statistics for determining the average number of kids by status and zip code location.

• 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

January 2017 to August 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

3

• 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. Manipulated the data for presentation in different formats (pie charts, bar charts, etc) to effectively display and deliver answers to questions in queue

• Create and present statistical payroll reports to senior management to assist in strategic financial planning and decision making

• Worked as liaison between users, managers, supervisors and senior management to create statistical reports that would assist in major decision making and in addition, would automate manual workflow duties

Senior Information Analyst

City Of Miami Beach

June 2015 to October 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

February 2014 to May 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 Structure 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

2012 to 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

4

Computer Services Manager/Stats and Reporting Group Miami Dade County Courts

2002-2011

• Coordinate, monitor, supervise, document 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

• Civil, Cost Accounting, etc. using SQL, SAS, Microsoft SQL Reporting Services

(SSRS), Crystal Reports and Mortgage Foreclosure Reports. Senior Systems Programmer Analyst/Ad Hoc Reporting Group Supervisor Miami-Dade County Courts

1997-2001

• Maintenance, Enhancement and Ad Hoc Report generation using SAS and SQL of live complex IDMS databases running on IBM mainframes. One database alone serves 100 agencies, 13,000 users, has 360 screens and produces about 700 or more reports.

• Supervision of two Computer Programmers and assign/prioritize projects to assure their timely completion.

• Calculate and convey cost estimates for requested information reports to various users including outside agencies, private attorneys, The Miami Herald, The Daily Business Review, The University of Nebraska, etc.

• Assist, train, and guide other programmers on technical design and coding specifications of various IDMS mainframe databases.

• Conduct interviews and support users to properly resolve their issues and create reports according to their needs and specifications

Programmer Analyst

Miami-Dade County Courts

1994-1996

• Analyze, design and code ad hoc requests using SQL, SAS, JCL, and IDMS for several systems Including Cost Accounting, General Masters, Civil, Criminal Justice information, and Traffic systems.

● Perform maintenance in the Civil and Criminal Justice systems including additions and modifications of offenses and judges.

● Responsible for inputting service requests for the Information Technology Department using the INFOMGT system.

● Assist supervisor in the procedures to be followed for new report requests. Preliminary analysis, approvals, logging, cost and time estimates, invoice generation, post-delivery support etc.

● Ran monthly statistics reports including Drug Court and Personnel reports.

• Assisted users and staff in training of systems and resolving of system problems.

Contact this candidate