RDBMS : Oracle 9i,10g,11g, Sql server 2016
Hi, I’m
Rajesh Kumar Sinha
Data Architect
Hyderabad
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 IncHyderabad
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 MahindraDubai
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 CSENITW
07.1994 - 08.1998
Skills
DATA MODELING
DATA GOVERNANCE
DATA MANAGEMENT
DATA INTEGRATION
DWH Management
AWS cloud
Software
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