SUMMARY

• Around 8 years of IT experience in teh 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 teh 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 teh data.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix teh errors.
• Experience in Designing and Building teh Dimensions and cubes wif 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 wif 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 teh client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2008/2008 R2.
• Worked extensively wif complex T-SQL queries, stored procedures.
• Created SSIS packages to load teh data into teh staging and teh main tables along wif archiving of teh data into teh history tables maintaining teh back up of data
• Documented teh current existing process and scope of changes in teh new process which uses Sub Version Repository.
• Created, updated and closed teh Change Request’s and Problem ticket’s using ticketing system tool for Change Management process called BMC Remedy.
• Deploying teh SSIS packages, Stored Procedures, Code fixes into production environment.
• Scheduled SSIS packages to run every morning in tidal jobs and SQL server Jobs.
• Monitoring teh Jobs running on production servers and teh records being updated in teh final tables using different metrics.
• Identified teh Data Source and defined them to build teh 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 teh current process.
• Worked closely wif teh end users to correct teh data related issues in different kinds of reports like Hyperion, Rex, SSRS.
• Generated monthly reports using SSRS for different Line of Businesses depending on teh 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 teh 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 teh client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2008.
• Worked extensively wif complex T-SQL queries, stored procedures.
• Created SSIS packages to load teh data into teh staging and teh main tables along wif archiving of teh data into teh history tables maintaining teh 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 teh Data Source and defined them to build teh 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 teh current process.
• Worked on multiple projects simultaneously.
• Involved in testing, bug fixing and documentation for teh 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 teh client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2012/2008.
• Worked extensively wif complex T-SQL queries, stored procedures.
• Created SSIS packages to load teh data into teh staging and teh main tables along wif archiving of teh data into teh history tables maintaining teh back up of data
• Created month end summary report for eTrade and eRevenue.
• Documented teh current existing process and scope of changes in teh 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 teh 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 teh Data Source and defined them to build teh 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 teh current process.
• Worked on multiple projects simultaneously.
• Involved in testing, bug fixing and documentation for teh 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 teh database migration from SQL server 2005 to SQL server 2008.
• Analyzed business and technical requirements, including logical data model according to teh requirements and developed scripts for teh creation of teh 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 teh 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 teh patient data from teh ftp server of teh providers into teh 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 teh reports on teh web server to be accessed by teh case managers.
• Responsible for performance tuning, optimizing teh queries, removing redundant and inconsistent data, joins from teh 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 teh upgrade of databases from SQL server 2000 to SQL server 2005.
• Migrated teh DTS packages into SSIS and created new SSIS packages to Extract, transform and load teh data from old data warehouse to a new data warehouse and OLTP to OLAP.
• Removed teh DTS package references from stored procedures and created as SSIS packages and embedded those procedures in teh SSIS package to retain teh load functionality of teh system.
• Performed regular Administration activities from Managing system resources, users and database to teh fine-tuning level and implemented teh 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 teh queries, removing redundant and inconsistent data, joins from teh 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 teh production environment using teh database maintenance plan wizard.
• Setup database maintenance plans and used index tuning wizard to reorganize indexes, re-indexing and update teh index statistics on teh 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 teh forms according to client requirements using C#.
• Involved in Analysis, design, and developed teh Application in ASP.Net.
• Used ADO.Net Object Model to interact wif SQL Server database. Developed data layer component to connect wif teh 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 teh data flow and teh 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 teh 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 teh various Views of Business Intelligence.

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