AKSHITA SRIVASTAVA

Managed to work in 3 different teams in close collaboration with Tableau(data visualization), ETL, and data modeling. Processed, manipulated, stored, and parsed data in 2 data pipelines. Designed, developed, deployed, and maintained Tableau reports for over 10+ dashboards. Developed best practice documentation for each category with approaches to support continuous process automation for data ingestion and data pipeline workflow. Led the migration from MSSQL to Redshift using Amazon Athena and S3, resulting in an annual cost savings of $480,000. Designed and implemented a data pipeline to process semi-structured data by integrating millions of raw records from 2 data sources using Spark- Scala and SQL. Ingested data from disparate data sources using a combination of SQL, Amazon Redshift, Athena, S3, Glue, CloudWatch, and Spark Framework using Scala to create data views to be used in BI tools like Tableau. Worked with clients to understand business needs and translate that business needs into actionable reports in Tableau, saving time of manual work each day by manually extracting the data. Now clients can visit the portal and get the required data downloaded.

Budding Technologist Award by SHL

Performed source system analysis, data profiling, and design mapping logic between source systems and 3 data warehouses. Created data extraction, cleansing, and load programs to move data from source systems to 3 data warehouses. Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs. Received, cleaned, and prepped data using Python, SQL, and Excel to help build marketing mix models that resulted in a lift in ROI of 8 basis points. Collaborated with product managers, gaining insight into marketing aspects and writing documents.