Data Analyst Power Bi

Akash Ganesan

USA 857-***-**** *****.***********@*****.*** LinkedIn

SUMMARY

Data Analyst with 4 years of experience in data modeling, product and market analysis, predictive modeling, and process optimization, delivering a 20% revenue increase and a 45% efficiency boost. Proficient in Python, SQL, and Power BI, Tableau, applying data insights to enhance workflows and drive strategic decisions EXPERIENCE

Johnson And Johnson, Boston, MA Jun 2023 – Dec 2023 Data Analyst Co-op

• Reduced 90+ day overdue balances by 60% through data-driven negotiation strategies, strengthening client relationships and improving cash flow

• Built Power BI dashboards to analyze market trends and purchasing patterns, driving strategic product placement and boosting revenue recognition by 30%, adding $4M in quarterly revenue

• Engineered advanced Alteryx workflows for complex ETL processes, integrating data into an AWS Redshift data lake using OBT data modeling approaches for streamlined structures and optimized query performance

• Developed a time series analysis model using LSTM to predict customers' month-end landing balances, enabling tailored strategies that improved cash flow management and reduced average receivable days by 15% Wipro Technologies, Chennai, India Jul 2021 – Jul 2022 Data Engineer

• Engineered ETL/ELT workflows with Spark, Kafka, Python and Airflow, boosting data scalability by 30% and cutting operational costs by 20%

• Designed Tableau dashboards leveraging Hive and SQL Server to uncover actionable insights from call and usage patterns, driving a 12% revenue increase through data-backed marketing offer

• Set up real-time monitoring with Prometheus and Grafana to evaluate network performance and user behavior, boosting customer retention by 18% via targeted A/B testing

• Performed in-depth market analysis to refine product strategies, achieving a 10% increase in ARPU and a 3x ROI on targeted campaigns

Newton Cloud, Chennai, India Jan 2019 – Dec 2020

Data Analyst

• Developed Power BI dashboards with advanced DAX measures to monitor credit risk and operational metrics, leading to a 15% drop in default rates

• Implemented dimensional data models and data marts in Snowflake tailored for credit and risk analysis, optimizing data retrieval and ensuring consistent reporting for compliance and performance monitoring

• Streamlined the ingestion of critical risk data into Snowflake through automated pipelines utilizing Apache Airflow; improved both the speed and precision of data delivery by 25% for better decision-making processes

• Conducted in-depth data analysis on financial anomalies and trends, leveraging Python and Power BI to uncover key risk factors and drive data-informed credit risk management strategies TECHNICAL SKILLS

• Databases: PostgreSQL, Redshift, Big Query, MySQL, SAP HANA, SQL Server, Cassandra

• Programming languages: R, Python, SQL, DAX, TypeScript, Java, Spark

• Data Visualization Tools: SAS, Power BI, Tableau, Grafana, Matplotlib, Plotly, Looker

• Workflow Tools: Airflow, DBT, Excel VBA, SAP, Talend, Alteryx, Ab Initio, Palantir Foundry

• Cloud: AWS, GCP, Azure, Snowflake, Databricks

• Machine Learning: Keras, TensorFlow, Pandas, NumPy, Seaborn EDUCATION

Northeastern University Boston, MA

Master of Science in Data Analytics Engineering Sep 2022 - Dec 2024 Anna University Chennai, India

Bachelor of Engineering in Computer Science Jun 2017 - May 2021 PROJECTS

Customer Segmentation for an Online Store Kafka, Spark, Python, Postgres, Power BI Sep 2024 – Dec 2024

• Built machine learning models (Naive Bayes, Logistic Regression, SVM, Neural Networks) on AWS to analyze consumer behavior and optimize product recommendations

• Achieved a 25% improvement in predictive accuracy, uncovering key market trends and driving data-driven directed marketing strategies. Leveraged Power BI to visualize customer clusters, enabling precise promotional strategies and enhancing customer retention

Contact this candidate