Vasantha G

Software Developer

Email: acafnb@r.postjobfree.com

Phone: 832-***-****

Objective:

Seeking a technically challenging position as a

Software/Application Developer, providing a highly motivated, progressive,

friendly environment which allows the pursuit of career advancement and the

expansion of my knowledge and skills

Summary:

. 3+ years of programming experience in .Net Languages.

. Experience in Design and Development of Enterprise-level applications

using Microsoft Technologies.

. Demonstrated capacity to successfully manage all phases of IT Projects

from need analysis and business requirement definition to implementation,

testing, deployment and maintenance.

. Experience in using .NET technologies -C#, VB.NET, ASP.NET 1.1/2.0/3.5,

ADO.NET, and XML/XSLT.

. Experience in using IBM WebSphere MQ 7.0 to process the transactional

message asynchronously from one system to another system.

. Expertise in Web forms GUI development including Client and Server

Components, Custom Controls, User controls, ADO.NET.

. Extract,Transfer and Load data from existing server to new server using

Sql Server Integration Server (SSIS) in Sql Server 2005

. Experienced in Creating Stored Procedures, Functions, and Triggers SQL

Server 2005/ SQL Server 2008.

. Excellent knowledge of Windows application development (Win Form, Windows

Service etc.).

. Proficient in XML, XSD, and XSLT (XSL Transformation).

. Hands of Experience on generating Crystal reports as per requirements.

. Experience in designing and developing HighJump Supply Chain Advantage

9.0 dashboard screens for warehouse operations.

. Experience with full Software Development Life Cycle (SDLC).

. Experience in Team Foundation Server (TFS) 2008 for project version

control and maintenance.

. Troubleshooting performance issues, fine-tuning queries and stored

procedures using tools like Query Execution Plan, SQL Profiler and Index

Tuning Wizard.

. Extensive knowledge on SQL Server Import and Export Wizard tool to import

and export the data to and from the database.

. Quick learner, exceptional problem-solving and trouble-shooting

capabilities.

Education:

Masters in Computer Science, University Of Houston - Clear Lake,

Texas, U.S.A

Masters in Computer Science (M.C.A), Nagarjuna University, Guntur, Andhra

Pradesh, India.

Bachelors in Computer Science, Nagarjuna University, Guntur, Andhra

Pradesh, India, India

Attend training in C, C++, C #.NET, VB.NET, ASP.NET 3.5 and SQL Server

2005/2008 in

Naresh Technologies, Hyderabad, India

TECHNICAL SKILLS

. Programming Languages: C, C++, C #.NET and VB.NET.

. Web Technologies: ASP.NET 3.5, IIS, Web Services, JavaScript, HTML,

XML, and XSL.

. Operating Systems: Windows 95/98/NT/2000/XP/2003/2007/vista/Windows

2003 Server, Dos, and UNIX.

. Databases: SQL Server 2005/2008, PL/SQL, DBMS, and MS Access.

. Database Techniques: ADO, ADO .NET, and ODBC.

. Web Servers: Microsoft IIS.

. Software/IDE/Tools: MS-Office, Microsoft Visual Studio 2008, IBM

WebSphere MQ, HighJump Supply Chain Advantage 9.0, Business

Intelligence Development Studio (SSIS).

. Reporting Writer: Crystal Reports XI

. Version Controls: TFS 2008

. Design Tools: Visual Studio .Net, Microsoft Visio,

. Applications: Microsoft Office (Word, Excel, Visio, and Power Point).

EXPERIENCE

Software Developer

Oct'

2011-Present

99 Only Stores, Texas, U.S.A

Business Integration Framework (BIF):

"BUSINESS INTEGRATION FRAMEWORK (BIF)" project is designed to receive,

transform, and publish different warehouse transactions (Like Store

order creation transaction, Item receiving transaction, Inventory loading

transaction, Shipping transaction and so on.) from different input

systems to different subscribe systems.

BIF is a combination of two different .NET applications; 1) "HighJump

Transactional Interface" (HTI) 2) "Standard Transactional System

Interface" (STSI)

"HighJump Transactional Interface" application is a .NET windows service

application which runs continuously on the application server to check

for new transactional messages (which are in the form of xml format) that

are logged onto the database and post those new transactions on to the

IBM WebSphere MQ queue.

"Standard Transactional System Interface" application runs on the IBM

WebSphere MQ queue to pick up the new transactional messages from the MQ

queue and transform those messages in standard transactional xml message

format that is required by the subscribe subsystems and post the standard

transactional message to subscribe subsystem queues.

