Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Mohsin Hashmi

Mohsin Hashmi

Sr. Data Architect

44 years old
Driving License
Dubai (500500) United Arab Emirates
Employed Open to opportunities
Mohsin has around 12 years of experience in the I.T. Industry of which 10 years has been
engaged in as Data Architect, Information Architect, Master Data Management (MDM) Lead,
DataFlux Data Quality and Governance consultant, Data Mapping, and Informatica ETL Lead
delivering OLTP and OLAP databases implementation, Customised development, Support &
Maintenance, Migration & Upgradation projects.Experience in diverse business domains
including Gas Transmission, Insurance, B2B Application, Credit Cards, Automobiles,
Mortgage and dealer management systems. He has extensive experience leading technical
teams of up to 10 consultants globally, has the ability to work as a team player and
continually meets deliverables to aggressive deadlines.
Expertise in Master Data Management design and development and implementation.
Expertise in Data Quality analysis and Governance using DataFlux.
Expertise in ETL design, development for BI systems using Informatica and Data
Architecture.
Ample experience in-
Requirement gathering, conceptual data modelling, logical data modelling and physical data
modelling.
Standardising the Enterprise data model and setting up of corporate level database
standards.
Data Warehouse data analysis and data mapping.
Oracle PL/SQL, SQL and oracle database concepts.
Possess excellent written and verbal communication skills.
Have good team leadership skills and invariably meet client expectations.
Mohsin spent over 7 years as a Senior Data Architect for various clients including National
Grid UK, Prudential Scotland, Assurant Minneapolis Minnesota USA, Cisco Systems
California USA, American Express Phoenix USA, DaimlerChrysler Germany and Ameriquest
Mortgage.
While in the UK Mohsin is working as a freelance contractor since November 2011, now is a
Data Architect at The Scottish Government Project since November 2013.
Resume created on DoYouBuzz

Sr. Data Architect

AXA Gulf
Since 2016
Consultant
Dubai
United Arab Emirates
  • Data Cleansing & Deduplication
  • Customer 360 View
  • Data Quality & Data Governance
  • Master Data Management
  • Power BI & Tibco Spotfier data visualization
  • Data Virtualization and Business View
  • Data Lake setup
  • SSIS ETL integration
  • Data Modeling & Data Dictionary
  • Enterprise Data Architecture
Learn more

Sr. Data Architect

The Scottish Government
2013 to 2016
Consultant
Edinburgh
United Kingdom
  • Data requirements elicitation and analysis
  • Data modelling (conceptual, logical and physical levels)
  • Architect for the development of data standards and the overall information
  • Design maintains the Data Dictionary Manages business semantics
  • Contributes to data quality and integration jobs
  • Data migration strategy
  • Data marts for analytical reporting
Learn more

Information Architect

National Grid
December 2012 to October 2013
Consultant
Warwick
United Kingdom
  • Data modelling conceptual, logical, physical. Interpretation, creation and delivery of data models
  • Interpretation of business requirements into the full data lifecycle
  • Master Data Management roadmap
  • Data Quality & Governance development and delivery
  • Working with other architects to ensure a consistent view across all layers of the architecture
  • Developing enduring data process, procedures and models
  • Information governance and controls, establishment and delivery
  • Stakeholder management, negotiation and presentation
  • Create case studies to explain business about technology, data constraints in non-technical language
  • Data migration strategy
  • Data security and integration
  • Data marts for analytical reporting
Learn more

Data Architect

Zensar Technologies - Prudential Financial
December 2011 to November 2012
Full-time
Stirling
United Kingdom
  • Design and development of Phase 3 Migration project for Business Intelligence
  • Requirement Analysis of data migration need to BI and data marts in phase 3
  • Data Quality analysis & reporting
  • Meeting with business users and data stewards for requirement reviews
  • Design and Development of ETL loads to EDW and DataMarts
  • Shell Scripting and NT DOS scripting pre and post Informatica workflows execution
  • Maestro job scheduling and maintenance for Informatica loads
  • Plan and/or Manage ETL team tasks and activities
  • Weekly status reports for ETL team
  • Involved in creating MDM proposals
  • Proposed MDM architecture and various design approaches to clients for MDM implementation
  • Part of COE (Centre of Excellence) for master data management in BI practice
Learn more

Data Architect

