SUMMARY

• Over 8+ years of extensive experience inSQL Server Suite of products(SSRS/SSIS/SSAS) and involved in all phases ofSoftware Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Experience inMS - SSRS, SSIS, SSAS, OLTP, OLAP,Slowly Changing Dimensions, Data Cleansing andData Migration.
• Good Knowledge ofdatawarehousing techniques and standards.
• Extensively worked onErwin Data Model Tooland good knowledge of RelationalDatabase Modeling/Loadingand Dimensional database modeling concepts.
• Experience in High Level Design ofETLPackagesfor integrating data usingOLE DB connection from heterogeneoussources(Excel, CSV, Oracle, flat file,Text Format Data) by using multiple transformations.
• Created user interfaces using Resource Layout and publishes 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).
• Scheduling theSSIS packagesand Jobs.
• Specialized in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Chartsusing SQL Server Reporting Services.
• Created emailsubscriptionsfordata driven reportsby using Report Manager.
• Used C#.Net, ASP.Net for GUI design and business logic implementation.
• Extensive knowledge of Client/Server and Web based applications using Visual Basic 6.0, ASP, and ASP.Net.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Experience withAd-HocreportingusingReport Builderin SSRS for daily reports.
• Used Performance Monitor/Profiler to solvedead locks/long running queries.
• Worked on analyzing and performance tuning queries by looking atQuery Statisticsand Execution plans.
• Expertise in SQL Server 2000/2005/2008 R2 Development Skills including writing Stored Procedures, User-Defined Functions, Triggers and proficiency in Joins and Indexes.
• Experienced in managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in writing complex SQL queries involving multipletable inner and outer joins, temporary tables, table variables.
• Experience increating indexed views, complex stored procedures, effective triggers, and useful functionsto facilitateefficient data manipulation and consistent data storage.
• Excellent report creation skills usingMicrosoft Reporting Services(SSRS) with proficiency in usingReport Designeras well asReport Builder.
• Experience of working with huge databases (size>5 M rows).
• 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 both agile and waterfall methodologies
• Has experience in driving and maintain the scrums/ sprints.

TECHNICAL SKILLS

Hardware: Dell Servers, HP Servers

Database: SQL Server 2000/2005/2008 R2,MS Access, Oracle 9i, 10g, Netezza Performance Server,Aginity workbench for Netezza

Operating Systems: Windows XP/2000/2003, UNIX

Programming Languages: T-SQL,PL/SQL,HTML, C#, ASP.Net

BI Suite: SSRS, SSAS, MOSS 2007 Dashboard

ETL Tools: SSIS, DTS, Bulk Import, Import Data, Export Data

Database Tools: SSMS, Toad for SQL Server 4.6

Modeling Tools: Erwin (4x, 7x)

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SSRS/SSIS/SQL Developer

Responsibilities:

