Post Job Free

Resume

Sign in

Management Sql Server

Location:
Iowa City, IA
Posted:
June 16, 2015

Contact this candidate

Resume:

Sridhar Ramadass

Software Developer

732-***-****

acp87x@r.postjobfree.com

Summary:

Over 5+ Years of experience in Design, Development, Testing, Implementation and maintenance/support of Multi-Tier and Windows-based applications using Microsoft Technologies.

Over 3+ years of Project Management experience, coordinating with teams in an Onsite-Offshore model.

Having Complete Software Development Life Cycle (SDLC) experience.

Strong knowledge in Object Oriented Programming Structure and in implementing n-Tier architecture applications.

Strong experience on the windows based application development using .NET Frameworks 2.0/3.5/4.0, Visual Studio .Net 2005/2008/2010, VB.NET, ADO.NET, SQL-Server 2005/2008/2012, XML.

Developed and deployed Win Forms and Window service applications extensively.

Intensively involved in supporting, maintaining and troubleshooting activities for software applications and services.

Extensively used ADO.Net, XML, for disconnected databases and displayed proficiency in employing Grid views, List view, Data Readers and Datasets for data manipulation.

Well versed in writing Stored Procedures, Triggers, Functions, Views and Database Design using MS SQL Server.

Having knowledge in MS SQL Server database development and administration in enterprise production environment including server installation, configuration, and backup/restore.

Worked extensively on version control tools like TFS and VSS.

Expertise in using Third party components DevExpress 8.2/9.1/11.2. Developing Windows application using DevExpress XtraForms and XtraReports.

Comparison Tools like WinMerge(For File Comparison) and RedGateSQLToolbelt(For Database Schema Comparison)

Experience in adding Barcode functionality in .NET application.

Functional knowledge of Laboratory Information Management System (LIMS) for Environmental labs.

Technical Skills:

Programming Languages:

VB.NET, ADO.NET, ASP.NET, HTML, Visual Basic 6.0, C, C++

Frame Works:

Microsoft .NET 2.0/3.5/4.0

Programming Environments:

Visual Studio.NET 2008/2010/2012

Databases:

MS SQL Server 2012/2008 R2/2005, XML, MS Access

Reporting Tools:

DevExpress Reporting tools, Crystal Reports

Version Control Tools:

Team Foundation Server 2010, MS Visual Source Safe 6.0

Development Methodology:

Waterfall Model

Miscellaneous Tools:

WinMerge, RedGateSQLToolbelt

Operating Systems:

Windows 8/7/XP, Windows Server 2003/2000

Education:

Master of Computer Application from Alagappa University, Karaikudi, TamilNadu, India.

Domain Expertise:

Laboratory Information Management System (LIMS)

Client Profile:

Client: BTLIMS Technologies, Houston, TX. Experience: 5 Yrs 1 month [Apr 2009 – May 2014]

BTLIMS Technologies, a subsidiary of CVR Labs Pvt Ltd, a dedicated firm to automate the workflow and simplify the LIMS (Laboratory Information Management System) process and customizing the LIMS in line with the client’s requirements. With more than a decade of experience in LIMS, the company developed a product that can withstand any stance irrespective of time. The holistic approach and solutions to all lab related flow, BTLIMS has managed to be on the top with its state-of-the-art technology and comprehension of the each lab technician’s requirements. Combining the expertise of both software professionals and laboratory professionals, BTLIMS is a product that serves most of the laboratories round the globe.

Project Profile:

Talent Logic, Inc. Kingwood TX [Nov2014 – Till Date]

Project : Collybus

Client : Data Dimension, Brookfield, WI

Environment : .NET Web Application, WCF, MVC, Entity Framework, Workflow Manager,

IIS, Powershell3.0, C#.NET, Visual Studio 2014, SQL Server 2014.

Description:

Collybus is a comprehensive Enterprise Content Management (ECM) platform that automates information-driven business processes. It combines powerful workflow with secure document and data storage and management, along with robust reporting and analytics. The platform’s intuitive interface enables front-line user to quickly create, execute and access business-critical documents and processes. Collybus also provides users with the ability to view relevant documents concurrently with core application screens, reducing processing times and costs, and increasing efficiency and productivity, while enhancing control of business-critical information.

Responsibilities:

• Primary responsibilities include development, code review, unit testing.

• Involved in Implementation and setup a Collybus website including workflow management.

CVR Labs, Chennai, INDIA [Apr 2009 – May 2014]

Project : BTLIMS

