Rishu Singh Email & Phone Number

Mclean, Va, Us

Design & Code Financial Marketing and Servicing Campaigns: Developed and implemented SQL scripts to extract card customer data based on specific campaign intents. Created and tracked metrics for account inclusion/exclusion and developed validation metrics for campaigns using Databricks.● Analyze and organize raw data of millions of customers from S3 files into structured data in Snowflake using Pyspark for use in analyticsand downstream systems enhancing data privacy and security.● Conducted A/B Testing on Marketing Campaigns: Optimized message templates and design elements● Developed and presented comprehensive campaign insights and performance metrics to stakeholders, focusing on key performance indicators (KPIs) such as target population, customer segmentation, and exclusion groups. ● Requirement Analysis and Liaison: Gathered and analyzed business and client requirements, acting as a liaison between business analysts and product owners to ensure alignment and clarity.● Monitor and track campaign progress and reconciliation via Quicksight.● Optimized Data Extraction: Developed and executed optimized SQL queries to extract data from multiple storage systems, including S3, Snowflake, and Data Lake increasing data retrieval efficiency by 30% and enhancing the campaign's ability to gather data from various sources.

Santa Clara, Ca, Us

● Optimized SQL queries for improved performance and scalability.● Conducted Exploratory Data Analysis (EDA) by analyzing data from diverse sources, utilizing Python to unveil insights.● Conducted root cause analysis of data and processes to address business questions and identify improvement opportunities.● Performed meticulous data cleansing, significantly boosting data quality.

Pittsburgh, Pennsylvania, Us

● Successfully developed an oracle cloud-based database on Salesforce enhancing data organization, accessibility, and privacy by 2x, leading to improved and streamlined processes across multiple programs.● Translated business needs into a relational data model for efficient data storage and organization on salesforce which has completely automated the daily dashboards and reports.● Extensively used ETL to load data from Oracle and Flat files to Data Warehouse● Automated data loading process by 70% by developing a Python program that efficiently scrapes data from diverse files and consolidates it into a CSV file.

Baar, Zug, Ch

● Performed A/B testing to understand the impact of promotions resulting in 5% increase in sales in a quarter.● Collaborated with product managers to perform cohort analysis and create customer lifecycle analysis, identifying important products and growth categories. These efforts led to a 10% year-over-year growth in revenue.● Leveraged strong consulting skills to provide valuable recommendations and strategic insights to key stakeholders weekly by utilizing descriptive and diagnostic analytics on the entire assortment plan.

Beaverton, Or, Us

● Leveraged 9 segment and long-tail analysis to lead financial and assortment planning for the apparel category, resulting in a remarkable 10% improvement in performance.● Performed data cleansing on user behavior data to address missing values and outliers using pandas and improved data quality● Automated email sent to stakeholders reporting data quality issues everyday using Databricks python notebook engaging business users and saving ~ 20 man-hours in reporting.● Developed predictive time-series model to forecast sales with 90% accuracy (resulted in $1 million in revenue growth)● Designed Tableau ETLs and created dashboards to create a seasonal budget and periodic forecast and generating insights, saving ~60 hours of monthly labor

Master Of Science - Ms, Information Science/Studies

Bachelor Of Science (Bsc), Mathematics Honors

Master'S Degree, Management

12Th (Hsc), Non Medical Science Stream (Pcm With Computer Science)