AMIT DHIMAN

Data Analyst & Specialist

MS Certified Data Analyst Associate

MBA, MCA, MCP, BCA

Certified Data Analyst Associate
MS Certified Web Professional

CFA Investment Foundation Certified

Mobile: +971 581839685

emails@amitdhiman.com

https://amitdhiman.com

https://cv.amitdhiman.com

https://blog.amitdhiman.com

 Current Location

Abu Dhabi, UAE

 Industry Experience  

·       Investment Banks

·       Asset Management

·       Financial Management

·       Energy

 Technology Expertise

·       Data Analysis

·       Business Intelligence

·       Report Development

·       Data warehouse

·       Data Integration

 Education

·       MBA

·       MCA

·       BCA

 Certifications

·       CFA-Investment Foundation

·       MCDAA (Data)

·       ITIL Foundation Level

·       MCP (Web)

·       Web Architecture from SSI - 2003

·       Java Technology from SSI – 2003

Awards

·       Core Value (Creativity)

·       Core Value (CFD)

·       Kaizen

·       Best Performance Team

 PROFILE SUMMARY 

Currently working as a BI /Integration Specialist and Solution Architect and having about overall 15+ years of experience in Information Technology (IT). Recent system implementation done by me were SSIS and Power BI Server. My current expertise are Data Designing, Business Intelligence and Data Analysis, Report development, Data Integration (ETL) and users support for BS applications for about 2.8 years in the Council.

Prior to the Council, I worked for a capital management project as a Data Architect & Specialist. I also led Tableau BI project as a Tableau BI Architect in my other previous engagements in publicies.sapient. I also worked for an energy/commodity project. I have acquired over the years a comprehensive technical understanding of designing solutions, integration, database design and methodology from multiple perspectives and hands-on experience in designing, developing, and implementing Reporting systems, Data warehouse, and Business Intelligence solutions.

 EXPERIENCE 

ABU DHABI INVESTMENT COUNCIL, ABU DHABI, UAE ....................................... (MAY 2019 – PRESENT)

DATA ANALYST, BI SPECIALIST

Integration: Bloomberg feeds, SWIFT data feeds, SSI feeds transformation

Framework: ETL Framework for integration monitoring automations, BISAM API integration in python, SWIFT data integration framework

Data Analysis / Report Development: All Tableau reports of BA team were migrated to Power BI, Report development for AFS team and other departments

Solution Architecture: Implemented the centralized integration (ETL) system and Power BI reporting server in the Council, Database solutions designing for various enhancements

Support: Supporting the users for eFront, Power BI reports, Bloomberg, applications upgrade, patching and ETL job monitoring etc.

PUBLICIS.SAPIENT CONSULTING, PVT., LTD, GURGAON, INDIA ...................... (DEC 2009 – MAY 2019)

# OCHZIFF Capital Management (An HNW Capital Management Firm), USA

Data Architect & Specialist - Storing the data into Data warehouse for RISK, Fund Positions, Securities and other referenced data, Market Data (Bloomberg) and Market Values are the common areas

# Brown Advisory (An HNW Investment Firm), USA

Tableau & Data Architect - Maintaining Data Warehouse for Reference data, Transaction and Fund Position

# ADIA, Abu Dhabi, UAE - (Abu Dhabi Sovereign Wealth Fund)

BI/Reports Lead - Maintaining of Reports of Fixed Income for example, Trade Data / Transactions, Position, Pricing etc.

# Brown Advisory, USA (HNW Asset and Portfolio Management)

Lead Analyst - Maintaining Data Warehouse for Reference data, Transaction and Fund Position, Performance (Portfolio performance over the period e.g.: Since inception), Asset Allocation (Bucket in Groups)

# Unicorn Data Management, RBS, London, UK

Lead BI Developer - Reports of various data migration activity from source to Unicorn application using salesforce implementation / customization

# CHEVERON – An Oil Commodity Trading and Risk Management Project

Sr. SQL Developer - Implementing Commodity based application. Involvement in reconciliation reports for Account Receivable and Account Payable

INCA INFORMATICS, PVT LTD, NOIDA, INDIA ......................................................... (AUG 2007 – DEC 2009)

THEIKOS, GURGAON, INDIA ......................................................................................... (DEC 2006 – MAY 2007)

CLASSIC INFORMATICS PVT. LTD., DELHI, INDIA .................................................. (APR 2006 – DEC 2006)

PATNI COMPUTER SYSTEMS LTD., NOIDA, INDIA .................................................. (DEC 2003 – APR 2006)

SELF-FUNDED PROJECTS FOR SOCIAL HELP

# Full Stack Owner – https://www.citymatrimony.com

 PROFESSIONAL CREDENTIALS 

CFA Investment Foundation, CFA Institute – 2022

Microsoft Certified Data Analyst Associate, Microsoft – 2021

Finance for Non-Finance Professional, Rice University – 2020

Introduction to Financial Markets, Indian School of Business – 2020

ITIL Foundation Level - 2019

Microsoft Certified Professional (Web), Microsoft - 2006

 ACADEMIC CREDENTIALS 

MBA, Sikkim Manipal University, India 2011

MCA, Sikkim Manipal University, India- 2006

BCA, Kurukshetra University - 2003

 TECHNICAL SKILLS 

·       Reporting and Analytics, Business Intelligence, Data Migration, Data Integration, Data Mart, Data Warehouse, ETL, Analysis and Reports Automation

·       ETL Data Integration - SSIS & SQL Server 2016

·       Reporting – Power BI, Tableau, eGlue Reporting

·       Programming – Python, C#

·       Database Performance Tuning

·       IBM Cognos BI - 1 Year

·       Early Stages

·       SAP-BI Reporting

·       Salesforce CRM (About 1 year)

·       Web Development

·       ESRI, ArcGIS (2.5 Yrs. in Telecom)

·       Interface/Integration Technology – 1 Year

·       VBA Applications, Excel Reports automation – 2+ Years

·       Open Source (Laszlo, CMS tools e.g.: WordPress, Joomla, phpBB, Drupal)

·       Knowledge of SEO (Search Engine Optimization)

 AWARDS 

Invited Speaker: by Delhi Technological University, 2014

Core Value: Creativity (Team Sparks – Sapient), 2012

Core Value: Client Focus Delivery (Team Sparks – Sapient), 2012

Kaizen Award for Developing Reports Automation System, Patni Computers, 2003

Best Performance Team Award, Patni Computers, 2003

 TRAININGS 

AZURE POWER PLATFORM provided by Microsoft, 2020

IBM COGNOS 8 Reporting, 2010

SAP BI/BW, 2009

Object Oriented Designs, provided by ICalibrator, 2008

SALESFORCE Implementation by Theikos, 2006

 PERSONAL DETAILS 

Nationality                               Indian

Language Known                    Hindi & English