Lavanya

302-***-****

il0mnu@r.postjobfree.com

Summary

. Over 7 years of IT experience, which includes in Database

Administration, Development of MS SQL Servers 2008/2008R2 in

Production, QA, and Development environments

. Expert level skills in Data Modeling, Data Mapping, Table Normalization,

Optimization and Tuning.

. Worked extensively on system analysis, design, development, testing and

implementation of projects (SDLC).

. Proficient in creating highly flexible Database Architecture according to

business requirements.

. Extensive knowledge in Tuning T_SQL queries (DDL and DML) to improve the

database performance and availability.

. Expert in implementing business logic and procedure in backend using

complex Stored Procedures and effective Functions.

. Expert level skills in Object creation such as Tables and Views, Table

Normalization, Defined Functions (UDF), User created Data Types, Indexes

and appropriate Triggers to facilitate efficient data manipulation and

data consistency.

. Highly proficient in the use of SQL Server and T-SQL in constructing

triggers, tables, user defined functions, views, indexes, Stored

Procedures, user profiles, relational database models and data

integrity, SQL joins, sub-queries and query writing

. 5+ years highly responsible in System Analysis, designing databases,

implementation of Database Objects like tables, Constraints, SQL

stored procedures, triggers, functions, views, indexes

. Good experience in installation and upgrades of/to SQL server

2005/2008 and its service packs, database migrations, backup, recovery

and maintenance of SQL Server 2005/2008 databases in Cluster

environment

. Marveled in Query Optimization, Performance tuning using tools like

SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor

. Design, development and deployment of large software products in both

Client/Server and Web Server Environment.

. Good Knowledge of Normalization/De-normalization, Normal Form and data

modeling

. Good hand on experience on Joins and sub-Queries to simplify complex

queries involving multiple tables

. Strong SQL Server 2008/2008R2/2012 Developer Skills including writing

stored procedures, user defined functions, views, query writing

. Proactive monitoring of databases

. Experience in creating and maintaining database and its objects

. Good in Data warehousing concepts and components.

. Familiar with OLAP cubes and fact table, star and snowflake schemas

. Excellent in MS SQL Server suite of products like SSRS, SSAS and SSIS

of MS SQL Server 2008R2

. Expert in designing reports using SQL Server Reporting Services (SSRS)

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

. Good hand on experience on Joins and sub-Queries to simplify complex

queries involving multiple table

TECHNICAL SKILLS

|Databases |SQL Server 2008/2008R2 & 2012, MS-Access |

| |2000/2003/2007, MySql, adequate with Oracle 9i & |

| |10g |

|Database Tools |Enterprise Manager, Query Analyzer, SQL Server |

| |Profiler, SSIS, SSAS, SSRS, DTS, BCP, Business |

| |Intelligence Studio |

|Languages |C, C++, VB, XHTML, PHP,T-SQL |

|OS |Windows 2008 Enterprise, Windows 2000 Datacenter, |

| |Windows NT & XP |

|Web Servers |IIS 5.0, Apache, Tomcat |

|Other Tools |Erwin, Microsoft Visual Studio 2008/2012, Microsoft|

| |Visio, Microsoft Visual Source Safe, MS-Front Page,|

| |Internet Information Server (IIS), FTP, MS-Outlook |

| |Express. |

|Architecture |Relational DBMS, Client-Server Architecture, OLAP,|

| |OLTP |

WORK EXPERIENCE

JP Morgan Chase

May' 11 - Till Date

Newark, DE

SQL Server SSIS/SSRS Developer

Description

Correspondent mortgage banking section is one of the major leading

ongoing projects in JPMC, where different applications are developed for

the correspondent users as well as Chase Mandatory Desk group to process

multiple loans and payments with the chase in the market. The main purpose

of this project is to process the mortgage loans (single/pool of loans)

which are generated by the correspondent users.

Responsibilities:

. Involved in planning, designing, and implementing application database

code objects, such as stored procedures and views.

. Responsible for building and maintaining SQL scripts, indexes, and

complex queries for data analysis and extraction.

. Well versed in creating Dynamic SSIS packages, using containers &

variables, configuring and scheduling the packages.

. Used different transformations like Conditional Split, Lookup, Merge

Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.

. Used SSIS and T-SQL stored procedures to transfer data from OLTP

databases to staging area and finally transfer into data marts and

performed action in XML.

. Designed and developed SSIS packages, triggers, configuration files,

tables and functions

. Implemented best practices to maintain optimal performance.

. Developed reports using SQL server reporting services (SSRS).

. Participated in study and analyzing business requirements.

. Involved in automating several existing manual processes.

. Developed new processes to facilitate import and normalization,

including data file for counterparties.

. Worked with business stakeholders, application developers, and

production teams and across functional units to identify business

needs and discuss solution options.

. Ensured best practices are applied and integrity of data is maintained

through security, documentation, and change management.

. Designed SSAS cube to hold summary data for Targit dashboards.

Developed Cube with Star Schema.

. Involved in development &Deployment of SSAS Cubes and Monitor Full and

