We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

Summary

  • 10 plus years of experience in IT industry, as Database Developer.
  • Experienced in Database Design, Development, Maintenance and Administration on SQL Server 2000/2005/2008 R2/2012.
  • Experienced in Installation, Upgrade and Configuration of Microsoft SQL Server 2000/ 2005.
  • Expert level skills in Data Modeling, Data Mapping, and Database Normalization using RDBMS Concepts and Constructs.
  • Very good understanding of Business Processes and Data warehouse concepts.
  • Expert level skills in creating Tables, Views, Indexes, Stored Procedures, Cursors, CTE, Triggers.
  • Proficient in Tuning, Maintenance and Optimization of Database using various SQL Server tools SQL Server Profiler, Index Tuning Wizard .
  • Experienced in data Extraction, Transformation and Loading ETL between Homogenous/Heterogeneous System using SQL tools SSIS/DTS , Import/Export Wizard .
  • Experienced in creating Report Models, generating Ad hoc Reports, Scheduled Reports for business analysis and management purposes using SQL Server Reporting Services SSRS .
  • Creating and publishing Reports on Share Point 2007/2010.
  • Excellent knowledge of all the phases of Software Development Life Cycle SDLC .
  • Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
  • A Well-Organized, Goal Oriented, Highly-Motivated Effective team player with excellent Analytical, Troubleshooting, and Problem Solving Skills.

TECHNICAL SKILLS

  • RDBMS/DBMS: MS-SQL Server 2000/2005/2008 R2/ 2012, Oracle 7.x/8.x/9i, MS Access, DB2.
  • Database Technologies/Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Server Management Studio SSMS , SQL Profiler, SQL Configuration Tools, SQL Server Business Intelligence Studio BIDS , Visual Studio 2005/2008, Red Gate.
  • Analysis Services: Data Transformation Services DTS , SQL Server Integration Service SSIS . Reporting Services: SQL Server Reporting Service SSRS .
  • Operating Systems: Windows 7, Vista, XP, 2000, NT, 98 SE, MS DOS, UNIX.
  • Servers: Windows 2000, 2003, NT, SharePoint Server 2007.
  • Application Servers: IIS, PWS.
  • Programming Languages: T-SQL, Java, VB.Net, C, C , PL / SQL, XML.
  • Web Technologies: VBScript, Java Script, HTML, Microsoft FrontPage.
  • Data Modeling Tools: MS Visio, ER-Win.
  • Version Control Tools: PVCS, Serena Dimensions

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer

Centre for Health Care Financing CHCF is a division of University of Massachusetts Medical School.

  • Analyze data, Claims Files 837, 835 .
  • Create Conceptual, Logical and Physical Model to persist Claims data.
  • Create Stored Procedures, Functions to support the Claim Search feature of the CBE Consolidated Billing Environment.
  • Designed/Re-Factored data model to accommodate different Programs.
  • Gathered requirements to Reconcile Claims for various Programs.
  • Created Stored Procedures, User Defined Functions, Views to accommodate different reconciliation methods per different programs
  • Involved in Production Support by analyzing the issues using SQL PROFILER and fixing the bugs.
  • Designed and maintained Security for the application, driven by the Database.
  • Create Users give appropriate access and permissions as per different Programs in CBE.
  • Back-up and Restore database to different environments.
  • Promote code to different environments using TFS Team Foundation Server .
  • Designed, Developed and Created Reports and Scheduled to be uploaded to SharePoint.
  • Created SSIS Package to trigger SSRS Report thru Web Reference, connect to SharePoint thru Web Reference in C and upload the report extract on to SharePoint.

Environment: SQL Server 2012, SQL Server Data Tools 2010 SSDT , Windows 7, T-SQL, C , Team Foundation Server TFS .

Confidential

Database Developer

  • OneBeacon Professional Insurance is specialty insurance, operating subsidiary of OneBeacon Insurance Group Ltd. They specialize in Health Care, Management Liability, Professional Liability, Design Professional Liability, Technology Professional, etc.
  • Interacted with the business users to gather requirements.
  • Designed, developed and debugged Stored Procedures, User Defined Functions, and Views.
  • Upgrade SSIS 2005 package to SSIS 2008 R2.
  • Enhanced/Upgraded SSRS 2005 reports to SSRS 2008 R2.
  • Analyzed, designed, created, tested and deployed Reports as per user requirements using SSRS.

Environment: SQL Server 2005/2008 R2, Windows 2003, Microsoft Business Intelligence Studio, T-SQL, SSRS, SSIS, VB.NET, SharePoint Server 2007,PVCS, Red Gate.

