System Analyst
Macrosoft Inc.
Keywords
Skills
Visual Foxpro Ver-6, UNIX, Dbase, database, MS SQL Server, MySql, Net, Java, Visual, Python, Django Framework, Visual FoxPro Version 6 & 9, Foxpro For Unix & Dos, RDBMS, SQL Server, Windows, SCO UNIX 3.2, Database Migration, SQL, SQL database, MSSQL, PostgreSQL, MongoDB, foxpro, Visual FoxPro Version 9, Word, Coding, backend, Dot Net developers, Dot Net, XML, Excel, Visual Foxpro Version 6, Visual Foxpro, Visual Foxpro 9, Visual Foxpro 8, Visual Foxpro 6, Power Point, PowerPoint, backup, Data Entry, Novell NetWare Server, TCP/IP, SPX, IPX, Unix Server 3.2, shell scripts, DOS, quality control
Project history
12/2015
-
02/2020
Projects: Here currently i am 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 Sepcification 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 execl showing foxpro table details like
fields, relations, indexes, record count etc.
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 Sepcification 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 execl showing foxpro table details like
fields, relations, indexes, record count etc.
12/2015
-
03/2017
System Analyst
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.
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.
12/2015
-
10/2016
System Analyst
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.
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.
05/2015
-
07/2015
System Analyst
Macrosoft IT Solutions India Pvt. Ltd.
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.
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.
09/2012
-
12/2014
Developer
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
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
08/2010
-
12/2014
Senior Programmer
Symphony Infotech
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 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.
08/2010
-
12/2014
Developer
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.
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.
08/2010
-
12/2014
Developer
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.
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.
05/2007
-
07/2010
Team Leader
Overnite Express Limited
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 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.
05/2007
-
07/2010
Developer
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.
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.
09/2004
-
07/2006
Senior Consultant
C-Soft Consultants
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.
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.
09/2004
-
07/2006
Developer
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
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
09/2004
-
07/2006
Developer
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.
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.
02/1998
-
07/2004
System Administrator & Developer
South Eastern Carriers Limited
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 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
02/1998
-
04/2003
Developer
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.
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.
09/1995
-
01/1998
Software Developer
Apothecaries Limited
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: -
* Accounts (Cash/Bank Transactions, Trial Balance, Profit and Loss A/c, Balance Sheet)
* Inventory (Stock of raw material, Purchase of raw material)
* Production ( Requisition details, Advice to quality control dept. Formula Entry )
* Quality Control (Passing Quality test of Drugs/Excipients/packing/finished material.
* Utilities (Indexing of files, Data backup, Password assignment to users)
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: -
* Accounts (Cash/Bank Transactions, Trial Balance, Profit and Loss A/c, Balance Sheet)
* Inventory (Stock of raw material, Purchase of raw material)
* Production ( Requisition details, Advice to quality control dept. Formula Entry )
* Quality Control (Passing Quality test of Drugs/Excipients/packing/finished material.
* Utilities (Indexing of files, Data backup, Password assignment to users)
09/1995
-
01/1998
Developer
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)
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)
Local Availability
Only available in these countries:
India