Incremental loads and support any issues.

. Worked closely and pro-actively with project leadership to identify

and resolve key risks with the Hyperion upgrade project.

. Prepare and schedule Database change requests and coordinate with DBA.

. Setup of test and QA environment from production.

. Prepared SQL scripts for initialization.

. Testing of Backup's and Documenting backup strategies. Created scripts

for automating online daily backup and for automating data loading

from flat files.

. Involved in unit testing and functional integration testing of PL/SQL

programs.

. Generated reports using SQL Server Reporting Services 2008 R2 from OLTP

and OLAP data sources.

. Designed and deployed report with Drill Down, Drill Through, Dropdown

menu option, Parameterized and Linked reports.

. Deploying and scheduling Reports using SSRS to generate all daily,

weekly, monthly and quarterly Reports including current status.

. Created report models and deployed on report server.

. Designed and implemented several complex reports and administration

modules.

. Created Reports with latest features provided by SSRS like dynamic

navigation, hyperlinks, different set of graphs in tabular format etc.

Environment: SQL Server 2008/2008R2, SQL Reporting Services(SSRS), SQL

Server Integration Services(SSIS),DTS,SQL Server Analysis

Services(SSAS),ERWIN, C#, Java Script, JQuery, ADO.NET, Visual Studio.NET

Atos, Jan' 10 -

Apr'11

CincinnatiOH

SQL Developer/SSIS/SSRS

Description

Atos is an international information technology services company which

delivers hi-tech transactional services, consulting and technology

services, systems integration and managed services.

Responsibilities:

. Helped in the Installation and configuration of MS SQL Server

. Responsible for developing Stored Procedures, Triggers, Views and User

defined functions

. Efficient use of Joins and sub-queries in queries that involve data from

multiple tables

. Fine tuning of stored procedures to improve the performance

. Performed Performance tuning on SQL queries, triggers and stored

procedures

. Used Audit functions to keep track of the changes made to the database

. Responsible for design and Normalization of the database tables.

. Used Exception handling to catch and report the errors

. Created custom and Ad hoc reports using SSRS

. Created User list first title played reports.

. Created reports by retrieving the data from cube using MDX reports.

. Designed reports, Graphs and deployed reports to web applications using

SSRS.

. Used Caching (Cache Technology) for fast retrieval of data to generate

reports against data warehouse.

. Designed MDX queries to retrieve data from SSAS cubes.

. Created SSIS packages for File Transfer from one location to the other

using FTP task.

. Designed Cube partitioning and incremental synchronization for SSAS

cubes.

. Generated several drill down and drill through reports using SSRS

. Responsible for creating SSIS packages to extract data from different

sources consolidate and merge into one single source.

. Used DTS packages to implement Extraction, Transformation and Load (ETL)

. Modified existing SSIS packages to meet current business needs

. Wrote stored procedures to be used in the SSIS packages

. Played Active part in the development of SQL Server Maintenance plan,

scheduling of Jobs, Alerts and Troubleshooting

. Had to modify the current stored procedures to meet the current design

. Responsible for creating indexed views, and appropriate indexes to cut

the complex query time.

. Involved in system testing

. Active part in maintenance of data cubes

. Monitored performance and optimize SQL queries for maximum efficiency

. Identified and defined the Datasets for report generation

. Wrote T- SQL queries for data retrieval

. Took part in the normalization and de-normalization of database

Environment: SQL Server 2008R2/2008, Reporting Services (SSRS), Integration

Services (SSIS), Analysis Services (SSAS), DTS, Oracle 9i/8i, T-SQL, MDX,

Erwin, SharePoint, Visual Studio 2005, Windows 98/NT/2000/2003, XML,XSLT,

Java, Web Services, MS Excel MS Access and Team Foundation Server

Penn National Insurance,

Aug'08-Nov'09

Harrisburg, PA

SQL Server BI Developer

Description:

Penn National Insurance sells property-casualty insurance like

business insurance, personal auto, home owners, etc. and surety bonds

through independent agents in nine states

Responsibilities:

. Collected the user and system requirements and write technical

specifications.

. Actively involved in Normalization & De-normalization of database.

. Create tables, views, clustered & non-clustered index, user defined data

types, and user defined functions.

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

tables.

. Mentor front end users about SQL Queries.

. Designed and built OLAP cubes to meet reporting needs.

. Imported various Sources, Targets, and Transformations using SSIS

packages.

. Generated different types of Reports (Tabular/Matrix) using SSRS.

. Experience in creating reports using SSRS and worked on OLAP environment.

. Created several Complex Reports (sub reports, graphical, multiple

groupings, drilldowns, parameter driven, formulas, summarized and

conditional formatting) using SSRS.

. Develop and implement backup and recovery strategy.

. Created stored procedures and triggers for database transactions in SQL

Server

. Create and customize SSIS packages and used SSIS to load data from

difference sources.

. Performed ETL operations to support the data loads and transformations.

. Experience in assisting the Application Developers in creating conceptual

data models that meet the business and technical objectives.

. Used Performance Monitor and SQL Profiler to optimize queries and enhance

