SUMMARY

• Overall 8+ years of extensive IT professional experience with expertise in Database development, Database modeling, Design and Technical Management using SQL Server 2000, 2005, 2008 and 2012 in various domains like Retail, Health Care, Banking and Insurance as SQL Developer and MSBI Developer.
• Expertise in Microsoft Business Intelligence Services like SQL Server Integration Services, SQL Server Analysis Services and designing reports using SQL Server Reporting Services.
• Experience in designing 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).
• Experience in developing, monitoring and deploying of SSIS packages.
• Experience in designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.
• Expertise in generating reports like Drill Down, Drill through reports using SSRS 2008.
• Experience in generating Ad - hoc reports using MS Reporting services and Crystal reports.
• Experience in generating reports using SSRS from OLTP and OLAP data sources and deployment on server.
• Proficient in design and Development of matrix, tabular and parametric Reports in the SQL Server Reporting Services.
• Implementation of Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Managing Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.
• Experience in implementation of data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert and XML)
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Strong expertise in Creating Stored Procedures, User-Defined Functions, Triggers, Indexes, Views, User Profiles using Transact SQL.
• Experience in Normalization\De-Normalization, data design and building referential integrity for Relational databases.
• Experience in scheduling backups and maintaining tasks.
• Experience in Scheduling Jobs through SQL Agent and JAMS Agent.
• Worked actively in performance tuning and optimizing the SQL queries using the SQL Profiler, query execution plan & SQL DMV’s, DBCC commands and Custom Script, Built in performance Report and Activity Monitor.
• Experience in optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Good knowledge in query optimization & performance tuning, using SQL Server Profiler, Execution Plan and Performance Monitors.
• A well organized team member with good communication skills and actively participated in problem solving and trouble-shooting issues.

TECHNICAL SKILLS

Operating Systems: Windows 2007/2003/XP/Vista, Windows 2000 Advanced Server, Windows 2003 Enterprise Server

Languages: T-SQL, C, C#, VB.NET, HTML

Databases: MS SQL Server 2000/2005/2008/2012, MS Access, Oracle Database 11g/10g/9i

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio ( SSIS, SSAS, SSRS).

Version Controlling Tools: VSS, TSF

Data Modeling Tools: MS-Visio, Erwin 7.2/4.5, Visual Studio

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer\ETL Developer

Responsibilities:

• Designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.
• Design of the data source and data flows, data quality analysis.
• Gathered business requirements, working in conjunction with the data warehouse architect on the development of logical data models.
• Created Stored Procedures, Views and User Defined Functions to support the front-end application.
• Implementation of Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Created Jobs using SQL server agent and JAMS agent to automatically run the SSIS Packages and stored procedures in scheduled time.
• Generated xlma’s to Refresh Tabular Model and scheduled jobs for respective xmla’s through JAMS
• Used various Transformations such as Multicast, Merge Join, Lookup, Multiple Hash, Conditional Split,Union All, Derived Column Transformations and Containers in the SSIS Packages.
• Worked on de-bugging package execution using break points in control flow and data viewer in data flow.
• Optimized packages minimizing use blocking transformations, adjusting buffer size, parallely executing packages in control flow, and using proper event handing, loggings and check points.
• Worked on importing and exporting data from MS-Access Database to SQL Server Database.
• Developed, created and implemented complex ETL strategy to grab the data from OLTP, perform various transformations and dump the incremental data into Data Mart.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Designed, deployed and maintained various SSRS Reports in SQL Server 2008 and 2012.
• Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create SSRS reports
• Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS.
• Scheduled and monitored dependency and pre-check jobs using JAMS and Schedule jobs to run according to business days using the SQL Server Agent.
• Used XML nas SQL server package configuration in deploying packages to production environment.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Experience in Using and maintaining the Visual Source Safe for version control.
• Created Complex Views and complex functions to expose the particular columns as per the client requirement.
• Monitoring DB space growth in SQL servers and working with different teams to get them sorted out.
• Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.
• Worked actively in performance tuning and optimizing the SQL queries using the SQL Profiler, query execution plan & SQL DMV’s, DBCC commands and Custom Script, Built in performance Report and Activity Monitor.
• Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation
• Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.

