Sql Server Data

Microsoft SQL server BI Developer

Srikanth

Sr MS SQL Server BI Developer / DBA

E-Mail : ********.****@*****.*** Mobile : 469-***-****

1

PROFESSIONAL SUMMARY:

2

• 8+ years of experience in IT industry as a Microsoft SQL Server BI Developer and specializing in

database design, development & administration work with Microsoft SQL Server

2012/2008R2/2008/2005 for OLTP, OLAP,large-scale data warehouse applications.

• Over 6+ Years of experience in data warehouse development with Integration Services (SSIS),

Reporting services (SSRS) and Analysis services (SSAS).

• Extensive experience with different phases of software development life cycle (Analysis, Design,

Implementation, Testing, and debugging new and existing client-server based applications).

• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views,

Cursors, Joins and Sub queries with T-SQL.

• Strong knowledge in database design features including ER Diagrams, normalization, tables,

views, indexes, constraints, keys, data dictionaries, and data integrity.

• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes,

triggers when required and complex queries including correlated queries and queries with complex

joins and aggregate functions.

• Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and

planning.

• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading,

backup & recovery, Database mirroring, Log shipping, user and application table management,

upgrades, creating database partitioning, databases/file groups/files/transaction logs.

• Experience in query optimization (SQL tuning) using SQL Profiler, Database Tuning Advisor

(DTA), Index tuning wizard and Performance monitor for performance tuning.

• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load

(ETL)solutions for data warehousing using SQL Server Integration Service (SSIS)

• Developed ETL process using SSIS with various control flow, data flow tasks and store procedures

for work order validation process.

• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in

SSIS packages by using Row Transformations, Block and Unblock Transformations.

• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.

• Creating SSIS Packages and involved in Package configurations and deployments between

Development and QA and Production servers.

• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both

relational databases and OLAP cubes.

Microsoft SQL server BI Developer

• Expert in designing and generating reports using SQL Server Reporting Services (SSRS) and Excel

Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list,

matrix, dynamic reports and other features of reporting service.

• Good understanding of Microsoft Reporting Service(SSRS) with Report authoring, Report

management, Report delivery and Report security.

• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix

Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting

Services (SSRS) in Business intelligence development studio (BIDS).

• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports,

Snapshot, Cached, Adhoc reports using SSRS.

• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using

SQL Server Analysis Services (SSAS) 2005/2008.

• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL

Server 2005/2008 Analysis Services.

• Experience in Cube designing in Business Intelligence Development Studio using SSAS.

• Strong experience in defining Referenced relationships in SSAS.

• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing,

Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server

Applications.

• Ability to manage multiple tasks and responsibilities in high-pressure environments.

• Track record of taking projects to successful completion.

• Excellent analytical, problem solving skills and a team worker with a strong customer focus.

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes

but is not limited to ensuring successful backups, resolving system issues, opening cases with

technical support to resolve issues, monitoring success and failure of automated jobs, monitor system

availability, updating system documentation, system and database recovery, etc.

• Coordinating with the Systems Administration team, install and maintain Boardwalk approved

application software and systems that integrate with Boardwalk's database systems.

• Updating database systems by reviewing, planning, testing and installing database security patches

and service packs.

• Design, document, and promote security "best practices", policies, standards and protocols.

• Migrating application code and objects from development/test environments to production.

• Working with development and systems teams to perform application and database tuning.

• In conjunction with development teams, define and maintain database and code standards and naming

conventions for the organization to ensure consistency in database and code development.

• Migrating Databases from SQL Server 2005 to SQL Server 2008.

• Setup and maintenance of appropriate database and application monitoring.

• Setup, test and maintain business continuity/disaster recovery infrastructure database and

applications.

• Providing highly available database and application infrastructure according to Business

Continuity requirements using SQL clustering, load-balancing, etc.

• Evaluating data modeling, database administration, and database backup and recovery tools

and make recommendations.

Microsoft SQL server BI Developer

• Setting up and Monitored transactional replication, Database mirroring on Production and

QA servers.

• Responsible to Monitor and troubleshooting Log Shipping.

• Review of physical and logical database design; Promote the reliability of database design by

