AARTI MEHTA

Boston, MA ad2ajw@r.postjobfree.com 617-***-**** https://www.linkedin.com/in/aarti-mehta/ EDUCATION

Northeastern University, Boston, MA Grade: 3.8/4 2021 – 2023 Master of Science in Information Systems

University of Mumbai, Mumbai, MH, India 2013 – 2017 Bachelor of Engineering in Information Technology

TECHNICAL SKILLS

• Programming Languages: SQL, Python, Java, UNIX, Linux

• Tools: DynamoDB, AWS SQS, AWS CloudWatch, CloudFormation, AWS Glue, AWS Sage, S3, Tara, Tableau, Power BI, Alteryx, ER Studio, Talent Studio, Salesforce, API, ServiceNow, Jira, Apache Kafka, Spark, Airflow, Postman

• Databases & Cloud: DynamoDB, Teradata, SQL Server, Oracle, MySQL, Azure, AWS RedShift, Snowflakes, PostgreSQL PROFESSIONAL EXPERIENCE

Northeastern University, Boston Data Analyst Jan 2023—Dec 2023

• Conducted exploratory analysis on user behavior data for the Information Technology Services (ITS) website, extracting actionable insights to inform A/B testing strategies and enhance user engagement.

• Applied statistical analysis techniques to evaluate results, ensuring robust conclusions and informed decision-making.

• Utilized predictive modeling to forecast user traffic, contributing to strategic planning for website optimization Amazon AWS Chime SDK, Seattle Software Development Engineer Intern Sep 2022—Dec 2022

• Developed a REST API for Intelliquent inventory, enabling phone number search, provisioning, and automating billing processes. Initiated subscription events, and established default calling names for enhanced user experience

• Implemented AWS Account ID allow list to prevent spam and fraudulent attacks, enhancing system security

• Orchestrated API integration with Simple Queue Service (SQS) for asynchronous execution of 100+ phone numbers

• Designed and integrated DynamoDB for real-time order and status updates

• Utilized SQS Worker, CloudWatch, CloudFormation, Isengard, and DynamoDB for seamless API integration and efficient system operation

Teradata Pvt. Ltd., Mumbai Data Analyst 2017 – 2021

• Enhanced database performance through meticulous query tuning and monitoring and successfully orchestrated the migration from on-premises to the cloud, ensuring improved scalability

• Identified and addressed repeated issues that reduced manual efforts by 98% via the creation of Unix scripts and automation using Control M

• Ensured system stability by proactively monitoring, performing workload management, and troubleshooting errors during batch jobs, and streaming data

• Generated insights into trends, job runtimes, and failures via comprehensive weekly backup reporting

• Attained 25M CPU and 3TB space savings via strategic query tuning, multi-valued compression, by best practices

• Attained a 99% success rate in bug resolution via root cause analysis of high-priority bugs

• As the offshore lead, I managed a team of three to design, develop, and deliver multiple projects ACADEMIC EXPERIENCE

Datawarehouse/ Business Intelligence Jan’22 – May’22

• Built a data model for Adventure Works DW, Boston food inspection, and IMDB dataset with over 52M records in ER/Studio. Also, created a list of dimensions and facts as per the snowflake and star schema

• Gathering business and functional requirements; Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router, and Update Strategy in data lake

• Responsible for designing and developing mappings, mapplets, sessions, and workflows to load the data from the source to the target database using Informatica Power Center, Talend, Alteryx, and Apache Airflow

• Loaded datasets from various sources (MSSQL, AZURE, SSMS, ORACLE, POSTGRES) into Alteryx and using Python

• Applied data integration: Slowly Changing Dimensions and Rejection logic to the data quality management

• Created Tableau & Power BI dashboards using Power Query and DAX for data-driven decision-making CERTIFICATIONS

• AXELOS: ITIL V4 Foundation (Information Technology Infrastructure Library)

• Microsoft Azure: Azure fundamentals (AZ-900), Data fundamentals (DP-900), Data Engineering (AZ-103)

• Teradata: Vantage Certified Associate Advanced SQL Engine and Vantage Certified Administrator

• Amazon Web Services: AWS Business Professional issued

• Oracle: Oracle Database 11g

Contact this candidate