PDF Version

AMIT KR. DHIMAN

Data Architect & Specialist

MCP, MBA, MCA, BCA

 

Total 13+ Yrs. of Experience


Online Profile:
cv.amitdhiman.com

Blog: blog.amitdhiman.com

Email: email@amitdhiman.com, emails.amitdhiman@gmail.com

Mobile: +919910099505

 

 

 

 

Summary

I am working as a BI /Data Architect & Specialist and have about overall 13+ years of experience in Information Technology (IT). My current expertise are Data, Business Intelligence, Reporting, Data warehouse and Integration (ETL) for about 8 years in Sapient.

 

I have been leading one of the capital management projects as a Data Architect & Specialist. I also led Tableau BI project as a Tableau BI Architect as my recent previous engagement in sapient. My previous project in sapient were Investment Banks and energy/commodity. I have acquired over the years a comprehensive 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.

Current (8 years)

·         Reporting and Analytics, Business Intelligence, Data Mart, DWH and ETL, Analysis (Approx. 8 years)

§  SSIS & SQL Server 2016, Migration & integration of a legacy system to the current used technolog

§  Tableau, A Data analytical tool to present current state, various growth and improvement areas of a business graphically. (Integration with Salesforce)

§  eGlue Reporting: CTECH proprietary tool used for ADIA (CTECH FIT) in reporting, analytics and reconciliation reporting. Used Informatica to load data from various sources.

§  Microstrategy: Evaluated (as POC) in start of eGlue project in ADIA (CTECH FIT). Used in Sapient’s data capability team to build sample analytics reports.

§  Performance Tuning, Database designing, Database Modeling, SQL Script Coding, Replication, Data Switch Scripting, SQL Server Mailing system (HTML formatted), Setting Server for SSIS on distributing environment, SSIS, Automating jobs using SQL Server Agent, SSAS Cube Designing / Modeling,  SSIS C# Component scripting.

§  IBM Cognos BI - 1 Year

Previous (6+ Years):

·      SAP-BI Reporting - Generic, custom extractor, ABAP, Cubes, DSO, Administrative Workbench, Bex Query Designer, Webi (BO) etc. (About a year)

·      Salesforce CRM (About 1 year) – Tools used: Salesforce.com (Customization, Development SFDC, APEX, Triggers etc.)