Environment: Windows 2007 Server/XP, SQL Server 2012/2008R2/2008/2005, T-SQL, SQL Integration Services(SSIS), SQL Reporting Services (SSRS), SSAS, Business Intelligence Studio, JAMS, Visual Studio 2012/2010, BI Xpress, SharePoint, Project Server, C#,VB, HTML, Team Foundation Server (TFS).

Confidential

SQL Server BI Developer

Responsibilities:

• Successful migration of the data from 2005 SQL database to SQL 2008, 2012 database by converting and re-writing DTS packages and updating them to SSIS packages.
• Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server .
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Implementation of Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Created Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Created Triggers (Instead Of and After) for Auditing Purpose.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Created Jobs using sql server agent to automatically run the stored procedures in scheduled time.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Worked on de-bugging package execution using break points in control flow and data viewer in data flow.
• Worked on importing and exporting data from MS-Access Database and XML to SQL Server Database.
• Developed, created and implemented complex ETL strategy to grab the data from OLTP, perform various transformations and dump the incremental data into Data Mart.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Optimized ETL packages using various SSIS features at Control Flow and Data Flow level.
• Implemention of OLAP Data Warehouses using SQL 2008/20012 Analysis Services.
• Designed, deployed and maintained various SSRS Reports in SQL Server 2008 and 2012.
• Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create parameterized, cascading parameterized reports, drill down, drill thorugh and Tab reports
• Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS
• Optimized packages minimizing use blocking transformations, adjusting buffer size, parallely executing packages in control flow, and using proper event handing, loggings and check points.
• Used XML nas SQL server package configuration in deploying packages to production environment.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Experience in Using and maintaining the Visual Source Safe for version control.
• Created Complex Views and complex functions to expose the particular columns as per the client requirement.
• Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.
• Worked actively in performance tuning and optimizing the SQL queries using the SQL Profiler, query execution plan & SQL DMV’s, DBCC commands and Custom Script, Built in performance Report and Activity Monitor.
• Automate the backup and the recovery strategies for the Production environments.
• Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation
• Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.
• Monitoring DB space growth in SQL servers and working with different teams to get them sorted out.
• Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.

Environment: Windows 2007 Server/XP, SQL Server 2012/2008R2/2005, MS Access, T-SQL, SQL Integration Services(SSIS), SQL Reporting Services (SSRS), SSAS, Business Intelligence Studio, Visual Studio 2008, Erwi4.0, SharePoint,, C#,VB, HTML, Visual Source Safe (VSS).

Confidential, Houston, TX

MSBI/SQL Developer

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005, 2008 and 2012.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.
• Created Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, CTE’s, Triggers etc. according to the Requirements.
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like For Loop Container, For Each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Created Jobs using sql server agent to automatically run the stored procedures in scheduled time.
• Created Triggers (Instead Of and After) for Auditing Purpose.
• Monitored and modified SQL query Performance using execution plans creating Index and re-building indexes.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Implemention of OLAP Data Warehouses using SQL 2005/2008 Analysis Services.
• Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create parameterized, cascading parameterized reports and Tab reports
• CreatedSub Reports, Parameterized and Drill down Reportsbased on the requirements provided.
• Optimized packages minimizing use blocking transformations, adjusting buffer size, parallely executing packages in control flow, and using proper event handing, loggings and check points.
• Used XML nas SQL server package configuration in deploying packages to production environment.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Involved in Database Administration activities like Back up, Security, Migrations in the development servers.
• Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.
• Involved in Knowledge Transfer to the peers, documentation of all the Business logic insuring maintenance is easy for the Peers.

Environment: Windows 2003 Server/XP, SQL Server 2008R2/2008/2005, T-SQL, SQL Integration Services(SSIS), SQL Reporting(SSRS), SSAS, Business Intelligence Studio, Visual Studio 2008, Erwi4.0, SharePoint, MOSS2007,C#, HTML, Visual Source Safe (VSS).

Confidential, East Hanover, NJ

SQL Server/SSIS/SSRS Developer/DBA

Responsibilities:

