• Customer: KFC, HEB• Task Performed:o Accountable for compiling, harmonize analyze and vizualize large data sets coming from multiple sources by mainly using Datorama and Python programming to either transform and store datao Query and extract data to answer key business questions and resolve ad hoc requestso Advise and lead a team of 2 people on data storage, modeling and classificationo Present and propose reporting solutions to the client while finding an… Show more • Customer: KFC, HEB• Task Performed:o Accountable for compiling, harmonize analyze and vizualize large data sets coming from multiple sources by mainly using Datorama and Python programming to either transform and store datao Query and extract data to answer key business questions and resolve ad hoc requestso Advise and lead a team of 2 people on data storage, modeling and classificationo Present and propose reporting solutions to the client while finding an intermediate solution without impacting internal data processeso Collaborate and partner with multiple media investment teams to better consolidate and harmonize platform data which results in cleaner and structured data that allows clients and internal teams to derive insights and make business decisions• Technologies: Python, Datorama, SQL Server Show less

• Customer: Meta• Task Performed: o Worked alongside with Data Engineers to improve the data model used for data delivery to Meta as well as classify all data coming into the data warehouse and finally QA data showcased in the dashboardso Automated a data manipulation process with Pandas in Python which ultimately helped my team have a better understanding of the data by asking impactful questions and deriving insights that impacted business decisionso Complied and enforced… Show more • Customer: Meta• Task Performed: o Worked alongside with Data Engineers to improve the data model used for data delivery to Meta as well as classify all data coming into the data warehouse and finally QA data showcased in the dashboardso Automated a data manipulation process with Pandas in Python which ultimately helped my team have a better understanding of the data by asking impactful questions and deriving insights that impacted business decisionso Complied and enforced Meta’s data governance and reporting policies which helped the team spot discrepancies and errors ahead of time• Technologies: Python, Tableau Show less

•Customers: Post Foods, Aflac•Tasks performed: o Created and QA'd dashboards showcasing key digital marketing metrics and KPIs o Reduced the margin of error for weekly data classifications by automating the process with Pandas and Regex o Derive insights and recommendations from data to present to clients o Mastered the visualization tool Datorama (Salesforce) to upload, govern, model, analyze, map, and visualize data from… Show more •Customers: Post Foods, Aflac•Tasks performed: o Created and QA'd dashboards showcasing key digital marketing metrics and KPIs o Reduced the margin of error for weekly data classifications by automating the process with Pandas and Regex o Derive insights and recommendations from data to present to clients o Mastered the visualization tool Datorama (Salesforce) to upload, govern, model, analyze, map, and visualize data from multiple digital, TV, video and out of home campaigns•Technologies: Python, Datorama Show less

• Managed, executed, and configured an e-commerce store for B2B clients which reduced the margin of error in supplies orders• Manage the migration and construction of supplies databases for a B2B e-commerce store

•Tasks performed: o Analyzed, interpreted, and draw conclusions from suppliers' data that was cross-checked with internal data to identify discrepancies in costs or quantity of productso Extracted and analyzed data from a relational database with SQL programmingoUpdated price database based on cost and quantity analysisoEffectively communicated with other teams within the company to come up with effective solutions to problems regarding contracts, invoices, and payments… Show more •Tasks performed: o Analyzed, interpreted, and draw conclusions from suppliers' data that was cross-checked with internal data to identify discrepancies in costs or quantity of productso Extracted and analyzed data from a relational database with SQL programmingoUpdated price database based on cost and quantity analysisoEffectively communicated with other teams within the company to come up with effective solutions to problems regarding contracts, invoices, and payments disputes•Technologies: SQL server, Superuser Show less

•Customers: Telemundo, Nielsen•Tasks performed: o Worked in collaboration and independently to creatively solve data analysis and data management problems to derive valuable insights through Excel and research Software Q (a software similar to SPSS)o Model data and explained insights through PowerPoint presentations focusing on television trends, brand tracking, and market segmentationo Organized, interpreted, manipulated, and analyzed large amounts of data to facilitate… Show more •Customers: Telemundo, Nielsen•Tasks performed: o Worked in collaboration and independently to creatively solve data analysis and data management problems to derive valuable insights through Excel and research Software Q (a software similar to SPSS)o Model data and explained insights through PowerPoint presentations focusing on television trends, brand tracking, and market segmentationo Organized, interpreted, manipulated, and analyzed large amounts of data to facilitate cross-tabulationso Reduced time in the process of manipulating and organizing data through the use of Microsoft VBA/ Macro Programming and formulas in Excel•Technologies: Excel Macros, Q Software (software similar to SPSS) Show less