BI Specialist
Alinma Bank
Total years of experience :20 years, 5 Months
• Working on Strategic projects such as ATM Control, Remittance, Corporate /Retail reporting enhancements.
• Creating and modifying reports using Web Intelligence tool which were critical for users from multiple departments.
• Analyzing the data to fix defects raised by Business Users.
• Creating universes used for ADHOC reporting by Business Users and provided presentations.
•Working on Strategic projects such as REL Productivity Phase 2, Collections and REO conversion to Citilink.
•Created multidimensional Cubes using Transformer with Drill-through.
•Created complex Dashboards with Drill through Reports which were critical for users from multiple departments.
•Created Packages used for ADHOC reporting by Business Users and provided presentation on Query Studio procedures for creating on-demand reports.
•Created Multiple OLAP reports in Analysis Studio and presented the advantages of Analysis Studio compared to Power Play Explorer.
•Evaluated Report Performance upon completion of the reports and validated the output data and query SQL statements.
•Created Date Prompt reports with scheduling capability.
•Created/modified Framework Manager Models based on projects requirement.
•Involved in designing the fact and dimension tables with data Modeler which suit the needs of cognos reporting keeping in view the performance and maintenance.
•Created Shell scripts for building cubes and extracting DB fields.
•Used ClearCase in Implementing the Projects and merging them from Development to QA to Production.
•Worked on REL Integration (Integration of Prime and Sub-Prime CitiMortgage sections), Wall Street Reporting, Vendor Management, REL Productivity and Vulnerability Assessment Dashboard.
•Analyzed of the specifications provided by the clients.
•Created multidimensional Cubes using Transformer with Drill-through, special categories, Slice/dice abilities and tuned the performance of the cubes.
•Created complex reports such as Master/Detail report, Drill Through, Mailing Lists (Repeaters), Charts with graphs and cross tab reports.
•Evaluated Report Performance upon completion of the reports and validated the output data and query SQL statements.
•Analyzed the Data on existing Cubes/reports to fix issues raised by business through Remedy Ticket Software.
•Migrated complex Microsoft access queries (which contain multiple sub queries) to Cognos Impromptu.
•Created Catalogs in Impromptu Administrator and defined the catalogs data sources, join conditions, relations, cardinalities and schemas.
•Published/scheduled various reports/cubes to the upfront portal.
•Involved in designing the fact and dimension tables with data Modeler which suit the needs of cognos reporting keeping in view the performance and maintenance.
•Used ClearCase in Implementing the Projects and merging them from Development to QA to Production.
•Worked in a team and my primary role in this project was to gather user requirement and develop reports to provide a Decision Support System for the company’s Business users. This use of technology helped in enhancing the capability for banks to make strategic decisions.
•Communicated with business users closely on a daily basis, gathered and understood project specifications and requirements for data modeling and report generation.
•Worked extensively on Framework Manager to model data using Oracle as the primary data source. Created query subjects, relationships, complex calculations, and filters.
•Created Security filters in Framework manager to restrict data viewed by User Groups based on filter information.
•Segmented and linked Framework manager packages in order to organize the projects according to the company requirements.
•Tested and validated SQL in query subjects and relationships to ensure required data is retrieved before publishing packages.
•Developed detailed and ad hoc reports using Report Studio and Query Studio.
•Created bursting reports, drill through reports, report views, and Master-Detail reports using variables, cascading prompts, calculations and filters.
•Involved in the Migration, Deployment, testing and publishing of Cognos Impromptu catalogs and reports to ReportNet.
•Involved in the integration of Cognos Upfront content with ReportNet content.
•Published many Transformer protected cubes to ReportNet Server.
•Exported and published Framework Manager packages in IQD for further modification in Transformer.
•Trained business users on basic usage and implementation of Query Studio and Report Studio and how to use Templates for creating reports
•Provided IT consulting services to SBM-IBM for various projects.
•Installation and troubleshoot of LAN Networks, Wireless Access Points, Core Switches and Routers.
•Configuration of IP telephony system (Unity Server, Call Manager Subscriber/Publisher), LAN Management (Cisco Works Ver.2.2) and Cisco Routers.
•Set up Static Routes, Dynamic Routes using Routing Protocols such as RIP, IGRP, EIGRP and OSPF.
•Segmented networks with Edge/Core Cisco Switches (Catalyst 3750G-12S, Catalyst 3750-48TS, Catalyst 2950SX, 3550-12G, 3524, 1900), Cisco Routers (1760, 2500, 3660, 2620).
•Tested the Fiber optics/UTP connectivity across the network and providing daily reports to the Project Managers.
•Gathered the Business requirements from the users and Developed various type of Reports.
•Wrote SQL queries to create reports directly from MS Access.
•Checked the database structure and analyzed data for testing purposes.
Awarded Nortel Network Scholarship in Information Technology for being ranked one of the top 15 percent in the Faculty of Engineering.