Davoud Saljoughi Badlou

Successfully managed and maintained a large-scale data warehouse and data lake in Google Cloud Platform's BigQuery, handling various file types including JSON, CSV, Parquet, and GZ Developed and optimized over 30 data pipelines using Google Dataflow, Apache Airflow, and Google Cloud Functions to efficiently process and transform streaming Pub/Sub messages and batch data. Enhanced query performance for terabyte-sized tables, employing advanced optimization techniques to ensure efficient data retrieval and processing. Management: Implemented continuous integration and continuous deployment (CI/CD) practices using GitHub, ensuring streamlined development and deployment processes. Team Collaboration and Leadership: Collaborated with a large team of 10+ engineers and other stakeholders, contributing to project planning, execution, and optimization to meet business requirements.

- Designed, created, and maintained batch and streaming data pipelines using GCP technologies and Python. These pipelines processed data from multiple sources with millions of records, ingesting it into BigQuery. - Developed data transformations and analytics modules based on business requirements. Depending on performance considerations, I utilized either complex and optimized SQL analytics queries or scalable, real-time optimized algorithms in Python. - Designed and implemented multi-region streaming and batch data pipelines to ensure efficient data processing and delivery. - Managed ETL/ELT activities to support various workloads, including ad-hoc analysis and data governance. Identified areas for improvement and implemented process enhancements such as automation, data delivery improvements, and infrastructure redesign for scalability. - Collaborated closely with data scientists and reporting teams to fulfill their requirements for new reports, data modeling needs, and data insights. - Took ownership of deploying, monitoring, and maintaining data pipelines in the production environment, ensuring their reliability and performance. Technologies and skills: - Python (Apache Beam, Apache Airflow), GCP services (BigQuery, Workflow, Dataflow, Airflow, Cloud Storage, Cloud Functions, and Cloud Scheduler), SQL (MySQL, PostgreSQL), Docker, Fivetran Connectors, Salesforce API, Git, Jira, Tableau

- Designed and developed ETL/ELT pipelines using SSIS to manipulate, create custom fields, and transfer data from source databases to a data warehouse. Ensured efficient data extraction, transformation, and loading processes. - Created Business Intelligence dashboards and data visualization products for six different projects using Power BI and SSRS. These solutions provided valuable insights and enhanced data-driven decision-making capabilities. - Developed three software tools to support Health Canada Cannabis inspectors in their day-to-day operations. These tools streamlined processes and improved efficiency in data management and reporting. - Conducted data quality and validity analysis, identifying areas for improvement in data processing and handling. Proposed and implemented enhancements to ensure data accuracy and integrity. - Took ownership of data modeling, documentation, and implementation processes, ensuring effective organization and accessibility of data assets. - Utilized advanced SQL queries, including joins and subqueries, to retrieve data from databases and perform complex data manipulations. Technologies: Python, SQL Server (SSIS, SSRS), Power BI, Tableau, PostgreSQL, Dynamics 365, Jira

- Monitored trends, reported variations, identified outliers, and formulated suggestions for improvement using Python and R. Leveraged these programming languages to perform advanced data analysis and statistical modeling, providing valuable insights for decision-making processes. - Advised on study design, data standards, statistical analyses, and presentation techniques for reports and publications. Ensured adherence to best practices in data analysis and effectively communicated findings to diverse audiences. - Conducted data quality and validity analysis using Python, implementing robust data validation techniques and identifying areas for improvement. Developed data validation scripts and processes to enhance data accuracy and reliability. - Authored "Data Visualization Best Practices," an internal guideline in Statistics Canada for publishing data visual products. This comprehensive guide provided recommendations and standards for creating visually appealing and informative data visualizations. Technologies: Python, R, Power BI, RStudio, Jupiter Notebook

Company: Bahar Dalahoo was established in 1998 in Islamabad Garb (Kermanshah province). This company produces over 80 SKU dairy products with the MANIZAN, SHOWAN, and Mamisha brands. Bahar Dalahoo's main market is Iraq, where the company sells more than 70% of its total sales. My Duties: Senior Data Analyst | Sep 2015 - Dec 2018 • Gathered, prepared, cleansed, and transformed data for analysis and AI automation. • Performed statistical modeling and time series analysis to extract insights. • Analyzed customers and their purchasing habits using machine learning techniques. • Provided various reports to support internal teams in pursuing key business opportunities. • Led technical projects within the organization, including the implementation of a new CRM system for tracking organization-wide activities and sales software. • Interpreted and visualized data to develop new insights. Data Analyst | Sep 2012 - Jul 2013 • Prepared S&OP (Sales and Operations Planning) planning and cost control. • Analyzed customers and their purchasing habits to identify trends and opportunities. • Supported the sales team by providing analytical reports. • Improved the shipping cost of selected products through the introduction of new packaging solutions. Technologies: Python, SQL Server, MS Office

Company: Nasr al Rafedain is an Iraqi service company, which provide export management, market research, legal services, Logistics and consultant in Iraq market. Business Development Department is responsible for market research, export management projects in the market. My Duties: • Developing new business line in the company • Prepare Market study and analysis reports for companies • Design and implement market research projects

Company: Golrang Industrial Group was established in 1970s decade, This company has over 40 sub-companies and produces & distributes about 1000 SKU products with Brands like AVE, SOFTLAN, GOLRANG, FAMILA, OILA, NANCY in the market. My Duties: • Prepare daily reports about the sales and channels performance • Controlling different KPI and preparing periodical reports • Analyze the Profit/Lost of different Products in Retail • Managing a team of merchandisers in different chain stores in Tehran • Preparing the marketing plan for the company