VELVIZHI RAMASAMY

Email: adoysj@r.postjobfree.com

Phone: 346-***-****

SUMMARY:

Although I have several years of experience in software development, I am interested in switching my job as a software tester in manual/automation testing

Have hands-on experience in developing TDD testing framework, Unit testing, API testing, performance testing, writing and review test cases

Have good knowledge in selenium automation test framework, JIRA Agile tool for SDLC, STLC, IntelliJ IDEA, Maven, JAVA JDK

Software Professional with 9.4 years of experience in developing .NET applications from various projects

Involved in complete SDLC including requirements gathering, client interaction, analysis, design, development, testing

Around 2 years of experience as onsite lead developer role in Lansdale, PA – involved in requirements gathering at client’s place, design, offshore team coordination, application development and delivery

Around 3 years of experience as offshore lead in Bangalore, India – involved in requirements gathering, design, daily stand-up meetings, weekly status meetings with onsite/off teams and stake holders, QA meetings with process teams, application development, sprint demos, integration testing and production moves

Strong experience in project inception and coordinate teams to execute projects under strict deadlines

Solid experience in design and development of N-Tier applications using .NET Framework 1.1/2.0/3.0/3.5/4.0/4.6, C#, VB.NET, Web Applications, ASP.NET, MVC .NET 2, 4 & 5, AJAX, ADO.NET, LINQ, Visual Studio.NET 2012/2010/2008/2005, XML, HTML 5, JQuery, Win forms, Angular JS 4 etc.

Proficient in separating UI, Business and Data Access layers

Experience in implementing advanced .NET concepts including WCF, LINQ; Multi-threading; .Net Remoting, Web Services using .NET, Web API, XML, SOAP; Objected Oriented Programming using UML, MS Visio and Familiar with Share Point Portal, BizTalk Server, and Content Management Server.

Experience also includes legacy systems using VB 6.0, ASP, COM/DCOM, HTML, DHTML, VBScript, JavaScript, and other technologies

Experience in Data Modelling, Database Tuning, Integration Services (SSIS), Reporting Services (SSRS)

RDBMS experience includes SQL Server 2012/2008/2000, Oracle 10g/9i, Access 2000 and programming using SQL, PL/SQL, TSQL, LINQ/ADO.NET, JDBC, DB query, OData query etc

Experienced with Waterfall & agile methodologies

Solid experience in MVC design pattern, repository pattern & other design patterns

Functional domain knowledge includes Engineering with The Timken Company, Clinical Services, Oil, Insurance, freight shipping and Healthcare with leading clients including UPS, Almac Clinical Services, The Timken Company

Experience in creating documentations for end users and for project itself

Experience in using TFS, IBM Clear Case, Tortoise SVN and Visual Source Safe (VSS) for versioning control

Possesses excellent communication skills and good team Player with extraordinary problem solving and trouble-shooting capabilities and will prove an asset to any project.

TECHNICAL SKILLS:

OS

Windows 10, Windows XP, Vista, Windows 7, Windows 8

Technologies:

.Net Framework 1.1, 2.0, 3.5, 4.0, 4.5, 4.6

Languages

C#, VB using .Net Framework

Database

SQL Server 2012/2008/2000, Oracle 10g

Others

MVC 4 & 5 .NET, ASP.NET, Angular 4 JS, WINFORMS, LINQ, ADO.NET, Entity framework, Crystal Reports, SSRS, SSIS, TSQL, XML, HTML, CSS, IIS, Web Services, WCF, Web API

Tools:

Visual Studio IDE 2012/2010/2008/2015/2017, Visual Source Safe, Tortoise SVN, Accenture internal tools for bug tracking and all SDLC phase tracking, IBM Clear Case, IBM Clear Quest, TFS, ALMAC AIM Tool sets

Strong Concepts

Dot Net Application concepts to develop Web Applications using MVC 4 & 5

Object Oriented Programming Concepts

Design Patterns

RDMS Concepts & writing complex T-SQL queries

EDUCATION:

B Tech (Bachelor of Technology) in Information Technology with distinction 76% from SASTRA University, India. (2001-2005)

TRAININGS & CERTIFICATIONS

Software operational procedure trainings in Almac's Master Control site, Lansdale PA, USA

