Project System

Over ** years of Development and Technical support skills in Analysis, Design, Development, Testing, Implementation, Conversion, Documentation, Problem Solving and Production Support skills in multiple Application areas on Microsoft Technologies and Delphi using System Development Life Cycle (SDLC) methodology.Experience in the areas of Microsoft 2003 Server, Microsoft 2000, Microsoft XP, UNIX, Visual-C++, Visual-Basic, SQL-SERVER, ORACLE, Microsoft-C and C#.Net.Excellent communication skills, both written and verbal, and good interpersonal skills. Have worked in industries in Inventory Management, Payroll, Utility Management (at UK) and State Government Projects.

Languages : VB, C#.Net, ASP.Net, Delphi, PL//SQL, MF-COBOL

OS : Windows-2000 & 2003 Server edition, Windows-XP UNIX

Databases : SQL-SERVER, ORACLE 8i/9i, MS-ACCESS

Software/Tools : LOTUS-NOTES, MS-OFFICE 2003.

Contact Numbers : +91-990******* (mobile) [Email address : ***********@*****.***]

Academic Qualification : B.Sc from Calcutta University in the year 1983

Advanced Post Graduate Diploma in Computer & Systems Management in the year 1992

Passport No. : E7750267 (valid upto 02/09/2014)

Stup Consultants, Calcutta (INDIA) May’12- till date

Working as a Team Lead for Web Application for a Clothing Shop Project

Project Description: Web based ERP (specific module) solution of a Small Clothing Shop

Responsibility: ● Period interaction required to complete the contract and continuous communication with client to meet the time schedule related issueProvid all sorts of assistance to the team members to meet the time frame mentioned in the contract.

● Formulation of strategies and procedures to achieve the implementation of methodology proposed.

Stup Consultants, Calcutta (INDIA) Aug’11- Apr’12

Working as a Team Lead for PTZ Camera Integration Project

Project Description: Integration required for a remort camera with the IDE prepared by the SDK provided by the vender

Responsibility: ● Provid all sorts of assistance required to the team members to meet the client’s request

● Formulation of strategies and procedures to achieve the implementation of methodology proposed.

Stup Consultants, Calcutta (INDIA) May’10- till date

Working as a Deputy Team Lead for various projects.

Project Description: Updating work components of different projects to match client requirements realized during actual operation and running of the project

Responsibility: ● Providing assistance to the team members to meet the client’s request

● Formulation of strategies and procedures for future working of the team.

Stup Consultants, Calcutta (INDIA) Mar’10- May’11

Sr. Programmer, Title : Online Ordering System (Magnum Surveyors (I) Pvt. Ltd.)

Project Description: An online ordering system for quick ordering via web or phone. The system seamlessly integrates services of several ASPs to provide a unique experience to the end user. The product has ability to process payment online, while producing billing information to the concerned partners with provision for notification to customer and partners.

Responsibility: ● Started working as a Sr. Team Member.

● Overviewed the module design and helping the team to prepare the code following the business logic .

● Writing and debugging of stored procedures.

● Programming in C# language according to functional Requirements and report generation.

Environment: C#.Net, ASP.Net, HTML& XML SQL Server.

Stup Consultants, Calcutta (INDIA) Jul’09- Feb’10

Sr. Programmer, Title : e-Billing (RMS Telecommunication)

Project Description: e-Billing is a web based billing system for RMS Telecommunication. The clients have the freedom to design their own customized plan at runtime, define their own brands and heads and also define their billing levels and formats. The system can handle multiple invoice formats and has features to enable client to define their own reports other than the canned reports provided normally by the system. The system has unique auditing tools to analyze each and every activity the user performs through the system.

Responsibility: ● Worked as a Module Leader.

● Overviewed the module design and helping the team to prepare the code following the business logic .

● Writing and debugging of stored procedures, triggers, views, and cursors.

● Report Generation in various formats such as WORD, RTF, EXCEL, TXT

● Module covered such as Security Module, Search Module, Query Builder etc.

Environment: C#.Net, ASP.Net & JavaScript, SQL Server (VB.Net, Visual Source Safe, MS-Project).

Stup Consultants, Calcutta (INDIA) Nov’08 – Jun’09

Sr. Programmer, Title : Development of Back office Software

