Tyler Ramirez Email & Phone Number

Contractor for Long Beach Police Department

▪ Develop and maintain enterprise-wide reporting and dashboards, utilizing data from multiple sources within a Microsoft SQL Server database▪ Design and implement data warehouse flows and schemas, including staging, fact, dimensions, cubes, and reporting models.▪ Create accurate business requirement definitions and user training documentation▪ Produce reports and dashboards using Microsoft Power BI to provide meaningful insights to stakeholders▪ Conduct data analysis and effectively communicate results to drive business improvements▪ Collaborate with stakeholders to interpret business and reporting needs, providing feasible solutions▪ Ensure compliance with IT policy, Sarbanes-Oxley, and SOC2 requirements▪ Redefine and enhance existing Business Intelligence systems▪ Proficient in SQL querying, performance tuning, and ETL processing using SSAS, SSIS, and SSRS▪ Designed, developed, tested, and deployed Power BI reports and dashboards based on detailed analytics▪ Utilize DAX queries and functions in Power BI for advanced data analysis▪ Collaborate with cross-functional teams for performance improvements and suggestions▪ Support development and production environments for databases and Power BI reports▪ Assume ownership of existing integrations, including NetSuite to SQL, SQL Server to Azure, and Azure toPower BI▪ Manage and improve existing documentation while creating additional documentation as needed▪ Continuously sought opportunities to enhance and automate existing configurations, resulting in increasedefficiency and potential cost savings

• Perform primary administration, analysis, evaluation, requirements definition, design, development, testing, implementation, documentation, and maintenance for all Engineering systems and programs• Provide primary database administration support for all Engineering databases• Create, alter, maintain, optimize, and implement SQL stored procedures, functions, tables, logins, roles,integrations, triggers, jobs, restorations, and backups• Produce and maintain existing SSIS packages and jobs• Act as the secondary administrator on all SQL Servers and SQL Databases• Perform regular SQL Server maintenance and patching• Collaborate with IT staff to maintain regular backups of SQL Servers• Provide administrationfor reporting systems Power BI and SSRS• Develop, maintain, modify, optimize, and implement reports in SSRS and PowerBI• Build integrations between software and databases• Train internal and external staff (individual or group) on all applications used by the Engineering department• Liaison between the Engineering department and IT• Meet with Engineering Management and the Project Management Office weekly• Produce monthly status reports and present quarterly presentations to IT Management on the status of all ITsystems and programs in Engineering• Create and maintain documentation for all Engineering systems• Complete any service requests and incidents submitted to ticketing system• Work with user groups to implement new components and processes• Support the Project Management web application as the primary administrator and regularly meet withconsultants to improve the software• Work with vendor support to troubleshoot any software issues and request additional services or features• Investigate potential new software solutions and improve any deficient processes• Create packages and deployments in the configuration manager for software deployment• Ensure all software applications are updated consistently and stay current on security practices

• Troubleshoot, analyze, and resolve all software and hardware issues related to computers, printers, peripherals, and more• Attend meetings with internal and external staff to enhance and support existing systems• Create and provide documentation for training end users on using software or hardware• Participate in training courses to develop technical knowledge for better supporting applications• Monitor and maintain existing hardware, applications, and servers• Create SSRS reports for a variety of SQL databases• Provide primary administration support and project management on software and hardware• Use BMC and SCCM for device management of software, patches, reporting, inventory, compliance, OSdeployment, and auditing• Train staff and coworkers on programs and projects• Lead projects that will update existing equipment or software with the goal of staying current with technology• Upgrade or install vendor software• Test, evaluate and document new software and features• Collaborate with staff to create solutions and approaches for solving problems• Follow all ITIL practices, policies, and procedures

• Communicate issues effectively with higher level support staff for resolutions• Follow established protocols and procedures for installations, configurations, and upgrades of hardware,software, and networks in relation to end-user profiles• Assist in training end-users on new hardware and software capabilities, uses, and functions• Ensure excellent customer service through quick and thorough response to requests and inquiries into technicalissues• Configure Office 365, Adobe, and Java views, settings and preferences in Windows 7, Windows 8.1, andWindows 10• Train new User Support Technicians and Staff Aids on how to perform the job requirements• Install updates and applications on all courthouse computers that use the county programs ERMI and Monarch.• Upgrade end user computer equipment and transfer all data to the new equipment along with configuring theprofile for Windows 8.1 and Windows 10• Perform lone on-site support, troubleshooting, and evaluation of all issues

Minor In Mathematics

Computer Science, Computer Science