♣ Lead, supervised, and managed the Business Intelligence (BI) technical team♣ Designed and developed standardized reporting platforms, delivering key operational metrics to stakeholders across all levels of the enterprise♣ Interpreted data and reports in a clear and concise manner, ensuring accessibility and understanding for all business users.♣ Designed BI dimensional models using the IBM Cognos 10 Framework Manager, optimizing business processes for diverse organizational needs.♣ Served as a key resource in the implementation of enterprise-wide BI solutions using Microsoft SQL Server.♣ Experienced in Cognos and SQL Server administration, ensuring seamless integration and performance♣ Extensive expertise in Extraction, Transformation, and Loading (ETL) processes, working with various data sources to populate Data Warehouses using SQL Server 2012 Integration Services (SSIS).♣ Collaborated as part of a team to create and enhance IBM Cognos metadata models and Data Warehouses, tailored to meet customer requirements and provide ongoing support.♣ Applied Kimball methodologies in the design and development of Data Warehouses♣ Developed insightful dashboards for higher management, facilitating data-driven decision-making.♣ Performed performance tuning for complex SQL/PLSQL queries, procedures, functions, and processes to optimize system efficiency♣ Assisted in mapping tasks, developing, and validating source-target mappings and transformation logic to support critical information needs.

♣ Lead & manage Business Analytic technical team♣ Creating and developing reporting prototype.♣ Creating report mapping to convert business requirement into report/dashboard♣ Team up with vendors on developing Data Warehouse.♣ Developed and automate various Business reports.♣ Develop RO/RM scorecard via Cognos Analytics.♣ hands-on on HP Vertica and SQL Server database.♣ Conduct meeting with stake holders for requirement gathering.

♣ Lead, supervised & managed Business Intelligence technical team.♣ Designing & development of a standardized reporting platform that provides key operational metrics to all levels of the enterprise.♣ Interpreting data and reports in a meaningful simple-to-understand way so that everyone understands their meaning and interpretation.♣ Supported multiple teams in administration & integration of IBM Cognos with multiple applications.♣ Performance tuning of complex SQL/PLSQL Queries, Procedures, and Functions & Processes.♣Supported in mapping tasks, developing & validating source target mappings and transformation logic required to support information requirements♣ Implemented ‘Email Notifications and security for IBM COGNOS 10 BI application♣ BI Dimensional Model designing using IBM COGNOS 10 Framework Manager for different business processes♣ International experience of implementing IBM Cognos in Habib Bank AG Zurich Dubai.♣ International experience of implementing SQL Server Data warehouse in Habib Bank AG Zurich Dubai. ♣ Creating different static and dynamic reports for different countries.♣ Give Cognos Self Service training to different users of Hong Kong, UK, Zurich and others four countries.

♣ Working as a key resource in the implementation of Enterprise-wide BI solution using Ms SQL server♣ Worked as a Cognos and SQL Server Administrator.♣ Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses Using SQL server 2012 Integration Services(SSIS)♣ Responsible to work as a team for creating and enhancing an IBM Cognos metadata model and Data Warehouse, to customer requirement; & support♣ Worked in building Data Warehouse using Kimball methodologies.♣ Create dashboard for higher management.

ETL management on IBM Datastage 9.7Cognos 10.2.1

Create and monitor ETL process.Developed reports on IBM Cognos 10.Developed Dashboards on IBM Cognos 10

Working as a Technical member in merging activity of ATLAS Bank Ltd and Summit BankLimited.� Working as a Technical Member in merging activity of Summit Bank Limited and Atlas Bank Limited.o Main responsibilities to collect data from one database and put it into Excel after massagingand upload data to Summit CoreBanking system. Reconcile data after uploading .� Working as an IT Technical Team Lead in merging activity of Summit Bank Limited and My BankLimited.� Create multiple utilities during Merger using VBA.o I have create multiple utilities using VBA, which gets data from one corebanking system andput into excel and apply desired formatting. Through this utility, we can generate any file byselecting check boxes.� Engage in Report Archiving project though Cognos.o Report archiving project is to facilitate end user by giving all major reports on single location.To do this, I have break report branchwise and create two scripts using vbs, first scriptrename all the files and second script copy this file to day wise hierarchy.� Cognos Administration.� Bursting of Congos reports through email or on disk� Departmental Reporting.o Generating the full range of MIS reports for Risk Management, FINCON, CAD, Compliance,Treasury, Consumer and Operations Department and validating the data fetching andprocessing at IT end

Working as IT Ops & MIS in Samba Bank Limited