Sql Server Data

SWETHA

SQL Server BI Developer

PROFESSIONAL SUMMARY

• Over 7+ years of experience in all phases of Software Development Life Cycle ( SDLC) of Data warehousing, including

requirement gathering from business users, analysis, design, creation of mapping documents, specification writing,

development, testing, and implementation using Microsoft Technologies.

• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services ( SSIS),

Business Intelligence delivery using Microsoft SQL Server Analysis Services ( SSAS) and Reporting solutions using Microsoft

SQL Server Reporting Services (SSRS), DTS, Performance tuning, Designing logical/physical databases and

Troubleshooting.

• Expert T SQL development skills in Objects creation such as Tables and Views, Table Normalization, User Defined

functions, Indexes, Stored Procedures, Correlated sub queries, Cursors and Triggers using SQL Server

2000/2005/2008R2/2012

• Experience in report writing using SQL Server Reporting Services and creating various types of reports like

Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill

Down reports using SSRS.

• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in

SSRS.

• Worked on all activities related to the development, implementation, administration and support of ETL processes

for large scale Data Warehouses using SQL Server SSIS 2008.

• Expert in creating the MDX cubes and dimensions in SSAS.

• Involved in requirements gathering, building dimensional cubes and writing MDX Queries, Calculated Members, and

KPI’s with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server

Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.

• Experience in Performance Tuning and Query Optimization.

• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries

and tune the same to improve performance.

• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

• Excellent in High Level Design of DTS and SSIS Packages for integrating data using OLE DB connection from

heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by

SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

• Experience in using Fuzzy Lookup and Fuzzy grouping transformations for data cleansing.

• Experience in creating and managing fragmentation of Indexes to achieve better query performance.

• Experience in defining logging for packages to record the error records, updated records, and inserted records.

• Experience in creating jobs, Alerts and schedule SSIS Packages using SQL Agent.

• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and

possess strong analytical skills.

• Self motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

Team oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

EDUCATION

• Bachelors in Computer Science

TECHNICAL SKILLS

Data Warehousing/BI Tools : SQL Server Business Intelligence Development – SSIS, SSAS, SSRS, DTS

RDBMS/DBMS : MS SQL SERVER2000/05/08/2008 R2/2012, SybaseIQ 12.7, MS Access

Tools : Management Studio, Enterprise manager, Query Analyser, DTS, BCP,

Performance Monitor, Power Pivot, SQL Agent, SQL Mail, SQL Trace,

Visio, Microsoft project, Tortoise Subversion, JIRA, Rational Clear Case,

and Clear quest.

Web Technologies : HTML, DHTML, XML, XSLT, XMLA, IIS, Apache.

Programming Languages : C#.net, VB.net, Java, JavaScript, VBScripts.

PROFESSIONAL EXPERIENCE

REI Systems, Inc., Sterling, VA Jan 2013 – Till Date

SQL Server BI Developer

REI provides IT solutions to the Bureau of Primary Health Care of Federal Government. Under BPHC, there are many

projects such as Uniform Data Systems (UDS), which collects patient’s data electronically from all health centers in

nationwide. The data are used to improve health center performance and operation and to identify trends over time. The

project is about building a Data warehouse to create various kinds of standard and Ad Hoc reports using SSIS, SSRS, and

SSAS technologies.

Responsibilities

Closely worked with business users and business analyst to gather user requirements and generate high level BRD’s and

•

Report Mockups for the Report Development.

• Actively participated in design, development discussions with DBA, team lead and project manager and performed impact

analysis.

• Performed detail Data Analysis and Reconciliation of the projects and provided better approach to the system.

• Played major role in Data warehouse UDM design, followed SQL server object naming standards.

• Created SSIS packages to extract data from different data sources ( SQL Server, Oracle, Access, Flat files, Excel files )

and loaded them into OLAP system by performing different kind of transformations to fulfill business needs.

• Created multidimensional cubes, dimensions with hierarchies, calculated measures, KPIs using the SQL Server

Analysis Services (SSAS).

• Created Tablix, Drill down, Drill through, Matrix, Tabular, Multi Parameterized, Linked, Chart and data driven reports

using SSRS 2012/2005.

• Creating MDX Queries to retrieve data from SSAS Cubes and to generate cube RDL reports from Cubes.

• Highly involved in performing Unit Test, Regression Test, Functional Test, Integration Test, and Stored Procedure

Performance Test on Test server and preparing combined Developer Testing document.

• Created Report level security and assign user permissions on Report Manager.

• Created the subscription and scheduled the published reports from Report Manager.

• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL,

DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.

• Involved in Normalization and De Normalization of existing tables for faster query retrieval.

• Involved in upgrading from SQL Server 2005 to SQL Server 2012.

• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning,

and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.

• Created SSIS Packages by using advance transformations (i.e. Fuzzy Lookup, Derived Columns, Condition Split, Term

extraction, Aggregate) and also used Custom components such as Audit on Pre Execute, Audit On Post Execute, Custom

Email Task and Statistics Logging Component.

• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each

Loop, For Loop to loop over a Directory to load inbound files coming daily.

• Conducted Peer review sessions to identify and minimize issues in testing phase. Provided QA and UAT Support by

actively fixing issues which are reported in JIRA tracker.

Environment

SQL Server 2012/2005, Oracle 9i, Management Studio, Microsoft SQL Server Integration Services(SSIS), C#, ADO.NET, Windows

2012 Server/2003 server, SQL Server Reporting Services (SSRS), MS Visio, Microsoft Visual studio 2012/2005, SQL Server

Profiler, JIRA, SVN.

Department of Agriculture, Washington, DC Nov 2011 – Dec 2012

SQL Server BI Developer

Food Safety and Inspection Service (FSIS) is the public health regulatory agency responsible for ensuring that domestic and

imported meat, poultry, and processed egg products are safe, wholesome, and correctly labeled and packaged. FSIS

implemented the Public Health Information System (PHIS) as part of our effort to collect, consolidate, and analyze data. It's

a user friendly, web based application that replaces many of FSIS' existing systems, such as the Performance Based

Inspection System (PBIS) and the Automated Import Information System (AIIS). PHIS have four components: domestic

inspection, import activities, export activities, and predictive analytics.

Responsibilities

• Analyzing business requirements and build logical data models that describe all the data and relationships between the

data.

• Developed Stored Procedures, Functions, Tables, Views, Triggers, Cursors, User Defined Functions, other T SQL

code and SQL joins for applications to handle large amount of data manipulation.

• Errors handling using TRY and CATCH blocks and performance tuning the SQL Code.

• Creating ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted

data into destination tables.

• Responsible for transferring the data using SSIS packages from excel/flat file sources to database.

• Published migrated data using SSIS (SQL Server Integration Services) Tool through data flow tasks, look up

transformations and script tasks.

• Creating Logging and Error Handling in SSIS Packages using BI Xpress.

• Dealing with SSIS script task, look up transformations and data flow tasks using T SQL and Visual Basic (VB) scripts.

• Responsible for deploying/scheduling SSIS packages as per schedule.

• Monitoring, Identifying and troubleshooting SQL Server performance issues using SQL Server Performance monitor,

profiler and Performance dashboards

• Responsible for creating a trace to identify and analyze the Poorly Performing Queries Identified by Profiler in SQL

Server 2008 R2.

• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

• Developing Cascading Reports for Analytics Reports, Ad hoc Reports using Report Builder, SQL server Reporting

Services (SSRS) 2008 R2

• Creating and deploying various Reports like Drill Down, Drill Through, Chart, Linked and Parameterized reports using

SSRS

• Generating on demand and scheduled reports for business analysis or management decision using SQL Server

Reporting Services (SSRS).

• Performing Unit and Regression tests for Developed Reports and Deployed into the Server

• Involving in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.

• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.

Developed functional and technical documentation to assist in the design, development and/or maintenance of

•

deliverables.

Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server

•

to facilitate Ad hoc reporting by the business users.

Environment

Microsoft SQL Server 2008 R2, Business Intelligence Development Studio (BIDS 2008 R2), Management Studio, Visual Studio

2010/2008, .NET Framework, Windows Server 2003

Direct Energy Business, Pittsburgh, PA Jan 2011 – Oct 2011

SQL Server BI Developer

The project Operational Transaction Store is to enhance existing manual system to automate pricing information of a customer. For

all the markets, the new process to be delivered in this work stream shall add a hierarchy of how data will be acquired and validated.

The system shall establish a hierarchy that will attempt to retrieve data from web scrapes and ECL (Eligible Customer List) data

which will save cost and eliminate three day wait time to acquire data from ESG (Energy Services Group). The hierarchy

functionality is being covered in its own work stream but the Pricing work stream shall take advantage of the new hierarchy.

Additionally the new HU Requestor shall significantly reduce turnaround time for usage data request/acquisition.

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to

the database and written functions, stored procedures and triggers.

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using

SSIS, BCP and Bulk Insert.

• Created complex Stored Procedures, triggers, cursors, tables, views and SQL joins and statements for applications by

using T SQL.

• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

• Created Dimensions with the cube wizard and also individually.

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.

• Created reports with Analysis Services Cube as the data source using SQL Server 2008 Reporting Services.

• Created the automated processes for the activities such as database backup processes and SSIS Packages run

sequentially using SQL Server Agent job.

• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

• Assisted in production of OLAP cubes, wrote MDX queries to produce reports using SQL Server 2008 Analysis Services

(SSAS) and Reporting service (SSRS).

• Helped in Designing Business Models as per requirement for SQL 2008 Analysis Services cubes.

• Involved in coding for script task for creating SSIS Packages. Very good understanding knowledge of SQL CLR objects.

• Filtered bad data from legacy system using complex T SQL statements, and implemented various constraint and triggers

for data consistency.

• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of

information from both internal and secondary data sources to customers in sales area.

• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute

Process Task, Execute Package Task, Send Mail Task.

• Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.

• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments

for the SSAS cubes.

• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication

verification, database integrity verification, indexing and statistics updates.

• Involved in designing cubes in SSAS environment using Star Schemas.

• Involved in creating Dimensions, KPI, Measures and calculations.

• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring

and Tuning MS SQL Server Performance.

• 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.

Environment:

MS SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, T SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS,

Performance Point Server, ASP.Net, C#, IIS 4.0, Visio 2000, SQL Server Query Analyzer, SQL Profiler,, MS Access.

AT & T, San Antonio, TX Oct 2009 – Dec 2010

Role: SQL Server / BI Developer

AT & T is one of the leading providers of high growth communications services. It is the Implementation of high performance data

warehouse infrastructure that integrates data from a several of source systems and provide client with information. The major role

was that of migration of packages using SSIS and work on T SQL, stored procedures to implement business logic.

Responsibilities

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and

•

understanding the functional work flow of information from source systems to destination systems.

Involved in business requirement gathering, technical design documents, business use cases and data mapping.

•

Involved in Normalization and De Normalization of existing tables for faster query retrieval.

•

• Involved in upgrading from SQL Server 2000 to SQL Server 2005.

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

•

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.

•

Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and

•

errors using SQL Server Integration Services (SSIS).

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the

•

environments (Development and Production).

Implemented Event Handlers and Error Handling in SSIS packages.

•

Created SSIS packages for Data Conversion using data conversion transformation.

•

Configured the loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also

•

implemented checksum SCD method to load the data into date warehouse.

Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting

•

requirements.

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.

•

Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP

•

reporting needs.

• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to

analyze performance of Strategic Business Units as well as corporate centers.

• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of

unused attributes and by changing the attribute hierarchy options in SSAS.

Developed functional and technical documentation to assist in the design, development and/or maintenance of

•

deliverables.

Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).

•

• Developed a High level dashboard using SSRS 2005

Created copies of operational Databases using the Import/Export Wizard.

•

• Designed and created Report templates, bar graphs and pie charts based on the financial data.

Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

•

• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005

• Involved in creating report models and applying row level security filters for report model.

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL,

•

DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.

Environment

SQL Server 2000/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net

framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Andhra Pradesh Dept. of Community Health, India Sep 2007 – Aug 2009

SQL Server Developer

This project was mainly for the clients of the health department wherein they have to produce their bills for the reimbursement for

traveling, car rental, lodging; this resulted in developing a system to keep track all of the payments using Oracle, Forms 4.5 and

Reports 2.5. This application encompassed the equipment and software modules along with the relevant modules like the location,

description and status codes.

Responsibilities

• Actively participated in gathering Business Requirements and System Specifications.

• Created new Databases, tables, established relationship among tables in a database .

• Created complex stored procedures and functions to support efficient data storage and manipulation.

• Implemented batch processing using Jobs and DTS.

• Created views to display required information on user interface, and triggers to validate consistent data entry into the

database.

• Defined Constraints, Rules, and Indexes.

• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard) .

• Scheduled Jobs using SQL Server Agent.

• Used SQL Server System Catalog to find Stored Procedures, UDF, Triggers, Tables, indexes and constraints on

existing databases.

• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

• Used various levels of triggers and procedures to validate the data at each level.

• Extensively involved in writing stored procedures, triggers, functions and packages based on the client requirements.

• Created database tables with complex constraints applicable to the business rules.

• Analyzed requirement of client and worked on developing and designing reports.

Environment

SQL Server 2000, Crystal Reports, MS Access, Excel, MS Word and Windows NT.

Rane Brake Linings Ltd, India Nov 2006 – Aug 2007

SQL Server Developer

Rane Brake Linings is one of the leading automobile industry manufacturing products like Brake Linings, Clutch Facings and

Railway blocks. There are four modules: Test Parameter Information Module, Supplier Complaints handling Module, ISO Procedure

Module, Reports and Graphics Module. Test Parameters required for testing Raw Material, Packing Material and Other General

Stores Items are maintained. Supplier Complaints are entered in the system. From the Invoice number the reasons for the rejections

are identified.

Responsibilities

Involved in requirement gathering, analysis, design, development, change management, deployment and user

•

training.

Involved in Physical / Logical design of database, creating and managing the database and all the database objects.

•

Generated T SQL scripts for application development.

•

Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential

•

Integrity.

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

•

Created Stored Procedures and User Defined functions.

•

Created Indexes to speed up the queries.

•

Worked on complex data loading (implemented the batch data cleansing and data loading).

•

• Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

•

• Monitored performance and optimized SQL queries for maximum efficiency.

• Implemented fine tuning of database objects and server to ensure efficient data retrieval.

• Transformed data from various data sources using OLE DB connection by creating various DTS packages.

• Planned Backup strategy based on projects requirements.

• Worked in Enterprise Manager for job scheduling and batch queries.

Environment

SQL Server 2000, SQL Server Query Analyzer, DTS, SSAS, SSRS, Crystal Reports, T SQL, Windows 2000/XP.

Contact this candidate