Sql Server Quality Assurance
Resume:
Vasantha G
Software Developer
Email: ***********@*****.***
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