SQL/Ssrs/SSIS/Ssas/T-SQL/ETL Developer

Obj***

MANJARI

Email: ********.***@*****.***

EMP: *****.********@*****.***, 609-***-****

Professional Summary:

• 7+ years of experience in Data Modeling, Database Design, Programming, Development and

Implementation of Client-Server Applications & Database systems using SQL Server

2000/2005/2008/2008R2/2012.

• Hands on experience in creating indexed Views, complex Stored Procedures, effective

functions, and appropriate Triggers to assist efficient data manipulation and data consistency.

• Efficient in creating joins and sub-queries for complex queries involving multiple tables.

• Well versed in Normalization/Demoralization techniques for optimum performance in

relational and dimensional database environments.

• T-SQL Programming using DDL, DML commands for various business applications.

• Developing the reports using Multi-dimensional expressions (MDX)

• Expertise in solving Dead Locks/Long running queries using Performance Monitor and

SQL Profiler.

• Experience in collecting the user requirements and documenting by creating the use case and flow activity

diagrams.

• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support

Services and MDX technology of the analysis services.

• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.

• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other

heterogeneous relational databases. Hands on experience with performing various SSIS data transformation tasks

like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.

Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server

Analysis Services (SSAS), Stored Procedure, Functions, Views, Joins and Cursors.

• Supported team in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in

creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP

and Sub reports, and formatting them.

• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, and

Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.

• Experienced in deploying created reports in various sources like Web browser, XML and PDF

• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding

of SSAS, OLAP cube and Architecture.

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS

SQL Server by using BCP utility, DTS and SSIS services

• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event

Handlers, Loggings, Checkpoints, Transactions and package configurations

• Created many complex SSIS packages with complicated transformations like Lookup, Derived

Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split etc.

• Great Expertise in Creating and managing event handlers, Package Configurations, Logging, Check

points, Package Securities and User Defined Variables for SSIS Packages.

• Developed materialized views for data replication in distributed environments.

• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for

OLTP and dimension modeling for OLAP.

• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.

• Excellent experience in designing and developing Reporting System using Business Objects. Experience

with Finance, Banking & Accounting Clients.

• Excellent verbal and written communication skills combined with interpersonal and conflict resolution

skills and possesses strong analytical skills.

• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating

DTS/SSIS Packages.

• Worked with improving the performance on SQL, TSQL and SSRS procedures and

provided the recommendation on server related tuning issues.

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS

SQL Server by using BCP utility, DTS and SSIS services.

• Experience in creating SSIS packages with Error Handling.

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

server.

• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).

• Experience in deploying created reports in various sources like Web browser, XML and PDF.

• Efficient in upgrades and migration from MS SQL Server 2000/2005 to MS SQL Server 2012/2008.

• Good Exposure with Microsoft Office System – MS Word, MS EXCEL, MS PowerPoint, MS Access,

MS office Tools.

Technical Skills:

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

Programming T-SQL, MS SQL, MDX, C/C++, Java, VB, VBA, HTML, XML

Languages

BI and ETL tools Microsoft SQL SERVER 2012/2008/2008/2005/2000 Business Intelligent

Development Studio (BIDS), SQL server Data tools, Microsoft SQL SERVER

2005/2008/2012 Integration Services Toolkit (SSIS), Microsoft SQL SERVER

2005/2008/2012 Analysis Services (SSAS), Pervasive Data Integrator, Adept

SQL diff, Oracle SQL developer, Microsoft Visual Studio2010/2012

Reporting Tools Microsoft SQL SERVER 2005/2008/2012 Reporting Services (SSRS), Report

Builder 2.0, Report Builder 3.0, Crystal reports 10

Relational Databases SQL SEVER 2012/2008R2/2008/2005/2000

Office and Other Microsoft WORD 2007/2010, Microsoft EXCEL 2007/2010, Microsoft POWER

Tools POINT 2007/2010, Microsoft Visio

Professional Experience:

CHI - Catholic Health Initiatives, Englewood, CO Sept'14 – Present

MS SQL/BI Developer

CHI is a nonprofit, faith-based health system formed in 1996 through the consolidation of four Catholic health

systems, expresses its mission each day by creating and nurturing healthy communities in the hundreds of sites

across the nation where it provides care. One of the nation’s largest health systems, Englewood, Colo.-based

CHI operates in 19 states and comprises 105 hospitals, including four academic health centers and major

