Tatiana Zetino Martinez
Norfolk,NY
Summary
Data Analyst with five years of experience in SQL and database management, specializing in advanced query development for analytics, automation and data migration. Proven problem-solver with a comprehensive understanding of IT systems and business processes. Proficient in Agile methodologies and project management. Currently pursuing a transition into Data Engineering, focusing on scalable data pipelines and effective ETL solutions.
Overview
6
6
years of professional experience
2
2
Certifications
Work History
Data & Reporting Analyst
Efficiency One
Dartmouth, Nova Scotia
02.2024 - Current
- Automated data processing tasks, enhancing efficiency and minimizing manual errors.
- Analyzed user requirements, designed ETL processes for enterprise data integration using Python, SSIS, Power BI.
- Developed Python scripts for data extraction from web services APIs into databases.
- Implemented Power BI to create dashboards and reports for business stakeholders.
- Built visualizations that facilitated quick interpretation of complex analysis results.
- Provided technical support for existing reports, dashboards, and tools.
- Assisted internal clients through a ticketing system by generating SQL queries for on-demand report creation.
Database Analyst
Efficiency One
Dartmouth, Nova Scotia
03.2023 - 02.2024
- Oversaw system software upgrades to enhance operational efficiency.
- Troubleshot Salesforce malfunctions, restoring normal functionality promptly.
- Explored new technologies and tools to improve processes and security.
- Extracted data from Salesforce using SOQL for reporting and manipulation.
- Created reports and dashboards in Power BI to analyze trends against targets.
- Managed data migration from Google Analytics to data warehouse using ETL processes.
Technical Analyst
Risk Control Technologies Inc.
Toronto, Ontario
09.2020 - 03.2023
- Delivered tier 1 and tier 2 support via email, phone, and Zendesk in English and Spanish, adhering to SLA agreements.
- Maintained data integrity while modifying client databases using SQL commands and backup strategies.
- Developed large SQL scripts with cursors to migrate historical client data into the database.
- Provided occasional tier 3 support through code changes, committing updates to source control with GitKraken.
- Updated client sites by executing migration scripts and deploying new code using Azure DevOps and Octopus Deploy.
- Created a data reporting system with SQL and PowerShell to analyze client usage for informed business decisions.
- Generated reports for clients using Tibco Jaspersoft/Jasper reporting tool.
- Managed implementation projects to onboard new clients, customizing sites and automating database maintenance tasks.
Scrum Master
Risk Control Technologies Inc.
Toronto, Ontario
02.2021 - 01.2023
- Led a team of 8 individuals, implementing Agile methodologies and facilitating scrum ceremonies.
- Removed impediments to enhance team capacity while ensuring accountability for commitments.
- Supported product owner in managing customer expectations for project deliverables and internal stakeholder communications.
- Optimized team performance by enforcing definitions of ready and done during story selection.
L1 Customer Service Representative
Fortinet Technologies
Ottawa, Ontario
09.2019 - 09.2020
- Managed incoming phone calls, creating technical tickets and transferring them to engineers as necessary.
- Communicated with customers via phone, chat, tickets, and emails to resolve inquiries.
- Resolved customer issues in ticket inquiries by collaborating with internal teams on device transfers and account changes.
- Conducted minimal troubleshooting on web filters, firewalls, and graphical user interfaces.
- Enhanced customer satisfaction by delivering creative solutions in four languages.
- Maintained up-to-date industry knowledge through continuous education and training.
- Coordinated effectively with internal teams to gather accurate information for customers.
- Participated in UAT testing for new products and developed documentation for usage steps.
Education
Bachelor of Science - Computer Science
Carleton University
Ottawa, Ontario, Canada02.2022
Technical Skills
Data Engineering: ETL/ELT Pipelines, Data Warehousing, Data Lakehouse Architectures
Tools & Platforms: Power BI, Power Query, SSIS
Databases: SQL Server, PostgreSQL, MySQL
Languages: SQL, Python, UNIX Shell Script / PowerShell
Other: Data Modeling, Dashboard Development, Automation & Orchestration
Operating Systems: Linux (Ubuntu) | Windows | macOS
References
References upon request.
Certification
Certified Scrum Master, CSM issued by Scrum Alliance - Sept. 2021
Languages
English
Native/ Bilingual
Spanish
Native/ Bilingual
French
Professional
Timeline
Data & Reporting Analyst
Efficiency One
02.2024 - Current
Database Analyst
Efficiency One
03.2023 - 02.2024
Scrum Master
Risk Control Technologies Inc.
02.2021 - 01.2023
Technical Analyst
Risk Control Technologies Inc.
09.2020 - 03.2023
L1 Customer Service Representative
Fortinet Technologies
09.2019 - 09.2020
Bachelor of Science - Computer Science
Carleton University