Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

YULIEN MARTINEZ

Miami,FL

Summary

Results-driven and motivated database analyst with hands-on experience in business and data analysis, with advanced computing skills, in the use of different soft skills such as competition, organization, multitasking, rapid learning, time management, good team player and very curious about the data and its insights. Ability to manage the relationship with a large group of people. Efficient Database Analyst recognized for interpreting and analyzing data to develop innovative business solutions. Over 10 years of industry experience with proficiency in statistics, mathematics and data analysis. Adept at successfully interpreting data to draw conclusions and presenting findings to improve strategies and operations.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Database Analyst

Palm Medical Centers
08.2021 - Current
  • Create tables, views and designed the PMC database
  • Transfer inbound data from various sources MS Access, Excel, web service, websites, csv. files to the database
  • Develop T-SQL code such as Stored Procedures, functions, triggers, Indexes, and views for the application, using PostgreSQL, pgAdmin
  • Responsible for optimizing SQL queries, stored procedures to improve the performance time
  • Develop reports and analyze data to answer the manager inquiries about PMC membership, quality trends, disenrollment rate, patient visit rate, providers, centers, payers
  • Create detailed charts and diagrams outlining results/findings of the analysis using PowerBi, Dax Formulas, Power Query.
  • Develop a linear regression model to predict the probability of disenrollment for a patient using excel and powerBi
  • Gather, transform and create Hedis and Qi Reports combining data from different sources (Access, SQL Server, and excel spreadsheet)
  • Report about the revenue, enrollment, disenrollment, patients status, Hedis gaps and others trending throughout the years, quarters, months or days to identify patterns and help to the decision making by the manager.
  • Effectively translated raw data into actionable insights via the creation of clear visuals and reports which facilitated informed decision-making amongst stakeholders.
  • Increased efficiency by automating repetitive tasks using scripting languages such as SQL, Python or java Script.
  • Increased efficiency by automating repetitive tasks using ETL tool such as Knime.

Database Analyst

RoadTex Transportation
08.2019 - 07.2021
  • Designed databases, tables, and views structure for the application
  • Transfered inbound data from various sources MS Access, Excel, csv files into database
  • Developed T-SQL code such as Stored Procedures, functions, triggers, Indexes, and views for the application, using SQL Server 2016 and DB2
  • Responsible for optimizing SQL queries, stored procedures to improve the performance time
  • Developed reports and analyze data to answer the manager inquiries about revenue and expenses
  • Created detailed charts and diagrams outlining results/findings of the analysis
  • Improved and updated existing daily/weekly/monthly reporting templates
  • Data used Transact-SQL to create reports
  • Reported about the revenue trending throughout the years to identify patterns and help to the decision making by the manager
  • Coordinated with the manager for data cleaning and variable selection for freight and truck data to make the data meaningful and analyzable
  • Created and maintained reports using SQL and Excel to monitor customer performance for the company by states, identifying patterns and trends
  • Produced databases, queries, and reports for analyzing, summarizing, and root causing truckload failure data
  • Found patterns and trends in complex, multi-variable data sets
  • Ensured data accuracy through the creation and implementation of data integrity queries
  • Created Reports combining data from different types of data sources (Access, SQL Server, and excel spreadsheet).

Database assistant

DIRECTV Latin America Procurement Department
04.2018 - 05.2019
  • Analyzed DIRECTV's records and business data by designing queries and reporting specifications, identified the organization's business needs
  • Collaborated with other programmers on data modeling
  • Reviewed and created reports, answered to manager inquiries
  • Migrated 4488 DIRECTV Latin America Agreements information from an old system to a new one used Ariba System, Easy System, advanced excel, and SQL Server
  • Proactively identified and presented findings, about DIRECTV Suppliers and DIRECTV Programmers Contracts on the system, mitigating risks successfully
  • Created presentations and reports about results and insights found on data, used Microsoft PowerPoint, SQL server and excel
  • Identified missing information on contracts requests and DIRECTV's agreements data, identified its risk for the company
  • Gathered and cleaned data about contract requests and agreements
  • Created weekly and monthly reports about DIRECTV's contract status, used SQL language and SQL Server.

Software System Analyst

