SUMMARY

• Over 6 years of experience in the IT industry, includes Software Analysis, Design, Development, Customization and Implementation of various business applications.
• 4+ years of experiences in SSIS, SSAS and SSRS of MS SQL SERVER.
• Extensive experience in SQL Server, T - SQL, MYSQL, Oracle and MS Access.
• Experience in the complete life cycle of databases which includes the design a database, populating lookup data, creating Stored Procedures as per front end developer’s requirement and commercial transitions, writing Triggers, creating user defined functions and created views to simplify the complexity of the data structure.
• Experience on T-SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function.
• Expert in designing start schema with Facts, Dimensions, Measures and Cubes.
• Experience in designing, creating and processing of cubes
• Excellent experience in creating, managing and deploying various types of reports using SQL Server Reporting Services and Report Manager.
• Extensive experience in developing reports using SQL Server Reporting Services (SSRS), Crystal Reports, Oracle Reports and MS Access reports.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP).
• Experience in database administration and maintenance activities such as Backup and Recovery, monitoring SQL Server.
• Experience on optimization of the stored procedures, Created indexes on the required tables, Created distributed partition views, and indexed views.
• Experience in Capacity planning and Disaster Recovery Planning.
• Experience on optimization of the stored procedures, Created indexes on the required tables, Created distributed partition views, and indexed views.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Monitored and tuned application using the performance Diagnostic tools such as SQL Profiler.
• Experience in maintaining security on multiple servers and multiple databases with Windows authentication and SQL Authentication.
• Experienced in Migrating databases from SQL Server 2005 to SQL Server 2008.
• Knowledge of data warehouse fundamentals,
• Good knowledge of parallel processing used it for faster query processing and loading data.
• Based on the business requirements,worked onFACT’s and DIMENSIONS.
• Good experience with database designing, creating logical and physical data models using Erwin and Visio.

TECHNICAL SKILLS

Databases: Oracle 10g/9i/8i/8.0, Access, MS-SQL Server.

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS),SSIS, Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, Query Builder, Informatics, Erwin.

Languages: C, C++, SQL, PL/SQL, UNIX Shell Programming, HTML, Visual Basic, Java, XML.

Web Applications: Active Server Pages 2.0.

Testing Tools: Win Runner 7.0, Test Director 8.0

GUI Tools: Forms 5.0/6i/9i, Reports 3.0/6i/9i

Other: MS Word, Excel, PowerPoint, Visio

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Application Developer

Environment: Open Connect Configure, NASCO (HRBK, HEHK (EEC), HURK, HIQK), SQL PLUS, SQL Server, ASP.NET 2.0, Visual Studio.NET 2010, C#.

Responsibilities:

• Designed and developed SQL Server database to responsively handle complex queries (T-SQL, triggers, stored procedures, functions, optimization)
• Created database objects like tables,Views and user defined datatypes.
• Experiences working in sql server 2008.
• Experiences working in Database like MYSQL .
• Developed Open Connect Robots to resolve different edits
• Worked extensively in HIQK, HEHK (EEC), HRBK modules of NASCO claims processing system.
• Designed and developed dot net interface to consume HIPAA 5010 web service to be used in OFP robots
• Responsible for implementation and testing of ICD 10 changes in the existing Open Connect Robots.
• Worked with business and development teams to develop System, End-to-End, and Regression test scenarios, plans, and scripts.
• Reviewed/Participated in the development and execution of quality assurance plans to ensure HIPAA 5010 modifications ability to meet business requirements..
• Involved in Production Support.

Confidential, Pittsburgh, PA

Sir SQL Server DBA\ BI Developer

Environment: VB.NET 2010, ASP.NET, MS SQL Server 2008, SSIS, SSRS, ADO.NET, XML, HTML, DHTML, CSS, JavaScript, AJAX and .Net Framework.

Responsibilities:

• Installing, Configuring and Administering SQL server 2008.
• Performing Database maintenance activities like Backups, Restoring, and indexing.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Ensuring high availability of the database exploiting the concepts of mirroring, replication, Log shipping etc.
• Monitoring the Disk spaces on all the servers.
• Checking the general Health of the servers for identifying Bottlenecks.
• Analyzing, Identifying and Resolving performance issues of the server.
• Designing Database and estimation of future requirements.
• Database performance tuning for optimal results.
• Developed Backup strategies for Database Recovery.
• Ensuring High Availability using Technologies like DB mirroring, Log shipping.
• Configuring Replication between servers.
• Involved in Designing and Coding of various modules including UI screens in application using VB.Net, XHMTL, JavaScript and AJAX.
• Involved in working with XML by displaying and retrieving the data using XML file.
• Validation of web pages using required field, range, validation summary and regular expression.
• Responsible for connectivity of database using ADO.NET Components.
• Extensively worked with VB.Net for creating classes for Data Access Layer of the application and integrated with ASP.Net pages.
• Created components in VB.NET that can be reused on several pages.
• Created Database Diagrams, Defined relationship between tables and enforced the referential integrity constraints.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and Functions.
• Used Various tools to improve SQL Server Performance like Performance monitor, Profiler trace, Index Tuning wizard...
• Extracted, transformed, and / or loaded data (ETL).
• Implementation and release of database changes, testing and security review...
• Create SSIS and used the task to import and export files.
• Create, modify, schedule, test, delete, and / or troubleshoot SQL Server Integration Services (SSIS) packages, stored Procedures, tables, and views.
• Create ad hoc complex management reports as required. Handle distributed queries, distributed transactions.
• SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Involved in Unit Testing and System Testing of the application.

