Mukesh Khandelwal

Personal Details:

Age - ** Years

Nationality - Indian

Email Id - aduwkb@r.postjobfree.com

Mobile # 971-***-****

Summary:

** ***** ** ********** ** Software Development.

Experienced in development of Desktop applications.

Development experience with Visual Foxpro Ver-6,9, Foxpro For DOS/UNIX, Dbase.

Experience in database MS SQL Server, MySql.

Microsoft office Automation with Visual Foxpro.

Got training in ASP .Net, Java, Visual basic. Currently learning Python, Django Framework.

Education

Master of Computer Application (MCA), Sikkim Manipal University, India, 2011.

BSc.-IT Sikkim Manipal University, India, 2009.

2Years Diploma in System Management, NIIT, Delhi, 1993-1994

Certification

Microsoft Certified Professional (MCP) in 2004

Sun Certified System Administrator for Solaris 10 OS (Part I & II) in 2010

CCM certification “Inspire Designer Basic” in 2019

CCM certification “Inspire Content Manager Basic” in 2019

Technical Skills:

Languages : Visual FoxPro Version 6 & 9, Foxpro For Unix & Dos, Dbase

RDBMS : SQL Server

Operating Systems : Windows, SCO UNIX 3.2

Experience Details

Company: Universal Technology Services Pvt. Ltd. Unit of Universal Weather & Aviation, Inc. US

Tittle: (Software Developer) December 2020 – Till Date

Projects: Company is having a product called “FlightPak” which is used by clients for scheduling and Trip Planning for charter planes. My responsibility is to maintain this product (enhancement/debugging etc.).

I am also doing some development using .Net, c# to integrate it with SalesForce, Sharepoint.

Company: Macrosoft Inc., NJ, U.S./Kerala December 2015 – Feb 2020

Tittle: (System Analyst)

Projects: Here i was working on a Database Migration project in which we have to change VFP Database to SQL database and do changes in VFP application so that it will communicate with SQL database.

Here with the team, I have developed following tools which will help in migration

1.DataMorph -will migrate VFP database to MSSQL,MySql,PostgreSQL,MongoDB.

2.SpecGen -will generate Technical Specification Word Document from foxpro source code

3.CodeMatrix -will show the stats of FoxPro source code in excel report like number of screens, programs, libraries, objects, commands etc.

4.DBAnalyzer -will generates different reports in excel showing foxpro table details like fields, relations, indexes, record count etc.

Project 1: (VCS)

Tools : Visual FoxPro Version 9, Word

Role : System Analyst

Responsibilities : Analyzing project & Documentation

Duration : December 2015 – October 2016

Description:

I worked here as System Analyst in Migrate to .Net Team. In this project i have to analyze/understand the project, its logic and document it to help .Net Team to migrate it to .Net.

Project 2:(Metro)

Tools : Visual FoxPro Version 9, Word

Role : System Analyst

Responsibilities : Coding, Analyzing, Developing & Documentation

Duration : December 2015 – March 2017

Description:

In this project, requirement is to change the VFP database backend to SQL Database and document the functionality of the project. This document will be used by Dot Net developers for migrating this project to Dot Net.

Company: Macrosoft IT Solutions India Pvt. Ltd. May 2015 – July 2015

Tittle: (System Analyst)

Projects:

Project 1:

Tools : Visual FoxPro Version 9, Word

Role : System Analyst

Responsibilities : Analyzing project & Documentation

Duration : May 2015 – July 2015.

Description:

I worked here as System Analyst in Migrate to .Net Team. In this project I document the logic applied in the VFP application.

Company: Symphony Infotech August 2010 – December 2014 &

Tittle: (Senior Programmer) August 2006 – April 2007

Projects:

Project 1: (Elite Real Estate Management System)

Tools : Visual FoxPro Version 9, SQL Server, XML, Excel, Word

Role : Developer

Responsibilities : Coding, Analyzing, Designing, Developing

Duration : August 2010 – December 2014.

Description:

This package is for Real Estate Companies for managing Allotment of Flats /Plots/ Shops etc. & their Payments plans. Package covers the following areas:

Defining Unit Size, Unit Numbers, Payment Plans, Broker commission slabs, PLC, ADC,EDC.