Project Description : The Finance module handles the Voucher entry, Ledger Entry,Balance Sheet etc. HR Module handles the Recruitment process. Attendance Module handles the daily attendance of every employee of the company. The system was developed as a product to handle the inventory of raw materials. It records Stock, suppliers, billing, accounts, purchases etc and helps to plan the order, production, sales of the organization. It can also handle return of stock, transfer of stock etc. It also helps to plan the total job work, workflow and day to day work and generates

reports on these.

Responsibility: System Analyses and design.

Writing of PL/SQL, procedures/functions, Packages, Database Triggers, and Cursors.

Programming in c# language according to functional Requirements.

Report Generation, and Implementation.

Environment: C#.Net, ASP.Net, Oracle 8i.

Stup Consultants, Calcutta (INDIA) Feb’08 –Oct’08

Sr. Programmer, Title : Mail Management/Intranet Mailing System

Project Description : The project is about creating smooth operation of incoming of Logistics in the mailing systems. It helps manage the distribution of mails as well as the Logistics to the proper identity with the confirmation details and acknowledgement between the sender and the receiver and vice versa. It also helps the Intra-departmental-communication.

Responsibility: Overviewed the system and re-designed. Prepared the business logic based on the inputs generated. Designed and created the database, Coded, Tested and Implemented.

Environment: C#.Net, ASP.Net, SQL-Server 2000, Windows 2003 Server.

Stup Consultants, Calcutta (INDIA) Apr’06 – Jan’07

Sr. Programmer, Title : Online Ordering System (Swastik Infotech (P) Ltd.)

Description: An online ordering system for quick ordering via web or phone. The system integrates services of several ASPs seamlessly.

Responsibility: ● Worked as a Sr. Programmer.

● Overviewed the system and module design and helping the team to prepare the code.

● Helping the team to write the debug the code.

Environment: C#.Net, ASP.Net, HTML& XML SQL Server.

Stup Consultants, Calcutta (INDIA) May’05 – Mar’06

Sr. Programmer, Title : Web Application Developer (Kaashyap Radiant Systems Limited, New Delhi)

Project Description : A comprehensive application for maintenance of Medical Transcription records. It takes care of everything right from distribution of files till collection of files. It keeps a track of the job done as well as the unfinished jobs.

As part of a team involved in development of functional web sites, the job responsibilities entails understanding their web site requirements, proposing efficient custom solutions and finally development of various software modules.

Responsibility : Overviewed, analyzed and designed the system., Report Generation, Coded, Tested and Implemented .

Environment : C#.Net, ASP.Net,, HTML, XML, SQL Server 2000

Npower Newcastle, UK Nov’04 – Mar’05

nPower is a giant utility company having business of Gas and Electricity distribution in UK and Ireland.

Sr. Programmer, Title : Software for Integrated Billing

Project Description : The existing automated system was upgraded as Core Consolidation Program going through the different releases fulfilling basic requirements. Integrated Billing (IB) division, being one of the vital divisions of this Core Consolidation Program, is responsible for smooth functioning of few hundreds of batch programs.

Responsibility: Worked as a team member of IB Department development team, Analyzed the Technical Specification (TS) & Functional Specification (FS), Wrote new codes and modified legacy codes from the respective Program Specification (PS). Compiled, debugged (using animator) and executed the programs successfully by creating test data, test script and also extensive usage of PL/SQL. The test data was prepared after copying production data (through an utility software) to a test bed and writing SQL queries.

Environment: MF COBOL, Ingress, Unix, Windows NT.

Stup Consultants, Calcutta (INDIA) Nov’03 –Sep’04

Sr. Programmer, Title : Software for Online Ordering System

Project Description : An online ordering system for quick ordering via web or phone. The system seamlessly integrates services of several ASPs to provide a unique experience to the end user. The product has ability to process payment online, while producing billing information to the concerned partners with provision for notification to customer and partners. The system also has a FAX notification for quick order.

Responsibility: Worked as a Deputy Team Leader. Analyzed the system and then designed it according to the client’s need. Developed Web Services.

Environment: C#.Net, SQL Server 2000, Windows 2003

Stup Consultants, Calcutta (INDIA) Jan’03 –Oct’03

Sr. Programmer, Title : Software for Professional Services Automation (PSA)