Client Audit trainings at Almac, Lansdale, PA, USA

AIM (Almac Iterative Methodology) training at Almac, Pennsylvania, USA

NTT Data Learning Management System (LMS) trainings, online

SDLC training at Accenture, Bangalore, India

Lifecycle management trainings at Accenture, Bangalore, India

Training in Asp.net 2.0 & SQL Server 2005 at Calsoft, Chennai, India

Microsoft Certified Professional in SQL Server 2000

Taken 6 months J2EE certification course in NIIT, Chennai, India

PROJECTS IN DETAIL:

Company : Timken India Limited Sep 2014 to Oct 2018

Work Location : Bangalore, India

Designation : System Analyst

Technologies: Microsoft .NET Framework 4.0/4.5/4.6, C# ASP.Net, MVC 5.0, LINQ, ADO.NET, Entity framework, Web API, WCF, HTML, CSS, Jquery, Angular JS, NuGet, SQL Server 2012, Windows Server 2008 R2, Visual Studio 2017/2015/2010, Microsoft Office 2016, XML, TFS source control, IBM Web Spear MQ client, SSIS.

Timken Project 1: EDQ – Engineering Domain Query application

Engineering Domain Query or EDQ is the one place where different department engineers within The Timken Company review domain data and query by relevant search to fetch data from SAP systems. This application replaces legacy version of application was developed in Asp and data came through DB2. There are many Web API interfaced based on domain data like dimensions, product type, manufacturing and more to make communication between application and SAP systems.

Responsibilities:

As one of development lead in Connex I project, I was responsible for to migrate application/service from legacy technology to latest technology to ease future maintenance. Front end of ASP application re-written into ASP.NET MVC application. Major back-end data moved from DB2 to SAP systems and some to SQL Server

Requirements gathering from domain engineers from canton, USA. Design and developed engineering Domain Query application and Web API services required for EDQ to support Connex I project migration project

Responsible for sprint demos and deliverables

Hosting applications and services in appropriate application and web servers

Timken Project 2: PTPlace Customer facing application for The Timken Company

This is the place where data flows for all Timken customer checks price and availability of Timken products, place their orders, checks their placed products, other error and history of transaction details goes safely into SQL Servers. All data processing, business logic by country locations handles with .net broker components – Price Avail, Order, Order status, Error, History, and other custom configurations. This is a highly critical application for The Timken company.

Responsibilities:

Application maintenance person for .net broker components Price Avail, Order, Order status, Error, History and others

Implement approved change requests come through stake holders

Investigate behaviour of component by debugging .net broker component and produce results

Analyse load of system for the given period and produce results

Perform testing component in QA and release it for production servers and monitor system behaviour in the production system any day and anytime of week

Timken Project 3: PRT Modular Batch System

This system replaces the legacy applications into unified platform for automation of these workstreams moving

forward, increasing flexibility of job sequences without additional hard-coding, and expanding CAD generation to support both NX and ProE CAD systems. User Optimized Web based user interface, to enable users to track, manage, and view results for every job submission. For every job and/or design request, the user will be able to see, in real time, job progress at each processing step [queued, running, completed, error] as well as overall progress, Data compare results.

Responsibilities:

Requirements gathering from Timken system engineers and coordinate offshore development team to build PRT Modular Batch user interface and PRT Batch WCF service. Requirement collection through release in Production environment

Periodic design reviewed for Initial system design, interim change requests with technical managers, domain experts

As Lead and developer, developed application and service

Responsible for sprint deliverables, code review, coordinate with testing team to perform integration testing

Timken Other Project:

Developed SSIS projects to migrate data from DB2 to SQL Server applications to support engineering legacy applications and services to migrate them as part of connex I, II projects for The Timken Company.

Optimize and clean-up project to retain good data in SQL Server transaction tables using stored procedure logics to support Timken application called Installed Base. .net component developed to migrate data from MS Excel to SQL Server for the same application Installed Base.

Company : NTT Data Inc, USA Aug 2012 to Jan 2014

Client : Almac Clinical Services, Lansdale PA, USA

Work Location : Lansdale PA, USA

Designation : Principal Consultant

Responsibilities at ALMAC:

Work with client (Almac) in coming up with the Requirements

