Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Waterloo, IA
Posted:
January 13, 2017

Contact this candidate

Resume:

RaghuRam. Garaga Mobile : 515-***-****

.Net Developer Email : acx9nt@r.postjobfree.com

Experience Summary

Overall My It experience 10+ years (2 years in Design 8+ years in Development) of progressive experience in Design, Development and Implementation of Client/Server and Internet/Intranet applications.

Good Experience developing Web applications, Windows applications(Win Forms), Console Application, Windows services and web services in Microsoft Visual Studio .Net using VB.Net, C#.Net, ASP.NET, ADO.NET and SQL Server, MY SQL, Oracle and MS-Access, Crystal Reporting, SSRS Reports, SSIS(SQL Server integration services)

Excellent experience in the entire Software Development Life Cycle – Requirements gathering, Analysis, Design, Development and Testing.

Experienced with Object Oriented Programming, agile environment, Windows Forms and UI design.

Experienced with Architect the application using MVC, Entity Framework model for WPF.

Hands-on Experience in creating and consuming XML WapApi Web services, RESTful Services including AJAX, HTML,XAML, SOAP using .NET Framework 2.0/3.5/4.0/4.5

Experience with RDBMS databases to include MSSQL Server 2000/2005/2008/2012 R2, DB2 and Oracle 9i.

Good experience in database programming using ADO.NET objects such as SQL / OLEDB connection, Command, Data Reader, Dataset and Data Adapter.

Expertise in using data access layer development using Entity Framework, LINQ to SQL. and control SQL injection, Oracle, OracleSTORED PROCEDURES AND FUNCTIONS, packages(yog, Navigating etc)

Experienced in customizing and adopting Microsoft provided Application blocks (Validation, Logging, Exception, Data, and Security)

Experience in designing and developing enterprise applications using MVC (Model View Controller) Architecture.

Hands-on experience with WCF (Windows Communication Foundation) and WWF (Windows Workflow Foundation)

Expertise in maintaining, supporting, troubleshooting and fixing application bugs.

Experience in creating complex stored procedures to access data from SQL Server.

Thorough understanding and experience designing database tables, stored procedures, functions in SQL Server 2005/2008.

Proficient in development of secured, scalable web applications by using appropriate validation of user input and proper data access methods.

Proficient in Object Oriented Design/Development(OOA),Object Oriented Analysis and Design(OOAD),Model View Control (MVC) design pattern.

Additional responsibilities include performance tuning, in ASP.NET security mechanism such as Impersonation, Authentication and Authorization. setting quality standards, enforcing efficient quality control across systems, code walk-through, focusing on system performance.

Working knowledge of Third party tools with Telerik, DevExpress, Infragistics, Dundas in the implementation of WebPages

Expertise with Visual Source Safe (VSS), SubVersion, Team Foundation Server (TFS), Tortoise SVN, GIT.

Expertise in AGILE Methodologies and waterfall Methodologies

An enthusiastic and goal-oriented team player possessing excellent communication and interpersonal skills with high level of adaptability.

Fiscally responsible decision making with emphasis on practical operational controls and timely successful implementations.

Education

B.E in Computer Science. in University of Madras

Technical Skills

Languages:

VB.6.0, C#.NET, VB.NET, HTML, XAML.

Databases:

MS SQL Server 2005/2008/2012 R2, MY SQL 5.0/5.1, Oracle 9i/10g, MS-Access.

Web Technologies:

ASP.NET, ADO.NET, Web Services, WCF, HTML, DHTML, CSS, XML and AngularJS,(MarkLogic).

Web Tools:

Visual Studio.NET 2005/2008/2010, AJAX, Telerik tools, Syncfusion, Dreamweaver, Adobe Photoshop CS3, MVC, After Effects, Flash8, Adobe Illustrator. SSIS.

Operating Systems:

Windows XP/2000/98, UNIX and LINUX.

Scripting Languages :

Java Script, VB Script.

Platforms and Servers :

.Net 2.0/3.5/4.0, IIS, Windows XP.

Others :

WCF, MVC, MVVM, WapApi, Windows Services, Web Services.

Version control Source Safe :

