Experience

Act Digital Consulting

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Data Analyst

  • Mar 2020 - Present

  Chicago, Illinois, United States • Conducted review meetings with the client for the proper implementation of the model using AWS EC2. • Built a model to predict CPM for social media ad targeting using KNIME and Python. • Developed live dashboards in Tableau to analyze and increase profits from digital marketing. • Performed EDA on 15-month demographics (through April 2019) to obtain CPM (cost per mile) information. • Created three different pricing models using Linear Regression, Random Forest, and Gradient… Show more • Conducted review meetings with the client for the proper implementation of the model using AWS EC2. • Built a model to predict CPM for social media ad targeting using KNIME and Python. • Developed live dashboards in Tableau to analyze and increase profits from digital marketing. • Performed EDA on 15-month demographics (through April 2019) to obtain CPM (cost per mile) information. • Created three different pricing models using Linear Regression, Random Forest, and Gradient Augment Tree. • The Gradient Boosting method achieved 96.7% accuracy on the real model after validating it with a new data set. • Optimized SQL stored procedures and reduced their execution time from 37 minutes to 4 minutes and 17 seconds. • Handled grossly unbalanced data through cross-validation and the combined use of SMOTE and ENN. Show less



Cendyn

• United States
• Software Development
• 400 - 500 Employee

• Data Analyst

  • Aug 2018 - Jul 2019

  Boca Raton, Florida, United States • I enabled my associates to be more productive by automating their tasks with VBA macros in Excel. • Ensured that SAP module updates could be validated by developing automated tests with HP software. • Reduced company equipment leasing costs by creating an asset tracking database with Microsoft Access. • Ensured timely implementations of SAP modules by assisting the project management team during outages. • I avoided shipping delays by correcting supply chain problems that were… Show more • I enabled my associates to be more productive by automating their tasks with VBA macros in Excel. • Ensured that SAP module updates could be validated by developing automated tests with HP software. • Reduced company equipment leasing costs by creating an asset tracking database with Microsoft Access. • Ensured timely implementations of SAP modules by assisting the project management team during outages. • I avoided shipping delays by correcting supply chain problems that were discovered by the SQL queries I wrote. • Greater efficiency by converting handwritten processes into workflows using GE, HTML, and CSS tools. • Increased my bandwidth by automating time-consuming Excel and Access reports with VBA-driven macros. Show less