Post Job Free

Resume

Sign in

Sql Server Management

Location:
Jacksonville, AR
Posted:
September 29, 2015

Contact this candidate

Resume:

SUMMARY OF EXPERIENCE:

Over **+ years of experience in System Analysis, Design, development and implementation of software for various commercial applications with experienced with complete software life cycle Development using Microsoft.Net Technologies.

Strong .NET experience using ASP.NET 2.0/3.5/4.5, VB.NET, MVC 3/4 architecture, ADO.NET, Microsoft Visual Studio 2003/2005/2008/2010, .Net Framework 2.0/3.0/3.5/4.0/4.5, C#, Web Forms, Win Form, windows applications and Web Services.

Extensive knowledge and hands-on experience in Installation, Configuring, Developing, Migrating and Administrating Microsoft SharePoint Server 2010 and SharePoint Designer.

Expertise in Database Development and working on Microsoft SQL Server 2012/2008/2005, MS SQL, SSIS, SSRS (SQL Reporting Services and data extraction) and T-SQL.

Experience in developing T-SQL queries, function, stored procedures, and triggers using SQL Server and used Data Adapter, Dataset and Data reader as a part of ADO.NET to access and update database in ASP.Net environment.

Strong RDBMS experience in Oracle 10g/9i, PL/SQL. Accessed SQL Server database through .Net using SQL Command, SQL Data Reader and Dataset and extensively used PL/SQL, Triggers, Data Management.

Experience using Team Foundation Server 2010 (TFS 2010), Microsoft Visual Source Safe (VSS).

Developed N-Tier application, Web based enterprise application, full-fledged software products and involved in full life cycle development of various web based and Client/Server applications.

Good working knowledge in developing Web Controls using XML applications, XSL, XSLT, XML Schema, XPATH and DOM.

Worked in different areas including Collaboration, Document Management, Portal and Web Content Management.

Excellent knowledge in Multithreading, Object Oriented Design/ Programming, Client Server Architecture (2-tier). Familiar with Crystal Reports, MS Projects.

Good knowledge in creating Use Cases using Rational Ross and Visio Tool.

Experience and good knowledge of Object Oriented Programming and Design (OOPD) with Inheritance, Polymorphism, Encapsulation and Virtual Functions.

Well acquainted with Class, Use Case, Interaction and State Diagrams of Unified Model Language (UML).

Experienced in Test Driven Development (TDD) and writing Unit Test Cases using N-Unit.

Implemented design pattern in multiple projects.

Involved in execution of total SDLC and Agile methodology.

My experience enables me to handle multiple assignments under pressure and cope up with tight deadlines and actively participated in code reviews.

Self-motivated and result-driven in developing business solution for the company’s operations.

Communicated with business group to gather requirements and involved in the design phase of the project to structure various layers of the application.

Interacted with Business analyst, customer and with QA members to understand the user requirement and for requirement acceptance.

Effective team player with excellent problem solving abilities, a willing and quick learner with strong technical skills.

Excellent communication & interpersonal skills with proven abilities in resolving complex software issues.

EDUCATION & CERTIFICATION:

M.Sc. Information Technology, Manipal University, Karnataka, India. June 2002 to 2004

MCAD in Asp.net

MCTS in MS SQL Server

MCTS in SharePoint 2010

TECHNICAL SKILLS:

.NET Technologies

.NET Framework (1.1/2.0/3.0/3.5/4.0/4.5), ADO.NET 2, ASP.NET 4.0/2.0

GUI/IDE

Microsoft Visual Studio 2010/2008/2005, Microsoft Office Visio 2007, SharePoint Designer 2010

Web Development

HTML, CSS, XML, XSL, XSLT, X-Path, SOAP, AJAX, Jquery, XAML, Web Services, WCF, WebApi

Programming Languages

C#. Net, Visual Basic. Net, Visual Basic 6.0

Web Scripting Languages

JavaScript, VBScript, JQuery

Database Technologies

SQL Server 2010/2008/2005, Oracle 10g/9i, MS Access

Business Intelligence

SSIS, SSRS

Reporting Tool

SSRS,SSIS, Crystal reports 10/11

OS/Platforms

Windows XP/7/8

Development Tools

Visual Studio.NET 2003/2005/2008/2010/2013, MS Visio, Crystal Reports, Office 2000/XP

Application Servers and Version Control

IIS, MS Visual Source Safe (VSS), Team Foundation server (TFS 2010)TFS,

