Sql Server Data

Leelaram

Sr. SQL Server Developer

*******@*****.*** 331-***-****

Professional Summary:

• Over 8 years of professional experience on Design, Development and Maintenance of Database using tools of MS

SQL Server as a Developer.

• Managed and executed all phases of a Data warehouse project life cycle during the tenure that includes Scoping

Study, Requirements Gathering, Architecting, Design, Development, Implementation, Quality Assurance,

Application Support for end-to-end IT solution offerings in Datawarehousing, OLAP & BI space

• Proficient in SQL Server suite of products includes SSRS, SSIS, SSAS.

• Experience in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

• Experience in designing Relational Database Model and implementing as per business requirement.

• Expert in working with SSIS for creating packages to transform data from different sources to different destination

and worked on Data Integrity and DTS Export and Import.

• Experience in design and development of reports using Crystal Reports 9.0/8.0 and SQL Server Reporting

Services (SSRS).

• Experience in designing reports for the end user using SQL Server Reporting Services (SSRS) and creating

multiple reports in Drill mode using Tables, Financial tables, Cross tabs, Matrix type reports and Charts using

SSRS.

• Good knowledge of defining and deploying Cubes using MS SQL Server 2005/2008 Analysis Services (SSAS).

• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes

and dimensions.

• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

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

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

• Involved on administration tasks such as Data Loading, Batch Jobs, Data Unloading, Backup and Recovery,

Upgrades, Creating Databases, Files, File groups and Transaction logs

Education:

Bachelor of Technology in Computer Science Engineering from JNTU, INDIA.

Technical Skills

Programming Languages C, C++, C#.NET, FORTRAN, SQL, TSQL, PL/SQL

RDBMS MS-SQL Server, Oracle, Microsoft Access, DB2

IDE Tools Visual Studio.Net

ETL Tools SQL Server Integration Services (SSIS), DTS,Ab Initio

OLAP Tools SQL Server Analysis Services (SSAS)

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

Database Tools SQL Server Management Studio(SSMS), SQL Server Business Intelligence

Studio(BIDS), Enterprise Manager, SQL Profiler, Query Analyzer

Operating Systems Windows 98, Windows 2000 Advanced Server/Professional, Windows Server

2003, Windows NT, Windows XP Professional/Standard, Windows Vista, Linux,

Unix

Professional Experience

Walgreens, Deerfield, IL Apr’12-Till Date

Sr. SQL Server Developer

EMR KPI

KPI system will be receiving immunization metrics from both the EMR and the IC+ systems, but the KPI requires

that the data from the EMR and the IC+ be consolidated when displayed on the Immunization summary screen. The

KPI system cannot process multiple files with the same Stat IDs for the same day and store as this will cause the

affected records to be overwritten. If the KPI is responsible for combining the KPI files received from the EMR and

IC+, then there may need to be changes in the naming conventions for the Stat ID to ensure that the same stat IDs are

not being sent from the EMR and IC+ to KPI..

Responsibilities:

• Developed and created the new database objects including tables, views, index, stored procedures and

functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the

existing servers.

• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data

from various data sources using DTS.

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

2008 using SSIS, BCP and Bulk Insert.

• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files

and Excel files.

• Done incremental processing into cube partions using SSIS Partion Processing Destination.

• Improved SSIS performance by using different methodoligies in SSIS like Bulk Insert, Fast Load.

• Developing and extending the cubes with around 35 dimensions, about 10 measures, and 25 calculated

members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing

cube schema.

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

sequentially using SQL Server Agent job

• Experience in executing MDX queries for cubes and performance optimization of MDX queries.

• Analyze historical trends, identifies issues and analyze root cause on PROCLARITY dash board.

• Worked on PROCLARITY to create OLAP datasets and queries are created directly from the Unified

Dimensional Model.

• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from

database tables and write the data to text files.

STARS

STARS, Strategic Tracking and Analytical Reporting System, is a reporting system that tracks pharmacy events to

determine at what point during the workflow process an event resulted. STARS application allows the ability to

identify negative performance patterns and reveals opportunity for training.

Responsibilities:

• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups

etc.

• Involved in ETL architecture enhancements to increase the performance using query optimizer.

• Implemented Event Handlers and Error Handling in SSIS packages.

• Created SSIS packages for Data Conversion using data conversion transformation.

• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.

• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).

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

• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

• Involved in scheduling,creating snapshots and subscriptions for the reports using SSRS 2008.

Environment: SQL Server 2012/2008/2005 Enterprise Edition,SQL Server Data Tools, SQL Server Business

Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and

Windows Server 2003. .

Wells Fargo, SFO, CA Jul ’11 - Mar’12

SQL BI Developer

Wells Fargo bank provides a full range of commercial & individual banking products and services. The bank primarily

engages in generating deposits and originating loans. Its deposit products include savings accounts, money market, and