Confidential

Report Developer

  • Wholesale Technology group of the bank.
  • Created/refactored reports to accommodate graphs, RTF data in SSRS 2008 R2.
  • Troubleshoot Stored Procedures, UDFS, etc.
  • Created Indexes to improve performance of the .Net based front end.
  • Involved in Production Support.
  • Used SQL PROFILER to trace and enhance the performance.
  • Created Indexes and performed Index Tuning using Index Tuning Wizard for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Environment: SQL Server 2005/2008 R2, Windows 2003, Microsoft Business Intelligence Studio, T-SQL, SSRS, SharePoint Server 2007.

Confidential

Database Developer

Confidential a leading global provider of insurance, annuities, etc. It provides services across U.S.A. and over 60 countries through its subsidiaries and affiliates. Confidential purchased ALICO, a subsidiary of former AIG.

Responsibilities:

  • Gathered business requirements.
  • Designed and developed mapping documents to map the fields to the existing structure in MetLife.
  • Created and modularized the existing Stored Procedures.
  • Enhanced the performance of the existing database Objects like Stored Procedures, Functions by tuning.
  • Analyzed and resolved production issues within stipulated time frame.

Environment: SQL Server 2000/2005, Windows 2003, Microsoft Business Intelligence Studio, BugZilla.

Confidential

Report Developer

Responsibilities:

  • Gathered business requirements for the reports to be generated.
  • Created mapping documents by comparing the Business Objects Universes with the current databases on Oracle or SQL SERVER 2008.
  • Created Training Documents on Report Builder 2.0/ 3.0 for Business Users.
  • Conducted Training Sessions on using Report Builder 2.0/3.0 sourcing SQL SERVER ANALYSIS SERVICES CUBES / Report Models and Excel Services.
  • Replicated the Business Objects Universes in Report Model using SQL SERVER 2008.
  • Generated Report Models sourcing Oracle databases.
  • With Report Model as data source, created ad hoc reports using Report Builder 2.0/3.0.
  • As part of different source requirements for different departments, created reports with DB2, Oracle, SQL SERVER 2008 as the data source.
  • Contributed to the creation of Reporting Standard Style Guide as per the standards of CareFirst.
  • Designed reports using Report Builder 3.0 by joining multiple Data Sets from multiple Data Sources Oracle, DB2, .txt Files .
  • Developed and published ad hoc reports on to Share Point.

Environment: SQL Server 2008, Windows 2003, DB2, Oracle, Microsoft Business Intelligence Studio, Report Builder 2.0/3.0, SSRS 2008, Business Objects, Share Point Server 2007, Serena Dimensions, Excel Services.

Confidential

ETL/ Report Developer

  • OneBeacon Professional Partners, now known as OneBeacon Professional Insurance, is specialty insurance, operating subsidiary of OneBeacon Insurance Group Ltd. They specialize in Health Care, Management Liability, Professional Liability, etc.
  • NorthStarDM the database is a one stop place for all the in-house needs of business users. It is a data store for complete information about policies, pertaining to all the sources and different specialty areas.

Responsibilities:

  • Interacted with the business users to gather requirements.
  • Designed, developed and debugged Stored Procedures, User Defined Functions, and Views.
  • Traced and enhanced the performance of Stored Procedures, User Defined Functions by using Performance Tuning Tools.
  • Designed, re-factored, created, configured , scheduled SSIS Packages from different sources like Flat Files, .Dat Files, .CSV Files and Excel Files in different environments.
  • Created Command Files and SSIS Configuration Files for different environments.
  • Analyzed and designed the Script Components in SSIS Packages using VB.NET.
  • Designed and implemented error handling at different levels using Stored Procedures, Table Valued Functions, SSIS Packages, etc to feed the down stream systems.
  • Designed, created Reports using SSRS and published them on to SharePoint 2007 Server.
  • Analyzed and created a process for Policy and Claims to put SOX Compliance Controls in-place for audit.
  • Responsible for monitoring, supporting and troubleshooting Production issues.
  • Used Red Gate Tools to maintain database consistency across environment.

Environment: SQL Server 2000 /2005/2008, Windows 2003, Microsoft Business Intelligence Studio, T-SQL, SSRS, SSIS, VB.NET, MS Access, MS Excel, SharePoint Server 2007,XML, PVCS, Red Gate.

Confidential

SQL Server Developer

