304 West Kirkwood, Apt #11
Fairfield, IA 52557
Email: vdeshpande67@yahoo.com
Vivek@Cicorp.com
PROFESSIONAL SUMMARY:
A business oriented professional with more than 6 years full life cycle IT development,
requirements testing. Over 2.0 years of PeopleSoft experience in analysis, design
Telecommunication background and expertise in Relational Databases and Structured Query
Language (SQL).
TECHNICAL SUMMARY:
RDBMS: Microsoft SQL Server, Oracle 7.1, Visual Fox Pro, Microsoft Access.
PeopleTools 7.0/7.5, PeopleSoft 7.0/7.5, SQR, Crystal Reports, Java, Import Manager
PVCS Query Administrator
Hardware Platforms:
Operating Systems: UNIX, VMS, Win N4.0, WIN 95
Industries: Telecommunications Services
PROFESSIONAL EXPERIENCE
Telegroup, Inc. (A leading telephone company with worldwide operations)
Primus telephone company
PeopleSoft Experience: 2 Years
Tools and Methodologies:
Application Designer, Application Engine, SQR, Crystal Reports, PS/Query, PS/NVision, Tree
Manager, Security Manager, Process Scheduler, PVCS admin, Test Lead.
Financial Implementation/Conversion Project
Design & Development of data conversion transfer data from legacy system (Filemaker)
to the PS 7.01
using SQR/SQL} Programming.
Worked heavily on Data migration of Filemaker Pro databases PeopleSoft/Oracle
Used Import Manager after data mapping and performed system edits per user specifications.
Created mapping documents based on functional analysis and programs to load data
Developed and wrote ad-hoc queries to retrieve outstanding checks, identify payments, open
accounts
Extensive interaction with PeopleSoft functional users and legacy experts.
Interaction with PeopleSoft functional users and legacy systems
Extensive use of PeopleTools (Process Scheduler, PeopleCode Debugger, Application Engine,
Security Administrator Utilities, Queries)
Development of programs to move data between databases used applications.
Production Support for the delivered and customized modules developed querie
Security was implemented using the PS Security Administratorto view sensitive for users
Created Run control panels, panel groups, attached the menus through Application Designer
and made them available to operators through various
Run Peoplesoft, delivered processes to check validity of data that imported and make
necessary changes to the interface program Security Administrator
Utilize PeopleCode to apply and use PeopleCode Debugger extensively to debug PeopleCode
Customization.
Migrate Peoplesoft objects between different databases, imports and Process Scheduler and
creating process definitions.
Involved in coming up with the Design for Quality Assurance
Design for Quality and System Testing. This involved interaction with users and writing
and running test scripts and running reconciliation queries for A/R.
Involvement in parallel testing of the Application and user acceptance testing. This
involved working within the to test the validity and tracing etc. This also involved
debugging.
Assisted upgrade from 7.0 to 7.5 and develop new Records, Pages, Components, Menus and
Process Finacial implementation. The modules touched were Finacial GL/AP/AR.
The Upgrade process involved writing various upgrade template
Tasks, Steps, SQL scrReviewed SQR Programs and reports and modified them for the upgrades.
Based on users requirement, Created/Modified SQR reports and attached same to Panel Grids
Developed Unit, System and Integration test development plan for General Ledger, Accounts
Payatested the functionality of General ledger, Accounts Payable & Asset Management
Inventory
Worked on upgrade project from Test environment to Production PeopleSoft upgrade {3.0).
Wrote and modified PeopleCode from commenting to trouble shooting panels that involved
using major programming
Wrote Intensive modules
Creation and modification of Peoplesoft objects, i.e., Record Panels Groups and Panels
Used the Process Scheduler to set up the reports for the autprocess.
Worked with Security Administrator for Creation of operators and operator classes.
Trees, building and Maintenance programs for converting Customer information using SQR
Involved in Object Security to restrict users to their work area.
Responsible for coordination and administering acceptance testing.
Training: PeopleSoft Financials, General Ledger I & 11, SQR, PEOPLE TOOLS 1 &11.
Crystal Reports training
Experience in Revenue Systems/Order Entry
SQL Server Experience:
Managing Database server for QA.
Experience working with Enterprise Manager including Modifying Databases and Transaction
Logs.
Database creation
Perform user based SQL transact SQL queries, including joining tables.
Created views as per User requirement.
Help user Installing SQL server on various machines.
ODBC configuration to connect with other databases.
Configuration of databases using TCP/IP Network.
Trouble shoot Server problems.
JAVA testing on Order Entry system involving debugging the code.
FoxPro and SQL testing on a billing system that processes telecalfile. Design, integrate,
create and execute test plan includes unit, system, regression integration testing.
Developed integration test plan for complete Software life which includes raw CDR, match
& rate calls to invoice creation.
Developed regression test to include test data and writing test cases to cover all
possibible servics of Telegroup.
Developed and maintain Billing release system through promotion mode using PVCS as version
control software.
PVCS Administrator: Experience 5 years
PVCS is used for software configuration management in the client/seenvironment. Experience
in duration management in the client/serv creating projects, managing project files,
project configuration, version branching, merging, promotion group, security &
caccess. Synchronizing different promotsoftware releases. Managing privileges assignments,
user security using Win NT 4.0.
assignment version labels
PROFESSIONAL TRAINING AND CERTIFICATIONS:
Completed 3 months online training course for JAVA
PeopleSoft, Detroit
Attended training for General Ledger 1 in PeopleSoft.
Intersolv University, Washington D.C.
Attended training on PVCS Version Manager for Administration.
Quality Assurance Institute, Dallas, Texas.
Quality Assurance Institute, Dallas, Texas
Attended one week long training on Effective Methodology Testing.
one week long training on Effective Methods System
EDUCATION:
MBA, Management Information Systems, Maharishi International University, Fairfield, Iowa.
Diploma in Computer Science, Maharishi International University, Fairfield, Iowa.
Bachelor's of M.P. Govt. Engineering College, India
Gaur Vishwavidyalaya Govt.
COMPUTER COURSE WORK:
Artificial Intelligence, Operating system, System's Programming,Computer Architecture,
LISP
Computing system, System's Programming, Database system (Access), Digital Logic,
Networking, Scientific computation, C-language. Digital Logic, Networking