Confidential

SQL Server DBA\ BI Developer

Environment: VB.Net,ASP.NET, MS SQL Server 2008, SSIS, SSRS, ADO.NET, XML, HTML, DHTML, CSS, JavaScript, AJAX and .Net Framework 2.0/3.0.

Responsibilities:

• Designed the Functional Specifications of the system.
• Performing Database maintenance activities like Backups, Restoring, and indexing.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Ensuring high availability of the database exploiting the concepts of mirroring, replication, Log shipping etc.
• Monitoring the Disk spaces on all the servers
• Designed and developed SQL Server database to responsively handle complex queries (T-SQL, triggers, stored procedures, functions, optimization)
• Prepared project schedule and monitored tasks assigned to team members to ensure all deadlines are met.
• Create SSIS and used the task to import and export files.
• Create, modify, schedule, test, delete, and / or troubleshoot SQL Server Integration Services (SSIS) packages, stored procedures, tables, and views.
• Create ad hoc complex management reports as required. Handle distributed queries, distributed transactions.
• Used SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.

Confidential

SQL Server DBA\ BI Developer

Environment: VB.NET 2005, ASP.NET, MS SQL Server 2008, SSIS, SSRS, ADO.NET, XML, HTML, DHTML, CSS, JavaScript, AJAX and .Net Framework.

Responsibilities:

• Installing, Configuring and Administering SQL server 2008 and SQL Server 2005.
• Performing Database maintenance activities like Backups, Restoring, and indexing.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Ensuring high availability of the database exploiting the concepts of mirroring, replication, Log shipping etc.
• Monitoring the Disk spaces on all the servers.
• Checking the general Health of the servers for identifying Bottlenecks.
• Analyzing, Identifying and Resolving performance issues of the server.
• Designing Database and estimation of future requirements.
• Database performance tuning for optimal results.
• Developed Backup strategies for Database Recovery.
• Ensuring High Availability using Technologies like DB mirroring, Log shipping.
• Configuring Replication between servers.
• Designed the Functional Specifications of the system.
• Performing Database maintenance activities like Backups, Restoring, and indexing.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Ensuring high availability of the database exploiting the concepts of mirroring, replication, Log shipping etc.
• Monitoring the Disk spaces on all the servers
• Updated classes in VB.NET to be reused in ADO.NET
• Used MS Visual SourceSafe .Net for source code management
• Created multiple tables for Sales, Marketing and Inventory System and accounts Receivable Systems that interact with data access objects for data retrieval using ADO.NET .Net
• Design and implementation of Security Model, policies and procedures
• Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool
• Created Snapshot Replication for the Development and Testing Databases across different Servers
• Development of SSIS Packages, stored procedures, views, triggers, index and SQL Scripts
• Release of database changes and security reviews
• Designed and developed complex SSRS reports
• Involved in Unit testing and System Testing for the application.

Confidential

SQL Server DBA\ BI Developer

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, SSRS, SSIS, SSAS, Erwin.

Responsibilities:

• Designed and developed SQL Server database to responsively handle complex queries (T-SQL, triggers, stored procedures, functions, optimization) .
• Experience working in SQL Server 2005.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc
• Grant privileges to users to access systems and databases.
• Recovery of the database during crash or data Loss.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• To set up SQL Server configuration settings.
• Running DBCC commands to check Database Consistency.
• Monitoring the Disk spaces on all the servers
• Experiences in designing, Creating and processing of Cubes using SSAS.
• Scheduling cubes processing from staging Database Tables using SQL Server Agent.
• Aggregated the cubes with 40% Performance for better performance.
• Processed cubes to perform incremental updates.
• Create Reports by extracting data from cube.
• Experiences in Dimensional Modeling
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Created Dashboards in SSRS 2008.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.

Confidential

SQL Server DBA\SQL Server Developer

Responsibilities:

• Involved in designing of conceptual logical model and physical model.
• Installing, Configuring and Administering SQL Server 2005.
• Performing Database maintenance activities like Backups, Restoring, and indexing.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Ensuring high availability of the database exploiting the concepts of mirroring, replication, Log shipping etc.
• Created new database objects like procedures, functions, packages, triggers, indexes and views .
• Fine-tuned the logic in procedures, functions and triggers for optimum performance.
• Developed database triggers to enforce data integrity and additional referential integrity.
• Wrote transact SQL utilities to generate table insert and update statements.
• Involved in performance tuning and monitoring of PL/SQL blocks.
• Wrote stored procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created stored procedures to transform the data and worked extensively in for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (cluster index, non cluster index) tables.