Sql Server Project
Resume:
Ashwini A Khetmalis
*. *********.*********@*****.***
Career Objective
To obtain a challenging position in the information technology that
will utilize my technical and analytical skills and my experience and will
provide the opportunity for professional growth and enhancement.
Looking for role of Asp.net Senior Developer
Profile:
. 7+ years of work-experience in the IT industry developing .NET Web
applications.
. The core areas of expertise are in Development, Coding, Testing and
Implementation using ASP.Net 1.1/2.0/3.5, C#, VB.Net, Enterprise
Library, ADO.Net, LINQ, XML, Web Services, WCF, SQL Server
2000/2005.
. Coordinating with team to ensure deliverables are prepared to satisfy
the project requirements.
. Substantial experience in Software Development Life Cycle (SDLC).
. Substantial experience in various Industry Verticals like Financials,
Insurance and GIS
. Hands on expertise in designing and setting Continuous Integration,
Build and Deployment process.
. Excellent work experience in SQL Server 2000/2005
. Extensive experience in writing SQL queries, stored procedures,
functions, packages and triggers.
. Experience in Composing User Controls and Custom Server Controls.
. Good Experience on Web Technologies: HTML, Java Script, CSS, AJAX,
XML, JQuery
. Hands on experience in VSS 6.0, IIS 5.0/IIS 6.0
. Exposed to all phases of SDLC, Analysis, Object Oriented Design(OOD) &
Programming(OOP), Development, Testing, Maintenance and Production
Support
. Experience in developing UML diagrams including Use Case diagrams,
Class diagrams, Sequence diagrams, interaction diagrams, State
diagrams
. Highly motivated, quick learner, good communication skills and an
effective team player
. Have excellent analytical, logical and reasoning skills.
. Possess a positive attitude.
. Part of technical recruitment team in Accenture
Software Technical Skills:
Programming Technologies: ASP.Net, C#, VB.Net, ADO.Net, SQL Server
Web Programming: JavaScript, Web Services, WCF, HTML, CSS,
JQuery, XML Databases: SQL Server 2000/2005/2008.
Frameworks: .Net Framework 1.1/2.0/3.5/4.0
Technologies: AJAX
Application & Web Servers: IIS 5.0/IIS 6.0
RDBMS: SQL Server 2000/2005 and 2008
Version Controls: VSS 6.0, TFS
Bug Tracking Tools: Bugzilla
UML: Visio
Operating Systems: Windows XP/2003/2008/7
Professional Experience:
Oct 2011 - till the date: ACCENTURE SERVICES PVT LTD.
Project #1
Client : HDFC ERGO General Insurance Company - Third Party
Liability Insurance
Role : Asp.net Team Lead
Period : Jan 2012 - Oct 2013
Responsibilities:
. Interacted with the client and end users for requirements gathering,
analyzing and documenting the requirements.
. Taking daily call directly with client.
. Did Research and analysis and suggested solution for new changes.
. Created the technical document for new enhancements.
. Designed the architecture for new enhancement based on the requirements.
. Involved in development, deployment and maintenance of new enhancements.
. Worked on the development, deployment and maintenance of existing web
applications.
. Managing access and view permissions for various roles using DB and
Active Directory Authorization.
. Developed XSLTs to display XML data from database.
. Developed Cascading Style Sheets (CSS) for User Interface uniformity
throughout the application.
. Integrated the Java Web Services in .NET application.
. Used HTML, JavaScript and AJAX for developing custom control and web
forms.
. Involved in migration of application from NET 2.0 to .NET 4.0.
. Written SQL queries, procedures, views and functions in SQL Server 2005
and 2008
. Effective in Query tuning on SQL Server database
. Worked on Java script for client side validations.
. Prepared Test cases for the Testing team to test the Application.
. Done Code Review for quality of the code and for coding standards.
. Unit tested the application based on the test cases and business
understanding.
. Worked on quick fixes of UAT issues.
. Worked on trouble shooting and fixes of Production issues.
Environment: Windows XP 2000, VISIO for UMLs, ASP.net 3.5,c#, MS SQL 2008,
SQL Server Management Studio, Microsoft Visual Studio 2008 and TFS
2010,Visio.
Project #2
Client : HDFC ERGO General Insurance Company - Private Car
Insurance
Role : Asp.net Team Lead
Period : Oct 2011 - Dec 2012.
Responsibilities:
. Interacted with the client and end users for requirements gathering,
analyzing and documenting the requirements.
. Taking daily call directly with client.
. Did Research and analysis and suggested solution for new changes.
. Created the technical document for new enhancements.
. Designed the architecture for new enhancement based on the requirements.
. Involved in development, deployment and maintenance of new enhancements.
. Worked on the development, deployment and maintenance of existing web
applications.
. Managing access and view permissions for various roles using DB and
Active Directory Authorization.
. Developed XSLs to display XML data from database.
. Developed Cascading Style Sheets (CSS) for User Interface uniformity
throughout the application.
. Integration the Java Web Services in .NET application.
. Used HTML, JavaScript and AJAX for developing custom control and web
forms.
. Involved in migration of application from NET 1.0 to .NET 4.0.
. Written SQL queries, procedures, views and functions in SQL Server 2005
and 2008
. Effective in Query tuning on SQL Server database
. Worked on Java script for client side validations.
. Prepared Test cases for the Testing team to test the Application.
. Done Code Review for quality of the code and for coding standards.
. Unit tested the application based on the test cases and business
understanding.
. Worked on quick fixes of UAT issues.
. Worked on trouble shooting and fixes of Production issues.
Environment: Windows XP 2000, VISIO for UMLs, ASP.net 3.5, MS SQL 2008, SQL
Server Management Studio, Microsoft Visual Studio 2008.
Dec 2009 - Oct 2011: Sutherland global services
Project #3
Client : Barclays Bank
Role : Sr. Software Developer
Period : Feb 2011 to Sep 2011
Responsibilities:
. Designed the N-tier architecture for the application
. Designed UML diagrams (class diagrams and sequence diagrams).
. Developed Web forms, business logic for the project in C# language
. Worked on Java script for client side validations.
. Worked on development and deployment of Web Services with different
applications.
. Developed reports to show effective utilization of process to the
management.
. Worked on ADO.NET in Data layer for database connectivity with the
application.
. Used XML for saving and retrieving data from DB.
. Written Stored Procedures and functions in Database using TSQL
. Provided Role-based security, so that the user can access the information
for which he has got access
. Prepared test cases for the project and guided teammates in writing test
cases.
. Reviewed the code of the application for checking the quality of the code
and for coding standards.
. Unit tested the application based on the test cases and business
understanding.
. Done UAT (User Acceptance Testing) for the application.
Environment: Windows XP 2000, ASP.net 3.5, MS SQL 2008, SQL Server
Management Studio, Microsoft Visual Studio 2008.
Project #4
Client : AIRLINE client
Role : Senior Software Developer
Period : Apr 2010 to Jan 2011
Responsibilities:
. Responsible for all the phases of SDLC from software requirements phase
to design, implementation, testing, debugging and documentation.
. Developed windows service applications using C#, ADO.NET, SQL Server
2005, Visual Studio.NET 2005/2008, Windows XP.
. Designed and developed user interfaces using cascade style sheets.
. Used JavaScript for handling validation logic
. Created a prototype of the application for demo before developing the
application
. Designed and developed the User interface using ASP.net User Controls
. Experienced in building rich Ajax enabled UI based web applications in
.NET
. Created tables, designed database, relational diagrams, and functions
stored procedures, triggers, cursors and indexes in SQL Server 2008.
. Integrated different modules in the production server for the UAT test.
. Preparation of the Test Plan and review of Test Cases.
Environment: Windows XP 2000, ASP.net 3.5, MS SQL 2008, SQL Server
Management Studio, Microsoft Visual Studio 2008.
Project #5
Client : Amlak Finance
Company : Sutherland global services
Role : Software Developer
Period : Dec 2009 to Mar 2010
Responsibilities:
. Requirement Gathering, System, database design, Coding & Testing
. Gather new business requirements for customer servicing.
. Design and implement online payment form to log all cheque payments by
customers.
. Design and implement Java Applet that checks for the available scanners,
initiates the scanner and send commands to the scanner to scan the
cheque.
. Design and implement the functionality that takes the image scanned by
scanner and uploads it to a server. Create Business Continuity Plan for
the project.
. Design reporting features to enable auditing of cheque transactions for
user accounts.
Environment: Windows XP 2000, ASP.net 3.5, MS SQL 2005, SQL Server
Management Studio, Microsoft Visual Studio 2005.
Aug 2008 - Jul 2009: Mourant International Finance Administration
Project #6
Client : International Finance Administration (UK based client)
Role : Project Analyst
Period : Aug 2008 to Aug 2009
Responsibilities:
. Requirement Gathering, System, database design, Coding & Testing
. Data from existing system has to be extracted, transformed and cleaned in
staging area before pushing it into reporting database.
. Developed web based reporting solution to satisfy COR reporting
requirements with reliable and secure delivery.
. Implemented data security (to ensure users see only approved data to
which they have been granted access)
. Formatted business statements in PDF format on demand.
. Archiving of reports in line with Company standards.
Environment: Windows XP 2000, ASP.net 3.0, MS SQL 2005, SQL Server
Management Studio, Microsoft Visual Studio 2005.
Sep 2006 - Jun 2008: Cyber Tech System & Software Ltd
Project #7
Client : ESRI (Environmental Systems Research Institute)
Role : Software Programmer
Period : Sep 2006 to Mar 2007
Responsibilities:
. Client interaction and study to understand the user activities and
requirements.
. Designed and developed user interfaces in HTML, CSS, User Controls in
ASP.NET
. Designed Front end interface, for data import, metadata generation
. Used Geomedia objects for GIS analysis on hydrological data
. Configuration of web.config files to enhance the performance of the
application.
. Designed and coded the user and the admin module for the application
. Involved in data modeling and development of stored procedures in T-
SQL.
. Extensively used ADO.NET objects for various data manipulation
activities
. Developed validation using the ASP.net validation controls
. Assisted in deployment of the application.
Environment: ASP.net 2.0, MS SQL 2000, SQL Server Management Studio,
Microsoft Visual Studio 2005.
Project #8
Client : ESRI (Environmental Systems Research Institute)
Role : Software Programmer
Period : Apr 2007 to Jun 2008
Responsibilities:
. Designed and developed web forms using ASP.Net 1.1, C#.Net 1.1, HTML
and CSS.
. Implemented presentation, business and data access layers using VS.Net
1.1.
. Developed stored procedures, triggers, views and functions in T-SQL.
. Created web services that write and read XML file data and saves the
xml data into the database.
. Designed the data access layer using ADO.NET objects.
. Enhanced Business processes by using OOPS to develop business rules
and C# for data manipulation.
. Unit testing of the application in Nunit & VS 2008
. Development of the Order Information module.
. Used Visual Source Safe for version control.
Environment: NET 2.0, ASP.NET 2.0, ADO.Net, C#, SQL Server 2000,
JavaScript, Visual Studio 2005 IDE,IIS,VSS.
Educational Qualification
. Bachelors of Engineering in Information Technology from Pune University
India in July 2006 secured Higher Second Class.
Contact this candidate