Sql Server Data

Satya Kiran

Email ID: ***********@*****.***

Phone No: 202-***-****

PROFESSIONAL SUMMARY:

Over 8+ years of IT experience as a MS SQL Server developer specialized in database design, development and administration in SQL Server and worked in different domains like Financial, Banking, Investments, Insurance and other business domain.

Good experience in Transact-SQL (DQL, DDL, DML).

Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, and Table Variables.

Experience in implementing business logic using Triggers, Views and Stored procedures.

Involved in optimizing code and improving batch efficiency with databases including re-indexing, updating statistics and recompiling stored procedures.

Data migration using SSIS Services across different databases like DB2, Oracle, MS access & flat files.

Good experience in Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Database Tuning Advisor, upgrading from DTS SQL Server 2005 to SSIS SQL Server 2008 packages.

Experience in SSIS/DTS script task, look up transformations and data flow tasks using T-SQL, C# code and Visual Basic (VB) scripts.

With Reporting Services (SSRS), experienced in creating tabular, matrix, ad hoc reports based on predefined models and interactive reports from relational, multidimensional or XML data sources and publishing reports, scheduling report processing, or accessing reports on-demand.

SQL Server Analysis Services (SSAS) design and build experience that covers the following advanced features required ensuring high-performing, scalable solutions: multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, and role and data-level security.

Extensively worked with multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to the Analysis Services cubes (SSAS Cubes).

Hands on experience in analyzing existing Data-Warehouse and multidimensional structures, for identifying opportunities for redesigning to meet changing business needs.

Experience in working of UAT and production environment.

Experience in transforming the design of Relational Databases (OLTP) to the Data Warehouse (OLAP).

Well acquainted with high availability solutions like Database mirroring, Fail over clustering, Log Shipping, Replication, Scalable shared Databases.

Strong written and verbal communications. Interested in a challenging technical track career in an application development environment.

Strong analytical skills and ability to create and maintain a database environment to support business requirements.

Good experience on bug tracker and version control tool, VSTFS.

PROFESSIONAL EXPERIENCE:

Bluecoat Systems- Sunnyvale CA August ‘13 to Present

MS SQL/ BI Developer

Description: Blue Coat Systems Inc., formerly CacheFlow, is a based provider of security and networking solutions. This project was intended to develop automated reports for executives to keep track of their respective businesses and for Managers to help in their Operations. Also to provide drill down business overview dashboards.

Responsibilities:

Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Created Stored Procedures for inserting, updating and deleting settings (MS-SQL)

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.

Analyzing the performance issues in SQL Server and created Clustered and Non-Clustered indexes.

Identified the unique combination on table's data and implemented unique non-clustered indexes to avoid inserting duplicates.

Worked on Filtered Views, views and Base table integration between different Source systems.

Optimized queries by looking at Execution Plan for better tuning of the database.

Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.

Created SSIS packages to validate, extract, transform and load data to data warehouse databases.

Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.

Created SSIS Packages to pull legacy data from Facets databases, Flat files and Excel spreadsheets.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Developed various operational Drill-through and Drill-down reports using SSRS

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Created the component in the business layer to read the settings from the database and use it in the UI layer.

Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.

Experience in creating Multidimensional cubes using SSAS and designing DW schemas.

Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS)

Implemented data exchange for retrieving settings and data calculation from the database (ADO.NET)

Used the existent procedures for calculation of data as per business requirements (MS-SQL)

Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.

Built connections to/pulling data from AS400, mainframe/db2 and Oracle.

Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.

Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC)

Environments: Environment: Windows2003 Advanced Server, ODBC, MS SQL Server TSQL, Visual Studio 2008, Oracle, SSRS, SSIS, MS PowerPoint.

Homesite Insurance- Boston, MA May’11-July’13

MS SQL/ BI Developer & Tableau Developer

Description:

Homesite Insurance focuses on niches in commercial, property and casualty insurance areas. It is distinguished by its leading positions in specialty insurance. Although each business is unique and diverse. They were implementing policy admin system, so the goal of the project was to generate reports to do analysis and configure the data.

