Photo of David Cardenas

David Cardenas

SQL Developer

Monterrey
0
Followers
0
Following
I have almost three years of relevant experience in SQL Server for creation of new databases based on requirements, organization of tables, creation of schemas, advanced SQL queries with CTE, UNIONS, JOINS, creation of Views, creation of maintainable Dimensional and Fact tables, creation of Triggers, SSIS, Power Query, Pivot Tables, Power Pivot; experience developing dashboards in Power BI and Tableau, two years of experience in Python and data science toolkit (Pandas, Numpy, MatPlotLib).
I’m very comfortable working with large datasets for different goals such as machine learning, analysis, decision making, cleansing, loading to database, database enhancements, in Agile environment etc. 
Learning: Azure Data Factory & Azure Databricks

Careers

Sr IT Business Analyst

Schneider Electric

Full time02/2023 - 12/2023
  1. Creation of Tableau dashboards
  2. Contribute to other initiatives across multi-cultural teams worldwide.
  3. New Machine Learning developments
  4. Technologies: Python (scikit-learn, KERAS, Pandas), SQL Server, ETL with SSIS, GIT)
Business Intelligence Analyst

Advanced Technology Services

Full time11/2022 - 02/2023
  1. Power BI dashboards creation, connection with DAX Studio, Power Query.
  2. ETL with Power BI Dataflows, SSIS and SQL Server.
  3. Standardization using Python Machine Learning libraries (scikit-learn, NLTK)
Data Integrity Specialist

Advanced Technology Services

Full time04/2022 - 11/2022
  1. Web Scraper Python JSON files.
  2. Processes automation with Power Automate.
  3. ETL with SSIS, SQL Server and GIT.
Data Analyst

Afirme Financial Group

Full time04/2021 - 04/2022
  1. Requirements, development and implementation of a blacklist system using SQL Server and Macros for the Debt Collection Area.
  2. Gantt diagrams.
  3. Data modeling and dashboards with PowerPivot.
  4. Data cleansing with PowerQuery.

Education

Universidad CNCI de Mexico

Computer Science

09/2019 - 08/2022Bachelor's DegreeClass of 2022

My projects

Productivity Predictor (Internal)

No image available

This is a Tableau dashboard developed for a Procurement Community whose datasource (3 million rows) has future productivity predictions using Neural Networks at part number level.

Role: Developer

Completed: 12/2023

Live project: N/A

  1. 1
  2. 2
  3. 3
  4. 4
Skills
Microsoft SQL ServerMicrosoft ExcelSSISPower BIPythonWorking with dataMachine learningGithubTableau
Experience1-3 years
Hourly rate$20/hr
Open to
remote

Similar profiles

  1. no alt text

    Carlos Reyna

    SQL Developer

  2. no alt text

    Ulises Villegas

    SQL Developer

  3. no alt text

    Enzo Fuentes

    SQL Developer

  4. no alt text

    Martha Tassew

    SQL Developer

  5. no alt text

    Shaik Asad

    SQL Developer

astro circleWelcome to Outdefine

A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!

Join for free
astro-hello

Join a community, when you join Outdefine!Connect with 72,000 tech professionals globally.

A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!

Log inJoin for free