the performance of database servers.

. Extensively used the SQL Analyzer and Profiler for studying the SQL

statements and procedures.

. Performing Backup and Recovery & Automation of Backup and Recovery.

. Creating Triggers, stored procedures, tables and queries. Import and

export of SQL objects from and to various sources.

. Monitored database performance and processed speed activities on SQL

profiler and optimized database.

Environment: SQL server 2008, Oracle 9i, Visual Studio .NET, Win Nt, Lotus

notes, Microsoft Visual Source Safe SSIS, SSRS, SSAS, ER-Win.

Lehman Brothers, Apr'07-Jun'08

India

SQL Developer

Description:

This was a health care web portal that manages the communication

between on-field therapists and the administrative staff in the corporate

office. Critical patient information is shared along with time-entry and

billing information. This was a migration project from Oracle 9i to SQL

Server 2000.

Responsibilities:

. Developed data conversion programs to load data from various sources

(Excel, flat files, MS Access) into lookup tables.

. Cleaned up and loaded data from flat files and Excel sheets into

database lookup tables using DTS and SQL scripts

. Provided p

. Written T-SQL Stored Procedures, Functions and Triggers to implement

business rules into the application.

. Involved in data extraction, transformation and loading (ETL). Used DTS

to load data into database. Worked with variety of data sources like

flat files, Excel sheets, Access Database, Oracle 9i database.

. Written stored procedures to populate final database tables from staging

tables and clean inaccurate data.

. Extensive use of DTS packages to extract weekly Excel reports from

database tables.

. Created and maintained versions SQL Scripts for tables, indexes,

constraints, views etc. for the entire project.

. Developed numerous programs using T-SQL and many functions to do the

validations, data cleansing and loading as per requirements.

. Schedule nightly and weekly jobs using SQL Agent jobs. Responsible for

monitoring the nightly data load and report generation schedule.

. Took daily and weekly database backups.

. Generated SQL Scripts and create views for reports.

. Used Query Analyzer and Enterprise manager as a development tool.

. Ad hoc report generation using Query Analyzer.

. Used Execution Plan and SQL Profiler to tune database views and queries.

Environment: SQL Server 2005, SQL, T-SQL, DTS packages, Query Analyzer,

Enterprise Manager, Windows 2000, VB Script.

Hutchinson Essar,

Feb'06-Mar'07

India

SQL Developer

Description:

Hutchinson Essar is India's largest and leading mobile communications

company. Worked as a part of the team responsible for the development of

Billing and Customer Relationship Management system

Responsibilities:

. Efficiently helped in the Software Development Life Cycle (SDLC)

processes including Analysis, Design, Programming, Testing and

Documentation

. Responsible for MS SQL Server Installation and configuration, applied

service packs and hot fix.

. Used SQL Server Enterprise Manager and Query Analyzer to administer SQL

Server.

. Involved in creating Databases, Tables, Cluster/Non-Cluster Index,

Unique/Check Constraints, Rules and Defaults.

. Wrote User Defined Functions and Stored Procedures, and also defined

Roles and Privileges to control access to database.

. Created Triggers to enforce data and referential integrity.

. Created Constraints, Defaults, Views and Indexes.

. Created Triggers to enforce data and referential integrity.

. Developed Master/Detail Reports and Tabular reports based on the user

requirements using Crystal Reports

. Defined Check constraints, Business Rules, Indexes, and Views.

. Hands on Performance tuning, Analyze and optimize SQL Server

application using performance monitor

Environment: SQL Server 2005, Windows NT 4.0, Crystal Reports 9.0.

HDFC Bank,

Jan' 05-Jan, 06

India

SQL Developer

Description:

HDFC Bank provides different Home mortgage plans for its customers

based upon there convenience. Different loans were processed based upon the

interest rates that are available in the present day market.

Responsibilities:

. Involved in the Software Development Life Cycle (SDLC) processes

including Analysis, Design, Programming, Testing and Documentation

. Successfully implemented physical database on MS SQL Server 2000.

Supported complex relationship using triggers.

. Tuned database by creating proper Indexes on different tables that

improve the performance of T-SQL queries on the database.

. Facilitated simplified access of database for end users using de

normalized views and created triggers on them to maintain to database

integrity.

. Created audit trails of activities on database using triggers on

backend.

. Implemented the business logic and processing of the payment by

developing stored procedures and scripts.

. Created Cursors to facilitate the users (credit officers) to scroll

through the Queues to perform manual operations on the payment.

. Automated many operations by scheduling multiple DTS packages using

jobs.

. Created Crystal Reports on daily, weekly and monthly basis for manger's

review

. Used SQL Server Profiler to trace the slow running queries and

optimized query execution with the use of Index Tuning Wizard and

Rebuild indexes if necessary.

. Used SQL Server Enterprise Manager and Query Analyzer to administer SQL

Server

Environment: MS SQL Server 2000, Reporting Services, XML, DTS, Crystal

Reports

Educational Summary

Bachelor of Engineering in JNTU India

Contact this candidate