Umer I. Email & Phone Number

Florida, United States

Leicester, England, United Kingdom

• Teradata/SQL, EDW and data lake Development using informatica, Hadoop, DataStage.• Database and data warehouse optimization at query to batch level.• Increase it's efficiency of data pipelines to process Terabytes of data.• Utilize the NoSQL like MongoDB, Cassandra in different project. • Dashboard development through Power BI and OBIEE. • Developed the AML, FMS, RAM Systems.• Oracle Financial Services Analytical Application• Financial Data Modeler.

Al-Riyadh Governorate, Saudi Arabia

• Financial Data Modeler. • Teradata/SQL, ETL Development and Support • Database and data warehouse optimization at query to batch level• Informatica Development.• BI development.• Developed the Anti-Money Laundering System.• Developed the Fraud Management System.• Developed the risk Assessment Management System.• Oracle Financial Services Analytical Application

Saudi Arabia

Lahore

● Teradata/SQL, ETL/ Data integration development, operations and optimization.● ETL Strategy implementation.● Database Development and optimization.● Query Writing and Optimization in PL/SQL and T-SQL.● Agile Data Modeling.● Work in Scrum Model.● Database Administration.● Multi-tenant Database Architecture implementation.● Hands-on experience with Data warehouse and Business Intelligence Tools● Dedicated, Hardworking and Team Oriented Skills.

Pakistan

1. DWH and BI Developement2. Query Optimization 3. Document Developement

Muscat, Oman

• Business Requirement gathering for PCRF and Billing.• ETL Development and Support (Informatica and Teradata utilites).• SMX development/ Data warehouse modeling.• Unit and integration testing• Data Analysis.

Lahore

• Design, design reviews, implementation and testing of migrating • Oracle Warehouse Builder 11gR2 ETL jobs to Informatica 9.6.0. • Informatica development and optimization.• Effort estimates Planning. • SMX Development.• Develop a naming convention Document.• Technical support to the ETL development team for migration & Performance

Islamabad

• Batch Optimization• ETL Development and Support• Development of UNIX Script.• Review of Current TASM settings• Analysis of Overall System Performance & suggestion recommendation.• Analysis of ETL workloads is identification & suggests recommendation.• System wide Stats and space Analysis and suggest recommendation.

• Overall development of SQL Server and Oracle (BI and RDMS)• Understand and Implement the Financial Services business scenarios• Optimization at database, Batch and Query level.• Optimized the Activities related to Database Administration.

• Overall development of SQL Server and Oracle (BI and RDMS)• Understand and Implement the Financial Services business scenarios• Optimization at database, Batch and Query level.• Optimized the Activities related to Database Administration.

Lahore

• Database Migration• Proactive Database Administration.• Identification and resolution of Schema Gaps.• Identification and resolution of Bad Queries in Productions.• Setting up DBA activities & Processes.• Setting up DRP Plans and executions.

Lahore

• Healthcare Database Modeling.• Data warehouse and Database development.• Work on different healthcare modules.• Proactive Database Administration through automation.• Identification and resolution of Schema Gaps.• Identification and resolution of Bad Queries in Productions.• Work on SQL Server and Oracle.• Work as team lead

Abbottabad

Web Development is need of today e-commerce and business development which is a focus of Feather Soft. It is Project Base Company worked on web site of E-commerce, Informational, and Personal Websites etc. 1. Web Developer2. Database Developer3. Web Front End Developer4. Data Modeler

Computer Engineering, Data Mining, A

Doctor Of Philosophy - Phd, Ai

M.Sc, Computer Engineering, A

Activities and Societies: + Worked on Intelligently DBA through Intelligent Agent + Data mining Decision Support System for Agriculture My.

B.Sc, Computer Software Engineering, A

Education record