EDWARD HANSEN

7520 Maple
  Avenue

Silver
  Spring, MD  20912

(Cell) 240-671-1520

Email: 
ed_hans2@yahoo.com

 

Sr.
PeopleSoft Architect/ BI Consultant





SUMMARY
OF QUALIFICATIONS

 

A seasoned PeopleSoft and ERP professional with
fifteen years experience in Information Technology, including software design,
programming and development. 
Possesses 5+ years of PeopleSoft experience, assuming the roles of
project leader, architect, analyst, developer, database administrator, and
testing/support analyst.  A
PeopleSoft technical expert with Application Designer, Application Engine,
Application Messages, Application Packages, Component Interfaces, Integration
Broker, PeopleCode, SQR, Upgrade Assistant, Workflow.

Over six
successful PeopleSoft CRM implementations including 8.8 (SP2,MP3), 8.9, EPM and
others. Experience with CRM Verticals: Communications, Energy, Financial
Services, Insurance, Federal Government and Global. Experienced in other
applications such as Oracle Financials, Order Management, Inventory Management,
HRMS, Sales, Environmental Management System.

 

 

SKILLS/TRAINING:

 

ERP:                                                       CRM
experience: Application Message interfaces to Supply Chain 

OS:                                                         Windows
2000/XP Professional, UNIX, AIX, Solaris, LINUX

Programming Languages:                                SQL,
C++, Perl, Unix Shell, Korn Shell, Java, J2EE, 

RDBMS:                                                SQL
server, Sybase, Informix, DB2, Oracle 9i, Oracle 10g, Access 2000, PeopleSoft 

( ver 7.0, 7.5, 8, 8.45, 8.8,
8.9)

Tools/Applications:                             Financials
experience: Asset Management, Payables, Projects, Purchasing, Receivables

Supply Chain experience: Billing, Inventory, Order Management

Human Resources experience: Time and Labor, Human Resources, Base Benefits,
Stock Administration, Payroll, Human Capital Management.

Additional Skills:                                  Team
Lead/Project Management experience. 
PeopleSoft:  Application
Engine 8, PeopleCode 8 Delta, PeopleTools 8 Delta, Data Management Tools,
General Ledger, Accounts Payable, Accounts Receivable, PeopleTools I, II,
PeopleCode.  Oracle 

Training:                                               Oracle
Master Certification, Peoplesoft, SAP, OLAP, Informatica, Abinitio.

 

PROFESSIONAL EXPERIENCE

Feb 
2006 to Present                                                                                         
           ACETechnologies,
Inc. 

Sr. Technical
Architect/Manager and Liaison to IS 
                                                                                                                      Manager within business group
acting as application architect, coordination and liaison to the IS department.
translating IS requirements for documentation and deliverables into business
area requirements. Develop implementation schedule, plan and reporting
requirements for multiple concurrent projects within the Environmental Health
& Safety department. Work with Health and Safety personnel to define system
requirements for software. Work with software vendors, (Oracle, SAP- BW) to
collect and define functional and reporting requirements and process flows for software. Plan and conduct
weekly status meetings with deliverables. Designed and implemented Business
Intelligent web system with user authentication and online reporting interfaces
using Abinitio, Peoplesoft and Microstrategy  

 

 

April 2005 to December 2005                                                                                       
Smithsonian Institution

Production
Support, PS Financials 8.4


 
Focused on Asset Management, Payables, Purchasing.
 
Developed an Application Engine program to load assets to the Asset
     interface tables. 
 
Developed an Application Engine program to extract asset
     information to flat-files. 
 
Developed an Application Engine program to load receipts to
     Purchasing for multiple business units. 
 
Customized the Weekly Elapsed Time page to allow time entry for two
     weeks.  


 

January 2004 to February 2005                                                                                       TGIX Systems

Upgrade
and Implementation, PS Time and Labor 8.8


 
Customized the Weekly Elapsed Time page to include daily totals for
     reported and scheduled hours, pay period summary hours for reported time,
     scheduled time, holiday time and leave without pay.  
 
Developed extensive PeopleCode edits for business rules and
     validations using Application Packages.
 
Developed a Pay Period Time Summary page for reporters, which
     categorizes and summarizes, reported and scheduled time by day and
     project. 


 

October to December 2003                                                                                     WellPoint Health
Networks

Production
Support, PS Financials 8.4

§        
Asset
Management, Payables, Purchasing. 

