Gabriel P.
Data Analyst

Skills

.NET

Airflow

Transact-sql

Github

Microsoft Sql Server

Python

Postgresql

Mysql

Amazon Aws

Gabriel is available for hire

Hire Gabriel P.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A highly qualified technical professional with expertise in SQL and RESTful API development using Python (FASTAPI). This individual has demonstrated exceptional skills in creating and optimizing complex SQL queries, data modeling, and implementing stored procedures for process automation. Proficiency in Python has supported the development and maintenance of high-quality RESTful APIs, contributing to modern, scalable applications. Experienced in system integration, microservices implementation, and building interactive user interfaces, with a focus on code efficiency and user experience.

Possesses strong problem-solving abilities, and effective communication skills, and works well within a team setting. Continuously strives for skill enhancement and stays current with the latest trends and technologies in computer science.

Demonstrates a results-oriented approach and unwavering commitment to excellence, ready to address technical challenges and contribute to the success of complex projects. Whether collaborating within a team or independently, this versatile technical professional is prepared to add immediate value and make impactful contributions.

Senior Developer
8/1/2023 - Present

Strategically managed a developer team, acting as the primary customer's point of contact for management activities, facilitating team productivity by mapping needs, monitoring tasks, and resolving conflicts. Developed REST APIs for consumption using FASTAPI, while maintaining legacy code on the .NET platform with VB.NET. Created data automation routines utilizing Python, leveraging SQLAlchemy for database connectivity and manipulating data with the Pandas library. Maintained ETL scripts and managed data manipulations for client report exports. Administered and maintained SQL Server databases hosted on Azure Cloud, functioning as an SQL developer for ETL routines, overseeing database modeling, optimizing data processing queries, and managing backups and restores.
Database Administrator
10/1/2021 - 8/1/2023

Served as the IT team's focal point for database management, utilizing SQL Server, MySQL (MariaDB), and PostgreSQL technologies. Guided developers on best practices for query design and database object creation, ensuring optimal performance and reliability. Conducted analysis of business rules and modeled new entities and relationships. Responsibilities included the creation of new databases and schemas, user management, mapping, and permissioning. Developed and executed maintenance plans, recovery, and backup models in line with the company's RTO and RPO requirements. Performed query analysis for optimization and tuning, defragmented search indexes, and created jobs, triggers, stored procedures, functions, and views. Additionally, carried out query analysis for report building, T-SQL development, and routines for cleaning search indexes, while consistently monitoring backups and managing locks/deadlocks.
Web Developer
8/1/2020 - 10/1/2021

Developed web applications using ASP.NET (VB.NET) technology, focusing on business rule analysis, CRUD form development, implementation of new features, code improvements, and error handling. Provided technical guidance and mentorship to newer team members, aiding leadership in task distribution and resource development. Excelled as a key resource on SQLSERVER, guiding best practices and efficient query development. Tasks included business rule analysis, creation of stored procedures, triggers, views, functions, and queries, as well as comprehensive database administration. This encompassed user management, development of new entities and schemas, T-SQL operations, backup strategies, recovery models, and database management tailored to client-specific RTO requirements. Additionally, formulated and executed compelling maintenance plans.
Developer Analyst
3/1/2019 - 7/1/2020

Developed and maintained VB6 legacy development routines, ensuring system sustenance and evolution. Demonstrated expertise in ASP.NET and VB.NET within VisualStudio using the MVC standard to implement new features, manage version control, create data export, routine creation, CRUD elements, GRID reports, and spreadsheet exports. Provided robust system support in JAVA SE using NETBEANS and the MVC standard, focusing on building CRUD forms, implementing new functionalities, generating reports, and advancing tool evolution.

Leveraged SQL SERVER to develop small conceptual and logical database models for project updates, execute T-SQL operations, extract reports, manipulate and extract data through complex queries, and develop, analyze, and maintain stored procedures, triggers, views, and jobs. Ensured seamless data queries and backup while creating detailed routines for log report generation.
Junior Support Analyst
12/2/2017 - 3/1/2019

Responsible for SQL Server database troubleshooting and the implementation of small database modeling projects. Handled incidents and developed stored procedures for data processing and report extraction. Created triggers for log recording and processing, along with functions and views for streamlined database operations. Managed database backup and restore processes, executed DML and T-SQL operations, and produced detailed reports. Facilitated interaction with users and clients for business rules analysis and object construction, demonstrating comprehensive database management skills.
Electronics Technician I
5/2/2015 - 3/2/2017

Managed company equipment allocated at client sites, developing proficiency in equipment handling and client coordination. Created and maintained a comprehensive preventive maintenance calendar to ensure optimal equipment functionality. Exercised precise inventory management and performed detailed data handling. Efficiently resolved incidents and integrated seamlessly with users and clients. Conducted training sessions, imparting essential knowledge to users, and prepared detailed supply consumption reports for monitoring and analysis.
Computer Maintenance Technician
12/2/2012 - 3/2/2015

Gained expertise in the technical maintenance of microcomputers and workstations while providing helpdesk support and direct user interaction. Developed skills in network configuration, support, and installation, including printer configuration and working knowledge of network equipment such as hubs, switches, and routers. Acquired proficiency in general cabling and extensive knowledge of the Microsoft Office suite. Provided support for Windows XP, 7, 8, and Windows Server 2008 R2. Served as a systems administrator for XenServer, Citrix, and ProjectWise. Demonstrated strong knowledge in DNS, DHCP, Active Directory (AD), firewall management, backup solutions, and Windows services.