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.

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.

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.

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.

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.

M.S. Business Analytics, Business Analytics

Bachelor’S Degree, Electrical, Electronics And Communications Engineering