Responsibilities:

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysi

Redesigned the data source having data from different sources into one SQL Server and to Tableau.

Interacted with Business Teams to understand what needs to be visualized.

Understanding what the client is expecting out of the reports, data cleaning to get to the right numbers for the weekly report.

Generated Tableau dashboards with forecast and reference lines.

Analyzed and gained understanding of the underlying data. Enterprise Key Metric Tableau dashboard is sourced from multiple Excel files.

Designed Tableau dashboards for Project/Resource analysis application and Enterprise Key Metric application. These dashboards were utilized by higher management to do analysis, product development and their market share.

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.1.

Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.

Also developed a process in the company to generated Tableau dashboards, which can be used for all the clients in the company by gathering the requirements.

Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently

Studied and understood the Data warehouses, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.

Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Data Tools.

Optimized queries using Database Engine Tuning Advisor and SQL Profiler.

Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.

Extensively used derived column, union all, conditional split, audit, script, lookup, SCD, row count, fuzzy lookup and fuzzy grouping transformations in SSIS packages.

Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data warehouse.

Created configuration files and enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS.

Responsible for scheduling SSIS jobs using SQL Server Agent, and created alerts for successful and unsuccessful completion of Scheduled Jobs.

Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.

Built packages and handled slowly changing dimensions to maintain the historic data.

Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Created different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Used cascaded parameters to generate a report from two different Data Sets in SSRS.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and representatives for various business needs using Subscription in SQL Server Reporting services (SSRS).

Environment: MS SQL Server 2012, T-SQL, SSIS, SSRS, ETL, Business Object 3.1, Oracle 11g, Microsoft Excel, MS Access.

Costco-Kirkland, WA October’ 09 to April’11

MS SQL/ BI Developer

Description:

Costco Wholesale Corporation is an American membership-only ware house club that provides a wide selection of merchandise. As of 2014, it was the third largest retailer in the unites states, in 2015 it is the second largest in the world (after Wal-Mart) and the largest membership warehouse club chain in the United States

Responsibilities:

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.

Created SSIS Packages to integrate data coming from Text files and Excel files.

Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

Created SSIS packages to validate, extract, transform and load data to data warehouse databases.

Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

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.

Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Wrote many stored procedures for cleaning, manipulating and processing data between the databases.

Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Deploying the Packages and Reports on to the server.

Created different Power Pivot reports as per the client requirement.

Worked on Filtered Views, views and Base table integration between different Source systems.

Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.

Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.

Document new SSIS packages and Train Senior Analyst on basic SSIS concepts

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligent Integration Services (SSIS […] Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

ICICI - Hyderabad, Andhra Pradesh June’07 to July’09

SQL BI DEVELOPER

Project Scope: The project was initiated with the intent to advance and improve existing version of the online banking application currently in use. Subsequent releases added new features and functionalities (such as portfolio and wealth management and mobile banking) with the final aim of regaining market share, improve customer loyalty and derive benefits from a service oriented architecture which helped expose individual business processes across multiple channels as per business demands to their customers.

Responsibilities:

Worked with the application developers and provide necessary SQL Scripts using T-SQL.

Created database maintenance plans for the performance of SQL Server including database integrity checks, update

database statistics, re-indexing and data backups.

Created User Defined Functions, Stored Procedures, and Triggers.

Designed and created SQ; Databases, tables, indexes, and views based on user requirements.

Create joins and sub-queries for complex queries involving multiple tables.

Worked with the application developers and provide necessary SQL Scripts using T-SQL.

Experience in creating complex SSIS packages using proper control and data flow elements.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).

Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).

BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI, Reporting Agent and Broadcaster.

Created data loads and Upgrade scripts for data migrations and validations

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS.

Have deployed packages on different servers by configuring it.

Involved in Analyzing, designing, building &, testing of data cubes with SSAS 2005 and in adding calculations using MDX.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.

Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.

Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.

Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Generate various ad hoc reports using MS Reporting services.

Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Contact this candidate