Jacobo Hernandez Cid

As a Systems Analyst at Coppel Corporation, I focus on enhancing and optimizing the organization's information systems, with a strong emphasis on SQL and database management. My key duties include:

• Database Management: Utilize MS SQL Server for report creation, troubleshooting processes, stored procedure creation and modification, table creation, and cleaning. Execute regular backups of databases, contributing to the organization's data security and disaster recovery protocols.
• ETL Processes: Perform ETL from multiple sources like PostgreSQL and MySQL.
• Reporting Platforms: Use Laravel as a reporting platform and Excel PowerQuery for complex, one-time report creation.
• Jira Expertise and Training: Utilized Jira as the primary helpdesk software to optimize ticket management and resolution workflows, ensuring efficient support for all users. Leveraged my experience to mentor and train coworkers on effectively using the platform.
• Confluence Documentation Management: Employed Confluence as a documentation repository to keep all processes and procedures well-organized and easily accessible. Actively promoted and taught the use of Confluence to colleagues, enhancing overall team productivity.

Additionally, I am involved in:

• Systems Enhancement Solutions: Analyze and implement improvement solutions for the organization's information systems.
• Requirement Lifecycle Management: Collect, confirm, and validate solution requirements.
• Scope Analysis and Performance Oversight: Monitor the performance of implemented solutions and address any incidents.
• Testing Regimen: Conduct functional tests and oversee user acceptance tests.
• Installation Planning and Oversight: Plan and monitor the installation of solutions.

In this role, I am committed to ensuring the seamless operation of information systems, driving efficiency, and delivering unparalleled technical support to users on-site.

• Keystone Platform Management: Utilized the core platform called Keystone from Corelation, which uses DB2 for the database, to ensure seamless operations and data integrity.
• Report Creation and Modification: Created and modified ad-hoc daily, weekly, and monthly reports using Jaspersoft Studio and Google Dashboards to convey critical information to stakeholders.
• Helpdesk Software Utilization: Leveraged Jira as the central helpdesk software to streamline ticket management and resolution processes, ensuring efficient support for all users.
• Documentation Repository Management: Used Confluence as a documentation repository to maintain organized and accessible records of all processes and procedures.
• Server Upgrade and Maintenance: Led server upgrade and maintenance initiatives to enhance system performance and reliability.
• Operational Efficiency: Implemented automation and process improvements to reduce operational hours and enhance system reliability.
• Stakeholder Communication: Effectively communicated technical information and report findings to stakeholders, ensuring transparency and informed decision-making.

As a Tech Support Specialist, I ensured the seamless operation of corporate computing infrastructure by troubleshooting, upgrading, installing, repairing, and maintaining computers and peripherals. Key responsibilities included:

• Installing, configuring, and updating Microsoft Windows 10 Pro.
• Integrating new computers into the corporate Windows Active Directory.
• Installing essential software like eClinicalWorks.
• Configuring user-specific settings and peripherals.
• Troubleshooting and configuring Mitel phone extensions.

My role focused on enhancing corporate efficiency through swift problem-solving and cutting-edge tech solutions.

• Database Management: Responsible for backups and restores of MySQL, Oracle, Sybase, and Access databases as needed.
• Server Management: Oversaw OS and hardware upgrades and maintenance for servers running Windows, Ubuntu, and Oracle. Utilized Webmin and Windows Server Manager for efficient server management.
• Performance Optimization: Tweaked server settings to ensure optimal database performance.
• Database Development: Created, modified, and cleaned tables, functions, stored procedures, indexes, triggers, and data links across all managed databases.
• Custom PHP Platform: Designed and implemented a custom PHP platform for rapid development, featuring comprehensive logging and configurability, including user roles, processes, and permissions.
• New Justice System Implementation: Played a key role in implementing and maintaining the database for the 'New Justice System' launched in August 2010 in Mexicali, ensuring minimal downtime and smooth operations.
• Operational Oversight: Monitored database operations to achieve minimal downtime and ensure continuous availability.

• Report Creation: Developed and generated reports within government applications using PowerBuilder and Oracle SQL.
• Data Analysis: Analyzed data requirements and created SQL queries to extract relevant information for reporting purposes.
• Application Support: Provided support and maintenance for existing government applications, ensuring accurate and timely report generation.
• Collaboration: Worked closely with other developers and government officials to understand reporting needs and deliver effective solutions.
• Entry-Level Responsibilities: Gained valuable experience in software development and database management, laying the foundation for future career growth.

• Administrative Dynamo: Handled the reception of snack suppliers, streamlined orders, and managed payments, ensuring a seamless supply chain.
• Facility Maestro: Ensured the functional integrity of store facilities, verifying smooth operations and addressing issues promptly.
• Customer-Centric Steward: Managed the store front daily, ensuring exceptional customer experiences and overseeing day-to-day operations.
• Financial Savvy: Conducted daily balances at the end of each shift and compiled weekly Income-Expense reports, providing vital financial insights.
• Client Satisfaction Champion: Ensured clients received exceptional service and enjoyed their time, cultivating lasting relationships.