Collaborate with client and offshore team in conceptualizing the design

Implemented Proof of Concept for some of the challenging modules in project

Day to day coordination with offshore team in successful execution and delivery of the project

Perform design and code review on the project deliverables

Integration testing and debugging before client acceptance

Worked as developer in some of the Almac applications

Technologies: Microsoft .NET Framework 4.0, C#.Net, MVC 4.0 Razor, WINFORM, LINQ, ADO.NET, WCF, Web Services, SOA, AJAX, HTML, CSS, Jquery, SQL Server 2012/2008/2000, IIS 6.0/8.0/9.0, Windows Server 2008 R2, Visual Studio 2012/2010/2008, Microsoft Office 2010, XML, VSS, Infragistics controls, IBM Clear Case, Clear Quest, SSIS, SSRS, DB Tracking tool, Bug tracing tool, SOP, Quality Gate, Validation Processes, Development Templates.

ALMAC Project 1: DB Ticketing System for Almac

Responsibilities:

Built web application using C#.Net Model View Control 4.0

Gathered requirements, came up with Mock-ups for different modules, Deployment diagrams

Performed a detailed architectural analysis and spilt up the modules within the team

Tasks breakdown. Prioritize tasks, assign tasks to offshore team, Perform design reviews & Code reviews

Used HTML 5 and CSS for web page design and Data Annotations to Customize Data Classes

Code Implemented to handle request for Grid columns, Cascading dropdowns, Custom File format & others

Used LINQ to dynamically connect to respective SQL Servers & to make all DA Layer connections

Designed application database using SQL Server 2008. And distributed server specific SPROCs in

SQL Servers 2012/2008/2000

Created distributed deployment database design & implemented code LINQ establishes connections to SQL Server dynamically. Developed various SQL objects View/Tables/SPROCs/Triggers

Used Log4NET for error handling, Audit tables to track modifications to different modules of application

Gave weekly demo to PM and TM

Technologies: Microsoft .NET Framework 4.0, Visual Studio 2012, C#.Net, MVC 4.0 Razor, LINQ, AJAX, HTML 5, CSS, Jquery, Log4NET, SQL Server 2012/2008/2000, IIS 9.0, Microsoft 2010 Word/Excel/One Note/power point, IBM Clear Case, Clear Quest, TFS 2012

ALMAC Project 2: Incident Management System

Responsibilities:

Developed web application using C#.Net Model View Control 4.0

Used HTML and CSS for web page design and JavaScript for client-side validations

Responsible for gather requirements, design, development, hosting application

Implemented data modelling for the application using SQL Server 2008

Performed weekly demo to NPS Application Support team. Provided design solution for complicated tasks.

Implemented SSIS to import ‘NPS Application Support’ incident details to application database.

Implemented application to import ‘NPS Application Support’ rich content incident details from MS word to database tables. 500+ pages

Developed application inventory reports using SSRS. Application inventory report can be filtered based on Server, Application type, Server Names etc

Technologies: Microsoft .NET Framework 4.0, C#.Net, MVC 4.0 Razor, WINFORM, LINQ, ADO.NET, AJAX, HTML, CSS, Jquery, SQL Server 2008, IIS 8.0, Visual Studio 2010, Microsoft 2010 Word/Excel/One Note/power point, IBM Clear Case, Clear Quest, SSIS, SSRS

ALMAC Project 3: Database Projects

Responsibilities:

I was responsible for developing T-SQL scripts for various common/study server databases.

I had weekly project meet with team members (System Developer, Study developer, Technical Manager, Project Manager, and Product Owner) to find solution for blocking issues, understand top level management decisions, share current week findings & prioritize the tasks & script installations.

Performed unit test in desired environments

Taken care of documentation, script versioning in IBM clear case, uploading documents in master control

I worked closely with DBAs to install the scripts in all PROD environments

Technologies: SQL Server 2000/2008/2012, T-SQL complicated queries, Performance Tuning, IBM Clear Case, Clear Quest, Microsoft Office 2010 Word/Excel

ALMAC Project 4: Gateway

This is a System administration tool, which bridges all the Almac applications. The PMs, Medical study developers, testers, BAs and NPS developers/tests/BAs depend on this tool to update medical study details in the database based on privileges they have.

