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 Transformationto get the data from reference data sets.
• Scheduling the SSIS packages and Jobs.
• Specialized in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Chartsusing SQL Server Reporting Services.
• Experience inMS-SSRS, SSIS, SSAS, OLTP, OLAP,Slowly Changing Dimensions, Data Cleansing and Data 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 inTroubleshootingandPerformance 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, Plano TX

MS SQL/BI Developer

Responsibilities:

• Performed Server installation and 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, Stamford, CT

MS SQL / BI Developer

Responsibilities:

• Good knowledge of Relational Database Modeling/Loadingand Dimensional database modeling concepts.
• Worked with excel reporting and writing VBA script for automation.
• Individually designed MS SQL Server 2008 database, coded stored procedures(T-SQL).
• UtilizedT-SQLon a daily basis in creating customs view for data and business analysis.
• Worked with various XML data and worked on creatingETL packageswith loading all package in loop and loading them in SQL server.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Created a report model on SSAS cubes.
• Created package 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 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.
• Worked with creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
• Createdtemporary tables and table variableswhilecreating complex queriesin SQL Server 2005/2008.
• DefinedIndexes, Views, Constraints and Triggers toimplement business rules.
• Writing complex SQL queries using tablejoins (inner and outer), temporary tables, and table variables.
• Good experience in creating pivot tables and charts in Excel using data sources SQL Server, SSAS cubes, Access and power pivot
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• 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.
• Developed indexed views, complex stored procedures, effective triggers, and useful functionsto facilitateefficient data manipulation and consistent data storage.
• Designing, developing, implementing, and maintaining reporting frameworks..
• CreatedSQL Server Profilertraces & used withDatabase Tuning Advisor (DTA)for optimum performance of queries.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Optimized the SQLs andInformaticamappings which handled millions of records
• RestoredQA server from development periodicallyto test the queries on the QA server.
• BuiltSSRSreports from various heterogeneous sources like SQL Server, Oracle.
• Creating Parameterized Reports, Drill down, Sub-reports usingSQL Server Reporting Services 2008.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Done front end ASP.Net application bridging to the back-end Database systems.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition,ODBC, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0

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.
• WroteMDXqueries 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, Bensalem, PA

Responsibilities:

• Created indexes, optimizedSQLqueries and alter joins to improve the performance Scheduled the SSIS packages and Jobs.
• Developed, designing and deploying of various complex reports such asDrill down, Tabular reports, Parameterized, Pie chartsusingExpressions, 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 SubscriptionandReport 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).

Confidential

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.