Mohammed Diwan
USA
Summary
Mohammed Diwan is a Sr Data Modeler at Charles Schwab. He has over 10+ years of working experience in Data Modeling, Data Analysis, and has extensive experience on AWS, Big Data, and the Hadoop ecosystem. He has excellent proficiency in software development, Agile/Scrum, and waterfall methodologies. He has worked with various data models and databases, including Google Big Query, Teradata, Hive, and SQL Server.
Overview
11
11
years of professional experience
Work History
Data Modeling
PepsiCo
12.2023 - Current
- Collaborated with software developers to translate business requirements into technical specifications for database design
- Implemented best practices for naming conventions, indexing strategies, partitioning schemes, and other database design principles
- Identified opportunities for automation or process improvement within the data modeling workflow
- Conducted regular reviews of existing data models to identify areas of optimization or consolidation.
Sr. Data Modeler
Charles Schwab
TX
01.2022 - 09.2023
- As a Data Modeler, I analyze the logical and physical data models and apply DM (Data Modeler) standards for production implementation
- Review physical data models and generate SQL files from the approved data models
- Provide Google Big Query SQL conversion support to the business system analysts
- Involved in GCP framework and Data pipelining process and provided dataset and schema names
- Provide security solutions and create Data Access Area roles for the physical data using view level access for Integrated Data Warehouse (IDW) and Cloud Data Warehouse (CDW)
- Work with offshore team to create Data Access Area roles to restrict data access for the end-user
- Provide clustering and partitioning solutions for GBQ and Teradata database objects
- Upload approved DDLs (Data Definition Language) into bitbucket and create a feature branch for the master repo merging process
- Create pull request for promoting feature branch into the master branch/PRD repositories in the bitbucket
- Suggest data pipeline and infrastructure framework to business system analyst for source to target mapping
- Work with BSA to Analyze business requirements and review logical/physical data models that describe all the data and relationships between the data
- Involved in migrating Teradata and BDH (Big Data Hub) Hive Databases to Google cloud platform with Google Big-Query data warehouse solution
- Provide suggestions for Integrated data from multiple sources including Teradata and Hive Data warehouse
- Involved in Planning, Defining and Designing Erwin data mart using ERWIN Data Model 2020 r1 and 2022 r12 on business requirement and provided documentation
- Work with Data Management team to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata
- Developed User defined columns and process to convert Teradata SQL to Google Big-Query SQL
- Created data schema and physical data types of data warehouse for standardized data storage and access
- Developed scripts in Erwin Data modeler for SQL transformation to GBQ SQL DDL
- Work with Data management team to provide IDW and CDW Accusation layer standards for data modeling process
- Provide multilayer standards and support to the business for data model creation
- Environment: Erwin Data Modeler tool, Teradata R15/R16, Hive, Google Cloud Platform, Big-Query, Teradata SQL Assistant, Bitbucket, Atlassian products
Sr. Data Modeler
Quantum Health
Dublin, OH
04.2020 - 12.2021
- As a Sr Data Modeler understand the high-level design choices and the defined technical standards for software coding, tools and platforms and ensure adherence to the same
- Involved in Planning, Defining and Designing database using ERWIN Data Modeler on business requirement and provided documentation
- Analyze business requirements and build logical data models that describe all the data and relationships between the data
- Integrated data from multiple sources including HDFS to Hive Data warehouse
- Designed both 3NF data models for ODS (Operational Data Store), OLTP systems and dimensional data models using Star and Snowflake Schemas
- Translate business and data requirements into logical data models in support of Enterprise Data Models, Operational Data Structures and Analytical systems
- Partner with DBAs to transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database
- Used Agile Methodology of Data Warehouse development using Kanbanize
- Work with Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata
- Developed Full life cycle of Data Lake, Data Warehouse with Big data technologies like Spark and Hadoop
- Applied all phases of the Software Development Life Cycle, which include requirements definition, analysis, review of design and development, and integration and test of solution into the operational environment
- Worked on Azure Power BI (Business Intelligence) Embedded to integrate the reports to application
- Created data schema and architecture of data warehouse for standardized data storage and access
- Used data profiling automation to uncover the characteristics of the data and the relationships between data sources before any data driven
- Used Azure reporting services to upload and download reports
- Developed test scripts for testing sourced data and their validation and transformation when persisting in data stores that are physical representations of the data models
- Designed and documented Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio
- Completed enhancement for MDM (Master data management) and suggested the implementation
- Environment: ER Studio 9.0, Hive, Hadoop, MDM, MS Azure, HDFS, PL/SQL, SQL Server, Azure SQL DB, UNIX
Sr. Data Modeler
JB Hunt
AR
11.2018 - 03.2020
- Working as Sr
- Data Modeler with client to develop huge data warehouse with the help of MS Azure cloud and data modeling technique
- Generated Data Models using Erwin and developed relational database system
- Extensively used agile methodology as the Organization Standard to implement the data Models
- Worked in MS Azure provisioning and used MS Azure services
- Created semantically rich logical data models (non-relational/NoSQL) that define the Business data requirements
- Converted conceptual models into logical models with detailed descriptions of entities and dimensions for Enterprise Data Warehouse
- Involved in creating Pipelines and Datasets to load the data onto Data Warehouse
- Coordinate with Data Architects to Design Big Data, Hadoop projects and provide for a designer that is an idea driven
- Created database objects in AWS Redshift
- Followed AWS best practices to convert data types from oracle to Redshift
- Worked on NoSQL Databases as Cassandra
- Identified data organized into logical groupings and domains, independent of any application or system
- Developed data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema
- Created S3 buckets in the AWS environment to store files, sometimes which are required to serve static content for a web application
- Developed Model aggregation layers and specific star schemas as subject areas within a logical and physical model
- Identified Facts &Dimensions Tables and established the Grain of Fact for Dimensional Models
- Configured Inbound/Outbound in AWS Security groups according to the requirements
- Established measures to chart progress related to the completeness and quality of metadata for enterprise information
- Developed the data dictionary for various projects for the standard data definitions related to data analytics
- Managed storage in AWS using Elastic Block Storage, S3, created Volumes and configured Snapshots
- Generate the DDL of the target data model and attach it to the Jira to be deployed in different Environments
- Conducted data modeling for JAD sessions and communicated data related standards
- Investigate Data Quality Issues and provide recommendation & solution to address them
- Optimized and updated UML Models (Visio) and Relational Data Models for various applications
- Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
- Prepared reports to summarize the daily data quality status and work activities
- Environment: Erwin 9.7, NoSQL, Sqoop, Cassandra 3.11, AWS, Hadoop 3.0, SQL, Pl/SQL
Sr. Data Modeler/Data Analyst
Wells Fargo
St. Louis, MO
12.2016 - 08.2018
- As a Data Modeler/Analyst role to review business requirement and compose source to target data mapping documents
- Participated in design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment
- Researched and developed hosting solutions using MS Azure for service solution
- Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements
- Coordinated with the Business Analyst and prepared Logical and Physical Data models as per the requirements involving multiple subject areas, domains, and naming standards
- Built Data Warehouse in Azure platform using Azure data bricks and data factory
- Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications
- Developed data Mart for the base data in Star Schema, Snowflake Schema involved in developing the data warehouse for the database
- Designed both 3NF data models for ODS, OLTP systems and dimensional data models
- Prepared complex T-SQL queries, views, and stored procedures to load data into staging area
- Created and maintained data model standards, including master data management (MDM)
- I worked in importing and cleansing data from flat files, SQL Server with high volume data
- Explored NoSQL options for current back using Azure Cosmos DB (SQL API (Application Programming Interface))
- Created PL/SQL procedures to aid business functionalities like bidding and allocation of inventory to the shippers
- Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin
- Worked with project management, business teams and departments to assess and refine requirements to design BI solutions using MS Azure
- Created DDL scripts using Erwin and source to target mappings to bring the data from source to the warehouse
- Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS
- Created Project Plan documents, Software Requirement Documents, Environment Configuration and UML diagrams
- Worked on Data load using Azure Data factory using external table approach
- Developed the stored Procedures, SQL Joins, SQL queries for data retrieval, accessed for analysis and exported the data into CSV, Excel files
- Created data flow, processed documents, and ad-hoc reports to derive requirements for existing system enhancements
- Environment: MS Azure, Azure Data factory, Agile, 3NF, T-SQL, MDM, SQL, PL/SQL, Erwin 9.7, MS Visio 2019, ad-hoc, SSRS, SQL Server 2016, Azure Databricks
Sr. Data Analyst
VF Corp
Greensboro, NC
07.2014 - 11.2016
- As a Data Analyst analyzed data quality issues against source system and prepared a data quality document confirming all the source data quality
- Understand the data visualization requirements from the Business Users
- Developed data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema
- Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements involving multiple subject areas, domains, and naming standards
- Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects
- Performed in team responsible for the analysis of business requirements and design implementation of the business solution
- Developed and implemented data cleansing, data security, data profiling and data monitoring processes
- Extensively used Data Analysis for OLTP and OLAP systems
- Used SAS Import/Export Wizard plus SAS programming techniques to extract data from excel
- Written complex T- SQL, SQL queries using joins, sub queries and correlated sub queries
- Involved with data profiling for multiple sources and answered complex business questions by providing data to business users
- Developed and presented Business Intelligence reports and product demos to the team using SSRS (SQL Server Reporting Services)
- Used Informatica features to implement Type I & II changes in slowly changing dimension tables
- Developed database triggers and stored procedures using T-SQL cursors and tables
- Identified source databases and created the dimensional tables and checked for data quality using complex SQL queries
- Involved in data mining, transformation and loading from the source systems to the target system
- Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters
- Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent
- Developed UNIX Shell scripts to automate various periodically repetitive database processes
- Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests
- Environment: SQL, PL/SQL, OLAP, OLTP, BI, SAS, T- SQL, SSIS (SQL Server Integration Services), SSRS, Informatica, Tableau and UNIX
Data Analyst
Persistent
Hyderabad, India
10.2013 - 06.2014
- Designed and implemented business intelligence to support sales and operations functions to increase customer satisfaction
- Involved in data analysis, data discrepancy reduction in the source and target schemas
- Developed complex PL/SQL procedures and packages using views and SQL joins
- Developed reports using different SSIS Functionalities like sort prompts and cascading parameters, Multi Value Parameters
- Conducted detailed analysis of the data issue, mapping data from source to target, design and data cleansing on the Data Warehouse
- Involved in identifying the Data requirements and creating Data Dictionary for the functionalities
- Analyzed and built proof of concepts to convert SAS reports into tableau or use SAS dataset in Tableau
- Created or modified the T-SQL queries as per the business requirements
- Developed and optimized stored procedures for use as a data window source for complex reporting purposes
- Performed the batch processing of data, designed the SQL scripts, control files, batch file for data loading
- Coordinated with data stewards / data owners to discuss the source data quality issues and resolving the issues based on the findings
- Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources
- Involved with data profiling for multiple sources and answered complex business questions by providing data to business users
- Worked on SQL Server concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services)
- Developed database objects including tables, Indexes, views, sequences, packages, triggers, and procedures to troubleshoot any database problems
- Worked on different data formats such as Flat files, SQL files, Databases, XML schema, CSV files
- Involved in designing Parameterized Reports for generating ad-hoc reports as per the business requirements
- Environment: SAS, Tableau 8.1, Ad-hoc, SQL, T-SQL, Flat Files, SSIS Vs 2013, SSRS, SSAS, SML, Business Intelligence
Education
B-Tech
University of Osmania
Hyderabad, IndiaSkills
- Erwin 2022 r12
- Erwin 2020 r1
- ER Studio v17
- SQL
- PL/SQL
- HTML
- XML
- SSRS
- SSAS
- Tableau
- Informatica
- MS-Excel
- GCP
- AWS
- MS Azure
- Google Big Query
- Teradata R16
- Teradata R15
- MS SQL Server 2018
- MS SQL Server 2017
- Oracle 12c
- Oracle 11g
- DB2
- Windows
- UNIX
- RAD
- JAD
- RUP
- UML
- SDLC
- Agile
- Waterfall Model
- Bitbucket
- Atlassian products
Timeline
Data Modeling
PepsiCo
12.2023 - Current
Sr. Data Modeler
Charles Schwab
01.2022 - 09.2023
Sr. Data Modeler
Quantum Health
04.2020 - 12.2021
Sr. Data Modeler
JB Hunt
11.2018 - 03.2020
Sr. Data Modeler/Data Analyst
Wells Fargo
12.2016 - 08.2018
Sr. Data Analyst
VF Corp
07.2014 - 11.2016
Data Analyst
Persistent
10.2013 - 06.2014
B-Tech
University of Osmania