Visual Source Safe, Tortoise SVN, Team Foundation Server, GIT.

Reporting Tools :

Crystal Reporting, SSRS Reporting,

Office Tools :

MS Office 2007 and PowerPoint.

Professional Experience

Project # 1

Sr. Software Developer Jan 2016 –till date

Client: Monsanto

location : Ankeny, IOWA, US

Monsanto's agricultural seed company, here we developed a window(WinForms) based product which contains number of applications. In that one of the application is based on Corn Breed which maintains all the information about the devices (Fax, Scanner etc.). This product has been given for rented to various clients in US according to their use of device. This automatically keeps track of meter reading of devices specified to it and generates auto mails which include all the information about cost and for Generation of month reports to analyses data and we developed Web application Toolkit using Angular JS, Web service WebAPI for develop registration module.

Responsibilities:

Involved in Software Development Life cycle starting from Requirements gathering and performing object oriented analysis, design and implementation.

Involved in overall project planning and product development. Designed and developed web application in .NET framework using VB, ASP.NET, JavaScript.

Oracle, Oracle stored procedures and functions, packages(yog, Navigating etc)

Used MVC framework to effectively separate data access, presentation and user-interaction layers.

SSIS and Crystal Reporting we migrate and generate New SSRS Reports .

Implemented functionalities such as login security, field validations, search and sorting using VB.Net with a high degree of maintainability and re-usability.

Primarily responsible for the development of a feature rich quoting application using Angular JS, jQuery,ASP.Net Web API.

Developed several front-end UI components using Twitter Bootstrap, Angular JS.

Familiar with TDD principles –Developed unit tests for both front-end (testacular) and back-end (xUnit) components.

Created test scenarios and performed functional testing of various functionalities of the application to complement the user stories.

Involved in integration with inRule – Business Rule Management Engine.

Worked with end-user to gather and document business requirements.

Helped with grooming the stories to identify the dependencies and provided inputs in form of development estimates.

Planning and Sprint Retrospectives.

Helped create user manual for the application developed that immensely helped the customer understand the application flow and functionalities.

Extensively coordinated with other members of the team and external customer to understand the issues and dependencies involved.

using AGILE Methodologies enter application.

Used TFS, to check in and checkout the code into branches and update the burn down chart.

Environment: here we using AngularJS, MVC, Entity Framework, ASP.NET, C#.NET, VB.NET, HTML, SQL, Bootstrap, jQuery, and CSS

Project # 2

Sr. Software Developer May 2015 –Dec 2015

Client: ColFax INN

location : Des Moines, IOWA, US

ColFax INN is a US based company, here we develop Hotel Management System (HMS) for Globalism to group of Hotels. HMS maintain all the details of Customer booking information, trace the details of all Hotels under this group and also maintain the information about the room availability, etc

HMS already in VB6 legacy application we migrate this application to web application. this was developed in ASP.Net, MVC Entity Framework by using VB.Net as well as C#. The Current using SQL 2003 was migrated to Oracle for migrate purpose we are using SSIS and Crystal Reporting we migrate and generate New SSRS Reports .

Responsibilities:

Involved in Software Development Life cycle starting from Requirements gathering and performing object oriented analysis, design and implementation.

Involved in overall project planning and product development.

Designed and developed web application in .NET framework using VB,C# ASP.NET.

forms VB6 coding

Oracle, Oracle stored procedures and functions, packages(yog, Navigating etc)

T SQL STORED PROCEDURES AND FUNCTIONS we righting

Used MVC framework Template MVC to effectively separate data access, presentation and user-interaction layers.

Implemented functionalities such as login security, field validations, search and sorting using VB .Net with a high degree of maintainability and re-usability.

Primarily responsible for the development of a feature rich quoting application using AngularJS, jQuery,ASP.Net Web API.

Developed several front-end UI components using Twitter tools Bootstrap, KendoUI and layout in MVC TMVC, AngularJS.

Familiar with TDD principles –Developed unit tests for both front-end (testacular) and back-end (xUnit) components.

Created test scenarios and performed functional testing of various functionalities of the application to complement the user stories.

Involved in integration with inRule – Business Rule Management Engine.

