Sql Server Data

Sujatha Medicherla

************@*****.***

Cell: 469-***-****

SUMMARY:

• Around 7+ years of experience in analyzing, designing and developing Business

Intelligence (BI) database applications and various segments of Software

Development Life Cycle (SDLC), using MS SQL Server 2008/2005/2000, SQL

Server Integration Services (SSIS) and Reporting Services (SSRS).

• Hands on experience in installation, configuration, performance tuning, optimization,

backup and recovery in SQL Server 2008/2005/2000.

• Excellent knowledge in creating Databases, Tables, Stored Procedure, Views, User

defined data types, Cursors and Indexes using T-SQL.

• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the

database performance and availability.

• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.

• Experience in Query Optimization and performance tuning of stored

procedures, functions etc.

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat

file, Oracle to MS SQL Server by using BCP utility and SSIS services.

• Created many complex SSIS packages with transformations like Lookup, Derived Column,

Condition Split, Multicast, Sort, Union All, Conditional Split etc.

• Extensive experience in creating several reports such as drill down reports, parameterized

reports, linked reports, sub reports, Matrix Reports using SSRS.

• Ability to work with team with SQL Profiler and Query Analyzer to identify

performance issues.

• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the

SQL Server Performance.

• Expert in planning and scheduling backups and restoring databases.

• Good knowledge in Normalizing and De-normalizing the tables and maintaining

Referential Integrity by using Triggers and Primary and Foreign Keys.

• Knowledge in SQL Server Analysis Services (SSAS) for designing OLAP

Cubes.

• A well-organized, goal-oriented, highly-motivated effective team member with

excellent analytical, troubleshooting, and problem solving skills.

Technologies:

RDBMS/DBMS : MS-SQL Server 2008/2005/2000, MS Access, MS Excel

Programming Languages: T-SQL, PL/SQL, C, C++, HTML, XML,

ETL Tools : SQL Server Integration Services (SSIS), Data

Transformation Services (DTS)

Reporting Tools : SQL Server Reporting Services (SSRS), Crystal Reports

SQL Server Tools : SQL Server Management Studio (SSMS),

Business Intelligence, Development Studio (BIDS)

Operating Systems : Windows 98/2000/2003/XP/NT/Vista

Citigroup, Dallas, TX April 11 – Nov 13

SQL Server/BI Developer

Description: Citigroup is one of the leading diversified financial services company in

world with leading business in areas of consumers, corporations, governments and

institutions with a broad range of financial products and services, including consumer

banking and credit, corporate and investment banking, securities brokerage, transaction

services and wealth management. The firm is a leader in, financial services for

consumers, small business and commercial banking, financial transaction processing,

asset management and private equity. The project I was involved with AG-NMS

(National mortgage settlement) for various mortgage related 26 metrics to Government

Agencies

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform

and load data from OLTP system to the ODS Data warehouse and Report-Data

mart for NMS metrics.

• Involved in the requirement and gap analysis, design phase and development

phase of SDLC model system and closely working with PM/PL’s in

project/delivery timeline tracking

• Using SSIS, built high performance data integration solutions, including extraction,

transformation, and load (ETL) packages to bring data from default, MAT and

Origination systems into staging layer in ODS for faster reporting.

• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views,

Cursors, Joins, and User Defined Functions to implement the business logic and also

created clustered and non-clustered indexes

• Involved in creating Schemas, Logins, Tables, Views and subject area tables for

reporting marts

Modifications

o

Short sales

o

Late/application fee

o

Foreclosure approvals

o

Appeals information

o

• Developed complex Stored Procedures, Functions involved in extracting data from

default and origination systems for loan Modification, short sales, late fee’s, payment

processing and Application fee attributes for NMS QA reporting

• Performed job scheduling to ensure execution of certain jobs and daily updates.

• Managed the products and development databases including performance tuning, SQL

Server clustering, Log shipping, database security configuration.

• Performed advance queries for databases by using Query Analyzer and SQL Server

Enterprise Manager.

