My Projects
Below is the list of few of my Projects. Nearly all the projects / applications
represent various domains that I have worked upon.
|
Company
|
TEKNOBYTE SOFTWARE EXPORTS LTD.
|
|
Clients
|
100 + clients across INDIA
|
|
Platform
|
VB / SQL Server 2000 / Crystal Reports / Component-One Studio
|
|
Description
|
|
The Offline application for the Non Banking Finance Companies. The application is
used to manage everything related to finance and related accounting. The application
is generating approx 100 + reports for modules like Hire Purchase, Hypothecation,
Loans, Trade Accounts & Deposits. It is also used to maintain financial accounting
and generates all the accounting reports like Day Book, Cash Book, Bank Book, Profit
& Loss, Trail Balance and Balance Sheet etc. The application is like a small ERP
focusing on finance and accounting.
|
|
Features
|
- Manage Accounts - General Accounts, Control Accounts, HP, Hypothecation, Loans &
Deposits
- EMI Calculation, IRR Calculation, Overdue Calculation
- Voucher Entry for all the transactions
- Managing PDCs, Installment Overdue, SMS for EMI
- Accounting Reports like Day Book, Bank Book, Cash Book, P & L, Trail & Balance sheet
etc.
- Finance Reports like - Debtor Summary, Defaulter Summary, Party Statement, Agewise
Analysis calculation & summary
- Finance Reports like - FD & RD Statement, Premature Calucation Report, Pre-closer
of account etc.
- Receipt Printing, Voucher Printing, Letters Generation etc.
- 100 + Reports overall for Accounting & Finance
- User friendly interface, Multi User & Multi Company Data Management
- Reporting in Crystal Reports, Export to Excel, XML Reports
- DOS Printing for continous printing
|
|
Company
|
WIPRO Infotech
|
|
Clients
|
GENPACT India (ICICI / Standard Chartered / Mashreq Bank / XEROX)
|
|
Platform
|
ASP.NET 2.0 / Oracle
|
|
Description
|
|
This CRM specifically made for ICICI. Tool enables organization to call different
customers for collection of Loan EMIs. The tool is integrated with Aspect Dialer.
Dialer OCX used to fetch the calls from dialer. Dialer route the calls to different
agents. Application fetches the details of customer called and displays the details
to agent. Agent then talks to customer depending on the information displayed. CRM
allows different reporting also and also generates callable list for uploading in
dialer
|
|
Features
|
- Tool integrated with Dialer
- Whenever any call comes to agent extension, the application fetches the details
of the calling customer
- Agent can input the call feedback and based on the feedback different analysis done
- Callable list generation
- Reports export to excel
- Customer Data Daily upload using SQL Loader
|
|
Company
|
WIPRO Infotech
|
|
Clients
|
GENPACT India
|
|
Platform
|
SQL Server, VB, Mainframe
|
|
Description
|
|
The tool made to automate transaction remarks updations in mainframe system while
agent is calling customer. The application provides the platform to scrap and paste
information from and to the mainframe screens. The agent enters the account no while
calling, the application capture the account no and scrap the information from mainframe
application. The application can also update the transaction remarks to the mainframe
application.
|
|
Company
|
WIPRO Infotech
|
|
Clients
|
GENPACT India
|
|
Platform
|
Classic ASP / SQL Server
|
|
Description
|
|
e-Payroll web application provided web interface to all employees to view their
Payslip, Tax Statement ,Reimbursement & PF Statement. Application also enabled employees
to declare their Tax Savings which further was integrated into Oracle payroll software
for tax & salary calculations. The application was common interface for all employees
of multiple companies of GENPACT.
|
|
Features
|
- Displaying different report like e-Pay Slip, e-Hypotax, e-Onsite allowance, e-Reimbursement
and e-PF.
- Employees Investment declaration from web application
- Multi user, Multi company compatibility
- Other declarations like Car declaration, conveyance declaration etc. as per company
and band specific
- Integration between different payroll software and providing web interface to the
reports
- Integration between SQL server and Oracle payroll
|
|
Company
|
WIPRO Infotech
|
|
Clients
|
GENPACT India
|
|
Platform
|
Oracle Web Portal and Oracle 10g as backend
|
|
Description
|
|
Tool made specifically for supervisors / HR Managers to see all the information
of their DRs. The person logged-in is able to see the tree hierarchy under him /
her with other details. The tool is helpful for supervisors to analyze the attrition
rate and status of the employees. Supervisor can view the compensation, Performance
ratings and other general details for all DR under him / her. The tool can be viewed
in three different languages (English, Spanish and Chinese).
|
|
Features
|
- Project act as single platform for supervisor to extract data from different systems
and display on tool
- Supervisors can view all the information of their DRs
- Information is extracted from different source systems using ETL
- Separate data warehouse to manage complete data transformations and loading
- Alerts and mail notifications on achievements, ratings, performance status and other
events like birthdays etc
|
|
Company
|
WIPRO Infotech
|
|
Clients
|
GENPACT India (Hyatt Hotels Group)
|
|
Platform
|
SQL Server, ASP, AJAX
|
|
Description
|
|
The tool is made for Hyatt group of hotels, one of esteemed client of Genpact. The
tool is made for 110 Business Units across USA, CANADA AND The Caribbean. Each month,
each BU is aligned some financial activities for which status needs to be updated.
Manual tracking of status for each activity to each BU is very difficult. The tool
is automating the requirement to monitor the status of each activity and also escalating
emails sent to their owners.
|
|
Features
|
- Aligning different activities to different Business Units
- Activities Monitoring aligned to different Business Units
- Multi user compatibility
- Multiple User type and Menus loading as per the roles and rights aligned to each
user
- AJAX used for dynamic loading of data
- Auto Mail Alert for Missed Target Date-Time for each BU and each Activity
|
|
Company
|
ITQ - InterGlobe Technology Quotient
|
|
Clients
|
Thomas Cook, Xplorz.com
|
|
Platform
|
ASP / ASP.NET / SQL Server
|
|
Description
|
|
The application is an online booking of air tickets. Galileo GDS used to search
query for availability in different airlines, booking and PNR Generation. Application
hits to GDS in form of XML query and received result in XML and parsed to display
results. Payment gateway was used for payment
|
|
Features
|
- Online Air ticket searching through GDS
- Online Air ticket, Hotels booking through payment gateway
- Supplier, Sub-agent management. Ticketing and vouchers generation
- All related MIS reports
- Auto mailing alerts
|
|
Company
|
MSS Technolozy
|
|
Platform
|
ASP / ASP.NET / SQL Server
|
|
Clients
|
- OTNM Network Marketing Pvt. Ltd.
- Glaze Trading India Pvt. Ltd.
- Fortune India
- Leisures Health Care Pvt. Ltd.
- Levision India Pvt. Ltd.
- Tirupati Network Marketing Pvt. Ltd.
- Mile Stones Marketing
- Palm E-Shoppe Pvt. Ltd.
- Prityaksha Network Marketing Pvt. Ltd.
|
|
Description
|
|
MLM software applications are made for incentive calculations of MLM companies (Multi
Level Marketing). MLM companies sell product using chain marketing. Entire system
depends on incentive distributions. Whenever any person purchases the product, he
/ she become the associate of company and can sell the products of company. On any
sale, the incentive is distributed to their parent associates. Incentive calculation
and distribution in these systems is a very time taking and critical part. Member
Panel, Admin Panel and Incentive Calculation Panel were mainly 3 phases of the application
|
|
Features
|
- Incentive Calculations as per distribution plan
- New Registrations (Online / Offline)
- TDS and Service Charges deduction on Incentives
- Incentive and Registration related all reports
- Cheque printing
- Reporting - Genealogy, Payment History, Registration List, Datewise Cheque Report,
TDS Report
- SMS & Email alerts
|
|
Company
|
MSS Technolozy
|
|
Platform
|
VB / SQL Server 2000 / Crystal Reports
|
|
Clients
|
Coil Company
|
|
Description
|
|
The application was build to maintain inventory for the company. The company is
the largest manufacturer of cooling coils. The application is made at client side
to fulfill all requirements of the organization. Inventory management in form of
raw materials and current stock in store and shop floor is maintained. All the features
of Inventory Management like Stock Receiving, Stock Issue, Gate Pass Management,
Item Master, Suppliers Master etc.
|
|
Features
|
- Item Management, Clients Management
- Stock requirement analysis, Gatepass, inventory updating, Raw Material costing.
- Stock transfers to various branches and outlets
- Order processing, invoicing, delivery, goods return, credit notes, outstanding,
receivables etc
- Multi User, Multi Company system, Users and user rights administration
- Reorder alerts
|
|
Company
|
MSS Technolozy
|
|
Platform
|
VB / SQL Server 2000 / Crystal Reports
|
|
Clients
|
- Glaze Trading India Pvt. Ltd.
- Mile Stones Marketing
- Prityaksha Network Marketing Pvt. Ltd.
|
|
Description
|
|
The application was build specifically for MLM (Multi Level Marketing) companies.
The product developed reminding the requirement streamlining various departments
including Sales Booking, Product Delivery, Stock Maintenance and Inventory management.
The product was made with some standard features of Inventory management and customized
solutions for integrating sales marketing with inventory management. The product
was capable of maintaining multiple branches and multiple users. Main features includes
Sale Booking, Stock maintenance, Invoicing and Challans etc. The product was customized
to integrate with MLM incentive software to track sales booking and product booking
|
|
Features
|
- Products Package creation as per MLM Products distribution
- Integration with Product Delivery, Stock Maintenance, Product Booking, Sale Booking,
Re-order alerts, Per Sale Package Distribution
- All Reports related to Stock Maintenance, Receiving, Billing, Challans, Inflow,
Inflow Details
- Integration of MLM Software with MLM Inventory
- Multi User, Multi Company system, Users and user rights administration
|
|
Company
|
MSS Technolozy
|
|
Platform
|
ASP / SQL Server 2000
|
|
Features
|
- To maintain the books of accounts online to access from anywhere in world
- General Accounts, Control Accounts Management
- All books maintenance including day book, Ledgers, Bank book, Cash Book etc.
- Voucher Entry, Trial balance, Balance sheet etc
- Multi Company maintenance
- Multi User system, Access Rights administration
|
|
Company
|
MSS Technolozy
|
|
Platform
|
VB / Access
|
|
Features
|
- Maintaining the Car Sale-Purchasing, Net Profit/Loss, Car Maintenance Track
- Query Management, Query Follow-ups, Commission calculation, Inflow-outflow details
management
- To maintain Dealers and customers details.
- Monthly Alert for commission and installment cheques
- Monthly statement for Inflow / outflow
- All other customized MIS reports
|
|
Company
|
MSS Technolozy
|
|
Platform
|
ASP / SQL Server
|
|
Features
|
- Software for marketing and after-sales service companies.
- Integrated application to manage the day-to-day activities of companies doing business
in the field of marketing and after-sales service
- Maintenance, analysis and follow-ups of Marketing, Query and Complaints from the
clients of the company
- Various analysis reports can be generated based on client, product, executive, category
and daily schedule etc
- Other major features include bulk label and letter printing and email sending, Quotation
and Invoice generation, Important Dates Reminder, AMC and Warranty Register maintenance
etc
- There is a scheduler for reminding the daily appointments, AMC / warranty expiry
and important dates
|
- Online Newspaper
- Insurance advisor application - For managing customers, Due Premium, Policy Management
etc.
- Tender Managment system
- Online Books Selling Portal
- Bulk Email / SMS Software
- Election Analysis Software for C-Voters
- KuljeetSingh.com
|
|