TECHNICAL SKILLS:

Hardware: HP - 9000, IBM RS/6000, Sun Solaris, Sequent, IBM PCsOperating Systems: UNIX, Linux, VMS, Windows NT, Windows Vista/XP/2000/ 98, MS-DOS

Languages: C, COBOL, SQL, PL/SQL, HTML, Java, UNIX, Perl, Shell Programming

Databases: Oracle RDBMS 11g,10g. 9i, 8i, 8.0, 7.3, 7.1, 6.0, 5.0, SQL Server

Software: PL/SQL, Oracle Forms 10g/ 9i/ 6i / 5.0 / 4.5 / 3.0, Oracle Reports6i,9i,10g, COGNOS, PRO*C, SQR, SQL*PLUS, Unix, C, C++, Perl, / Shell Programming, COBOL, JSP, Java Programming, XML, EDI Smart, MS Project

Development Tools: Developer 2000, JDeveloper 3.2/9i, Toad, Oracle Application Server, . Appworx, ChangeMan, Oracle Enterprise Manager

PROFESSIONAL EXPERIENCE:

Confidential, Sandiego, CA

Banner Technical Consultant

Responsibilities:

• Worked as team lead on various new project implementation and production problem solving resource
• Worked on Academic history/degree/grades records conversion to Banner from Main Frame system
• Designed, wrote Emergency Notification system interface for all University Students/Employees/Faculty using PLSQL packages, UNIX scripts, Oracle forms.
• Worked on Oracle Forms 10g and Oracle Reports to satisfy user new requirement.
• Designed, developed University Judicial tracking system interface using PLSQL packages
• Created SSB web pages and created new Oracle Banner forms for student system
• Created many PL/SQL reports/process for Banner JOBSUB.
• Customized Student and Financial aid Baseline Oracle forms to take care University business requirement.
• Involved problem solving on Sungard Banner 7.3 and User training,
• Helped to solve Banner Luminis, WebCT problem solving and did some enhancement.
• Developed Banner interfaces,
• Involved in Oracle EBS and Oracle HR to Banner interface implementation.

Confidential, OH

Banner Technical Consultant

Responsibilities:

• Took lead roll for Banner 7x ERP implementation and Student data conversion.
• Was responsible for conducting meetings, requirement analysis, resource assigning and lead project developer.
• Helping Banner 7.x implementation for Financial Aid and Student system, Finance system
• Wrote complicated Financial Aid Fund/Loan tracking/Auto Hold managing/PLSQL reports
• Acted as technical lead to design/write/implement various PL/SQL projects to load student/Financial Aid data from existing Plus system
• Developed PL/SQL interfaces for Library system, Book-Store, Library and several subsystems
• Wrote self service Banner(SSB) programs(web application) for student system
• Trained local programmer on PL/SQL / forms/Unix shell files
• Did Production support and problem solving
• Worked many interfaces/Oracle Forms/PLSQL/C/Web/Unix/Oracle Reports for Banner implementation
• Wrote Java utility interface packages for Oracle database and third party software.
• Developed some new custom Oracle forms for student system.
• Played lead role for converting IBM M204 mainframe data to Banner Students Oracle tables.
• Worked with DBA’s for Sungard patches implementation and Database issues.

Confidential

Banner Technical Consultant

Responsibilities:

• As main techno functional resource for new project development and to lead local developers.
• Acted supporting DBA in absence of main DBA, Improved back-up strategy, backup scripts, notification.
• Tuned up some slow running applications, Worked on planning and clustering oracle 10g database.
• Production support and problem solving
• Building interfaces using PLSQL, Oracle forms, Web pages, ProC
• Helping Student system for new requirement and customization
• Customizing HR/Finance system using Pl/SQL, ProC, Oracle Forms, Oracle Reports, UNIX Shell scripts
• Worked with many miscellaneous. interfaces between Confidential bank and other third party software, developed new subsystems using PL/SQL, web
• Created many new custom Oracle forms and Self Service Banner web pages.