Booking Details Entry, Installment Payments, Transfer of Unit, Co-Applicants Details, Receipt Entry & printing.

Generates various letters like Allotment letter, Demand Letter, No objection certificate, Request for NOC, Permission for mortgage, Triplet Agreement, Buyer Agreement in Microsoft Word.

Reports like due payments, Broker wise commission, Sizewise/ratewise/brokerwise Bookings and many more.

Project 2: (Human Resource Management System - HRMS)

Tools : Visual Foxpro Version 9, SQL Server, XML, Excel, Word

Role : Developer

Responsibilities : Coding, Analyzing, Designing, Developing

Duration : August 2010 – December 2014.

Description:

The HRMS covers varied aspects of HR department of an organization in a streamlined and efficient manner. This includes

Recruitment, Employee Master, Training and Evaluation, Payroll generation.

P.F/ E.S.I.C Statutory Reports, Income Tax Calculation Processing, Full & Final Settlement.

Annual Benefits processing, Letters generation & MIS Reports, Online Bio-Data Submission.

Employee's Performance Appraisal.

Setup for Salary, PF, ESI, Bonus, Leave and Professional Tax Structure.

Can Create Multiple Companies, branches, departments, locations, ESI & PF numbers.

Project 3: (Visual Payroll – VisPay)

Tools : Visual Foxpro Version 6

Role : Developer

Responsibilities : Coding, Analyzing, Designing, Developing

Duration : August 2010 – December 2014.

Description:

The Vispay software covers the following aspects.

Payroll Generation

Setup for Salary, PF, ESI, Bonus.

Handles Salary of Contract & Permanent & Daily Wages Employees.

P.F/ E.S.I.C Statutory Reports, Pay register.

Project 4: (Facility Management System for Builders-FMS)

Tools : Visual Foxpro version 9, SQL Server, XML, Excel, Word

Role : Developer

Responsibilities : Coding, Analyzing, Developing & Maintenance

Duration : September 2012 –December 2014.

Description:

FMS is comprehensive Real Estate Facility Management System especially designed for Real Estate Industry. The System will maintain unit wise database of occupants, who occupies the flats/shops (customers). It keeps the records of meter readings, generates the bills towards maintenance charges, electricity, water, gas, internet and others. It also keep the records of receipts against the bills, calculate surcharge on overdue bills, and generate outstanding statements. System will also include offline voucher posting in financial accounting, from which financial accounting statements can be generated.

Maintenance of Other Visual Foxpro Projects:

Gym Management Software

Wines Management Software

Attendance Management Software ( Import Attendance From Bio-Matric Machine)

Inventory Management

Company: (Overnite Express Limited) May 2007 - July 2010

Tittle: (Team Leader)

Projects:

Project 1: (Financial Accounting Software for Courier Business)

Tools : Visual Foxpro 9, SQL Server

Role : Developer

Responsibilities : Coding, Analyzing, Designing, Developing

Duration : May 2007 – July 2010.

Description:

This Software take cares for all financial needs from daily Expense vouchers to Balance Sheet.

Project 2: (Business Associate Accounting Software for Courier Business)

Tools : Visual Foxpro 9, SQL Server

Role : Developer

Responsibilities : Coding, Designing, Developing

Duration : May 2007 – July 2010.

Description:

This Software will take care of accounting part of Business Associates (Booking & delivery Agents) of the Company & includes Entry of their Booking & Delivery Commission & various MIS reports.

Company: (C-Soft Consultants) September 2004 - July 2006

Tittle: (Senior Consultant)

Project 1: (Subscription Management System For Publishers)

Tools : Visual Foxpro 8, SQL Server

Role : Developer

Responsibilities : Coding, Analyzing, Designing, Developing

Duration : September 2004 –July 2006.

Description:

This package is used to manage Subscription of Journals / Books to Customers & their payments. This package is developed in VFP-8. This covers the following areas

Master Entry of Journals / Books / Customers etc.

Generation of Proforma Invoice for Subscription.

Receipts Entry, Dispatch Entry, Un-supplied entry.

Generation of Renewal Notices.

Letters to customers.

Project 2: (Book fare Software)

Tools : Visual Foxpro 6, SQL Server

Role : Developer

Responsibilities : Coding, Designing, Developing

Duration : September 2004 –July 2006.

