We provide IT Staff Augmentation Services!

Sql Server Developer Resume

5.00/5 (Submit Your Rating)

Summary:

  • Over 7 years of Professional IT experience in developing Data Warehouse, client/server, N-Tier, Web-Based and Windows Applications using SQL Server 2000/2005, SSIS, SSRS, SSAS and .Net framework
  • Technical expertise includes Asp.Net, C#, Vb.Net, Ado.Net, SQL server, T-SQL, PL/SQL for standard client/server and web based applications
  • Proficient in SQL Server developing Stored Procedures, Triggers, Cursors, T-SQL Statements, User Defined Functions and Views.
  • Expert in designing and developing SQL server Reports using SSRS 2005 and Crystal Report 2008.
  • Expert in creating the cubes and dimensions. Strong experience in defining Referenced relationships in SSAS.
  • Worked on administration tasks such as batch jobs, backup & Recovery, creating databases/File groups/files/Transaction logs.
  • Experience in writing complex formulas in crystal reports, SQL queries using Crystal Designer, migration of Crystal reports in different versions.
  • Excellent T-SQL Programming, query optimization and performance tuning.
  • Experienced in creating DTS and SSIS packages to transfer data from heterogeneous databases and different files format (Text File, Spread Sheet) to SQL Server.
  • Experience in developing applications using WebForms and Win Forms
  • Proficient in developing User Interfaces (UI) employing HTML, DHTML and Asp.Net
  • Used Version Controlling tools such as Visual Source Safe (VSS) and expertise in Visual Studio .Net 2005/2003 (Ver. 2.0, 1.1).
  • Excellent skills in developing code for the database applications to interact with the databases, having extensively used the Ado.Net with SqlClient, Oracle Client, Oledb, and ODBC using Connection Object, Command Object, Data Reader Object, Dataset Object, Data Adapter, Grid View, Details View, Form View.
  • Experienced in producing Excel, RTF, HTML and PDF formatted files using SAS /ODS to produce ad hoc reports for presentation and further analysis.
  • Experience in all stages of software development life cycle (SDLC), including requirements analysis, design, development, testing, implementation, release, production support and documentation.
  • Good organizational skills, ability to handle multiple tasks and work independently as well as in a team.
Technical Skills:
  • SQL Server 2000/2005 , MS BI (SSIS/SSRS/SSAS), C#, Asp.Net, MS.Net 2.0, Vb.Net, Ado.Net, DTS, SAS, Profiler, OLAP, OLTP, ODBC/OLEDB, Multidimensional Expressions (MDX), Oracle 9i/8i with Developer 2000, IIS 6.0, Vb 6.0, JavaScript, Visual Studio.Net 2002/2003/2005, Visual Interdev 6.0, Visual Source Safe 6.0, Unix, Linux, XML, HTML4.0, XHTML1.0, CSS, Front page 2003,MS-Office, Windows /95/98/NT/2000/2003/XP FTP, VISIO, Erwin, Crystal Reports10.

Experience:

Confidential, Pennsauken, NJ January 2009 – Till Now
Web Developer /Report Developer

