Sql Server Data

Sambhavi D

Ph.No.650-***-**** Email: *********.*****@*****.***

Professional Summary:

Over 7+ years of extensive experience in Database design, development and administration of applications with MS SQL Server versions 2014/2012/2008R2/2008/2005/2000 using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) in diverse industries.

Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

Having good experienced on BI Share Point like SharePoint 2013, SharePoint 2010 and Good Exposure with Microsoft Office System like MS Word, MS EXCEL, MS PowerPoint, MS Access, MS office Tools

Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes

Experience in Database Backup, Recovery and Disaster Recovery procedure

In depth knowledge in ADHOC-SQL (DDL and DML) statements, RDBMS, data dictionaries.

Strong experience in Stored Procedure, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.

Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.

Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.

Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS 2012/2014.

Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.

Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.

Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.

Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.

Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

Experienced in SQL Server Analysis Services OLAP Cubes and Data Mining.

Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality

Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

Used SQL Server reporting services 2005/2008/2012/2014 for generating reports.

Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.

Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.

Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2005/2008/2012.

Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008/2012/2014.

TECHNICAL SKILLS:

Languages

Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Databases

SQL Server 2014/2012/2008R2/2008/2005/2000,MS Access

Analysis/Reporting Tools

SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

ETL Tools

DTS, SSIS(SQL Server Integration services), Data Stage

Other Software

MS Office- 2013/2010/2008/2007/2003/2000

Operating Systems

Windows 98/2000/2003/2007/2010/XP/Vista

Database Tools

SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

EDUCATIONAL DETAILS

Bachelors in Computer Science Engineering, Osmania University, India.

PROFESSIONAL EXPERIENCE:

Client: Care First Blue Cross Blue Field, Baltimore, MD March 2016 –Present

Role: Sr.SQL BI Developer (SSIS/SSRS)

Responsibilities:

Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.

Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.

Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.

Designed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Used SQL Profiler, Execution Plan, Database Tuning Advisor, Performance Monitor and DBCC Commands.

Responsible in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).

Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.

Analyzed Query Optimization and SQL Server Profiler for tuning report queries and improved performance in SQL Server.

Expert in T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.

Built SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.

Involved with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics and online indexing.

Experience in DR Processes including Log shipping and Database Mirroring.

Involved in developing stored procedures, triggers for the application.

Designing Enterprise reports using SQL Server Reporting Services (SSRS 2014) which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

Generated reports from the cubes by connecting to Analysis server from SSRS.

Involved in XML Development and XML File Parsing in SSIS and SSRS.

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.

Expert in data warehouse modeling (designing Star Schema, snowflake schemas with identifying Facts and Dimensions).

Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

Environment: MSSQL Server 2012/2014 Developer Edition, Visual Studio 2012/2015, SSMS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Team Foundation Server

Client: St. Joseph Health Systems, Anaheim, CA Jan 2015 –Mar 2016

Role: Sr. ETL/DW/SQL BI Developer (SSIS/SSRS)

Responsibilities:

Key role in team of 4 in bringing 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.

Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.

Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.

BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service and Reporting service.

Used SQL Server Package Configuration technique to make Dynamic configurations.

Used Text Files/ SQL Server Logging for all SSIS packages.

Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.

Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.

Worked on Excel Sheet Macros, gave connections for MDX to create Power Pivot Reports.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.

Schedule the packages to keep extracting the data from OLTP at specific time intervals.

Responsible for rebuilding the indexes and tables as part of performance tuning.

Deployed the packages to production using XML package configuration.

Configuration and Deployment of all reports across various SDLC environments.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.

Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2012

Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.

Deployed and configured the reports in the Report Server.

Involved in Report generation using SSRS, Excel services, Power BI and deployed them on SharePoint Server.

Used Power View and created various analytical reports and Dashboards to help managers to identify critical KPIs and facilitate strategic planning in the Hospital

Defined parameters for parameterized Reports using SSRS

Environment: Power BI, SQL Server 2012,SQL Server 2008R2/2008/2005, SSRS 2008, SSIS 2008, Data Stage, FileZilla FTP client, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Client: GEICO, Macon, GA Oct 2013– Dec 2014

Role: Sr. ETL/DW/SQL Server Developer (SSIS/SSRS)

Responsibilities:

Performed server installation and configuration using SQL server2012.

Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements

Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, Fast export. Involved in an upgrade from V2R6 to TeraData12.Implemented much efficiency in present processing utilizing many of the performance enhancements in this upgrade.

Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.

Used Quality center (Defect tracking tool) for Bug fixing and resolution details.

Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.

Created Packages that Transfers Databases from One SQL Server instance to Another Instance and Scheduled the SSIS package for migration of data from old system to MS SQL 2012

Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose

Monitored performance and optimized SQL queries for maximum efficiency.

Worked with DTS packages and MS OLAP Services.

Maintained the consistency of the client’s Database using DBCC.

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Responsible for testing to optimize the procedures and triggers to be used in production.

Environment: SQL Server 2012, 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.

Client: Verizon, Irving, TX Nov 2012 – Oct 2013

Role: SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.

Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2

Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Experience in developing reports using SSRS 2008 and SSRS 2008 R2

Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.

Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Worked on ADHOC-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.

Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.

Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.

Developed complex stored procedure using ADHOC-SQL to generate Ad hoc reports using SSRS.

Build database queries and test cases for the testing team to test the reports.

Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2008/2008 R2, 2005, 2000, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.

Client: LittleCaesars, Detroit, MI. Nov 2010 – Oct 2012

Role: SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

Worked with development team and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.

Involved in Database design & Data modeling various databases.

Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.

Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.

Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.

Prepared technical documents like High Level Design

Involved in Business Analysis & Requirement collection.

Understanding Customer requirement via interaction and writing functional specification.

Wrote complex stored procedures and cursors to implement various business logics as per the client requirements

Generated Script files of the databases whenever changes are made to stored procedures or views.

Experience working in agile environment and supported iterative testing methodology.

Worked in on site/ off shore/ off site environment; coordinated my activities by proactively communicating with my counterparts in the other teams.

Environment: MS SQL Server 2008/2008R2, 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, ProClarity, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Client: Cyber Inc., Hyderabad, India June 2009 - Aug 2010

Role: SQL Server Developer

Responsibilities:

Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.

Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.

Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.

Responsible for Design and Normalization of the database tables.

Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.

Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).

Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.

Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).

Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.

Identified and worked with Parameters for Parameterized Reports in SSRS 2005.

Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT

Contact this candidate