ensuring appropriate referential data integrity is implemented and appropriate data types are

used.

• Create processes and procedures for application code and database object migrations to

support an efficient and reliable system development lifecycle.

TECHNICAL SKILLS:

3

SQL Server/BI Tools SQL Server Integrating Services (SSIS), SQL Server Reporting Services

(SSRS), SQL Server Analysis Services (SSAS), SQL Azure, SQL

Profiler, Query Analyzer, SSDT, Export & Import (DTS)

Databases MS SQL Server 2012/2008R2/2008/2005, MS Access, My SQL

Programming Languages C#, T-SQL, HTML, JSP, Java Script, Asp.Net and VB.Net.

Tools Visual Studio 2012/2010/2005, Erwin 7.2

Application Packages MS Office, MOSS 2007, PPS 2007

Operating Systems Windows 2000/NT/XP, UNIX, Windows Server 2012/2003

Architecture RDBMS, OLAP, OLTP

Data Modeling Tools Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

EDUCATION & CERTIFICATIONS:

4

• Bachelor of Technology (Information Technology) - GITAM UNIVERSITY, INDIA

• Microsoft Certified IT Professional (70-480) –HTML5 with JavaScript and CSS3

PROFESSIONAL EXPERIENCE & DEVELOPMENT:

HomeAway - Austin, Texas

Sr.SQL/BI Developer December 2013 – Present

HomeAway, Inc. is a vacation rental marketplace with more than 1,000,000 vacation rental listings in 190

countries. The project involved developing and testing SSIS Packages to deal with high volume

processing output loading data from different systems into master data warehouse and providing data to

various teams. Also worked on creating Reports using Microsoft SQL Server environment for loss

prevention and auditing team’s for fraud prevention and balancing sales.

Responsibilities:

Microsoft SQL server BI Developer

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse

database from heterogeneous sources.

• Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.

• Developed and maintained critical applications for sales auditing team by balancing sales and

settlements of credit amounts with the bank on a day to day basis.

• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS

packages and SQL scripts and SSRS reports.

• Created packages with different control flow options and data flow transformations such as

Conditional Split, Multicast, Union all and Derived Column etc.

• Created SSIS packages for File Transfer from one location to the other using FTP task with Master

SSIS Package to run all other packages.

• Implemented database standards and naming convention for the database objects and documentation

of all the processes involved in maintaining the database for future reference.

• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server

databases.

• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures,

cube and established data granularity.

• Worked on multidimensional data modeling.

• Participated in Databases Architecture and data modeling design.

• Reviewed and developed data models and database designs with development teams

• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and

SQL joins for applications.

• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine

Tuning Advisor (DTA) and Performance monitoring.

• Developed various types of reports like Drill down, Drill through and parameterized reports using

SQL Server Reporting Services 2008 R2.

• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-

SQL.

• Worked on Change Management Cases to resolve the production change request issues based on the

Specifications provided.

• Worked on call support to resolve issues whenever needed.

• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: SQL Server 2012 & 2008R2 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,&

Windows 2003 server, Business Intelligent technologies like SSAS,SSIS,SSRS.

Microsoft Club - Redmond, Washington

Sr.SQL/BI Developer January 2012 - November 2013

Microsoft Club is designed to recognize the support of resellers who specialize in selling Open Licenses

on eligible Microsoft products, distributing legal Microsoft products directly to small and medium

businesses and provide both Cash Rebate and Coop Marketing Funds when partners meet the MS Club

eligibility requirements and objectives.

Responsibilities:

Microsoft SQL server BI Developer

• Created databases and schema objects including tables, indexes and applied constraints, connected

various applications to the database and written functions, stored procedures and triggers.

• Successfully migrated the database from SQL Server2008R2 to SQL Server 2012

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL

Server 2008 using SSIS, BCP and Bulk Insert.

• Used Query Analyzer to optimize SQL Queries.

• Generated reports from the cubes by connecting to Analysis server from SSRS.

• Created Dimensions with the cube wizard and also individually.

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

• Designed and created Report templates, bar graphs and pie charts based on the financial data

• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008

Reporting Services.

• Created the automated processes for the activities such as database backup processes and SSIS

Packages run sequentially using SQL Server Agent job.

• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008

Analysis Services (SSAS) and Reporting service (SSRS).

• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to

MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data

to the database.

• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.

• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help

of SSIS.

• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance

Monitor for Monitoring and Tuning MS SQL Server Performance.

• Deployed SSIS Package into Production and used Package configuration to export various package

properties to make package environment independent.

• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report

Design.

• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for

the report.

• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data

Warehousing, and OLTP, OLAP Database projects.

• Created hybrid cloud application using Microsoft Azure (SaaS,PaaS)

Environment: SQL Server 2012,2008R2 Enterprise Edition, SSAS,MDX,OLAP, SSIS, T-SQL, SSRS,

Windows Server 2012, Performance Point Server 2007, MS Access, Visual Studio 2010, .Net4.0

The Hartford Financial Services Group, Inc – Hartford, CT

SQL/BI Consultant October 2011 – January 2012

Microsoft SQL server BI Developer

The Hartford is the 12th-largest property & casualty company in the United States, The Hartford sells its

products primarily through a network of agents and brokers, and has been the direct auto and home

insurance writer for members of AARP (formerly the American Association of Retired Persons) for more

than 25 years.

Responsibilities:

• Developed SSIS Packages to extract data from various data sources such as MS Access, Excel and

flat files into SQL server 2008 using different transformations, Derived column, Sort, Row count.

• Developed, deployed and monitored SSIS Packages.

• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

• Made SSIS packages parameterized using Configuration files.

• Experience with SSIS performance tuning using counters, error handling, event handling, re-running

of failed SSIS packages using checkpoints.

• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and

validated.

• Used efficient task objects/connections/work flows in packages based on data volumes and data

sources.

• Studied the existing OLTP system(s) and Created facts, dimensions and Star Schema

representation for the data mart.

• Responsible for identifying and defining Data Source and Data Source views.

• Created cubes and defined the dimensions.

• Optimized cubes for better query performance.

• Created and integrated User defined functions and stored procedures for reporting purposes.

• Generated reports that can handle dynamic grouping and dynamic sorting.

• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve

the report generation time.

• Defined relationships between Dimensions and Measure groups.

• Expert in calculating measures and dimension members using mathematical formulas, and user-

defined functions.

• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL.

Promoted RDLs to Reporting Service Server.

• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly

Reports including current status.

• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data

sources.

Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Analysis Services 2008,MS SQL

Reporting Services 2008, MS Access, MS SQL SSIS/SSRS 2008, Windows XP Professional, Relational

DBMS, data warehousing, Insurance Systems.

PNI - Harrisburg, PA

SQL BI DEVELOPER August 2010 – September

2011

Microsoft SQL server BI Developer

Penn National Insurance sells property-casualty insurance like business insurance, personal auto, home,

and owners etc. and surety bonds through independent agents in nine states.

Responsibilities:

• Created/Updated database objects like tables, views, stored procedures, function, packages,

• Created views to facilitate easy user interface implementation, and triggers on them to facilitate

consistent data entry into the database.

• Developed tablix reports, chart reports, line reports, parameterized reports, sub reports using SQL

Server Reporting Services 2008.

• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes

and SQL Server in Excel 2007.

• Integration of SSRS Reports using various web parts into SharePoint and various delivery

mechanisms.

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from

the database.

• Deployed SSRS reports onto Microsoft Office SharePoint Server2007(MOSS).

• Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server

2008/2008R2.

• Involved in providing ETL support for the production server.

• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.

• Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.

• Querying and manipulating multidimensional cube data through MDX Scripting (SSAS).

• Enhanced the functionality of OLAP cube by creating actions and perspectives from huge dataset

using SQL Server 2008 Analysis Services.

• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum

performance of T-SQL and MDX queries.

• Created logical and physical database design, data structures and maintained it by writing stored

procedures, user defined functions, views, T-SQL script.

• Optimize the database by creating various clustered, non-clustered indexes and indexed views.

Environment: SQL Server 2008 Enterprise Edition, BIDS, SSAS, SSIS, SSRS, T-SQL, MOSS 2007,

