Daniel D.
Data Analyst

Skills

Tableau

Sql

Google Bigquery

Python

Postgresql

Daniel is available for hire

Hire Daniel D.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

Database professional with over seven years of experience specializing in database management and data analysis. Proficient in executing ETL processes to integrate new databases into analytical environments, devising SQL database queries, and performing environmental analyses to design robust data visualization report systems (BI). Demonstrates expertise in extracting large data volumes from clusters for report generation, facilitating client decision-making, and developing dashboards for monitoring purposes. Skilled in data modeling and adept in utilizing technologies such as PostgreSQL, BigQuery, Tableau, Power BI, Metabase, GitHub, Pentaho, Python, along with cloud platforms like GCP and AWS.

Data Analyst
5/1/2022 - 12/1/2023

Developed new metrics and KPIs while prioritizing tasks using agile methodologies, specifically Scrum. Extensive experience in creating dashboards of indicators using Tableau and Looker to support various business areas such as Marketing, Finance, and Logistics. Prepared on-demand reports and dashboards with a focus on decision-making, utilizing advanced SQL queries in BigQuery to extract strategic information from large datasets. Demonstrated skills in developing data pipelines to efficiently extract, transform, and load (ETL) large volumes of data.
Data Analyst
11/1/2017 - 5/1/2022

Developed dashboards to replace Excel-generated reports, automating processes, improving service productivity, and generating insights. Gained expertise in data mapping and excelled in task prioritization using agile methodologies, particularly Scrum. Utilized ETL tools such as Pentaho to streamline data processing. Created indicator dashboards leveraging Tableau, PowerBI, and Metabase. Provided support to the Development team in maintaining robust and efficient databases.
IT Requirements Analyst
12/1/2014 - Present

Gained extensive experience in requirements analysis, focusing on gathering and documenting technical requirements. Developed advanced proficiency in using tools like JIRA and Confluence to capture and track requirements. Conducted comprehensive stakeholder interviews and facilitated requirement workshops to gather detailed specifications. Demonstrated strong analytical skills in performing gap analysis and feasibility studies, employing UML and BPMN for creating models and diagrams. Utilized Microsoft Visio for visual representation of requirements. Ensured effective communication and consensus-building among cross-functional teams throughout the project lifecycle. Applied Agile methodologies to manage changing requirements and enhance project adaptability, while ensuring alignment with business objectives.
IT Infrastructure Technician
7/1/2014 - Present

Supported PostgreSQL databases by optimizing performance, ensuring high availability and implementing backup and recovery strategies. Developed SQL scripts to automate tasks and streamline database operations. Utilized tools such as pgAdmin and psql for database management and monitoring. Coordinated with application developers to troubleshoot and resolve database-related issues. Ensured data integrity and security by applying appropriate measures and compliance protocols. Contributed to database design and architecture decisions to enhance system efficiency and scalability.
IT Infrastructure Technician
1/1/2014 - 7/1/2014

Developed deep technical expertise in database administration and system support, focusing on MySQL, PostgreSQL, and SQL Server. Administered and optimized performance for databases, ensuring high availability and disaster recovery using tools such as MySQL Workbench and SQL Server Management Studio. Implemented and managed backup strategies, automated job scheduling, and routine maintenance tasks to minimize downtime. Utilized performance tuning techniques including query optimization and indexing strategies.

Configured and maintained Linux and Windows servers, ensuring secure and efficient operation using tools such as Nagios for monitoring and Chef for automation. Managed virtualized environments with VMware, enhancing resource allocation and system resilience. Provided robust systems support, troubleshooting and resolving complex issues by collaborating with network administrators and software developers.

Gained proficiency in scripting languages like Python and Bash, enabling the automation of routine tasks and the development of custom solutions for unique operational challenges. Utilized version control systems such as Git to manage and deploy database schemas and configurations. Executed thorough documentation practices, creating and maintaining technical guides and runbooks to ensure continuity and knowledge sharing within the team.
Government Salesperson
6/1/2013 - 10/1/2013

Demonstrated strong proficiency in understanding and conveying complex technological concepts, focusing on developing customized technology solutions to meet client-specific requirements. Utilized extensive knowledge of CRM systems like Salesforce and HubSpot to manage customer relationships and sales pipelines efficiently. Showcased technical expertise in cloud platforms such as AWS and Azure, and leveraged those platforms to propose viable solutions that aligned with client infrastructures. Facilitated product demonstrations and technical workshops to explain the benefits and functionalities of software solutions, and maintained up-to-date knowledge of emerging technologies and market trends. Cultivated skills in negotiating contracts and managing post-sales support, ensuring customer satisfaction and retention. Employed data analytics tools like Tableau and Power BI to analyze sales performance and drive strategic initiatives, and consistently collaborated with cross-functional teams to deliver cohesive and robust technology projects.
Support Analyst II - Infrastructure
3/1/2010 - 3/1/2013