Client : BTLIMS Technologies, Houston, TX

Environment : VB.NET Windows forms, Visual Studio 2008/2010, SQL Server 2005/2008

R2/2012, DevExpress

Description:

LIMS is the acronym for Laboratory Information Management System (LIMS). It is a system that allows laboratories to trace and track all samples or specimens that are received into the laboratory, tests performed, methods utilized, their results, any changes to results, control limits, QC values, and also track the analyst, date, and time of each step in the analysis process. BTLIMS is a product which has many modules needed to manage an Environmental testing lab; BTLIMS is customized for clients according to their need.

Responsibilities:

Involved in the complete Software Development Life Cycle (SDLC) for development process including Design, Coding, Testing and Maintenance.

Designed the GUI using Devexpress8.2/9.1/11.2 controls. Created XtraForms, XtraUserControls, XtraReports, Business Logic Layer, Data Access Layer Classes using VB and .Net 2.0/3.5/4.0.

As a team member, developing the application using VB.NET and sqlserver2005. Developed solutions for diverse programming scenarios in VB.Net, employing Object Oriented Programming (OOP) concepts such as encapsulation, inheritance, polymorphism, and abstraction.

Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation using SQLSERVER2005/2008.

Involved in database design, created tables according to requirements. Writing Queries using PL/SQL Statements, Views, User Defined Functions, Complex Stored Procedures, Triggers in MSSQLServer for inserting/Updating/Deleting the data into the relational tables.

Used Devexpress Grid View control to display page and sort multiple records. Extensively used Data grids, Data Tables and Datasets for Data manipulation.

Extensively worked on Devexpress controls like XtraGridView, XtraGridLookup, XtraLookup, CheckedListbox, Repository Controls for Data Entry and View.

Extensively used XML for data transfer across different systems.

Integrated various reports into the application the reports were created using Devexpress XtraReports.

Import/Export the Table/Reports into Excel/CSV/PDF/TXT Files.

Worked on perform coding, unit testing, error handling, bug fixing/verification.

Working with version controller Visual Source Safe (VSS) and Team Foundation Server (TFS) for maintaining history of source-code and project documents.

Involved in Deployment and Troubleshooting issues in the application.

Involved in writing Code Documentation.

Used BTLIMS Tracker for Bug Tracking.

Project : Sampling Field Entry

Client : BTLIMS Technologies, Houston, TX

Environment : Winforms using VB.NET, Visual Studio 2010, SQL Server 2008, DevExpress

Description:

The project Sampling Field Entry is a tablet application used to manipulate the laboratory

information at various locations. Those key features include the workflow of Laboratory

Information Management System and data tracking support, and smart data exchange by

downloading the data from XML file, entering the data in the field and exporting the data as an XML

into the FTP. This tablet application is also integrated with the BTLIMS to process the data in the

Sample Management module forms.

Responsibilities:

Design and Development of User Interface using VB.Net.

Implemented the 3-tier architecture with clear separation between various logical layers namely the User Interface, Business Logic and Data Access Layers.

Created the Classes for Reusability and Maintainability using OOPS.

Developed a Data Layer to populate the Data using ADO.Net and SQL Server.

Used XML for mapping data and send to Stored Procedure.

Created and maintained SQL Server Database objects like Tables, complex Stored Procedures, Views and SQL Joins, Functions.

Maintained and Administration of Database in SQL Server Management Studio (Regular Backup, Automatic Task).

Involved in Manual Testing to improve the quality of the product.

Used Visual Source Safe (VSS) Tools for Software Configuration Management.

Worked on Team Foundation Server(TFS) to maintain the source code, Daily Update/Comparison of Different Versions for Update.

Project : Project Login Automation

Client : BTLIMS Technologies, Houston, TX

Environment : Winforms using VB.NET, Visual Studio 2010, SQL Server 2008, DevExpress

Description:

The project Project Login Automation is an application used to automate the daily process in the laboratory based on the project setup; it required to enter the number of days to perform the automation before the scheduled date. This application automates the process by using the windows service. Automatic Process includes Creating Jobs, Creating and Uploading of XML files to the Sampling Field Entry (Tablet Application)

Responsibilities:

Developing windows service code in VB.Net

Coding to change the database frequently to work with the Windows service.

Used ADO.Net to establish database connectivity and data manipulation.

Design and Development of Databases, Tables, Views, Function and Stored procedures using SQL Server to Manipulate the records which are to be processed by the windows service.

Creating the windows service as a Setup and Installing and starting the windows service.



Contact this candidate