MDX, ETL, VB.Net, ASP.Net, C#, Oracle 9i, Performance Point Server 2007, Erwin 7.2.

VHA INC. - Irving, TX

Sr. SQL/ETL Developer October 2009– July 2010

VHA, the industry’s leading supply contracting company, delivers unmatched savings to nearly 25,000

Novation. And the University Health System Consortium (UHC) member organizations and 5,500

Provista members covering 28,000 sites.

Microsoft SQL server BI Developer

Responsibilities:

• Formulated and documented the physical ETL process design based on business requirements and

system specifications with strong ETL design skills, including source to target mappings,

transformations, lookups, aggregations, expressions.

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and

functions; implement best practices to maintain optimal performance.

• ETL through SSIS and responsible for loading Data to DB from different input sources.

• Built SSIS packages with EXCEL and FLAT file source with validations to capture any kind of

errors in the source.

• Migrated data from Oracle source to SQL server tables using SSIS.

• Deployed SSIS packages for various environments.

• Created packages in SSIS with error handling as well as created complex SSIS packages using

various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column

conversion, fuzzy grouping, and script components for de-duplication of data.

• Designed, created and distribute reports in multiple formats such as Excel, CSV using SQL Server

2008 Reporting Services.

• Schedule Jobs to run SSIS package using UC4 scheduler.

• I have created dynamic connection script using C# to dynamically set connection strings and make

the packages more portable.

• I have used script tasks and script components using C# that allow custom logic in control flows.

• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.

• Generated server side T-SQL scripts for data manipulation and validation and created various

snapshots and materialized views for remote instances.

• Modified existing databases by adding/removing tables there by altering referential integrity, primary

key constraints and relationships according to requirements

• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on

stored procedures and Scripts.

• Fixes Production issues and monitoring the whole job process to deliver committed work.

• Wrote documentation for the packages and scripts and job created for migrate data.

• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.

Environment: SQL Server 2008, Windows 7, T-SQL, SSIS, SSRS, ASP.Net

Molina Health Care - Long Beach, CA

MS SQL Server / SSIS/SSAS/SSRS Developer April 2008 – September 2009

Molina Healthcare has been a leader in providing quality healthcare to those who depend on government

assistance. It serves as a health plan providing a wide range of quality health care services to families and

individuals who qualify for government-sponsored programs, including Medicaid and the State Children's

Health Insurance Program (SCHIP).

Responsibilities:

Microsoft SQL server BI Developer

• Scheduled the packages to run automatically for incremental data and deploy them to their destination

servers

• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server

Management Studio.

• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing

dimensions, hierarchies and adding aggregations to the cube.

• Deployed SSIS package into production environment and used package configuration to export

various package properties to make package environment independent.

• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP

environment.

• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning

Wizard.

• Developed Report Models using report builder and distributed reports in multiple formats using SQL

Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

• Improved data load performance by analyzing database design and query plans.

• Performed changes in the schema of the proposed database as required and informed those changes to

the application development team.

• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data

is loaded into staging area.

• Documented different stages of data transformation, procedures and scripts.

• Optimized the query performance with modification in T-SQL queries, removing unnecessary

columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful

clustered index and non-clustered indexes.

Environment: SQL Server 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning

Wizard, Data Transformation Services (DTS), Crystal Reports 8.0, XML, ASP.Net, VB Script.

Axis Bank - Hyderabad, India

Jr. SQL Server Developer Aug 2006 - March 2008

This project was for the Automobile Finance division of a leading bank. The department in the company

provides customers with loan solutions to pay for and manage the cost of automobile. Customer-centric

data base was built to analyze transactions across finance, marketing, risk, collections, and consumer

relations were developed.

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Involved in

Design, Development and testing of the system

• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)

• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate

consistent data entry into the database.

Microsoft SQL server BI Developer

• Implemented Exceptional Handling

• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports

• Creating and automating the regular Jobs.

• Tuned and Optimized SQL Queries using Execution Plan and Profiler

• Rebuilding Indexes and Tables as part of Performance Tuning Exercise

• Involved in performing database Backup and Recovery

• Worked on Documentation using MS word

Environment: SQL Server 2005, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5,

ASP/VB.NET

Contact this candidate