SUMMARY:

• Over thirty years of IT experience in analysis, design, implementation, testing and support of various business systems in legacy and Multi-tier Client-Server applications.
• Experience working with various platforms such as Oracle, DB2, Informix, Access2000 and SQL Server.
• Experience utilizing various conversion utilities to load and extract data to and from various platforms.
• Experience with financials modules GL and Purchasing Orders in Peoplesoft.
• Five years of experience in PeopleSoft HRMS Basic Benefits, Ben Admin, Payroll and general interfaces .
• Extensive experience in developing interfaces and conversion programs to PeopleSoft with various legacy systems in PeopleSoft HR modules.
• Well versed in People Tools 8 versions: Application Designer, People Code, Query, Process Scheduler, Import Manager, Data Mover, SQR and Seagate Crystal Reports.
• Specialized in writing the data extraction interfaces and conversion scripts from legacy/feeder systems to PeopleSoft applications and proven experience in data conversion and cleansing data using SQL Loader, Export and Import and ODBC Utilities.
• Good experience in working with the PeopleSoft System Catalog, People Tools, Application Data database tables.
• Experience in writing the Test Plans, cases and scripts based on system specifications.
• Exposed to various technical engagements and gained extensive knowledge and experience in quality management, project management, and presentation skills.
• Excellent in problem solving, logical and analytical abilities and self-learning attitude.
• Experience in writing Access2000, SQL and Visual Basic routines for a HMO health care Office.
• Experience in Crystal Reports version 8,8.5 and 9.0.

Key SKILLS:

• Technical consultant, Software design and development, Programming,
• Database design and administration, Training, Oracle, Informix, PeopleSoft Certified Technical Consultant

TECHNICAL SKILLS:

Tools SQL, PL/SQL, C, Visual Basic 5.0, TOAD 4.0, Cobol, Access 2000, Unix, DTS, SQL Plus, Toad V. 7.3,PL/SQL Developer Databases MSSQLServer2000/7.0/6.0, Oracle 6, 7, 8i and 9i, 10g, 11g DB2, Informix, Database IV, Access 2000. ERP

• PeopleSoft HRMS v6.0, v7.5, v8.0, v8.1, v8.2, v8.3,v9.1 BA, Payroll, BB, workman's comp
• PeopleSoft Financials v7.5, v8.4 AP, GL sp2, v8.9 CRM 8.4, CRM 8.8, PeopleSoft CRM v8.9, PeopleSoft ELM 9.0

People Tools

• 6.01/7.55/8.13/8.3/8.40.09/ v8.41, v8.45, v8.46, v8.47,v8.48,v8.49,v.8.51 v8.52
• Administration Tools: Configuration Manager, Application Server, Process Scheduler and PeopleSoft Utilities Development Tools: PeopleCode
• User Tools: PS Query Tool, SQL Tools.

DM Tools Data Mover, EDI Manager and Import Manager. Reporting Tools SQR 6.x/4.x/3.0, Crystal Reports 9.0/8.x/7.0/6.0/5.0 and custom quires, Crystal Report Information Viewer, Report Miner: V 2.0 Decimation Utilities for Crystal Reports. Security Tools Maintain Object Security, Query Security. O.S.

• Windows XP/2000/NT/98, Sun Solaris.
• Secret Clearance June 2013.

EXPERIENCE:

Confidential

Assign to the NSIPS team.

• Maintain existing system for NSIPS.
• Confidential
• Assign to the Peoplesoft V8.9 Financials team.
• Modified an interface sqr. I had to modify the sqr to produce
• two data files containing accounting information to be sent to the IBM main frame.
• Converted a query to a sqr to extract accounting information from the

PS LEDGER table to produce a crystal report.

