We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

AZ

PROFESSIONAL SUMMARY

  • 11 years of IT experience in analyzing requirements, coding, unit testing and providing post- implementation support.
  • Strong Technical Expertise in technologies like ASP.NET, C , VB.Net, Web services, Classic ASP, JavaScript, JQuery, SQL Server and MSBI SSIS, SSRS and SSAS .
  • Expertise in all the phases of Software Development Life Cycle SDLC including requirements, analysis, design, implementation, integration,testing, deployment, maintenance. Expertise in working with ADO.NET components such as Dataset, Data Adapter and Data Reader.
  • Experience with client side scripting technologies like JavaScript.
  • Excellent experience in creating consuming Web services over SOAP using C VB.NET.
  • Developed Data Access Layer DAL , Business Logic layer BLL also in implementing Business Processes, Abstract factory as part of Service Oriented Architecture SOA
  • Experience in designing GUI screens using usability and design principles.
  • Acquaintance in Windows Event Logging andAJAX using Agile Methodologies.
  • Experience in writing complex user defined Functions, Stored Procedures, Views, Triggers, and cursors using MS SQL Server 2000/2005/2008/2012 .
  • Experience in relational database design, data extraction, data transformation and loading from large and complex data sources using MS SQLServer.
  • Experience in using Microsoft Visual SourceSafe, Tortise SVN and TFS for Version Control.
  • Experience in XML related technologies including XML, XSD and XSLT.
  • TechnicAL SUMMARY
  • Internet Technologies: ASP.NET 1.1, ASP.NET 2.0, ASP.NET 3.5, WCF etc.,
  • RDBMS: MS Access, SQL Server 7.0/2000/2005/2008/2012
  • GUI: Visual Basic 5.0 6.0
  • Operating Systems: Dos, Windows 95/98/2000/XP, NT 4.0, Unix, Sun Solaris 5.6, Linux
  • Languages: VB.NET, C .NET, C, T-SQL, HTML, DHTML, VBScript, Java Script, AJAX 1.0, AJAX 3.5, XML, XSD and XSLT.
  • Web Designing Tools: Visual Studio. NET.
  • Web Servers: Win 2000 Advanced Server, IIS 6.0, Apache web server, Personal web server
  • Software Packages: MS Office
  • Case Tools: UML, Visio, Crystal Reports

CAREER SUMMARY

Confidential

Programming Languages: ASP.Net, C , JavaScript, CSS, SSIS, SSRS, SSAS and SQL Server

ROLES AND RESPONSIBILITIES:

  • Understood the technical business needs of the project through Business Rules.
  • Provided technical support for implemented applications, diagnosing and reporting bugs, applying patches and upgrades as needed
  • Design and developed multiple Master page, User controls, Ajax Toolkit for the ASP.Net pages and implemented them in various pages. The developed code versioning has been maintained using TFS VS-2012
  • For front end development used ADO.Net with C .Net, ASP.Net, AJAX Control Tool Kit and inline SQL queries / Stored procedures are used for the Back end process...
  • Provided database connectivity using ADO.Net and created procedures,Indexes and Triggers using MS SQL Server.
  • Involved in DBA tasks such as SQL Server Installation, Server configuration, database creation, schema handling, maintenance, and performance tuning and query optimization
  • Complete support has given in the Application deployment. Production support has given to various clients
  • Used .Net framework 4.0, n-tier architecture and Object Oriented Methodologies for application development.
  • Used Web Services to authenticate user's Implementing Role-based authorization
  • Extensively used Java Script for client side validations.
  • Design and developed Master page, User controls for the ASP.Net pages and implemented them in various pages.
  • Involved in the Unit Testing
  • Coordinated in the Data Migration

Confidential

Programming Languages: ASP.Net, C , JavaScript, CSS, SSIS, SSRS and SQL Server

PROJECT DESCRIPTION:

This Application deals in the area of Properties selling/buying. This application helps Realtors providing for them access to the County wise database and customized portals for their customers. After successfully logged in to the application that will give him permission specific access. Set of permissions are available in the application are Head Broker, Office Broker, Listing Agent, Office Agent and Outside User.The brokers or agents can do anyone of the following subject to their access levels like Add a listing, Search Listings, Close listing, Create open house, Open House Search, Generate reports and CMA Comparable Market Analysis

CLIENT DESCRIPTION

Confidential is the company financial services and real estate professionals turn to for comprehensive data, analytics and services. Powerful insight gained from this knowledge provides the perspective necessary to identify, understand and take decisive action that solves today's business challenges.

