Description
PROFESSIONAL SUMMARY: * 8+ years of experience in Project Design, Analysis, Development & Management using Microsoft SQL 2005/2008/2008R2 and 2012. Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and worked in a technically challenging environment. * Expert in Microsoft Business Intelligence technologies like MS SQL Server (MSS) Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL server Analytical Services (SSAS) of MS SQL server 2005/2008/2008R2/2012. * Proficient in database modelling for OLTP, Data Marts, Operational Data Store (ODS) and OLAP. * Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins. * Involved in Designing and Building of OLAP dimensions and cubes using SSAS. * Experience in defining Query 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. * Experience of creating various functional documents for the systems to be developed like: Business Requirement Document (BRD), Functional Requirement Document (FRD), Data Required Document (DRD), Systems Requirement Specifications (SRS), Business Rules Document, use cases and design document * Good knowledge in database and Data warehousing concepts. * Excellent skills in creating SQL objects like 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, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS. * Worked on OLAP Data warehouses, Modeling, Design, 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 SQL Responsibilities: * Involved in Data mapping, logical data modeling, created ER diagrams and used SQL queries to filter data within the database. * Actively involved as part of a team for gathering and analyzing the needs of end User Requirement and System Specification. * Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs. * Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis. * Designed index, statistics and optimized queries by using execution plan for performance tuning of the database. * Created complex ETL strategies to extract, clean and deliver data to OLAP environment. * Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence. * Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports. * Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users, Documented and maintained history of changes for future reference. * Designed cubes with star schema using SQL Server Analysis Services (SSAS). * Created complex SSAS cubes to support business reporting with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. * Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler/Query Analyzer/SSMS. Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), TFS, Microsoft Office Share Point Server, XML, and Windows Server 2003. Server Developer 03/2010 - 02/2011 Responsibilities: * Actively participated in gathering Business Requirements that are focused on providing a user friendly System usage or ambience. * Created new database logically and physically designed to fit new business requirements. Created various database objects Tables Indexes Views SQL Joins and Triggers * Writing T-SQL queries Views Stored Procedures and User Defined Functions. * Filtered bad data from legacy system using complex T-SQL statements implemented various constraints and triggers for data consistency. Used DBCC Utilities for Performance Tuning Query Optimization and Client Server Connectivity & Database consistency checks. Planned the complete backup (with the suitable recovery model) of various Databases. Creates technical specifications test plans and test data to support ETL processes
Accomplishments
Highlights:
Keywords
