Deepak Nayak Email & Phone Number

Los Angeles, Ca, Us

California, United States

Remote, Usa

Extracted over 1 million transactional records from POS and e-commerce systems for Market Basket Analysis using SQL and Python (Pandas), apply data wrangling methods, like filtering and aggregation, for data accuracy and consistency. Conducted EDA using Python libraries like Seaborn for statistical visualizations (e.g., histograms, box plots) and Plotly for interactive charts these visualizations uncovered trends and purchasing patterns, improving insight of customer behavior. Utilized Python’s MLX tend library for association rule mining, generating over 50 actionable rules based on frequent itemset, and identified product relationships that led to a 20% increase in effective cross-selling and bundling strategies. Developed a recommendation engine on Market Basket Analysis findings, resulting in boost in customer engagement, and integrated recommendations into targeted marketing campaigns, leading to a 10% gain in conversion rates. Employed SQL for data extraction, aggregation, and complex querying, and prepared data for analysis and reporting in Power BI, ensuring accuracy in 15+ comprehensive reports and dashboards. Created dashboards and visualizations in Power BI to monitor the impact of recommendations, using AWS S3 for efficient data storage and retrieval, improving data access speeds by 40% and refining strategies based on performance analytics.

Mumbai, India

Conducted a wide ETL process optimization project, focusing on data extraction, transformation, and loading, improving data accuracy and processing, easing processing time and resulting in faster and more reliable data analysis. Employed Python (Pandas and NumPy) for automating data processing tasks, streamlining repetitive data handling and analysis workflows, improve data management by 20%, allowing for a greater focus on complex analytical tasks. Developed and optimized complex SQL queries for data extraction and transformation, improving data accuracy and reliability by 30%, and used queries to handle and analyze large datasets, managing data storage solutions using AWS S3. Participated in data validation and testing activities, including User Acceptance Testing (UAT), to verify report accuracy and completeness, and achieved a 30% reduction in errors through prompt resolution of discrepancies. Migrated and integrated data from on-premises Teradata to Google Cloud Platform (GCP), utilizing BigQuery and Dataflow, and ensured seamless access to data for analysis and reporting, contributing to streamlined data workflows. Generated and delivered comprehensive reports using SQL BTEQ scripts, Power BI, and Fast Export, and ensured timely availability of critical business insights and improved reporting efficiency by 20%. Conducted in-depth data analysis and visualization using Power BI, using refined features like DAX and Power Query, and created dynamic dashboards and reports, which provided actionable insights and improved business decision-making.

Masters Of Science In Information Systems, Business Analytics

Bachelor Of Engineering - Be, Computer Engineering