• Developed Complex Queries in T-SQL, Stored Procedures and Views with best execution plan.
• Created T-SQL scripts to validate and verify the data migration from SQL Server 2000 to SQL server 2008 R2 production server.
• Developed stored procedures for front-end to upload customer’s record from online applications into SQL server 2008 R2.
• Created Logging and Configuration files for SSIS packages.
• Responsible for developing, monitoring and deploying SSIS packages.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 2 slowly changing dimensions.
• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Implemented error handling in packages using SSIS.
• Creation of very complex ETL strategies to include auditing, transactions, checkpoint in packages, change data capture (CDC) and checksum for incremental load in OLAP and securing ETL packages using encryption in conjunction with passwords.
• Loaded flat files into stage tables by using Bulk Copy Program BCP and DTS packages. Scheduled database jobs for automation of DBA tasks.
• Involved in designing and developing cubes in SSAS environment using Star Schema Design for the operational data.
• Used proper storage modes like MOLAP and HOLAP based on the requirement and frequency of use.
• Worked on SSRS to generate reports using XML data source.
• Automate the backup and the recovery strategies for the Production environments.
• Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation
• Generated parameterized/Drilldown reports using SSRS 2008 and Crystal Reports.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Took part in the normalization and de-normalization of database.
• Worked actively in performance tuning and optimizing the SQL queries using the SQL Profiler, query execution plan & SQL DMV’s, DBCC commands and Custom Script, Built in performance Report and Activity Monitor.
• Automate the backup and the recovery strategies for the Production environments.
• Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation.
• Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.

Environment: SQL Server 2000/2008 R2, T-SQL, Server Integration Services (SSIS), SSRS, MS Excel, Advanced Windows 2003 Server, Crystal Reports, MS Visual SourceSafe, Ervin 4.0, Visual studio 2008, SharePoint(MOSS) 2007.

Confidential, Columbus, OH

SQL MSBI Database Developer

Responsibilities:

• Involved in gathering business requirements from business and clients to develop various reports and cubes.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality.
• Enhanced the old logical and physical database to fit new business requirement and implemented new design into SQL Server 2008.
• Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
• Wrote T-SQL queries, Stored Procedures and used them to build Packages.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, OLEDB and Access to SQL Server.
• Generated reports using Crystal reports and excel spread sheets.
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Scheduling backups and automating weekend maintenance tasks.
• Built Drill Down, Drill through reports using SSRS 2008.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in daily and monthly running processes and maintain the database for future reference
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.

Environment: SQL Server 2008/2005, T-SQL/PL-SQL, Query Analyzer, Windows XP/2003, Visual Studio 2008/2005, TFS 2008/2005, Erwin, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS-Visio, .Net4.0, C#.net, Html, MSAccess.

Confidential

SQL SSIS/SSRS Developer

Responsibilities:

• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created various complex stored procedures for ETL as well as maintenance of the database.
• Performed database Log Shipping for high availability solutions and fault tolerance between multiple SQL server instances.
• Created tables, relationships, triggers and indexes for enforcing business rules.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Created the different user defined functions in the application as per business requirement.
• Created triggers, UDF, views, tables and generated T-SQL script for application and indexes for better performance.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Tuned SQL statements and Stored Procedures.
• Worked on DTS/SSIS Package, DTS Import/Export Wizard for transferring data from heterogeneous database sources.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques
• Involved in unit testing with the daily file and sent the everyday test Agent training file by running the jobs manually.
• Worked on production support and resolved the issues with the jobs.

Environment: Windows XP/2003, SQL Server 2008/2005,T-SQL, DTS/SSIS,Visual Studio2005, Erwin, MS-Visio, .Net3.5,C#.net, Html, DTS, Css, MSAccess, Microsoft-Office 2003/2007.

Confidential

MS SQL Server Developer

Responsibilities:

• Gathered functional requirements and business requirements and written the technical specifications.
• Worked on data migration from MS SQL Server 2000 to MS SQL Server 2005.
• Created Indexes and Rebuild indexes for better Query performance.
• Backing up, Restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Participated in designing and testing disaster recovery model.
• Resolved any deadlocks issues with Databases/Servers on a real-time basis.
• Wrote complex stored procedures, User Defined Functions, Triggers using T-SQL.
• Created reports using Crystal Reports.
• Used SQL Profiler, System Monitor, Query Analyzer for Troubleshooting, Monitoring, Optimization and Tuning of SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning advisor.

Environment: SQL Server 2000/2005, MS Access, SQL Server Configuration Utility, T-SQL, SQL Query Manager, MS Visual Source Safe, Windows XP.