SharePoint 2010

Web Content Management (Publishing Portal), Custom Web parts, BDC, Custom Navigation (Portal Site Map provider), Site Columns, Master Page, Minimal Master Page, Content Types, Page Layouts, SharePoint Designer, and SharePoint Object Model, Timer Jobs.

Others

JIRA, HP Quality Control, HP Fortify, NService Bus, Couchbase, Knockout framework, Version one, VSS, TFS

PROFESSIONAL EXPERIENCE:

Compubahan – TransAmerica(LittleRock, Arkansas) – Developer – March 2015 – Till Date

Description:TEB wants to implement its own web enrollment system that can be used to enroll groups and their employees. Implementing this system should give TEB producers a competitive edge in the marketplace, increase sales opportunities, make it easier for customers to do business with us, and potentially eliminate some of the expenses associated with paying third party vendors to facilitate electronic enrollments on our behalf. The enrollment system will be web-based and designed to accommodate agents’ face-to-face enrollments, self-enrollments, and ongoing group enrollments. This project supports the overall business goals for TEB and it addresses a component of each of the four Must-Win Battles that are key initiatives in support of ONE AEGON, which are: optimizing our portfolio, enhancing customer loyalty, delivering operational excellence, and empowering employees.

Responsibilities:

Design & Development of the Application Architecture, Identifying the modules, designing solutions/projects.

Used TFS for source control and configuration management.

Customizing the product to meet individual client requirements.