Worked with end-user to gather and document business requirements.

Helped with grooming the stories to identify the dependencies and provided inputs in form of development estimates.

Planning and Sprint Retrospectives.

Managed test data and identified bugs and fixed them timely.

Used TFS, to check in and checkout the code into branches and update the burn down chart.

Environment: Visual Studio.NET 2010, ASP.NET 4.0, VB.NET 4.0, C#.NET 4.0, Java Script, j Query, MY SQL 5.1, SQL Server 2008R2, IIS 7.0, Crystal Reports SSRS, SSIS.

Project # 3

Sr. Software Developer Oct 2014–May 2015

Client: IOWA Insurance Division

location : Des Moines, IOWA, US

Project Description: IID (IOWA Insurance Division) is an Iowa state department division and they will do company registrations for businesses. Upon registration companies have to renwal their license every year from the IID. Through Brokers & dealers we can do the registrations and they are using an application called blue express in order to do the registrations. Once the broker or dealer submits the application IID will receive the same and they will verify the check amount and approve the same. IID will use Access and VB6 (old application) to approve the entire process. Now, we are migrating Access and VB6 to Visual studio 2010, SQL 2008R2 and we developed WPF windows application this new application may contain administration, Registration, Amend Registration, Exemptions, Record Edit, Broker Forms, Correspondent forms, videos up lodes, and display Renewal and over sales etc.

Responsibilities:

Involved in Software Development Life cycle starting from Requirements gathering and performing object oriented analysis, design and implementation.

Involved in overall project planning and product development.

Designed and developed web application in .NET framework using VB, ASP.NET, JavaScript. TSQL STORED PROCEDURES AND FUNCTIONS

Access forms VB6 coding

Used MVC framework to effectively separate data access, presentation and user-interaction layers.

Implemented functionalities such as login security, field validations, search and sorting using VB.Net with a high degree of maintainability and re-usability.

Primarily responsible for the development of a feature rich quoting application using AngularJS, jQuery, DevExpress,ASP.Net Web API, NServiceBus, RavenDB.

Developed several front-end UI components using Twitter Bootstrap, KendoUI and AngularJS.

Familiar with TDD principles –Developed unit tests for both front-end (testacular) and back-end (xUnit) components.

Created test scenarios and performed functional testing of various functionalities of the application to complement the user stories.

Involved in integration with inRule – Business Rule Management Engine.

Worked with end-user to gather and document business requirements.

Helped with grooming the stories to identify the dependencies and provided inputs in form of development estimates.

Planning and Sprint Retrospectives.

Helped create user manual for the application developed that immensely helped the customer understand the application flow and functionalities.

Extensively coordinated with other members of the team and external customer to understand the issues and dependencies involved.

using AGILE Methodologies enter application.

Used TFS, to check in and checkout the code into branches and update the burn down chart.

Environment: Visual Studio.NET 2010, ASP.NET 4.0, VB.NET 4.0, C#.NET 4.0, wcf Java Script, j Query, MY SQL 5.1, SQL Server 2008R2, IIS 7.0, Crystal Reports SSRS, SSIS.

Project #4

Sr. Software Developer Sep 2013–oct 2014

Client : Aveda Institute, USA Launch IT

location : Des Moines, IOWA, US

Project Description: Aveda Institute is one of the biggest beauty college in USA. This Institute has lot of branches all over in USA. This Insitute is using an application called Sky View – Application is a student management system that provides each student, graduate and alumni a unique personalized experience. This application migrated from vb6 to C# Net and VB.Net. Sky View was designed specifically to help schools increase each department's key performance indicators. This application allows colleges and institutions to better manage their communication and achieve operational success between students, graduates, alumni, faculty and administrators. This application improves student engagement in all aspects of Admission, Financial Aid, Education, Student Services and Career Services by providing direct contact to students through the application.

In order to use entity frame work we have to install the frame work in visual studio. By using entity frame work have developed sky view application. The Entity Framework is a raping the ADO.Net set of Telerik tools technologies that support the development of data-oriented software application. In Entity frame work had used LIN Q to fetch the data from data base SQL 2008 R2. In MVC frame work the usage of entity frame is must.

