SQL Server Developer

KRISHNA MADHARI

Employer details: *******@*******.***

Contact: 571-***-****

MS SQL SERVER BI DEVELOPER

SUMMARY:

. Microsoft Certified Professional with 8 years of IT experience as a

MS SQL Server Developer 2000/2005/2008 in various industries like

Financial, Health-Care and Insurance

. Extensive experience in MS SQL Server 2008/2005/2000, Business

Intelligence in MS SQL Server Integration Services, MS SQL Server

Reporting Services, and MS SQL Server Analysis Services

. Extensive experience in Extracting, Transforming and Loading (ETL)

using SSIS, bulk insert, BCP, DTS packages into the Data warehouse

from heterogeneous databases

. Proven ability in utilizing ETL tools including SQL Server

Integration Services (SSIS), Data Transformation Services (DTS)

. Expert in creating and deploying SSRS Reports on the portal for

user accessibility

. Experienced in writing parameterized queries for generating Tabular

reports, Formatting report layout, Sub reports using Global

Variables, Expressions, Functions, Sorting the data, defining data

source and sub totals for the reports using SSRS 2008/2005

. Supported large user groups in productions and work closely with

OLTP and OLAP/ data warehouse infrastructure management teams and

database administrator

. Expert in deploying SSRS reports on the portal for user

accessibility.

. Created multiple Cubes with Dimensions and Facts and calculating

measures and dimension members using Multidimensional expression

(MDX).

. Experience in implementing KPI's, Aggregation, Partitions,

Perspectives, Hierarchies and calculated members using SSAS.

. Highly proficient in using T-SQl for developing complex Stored

Procedures, Tables, Views, SQL Joins and T-SQL Scripting

. Experience in Logical and Physical Database design & development,

Normalization and Data Modeling using Erwin and SQL Server

Enterprise Manager

. Expert in transforming complex business logic into database design

& maintaining it by using SQL objects like Stored Procedures, User

Defined Functions and Views

. Proficient in analyzing query plans using extended stored

procedures, creating and managing Indexes and locks

. Experience in query optimization & performance tuning of stored

procedures and functions

. Worked with third party tools like Erwin, SVN and Visio

. Excellent communication and inter-personal skills with ability to

develop creative solutions for challenging client needs using agile

methodologies

. Ability to handle multiple tasks and responsibilities independently

as well as a proactive team member

. Flexible and versatile to adapt to any new environment and work on

any project

EDUCATION:

Masters in Software Engineering Stratford University GPA: 3.63/4.0

Bachelor of Technology in Computer Science and IT, JNTU, INDIA

CERTIFICATION:

70-448 Microsoft SQL Server 2008 Business intelligence Development &

Maintenance

70-433 Microsoft SQL Server 2005 Business intelligence Development &

Maintenance

Technical Skills:

RDBMS/DBMS : MS SQL Server, MS Access

Database Technologies/Tools : SQL Server Enterprise Manager, T-SQL, OLTP,

OLAP, Query Analyzer,

SQL Profiler, DTS,

SSIS, SSRS, Replication, DBCC, BCP

Operating Systems : Windows XP, 2003, 2000, Windows 3.0,

MS DOS 4.0-6.2

Programming Languages : SQL, TSQL, XML, HTML, C, C++

Web Tools : Internet Information Server

(IIS), FTP, MS Office 2007/2003, MS

Excel 2007/2003, MS

Outlook 2007/2003

Professional Experience:

ING, Windsor/CT

Sep'11 - Present

Role : SSIS/SSRS Developer

The data from the upstream systems (GMDB, IIM, ESG & BU Liability Cash

Flows) are gathered and stored in staging database (ING EC Staging

Database).The data is then transferred to the vendor operational database

through an ETL process. All the EC calculations will be performed on the

data available in operational database. The results will be stored in the

operational database. Various reports will be generated using the

analytical services hosted in the reporting database server. The business

users will be able to view these reports through the Share Point

application.

Responsibilities:

. Analysis, Design and Development of the requirements based on

Application Functional Document (AFD).