Description:

This package used to for entering sales made in Book fair. Afterwards which will be merged in data of Subscription Management Software

Project 3: (Online Book Catalogue)

Tools : Visual Foxpro 8, SQL Server, Power Point, Word

Role : Developer

Responsibilities : Coding, Designing, Developing

Duration : September 2004 –July 2006.

Description:

This package is created for publisher. All the information regarding books will be stored in a SQL database. User will have a interface for selecting Books to be included in Catalogue & Catalogue of selected books will be generated in PowerPoint (One Book / slide) or Word (One book / Page). Catalogue information include Author name, Subject, Sub subject, Brief description about book in text / in gif file, no. of pages, price, remarks etc.

Company: (South Eastern Carriers Limited) February 1998 – July 2004

Tittle: (System Administrator & Developer)

Projects:

Project 1: (Transport Management System)

Tools : Foxpro For Unix

Role : Developer

Responsibilities : Coding, Analyzing, Designing, Developing

Duration : February 1998 – July 2004.

Description:

This package stores Documents details like Consignment, Challan, Short Excess Damage report, Delivery Acknowledgement Forwarding Memo, Bills, Money receipt, Lorry Hire Payment.

Generates various types of over 100 reports, e.g. Outstanding Bills, Costing of Consignment, Customer/Staff Ledger, Consignment in Stock, Short Excess payment.

Entry of Daily Cash Statement, Payment Received, Payment to Lorry hired

Payroll generation integrated with cash statement.

Daily data backup send to and received from different branches

Project 2: (Student Management System)

Tools : Dbase

Role : Developer

Responsibilities : Coding, Designing, Developing

Duration : February 1998 – April 2003.

Description:

This system was developed for Aptech Center, Noida and Aptech Center, Madras Branch

Maintains Student and Staff Master Details.

Maintains Database of Courses Details, Payment plan.

Data Entry of Payment advice, Payment receipts daily cash statement.

Maintains Library Details ( Issue and receipt of books, Late penalty)

Reports like Outstanding students, Staff Payroll Register, Student attendance Sheet, CashBook, Trial balance.

Job Profile:

Making Connectivity of UNIX with Novell NetWare Server using TCP/IP, SPX/IPX

Design, development and maintenance of TMS (Transport Management System) system on Unix platform.

Planning, Installation, Configuration & Maintenance Of Unix Server 3.2 Mounting, Dismounting File Systems.

Planning And Designing of various MIS reports with Sr. Executives.

Creating shell scripts to store backup on External hard disk.

Creating shell scripts for automated shutdown.

Creating Users, Setting Space, Authorization, Login Restrictions.

Making TMS software Y2K compliant.

Managing 10 computerized branches, Impart training to Branch Employees.

Giving Novell user access on Unix.

Company: (Apothecaries Limited) September 1995 – January 1998

Tittle: (Software Developer)

Projects:

Project 1: (Pharmulation System For Medicine Manufacturing Companies)

Tools : Foxpro For DOS

Role : Developer

Responsibilities : Coding, Analyzing, Designing, Developing

Duration : September 1995 – January 1998.

Description:

This package is for Pharmaceutical-manufacturing Unit, which consists of 5 sub packages as follows: -

oAccounts (Cash/Bank Transactions, Trial Balance, Profit and Loss A/c, Balance Sheet)

oInventory (Stock of raw material, Purchase of raw material)

oProduction ( Requisition details, Advice to quality control dept. Formula Entry )

oQuality Control (Passing Quality test of Drugs/Excipients/packing/finished material.

oUtilities (Indexing of files, Data backup, Password assignment to users)

Project 2: (Pharmacy Management System For Chemists)

Tools : Foxpro For DOS

Role : Developer

Responsibilities : Coding, Designing, Developing

Duration : September 1995 – January 1998.

Description:

This package was designed and developed specifically for Chemists shops and Hospitals for maintaining details of their patients.

Storing contamedication of patients with medicines, allergy with medicines.

Maintains database of medicines and their ingredients, contraindication between medicines.

Generates reports like Stock of medicines, Outstanding dues of patients/ Suppliers.

Invoice generation.

Maintains Accounts (Cash/Bank Transactions, Trial Balance, Profit and Loss A/c, Balance Sheet)

Contact this candidate