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