Professional Summary:

• Around 7 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2012/2008 R2/2008/2005/ 2000 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
• Experience in Data Schema Design, and Table Design.
• Experience with T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience in Using multiple join statements to retrieve data from multiple tables
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
• Worked in SDLC Systems Development Life Cycle for developing systems/Software
• Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning.
• Experience in MS Business Intelligence tools like SQL Server Integration Services, Analysis Services and Reporting Services.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005/2008/2012 via SQL Server Integrated Services.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS 2012.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Expert in removing the Duplicate De-duplication rows from a table and applying Fuzzy lookup in SSIS
• Worked with Financial companies for application related pricing and security applications
• Experience in SQL Server Analysis Services SSAS OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema
• Experience in multidimensional databases with demonstrated ability to create calculated members and MDX scripting
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS
• Expertise in creating Cell Level Security in cubes using SSAS.
• Developed Reports using efficient data retrieval techniques
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .
• Built and wrote MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2005/2008/2012 Analysis Services Business Intelligence SSAS, SSRS
• Excellent Report creation skills using Microsoft Reporting Services SSRS 2008/2012.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

Technical Skills:

Professional Experience:

Responsibilities:

• Installed and Configured Microsoft SQL Server 2008/2012.
• Stored Procedures, User Defined Functions, Views, tables, T-SQL Scripting for complex business logic. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Worked on Cross platforms like SAS Statistical Analysis System to SQL server, Transformed the SAS Macros to SSIS.
• Extensively used Extract Transform Loading ETL tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
• Developed, monitored and deployed SSIS 2012 packages.
• Worked in transferring the data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing the ETL operations
• Utilized Integration Services SSIS to produce a Data Mart for reporting.
• Strong experience in working with BCP, SSIS DTS, DTSX packages for Data Integration Services.
• Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Expertise in creating Property Expressions, Script Tasks for SSIS packages
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008/2012 via SQL Server Integrated Services
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Experience in multidimensional databases with demonstrated ability to create calculated members and MDX scripting
• Worked in SQL Server Analysis Services SSAS OLAP Cubes, and Mining, Involved in Analyzing, Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services SSAS
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Implemented Snow Flakes Schema and Star Schema
• Worked with Development teams in relation to application tuning and Performance tuning
• Involved in the Database design Logical Data Modeling and Physical Data Modeling of the system and worked with tools like ER Studio 8.5
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on OLAP cubes using SSAS.Created and Managed OLAP Cubes using SSAS.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/2012.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created data driven subscriptions for different users using Report Manager.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2005/2008/2012. Extensively worked in sorting the data, defining subtotals for the reports
• Delivered the reports using 'pulled' and 'pushed' methodologies and formatted the reports using the Global variables and expressions.
• Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.
• Worked in SDLC Systems Development Life Cycle for developing systems/Software

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2005/2008/2012, SQL Server Analysis Services, MDX Cubes, MS CRM 3.0/4.0, Windows Server 2003, ASP.NET, Query Analyzer, VB.Net, C , Unisys, Wintel, Visual Studio, HTML, Java Script, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, SQL Clustering, Oracle, SAN, Source Control Management System, Index Tuning Wizard, SDLC, Data Warehousing, Data Transformation Services DTS .

Responsibilities:

• Installed, Configured, Managed and Monitored SQL Server 2005/2008.
• Created tables, views, indexes, stored procedures, triggers and provide constraints and user defined rules and defaults. Used multiple join statements to retrieve data from multiple tables
• Written T-SQL Procedures using temp tables, cursors, sub queries and functions
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement using the TOP operator to limit the Select Statement in certain Queries.
• Extensively used Insert/Update and Delete triggers and created views for generating reports
• Developed, monitored and deployed SSIS packages.
• Worked on multidimensional databases with use of OLAP tool in Data warehouse SSAS.
• Migrated data from SAS environment to SQL Server 2005 via SQL Integration Services SSIS .
• Responsible for transferring the data using ETL SSIS packages.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Used XML and environmental variables in the package configuration for Deploying SSIS packages
• Extensively used SQL Server Analysis Services Snow Flakes Schema and Star Schema.
• Developed multiple processes for Daily Data Ingestion from Client associated data vendors and Production Team, Client site employees using SSIS and SSRS.
• Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notification using SSIS and SSRS.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information As per business logic by using SQL Server Agent and windows Scheduler.
• Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Involved in Analyzing, Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services SSAS
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Extensively used Extract Transform Loading ETL tool of SQL Server to populate data from various data sources
• Involved in creating SQL server Analysis Projects using MS SQL Server 2008.
• worked in sorting the data, defining subtotals for the Reports and Created Adhoc Reports
• Worked with WebFocus Reports and transformed them to SQL Reports
• Worked with Development teams in relation to application tuning
• Involved in the Database design Logical Data Modeling and Physical Data Modeling of the system.
• Worked with Clear Case and Autosys applications for version control
• Generating scripts using Erwin and Created and Altering the Databases
• Worked in SDLC Systems Development Life Cycle for developing systems/Software
• Tested the application for deployment, Function and behavior

