Sql Server Data

NETHRA AVULA

SQL BI Developer

Professional summary:

. 6+ years of experience in Data Modeling, Database Design, Programming,

Development and Implementation of Client-Server Applications & Database

systems using MSSQL 2000/2005/2008/2012 for both OLTP (Batch Processing,

Online Processing)& Data warehousing (SSIS, SSAS, SSRS) applications.

. Experience in database programming in writing T-SQL Stored procedures,

Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and

Batch Scripts using various DDL and DML commands.

. Strong technical knowledge in MS SQL Server development including DTS,

Microsoft Analysis Services, Performance tuning, Reporting, Designing

logical/physical databases and Troubleshooting.

. Experience with software development life cycle (SDLC) and project

management methodologies.

. Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard,

Database Tuning Advisor, DBCC Commands, DMV's, DMFs and Query Execution

Plans.

. Used Erwin Data modeling tool and Microsoft Visio for designing the

logical and physical data models.

. Thorough knowledge of addressing Performance Issues and Involved in query

tuning, Index tuning, Data Profiling and other database related

activities.

. Expertise in generating reports using SQL Server Reporting Services,

Crystal Reports, and MS Excel spreadsheets.

. Involved in Installation, Configuration, Development, Deployment and

Troubleshoot Reporting services using SSRS2000/2005/2008 across various

environments.

. Expert in designing Enterprise reports using SQL Server Reporting

Services (SSRS 2000/2005/2008), use of multiple value selection in

parameters pick list, cascading prompts, matrix dynamics reports and

other features of reporting services.

. Expert in generating drill down reports, parameterized reports, linked

reports, sub reports and filters, charts in SSRS 2005/2008.

. Experience in creating Ad-hoc reports, data driven subscription reports

by using Report Builder in SSRS.

. Involved in Huge data migrations, transfers using utilities like Data

Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk

Insert.

. Experience in conversion of packages from legacy systems (DTS to SSIS)

and migrating, deploying the packages across Dev/UAT/Prod environments.

. Experience in providing Logging, Error handling by using Event Handler,

and Custom Logging for SSIS Packages.

. Experience in Performance Tuning in SSIS packages by using Row

Transformations, Block and Unblock Transformations

. Experience in Developing and Extending SSAS Cubes, Dimensions and data

source views SSAS-Data Mining Models and Deploying and Processing SSAS

objects.

. Good knowledge of Data Marts, Data warehousing, Operational Data Store

(ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema

Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis

Services.

. Proficiency in creating different types of reports such as Cross-Tab,

Drill-down, Summary, Form, OLAP and Sub reports, and formatting them

using both SSRS 2005/2008.

. Experience in deploying created reports in various sources like Web

browser, XML and PDF.

. Experience importing data using PowerPivot for Excel 2010 and 2013.

SKILLS:

Languages SQL, T-SQL, PL/SQL, C#, Asp.Net

RDBMS MS SQL Server 2012/2008/2005/2000/7.0, MS Access,

Oracle 9i and 10g

Database Tools SSRS, SSIS, SSAS, DTS, BCP, Business Intelligence

Studio (BIDS), Query Analyzer, SQL Management

Studio, SQL Server profiler, SQL Agent, SQL

Enterprise Manager, (SQL Server Data Tools) SSDT

Operating Systems Windows 98/2000/XP/7/8/, Windows 2000/2003/2008,

UNIX

Architecture Relational DBMS, Client-Server Architecture

Version control Team Foundation Server, Visual Source Safe, SVN.

Tools

Tools And SQL Server Management Studio, SQL Server

Utilities Enterprise Manager, SQL Server Profiler, Import &

Export Wizard, Visual Studio .Net, Microsoft

Management Console, Visual Source Safe 6.0, DTS,

Business Intelligence Development Studio (BIDS),

Crystal Reports, Business Objects, Web Services,

SOAP.

PROFESSIONAL EXPERTISE:

Driven Solutions, Carrollton, TX

Jan 2013 - Present

Role: SQL BI Developer

Driven Solutions is a B2B solution company providing roadside assistance

and logistic services. Supported QUASAR, which is a homegrown CRM

application, which is used by Customer Service Representatives for dispatch

and also used by accounting for processing Invoices.

Responsibilities

. Wrote T-SQL queries, triggers, functions, cursors and stored

procedures

. Involved in database design, normalization, de-normalization in

building the Data warehouse and

Reporting systems

. Responsible for creating Table Constraints and Indexes (Clustered

and Non Clustered)

. Created Views to restrict access for the security of data in a table

. Catching and Reporting errors using exception handling (TRY & CATCH)

. Monitoring the performance of the scheduled jobs and alerts

. Performance tuning and testing on stored procedures, indexes and

triggers

. Performed the Data Modeling using the ER diagrams using ERWIN

. Extensively used SSIS Import/Export Wizard, for performing the ETL

operations

. Developed, monitored and deployed SSIS packages to SQL Server and

File system

. Used SSIS script task, look up transformations and data flow tasks

using T- SQL and Visual Basic (VB) scripts and ensured that the

packages doesn't encounter performance issues

. Developed DTS packages to extract and transform data from multiple

sources

. Used various transformation tasks to create ETL packages for Data

Conversion

. Imported flat files into database by performing Bulk data migration

using DTS

. Extract and transform data by developing packages using DTS

. Generated reports using SSRS to create reports based on SQL Server

database for various forecast reports

. Used SSRS to create Drill-Down and Drill-through reports

. Connected OLE DB data sources and providers by creating Linked

servers.

Environment: MS SQL Server 2005/2000, SSRS, SSIS, T-SQL, DTS, SQL Server

Enterprise Manager, SQL Server Query Analyzer, SQL Server Business

Intelligence Development Studio, Microsoft Visual Studio 2005.

The Freeman Company, Dallas, TX

Apr 2011 - Dec 2012 Role: SQL Server

Developer/BI (SSIS, SSRS)

Freeman is a Event Service solution provider for live events, corporate

events, exhibits etc., Involved in Quote and cost analysis of event

projects

Responsibilities

. Worked in AGILE methodology using SQL Server 2008 R2.

. Filtered and cleansed bad data from legacy system using complex

Transact- SQL statements in staging area, and implemented various

constraints and triggers for data consistency.

. Performed Data Modeling in the initial stages of the project.

. Developed SQL scripts to Insert/Update and Delete data in MS SQL

database tables.

. Developed SQL Queries to fetch complex data from different tables in

remote databases using Inner/Outer joins, sub-queries, accommodating

complex filters and database links.

. Optimized the performance of queries with modification in TSQL

queries, removed unnecessary columns, eliminated redundant and

inconsistent data, normalized tables, established joins and created

clustered/non-clustered indexes wherever necessary.

. Developed complex Stored Procedures to process prospective customer

information and balanced the processing load between front end and

back end.

. Extensively used joins and sub queries to simplify complex queries

involving multiple tables. Developed views using complex split week

logics.

. Experience in writing VB scripts in script component task.

. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup,

Derived Columns, Condition Split, Term extraction, Aggregate, Execute

SQL Task, Data Flow Task, and Execute Package Task etc, to generate

underlying data for the reports and to export cleaned data from Excel

Spreadsheets, Text file, MS Access and CSV files to data warehouse.

. Design, deploy, and maintain various SSRS Reports in SQL Server 2008

R2.

. Generated Daily, Weekly, and Monthly Reports as per the customer

requirements using subscriptions and Created Tabular Reports, Cross

Tab Reports, Sub Reports.

. Built effective queries for high-performance reporting and rendered

them to HTML, XML, PDF and Excel format using SSRS 2008.

. Designed different kinds of reports like Linked, cascaded and

parameterized reports and Worked on Drill Down and Drill-through

Reports, Tabular, Matrix etc.

. Experienced in developing stored procedure driven reports, building

custom application on reports, formula writing/editing in reports,

Report Administration and performance tuning of reports.

. Involved in query optimization and performance tuning.

. Used Performance tools like SQL Profiler, Index Tuning Wizard and

Database Engine Tuning Advisor

. Implemented error handling in several existing Store Procedures using

Try Catch blocks.

. Worked in SVN version controlling environment.

. Handled complex financial data and large databases.

Environment: SQL Server 2008 R2/2008, T-SQL, Excel, MS Access, Microsoft

BI, Windows Server 2008, Visual Studio, Query Analyzer, SQL Server

Profiler, SVN version controlling.

IMS, Chicago, IL

Jan 2010 - Mar 2011

Role: SQL Server Developer/BI

Integrated Merchandising Systems is a service firm providing branded

merchandise, in-store display boards. Involved in development of JMS (Job

Management System), which handles all the subcontracts offered by IMS to

outside agencies. JMS tracks all the bids presented for a particular job

and also keeps tracks of the progress of the jobs.

Responsibilities

. Installation, configuration of MS SQL Server 2005/2008.

. SQL server Upgrade from 2005 to SQL 2008.

. Designing and creation of tables and stored procedures with E-R

diagrams.

. Merging 2 different versions of databases to one single database and

upgrading to SQL 2008.

. Designed the Dimensional modeling of the Data warehouse using Erwin.

. Directly responsible for the Extraction, Transformation and Loading of

data from Multiple Sources to Data Warehouse

. Supported batch processing and boarding windows, handling huge

population of loans around 128k.

. Extensively involved in designing (Logical and Physical) of customer

database.

. Data Warehousing using Data Transformation Services Package (SSIS).

. Created SSRS Report Model Projects in BI studio and created, modified

and managed various report models with multiple model objects, source

fields and expressions.

. Highly involved in creating, structuring, formatting using Report

Designer and Report Builder.

. Creating and managing schema objects such as tables, views, cursors,

indexes, procedures dynamically for any tables, triggers and

maintained Referential Integrity.

. Database and log backups and restoration, backup scheduling the

backups. Backing up master and system databases and restoring them.

. Query optimization and performance tuning. Writing triggers and stored

procedures and optimizing it.

. Managing the use of disk space, memory and connections. Running DBCC

consistency checks, fixing data corruption in application databases.

. Ensured developers coordinated their efforts in managing and

maintaining different application databases.

. Reduced systems downtime risk through automatic offsite backup and

recovery over network.

Environment: MS SQL Server 2005/2008, Windows 2003 Server, SQL Query

Management Studio, BIDS (Business Intelligence Development Studio), SSIS,

TSQL, C#, ASP.NET.

Birla Sun Life Insurance Company Limited (BSLI), INDIA

Jun 2007 - Oct 2009

Role: SQL Server Developer

Birla Sun Life Insurance is one of India's leading life insurance

companies. Because of the strong investment lineage of Birla group Birla

Sun Life Insurance is able to offer a comprehensive variety of products and

services that suit the diverse needs and risk-return profiles of every

investor. The Project started in 2003 with a life Insurance Plan .The

requirement here was assisting building database and also modifying when

required. Integrating different databases and finally giving report about

the effective policies sales.

Responsibilities

. Involved in Physical and Logical design of the databases.

. Developed DTS Packages to transfer the data between SQL server database

and files.

. Created and maintained Data Transformation Service (DTS) packages for

migrating data.

. Scheduled Jobs for DTS packages.

. Used BCP/Bulk Insert to publish table output to text files.

. Created advanced T-SQL queries using DDL, DML and Indexes, Views,

Cursors, Triggers, User Defined Functions and Stored Procedures.

. Used all Declarative Constraints for maintaining Data Integrity.

. Created Views to restrict access to data in a table for security.

. Involved in performance tuning of T-SQL queries and Stored Procedures.

. Implemented Auditing using triggers.

. Created schema objects, rules and granted roles to the users.

. Used SQL Profiler to debug T-SQL and slow running queries.

. Monitored the Database Performance using execution plans and Index

tuning.

. Optimized the query performance with modifications in TSQL queries,

removing unnecessary columns, eliminating redundant and inconsistent

data, normalizing database, and establishing necessary joins.

. Involved in scheduling backups of databases and logs and restoring them

when necessary.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, SQL Server Enterprise

Manager, and SQL Server Query Analyzer.

EDUCATION:

Bachelors Degree in Computer Science from Jawaharlal Nehru Technological

University, Hyderabad, India.

Contact this candidate