SUMMARY

• Around 7+ years of IT experience in Database Administration, and Support of MS SQL Server 2008/2005/2000/7.0 in Production, UAT and Development Server Environments.
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Expertise in Database design, Entity Normalization and Database Creation.
• Proficient in Designing and Documentation of SQL Server Strategies and plans.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Full - Text indexing and Database Application Development using varied development tools.
• Extensive use of T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Expert in creating tables, views, user defined data types, indexes.
• Good experience in working with Reporting services and Analysis services using SQL server 2000/2005/2008.
• Experience in building Data marts, OLAP Cubes using SSAS.
• Worked extensively on Optimization and Tuning for increasing Query and Database performance.
• Extensive experience in T-SQL (DDL, DML, DCL), Views, Stored Procedures, Cursors andTriggers.
• Created ad-hoc queries from SQL Server databases for custom reporting needs.
• Developed and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services.
• Created SQL Server drill down and drill through reports using both SQL Server 2005 and 2008 Reporting Services (SSRS).
• Experience in Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
• Migrated data from legacy system (text based files, Oracle, and Access) to SQL Server databases usingSQL Server Integration Services (SSIS).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005).
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• DevelopeddashboardreportsusingSQLServerReportingServices(SSRS), Report Model and ad-hocreporting usingReport Builder.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services.
• Built various packages in SSIS to load the data coming from various interfaces like OMS.
• Proficient in SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
• Migrated Organization, Orders, Adjustments, Objectives and Callidus data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Well acquainted with Data-warehousing concepts, MOLAP/ROLAP cubes structure.
• Experience in creating script files using VB6.
• Use to create web services.
• Highly motivated and a conceptually strong individual with Exceptional Analytical and Design Skills.
• Strong Inter-Personal Communication, Technical, Organizational and analytical skills.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2000/ 2005, MS Access.

Database Technologies: SQL Server Enterprise Manager, OLTP, SQL Profiler,Data Transformation Services (DTS), ETL, Upgrade Wizard,Replication, Jobs and task creating and scheduling, DBCC and BCP.

Operating Systems: Windows XP, 2003, 2000, NT, 98, 95, MS DOS 4.0 - 6.2.

Languages: SQL, Transact SQL, UNIX/AIX, UNIX Shell scripting, HTML, XML.

Programming Languages: SQL, TSQL, XML, C, C++, HTML, ASP.NET

Testing Tools: Win Runner, Load Runner, Test Director, and Quick Test Pro

PROFESSIONAL EXPERIENCE

Confidential, PA

SQL Server Developer

Responsibilities:

• Executed performance tuning on complex queries in SQL server using Profiler, Index Tuning Wizard, and Trace File.
• Created required indexes, new Stored Procedures and reduced the response time and failure rate for application and reports.
• Created drill down and drill through reports using SSRS and created OLAP Cubes using Star Schema and Snow Flake Schema.
• Used SSIS to load Data from different source sources to SQL server and from SQL server to spreadsheets.
• Created trend charts using SQR (SSRS) and also created paretos and trend charts using visual basic.
• Created Views for Dimension and Fact Tables in Staging for more flexibility.
• Created Indexes on Tables to improve the performance.
• Performed Data Validation to ensure data integrity in source, staging, core and destination database for the Data Mart Project.
• Created functions, procedures, triggers for Reporting Objects.
• Created SSIS packages for importing and exporting data from Excel, Flat file, Oracle to MS SQL Server databases by using SSIS.
• Interacted with the users to analyze the changes for enhancements to existing reports and developed them.
• Involved in creating a demo Data Mart for Claims System by analyzing the source data.
• Involved in creating and reviewing Data Dictionary.
• Created ETL logging Control tables for maintaining a log of all the loads
• Involved in the creation of Demo cube from Data Mart using SSAS.
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for the Dashboard for Health Management systems.
• Worked in OLTP & OLAP environment that includes Production, QA and development databases in SQL Server.
• Worked extensively in integrating different data sources (Oracle, Access, & Excel) without taking the production system offline.
• Developed scripts and re-usable modules in SAS.
• Written UNIX shell scripts for testing the application and writing the SQL queries for Sybase database.

