Rucha Deshpande Email & Phone Number

Dallas, Tx, Us

Dallas, Us

New York, Ny, Us

Working as a Data Analyst as a part of Business Decision Support team for Saks Fifth Avenue and Saks-Off5th retail brandsData Analysis Tools : SAS, Python, SQL, Looker, Adobe Analytics, MS Excel, MS PowerPointDatabases: Oracle, Teradata• Optimizing Customer Relationship Management model by building segmentation algorithms for statistical and predictive data modeling using Python• Analyzed performance of digital marketing channels such as Email, Social Media, natural search, paid search, shopping comparison and affiliates (including Ebates, Honey, RetailMeNot, Groupon) using Adobe Analytics• Coordinated with web development team to debug tags and ensured consistency on websites across multiple brands ( Saks/ Saks Off5th/Lord & Taylor)• Identified fraud resellers by analyzing credit card usage which reduced fraudulent transactions by two percent• Evaluated performance of a marketing campaign by conducting cost-benefit and forecasting analysis SAS and SQL, which improved brand’s profitability by nine percent • Influenced business recommendations by presenting critical statistical findings through visualization of Quantitative Reporting Information using MS Excel• Analyze results of A/B tests to compare performance of different versions of a website• Constructed international sales report to analyze sales trend on monthly basis• Identify customer’s shopping trends/patterns in data sets of varying size and complexity• Explore marketing and promotional data using analytical techniques such as customer profiling and segmentation analysis on weekly basis• Handle Salesfloor data to study incoming sales obtained by web customers with the help of an associate • Work with a cross functional team to improve the integration and dissemination of data and intelligence across the company• Interpret the needs of cross-departmental partners and present relevant analytical approaches to support those needs

Brentwood, Tn, Us

Data Analysis tools: R studio, Tableau, MS Excel Database: MS SQL server• Performed quantitative data analysis on Insurance claims to identify trends and opportunities in patient transitions between acute/post-acute care facilities and presented findings with the help of dynamic Tableau dashboards• Improved accuracy of forecasting model by 24% to 76% to predict patient's Readmission Rate, Length of Stay, Discharge to Community Rate• Increased performance of SQL queries to access large amounts of data • Performed Quality Analysis for CMS (Centers of Medicare and Medicaid Services) and SNF (Skilled Nursing Facilities) KPIs using VLOOKUP, HLOOKUP, INDIRECT functions in MS excel.• Acquired functional knowledge about Diagnosis related Groups (DRGs) and ICD-9 codes.• Characterized patient transition times between different care settings (Skilled Nursing Facility , Inpatient Rehabilitation Facility , Home health care , Long Term Care Hospitals) using LDS claims dataset. Worked on SAS Enterprise Guide to formulate episode of care data within BPCI model.• Analyzed CMS data metrics by doing basic statistical & graphical analysis. Implemented capping analysis to reduce the effect of outliers on product output. Run a comparative analysis on metric distributions by plotting histograms using ggplot in R studio. • Executed correlation study for Health Service provider’s data obtained from Severity Adjusted Dashboard (SADB). Identified outliers with boxplot and fitted line graph method using R Studio• Coordinated with people from various teams across the organization to acquire and collaborate the functional knowledge• Successfully communicated data insights and business recommendations to the client

Tampa, Florida, Us

• Worked as a Graduate Teaching Assistant at the ISDS department of University of South Florida• Aided undergraduate students in the course Information Systems in Organizations• Addressed questions and concerns regarding projects and assignments based on HTML , MS Excel , MS Access.• Assisted faculty members with grading and maintaining records.

Data Analysis tools: IBM InfoSphere Streams, IBM Cognos, TableauDatabase: IBM DB2• Increased consumer retention rate by 17% by performing Customer Analytics and visualizing insights using Tableau • Identified top customers by discovering patterns in historical service usage and formulated targeted marketing strategies• Collaborated with Business Analysts and cross-functional teams to translate business requirements into unit test plans• Assisted a team of Associate Engineers to adapt changes to an existing data modelling system• Maintained the Business Intelligence system of a telecommunication network service provider by executing design, development, data analysis and performance management. • Developed and optimized SQL queries, stored procedures, data aggregations, and ETL processes to improve data delivery• Coordinated and executed ad-hoc analysis that informed both the strategic and tactical initiatives of the Product team• Integrated solutions for data discovery and Business Intelligence reporting using IBM Cognos analytics. • Involved in Software Development Life Cycle of the project.

Business Administration And Management, General

Master'S Degree, Business Analytics And Information Systems

Bachelor Of Engineering (B.E.), Electrical, Electronics And Communications Engineering

Science