Data analyst

YAXAL ARENAS MSc, Lean Six Sigma Green Belt

647-***-**** / Oshawa L1J 5H3 Ontario / *****.******@*****.***

PROFESSIONAL SUMMARY

Multilingual Technical analyst with a BSc and MSc. An extensive background in database management: proficient in creating reports and visualizations, operations improvement and analytical tools for effective relational modeling, data analysis and scripting. Ability to master new applications, languages and, technologies quickly. Excellent communication skills, positive attitude, and a strong team player.

HIGHLIGHTS OF SKILLS AND EXPERIENCE

oInterpreting and analyzing data sets

oResults and Target Orientated

oExperienced in cross-functional teams

oExcellent Presentation Skills

oAgile methodologies, Lean and Six Sigma, operation improvement

oProject management and stakeholder management

oAbility to prioritize in stressful environments

oAnalytical thinker yet flexible and resourceful

oMaintains high levels of confidentiality

oStrong interpersonal and communication skills - English, Spanish; intermediate French

TECHNICAL SKILLS

oRelational databases and scripting SQL

oDevelopment, modification, maintenance and data mapping using SQL, AWS, Node.js,

oUnstructured databases: MongoDB

oMachine learning models and Statistical Analysis of big data, AWS and Hadroop

oAutomation of data extraction and manipulation, BI Analysis & Reporting

ounderstanding of QA and testing methodologies and testing tools

oMicrosoft Excel: VBA creation modification of complex macros, pivot tables, VLookups, advanced formulas

oData visualization, PowerBI and custom reports, plots and animations using D3.js

oAdvanced MS Office: 360, Excel (macros, pivot tables and VBA), Word,

oPowerPoint decks, reports and macros

oFond end and back end technologies

WORK EXPERIENCE

Analyst II, Concentrix, Oshawa, Ontario February 2020 to February 2021

oUse of CRM system, Excel and internal sql database to create reports and case handling information

oWrite SQL queries to obtain information from sales and transfers data to create improvement reports

oPerformed daily Excel reports to enhance business impact and customer satisfaction

oListened to needs and concerns, took notes and created appropriate reports

oProvided service support and resolution of non-routine problems

oDetermined customer needs through effective questioning and research, while maximizing opportunity to build rapport with the customers, members, businesses, and dealers

Data Analyst, dynaCERT, Toronto, Ontario January 2019 to July 2019

oReduced monthly billing by $500 by comparing SQL and unstructured databases to find unused phone Sim cards

oWrote SQL queries involving multiple tables to merge data and retrieve elements with unique information

oWrote and modified queries intended to improve the reports and to adjust for changes in the financial department load

oModified SQL procedures that control the automatic run time of queries in SQL to produce daily reports

oCreated events in the information schema of the database for continuous delivery of daily, weekly and monthly reports

oDesigned and performed data extraction, pre-processing and optimization

oCreated a visualization from SQL data to show time progression of expenses in the research sector

oPerformed complex quantitative analysis using Python to enhance business impact

oCreated a query to automate searches in SQL relational databases from 24hrs to 30 minutes

oPerformed collection, organization and statistical analysis of data to identify and make recommendations for operation improvement

oCreated visualizations using node.js and javascript to communicate results with stakeholders, using specialized reports showing the billing for each account and business avenue

oMonitored, synthesized, presented information and generated reports for the Accounting/finance and the engineering departments on a weekly, monthly, and quarterly basis using VBA and pivot tables in Excel, PowerBI from a MySQL live data stream

oCreated work flow analysis, and system and data map that prompted a re-structuring of the database management for one of the accounts

oAssisted managers with KPI’s and project management, creation of policy manuals,

oCommunicated and collaborated with cross-functional teams to acquire requirements for projects and reports

Data Analyst, Last Call Analytics, Toronto, Ontario August 2018 – December 2018

oWrote multi-database queries to retrieve information from different income stamens, sales revenue and SQL tables, using complex and nested queries and joints decreasing post processing time in Excel. Successfully decreased the post processing time form 1 day per report to 1h per report. (Reports were produced monthly for multiple entities, multiple pages and plots and mixed datasets)

oDeveloped reports from SQL raw data into Excel reports to identify, understand and capture consumer purchase behavior and trends to increase sales and business growth

oMonitored, synthesized, presented information, and generated reports on a weekly, monthly, and quarterly basis using advanced functions, VBA and pivot tables in Excel

oWrote and modified sql queries to troubleshoot lack of communication with the server or to improve the time delivery and automation of the reports

oQA tasks, maintained and analyzed problem logs to identify and report recurring issues to management and production team

oQA tasks, carefully maintained complaint and nonconformance processing through records and tracking systems, including root cause

oMade adjustments, and customizing Excel reports depending on the sales agent and region

oPerformed design, data extraction, pre-processing, data exploration, database model building, model adaptations and optimization of SQL and Excel sources

oPerformed automation tasks and data acquisition from pdf and JSON files using Node.js (javascript) to make data usable and transferable to SQL or Mongo DB.

oWas able to decrease the processing time from 2h to 15 min for the pdf data acquisition creating an automated system to read the data from a pdf into SQL using commands from Excel to call the sql database directly and node.js to make the preprocessing

oCreated an automated flow to input data from Excel files stored in AWS buckets into SQL database

Data analyst and web developer NickyNames.com, Toronto, Ontario January 2016-July 2018

oDesigned, implemented and tested databases in customers’ servers and SQL database repositories

oWrote queries inside of php for SQL to acquire data from webpages and input it onto the sql databases

oDatabase design, data extraction, pre-processing, data wrangling, data exploration, model building

oCreated visualizations including maps, time line plots, earnings and market trends using d3.js.

oMaintained SQL server based databases and AWS buckets that contained customer data

oCreated visualizations to identify consumer purchase behavior, trends, and sentiment for business growth, applied to realtors’ housing market data and to website purchases. Continuous work with HTML and javascript.

Scientist/Functional Manager Assistant Theralase MaRS - UHN, Toronto, Ontario May 2014-October 2015

oCreated detailed plans and accurate estimates towards developing and testing projects

oProduced and tracked budgets, project plans, process flow-charts, KPI’s/dashboards that enabled the creation and approval of a medical probe

oAssisted managers with KPI’s and project management, provided training in 5S-Lean process improvement

oCommunicated and collaborated with cross-functional teams, led junior technical staff and placement students

oCreated, systems testing procedures, SOP, quality and policy manuals and

oTracked technological and business driven trends; developed predictive and descriptive models

oCreated project plans by acquiring stakeholders’ requirements, tracked budgets and requirements for a multidisciplinary team (in different areas in Canada and China).

EDUCATION

BSc. Physics University of Las Americas Puebla (UDLAP) 2007

M.Sc. Physics/Optics National Institute of Astrophysics Optics and Electronics 2011

Lean Six Sigma GB YDelay Toronto 2017

Machine learning University of Toronto 2019

Contact this candidate