Amado Fernandez

* Collaborated closely with cross-functional teams to gather requirements, developing critical data analytics using T-SQL and Snowflake queries, and crafting interactive dashboards in SQL Server Management Studio and Looker. * Conducted comprehensive data profiling on diverse datasets to assess data quality, accuracy, and completeness. * Analyzed and interpreted data structures, identifying patterns and anomalies to ensure data integrity. * Executed column-level analysis, scrutinizing data types, ranges, and formats for alignment with expected standards. * Implemented thorough completeness analysis, addressing missing values and null entries to enhance dataset reliability. * Meticulously crafted a sophisticated SQL script to adeptly extract, consolidate, and store extensive volumes of data from diverse sources, including our internal policy and claims systems. This process was aimed at extracting vital metrics and aggregating them into centralized data warehouse tables. These aggregated metrics are instrumental in generating month-end and year-to-date reports that are crucial for management's decision making. * Designed visually engaging dashboards and charts in Looker to provide stakeholders with a clear view of key policy premium metrics. This allowed them to assess payments received in comparison to outstanding amounts, ensuring a stable cash flow and maintaining financial stability. * 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. This report and dashboards offered a clear picture of the organization's claims management and financial performance. * 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 performance insights, empowering strategic decision-making.

• 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. • Designing an SQL database for a Case Load Tracking System involves creating a structured and efficient data model to store information related to cases, users, case notes, and any other relevant entities. • Integrated a suite of twelve SSRS reports into the Case Load Tracking Systems, enhancing data insights and communication capabilities. • Developed various applications via Visual FoxPro, including Client File, Calendar Contacts, Codefendant, Investigations Request, Investigators Travel Log, and Social Worker applications, to further support the organization's operational requirements.