Nelson Correia
Data Team Lead at Tekside.iO- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Portuguese -
Topline Score
Bio
Credentials
-
Essential Design Principles for Tableau
CourseraOct, 2022- Nov, 2024 -
Doing More with SAS Programming
CourseraJul, 2022- Nov, 2024 -
Getting Started with SAS Programming
CourseraJun, 2022- Nov, 2024 -
Introduction to Microsoft Azure Synapse Analytics
CourseraJun, 2022- Nov, 2024 -
Fundamentals of Visualization with Tableau
CourseraFeb, 2022- Nov, 2024 -
Tools for Data Science
CourseraSep, 2021- Nov, 2024 -
What is Data Science?
CourseraAug, 2021- Nov, 2024
Experience
-
Tekside.iO
-
Canada
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Team Lead
-
Sep 2018 - Present
- Managing small team providing guidance on various data projects - Transitioning the team from legacy software to newer technologies - Developing and optimizing SQL Stored Procedures, SQL Jobs, Table Schemas and Indexes - Monitoring MSSQL and MySQL databases using Solarwinds DPA and acting on tuning recommendations - Automating Data Integration processes to improve overall turnaround time using Pentaho ETL software - Generating reports and data visualizations via SQL, Metabase… Show more - Managing small team providing guidance on various data projects - Transitioning the team from legacy software to newer technologies - Developing and optimizing SQL Stored Procedures, SQL Jobs, Table Schemas and Indexes - Monitoring MSSQL and MySQL databases using Solarwinds DPA and acting on tuning recommendations - Automating Data Integration processes to improve overall turnaround time using Pentaho ETL software - Generating reports and data visualizations via SQL, Metabase and MS Excel that allow clients to make timely and vital decisions - Standardized the documentation process for projects built using Pentaho ETL software - Designing dashboards through Metabase to display relevant and insightful data - Working with development team to on-board new clients on internal Reporting platform that serves clients email performance metrics - Collaborating with clients and understanding requirements to provide custom solutions for their data needs - Modeled databases, creating ERD diagrams for current systems and designing new databases for client projects Show less - Managing small team providing guidance on various data projects - Transitioning the team from legacy software to newer technologies - Developing and optimizing SQL Stored Procedures, SQL Jobs, Table Schemas and Indexes - Monitoring MSSQL and MySQL databases using Solarwinds DPA and acting on tuning recommendations - Automating Data Integration processes to improve overall turnaround time using Pentaho ETL software - Generating reports and data visualizations via SQL, Metabase… Show more - Managing small team providing guidance on various data projects - Transitioning the team from legacy software to newer technologies - Developing and optimizing SQL Stored Procedures, SQL Jobs, Table Schemas and Indexes - Monitoring MSSQL and MySQL databases using Solarwinds DPA and acting on tuning recommendations - Automating Data Integration processes to improve overall turnaround time using Pentaho ETL software - Generating reports and data visualizations via SQL, Metabase and MS Excel that allow clients to make timely and vital decisions - Standardized the documentation process for projects built using Pentaho ETL software - Designing dashboards through Metabase to display relevant and insightful data - Working with development team to on-board new clients on internal Reporting platform that serves clients email performance metrics - Collaborating with clients and understanding requirements to provide custom solutions for their data needs - Modeled databases, creating ERD diagrams for current systems and designing new databases for client projects Show less
-
-
-
Inbox Marketer, now part of Shift Paradigm
-
United States
-
Advertising Services
-
1 - 100 Employee
-
Data Analyst
-
Feb 2015 - Sep 2018
- Create and optimise SQL Stored Procedures - Generate reports that allow clients to make timely and vital decisions - Migrated Reporting systems data via Pentaho ETL Software - Assisted in designing and implementing Data ETL automation - Automate processes to improve turnaround time using Pentaho ETL Software - Collaborate within internal team in Agile team structure - Primary Data Team resource for new team members - Create and optimise SQL Stored Procedures - Generate reports that allow clients to make timely and vital decisions - Migrated Reporting systems data via Pentaho ETL Software - Assisted in designing and implementing Data ETL automation - Automate processes to improve turnaround time using Pentaho ETL Software - Collaborate within internal team in Agile team structure - Primary Data Team resource for new team members
-
-
-
Second Foundation Consulting
-
Canada
-
Software Development
-
1 - 100 Employee
-
IT Support
-
Sep 2014 - Dec 2014
- Assisted with the installation of operating systems and end user application software - Transitioned servers and network into new building during a major move - Responsible for the day to day procedures of system backups - Created a SQL stored procedure to notify employees of overdue tickets via email - Assisted with the installation of operating systems and end user application software - Transitioned servers and network into new building during a major move - Responsible for the day to day procedures of system backups - Created a SQL stored procedure to notify employees of overdue tickets via email
-
-
-
Brock Solutions
-
Canada
-
Automation Machinery Manufacturing
-
500 - 600 Employee
-
Software Programmer
-
Jan 2014 - Apr 2014
- Developed on software projects for Ottawa International Airport - Designed and implemented custom SQL Server Reporting Services reports for customers - Built web pages for the customer’s ASP.NET web client - Developed on software projects for Ottawa International Airport - Designed and implemented custom SQL Server Reporting Services reports for customers - Built web pages for the customer’s ASP.NET web client
-
-
-
Walmart
-
United States
-
Retail
-
700 & Above Employee
-
Merchandiser
-
Aug 2010 - Dec 2013
- Stock shelves with new product ensuring product rotation in areas such as dairy - Ensure area is clean and safe for associates and customers - Assist in all areas when needed including the receiving area, organizing product received on truck and then bringing out to specific department - Stock shelves with new product ensuring product rotation in areas such as dairy - Ensure area is clean and safe for associates and customers - Assist in all areas when needed including the receiving area, organizing product received on truck and then bringing out to specific department
-
-
-
Sam's Club
-
United States
-
Retail
-
700 & Above Employee
-
Merchandiser
-
Sep 2006 - Apr 2010
- Merchandised to the company’s high standards - Handled the training of new associates - Became a Team-Lead for area’s night crew with the responsibility of prioritizing tasks for fellow employees and ensuring products were positioned in areas that allowed for best sales - Merchandised to the company’s high standards - Handled the training of new associates - Became a Team-Lead for area’s night crew with the responsibility of prioritizing tasks for fellow employees and ensuring products were positioned in areas that allowed for best sales
-
-
Education
-
2011 - 2014
Conestoga College
Computer Programmer/Analyst, Information Technology
Community
