Ekta Kulkarni Email & Phone Number

Alpharetta, Georgia, Us

Stockholm, Se

• Extracted data in Power BI through Excel and designed Weekly Accessories WebShop Retention Dashboard through which we can map below things:o Customer Journey/ Customer Behavioro Top Customers by Orderso Top Customers by Revenueo New Customers• Built customized measures using DAX in Power BI to determine drop-out customers which are being used to improve Customer Retention.• Developed and automated Python program which converts raw XML files to analytics-ready Excel data.• Analyzed web data and prepared Monthly WebShop Reports which primarily includes Monthly Revenue, YoY trend, and Webshop Contribution.• Designed dashboard in Power BI to determine the effectiveness of the QuickShip and Promo-code programs.• Collaborated with BI team and developed OLAP cube in SSAS to connect with real-time data in the database.• Integrated SQL Server database with Power BI and performed ETL processes using Power Query to transform and prepare data for analysis• Connected to live database using DirectQuery connectivity mode in Power BI and mined insights around Overall Vs Online Sales and time-series analysis.

Plano, Texas, Us

• Implemented topic modeling using natural language processing techniques on unstructured finance data • Designed and developed ETL data pipelines and built dimensional data model to identify trends, patterns and anomalies in financial dataset• Built SQL scripts to load data into fact and dimension table and created OLAP cube using SSAS platform• Designed dashboards utilizing VIVE business intelligence tool to uncover insights of banking industry for last 10 years

San Francisco, California, Us

• Extracted data from property portals using Scrapy, analyzed and reported to target potential roof customers• Performed data cleaning operation on web scraped data using machine learning libraries and SQL to boost data quality • Optimized accuracy of object detection & image segmentation model to 83% to detect roof damage appropriately• Generated and automated reports using Python and Tableau by collection of image and textual data from property portals

Chicago, Il , Us

Clients - Sony Entertainment Television, Start TV Network, Idea Cellular, Aditya Birla Life Insurance, Hotstar, SonyLIV• Performed data exploration on social media complaints, identified areas of improvement in the loan application process and recommended changes to product team resulting in 4% fewer customer complaints• Predicted churn rate of telecom customers using predictive modeling techniques that increased retention by 3%• Studied telecom user’s behavior using clustering algorithms to drive targeted and personalized customer strategies• Gathered requirements & executed ad-hoc data mining utilizing Power BI with DAX to provide custom insights reporting

New Delhi, New Delhi, In

Client - Sony Entertainment Television• Studied OTT platform’s pricing strategy using statistical methods that increased the subscriber base by 7% in a month• Developed customer profiling and segmentation reports using unsupervised machine learning algorithms that assisted marketing team to elevate digital campaigns engagement by 25-35%• Reduced 40% manual efforts by utilizing complex SQL queries to fetch data & SSRS for weekly web-series analysis report

Mumbai, Maharashtra, In

Client – Reliance Jio• Automated classification of customer complaints which boosted efficiency of crisis management team by 20%• Developed KPIs & built interactive BI reports in Tableau to drive lead generation and customer experience strategies• Evaluated effect of features via A/B test to identify causal relationships in customer behavior to drive profitability• Examined social media operations & proposed changes leveraging response team to respond within the SLA of 10 minutes

Master Of Science - Ms, Information Technology & Management / Data Science

Master Of Business Administration - Mba, Business Administration / Marketing

Bachelor Of Science - Bs, Chemistry