Bilal Mohammad Email & Phone Number

United States

Utilized the Waterfall methodology of development for Requirements, Planning, Design,and Deployment.• Created interactive dashboards in Tableau to visualize key performance indicators and track progress towards organizational goals.• Designs, develops, and maintains data pipelines, ETL processes, and data models within Snowflake.• Implemented SpaCy dictionaries to structure and rank campaign similarities, providing machine learning solutions for language and text analysis.This involved designing, building, and deploying models for millions of unstructured keyword datasets assigned to campaigns.• Executing advanced SQL queries and stored procedures to access and analyze data fromthe relational database for data modeling andreporting.• Utilizes Snowflake for querying, analyzing, and deriving insights from data stored in the Snowflake data warehouse.• Creates and executes complex SQL queries, performs statistical analysis, and builds machine learning models using Snowflake data.• Conducted A/B tests and hypothesis testing to drive data-driven decision-making, leading to a 15% improvement in conversion rates.• Created clear Power Point with data visualization results from R and Tableau andpresented to customer service team.• Wrote calculated columns, Measures query's using DAX in Power BI to show good data analysis techniques.• Statistical analysis of clinical data to obtain the required results.• Used statistical methods, metrics, quantitative methods, and strategic project plans for data collection and later given the responsibility tovalidate the data integrity using SQL queries

United States

Worked on sentiment analysis in python to analyze the severity of fraudulent activity from the articles.• Worked on various applications using Python-integrated IDEs such as Visual Studio Code and PyCharm.• Devised innovative strategies that streamlined data collection, and daily deposits and decreased daily backlog process to drive team memberproductivity.• Designed and implemented Informatica (ETL) workflows to process hundreds of files at a time and maintain proper queue when dependenciesare present.• Improved code efficiency in applications where the data is in distributed systems by converting scripts to PySpark.• Use packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low graphs to identify the relationship betweendifferent variables.• Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split, Merge Join, Union, and Execute SQL Taskto load into database.• Collecting and iteratively refining specifications from management to augment current pivot table reporting with high-quality dashboardvisualizations in Excel.• Extensively used ERWIN and Power Designer to design Logical and Physical Data Models, to forward and reverse engineering data models andpublishing data model to acrobat PDF files.• Wrote several complex SQL queries to extensively test the ETL process.• Performing data analysis and maintenance on information stored in MySQL database.• Working on developing Python script for the whole data science project life cycle including data acquisition, data cleaning, data exploration, anddata modeling.

India

• Performed database testing on data warehouse by using complex SQL queries in SQL Server to validate the data present in it.• Worked on architecting, designing, and implementation of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.• Participated in collaborative team designing and developing a Snowflake data warehouse.• Designed and created data extracts, supporting Power BI visualization reporting applications.• Create a storyboard of backlog items in Agile and develop items according to business needs.• Automated web-scraping tool to producemarketing content using Python.• Develop and design interactive and visually appealing Power BI reports and dashboards.• Created data models, relationships, and data transformations using Power Query.• Implement DAX (Data Analysis Expressions) calculations to extract insights from data.• Designed and developed data ingestion from different source systems to snowflake Datawarehouse.• Collaborate with business analysts and stakeholders to gather and define reporting requirements.• Involved in requirements gathering, source data analysis and identified business rolesfor datamigration andfor developing datawarehouse/datamart.

Master'S Degree, Information Systems And Business Analytics, 3.94

Bachelor Of Technology - Btech, Aerospace, Aeronautical And Astronautical Engineering, 3.12