Data Analyst Digital Marketing

Rean Rodrigues Boston, MA *********.****@*****.*** 857-***-****

linkedin.com/in/rean-rodrigues github.com/ReanRodrigues EDUCATION

Master of Science in Engineering Management – Northeastern University, GPA 3.7/4.0 Aug ’18 - May ‘20 Coursework: Database Management and Design, Computation and Visualization for Data Analytics, Statistics, Applied Machine learning in Finance, Algorithms for Digital Marketing, Business Model Design and Innovation, Product Development Bachelor of Technology, Mechanical Engineering – Symbiosis International University, India Aug ’12 - May ‘16 SKILLS & CERTIFICATIONS

Databases

Business Intelligence

Programming Languages

Machine Learning Techniques

Data Engineering tools

Certifications

Oracle SQL Developer, MySQL, Microsoft SQL Server, PostgreSQL Tableau, Power BI, Looker, Einstein Analytics (Salesforce), Excel Python, PL/SQL, HTML5, VBA, XSV

Regression, Clustering, Classification, Recommender Systems, ARIMA Microsoft SSIS, Snowflake, AWS - S3, RDS, EC2, Lambda Functions, Git, Heroku Tableau Analyst, Data Warehouse Implementation with Microsoft SQL Server PROFESSIONAL EXPERIENCE

Business Data Analyst Co-op Danfoss Innovation Accelerator, Cambridge Sept ‘19 - Dec ‘19

− Created optimized SQL queries for ad hoc analysis of sales data to uncover $10M worth of investment opportunities

− Built automated Tableau dashboards to extract growth patterns, showcase core sales metrics and deliver data-driven insights

− Developed Python scripts to scrape data from 10 disparate data sources and identify potential customer segments

− Led the analysis for scalable and tactical recommendations to boost sales volumes and increase the market share by 12%

− Streamlined the processing of sensor data by writing automation scripts in Python saving the team 48 hours every month Data Analyst Dana Incorporated, India Aug ‘16 - Jul ‘18

− Redesigned the system for analyzing customer requirements through SQL queries and improved turnaround time by 27%

− Built interactive, self-service dashboards on Tableau to track KPIs and provide ongoing insight to business stakeholders

− Collaborated with 7 cross-functional stakeholders to identify root causes of issues and deliver data-informed decisions

− Transformed business requirements into technical design documentation to address client’s analytical needs

− Conducted market opportunity analysis to identify profitable business segments to boost annual profits by 10 DATA ANALYTICS PROJECTS

US Electoral System Database Design SQL Developer, Oracle database server, Oracle SQL model Mar ‘19 - Apr ’19

− Built a relational database containing voter and candidate information on Oracle SQL based on predefined business rules

− Optimized query execution and created Triggers, Views, Stored Procedures on the dataset to control the election process Marketing Analysis Insights App - Alibaba Salesforce – Einstein Analytics Jan ’20 - Feb ‘20

− Created dataflow diagrams to combine 15 different tables into a single OLAP cube in Salesforce for efficient data reporting

− Built real-time automated dashboards to monitor sales distribution by regions, vendors, and products

− Forecasted 3, 6 and 12 months of sales using historical sales data to optimize inventory management by 15% Automated ETL using AWS Lambda EC2, S3, Lambda, CloudWatch, Python May ‘19 - Jun ‘19

− Created an EC2 instance on Ubuntu Server, installed dependencies and exported it to an S3 bucket

− Designed Lambda functions and wrote Python Scripts to Extract, Transform and Load CSV files into an S3 bucket

− Created rules on CloudWatch to automatically run the function everyday and generate reports as per business use case Customer Segmentation for a game streaming website Matplotlib, Plotly, Streamlit, SciKit Learn May 20’ - Jun ‘20

− Evaluated Recency, Frequency and Engagement metrics to analyze consumer usage patterns for a game streaming website

− Developed a K-Means clustering model to profile customers into segments and improve customer lifetime value by 8%

− Created a Streamlit application to visualize results enabling data-driven marketing and deliver strategic recommendations Game recommendation application for Streamers Python, PostgreSQL, Amazon RDS, Heroku Apr ’20 - May ‘20

− Developed Python scripts to ping the Twitch API to pull in the live stream data from the Twitch website

− Funneled the data into a PostgreSQL database using Amazon RDS services and connected it to python for analysis

− Created recommendation model for streamers using the surprise package on python and deployed the application on Heroku

Contact this candidate