Acuity Point is a Business Web Solutions company providing Custom Application Development, E- Commerce Solutions and Database Integration and Reporting Services to the clients. The scope of this project involved complete logical and physical design of a database. Sales Automation Inventory Management involved design, development of database application, implementations, data cleansing, disaster recovery strategies, migration of databases, implementing SSRS and SSIS.

Responsibilities:

  • Configured and installed SQL Server 2005 on Windows 2003 Server.
  • Conducted Performance Tuning to improve the performance of slow running queries and Stored Procedures, using SQL Server Profiler to trace the slow running activities.
  • Developed and debugged Stored Procedures, Views, Triggers and User Defined Functions to handle complex business rules.
  • Planned, designed and managed the migration of SQL Server 2000 databases to SQL Server 2005.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Migrated data from legacy system text based files, Excel spreadsheets, and Access to SQL Server 2005 databases using SQL Server Integration Services SSIS .
  • Set up and configured Report Server.
  • Created Reports using Report Designer and set up access from ASP.NET Web Applications in Visual Studio 2005 for authorized personnel.
  • Developed Report Models as per the requirements and generated Ad hoc Reports using SQL Server Reporting Services SSRS .
  • Generated Drill Through, Drill Down, and Ad hoc Reports.

Environment: SQL Server 2000 /2005, Windows 2003, Microsoft Business Intelligence Studio, Java, T-SQL, SSRS, IIS, SSIS, VB.NET, Visual Studio 2005, MS Access, MS Excel.

Confidential

SQL Server Developer

Responsibilities:

  • Installed and Configured SQL Server 2005.
  • Created Logical Model using MS Visio.
  • Configured the Window Server upgrading required Service Packs.
  • Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio SSMS and T-SQL statements to implement complex business logic.
  • Created and implemented Constraints and Checks on the Database Objects to maintain Data Integrity.
  • Designed and migrated all Data Transformation Services DTS Packages to SQL Server Integration Services SSIS and modified the packages accordingly.
  • Recreated and reconfigured DTS packages in SSIS.
  • Created Stored Procedures, User Defined Functions and improved efficiency by critically evaluating the code and optimized the slow running queries by using Query Optimizer.
  • Increased query performance by monitoring performance, tuning and Optimizing Indexes tasks by using Performance Monitor, SQL Server Profiler and Index Tuning Wizard.

Environment: SQL Server 2000/2005, SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , Windows XP, MS Excel, MS Access, MS Visio.

Confidential

SQL Server Developer

Responsibilities:

  • Gathered business requirements by interacting with the Business Analysts.
  • Installed, configured and maintained MS SQL Server 2000.
  • Designed logical Data Model using ER-Win to fit business requirement.
  • Created Database and implemented Normalization.
  • Performed data conversion from Flat File, MS Excel and MS Access into Normalized database structure.
  • Developed Database Objects such as User Defined Functions, Tables, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
  • Converted complex business logic into SQL Stored Procedures and User Defined Functions to achieve functionality required by the UI team.
  • Created Triggers to enforce Data Integrity and Referential Integrity.
  • Performed data transfer import export using BCP.
  • Developed Backup and Restore Scripts for SQL Server 2000.
  • Used in Enterprise Manager for Job Scheduling.

Environment: SQL Server 2000, ER-Win, T-SQL, Windows NT, ASP.NET, VB Script, JavaScript, DTS, Excel, Access, Microsoft Visual Studio 2005.

Confidential

SQL Developer/DBA

Responsibilities:

  • Successfully implemented Logical Data Model into Physical Data Model.
  • Designed and implemented the system with Microsoft SQL Server 2000.
  • Installed, configured and maintained SQL Server 2000 with regard to the requirements.
  • Created Database Schema, Database Objects and Normalized database.
  • Transformed complex business logic into Stored Procedures, User Defined Functions UDF , Triggers, Cursors, and Views.
  • Created and modified Clustered and Non Clustered Indexes to optimize the queries using Index Tuning Wizard.
  • Created DTS packages to transfer the data from the old system to the staging area.
  • Successfully performed ETL process by pulling large volumes of data using DTS, BCP into the staging database from various data sources like MS Access, Excel.
  • Performed the Transformation of the data using Transform Task in DTS.
  • Handling database objects with Enterprise Manager and Query Analyzer.

Environment: SQL Server 2000 ,Query Analyzer, Enterprise Manager, DTS Designer, MS SQL Reporting Services, SQL Profiler, Index Tuning Wizard, Windows XP, MS Excel, MS Access.

Hire Now