*entity frame work is must

Responsibilities:

Involved in Software Development Life cycle starting from Requirements gathering and performing object oriented analysis, design and implementation.

Involved in design of application Entity Framework using MVC (Model-View-Controller) guidelines and MS Visual Studio.

Involved in overall project planning and product development.

Designed and developed web application in .NET framework using C#, VB, ASP.NET, JavaScript.

Data Dase Designed SQL 2008R2 and Tsql STORED PROCEDURES AND FUNCTIONS

Used MVC framework to effectively separate data access, presentation and user-interaction layers.

Implemented functionalities such as login security, field validations, search and sorting using C# with a high degree of maintainability and re-usability.

Primarily responsible for the development of a feature rich quoting application using AngularJS, jQuery, ASP.Net Web API.

Developed several front-end UI components using Twitter Bootstrap and AngularJS.

Created test scenarios and performed functional testing of various functionalities of the application to complement the user stories.

using AGILE Methodologies enter application Involved in integration with inRule – Business Rule Management Engine.

Worked with end-user to gather and document business requirements.

Developed and consumed WCF services. Created Data contract, Service Contract and operation contract, defined endpoints, and created proxy classes.

Helped create user manual for the application developed that immensely helped the customer understand the application flow and functionalities.

Extensively coordinated with other members of the team and external customer to understand the issues and dependencies involved.

Managed test data and identified bugs and fixed them timely.

Environment: Visual Studio.NET 2010, ASP.NET 4.0, C#.NET 4.0, VB.NET 4.0,WCf, Java Script, j Query, MY SQL 5.1, SQL Server 2008, IIS 7.0, Crystal Reports SSRS, SSIS.

Project # 5

www.cmg.com.my

Sr. Software Developer in Malaysia Aug 2012–Aug 2013

Client: Pizza Hut

Project Description: Pizza Hut is an American restaurant chain and international franchise, known for pizza and side dishes. The company had more then10 Pizza Hut restaurants and had more than 210 store locations in Malaysia. This application has been in use across APAC region. It simplified things to offer the best experience for customers in various locations of Malaysia. This project contains 2 applications one at stores and another at main center (HQ). The main modules in HQ are Administration, Order Taking, Order Verify, End-of-Day, Clock-in and Reports etc. The main modules at stores are Administration, Order Taking, Order Tracking, Make-Line, Routing, Clock-in, Reports, etc.

Responsibilities:

Actively involved in all stages of the Software Development Life Cycle.

Involved in designing the pages with C#.NET, ASP.NET, VB.NET, MVC ASP and screens in Visual Studio .NET 2008.

Developed UI layer for an internal web application using ASP.NET Web forms and code behind using C#.NETfor implementing the Event Creation, Management and Payment processing.

Developed and consumed WCF services. Created Data contract, Service Contract and operation contract, defined endpoints, and created proxy classes.

Utilized ASP.NET server controls such as Data Readers, Data Grid, and Generics List controls.

Developed Web pages using Telerik tools which has inbuilt Ajax. Tools like Telerik tools used to develop Web pages

Windows Workflow Foundation (WWF) allows for building of task automation and integrated transactions using workflows.

Implemented MVC 4 pattern in the application development.

Implemented the SQL Server 2008 database connectivity using Entity Framework, LINQ to SQL.

Created snapshots by using WPF(Windows Presentation Foundation) for the functional requirement phase and used SQL Server Integration Services (SSIS)

Used Reporting Services to modify and develop the Program Invitations required for the new brand of events that were being organized.

Written stored procedures and functions to integrate database with the application layer.

Created complex Stored Procedures, Views and Functions for database for fast retrieval of data in SQL Server using T-SQL

Utilized Web Services in handling the Event processfor the Financial Payments.

Used XML intensively to bind the data to the Web Controls, Data manipulation to store data.

Worked on parsing and editing XML documents by validating it to the schema using class libraries provided by .NET and Twitter tools

Used Silverlight to enhance the application interactivity and user input, basic UI controls, graphics and animation, media playback.

Actively managed the role of Production Support to fix the application issues on time.

Used Tortoise SVN for the Source Control Management.

Involved in Code Review with the team members.

