Summary
Overview
Work History
Education
Skills
Software
Certification
Timeline
Hi, I’m

Rajesh Kumar Sinha

Data Architect
Hyderabad
Rajesh Kumar Sinha

Summary

Total 15+ years of diverse experience in the field of Data warehouse and Business Intelligence in Banking and Investment management Domain.

Overview

21
years of professional experience
4
years of post-secondary education
3
Certifications

Work History

IBM Inc
Hyderabad

Data/Cloud Solution Architect
04.2019 - Current

Job overview

  • Data Modelling
  • Created data model for Customer data - Type 1, Type2 and Type 3 table. Also created monthly snapshots and data marts.
  • Created data model for Loan data - Created monthly snapshots and data marts.
  • Created data model for Agreement data - Created monthly snapshots and data marts.
  • Designing Solution for Banking Problems.
  • Designed and implemented CDC(change data capture) for Real time data using IBM CDC and IBM CTM on AIX server.
  • Created solution for biggest file of 400 columns to consume as CDC in real time.
  • Data Solution
  • Worked to create single point of file for all Source systems.
  • Setting up new servers for DR.
  • Measured server capacity plan based on load and suggest to add servers for future for AIX
  • Data Management
  • Created plan for data life from end to end till purge and archive to tape.
  • Created retention policy for file system , Stage tables , Fact tables and Data Marts Based on consumption pattern and Implemented. Used s3 for cold data storage. Direct connect was created make data connection between data center and cloud storage.
  • Created Data storage strategy based on usage pattern of Hot, warm and cold data.
  • Master data Management
  • Solving Optimization challenges
  • Data Governance
  • Created plan for ODS and Data warehouse. Bank has lot of data which in DWH without any transformation.
  • Data Migration - Involved in data migration to some extent
  • Worked as part of Pre-sales team to understand RFP and provided solutions and inputs for some of the problems.
  • Managed data warehouse house batch loading 24/7 for Bank
  • Interacted extensively with User to understand multiple data structure, files, types , connections for boarding into data warehouse. Created High level design and LLD for ETL to work.
  • Interacted with stakeholder , Business Analysis, SA to understand requirement and Lead data warehouse team to implement end to end project.
  • Data Performance issue
  • Tuned multiple sql queries , created index and partitions in oracle database.

Franklin Templeton services pvt. ltd.
Hyderabad

Data Warehouse Lead
09.2006 - 03.2019

Job overview

  • Excellent experience in Data management tool Markit EDM 17.1 which is mainly customized in finance for data model.
  • Exp in data matcher, constructor, porter, inspector, rule builder, illustrator , Generator, Inbox etc.
  • Created many data pipe line and loaded into system using Markit EDM tools like.
  • Created multiple source loading for single master table.
  • Migrated complete ETL logic from Informatica to Markit EDM 17.1
  • Data Migration
  • As migration project, worked to create new data model to reload data oracle to sql server 2016
  • Performed Data reconciliation at column and summary level for fact tables
  • Created Mapping, Mapplet, Tasks for data loading in Informatica.
  • Created Plsql procedures, packages to evaluate rating for banking products like SRRI. Rate of returns, Holdings, Risk data.
  • Troubleshoot Informatica issue using informatica monitor and session logs
  • Troubleshoot Plsql issues using Toad.

Dell International pvt. ltd.
Hyderabad

Snr Software Engineer
11.2005 - 08.2006

Job overview

  • Writing Pl/sql procedures and Functions
  • Writing Pl/sql Packages
  • Creating users/schemas , Tables, Views, Triggers in Oracle 9i.
  • Troubleshooting Query issue

Tech Mahindra
Dubai

Software Engineer
01.2001 - 10.2005

Job overview

  • Coding in Oracle 8
  • Troubleshoot Oracle forms 12 and Report 12 Reports issues
  • Debug Procedures, Functions, Packages in oracle
  • Supporting Airline Billing system product.
  • Insert, Update, delete Data from Table.
  • Ticket resolutions

Education

B.Tech. in CSE
NITW

07.1994 - 08.1998

Skills

    DATA MODELING

undefined

Software

RDBMS : Oracle 9i,10g,11g, Sql server 2016

NOSQL : Mongo db 44

ETL : Informatica 10, Markiyt EDM 17

Big Data : Sqoop, Hive

Script : Python

Certification

AWS - Solution Architect Associate Certified

Timeline

Data/Cloud Solution Architect

IBM Inc
04.2019 - Current

Data Warehouse Lead

Franklin Templeton services pvt. ltd.
09.2006 - 03.2019

Snr Software Engineer

Dell International pvt. ltd.
11.2005 - 08.2006

Software Engineer

Tech Mahindra
01.2001 - 10.2005

B.Tech. in CSE

07.1994 - 08.1998

Similar Profiles

CREATE PROFILE
Rajesh Kumar SinhaData Architect