Zensar Technologies - Assurant Corporate Technology
January 2011 to December 2011
Full-time
Woodbury
United States - Minnesota
  • Meta Data Management
  • Enterprise Data Model standards and best practices
  • Data Profiling and analysis
  • DataFlux architect job for reports reconciliation
  • Data Architecture, conceptual logical & physical Data modelling
  • Integration with Master Data Management System
  • Requirement Analysis of Data Marts
  • Meeting with business users and data stewards for requirement reviews
  • Data Marts Design
  • ETL design and development in Informatica
  • Shell Scripting for Informatica workflows
  • Scheduling and maintenance for Informatica jobs
  • Plan and/or Manage ETL team tasks and activities
  • Weekly status reports for ETL team
Learn more

MDM Architecture

Zensar Technologies - CISCO Systems
January 2010 to December 2010
Full-time
Pune
India
  • Requirement gathering for MDM
  • Meeting with business users and data stewards for requirement reviews
  • MDM Architecture and Design
  • DataFlux data architect jobs development for data quality monitoring and control
  • DataFlux data Profiling and for Master Data Management (MDM)
  • ETL Design & development in Informatica
  • Baseline reports and data cleansing using dataflux jobs
  • MDM strategies and approaches
  • Data Architecture & conceptual logical & physical Data modeling
  • Data Base Schema creation and Change Management
  • DataFlux profiling and monitoring jobs
Learn more

Data Architect

Zensar Technologies - CISCO Systems
October 2008 to December 2010
Full-time
Pune
India
  • Requirement gathering for database design
  • Requirement reviews with business users
  • Logical and Physical database design and development
  • Database design strategies and approaches
  • Data Architecture & conceptual logical & physical Data modeling
  • Data Base Schema creation and Change Management
  • PLSQL programming for database development
  • Test Data Setup and Data Preparation
Learn more

Data Architect

Syntel Limited - American Express
February 2007 to July 2008
Full-time
Phoenix
United States - Arizona
  • Requirement gathering for database design
  • Meeting with business users for requirement reviews
  • Planning for Logical and Physical database design deliveries
  • Propose designing approaches and evolve database design
  • Data Architecture & conceptual logical & physical Data modeling
  • Data Base Schema creation and Change Management
  • ETL Mapping from source database to destination database
Learn more

Data Architect

Tata Consultancy Services - DaimlerChrysler
April 2006 to February 2007
Consultant
Mumbai
India
  • Defining Database design process
  • Setting up database modelling standards
  • Planning for Logical and Physical database design deliveries
  • Propose designing approaches and evolve database design
  • Gather requirements with business analyst and convert to design
  • Data Architecture & Data modelling
  • Data Base Schema creation and Change Management
  • ETL Mapping from source database to destination database
Learn more

Data Modeller

Tavant Technologies - Ameriquest Mortgage
October 2004 to March 2006
Full-time
Bangalore
India
  • Setting up database modelling standards
  • Planning for Logical and Physical database design deliveries
  • Propose designing approaches and evolve database design
  • Gather requirements with business analyst and convert to design
  • Data Architecture & Data modeling
  • Data Base Schema creation and Change Management
  • ETL Mapping from source database to destination database
  • Database access layer development
Learn more

Java Developer / Data Modelling

Tavant Technologies - Bobcat Ingersoll-Rand
October 2003 to October 2004
Full-time
Bangalore
India
  • Data Architecture & Data modeling
  • Data Base Schema creation and Change Management
  • Entity & Session Lear API Development
  • Data Access layer development Spring Hibernate
Learn more

MCA

University Of Pune

May 2001 to April 2003
Master of Computer Application

B.Sc

SRTM University Nanded

May 1997 to May 2000
Bachelor of Science (Mathematics, Statistics, Computer Application)
  • Data Strategy
  • Data Modelling
  • Data Dictionary
  • Report Catalogue
  • Enterprise Architecture
  • Architecture Blueprint
  • MDM approaches
  • MDM Architecture
  • MDM Roadmap
  • Data Cleasing
  • Data Deduplication
  • Data Governance
  • DataFlux Studio
  • ERWin
  • Embarcadero ERStudio
  • Innovator
  • Visio
  • Rational Rose
  • Informatica
  • TOAD Data Modeller
  • Eclipse Data Modeller
  • Oracle 8/8i/9i/10G/11G
  • SQL Server 2014
  • MySQL
  • DB2
  • Cricket