SUMMARY

• Around 8 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite SQL Server 2000/2005/2008 R2/2010/2012 (Development and Production Environment on various business domains like Banking, Publishing, Healthcare and IT Solution providing).
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting MS SQL Server 2012/2008/2005/2000 .
• Expert in writing T - SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Experience in Extracting, Transforming and Loading (ETL) data from various sources to several destinations using BCP utility, DTS and SSIS.
• Experience in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating the data.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2005.
• Experience in Creating, Consuming and Publishing XML Web Services using .NET Framework 4.0/ 3.5/2.0/1. x.
• Experience in developing GUI applications in .NET with SQL server, MS access and Oracle as backend.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in performing DBA tasks using Enterprise Manager and Query Analyzer.
• Experience in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Experience in implementing change requests for enterprise level project deployments and bug fixes into production environment.
• Experience in resolving trouble tickets/problem tickets for issues related to production from end users.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Experience in Software Development Life Cycle (SDLC) specifically waterfall and Agile methodology
• Expertise in designing Database Models using MS Visio.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated TEMPeffective team member.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, DTS, SQL Profiler, Index Tuning wizard

ETL & Reporting Tools: SSIS, SSRS, SSAS, Informatica, Crystal Reports, Business Objects

Databases: MS-SQL Server 2012/2008/2005/2000 , MS Access 97/2000, Oracle, DB2

Web technologies: MS Visual Studio 3.0/2.0, .Net framework 4.0/ 3.5/2.0/1. x, ASP.NET, VB.NET, C#, XML, PHP, HTML, DHTML, Java Script and VB Script, T-SQL, PL/SQL

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix,MS-DOS

Tools: SSIS, SSRS, SSAS, TOAD, Bug tracker.net, SVN

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2008/2008 R2.
• Worked extensively with complex T-SQL queries, stored procedures.
• Created SSIS packages to load the data into the staging and the main tables along with archiving of the data into the history tables maintaining the back up of data
• Documented the current existing process and scope of changes in the new process which uses Sub Version Repository.
• Created, updated and closed the Change Request’s and Problem ticket’s using ticketing system tool for Change Management process called BMC Remedy.
• Deploying the SSIS packages, Stored Procedures, Code fixes into production environment.
• Scheduled SSIS packages to run every morning in tidal jobs and SQL server Jobs.
• Monitoring the Jobs running on production servers and the records being updated in the final tables using different metrics.
• Identified the Data Source and defined them to build the Data Source Views.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Extensively worked on design, plan and implementation of automating the current process.
• Worked closely with the end users to correct the data related issues in different kinds of reports like Hyperion, Rex, SSRS.
• Generated monthly reports using SSRS for different Line of Businesses depending on the requirement.
• Experience in developing applications using .NET framework 3.5/4.0, VB.Net, Web Services and Entity Framework
• Worked on multiple projects simultaneously.
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008R2/2008, SQL BI Suite (SSAS, SSIS, SSRS), SQL Profiler, Index Tuning Wizard, DB2, Oracle, .Net framework 3.5/4.0, MS Office, Visual Studio, Tidal, Red Gate, Sub Version, Bug Tracker.net, BMC Remedy.

Confidential, Houston, TX

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2008.
• Worked extensively with complex T-SQL queries, stored procedures.
• Created SSIS packages to load the data into the staging and the main tables along with archiving of the data into the history tables maintaining the back up of data
• Scheduled SSIS packages to run every morning in tidal jobs.
• Created different types of SSRS Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting using SSRS.
• Experience in developing applications using .NET framework 3.5/4.0, VB.Net, Win Forms, Web Services and Entity Framework
• Identified the Data Source and defined them to build the Data Source Views.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Extensively worked on design, plan and implementation of automating the current process.
• Worked on multiple projects simultaneously.
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008R2/2008, SQL BI Suite (SSAS, SSIS, SSRS), Toad, SQL Profiler, DB2, .Net framework 3.5/4.0, MS Office, Visual Studio, Tidal, Business Objects.