Confidential, Denver

Banner Technical Consultant

Responsibilities:

• Worked as team lead to implement Banner Finance system converting from legacy system.
• Helped migration of Banner 7x from Banner 6x.
• Helped Banner 7.3 implementation and solving Banner problems.
• Wrote Fund/Budget/account balance finance reports for accounting department and HR department.
• Designed, developed, implemented Lowest possible grade system using Oracle forms, Pro*C, PLSQL, SSB, Jobsub. Under VMS environment
• Wrote custom Account Receivable reports in Oracle Reports.
• Designed, developed custom interfaces, subsystem for Banner HR system(7.3) using PLSQL packages, oracle reports.
• Trained users, local programmers.

Confidential, Salem, NC

Banner Technical Consultant

Responsibilities:

• Helped migration of Banner 7x from Banner 6x.
• Converted all HR custom 6i forms to Oracle Forms10g for Banner 7.3. Worked on HR users for new development requirement.
• Converted all Finance custom forms to Oracle Forms 10g for Banner 7.3
• Created web pages, designed and created reports for Alumni module.
• Created ProC, PLSQL, Oracle Reports 9i custom reports and forms for Alumni users.
• Tuned applications, trained users. Managed projects, prepared documentations
• Developed Discoverer for developing custom reports.
• Involved Sungard Banner Release 7 HR implementation.

Confidential

Banner Technical Consultant

Responsibilities:

• Wrote interfaces and helped for Banner 7.3 Student and Financial Aid implementation using PLSQL stored procedures, java, Unix scripts.
• Developed BASC admission interview system for Brown University using PLSQL stored procedures
• Developed programs to satisfy “Checklist Logic” for student admission using PSLQL stored procedures, Unix scripts, Approx scheduler
• Developed “Ready to Read” student admission processing using PSLQL stored procedures, Unix scripts.
• Fixed some of the SCT defects using forms 10g, and pro*C. Required by Brown University to go live Banner version 7.3.
• Tuned applications, trained users. Managed projects, prepared documentations.

Confidential

Salem, NC

Banner Technical Consultant

Responsibilities:

• Was lead technical resource for Banner 7x implementation and data conversion for Student and Finance system.
• Developed custom Payroll data entry Oracle form to short cut Sungard provided NBAJOBS and other six individual payroll forms into single simplified form.
• Developed PLSQL reports for HR system and state reporting.
• Designed, developed, tested, documented and implemented many interfaces, PL/SQL packages, triggers, ProC, Oracle forms and reports for Account Receivable, Finance, Alumni and Student systems.
• Developed Banner interface for ARAMARK, meal planning solution.
• Developed Banner Interface for Campus Partners data processing
• Wrote custom student billing program for Wake Forest University
• Help implementation of Banner 6x HR, Finance from plus system.

Confidential, Grand Rapids, Michigan

Banner Technical Consultant

Responsibilities:

• Designed, developed, tested and implemented complex Pre-Collection and Collection System for Banner Accounts Receivable using Oracle Forms, Oracle Reports, PLSQL, ProC
• Designed, developed web application for Fee Assessments before actual assessment.
• Helped Banner 6x implementation in many modules, wrote interfaces for existing system and conversions.
• Wrote online web applications for Student system, Accounts Receivable, orientation programs and graduation ceremony attendance.
• Wrote many PL/SQL packages, database triggers for Banner Accounts Receivable and Student system
• Customized application of payments, hold applies and ‘unapplies’ (TGPHOLD), other Banner processes and Banner Oracle forms.
• Mentored local programmers to learn Banner web applications, Pro*C and Banner forms.
• Tuned applications, trained users. Managed projects, prepared documentations

Confidential, FL

Programmer/Analyst

Responsibilities:

