Amado Ricardo Fernandez
Miami, Florida *****
Cell: 786-***-****
ad0457@r.postjobfree.com
https://www.linkedin.com/in/amado-fernandez-a115a1287/ PROFILE
I am a dedicated data analyst and reporting professional with a proven track record of excellence in managing business intelligence requests from inception to a successful completion. My expertise in SQL empowers me to create intricate queries, facilitating data extraction, manipulation, modeling, pipeline analysis, and reporting all of which are instrumental in driving company growth and profitability. My success is bolstered by a strong history of effective collaboration with diverse stakeholders, including cross-functional teams in accounting, audit, claims, operations, underwriting counsel, and sales. I am committed to delivering results and supporting the strategic goals of the organization.
EDUCATION
The Chubb Institute Jersey City, NJ
Bachelor’s Degree in Computer Science
SKILLS
T-SQL
SQL Server Reporting Services
SQL Server Management Studio
Looker Development
Looker Data Visualization
Snowflake
Salesforce
SQL to Snowflake Migration
Data Warehousing
Data Cleaning
Data Normalization
Data Standardization
ETL
Python
JIRA
GitHub
Kanban Agile Development
Word
Excel
WORK EXPERIENCE
Data Analyst January 2013 – September 2023
DOMA - Miami, FL
In my role as a Data Analyst and Reporting Analyst, I fostered strong collaboration with cross-functional teams to meticulously collect data insights and deliver them through visual tools such as SSRS and Looker.
I adeptly developed critical data science techniques, encompassing data capture, maintenance, processing, analysis, and effective communication of outcomes, all achieved through SQL and Snowflake. These insights were thoughtfully conveyed to key stakeholders, supporting informed decision-making.
Accounting Team
I meticulously crafted an advanced Snowflake script extracting cloud-based datasets, and consolidating them to a monthly and yearly aggregate warehouse tables. These tables were primarily sourced from Salesforce and our internal policy and claims systems, yielding the following outcomes:
Efficiency: Reduced policy and premium data extraction and consolidation time, resulting in a faster process for generating reports.
Data Quality: Ensured the accuracy and integrity of critical metrics, reducing errors in reports and decision-making.
Data Accessibility: Improved access to consolidated data for cross-functional teams, enhancing collaboration and information sharing.
Reporting Precision: Enhanced the precision of month-end and year-to-date reports, providing more accurate insights for management.
Cost Savings: Potentially reduced data storage costs by optimizing the storage of aggregated data.
Management Decision Support: Provided valuable data for management, enabling them to make more informed and strategic decisions.
Audit Team
I designed visually engaging dashboards and charts in Looker to provide stakeholders with a clear view of key policy premium metrics. This allowed the team to assess payments received in comparison to outstanding amounts, ensuring a stable cash flow and maintaining financial stability.
Claims Team
I designed SSRS and Looker dashboards within our internal policy and claims system to effectively identify key trends relating to agency revenue, claims, loss prevention, fraud detection, and overall profitability. The above data analysis allowed for reports and dashboards to provide a clear picture of the organization's claims management and financial performance.
Operations Team
I skillfully developed SSRS and Looker dashboards that seamlessly integrate Salesforce agency data with our internal policy and claims data. These robust reporting tools effectively capture essential agency history and performance insights, empowering strategic agency decision-making.
Underwriting Counsel Team
I implemented a robust FINCEN reporting system in Looker targeting policy transactions vulnerable to money laundering, terrorism financing and related crimes.
Sales Team
I designed a comprehensive report to track non-affiliated agency transactions and calculate their remitted payments. This ensures accurate monthly sales commission calculations for our agency sales managers.
Systems Analyst/Programmer February 1999 – December 2012 Law Offices of the Public Defender, 11th Judicial Circuit of Florida
Spearheaded the full-stack development of an internal Case Load Management System within the Visual FoxPro environment.
Led the conceptualization, execution, and continuous enhancement of an intricate Case Load Management Tracking System tailored to a diverse user community of over 440 members, including attorneys, investigators, and clerical staff, each with unique operational needs.
Collaborated closely with key stakeholders to comprehensively understand their workflows and requirements, resulting in the successful design, implementation, and maintenance of the Case Load Management Tracking System. This initiative significantly elevated the organization's capacity to efficiently manage cases, fostering improved collaboration, streamlined workflows, and operational excellence.
Maintained and managed object classes/libraries, projects, screens, procedures, tables, business actions, and business rules within the Case Load Tracking System.
Integrated a suite of twelve SSRS reports into the Case Load Tracking Systems, enhancing data insights and communication capabilities.
Developed various applications, including Client File, Calendar Contacts, Codefendant, Investigations Request, Investigators Travel Log, and Social Worker applications, to further support the organization's operational requirements.