1. Understanding the underlying Enterprise Data warehouse architecture of client with their existing software.
2.  Developed and Maintained ETL (Data Extraction, Transformation and Loading) by writing PLSQL procedures to extract the data from multiple source systems that comprise databases like Oracle 11g, files like csv,xml to the Staging area to EDW.
3. Developing and Designing Analytic Reports in OBIEE.
4. Writing Complex SQL queries for DDR Report.
5. Developing Windows Batch Script for fetching files from Source server to Target server.
6. Unit Testing. And Production Support

1. MIT Surveillance in third party product used for closely observing suspect order or trade.
2. Developed order and trade related report in Reporting tool.
3. Developed Shell Script for FTP of report from sever location to business user’s location.

Involved in analysis of source system, business requirements and identification of business rules and creating low-level specification.

Developed utility in Python to populate data from csv file to Staging area.

Developed ETL for populating data in Dimension and Fact Tables.

 Implemented Slowly Changing Dimensions (Type 2) for Dimension using triggers.