SUMMARY:

To become an Enterprise Architect in Data Warehousing and Business Intelligence in Banking, Telecommunication, Health Care and Insurance businesses.

SUMMARY:

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

ETL Systems Development

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 FIRB System Approach.
• Implementing the new system design to enrich the existing ALGO/BASEL II systems with required extra information to follow FIRB 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 FIRB 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