ROLES AND RESPONSIBILITIES:

  • Played significant role in the UI design and development.
  • Design and developed multiple Master page, User controls for the ASP.Net pages and implemented them in various pages
  • For the client validation Java Script has been used almost in every application.
  • Involved in developing WCF Web Service using SOAP/HTTP to communicate with legacy systems
  • Designed and developed the Cybicshop Core business logic in VB .
  • Provided technical support for implemented applications, diagnosing and reporting bugs, applying patches and upgrades as needed
  • Deployment or patching of applications via Cruise Control
  • Designed reports to generate statistics of material sent using SSRS.
  • Used the tables and stored procedures in the SQL server 2005 database along with SQL Reporting Services tools to generate reports.
  • Created WPF Windows Forms as the front end integrated on a touch screen.
  • Worked on parsing and editing XML documents by validating it to the schema using class libraries provided by .NET.
  • Designed, Developed Business Logic, Data Access COM Components in Visual Basic.
  • Used Data Grids, Data Sets, Data Views, Data Adaptors to extract data from the backend.
  • Wrote database adapter components in VB .NET.
  • Used SOAP protocol for creating web services.
  • Created class libraries containing code for business and data access logic using C .Net.

Confidential

Programming Languages: ASP.Net, C , JavaScript, CSS, SQL Server

PROJECT DESCRIPTION:

  • The Product comprises of hardware devices to capture and transfer the real time data of the transactions and Asset movement in the Ambulance. This data is worked upon to get the desired reports and alerts. The integrated system of the hardware devices and the software comprises the Asset tracking and Consumables supply chain management in Ambulance
  • This web application will be available to Fleet Admin and Supply Chain Manager. Fleet Admin will be able to view Assets and Consumables Reports and alerts about unaccounted Asset movement and will be able to add assets/consumables to the master tables. Both Fleet Admin and Supply chain manager will receive an alert for consumable replenishment.

ROLES AND RESPONSIBILITIES:

  • Created and Used Web User and Web Custom Controls
  • Involved in DBA tasks such as SQL Server Installation, Server configuration, database creation, schema handling, maintenance, and performance tuning and query optimization
  • Understood the technical business needs of the project through Business Rules.
  • Involved in gathering the requirements from client and in the analysis, design development of the project.
  • Developed the Business Logic using C .Net.
  • Extensively developed Web Services and consumed the services in the application.
  • Generated Stored Procedures, Modified Stored Procedures based on the client requirement.
  • Extensively used Java Script for client side validations.
  • Design and developed Master page, User controls for the ASP.Net pages and implemented them in various pages.
  • Involved in the Unit Testing
  • Coordinated in the Data Migration
  • Complete support was given in the Application deployment.
  • Used HTML, DHTML and CSS for developing Web Pages.
  • Designed CSS aiming for a rich personalization of server side controls.Involved in developing WCF Web Service using SOAP/HTTP to communicate with legacy systems.
  • Analysis of Defects faced in the project and to keep track of defects using SDLC

Confidential

Programming Languages: ASP.Net, C , JavaScript, CSS, SSIS, SSRS and SQL Server

PROJECT DESCRIPTION:

Confidential is to generate trip sheets for the vehicles with AVLT equipment, based on the operation performed on the switch panel of AVLT instrument.

ROLES AND RESPONSIBILITIES:

  • Generation of Trip Sheets in the FMS database and to be viewed from the FMS application.
  • Provide the user with the Detailed Trip Sheet Report, Summary Report Enhancement and Trips Report sorted by Kms Covered / Distance Covered .
  • Created help documentations for all the applications in HTML
  • Scheduled project plan, created software requirements specification for the entire project
  • Deployment or patching of applications via Cruise Control
  • Implemented input validation using the ASP.NET Input Validation Controls
  • Developed the Business Logic using and VB .NET and C .Net.
  • Extensively developed Web Services and consumed the services in the application.
  • Involved in DBA tasks such as SQL Server Installation, Server configuration, database creation, schema handling, maintenance, and performance tuning and query optimization.
  • Implemented client side validations using Java Script.
  • Design and developed Master page, User controls for the ASP.Net pages and implemented them in various pages.
  • Worked extensively with jQuery to make Ajax calls for partial page execution and jQuery plugins to develop various UI functionalities.
  • Designed and developed CSR portal for Modern Greetings customer service representatives to manage orders.
  • Involved in bug fixing, debugging, and troubleshooting of the application. Provided technical assistance and support to customers in a professional manner while working with other members of a team to maintain the application interface, and architecture of the web application.

Confidential

Programming Languages: ASP.Net, C , Classic ASP 3.0, JavaScript, HTML, CSS, SQL Server

PROJECT DESCRIPTION:

1 .Confidential is an acronym for Safety Tracking and Reporting. Confidential is a web-based internet version of the SPAM program that historically has been a paper or Microsoft Excel based program. The web version allows for improved flexibility, visibility and overall program management.

2 .Safety Managers and other employees can electronically record the essential information relating to an accident or other incident, and rollup all of these records for reports to management or for analysis of root causes and other research. A priority report can be created immediately after an incident, and subsequent details and investigation results can be added later. The 'action matrix' component of this module enables the administrator to assign specific follow up, corrective and preventative actions to individuals, and then track these tasks to completion.

ROLES AND RESPONSIBILITIES:

  • Understood the technical business needs of the project through Business Area Requirements BARR , Business Specification Document BSD and Technical Specification Document TSD .
  • Web service development using Node.js and C using VS
  • Extensive experience in developing reports using Crystal Reports, MS Access reports, Entity Framework and SQL Server Reporting Services SSRS
  • Windows application development using VB, VB.Net, C .
  • Developed one project module in MVC3 using Entity Framework Model-First approach Worked on Controller actions, filters, custom validations etc
  • Development of UI and Server side code behind using .Net Framework
  • Used SVN, Codesion as source control Configuration Management
  • Used CruiseControl.Net for building and uploading the project into test and production.
  • Prepared Architecture document, design document using Microsoft Visio
  • Web Application development using VB, C , VBScript, JavaScript and Actionscript/FLEX
  • Understanding and analyzing the client's requirement and involved in GUI designing of the application.
  • Designed, Developed Business Logic, Data Access COM Components in Visual Basic.
  • Used Data Grids, Data Sets, Data Views, and Data Adaptors to extract data from the backend.
  • Wrote database adapter components in VB .NET.
  • Used SOAP protocol for creating web services.
  • Created class libraries containing code for business and data access logic using C .Net.
  • Implemented Forms-based Authentication in ASP.NET to authenticate the users.

Confidential

Programming Languages: ASP.Net, C , JavaScript, SQL Server

PROJECT DESCRIPTION:

  • Employees on a periodic basis for a predefined set of activities that they need to complete before the specific due dates set for each of them. User's performance will be calculated based on the completion of the activities within the prescribed due dates.
  • Various analyses in the form of grids and charts were developed to make the analysis easy for the management.

ROLES AND RESPONSIBILITIES:

  • Understood the technical business needs of the project through Business Area Requirements BARR , Business Specification Document BSD and Technical Specification Document TSD .
  • Developed user interfaces using ASP.Net, C , JavaScript.
  • Used ASP.NET web form controls such as GridView, ListView, etc. for displaying data.
  • Developed Webservices using C .
  • Involved in implementing the logic using C and oops concept.
  • Extensively used ASP.NET, C .NET Validation Controls and JavaScript for client side validations in the Web Pages.
  • Involved in testing, client Handling, Data Migration.
  • Involved in database design like writing queries for report generation
  • Involved in complete System Development Life Cycle
  • Prepared SQL Queries and written Stored Procedures and Database triggers in Oracle
  • Database created in Oracle.
  • Used ADO for retrieval of data from the backend Oracle.
  • Helped in the generation of forms for the application in Visual Basic for the stand-alone application.
  • Involved in implementing the logic using C and oops concept.
  • Extensively used ASP.NET, C .NET Validation Controls and JavaScript for client side validations in the Web Pages.

Confidential

Programming Languages: Visual Basic, SQL Server

PROJECT DESCRIPTION:

This Project was developed for a Medical Diagnostic Center. The main objective of this project is to automize all the activities in a Diagnostic Center viz., Counseling about the Tests, Patient Registration, Payment Handling, Test Report Generation, Report Delivery, Stock Maintenance, Personal Management, Equipment Maintenance, Marketing etc. To increase the efficiency in its services the process need to be Automized. With slight modifications and changes, the system can be adopted to other organizations also. With the help of Computers, the processing of official work is easier with short duration, less man power and with accurate information.

ROLES AND RESPONSIBILITIES:

  • Understood the technical business needs of the project through Business Area Requirements BARR , Business Specification Document BSD and Technical Specification Document TSD .
  • Design and development of Windows Forms and using data binding for the controls using both the designer and manually in the code.
  • Designing and Creating Typed Datasets to store, manipulate, and using both Datasets and Data Reader to gather and manipulate data from the database.
  • Development of the application using n-tier distributed architecture.
  • Design and Developing crystal reports using Visual Studio
  • Design and Development of database using SQL SERVER including creation of Stored Procedures, user defined functions, and triggers.
  • Development of the application as n-tier distributed architecture.
  • Using and configuring the IIS application server.
  • Creating the setup program in VB for installing and deploying the application and used merge modules setup program to deploy other related components.

Hire Now