Ali Abdollahi Email & Phone Number

Oulu, Fi

Oulu, Fi

Tehran Province, Iran

- Migrated the tables between different servers and databases after backend refactor to addressthe previously designed processes without a breakdown- Led the automation process of updating sales and stock dashboards from excel reports on different distributors' websites via Python webscraping libraries- Automated the process of sales update through API and web service communication via Postman and Python- Minimized the manual work for data entry in a sales and marketing app and… Show more - Migrated the tables between different servers and databases after backend refactor to addressthe previously designed processes without a breakdown- Led the automation process of updating sales and stock dashboards from excel reports on different distributors' websites via Python webscraping libraries- Automated the process of sales update through API and web service communication via Postman and Python- Minimized the manual work for data entry in a sales and marketing app and mission costs dashboard through pre-calculated excel structure and sql tables design alongside relevant data pipeline- Managed the troubleshooting process and debugged the automated data pipelines and jobs ona daily basis- Supervised the PBI dashboards design as per the business requirements, data quality anddashboards performance- Consulted the process of KPIs design and team-based implementation for the whole companyas performance management procedure- Led the project of training MLPs and LSTM to forecast the sales volume and targets based onthe sales statistics data- Led the process of changing the data sources of the PBI dashboards to SSAS Tabular tomaximize their performance- Led the data journey of the team and their roadmaps to meet the business targets whilepaying off the technical debts- Moved the packages/scripts to GitLab and managed the source/version control process for theentire team collaborations- Restructured the ETL procedure of a voip monitoring dashboard to connect directly toPostgresql database to further the performance and data transfer standard- Trained junior and mid-level members of the team to onboard as quickly as possible and provided them with data roadmap- Structured the team in agile methodology to work on Jira based on planned sprints and scrumceremonies Show less

Tehran, Iran

- Created and designed the sales statistics database and its tables alongside the ETL procedureand automated jobs, to contain the historical data for future sales forecast- Trained and supervised the other members of data team to manage their tasks based onstandards and best practices- Designed and implemented the SSIS packages to transfer data from excel sources to sqldatabases- Optimized sql queries for data transfer and automated the process

Tehran, Iran

- Developed data pipelines in SSIS to populate different data mart facts and dims (also rarely in Python)- Monitored data pipelines and addressed the bugs/issues in data sources and/or pipelines- Learned Elasticsearch and Kibana as parts of the ELK stack to develop data pipeline for search logs on the website to derive user activity insight- Developed data pipeline to ETL search data from Elasticsearch to sql server data lake- Managed to deliver incremental clean data from data… Show more - Developed data pipelines in SSIS to populate different data mart facts and dims (also rarely in Python)- Monitored data pipelines and addressed the bugs/issues in data sources and/or pipelines- Learned Elasticsearch and Kibana as parts of the ELK stack to develop data pipeline for search logs on the website to derive user activity insight- Developed data pipeline to ETL search data from Elasticsearch to sql server data lake- Managed to deliver incremental clean data from data mart via views and SPs to marketing team in agreed structures to develop features for loyalty users- Designed new data mart for the hotel product based on the previous version of the mart- Modified the data pipeline which used MongoDB as a data source- Worked with Gitlab and Docker for CI/CD and version control of different packages for data pipelines- Worked on a daily basis with Jira and Confluence as part of the team scrum framework- Started learning Big Data lifecycle with all the tools available in the field and practiced them on the go- (Taught Python programming to underprivileged teenagers as part of Alibaba social responsibility program) Show less

Tehran, Iran

