Yogesh Suresh Dhuri

Sr. Technical Consultant (Big Data and Datawarehousing)

Email id : acs4rp@r.postjobfree.com Contact : 976-***-****

Education Qualifications and Certifications:

Hortonworks Certified Apache Hadoop 2.0 Developer

Informatica Cloud certification

Teradata 12 Certified Technical specialist

Oracle Certified Associate

NCFM Certified Financial Beginner’s Module

Bachelor of Computer Engineering, Mumbai University

Profile and Experience:

Yogesh Dhuri is an experienced IT professional and has more than 10 years of experience in Information Technology, with focus on Big Data, Data-warehousing, Data Modeling, ETL and Reporting.

He has worked in several areas of Data Modeling, ETL, Data Warehouse development, Business intelligence and Big data including Business Analysis, Requirement Gathering, Design, Development and Implementation.

He has worked on several projects in Retail, Banking, Banking-Financial Services, Retail, life Insurance, General Insurance (P & C-billing) domains.

Skill Sets:

Big Data

Hadoop, Hive, Pig, Hbase, Teradata

Programming/Scripting

Unix Shell, PL/SQL

Operating Systems

Windows 64 bit 2003 server, Unix-HPUX

ETL Tools

Informatica 8.6, ABINITIO, Oracle Data Integrator

Data Modeling Tools

ERWIN Data Modeler 8.2 / 9.5

RDBMS

Teradata 12/14.0, Oracle 10G, Oracle 11g R2 RAC

Other Tools

Oracle Data guard, Autosys, Teradata Warehouse miner 5.3.3

Project experience:

1.

Client : Westpac Bank Australia

Period : Nov 2015 – Till Date

Industry : BFS

Project Name : Future Analytics

Project Type : Prediction and DSS

Environment : Teradata 14.10, Hadoop 2.0, Sas

Role : Physical Data Modeler

Responsible for:

Bid Data solution development using Pig and Hive as per PDM design.

Designing Logical data model as per business requirement.

Physical Data Modeling in Hive.

Loading/Migration of Adhoc data into Hive from Teradata database.

Data Analysis using Hive on POC

Semantic layer design for reporting and security access.

Mentoring Team members and task delivery.

Client support and resolving user tickets/issues.

2.

Client : Amex (American Express)

Period : Oct 2014(mid) – Till Date

Industry : BFS

Project Name : Future Analytics

Project Type : Prediction and DSS

Environment : Teradata 14, Hadoop 2.0, Sas

Role : Big Data Consultant and Data Modeler

Responsible for:

Bid Data solution development using Pig and Hive as per PDM design.

Designing Logical data model as per business requirement.

Physical Data Modeling in Hive.

Loading/Migration of Adhoc data into Hive from Teradata database.

Data Analysis using Hive on POC

Semantic layer design for reporting and security access.

Mentoring Team members and task delivery.

Client support and resolving user tickets/issues.

3.

Client : Sears Corporation

Period : Aug 2014 – Oct 2014

Industry : Retail

Project Name : Integrating the Extreme Data Appliance

Project Type : Big Data-PDD

Environment : Hadoop and Teradata

Role : Data Architect

Responsible for:

Designing Logical data model as per business requirement.

Designing Physical Data Model

Designed six data marts in Hive

Data migration from Teradata into Hadoop using sqoop and flume.

Data profiling activity using Teradata Warehouse miner

Semantic layer design for reporting and security access.

SQL queries performance tuning on Teradata to meet SLA requirements and reduce CPU utilization

Mentoring Team members and task delivery.

Client support and resolving user tickets/issues.

4.

Client : Target Corporation

Period : Mar 2014 - July 2014

Industry : Retail

Project Name : MBI PDD FlexPLM Merchandising

Project Type : Logical and Physical Data Modeling using Erwin and PDM in Hive

Environment : Erwin, Hadoop

Role : Data Modeler and architect

Responsible for:

Big data solution development using hadoop

Designing Logical data model as per business requirement.

Designing Physical Data Model

Designed six data marts

Data profiling activity using Teradata Warehouse miner

Mentoring Team members and task delivery.

Client support and resolving user tickets/issues.

5.

Client : Royal Bank of Canada

Period : Sept 2013 - Dec 2013

Industry : Banking

Project Name : Content Manager Reporting

Project Type : Implementation of Content Manager Data mart and reporting

Environment : Hadoop, Teradata 13

Role : Data Architect

Responsible for:

Understanding CM reporting data workflow.

Designed Big data solution and POC submission

Validating Semantic layer as per functional specification/requirement

Designed reporting layer

Client warranty support for POC

6.

Client : American Express

Period : Apr 2013 - July 2013

Industry : Payment and Finance, Credit Cards

Project Name : AMEX IMPAC and UDW

Project Type : Performance Tuning

Environment : Sybase, Teradata 14, DBQL

Role : Team Member

Responsible for:

Analysis of performance issues reported by client.