Responsibilities:

Implemented change requests for every Gateway release.

Worked with Product owner, team members to understand /review /clarify the requirements. Update FRS document, code implement, releases.

provide support to prod IT group & end users

Prioritize daily issues which were assigned by NPS Support team

Technologies: Microsoft .NET Framework 3.5, C#.Net, WINFORM, ADO.NET, WCF, Web Services, SQL Server 2008/2012, Visual Studio 2008, XML, Infragistics controls, IBM Clear Case, Clear Quest.

Company : Accenture Services Pvt Ltd, India

Client : United Parcel Service (UPS) May 2010 to July 2011

Work Location : Bangalore, India

Designation & Role: Sr. Net Developer

Project: Global Image Management System for UPS

GIMS is a software management project done by Accenture for providing paperless solution for UPS business

Responsibilities:

Developed a system based on Service Oriented Architecture utilizing .NET Framework 3.5 using C#

Performed a detailed architectural analysis and spilt up the modules within the team

Involved in gathering requirements from the business and documenting it for the team’s review

Involved in all SDLC phases from Requirement gathering, Design, Coding, Testing, Release, Support

Delivered high quality and high-performance applications

Developed application using Model View Controller (MVC) Pattern and used Singleton pattern with in WCF service business logic to avoid multiple authentication calls

Used JavaScript to build the rich text editor with file upload options

Used HTML and CSS for web page design and JavaScript for client-side validations

Created UML model diagrams using MS Visio

Used extensive AJAX programming to avoid the server-side overload

Used ADO.NET for data communication for the web application and the databases

Used extensively LINQ to SQL and LINQ to Objects within the business objects

Responsible for writing SQL Queries, Stored Procedures, functions, SSIS packages and Database Triggers using T-SQL

Involved in tuning expensive SQL queries and Stored Procedures for better performance.

Developed an SSIS package to extract the excel file from FTP location and import the data into SQL table using FTP file task

Developed & consumed WCF Web Services in the business logic of the application and tested the services using SOAP UI

Hosted WCF services in IIS

Used caching to improve the performance of the application

Involved in developing reports using crystal reports, active reports and generated the PDF output

Used Star Team (VSS) for version controlling and configuration management

Handled application using multithreading concepts

Performed Nunit tesing in applications

Object Oriented Programming concepts & followed coding practices

Created technical documentations and as well as training materials for the end users

Technologies: Microsoft .NET Framework 2.0/3.5, C#.Net, ASP.NET, MVC2.Net, WINFORM, .NET, LINQ, WCF, Web Services, SOA, SOAP, AJAX, HTML, CSS, JavaScript, Jquery, SQL Server 2005, IIS 6.0, Windows 2003, Visual Studio 2005/2008, Microsoft Office, XML, VSS.

Company : California Software Pvt Ltd. June 2006 to Mar 2009

Work Location : Chennai, India

Designation : Programmer Analyst

Project 1: Fuel Procurement Management System for A.P. Moller-Maersk

Client: A.P. Moller-Maersk, Denmark

Fuel Procurement Management System (FPMS) solution is implemented at their Denmark, Singapore, US offices. FPMS are a simple and easy to use procurement solution for oil shipping companies. The solution facilitates coordination for fuel oil procurement and supports decision making for cutting fuel costs, improving quality, and managing fuel price risks

Responsibilities:

Implemented ASP.NET provider models like Role, Session, Sitemap, Membership providers

Implemented Master pages, Themes, CSS for rich user interface

Implemented complex business functionalities like file uploading, letter generation using C#

Developed reusable parameterized .ASCX user controls to be used in various web pages

Implemented AJAX, XML, and XSL in the application to provide user friendly interface to the user

Used LINQ within collection objects to filter the data

Developed Service Oriented Architecture (SOA) based system with Windows Communication Foundation (WCF) hosting plans and coverage codes

Consumed existing SOAP based web services by creating proxy objects using wsdl.exe tool

Used SOAPUI to test the web services

Implemented Exception Handling, Data Access Layer and Event logging using Microsoft Application Blocks

Created XML based stored procedures in SQL Server to avoid multiple calls from Data Access layer

Reporting to client based on requirements using SQL Server Reporting Services (SSRS)