Project Description : The software will address the business needs of any and every kind of professional service firms, which are also known as staffing firms, supplemental staffing firms, placements agencies, executive search firms, body shops, staff augmentation firms, job placement firms, temp agencies, consulting firms, etc. We shall refer to this kind of a firm as a Professional Services Firm. The system will be handling service sector industries, where interactions and billing points are based on Human resources.

Responsibility: Worked as a Deputy Team Leader. Designed, prepared and debugged stored procedures, Trigger, Views and Cursors. Prepared user services using C# and Web Services.

Environment: C#.Net, SQL Server 2000, Windows 2003

Stup Consultants, Calcutta (INDIA) Sep’02 –Dec’03

Sr. Programmer, Title : Software for Structural Analysis and Design

Project Description : The program has been developed for the purpose of structural analysis and design of superstructure, girders of road bridges.

Responsibility: Assisted the design team (a group of Civil Engineers) in making the interface of the design-diagrams. Designed and prepared the database and developed programming code as necessitated by the process logic.

Environment: C#.Net, MS-Access, Windows 2000.

Dept. of PHE, Govt. of West Bengal (INDIA) Oct’01 – Aug’02

Sr. Programmer, Title : Software for Payroll System

Project Description : This is a customized application software that has been made for accounts department to generate monthly payroll, leave etc. The Department has more then 500 employees.

Responsibility: Overviewed the design and architecture of the system, actively involved in system analysis and design, prepared the database design and developed programming code as based on the process logic. Writing of PL/SQL, procedures/functions, Packages, Database Triggers, and Cursors.

Environment: C#.Net, Oracle 8i, Windows 2000.

Stup Consultants, Calcutta (INDIA) Nov’00 – Sep’01

Programmer, Title : Software for Computerization of Library Management System

Project Description : This is a customized application software that has been made for Library facilities to track the usual issues and returns of books/journals and also for cataloguing repetitive use and frequency of borrowing books /journals etc. in order to stock supplementary copies of the same.

Responsibility: As a team member overviewed the design and architecture of the system, actively involved in system analysis and design, prepared the database design, created pages and developed programming code based on the process logic.

Environment: Visual Basic 6.0, MS-Access, Windows 2000.

LMIIT Computer Centre, Calcutta (INDIA) Dec’99 – Sep’00

Programmer, Title : Software for Computerization of Students admission, Fees and Booking of machines in a laboratory.

Project Description : This is a customized application software that has been made for automating students’ admission, fees and booking machines in laboratory.

Responsibility: Analyzed the system interacting with the users/clients. Prepared interconnectivity logic based on their inputs, outputs to be generated and the derivative process. Designed the database, created the necessary tables and coded based on business logic.

Environment: Visual Basic 5.0/6.0, MS-Access, Windows 98.

State Co-operative Bank, Howrah, West bengal (INDIA) Jan’98 – Oct’99

Programmer, Title : Software for an integrated banking system covering all aspects of banking including MIS (Financial Accounting) for 14 branches of Co-operative Bank in the state of West Bengal.

Project Description : This software is designed to provide full computerization of all banking operations and services in each of the branches and at the Headquarters. As a team-member, involved in the development of three sub-systems viz. Payroll system and Membership Loan Accounting System and MIS.

Responsibility: Analyzed and overviewed the system interacting with the users/clients. Prepared the business logic according to the inputs received from clients, outputs to be generated and the derivative process. Designed the database, created the tables and coded based on business logic.

Environment: Visual Basic 4.0/5.0, Oracle, PL/SQL, Windows NT.

Full Resettlement Plan for Canal Informal Dwellers, Calcutta, INDIA Jan’96 – Dec’97

Programmer, Title : Software for making Photo-ID Card for the Dwellers for their resettlement proof and benefits.

Project Description : This software is designed to prepare the Photo-ID Cards of Canal Informal Dwellers, they have been resettled in a different place from the existing one by the authority to clear the bank of the canals for the betterment of the canals by producing their Photo-ID Card as proof :

Responsibility: Overviewed the system and prepare the business logic as per the outputs received from the client. Designed and prepared the tables of the database and coded based on business logic.

Environment: Visual Basic 4.0/5.0, Access, Windows 98.

