James Smith Email & Phone Number

Technical lead on project to add email interface to Structured Query Report (SQR) ETL processes in Windows 2003 Server/Outlook environment. Enable sending of attachments and enhanced SQR’s running from batch Process Scheduler, resulting in increased timeliness, efficiency and a more streamlined process.•Technical lead on project to convert all instances of Peoplesoft employee id (SSN based) to match SAP HR Personnel number. Which resulted in greater efficiency between the two systems.•Development, testing, debugging support of vendor interfaces for 25,000 employee payroll for ADP Payroll (PeopleSoft) on Oracle 9i database utilizing SQR ETL along with SQL and PeopleCode and PeopleTools.•Development of centralized documentation for payroll technical processes.•Creation of SQRs for reports/files to run from Process Scheduler, utilizing PeopleTools, PeopleCode.•Selection and utilization of tools to enhance vendor interface development, i.e. TOAD, SQR Express for Peoplesoft, and Microsoft Visual Source Safe for source version control.•Setup and configuration of new operators, new departments, tax codes, etc., database security.•Addition of new items to menu tree and addition of SQR processes to run from Process Scheduler

•Technical lead in successful application development of electronic forms interface for Loan Origination System in client server environment utilizing SQLBase and Gupta. Which resulted in improved processes and efficiency as well as reducing cost related to preprinted forms.•Technical lead on development, testing, debugging and support of Loan Origination System on IBM AS/400 (iSeries) complete with electronic forms.•Led development of application to distribute software to 30 IBM AS/400 (iSeries) in remote locations.•Developed and provided documentation for Loan Origination system.•Technical lead on development/modification of ADP (Peoplesoft v6.0) HR/Payroll Panels utilizing PeopleTools and PeopleCode.•Development of interfaces to/from HR/Payroll system utilizing SQR ETL tool along with SQL, PeopleTools & Process Scheduler.•Provided developmental support for the Employee Benefits Open Enrollment process.•Led effort to select tools to enhance ADP (Peoplesoft v6.0) HR/Payroll vendor interface development, i.e. TOAD and SQR Express. Resulting in faster, more accurate development.

Bs, Bus Adm

Dean's List - Senior Year

Education record