Involved in testing & debugging of the application.

Actively participated in all the Team meetings and also interacted with the clients for the new enhancements.

Environment: Visual Studio.NET 2010, ASP.NET 4.0, VB.NET 4.0, Java Script, wcf, jQuery, MY SQL 5.1, SQL Server 2008, IIS 7.0, SSRS, Crystal Reports

Project # 6

Sr. Software Developer Aug 2011–Aug 2012

Client: RESB (in Malaysia)

Project Description: Recycle Energy (RESB) – is a pioneering in the use of green technology to generate energy from their recycling plant, in Semenyih. RESB is an accounting Web application design for the users of RESB in various locations of Malaysia. This application has several modules including Administration having 13 sub modules, Accounts having 11Sub modules, Assert management having 2 sub modules, Purchase department having 5sub modules, Sales department having 3 sub modules, Warehouse having 3 sub modules, Payroll’s . It is mainly intended for administrative staff of the RESB to maintain details of Accounts, sales and purchase etc. It provides single point of administration for the staff members to actively monitor activities in various segments of RESB.

Responsibilities:

Involved in all stages of the SDLC process and interacted with clients.

Used Use case, Sequence and Class diagram’s for the application development.

Developed ASPX pages, user controls and validation controls using ASP.NET.

Extensively used Data Controls like Grid View, Repeater controls to display the data.

Implemented features of AJAX controls such as Update Panel, Update Progress bar, Model Popup Container, Calendar Controls, Repeater Control, and Validation controls, Dataset.

Developed database components using LINQ queries for data accessing.

Used Data Reader and Datasetfor data manipulations and database operations.

Used panels to display more than one input screen in a single form, to help user navigate to any screen during data entry.

Windows application development using VB 6, VB.Net, C#, WPF.

Involved in designing login dialog and the application’s main screen functions that included: Adding, modifying, updating, canceling deactivating, reactivating, depositing/withdrawing, transferring of accounts, and commitment application screens.

Developed UI layer for web application using ASP.NET Web forms and code behind using C#.NET.

Created CSS for styles on web page, and referenced them in ASP.NET pages.

Developed various utility classes which are used across the whole project using ASP.NET, VB.NET and ADO.NET.

Used Silverlight mainly for interactivity and user input, basic UI controls, graphics and animation, media playback, Digital rights management, and DOM integration.

Created Visual Models using UML for design representation.

Created WCF Services for exposing the functionality of each module so that all modules could interoperate with each other.

Created tools to deal with complex macro-enabled Excel files facilitating user-friendly presentation of reports and calculating commissions using C#.NET and ASP.NET.

Was responsible for troubleshooting developmental issues.

Wrote stored procedures and functions to integrate database with application layer.

Was responsible for development of a working prototype for core business requirements using ASP.NET 3.0, C#.NET and SQL Server 2008.

Generating reports using Crystal

Created classes and core modules in C# for implementing business layers.

Involved in Code Review with the team members.

Involved in testing & debugging of the application.

Environment: Visual Studio.NET 2010, ASP.NET 4.0, VB.NET 4.0, SQL Server 2008, Oracle 9i, IIS 7.0, Crystal Reports.

Project # 7

Renorite SDN BHD: Sr. Software Developer Oct 2010–July 2011

Client: Zensoft Solutions (in Malaysia)

Project Description: Zensoft Solutions – This project consists of seven modules Administrate, Maintenance, Vehicle Info, Operation, and Search Reports. Administrate module consists of user creation form, user permissions and Change Password Screens. Maintenance having ten sub modules shipping Derails, Drives Info, Job Listing Driver Incentive vessel info etc. Vehicle Info having three sub modules, operating having two modules one is the RFT and job updating. Reports having 25 different types of reports got like invoice, movement, revenue, rebate, driver incentive, Prime mover income, trailer engage and trailer movement history etc.

Responsibilities:

Developed User Interfaces using ASP.NET with C#.

Utilized Visual Modeler to develop Sequence and Class diagrams to design business needs.

Wrote Custom, User Data Controls to display the Customer Info using ASP .NET for reusability

Wrote Middleware Business Classes using .NET Components and Services.