Developed tools, created scripts, and setup systems for a one-step scripted build including unit testing, functional testing and automated the test cases

Developed couple of SSIS packages to read CSV files to import the data into staging and master tables and scheduled a job to run once a day

Used XML package configuration to deploy these packages

Customized existing WPF Client/Server application using XAML

Used VSS for versioning control

Technologies: C# ASP.NET, VB.NET, Framework 2.0/3.5, SQL Server 2000/2008, IIS 6.0, VS 2005, Windows Server 2003, Windows application, Jquery, JavaScript, HTML, CSS, VSS

Project 2: Bunkering and commodity solutions for FALOIL, Sharjah

Client : FALOIL, Sharjah

Calsoft’s oil bunkering and commodity solutions products called DeRisk, and OBIS (Online Bunkering Information System) are customized and used for FALOIL Sharjah. APPX is an open-source system used by the FALOIL to maintain the Supply & demand, Inventory, Invoicing for its Sales & Purchases

Responsibilities:

Involved in Requirements gathering, project customization, enhancement of applications

Customized existing windows applications based on requirements

Introduced term contract type in Derisk application for OIL bunkering

Was responsible for preparing design documents, Code review documents, Unit test cases which are meet CMMI level 5 capabilities

Involved in support after product release and proposed new requirements.

Database design using SQL Server 2000. Created DDL, DML scripts to run on client database.

Normalized database to eliminate redundancy, reduce potential for data anomalies

Wrote stored procedure, functions, triggers using T-SQL

Implemented data access layer using ADO.NET

Developed Ad-Hoc reports using Crystal Reports

Used Crystal Report viewer control with in ASP.NET to display reports data

Technologies: VB.NET, Crystal Reports, SQL Server 2000, Framework 2.0, XML, SVN Tortoise, Bug tracking tool, Windows Server 2003

Project 3: ACS (AmeriNational Community Services Inc., a subsidiary of Americana National Bank) for AMERINATIONAL LOAN INFORMATION AND SERVICES, UK

Client: AMERINATIONAL LOAN INFORMATION AND SERVICE, UK

The system (ALIAS) provides a reliable solution to ACS to manage the Insurance, loan (housing & mortgage), disbursing, Collection, Invoicing, and it is intended to provide monthly and yearly reports

Responsibilities:

Involved in all the phases of software development life cycle

Performed analyses of business requirements. Design system architecture, design, and code in accordance with the Clients' requirement.

Involved in preparation of Low-Level Design document, Unit Test Case, Impact Analysis documents

Created various SQL Objects for the application

Incorporated proven calculation method in ACS windows application

Import Microsoft excel data to database using ADO.NET framework

ADO.NET to communicate with windows application and databases

Coordinated and collaborated with other team members to design, build second generation ACS applications

Generated reports using crystal reports

Generated dashboard graphical daily/weekly/monthly/yearly reports for analysis

Configured and normalized and SQL Server query language

Performed 24/7 production support as needed

Created user guide document for the modules which I worked on for the second generation of ACS application

Technologies: VS 2005, .NET Framework 2.0, ASP.NET, C#, Crystal Reports, SQL Server 2000, windows server 2003, MS Excel, Dashboard report plug ins, Microsoft spread sheet, xml

Project 4: Clarus, from American Health Net (AHN)

Client: Lavaca Medical Centre, Smith Valley Hospital (USA)

American Healthnet has been in operation since 1980 and has been providing enterprise information systems to various community healthcare facilities. Clarus, from American HealthNet provides a paperless, completely integrated EMR (Electronic Medical Records) using Windows technology and provides an integrated system with over thirty applications.

Responsibilities:

Involved in product maintenance for Patient Registration windows application

Generated crystal reports for Payroll and Time and Attendance windows applications

Responsible for creating design document, Impact Analysis, Test plans & Test cases

Implemented calsoft intranet application for time and attendance application

Created technical documentation and user guide document for end user

Taken training in ASP.NET, SQL SERVER from Microsoft certified training institute

Participated system testing sessions and product trainings

Technologies: VS 2003, .NET Framework 1.1, ASP.NET, C#, SQL Server 2000, windows server 2003, Visual Source Safe, bug tacking tool

Contact this candidate