Post Job Free

Resume

Sign in

Data Analyst Digital Marketing

Location:
Manhattan, NY
Posted:
October 05, 2023

Contact this candidate

Resume:

https://www.verify-resume.org/verify/oSqcyifpyqkIlmzmUHBn

RAKESH CHOUDHARY

New York City, NY, US adz6nt@r.postjobfree.com 857-***-**** linkedin.com/in/rakeshchoudharyd/ EXPERIENCE

Data Analyst

Horizon Media June 2022 - Present, US, NY, New York

• Achieved a 23% ROI improvement on digital marketing spending by developing marketing mix models and MTA using SQL and Python, resulting in savings of over $500,000.

• Optimized 25 Tableau reports using custom SQL queries, reducing loading time from an average of 30 seconds to less than 5 seconds, enhancing productivity and enabling real-time data access.

• Led impactful A/B tests on website landing pages, resulting in a 30% CTR increase and a 20% boost in conversion rates, translating to a substantial revenue increase.

• Implemented real-time reporting on Swivel, saving 210 monthly hours of manual reporting, and standardising metrics across the team, increasing operational efficiency by over 25%.

Business Intelligence Analyst

Eversource Energy June 2021 - June 2022, US, MA, Boston

• Increased visibility into the marketing pipeline by 78% by creating 18 reports using Power BI and SQL queries, enabling better-informed decisions.

• Proposed segmentation analysis, leading to a 20% consumption tracking increase and added a $300,000 revenue boost towards EV projects.

• Attained 25% growth in revenue and customers over the year by collaborating with stakeholders and designing a new data warehouse.

• Identified areas for demand response programs by analyzing energy consumption data, resulting in a 30% increase in saving $400,000 in charges and ensuring sustainability.

Business Analyst

Hari Om Marble & Granite June 2018 - July 2019, Coimbatore, IN

• Orchestrated productive meetings with project teams, resulting in a 15% reduction in project development timelines, and ensured clear project objectives with a 98% stakeholder satisfaction rate.

• Led cross-functional teams to document requirements, reducing project timelines by 15% and achieving an annual cost savings of $500,000.

• Managed end-to-end project lifecycles, achieving a consistent 20% faster completion time compared to industry benchmarks, resulting in 12 successful projects per year.

• Resolved system issues, reducing downtime by 25%, and improved project success rates by 10%, resulting in an additional $1 million in revenue and cost savings.

Data Analyst

Accenture May 2017 - July 2018, Bangalore, IN

• Facilitated collaboration across teams to establish standardized data, metrics, and dashboards in Tableau and Excel, driving informed decisions for 8 business/product stakeholders' leadership teams.

• Leveraged SQL and Python to analyze large datasets, unveiling trends and correlations that led to a 10% improvement in site engagement, enhancing user experience.

• Elevated OLAP cubing, enhancing reporting tools, and reducing report generation time by 20%, improving data accessibility.

• Crafted and delivered 30+ reports and dashboards using advanced Excel skills and data visualisation tools like Tableau, contributing to a 15% increase in data- driven decisions and a 25% reduction in reporting turnaround time. EDUCATION

Master's in Data Analytics

Northeastern University • Boston, MA • 2021

Bachelor of Technology in Electronics and Communication Kumaraguru College of Technology • Coimbatore, India • 2017 SKILLS

Programming Languages: SQL, Python, R, C/C++, VBA

Databases/Data Warehouse: Amazon Redshift, S3, Snowflake, Google Big Query, Scala, SPSS, DBeaver, Azure Data Factory, PostgreSQL Data Visualization Tools: Tableau, Tableau Prep, Power BI, Google Charts, Advanced Excel, Swivel, Superset CRM/PM Tools: Salesforce, SAP, Microsoft Dynamics 365, Oracle NetSuite, Asana, Agile Methodology Big Data/ETL Tools: Microsoft Azure, Hadoop, Apache Spark, Data Built Tool (DBT), Dataiku DSS, Apache Airflow, GCP, Azure Databricks



Contact this candidate