Mahsa J Marand
Software Engineer
Seattle,WA
Summary
Experienced software engineer with +6 years of corporate background in Accenture, Amazon, Microsoft and Coinstar, mainly concentrated on programming, designing ETL/ELT pipelines, automating, debugging and optimization.
Proficiency in statistics, machine learning, data-driven modeling and quantitative analytics. Experienced in interpreting and analyzing data to drive growth for businesses. Enhanced product sales amounts by 7% and increased website click proportion rate by 25% through statistical data analysis. Consolidated and automated 150 multilingual reports in one dynamic report using SSRS and PowerShell.
Overview
7
7
years of professional experience
Work History
Software Engineer
Coinstar
Seattle, WA
04.2020 - Current
- Migrated on-prem datawarehouse to Azure synapse and designed normalized MDW.
- Designed ETL/ELT pipelines and custom activities using Azure Datafactory, Azure Batch and Polybase.
- Designed automated emailing/reporting process using PowerShell, AzureBatch and SSRS which saved 92% of costs.
- Consolidated 150 multilingual reports in one dynamic report using PowerShell, SSMS and SSRS.
- Designed AAS and SSAS cubes and data models and improved dashboards latency.
- Built cloud-native, cloud-scale applications with micro services, and RESTful APIs.
- Checked client code for bugs and weaknesses using approved troubleshooting methods.
Data Engineer
Amazon
Seattle, WA
01.2020 - 04.2020
- Developed SQL scripts and stored procedures to identify data discrepancies between obsolete and new systems.
- Architected/ Designed/ Developed big data ETL pipelines using AWS Glue to process, clean and ingest semi structured data.
- Consolidated 34 redundant legacy reports into six integrated reports, reducing customer ad-hoc requests by 80% and improving operational efficiency by 40% using QuickSight and Tableau.
- Lead team migration from Tableau to QuickSight, including project design and implementation.
Data/BI Engineer
Microsoft
Redmond, WA
02.2019 - 01.2020
- Designed & developed Data warehouses and ETL packages using Talend, SSIS and Azure Data factory.
- Automate/Build reports using multiple databases with Power BI for VP level business decision makings.
- Troubleshooting and debugging complex queries and reports to support business partners.
- Analyzed security and AI large chunks of data using Kusto, Cosmos (Scope), Python and Spark.
- Ran a machine learning project(clustering) on proprietary security data which improved business process by 20%.
- Managed agile and scrum projects using Azure DevOps
Software Engineer
Providence Health & Services
Renton, WA
05.2018 - 01.2020
- Designed dynamic websites using PHP,CSS,Html
- Used SPSS, Python and Excel to analyze datasets obtained from google analytics and other sources.
- Used Hypothesis testing, based on logistic regression and bootstrapping, to verify A/B test results.
- Based on Analysis, online product sales increased by 7% and website click proportion rate improved by 25%.
- Quantitative reports for decision-making created by Tableau, Python, SSRS and, Excel.
- Wrote SQL queries to extract data and transfer results either in Tableau or Python or SSRS.
Software Engineer
Accenture
Remote
05.2015 - 12.2017
- Architected/ Designed/ Developed big data ETL pipelines using Airflow to process, clean and ingest semi structured data.
- Created rest API’s and updated views and contents with Python, Flask.
- Produced reports based on product data and explained insight revealed to higher executives.
- Created procedures for system monitoring, recovery, backup and optimization
Education
Master of Science - Computer Science
University of Tehran
Bachelor of Science - Computer Science
Azerbayjan University
Skills
Python, Java, PHP, HTM, CSS,
Github Projects
Predicting-Stutent-Admissions-with-Neural-Networks
SMS-Classifying-Using-Ensemble-Method
SMS-Spam-Classifying-with-Naive-Bayes
Data-Modeling-with-Postgres
Data-Warehousing-with-Amazon-Redshift
Fyurr Web Application
Timeline
Software Engineer
Coinstar
04.2020 - Current
Data Engineer
Amazon
01.2020 - 04.2020
Data/BI Engineer
Microsoft
02.2019 - 01.2020
Software Engineer
Providence Health & Services
05.2018 - 01.2020
Software Engineer
Accenture
05.2015 - 12.2017
Bachelor of Science - Computer Science
Azerbayjan University
Master of Science - Computer Science
University of Tehran
Similar Profiles
Denny Van MeterDenny Van Meter
Transportation Services Rep/Field Technician at CoinstarTransportation Services Rep/Field Technician at Coinstar
Jorge A. DeLunaJorge A. DeLuna
Warehouse Supervisor at Incomm/Coinstar EpayWarehouse Supervisor at Incomm/Coinstar Epay
Shinnosuke IijimaShinnosuke Iijima
Cash Operation Manager at Coinstar, Inc.Cash Operation Manager at Coinstar, Inc.
Holly HyltonHolly Hylton
Teacher at Concordia Lutheran SchoolTeacher at Concordia Lutheran School
Alexandra SweetAlexandra Sweet
Certified Pharmacy Technician at WalgreensCertified Pharmacy Technician at Walgreens