Juan Camilo E.
General Motors - Data Analytics & Optimization Consultant @Kin Carta
Signup · Get unlimited contacts
WORK HISTORY
General Motors - Data Analytics & Optimization Consultant @Kin Carta
Led the architecture and development of advanced data analytics solutions to drive brand marketing performance and customer insights for General Motors. Designed scalable ETL workflows with Power Query, integrating diverse data sources and ensuring high data quality to support data-driven decisions aligned with marketing strategies.Queried structured datasets directly from the Databricks data catalog using SQL, enabling seamless integration with Power BI and reducing latency in reporting pipelines. Developed optimized semantic data models and advanced DAX calculations to support scenario simulations, forecasting, and trend analysis.Created dynamic and interactive Power BI dashboards, applying effective data visualization techniques to communicate key insights, analyze campaign performance, and optimize media efficiency. Partnered with GM marketing stakeholders to automate the delivery of prescriptive analytics, enhancing the agility of strategic decision-making processes.Led the migration of Excel-based reports to scalable, governed Power BI solutions, incorporating site traffic and clickstream data across GM’s T1, T3, and third-party platforms to improve user journey optimization and channel attribution modeling.Published dashboards through Power BI Service, implementing role-based access and security controls to ensure compliance and enable cross-functional collaboration.Key Achievements- Integrated Databricks SQL queries directly into Power BI, streamlining access to curated datasets- Replaced manual Excel workflows with automated analytics dashboards for marketing intelligence- Enabled advanced marketing performance simulations and forecasting to support strategic planning.
EDUCATION
Pontificia Universidad Javeriana
Citizen Data Scientist, Data Science
Universidad Nacional de Colombia
Systems Engineer, Machine Learning
University of Buenos Aires
International interchange, Industrial Engineer
Project Management Institute
Project Management Professional, Project Management
Universidad de Los Andes
Master in Information Engineering, Data Science | Business Analytics | Data Analysis | Data mining | Machine Learning
Universidad de Los Andes
Advanced Topics in Project Management, Project Management
Universidad del Rosario
Management skills, entrepreneurship and innovation, Executive Management
Universidad Nacional de Colombia
Diploma in Autonomous and Significant Learning Strategies in Engineering, Pedagogy
Universidad Nacional de Colombia
Magister in Industrial Engineering, Industrial Engineering | Data mining | Transport | Machine Learning | Logistic
SKILLS
ABOUT JUAN CAMILO E.
Professional with twelve years of experience in Business Analytics, specializing in Machine Learning and Deep Learning technologies. Proficient in PMI methodology for project management, CRISP-DM for advanced data analysis, and DAMA for Data Governance. Exceptional skills in handling and analyzing large data sets, coupled with a proven track record of leading Agile projects.Abilities for leadership of agile projects: shield the team from distractions and interferences, enforcing rules to ensure the correct use of the scrum process, remove impediments, be a servant leader, negotiation skills, team leadership, active listening, adaptation to change, and Machine Learning Deep learning: Multilayer Perceptron, Convolutional Neural Network, Autoencoders, Recurrent Neural Networks, Transfer Learning, Fine Tuning- Classification: Decision Trees, K-NN, Naïve Bayes, Random Forest, Neural Networks, Logistic Regression, SVM- Ensemble: Voting (Hard, Soft), Boosting (XGBoost, LightGBM, CatBoost), Bagging, Stacking- Clustering: K-means, DBSCAN, Agglomerative clustering- Regression: Linear, Lasso, Ridge- Association rules: FP-Growth- Validation: split validation and cross validation- Data preparation: one hot encoding, normalization, binning, feature selection, data cleaning- Text mining: remove stop words, tokenization, stemming, lemmatization, TF-IDF, sentiment analysis- Hyperparameters tuning: grid Skills Data mining and machine learning tools like: Scikit-Learn (Python), Anaconda Framework, Rapiminer, Rapidminer Server, Weka, Watson Analytics and SPSS- Notebooks: Colab, Jupyther, Zeppelin- Cloudera (Big data): hive, impala, sqoop, PySpark, SparkML, SparkSQL- Hortonworks: Ambari, YARN, PySpark- Design and management of database in SAP IQ, MySQL, PostgreSQL and Oracle engines- Data modeling in tools like: SAP Power Designer, Vertabelo- Data preparation tools like: Pandas (Python), SAP Data Services, Pentaho Data Integration- Data visualization in Tableau, Power BI, TIBCO Spotfire and D3.js- Deep Learning: Keras- Text mining in rapidminer and NLTK (Python)- Git tools: GitHub, BitBucket, GitKraken- Code editors: Notepad++, Visual Studio Code, PyCharm- Boards: Trello, Planner, Azure DevOps, Jira- AWS: EC2, S3, RDS, EFS, Lambda, Dynamo, IAM, CloudFront- GCP: Compute Engine- Azure: SqlServer, Azure Data Factory, HDInsights, Data Lake Storage V2, Azure Databricks, Azure Synapse, Azure Open AI- Generative tools: ChatGPT, Dall-E, Bard
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.