.Net Project Business Development Sql Server Software
Resume:
Swapna Akarapu
________________________________________________________________
********@*****.***
Austin, TX 78728 Cell Ph: (512)
Professional Summary:
. Worked as a software engineer for the past 7 years in various software
technologies, product development, web development and intranet
developing.
. Involved in every phase of software life cycle, Requirements analysis,
Designing, Development, Implementation, Testing, Risk Analysis and
evaluation, Change control and Configuration Management.
. Developed web based and windows based applications using ASP.NET,
VB.NET, C#, Visual Basic 6.0, CSS, LINQ, ADO.NET, ADO, WCF and XML.
Developed XML Web Services in .NET. Also worked with standalone
applications.
. Extensively worked in designing and developing of .NET Assemblies and
COM/COM+ components.
. Very strong in Object Oriented Analysis and Designing (OOA and OOD),
Object oriented programming (OOPS) including in depth knowledge of
.NET Remoting, Memory Management and Garbage Collection.
. Possess in-depth knowledge in SQL Server 2005/2000 with technologies
such as Stored Procedures, Views, Triggers and Enterprise Manager.
. Excellent programming skills in C#, C++, VB 6.0, ASP.NET, JAVA with
latest modeling technique like UML and object oriented principles.
. Employed Agile-SCRUM software development methodology resulting in
on time, on budget deliveries with low defects and high customer
satisfaction.
. Innovative and results driven professional with excellent
technical, business, and communications skills.
. Extensive knowledge in Software development, Software
configuration, build and release processes, Software testing and
installation etc.
. Team player with commendable Lead qualities, infectious positive
attitude and strong communication skills.
CERTIFICATIONS
. Microsoft Certified Application Developer(MCAD)
. Certified in C++ Track -Austin Community College.
. Certified in Java - Austin Community College.
. Brainbench Certification in C#.
COMPUTER SKILLS
DotNet : C#, ASP.Net, ADO.Net,,LINQ,Web & Windows
Services, WCF
Components : .Net Components, COM+, ActiveX, COM, XML, SOAP,
Languages : C, C++, Visual C++, SQL, PL/SQL, Java, COBOL
Operating Systems : Windows 2003/2000/XP/NT, UNIX, MS-DOS
Distributed Technologies : COM / DCOM, RMI, EJB.
Databases : MS SQL Server 2005/2000, Oracle 10g, MS Access
2000
Database Connectivity : ADO .Net 2.0, ADO, ODBC, OLEDB, JDBC
Web Servers : IIS 6, Apache Web Server, Tomcat, Java Web Server
Packages : Dreamweaver 4, Matlab 5.3, MS-Office 2000
Web Technologies : ASP .NET, ASP, XML, XSLT, Servlets, JSP, Perl,
CGI
JavaScript, VBScript, HTML, CSS
GUI : Visual Basic 6.0, Jbuilder 4.0, Java (JFC/Swing),
Config. Management Tools : Visual Source Safe, WinCVS,TSF and SVN
Professional Experience:
PROJECT DETAILS
Title : .Net Developer
Company : UniMed Direct (Austin TX)
Duration : August 10 - September 10
Team Size : 5
Environment : .Net 3.5, C#, ASP.NET, LINQ, MS-SQL Server 2005,
XML, WCF
Visual Source safe, IIS 6.0, CSS, JavaScript, MS-Visual Studio
2008/2005,
Windows 2000/2003 server, Infragistics, Resharper.
UniMed Direct is a medical cost containment company focusing primarily
on the property and casualty insurance market, which includes workers'
compensation, auto casualty and liability.
. Involved in development and maintenance using ASP.NET, Visual Studio
.NET, C#, HTML and JavaScript.
. Created a User Control for file uploading and saving documents to
concern table with validation and confirmation using JavaScript and
popup modal.
. Involved in the design and development of the application using a
Service Oriented Architecture using WCF Services.
. Worked on Presentation, Data Access and Business Logic layers of the
application.
. Worked extensively with GridView in ASP.Net and WCF services for data
transformation between the Business layer and the database layer.
. Implemented form based authentication for the customers and the users
based on their access level.
. Developed stored procedures, triggers for the application in SQL Server
2005.
. Define and manage database content using LINQ to SQL.
Title : Programmer/Analyst
Project : Venti Consulting (Austin TX)
Duration : March 10 - July 10
Team Size : 5
Environment : .Net 3.5, C#, ASP.NET, LINQ, MS-SQL Server 2005,
XML, XSL, Subversion,
IIS 6.0, NUnit, CSS, JavaScript, MS-Visual Studio 2008/2005, Windows
2000/2003 server.
City-Grocery is an online portal dedicated to provide customers with a
rich and cost saving shopping experience. They offers all your favorite
brands at great prices with free home delivery. Services like Gift
Certificate, Loyalty Program and Referring a Friend are also provided.
Customers are provided the ability to create shopping lists from
previous orders for easier and convenient shopping.
. Involved in development and maintenance of City-Grocery portal using
ASP.NET, Visual Studio .NET, C#, XML, HTML and JavaScript.
. Created a windows service that automatically sends an email to all
customers when there is any update to the products in their shopping
list.
. Involved in the design and development of the application using a
Service Oriented Architecture using Web Services.
. Worked on integrating the authorize.net payment gateway with the
checkout process.
. Developed HttpModules, HttpHandlers and several utility classes in C#
to meet URL rewriting, JavaScript compression and user authentication
requirements of the website.
. Worked on Presentation, Data Access and Business Logic layers of the
application.
. Involved in validating the data like username, password and email
fields, using validation controls in the Asp.Net and JavaScript.
. Worked extensively with DataGrid in ASP.Net and XML For data
transformation between the Business layer and the database layer.
. Implemented form based authentication for the customers and the users
based on their access level.
. Developed functions, stored procedures, triggers for the application in
SQL Server 2005.
. Define and manage XML content using LINQ.
. Worked on Preparation of Requirement Specification Document, Technical
Specification Document and Functional Specification document for the
project.
. Designed use cases, activity, sequence, collaboration and class diagram
using MS-Visio for generating the prototype.
. Involved in unit testing and integration testing of the application
that is developed, to validate functional requirements.
. Employed Subversion for version control of source code.
Project : Venti Consulting (Austin TX)
Duration : Nov 08 - Dec 08
Team Size : 5
Environment : Visual Studio 2008 and ASP.NET C# Language,
.Net Framework 3.5
Windows Installer 3.1, Team Foundation
System, MS SQL Server 2008.
Venti's HRTools project was to deliver the user defined job
descriptions and employment policies.
I was involved in Project Requirement Documentation, Analysis and
Design for HRTools, Worked
on business layer.
. Designed and developed WebPages using Asp.net and JavaScript.
. Worked on documentation to produce a chm file and html file using Sand
Castle HelpFinder.
. Analyzed existing project to find the feasibility and requirement of
additional modules.
. Designed and coded additional modules according to the requirements.
. Used Team system foundation for version control of source code.
Project : Advanced Micro Devices (AMD, Austin TX)
Duration : Jan 08 - Oct 08
Team Size : 8
Environment : Visual Studio 2008 and ASP.NET, C# Language,
.Net Framework 3.5
Windows Installer 3.1, MVC,Windows
Communication Foundation (WCF)
Integration,LINQ, NUnit2.4.6,
MS SQL Server 2005,SSIS.
Co-Lead and mentor software development team for an on-line Auto
Scheduling Factory Planning On-Line System to automate Assembly
Scheduling; Testing, Mark and Pack(TMP)
Processing in coordination with manufacturing facilities
located in Penang, Singapore and Suzhou.
. Project Requirement Documentation, Analysis, Design and
Developed implementation of GUI website for Factory Planning
System Prototype Phase.
. Developed Automated builds using Nant for Factory Planning
System to run on production servers.
. Developed SSIS packages for transferring the existing data from
Oracle, MySQL using Business Intelligence Development studio and
Scheduled them using SQL Server Agent.
. Involved in creating complex store procedures and triggers.
. Developed email notifications in HTML format for confirmations
and errors using SMTP server.
. Developed custom paging and sorting for faster and efficient
results for all WebPages.
. Developed test cases for window based applications in C# and
implemented testing on WebPages using NUnit tool.
. Employed WinCVS and SVN for version control of source code.
Project : BillServ Inc, San Antonio, Texas.
Duration : May 04 - Dec 06
Team Size : 12
Environment : Visual Studio,C #, VB,ASP.NET,
ADO.NET, Web Services, VB 6.0, MSXML,
MS-SQL Server, 2K, DTS,
IIS, JavaScript, Windows 2000/2003 server.
Billserv delivers comprehensive, cost effective solutions for presenting
and servicing consumer bills for secure and reliable payment via the
Internet, as well as tools to quickly drive consumer adoption of its
clients' EBPP (Electronic Bill Presentation and Payment) solutions. As part
of an integrated EBPP solution, Billserv also provides market-leading
Internet customer care and direct marketing applications. Additionally,
Billserv provides products and services that meet a variety of e-commerce
and Internet-based technology needs.
. Worked in close collaboration with the project managers and business
users to gather, analyze and document the functional requirements.
. Envisioned and built front-end for the site written in ASP.NET, MS
Visual Studio .NET, C#, XML, XPATH, XQUERY, HTML and JavaScript.
. Developed ASP.net user controls using C# code behind.
. Developed C# middleware components related to the ASP.Net application.
. Developed XML web services for the business layer to communicate with
the application layer.
. Involved in the Integration of .NET and VB 6 COM objects.
. Building a cache manager to provide the caching needs of the site.
. Developed a windows service email system that would render emails for
client/customer activity notification.
. Developed a DTS package that would generate an excel file, with daily
business vitals.
. Created sophisticated SQL Server database to responsively handle
complex queries (T-SQL, DTS, triggers, stored procedures, functions,
optimization) and .NET data access components.
. Developed an Installation Application using VB 6.0 that would update
web servers with the latest code, image files, registry settings and
also updates the SQL Server database.
. Created code documentation using Visual Studio .Net and Ndoc.
. Employed Visual Source safe for version control of source code.
Search Engine
Allows the users to search on various models based on region, length and
price etc
. Involved in the design and development of a service-oriented
architecture (SOA), using C#, that can be seamlessly integrated with
the existing systems.
. Implemented the Singleton design pattern to implement caching of most
recent search results.
. Deployed XML Parser and DOM Model to validate XML documents and used X-
path to query data in the XML file.
. Designed and developed SQL Server 2000 stored procedures and triggers
for the search application.
Programmer/Analyst, ITW Signode LLC. India
Project : Learning Management System
Duration : Nov 01 -Dec 03
Team Size : 8
Environment : C#, VB .Net, ASP .Net, VB 6.0, COM, ASP, VBScript,
MSXML, MS-SQL Server 2000, Oracle 9i, IIS,
JavaScript, HTML, Active Directory, Windows 2000.
ITW Signode LLC provides Web-based e-learning software for online corporate
training and evaluation, including development tools for tailoring
courseware to specific applications. The company's software offerings
include ITW for learning environment management and progress monitoring;
ITWCore for identifying training needs; ITW Assess and ITWPublish for
capturing the knowledge of retiring workers and training new employees.
. Worked with client and other team members to construct and validate
required project documents.
. Developed ASP.Net web forms for ITWAssess and ITWPublish Modules using
ASP.NET, MS Visual Studio .NET, C#, HTML, CSS and JavaScript.
. Developed a C# .Net web service for third part content providers to
report user performance metrics.
. Implemented business logic as .NET Framework assemblies using C#.
. Involved in the development of an Object Model, using UML, for the
existing ITWLearn LMS.
. Developed an E-commerce tool that utilizes a COM object that would
interact with authorize.net component to facilitate credit card
transactions.
. Implemented user security in applications based on Active Directory
settings.
. Converted VB 6 Com objects to C# .Net components.
. Developed a data entry and report generating application for a Question
Engine using MS-Access and VBA.
. Helped client with optimization of existing code.
. Worked with ASP and VBScript to support older versions of the product.
. Developed SQL stored procedures for Data manipulation at the database
server.
. Was responsible for writing a number of sophisticated Data
Transformation Services (DTS) in T-SQL in SQL Server.
. Involved in unit testing and integration testing of the components
developed to validate functional requirements.
EDUCATION
. Bachelor of Science in Computer Applications - GPA 3.7 / 4.0
Osmania University, Hyderabad, India.
. Post Graduate Diploma in Computer Applications - GPA 3.6/4.0
Osmania University, Hyderabad, India.
REFERENCE: Furnished upon request.
Contact this candidate