Rishika D Email & Phone Number

• Work with stakeholder across the product and tech group in improving the client media data and evaluate right data pipelines and platforms to execute the data flow.• Perform Exploratory Data Analysis of client data using SQL and/or Python/Spark and perform data matching with internal data using Airflow DAG and ingest the results into Data Lake• Built data pipelines, using python, spark, and airflow DAG, which would ingest TBs of data into Data Lake which reduces manual efforts and enables data scientists drive insights. • Work in collaboration with data scientists to transform data and integrate algorithms and models into automated processes.• Build and maintain visualizations in Tableau and Redash.• Define and establish standards and governance in big data solutions and data engineering.

• Develop and maintain automated data pipelines in databricks to assemble, clean and transform large, complex datasets from sources and load results into Azure Storage Explorer.• Improve existing ETL processes and optimized the queries to speed up daily CRM data by ~40%.• Work in collaboration with data scientists to transform data and integrate algorithms and models into automated processesusing Python and PySpark.• Provide modifications in existing python code to optimize operational data, based on which company predicts itscustomer’s demand and enhances its business.• Develop and maintain SQL scripts for creating analytical schema to support reporting and business intelligence• Build visualizations in Qlikview & Redash and developed queries to display business metrics and KPIs.• Design and implement database solutions in Azure SQL Data Warehouse.

San Diego, California, United States

• Built predictive scores, in Python, using time series model which identifies potential new customer businesses for a marketing campaign which helped increase sales by 20%.• Monitored data pipelines and fixed bugs which decreased infrastructure costs by 30%• Saved 40-man hours per week by automating daily sales reports.• Build workflows in Alteryx for data blending, data integration and advanced data analytics.• Scheduled data refresh for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately. Create, modify and troubleshoot Jobs.

San Diego, California, United States

• Created reports and customized data analysis to identify fraudulent customers using SQL and Tableau.• Responsible to identify parameters to be added in the reports as per the business requirement. • Tested dashboards to ensure data was matching as per the business requirements

Hyderabad, Telangana, India