Environment: MS SQL Server 2008/2005 Enterprise Edition, MS Integrated Services 2008/2005, MS Analysis Services 2005, MS Reporting Services, WebFocus Reports, MS Access, Import Export Data, Source Control Management System Windows XP, Index Tuning Wizard, Silver light, Crystal Reports, Web Focus Reports, Data Warehousing, SQL Server ETL Tools, ER Studio, SDLC, Data Transformation Services DTS .

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources Excel, CSV, Oracle, flat file, Text Format Data .
• Created SSIS packages to migrate data from Oracle 8i to MS SQL Server 2005.
• Used BCP utilities, Data Transformation Services DTS , Extract Transform Loading tool SSIS to populate data from various data sources, created packages for different data loading operations for application.
• Created SQL server Reports using SSRS 2005 for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Set up hierarchies and defined Scope of Analysis in the Universe for providing drill down/ drill through options in the reporting environment.
• Created Queries for generating drill down reports in SSRS 2005.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Physical Implementation of database into SQL Server using T-SQL
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .
• Created Condition Objects in the Universe to restrict data
• Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
• Created simple query filters, prompted filters and complex filters to restrict data in reports.
• Collected business requirements, designed data maps and data models. Created Internal and External Design Documents and Transaction Definition Documents.
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Created several stored procedures, triggers, views.
• Tuned lots of ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Environment: MS SQL Server2005/2000, SSRS, SSIS, SSAS, MDX Cubes, ADO, T-SQL, Stored Procedures, HTML, XML, IIS 6.0, MS Visual Studio 2005, DTS, Crystal Reports 9.0

• Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
• Gathered user requirements and analyzed and designed software solution and database.
• Involved in migration of Sql Server 2005 to 2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Good understanding of Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Subsequently evaluated Proclarity and business objects as a front end for the ANALYSIS SERVICES implementation.
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Designed Dataflows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in Analyzing, designing, building , testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Responsible for implementation of creating complex SSIS packages using proper control and data flow elements with error handling.
• Excellent in Data Extraction, Transforming and Loading ETL using SQL Server Integration Services SSIS , DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services SSIS packages and using various control flow task and data flow transformation.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service SSRS .
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Designed, developed, tested, deployed, supported, maintained and documented Key Point Indicators KPIs , Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server 2007 and SQL Server Analytical Services.
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Stored Procedures, User Defined Functions, Views, T-SQL scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Experience in creating ASP.Net User Controls and Components to reduce the complexity of user interface design.
• Implementation of Ajax feature for improved performance.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Taking Database full Backup, Transaction log backup differential backup in daily Routine.

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics Query Optimizer
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager
• Created and administered multiple development, training and production databases
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check
• Responsible for creating standards and operating procedures to maintain all databases
• Worked with development teams in the design of physical databases and in modification
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Managed MS SQL server storage, memory, processing and their dependencies/performance bottlenecks

Environment: SQL Server 2000, Windows 2003/2000 Server, Data Warehousing, C, CPP, C , .NET, Rational Rose Enterprise

Responsibilities

• Installing and Configuring of SQL Server 2000/7.0 0n windows 2000/NT OS.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• 24x7 Production support.

Environment: Windows 2000, SQL Server 7.0/2000, Enterprise Manager, SQL Profiler, DTS, T-SQL, BCP, Replication.