SUMMARY:

To become an Enterprise Architect in Data Warehousing and Business Intelligence in Banking, Telecommunication, Health Care and Insurance businesses. Senior ETL Consultant having more than ten years of experience Data Warehousing and Business Intelligence Design and Implementation in various projects in Banking Business with various customers (co - operating with different vendors.

TECHNICAL EXPERIENCE:

• Data Warehousing and Business Intelligence
• Master Data Management
• Informatica PowerCenter 8.x/9.x Development and Administration
• Ascential Datastage 7.5.1.A
• OWB 10.x
• Oracle 10g/11g/12c PL/SQL
• Teradata 13.10/14.10
• Unix/AIX Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Setting ETL Standards in Confidential according to Informatica advised best practice.
• Automate Failover Recovery and achieve High Availability of running jobs.
• Integration of different systems with Informatica Server (Teradata, Hyperion Essbase)
• Troubleshooting and Performance Tuning.
• Informatica Servers Administration (Installations, Maintenance, Updates and Upgrades)
• Integration with various systems served, scheduled and monitored by ETL.
• Data Encryption/Decryption using Informatica and third-party tools like Symantec PGP.
• Estimate ETL project requirements (Procurement, Man-days and Cost).
• Sizing ETL Servers to cope with system growth (Space Requirements, H/W Resources and S/W Compatibility)
• Knowledge Transfer/Handover to/from other team members (Employees and Vendors).
• Systems and Data Analysis.
• Co-operate with Network and Security teams to resolve ETL Server Connectivity problems.

Tools:

• Informatica PowerCenter 9.6.1
• Informatica Essbase Client 9.0.1 and 9.6.1
• Informatica Teradata Client 9.0.1 and TTU Client 13.10 and 14.10
• Quest Software TOAD 12.0 for Oracle
• Teradata Express 14.10

Confidential

Responsibilities:

• Analyzing existing system and/or collecting new requirements.
• Setting the new database models to enable system automation and failure recovery.
• Design and Implement ETL process according to systems requirements.
• Automate External Files Transfer FTP/SFTP (Shell Scripts and Web Services)

Tools:

• Informatica PowerCenter 9.0.1 Hotfix 1 and Administration Console.
• Quest Software TOAD 10.7 for Oracle
• SSH

Confidential

Responsibilities:

• Determining the affected parts of the DWH System due to Core Banking System Upgrade.
• Applying proper changes to fulfill new DWH System Structure and Business Requirements.

Tools:

• Informatica PowerCenter 9.1
• Quest Software TOAD 10.7 for Oracle

Confidential

Responsibilities:

• Analyzing Source Data in DWH.
• Unifying Transactions Type Codes.
• Design Transactions Monthly Statistics Datamart Structure.
• Design/Implement ETL jobs that loads data to the Datamart and extract the flat file.

Tools:

• Quest Software TOAD 10.5 for Oracle
• Ascential Datastage 7.5.1.A
• Microsoft Excel 2010.

Confidential

Responsibilities:

• Analyzing/Designing Confidential System Approach.
• Implementing the new system design to enrich the existing ALGO/BASEL II systems with required extra information to follow Confidential approach.
• Enhancing ALGO/BASEL II system performance and integrating the existing system with the new system approach to reduce the effect of the extra information load.
• Restructuring/Creating XML used for enriching ALGO/BASEL II systems with Confidential required data via Risk Watch engine.

Tools:

• Quest Software TOAD 9.7 for Oracle
• Informatica PowerCenter 8.5/9.0.1 Designer and Administrator
• Advanced XML File Structuring and Creation using Informatica 8.5/9.0.1
• SSH for AIX Scripting and FTP

Confidential

Responsibilities:

• Monitor the subject DWH batch processes, measuring and analysing their throughput, and applying the proper enhancement method to get a better performance to fit the timeliness.

Tools:

• Quest Software TOAD 9.6 for Oracle
• Informatica PowerCenter 8.1 Designer and Administrator / Informatica PowerExchange
• SSH for AIX Scripting and FTP

Confidential

Responsibilities:

• Analysing source systems tables for data retrieval.
• Implementing CBR database stored procedures and functions that aggregate and load data into CBR database using PL/SQL language.
• Modifying some Forms and Reports layout.

Tools:

• Quest Software TOAD 9.1
• Oracle 10g Forms Builder
• Business Objects XI - Interface Only
• SSH for AIX Scripting and FTP

Confidential

Responsibilities:

• Analysing some source systems, documenting the design and implementing the temporary data loading part.
• Implementing, Running and Monitoring data loading maps.
• Data Profiling.
• Overriding generated PL/SQL codes used to read source data to achieve selection criteria and tune the queries performance.

Tools:

• Informatica PowerCenter 8.1 Designer/Administrator/Monitor
• Informatica PowerExchange 8.1
• Quest Software TOAD 9.1
• SSH Secure Shell

Confidential

Responsibilities:

• Implementing, Running and Monitoring data loading maps.
• Data profiling using the same tool.

Tools:

• Informatica PowerCenter 8.1 Designer/Administrator/Monitor
• Informatica PowerExchange 8.1
• Quest Software TOAD 9.1