Christina

SQL Server Developer

Ph No:908-***-****

Email id:acxv8f@r.postjobfree.com

Professional Summary:

Having 8+ years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of software applications.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop SQL Objects and maintain Stored Procedures and User defined functions

Expertise in building script using T-SQL (DDL and DML)

Experience in debugging and optimizing Views, Functions, T- SQL queries, stored procedures and triggers

Expert in developing Data Definition Language (DDL) and Data Manipulation Language (DML)

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity

Created sub queries, Created Clustered and Non Clustered indexes on Tables

Good knowledge of normalization/de-normalization of database tables and building referential integrity for the Relational Database Management System (RDBMS)

Experience in creating packages, Jobs, Sending Alerts using SQL Mail

Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities

Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery

Experience in using SSIS for data extraction, transformation and loading

Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling

Using MS SQL Server Analysis Services (SSAS) on a Data Warehouse

Create/Edit/Maintain ETL processes utilizing Microsoft SQL Server Integration Services (SSIS) from a diversity of data sources including other servers, flat files, MS Access and Excel

Experience in enhancing and deploying the SSIS Packages from development server to production server

Hand-on working experience in creating SQL Server Reports using SSRS

Hands-on working experience in Installing, configuring, upgrading and managing SQL Server 2008/2005/2000 and required Service Packs

Experience in supporting production Databases, monitoring, troubleshooting and documenting root cause analysis

Experienced in handling Service Level Agreements (SLA's) as well as Operational Level Agreements (OLA's)

A well-organized, goal-oriented, highly motivated effective team member with excellent troubleshooting, and problem solving skills

Excellent communication skills, analytical skills, understand business requirements in various domains

Technical Skills

Databases : MS SQL Server 2000/2005/2008/2008r2, MS access

Languages : C#.Net, VB.Net, SQL, T-SQL, PL/SQL, HTML, XML

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

Operating Systems : Windows Server 2000/2003/2008, Windows XP/Vista

SQL Server Tools : SQL Server Management Studio, Enterprise Manager, Query Analyzer, Profiler, Export & Import (DTS)

Business Intelligence Tools : Business Intelligence Development Studio (BIDS), DTS Packages,

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

Web Technologies : ASP.NET

Internet Tools : Internet Information Server (IIS 5.0/6.0)

Other Tools : Microsoft Office 2003/2007, TFS 2008

Professional Experience:

Waddell and Reed, Shawnee Mission, KS April ’16 – Present

Role: SSRS Developer

Waddell & Reed Financial, Inc. is an American asset management and financial planning company founded in 1937. It operates asset management and distribution subsidiaries, including Ivy Investment Management Company and Waddell & Reed Investment Management Company.

Responsibilities:

Provided problem solving techniques for performance issues and data fine tuning.

Worked with HP Application Lifecycle Management (HP ALM) for issues with existing reports and task allocation.

Focused on modifying existing reports for changes in business rules.

Worked closely with Business team and end users to translate reporting requirements into feasible end products.

Worked with PostgreSQL DMBS as a data source for reporting purposes.

Used SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reports.

Worked with Hadoop Distributed File System (HDFS) for data storage purposes.

Environment: SQL Server Reporting Service (SSRS), PostgreSQL, Hadoop Distributed File System (HDFS), HP Application Lifecycle Management (HP ALM), MS Excel

USDA, Risk Management Agency, Kansas City, MO Jan ’15 – Feb ‘16

Role: Database Developer

Risk Management Agency is within the U.S. Department of Agriculture and provides risk and insurance coverages dealing with both insurance providers and the final end users. It maintains several internal and external applications.

Responsibilities:

Table creation with Keys, Clustered and Non Clustered Indexes on tables, views, and columns.

Responsible for Stored Procedures optimization, Performance tuning & index tuning.

Provided problem solving techniques for performance issues and data fine tuning.

Reviewed stored procedures developed by the developers and given recommendations for the code modifications for production.

Worked with Team Foundation Server for source control, working with CRs (change requests) and DRs (Deployment Requests).

Worked with the largest DB maintained for the agency.

Made changes and fixes that affect both databases and applications (both internal and external).

Participated in Daily Scrum meetings for general updates and bi-weekly scrum meetings for a specific new project.

Creation of required data structures, stored procedures and SQL Agent Jobs for new projects

Attended mandatory government procedures and safety standards training for IT division

Worked on POCs (Proof Of Concepts) for Data Virtualization with DENODO and CISCO.

Worked in the Operations and Maintenance team on quick fixes.

Environment: SQL Server 2012, SQL Server Reporting Service, SQL Server Integration Services, SQL Server Management Studio, Visual Studio 2013,TFS, MS Excel, DENODO Data Virtualization software, CISCO CIS software.

GEHA Inc., Lees Summit, MO Feb ’13 – Jan ‘15

Role: SSRS/SSIS Report Developer

GEHA is a health insurance company which provides coverage to more than 1 million lives worldwide.

Responsibilities:

Worked in creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views for applications

Extensive knowledge on Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production

Developed complex T-SQL code for the application

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc. Created derived columns from the present columns for the given requirements

Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server

Created SSIS package to get data from different sources consolidate and merge into one single source

Used various SSIS tasks and transformations such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse

Created various kinds of reports like Chart Reports, Pivot Reports, Master Detail Reports and Multiple Reports using SSRS

Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query

Setup Machines in different OS and Office combination and available them for test

Security Management - Handling Roles, Users, Logins and granting the Rights

Perform monitoring, daily DB maintenance & updates, debug performance issues

Ensured that best practices are applied and integrity of data is maintained through security and documentation

Environment: SQL Server 2008R2/2008, SQL Server Reporting Service, SQL Server Integration Services, SQL Server Management Studio, Visual Studio 2010,TFS,, Enterprise Manager, MS Excel, Win 2k7 32/64, Win 2k8 32/64

Blue Cross Blue Shield, Newark, NJ Jan ’12 - Jan ’13

Role: SQL Server Developer

BCBS is a health care company which provides different health insurance solutions from health management, monitoring to diagnosis. It also provides many health care products which treat infections, disorders and provide remedy for chronic and solutions to clinical care. Work revolved around the department which acts as liaison between the government and the health care receivers. Worked in the department to help maintain and provide effective solutions to manage the data.

Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO

Configured data partitioning/table partitioning on large tables containing millions of rows in Data ware house databases for better performance and performed Data Compression on large tables to reduce the Database size

Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping

Configured and deployed SSIS Packages from Development to Production Environments

Created, deployed and managed reports using SQL Server Reporting Services(SSRS)

Automated manual processes by creating SQL scripts, tables, indexes, views, and constraints

Monitoring of database size, disk space in all (Production, Model & Development) the environments

Set priorities on tasks that are available on my plate and perform as per their priority

Involved in testing, bug fixing and documentation for the project

Trouble shoot any application, network and security related problems, investigate and report my finding with possible solution and/or recommendation

Discuss issues with program managers, developers and test leads so that we can come up with the solution

Environment: SQL Server 2012/2008R2/2008, SQL Server Reporting Service, SQL Server Integration Services, SQL Server Management Studio, Visual Studio 2010,TFS, Win 2k8 64 Bit Win 2k3, Win Server 2008 R2

Pfizer Pharmaceutical, Exton, PA Oct ’10 – Dec ’11

MS SQL Server Developer

Pfizer is the world's largest research-based biomedical and pharmaceutical company. Pfizer also continues to be one of the world’s largest animal health businesses. They’re focused on disease prevention: animal vaccines and animal prescription medicines. The Project aim was to evaluate database objects and to maintain the database.

Created Clustered and Non Clustered Indexes on tables, views, and columns

Responsible for Stored Procedures optimization, Performance tuning & index tuning.

Reviewed stored procedures developed by the developers and given recommendations for the code modifications for production

Performed the task of taking the backups and scheduling it according to the environment and recovery.

Expert in Configuring, Managing and optimizing transactional replication

Implemented, monitored and configured Database mirroring

Configured and deployed SSIS Packages from Test to Production Environments.

Created, deployed and managed reports using SQL Server Reporting Services(SSRS)

Developed and deployed OLAP cubes for reporting purpose using SSAS.

Deployed database objects from development/testing environment to production environment.

Configured IIS and Report server using Reporting services configuration.

Monitoring the system bottlenecks - CPU, RAM, Disk IO and Networking using performance counters

Used SQL profiler, Query analyzer System monitor, event log viewer,

Monitor and tune the performance of SQL server and scheduled jobs, created alerts, notifications with SQL agent

Worked with Application Developers and Business Analysts to produce all required documentation

Experience in Importing/migrating data from different data sources using SQL server integration services (SSIS)

Experience developed and generating reports using SQL Server Reporting Services (SSRS)

Languages/Technologies/Tools: C#.Net, ASPOSE Cells, SQL Server 2005, SQL Server Reporting Service, SQL Server Integration Services, SQL Server Management Studio, Windows NT/ Windows 95

Department of Health and Human Resource, Lewisburg, WV Dec ’08 – Sept ’10

Sr. Software Engineer

Modified the existing stored procedures, views and triggers to meet the current design

Worked Created Views, Indexed Views, and Partitioned Views as required by front end developer for easier implementation

Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures

Created indexes to speed the execution of data retrieval queries and stored procedures.

Worked on data conversions and data loads from various databases and file structures

Worked on DTS and BCP to transfer data from legacy Server to SQL Server, to load Flat files to SQL Server, database backup and restoration of backup.

Actively involved in troubleshooting existing and new DTS packages issues

Developed rendering C# classes file to reports designing

Attending daily conference calls with the client for discussing development updates and related issues

Environment: C#.Net, ASPOSE Cells, SQL Server 2005, Crystal Reports, Windows NT/ Windows 95

Idea Solutions, India Aug ’07 – Nov ’08

Sr. Software Engineer

Developed the UI Component's like Panel, Textbox, Button, Check Box, Radio Button, and DataGrid etc.

Developing code for data access using ADO.Net

Involved in the debugging and error handling

Created and integrated UDFs and stored procedures for reporting purposes

Designed and wrote queries ADO.Net objects for rendering data reports

Designed and implemented several complex reports and administration modules

Environment: VB.net, SQL Server 2000, Crystal Reports, Windows NT/ Windows 95

Contact this candidate