Environment: Visual Studio .NET 2008, VB.NET, ADO.NET, Windows Services,

MS SQL Server 2008, T-SQL, XML, TFS, IBM WebSphere MQ, Windows server

2003, and Microsoft Visio 2010.

Job Responsibility:

. Gathered business requirements and designed the application as per

requirements.

. Created Visio diagrams to present the higher- level and lower- level flow

of the project.

. Programmed ADO.NET for communication between application and database,

used extensively Data Set, Data Table, Data Reader, and Data Adapter.

. Developed code in VB.net to connect to the MQ queue to put the message

(from database) to the queue and send the message to subscribe subsystem

out of queue.

. Developed Data Access objects as per application architecture.

. Developed code to perform XML schema validation for the transactional

message before passing the message to the MQ queue.

. Worked on IBM WebSphere MQ Version 7.0 for creation of the MQ queues

(Application queue, Initiation queue, Process definition, and service

definition) to process the transactional message asynchronously from one

system to another system.

. Involved in design and development of the database.

. Created tables, indexes, PL/SQL stored procedures and queries as per

business requirements.

. Worked on Team Foundation Server (TFS) version 2008 to build the project

and for version control.

. Worked on bug fixing for the total project during post production.

. Provided immediate QA support as needed to address any issues.

. Documented both QA and Production deployment plans.

. Documented all the coding involved.

Transportation Management System (TMS) Interface:

"TRANSPORTATION MANAGEMEN SYSTEM" program creates routing information of

trucks (truck scheduling information- where the truck should go first for

delivery) based on the orders that are created for the day per store and

keeps that information in XML format. Transportation department employee

will move the xml file to a network shared location. TMS interface is a

SQL server job that runs SQL Server Integration Service (SSIS) package

checks for the XML file dropped by TMS program with route/truck

information in shared network folder. TMS interface will parse through

XML file for truck, route, sequence, warehouse order, and store

information to populate in respective database tables for user reference.

Environment: Microsoft Visual Studio for Application (VSA), VB.NET,

ADO.NET, SQL Server Business Intelligence Development Studio (BIDS), MS

SQL Server 2005, T-SQL, XML, Windows server 2003, and Microsoft Visio

2010.

Job Responsibility:

. Gathered business requirements and designed the application as per

requirements.

. Created Visio diagrams to present the higher- level and lower- level flow

of the project.

. Developed SSIS script task in VB.net to parse the XML file for specific

nodes to find transportation relation information and to insert the

information in respective database table.

. Programmed ADO.NET for communication between application and database,

used extensively Data Set, Data Table, Data Views and Data Adapter.

. Created SQL server job to execute SSIS package for every 30 minutes at a

specified time.

. Setup email notification in SQL server job to send e-mail to systems

group in case of SQL server job fails to execute.

. Involved in design and development of the database.

. Created tables, indexes, PL/SQL stored procedures and queries as per

business requirements.

. Provided immediate QA and Production support as needed to address any

issues.

. Documented both QA and Production deployment plans.

. Documented all the coding involved.

Purge and Archive System:

Created SSIS project to purge and archive data from active database

tables to history tables to improve database performance and user

productivity. A SQL server job that runs SSIS package cleans the data

records (Records which are older than the specified number of days) from

active tables and insert into history tables. The data in the history

tables will be used for future reference for a specified number of days.

Environment: SQL Server Business Intelligence Development Studio (BIDS),

MS SQL Server 2005, T-SQL, Windows server 2003, and Microsoft Visio 2010.

Job Responsibility:

. Gathered business requirements and designed the application as per

requirements.

. Created Visio diagrams to present the higher- level and lower- level flow

of the project.

. Developed SSIS control flow and data flow designed surfaces to purge data

from active table and archive to history tables

. Programmed SQL query by specifying how long the data records can be

accessible in active tables.

. Created SQL server job to execute the SSIS package

. Setup email notification in SQL server job to send e-mail to systems

group in case of SQL server job fails to execute

. Involved in design and development of the database.

. Provided immediate QA and Production support as needed to address any

issues.

. Documented both QA and Production deployment plans.

. Documented all the coding involved.

Warehouse Dashboard screens and Crystal Reports development:

99 Cents Only Stores uses third party software called HighJump for

warehouse management. HighJump software provides webwise page editor tool

to design and develop dashboard (Webwise Dashboards Provides strong

visibility into distribution operations) pages for warehouse users.

Crystal Reports is a third party software package that WebWise uses to

generate, display and print reports.

Environment: Business Objects XI, HighJump Supply Chain Advantage 9.0, MS

