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