Used ASP.Net MVC 4.0 Framework (C#.NET) for building web applications using a MVC (Model View Controller) design.

Created Table, Views, Stored Procedure and function in Sql Server 2008 R2.

Implemented knockout framework for Leverages MVVM design pattern to increase modularity and provide for a clean separation of concerns and cohesive implementations.

Written web api methods for building HTTP services.

Used Fluent NHibernate 3.1 ORM for XML-less, compile safe, automated, convention-based mappings.

Used NHibernate Couchbase 2nd Level Cache Provider.

Worked on NServiceBus for Messaging.

Worked on Structure Map 2.6 for Dependency Injection.

Used AutoMapper for convention based object-object mapping

Used fluent validation and lambda expressions for building validation rules for your business rules.

Used log4net for logging.

Created PDF using iTextSharp for creating report.

Used Jenkins for build and deployment.

Involved in Kanban software development methodology.

Implemented Onion Architecture(DDD)

Environment: Asp.net, MVC 4.0, Web API,C#, SQL server 2008 R2, HTML, CSS 2/3, AJAX, JQuery, Linq, Fluent Nhibernate 3.1, Structure Map 2.6, NServiceBus.

Ciber - ANOKA/DAKOTA County – Ciber Law, Principal Consultant – April 2014–January 2015 Bangalore – India

Description:CIBERLaw (State & Local Government Product) comes under the State and Local Govt. sector in CIBER. CIBERLaw is a product from CIBER. The product is a comprehensive case management system, designed by and for public attorneys. CIBERLaw helps manage all aspects of a case and features intelligent, automated generation of case documents and reports. The CIBERLaw solution fully integrates case processing and reporting, legal support, and case event tracking activities. The CIBERLaw system provides capabilities to scan and record external files, so attorneys can reference all case evidence and documents from one location. Related cases can be automatically or manually linked together, making it simple to see all the matters involving a particular person or incident across multiple teams within the offices of the District Attorney.

Responsibilities:

Design & Development of the Application Architecture, Identifying the modules, designing solutions/projects.

Used TFS for source control and configuration management.

Customizing the product to meet individual client requirements.

Extensively worked on WCF services to enable effective communication between SOA.

Utilized Entity Framework with Database first approach.

Used MVC Framework (C#.NET, ADO.NET) for building web applications using a MVC (Model View Controller) design.

Created Business Logic Layer & Data Access Layers to implement the MVC architecture.

Implemented Repository pattern to maximize the amount of code that can be tested with automation and to isolate the data layer to support unit testing.

Implemented the MVC model to render clean html and a clear testable application.

Involved in writing complex queries and stored procedures using T-Sql programming.

Involved in performance tuning of the application by creating various database Indexes and optimizing database queries.

Involved in indexing the database table columns to get a faster retrieval.

Involved in developing heavy client side functionalities on the web forms using JQuery, JSON and JavaScript.

Involved in Impact Assessment, Development, Reviews, and Walkthroughs & Estimation.

Complete guidance to the team including technical and process related issues.

Involved in doing manual testing and automated unit testing using TDD.

Discussions & Brain Storing Sessions with Business Analyst to understand & document the requirement & further design the Application as per the requirement.

Providing quick analyses/solutions to the new requirements and JIRA Production issues, which involve possible best solutions with logic and code snippet, coordinate with offshore implementation and code review.

Environment: Asp.net, MVC 4.0, C#, SQL server 2012, WCF, SSRS, HTML, AJAX, JQuery, Linq

Ciber - Bayer – PCR/CAPA/VIP, Principal Consultant – October 2012 –April2014 Bangalore – India

Description:PCR (Packing Change Request), CAPA (Corrective Action and Preventive Action) and VIP (Value Improvement Plan) are legacy application developed with old technologies, our task is understands the application requirement and rewriting into SharePoint application, for this we leveraged out-of-the-box (OOTB) SPS 2010 components in conjunction with custom features/solutions such as web pages, web parts, event handlers, and web services…etc. built using .NET and associated technologies.

Responsibilities:

Preparing effort estimation,Quality management & Risk management activities

Designing solution architecture and high level design

Used TFS for source control and configuration management.

Used central administration tool to create and configure web application, site collection, search services and content development in SharePoint 2010.

Used SharePoint server 2010 document library and management. Used Windows based authentication for SharePoint portal.

Created site templates and added built in web parts to the SharePoint site.

Created Custom Web Parts List and Document Library.

Created several BCS lists using SharePoint Designer.

Created SharePoint Workflows using SharePoint Designer majorly for displaying different analytic reports and to and sends notifications to the corresponding users based on Conditions and Actions with the help of Work flow Designer 2010.

Developed multiple reports using SSRS.

Created workflows using Nintex.

Involved in code reviews

Planning continuous integration and code quality assessment

Prepare project Daily status reports

Involved in AGILE software development methodology.

Mentoring the team.

Environment:SharePoint 2010, C#, SQL server 2008R2, Web Service, SSRS, SSIS, HTML, JQUERY,Linq, Nintex work flow

Dell Services, OST, SOFTWARE DEVELOPMENT ADVISOR – March 2012 – October2012 Bangalore

Description: The Online Sales Tool (OST) will be used by the sales team to manage all OLR migrated stores of OLR and also manage transactional settings for eSupport. It is the only UI which is available to manage Enterprise Settings to manage the customer experience & customizations on Portal side. The architectural changes in OST over legacy premier tool will allow quicker turnaround in business requirement delivery due to flexibility offer by metadata based design and solutions.

Responsibilities:

Have involved in application development using MVC framework

Extensively worked on WCF services to enable effective communication between SOA.

Have implemented Dependency injection using Unity IoC container

Have implemented Design pattern like singleton, Adapter.

Involved in developing heavy client side functionalities on the web forms using JQuery and JavaScript.

Creating objects like tables, indexes & views in Sql server 2008 as well as Oracle 10G

Wrote PL/SQL, queries, stored procedures for the Oracle 10g Database.

Deploying application onto UAT environments.

Troubleshooting environmental issues.

Extensively used TFS 2010 to maintain the versions and create Builds on daily basis.

Involved in AGILE software development methodology.

Environment:ASP.net 4.0, C#, ADO.net, Linq, MVC 3, JQuery, WCF, SQL Server 2008,Oracle 10 G

Dell Services, DBI Quality Apps,SOFTWARE DEVELOPMENT ADVISOR –September2010 – March2012 Bangalore

Description:It contains a suite of application which includes Team Track, Test-drive and PG Metrics in the PLM Domain. Team Track is an issue tracking product developed by Serena software with lots of Dell customization on it which is developed at Dell. test-drive is a test management tool which helps the Product Group to test the quality of the Dell Products that are in development .PG Metrics is a home grown reporting tool which has interfaces with the critical applications in quality space .With this tools operational, exceptional & dashboard reports executives can take the decision of product launches and its stage wise milestone.

Responsibilities:

Involved in fixing HP fortify tool issue fix.

Involved in troubleshooting of production problems, worked in enhancements and permanent fixes

Handled ASP.NET features such as Exception Handling and Custom Error Messages.

Handled Run Time Errors & Design Time Errors by implementing appropriate Error handlers in C#.Net.

Wrote PL/SQL, queries, stored procedures for the Oracle 10g Database.

Involved in indexing the database table columns to get a faster retrieval.

Involved in performance tuning of the application by creating various database Indexes and optimizing database queries.

Involved in getting the requirements from the Business users and clients, coordinating for UAT and Production move.

Responsibilities include helping new members of the team to understand the domain and applications

Lead Developer Responsibilities includes estimate, work breakdown, task assignment and tracking, deployment, unit testing, user training and post deployment support for smooth transitioning of the project to business owners

Provide adequate amount of status reporting to the project management team and other stake holders

Involved in AGILE software development methodology.

Environment: ASP.net 4.0, C#, ADO.net, Linq, WCF, SQL Server 2005, Oracle 10 G.

TARGET, BANGALORE –RCS- SENIOR SOTWARE ENGINEERJuly 2008 - September 2010

Description:This project Address the significant increase in workload due to the increase in the number of planograms driven by the 2008 implementation of the Planogram Optimization project by MPD by focusing on the Reconciliation Process. Current PD Retrofits reconciliation process is manual, cumbersome, and prone to error which results in fixture waste and additional workload. The Retrofits Change System will automate the manual reconciliation process. Reduce or eliminate keying/re-keying errors that result in the shipment of incorrect fixture quantities to stores. Optimize headcount required to address the increase in workload due to POG optimization initiative.

Responsibilities:

Worked on .Net 3.5 framework and used Sql 2005 database as back-end.

Involved in Asp.net Web Forms design using HTML, CSS.

Client side validations are done using JavaScript and AJAX scripting.

Enhanced web pages interactivity using powerful AJAX controls.

Used Telerik controls for developing complex grid.

Used ADO.Net for data retrieving, querying, storage and manipulation from SQL Server 2005 database.

Involved in the Design & Development of Web Services using Windows Communication Foundation (WCF).

Created tables, indexes & views.

Created Procedures and functions.

Responsible for writing Unit Test Cases.

Environment: ASP.net 3.5, C#, ADO.net, Linq, Ajax, WCF, SQL Server 2005, Telerik .NET Controls

Satyam, Telstra Myleon– SENIOR SOFTWARE ENGINEER – January 2008 – June2008 Bangalore

Description:This system was created to enable the Legal & regulatory group of Telstra to manage external and internal legal matters (Create, Search) track costs incurred on external matters by standard reporting. The following are the features of Myleon:

1.To create and maintain legal matters, projects

2.To search legal matters, projects

3.Generate reports

4.User profile maintenance

5.Administration (User maintenance, downloads)

Responsibilities:

Involved in ASP.net page design and development using HTML, VBScript and JavaScript.

Support to this website for maintenance.

Environment:ASP.net 2.0, C#, ADO.net, SQL Server 2000

PDM Technology, BANGALORE – Gerber Technology – WebPDM - PROGRAMMER – January 2007– December 2007

Description:WebPDM helps apparel companies and retailers facilitate communication and simplify the coordination of product development tasks. By connecting design, engineering, costing, and manufacturing information through a centralized database of product-related information.

This product data management tool accumulates all product related information on a centralized database - shortening the product development cycle and reducing development costs. Produce and communicate product specifications in real time. The information on materials, specs, costing, sourcing, style construction, bill of materials and more can be controlled. We can pull the data from a central source so everyone involved has access to the most up-to-date information on a product minimize errors caused by miscommunication. Configured ready-to-use page layouts are included in the system, enabling you to build and communicate complete specification packages quickly. Create technical sketches faster by using a library of standard styles and components (sleeves, pockets, etc.) and publish them in their own color ways, Streamline your day-to-day activities. Once the data is in the system you can re-use it or edit it easily to create new styles.

Responsibilities:

Involved in Forms design enhancement and bug fixing.

Developed various reports using .NET, Crystal Reports.

Creating objects like tables, indexes & views.

Creating Procedures and functions.

Creating Unit Test cases.

Design and development of various reports.

Environment:VB 6.0, SQL Server 2000, XML, MTS, Crystal Report.

PDM Technology, BANGALORE – Carters,Oshkosh – PDF Creator - PROGRAMMER – July 2006 – January 2007

Description:The main goal of this project is to automatically create product specification .PDF output from WebPDM with E-Spec’s PDF Creator. Generate .PDF files from the WebPDM™ Print Server, resulting in faster creation of files with no impact to end users machine performance done by the sub links also .The other main module of our project is the server side module. All the DSA offices are controlled by the head office. Our system is a total centralized sales solution. All the DSA data are maintained and made centralized using our server module.

Responsibilities:

Worked on .Net 2.0 framework and used Sql 2000 database as back-end.

Involved in Forms design and development.

Creating the data sets, data adapters and methods for data access layers.

Creating objects like tables, indexes & views.

Creating Procedures and functions.

Creating Unit Test cases.

Design and development of various reports.

Windows service Development and deployment.

Environment:C#.Net 2.0,SQL Server 2000

QBIC Solution, Chennai – Volvo – Centrac - ANALYST PROGRAMMER – October 2005 – May 2006

Description:This project monitors various activities of Central Excise. It takes care of Raw / Capital materials received and issued rejection of Raw material / Capital goods. It takes the incoming goods, production details and the invoice details from various systems maintained by the Volvo. It automatically updates the REG 57A, RGI and PLA registers. It also takes care of Excise Invoices, Material Invoice, Export Invoices/Removal details and their annexes. This system also takes care of Product Sales, Stock and Rejection and their duty information.

This system provides reports like Production Information, Duty Payables, Sales Details, REG 57AE (Input and Capital Goods, Miscellaneous Credit and Debit Details), RG1, RT12 and PLA registers information and annexure details, register balance, rejected information, job work information and all reports respect with Central excise and other related MIS Reports. This system reduces manual work and increase flexibility.

Responsibilities:

Involved in Forms design and development.

Creating objects like tables, indexes & views.

Creating Procedures and functions.

Creating Unit Test cases.

Environment:VB 6.0, SQL Server 2000, Crystal Reports 8

QBIC Solution, Chennai – SRM Hospital – HospiQ - ANALYST PROGRAMMER – January 2005 – August 2005

Description:HospiQ is a comprehensive hospital management system that computerizes principal operations and administrative functions in a hospital. This relates to managing patient information, managing the administration of the hospital, managing doctor itineraries, providing the management with MIS information, etc. Cost effective management of a modern hospital, requires a pro-active automated system. HospiQ has been designed to cater to these very needs of today’s health- care industry

Responsibilities:

Involved in Forms design and development.

Developed various reports using Crystal Reports.

Creating objects like tables, indexes & views.

Creating Procedures and functions.

Creating Unit Test cases.

Used Visual Source Safe for project management.

Environment:Visual Basic 6.0, SQL Server 2000 and Crystal Reports, VSS

QBIC Solution, Chennai – UAN - ANALYST PROGRAMMER – May 2004 – December 2004

Description:This is a portal for the purposes of updating the artists and lifestyle partners in UAN with the latest information. Artists can register at the site and participate in the program to receive certain membership benefits and privileges.

The portal consists of 2 different categories:

a) Public Portal – This is where artists interact and participate in the program.

The main functionality here is content browsing, registration and updating of personal profile.

b) Management Console – This is where authorized administrators log in to manage the program.

The main functionality here is to manage member, content management for the events, notifications & audition and reporting

The Manage Events Module allows user to key in the events and inform the relevant members in the Public Portal. Notifications module allows user to communicate to the relevant members in the Public Portal Notice Board. Auditions module allows user to inform the relevant short-listed members in the Public Portal about the auditions information. Registration module allows actor to sign up for the UAN Artist Lifestyle Portal

Responsibilities:

Worked on Asp.Net 1.0 framework and used Sql 2000 database as back-end.

Involved in ASP.net page development using HTML, VBScript and JavaScript.

Support to this website for maintenance.

Creating Unit Test cases.

Environment:Asp.Net 1.0, C#, HTML, ADO.NET, SQL Server 2000

QBIC Solution, Chennai – Tele Report - ANALYST PROGRAMMER – March 2004 – May 2004

Description:This product reports the information of telecall details. User can view the telecall details for each and every call registration. User can view the call summary for missed calls, received Calls and answered calls, which are stored in the database. And also the user can view daily and monthly summary and also user can get the reports for that summary.User also can search for a particular extension in between the specified dates.

Responsibilities:

Worked on .Net 1.0 framework and used Sql 2000 database as back-end.

Involved in Windows form development to provide very user-friendly interface using C#.

Designed data access layer using ADO.NET datasets & data adapters.

Creating the data sets, data adapters and methods for data access layers.

Creating objects like tables, indexes & views.

Creating Procedures and functions.

Creating Unit Test cases.

Environment:VB.Net, ADO.Net, SQL Server 2000



Contact this candidate