·      Web Development - .Net (C#, asp.net, MVC.net 4), JavaScript, jQuery, HTML, CSS – 2+ years

·      ESRI, ArcGIS and Telecom Network Engineer GIS based Tool (2.5 Yrs. in Telecom)

·      Interface/Integration Technology - Web Service, Windows Service – 1 Year

·      VBA Applications, Excel Reports automation – 2+ Years

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

·      Knowledge of SEO (Search Engine Optimization)

Work Profile

 

# SAPIENT CONSULTING, PVT., LTD, GURGAON, INDIA       (DEC 2009 – PRESENT)

 

# Data Architect & Specialist, Ochziff Capital Management (An HNW Capital Management Firm), USA

Oz Management is a global, diversified alternative asset management firm with a range of fully-integrated platforms across Multi-Strategy, Credit, Real Estate and Energy

 

§  Providing expertise in data and integration of applications for Ochziff client

§  Reverse Engineering of a legacy tool and converting the requirement to new application

§  Managing RAIDs (Risk and Issue/Defects) document

§  Data Analysis, Data management, Data warehousing and working on queries

§  Designing architecture and designing technical documents

§  Performance Tuning

§  Co-ordination and Project status update

 

Tools Used: SQL Server 2016, SSIS

 

#Tableau & Data Architect, Brown Advisory (An HNW Investment Firm), USA

Brown Advisory is an independently-owned investment firm committed to safeguarding and generating clients’ wealth.  Brown Advisory maintains Asset and Portfolio management of United States' HNW people.

 

§  Managing data track of 12 people in Brown Advisory and Track

§  Estimation, Planning, Tracking, Requirement gathering and Documentation etc.

§  Data Analysis, Data management, Data warehousing and Query

§  Designing architecture and designing technical documents

§  Estimation and client calls discussion (Negotiating release items and dates)

§  Performance Tuning

§  Co-ordination and Project status update

 

Tools Used: Tableau, SQL Server 2012, SSIS, Salesforce

 

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

ADIA is an investment firm committed to prudently investing funds on behalf of the Government of Abu Dhabi with a focus on long-term value creation.

 

§  Responsible for reconciliation reporting solutions and other FIT reports

§  Responsible for ETL (Informatica packages) required for eGlue reporting

§  Design and development overall eGlue and ETL project architecture

§  Requirement gathering and analysis of data, translating the requirement into technical document

§  Task Estimation and Calls to product vendor (CTECH) (Resolutions and Negotiating defect items and dates)

 

Tools Used: eGlue, CTECH Suit, SQL Server 2012, Datawarehouse, ETL, Informatica, TSQL, Microstrategy (POC)

 

Brown Advisory, USA (High Net-Worth Asset and Portfolio Management)

Lead Analyst

 

Brown Advisory is an independently-owned investment firm committed to safeguarding and generating clients’ wealth.  Brown Advisory maintains Asset and Portfolio management of United States' people.

 

§  Managing data track of 7 people in Brown Advisory and Track (Managing task, tracking LLP, Creating Plan, and Estimation etc.)

§  Development ETL Packages (I also develop ETL packages in SSIS and provide feasible solutions to team)

§  Design Documents and database modeling

§  Estimation and client calls discussion (Negotiating release items and dates)

§  Performance Tuning

§  Warehouse and Database Performance Tuning

§  Requirement gathering and preparing Design Documents

§  Data Analysis, Data management, Data warehousing and Query

§  Designing architecture and designing technical documents

§  Designing Business Flow and other design diagrams

§  Team status and client dashboard

 

Tools: SSIS, SSAS, MDX, SQL Server 2012 and Data Warehouse

 

 

# Unicorn data management, RBS, London, UK

Track Lead / Sr. BI Developer

 

Unicorn Data Management Project has been created on merger of ABN AMRO bank with RBS. The complete data merging with RBS is all about Unicorn Data Management.

 

The purpose of the project was to collaborate and integrate the data/clients in ABN to RBS. Multiple technologies tools have been used to accomplish this process.

 

Module: Novation Tracker - (Sr. BI Consultant)

Novation tracker is a client, agreement, work stream tracking system which gets data from different feeds and after managing / setting different level agreements then it sends data to different systems to integrate.

 

Tools: SAP-BI/BW (ETL, Reporting in Excel, Web), Salesforce, APEX, Cozyroc, SSIS, SQL Server 2008 R2

 

 

# Chevron – A Trading and Risk Management Project

Sr. SQL Developer

Chevron is one of the world's largest integrated energy companies. Headquartered in San Ramon, Calif., Chevron conducts business worldwide. It is engaged in every aspect of the crude oil and natural gas industry, including exploration and production, manufacturing, marketing and transportation, chemicals manufacturing and sales, geothermal energy, and power generation. It is also investing in renewable and advanced technologies.

 

The purpose of the project was to collaborate and integrate the systems used in Chevron and multiple technologies tools have been used to accomplish this. Developing Derivative and SAP reports is a part of that integration.

 

Error Reports End to End Implementation- (Sr. BI Consultant)

Show the errors occurred while processing different interfaces used in Chevron Integration system to other systems. This report show the complete navigation to error analysis why an interface has failed during data transfer.

Tools: SAP-BI/BW (ETL, Reporting in Excel, Web and Cognos, SQL Server 2008)

 

SAP Accounting / VolumeOnly Data Reports Implementation: (Sr. BI Consultant)

Show the data flow and approval of accounting receivables and payables. These reports also have error report for the two corresponding reports which show not successful status of the two and why.

 

Using the above reports reduce the turnaround time in the reporting and completion of repair work on any communication. 80% testing of SAP/Derivative interface data transfer also done by SAP reports and derivative reports respectively.

Tools: SAP-BI/BW (ETL, Reporting in Excel, Web, PowerBuilder and COGNOS, SQL Server 2008), Along with AR/AP data from SAP FICO.

 

Derivative reports Implementation – (Sr. BI Consultant)

Derivative reports includes physical commodity data, future data deal captured in Solarc RightAngle. Reports analysis work done in COGNOS framework and SQL Server Scripts. These reports mainly includes the derivative daily trade, month’s view trade and summary of trades, Opened trades status.

Tools: COGNOS, SQL Server 2008

 

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

 

PMG – An Electricity NETWORK MANAGEMENT PROJECT [USA]

Project Lead / Track Lead

PMG is an electrical network management system. This has various controls on power and network. Power network is managed by a GIS application where complete power network can be viewed and managed graphically. This application has various phases, current it is in 1st phase. NMS has the functionality of reading meters data, showing HV, MV, LV lines and other electrical inventories on the map, exporting meter data to other formats. This contains the following components/areas:

-       NMS (Network Management System, network managed graphically on the client application that is used to )

-       Load management, Network analysis (Controls in electricity theft)

-       Portal (Public portal for interaction user for billing, reports, etc.)

-       Gateway (Central database for a power station, pings meters/meters bank/transformer meter in a specific time.)

 

 

·         Leading PMG project with single point of contact, Managing team, Handling PMG client

·         Requirement Gathering and Analysis, Designing/Review HLD, DDD and code, Designing and Development of Technical Architecture of the project


Tools USED:

o    .NET [C#, ASP.NET], SQL Server 2005, Meter APIs, XML

 

# NGEDT –A Telecom NETWORK INVENTORY MANAGEMENT

 

About NGEDT:

NGEDT (Next Generation Engineering Design Tool) is a telecom inventory management system which will help AT&T to manage their telecom network graphically. This is being developed for users, who want to design and analyze their network inventory graphically on Network Engineer (Product of Telcordia). NGEDT project is own by AT&T and a part of it, customized by INCA. This project is going through with complete SDLC process.

 

This project is a GIS based network inventory system i.e. developed on Network Engineer extension.

 

 


Tools USED:

.NET [C#], Oracle, ArcGIS, Network Engineer, ArcObjects, NEAPI

 

THEIKOS, GURGAON, INDIA                                                                (DEC 2006 - MAY 2007)

(Ensemble)

 

# MITT ROMNEY – AN EVENT MANAGEMENT WEBSITE (Salesforce.com)

Sr. Developer

 

About Mitt Romney:

Former Massachusetts Governor Mitt Romney has been widely recognized for his leadership and accomplishments as a public servant and in private enterprise.

 

This site has been developed under salesforce implementation.

 

 

Tools USED:

.NET [C#, ASP.NET], ATLAS/AJAX Technology, Sql Server 2005, SForce Explorer JavaScript, HTML, DHTML(CSS), etc.

 

Achievements:

§  Had been a part of getting highest incentive in most of the months

 

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

(Ensemble)

Web Developer

 

Tools USED:

.NET [C#, ASP.NET], ATLAS/AJAX Technology, Sql Server 2005, JavaScript, HTML, DHTML (CSS), etc.

 

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

 

# MIS REPORT AUTOMATION

 

This System is helping in high level project goals for generating reports in MS-Excel automatically. This system will identify flat file and .CSV extension exported from SQL Server will import in Ms-Excel one by one and calculates data more accurately and analyze their value accordingly in that order as user wants.

 

It captures information from these files and makes other Excel files to give their desired report. It improved accuracy level of the reports. This system is running successfully in different process of the company.

 

 

Tools USED: - SQL Server 2000, Ms-Access, C#, ADO.NET, VBA, Visual Basic, ASP, HTML, DHTML, VBScript for validating the user web forms.

 

Achievement / Awards:

§  Got an “AWARD - KAIZEN for Developing (Report Automation).

§  Got Best Performance “TEAM AWARD”

Self Projects

 

§  Project: CITYMATRIMONIALS.COM– a MATRIMONIAL WEBSITE

Team Size: Just Me

 

MY OWN WEBSITE:

I have been maintaining this website for a long time now. I started it just to help people and to enhance/explore my knowledge as well. This provides 100% free matrimonial services online.

 

·         Leading this project, Analysis, Designing Technical Architecture

·         End to end solution, UI Designing, All testing

·         Promoting the website, SEO (Search Engine Optimization)


Tools USED:

.NET [C#, ASP.NET], SQL Server 2012, HTML, CSS, Javascript, Ajax, jQuery

EDUCATION

Academic Career

 

SIKKIM MANIPAL UNIVERSITY, MANIPAL, INDIA

(MBA) Master in Business Administration

 

SIKKIM MANIPAL UNIVERSITY, MANIPAL, INDIA (2006)

(MCA) Master in Computer Application

 

KURUKSHETRA UNIVERSITY, KURUKSHETRA, HARIYANA, INDIA (2003)

(BCA) Bachelor in Computer Application.

Professional Career

 

MCP [Microsoft Certified Professional]

– Asp.Net Using C#

 

ATS INFOTECH PVT LTD, DELHI, INDIA

.NET Training [C#, VB.NET, ASP.Net, Crystal Reports, XML, SQL Server]

 

SSI, PREET VIHAR, DELHI, INDIA

Certificate in Web Architecture.

Certificate in Java Technology.

 

SHRAMIK VIDYA PEETH, GHAZIABAD, U.P., INDIA

Certificate in Application Technology of Computer.

 

Additional Details

Certification/Trainings

 

Self-Learning:

70-534: Architecting Azure Solutions

Tableau, 2016

R Language, 2016

eGlue Reportings, 2014

Business Objects (BO) – (WebRich Intelligence), 2011

 

Trainings:

IBM COGNOS 8 Reporting, 2010

SAP BI/BW, 2009

OODs, provided by ICalibrator, 2008

ArcGIS provided by INCA, 2008

Network Engineer Training provided by INCA, 2008

SALESFORCE.COM Implementation, 2006

LASZLO Online Training held by the Laszlo Systems, 2005

 

Certifications:

Microsoft Certified Professional (MCP), 2007

Certificate in Web Architecture from SSI, 2003

Certificate in Java Technology from SSI, 2003

 

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

 

 

 

Although I am amateur and need immense knowledge and experience to be a quality professional and I would deem it as an honor to work in your prestigious company and would prove to be an asset to you also.

Relevant

Views: