Binay Kumar Pandey 1438 Maruti Vihar, Chakarpur, Gurgaon Phone : +91-124-6811059 Mobile: 9810501936 E-Mail: bkpandey@yahoo.com Web : http://www.angelfire.com/bc/bkpandey Profession : Software Development : Professional : More Than 9 years in Software Industry Experience : OS Installation & Maintenance : SCO Unix, Windows NT, Novell Netware : Development Tools / : Power Builder, Sybase DWB & APT, Sybase T- Programming : SQL, Oracle Developer 2000, Oracle Language Used PL/SQL, Clipper, dBase, FoxPro, HTML RDBMS Maintained & Used for : Sybase 12.5, Unify, Sybase SQL Anywhere Development : 5, Watcom 4, Oracle 8 Packages Used & : MakESS ERP, Lotus 123 (DOS/Win), MS- Implemented : 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 : Tools Used · 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) · 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. · 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. Network Installation & Maintained · 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 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 : 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 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 : 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 Developer My 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 : 109, Mukta Ram Babu Street Calcutta – 700007, Address 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