Hanna Hanna

**** ********** ****, **** #* ( Chula Vista, CA 91915 619-***-**** (

abhl7q@r.postjobfree.com

Technical Consultant - PEOPLESOFT PROGRAMMER

Strong programming, analysis and problem solving skills can deliver under tight

deadlines and accustomed to multi-tasking, ability to work through issues under

high-pressure and tight schedule environments, work both independently and as

part of a team as well as working with remote teams in different time zones,

strong interpersonal skills with customers

Education

Bachelor of Science in Mathematics, Alexandria University - Egypt, 1992

Oracle Build forms and reports Specialized certificate, University of California

- San Diego, 2000

Technical Fundamentals Documentum 4i, San Francisco, 2002

Graduate Degree in Computer Science, American University - Egypt, 1998

Summary of Skills

Over Ten years of technical, functional, hardware and network experience,

including full-lifecycle implementations and upgrades for various versions of

PeopleSoft HRMS, Financial, EPM, Student Administration and Portal, Extensive

experience in PeopleTools Application Designer, Application Engine, Application

Server, Security Administration, Process Scheduler, Change Assistant, Workflow,

Integration Broker, Component Interface, SQL, SQR, PeopleCode and XML Publisher.

Professional Experience

San Diego Unified School District, San Diego, CA

11/2004 - Present Senior System Analyst Programmer

Utilizing Component Interfaces and Application Packages to convert the Position

Management setup to a "one to one" configuration, Providing technical support for

existing PeopleSoft applications within the HRMS and FINANCIAL modules. Lead the

technical team in PeopleSoft major upgrades. Developing and maintaining new and

existing PeopleSoft customizations. Configured PeopleSoft Web Services,

Integration Broker, Messages, Channels and Queues between TMA and T&L

Technical lead and acting technical manager for the San Diego Unified School

District implementation of PeopleSoft HCM 8.9, Financials 8.9, EPM 8.9, and

Enterprise Portal 8.9 also for the PeopleTools 8.49 and 8.51 upgrade.

Appling bundles, fixes and upgrade jobs within Change Assistant

Developing custom Application Program Interfaces for integration with third-party

vendors Direct and assist in developing test plans

Developing and maintaining PeopleSoft full lifecycle project using PeopleTools

technologies such as PeopleCode, Application Engine, Component Interface,

Workflow, Application packages, Messaging & Integration broker, SQR and XML

Publisher

Analyzing batch processing data flow and provide recommendations to improve

process quality

Creating detailed design documents as deliverables, detailing the configuration,

sample code, screen shots, and development efforts required to make requests via

real time Application Program Interfaces

Assess required changes to payroll process and HR applications due to changes in

requirements and manage the change process as needed

Review, analyze, and assign initial priority of requests from staff and

management

Conduct and organize technical staff meetings

Responsible for reviewing, analyzing, and approving Business Requirements

Documents and

Taking an active and successful role in SQL tuning and process optimization

Participating in Software Selection Committee

Developing Security Audit Reports to detail the differences between the different

databases

Leading technical and functional analysis issues in UAT and production.

Build the Physical and Presentation layers for the Student Administrator Business

Models, Create Dimensions, Subject Areas, Workflows and Mappings using Oracle BI

Data Warehouse Administrator Console (DAC), ETL Informatica Power Center

Configured Analytic Requests and Dashboard Prompts. Managed the Web Catalog and

Presented high-level Analytics Executive Summary Reports to Upper Management

Served as a key developer for troubleshooting, as well as batch, reporting, and

custom development

Science Application International Corp - SAIC, San Diego, CA

09/2000 - 09/2004 System Application Analyst

Performed the analysis of current programs, developed applications using, Visual

Basic, Visual C++ and MS Access. Generated reports for analysis of Billing and

Contact Information. Designed and developed several program modules that meet

design specifications and are well documented meeting all development standards.

Maintained, tune and repair applications in order to keep them performing

according to technical and functional specifications

Developed and supported integrations, conversions, reports, workflow, and custom

applications

Evaluated and developed applications for year end changes using Visual C++

Developed application used to record district public user's complaints

Designed and developed programs for new reporting system using Visual C++

Conduct and coordinate test plans to test new developments to ensure reliability

Worked with Business Analysts to identify key Performance Metrics and high

priority escalation queuing to final resolution and Customer follow-up

Created reports for analysis of billing and contact information using Oracle

reports using Oracle reports, SQL, PL/SQL, AX-Alpha, RALLY and COBOL

Creative Systems Solution, San Diego, CA

07/1999 - 09/2000

Application Systems Analyst

Performed the Analysis for current programs in the County of San Diego,

Designed, developed and converted dBases to fully normalized Access 97, SQL,

Visual Basic and Crystal Reports, Performed technical documentation, training and

manuals for users

Developing interfaces and custom Application Program for integration with

third-party vendors

Successfully developing a real-time provisioning and custom billing process

Developed a testing core functionality for the full transaction lifecycle

including order capture, requisitions, order fulfillment, billing, publishing,

and account maintenance

Maintained the City's Permits Plus system and each department's use of it

(building permits, code enforcement, business tax, fire inspections, weed

abatement, parcel management)

PrimaPharm Inc, San Diego, CA

01/1998 - 07/1999

Systems Analyst Programmer

Performed the System Analysis for current application, submitted reports of

recommendations to improve system productivity, maintained files and reports for

the work in progress. Developed applications using Visual Basic. Created a new

Inventory Program to save and print all the service operation procedure to check

the Inventory needs. Developed implementation procedures and managed maintenance

of implemented applications and perform systems analysis/programming as required.

Providing technical support and problem-solving techniques for the functional and

technical team

Taking an active role in writing, reviewing, and approving project deliverables

Rewrote existing procedures to maintain current functionality in planned release

Developed Visual Basic Inventory application to monitor products usage level

American University, Alexandria, Egypt

02/1995 - 02/1998

Programmer

Developed programs to monitor teachers schedule. Designed and developed

applications using MS Access, SQL, C and Visual Basic. Build reporting system

with MS Access and MS Excel report engine

Developed programs to monitor student and teachers schedule using Visual Basic

Worked with users to assist in the troubleshooting of system issues

Maintained current system functionality and development of new custom functions

Managed, designed, and built client tools to help data cleanup using SQL, MS

Access and Excel

El Mahgoub High School, Alexandria, Egypt

06/1991 - 02/1998

Mathematics Instructor

Prepared instruction materials, supervised classrooms taught and evaluated.

Developed evaluated report for submission to accreditation board reported details

and assessed present and future goals, programs, plans and professional

performance

Trained students in general mathematics, algebra, calculus and geometry

Evaluated student's progress daily in math class

Contact this candidate