Sandeep Rani Pradeep Kumar Email & Phone Number

Dallas, Texas, Us

Purchase, Ny, Us

1.Accomplished a 10% increase in user engagement by engineering an efficient data model to monitor Devices for Chronic Care Management and reducing key risk indicators through heavy strategic analysis by leveraging Azure Synapse Analytics and SQL.2.Orchestrated the development of a robust data model for Marketing Campaigns triggered from SFMC and ADLS, across various channels (Emails, Direct Mails, Push notifications, SMS), resulting in a 20-30% reduction in user Healthcare costs by exercising Virtual Primary Care(VPC) .3.Achieved a 2-3% improvement in Provider Cancellation and Decline rates by utilizing visual storytelling to devise and track KPIs using SQL for the Mental Health(MH) product line and designed an insightful data-driven Tableau dashboard.4.Decreased deployment time by 1-2 weeks through collaboration with 20+ members across departments, developing a smooth change management process in JIRA for analyzing impacts from source systems and presenting optimal solutions.5. Attained a 20-hour weekly efficiency gain by seamlessly incorporating Generative AI with LLM using Python(Pandas AI) into Exploratory Data Analysis, optimizing trend and pattern identification for large and complex datasets.

Marseille, Fr

•Designed data pipelines to streamline data extraction, data manipulation and data analysis and finally schedule reports using Microsoft SQL server suite (SSIS, SSRS).•As analyst for Finance and Customer Care, worked with different teams to understand business requirements and coordinated with the technical teams to provide reporting solutions.•Created and optimized 20+ SQL templates to supply meaningful data to the Customer Care and Finance teams, thereby standardizing the reporting process and eliminating ad hoc reports•Built and automated Quarterly FMC Audit process to calculate top customers in different trade lines for reporting to FMC thereby saving 40 hours of manual work.•Developed disputes audit engine using SQL to identify disputed invoices, thereby boosting revenue collection by 5-10%

Marseille, Fr

1. Accomplished average monthly savings of $200,000 by building a Least Cost routing engine exploiting Advanced SQL and Microsoft SQL Server Suite. Compared and forecasted costs among various suppliers, identifying variances and sub-optimal expenses, leading to efficient cargo re-routing.2. Realized cost savings of $72,000 on report production by implementing an optimized and automated solution for a Performance reporting dashboard using Qlik Sense. Integrated data from diverse data sources to monitor employees' weekly performance.3. Executed 40+ hours of manual labor savings and data quality checks by developing an automated Quarterly FMC Audit process employing complex SQL queries . Identified top customers across regions for reporting to FMC.4. Implemented the development of 100+ impactful Qlik Sense dashboards based on large and complex data sets for key business stakeholders, measured by a 30% improvement in decision-making efficiency. Achieved this by designing data pipelines that streamlined data extraction, manipulation, and analysis.

Dallas, Tx, Us

1. Attained a 15% improvement in business value by building, manipulating, and analyzing dynamic Tableau reports and dashboards. Derived actionable insights and recommendations for enhancing KPIs and metrics.2. Coordinated with a cross-functional team of 20+ members across USA and India as a Scrum Master, achieving a 20% boost in customer satisfaction by delivering language-translated dashboards for Germany and Spain.3. Built complex SQL queries to analyze large data sets and produce business reports with useful data interpretations and insights that capture user’s interaction with the products

Irving, Texas, Us

•Built an interactive dashboard for use by the C-level executives and the Marketing team to track their campaigns, budget expenses, sales performance and popularity of the products.• Analyzed the performance of different areas and categories in apparels, headwear, accessories and recommended marketing strategies to improve reach and increase revenue by 20%.

San Francisco, California, Us

1. Developed a price recommendation engine for the client which automatically suggests product prices depending on competitor’s pricing on a daily basis for around 5000 products in FMCG market, ultimately leading to 50M $ funding for the client in 20202.Programmed and automated web scraping ETL applications using Python to crawl 4-5 competitor’s pricing data for 15+ cities for benchmarking the prices on a daily basis, and route it into AWS data warehouse, thus building a big data lake3. Built a product matching data pipeline using statistical and ML libraries in Python to automate report generation thus reducing manual labor by 80%.4. Designed an intuitive pricing analysis dashboard demonstrating price comparison and daily trends among market competitors for different products5. Programmed a campaign validation system to keep the client campaigns on the website free from errors.

Chennai, Tamil Nadu, In

1. Created visually impactful graphical dashboards using PowerBI to represent university admission data of 2 years for American College of Kuwait(ACK).2. Devised a ETL program to process financial details from core banking system to the financial CRM application, thus increasing efficiency by 20-30%3. Implemented new functionalities in the FABX application( dashboard used my Relationship managers) like Chat rooms

M.S. Business Analytics, Business Analytics

Bachelor’S Degree, Electrical, Electronics And Communications Engineering