عتيق الرحمن

Application development and support for Insurance sector in financial domain. PL/Sql development in financial application. Automate creation of AR/AP process related to insurance.

ERP application development and support. Report designing using crystal reports. Application development using C# and .Net technologies

UKBS Data Migration

Migrate business data from legacy CSS system to newer Siebel systems using PL/SQL code.

Co-ordinated monthly roadmap releases to push enhanced/new ODI code to production.

Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using

Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.

Experience in designing OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.

Highly experienced in Data Modeling using Dimensional Data Modeling, Star and Snowflake Schema modeling, Fact and Dimension tables, and Physical and Logical data modeling.

Maintained SQL scripts and complex queries for analysis and extraction.

Involved in performance tuning of targets, sources, mappings, and sessions.

Performed Data Analysis before Migration of Data.
Performed thorough unit testing of developed code before deployment.

Developed fully functional responsive prototypes based on Business Requirements using PL/SQL, APEX and JavaScript.

Upgraded the Database from Oracle 10g to 11g.

Created reports using Crystal Reports.