. Providing analytical and technical support in the design, development,

and implementation of applications in a SQL environment.

. Created SSIS packages to Extract, Transform and load data using

different transformations such as Lookup, Derived Columns, Condition

Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension,

Merge Join and Union all.

. Created archive folders and variables to the packages for

success/Failure.

. Create and modifying various Stored Procedures used in the application

using T-SQL.

. Design and Create Packages in SSIS for file transfer, and data

movement across databases.

. Design and Develop the reports in the form of Excel and text files.

. Developing complex Stored Procedures to generate various Drill-through

reports, Parameterized reports, Tabular reports, Matrix reports and

linked reports using SSRS

. Deployed and scheduled reports using SSRS to generate weekly and

monthly reports

. Designed security based Roles in SSRS (SQL Server Reporting Services).

. Managed Reports accordingly with the business user requirements.

. Created and managed the database, tables, stored procedures, functions

and views.

. Analyzed and manipulated data using T-SQL queries.

. Scheduled jobs for executing the packages which were developed to

update the database on day to day basis.

. Involved in index tuning for better performances.

. Involved in Development, QA and Production environments.

. Document all work of ING applications, so users can easily understand

the flow of process.

Environment : MS SQL Server 2008R2, Microsoft SSIS, Microsoft SSRS, MS

Visio, Excel, Share Point Portal, QRM, SVN and AC

KPMG, Montvale, NJ

Jun'09 - Sep'11

Role: SSIS/SSRS/SSAS Developer

KPMG provides audit, tax and advisory services and industry insight to help

organizations negotiate risks and perform in the dynamic and challenging

environments in which they do business. eAudIT, an enterprise solution

designed and developed to build to support and enable the audit and

advisory methodology. It is robust and easy-to-use application that

supports consistent implementation of the audit, advisory process and helps

to drive quality with industry standards and compliances. eAudIT balances

prescriptive screen-driven data entry with the more familiar forms/document-

driven data entry using InfoPath form to achieve its requirements and to

support electronic workflows, Electronic reviews, real time connectivity/

Synchronization and team management

Responsibilities:

. Involved in the Requirement Analysis, Design and Development phase of

the project.

. Created SSIS packages to extract data from OLTP to OLAP systems and

scheduled jobs to call the packages and stored procedures.

. Used SSIS to implement the Slowly Changing Transformation, to maintain

historical data in data warehouse.

. Extensively involved in designing the SSIS packages to export data of

Excel spreadsheets and flat files sources to SQL Server Database

. Performed data analysis and source to target mapping using

transformations

. Worked with development team to document ETL requirement and turn

those requirements into ETL jobs

. Schedule and maintained routine SSIS packages and alerts using Event

Handler in SSIS and SQL Server Agent

. Developed, scheduled and generated variety of reports like List,

Matrix, Drill-Down, Chart and Sub Report and standardize company

report by implementing SQL Server Reporting Services (SSRS)

. Design standard and menu driven subscription to generate ad-hoc

reports

. Used notification services to generate error messages and send them to

the users through e-mails and text messaging

. Involved in trouble-shooting SSRS reports and maintained proper

documentation for future references and used role based security to

control access to folders and reports

. Used Report Manager to deploy and schedule reports and created groups

and users

. Created cube structure for the analysis of business condition and for

report creation using SSAS..

. Processed cubes to perform incremental updates and optimized cubes for

better query performance.

. Troubleshooting performance issues, optimizing and performance-tuning

queries and stored procedures and providing consultation to other

developers

. Implementing and administering database replication, database

mirroring, log shipping

. Used SQL Server profiler to monitor and trace the events

. Created stored procedures and user defined functions to support

efficient data storage, manipulation and report creation Optimized the

overall performance by creating clustered and non-clustered indexing,

index views and stored procedures

Environment : SQL server 2008/2005/2000, VB.Net, ASP.Net, SQL Server

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

Server Analysis Services (SSAS),.Net Framework 2.0 & 3.5, Visual Studio 08

&10

Bank Of America, Charlotte, NC

Aug'08 - Jun'09