Environment: MS SQL Server 2008/2005, TSQL, SSIS, SSAS, Unix, Windows 2003, Business Objects Data Integrator, Erwin, C#.Net, XML, ADO.Net.

Confidential, Baltimore, MD

SQL Server Developer

Responsibilities:

• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Migrated the SQL server reports and cubes from 2005 to sql server 2008 edition.
• Created multi-dimensional cubes with different dimensions and measures in it using SSAS.
• Created SSIS packages to load data into SQL server from excel, flat files and using FTP.
• Written different T-SQL scripts for automated execution of the tasks.
• UsedMS ACCESS 2003 as an ETL tool, data loaded via VBA code to and fromMS Excel 2003 as a data entry tool on a weekly basis.
• Scheduled and executed different automated and manual jobs once the package is executed.
• Managed the Clustered environment databases and was fixing the errors when they arose.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers. Maintained
• Written complex stored procedures and functions and integrated it with the front end application.
• Data transfers between various servers using BCP, DTS and SSIS.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server.
• Assigned permissions to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Actively participated in User Acceptance Test (UAT) for various modules.
• Prepaid user manual and technical support manual.

Environment: MS SQL-Server 2008,2005, DTS, SQL Diagrams, Erwin, SSAS, SSIS, Windows 2003 Server, MS Access, Microsoft Analysis Services, T-SQL, Outlook, DTS, BCP.

Confidential, Manchester, NH

SQL Server Developer

Responsibilities:

• Analyzed the functionality, developed data model for Pharmacy Modules.
• Created Database, tables, relationships between tables, wrote Stored Procedures to insert the information of items received, issued, returned, and indents generated, expired items.
• Wrote Triggers to update the item status when item is issued, returned back from client, and sends a message when item goes below reorder level in stock.
• Implemented the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures
• Developed database objects such as DTS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL/PL SQL, SQL Analyzer and Enterprise Manager
• Created Database Maintenance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing and involved in Backup Operations.
• Created/reallocated database objects on appropriate file group to ease maintenance and improve data access performance.
• Wrote DTS Packages to transform daily and monthly jobs, like data on expired items, items below reorder level etc.
• Used SQL Server Profiler to trace the slow running queries and the server activity and with SQL performance tuning too.
• Analyzed and debugged jobs and procedures.
• Used Crystal Reports to generate ad-hoc reports.
• Worked on both Multidimensional OLAP and Relational OLAP.
• Used MS SQL Server reporting services to use daily report basis with client-server application.

Environment: Windows 2003, MS SQL Server 2005, SQL, T-SQL, SQL Query Analyzer, Profiler, Crystal Report 10.0., MS SQL reporting services

Confidential, Jersey City, NJ

SQL Server Developer

Responsibilities:

• Wrote Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored proc and maximized the readability of such Stored Procedures.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
• Created and managed users, roles and groups and handled database security.
• Added replication definition and its function on Reporting Server and monitored replication.
• Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and networking).
• Maintained database and Backup/recovery. Defined Database Maintenance Plan which was scheduled as job which ran automatically.
• Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table. Designed XML documents and generated XML documents from tables.
• Handled development and production support, document reviews, test plan, integration of the system.

Environment: MS SQL Server 2000, T-SQL, MS Excel, MS Access 2000, Visual Source Safe and Crystal Reports, Windows NT

Confidential

SQL Server Developer

Responsibilities:

• Wrote Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored proc and maximized the readability of such Stored Procedures.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
• Created and managed users, roles and groups and handled database security.
• Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and networking).
• Maintained database and Backup/recovery. Defined Database Maintenance Plan which was scheduled as job which ran automatically.
• Handled development and production support, document reviews, test plan, integration of the system.

Environment: MS SQL Server 2000 Enterprise Edition, Windows NT, Windows 2000 Professional for workstations, MS Access 2000, MS Excel, Visual Source Safe and Crystal Reports.