Business Intelligence Data Analyst

AISHWARYA PARAB

857-***-**** Austin, TX ad5xow@r.postjobfree.com www.linkedin.com/in/parab-aishwarya

PROFESSIONAL EXPERIENCE

Business Intelligence Engineer at Amazon.com Inc, Austin, TX, USA January 2022 - Present

●Developed a dashboard highlighting underperforming lanes in fulfillment network, helping improve plan by 50 basis points

●Designed data solution automating sync of config tables from RDS to Redshift, reducing weekly manual work by 10%

●Identified opportunities to enhance forecasting model, resulting in a 70 basis point reduction in WAPE for truck volume plan

●Established a gamma data pipeline, expediting reporting bridge analysis and testing, leading to a 30% reduction in deployment time for forecasting models to customers outside North America

●Implemented development desktop, code repository, and streamlined review processes, increasing productivity by 15%

●Volunteered to build solution for identifying internal candidates saving 50% time compared to externally recruited candidates

●Enhanced process adoption by 25% through collaboration on requirement gathering, meticulous documentation of adoption criteria, and development of tailored reporting presentations for global clients in Australia (AU), Brazil (BR), Mexico (MX)

Data Manager at Climate LLC, Boston, MA, USA November 2021 - January 2022

●Collaborated closely with Data Stewards on data governance steps, wrote python script to enforce data quality rules

●Designed the ingestion process to maintain integrity of the production tables for Science team to run machine learning models

Data Engineer Intern at OmniView Sports, Boston, MA, USA February 2021 - May 2021

●Coordinated with the Android team on adding the Google Firebase Analytics to the app for tracking function wise app usage

●Proposed utilizing Big Query Database and Data Studio with Firebase to create dashboards for business-specific information

Assistant Data Analyst at Northeastern University, Boston, MA, USA December 2022 - May 2021

●Built a python application to automate the process of collecting data from social network using Beautiful Soup for web scraping and Selenium python libraries for automation which in turn increased data gathering efficiency by ~15

●Represented HERI CIRP Freshman Survey data by designing visualizations on Tableau dashboards for generating insights for the university on the incoming batch of students with respect to their demographics, skills, cultural diversity and interests etc

●Reduced the time spent on data cleaning by ~20% by generating a Tableau Prep flow to handle the basic data cleaning tasks

Software Engineer at TCS, Mumbai, India March 2017 - March 2019

●Lead a team of five in developing scripts on Adobe Designer Suite and CMSA to build transcripts for correspondence letters

●Streamlined User story approval and deployment process using CI/CD pipelining with- GitLab, JIRA, Jenkins & Nexus and acquired good exposure to Scrum, Kanban, and other frameworks from Agile SDLC (Software Development Life Cycle)

EDUCATION

Master of Science (M.S.) in Information Systems

Northeastern University, Boston, MA GPA: 3.5/4 September 2019 - August 2021

Courses: Big Data Systems Intelligence Analytics, Data Science, Designing Data Architecture and Business Intelligence

Bachelor of Engineering (B.E.) in Electronics and Telecommunication

University of Mumbai, Mumbai, India GPA: 8.6/10 August 2012 - May 2016

Courses: Structured Programming Approach, Object Oriented Programming

TECHNICAL SKILLS

Data Visualization Tools and Analysis: Looker, Tableau, Power BI, Quicksight, Python3, SQL (Structured Query Language), Excel

Database Management Systems: MySQL, PostgreSQL, AWS Redshift, RDS, Oracle, MongoDB, MS SQL Server, DynamoDB, Snowflake

Big Data Technologies: Hadoop, Spark, Hive, Pig, HBase

Cloud Platforms: AWS, Azure, Google Cloud Platform

Other Technical Skills: Java,, HDFS, REST APIs, AWS Lambda, S3, Glue, Cognito, R, Github

ETL (Extract, Transform, Load) Tools: Anaconda, Jupyter Notebook, ER Studio, Alteryx, Datagrip

ACADEMIC PROJECTS

IMDb Movie and Reviews Analysis using Talend (Data Warehousing and Business Intelligence) May 2020-Aug 2020

●Loaded source files from IMDb website in Tableau for analyzing the data and organizing into Source Target Mappings

●Conducted ETL process using Talend to process data and loaded it to the BI schema in MS SQL Server database

●Used Tableau to build creative visualizations on movie reviews, ratings, gross income for business insights

AdventureWorks2017(OLTP) Study and Analysis May 2020 - June 2020

●Conducted ETL processes in Alteryx with dimensional modeling designed using database source AdventureWorks2017 (OLTP)

●Performed data profiling, cleansing, integration on continuously changing data fields with SCD type2 and reporting

Contact this candidate