Role: SSIS/SSRS/SSAS Developer

The project involves development of a multi-tier Web Enabled application

for the customers to register and access their accounts online from WMS

(Wealth management System), make transactions and browse for Stocks and

Market Data (Foreign Exchange rates, Equities, Indices) on the Internet.

The application is multi layered for optimized application access

Responsibilities:

. Designed and developed SSIS packages to extract, transform and load

various data sources such as text files, CSV files, Excel spreadsheets

and Oracle data into SQL Server 2005 for further data reporting and

analysis

. Performed various transformations on data such as Data Conversion,

Conditional Split, Term Extraction, Execute SQL task, Bulk Insert,

Merge and Union all etc

. Implemented Complex loggings in SSIS packages

. Scheduled jobs for executing the stored SSIS packages which were

developed to update the database on daily basis

. Developed reports using SSRS

. Created different types of reports such as drill-down, list, matrix

and ad-hoc reports to meet business requirements using SSRS

. Created dynamic reports using SSRS for monthly claims and details of

all locations, generated report models using report builder for the

end users

. Assisted in scheduling and deployment of the reports and also assisted

in uploading files to a report server catalog from the report manager

. Scheduled the monthly/weekly/daily reports to run automatically onto

the dashboard

. Created and manage notification services to manage packages on

success, completion and failure

. Designed and developed data ware house, data marts and business logic

using multidimensional models such as star schema and snow flake

schema

. Implemented OLAP Cubes, Facts and Dimensions for providing summarized

and aggregate views of large sets of data and used Multidimensional

Expressions (MDX) to access them.

. Created and managed stored procedures, indexes, views, user defined

functions and database constraints to meet business requirement and

policies

Environment: SQL Server 2005, 2008, T-SQL, SSIS, SSRS, SSAS, Query

Analyzer, MS-Access, SQL profiler

American Capital, Bethesda, MD

Oct'07 - Jul'08

Role: SQL Developer/ SSIS/SSRS/SSAS

American Capital is the only alternative asset management company that is a

member of the S&P 500. With $20 billion in capital resources under

management, American Capital is the largest U.S. publicly traded private

equity firm and one of the largest publicly traded alternative asset

managers. The project involved Database Administration, Support

(Development & Production), Software Installation, Database Performance

Tuning & Maintenance, Database Back up and Recovery, Export/Import of Data

Responsibilities:

. Transformed data from MS SQL Server 2000 to MS SQL Server 2005 using

OLE DB Connection by creating various SSIS packages

. Developed DTS Packages to transfer the data between SQL Server and

other database and files.

. Created the DTS packages in which records were loaded daily in order

to create and maintain a centralized Data Warehouse

. Used SSIS to create ETL packages to validate, Extract, Transform and

load data from different Databases to the Data Warehouse and Data

Marts.

. Scheduled jobs for executing the stored SSIS packages which were

developed to update the database on a daily basis.

. Designed, Developed and Deployed reports in MS SQL Server environment

using SSRS 2005

. Generated various reports like Tabular reports and Drill down reports,

Sub reports and Parameterized reports using SSRS.

. Responsible for Monitoring and tuning Report Performance.

. Implemented SSAS Cubes, Facts, and Dimension Tables to perform

Analysis.

. Created MDX queries to extract data from Data mart.

. Designed schema for the Data Mart databases.

. Created objects like Procedures, Functions, Packages, Indexes and

Views using T-SQL Scripts in Development and Production environment

for SQL Server 2005

. Implementation of SQL Logins, Roles and Authentication Modes as a part

of Security Policies for various categories of User Support

. Creating stored procedures, batch scripts, cursors for the Bulk

application, testing on the test servers and moving them to production

. Responsible for Database creation, database tuning, performance

planning and database administration

. Rebuilding the indexes at regular intervals for better performance.

. Involved in trouble shooting and fine-tuning of databases for its

performance and concurrency

. Monitored and modified Performance using execution plans and Index

tuning

. Extensively working on IMS performance issues like update statistics,

rebuilding the indexes at regular intervals for better performance

