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, 2014 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, Oracle, Flat Files, XMLs, Salesforce, WorkDay,Teradata, AS400 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 and 2012.
• 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 2008.
• 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, maintaining tasks and scheduling jobs using SQL Server and JAMS.
• 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 effective communication skills and actively participated in problem solving and trouble-shooting issues.

TECHNICAL SKILLS

Operating Systems: Windows 2008/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/2014/2016, 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, The Woodlands, TX

Sr. SQL Server Developer

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as flat file, Excel, SQL Server 2014, 2016, DB2 and Salesforce.
• Involved in designing and developing packages for Data Warehouse and Data Migrations projects using Integration Services (SSIS) on different Data Sources.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• 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 Data Conversion, Conditional Split, Lookup, Derived Column, Send Mail, Web Services and File System Task etc.
• Worked with different Control Flow elements like For Loop Container, For Each Loop Container etc.
• Used Workbench to validate the Salesforce data after data upload to Salesforce.
• Used IBM data studio for accessing AS400 data for migration and data validation.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Desinged and deloped SSIS package with CDC tracking the delta records.
• Created Jobs using sql server agent to automatically run the stored procedures in scheduled time.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• 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.
• 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 Dynamic SQL extensively in T-SQL queries and stored procedures increasing usability of code.
• Scheduled and monitored dependency and pre-check jobs and Schedule jobs to run according to business days using the SQL Server Agent.
• Used SSIS Project parameters for connections to be used in more packages and package parameters allowing package modification during execution without editing packages.
• Used Event Handlers in SSIS package at the package and task level on error, on warning and configured it using send email task and script task.
• Expertise in generating reports using SQL server reporting Services, Power Pivot and Power Bi.
• Used project configuration in deploying packages to production environment.
• Experience in Using and maintaining the Team foundation server for version control.
• Involved in Knowledge Transfer to the peers and documentation.

Environment: SQL Server 2012/2014,T-SQL,SQL Integration Services(SSIS),Power Bi, SQL Reporting(SSRS), Business Intelligence Studio, IBM Data Studio, Visual Studio 2013, Salesforce Workbench, SharePoint, C#, HTML, Team Foundation Server (TFS), Jira.

Confidential, San Antonio, TX

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 and incorporated business defined transformation logic to loaded SQL and Teradata Tables.
• 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.
• 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.
• Created report for users in different departments in organization using SSRS and Power Bi.
• 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 and 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.
• Worked actively in performance tuning and optimizing the SQL queries using the SQL Profiler, query execution plan & SQL DMV’s, DBCC commands 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, Power Bi, Business Intelligence Studio, JAMS, Visual Studio 2012/2010, BI Xpress, SharePoint, Project Server, C#, VB, HTML, Team Foundation Server (TFS), Service Now.

Confidential, Conway, AR

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.
• 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.
• 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 columns as per the client requirement.
• Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.
• 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: Windows 2003 Server/XP, SQL Server 2012/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), CASD, Jira.

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.
• Used Dynamic SQL extensively in T-SQL increasing usability of code and used dynamic query to create parameterized, cascading parameterized 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 ensuring 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.
• Loaded flat files into stage tables by using Bulk Copy Program BCP and DTS packages. Scheduled database jobs for automation of DBA tasks.
• 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.
• 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.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality.
• 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.
• 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), MS-Visio, .Net4.0, C#.net, Html, MSAccess.