University of Camaguey
09.2008 - 12.2015
  • Developed Software Engineering throughout the FSDLC, used VP and Rational Rose for UML, and VP, Rational Rose, and Erwin to the ER and MER models
  • Professor and researcher in software engineering problems using artificial intelligence techniques
  • Applied Agile Methodologies (XP, MSF Agile, RUP Agile)
  • Specialized in Traditional Methodology (Rational Unified Process) during the development of software for different clients
  • Executed Object-Oriented Programming in Java Language, applied the Design Patterns concepts
  • Developed Desktop applications (Java, C++, C#), used Eclipse
  • Developed the database design, queries, and Reports
  • Used Microsoft SQL Server 2012 and Crystal Report
  • Analyzed and documented high level and detailed business requirement and translated in use case diagram
  • Used machine learning techniques and IA methods to predict results and help to the decision making
  • Translated technical applications specification into functional and nonfunctional business requirements
  • Developed and designed the Test Model
  • (Identified test cases, test objects and test plan)
  • Executed manual tests to a wide variety of software
  • Developed Manual Testing using Black and White Box methods
  • Performed Unit, Component, Interface, and System tests whit great results reducing the cost of software construction
  • Planned duration of tests, designing test cases, and identifying test objects before each iteration
  • Researched in Automatic software testing.

Education

Master's in science Degree in Applied Computer Science -

Camaguey University
Camaguey, Cuba
01.2011

Bachelor's Degree in computer sciences -

University of Information Science "UCI"
Havana, Cuba
07.2008

Skills

  • Good command of written and spoken (Spanish and English)
  • Advanced knowledge in Data Analysis, Design and Development Advanced knowledge Business Analysis
  • Java, C, Visual Basic Language skills, python, Java Script , SQL
  • Advanced knowledge in Excel, Power Query, Dax formulas
  • Excellent command of PC-based computer systems and software such as Microsoft Windows, Microsoft Office (Word, Power Point, Excel, Access, Project, Visio, and others)
  • Tools: Eclipse, Dreamweaver, Rational Rose, Visual Paradigm, Weka, Borland Builder, SQL erver, Visual Studio, PowerBi, Knime
  • Data Science Tools Knowledge (Watson Studio, RStudio, Jupiter Lab)
  • Java: EJB2, EJB3, Eclipse, Visual Studio 2017
  • Good command of relational modeling, SQL, Transact-SQL
  • Professional Certificate: Analysis Skills by Microsoft- 2019
  • Scrum Master Professional Certificate (SMPC) - (English) 2020
  • Data structures knowledge, Data Visualization
  • Problem-Solving
  • Multitasking
  • Reliability
  • Excellent Communication
  • Organizational Skills
  • Team Collaboration
  • Active Listening
  • Task Prioritization
  • Goal Setting
  • Professionalism
  • Agile Methodology
  • Time management abilities

Certification

  • Professional Certificate by Microsoft: Data Analysis: Essential Skills, December 2019, https://credentials.edx.org/credentials/4373895cca694edeb727843aef1753a0/
  • CERTIFICATE of ACHIEVEMENT by Microsoft: Introduction to Data Analysis using Excel, December 2019, https://courses.edx.org/certificates/69a5682a06ad455c8f14ec4485d2d802
  • CERTIFICATE of ACHIEVEMENT by Microsoft: Querying Data with Transact-SQL, December 2019, https://courses.edx.org/certificates/fe350b5e86e646d4a8a014360b7dd46d
  • CERTIFICATE of ACHIEVEMENT by Microsoft: Analyzing and Visualizing Data with Excel, June 2019, https://courses.edx.org/certificates/9be77623fbba44abac1bbf016ca2444a
  • CERTIFICATE of ACHIEVEMENT by Microsoft: DevOps Testing, 2019, https://courses.edx.org/certificates/user/10885825/course/course-v1:Microsoft+DEVOPS200.5x+2T2019
  • CERTIFICATE of ACHIEVEMENT of Achievement By IBM: DS0101EN: Introduction to Data Science, https://courses.edx.org/certificates/3c7905f23188409f98dec15b913d7819
  • CERTIFICATE of ACHIEVEMENT of Achievement By IBM: DS0105EN: Data Science Tools, https://courses.edx.org/certificates/ada03f7f23754d3abdef8e255bd2c0ab
  • Scrum Master Professional Certificate (SMPC) - (English), 10/8/2020

Timeline

Database Analyst

Palm Medical Centers
08.2021 - Current

Database Analyst

RoadTex Transportation
08.2019 - 07.2021

Database assistant

DIRECTV Latin America Procurement Department
04.2018 - 05.2019

Software System Analyst

University of Camaguey
09.2008 - 12.2015

Master's in science Degree in Applied Computer Science -

Camaguey University

Bachelor's Degree in computer sciences -

University of Information Science "UCI"

Similar Profiles

CREATE PROFILE
YULIEN MARTINEZ