teaching hospitals.

Responsibilities:

• Developed complex programs in SQL, writing Stored Procedures, Views, Triggers and Queries with

best execution plan in SSMS.

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse

databases and data mart databases.

• 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.

• Uploaded reports on to the report manager and organized them into folders.

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

cursors and used SQL Profiler to improve performance.

• Developed Query for generating drill down, drill through and parameterized reports in SSRS 05/08.

• 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.

• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

• Experience in developing the Drill down, Drill through, Parameterized reports using SSRS

• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis

Services (SSAS) for analyzing purpose.

• Developed physical data models, data warehouse models and created DDL scripts to create database

schema and database objects.

• Extensively worked on stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas,

permissions and performance issues with client/server database design.

• Experience in collecting the user requirements and documenting by creating the use case and flow

activity diagrams.

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse

databases and data mart databases.

• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.

• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching

between SQL and PL/SQL engines.

• Involved in the Data modeling, Physical Design of Database using tools like Erwin.

• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like

CHECKDB before backing up the databases.

• Performing Replication (snapshot and transactional)

• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset

using SQL Server 2005 Analysis Services.

• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies

based on the OLAP reporting needs.

• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively

monitoring the performance of SQL Server databases.

• Configured replication servers and transactional replication between production & standby server for

disaster recovery.

• Created calculated measures and dimension members using multi-dimensional expression ( MDX).

• Created Tables, Stored procedures, defined functions, Data Mapping. Created SQL scripts for tuning

and scheduling.

• Experience using REDGATE to compare and synchronize all database objects.

• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and

maintaining security up to date.

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

Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index

Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS

Access, Visual Team Foundation Server, Crystal Reports, TOAD, visual studio 2008,visual studio 2012 .

Capital One. Plano TX Nov '13 – Sept '14

MS BI Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries

with best execution plan in SSMS.

• Designed and developed SSIS Packages to extract data from various data sources such as Access database,

Excel spreadsheet, and flat files into SQL server 2005/2008/2012 for further Data Analysis and Reporting by

using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert,

merge and union all.

• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package

according to the advanced feature of SQL Server Integration Services.

• Developed Query for generating drill down and drill through reports in SSRS 05/08.

• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2000/2005/2008/2012.

• Experience in developing the Drill down, Drill through, Parameterized reports using

SSRS.

• Experience in creating stored procedures, triggers, Views, cursors, CTE’s, T-SQL

scripts, schemas, permissions and performance issues with client/server database design.

• Defined Check constraints, Business Rules, Indexes, and Views.

• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.

• Worked with Exception handling with @@error and with Try/catch.

• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for

maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.

• Experience in creating and managing stored procedures, indexes, views, UDF’s, Database

Constrains, to meet business requirements and policies.

• Developed dashboards using Excel Power Pivot.

• Good Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL

Server Analysis Services (SSAS).

• Uploaded reports on to the report manager and organized them into folders.

• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

Designed and implemented stylish report layouts.

• Have good hands on experience working with FTP component in SSIS and used Configuration Manager

to retrieve the passwords.

• Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared

for an update.

• Enhancing performance using optimization techniques- normalization, indexing and

Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and

processes.

• Designed and created MDX queries to retrieve data from cubes using SSIS.

• Managed the migration of SQL Server 2000 databases to SQL Server 2008.

• Provided day-to-day administration tasks like space and log management.

• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.

• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with

development resources and System Administrators.

Environment: MS SQL Server 2012/2008/2005/2000/7.0, DTS, Windows Server 2008, SSMS, BIDS,SSRS,

SSIS, SSAS,Report Builder 3.0,Report Model, Erwin, Team Foundation Server, Performance Point Server,

ProClarity, SharePoint (MOSS), FTP, MS-Visual Studio, UNIX, XML,XSLT, ADO.Net.

Purdue Pharma, Stamford, CT. Nov '11 –Oct '13

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Create User Defined Functions, Stored Procedures, and Triggers.

• Performed data conversions from Flat files into a normalized database structure.

• Developed, modified, and optimized complex stored procedures, triggers to handle complex business

rules, history data and audit analysis.

• Managed up gradation of DTS packages to SSIS packages.

• Created triggers, views, user defined functions to incorporate the flow of business and called various

stored procedures from DTS to make the flow of DTS effective.