Confidential, Scranton, PA

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2012/2008.
• Worked extensively with complex T-SQL queries, stored procedures.
• Created SSIS packages to load the data into the staging and the main tables along with archiving of the data into the history tables maintaining the back up of data
• Created month end summary report for eTrade and eRevenue.
• Documented the current existing process and scope of changes in the new process which uses File Ingestion Tool.
• Scheduled SSIS packages to run every morning in tidal jobs.
• Worked on creating cubes, calculations, KPI’s, deploy of cubes using SSAS.
• Generated monthly reports for financial department regarding the books sold for that month and revenue details using SSRS.
• Experience in developing applications using .NET framework 3.5/4.0, VB.Net, Win Forms, Web Services and Entity Framework
• Identified the Data Source and defined them to build the Data Source Views.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Extensively worked on design, plan and implementation of automating the current process.
• Worked on multiple projects simultaneously.
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2012/2008R2/2008, SQL BI Suite (SSAS, SSIS, SSRS), SQL Profiler, DB2, .Net framework 3.5/4.0, MS Office, Visual Studio, Tidal.

Confidential, NJ

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in the database migration from SQL server 2005 to SQL server 2008.
• Analyzed business and technical requirements, including logical data model according to the requirements and developed scripts for the creation of the physical database schema(s), data security and protection, and archiving data.
• Created and maintained database objects.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Scheduled Daily, Weekly and Monthly jobs using SQL server agent to load the patient information.
• Used SSIS in building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Used SSIS to load the patient data from the ftp server of the providers into the SQL server database.
• Experience in developing applications using .NET framework 3.5, VB.Net, Web Services and Entity Framework
• Involved in installing and migrating DB2 database to SQL Server 2008
• Involved in developing life cycle using Agile methodology
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and sub reports. Published the reports on the web server to be accessed by the case managers.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

Environment: Windows XP Professional (SP 2), SQL Server 2008/2005, DB2, SQL Profiler, SSIS, SSAS, SSRS, .Net framework 3.5, Agile.

Confidential, Los Angeles, CA

MS SQL Server Developer

Responsibilities:

• Involved in the upgrade of databases from SQL server 2000 to SQL server 2005.
• Migrated the DTS packages into SSIS and created new SSIS packages to Extract, transform and load the data from old data warehouse to a new data warehouse and OLTP to OLAP.
• Removed the DTS package references from stored procedures and created as SSIS packages and embedded those procedures in the SSIS package to retain the load functionality of the system.
• Performed regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.
• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created and monitored all SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio. Includes, implementation of necessary batch processes for periodic updates.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Involved in developing life cycle using Agile methodology
• Scheduled full and transactional log database backups in the production environment using the database maintenance plan wizard.
• Setup database maintenance plans and used index tuning wizard to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.

Environment: Windows XP Professional (SP 2), SQL Server 2005/2000, SQL Profiler, SSIS, SSAS, SSRS, Agile.

Confidential

MS SQL Server/.NET Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed rich client applications using C#, ADO.NET, SQL Server 2000 using Visual Studio.Net IDE tools.
• Designed and validated the forms according to client requirements using C#.
• Involved in Analysis, design, and developed the Application in ASP.Net.
• Used ADO.Net Object Model to interact with SQL Server database. Developed data layer component to connect with the database.
• Defined relationship between tables and enforced entity referential integrity.
• Created DTS Packages to load dimensions and fact tables.
• Created indexes, constraints, views and rules on database objects.
• Performance tuned T-SQL code, Stored Procedures and DTS Packages.
• Scheduled, monitored and provided production support for DTS Packages.
• Used BCP utility to publish table output to text files.
• Extensively used enterprise manager (MMC) and query analyzer.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Documented the data flow and the relationships between various entities.

Environment: MS SQL Server 7.0/2000, T-SQL, C#, ASP.NET, Windows NT 4.0, HTML 4.0, VB 6.0, ADO 2.0, ActiveX.

Confidential

MS SQL Server Developer

Responsibilities:

• Loaded data from Flat files (.txt) into SQL Server
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL on this data
• Tested Performance & Accuracy related queries under SQL Server
• Development of T-SQL Stored Procedures for moving and maintaining synchronization of data between legacy system and newly developed application.
• Fine tuning of queries, assigned proper Indexes for better performance.
• Developed & executed several Optimized queries in SQL.
• Performance monitoring and tuning MS SQL Server.
• Moving data in and out of servers using BCP.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Created various reports using Crystal Reports after performing Data Analysis on the various Views of Business Intelligence.

Environment: SQL Server, Windows NT 4.0 Platform, Crystal Reports, T-SQL, EXCEL, Access.