Pragnesh Patel
*** ********** **. ************ ** 28311
ab9hfd@r.postjobfree.com
910-***-**** (Home)
803-***-**** (Cell)
Objective:
To obtain a challenging software Engineer position as a member of a team
developing business solutions where skills and experience can be utilized
Skills.
Career Summary
. 14 years of IT experience in System Analysis, Data Analysis and Report
Development inclusive of around Four years of Data warehouse reporting
of various commercial applications and experience in Retail and
Childcare.
. 4 years of experience in configuration, Installation & modification of
application packages developed with Java/XML/ASP/.NET web base
applications.
. 2 years of Experience with .NET technologies, C#, WCF, WPF and Visual
Studio 2010.
. Team Player, Multitasking: Ability to handle multiple projects at same
time and proven experience in working under pressure.
. Worked in different phases of software development life cycle i.e.
Development, Integration and Testing, Implementation.
. Proficient in writing stored procedures, functions, trigger and
related T-SQL code.
. Strong understanding of database structures, theories, principles and
practices.
. Experience in troubleshooting data related issues and provided clear
and reasonable resolutions.
. Extensive experience with relational database (SQL) and dimensional
modeling techniques.
. Robust knowledge on Data Loading and Reporting tools such as SSIS,
SSRS and Crystal Reports, Report Builder 3.0.
Technical Skills
. Methodologies Object Oriented Analysis, Modelling and Design,
Model Driven Architecture,
Test-driven Development, Continuous Integration, Structured
Analysis and Design, Database Normalization, Entity-
Relationship Modelling, SSIS, SSAS, SSRS,
. Languages ASp.Net, C#, Classic ASP, Delphi/Pascal, C#, T-SQL, PL-
SQL, ANSI-SQL,
DHTML, JavaScript, VBScript, Java, JSP
. Specifications JSE 6, JEE 1.4/5, XML, XML Schema, Servlets, JDBC,
Java Web Start/JNLP, ADO.
. Middleware IIS server 5.0/7.0, Apache Tomcat 6.0,, Jrun 2.3/ 4.0,
WebShpere
. Database MS SQL Server 2000/2005/2008/2012, Informix, Access
. CASE Tools MS Visio
. IDE/Tools Eclipse, Delphi, MS Visual Studio 2008/2010, Visual
SourceSafe,
Crystal Reports, Report Builder 3.0, JBuilder, Home Site,
visual Interdev
. OS Windows
PROFESSIONAL EXPERIENCE
Tree LLC. Greenwood SC
March 2005- Now
Software Developer
. Analyzed and discussed business requirements with the client
. Created use cases and performed walkthroughs with the client
. Assisted in creation of the project plans. Designed and developed
modules for OLR applications
. Created system specifications and design documents for OLR and
Online Payment prototype modeling
. Performed re-factoring, optimization and fine tuning of performance
sensitive modules
. Installed and provided consulting support for OLR and Online Payment
System
. Designed and deployed rdl files, data model and data source views
for management and admin department related Reports.
Highlight Projects
Childcare Online Registration Portal (OLR)
Description: Integrated Childcare Online Registration Portal (OLR) in
existing LMN-Tree Child care application. Designed OLR System
Database.
Environment: C#, .net, SQL server2008, Java, HTML, Java script, Visual
Studio 2010/2012.
LMN-tree Reporting services
Description: Created/Designed Reporting data Warehouse. ETL data from LMN-
Tree database into reporting Data Warehouse. Designed and developed
Reporting services for LMN-Tree childcare system. Designed and deployed
management reports data model using SQL Server Business Intelligence
Development Studio. Designed and deployed management reports .rdl files
using report builder 3.0. Developed Query for generating drill down
reports in SSRS 2008 prepared AD HOC reports through report builders.
Environment: MS-Sql2008, SSIS, SSRS, SharePoint
Global Payment online Payment solution
Description: Integrated Global Payment online Payment solution in
existing childcare program. Added module for processing Electronics check
and credit card with swiped and keyed feature for Centre director and
Parent portal. Automated the batch processing and parsing reporting data
daily from global payment site for 150 centers.
Environment: SQL server2008, Java, HTML, Java script, VBScript.
CRM Imports
Description: Design C# client application to import child care family
information from CRM into LMN-Tree.
Environment: MSQL server2008, C#, WCF.
Childcare Management:
Description: Childcare Management is a fully integrated Internet
application to manage all aspects of a single or multi-unit childcare
operation. It is developed in ASP and MSSQL. It is handle child care &
daycare administrative tasks including Family & Child Information, Family
Accounting & Child Care Billing, Payroll, Bill Paying including online,
Time Clock Hours, Attendance Tracking, and Budgets & Financial Reporting.
.Analysis, Design, Development and Testing of the system.
.Involved in development of entire project
.Involved in testing the application in all the phases, unit testing,
system testing and acceptance testing by client.
.Bug fixing for both acceptance and production tickets
.As primary support person, involved in monitoring and supporting the
application
.Enhancing the application and working on new releases.
.The definition of underlying ASP.net, Jscript, VBScript, support full DBA
role to MSSql design and development.
.Environment: HAPedit, ASP, Windows 2000/XP, JScript, IIS5.0, HTML,
JavaScript, and MSSql.
POS Project:
Description: Design and developing Retail in Point of sell software. POS
System is Client/server application to manage all aspects of a single POS
(Including merchandising and inventory management, purchase orders,
scheduling, and shipping/receiving, modules for Gift Cards, Store credits,
Gift Certificates, Loyalty Points, Price management with temp/permanent
markdown/markup pricing, price grouping, volume pricing)
Support full DBA role to MS-SQL database design and development.
Environment: Visual Studio 2012, WPF, MVVM, WCF, MSSQL 2012 and ADO entity.
Strategic Outsourcing Inc. Charlotte NC
August 1999- June 2004
JAVA/Application Developer
Employee Maintenance (HR Management) is an internal web based Human
Resource management application developed in Java server pages for the
payroll department of SOI to manage employee information. It is used to
maintain demographic, general client and payroll info, benefits/deductions
info, taxes info, employee notes, payroll info, general H/R and emergency
contact info.
. Analysis, Design, Development and Testing of the system.
. Involved in development of entire project
. Involved in testing the application in all the phases, unit testing,
system testing and acceptance testing by client.
. Bug fixing for both acceptance and production tickets
. As primary support person, involved in monitoring and supporting the
application
. Enhancing the application and working on new releases.
. The definition of underlying Java Servlet framework, Data Access Objects,
JSP design, custom JSP tag library design and development.
. Environment: JAVA, Windows 2000, Apache, Tomcat, JBuilder, HTML,
JavaScript, JSP, Servlets, Jrelational Framework, Informix.
Single Point of Healthcare Benefits Management is an internal web
application developed in Java server pages for the benefits department of
SOI to manage benefits information. Currently Benefits Administration is
outsourced to Electronic Benefits Service (EBS), a third party processor of
benefits. EBS is responsible for maintaining benefit information about
SOI's leased employee and their dependents as well as providing data feeds
to SOI Benefits providers. This project was initiated to bring the
maintenance and enrollment for employee benefits in-house. Thereby,
providing a cost savings by reducing the need for third party eligibility
administration.
. Development and Testing of the system.
. Involved in development of entire project
. Involved in testing the application in all the phases, unit testing,
system testing and acceptance testing by client.
. Environment: JAVA, Windows 2000, Apache Tomcat, Eclipse, JavaScript,
Servlets, and Informix.
Client/Employee Maintenance is an internal client server application
developed in java applets for create and maintains clients and employees
information. This application hires and rehire employee, maintain client
location, payroll information.
. Development and Testing of the system.
. Involved in development of entire project
. Involved in testing the application in all the phases, unit testing,
system testing and acceptance testing by client.
. Environment: Windows 1998, VARSADA, java, java beans, corba, Informix and
MS Access.
Time Entry System is an online web application developed in Active server
pages for the clients of SOI to do their payroll online. It is used to
process regular pay, one-time deductions and extra checks in just a few
easy steps. Clients can also upload Time clock data into the system and
view a wide range of payroll reports that outline all the data in easy-to-
read formats.
. Analysis, Design, Development and Testing of a time entry web application
for the clients of SOI.
. Involved in development and update of the documents (specification
documents, functional documents, project plans, technical documents, test
plans and user manuals for the project)
. Involved in development of entire project
. Involved in the Database model
. Involved in creating stored procedures
. Involved in testing the application in all the phases, unit testing,
system testing and acceptance testing by client.
. Implementing the new release
. Bug fixing for both acceptance and production tickets
. As primary support person, involved in monitoring and supporting the
application
. Enhancing the application and working on new releases.
. Environment: 2000 NT, IIS 5.0, Homesite, ASP, HTML, JavaScript, VB,
VBScript SQL Server 7.0, Informix.
Bacon E-Commerce, Charlotte NC
December 2000 - February 2001
Software Engineer (Contract)
Develop online store for selling commercials filters.
Environment: JSP, java, Servlets, java mail, MQ Series, and web shepher,
Oracle
and DB2 database.
Information Architect, Charlotte NC
August 1998-August 1999
Programmer Analyst
Auditing and remediation of year2000 code in C, C++, JAVA, PL/SQL, and
Oracle.
Reengineering of the source code related to the Y2K.
Developed PERL scripts to search Y2K related code and use windowing
Perl/Tk.
Experience gained for Object-Oriented programming with C++, JAVA and
database
PL/SQL, and Oracle.
Environment Sun Solaris, Lotus Notes, and Windows NT.
Solectron Technology Inc. Charlotte NC 1996 -1997
Technical Analyst
Analyzed and fault tested Industrial Circuit Board. Maintaining production
flow.
Troubleshooting service return power supply.
Testing and troubleshooting Redundant and Fault-tolerant Circuit Board.
Managed Quality Testing Process of the service return data collection
software
for an Electronics manufacturing company in client-server environment.
EDUCATION
M.S., Electrical Engineer, University Of North Carolina Charlotte.
B.S., Electronics Engineering, Nagpur University, India
AWARDS
Employee of the quarter Award First quarter 2000. On line Time Entry
System.
Impact Award of year 2002. SOI team award SOI portal application.
Work Status
U.S. Citizen
Reference Available Upon Request