The World Bank is an international financial institution that provides loans to developing countries for capital programs. The main goal of the World Bank is the reduction of proverty, promotion of foreign investment, international trade and facilitation of capital investment. This project was done by building an online transaction processing system (OLTP) based on MS SQL Server 2008R2 and it's Reporting Services which would provide space for growth and standardizing its forms and templates.
• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server 2008 to 2008R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated Environment: SQL server 2008R2, Windows XP/2007, SSIS, SSRS, SSAS, T-SQL, ETL, BIDS 2008R2, Windows 2000 Advanced Server, Microsoft Share point Portal Server, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL LiteSpeed, Dell Power Edge 2650, 1750, and 2600.