HMV INDIA Aug’95 – Dec’95

Programmer, Title : Software for Order Booking and Sales Accounting System for a Private Audio Channel.

Project Description : This software was developed for time slot reservations for various advertising agencies like ITC, Colgate-Palmolive, Ciello car etc. and auto-generation of monthly bills based on orders booked. The custom-software was so prepared as to be capable of universal use for work of this kind.

Responsibility: As team member done thorough scrutiny of the system. Established the Business logic according to the system requirement; Created tables as per Database Design and wrote code as per the business logic

Environment: Delphi, Interbase, Object Pascal, PL/SQL, Windows NT.

State Co-operative Bank, Howrah, West bengal (INDIA) Nov’94 – Jul’95

Programmer, Title : Software for Pay Roll & Loan Accounting System of West Bengal State Co-operative Bank, Calcutta and fourteen other branches of West Bengal.

Project Description : This software is designed to provide Pay Roll & Loan Accounting System operations and services in each of the branches and at the Headquarters. As a team-member, involved the development of two sub-systems viz. Payroll system and Membership Loan Accounting System and MIS with following software:

Responsibility: As team member done in depth study of the system. Prepared Business logic according to the system requirements. Planned database design. Created tables and coded based on business logic

Environment: Delphi, Interbase, Object Pascal, SQL, PL/SQL, Windows NT.

Calcutta Electric Supply Corporation, Calcutta, India Oct’93 – Oct’94

Programmer, Title : Software for Automation In Project Management (APM); Module Order Processing System(OPS)

Project Description : Order Processing System, being a part of the APM, is a prelude to the materials’ management procedures. With the use of this program, I kept track of the stock on hand and the corresponding re-order level of the various materials needed at site.

Responsibility: Prepared the tables as per database design. Developed Program code. Tested and debugged the developed program, Tested the Module separately. Prepared the user manual and other documents

Environment: OPS is a client / server system with ORACLE running on Windows 3.x as the server and Basic presenting the user interface.

Calcutta Electric Supply Corporation, Calcutta, India Jan’93 – Sep’93

Programmer, Title : Software for Automation In Project Management (APM); Billing Status Reporting System(BSRS)

Project Description : BSRS forms the backbone of APM. Used this module to maintain a detailed report of all the payments made to all the contractors against their monthly bills and their various contract numbers.

Responsibility: Created the tables as per database design, Developed Program code. Tested and debugged the program, Prepared the user manual and other requirement documents.

Environment: BSRS is a client / server system with ORACLE running on Windows 3.x as the server and C++ presenting the user interface.

Calcutta Electric Supply Corporation, Calcutta, India Apr’92 –Dec’92

Programmer, Title : Software for Automation In Project Management (APM); Library Management System(LMS)

Project Description : LMS is used to create detailed databank of all the books and the members in the Libraries’ possession.

Responsibility: Reviewed functional specifications, Prepared tables as per database design, Developed, module tested and debugged program. Prepared user manual and other documents

Environment: Client/Server application with Oracle running on Windows 3.x as the server and C++ for user interface.

Calcutta Electric Supply Corporation, Calcutta, India May’91 – Mar’92

Programmer, Title: Software for Automation In Project Management (APM); Material Management and Reporting

Project Description : Through the use of APM developed, various requirements like Order Processing System (OPS), Billing Status Reporting System (BSRS), Library Management System (LMS), Materials’ Management and Reporting System (MMRS) are catered.

This program is used for keeping track of all the constructional materials along with their inventory.

Responsibility: Reviewed functional specifications, Created tables as per database design, Developed program codes, tested and debugged them.

Environment: Client / server system with SQL Server running on Windows NT and C++ for user interface.

Matthews & Co, Calcutta, India May’84 – Jun’90

Project Description: Supervisor

Responsibility: Supervision of In-house computer operation, budgetary and inventory control,

Environment: Client / server system with SQL Server running on Windows NT and C++ for user interface.

Training Undergone: Completed the training (conducted by PWC professionals) in SAP, ABAP in 2005.

It consists of the followings.

Interactive and Classical Report Generation.Data Retrieval from legacy System. (BDC & LSMW)Interface Designing using ALE & IDOC and BAPI.

Place : Kolkata, Date : 11/30/2012

Contact this candidate