• Development and design of a Mailing list system to replace an old system.
• Converted a query to an sqr to extract PO accounting information and produce a crystal report.
• Basic knowledge of Integration Broker.
• Upgrade development to v8.9 Financials.
• Made PeopleCode changes to the Strategic Sourcing module.
• Team lead and programmer for our non-peoplesoft 1099 processing.
• Have written several Application Engines for financials.
• Worked on GL,AP,AR ,ELM, PO, Inv, asset management and HR 91 and HR 9.2 modules.
• Developed pages , application engines, and crystal reports .
• Modified pages, application engines, and crystal reports.
• Co wrote a new voucher system. application engine
• Modified and enhanced a old system for processing 1099 for the state.
• Wrote many sqr's.
• Modified several application packages.
• Modified a component interface for vendors.
• Did general troubleshooting for 180 agencies.
• Co wrote a new p-card system.

Confidential

• Worked as a Peoplesoft consultant installing third party software.
• Maintain existing sqr and pages.
• Development of new sqr and pages.

Confidential

• Wrote an sqr to compare different leave accruals for Tronox employees.
• Wrote an sqr to calculate the leave liability for Tronox employees.
• Wrote an sqr to estimate the leave accrual for Tronox employees.
• that was going to expire.
• Wrote an App Engine program to notify supervisors of contractor's accounts
• Wrote an App Engine program to e-mail payroll changes to several depts.
• Modify an App Engine program for a Time and Labor module.
• Worked on a Employee/Manager Self Service project
• Provided technical support for current system.
• Designed pages.
• Wrote extracts against their HRMS 8.8 system.
• Worked as peoplesoft technical developer for Tronox.

Confidential

• Worked as a Senior Programmer Analyst writing sqr's for a CRM project.
• Use PeopleSoft 8.9 and Tools 8.45.
• Also server as a contact for a group of sqr writers in India.

Confidential

Kerr McGee Corporation Independent Consultant Feb. 2005 Aug. 2005 : Worked as crystal report developer for Kerr McGee. Some of the tasks were to upgrade and modify 400 crystal reports to reflect change in a new version of user software called Adage. Did some system analysis tasks. Updated views for changes in field's names, functions for new requirements, and triggers to load the load the data for the conversion. Oracle 9i experience.

• Upgraded more than 150 reports, which are in crystal reports 8.5 to version 10, considering the various database changes from Adage version 2.5 to version 4.6.
• Designed and restructured a logical regrouping of more than 450 reports based on their functionality.
• Created the report folders using Crystal Management Console and mapped the new reports.
• Created comprehensive authentication for accessing the reports by creating various groups/subgroups and users and assigned rights based on users' requirement.
• Scheduled reports to different destinations like STEP, PUFF, Excel, etc using calendar for scheduled deployment and make the reports available to all the users.
• Created Business Views using Business View Manager for providing the business users, an easy to understand database structure to create custom ad-hoc reports. Implemented row level and column level security by creating Filters based on users' geographic location and setting rights for table columns.
• Optimized the performance of many slow running reports by various methods like creating SQL Commands, using SQL expressions instead of formulas, changing the report selection formulas, setting the perform grouping on server option, etc
• Used Report Miner extensively to analyze the differences between various similar types of reports and prepared comprehensive documentation on the opportunities to consolidate them to a single report. Well versed on all the four tools of report miner namely Extract, RptDiff, SiteSurvey and Xref.
• Prepared test cases for reports and tested them on new version.
• Used TOAD 7.3 for writing the Stored procedures, Views, Functions in Oracle as the client.
• Interacted with various users to gather requirements for nearly 30 new reports. The specifications and design are in progress.
• Involved in the implementation and maintenance of Web Desktop.

Confidential

Claimlinks Inc Independent Consultant : Worked as a technical resource to provide some customizations to an existing Access2000 system.

Claimlinks Inc Independent Consultant : I worked as technical resource to convert an Access system to a SQL Server 2000 application. This included modifying access code to SQL code. Developed subsystem for current users. Additional workload includes backup administer for SQL Server 2000. Used Crystal reports version 8.5 to developed reports. Wrote several queries. Wrote DTS scripts to transfer data from the access system to the server.