196 Reputation
0
0
6
Michael Nabavian
Mentor
Rising Codementor
US$11.00
For every 15 mins
ABOUT ME
Database professional with 20+ years experience
Database professional with 20+ years experience
Currently a data architect, I have spent my career working with relational databases, producing data models, writing SQL, and supplying ETL specifications to developers. I enjoy solving difficult problems, and look forward to helping you solve yours!
London (+01:00)
Joined September 2020
EXPERTISE
20 years experience
Proficient in SQL. Experience with a variety of DBMS's, from SQL Server to Netezza to Oracle. Writing queries to meet any and all require...
Proficient in SQL. Experience with a variety of DBMS's, from SQL Server to Netezza to Oracle. Writing queries to meet any and all requirements, including highly complex ones. Writing stored procedures, including T-SQL stored procedures. Writing queries tailored to data extraction and intended for use as Informatica source qualifiers.
16 years experience
Working with a range of RDBMS platforms, especially SQL Server and Netezza but also including past experience on Oracle, Ingres, and DB2....
Working with a range of RDBMS platforms, especially SQL Server and Netezza but also including past experience on Oracle, Ingres, and DB2. Database design. Writing of SQL and DDL. Writing of stored procedures. Troubleshooting queries. Finding and resolving performance bottlenecks. Designing databases, Data Warehouses, Data Marts. Designing extract / transform / load (ETL) processes to populate a target database.
15 years experience
Designing Data Warehouses. Designing Operational Data Stores. Designing inbound interfaces into the Data Warehouse. Data modelling for st...
Designing Data Warehouses. Designing Operational Data Stores. Designing inbound interfaces into the Data Warehouse. Data modelling for star schemas, snowflake schemas. Kimball method and other approaches.
REVIEWS FROM CLIENTS
Michael's profile has been carefully vetted and approved as a Codementor. Connect with Michael now, and leave a review for them once you're done!
SOCIAL PRESENCE
EMPLOYMENTS
Data Architect
Axa XL
2013-10-01-Present
Consulting on data architecture questions; producing data model for Combined Operational Data Store, Delegated Authority database, and ot...
Consulting on data architecture questions; producing data model for Combined Operational Data Store, Delegated Authority database, and other databases; writing numerous ETL specs for interfaces to warehouses etc. and for data migrations; leading teams of ETL analysts.
SQL
Netezza
Microsoft SQL Server
View more
SQL
Netezza
Microsoft SQL Server
erwin
View more
Data Warehouse Analyst
Catlin
2009-08-01-2013-09-01
Delivered Enterprise Data Dictionary; delivered enhancements to Operational Data Store and Enterprise Data Warehouse; designed database b...
Delivered Enterprise Data Dictionary; delivered enhancements to Operational Data Store and Enterprise Data Warehouse; designed database backend and inbound interface for a new Cedant Performance tool; delivered a large number of ETL specs and refactored existing ETL processes.
SQL
Netezza
Microsoft SQL Server
View more
SQL
Netezza
Microsoft SQL Server
erwin
View more
BI Lead Modeller / Analyst
British Sky Broadcasting
2007-08-01-2009-07-01
Gathered requirements for extensions to Airtime Sales Data Warehouse, specified new tables and enhanced existing ones and specified ETL l...
Gathered requirements for extensions to Airtime Sales Data Warehouse, specified new tables and enhanced existing ones and specified ETL logic additions and changes. Modelled, designed, and built a tactical stopgap single-user system for Airtime Sales Reconciliations. Successfully argued for replacement of Hyperion-based Forecasting system with RDBMS-based alternative. Specified the database design and ETL for this, both of which were then implemented and achieved a nightly batch duration of just 5 minutes.
SQL
Oracle
Microsoft Access
View more
SQL
Oracle
Microsoft Access
View more