Sql Server .Net Developer Development Manager
Resume:
SUGANYA SAMPATH KUMAR
******@*****.***
. Over 7 years of hands-on experience in Client/Server, Multi-tier
and Windows & Web applications development with active
involvement in all the phases of SDLC such as design,
development, deployment and testing.
. Experienced in Analysis and Design with strong OOAD concepts.
. Experienced in User Interface development. Involved in
developing use case documents using UML notations.
. Good knowledge and experience of .NET Framework 3.5 and 3.0
features, WPF and WCF.
. Experience in web development using C#, VB.NET, XML, HTML, CSS,
Silverlight, AJAX, JavaScript and VBScript.
. Excellent data layunter programming skills using PL/SQL, T-SQL Stored
Procedures, Functions, Views and Triggers.
. Experienced in SQL Server Reporting Services (SSRS, Crystal Reports),
SQL Server Integration Services (SSIS) & Data Transformation Services
(DTS).
. Involved in the testing process by performing both manual and
automated testing.
. Good Knowledge and Experience in Service-Oriented Architectures (SOA),
TFS.
. Highly organized with the ability to manage multiple projects and meet
deadlines.
. A team player with excellent interpersonal, communication and
presentation skills.
. Experience in interacting with clients, collecting requirements,
preparing test cases, doing testing.
Education
Master of Computer Applications : Anna University, India.
Bachelor of Commerce : Madras University, India.
Technical Skills
Programming Languages : C# 3.0, C, C++, VB.Net, VB 6.0, PL/T-SQL
.Net Technologies : .Net Framework 3.5/3.0/2.0/1.1, ASP.Net, ADO.Net,
Web Forms,
Win Forms, Web
Controls, User Controls, Web Services, Windows Service,
WPF, WCF, Visual Studio 2003/2005.
Databases : SQL Server 2008/2005/2000, MS Access, Oracle 8i/9i.
Operating Systems : Windows NT 4.0/2000/XP, Windows 95/98, Windows
Server 2003.
Servers : Windows Server 2003, IIS.
Web Based : HTML, CSS.
Reporting Tools : Crystal Reports
Scripting Languages : JavaScript.
Tools : MS Visual SourceSafe, InstallAnywhere 2009, ClearCase 03.06,
ClearQuest 2003.06, Adobe Photoshop, MS Office, UML.
Work Experience
NetScout Systems, MA July 2009 - Till
Date
.Net Developer
Sniffer Analysis is a WinForms Application, which provides direct access to
InfiniStream devices, which benefits the customers depending on whether
nGenius Performance Manager is already deployed in your environment. If not
using nGenius Performance Manager, it provides various tasks such as mining
data, viewing statistics, decoding packets and viewing expert analysis. If
using nGenius Performance Manager, customers can deploy Sniffer Analysis in
situations where nGenius Performance Server is either temporarily
unavailable or impractical to use.
Responsibilities:
. Involved in design and development of the WinForms application
development.
. Designed using OOAD technologies. Involved in designing UML diagrams.
. Worked on multiple interfaces to provide different views of network
data.
. Worked with the design pattern Model, View, View-Model (MVVM) design
pattern in developing the application.
. Involved in UI development using Windows Presentation Foundation (WPF)
in Extensible Application Markup Language (XAML).
. Worked in Authentication and Authorization concepts of application
development.
. Implemented role based security and customizable workflows based on a
user's role.
. Specialized features for the Administrator role in the application
developed.
. Designed and developed in C# and user interface forms using WPF for
windows based application.
. Designed and developed user-interface of the project using Custom
controls, User Controls and JavaScript.
. Scripting work done using JavaScript to add features to the
application.
. Maintained the company standards in developing and writing codes for
the application.
. Responsible for working with local and international teams to deploy
applications to QA and production environments.
. Developed on user controls for customized application development.
. Proper Validation Controls applied wherever needed for the WinForms
application.
. Data layer using ADO.Net concepts for database connectivity.
. SQL Reporting Services, rdlcs with subreports in reportviewer.
. Designed the database in MS SQL Server, created specifications of SQL
Server stored procedures and implemented most of them.
. Responsible for maintaining versions of code using Visual Source Safe.
. Used InstallAnywhere2009 as a packaging tool to create the executable.
. Incorporated the structured Error Exception handling using try catch
blocks all throughout the development to handle exceptions.
. Performed Agile testing internally to ensure best performance of the
software.
Environment: .NET Framework 3.5/3.0, C# 3.0, IIS 6.0, MS SQL SERVER 2005,
JavaScript, CSS, InstallAnywhere 2009, Visual Source Safe.
Peak Financial Management, MA May 2008 - June 2009
.Net Developer
The project is about building web-based application that supported
Portfolio Management and Order management. The application provided
Portfolio Managers and Analysts to create order and implement investment
ideas across Portfolio and perform Modeling and Rebalancing. The
application was built on Web Form, C# with backend as MS SQL Server 2005.I
was responsible for designing, developing, providing production support,
fixing bugs and resolve day to day issues.
Responsibilities:
. Designed and developed new C# and web form UI using ASP.Net, AJAX and
Silverlight for rich web based application.
. Worked in Model-View-Controller (MVC) design pattern in developing
the application.
. Interacted with the Business Analysts and the clients for translating
the business requirements into Technical Specifications.
. Developed GUI using CSS and coded the related business tier using C#.
. Developed Windows Communication Foundation (WCF) applications using
C# coding.
. Ability to work well in a team environment and brainstorm with other
developers on ideas, design approach, technical issues and team
processes.
. Involved in development life cycle from design phase to
implementation phase, testing and deployment.
. Designed and developed Data layer classes using ADO.NET concepts for
creating and opening connections, accessing and binding data and sql
commands for reading and updating data on SQL Server 2005.
. Worked on designing of database, creating of tables using the
concepts of normalization and RDBMS.
. Developed and updated Queries, Stored Procedures, Functions, Views
and Triggers using SQL Server 2005.
. SQL Reporting Services, rdlcs with subreports in reportviewer. SQL
Integration services using SSIS as well as used DTS.
. Created selection criteria pages that builds complex SQL statements
from user input in text and list boxes.
. SQL Reporting Services reports with selection criteria pages and SQL
Server.
. Field display and positioning with DataList.
. JavaScript for client side input validation, and calculations that
change as user enters data.
. Performed Regression test, Integration test and Unit Test with
improved debugging standards.
. Worked in configuring the ASP.Net web applications in Internet
Information Services (IIS).
. Created the test plans as per the requirement provided. Executed the
test cases from Quality Center Tool.
. Provided Production Support for day-to-day issues.
. Responsible for maintaining versions of code using ClearCase and used
ClearQuest as a defect tracking tool.
. Responsible for creating the .NET builds and making sure the builds
are migrated all the way up to the Production Environment.
Environment: C# 3.0, IIS 6.0, ASP.NET, Silverlight, MS SQL SERVER 2005,
.NET Framework 3.5/3.0, JavaScript, CSS, ClearCase 2003.06.
Bank Of America, NY
Nov 2006- Apr 2008
.Net Developer
Corporate Action application was developed to increase the productivity for
departments like Investment, Tax, Accounting, Legal department. This
application provides schedule events to corporate users so that they can
keep track of corporate action events that are schedule monthly and help's
the users view the events occurring before hand and make informed decision.
Corporate User can view information about each Tender like Ticker, shares,
Entity, Expiration date, record Holding date and Effective date. After the
User verifies the Information if they wish they can comment. Once the User
is satisfied they can "sign-off" on a corporate action and email is sent
out to the respective members. Developed a Generic Dynamic Reporting Custom
Control Using a Data Grid, which helps user generate reports on the fly.
The application provides functionality like sorting; Paging, Summing,
Navigation etc by specifying the able, fields and the database where the
table exits and the report are created.
Responsibilities:
. Designed and Developed the Corporate Action Web application using
ASP.NET, ADO.NET, SQL Server 2000.
. Requirement analysis and design.
. Extensively used Validation Controls and Design Patterns.
. Developed rich GUI using CSS, Photoshop.
. Coded the related business tier using C#.
. Used ADO.NET for Database Transactions.
. Involved in Code Optimization and Performance Tuning of the
application.
. Involved in system defect tracking, bug fixing and maintenance.
. Worked with stored procedures, DTS and Triggers.
. Involved in working with winforms and webforms.
. Created and executed test plans as per the requirement provided.
. Used automated testing tool QTP (Quick Test Professional).
. Preparing the specifications For Front-end and Reports
. Creation of Views in the Database for Optimizing Crystal Reports.
. Experience With Content Management for Various departments in the
Bank.
Environment: ASP.Net, Sql Server 2000, C#.Net, JavaScript, CSS, Photoshop,
XML, Microsoft Visio, Rational Rose.
Ann Taylor, NY
May 2006 - Nov 2006
.Net Developer
Ann Taylor is a premier American specialty apparel retailer for the
professional woman. Due to vast increase in new designs, sales and
productivity, the production database is migrated to a new phase with new
attributes added. This increases the functionality of the system as many
new features are considered. The aim of Project is to allow users to work
seamlessly when they change from using phase 1 to phase 2.
Responsibilities:
. Designing of phase 2 Database with Normalization ensuring that all
tables are defined appropriate.
. Part of a team, which interacted with the client on requirement
specification and presented an approach on dealing with the
specifications provided.
. Wrote stored procedures, cursors, Triggers for the data migration
using T-SQL.
. Responsible for resolving the issues or inconsistencies of data prior
to migration
. Ensure that the Data is migrated to new phase on a rolling basis and
maintain the data integrity.
. Created a new administrative interface for the Phase 2 application
database using Visual studio.NET 2005, ASP.NET 2.0, C#, ADO.Net.
. Wrote business logic in C# and handled transactions from and to
database using ADO.NET objects such as Datasets, Data Adapters, and
Data Readers.
. Developed new UI Interfaces, Master Pages, Style Sheets and Themes for
the new Phase 2 Environment.
. Developed a new Ann-Taylor specific User controls.
. Responsible for Authentication and Authorization of the Pages for
Various Levels of Users.
. Tested and deployed the Project.
. Users are trained to use the new Phase 2 version of the database and
the Administrative Interface.
Environment: Visual Studio.NET 2005, C#.NET, ASP.NET 2.0, Oracle, T-SQL,
Dynamic SQL, Java Script, CSS, XHTML, IIS, VSTS, Windows 2003 server.
National Informatics Center, India
Dec 2005 - Apr 2006
.Net Developer
Project Name: Web Enabled Pre Audit System for Pay and Accounts Office.
. Develop an application that takes care of all the day-to-day
activities of a pay and accounts officer.
. Maintaining records of all the gazetted and non-gazetted rank
officers.
. Involved in the phase of analysis by looking into the user requirement
(OOAD).
. Management of database using SQL Server.
. ADO.Net Connectivity is used extensively to have a clear connection of
database with the application. Dynamic database connection and
database disconnection is done as and when needed by the application.
. Coding is done using C#.NET and ASP.NET.
. Design and development phase in coding is done in a separate level in
order to comply with the company standards.
. Performed System Testing and Integration Testing.
. Created and executed test plans as per the requirement provided.
. Implementation of the application is done at the client side.
. Validations and verification are done as and when required.
. Developed reports by Crystal Reports with Database connectivity.
. Documentation maintained at each level i.e. for Analysis, Design and
Testing Stage at the development level. Documented with the input,
performance and output status.
. Documentation done using Rational Rose and Microsoft Visio.
Environment: ASP.Net, Sql Server, C#.Net, IIS, JavaScript, CSS, XML, HTML,
DHTML, Microsoft Visio, Rational Rose.
KiwiSoft Technologies, India
Jan 2004 - Nov 2005
Programmer
Kiwi Technologies is a customer service company providing its client
customer online help by email, online chat and telephone assistance.
Involved in development and maintaining database for company payroll as
well as creating the front end.
Responsibilities:
. Developed Database for payroll department in SQL Server.
. Implemented SQL queries for accessing records
. Developed user interface using ASP.Net, VB.Net, HTML, DHTML, CSS,
JavaScript.
. Participated in database design. Involved in maintenance of database
process like trouble shooting in stored procedures and triggers.
Environment: SQL Server, ASP.Net, VB.Net, JavaScript, IIS, Windows NT, SQL.
SSI Ltd, Chennai, India Jan 2003 -
Sep 2003
Programmer
Student Information System.
. Responsible for the development of an application to maintain the
students records of an institution.
. Involved in the phases of Analysis, Design, Development, Testing and
Implementation following the OOAD concepts.
. Concentrated on the database management using MS Access.
. Coding is done using VB.
. Implementation of the application is done internally.
. Documentation work done at the final level of project management.
Environment: VB 6, VB Script, Windows NT, MS Access.
Additional Information
1. Certified for participating in the workshop undertaken in MOBILE
COMPUTING.
2. Obtained online certificates from Brain Bench Employment Testing.
[pic]
[pic]
[pic]
Contact this candidate