SQL Server 2005, T-SQL, Windows server 2003, and Microsoft Visio 2010.

Job Responsibility:

. Gathered business requirements and designed crystal reports as per

requirements.

. Created Visio diagrams to present the higher- level and lower- level flow

of the project.

. Designed crystal report for dashboard screens using Business Objects

Crystal Reports XI software

. Programmed SQL query to represent the data on the crystal report.

. Designed and programmed SQL code to develop dashboard pages.

. Involved in design and development of the database.

. Created tables, indexes, PL/SQL stored procedures, Functions, Triggers

and queries as per business requirements.

. Provided immediate QA and Production support as needed to address any

issues.

. Documented both QA and Production deployment plans.

. Documented all the coding involved.

Software Developer Intern

May 2011-

Aug' 2011

GetUs ROI LLC, Texas, U.S.A

. GetUs ROI is expertise in implementing Warehouse Management Systems

(WMS), RFID systems and software development & implementation.

. "CAROUSEL COMMUNICATION SYSTEM" is a reliable software application for a

warehouse management system development. The application consists of four

modules; those are receiving items from a warehouse, storing those items

into the horizontal carousels with in the warehouse, picking relevant

items from a particular storage location, and then loading\ shipping the

items to the customer specified address. Moreover, if we specify the

quantity of a particular item, the application will give the number of

similar quantity items with in the warehouse system. In addition, with in

the carousel communication system we have client-side logging and server-

side tracing tools in order to provide user friendliness.

Environment: VB.NET, HTML, XML, SQL, ASP.NET, and ADO.NET, MS SQL

Server 2005, and T-SQL.

Job Responsibility:

. Analyzed requirements and defined the development approach.

. Created Visio diagrams to present the higher- level and lower- level flow

of the project.

. Developed code in VB.net.

. Creating Bar-Code for shipping labels.

. Develop ASP pages for front-end screens and validations using

JavaScript.

. Enhancing code and creating setup packages.

. Design and write UI ASP.NET pages and database logic.

. Testing Code, ensuring quality assurance and implementing into

production.

Environment: C#, ASP.Net, XML, Web Services, Web Forms, Windows Forms,

Windows Services, TFS, ADO.NET, Dataset, Data Grid, Visual Studio.NET

2008, HTML, JavaScript, HTML, CSS, IIS 4.0/5.0, MS SQL Server, Office

2007 and Windows 2003 Server.

Career Path (Master's Project)

Jan' 2011- May

2011

University of Houston-Clearlake, Texas, U.S.A

The project is aimed at developing an online search Portal for the

Placement Department of the college to manage the student information

with regards to placement. The system is an online application that can

be accessed throughout the organization and outside as well with proper

login provided. Students logging should be able to upload their

information in the form of a CV. Visitors/Company representatives logging

in may also access/search any information put up by Students.

Job Responsibility:

. Analyzed requirements and defined the development approach.

. Enhancing code and creating setup packages.

. Developed code in C#.NET.

. Design and write UI ASP.NET pages and database logic.

. Testing code, ensuring quality assurance and implementing into

production.

Teaching Assistant

Aug' 2010 - May 2011

Department of Mathematical Sciences

University of Houston- Clear Lake, Texas, U.S.A

. Conducted office hours for many courses (Abstract Algebra; Real Analysis;

Linear Algebra; Ordinary Differential Equations and Dynamical Systems;

Mathematical Software & Modeling Simulation; and Numerical Analysis) to

help clear post-lecture doubts of students.

. Developed assignments for Abstract Algebra, Mathematical Software &

Modeling Simulation; and Numerical Analysis.

. Graded and provided feedback on student assignments.

. Worked effectively in teams during group projects and labs.

Research Assistant in NASA

Jan' 2010 - Aug' 2010

Department of School of Business

University of Houston- Clear Lake, Texas, U.S.A

. Conducted research on a project granted by NASA Johnson space center and

developed a conceptual analytical framework.

. Conducted Research on data of contractors, those having contract with

NASA during the FY 2000-2009 from the website (www.usaspending.gov).

. Gave presentations to subjects participating in research and help to

collect data.

. Maintained productivity and proactively address ambiguities in the data

collection process.

HONOURS

. Secured highest percentage of marks in freshman, sophomore, junior and

senior years of Bachelor's.

. Recipient of Gold Medal in undergraduate college for my standing as the

top student in the Department of Computer Science.

. Presented three papers at three different National Level Technical

Symposiums.

. Participated in THE GREAT INDIAN MIND CHALLENGE- 2006 conducted by IBM

India.

References: Available on request.

Contact this candidate