• Experience in developing the Cubes using SQL server analysis services SSAS, with star schema and

snow flake schemas.

• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning

Wizard.

• Experience in collecting the user requirements and documenting by creating the use case and flow

activity diagrams.

• Responsible for creating constraints, Indexes, and Views.

• Optimized the performance of queries with modification in T-SQL queries, normalized tables,

established joins and created indexes wherever necessary.

• Identified and worked with Parameters for parameterized reports in SSRS.

• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the

server at acceptable levels.

• Configured Server for sending automatic mails to when a DTS process fails or succeeds.

• Transformed data from various data sources using DTS packages.

• Created Crystal Reports on daily, weekly and monthly basis for manager’s review.

• Responsible for MS SQL Server 2000 in Production, Test, Development and Replication& Cluster

Server Environments.

Environment: SQL Server 2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS

Excel, MS Access,VB.NET 3.0 and DTS.

State Farm Insurance, Bloomington, IL Jan'10-Oct'11

SQL Server Developer/SSIS/SSRS

Responsibilities

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

performance of queries.

• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.

• Developed indexed views, complex stored procedures, effective triggers, and useful functions to

facilitate efficient data manipulation and consistent data storage.

• Running DBCC consistency checks, and fixing data corruption in databases.

• Monitoring execution plans to enhance the performance of the queries.

• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.

• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as

well as current ones.

• Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables.

• Worked on very complex project of designing Decomposition Tree View of SSAS cube in ProClarity

Analytics Server and used it as a part of PPS Dashboard with multiple Roll Ups & Calculations.

• Designing, developing, implementing, and maintaining reporting frameworks.

• Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, etc)

and loaded the data into target tables by performing different kinds of transformations using SQL Server

Integration Services (SSIS).

• Successfully deployed SSIS Package into Production environment and used Package configuration to

export various package properties to make package environment independent.

• Developed Scheduled Jobs to automate the packages.

• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various

user communities.

• Involved in creation of dimensions using Star, Snow Flake schemas.

• Involved in strategic, planning and budgetary responsibilities.

• Created several MDX queries according to Business requirements.

• Wrote MDX queries and expressions for use in Front End BI Applications

• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.

• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.

Environment: Microsoft SQL Server 2008 R2, T-SQL, SSIS, SSRS, Visual Source Safe, MS Excel,

Performance Point Server 2007.

Charming Shoppes, Bensalem, PA Nov '08 – Dec '09

SQL Server Developer

Responsibilities

• Created indexes, optimized SQL queries and alter joins to improve the performance Scheduled the SSIS

packages and Jobs.

• Generated of Ad-Hoc reports as per the client requirements using Report Builder.

• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report

caching using Report Manager.

• Developed complex SQL queries involving stored procedures, cursors, triggers, table inner and outer joins,

temporary tables, table variables.

• Developed effective triggers, and useful functions to facilitate consistent data storage.

• Done Performance tuning for stored procedures and optimizing SQL Server performance using SQL

Server Profiler.

• Involved in monitoring the execution plans of the queries to pre access the resources being used by the

queries.

• Good experience in creating Master Child Packages in SSIS.

• Hands on Experience in managing various SSIS Package Configurations in the form of XML Files.

• Generated various Reports using SSRS ( SQL Server Reporting Services ).

• Developed complex stored procedures, T-SQL functions, triggers and views using SQL Server

Management Studio.

• Identified and communicate system updates to ensure accurate processing and timely collections.

• Identified denial trends and present issue and solutions to management.

Photon Interactive Pvt Ltd, Banglore, India May'07 - Nov’08

Jr.SQL Server Developer

Responsibilities:

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

• Developed T-SQL Queries, Triggers, Functions and Stored Procedures.

• Used DDL and DML for writing triggers, stored procedures, and data manipulation.

• Used SQL Analyzer and Profiler analyzing the SQL statements and procedures.

• Created Schema Objects such as tables, views, maintained referential integrity and granted roles to the

Users.

• Developed internal reports using SSRS.

• Created different Data sources and Datasets for the reports .

• Created views to restrict access to data in a table for security.

• Trained a team of junior developers.

• Created detailed technical documentation.

Environment: MS SQL 2000, Windows 2000/XP, SQL Query Analyzer and Enterprise Manager. MS Access

2000 & Windows NT platform

Education:

Bachelor of Science in Information Technology. (J.N.T.U)

Contact this candidate