-
Johnson & Johnson, Boston, MA
June 2023 — Dec 2023
Data Analyst
● Achieved an 8% increase in user conversion rates through the seamless analysis of real-time data using Connectors (API), BigQuery, and Google Analytics; crafted impactful Power BI dashboards to visualize results.
● Optimized receivables aging by reducing balances in the 90+ days bucket to the 0-30 days bucket through data-driven analysis and forecasting. Leveraged SAP systems to enhance collections, streamline reconciliation, and improve cash flow.
● Designed user-friendly Tableau dashboards that delivered actionable insights on customer engagement, leading to improved decision-making processes across marketing, sales, and ops, resulting in a quarterly revenue increase of 4 million USD.
● Developed 10+ MicroStrategy dashboards and targeted email campaigns, facilitating a transition from state-based to zone-based supply chain management, enhancing demand forecasting accuracy by 15% and boosting operational efficiency.
● Implemented a machine learning model leveraging Gradient Boosting and XGBoost, analyzing 5000+ customer
-
Wipro Technologies, Chennai, India
July 2021 — July 2022
● Optimized and streamlined Big Data models using Airflow, DBT Cloud, S3, Python, and SQL for ETL/ELT processes with product sales data, enhancing hive/presto systems scalability efficiency while cutting operational costs by 20%.
● Developed and deployed Tableau dashboards utilizing SQL, DBT, and Looker; analyzed subscription revenue trends which led to optimized offer allocation resulting in a measurable 10% sales uplift across omni-channel strategies.
● Created comprehensive P/L dashboards leveraging Splunk and the ELK stack that integrated budgets alongside forecasted sales figures; utilized A/B testing strategies which led to an impressive 15% increase in customer retention rates.
● Retained 6+ clients by optimizing database performance using 20+ SQL logics and insights from Economics and Finance stakeholders, improving user satisfaction ratings from internal stakeholders and query response times by over 40%.
● Achieved a 4x ROI by designing and executing data-driven campaign strategies that integrated insights from brand marketing, finance, legal, and delivery teams within the retail sector.
-
Newton Cloud Computers, Chennai, India
Jan 2019 — Dec 2020
Data Analyst
● Established data lakes using BigQuery, Snowflake, and Redshift to ensure data accuracy and reduce redundancy by 20%.
● Automated complex ETL processes with Python, SQL, and SAS through Azure Data Factory, streamlining workflows by 70%.
● Designed dynamic dashboards using Power BI and SAS Visual Analytics, improving decision-making and operational efficiency by 25%.
● Engineered forecasting models using Azure Machine Learning and SAS analytics, optimizing resource allocation by 20%.
● Ensured compliance with HIPAA and HITECH guidelines, securing health data integrity and privacy.
● Reduced manual data handling by 70%, increasing data consistency across departments through automated workflows.