Wrote Custom Data Access Classes to retrieve cable data using ADO .NETDatasets for reusability.

Improved performance of order flow with multi-threading in middleware and tuned SPs in database.

Implemented SSIS packages to extract Deals feeds and load to SQL Server.

Used Visual Studio 2005 as IDE to develop user interface, middleware and data access components.

Worked on Silverlight for building applications that blend application UI, documents and media content.

Worked on XML forms to link up to the UI layer.

Created WCF Services for exposing the functionality of each module so that all modules could interoperate with each other.

Exchanged information across different platforms by sending and receiving data using MQ Series.

Used SQL Server 2005 to create and test stored procedures and functions.

Generated timely reports using SSRS.

Created Unit Test Cases. Performed Unit and System Testing before shipping code to Production.

Created code standards, code optimization guidelines for consistency and performance.

Environment: Visual Studio 2005,.NET Framework 3.0, C#, ASP .NET, WPF, ADO .NET, Web Service, SSRS, SSIS, SQL Server 2005, Oracle 9i, WCF, Silverlight, XML and Windows XP.

Project # 8

Development Engineer Aug 2008–March 2009

Client: Legal Point, Malaysia

Project Description: Legal Point – is a completely integrated case management and time & billing software product suite that contains everything law firm needs to meet client demands, increase staff productivity and improve law firm’s bottom line. Legal point has law firm’s legal software management needs covered. It also, has more than a simple contact Manager Docket list calendar or personal information manager. Legal point is a true business legal case management system for true professionals.

Responsibilities:

Involved in the Design, Coding and Implementation using Visual Studios 2008.

Wrote use cases, sequence and flow diagrams.

Responsible for designing database, modifying designs from legacy system.

Implemented validation usingvalidation server controlsand JavaScript.

Extensively worked with C#.NET for creating classes of this application and Integrated with ASP.NET pages.

Configured and implemented .NET Class Frameworkenvironment along with application.

Wrote database components to access Database usingADO.NET.

Involved in developing XML web services to implement the functionality.

Wrote Listener Service Component to import data from the external file.

Created Stored Procedures and to perform automated rules, updating to related tables in MSSQL Server along with creating tables, views, indexes and relations.

Created Jobs and DTS packages.

Environment: Visual Studio.NET 2008, ASP.NET 2.5, VB.NET 2.5, MY SQL, SQL Server 2005, Crystal Reports.

Project # 8

Sri Ramayya Tech. Pvt. Ltd.: Development Engineer March 2007–July 2008

Client: Sri Ramayya Tech

Project Description : Invoice Tracking System – is a tracking systemfor invoice and is capable to receive, check, process and store every single transaction details in an electronic document form of TCS clients. The System has got modules which cater to the specific needs like the RECEIVE module receives invoice and related purchases detail directly from the vendor, and stores details into the system, CHECK module checks on the duplication of invoice or transaction submitted by vendor, PROCESS & STORE Modules enables the system to Process the data according to the business logic and stores the information.

Responsibilities:

•Involved in analysis and design, development and defect fixing phases performing role of Senior Developer.

•Designed and developed web pages using Visual Studio 2005.

•Created User controls, Custom controls for the Web pages.

•Provided Session Management to preserve the state of session variables.

•Designed and implemented Data access layer using ADO.NET to connect, retrieve and manipulate database information.

•Used the SQL Profiler to pin point the pain point of application regarding the performance on the database side.

•Used JavaScript for the client side validations as well as client side event handling.

•Programmed ADO.NET for communication between application and database, used extensively data grid, data set, data table, data views, data adapter and data readers

•Involved in unit testing and integration testing of the application.

•Implemented page level caching mechanism to increase the application performance.

•Developed test strategies, test plans and test cases and performed Unit Test to identify and resolve integration, functional and usability issues before deployment.

Environment: VB.Net, Microsoft Visual Studio 2005, Web Services, UML, OOPS, JavaScript, ADO.NET, SQL Server 2005, ASP.NET.

2 years in Design projects

www.sunrisetourservices.com

www.shekinahgrace.org/aboutus.html

www.u2buysel.com

www.1roy.com



Contact this candidate