• Wrote interface for automatic students test score posting to Banner using Oracle forms, ProC, Jobsub, FTP scripts, PLSQL packages. JDeveloper
• Wrote student’s non payment courses voiding process,
• Wrote HRIS State reporting system using Oracle forms, ProC, PLSQL packages.
• Wrote some custom Financial Aid reports for users and Florida State requirement.
• Wrote some custom Pro*C reports and Oracle Forms for HR department.
• Wrote lot of custom finance ProC reports, Crystal reports.
• Install, setup, testing, implementing of SCT EDI Smart system
• Provided Oracle forms and ProC training for college programmers
• Worked on JDeveloper projects and implement other third party tools.
• Implemented Banner HR, Finance ERP system implementation.

Confidential, TX

Programmer/Analyst

Responsibilities:

• Analyst, tech lead for HRIS state reporting system designing, coding, implementing and clearing 3 years backlog state reporting within 4 months. Included user training, and documentation.
• Used: Oracle forms, ProC, database triggers, PL/SQL procedures, Unix scripts
• Developed a test score upload interface system to update local test scores to Banner using Oracle forms and ProC, self-service system.
• Helped users problem solving.
• Provided programmers technical training.

Confidential, FL

Programmer/Analyst

Responsibilities:

• Designed and developed state reporting system using Oracle forms, ProC, UNIX shell scripts, PL/SQL packages.
• Customized SCT baseline Finance forms and ProC reports.
• Developed new customized ProC reports, Oracle Reports.
• Provided Oracle forms 6i training,
• Worked on Banner version upgrade
• Wrote and modified custom Banner forms.
• Helped implementing SCT workflow, EDIsmart
• Created some ProC program, Oracle forms
• Helped reporting system in Oracle reports, Oracle Discoverer reports,
• Modified some Oracle Application finance reports
• Helped to convert to SCT HR Banner5x from Plus system
• Wrote ProC programs, PL/SQL packages, database triggers for HR department.
• Wrote many MIS reports.

Confidential

Programmer/Analyst

Responsibilities:

• Modified Banner finance reports.
• Created some custom Banner forms for Student and Accounts Receivable systems.
• Payment gateway
• Converted Banner student system from existing VMS system
• Wrote many converting scripts, ProC programs and shell scripts.
• Customized many SCT PL/SQL and WEB PLSQL packages as well as web tailors.
• Provided Oracle forms and ProC training for college programmers
• Created custom Oracle forms and Oracle Reports
• Helped with forms6i problems and production support.

Confidential, Malvern, PA

Programmer Analyst

Responsibilities:

• TRA - government project.
• Fixed many SCT Banner defects.
• Converted many SCT SQL scripts to new PL/SQL procedures.
• Fixed about 50 Account receivable defects in various forms, pro*C programs,

Sungard Student Application:

• Fixed numerous SCT student system defects
• Involved some ongoing projects like CAP, workflow, and other student system.

Sungard Finance/ HR system

• Wrote new finance forms/ ProC reports
• Purchase card project
• Fixed many SCT finance system defects (FORMS/PRO*C)
• Designed, wrote programs, implemented California VETS100 project for HR system
• Fixed more than 30 SCT HR system defects in HR Oracle forms and Pro*C reports.
• Involved as a team member in new HR projects.
• Was team lead for custom HR interface project

Confidential, MD

Programmer/Analyst

Responsibilities:

• Worked as key analyst programmer
• Members profile maintenance, training class scheduling, aircraft maintenance,billing and others.
• Software/OS used: Oracle Forms 5x, Oracle Reports, UNIX, NT.

Confidential, IN

Programmer/Analyst

Responsibilities:

• Banner Conversion to Banner 4.X implementation.
• Conversion of all custom forms to Oracle forms 4.5.
• Wrote customized Student billing program (TSRCBIL/Mailer bill) and other many customized ProC programs.
• Modified Finance and Account receivable baseline forms, created new custom forms
• Writing custom forms for Student, Accounts Receivable, HR, Purchase systems.
• Helping SCT Datamart implementation, performance improvement.
• Set-up and implementing EDI smart inbound/outbound transcripts for Banner.