Jaideep Muhuri

Maintenance and enhancement of ADMARC Datawarehouse Working with key stakeholders to determine the requirements & milestones.Worked closely with the business analyst & Data warehouse architect to understand the source data and need of the Warehouse. Organizing & leading meetings to reach decisions on Cloud versus On-premise delivery options and other key technical issues.Coordinated with offshore team to assign & monitor ETL Development tasks using Informatica Powercenter, Unix and IICS.

Development and maintenance of Employee/Contractor Data warehouse (EDW) Working with key stakeholders to determine the requirements and milestones.Organizing & leading meetings to reach decisions on Cloud versus On-premise delivery options & other key technical issues. Worked on solutions based on Informatica Cloud Intelligent Services & Informatica Powercenter with netezza as the database. Created ETL Design to maintain history of Employee / Contractor data in SCD Type 2.

Maintenance/Enhancement of Consumer Marketing Data warehouse. Worked on OLTP analysis & design for performance/scalability. Worked closely with the business analyst & Data warehouse architect to understand the needs of the Marketing Team which will receive the data. Created Automated ETL jobs using Informatica Powercenter, IDQ & Tidal to provide realtime data to the HBO Marketing Team. Used Oracle Eloqua API, Facebook API, AWS cloud services.

Managed of 60 employees across 4 locations including large offshore and third party contractors. Documented the requirements which were not captured in the initial version of the requirements document. Involved in designing of database schemas and facts to provide effective Financial Risk Related information to the Business Users. Design and Implementation of Access layer on top of the EDW for Risk Analytics and Reporting Purposes.Created ETL Jobs with Informatica Powercenter, Unix and Teradata.

Involved in designing of Reporting Access Layer for the Credit Card Risk management team.Created Informatica Powercenter mappings to implement the Change Data Capture in the Risk Data warehouse.Built reusable transformations for recurring business logics(mapplets) .Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling.Used Trillium Data Cleansing tool to obtain address information of Customers in correct format.

Worked with various Databases for extracting the files and loading them into different databases. Designing the ETL Jobs.Played a lead role in managing the offshore team.Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Loads.Writing PL/SQL packages, stored procedures and functions using new PL/SQL features like Collections, Objects, Object Tables, Nested Tables, External Tables, REF Cursors, MERGE, INTERSECT, MINUS, BULK INTO and Dynamic SQL commands.

Maintenance of PDONDS data warehouse in Reserve Bank Of India. Extensively worked in data Extraction, Transformation and Loading from Source to target. Involved in analysis, design & testing environment. Extracted data from SQL server and loaded into Oracle Target tables.Involved in the migration of existing ETL process to Informatica Powercenter.Created effective Test data and developed test cases to ensure successful execution of the ETL Jobs. Created reports using business objects.

Computer Applications, Algorithmic Design, DataStructures, PL/SQL

Electronics