Bhavesh Patel
Cell: 630-***-****
E-mail: *********@*****.***
Summary:
As a Computer Application Developer more then 15+ years experience
Knowledge and experience to follow the all phases of Software Development Life Cycle (SDLC) methodology
Extensive experience implementing software user interface improvements based on client needs.
Experience to Design & Development of Client - Server Application with Relational Database Management System(RDBMS)
Extensive experience of development of VB, VBA application with Ms Excel and Ms Access with OLE method
Strong expertise in writing complex Access, Excel Macros with Excel VBA for different Business Environments.
Experience in report design, table/query design and automation using VBA modules.
Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for data analysis & finance industry.
Evaluated numerous complex system problems and user requirements. Ability to develop structured and modular solutions. Built program specifications, requirements analysis and internal design to meet rigorous client standards.
Extensive experience in cutting edge of technologies for Microsoft Software
Technical Skills:
Operating System – Windows platform, DOS
For Application Development VB 6.0, VBA,VB.net with Excel, Ms-Access, SQL Server
Web Application development using PHP & My SQL, JavaScript, CSS, HTML5
Database development/scripting using Ms-SQL, Oracle, Ms-Access
Software MS-Office
Business/Soft Skills:
Requirement gathering, risk assessment, product demo/presentation, Customer interaction
Project management, execution and resource management
Working with team using agile methodology, planning, defining priorities
Planning and execution of Business Solutions
Professional Experience:
Freelancer, Ahmedabad, India
From Nov-2004 to Dec-2017
As freelancer, developed the computer application for business needs for financial, commercial & technical subjects as per client’s requirements.
Developed application in VB 6.0, VBA, VB.net with MS-Access, Ms-Excel, COM component, SQL, Activex Control for data analysis & database management
Experience of Data analysis and work on database management system with MS-Access and Ms-Excel with VBA, Pivot table, vLookup, External Data & macros
Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
In civil engineering field, developed application for Land surveying data, for analysis, drawing generation & database management with VB 6.0, VBA, VB.net, Visual Lisp, Ms-Access & SQL Server
Web application using PHP, JavaScript & My SQL, HTML5, CSS
Wilbur Smith Associates Private Ltd., Ahmedabad, India
Dec 2001-Oct 2004
Responsibilities:
Company is engaged in consulting business of urban infrastructure, transportation facilities, engineering planning, economic strategy development & environmental projects, respond to project design & developed computer application for data analysis
Development of computer application as per requirement of projects & drawing generation application as per requirement of the projects
Analyzed, Extract & Transfer geographic data to database management system
Experience:
Developed application in VB 6.0, VBA-Excel, C for different project
Developed application in VB 6.0, VBA with MS-Access using ADO Data Control & DAO. Application Developed for data analysis & database management
Drawing generation application in VB 6.0 & VBA-Excel interfacing with AutoCAD software
Drawing generation application in Visual Lisp & VBA support by AutoCAD
Developed an Automatic Reporting System which can reports according to the schedule in Word Document Format or Excel Spread Sheet Format, Crystal Report with VB 6.0
Cacit Consultant Pvt. Ltd., Ahmedabad, India
Computer programmer, Nov 1990 –Dec 2001
Responsibilities:
Design & develop computer programs for civil structural engineering field (for Analysis & Design) & development of computer application in commercial business as per client needs
Development of drawing generation application for civil engineering field
Report generation & Database management application
Experience:
Developed application in VB 6.0, VBA-Excel, Fortran & C language for civil engineering field
Developed application for commercial business in VB 6.0, VBA with Ms-Excel, MS-Access
Drawing generation application in VB 6.0 & VBA-Excel interfacing with AutoCAD software
Drawing generation application in Visual Lisp & VBA support by AutoCAD
Developed an Automatic Reporting System which can reports according to the schedule in Word Document Format or Excel Spread Sheet Format
Report generation in VB 6.0 with Crystal Report, MS-Access
L.D. College of Engineering, Ahmedabad, India
System Software Operator & Programmer, Applied Mechanics Department, March 1988 –Oct.1990
Responsibilities:
Teach computer programming language to Master of Engineering student (Computer Aided Structural Analysis & Design)
Guide the student for computer program, debug solve the problem computer programs for their dissertation thesis project
Develop the computer program for department & college
Experience:
Guide students in FORTRAN, AutoLisp & C computer programming languages
Computer application interfacing with drawing generating software AutoCAD
Developed computer application for payroll system
Database management in dBase III
Qualification and Certifications:
Bachelor Degree of Science (Physics)
Microsoft Certified Solution Developer (MCSD)
Certificate from SSI- Java & Oracle
Additional Information
Address : 643 Gundersen Dr.
Appt #102
Carol Stream 60188
IL
Visa status : Green Card Holder