. Designed and implemented comprehensive Backup plan and disaster

recovery strategies

Environment: SQL Server 2000/2005 with clustering, T-SQL, Windows 2003

Server, DTS, SSIS, SSRS, SSAS, Oracle, DTS, Excel, Access, IIS

UnitedHealth Group

Apr'06 - Aug'07

Plymouth, MN

SQL Server/SSIS/SSRS Developer

Description: United HealthCare coordinates network-based health and well-

being products and services that are innovative, affordable, and keep

individuals involved in their own health and wellness. The businesses of

UnitedHealth Group are diverse, they are involved in decision making that

often has positive life-changing consequences for millions of Americans

and execute complex health-related transactions on a huge scale. We have

perhaps the largest network of physicians, hospitals, health facilities and

caregivers in the nation

Responsibilities:

. Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS

Packages

. Experience in creating complex SSIS packages using proper control and

data flow elements

. Experience in Extracting, Transforming and Loading data from Excel,

Flat file to MS SQL Server by using BCP utility, SSIS services

. Created SSIS Packages using different type's task and with Error

Handling

. Regular Monitoring of Servers which includes Backup Job Monitoring,

Disk Space Monitoring, Services Monitoring, Block Monitoring and

troubleshoot all the issues on a regular basis

. Created SSIS packages for daily sales and delivery reports as well as

for adhoc data transforms and data extraction for the Data Migration

team and also upgraded DTS packages to SSIS packages

. Developed SSIS Packages to transform data from excel/Access file to

SQL Server database.

. Extensively involved in using SSRS to author, manage and deliver both

paper-based and interactive Web-based reports

. Experience in building Adhoc reports, Parameterized reports, Toggle

reports, Matrix reports, reports with Sub reports using SSRS

. Maintained and configured SQL Server Report Server

. Performance Tuning upon the live databases. This includes scanning for

performance bottlenecks and troubleshoots them in order to provide the

best service with the Servers

. Creating and Modifying Tables, Stored Procedures, Views, Indexes and

User-defined Functions as required

. Tuning Queries and Database performance using tools SQL Server Tuning

Advisor, SQL Server Profiler

Environment: SQL Server 2000/2005, MS Access, Windows 2000, T-SQL, SSIS,

SSRS, SSMS,SQL Profiler, Performance Monitor, DTS, Erwin, MS Visio.

Genpact

Feb'04 - Aug'05

Hyderabad, India

SQL Server Developer

Description: Genpact is a leader in managing business processes, offering a

broad portfolio of enterprise. This project is designed for the HR

Professional. The HR module is envisioned as a tool to aid the Human

Resources in GENPACT to analyze and portray the Attrition calculations. For

this module the sources are Exit database for the count of the employee's

attrited, internal transfers, for the total head count for Genpact starting

from background information about the employees. There are various cubes

and reports, which give the detail information of Head Count, Attrition%,

Logic Defect yearly, monthly, weekly and daily.

Responsibilities:

. Designing and implementing the module based on the business

requirements given by the business.

. Monitor and tune SQL scripts. Creating upgrade scripts for production

database and supporting it.

. Generating Script files of the databases when ever changes are made to

stored procedures or views or any other database objects and checking

the object

. Using Data Transformation Services (DTS) an Extract Transform Loading

(ETL) tool of SQL Server to populate data from various data sources,

creating packages for different data loading operations for

application.

. Running DBCC consistency checks, and fixing data corruption in

application databases.

. Installing SQL Server service packs based on the errors and flaws that

are found in the application.

. Creating and managing schema objects such as tables, views, clusters,

indexes, procedures & maintaining Referential Integrity.

. Monitoring MS SQL Server performance and network issues.

. Creating user logins with appropriate roles, dropping and locking the

logins, monitoring the user accounts, creation of groups.

. Database and Transaction log backups & restoration, backup strategies,

scheduling the backups.

. Backing up system & user databases and restoring them whenever

necessary.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, System

Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard

and Data Transformation Services, T-SQL, Windows 2003/2000 server.

Contact this candidate