Anand B Gupte 1418 Parkridge Drive Columbus, OH 43235 Phone: (614) 431 5115 Fax : (614) 431 5487 email: anandgupte@yahoo.com _______________________________________________________________________________ Objective Seeking a position as an Internet Developer for E-Commerce/E-Business, PeopleSoft Developer, Application Developer, or Programmer Analyst. Summary Seven years of experience in Software industry with two years of experience in the area of ERP implementation and customization on PeopleSoft (Version 5.12 and 7.02).Extensively worked on third party tools such as SQR and n-Vision. Experience in various industries development of application systems using Visual Basic, PL/SQL, C and Developer/2000 as front-end tools in Oracle environment. And knowledge of HTML Skills Operating Systems: MS Windows 95/98,NT,UNIX Languages: C, HTML, Visual Basic (version 6),SQL and PL/SQL, Java 1.0.2 Databases: Oracle 7.3 and MS Access GUI/Reporting Tools: Developer/2000 (Forms 4.5/5.0,Reports 2.5/3.0) , SQR (version 4.0) and Visual Basic ERP Software and Tools:PeopleSoft HRMS (version 5.12 and 7.02). Application Designer,People Code, Process Scheduler Work experience: The Ohio State University, Columbus OH (Since June 98 ~ Present) Programmer/Analyst Software: PeopleSoft RDBMS: Oracle v7.3 Modules: HRMS - Payroll and Benefits RETIREMENT BENEFIT SYSTEM : Worked on 4 different retirement benefit plans offered by OSU for their newly hired full time employees. Developed various weekly, pay period and monthly interfaces for the retirement process. * Developed various reports. FEE AUTHORIZATION : OSU offers graduate students, employees and their dependents certain fee waiver arrangements toward tuition payment. * Designed and developed interface system for Fee and Deposits of eligible Employee(s) and their Dependents Upgrade (PeopleSoft Version 5.12 to Version 7.01and SQR version 3.0 to 4.3): * Modified customized SQR reports for upgrade to new version. * Modified customized panels and records for upgrade to new version. System investigation Request (SIR) : * Modified various SQR's and developed various test scripts for testing the fixes and modifications for user identified problems. Chartfield Modifications : Chartfield fields keep track of the financial accounts on HR that feeds data to General Ledger. Receivables, and Asset Management to work as a one functional package. * Completed modifications to the batch, reporting and interface SQR's associated with Chartfield changes. * Completed modifications to the associated on-line code for Chartfield changes. * Developed various test scripts for testing the Chartfield modifications. Y2K Conversion: * Extensively involved in the conversion of interface, batch and reporting SQR's for Y2K. * Developed various test scripts for testing the Y2K test conditions John E Foster And Associates, Inc. Columbus OH (Since 1993 ~ 1998) Software used: AutoCAD, MicroStation for civil and architectural drawings. * Used HTML 3.0 and 4.0 and PhotoShop 5 - with Java scripts to enhance company web site * Created spreadsheets with Lotus 1-2-3 and Excel for engineering calculations of excavation and fill.Created spreadsheets with Lotus 1-2-3 and Excel for engineering calculations of excavation and fill. * Responsible for engineering designs American Electric Power, Columbus OH (Since 1981~ May 1993) Responsible for engineering designs for power plants. Created spreadsheets with Lotus 1-2-3 and Excel for engineering calculations for stress analysis and piping. Created Database for Instrumentaions and Controls using dBase IV. Sanderson and Porter Consulting Engineers, NY (Since 1974 ~ 1981) Designed and drafted systems for power plants such as circulating water, Condensate piping, High and low pressure steam piping. Education and Training * B.Arch. in Architecture. * PeopleTools I & II (Release 7.5) * PeopleCode * Oracle (version 7.3), PL/SQL programming. * Application Development using Developer 2000 and Designer 2000 * Application Development using PowerBuilder (version 5.0) * Java 1.0.2 References Available on request.