Developed proficiency in troubleshooting and resolving complex technical issues across various software platforms. Extensive work on incident management and service request systems, consistently delivering high-quality support to ensure customer satisfaction. Demonstrated expertise in using diagnostic tools to identify root causes of system failures, thereby minimizing service downtime. Improved efficiency in IT operations through the automation of routine tasks using PowerShell and Python scripting. Showcased skills in configuring and maintaining Windows and Linux server environments, as well as managing Active Directory and Exchange. Played a critical role in enhancing security protocols, including the setup and monitoring of firewall rules and VPN access. Adept at utilizing ITIL best practices to streamline support processes and contribute to continuous improvement initiatives. Proficient in using ticketing systems like ServiceNow and Jira for tracking and documenting issues, enabling better visibility and accountability within the support team.
Support Analyst I - Infrastructure
4/1/2008 - 2/1/2010

Gained extensive expertise in providing technical support and troubleshooting within a high-demand environment. Developed proficiency in incident management tools such as ServiceNow and Remedy for tracking and resolving issues efficiently. Enhanced skills in Windows and Linux operating systems, ensuring the smooth operation and maintenance of both platforms. Acquired in-depth knowledge of SQL and Oracle databases, facilitating the diagnosis and resolution of database-related issues. Demonstrated expertise in various communication tools including Slack and Microsoft Teams for effective team collaboration and problem-solving discussions. Enhanced network troubleshooting abilities by working with tools like Wireshark and PRTG Network Monitor. Showcased strong analytical skills by developing scripts utilizing Python and PowerShell to automate routine tasks, thereby increasing operational efficiency. Maintained a high level of customer satisfaction by providing timely and accurate technical solutions, leveraging CRM systems to track and manage interactions.
Technical Support - Infrastructure Support
9/1/2006 - 4/1/2008

Developed expertise in IT service management using ITIL and ISO 20000 standards. Ensured efficient incident resolution through the use of ServiceNow and Jira. Gained proficiency in SQL and Powershell scripting for data manipulation and automation. Expertly handled network troubleshooting with tools like Wireshark and Nagios. Monitored system performance utilizing Splunk and SolarWinds. Enhanced customer experience by delivering timely and effective technical support. Employed Remote Desktop Protocol (RDP) and VMware for troubleshooting and maintaining virtual environments. Implemented Active Directory management for user access and security. Showcased strong analytical skills to diagnose and resolve software and hardware issues. Maintained accurate documentation and knowledge base articles to streamline future support activities.
Network Support Analyst
5/1/2006 - 8/1/2006

Developed proficiency in administering and managing enterprise-level database systems, specializing in SQL Server, MySQL, and Oracle Database. Demonstrated expertise in configuring and maintaining databases, ensuring high availability and performance optimization. Acquired advanced skills in database backup and recovery, as well as in implementing robust security measures. Enhanced capacities in monitoring system health and performance using tools like Nagios and SolarWinds. Contributed to seamless integration with other technologies, utilizing ETL processes and scripting languages like Python and Bash. Leveraged comprehensive knowledge of system administration in Linux and Windows environments. Implemented and maintained automated job scheduling through tools such as Cron and Microsoft SQL Server Agent. Demonstrated strong problem-solving skills in troubleshooting and resolving database issues. Proved competent in collaborating with development teams to optimize query performance and ensure data integrity.
Computer Networks Internship
5/1/2005 - 4/1/2006

Provided extensive support for multiple systems and various database technologies. Demonstrated proficiency in managing, troubleshooting, and optimizing Oracle, MySQL, and SQL Server databases. Employed advanced performance tuning and query optimization techniques to improve database efficiency. Designed and implemented backup and recovery strategies to ensure data integrity and availability. Utilized tools such as SQL Developer, MySQL Workbench, and SQL Server Management Studio for effective database administration.

In addition to database management, excelled in system support by maintaining and monitoring Unix and Windows servers. Implemented automation scripts using Shell scripting and PowerShell to streamline routine tasks and minimize downtime. Leveraged VMware and Hyper-V for virtualization needs, ensuring robust and scalable environments. Exhibited strong skills in managing Active Directory and executing Group Policy management for better access control and user management.

Furthermore, developed a keen understanding of networking concepts and protocols, contributing to effective system communication and troubleshooting. Utilized monitoring tools such as Nagios and Splunk to keep track of system health and proactively address potential issues. Employed ITIL best practices in incident, problem, and change management to ensure minimal disruption and optimal service delivery. This multifaceted expertise in systems and database support resulted in increased reliability, performance, and security across diverse technical environments.