Sql Server Manager
Resume:
Lavanya
***.*******@*****.***
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