PROFESSIONAL SUMMARY

• 7 + years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008(R2)/2005/2000 in Development, Test and Production Environments with various business domains like Financial, Healthcare and manufacturing.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance
• Experience in Performance Tuning and Query Optimization.
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation
• Good knowledge of System Development Life Cycle (SDLC).
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart,Adhoc and Sub Reports.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSIS Packages from development server to production serverby using package configurations
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Used MDX to interact with the back end OLAP Services
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Well aware of SDLC procedures, Change control rules, problem management and escalation procedures.
• Experience in using profilers, IndexTuning Wizard and performance monitor to monitor SQL Server.
• Good in implementing SQL Server Security and Process Control.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS:

Languages: C,SQL,T-SQL
RDBMS: MS SQL Server 2008/2008 R2, 2005, 2000, 7.0, MS-Access
Web Technologies: HTML ,XML
Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage.
SQL Server Tools: Enterprise Manager,SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS
Data Modeling Tool: ERWIN, Visio
Operating System: Windows 95/98/2000/XP/NT,MS Dos and UNIX
Tools: Microsoft Visual Studio 2008, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA JAN ’11 – Till date
SQL BI Developer

Description:
Confidential, was primarily engaged in property and casualty insurance, with Health insurance representing a small proportion of their total business. It belongs to a family of companies under mutual risk management (MRM), a Bermuda based company. It was placed into liquidation in July 2003.

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting,dashboards, and scorecards.
• Involved in the dimensional modeling of Data warehouse using Erwin tool
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Createdappropriate Triggers to assist efficient data manipulation and data consistency
• Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Created dynamic Package Configuration of type Sql Server table.
• Developed Query for generating Drill Down and Drill Through Reports in SSRS 2008(R2)
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Deployed SSRS reports to Share Point Sever 2010 and also configured SSRS 2008 to Share Point Integration mode.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Involved in OptimizationandPerformanceof queries and stored procedures using Sql Execution Plan

Environment: Erwin,SQL Server 2008R(2), MS Server Integration services, SSRS (MS server Reporting Services), MS SSAS,Window 2007 Server, Crystal Reports, Share Point Server 2010,VB.net.

Confidential, Alexandria, VA NOV’8-DEC ‘10
SQL SSIS/SSRS Developer

Description:
Confidential, is the largest health benefits company in terms of commercial membership in the United States. This company delivers a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts.

Responsibilities:

• Worked closely with Business Analysts and data modelers in design of logical and physical design.
• Written T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Used Try catch block, Merge and Common table expressions in T-sql
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Created different type of reports including Cross-tab, Conditional, and Drill-down, OLAP and Sub reports.
• Have deployed packages on different servers by using Package configurations.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Worked with development teams in the design of physical databases and in modification.
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.

Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2008 and 2008(R2), SSIS, SSAS, SSRS, OLAP.

Confidential, Woonsocket, RI OCT’07– NOV‘08
SQL Server SSIS/ SSAS Developer

Description:
Confidential, is the largest pharmacy chain in the United States .As the retail pharmacy division of CVS Caremark, it sells prescription drugs and a wide assortment of general merchandise, including over-the-counter drugs, beauty products and cosmetics, film and photo finishing services, seasonal merchandise, greeting cards and convenience foods through their CVS Pharmacy and Longs Drugs retail stores and online through CVS.com

Responsibilities:

• Participated in gathering User Requirements and System Specifications for dimensioning modeling of data warehouse.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Improved the performance of the slow running queries.
• Created partitions to improve the performance of data retrieval.
• Created Cubes using SSAS that are used by business users
• Defined KPI’s, Actions and Calculations in SSAS using MDX
• Improved the performance of Cubes by creating partitions and defining proper attribute-relationships and hierarchies.
• Deployed SSAS cubes and managed the security.
• Created SSIS packages to process cubes on scheduled basis.
• Created and executed SQL Server IntegrationService packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Used Checkpoints to implement the restart ability of the packages in SSIS.
• Implemented Custom loggingin SSIS using event handlers and execute sql task.
• Deployed SSIS packages to file system, sql server and automated the packages.
• Created SSIS Packages to load data from Oracle Database with various transformations in Sql Server database.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Experience in creating snapshots of static reports and configure subscription.

Environment:
Windows 2000/2003 Advanced Server, MS SQL Server 2005, SQL Server Management Studio (SSMS), T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent

Confidential, Wilmington DEJUN’07-OCT’07
SQL SSAS/SSRS DEVELOPER

Description:
Confidential, an non-profit organization, is one of the biggest companies in Education Loan industry. The company is No. 1 originator in one of the Federal Education Loans, Graduate PLUS Loan. The projects participate are CompaignManagement, MarketMeasure, and Student Loan Service System (SLSS) etc. My responsibilities mainly focusd on designing SSIS Packages, generating reports by using SSRS, and creating cube by using SSAS, and also providing technical training as well

Responsibilities:

• Create and maintain the databases using SQL Server.
• Installing and Configuring SQL Server on the server and client machines provide connections and manage databases.
• Experience in MOLAP (Multidimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Involved in performance tuning (DB Tuning) and monitoring of T-SQL blocks.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005.
• DB Tuning And optimizing SQL Server by using performance monitor.
• Create packages, procedures, functions and triggers. Handle database performance and DB tuning.
• Created SSIS process design architecting the flow of data from various sources to target
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.

Environment: SQL Server 2000/2005, VBScript, ASP, .Net, Excel, MS Access, Visual Basic 6.0, and Windows 2000/NT 4.0

Confidential, Hyderabad, IndiaMAY’ 04 – MAR’ 07
SQL Server Develope

Description:
Confidential, prides itself as a young and vibrant organization and recognizes its employees as its greatest assets. Consequently, the employee satisfaction level in the Bank is, possibly, amongst the highest in the industry, and does not stem from the compensation package alone. Comprising of people drawn from different specialization and divergent backgrounds, the employees merge into a highly homogeneous working group, catalyzed by the informal and transparent HRD policies pursued by the Bank. In addition to an attractive compensation structure, we also offer leased housing facilities, medical and health insurance and loan option

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept
• Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• DevelopedUser Defined Functionsand createdViews
• CreatedTriggersto maintained the Referential Integrity
• 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 IndexesandTables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment:SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5,ASP/VB.NET