Sql Server Developer Project .Net Services Management
Resume:
Deepika M Jakkula Phone 336-***-****
Greensboro, NC *******.*******@*****.***
Permanent Resident of USA.
SUMMARY
• 6+ years of experience in Design, Development, Testing and Implementation of web based applications.
• Experience in leading the application support team.
• Good Team player, having interest towards exploring, learning and using new Tools & technology as quickly as required.
- Experience in client engagement.
- Excellent web application development skills.
- Experience working in a software development methodologies (Agile and Waterfall approaches)
SKILLS PROFILE
Operating Systems : Windows 7/Vista/XP
RDBMS Systems : SQL Server 2008, 2005, 2000
MS-Access 2000
.NET Technologies : Framework versions 4.0, 3.5, 2.0
VB.Net, C#, ADO.Net, ASP.Net, AJAX, WCF
Web Development : HTML, JavaScript, XML, JQuery, CSS 3
Multimedia : Flash, Adobe Photoshop
Version Control Systems : Visual source safe, TFS 2010
Applications / Tools/ Plug-in : Microsoft Office, Sitecore 6.0, Infragistics, Firebug
PROFESSIONAL EXPERIENCE
Skillstorm (Oct 2011 – Till Date)
Client- INMAR, Winston Salem, NC, US
Project Name : PRISM SPECTRUM – WAL-MART ON-BOARDING
Platform : ASP.Net 4.0, VB.NET, C#.NET, SQL Server 2008, JavaScript, Firebug
TFS, AJAX, JQuery, WCF, Spreadsheet Gear, SSRS
Client : Wal-Mart, US
Description :
Prism Spectrum is a Pharmacy Reconciliation and Contract Management web portal that enables daily reconciliation of claims (prescription data) and payments, and electronically matches individual claims directly to carrier contracts to validate that the paid amount meets contract terms.
Responsibilities:
Responsible for Designing, Coding, Testing and Support of ‘Contract Management’ module.
Implemented custom paging, sorting, and validations on grid views as a standard on most grids.
Used User Controls in grid view and validated them.
Created classes and designed web forms with front–end screens using ASP.NET, AJAX and JavaScript to change the contract entry according to the new business rule validations.
Extensively used IE Developer Tools and Firebug on making spectrum cross browser compatible by resolving the JavaScript issues and rebranded the look and feel of the website by creating new CSS.
Created Excel templates with validations using VBA macros for providing to Wal-Mart
Created new modules to import contracts from Excel using third party tools like Spreadsheet Gear for on boarding new customers as large as Wal-Mart.
Implemented WCF service to implement the excel import involved with spreadsheet gear.
Modified and created new reports using SSRS.
Debugged and executed stored procedures in the backend before creating objects.
Extensively used large datasets to retrieve data.
Created deployment scripts for deploying Database Changes
Used TFS for version control and experienced in publishing and deploying code using TFS
Created Change Control Board (CCB) request and obtained approvals
Acquaintance to SCRUM Agile Software Development Methodology.
Cognizant Technology Solutions (Jun 2010 – Feb 2011)
Chennai, India
Project Name : www.Lawyers.Com (LDC)
Platform : ASP.Net 3.5, C# 3.5, SQL Server 2005, Oracle, JavaScript, Firebug
TFS, AJAX, Site, JQuery, Sitecore 6.0
Client : LexisNexis, US
Description :
Lawyers.com is a search directory where web users can find attorneys and law firms based on area of Law/location. LDC is a medium for the lawyers or firms to showcase their profile, contact and rating information to the external world. It is a user-friendly site for the customers to locate and communicate with the attorney for their legal issues. It is also a repository for legal information and solutions for legal issues.
Lawyers.com consists of subsystems with data flowing between each one of them. There are several subsystems which are listed below
Search: Facilitates end users to search lawyers/Law firms (using simple search) or any text (using global search).
Profile: Facilitates end users to view the profile of Lawyers/Law firms with details like Profile, Contact info, Firm Members, Blogs, Ratings.
Email: Facilitates end users to contact Lawyers/Law firms with the use of “Send Email” option in the search listing page and “Click Here to Contact” option in the profile page.
Stats: Captures various statistics like Firm impressions (the number of times firm’s are listed in Featured Firms), Premier Banner impressions & Shared Banner impressions, User’s click on ads, Search statistics etc.
These statistics are captured using 3rd party tools like Web Trends, Google Analytics.
Understand your Legal Issue: Helps end users to understand legal issues based by Practice Area or by Life Events or by Location.
Legal Forms: Helps the users to prepare their own Legal forms.
Responsibilities:
Responsible for doing Impact Analysis, Designing, Coding, Testing and Support of ‘Legal Forms’ module.
The front end was designed using the Sitecore with ASP.NET and back end was implemented in C#.NET 3.5 using PL/SQL database and SQL database packages.
Creating widgets like ‘Find a lawyer’, ‘Skyscrapers’ which are displayed on every page of LDC.
Involved in designing the page using HTML, XHTML, HTML DOM, JavaScript, CSS, JQuery
Displaying and storing data on webpage using Sitecore.
Involved in discussions with client business users and technical team at onsite.
Leading a team of four.
Preparing Knowledge Transition documents, Functional Specification documents, Unit Test cases.
Involved in providing effort estimates.
Debugging JavaScript and CSS using Firebug.
Acquaintance to SCRUM Agile Software Development Methodology.
Aisys Technologies (May 2009 – June 2010)
Chennai, India
Project Name : Empresol (ERP)
Platform : ASP.Net 2.0, C# 2.0, SQL Server 2005, JavaScript, VSS, AJAX, Infragistics
Client : Accurate Steel Forging Industry
Description :
Empresol is a manufacturing product for automobile parts. The raw materials like 'rods' are ordered to the suppliers. After receiving the raw materials, different parts are made out of them like 'Cutting the rods and making shapes of it'. Finally these products are sold to the customers.
Empresol consists of different modules like :
Direct Purchase :The raw materials are received directly from suppliers.
Indirect Purchase :The raw materials are received from store.
Production : The production details of raw materials are maintained here.
Quality : Quality of raw materials manufactured are maintained.
Sales : Sales details that are made to the customers are maintained.
Payroll : Payroll details of employees are maintained.
Admin : User creation and Database Backups are maintained.
Responsibilities:
Involved in Designing, Coding, Testing and Support of Direct Purchase, Indirect Purchase, Payroll, Quality modules.
Involved in dividing the project into four layers. Transport, Data Access, Business, Presentation.
Involved in coding all the layers of the project using C#.NET 3.5
The front end was designed using ASP.NET and back end was implemented in C#.NET 3.5 using SQL database.
My responsibilities included design and development of stored procedures, user defined functions using Transact-SQL in SQL Server database.
Involved in designing and validating page using CSS, HTML, XHTML, JavaScript.
Involved in writing client side AJAX and server side AJAX.
Leading a team of 3 members.
iSOFT R&D Private Ltd(Jun 2008 – Dec 2008)
Chennai, India
Project Name : Lorenzo for National Health Services (NHS)
Platform : ASP.Net 2.0, C# 2.0, ADO.Net, SQL Server 2005, JavaScript, Web Services, AJAX
Client : NHS, UK
Description:
Lorenzo is a Patient Administration System (PAS) . It is a HealthCare product which is used by all the hospitals that fall under NHS in the UK. This provides end to end services for all needs of Hospitals and Doctors, like repository of all information about patients. It provides fully interactive records, capable of handling the complexities of modern patient care. It contains details of patient and his/her registration with Hospital, Patient problems/symptoms characteristics, past history, family history, drug allergies, patients related images like x-ray, scanning reports etc.
Responsibilities:
Involved in Design, Coding, Testing and Support of the Custom Controls.
Data Software Research Company (Oct 2005 – May 2008)
Chennai, India
1. Project Name : TTS Visas-Singapore(www.ttsdropbox.com )
Tenure : Aug 2007 – May 2008
Platform : ASP.Net, VB.NET, ADO.Net, SQL Server 2005, JavaScript, VSS
Client : TT Services, Chennai, India
Description:
This is one of the TT services applications. The TT Services, providing services in the area expediting of visa applications to the Singapore Consulate in South, North, and East India. This project is a operator driven module which facilitates the appointment system for visas for Singapore Consulate. Installed in TT Services, it is extremely used to administer the appointment management system.
Responsibilities:
Involved in design of the User Interface.
Done the Application-collecting, Email sending and some pages in Tasks module.
Involved in coding client side validation using JavaScript.
Involved in writing stored procedures.
2. Project name : Web Appointment System for US Consulate in Srilanka(www.ttsusvisas.lk )
Tenure : March 2007 – July 2007
Platform : ASP.Net, C#.NET, ADO.Net, SQL Server 2000, JavaScript, VSS
Client : TT Services, Chennai, India
Description:
A website for the same client, T.T. Services, furnishing visa processing tasks for the US Consulate in Colombo, Sri lanka. This involves a public website and an operator driven module for accepting application, dispatching passports, closing them, generating reports, setting interview dates and many more. A data generation logic takes care of the data to be sent to the consulate two days before the applicant's visit.
Responsibilities:
Involved in design of the User Interface.
Done the Appointment-fixing module and some pages in Status Reports module.
Involved in coding client side validation using JavaScript.
3. Project Name : TTS Visas - South Korea(www.ttservices.co.kr)
Tenure : Dec 2006 – March 2007
Platform : ASP.Net, C#.NET, ADO.Net, SQL Server 2000, JavaScript, VSS
Client : TT Services, Chennai, India
Description:
This is one of the TT services applications. The TT Services, providing services in the area expediting of visa applications to the Indian Consulate in South Korea. It handles visa requests from citizens of South Korea, wishing to travel to India. Installed in TT services, it is extensively used to administer the appointment management system.
Responsibilities:
Involved in User Interface design module.
Coding of Appointment-fixing module and various pages in other modules.
Involved in coding client side validation using JavaScript.
Involved in writing stored procedures.
4. Project Name : Disposable Service Agency
Tenure : Sep 2006 – Dec 2006
Platform : ASP.Net, C#.NET, ADO.Net, SQL Server 2000, VSS
Client : TT Services, Chennai, India
Description:
The Disposal Services Agency (DSA) provides a total disposal solution by acting as a broker and adding value through expert advice across the public sector. The DSA runs the largest operation of its kind in the UK and possibly Europe. Its methods of turnover are a model for other nations defence forces and its expertise is sought throughout the world.
The DSA has used a computer-based system to manage the disposal of equipment for many years. In 1999, year 2000 compliant system was introduced into the Agency. Since then, a number of enhancements have been applied to the system to take it from versions D2000, D2002, eDARTv1 and its current version called eDART version 2 (eDARTv2).
The DSA feels that the functionality and technical capabilities of eDART now no longer meet all the requirements of the Agency. This has resulted in the need to re-write the existing system.
Responsibilities:
Done the Actions module.
Involved in coding Server side side validation.
5. Project Name : Learning Management System (LMS)
Tenure : May 2006 – Aug 2006
Platform : ASP.Net, C#, ADO.Net 2005, SQL Server 2000, VSS
Client : DSRC Private Ltd., Chennai, India
Description:
This application, Learning Management System (LMS) is intended for conducting training programs and aptitude tests conducted by DSRC for fresher through Internet. This project consists of various modules like Admin, Faculty and Student Module.
Responsibilities:
Involved in design of the User Interface.
Developed various pages For Admin module and Faculty module.
Involved in client-side validations using JavaScript and server-side validations using validators.
6. Project Name : TTS Visa Services (www.ttsvisas.com)
Tenure : Dec 2005 – Apr 2006
Platform : ASP.Net, VB.NET, ADO.Net, SQL Server 2000, JavaScript, VSS,XML
Client : TT Services, Chennai, India
Description:
The visa application tracking system is developed for the TT Services, an agency providing logistic services to the U.S Consulate, Consular Section. The vital objective of the application is to assist in automating various tasks involved in collecting visa applications and updating the status of the passports. The applicant details are collected, sent in batches to the embassy, which processes them and sends the passports back to TT Services. The system also enables them to answer queries from applicants regarding the status of their passports. To help the applicant further, the www.ttsvisas.com web site was developed. The applicants can fill their applications online and further select a date and time to visit the Consulate. The application has helped to handle the large volume of applications (averaging 300 per day with peaks of 600 applications in a day) in a streamlined and efficient manner.
Responsibilities:
Involved in design of the User Interface.
Done the Editor module.
Involved in coding client side validation using JavaScript.
7. Project Name : Defect Tracking System
Platform : C#.NET, ASP.NET, HTML, SQL Server 2000
Client : DSRC Private Ltd., Chennai, India…
Description:
This system was developed as an Intranet application to track defects in an application. When an application has been completed, it has to undergo testing before it is given to the client. This application allows both the development team as well the Quality Assurance team to access the same database and report and fix defects.
Once the QA team member finds a defect in the application, he will report it through the application. The development manager then assigns this defect to the developer who coded that particular module. The developer can then view and fix the defect. Once the developer fixes the defect the defect will have to be validated by the person who reported it, only he can change the status of the defect to fixed.
Responsibilities:
Involved in design of the User Interface.
Developed various web pages for the user and administrative purposes.
Involved in coding client side validation using JavaScript.
Involved in writing stored procedures.
WT Shipping Limited (Jan’05 – Aug’05)
Essex, UK
Project Name : Global Booking/Tracking System
Platform : C#.NET, ASP.NET, HTML, SQL Server 2000
Client : WT Shipping
Description:
The online goods shipping application supports an online booking of goods that has to be shipped to different parts of UK, to Far East routes, USA, South Africa, Australia, India and its sub-continents from UK either through sea or air.
This site offers free membership and registration for customers. They can also make payment of goods through this system. The system displays availability calendar where they can select the date for booking goods. The payments for the goods are made through secure transaction. The customer can see the status of their goods whether it is shipped or not.
Responsibilities:
As a Junior Application Developer, I was involved in design and coding of the user interface for new user registration module, performed unit testing.
EDUCATIONAL QUALIFICATION
1999 – 2003 Jawaharlal Nehru Technological University, INDIA
• Bachelor of Technology In Information Technology
1996 – 1998 Board of Intermediate Education
• Intermediate Public Examination
1996 Central Board of Secondary Education
• Secondary School Examination
TRAINING
1. .NET 2005, SQL Server 2000, SQL Server 2005 at Data Software Research Company , Chennai, India
2. .NET 2003 at NIIT Ltd, Chennai, India
CERTIFICATIONS
1. Microsoft Certified Application Developer (MCAD) for Microsoft .Net
Exam 70-315:Developing Web Based Applications with Microsoft Visual C#.Net
Exam 70-316:Developing Windows Based Applications with Microsoft Visual C#.Net
Exam 70-320:Developing XML Web Services and Server Components with Microsoft Visual C#.Net
2. Microsoft Certified Professional (MCP)
Exam 70-229: Designing and Implementing Database with Microsoft SQL Server 2000 Enterprise Edition.
3. VS .NET & XML certification from NIIT
Contact this candidate