Kuwait City, Al Asimah, Kuwait
Working as a Senior Data Engineer in Boubyan Bank Kuwait • Creating ETL Pipelines using SSIS between various sources and Target systems. • Designing and implementing database structures, including tables, indexes and views, stored procedures and functions. • Worked on various source system like Core Banking solutions like Temenos T24 and IMAL. Debit card transactions – Switch ware, Credit Score CINET, Network International for prepaid and credit card transactions • Creating and deploying the jobs in SQL Server agent and scheduling in various frequency level. • Creating Data pipelines from various sources like structured, unstructured raw data and converting into useful information for the analysis purpose. • Design models of data processing that implement the intended business model. • Extensively communicating with business team and technical team for issue resolution. • Performing data architecture role like data modeling and managing data flow activities to ensure the reporting of business data to the Users should be timely in effective manner. • Writing SQL’s as part of Data validation testing.
• Technical Lead for MPG Project • Designing and implementing database structures, including tables, indexes and views, stored procedures and functions. • Creating and deploying the jobs in SQL Server agent and scheduling in various frequency level. • Creating Data pipelines from various sources like structured, unstructured raw data and converting into useful information for the analysis purpose. • Design models of data processing that implement the intended business model. • Extensively communicating with business team and technical team for issue resolution. • Performing data architecture role like data modeling and managing data flow activities to ensure the reporting of business data to the Users should be timely in effective manner. • Writing SQL’s as part of Data validation testing.
• Worked on change Requests (CR’s) • Worked closely with the Analyst team and business users to get knowledge of requirements and had the complete understanding of the requirement. • Implemented data security in model by using macros and session parameters etc.. • Had complete understanding on the Functional requirements of various systems of the Bank. • Developing reports by understanding Technical Report specifications. • Writing SQL’s as part of Data validation testing. • Develop and published Cognos Framework Model(which covers almost all systems of the bank) and published the package,Design unit test cases and thoroughly test reports.
Environment:Cognos11.0.4, Oracle Gallagher Bassett development and support project • Created reports with required filters, prompts, conditional variables, sorting orders and multiple queries and joins in order to achieve the functionality. • Completely understanding the data model and involved in creation of models and packages. • Understand the Business requirements and had complete understanding on the business requirement. • Handling the Support tickets raised in BMC Remedy System raised by User. • Developing and Format the reports as per business requirements. • Handling reports of Multiple Clients, which Gallagher Bassett is supporting, is very challenging. Environment: Cognos10.2 SQL Server 2012.
HSBC Gleam MI Senior Team Member and Module lead • Work on change Requests (CR’s) • Work closely with the Analyst team, get knowledge of requirements, and had the complete understanding of the requirement. • Implement security in model through AUTH table that maintain user ID information. Restricts access to site data based on entries in AUTH table. • Develop reports using complex features like drill through, conditional blocks etc. • Writing SQL’s as part of Data validation testing and generating DB2 Explain plans for verifying the access paths of report sql. • Populate data into base tables and run MQT scripts to load data from base tables into MQT’s during unit testing cycle in the development environment. Environment: Cognos 10.1, Cognos 8.4, DB2, UNIX Canara HSBC Life insurance Team member • Coordinating with Offshore team • Prepare the reports using prompts, filters and variables in report studio • Developing the Various Reports by writing SQL’s manually i.e. Custom SQL according to the business requirements. • Developing the package using Framework Manager. • Designed various reports with conditional Blocks,