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/2008 R2/2012 with specialized skills in SQL Server database, TSQL, SSRS, SSIS and SSAS.
• Experience of working with huge databases.
• Hands-on experience indebugging stored proceduresto optimize performance
• Assisted in restoring and updating the production database into development and QA environment for testing various stages of monitoring the queries.
• Experienced in creating front end application bridge to ASP.NET based applications
• Experience in usingvariables, expressions and functionsfor the reports.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Created user interface using Resource Layout and publish reports with Report Caster.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS),BULK INSERT, DTSImport/Export utility, andBulk Copy Program(BCP).
• Used Lookups Transformation to get the data from data sets.
• Scheduling the SSIS packagesand Jobs.
• Specialized in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Chartsusing SQL Server Reporting Services.
• Experience in MS-SSRS, SSIS, SSAS, OLTP, OLAP,Slowly Changing Dimensions, Data CleansingandData Migration.
• Good Knowledge of datawarehousing techniques and standards.
• Extensively worked onErwin Data Model Tooland good knowledge of RelationalDatabase Modeling/Loadingand Dimensional database modeling concepts.
• Analyzed, designed, created, implemented and supported various business application with Web FOCUSand worked in migration
• Experience in High Level Design ofETLPackagesfor integrating data using OLE DB connection from heterogeneoussources(Excel, CSV, Oracle, flat file,Text Format Data) by using multiple transformations.
• Expertise in designing/creating several reporting services reports that have been formatted specifically for dashboard displays, i.e. with charts, KPIS, tables, etc
• Used Performance Monitor/Profiler to solvedead locks/long running queries.
• Defined Indexes to implement business rules.
• Strong technical knowledge in Troubleshooting and Performance tuning.
• Created viewsto facilitate easy viewing implementation.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2000/ 2005/2008/2012 , MS ACCESS.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSRS, SSAS, Crystal Reports, BIRT, Plateau Report Designer.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

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

Web Technologies: HTML, DHTML, XML.

O/S: Windows 2008/2003/2000/ NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, MN

MS SQL/BI Developer

Responsibilities:

• Performed Server installationand configuration using SQL Server 2005/2008
• Written SSIS packages in 2005 and did conversion of DTS packages from
• Resolved complex issues and Error Handling inSSIS.
• Created and scheduledSSISpackages topulldata fromSQL Serverand exported to various data sources likeExcel Spreadsheets, Flat File etcand vice versa.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS).
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services(SSAS).
• Used various control flow tasks likeFTP, Bulk insert task, Transfer job tasketc and different data flow tasks.
• Experience in designing, creating, processing of cubes using SSAS.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Created complex stored procedures, Triggers and user defined functions using joins and cursors as required for SSIS packages.
• Completed left over tasks in other projects which includes sending invoice emails, modified excel files before loading them to database.
• Deployed SSIS packages and tested them on Model Office.
• Worked on SSIS script task, look up transformations and data flow tasks usingT- SQLandVisual Basic (VB)scripts.
• Worked onSSISperformance tuning using counters, error handling, event handling, re-running of failedSSISpackages using checkpoints.
• Developed cubes using Partitions, KPI's, and Perspectives, slow moving dimensions etc and created various user roles.
• Expertise in ETL techniques usingInformaticaPower Center 7.x, 8.x, Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional/Dimensional Databases
• GeneratedReport ModelsusingModel Designer,to enable the business users to build ad-hoc reports usingReport Builder.
• Involved indesigning reportsanddeliveringthem by any of the delivery methods likestandard subscriptions, data-driven subscription, URL accessetc.
• Analyze user requirements, functional and technical specifications,preparing test plans.

Environment: Windows2003 Advanced Server, ODBC, MS SQL Server 2005/2008/2012 , TSQL, Visual Studio 2008,Oracle 9i/10g, SSRS, SSIS, Erwin.

Confidential, Bloomington, IL

MS SQL/BI Developer

Responsibilities:

• CreatedSQL Server Profilertraces & used withDatabase Tuning Advisor (DTA)for optimum performance of queries.
• Createdtemporary tables and table variableswhilecreating complex queriesin SQL Server 2005/2008.
• Developedindexed views, complex stored procedures, effective triggers, and useful functionsto facilitateefficient data manipulation and consistent data storage.
• RunningDBCC consistency checks, and fixing data corruption in databases.
• Monitoringexecution plansto enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• TroubleshootingandPerformance tuningusingQuest Performance Analyzerto diagnose historic data as well as current ones.
• Writing complex SQL queries using tablejoins (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/MonitoredETL packageswith different data sources (SQL Server, Flat Files, Excel files,etc) and loaded the data into target tables by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• Successfully deployedSSISPackage into Production environment and usedPackage configurationto export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• ImplementedEvent Handlers and Error HandlinginSSISpackages and notified process results to various user communities.
• Involved increation of dimensionsusing Star, Snow Flake schemas.
• Involved in strategic, planning and budgetary responsibilities.
• Created severalMDXqueries according to Business requirements.
• Wrote MDX queries and expressions for use in Front End BI Applications
• BuiltSSRSreports from various heterogeneous sources like SQL Server, Oracle.
• Creating Parameterized Reports, Drill down, Sub-reports usingSQL Server Reporting Services 2008.

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

Confidential

Jr.SQL Server Developer

Responsibilities:

• Created indexes, optimized SQL queries and alter joins to improve the performance Scheduled the SSIS packages and Jobs.
• Developed, designing and deploying of various complex reports such as Drill down, Tabular reports, Parameterized, Pie chartsusing Expressions, Global variables and Functions in MS Reporting Services.
• Generated ofAd-Hocreports as per the client requirements using Report Builder.
• Successfully createdSnapshots Report,Report Subscription, Data Driven Subscription andReport cachingusing Report Manager
• Developed complex SQL queries involving stored procedures, cursors, triggers,table inner and outer joins, temporary tables, table variables.
• Developed effectivetriggers, and useful functionsto facilitateconsistent 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 creatingMaster ChildPackages in SSIS.
• Hands on Experience in managing variousSSIS Package Configurationsin the form ofXMLFiles.
• Generated various Reports usingSSRS( SQL Server Reporting Services ).
• Developed complex stored procedures,T-SQLfunctions, 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.

Environment: T-SQL, MS SQL Server Management Studio 2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).