Resolving performance issues using SQL query optimization/ tuning using DBQL

7.

Client : American Express

Period : Aug 2012 - Mar 2013

Industry : Payment and Finance, Credit Cards

Project Name : AMEX IMPAC and UDW

Project Type : Application/Datawarehouse Migration

Environment : Sybase, Teradata 14, DBQL

Role : Team Member

Responsible for:

Migration of Sybase stored procedures to Teradata 14.0 version

Mentored junior team members and code review of peers

Played role of module leader during phase1 of the project

Managed task estimation and task allocation to resource during phase1

Conducted knowledge sharing sessions for team members

Provided solutions for technical queries raised by internal team members through internal technical forum.

8.

Client : Internal

Period : June 2012 - Aug 2012

Industry : NA

Project Name : Internal – DB2 to Teradata migration

Project Type : Application/Datawarehouse Migration

Environment : DB2 10.1, Teradata 14

Role : Team Member

Responsible for:

Designed strategy to migrate application from DB2 to Teradata 14.0 version

Prepared ready reference guide document to help fast approach/techniques for DB2 to Teradata code migration

Prepared one to one Mapping document for built-in functions between DB2 and Teradata 14.0

9.

Client : Reserve Bank of INDIA, Bank of Ghana, Bank of Cyprus.

Period : May 2009 to Jan 2012

Industry : Banking and Electronic Payments Systems

Project Name : ECPIX (Electronic cheque presentment and image exchange)

Project Type : Development/Implementation of Operational Data Store and

Datawarehouse Solution using ETL

Environment : Windows server 2003 64 bit, Oracle 11G R2 64 bit RAC, Informatica

Role : Sr. ETL Developer Team Lead

Responsible for:

Analysis and design for new application change requests and enhancements.

Preparing LDD and HLD design documents.

Generate ETL Mapping document as per transformation rules.

Support Application certifications process for new software updates from vendors.

e.g. Oracle 10G to Oracle 11G migration process certification of the application

SQL query performance optimization using Oracle AWR reports.

ORACLE PL/SQL coding for new requirements and UT of code.

Code review

Preparing impact analysis document for new customization or enhancements.

Task estimation and project planning using agile methodology

Informatica Workflow design and transformations as per customer requirement and ETL mapping document.

Data replication using Data Guard.

Datawarehouse Data mart design and implementation

Developing Semantic layer for Reporting /Business Intelligence System

10.

Client : Citi Bank - UK

Period : Apr 2008 to Oct 2008

Industry : Banking

Project Name : Profit & Loss Reporting Citi Solar-UK

Environment : Oracle 10G R2, HP-Ux, ABINITIO, Autosys

Role : Sr. ETL Developer

Responsible for:

Analysis of user requirements and preparing LLD documents.

Database designing and development of code using Oracle PL/SQL.

Writing Packages, stored procedures in database

Design ETL transformation and data flow process.

Legacy Data Migration and daily trading positions data loading using AB Initio.

Job scheduling/Monitoring through Autosys tool.

11.

Client : Comprendium, Germany

Period : Sept 2007 to Mar 2008

Industry : Banking, Retail and Billing

Project Name : Integrated Lease and Financial Services

Environment : Oracle 10G R2, HP-Ux, ABINITIO, Autosys

Role : Sr. ETL Developer

Responsible for:

EDW Design and Development of Data marts

Database designing and development of code using Oracle PL/SQL.

Billing Module development and integrated it with Oracle Apps.

Lease contract Module development and integrated it with Oracle Apps.

Service contract Module development and integrated it with Oracle Apps.

Prepare UT plans for the new requirements and monitor the UT implementation.

12.

Client : CVSTARR-MFX, FairFax (USA)

Period : JAN 2007 to Jul 2007

Industry : Insurance

Project Name : Renaissance-Billing

Environment : Oracle 10G R2

Role : Developer

Responsible for:

EDW Design and Development of Data marts

Database designing and development of code using Oracle PL/SQL.

Technical architecture design for the Agency Billing Module

Development of Direct and Agency Billing Module independently

Support production environment issues/Bug fixing within SLA time.

Configuration Management in VSS for the offshore development team

Legacy data migration into Insurance application through SQL* Loader and ODI

13.

Client : ERP module design for multiple clients

Period : Aug 2003 to May 2006

Industry : SME

Project Name : Customized ERP Solution

Environment : Oracle 10G R2

Role : Developer

Career History:

Company

Date

Position

Teradata Corporation

APR 2012- till date

Sr.Technical Consultant

NCR CORPORATION

May 2009 – JAN 2012

Sr. Software Engineer

L &T Infotech Ltd.

Sep 2007 – Oct 2008

Sr. Software Engineer

Keystone Solutions

Jan 2007 – July 2007

Software Engineer

Softline Software

(Partner of Udyog Software India)

Udyog Software India

Nov 2005 – May 2006

Aug 2003 – Oct 2005

Software Engineer

Contact this candidate