About Me

• 7+ years of experience in project design, analysis, development, and management using Microsoft SQL 2005/2008/2012. 
• Expert in Microsoft Business Intelligence technologies including MS SQL Server Integration Services (SSIS), MS S...crosoft Business Intelligence technologies including MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL server Analytical Services (SSAS).
• Proficient in database modelling for OLTP, Data Marts, Operational Data Store (ODS), and OLAP.
• Created and published reports using SSRS, Report Builder, Report Designer, and Report Manager.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer, and Cross Joins.
• Involved in designing and building OLAP dimensions and cubes using SSAS.
• Experience in defining queries for generating drill down reports in SSRS.
• Experience in iterative and incremental software development.
• Experience in installing, upgrading, and configuring MS BI pack.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Good knowledge in database and Data warehousing concepts.
• Excellent skills in creating SQL objects including Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Experience in migration of data from Excel, Flat file, and Oracle to MS SQL Server by using MSSQL Server DTS and SSIS.
• Worked on OLAP Data warehouses, modeling, design, and cube development including KPIs, working with slowly changing dimensions.
• Experienced in creating Perspectives, Partitions, Roles and Groups, Design Aggregations, Key Performance Indicators (KPIs) in cubes, working with Multidimensional Expressions (MDX) using SSAS.
• Developed various business reports. Reports are provided in PDF-format, HTML-format, and can be printed directly to the specified printer.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model, and ad-hoc reporting using Report Builder.
• Worked extensively in developing DTS packages in SQL server 2000
• Experience in defining Query for generating Cross-Tab, Conditional, Drill-down, and Sub reports.
• Experienced in writing scripts for Automation Testing on QTP and Selenium.
• Provided 24x7 production support to Batch, continuous flow process for daily, monthly, and weekly job schedule