|
|
|
Nayan
S. Patel
|
    |
|
1481, Gateview
Circle
|
|
Marietta, GA
30062
|
|
Tel: 678-467-8747 (Cell), 770-578-6134 (Home)
|
| E-Mail:
admin@binaryworld.net |
| Website:
www.binaryworld.net
|
|
 Click
Here to download updated resume in word format
(last updated on 8/1/2005)
Over 4 years of
experience in software design and development for Industrial, Client Server,
n-tier and Enterprise applications using object-oriented technology.
Extensive knowledge of Microsoft technologies and multi-tier object
oriented development with different databases as SQL Server,
Oracle and MS Access. Possess strong trouble shooting and problem
solving skills. Excellent knowledge with all aspects of VB 6.0/VB.net
with ADO, COM/DCOM,
COM+, MTS, MSMQ, Win32 API calls, Crystal Reports, SQL Reporting Services,
ASP/ASP.net, XML, VB script, Java script, HTML,
DHTML, Arcview, JAVA, C#, ADO+, C++, VC++ and Assembly.
Involved in complete project development life
cycle from design to implementation of system. Always part of system
testing, Integrity testing, module testing. Quick learner and like
to work on new technologies. Handle system administration and
network configuration also.
|
Technical
Proficiency:
|
| Operating
System |
Windows
2003/2000/XP/NT,
Windows 9x, MS DOS |
| Languages |
Visual
Basic 5.0/6.0,
VB.net, JAVA, VC++,, C#, C/C++ |
| RDBMS |
SQL
Server 7.0/2000/2005,
Oracle 7.3/8.0, Access'97/2000 |
| Internet
Development |
ASP,
ASP.net, HTML, CSS, DHTML, VBScript and JavaScript, XML with
DTD, Schemas, XSL, XSLT, DOM, Perl |
| Middletier |
COM
(ActiveX
Server, ActiveX Client), DCOM, MTS, COM+ |
| Other
Tools |
Crystal
Report 6/7/8,
Visual Interdev, VBA,DTS, Visual Source Safe,
IIS, Microsoft Front Page, Microsoft Project, Microsoft Visio, Exchange Server,
MS Outlook, PhotoShop
Flash 4.0, SQL Server Analysis service
7.0/2000, Robo Help, SQL Reporting Services |
| Data
Access Technologies |
DAO,
RDO, ADO,ADO.net |
| Methodology |
UML
using Visual Modeler |
| |
Professional
Experience:
|
|
SOFTWARE Developer/DBA,
DynaSis Corporation, Atlanta
- GA (USA)
|
|
Projects : ConnectWise CRM and Reporting
Services
|
|
|
|
|
DynaSis is a leading
managed IT services provider in Atlanta. I
was responsible to write custom reports and handling data
integration between company's CRM ConnectWise
and reporting system. The entire reporting system was designed
using Microsoft SQL Reporting Services 2000
in a highly scalable and efficient manner. The custom Sync
Engine is a core component, which integrates the CRM and
Reporting System and it was written using
VB6/COM. |
|
Projects : Claim Management System
Client: NADO Insurance Company
|
|
|
Claim
management system allows company users to
add, delete, and manage claims information.
System allows different level of access to
different level of users based on their
credentials assigned by system admin. Here
is the list of some basic tasks allowed by
the system.
- Add,
delete and update claims .
- Upload,
delete and view claim documents .
- Manage
partners, users, insurance companies .
- Manage and
search invoices and deposits ... |
|
Project: H & A Jewelry E-Commerce site
Client: H & A International
|
|
|
This is a full functional
online store for diamond jewelry. Online
store contains 2 main applications
- E-Commerce site for customers
- Admin Site
Site includes the following functionality
- Shopping cart functionality
- Different payment options (i.e. PayPal,
Credit card)
- Products and Inventory management through
Admin site
- Shipping and Tax handling
- Recurring Billing option
- Bulk product upload using Admin site
- Discount, Wishlist, Gift card, Affiliate
Program
- Inventory Reports, Sales Reports and many
more . |
|
Project:
Data Synchronization and Integration
Client: The Andersen Group
|
|
|
|
Andersen group runs their
collection management software "Debt Master"
in Louisiana and their Web Hosting is in
Georgia. Debt Master runs on Sybase Adaptive
Server Anywhere. The challenge was to keep
their website updated with most recent data
entered in Sybase using "Debt Master". I was
responsible to write custom data
synchronization and integration routines in
a highly efficient manner so every day
several millions records can be synchronized
in a very short window of time without
hurting website users. |
| |
|
Tools & Technology used
|
|
XML, SQL Server 2k, VB.net, VB6, COM, Stored
Proc, Triggers, BCP, DTS, MSDE, Reporting
Services, Kaseya (Network management
system), ConnectWise (CRM) |
|
|
|
|
System
Developer,
SQData Corporation, Atlanta
- GA (USA)
|
|
Projects : ETL Design Studio
|
|
|
|
The SQData ETL Design Studio is an easy to
use Graphical User Interface (GUI) that
enables you to quickly develop and maintain
your data movement interfaces. From the
start, the intent of our Design Studio was
to significantly reduce the time required to
develop and deploy data integration
interfaces by overlapping some of the design
and development tasks.
The Design Studio includes several
time-saving features that allow user to:
- Create relational DDL, XML and C/C++
structures from any SQData supported data
structure such as a COBOL copybook or
relational DDL.
- Create relational database load utility
control statements based on the content of
the data movement interfaces.
- Create common procedures and share them
between projects
- Multi-level array handling (repeating
groups) of source data store records/rows
- Migrate objects to/from different
environments
The Design Studio's integrated metadata
repository is used to store the critical
information regarding corporate
databases/files along with the business
rules associated with your data. Software
metadata repository can be any ODBC
compliant relational database of your
choice. In addition to the reports supplied
with the Design Studio, user has the ability
to run your own SQL queries against the
underlying metadata to generate custom
reports. |
|
Projects :
Audit-X (Data Auditing Software)
|
|
|
|
|
Audit-X is designed to track data changes
(Update/Delete/Insert) in SQL Server.
Audit-X is easy to use tool which doesn't
require any programming for end user. You
can Audit several databases and tables using
this one tool. Audit-X keeps track of some
useful information e.g. Timestamp of data
change, Table name, database name, SQL
Statement which caused the change, User ID,
data row before change and data row after
change. |
|
|
|
Tools & Technology used
|
|
XML, SQL Server 2k, VB.net, VB6, COM, Stored
Proc, Triggers |
|
|
|
|
DBA/System Developer,
Binaryworld.net, Atlanta - GA
(USA)
|
|
Projects :
www.binaryworld.net site design and
development
|
|
|
|
Binaryworld.net
is a portal, which gives you access
to huge amount of programming resources.
Some features of Binaryworld include
ColorCoding for various languages,
FullText
Search on huge database; Membership
based Article Submission, Win32 API
Dictionary with more than 60,000
API/Constants/Structures, Keyword
Auto Hyperlink and many more.. Binaryworld
uses proprietary algorithm to give
ColorCoding for various languages. |
|
|
|
Responsibilities: |
-
Involved in designing site UI
(User Interface) and System
Design.
-
Implemented FullText
Search using
SQL Server/COM/VB.net/ASP.net.
-
Implemented Visitor tracking
System to find out visitors by
country. Used MaxMind
GeoIP database,
DTS,
T-SQL and
ASP.net to accomplish this task.
-
Designed a highly optimized
ColorCoding
component using RegX (Regular
Expressions) in
VB.net.
-
Created COM
component in VB 6.0
for Bulk SMTP
email and integrated it with
T-SQL.
-
Involved in site Database design
and coding various
Stored Procedures
and UDF.
-
Involved in Testing and
Performance Tuning of site.
Tools & Technology used
|
|
SQL Server 2k, VB.net/VB 6.0, ASP/ASP.net,
.Net Framework 1.0/1.1, Visual Studio 2003,
FullText Search, IIS 6.0, COM, Win32 API |
| |
|
|
SQL
DBA/Report Analyst/Programmer,
Intown Suites Management Inc., Atlanta - GA (USA)
|
|
Projects
: NiteVision/Automated Reporting System/Folio Viewer
|
April 03
- Current
|
| |
| Intown
Suites a hotel chain with 118 hotels all over the US. The head quarter
of Intown Suites is in Atlanta. All 118 properties are connected to the head
quarter by high speed Internet connection lines (i.e. T1). All
hotels run custom application called NiteVision This application stores
the data in local MSDE database. At corporate Head quarter there is a
process called Sync Process which synchronizes property data with
corporate database. Sync Process is called by SQL Job which creates new
instance of COM+ component. This Corporate Data is used for reporting of
all properties. There is an Automatic Reporting System which generates
reports according to schedule (i.e. daily/weekly/monthly) and sends reports in Word
Document Format or Excel Spread Sheet Format to the concerned
people. This entire Reporting Process is Automatic so no need of human
interaction. Whole reporting system is heavily dependant on stored procedures. |
| |
| Responsibilities: |
-
Involved in creation/maintenance of corporate
databases.
-
Creation/Modification complex
stored procedures which
are used for various reports.
-
Creation/ Maintenance of Indexes for vary fast and
efficient reporting process.
-
Analyzing the Database Growth and Space Requirement.
-
Handling Users/Logins/User Rights.
-
Creation/Deletion of Linked
Servers.
-
Managing historical data from various
heterogeneous data sources (i.e. Excel,
Access, SQL 6.5/7.0/2k,
and CSV Files).
-
Used DTS to
Extract/Transform/Load historical data (Stored in CSV files)
in to SQL Server 2k.
-
Created several Complex Reports using
MS Access. Used
macros, linked tables, pass through queries and many
-
other access features also wrote code in Access Basic
to perform some complex reporting tasks.
-
Created an application (Folio Viewer)
using VB 6.0 and Crystal Report 8.0 for
Guest Receipt this queries 3 different SQL
Databases having more than 40 Million
Records to search a particular guest by various
conditions (i.e. first /last name, arrival/departure date, hotel name etc.)
-
Designed database and Visual Basic Application to
handle Phone Billing Information for all 118 properties which reduced 60% paper
based search to verify billing information for each and every property for
different providers.
Created a very complex Excel Spread Sheet Occupancy Report for CEO/CFO/COO
using VB Programming which populates spread sheet using 3 other Excel Sheets,
SQL Server DB and MS Access DB. This report contains daily Occupancy for all 18
properties by Regions/Areas/Districts and Property.
Tools &
Technology used
|
| SQL
Server 2k/7.0/6.5, VB 6.0, MS Access, DTS, COM/COM+, Crystal Reports 8.0 |
|
| |
|
SENIOR
SOFTWARE ENGINEER,
Hi-Tech Engineering , Daman (India)
|
|
Projects
: Yarn Quality Monitoring System
|
November
01 - October 02
|
| |
|
Yarn
Quality Monitoring System is an ultimate combination of Electronics, Textile
and IT.
This System is used to monitor quality related problems during polyester yarn
manufacturing and it contains two main applications Machine Console and
Remote Analysis Console. Presently this system is installed in IRSL
(Indorama Synthetic Ltd.) one of the biggest polyester yarn manufacturing
plants in India.
Machine Console application
contains low level hardware interaction module, database module, network
module, printing module, graphics module and many more. Actual data acquisition
and error analysis is done using Machine console. This application is able to
process 24000 readings per second, which are taken from sensors installed
on Texurising machine. Machine Console detects Quality related faults and many
other events during error analysis phase. Machine Console is able to generate
various MIS reports. For each Texurising Machine full Quality Monitoring
System is installed which contains hardware (sensors, A/D cards ,I/O cards, MUX
cards etc.) as well as software (Machine Console Application). Machine Console
generates very large amount of data and which is stored in local database (MS
Access) and at the end of day data is transformed and loaded in
centralized database (MS SQL Server 2000) using DTS 2000.Thus at
the end of day summarized data of each and every Texturising machine is loaded
in to the SQL Server database then this data is used by various
departments of company.
Remote Analysis Console
Application is
used for executive people. Using this application whole plant can be monitored
in a single console. Thus Remote Analysis Console provides detailed centralized
monitoring and analysis for each and every machine in the plant. Remote
Analysis Console establishes connection to every available Machine(s) using TCP/IP
Socket. Executives can generate various kind of MIS reports as
well as they can do online monitoring of selected machine.
|
| |
| Responsibilities: |
-
Involved in documenting requirements &
specifications.
-
Analyzed old DOS based system (written
in C++ and inline
Assembly) and prepared system migration
plan to migrate DOS based system
to Windows based system.
-
For very fast hardware response
developed Win32 dll in
VC++ which contains low level hardware routines.
-
Designed Active-X dlls to create reusable components
for many modules used by both applications, managed version control too.
-
Implemented threading using
VC++ for periodic status
check/write operations.
-
Designed Graphical User Interface for
Machine Console using VB
6.0.
-
Developed Active-X
components in VB 6.0.
-
Designed and Coded Application Level
Protocol to communicate with Remote Analysis
Console using TCP/IP
Socket using VB
6.0.
-
Designed Web application to get online
data access in Intranet using HTML,
ASP, DHTML,
Jscript and JAVA.
-
Coded security module, database module,
network module, report module using
VB
-
Designed normalized database schemas
and implemented using
SQL2k/Access.
-
Coded Stored
procedures, Triggers,
Indexes, Views and
also managed Backup- Recovery, Performance tuning,
-
Replication and Users/Logins using
SQL Server.
-
Generated Complex MIS reports using
Seagate Crystal Report and VB
6.0 for Production and Quality Control departments.
-
Installed and Configure Win2k
Servers as Domain
Controller and Member Servers.
-
Installed and Configured DNS
Server / DHCP Server / IIS
Server / RRAS Server.
-
Coded Printing module to print
screenshot of bar graphs and signal graphs in
VB.
-
Designed layout for Database
Warehouse using Star
Schema.
-
Designed ETL (Extract Transform and
Load) strategy using DTS 2000.
-
Used SQL Server Analysis Service to design and
populate Cubes using ROLAP storage method.
-
Written MDX Queries to
fetch data from Cube using ADO MD.
-
Prepared system Help File using RoboHelp.
Tools &
Technology used
|
| Visual
Basic 6.0, VC++, Assembly, SQL Server 2000, Analysis Service 2000, MS Access,
COM, Visual Modeler, Robo Help, Crystal Report
8.0 |
|
| |
|
SOFTWARE
Developer, Surat
Municiple Corporation, Surat (India)
|
|
Projects
: GIS (Geographical Information system)
|
January
00- November 01
|
| |
| This
system is able to store geographical data. Data can be anything like
electricity distribution information, road information, railway track
information, city, state, police stations, fire stations etc. Layered
information is fed in to the database using GIS Map editor. One can
create different layers e.g. road layer in which you can feed various data
related to roads which may contain information like start and end point of
road, road number, road type etc. Then complex queries can be executed to
retrieve required information. Stored data can also be used by ASP to
generate html pages requested by user. |
|
|
| Responsibilities: |
-
Involved in Database Design for Geographical
Information System.
-
Coded stored procedures, triggers and user defined
functions. Data retrieval was achieved through stored procedures which pass the
data back to the client in the form of disconnected recordsets.
-
Generated various reports using Crystal report and
Visual Basic 6.0.
For ORACLE database coded many Stored Procedures using PL/SQL.
-
Coded many complex Stored Procedures using T-SQL with
some advanced concepts (e.g. cursors, locking, and transactions) for SQL Server
database.
-
Used Arcview to design sophisticated maps.
-
Designed MAP Editor Application in Visual Basic to
enter Geographical data using very easy to use GUI.
-
Designed Middle-Tire COM+ Components using VB and MTS
to handle better consistency and concurrency.
-
Designed web application to access corporate data
using Visual Interdev, ASP, DHTML, JScript, HTML, XML, XSL and CDO.
-
Tested and validated different modules.
-
Involved in integration of different modules and made
package for deployment.
Tools
& Technology used
|
| VB 6.0,
Visual Interdev, SQL Server 2000, Crystal Reports 7.0, ASP, MTS, Arcview |
|
| |
Qualification/Certifications:
|
-
B.E. - Computer Engineering (4 years)
Sarvajanik College of Engineering & Technology
-
Microsoft Certified Database Administrator (MCDBA 2000)
-
Microsoft Certified System Developer for .net (MCSD.net)
-
Microsoft Certified Application Developer (MCAD)
-
Microsoft Certified System Engineer (MCSE 2000)
-
MCP ( Data warehousing ) -
In Progress
|
|
| |
| |
|
"Success is a journey, not
a destination ..."
|
|