Aleksander Górajek

Areas of expertise:   ERP, DW, BI, Functional & Technical, Analysis / Design / Development

Technical Architect (Jun 2007 – present)
Greenplum (San Mateo, CA)

• Provided consulting services during implementations and maintenance of the Greenplum DW platform.

PeopleSoft / Oracle Consultant - contract (Sep 2007 – May 2008)
University of Wisconsin Medical Foundation (Madison, WI)

• Technical Lead and Upgrade Specialist in PeopleSoft HCM upgrade project.
  

  Project details:

  Upgrade from HRMS 8.8 SP1 to HCM 9.0
  Dedicated team of 2 consultants and 3 client employees
  Database size: 3000 employees, 15000 applicants
  Environment: Oracle 9i, Sun Solaris 9, Win 2000 Server, Bea WebLogic 5.1
  

  Upgrade scope:

  Human Resources, Benefits Administration, Resume Processing, Payroll for North America, Directory Interface, eBenefits, eDevelopment, eCompensation, ePay, eProfile, eRecruit, Candidate Gateway (https://ess.uwmf.wisc.edu/careers/jobs/index.html).
  

  Roles and activities:

  • Database and application administration
    Database setup and cloning.
    PeopleSoft Web, App, File server setup and configuration.
    Client workstation setup and support for Crystal Reports using PeopleTools ODBC.
  • Customizations design and development (PeopleCode, SQR, PL/SQL)
    Designed and created functional specs for 10% of all customizations.
    Created technical specs and developed 90% of all customization.
  • Testing and execution of upgrade scripts
    Used Change Assistant to prepare, test and execute all 8.8 to 9.0 upgrade steps, Maintenance Pack 3 Cumulative and other patches and updates.
  • Data conversions design and development
    Custom Chart Field account conversion for all Job Earnings Distribution tables (pre upgrade).
    Fix conversion for Referral Source data – complete refresh of 4 tables (post upgrade).
    Other various custom updates and conversions written in SQL and PL/SQL.
  • Payroll/GL integration setup and configuration (Integration Broker)

Systems Analyst / Database Analyst - full-time (Oct 2002 – Sep 2007)
University of Wisconsin Medical Foundation (Madison, WI)

• Provided technical and functional knowledge during design, implementation and maintenance of the following systems:
  

  Data warehouse and ETL processing – Oracle 9i / EPIC / Intersystems Cache

  Roles:	DBA / design / development / tuning
  Tools:	SQL, PL/SQL, Oracle Partitioning, Bitmap Indexes, Materialized Views, Stored Procedures, Job Queues, TKProf, Trace Analyzer, Execution Plans, Unix/Perl Scripts, KB-SQL, Toad, Benthic Software, VLDB

  ERP applications – PeopleSoft PT 8.4x, HRMS 8.8, FSCM 8.8, emPath, Ross Financials

  Roles:	customization design and development / upgrades / administration / security
  Tools:	PeopleTools 8.4x, Change / Upgrade Assistant, PeopleCode, SQR, Integration Broker (HTTP, XML), PeopleSoft Trace, Query Manager, emPath (Now Solutions)

  Business and clinical reporting environments – Crystal Enterprise, Business Objects, SAS

  Roles:	design / development / training / mentoring / SQL performance tuning
  Tools:	Crystal Reports 6-XI, Business Objects, SAS Info View, ePortfolio, Row Security, ODBC, SQL, PL/SQL

  OLTP databases for financial and HR / payroll systems – Oracle 8i, 9i

  Roles:	DBA / maintenance / support
  Tools:	SQL, PL/SQL, Unix Shell Scripts, Tru64, Sun Solaris, AIX, SAN

• Designed and supervised implementation of multiple interfaces connecting the above mentioned environments and other internal/external systems.
• Involved in the 24/7 collaborative support of the main EMR system (EPIC) and other legacy systems.

Marketing Manager - part-time (Aug 2001 – Apr 2007)
Goody Goody Gum Drop – Candy Kitchens (Wisconsin Dells, WI)

• Created and supervised on-line and local marketing campaigns.
• Designed and developed Purchase Orders automation system (Visual Basic, MS Access).
• Designed and developed on-line store at http://goodygumdrop.com (MySQL, PHP, HTML, JavaScript).
• Performed payroll processing, bookkeeping and fed/state tax reporting (Intuit QuickBooks).

Programmer Analyst - full-time (Dec 1998 – Jul 2001)
Hobbit (Warsaw, Poland)

• Performed analysis, design, logical and physical data modeling, process modeling, development of dedicated information systems for various government and public institutions:

Client:	Information Processing Center (http://www.opi.org.pl)
Project:	Internal web based information system for the core business activity (13 months).
Roles:	Application and Report Developer
Tools:	Oracle Developer 2000 (Forms & Reports), Crystal Reports 6.0

Client:	Federal Trade Inspection (http://www.giih.gov.pl)
Project:	Client/server based information system for the core business activity (12 months).
Roles:	Architect / DBA / Developer
Tools:	Oracle Designer 2000, Oracle RDBMS 8i, Oracle Developer 2000 (Forms & Reports)

Client:	Phone Information Agency (http://www.tai.com.pl)
Project:	Client/server and Internet based system for the core business activity (2 years).
Roles:	Application Developer (4 months)
Tools:	Sybase RDBMS, PowerBuilder, Visual Basic

Client:	Federal Agricultural Property Agency (http://www.anr.gov.pl)
Project:	Client/server based information system for the core business activity (1 year).
Roles:	Application Developer (4 months)
Tools:	Oracle Forms 6i, PL/SQL

Client:	Department of Polish National Forests (http://www.lp.gov.pl)
Project:	IT audit of system compliance with design specification (2 months).
Roles:	Systems Architect
Tools:	Informix 4GL, Software through Pictures (StP)

CERTIFICATES / LICENSES / TRAINING

• OCP 8i, 9i DBA, MCP (Win2k)
• PeopleSoft PeoplTools I/II, Integration Tools, PeopleCode
• Oracle BI (OWB), Epic Clarity Administration