Summary
Overview
Work History
Education
Skills
Accomplishments
Affiliations
Certification
Languages
Timeline
Generic

Mohammed Ali

Euless,U.S.A

Summary

Over 9 years of Experience in Oracle SQL, T-SQL, Data Warehousing and Business Intelligence applications (ThoughtSpot, Power BI and Tableau). Working exposure to RStudio, and Python. Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in Microsoft SQL Server, Snowflake, AWS and Azure. ETL experience in Alteryx, Azure Data Factory, Sage.


LinkedIn: https://www.linkedin.com/in/momas1400/



Overview

9
9
years of professional experience
1
1
Certification

Work History

Sr BI Engineer

Caterpillar
05.2023 - Current
  • Design and develop workflows and datasets in Alteryx to be used by the BI Reporting tool
  • Create ETL specific datasets (to be used by ThoughtSpot for BI)
  • Write Complex SQL queries on multiple tables using complex joins & perform end to end Data validation
  • Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
  • Gather the requirements from client and onsite teams on the ETL logic and develop the mapping accordingly
  • Make optimal solutions and provide inputs on design changes unique from normal traditional solutions that are efficient and consume lesser resources to generate better performance
  • Conduct Data Blending, Joins, Preparation, Parsing Tools, Connectors and Reporting Tools in Alteryx
  • Design and develop audit capture process to log all the metadata information of each table load
  • Data Governance and metadata Management and data quality using Collibra
  • T-SQL, Tableau, SVN, Snowflake, Azure DevOps.

Sr Business Data Analyst & Lead Certified, Data Steward

First Command Financial Services
06.2018 - 03.2021
  • Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing Stored Procedures for creating datasets for Reports and dashboards
  • Gather business and functional requirements, defined, and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models
  • Create SSIS packages to load the data from source to the tables
  • Create stored procedures and functions to transform data and load into the tables
  • As a Database ETL SSIS/Azure Data Factory developer I have certain responsibilities as following which are required for Project task/activities on daily basis
  • Work closely with the business leads and product owners across Financial Planning, Customer Insight (Commercial), Customer Services and understanding their reporting requirements, analyzing customer data and implementing the best solutions that meet their business requirements and technical challenges
  • Conduct Agile Scrum meetings
  • As per the new requirements, converting functional requirement into Technical solutions
  • Revise existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, and input/output requirements
  • Create and maintain SSIS packages
  • Involved in analyzing, designing, building & testing of SSIS packages to move the data downstream applications
  • Fine-tuned existing queries to improve performance utilizing SQL Profiler and Execution Plans
  • Performance tuning of Informatica jobs and SQL periodically to improve the load performance
  • Hold regular status meetings with team
  • Perform code reviews and mentor team members
  • Deploy the code changes in lower environments through Continuous Delivery (DevOps)
  • Helped kick off the pilot program of ThoughtSpot by attending its convention ‘Beyond 2018’
  • Help set up SSO (single sign on) for ThoughtSpot users
  • Work with ThoughtSpot to take snapshots
  • Build Data pipelines for Oracle into ThoughtSpot using ODBC/TS Load
  • Perform a techno functional role acting as liaison between Business & Technology partners
  • Understand user requirements and providing work estimates on planned releases and projects
  • Requirement scrutinization and maintaining traceability metric
  • Resolving issues reported by clients
  • Post development organizing with Team and the customer for QA, UAT and Production deployments
  • Build Business Glossaries, Data Dictionaries, Lineage, Controls for Data Quality in Collibra
  • Environment: MS SQL 2016, VSTS 2017, SSIS, SQL, T-SQL, ThoughtSpot, Power BI, DB Visualizer, Data Grip, SVN, Azure DevOps, GIT, AWS, Snowflake.

Business Data Warehouse Analyst

Buxton
05.2014 - 03.2018
  • Download, clean, validate and load data received from different clients
  • Gather Business requirements for different business needs
  • Document data elements with their data lineage in a data governance tool
  • Build logical dictionaries and business glossaries for different domains
  • Make sure that every project starts and ends with Data Stewardship
  • Report Data Quality issues and creating stories/tasks for developers to work on
  • Perform counts on prospects, customers based on different geographical locations as requested by clients
  • Provide customer, prospect names and other details from the database: Experian, DNB and other data sources
  • Extract data from the database and warehouse based on different criteria requested by clients
  • Process and aggregate data using Hadoop, Hive and Pig
  • Quality-check other team members work for delivery efficiency
  • Point of contact to client’s internal data team to receive initial data transfer from client
  • Hands on Alteryx tool for data analytics (ETL, cleansing, reporting and scheduling)
  • Setting up automation via Sagent automation
  • Attend meetings to interact with project management for new assignments received from clients
  • Document the standard and workflow processes for convenience of other team members
  • Conduct data mining, maintaining data cleansing and updating data warehouses
  • Derive demographics from spatial objects (TAB files) produced by Spatial Analytics (GIS)
  • Run different SQL queries to inquire about competition and opportunities nationwide
  • Retrieve and load data into AWS (S3 buckets)
  • Quality-check models built by predictive analytics
  • Communicate with project management to address client’s needs and specs
  • Track the progress of projects and tasks through Salesforce and Clarizen
  • Helped the department save 25% of its budget migrating from Oracle to Microsoft SQL Server.

Education

Master’s degree of Science - Business Analytics

The University of Texas Rio Grande Valley
Edinburg, TX
12.2022

Bachelor’s degree of Science - Business Administration, International Business, Finance

California State University
2011

Skills

  • Knowledge in all areas of
  • SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, relational database models, data dictionaries, and data integrity
  • Expertise in Extract Transform Load (ETL): Informatica 80, SQL Server Integration Services (2008,2012,2016,2017)
  • Expert in implementing Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL
  • Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data
  • Adept at using
  • Microsoft Visual Studio and deployment of ISPAC & DACPAC
  • TECHNICAL SKILLS:
  • Programming Languages
  • SQL, T-SQL, DAX, Hive, Pig
  • Databases
  • SQL Server 2016/2014/2012/ 2008, Oracle 11g, Oracle 12c, AS400
  • Database Tools
  • SQL Server Management Studio, Alteryx, Informatica, Business Intelligence Development Studio, T-SQL, ETL, Oracle SQL Developer, Collibra, MS Azure, AWS
  • Reporting Tools
  • SQL Server Reporting Services, Power BI, Tableau, ThoughtSpot
  • Application Packages
  • SSIS, Informatica, Sagent, Alteryx
  • Operating System
  • Windows 2008R2 Server, Windows Server 2012, Windows Server 2016,2017
  • Environment:
  • MS SQL 2008/2012/2014, SSIS, Tableau, Alteryx, T-SQL, MS Excel, Sagent, ETL, Visual Studio and Accuzip

Accomplishments


  • Golden Key International Honour Society Member
  • Certified Safe Scaled Agile Practitioner
  • MS in Business Analytics


Affiliations

Golden Key International Honour Society

Certification

Safe Scaled Agile Practitioner

Languages

English
Native or Bilingual
Arabic
Native or Bilingual

Timeline

Sr BI Engineer

Caterpillar
05.2023 - Current

Sr Business Data Analyst & Lead Certified, Data Steward

First Command Financial Services
06.2018 - 03.2021

Business Data Warehouse Analyst

Buxton
05.2014 - 03.2018

Master’s degree of Science - Business Analytics

The University of Texas Rio Grande Valley

Bachelor’s degree of Science - Business Administration, International Business, Finance

California State University

Similar Profiles

CREATE PROFILE
Mohammed Ali