This is Ecommerce project. The BIH utilizes this web application to manage its wood flooring throughout the state. I am executing projects for several of their clients. All projects were made in ASP.Net(C#). Besides the usual responsibilities of coding and developing systems, I am also leading teams of 2-4 towards timely completion of the projects, working with clients regarding business requirements and design and brought further business to the company. A windows service enables data to be pulled from the database to Crystal Reports, an online accounting solution. Admin and Sales people can then manage customer relations.

Responsibilities:

  • Researched and documented the proposal, prepared requirements, estimated the projects. Also conducted interviews with the clients on the open issues in the project.
  • Conducted analysis regarding the project and open issues to come out with approach to develop the project.
  • Designing and developing user interfaces in C# / ASP.NET.
  • Communicated on day to day basis with client on the project about the release of project, open issues, testing and conformation of functionality.
  • Used SQL Server 2005 management studio database as backend for writing queries, stored procedures, triggers and views.
  • Performed database tasks like CREATE, DELETE, UPDATE & SELECT. Prepared script files for the projects.
  • Specialized in creating crystal report using universe as a data source.
  • Communicated with all levels of the team to accomplish the tasks assigned.
  • Developing Crystal report for transferring the data from SAP Business one.
  • Used BugTracker.NET to track IT requests and the enhancements to the project and related issues that are raised in testing and production.
  • Developed SQL Server Stored procedures and SSRS to extract data from database.
  • Created the cubes and dimensions. Defined Referenced Relationships with the measure groups and fact tables.
  • Developed SSIS project for transferring the data.
  • Developed complex T-SQL code for the application.
  • The data in Legacy systems is extracted, transformed and loaded into Data mart using ETL tool SSIS.

Websites:Confidential

Environment: ASP.Net, VSS, VS 2003/2005/2008, HTML, C#, JavaScript, XML, XSL, CSS, .NET 1.1/2.5,Microsoft Web Expression 2, SQL Server 2000/2005/2008, SSRS, SSIS, Photoshop, VSS, Office 2007 bundle, Windows XP, Windows 2003 Server, SAP-Business one, Crystal Report 2008.

Confidential, Norwalk, CT July 2008 – December 2008
SQL Server Developer (SSIS & SSRS)

One of the major applications provides finance and operations with consistent views of their business in a timely manner to enable rapid decision-making. It also provides the measurement of key performance indicators to drive their business in an effective and consistent infrastructure. This automates the data mining from various data sources, combined and displayed to the user resulting in an efficient, accurate and consistent process.

Responsibilities:

  • Installed and Configured SQL Server 2005, Integration Services (SSIS) and Reporting services (SSRS) for Dev and Production environments.
  • Developed and deployed data transfers packages using SSIS also maintained the jobs running on Servers
  • Involved in creating, deploying and configuring reports according to the requirements using SSRS.
  • Used Dundas add-in for reporting. Created dash-board, ad-hoc reports.
  • Developed complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Migration from SQL server 2000 to 2005 using the upgrade advisor.
  • Installed and maintained Windows SharePoint Services (WSS 3.0), Project server 2007.
  • Created workspace and sites on SharePoint and Project server.
  • Integrated reporting services with SharePoint and deployed reports.
  • Used Table partition on large tables for better performance.

Environment:
SQL Server 2000/2005/2008, SSRS, SSIS, VSS, Office 2007 bundle, Windows XP, Windows 2003 Server, project server 2007, Windows SharePoint Services (WSS 3.0)

Confidential, Cleveland, OH October 2007 – June 2008
Sr. Programmer Analyst (SQL Server/SSIS/SSRS and .Net)

Insurance and Financial Services:
Designed and developed a windows based application for affiliates of John Hancock Insurance and Financial Services to manage and maintain the commercial insurance policies.

Responsibilities:

  • Responsible for collection & analysis of requirements, co-ordinate meetings & code-reviews.
  • Responsible for Design of Data Model, Data Flow, Entities & Relations, Creation of Logical & Physical Database Structures.
  • Responsible for system, database and presentation layer architecture.
  • Extensively used .Net Framework classes Asp.Net controls and XML/XSL, Ado.Net.
  • Identified the data source and defined them to build the data source views.
  • Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Developed SSIS packages not only for Initial Data Loads but also for incremental/delta loads.
  • Created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
  • Designed and developed several Reports using SSRS (SQL 2005 reporting services) according to business requirements.
  • Designed and created drill down reports in SSRS 2005.
  • Identified and worked with parameters for parameterized reports in SSRS 2005.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
  • Scheduled jobs and alerts. Tested applications for performance, data integrity and validation issues.
  • Performed comprehensive technical documentation.

Environment:

SQL Server 2005, SSIS, SSRS, SQL Server Management Studio, Visual Studio, .Net, Asp.Net, C#, Ado.Net, Microsoft Visual SourceSafe, MS Visio, MS Office 2003, Windows XP, Microsoft Product Studio, XML/XSL.

Confidential, Cleveland, OH December 2006 – September 2007
Sr. Programmer Analyst (SQL Server & .NET)
Provider Analysis and Scoring System (PASS): The Medical Mutual of Ohio (MMO) utilizes this web application to manage its medical and drug claims history throughout the state. The PASS system is a full-featured database system that aids MMO employees in the storage and retrieval of information about its claims. Based on this data, numerous data marts are designed and developed using SSIS. Data cleansing will be done at Hub level and transformed and then loaded into Warehouse. The application was originally created as a desktop application and has now re-implemented as a web-based platform.

Responsibilities:

  • Transformed business/functional requirements to technical requirements
  • Implemented Business Logic using C#, .Net.
  • Design and developed applications including UI Layer, Business Layer and data layer
  • Used Ado.Net for data access from SQL Server 2005
  • Database creation, database tuning, performance planning, backup planning and database administration
  • Designed and developed the required stored procedures, triggers and database functions using T-Sql.
  • To store XML data in a table.
  • Created the cubes and dimensions. Defined Referenced Relationships with the measure groups and fact tables.
  • Added roles to the cubes, defined the MDX calculations and sub cube calculations.
  • Enabled the cube drill through, Connected the cubes from excel.
  • Created an OLAP data-mining model using Microsoft clustering and a relational data-mining model using Microsoft decision trees.
  • Managed dimension member and cell level security. Created the SSIS packages and scheduled them.
  • Implemented the calculations to aggregate physical measures.
  • Developed SSIS project for transferring the data.
  • Developed complex T-SQL code for the application.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery
  • Involved in System testing. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Extensively used Ado.Net to access and retrieve or manipulate data from SQL Server 2005 database.
  • Prepared and maintained mapping specification documentation.

Environment:
SQL Server2005, Windows 2000, Visual Studio.Net 2.0. Windows 2003, MS SQL Server 2000/2005, Asp.Net, C#, .Net, Ado.Net, Vb.Net, Analysis Services (MSAS/SSAS), Microsoft Reporting services 2000/2005, MS Excel, Window XP, MS Word Microsoft Visio & MS Outlook.

Confidential, Jersey City, NJ January 2006 -November 2006
SQL Server & .NET Developer

Stock Investor Repository (SIR): contains the details of the stockholders of a company. Stockholder can hold stocks in the form of physical stock certificates or electronic stocks. This was the source to develop the target data mart. This data mart maintained historical data for Integration, analyzed Business in different locations. Application gives the statistical and graphical details of each stockholder and category wise top stock holders, Distributions scheduling of stock holders and Annual distribution Scheduling of Stockholders. Application helps in viewing the transaction of stocks and generates reports for each category.

Responsibilities:

  • Developed SQL Server stored procedures, functions and triggers as part of various modules.
  • Involved in logical & physical design, development and testing of the system.
  • Developed complex T-SQL code for the application. Implemented constraints on tables.
  • Responsible for creation and web publishing of reports using SQL Reporting Services in different formats (Excel & PDF).Worked on complex data loading (implemented the batch data cleansing and data loading).
  • Maintained long term data integrity and consistency by tightly implementing various data consistency check routine in backend using various levels of constraints and triggers.
  • Developed SQL Server Stored procedures and DTS packages to extract data from database.
  • The data in Legacy systems is extracted, transformed and loaded into Data mart using ETL tool SSIS.
  • Used DTS Import / Export Wizard, DTS Designer and other package execution utilities for performing the ETL operations.
  • Interacted with different departments regarding their access to the database system and creating views to facilitate the same.
  • Extensively worked on creating Window Forms using server controls and user controls.
  • Improved website performance, reduced page size, optimized template and streamlined website design using web standards and CSS (Cascade Style Sheet) to facilitate user’s requirement.
  • Involved in the weekly builds and monthly releases.
  • Worked with OLEDB technology to read data from various data Sources.
  • Utilized Ado.Net technology extensively for data retrieving, querying, storage and manipulation

Environment:
MS SQL Server 2000/2005, Windows XP, IIS 5.1, MS Visio, MS Reporting Services, writing store procedure, triggers and T-SQL queries and Windows NT/XP, C#, Asp.Net, Ado.Net, Visual Studio.Net 2003, .Net Framework 1.1, Microsoft Visual Source Safe (VSS), Cascading Style Sheet (CSS), HTML, DHTML, Java Script, Xml.

Confidential, Schenectady, NY. March 2005 – December 2005
Programmer (SQL Server & .NET)

Project was to develop an application, which is used in pre-processing Health Care claims. It allows users to search the company data repository through web. Then, the data is displayed in a summary or detailed view. Further, the application is designed to function in stand-alone mode and can be accessed through other web applications.

Responsibilities:

  • Performed data validation and aggregation.
  • Wrote stored procedures, triggers, custom functions, and constraints to ensure data integrity, data consistency and to meet the business rules.
  • Responsible for creation and web publishing of reports using SQL Reporting Services in different formats.
  • Responsible for writing Stored Procedures using T-SQL perform database activities.
  • Developed the Business Layer & UI Layer Components using Vb.Net.
  • Performed Bulk insert from one table to another across database using SSIS Packages.
  • Tuned SQL statements and Stored procedures. Used query analyzer to optimize queries.
  • Designed and implemented DTS package for data transformation and migration
  • Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers.
  • Transformed data from various data sources using OLEDB connection by creating various DTS packages.
  • Performed data cleaning, dataset merging, system modeling, and statistical analysis.
  • Created SAS output in RTF and HTML formats.
  • Developed extract views and SAS data extract from clinical data management system
  • Provided programming perspective on activities such as protocol and CRF review and SAP (Statistical Analysis Plan) review.
  • Responsible for generating error logs using XML.
  • Created XML files for presentation and transferring Data.

Environment:
MS SQL Server 2000, SAS/Base, SAS/Access, SAS/Macros, SAS/Graph, SAS/Stat, Query Analyzer, Enterprise Manager, C# .Net , Windows 2000/2003, SQL Profiler, DTS, T-SQL, BCP, Web Services, Asp.Net 1.0, C#, UML, XML, CSS.

Confidential, Singapore January 2004 – February 2005
Programmer Analyst (SQL Server & .Net)

Marine Survey System (MSS): Survey Database, Job Order Processing, Statistics and Analysis Report System covering generation of reports on survey and company’s overall performance for analysis, Job Tracking, Preliminary Report, Final Report, Email Sending. The user will be able to understand how the features of the new system can be effectively deployed to improve the user’s operational and functional efficiency.

Responsibilities:

  • Extensively used Data grids, Data Tables and Datasets for Data manipulation
  • Created stored procedures, triggers, views for data access and manipulation
  • Extensively used HTML, DHTML, CSS to design various Graphical User Interfaces (GUI)
  • Designed databases using normalize method, delivered optimized, complex and complicated stored procedure triggers and also helped other developers on creating more effective stored procedures.
  • Involved in database maintenance like differential and log backup / restore, checking / rectifying bad index on tables (using DBCC), etc on large database.
  • Created table partitioning (Vertical and horizontal) to improve process speed.
  • Created clustered, non-clustered and unique indexes for better query performance
  • Extensively used DTS packages to import data from different sources like flat file, XML file and FoxPro tables.
  • Designed and developed Supporting database tables and indexes.
  • Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
  • Automated most of the jobs (which in turn used DTS, T-SQL, Stored procedures)
  • Created and Modified Existing stored procedures in SQL SERVER and used them for Insert, Update, Delete & retrieve the data
  • Involved in Unit Testing of the developed Code before deploying
  • Used Data Grid Controls for displaying the data in a customized template

Environment: SQL Server 2000, Asp.Net, C#, .Net, Ado.Net, Xml, IIS 6.0, Visual Studio.Net 2003, Crystal Reports 10, Visual Source Safe 6.0 and Windows 2003.

Confidential, India September 2002 – December 2003
SQL Server Developer

The Project involved in analysis, technical design, program design and production implementation tasks like Software Installation, Database Performance Tuning & Maintenance, Database Back up and Recovery, Export/Import of Data, Replication.

Responsibilities:

  • Involved in system study and database designing. Implemented the SQL login security for developers and users.
  • Involved in Creation of Schema Objects, rules and granting of roles to the users.
  • Created separate operational data marts for financial transactions done regularly basis
  • Maintained backups for the databases.
  • Installed SQL Server 2000 in Windows 2000. Responsible for Creation of database objects.
  • Designed and created stored procedures and triggers according to the requirement
  • Created views consisting of computed columns to facilitate easy user interface.
  • Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
  • Worked on Disk space, memory management and user connections.
  • Created functions used cursors for complex queries.
  • Created DTS packages for the loading the data. Rebuilt indexes on various tables.

Environment: SQL Server 2000, Transact-SQL, Excel, Windows 2000 Server.

Education:

Master of Computer Application
Bachelor in Commerce

We'd love your feedback!