Abdullah Mohammad Email & Phone Number

Oakville, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Create data design and assists software engineers in data source discovery and Metadata capture. • Implements and enforces data definitions, standards and procedures relating to logical design.• Incrementally develop conceptual, logical and physical data models for new database objects.• Define data requirements and business rules, perform logical and physical data modeling, implement and test database design. • Used different ER Model techniques such as Parent Child, 'Associative', Sub Type Super Type, etc. to develop the data model.• Identified and Analysis of various facts from the source system and business requirements to be used for the data warehouse• Implementing Data warehouse solutions in Confidential Redshift to migrate data from on premise databases to Confidential Redshift, RDS(PostgreSQL) and S3.• Generating DDL scripts for both Redshift and S3 from ER Modeler.• Providing day to day data administration related tasks for ETL team related to AWS Redshift and S3.• Created S3 buckets in the AWS environment to store files, sometimes which are required to serve static content for a web application.• Configured S3 buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirement.• Coordinate data models, dictionaries and other documentation across multiple applications. • Handled data modeling and administration, advocating for data management principles and worked in a team environment.• Created physical data models with the details necessary for a complete physical data model, including the appropriate specifications for keys, constraints, Indexes and other physical model attributes.• Extensively worked with Embarcadero ER/Studio Repository Checkout and Check in Models and sub models, using Compare and Merge Utility and Reverse engineering the Data Models from the Database.• Followed Enterprise standards for both design and quality management of the project data models.

Toronto, Ontario, Canada

Involved in interaction with business and SME’s for gathering the requirements.• Worked with the legacy team in understanding the data flow and to perform effective migration from source to target.• Thorough study of understanding the source to target mappings by involving in regular interaction with the subject matter experts. • Involved on the architectural role to design and develop EDW program initiative.• Involved in design and conversion of business requirements to conceptual data model, logical data model and physical data model for subject areas using ER/Studio.• Performed Data Profiling and Data Quality using Oracle SQL Developer and Teradata Database.• Queried the databases, wrote test validation scripts and performed the system testing.• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.• Developing source to target mapping document.• Responsible for defining the key identifiers for each mapping/interface.• Worked on Oracle SQL Developer and SAP to analyze the source information.• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to Target systems using Informatica.• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.• Perform deployments of DDL objects in Teradata using UCD and repository as GitHub.• Interact with various data teams, document goals, and provide input to solution requirements• Ensure data integrity and consistency across Enterprise Database.• Maintain and support Teradata architectural environment for EDW Applications.• Modification of views on Databases, Performance Tuning and Workload Management. • Performed application level DBA activities creating tables, indexes, and monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.• Performed Space Management for Perm & Spool Space.

Sydney, New South Wales, Australia

Design, develop and implement changes/enhancements with key technical components of the solutionrelated to Medicare data.• Creating multiple Tableau dashboards to visualize the business analysis and creating post campaign reports.4 of 5• Analysis campaign data received from different media owners across Online, Radio,TV, Newspapers and Magazines.• Creating Online post campaign reports by extracting data from Online campaign manager platforms like Google Ads manager, Meta Ads manager and Snap Chat manager.• Creating Offline post campaign reports by processing data in Excel by using features like PIVOT and required calculations to get output metrics like (Reach, Connections, Impressions, Average Frequency etc,)• In depth analysis of delivered report compared to planned media campaign.• Working with media team to ensure delivery of reports to clients successfully and frequently catch up with the Media team if any under delivery in campaign metrics.Role: Data Analyst• Understanding the requirement from the customers and creating a design document to finalize the number of dashboards or graphs, graph type & algorithms and business logics required with coding in Python.• Extract data from research platforms, such as Asteroid or GWI and store them in secure locations.• Create and Maintain templates using Excel Macro’s by using VB codes to work efficiently.• Create procedures and checklists to improve data quality and consistency.• Update CDFs with new data and get it ready to push into the Precise platform (Company Campaign Planner Platform).• Check the quality of data and ensure consistency.• Connecting Tableau and Power BI to SQL database and creating designed dashboards iterative work on Formatting, alignments and look n feel of dashboard.• Data quality testing by comparing output of the dashboard with the database.• Functional testing by checking filters, navigation etc• Publishing dashboards on the server and giving access to users.

Hyderabad, Telangana, India

• Involved in the design of the overall database using Entity Relationship diagrams.• Established frameworks for ER modeling, database design and schema maintenance.• Created normalized models for various OLTP applications.• Involved in the coding of stored procedures and triggers using PL/SQL for various business requirements.5 of 5• Designed and developed all the tables, views for the system.• Modifying the database design and as necessary from time to time upon information given by the application users and developer.• Designing and developing forms validation procedures for query and update of data.• Created, deployed and managed complex SSRS Reports in a SQL environment according to product owner specifications.• Developed reports that assist teams in forecasting response levels for each markets.• Used Integration Services (SSIS) for ETL (Extraction, Transformation and Loading), Reporting Services (SSRS) for creating different types of reports and Analysis Services (SSAS) for designing and developing complex cubes.• Created automatically running stored procedures for day-end operation using SQL server agent.• Used SSRS to generate sub-reports, drill down reports, drill through reports and parameterized reports.• Developed several complex reports using SQL server reporting services (SSRS). • Hands on experience on handling complex SQL queries, Stored Procedures, Indexes, Triggers and Joins.Environment: Visio 2015 v14.0, Oracle 10G, PL/SQL Developer, Microsoft SQL 2014 Server, Microsoft SQL Management Studio, Microsoft SQL 2014 Integration Services, Microsoft SQL 2014 Reporting Services, Microsoft SQL 2014 Analysis Services, PL/SQL, Forms 4.5, Reports 2.5, Windows NT.

Master'S Degree, Information Technology

Bachelor Of Engineering - Be, Mechanical Engineering

Education record