§        
Developed
an Application Engine program to load assets to the Asset interface tables. 

§        
Developed
an Application Engine program to extract asset information to flat-files. 

§        
Developed
an Application Engine program to load receipts to Purchasing for multiple
business units.

§        
Developed
a modification for Payables to send customized Crystal checks to different printers. 

§        
Modified
an Application Engine program which loads Purchase Orders to Purchasing from a
flat-file via a Component Interface. 

 

March 2003 to September 2003                                                                              The TGIX Company

Upgrading,
Testing and Implementation, PS Supply Chain 8.4

§        
Inventory,
Purchasing and Order Management for this Oil & Gas firm.

§        
Developed
a series of Component Interfaces for integration with handheld devices. 

§        
Interfaces
included PO receiving (Maintain Receipts),
physical cycle counting (Update Counting Event), bin-to-bin inventory transfers
(EZ Transfer), inter-unit inventory transfers (Express Issue), inter-unit
receiving of transfers and recording production completions (Record Completions
and Scrap). 

§        
Customized
Application Messages between Financials and CRM databases. 

§        
Developed
custom SQR reports.

§        
Modified
the Dispatch POs SQR to print Terms and Conditions per client's formatting
requirements.

 

April 2002 to February 2003                                                                                                    
SunTrust Bank

Upgrading,
Testing and Implementation, PS Supply Chain 8.4 & Oracle Financials

§        
Life-Cycle
development of Internet-based Procurement Java/Weblogic Application 

§        
Backend consisted
of Oracle Financial and ERP
system (GL/AP/AR/PO/INV/BOM/OE). 

§        
Created
a replacement for EDI Manager using File Layouts, Application Messages and
publish-PeopleCode.

§        
Created
Application Engine programs to process multiple EDI transactions including
forecasts, purchase orders and invoices. 

 

 

 

 

 

 

Resume/EH/Page
3

 

 

January 2000 to April 2002                                                                                      
Washington Mutual Bank

Team
Leader/ERP, PS Human Resources and Benefits 7.5

§        
Developed
panels and PeopleCode for client's customizations. 

§        
Maintained
SQR interfaces to external applications.

§        
Customized
PeopleSoft Salary Administration module

Upgrading,
Testing and Implementation, PS Human Resources 7.5

§        
Upgraded
panels, PeopleCode and SQRs from 6 to 7.5. 

§        
Constructed
a PeopleSoft data warehouse for archived HR, Benefits and Payroll information
using data from previous PeopleSoft releases and non-PeopleSoft data sources.

§        
Developed
two-way data replication programs between PeopleSoft and Notes


 
Team led group of 7 specialists: 4
     developers, 2 testers, 1 auditor; $20 million annual budget.


 

 

November 1994 to December 2000                                                                                                      
AT&T.

Software Development Engineer 

 

§        
Performed
full life-cycle development of tracking software modules for Government (DOD)
projects.  


 
Developed Client/Server “CASE Management Support System and
     ‘NEW TRAFFIC Support” system with Oracle8i on SUN UNIX
     platform.
 
Primary resource
     for Testing, QA, SDLC methodologies (ISO, CMM, RUP, UML) and various other
     Enterprise
     systems solutions. Implemented new corporate SDLC methodology.
 
Analyzed and
     evaluated functional requirements, define technical specs, wrote code
     modifications.
 
Traveled to other cities to evaluate
     network/software infrastructure needs as well as provide on-site and
     remote support to client's software systems.


§        
Used
Cognos for business intelligence reporting and data warehousing.

 

 

January 1990 – November
1994                                                                        Advance
Technology Systems

Systems Analyst

§        
Responsible
for the functional and technical design of systems with Federal Government
contracts 

(Department of Education, Department of the
Navy/Patuxent River Project).  

§        
Full life cycle development, project design and
composition, and analysis of systems with Federal Government contracts
(Department of Housing, Department of Transportation).

 

 

EDUCATION

Master of Science, Software
Engineering. University
 of Maryland.

Bachelor of Science, Management
Information Systems, Howard
 University. 

 

 

CERTIFICATES &                      

INDUSTRY TRAINING               Oracle,
Master Database Technologies: Oracle
Corporation

Data Communications Networks &
Client/Server Technology, AT&T

                                               PeopleSoft
CRM, ERP: Peoplesoft/Oracle Corporation

Informatica/Abinitio:  Informatica
Corporation

                                               Quality Assurance Best Practices: HP