time deposits.

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the

requirements of the system.

• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL,

scripts, stored procedures and views).

• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like

data filtering, adding interactivity, deploying reports to report server using SSRS.

• Created an analysis Data Mart and Multidimensional Cube in SQL Server Analysis Services.

• Analyzed and optimized Microsoft SQL Server Analysis Query performance.

• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.

• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

• Deployed the reports in to the report server.

• Involved in testing various SSIS packages from development to production.

• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be

dynamically deployed into Dev, Test and Production Environments.

• Involved in extracting the data using SSIS from OLTP to OLAP.

• Developed many SSIS packages to conduct transformations on inconsistent data.

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages

using the execution package.

Environment: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008,.NET Framework, C#, ASP.NET,CSS,T-

SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008.

Molina Healthcare Inc, Long beach, CA April’10-Jun’11

SQL BI Developer

Molina Healthcare is the most experienced managed healthcare companies in the country. It provides an affordable

healthcare to families and individuals and has been a leader in providing quality healthcare to those who depend on

government assistance.

Strategic Standardization:

The projects aims to reduce the administrative costs associated with claims adjudication and improve overall Provider

& Member satisfaction by reducing the claims payment turnaround time. Maximizing the benefits of EDI transaction

standardization, resulting in improved Provider relations

Responsibilities

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application

• Developed Physical data models and created DML scripts to create database schema and database objects

• Mercury Quality Director-Worked on the assigned tickets for both Development, Test and Production

environment .

• Developed T-SQL scripts for testing & validation of reports.

• EDI 278 Standards are maintained while migrating data for third parties for security issues.

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server

databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

• Implemented Incremental load, used Event Handlers to clean the data from different data sources

• Created dynamic Master SSIS package having Child SSIS packages

• Generated periodic reports based on the statistical analysis of the data from various time frame and division

using SQL Server Reporting Services (SSRS)

• Developed various operational Drill-through and Drill-down reports using SSRS

• Identified and added the report parameters.

• Dealt with Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary

cursors wherever possible

Environment: SQL Server 2008 Enterprise Edition,SQL Server Agent,SSIS 2008, SSRS 2008, C#,T-SQL,Windows

2000/2003 Server, XML, MS Excel, MS Access.

Active Health Management, Chantilly, VA Oct’ 08 – Mar‘10

SQL BI Developer

Active Health Management basically provides health services in many aspects. Active Health Management is a

leading provider of health management services, including disease management, clinical decision support and personal

health records. My responsibility was implementation and maintenance of databases, Application Development,

Generating reports and Analyzing data.

Responsibilities

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring,

and archived data files for different DBMS.

• Generated database monitoring and data validation reports in Proclarity and SQL Server Reporting Service

(SSRS).

• Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).

• Deployed SSIS packages and Reports to Production Servers.

• Upgraded databases from SQL Server 2000 to SQL Server 2005.

• Responsible for the design and development of .Net web applications for firm's Solutions.

• Migrated data using ETL Tool in SSIS.

• Maintained system monitoring jobs and provide high availability support.

• Created partition table for very large database for good performance.

• Worked on Migration of packages from DTS using SQL Server Integration Service(SSIS).

• Participated Databases Architecture and data modeling design.

• Performing DBA functions, installing, configuring and supporting database systems.

• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server

2005

• In charge of converting data using SQL Server 2005 using SSIS

Environment: SQL Server 2005/2008,SQL Server Integration Services(SSIS),SQL Server Reporting

Services(SSRS),C#,VBScript,ASP.NET,T-SQL,MS Excel 2003, MS SQL Query Analyzer, SQL Profiler.

Aventis, NJ Duration: Oct 06 – Oct 08

Birlasoft, Hyderabad, India

ETL Developer

Aventis is a Pharmaceutical company, which provides new and improved biotech drugs for various diseases and their

symptoms. The objective of the project is to extract data stored in different databases and load into oracle system

which is the staging area and the business logic is applied to transform the tables in the required way. The data

warehouse is fed by marketing data, sample data, market (competitor) data, prescription data and others.

Responsibilities

• Involved in Designing of the logical and physical database.

• Involved in User Requirement Gathering and Technical Specification Documentation.

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL

in Development and Production environment for SQL Server 2000.

• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user

inputs.

• Interacting with the users and troubleshooting the problems involved with the development of stored

procedures, triggers and problems related to the privileges.

• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as

Excel, Access, and flat file, XML in order to create and maintain a centralized data warehouse.

• Plan and implement data roll-up from live site to data warehouse.

• Created reports using Crystal Reports using imported data sources.

• Generated various reports using Crystal Reports.

• Resolving the bugs in the database.

• Assisted with various ad hoc query requests.

• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005/2000,DTS,T-SQL, VSS, VBScript, XHTML, XML, Windows 2000/2003

Server.

Contact this candidate