Sql Server Manager
Resume:
Keerthi
Ph: 214-***-****
*******.******@*****.***
SQL/SSIS/SSRS/SSAS Consultant
CAREER SUMMARY:
More than 6+ years of experience in Design, Development, Implementation, Reporting, and
Analytics in OLTP/ETL environments using MSSQL Server 2008/2005/2000 across all SDLC
environments
Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User
Defined functions
Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and
Microsoft Visio for logical and physical data models
Very Good Experience in Business Intelligence applications using DTS/SSIS/SSAS/SSRS
Handled ETL process development, implementation and support for Terabyte+ data warehouse
environments
Expert in Data Extraction, Transforming and Loading ( ETL) using SQL Server Integration
Services ( SSIS ), DTS, Bulk Insert utilities
Extensively worked on upgrading DTS SSIS packages and Involved in Development, Deployment,
and support of SSIS packages
Experience in using Audit functions and extensively used Exception Handling for catching and
reporting errors
Extensive experience in creating enterprise reports using SSRS 2005/2008 using Report Manager,
Report Builder, and BIDS
Created many Drill Through, Drill Down, Parameterized reports using SSRS 2005/2008
Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular
Reports, Charts, and Graphs
Excellent knowledge in designing and developing Data Warehouses, Data marts and Business
Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
Experience in designing, building and deploying C ubes with Star Schema and Snowflake Schema
using SQL Server Analysis Services (SSAS 2005/2008)
Expert in calculating measures and dimension members using MDX, mathematical formulas, and
user-defined functions
Have hands on experience in Performance Tuning and Query Optimization. Worked on identifying
and resolving blocking and deadlocks
Extensively worked in Migration for MS SQL 2000 to MS SQL 2005 to MS SQL 2008
Worked with different types of Replication Models like Transaction, Snapshot, and Merge
Experience working with tools like Index Tuning Wizard, SQL Profiler, and Windows
Performance Monitor
Hands on Experience working with Oracle databases
Excellent Communication skills, Analytical skills and Team Player
EDUCATION:
• Bachelor’s Degree in Information Technology from JNTU, AP, India
TECHNICAL SKILLS:
Languages SQL, T-SQL, PL/SQL, C, C++, HTML, DHTML, XML
RDBMS MS SQL Server 2012/2008/2005/2000/7.0, MS Access, Oracle 9i
and 10g
Database Tools SSRS, SSIS, SSAS, DTS, BCP, Business Intelligence Studio(BIDS),
Query Analyzer, SQL Management Studio, SQL Server profiler,
SQL Enterprise Manager
Operating Systems Windows 98/2000/XP/NT/Vista, Windows 2000/2003 Advanced
Servers, UNIX
Architecture Relational DBMS, Client-Server Architecture
Version control Tools Team Foundation Server, Visual Source Safe
Other Tools Crystal Reports, Microsoft Visual Studio 2003/2005
PROFESSIONAL EXPERIENCE:
WCA, Houston, TX Nov 2014 - Present
SQL Server/BI Developer
WCA is a vertically integrated non-hazardous solid waste management company providing waste
collection, transfer, material processing and disposal services. WCA commenced business operations in
2000 in Houston, Texas and has expanded under the guidance of a veteran management team to cover
twelve states.
Roles and Responsibilities:
• Gathered end user requirements, developed applications and different Audit functionalities
depending on the requirement acting for both system analyst and an application developer
• Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries,
Dynamic SQL queries etc. Programming in SQL Server – Using Stored Procedures,
Triggers, User-defined Functions, Views, and Cursors
• Involved in database design, normalization, de-normalization in building the Data Warehouse
and Reporting systems
• Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for
data migrations and data validations
• Involved in query tuning by creating Cluster and Non Cluster Indexes on the tables, also used
Index Tuning Wizard (ITW) for enhancing the query performance
• Written complex Stored Procedures using temporary tables
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Derived
Column, Lookup, Merge Join, Conditional Split, Slowly Changing Dimension, and Data
Conversion etc) in SSIS packages
• Used event handlers for error handling includes (On Pre Execute, On Post Execute and On Error)
• Implemented SSIS package configuration files in SQL Server, XML files, Environment
Variables and Parent Package Variables
• Implemented Package logging in both standard (SQL Server and file based) and custom logging
using customer Stored Procedures and tables
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages
• Involved in troubleshooting Complex SSIS Packages and Production Support tasks
• Implemented Standard and Custom SSIS Package logging in SQL Server tables and text files
• Used SSIS Package Configurations stored in XML files and SQL Server Tables
• Involved in installation, reporting services configuration, maintenance, deployment and
troubleshooting SSRS reports in (2005/2008)
• Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports,
Drill Down, Drill Through, and Chart reports using complex data set queries, Stored
Procedures, Views in SSRS 2005/2008
• Created Ad-hoc reports more often based on end user requirements
• Generated and formatted reports using Global Variables, Expressions, and Functions
• Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded
parameters
• Developed complex Report Models which provides ability to the users to create their own
reports using Report Builder and save it in the Report Manager. Also created Linked reports to
optimize redundancy of the reports on the report server
• Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC
environments
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF,
MS Word(from 2008), and Excel formats using SSRS 2005/2008
Environment:
MS SQL Server 2012, SSRS, SSIS, T-SQL, SQL Server Query Analyzer, SQL Server Business
Intelligence Development Studio, Microsoft Visual Studio 2005, Crystal Reports
Maximus Coffee Group, Houston, TX Dec 2013 – Oct 2014
SQL Server/BI Developer
Maximus Coffee Group is the premier coffee and related products manufacturing group in North
America, providing the most integrated, world-class services and products at the highest quality and value
to its long-term clients.
Roles and Responsibilities:
• Gathered end user requirements, developed applications and different Audit functionalities
depending on the requirement acting for both system analyst and an application developer
• Wrote user requirement documents, created technical specs and design documents for various
projects
• Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for
data migrations and data validations
• Written complex Stored Procedures using temporary tables
• Hands on experience in using DDL Triggers (After and Instead of Triggers) to keep track of data
manipulations using Audit functionalities
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations in SSIS
packages
• Implemented SSIS package configuration files in SQL Server, XML files, Environment
Variables and Parent Package Variables
• Implemented Package logging in both standard (SQL Server and file based) and custom logging
using customer Stored Procedures and tables
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages
• Implemented Standard and Custom SSIS Package logging in SQL Server tables and text files
• Used SSIS Package Configurations stored in XML files and SQL Server Tables
• Involved in Monitoring and Deployment of SSIS Packages across DEV,UAT,SIT and Production
environments using DTEXEC Utility, command prompt with .bat files etc
• Involved in installation, reporting services configuration, maintenance, deployment and
troubleshooting SSRS reports in (2005/2008)
• Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports,
Drill Down, Drill Through, and Chart reports using complex data set queries, Stored
Procedures, Views in SSRS 2005/2008
• Created Ad-hoc reports more often based on end user requirements
• Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded
parameters
• Developed complex Report Models which provides ability to the users to create their own
reports using Report Builder and save it in the Report Manager. Also created Linked reports to
optimize redundancy of the reports on the report server
• Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC
environments
Environment:
MS SQL Server 2005/2000, SSRS, SSIS, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server
Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005,
Crystal Reports, C#, ASP.NET, ADO.NET, XML
CareFirst BCBS, Owings Mills, MD Aug 2012 – Oct 2013
SQL Server/BI Developer
CareFirst, Inc. is the not-for-profit, non-stock, parent company of CareFirst of Maryland, Inc.,
and Group Hospitalization and Medical Services, Inc., affiliates that do business as CareFirst BlueCross
BlueShield. CareFirst is a regional leader in providing health care coverage and related services
throughout the Maryland, Washington D.C., and Northern Virginia areas.
Roles and Responsibilities:
• Gathered end user requirements, developed applications and different Audit functionalities
depending on the requirement acting for both system analyst and an application developer
• Extensively studied the existing OLTP system(s) to create data mart and warehouse systems
using the facts, dimensions and star schema
• Wrote user requirement documents, created technical specs and design documents for various
projects
• Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries,
Dynamic SQL queries etc. Programming in SQL Server – Using Stored Procedures,
Triggers, User-defined Functions, Views, and Cursors
• Involved in database design, normalization, de-normalization in building the Data Warehouse
and Reporting systems
• Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for
data migrations and data validations
• Involved in query tuning by creating Cluster and Non Cluster Indexes on the tables, also used
Index Tuning Wizard (ITW) for enhancing the query performance
• Written complex Stored Procedures using temporary tables, table variables, error handling
(TRY & CATCH) methodology for data loads
• Hands on experience in using DDL Triggers (After and Instead of Triggers) to keep track of data
manipulations using Audit functionalities
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages
• Involved in complex SSIS package development with Microsoft BI standards and Development
strategies to pull data from various data sources such as (SQL Server, Oracle, DB2, Excel, and
Flat file etc)
• Participated in upgrading from dts(MS SQL 2000) to dtsx(SQL SERVER 2005) packages and
also from (2005) dtsx to (2008) dtsx
• Involved in Package deployment to DEV, TEST and Production for both SQL Server and File
system using DTUTIL, DTEXEC, .bat file, using Manifest file and also using 3rd party tools
like BIDS Helper
• Involved in SSIS package scheduling using SQL Agent jobs and using tools such as Windows
Scheduler and Control M
• Involved in installation, reporting services configuration, maintenance, deployment and
troubleshooting SSRS reports in (2005/2008)
• Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports,
Drill Down, Drill Through, and Chart reports using complex data set queries, Stored
Procedures, Views in SSRS 2005/2008
• Created Ad-hoc reports more often based on end user requirements
• Generated and formatted reports using Global Variables, Expressions, and Functions
• Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded
parameters
• Developed complex Report Models which provides ability to the users to create their own
reports using Report Builder and save it in the Report Manager. Also created Linked reports to
optimize redundancy of the reports on the report server
• Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC
environments
• Implemented Reports subscriptions using both data driven subscription and time driven
subscriptions
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF,
MS Word(from 2008), and Excel formats using SSRS 2005/2008
• Involved in building the Cubes for various departments and monitored cube loads and refreshes
(Process full and Incremental loads)
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS
OLAP/ Analysis Server (SSAS)
• Involved in Dimensional modeling and also created relationships between Dimensions and
Measure groups
• Identified KPIs in SSAS, and also created MDX queries for Analysis Services & Reporting
Services
• Designed dimensions and cubes with star schema and snowflake schema
• Designed and developed more than 100+ enterprise reports (SSRS/Crystal Reports) using the data
from ETL Loads, SSAS Cubes and various heterogeneous data sources
Environment:
SQL Server 2000/2005/2008/2008 R2 Enterprise Edition, SSIS, SSRS, SSAS, Oracle 9i and 10g, .NET
Framework, C#, ASP.NET, ADO.NET, Crystal Reports, Erwin, T-SQL, Java, J2EE, VisualStudio.NET
IDE, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access, Visual Studio 05
Cigna Health Care, Bloomfield, CT Jan 2012 – June 2012
Sr.SQL Server/BI Developer
Cigna is a global health service company, dedicated to helping the people we serve improve their
health, well-being and sense of security. Cigna make broad range of integrated health care and related
plans and services, and proven health and well-being programs.
Roles and Responsibilities:
• Involved in Installation and Configuration of MS SQL Server 2000/2005/2008
• Responsible for developing Stored Procedures, Triggers, Views, and User defined functions for
all the database change requests
• Fine tuning of stored procedures to improve the performance using best coding practices, proper
indexes and ANSI standards
• Wrote database triggers in T-SQL for auditing and integrity checks on the database
• Used TRY–CATCH error handling methodology to report errors
• Responsible for writing some PL SQL queries, triggers and packages to be used on Oracle
databases
• Monitored and maintained database documentation, including data standards, procedures, definitions for the
data dictionary and logical and physical models of the databases
• Responsible for creating SSIS packages to extract data from different sources consolidate and
merge into one single source
• Used various transformations while creating SSIS packages such as Derived Column, Data
Conversion, Lookup, Union All, Merge Join, Conditional Split etc
• Used DTS packages to implement Extraction, Transformation and Load ( ETL) and scheduled the
packages using SQL Server Agent and other 3rd party tools
• Involved in development of ETL Scripts extracting, transforming and loading (ETL) into enterprise
data warehouse system and corresponding data marts
• Wrote stored procedures to be used in the SSIS packages
• Involved in SSIS package deployment to both SQL Server and File system using .bat file, DTUTIL
and manifest file
• Generated weekly, monthly and quarterly reports using SSRS Reports and scheduled delivery of
reports through Emails
• Developed appropriate layout and designs for required reports using the SSRS and Stored
procedures to retrieve data from the SQL Server using appropriate SQL language (PL/SQL, T-SQL) to
provide optimal performance
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill Down
and Drill Through functionality and Graphical representation for effective analysis
• Created Tabular reports, Matrix reports, List reports, and Sub reports using SSRS
• Used complex expressions to Calculate, Group, Filter, Parameterize and Format the contents of
the report according to the business requirements
• Used Conditional Formatting to change the behavior of the report depending on the requirements
• Worked on Custom Development in reporting services using Custom code, Functions, Class
libraries, Data processing extensions and generating RDL
• Scheduled report delivery in formats like PDF, Excel, CSV, Microsoft Word and text files by
creating subscriptions on the report server to business users as a mail attachment
• Generated Reports that can handle dynamic grouping and dynamic sorting for the purpose of
efficient and clear viewing the reports
• Involved in SSRS Reports deployment to report server and maintenance
• Migrated and Converted over 200 Crystal Reports to SQL Server Reporting Services (SSRS)
• Involved in the code review sessions and reviewed cubes, changed the cubes and documentation according to
the requirement based on evaluation and revenue opportunities using SSAS
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis
Services (SSAS)
• Extensively involved in the SSAS storage methods (MOLAP, HOLAP, and ROLAP), partitions,
aggregations, calculation of queries, data mining models, developing reports using MDX and
SQL
Environment:
MS SQL Server 2000/2005, SSRS, SSIS, Oracle 9i and 10g, Business Intelligence Development studio,
T-SQL, Crystal Reports, Visual source safe, Visual studio 2005, Erwin, Java, J2EE, C#, ASP.NET,
VB.NET, MS Excel, MS Access
Lincoln Financial Group, Omaha, NE July 2009 – Dec 2011
SQL Developer
Lincoln Financial Group is a holding company whose subsidiaries offer investment products and
life and specialty insurance. The company relies on data management software for mission-critical
systems such as policy underwriting, claims processing, and commission payments to its agents.
Protective Life also uses a business-critical data warehousing and business intelligence solution based on
SQL Server 2008 R2 and Microsoft SharePoint Server 2010. The solution extracts data from about 30
disparate systems at the company’s subsidiaries.
Roles and Responsibilities:
• Participated in designing, coding, testing and implementing user interfaces, procedures and
functions for new and existing software application requirements
• Responsible in writing the stored procedures, triggers and functions based on the business
requirement
• Integrated Crystal Reports with SQL Server 2000 and Access databases
• Responsible for creating datasets using T-SQL queries and Stored Procedures
• Fine tuning the stored procedures and SQL queries for optimal performance by viewing execution
plans, database tuning advisor and 3rd party tools
• Involved in database normalization and de-normalization for creating Data ware house
• Used SQL server agent for scheduling jobs and alerts
• Developed DTS packages to extract and transform data
• Created DTS package to get data from different data sources, consolidate and merge into one single
source
• Used performance monitor and SQL Profiler to optimize queries and enhance the performance of
database servers
• Responsible for creating and implementing logins and user permission to databases
• Created technical design document for the project
• Imported and exported flat files using Bulk Copy Program (BCP) extensively to/from SQL Server
• Had a chance to implement different types of Replication Models like Transaction, Snapshot and
Merge
Environment:
MS SQL Server 2000, T-SQL, DTS, ASP.NET, Access 2000 & Windows 2K platform, MS Excel, Crystal
Reports
Volkswagen of America, Houston, TX Jan 2008 – Jun 2009
SQL Server Developer
Volkswagen Group Of America, Inc in Houston, TX is a private Automobile-Buyer company.
Company receives car from Germany via Ship to Port of Houston and then ships to the US dealers by
Trucks and Trains. IT is involved in all the operations, Inventory tracking, cars shipping and maintenance
till the cars receives to the dealer everything is based on work orders. The applications track billing
statements, produces various reports, monthly processing and renewals, accepts new carriers and plans,
financial specs, and handles database system security and data integrity pertaining.
Roles and Responsibilities:
• Installation of SQL Server on Windows 2000 Advance Server
• Involved in entire life cycle including database design, development, testing, optimizing and
deploying on development and production servers
• Responsible for creating the Tables, Views, Stored Procedures, Cursors, Triggers
• Participated in creating Indexes to improve the performance of database
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
queries
• Created Constraints and Views
• Generated reports using Crystal Reports
• Used Data Transformation Services(DTS) to export and import data
• Assisted in taking database backup and restored them and also resolved issues related to it
• Used SQL server profilers to trouble shoot the issues and checked the activity of the SQL server
• Involved in creating users and assigning permissions to access the database
• Experience in documenting the codes for easy understanding in future
Environment:
MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer,
Crystal Reports
Contact this candidate