• Implemented and successfully tested Log Shipping in SQL Server 2005 and SQL Server

2008.

• Used Lookups Transformation to get the data from reference data sets.

• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting

to create reports that draw content from a variety of data sources.

• Generated complex custom reports using SSRS 2005 as per customer requirement.

• Involved in the Query optimization and Performance tuning, and also tuned SQL

queries using Show plans and Execution plans.

• Created complex SSRS reports using data mart as well as from the SSAS Cube.

Citigroup, Dallas, TX Feb 09 - Mar 11

SQL Server/BI Developer

Description: Citigroup is one of the leading diversified financial services company in

world with leading business in areas of consumers, corporations, governments and

institutions with a broad range of financial products and services, including consumer

banking and credit, corporate and investment banking, securities brokerage, transaction

services and wealth management. The firm is a leader in, financial services for

consumers, small business and commercial banking, financial transaction processing,

asset management and private equity. The project was involved in reporting mortgage

related data workflow process of identifying SPOC and key loan related properties

Responsibilities:

• Developed complex T-SQL queries for reporting SPOC (single point of contact) and data

extraction from SQL Server

• Using SSIS, built high performance data integration solutions, including extraction,

transformation, and load (ETL) packages to bring data from other system into staging

layer for faster reporting

• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views,

Cursors, Joins, and User Defined Functions to implement the business logic and also

created clustered and non-clustered indexes

• Developed complex Stored Procedures, Functions involved in extracting data for SPOC

and key loan properties (Liens, Borrower, attorney involved, agency) for reporting

• Developed new reports for management to identify loans entering into SPOC workflow and

that are in Imminent Default, Modification, Exit Strategy, or have Foreclosure concerns

• Created DTS packages to export and import data from DB2 database excel to text using

SQL server 2008/2005

• Managed the products and development databases including performance tuning, SQL

Server clustering, Log shipping, database security configuration.

• Created and developed tables, views, indexes, functions and advanced queries for

databases by using Query Analyzer and SQL Server Enterprise Manager.

• Developed, modified, and optimized complex queries to data retrieval and modification

• Implemented and successfully tested Log Shipping in SQL Server 2005 and SQL Server

2008

• Used Lookups Transformation to get the data from reference data sets.

• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting

so create reports that draw content from a variety of data sources.

• Generated complex custom reports using SSRS 2005 as per customer requirement.

• Involved in the Query optimization and Performance tuning, and also tuned SQL

queries using Show plans and Execution plans.

• Created complex SSRS reports using data mart as well as from the SSAS Cube.

Environment: SQL Server 2005/2008, SQL Server Management Studio (SSMS), SQL

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

SQL Profiler, MS Access, Visual Studio 2008, SQL Profiler, Query Analyzer.

Citigroup, Dallas, TX Feb 06 – Jan 09

Business Analyst

Worked in analyst role for “Home Depot Credit Services” line of business within “CITI

commercial cards accounts” group, helping customers identify business requirements,

participate in user acceptance testing and onboarding new modules to business users,

research and resolve customer issues.

Responsibilities:

• Wrote detailed Test Scripts for all applications being affected by this project

• Wrote detailed Test Cases for all scenarios related to the application being tested

• Created a in-depth Test Plan prior to test execution to be approved by all Project

Managers

• Created and managing data preparation for a healthy test environment

• Documented and tracked defects related to all applications being tested during

the testing cycle

• Conducted a developer and 3rd party vendors to get outstanding issues resolved

in a timely manner

• Conducted front-end testing verified all GUI displays in the application are

correct

• Conducted backend process and database verification testing verified all data

populated by independent processes and in the tables is correct

• Verified all data sent to the 3rd Party Vendors is accurate

• Verified all data returned by the 3rd Party vendors is accurate

• Conducted an initial UAT (User Acceptance Testing) and final Walk-through for

users

• Found workaround in case of system failures during testing

Environment: UNIX, Windows XP, .NET, SQL Server and Test Director

Contact this candidate