1438
Maruti Vihar,
Chakarpur,
Gurgaon
Phone :
+91-124-6811059
Mobile:
9810501936
Web :
http://www.angelfire.com/bc/bkpandey
Click here to download
MS-Word format of this resume (Zipped)
Click here to download ASCII Text format of
this resume
|
Profession |
:: |
Software Development |
|
|
|
|
|
Professional Experience |
:: |
More Than 9 years in Software Industry |
|
|
|
|
|
OS Installation & Maintenance |
:: |
SCO Unix, Windows NT, Novell Netware |
|
|
|
|
|
Development Tools / Programming Language Used |
:: |
Power Builder, Sybase DWB & APT, Sybase T-SQL,
Oracle Developer 2000, Oracle PL/SQL, Clipper, dBase, FoxPro, HTML |
|
|
|
|
|
RDBMS Maintained & Used for Development |
:: |
Sybase 12.5, Unify, Sybase SQL Anywhere 5, Watcom 4, Oracle 8 |
|
|
|
|
|
Packages Used & Implemented |
:: |
MakESS ERP, Lotus 123 (DOS/Win), MS-Office,
MS-Project, Cobol, ProComm-Plus, Basic, WordStar, Tally A/c System, FACT
International A/c Package, PC-Tools, Norton Utilities, Mercury e-mail Server,
Samber Web Server, Netscape / Explorer Browsers, Outlook / Eudora e-mail
client. |
|
|
|
|
Software Development & Networking Experience :
·
Power Builder
6.5
Developed
Applications using Watcom, SybaseSQL Anywhere & Sybase 11.9.2 / 12.5 as
back-end Databases).
·
Sybase
DWB/APT
Developed Complete Applications using DWB/APT and Unix Shell with Sybase 10 as back-end Databases)
·
FoxPro 2.6
(DOS)
Developed many complete Applications as well as MIS reports using FoxPro. Used as a supporting tool for Power Builder Applications for DOS Printing of Reports developed on PowerBuilder.
·
Clipper 5.01a
(DOS)
Developed Application using FoxPro Database.
·
Oracle &
D2K
Developed Forms and Reports in Developer 2000 as a part of MakESS ERP implementation in Uniworth. Also maintained Database Administrator part for Oracle 8 Database on NT. Attended a 15 days training on Oracle DBA, D2K and NT Administration from APTECH.
·
Novell
NetWare 3.12 / IntranetWare 4.11
Installed NetWare 3.12 using BNC Connectors (RING Topology) in Birla Tyres for 20 nodes and IntranetWare 4.11 using UTP/HUB Connection (STAR Topology) in Marshall Corp. for 10 nodes.
·
SCO Unix
release 5
Installed SCO Unix release 5 using Fast Start Intranet Option with UPT/HUB Connections for 12 nodes and Serial Port Connections for 12 nodes.
·
Windows NT
4.0
Installed Windows NT for ERP Implementation with Oracle 8 database using Star Topology with TCP/IP protocol.
· Windows for Workgroup 3.11 / Win95/ 98
Installed WFW network with the existing network topology, so that the resources and information available on PCs can be shared.
Major Projects
|
·
Project |
:: |
Inter Branch Reconciliation (IBR) |
|
Role |
:: |
Team Leader
My job Responsibilities involved studying the Functional Specification Doc, system study, preparation of High Level Design, then object wise Low Level Design, assign the work to different team members, coding, code review and unit testing for all team members. |
|
Development Tool |
:: |
PowerBuilder 6.5 |
|
Database |
:: |
Sybase release 12.5 |
|
Operating System |
:: |
Client / Server (Windows as Client and UNIX Server) |
|
Company |
:: |
Polaris Software Labs Limited |
|
Descriptions |
:: |
As a part of BankNow Product, this functionality is related with the reconciliation of InterBranch entries between manual and computerized branches. It covers the concept of Advices for all Inter Branch entries. The development also includes the concept of external bank (Appex Bank) for DD issuance. |
|
|
|
|
|
·
Project |
:: |
Inter Branch Transactions (IBT) |
|
Role |
:: |
Team LeaderMy job Responsibilities involved studying the Functional Specification Doc, system study, preparation of High Level Design, then object wise Low Level Design, assign the work to different team members, coding, code review and unit testing for all team members. |
|
Development Tool |
:: |
PowerBuilder 6.5 |
|
Database |
:: |
Sybase release 12.5 |
|
Operating System |
:: |
Client / Server (Windows as Client and UNIX Server) |
|
Company |
:: |
Polaris Software Labs Limited |
|
Descriptions |
:: |
This functionality of BankNow product is related with all transaction between two or more branches. All such entries are balanced using proper balancing entries by posting the missing leg of entry into the Branch’s parent account. It also introduced the concept of Sub-Branch in the product. |
|
|
|
|
|
·
Project |
:: |
Signature Storage System – SignNow |
|
Role |
:: |
Team LeaderMy job Responsibilities involved studying the Functional Specification Doc, system study, preparation of High Level Design, then object wise Low Level Design, assign the work to different team members, coding, code review and unit testing for all team members. |
|
Development Tool |
:: |
PowerBuilder 6.5 |
|
Database |
:: |
Sybase release 12.5 |
|
Operating System |
:: |
Client / Server (Windows as Client and UNIX Server) |
|
Company |
:: |
Polaris Software Labs Limited |
|
Descriptions |
:: |
SignNow is a part of Polaris Flagship product for retail banking, BankNow. It stores scanned signatures of customer. Allow multiple signatures with Signatory Name for Business Customers. It also provides complete Maker-Checker facility with authorization as well as expiry of the signatures. It also includes storage of Operating Instructions from business customers. |
|
|
|
|
|
·
Project |
:: |
Production & Invoicing System |
|
Role |
:: |
Project Leader & Application DeveloperMy job Responsibilities involved creation of logical and Physical database and granting permission, development of Screens and Reports, creating back-end triggers/procedures, dbcc checks for every alternate day. Analyzing stored procedures, triggers and business rules extensively. Also performed tuning of stored procedure, which included troubleshooting and support. |
|
Development Tool |
:: |
PowerBuilder / Sybase APT & DWB |
|
Database |
:: |
Sybase release 11 |
|
Operating System |
:: |
Client / Server (Windows / Dos as Client and SCO UNIX Server) |
|
Company |
:: |
Fabworth (I) Ltd. (The Uniworth Group) |
|
Descriptions |
:: |
Covers Raw-material (semi finished Grey fabric) receipt, Dyeing-Finishing-Processing, Folding & Dispatch. Keep track of all the fabric with piece wise details. The System is functioning On-line as the movement of every piece is recorded from Grey dept to warehouse upto dispatch. |
|
|
|
|
|
·
Project |
:: |
Financial Accounting System |
|
Role |
:: |
Project Leader & Application Developer System Study, Design and Development of the Screens, Reports, creation of Database, back-end triggers/procedures, fine tuning of database, creation of users, rights allocation. |
|
Development Tool |
:: |
PowerBuilder (DOS Printing utility in FoxPro) |
|
Database |
:: |
Sybase SQL Anywhere 5 (Server for WFW Network) |
|
Operating System |
:: |
Windows for Workgroup Network |
|
Company |
:: |
Uniworth International Limited |
|
Descriptions |
:: |
Covers all aspect of financial accounting from voucher entry to balance sheet. Linked with Stock & Sales Accounting system for data transfer through floppy on daily basis from Warehouse. To exploit the utility of FoxPro, I have generated all reports on PB as well as FoxPro. During the execution, on the choice of user, PB is saving the data in DBF format and calling FoxPro with the respective prg to print the same report in DOS mode, which is faster. This option can also generate TXT files of reports to be send to Head Office through e-mail. |
|
|
|
|
|
·
Project |
:: |
Stock & Sales Accounting System |
|
Role |
:: |
Project Leader & Application Developer System Study, Design and Development of the Screens, Reports, creation of Database, back-end triggers/procedures, fine tuning of database. |
|
Development Tool |
:: |
PowerBuilder (DOS Printing utility in FoxPro) |
|
Database |
:: |
Sybase SQL Anywhere 5 (WFW Server) |
|
Operating System |
:: |
Windows for Workgroup Network |
|
Company |
:: |
Uniworth International Limited |
|
Descriptions |
:: |
Covers On-line Stock movement, Order Processing and Sales Recording of the company. All the required reports for MIS were generated from the system. Accept purchase data through floppy coming from Production System on UNIX Server. Also send Sales data to Financial A/c System. |
|
|
|
|
|
·
Project |
:: |
Project Cost Monitoring System |
|
Role |
:: |
Application Developer System Study, design, development, database creation, user creation and role assignment, development of screens and reports, regular maintenance of the system. |
|
Development Tool |
:: |
PowerBuilder |
|
Database |
:: |
Sybase NLM |
|
Operating System |
:: |
Client / Server (Windows & Novell NetWare) |
|
Company |
:: |
Marshall Corporation Limited |
|
Descriptions |
:: |
Project wise Cost monitoring is done through this system. Site wise division of cost is also calculated and budgets Vs actual are also obtained. |
|
|
|
|
|
·
Project |
:: |
Sea-Food Export System |
|
Role |
:: |
Project Leader & Application Developer Complete System Study and Development of the system, creation of users |
|
Development Tool |
:: |
PowerBuilder |
|
Database |
:: |
Watcom 4 |
|
Operating System |
:: |
Windows |
|
Company |
:: |
Chowhan Export Limited |
|
Descriptions |
:: |
Covers the Off-line Accounting of Seafood Export from the Site at Head Office. All the data collected from site comes to HO and entry done for all the required reports as well as information for other departments such as accounts etc. |
|
|
|
|
|
·
Project |
:: |
Payroll System |
|
Role |
:: |
Application Developer Complete System Study, Design and Development of the System. |
|
Development Tool |
:: |
FoxPro 2.6 (DOS) |
|
Database |
:: |
FoxPro 2.6 |
|
Operating System |
:: |
DOS 6.22 |
|
Company |
:: |
Birla Tyres |
|
Descriptions |
:: |
Complete Payroll Package for the head office as well as regional offices. Generate Pay-Slips as well as reports related to PF, ESI etc. |
|
|
|
|
|
·
Project |
:: |
Financial Accounting System |
|
Role |
:: |
Project Leader & Application Developer Development of Data Entry Screens, Reports and Implementation. |
|
Development Tool |
:: |
FoxPro 2.6 (DOS) |
|
Database |
:: |
FoxPro 2.6 |
|
Operating System |
:: |
DOS |
|
Company |
:: |
Birla Tyres |
|
Descriptions |
:: |
Complete Financial Accounting System from voucher entry to Balance Sheet. Accept Agent's Sales & Expenses data through floppy generated by Stock & Sales Accounting System. |
|
|
|
|
|
·
Project |
:: |
Stock & Sales Accounting System |
|
Role |
:: |
Project Leader & Application Developer Design and Development of the System. |
|
Development Tool |
:: |
Clipper 5.01 (DOS) |
|
Database |
:: |
FoxPro |
|
Operating System |
:: |
DOS |
|
Company |
:: |
Birla Tyres |
|
Descriptions |
:: |
Complete On-line Stock & Accounting System for the Agents of Birla Tyres. Covers stock receipt, order receipt, sales and payments with respect to stock & Debtors A/c and Expenses, Sales Targets and Commission for Agents. Data is transferred through floppy to generate MIS reports at Head Office as well as for Accounting entries in Financial Package. |
Professional Experiences
1) Company : Polaris Software Labs Limited, Noida, Delhi. Polaris Software Lab Ltd. is headquartered in Chennai, India and has over 2200 associates across fifteen locations worldwide. Lead by Arun Jain, Polaris has grown over hundred percent every year since inception. This year FORBES ranked Polaris among the Best Small Companies in the World. Polaris has the unique distinction of being the first organization in the world to be certified at SEI CMMi Level 5. The quality processes in Polaris are compliant to ISO 9001:2000 and SEI CMMi Level 5 standards.
As
a definite strategy to consolidate the focus on the banking sector, Polaris
created BankWare MODERNIZING MONEY WITH POLARIS, a unit manned by over
125 professionals, with both domain and technical expertise. Based out of the
BankWare Development Center in Gurgaon, near New Delhi, the unit is focused
towards rolling out state-of-the-art Banking Software Products.
a) Period : Since April 2001
b) Designation : Systems Engineer
c) Job Profile : Team Leader.
Part of the BankNow Product Development Team, a Product for Retail Banking solution being developed in PowerBuilder and Sybase. Job profile includes analyzing Functional Specifications, Preparing High Level & Low Level Designs, Unit Test Plan, Team management, Development, Code Review, Unit Testing for different functionalities being developed to enhance the product. Also, provide offshore support to Onsite team. Looked after Teller, Teller Admin, RunReports, Daily Operations, Archive Reports and Define Reports modules. Also, part of End Of Day support team to provide critical support for End of Day processing of production server on client site. Currently handling onsite team at Yemen for implementation of the BankNow product at Yemen Kuwait Bank.
2) Company : Uniworth International Limited, a multi national company of THE UNIWORTH GROUP engaged in Woolen Yarn and Worsted Fabrics manufacturing and exports. The company is well reputed in export market of its Yarn and in domestic markets with the brand The Uniworth Collection. The Woolworth (India) Ltd. has got an ISO 9002 Award for production. In 1995, the company begged President of India Award for Export in its short-term period of three years of commercial production. The turnover of the group is 350 crores.
a) Period : December 1996 to March 2001
b) Designation : Systems Executive
c)
Job Profile :
Systems Study, Designing, development and Implementation as well as maintenance
of existing Software packages. The
Windows for Workgroup Network is Installed and Implemented by me at the
warehouse of the Company. All the Developments were done on various
platforms, as it is a distributed network system. I developed packages on PowerBuilder
with Sybase SQL Anywhere & Sybase release 11 as back-end
databases, Sybase APT/DWB using Sybase release 11 database and FoxPro for
Printing PowerBuilder Reports in DOS. WFW and SCO UNIX Network were maintained by me. I am also maintaining the
old Stock & Accounting System, which is on Unify RDBMS residing on a UNIX Server. I am looking after
day-to-day work progress of the department. Working under a big computer set up
of 93 PCs out of which 33 are under SCO
UNIX and rest are using Novell
NetWare as well as Windows for
Workgroup / Windows 95/98 Network. Also Installed Intranet in the company
to share e-mails between users as well as Publish online info-base for the
management. Currently, installed Windows NT and added additional Network of 30
PCs for MakESS ERP Implementation. Now NT is configured with Oracle 8 Database
and D2K for ERP Implementation.
3) Company : Marshall Corporation Limited a company of the Chowhan group. The company engaged in Power Plant Construction business. The company successfully executed projects for CESC. Currently constructing a Power station at Budge Budge for CESC. And the company is negotiating for a project from CESC for BALAGARH worth of Rs 300 crores.
a) Period : From September 1995 to November 1996
b) Designation : Computer Programmer (Systems Dept. Head at Corporate Office)
c) Job Profile : Systems Studying, Designing and development of Software packages, writing Programs and implementation. The entire EDP set-up was started by me at the Head office and at factory for our sister concern (CHOWHAN EXPORTS LTD.). From conceptualisation to implementation of the entire computerisation process has been done by me. The major packages like Project cost monitoring system, Payroll, Seafood Export system were developed using Power Builder with Sybase NLM RDBMS. I also implemented FACT LAN for the Financial Accounting of the group. Today working under a big computer set up of three servers with 12 486DX nodes, which are under Novell LAN version 3.12.
4)
Company : Birla Tyres a company of the B. K. Birla groups. The youngest of all
Indian tyre units, this company produces a large range of automobile tyres,
tubes and flaps. In about two years of production Birla Tyres has achieved a
turnover of around Rs 330 crores.
Operating through a network of 52 depots and more than 2000 dealers in the
domestic market, Birla Tyres has also registered itself as an exporter of
Indian Tyres in a big way with a host of international clients.
a) Period : From September 1993 to August 1995
b) Designation : Programmer (South & West Region Development head)
c) Job Profile : Systems Studying, Designing and development of Software packages, writing Programs and implementation. I have developed packages like Financial Accounting, Payroll, Exports, Purchase Accounting and Sales Accounting, which are successfully running in the company. I was using Clipper, FoxPro and PowerBuilder with Watcom for development. Looking after day-to-day work progress of the department. Working under a big computer set up of 30 PCs that are under Novell NetWare version 3.12 I was also the LAN Administrator for the setup.
Out of our 52 depots, 45 deeps are computerised and the Sales Accounting package that is developed by me is running successfully since June 1994.
Permanent Address
|
:: |
109, Mukta Ram Babu Street Calcutta – 700 007, Phone No. (91)-(033)-2241-1058/6712 |
|
|
|
|
|
Date of Birth |
:: |
7th December 1974 |
|
|
|
|
|
Education |
:: |
B.Com (Hons) from Calcutta University Advance Post Graduate Diploma in Computer &
Information Management from UPTRON ACL, Calcutta |
|
Passport No. |
:: |
B 2261219 |