- Developed a Power BI report based on "ExecutionLog3" view of report server database for monitoring the reports with high load time or errors in loading to notify report server admins.- Researched the available templates and launched a Power BI report for monitoring Power BI report server.- Achieved to develop Power BI reports for sale and purchase procedures of a distribution company from their ERP solution as an end-to-end project, including: * Learned how the ERP solution… Show more - Developed a Power BI report based on "ExecutionLog3" view of report server database for monitoring the reports with high load time or errors in loading to notify report server admins.- Researched the available templates and launched a Power BI report for monitoring Power BI report server.- Achieved to develop Power BI reports for sale and purchase procedures of a distribution company from their ERP solution as an end-to-end project, including: * Learned how the ERP solution works in terms of data flows and database structures in tables and views * Extracted required information from ERP database based on the UI * Constructed as few as needed views with the desired data to be connected to the report as the data source * Designed the Power BI report for sale and purchase procedures- Installed and configured Power BI report server on a separate server and restored the report server database backup on the new server as a server migration step.- Practiced agile methodology with the Scrum framework using TargetProcess as the software tool.- Managed to develop, implement and maintain the BI solution for "LeaderBoard" project, including following steps: * Designed source and destination tables on different databases/servers * Developed SSIS packages for ETL * Designed the Power BI report based on the processed data after the KPIs calculations * Designed and implemented Row Level Security for the Power BI report using DAX measures * Created jobs for SSIS packages and refresh schedules for Power BI report on the report server- Worked with Redgate SQL Monitor to monitor BI servers for custom and default alerts.- Researched and documented the top BI monitoring tools, Redgate products and Cube documentation methods. Show less

Tehran Province, Iran

- Supervising the projects as an agent for Water Treatment systems company (Stilmas), for Sterilization systems company (Fedegari) and for Blow-Fill-Seal systems company (Brevetti Angela).- Being trained in water treatment systems, sterilization processes in the foreign manufacturing companies and offering technical supervisions to clients

Tehran Province, Iran

- Corresponded manufacturer company for orders registration, new products realization, etc.- Implemented quality assurance standards and designed forms for documentation.- Supervised CRM activities as an admin and resolved IT problems.

Stillwater, Ok

- Developed a multi-objective optimizing controller for flight control and programmed inMATLAB.- Designed an adaptive/optimal controller for nonlinear dynamic systems and programmed inMATLAB, collaborated with Technical University of Munich (TUM).- Simulated the adaptive/optimal controller in real-world simulation software, Flightgear,interconnected with MATLAB and Python codes.- Formulated a risk-averse planner for safe exploration in dynamic environments… Show more - Developed a multi-objective optimizing controller for flight control and programmed inMATLAB.- Designed an adaptive/optimal controller for nonlinear dynamic systems and programmed inMATLAB, collaborated with Technical University of Munich (TUM).- Simulated the adaptive/optimal controller in real-world simulation software, Flightgear,interconnected with MATLAB and Python codes.- Formulated a risk-averse planner for safe exploration in dynamic environments withadversarial tactics. Show less

Tulsa, Ok

Measurements and Instrumentation Lab assistant: - Graded assignments.- Led weekly lab experiments.

Stillwater, Ok

Engineering Analysis:- Graded assignments, quizzes and exams.- Led Q&A sessions.

Tehran, Iran

- Supervised the production line sections for quality control and safety rules.- Devised and assigned required sets of rules to the corresponding section of the production line.- Organized sorted lists of various components on production line to create an inventory.

Tehran, Iran

Measurement Systems:- Graded assignments and exams.

Tehran, Iran

- Designed two industrial robots for Biomedical-related companies and modeled them in CATIA.- Guided the machinist to fabricate the model parts with given dimensions and tolerances.- Corresponded to corporations and negotiated with managers to fully meet their expectations.

Master'S Degree, Mechanical And Aerospace Engineering, 3.88/4

Activities and Societies: Distributed Autonomous Systems Lab (DASLab), American Institute of Aeronautics and Astronautics (AIAA).

Bachelor Of Science (Bsc), Biomedical/Medical Engineering, 3.70/4

Activities and Societies: Guild Council, BioMEMS Lab, Iranian Society for Biomedical Engineering (ISBME)

Bachelor Of Science (Bsc), Mechanical Engineering, 3.74/4

Activities and Societies: Pasargad Robocup Rescue Team, Composite Materials Lab

Diploma, Mathematics & Physics, 19.44/20

Activities and Societies: NODET (National Organization for Developing the Exceptional Talents) Chemistry Olympiad, English Discussion Group