Software Developer Sql Server
Resume:
[pic] [pic]
PURVA DUBLAY
***********@*****.***
Summary:
* *** ** ********** ** developing web applications using Adobe ColdFusion
Mx, Coldfuion 7, Coldfusion 8 and 9 with Fusebox framework.
Good experience over 7 yrs on XHTML, HTML and CSS for the innovative
design.
Familiar with XML technologies.
Most of the projects needs interactive development using AJAX and Web
Services.
Thorough understanding of the MVC (Model, View, Controller) framework.
Worked extensively with Components(CFC), Custom tags, UDF's, Error and
Exception handling and web-services for more than 5 yrs.
Significant experience of 5yrs in writing stored procedures, triggers on
SQL 2005/2008, MySQL, T-SQL.
Experienced in writing technical documents such as technical designs, unit
test plans and user manuals.
Strongly believe in collaborative team for delivering quality software as
expected by client within expected time period.
SKILLS:
Languages: ColdFusion 9.0/8.0/7.0/MX 6.1, FLEX, HTML, PL-SQL, T-
Sql, C#, Asp.net
Databases: Sql Server 2005, 2008, T-Sql, MySql, Sybase.
O/S: Win 2003, Windows XP, Win 2000, Windows 7.
Internet Technologies: Ajax, Web-services, CSS, HTML, XML, Javascript,
JQuery.
Tools: Crystal Reports 8.0, VSS (virtual source safe),
CF report builder.
Web Servers: ISS 6.0, Apache.
Framework: Fuse-box.
Other: Dreamweaver, Notepad++, Adobe Photoshop, CF
Builder 1.
Source Version Control: SVN, Mercurial repository,
Work Experience:
Pearson Education.
Upper Saddle River, NJ USA.
October 2010 to May 2011.
Role : Sr. Software Developer
Pearson Education is a book publishing company. The role I am playing here
is a Sr. software developer who also needs a strong database knowledge.
Working on the intranet application for an employee facility and mail
department. Creating the reports and pie charts for the locationHeadcount &
occupiedSpace and many more for HR Department. Interactive employee search
criteria. Customize grid with drag, re-size,sort, hide column features
using Jquery. For the mail department get the fedex file, upload data in
the system, validate data, alert the error and create report and send
automated mail to authorized person.
Responsibilities:
Understanding existing software system while going through the code, old
functional requirement documents and test cases.
Writing CRUD procedures to related add/mod/delete actions in SQL Server.
Creating SSIS DTS Package to transfer the data between two databases.
Creating SSIS DTS Package to import file automatically into the database
tables.
Working on the PIVOT table in the SQL server.
Created the CFC's for the common methods.
Created Custom Tags for the rich interactive interface.
Enhancing the Application Security using SSL.
Using CROSS APPLY create multiple rows from string in SQL Server.
Import data into excel, workbook and world format using cold-fusion
format.
Deploying pie and line charts using cold-fusion graph feature.
Generating reports using ColdFusion Reporting tool.
JQuery used for the custom data-grid.
Writing the CSS class and build the Html layout.
MVC Architecture
Technology: CF8.0, CFMX, SQL-2005, SQL-2008, Dream-weaver 8.0, Notepad ++,
HTML, JavaScript, jQuery, AJAX, CSS, SVN.
KPL Canton Group,
Baltimore MD USA
January 2010 to September 2010
Role : Sr. Software Developer
www.kpl.com
"Kpl is a manufacturing and marketing firm", which provides innovative
protein detection technologies, reagents online store worldwide.
Incorporating purchase order and credit card functionality. It also
provides user friendly and innovative product search. Percentage discounts
and promotions on the products are the new added features.
Responsibilities:
Conceptualizing and programming Macromedia Flash Actionscript for Rich
Internet Applications, AJAX, XML and Social Networking concepts (Web 2.0).
Writing JavaScript functions for data validation and display logic for the
Job and Measures module.
Creating CFC's for the Job, Measure, Deferral, Complaints module.
Writing SQL Stored Procedures and Functions for the Job, Measure, and
Complaints.
Using JQuery functionality in the new user's form page, Summary page and
Results page.
Technology: Windows 7, CF8.0, ColdFusion 9.0, SQL-2005, ColdFusion
Builder, Crystal Reports 8.0, Action Script 3.0, Dreamweaver 8.0, HTML,
JavaScript, jQuery, CSS, Mercurial Repository.
MEDCO Canton Group,
Baltimore MD USA
June 2009 to December 2009
Role : Sr. Software Developer
www.medco-corp.com
"Its a private corporation established by state of Maryland for financial
assistance projects". They have different modules on client tracking
system. Its a huge database of projects with respect to their tax and
insurance details. Modify application to include new form 990K, create new
reports by the search criteria and create new user role to access this new
feature under admin section.
Responsibilities:
Understanding existing software system while going through the code, old
functional requirement documents and test cases.
Writing CRUD procedures to related add/mod/delete actions in SQL Server.
Deploying Application on Production Server and maintain the required
changes.
Generating reports using ColdFusion Reporting tool.
Creating respective CFCs & DAO's.
Mercurial repository Version Control System (VSS).
MVC Architecture
Technology: CF8.0, CFMX, SQL-2005, Dreamweaver 8.0, Notepad ++, HTML,
JavaScript, jQuery, AJAX, CSS, Mercurial Repository.
Imetris Corporation, MI USA.
December 2008 to May 2009
HRMS-Phase II
Role : Software Developer
HRMS is an intranet enterprise solution developed for managing human
resource processes in Imetris Corp. The system provides the HR department
abilities to perform regular day to day operation seamlessly along with
taking strategic decisions on resource allocations. The software also helps
HR department to manage communications with prospective employees and get
them onboard quickly. The system enables the employees to manage their
leaves and daily timesheets. Using the software senior management can
generate MIS reports which help them taking various decisions.
Roles and Responsibilities:
Developing the software modules as per the requirements gathered.
Writing technical specification documents and test cases
Writing T-SQL, triggers and stored procedure to obtain the desired result
from database.
Performing manual testing and validating test cases.
Participating in database design discussions.
Technology: C#, ASP.NET 3.5, CSS, HTML, JavaScript, MSSQL Server 2005,
Windows Server 2000.
Clinical trials management system,
October 2008 to November 2008
LabCorp Inc, Durham, NC USA
Role : Sr. Software Developer
LabCorp is a company which provides leading-edge medical laboratory tests
and services. The current project also known as PBMC is a clinical trials
management system used by LabCorp to manage clinical data for participating
patients and operating sites. The current assignment was an enhancement to
the system to accommodate new HVTN network. The main challenge while
working on this assignment, understood the existing system and delivering
new functionality within very short period of time. This application was
first built in ColdFusion Mx and then converted to ColdFusion MX 7.
Responsibilities:
Understanding existing software system while going through the code, old
functional requirement documents and test cases.
Coordinating with manager to handle the database related changes.
Implementing the required code changes without disturbing the existing
functionality of the system in the fusebox framework.
Unit testing the modified web pages.
Deploying Application on Production Server and maintain the required
changes.
Technology: CFMX 7.0, CSS, Dreamweaver 8.0, VSS, Fusebox 5.0, jQuery,
JavaScript, Sybase, XML.
Imetris Corporation, MI USA.
April 2008 to September 2008
HRMS-Phase I
Role : Software Developer
HRMS is an intranet enterprise solution developed for managing human
resource processes in Imetris Corp. The system provides the HR department
abilities to perform regular day to day operation seamlessly along with
taking strategic decisions on resource allocations. The software also helps
HR department to manage communications with prospective employees and get
them onboard quickly. The system enables the employees to manage their
leaves and daily timesheets. Using the software senior management can
generate MIS reports which help them taking various decisions.
Responsibilities:
Developing the software modules as per the requirements gathered.
Participating in requirements gathering discussions with the senior
management and users.
Writing technical specification documents and test cases
Writing T-SQL, triggers and stored procedure to obtain the desired result
from database.
Performing manual testing and validating test cases.
Fixing issues reported by users while interacting with them.
Making sure that the system is running well before doing demos.
Participating in database design discussions.
Technology: C#, ASP.NET 3.5, CSS, HTML, JavaScript, MSSQL Server 2005,
Windows Server 2000.
Radical Euro-Services SA, Luxembourg
January 2008 to March 2008
Role : Software Developer
www.radicaleuroservices.com
Radicaleuroservices.com is a corporate website for Radical Euro-Services SA
which explains about the business and services provided by Radical Euro. It
has a submit resume and contact us page using which people can contact
them.
Roles and Responsibilities:
Developing web pages for the site while getting the contents finalized by
the management people.
Working with designer to create the appropriate images to be displayed in
the site.
Proposing web layout of the website.
Coordinating the deployment and doing manual testing of the website.
Fixing any issues while coordinating with the management.
Making sure that everything works well at the time of demos.
Technology: N2-CMS structure with asp.net, HTML,CSS, MSSQL Server 2000,
JavaScript.
Professional Travel Insurance Company Limited
March 2005 to November 2007
ISCA (Travel Insurance)
Role : Software Developer
ISCA provides detailed analysis, performance and accounting data for
insurance policies underwritten by Professional Travel Insurance Company
Limited. The system is centered on regularly importing transaction premium
data and claims data from customers and suppliers.
Responsibilities:
Understanding the business requirements, specifications, and system
architecture.
Developing custom Tags and Working on the components (CFC).
Validating web filing with JavaScript and then testing them under various
scenarios.
Writing SQL stored procedures. Grasping the design of the SQL database
architecture, its schema and various tables in it.
Creating Indexes, Views, and Constraints on SQL tables.
Creating reports with CF Report Builder
Enhancing the SQL stored procedures and improving the performance of
queries.
Unit testing of code on the local host-server, QA-server and staging
servers.
Technology: Coldfsuion MX 6.1, Dreamweaver 7.0/8.0, SQL-2005, My SQL,
Fusebox Framework, CSS, IIS, MS Access, Crystal Reports 6.0, UML, HTML,
JavaScript, AJAX, XML.
TIMS (Telecom Inventory Management System)
February 2004 to February 2005
Magnet Technologies Pvt. Ltd.
Role : Software Developer
TIMS is an inventory management software enabling users to track and
analyze various telecoms component stocks.
The software has regular MRP functionality as follows
Add/modify/delete new parts.
Track inventory by parts.
Add and track customer orders.
Various MIS reports with searching capability.
Billing and order tracking module.
The project uses Cold Fusion Fuse Box framework as underlying architecture.
Responsibilities:
Lead developer co-coordinating with the team of 6 developers.
Developing Software Components.
Working on Remote web services and cfcs.
Participating in database design discussions.
Working on CFStoredProc and Query of Query (QoQ) to fetch the relevant
data.
Interacting with business analysts to discuss various requirements for
development.
Unit testing developed components.
Implemented MVC Architecture using fusebox framework.
Technology: ColdFusion Mx 6, MSSQL Server 2000, Windows Server 2000, Flex,
Dreamweaver 7.0/8.0, Fusebox, CSS, IIS, Crystal Reports 6.0, HTML,
JavaScript, AJAX.
Ideaengine Portal
September 2003 to January 2004
Role : Software Developer
www.ideaengine.org
Ideaengine is a tool that allows developing innovative marketing campaigns,
advertising and new products in very simple way. The user has to enter the
two keywords about their product and allow the engine to suggest innovative
slogans for the product using engine's intelligence.
Responsibilities:
Using custom controls extensively to provide re-usability of the code.
Developing the UI using HTML and CSS.
Validating Login modules, Document module and User Module using Java
Script.
Designing the Database using MySql.
Performing Unit Testing, Integration Testing and Peer to Peer Testing.
Played pivotal role in development team responsible for developing various
modules in the project.
Make the appropriate settings to Connect the database using CFAdmin part.
Technology: Coldfusion MX 6, Dreamweaver 7.0, HTML, UML, PHP, CSS, HTML,
MySQL, JavaScript, CSS.
EDUCATION:
Mumbai University of Engineering & Technology, Mumbai - INDIA.
2004
Bachelors of Engineering Degree in Computers (B.E.) - First Class.
Certification:
Microsoft SQL Server 2005 Implementation and Maintenance (70-431) - 2009.
Adobe Certified Expert in ColdFusion 8 - 2008.
Contact this candidate