Business Object and ETL Analyst
Qatar Islamic Bank
Total years of experience :11 years, 11 Months
Working as BI Analyst in Qatar Islamic Bank
Worked as BI Analyst in Qatar Islamic Bank
Worked as BI Analyst in Qatar Islamic Bank
• Interacted with business to understand the requirement and analyze Business Requirement Documents & Functional Requirement Documents.
• Design Mappings, Dataflow and jobs in Data Services tool as per business requirement.
• Acted as single source of contact from bank side for 3rd party development team.
• Developed mapping to extract data from core banking application T24, a file-based system (jBase), using Vultar.
• Development, testing and supporting ETL Processes through SAP tools.
• Create universes and create BO reports for various departments in Bank.
• Automate advice & statement generation and regulatory report submission
• Analyzing Business Requirement Documents and Functional Requirement Documents.
• Design Mappings, Sessions and Workflows in Informatica tool as per business requirement.
• Development, testing and supporting ETL Processes through Informatica tool.
• Analyze and resolve Informatica session failures and documenting them.
• Monitoring and Investigating Control-M Job failures, linked with Informatica for ETL processes (L3 Support)
• Preparing Ad-Hoc Queries using SQL and PLSQL to generate the report as per requirements.
• Worked as Developer (BO, Informatica) for the various Data warehouse projects for the renowned multinational conglomerate General Electric Company (GE).
My experience includes analysis, design and development of Data Warehousing (Informatica), BO development, Oracle (SQL, PL/SQL) and Unix scripting. I have worked on Universe designer, Objects and classes, WebI report creation, scheduling, Transformations, Mappings, Targets, Workflows, Worklets, Sessions, debugger wizards, metadata manager and data analyzer. I have extensively worked on BO Reports, Data Extraction, Transformation, and loading with RDBMS, Flat files.
•In addition, I work as the Oracle Developer and perform the various database operations such as creation of tables, views, partitioning and indexing