Sql Server Data

LAKSHMI

Sr. BI Developer

NY City, NY, USA 720-***-**** **********@*****.***

SUMMARY:

. Around 8 years extensive IT experience in MS SQL Server

****/****/****/****** *** 2012 in Strong and In-depth knowledge of

T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics in

Production, Dev and Test environment.

. Ensured on-time, quality release of systems and components.

. Provided technical direction to development teams.

. Expert in Table Design, Schema Design and T-SQL in constructing

Tables, Triggers, User Function, Views, User Profiles, Relational

Database Models, Data Dictionaries and Data Integrity.

. Expert in writing stored procedures, temporary tables, views,

indexes, and triggers as per business requirements.

. Implemented Constraints (Primary Key, Foreign Keys Check and Not

Null/Null) and fine tune Indexes on Tables.

. Experience in writing complex SQL queries involving multiple

tables, inner and outer joins and stored procedures.

. Good knowledge in RDBMS concepts, data models, Star/ Snow Flake

Schemas.

. Expert in Extraction, Transforming and Loading (ETL) data flows

using SSIS creating mappings/workflows to extract data from Oracle,

SQL Server and Flat File sources and load into various Business

Entities.

. Created Data Flow's for Aggregate, sort, lookup, merge, union all

and fuzzy lookups and Used containers for repetitive control flow

tasks

. Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export

control extensively in SSIS.

. Good understanding data warehousing concepts (OLTP and OLAP).

. Experience in Data Warehouse Modeling with SQL Server Analysis

(SSAS).

. Experience in Creation and deployment of cubes on SSAS.

. Created extensive reports using SSRS (Tabular, Matrix) and Crystal

reports.

. Good Hand on Resolving complex issues and Error Handling in SSIS

and SSRS and good knowledge in scheduling and deploying reports.

. Experience in developing User reports and management reports using

MS SQL Server Reporting Services (SSRS).

. Experience in developing Custom Report and different types of

Tabular Reports, Matrix Reports, Crystal reports and drill down

reports in multiple formats using SQL Server Reporting

Services (SSRS) in Business intelligence development studio (BIDS).

. Experience in enhancing and deploying the SSIS Packages from

development server to production server.

. Maintained Database authentication modes, creation of users,

configuring permissions and assigning roles to users.

. Good team player, strong interpersonal and communication skills

combined with self-motivation, initiative and the ability to think

outside the box.

DOMAIN:

. Finance

. Insurance

. Telecom

. Health care

EDUCATION: Bachelors in Engineering, India.

TECHNICAL SKILL MATRIX:

Operating 8 Years Windows Server 2000, 2003, 2008 and 2008R2.

Systems Unix, MS Windows (95,98,NT,2000,XP)

SQL Server Tools 8 Years Business Intelligence Development Studio

(BIDS), SQL Server Integration Services (SSIS),

SQL Server Analysis Services, OLAP (Online

Analytical Processing)-Cubes, Storage, Data

Mining Models, Visual Source Safe, BCP,

Enterprise Manager, Profiler and Data

Transformation Services.

Languages 8 Years MDX/DMX, VB.Net, VB Script, Transact-SQL,

PL/SQL, HTML, DHTML, XML, ASP, C and C++.

ETL Tools 8 Years SSIS (SQL Server Integration Services), DTS.

Reporting Tools 8 Years SQL Server Reporting Services, Import Export

Data, Bulk Insert, and Business Objects

6.5/XI/XIR2, Crystal reports, MS Excel.

RDBMS 8 Years MS SQL Server 2008R2/2008/2005/2000/7.0, Oracle

9i/8i, MS Access, DB2, Teradata V2R6/V2R5.

Data Modeling 2 Years Erwin, MS Visio.

and

Configuration

Tools

Methodologies 8Years RUP (Rational Unified Process), Agile, SCRUM,

Waterfall.

Testing Tools 8 Years Quick Test Pro, Mercury Quality Center, TOAD

(Tool for Application Developers).

PROFESSIONAL EXPERIENCE:

VIACOM, NY, USA Sept

2012- till date

Sr. BI Developer

Project: Navigo

Viacom, New York is a Media Company which we will be getting data from

multiple traffic sources system and provide distribution to the disparate

target application systems.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2008(R2), SQL

Server Reporting Services (SSRS), SQL Server Integration Services(SSIS),

SSAS, SQL Server Business intelligence Development Studio(BIDS), Report

Builder, T-SQL, Oracle 10g,11g, MS Excel.

Roles and Responsibilities

. Involved in all the aspects of the project development like - system

analysis, database design, requirements analysis, high level and

detail design, integration/system testing.

. Led team of developers in the delivery of technical systems and

components

. Ensured on-time, quality release of systems and components

. Provided technical direction to development teams

. Oversaw design of applications from functional and technical

specifications

. Installed SQL 2000/2005/2008 and 2008R2 on development and production

servers setting up databases, users, roles and permissions.

* Designed Database Objects like Tables, Stored Procedures, Triggers,

and user defined functions and as per the project requirement.

* Created Data Flow's for Aggregate, sort, lookup, merge, union all and

fuzzy lookups and used containers for repetitive control flow tasks

* Performed Multi File Imports, Package configuration, Debugging Tasks

and Scripts in SSIS and Scheduled package execution in SSIS and

Installing packages on multiple servers in SSIS

* Expert in Extraction, Transforming and Loading (ETL) data flows using

SSIS, creating mappings/workflows to extract data from Oracle, SQL

Server and Flat File sources and load into various Business Entities.

* Created the DTS, SSIS packages to import the data from different data

source like MS Access/Excel/ Oracle/Sybase/My SQL server to SQL

Servers.

* Created SSIS packages to Extract and Load data from diverse source

(flat file, excel, xml and oracle)

* Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export

control extensively in SSIS.

* Developed, tested and implemented Referential Integrity rules and

regulations through constraints, triggers and views, partitioned

views.

* Created Views and table for specific columns on a table to maintain

privacy of a customer data. Created Indexes to get the high level

performance.

* Maintained databases, performed software installations and upgrades,

monitored Database Performance.

* Performing the ETL operations to support the incremental, historical

data loads and transformations using SSIS.

* Created various Tabular and Matrix Reports using SSRS. Created various

drill down reports using SSRS. Involved in the post deployment

maintenance of reports.

* Designed SSIS packages for synchronizing the data between two

different servers.

* Expert in Creating and scheduling SSIS and SQL server jobs for various

tasks.

Bealls Inc, FL Jul 2011-Aug

2012

Sr. BI Developer

Bealls Florida have Bealls departmental store and Bealls outlet store

business are selling clothing, footwear, bedding, furniture, jewelry and

some other products. The scope of this project is monitoring daily Prod.

And support as per Business.

Environment: Microsoft SQL Server 2008(R2), SQL Server Reporting Services

(SSRS), Management studio, SQL Server Business intelligence Development

Studio(BIDS), SSAS, T-SQL, Oracle 10g,11g, MS Excel.

Roles and Responsibilities

* Designed Database Objects like Tables, Stored Procedures, Triggers,

and user defined functions and as per the project requirement.

* Created Cluster and Non- cluster Indexes for table and database to get

the high level performance.

* Modified the database by removing unwanted columns and also adding

proper constraints, rules and defaults to tables.

* Implemented Constraints (Primary Key, Foreign Keys Check and Not

Null/Null) and fine tune Indexes on Tables.

* Create and Modify Stored Procedures, According to the business. Fine

Tuning of Stored Procedures and SQL Queries. Worked with Control Flow

tasks, Data flow tasks and Data flow transformations using SSIS 2005.

* Developed various reports to validate the data between source and the

target systems. Involved in providing security to the reports by

restricting various users through Roles.

* Experience in writing and debugging Stored Procedures and triggers.

Designed, Developed and managed the reports using Reporting Services.

* Expert in creating the MDX cubes and dimensions (SSAS).

* Experience with adhoc reporting, Parameterized, Custom Reporting using

SSRS for daily reports and SSAS projects.

* Extensive use of DTS in SQL Server, Performance Tuning & Application

Design, Backups, Disaster Recovery Planning, Security Management,

Managing server and clients, T-SQL, Stored Procedures, Functions and

Cursors and Triggers etc.

* Developed, tested and implemented Referential Integrity rules and

regulations through constraints, triggers and views, partitioned

views.

* Maintained databases, performed software installations and upgrades,

monitored Database Performance.

* Responsible for gathering Business Requirements and System

Specification from users.

* Designed numerous ad-hoc, crystal reports and custom reports using SQL

Reporting Services.

* Extensive experience in data migration between homogenous and

heterogeneous system using various tools (Data Transformation Services

(DTS), SSIS, BCP, Bulk Insert, ActiveX).Involved in the post

deployment maintenance of reports

* Implemented logical design into Physical design. Involved in the

normalization of databases in the OLAP.

State Farm Insurance, Bloomington, IL Apr 2009 - Jun

2011

BI Developer

Godrej Industries is India's leading manufacturer of home appliance. The

aim of the project was to convert historical data files (mostly Excel,

Tally accounting files, Access Database) into the data model of the

database and assisting fellow database developers when needed.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC,

VBScript, Windows 2000/XP, IIS 5.

* Table Design, Schema Design and T-SQL in constructing Tables,

Triggers, User Function, Views, User Profiles, Relational Database

Models, Data Dictionaries and

Data Integrity.

* Interacted with Development Teams and Managers to analyze business

needs and developed technical specifications.

* Merged Data from Heterogeneous Data stores (Oracle, Access and Excel)

to SQL Server 2005 using SSIS packages.

* Participated in to Design ETL architecture and processes insurance and

policies related record from different locations. Successfully met

challenges of very high volume of data.

* Extensively used transformations, control flow tasks, data flow tasks,

containers and event handlers.

* Implemented the Indexing making the Transaction in SQL 2005 faster

nearly three times as compared to the SQL Server 2000.

* Experienced into Tested, Cleaned and Standardized Data meeting the

business standards using Fuzzy /exact lookups.

* Wrote complex T-SQL queries, stored procedures, triggers, cursors and

user defined functions (UDF's).

BMC Software, San Jose, CA Aug 2006

- Mar 2009

BI Developer

BMC develops markets and sells software used for multiple functions,

including IT service management, data center automation, performance

management. . The aim of the project was build database for newly build

application and implement into to this newly built environment.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC,

VBScript, Windows 2000/XP, IIS 5.

* Installed SQL Server 2005 on development and production servers

setting up databases, users, roles and permissions.

* Upgraded all SQL Server 2000 to SQL Server 2005 without any service

interruption.

* Involved in the all the stages of Software Development Life Cycle

(SDLC).

* Involved in the normalization and de-normalization of the databases.

* Created and Modified tables, views, triggers, Indexes, User Defined

Functions, Stored Procedures, cursors in SQL Server 2005.

* Wrote the complex queries using joints, Sub-queries, common table

expressions (CTE) in T-SQL-2005.

* Improved the performance of the T-SQL queries and Stored procedures by

using SQL profiler, Execution plan, SQL performance monitor and Index

tuning advisor.

* Created SSIS packages to transfer data from different data sources

load it to data warehouse.

* Configured SSRS 2008 with MOSS 2007 for directly deploying the report

in SharePoint 2007.

* Used SSIS features like event handlers, property expressions, and

package configurations, transaction option, checkpoints and protection

levels in the packages.

* Used MDX expressions to define calculated members in cubes to

calculate values at run time.

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

* Migrated DTS packages to SSIS packages using package migration wizard.

* Used containers, Execute SQL task, Execute package task, Script task

etc. for transformation of data in the SQL Server Integration Services

packages from OLTP to OLAP.

* Created efficient SSIS packages for processing fact and dimension

tables with complex transformations.

* Performance tuning MDX and dimensions design and scaling to large

numbers of users in SQL Server Analysis Services (SSAS). Created jobs

and scheduled jobs using SQL Server Agent.

* Developed parameterized reports through Reporting Services (SSRS) from

a variety of data sources including Analysis Services Cubes and

prepare for Web publishing.

* Responsible for monitoring the progress of a SSIS packages and logging

progress to a text file, SQL Tables and windows event log.

* Created cubes for Dimension and fact tables for future and current

reporting using SQL server Analysis Services (SSAS).

* Analyze historical trends, identify issues and analyze root cause on

ProClarity Dashboard.

* Created business critical key performance indicators (KPIs) using SQL

Server Analysis Services.

* Wrote MDX queries according to the business requirements.

* Designed and crated distributed reports in multiple formats such as

Excel, PDF, XML, HTML and CVS using SQL Server 2005 Reporting Services

(SSRS).

* Developed drill down and drill through reports from multi-dimensional

objects like star schema and snow flake schema using SSRS and

performance point server.

* Designed and Implemented Comprehensive Backup plans and disaster

recovery strategies.

GODREJ Ltd., Bangalore, India Aug 2006 - Mar

2009

SQL Server BI Developer

Godrej Industries is India's leading manufacturer of home appliance. The

aim of the project was to convert historical data files (mostly Excel,

Tally accounting files, Access Database) into the data model of the

database and assisting fellow database developers when needed.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC,

VBScript, Windows 2000/XP, IIS 5.

Contact this candidate