PANKAJ KUMAR
*****************@*****.***
Passport No. : F9504916
Mobile No. : 970*******, 950-***-**** .
Address : Flat- 696, 2nd Floor, B-Block, DDA Flat Bindapur,Dwarka,New Delhi-59.
Profile Summary
I have 15+ years of experience in designing and developing client/server applications and N-tier applications.
Expertise in Designing and Developing client/server and N-tier applications using Sybase PowerBuilder, PFC, PL/SQL and Oracle.
Proficient/expert in Sybase PowerBuilder, PFC, PL/SQL and Oracle.
Expert and having good experience in various project management methodologies like Waterfall etc.
Good experience in Development and Maintenance of projects. Follow CMM 5 Process and Procedures and Quality.
Worked as SME for couple of projects in PowerBuilder using PFC and PL/SQL.
Telecom OSS (Inventory, Ordering) domain, Production and accounts.
Worked on various Operating Systems like UNIX, LINUX and Windows.
Received the Bravo award for the excellence delivery from IBM.
Provide effort estimates and budget to the client.
Manage the project team to complete the releases on schedule and quality.
Provide the weekly status report along with the risks and issues.
Involved in Initiating, Planning, Execution, Monitor and control, Closure of multiple projects.
Work Experience:
Currently working as Sr. Technical Staff at PMAM Pvt Ltd., Mumbai - India,
since Feb. 2020 – Till Date
Currently working as Associate Manager at JK Technosoft Ltd., Gurugram - India,
since Oct. 2018 – Jan. 2020
Worked as Associate Manager at Accenture India Pvt. Ltd, Hyderabad- India,
since Dec 2013 – Nov. 2017
Worked as Sr. Staff Engineer at ORACLE India Pvt. Ltd, Hyderabad- India,
since April 2008 – Dec . 2013
Worked as Sr. System Engineer at IBM India Pvt. Ltd – Bangalore- India, since Dec. 2006 to Mar 2008.
Worked as Sr. Software Engineer at Infinite Computer Solution(CMM-5) – Bangalore, India, since Jan 2006 to Dec. 2006.
Worked as Programmer at Broadcast Automation Systems.- New Delhi.
Since Jan 2002 to Jan 2006.
Qualifications:
Master of Computer Application (MCA) From IGNOU(New Delhi) in Dec. 2001.
Two Years Post Graduate Diploma in Computer Science from ISCT(New Delhi) in Dec. 1996.
B.A(Hons) From Delhi University in July 1996.
Skill Set:
Operating Systems
MS-DOS, Unix, Linux, Windows ’98,/NT/2000/2003 & Vista.
.NET Technologies
C#.Net,ASP.Net.
Languages
JAVA, C,C++,Cobol.
Visual Programming
Power Builder 5.0 - 12.5 with PFC,Cognos 7.0.
RDBMS
Oracle 9i, 10g & 11g, SQL Anywhere 5.0 – 9.0.
Web Technologies
J2EE, Servlets, EJB, JSP.
Wireless Technologies
J2ME.
Application Server
Tomcat 5.0, Jrun, EASERVER 5.1,Web Logic.
Others
MetaSolv M6, Wise Installation Kit, PVCS, Formula One, XML.
Projects :
OASIS :-
Pro assurance (Assurance project).
Oasis system is maintaining the policy management, claim management, client management, financial management and risk management.
I am responsible for understanding the system and working on issues.
Environment : Power Builder 2019, PFC, Oracle.
Feb./20 to Till Date
Migration project for warehousing( converting into Powerbuilder 2017 and MS SQL Server 2017) :-
DB schenker (Global Logistic Solutions & Supply Chain Management).
Inbound, outbound, inventory and other activity are exciting though this application. Also provide the warehousing solution to the other company.
It is migration project for database MS Sql server 2017 and PowerBuilder 2017.We are migrating total 257 instances for different countries and also solving migration issues.
Environment : Power Builder 2017, PFC, MS Sql Server 2017.
Oct/18 to Jan/2020
Field Management System.:-
Oil related company.
Filed management system build on Oracle Apps database. It is managing the asset of Oil Company. It is creating the job, purchase order, invoice, transfer and credit notes.
•Off-shore Lead.
•Handling Sustaining Maintenance & Support and Enhancement/ Development Projects in Powerbuilder/ Oracle Technologies.
•Technical Lead for the projects requiring interfacing of FMS/ SAM Applications with other applications like QTrac, GT, SAP etc.
•Preparing Proposal Document, Technical Design Document & Unit Test Cases
•Resolution of ALM tickets –Coding & Enhancements, Unit Testing
•Interacting with L2 and C&R Team for requirement clarifications & facilitating UAT
•Build & Release co-ordination
•Monitoring work assigned to junior team members and doing code reviews.
•Monitoring ALMs and Status Reporting .
•Tracking on KPIs and SLAs for the project.
•Did staffing for this project..
Environment : Power Builder 12.1, PFC, PL/SQL, Oracle.
Dec/13 to till date
M6 (MetaSolv Product) :-
70+ Telecom companies using world wide.
It is telecom product for ordering and inventory. It is N-tr product. Telecom provider companies are using this product for Template base product, Circuit, Tel Phones (WTN, IN-PIN etc) and IP ordering. User can create the Jobs, SONET and Networks. MSS has maintained the complete life cycle of Tel Phone, circuit, IP and Network system. Complete life cycle means (Pending, In-Service, Transaction, unavailable and disconnect). User can set the permission on object level as well as row level. MSS can be interact with CRM and any other third party software through API..
MSS has four modules viz,
Order Management System comprising Provider Ordering, Inter-Carrier Ordering, Customer Management and Trouble Management.
Inventory Management System comprising Network Design, Equipment Management, Number Inventory and Engineering Work Order,IPv4 and IPv6 Address.
Work Management that ties the Order Management and Inventory Management Modules.
ASR for US government related order.
The Server takes care of most of the activities for MSS, like Telephone number recall, Database interactions, validations, background processor, job managers, etc. It has provisions to interact with the user through CORBA, XML APIs, Custom Extensions, EJB APIs and certain stored procedures.
I am responsible for understanding Inventory Management, Order Management system (PSR), Work Management and to do enhancements, maintain the Front end & back end coding, test plan and test cases .
Environment : Power Builder 10.5, PFC, PL/SQL, JAVA, JSP, C++, XML, EJB, Oracle and Web Logic.
April/08 to Dec 2013.
Supplier Tariff Analysis Resource(STAR) &Corporate Access Rates System(CARS)
AT&T(USA)
This Project migrated from USA to India and PowerBuilder 6.5 is upgraded to PowerBuilder 10.5. It is basically a tariff analysis system for AT&T .This application uses in many places in USA. Data is taking from CSV files as well as data entry screen. User can convert maximum reports in Excel sheet with the help of OCX control(Formula one) & using PVCS for version control purpose .The project uses lots of stored procedures and functions.
I am responsible for understanding the whole project and to do enhancements in it and give support to USA client, maintain the Front end & back end coding, test plan and test cases .
Environment : Power Builder 10.5, Oracle 10g(Unix), PVCS,
Formula one, WISE Installation Kit.
Feb/06 - April/08
Order Confirmation, Invoicing, Sales, Accounting, Stock & Production System
Orient Abrasives Ltd. (Factory).
This project divided into three parts comprising of four modules namely Order Confirmation system, Production System, Stock System and row material System. System analysis and designing has been completed for all the modules. This system automatically generates the code.(Items, location & customer code etc). The order system is related with orders from branch office of the company and direct customers for grinding wheels and other products. After the processing of order, Production plans are prepared, Invoice and stocks maintained accordingly. Factory input part has Order Confirmation, Order Allocation, Invoice, Item Production Details, Job Card, Production Processes, Stock Receive. In report part all report regarding production,order and Invoice is completed . Centre marketing is only making invoice for the non standard items ..Sales person and customer can see the online status through jsp(for this feature development is going on).
I was responsible for analysis and designing of the database and also programming and implementation of the application. I was a team leader & Developer in this software.
Environment : EASERVER 5.1, Power Builder 10.0, SQL Anywhere 9.0.
Feb/05 - Jan/06
Jewellery Invoicing & Inventory System
32 Jewellers (Ex. PP Jewellers, New Delhi etc.)
This project comprises of Four modules namely Accounts, Multi Approval,Stock system & Invoicing system. In this project Arrivals. Issue, Invoice, Receipt, Payment, Credit Notes & Debit Notes are entered. Various reports like Invoice, Stock status, Purity, Design, Day Book, P/L Account, Balance Sheet are generated. It’s already changed according to VAT.
My role was to handle the team and I was responsible for analysis and designing of the database, also programming and implementation of the application.
Environment : Power Builder 10.0,Sybase SQL Anywhere 5.0 – 9.0.
Aug/04 - Jan/05
Asset Management System
IKEA Trading (India) Pvt. Ltd., New Delhi
This project is to calculate the depreciation of all Assets . It comprised of lot of entry screens for example Location, Employee,Depreciation, branch ETC. and Depreciation Generate screen(for Company Act and Income Tax Act) etc.
I was responsible for analysis and designing of the database, also programming and implementation of the application.
Environment : Power Builder 5.0,Oracle 9i.
Mar/04 - Jul/04
Local Order Processing System .
IKEA Trading (India) Pvt. Ltd., New Delhi
This System is developed to maintain the Order processing of the company. In the pre-shipment module the company import the order, all the details regarding that Order are stored, Invoices are made and price conversions are done. In Post-shipment module FIRC allocation, Bank Realization Certificates (BRC), Purchase Voucher & Sale Vouchers (PVSV) are created, EXA Import and mismatch reports are generated and supplier payments are done. User password, permissions to access the records and other security levels are assigned to each user to secure the system. User can access only permitted components of the system. Reports are provided by which user can view different outputs in different formats.
I was responsible for programming and support of the application.
Environment : Power Builder 5.0, Oracle 9i
Jun/03 - Feb/04
Attendance & Access System
TVS Electronics Ltd Chennai
It was a smart card based application. The application can write on the card and gives the access rights according to the level of the employee. Locks can be opened according to the lock information stored on the card. Cards are inserted in terminal 550 and data gets converted in text format. The software converts the text file to Sybase database using run time pipelining and finally attendance generated.
I was responsible for analysis and designing of the database and also programming and testing of the application.
Environment : Power Builder 5.0, Sybase SQL Anywhere 5.0
Jan/03 - May/03
Purchase Order System
Praja Mechanicals Ltd., Ballabgarh, Haryana
Purchase module is a one of the module of system. This system works in close co-ordination of stores and required quantity. This module provides complete tracking of the order status and receipt of good. The system allows smooth managing of purchase activities. Procurement of material is done on the basis of indent raised. Preparation of Bill of material, Indent, Purchase Order Amendment, cancellation of Purchase Order and Arrangement for rejected goods.
I was responsible for Programming, testing and implementation of the application.
Environment : Power Builder 5.0, Sybase SQL Anywhere 5.0
Oct/02 - Dec/02
Payroll System
Praja Mechanicals Ltd., Ballabgarh, Haryana
This System is basically designed to computerize the payment of salary in a company. It checks the employee category his designation leaves making relevant deductions and giving allowances as per company’s specifications. It prepares payslips; salary registers after making deductions according to presence of employee in the office. Other report include Form 3A, Form6A, Loan Report, Monthly attendance details as well as annual attendance reports. Attendance is generated by punching of Smart Card and can be changed manually also. The application can show various reports (in-out statement, Salary details, Loan Status, Payslips, Employee details, Leave details) and windows for Login and Password update in web browser using JSP’s.
I was responsible for Programming of JSP’s and implementation of the application.
Environment : Power Builder 5.0, Sybase SQL Anywhere 5.0,
JSP, Apache Tomcat 4.0
Jul/02 - Sep/02
Branch System(Invoicing, Sales, Accounting & Stock)
Orient Abrasives Ltd. (for Branches & Centre marketing).
This project divided into three parts comprising of four modules namely Invoicing System, Stock System and Accounting System. System analysis and designing has been completed for all the modules. This system is only for Standard items and Branches make Invoice only for standard items . In branch report module, invoice report, aging report, ledgers, Bin Card, Debit & Credit Note, Stock status on any Date, Receipt and Branch wise report are prepared. It is working at all six branches along with factory of Orient Abrasives .The main feature of this project is multi location.
I was responsible for analysis and designing of the database and also programming and testing of the application.
Environment : Power Builder 5.0, Sybase SQL Anywhere 5.0
Jan/02 - Jul/02
Others Projects: -
Admit Card System (I.I.T Delhi)
Card System (ITKHAS Health Club Delhi)
Payroll System (IKEA)
Contact Information: -
E-mail : ***********@*****.***
Date of Birth : 01/01/1976.