• PerformedServer installationand configuration usingSQL Server 2008R2.
• Developed reports using ETL (SSIS) and Business Objects universes and reports.
• Involved indesigning reportsanddeliveringthem by any of the delivery methods likestandard subscriptions,data-driven subscription,URL accessetc.
• Extensive knowledge of loading data from various sources likeCSV, flat files, to SQL Server database using SSIS Package.
• Created tables, synonyms, views (particularly with analytic functions), and sequences in Netezza.
• Created indexes, optimizedSQLqueries and alter joins to improve the performance Scheduled the SSIS packages and Jobs.
• Created many summary reports and rollup reports.
• Developed many Tabular Reports, Matrix Reports, and Drill down Reports using SQL Server Reporting Services (SSRS).
• Defined High Level Data Architecture for ETL & BI Solutions & Framework Design, Prototyping, ETL Loading Strategy Definition, Datastage,Data Governance & RDBMS standards definition and enforcement, Definition of Datastage Best Practices & Coding Standards
• Analyze user requirements, functional and technical specifications,preparing test plans.
• DefinedIndexes, Views, Constraints and Triggers toimplement business rules.
• Writing complex SQL queries using tablejoins (inner and outer), temporary tables, and table variables.
• Used C#.Net, ASP.Net for GUI design and business logic implementation.
• Experience trouble shooting and resolving database issues. Debugging, identifying bugs and driving them to closure by working closely with the development team.
• Performance tuning and optimization experience
• Experience in working with large data warehouses, mapping and extracting data from legacy systems, Netezza/Sql Server
• 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 configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• ImplementedEvent Handlersand Error HandlinginSSISpackages and notified process results to various user communities.
• Worked on tools, methods, and programs to build, replicate, analyze and report on multi-terabyte data warehouses of network traffic snapshots and malware tables. Used Netezza TwinFin DW appliances to search 5-to-20 terabyte tables with subsecond response times. Developed methods to statistically simulate very large malware tables. Provided Netezza consulting experience, analysis, design and implementation expertise to the malware archiving and analysis project
• Experience with back up, restore, and recovery models
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many Cascaded parameters in the reports using T-SQL.
• Analyze stored procedure-based business logic in order to document and propose solutions for migrating to the middle tier.
• Design and development of deliverables on time, and to required quality.
• Work with Project Managers, Business Analysts, and Developers in defining requirements and prototyping solutions.
• Work with the Test team in resolving data quality issues and supporting the test cycle.
• Experience designing, developing, debugging and deploying SQL Server stored procedures
• Performing and maintaining data extracts and imports
• Address issues of Data Integrity/Migration (Validation, Clean-up and Mapping)
• Troubleshoots data issues, validates result sets, recommends and implements process improvements.
• Ability to effectively translate user requests in to reporting specifications.
• Ability to utilize Visual Studio in creating and deploying SSRS reports.

Environment: SQL Server 2000/2005/2008 R2, Visual Studio 2008, SSRS, SSAS, DTS, VB.Net, Visual Studio .Net, Team Foundation Server (TFS), Netezza Performance Server, Aginity Workbench for Netezza, Query Analyzer, SQL Profiler.

Confidential, Bowie, MD

SSRS/SSIS/SQL Developer

Responsibilities:

• PerformedServer installationand configuration usingSQL Server 2008R2.
• Worked on many different formats of CMS files like 837, 835, 5010 and CMS response files like 999,277CA, MAO-002 etc.
• Involved indesigning reportsanddeliveringthem by any of the delivery methods likestandard subscriptions,data-driven subscription,URL accessetc.
• Created many summary reports and rollup reports.
• Developed many Tabular Reports, Matrix Reports, and Drill down Reports using SQL Server Reporting Services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services. Expert in creating reports using SQL Server Reporting Services (SSRS), handling sub reports. Well-versed in defining data sources for creating data source views for SSRS Reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters in the reports.
• Created many Cascaded parameters in the reports using T-SQL.
• GeneratedReport ModelsusingModel Designer,to enable the business users to build ad-hoc reports usingReport Builder.
• Written SSIS packages in 2008 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.
• Experience in designing and implementation web applications using ASP.NET including client-side scripting using JavaScript.
• Used C# to write all the middle business layer logic.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS).
• Used various control flow tasks likeFTP,Bulk insert task,Transfer job tasketc and different data flow tasks.
• Created complex stored procedures, Triggers and user defined functions using joins and cursors as required for reports datasets.
• Worked onSSISperformance tuning using counters, error handling, event handling, re-running of failedSSISpackages using checkpoints
• Analyze user requirements, functional and technical specifications,preparing test plans.

Environment: SQLServer 2000/2005/2008 R2, Visual Studio 2008,SSRS, SSIS,SSAS,DTS,VB.Net,Visual Studio .NET, Team Foundation Server (TFS), Enterprise Manager, Query Analyzer, SQL Profiler.

Confidential, Cambridge, MA

SSIS/DTS/SSRS/SQL Server

Responsibilities:

• Rewriting existing DTS packages to SSIS packages using SSIS 2005.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB sources, Excel Spreadsheet to SQL Server 2005.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).Involved in FTP & SFTP for file transfers from one directory to the other directory.
• Used data conversion task to convert many Unicode data types to Non Unicode data types.
• Created SSIS packages to retrieve data from Legacy sources.
• Replaced all the existing Batch files using Script task.
• Wrote many VB scripts and C# scripts like for Zipping or Unzipping files, which are used in Script task, and scripts to generate for each loop in DTS packages.
• Modified existing DTS packages to perform as per the requirements.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Used many DTS tasks like Dynamic property task to change the properties of the package at run time, execute package task, Execute Process Task etc.
• Scheduled many jobs job to run on a daily basis to import and export data at nightly basis.
• Rebuilt existing Crystal reports to SSRS reports.
• Created SSRS reports for Franchise Health Reports.
• Created User list first title played reports.
• Created reports by retrieving the data from cube using MDX reports.
• Designed reports, Graphs and deployed reports to web applications using SSRS.
• Built many drill down reports, matrix reports.
• Used n level of sub reports in a single report.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Redesigned the entire schema of existing databases on SQL2000 and migrated to SQL server2005.
• Gathered all the requirements from the end users for designing the databases
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Created new indexes for better performance of the database, and maintained data integrity by using foreign key relationship.
• Rewrote existing stored procedures to enhance the performance.
• Develop and implement database design documentation, including database diagrams, data mapping documents, data dictionaries etc.

Environment: MS SQL Server 2005, SQL Integration Services 2005, SQL Analysis Server 2005, SQL Reporting Server 2005, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Informatica PowerCenter 9.1,C#, VB Scripting, Erwin, Visio.

Confidential, Basking Ridge, NJ

SQL Server / SSIS Developer/SSRS Developer

Responsibilities:

• Good knowledge of RelationalDatabase Modeling/Loadingand Dimensional database modeling concepts.
• 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 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 usingSQL Server Integration Services (SSIS).
• Created Custom Web Controls like Grid View and Calendar in C#.
• Successfully deployedSSISPackage into Production environment and usedPackage configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• ImplementedEvent Handlersand 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.
• DefinedIndexes, Views, Constraints and Triggers toimplement business rules.
• Writing complex SQL queries using tablejoins (inner and outer), temporary tables, and table variables.
• Used C#.Net, ASP.Net for GUI design and business logic implementation.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• 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.
• 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.
• CreatingAd hocreports using Report Builder.
• Done front end ASP.Net application bridging to the back-end Database systems.

Environment: SQL Server 2000/2005/2008 R2,Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, Windows Server 2003, C#, ASP.Net, Oracle 9i, Erwin 7x,Visual Basic 6,Visual Studio .Net, C#.Net.ASP.Net

Confidential, Long Island, NY

SSAS/SSRS/SSIS/SQL Developer

Responsibilities:

• Involved increation of dimensionsusing Star, Snow Flake schemas.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2008/2005.
• Generated many calculated members in the cube.
• Used many KPI’s in cube used by the business to take decisions accordingly.
• Created partitions in cubes based on the dates of the data.
• Extensively worked onMS-SSRS, SSISand Slowly Changing Dimensions.
• Adeptatrebuilding indexeson various tables.
• 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 functions to 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.
• 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 configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• ImplementedEvent Handlersand Error HandlinginSSISpackages and notified process results to various user communities.
• Involved in strategic, planning and budgetary responsibilities.
• 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.
• CreatingAd hocreports using Report Builder.
• Done front end ASP.Net application bridging to the back-end Database systems.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2003, C#, ASP.Net, Oracle 9i, Erwin 7x,Visual Basic 6

Confidential, Newark, NJ

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

• Extensive knowledge of loading data from various sources likeCSV, flat files, to SQL Server database using SSIS Package.
• Created indexes, optimizedSQLqueries and alter joins to improve the performance Scheduled the SSIS packages and Jobs.
• Good experience in creatingMaster ChildPackages in SSIS.
• Hands on Experience in managing variousSSIS Package Configurationsin the form ofXMLFiles.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• 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.
• Designed a new schema for the Data Mart databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Created MDX queries to extract data from the Data Mart.
• Generated Dynamic reports from Cubes (SSAS) using SSRS-2005.
• Developed, designing and deploying of various complex reports such asDrill down, Tabular reports, Parameterized,Pie chartsusingExpressions, Global variablesandFunctionsinMS 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.

Environment: MS SQL Server 2000/ 2005, SSRS, SSIS, SSAS, Oracle 9i, DTS, T-SQL, VisualSourcesafe, TFS.