TEJUNE
KANG
tejune@tejunekang.com
Obtain
a challenging lead technical position or technical/functional role on a
PeopleSoft EPM project.
I have been working with ERP
packages in technical and functional roles for approximately seven years, four
of the seven years working with PeopleSoft, Inc. My product experience includes PeopleSoft EPM
8.8 with Budgeting, Business Planning, Balanced Scorecard/Enterprise Scorecard,
Workforce Scorecard, 8.3 HRMS, 8.8 CRM, 8 CRM Upgrade Toolkit, and Vantive CRM. My
technical experience includes customizations involving Peoplecode, App Engine,
VBA, Oracle stored procedures, and more.
I have obtained multiple PeopleSoft certifications including EPM,
Technology, CRM, and Vantive. My multiple certifications and extensive
project experience position me as a strong candidate for any PeopleSoft 8
project or any other general technical opportunities. I have also presented at the annual
PeopleSoft User’s Conference (Connect) for various topics including performance
tuning and past successful engagements.
Furthermore, I have worked well in high-pressured fast-moving
“firefight” environments and have demonstrated to be a valuable team
member. My initiative and depth of
knowledge has earned me the coveted “Company Maker Rating” within PeopleSoft,
Inc.
Modules ¨ EPM Budgeting ¨ EPM Budgeting ¨ EPM
8/8.3/8.8 ¨ EPM
¨ HRMS Time and Labor ¨ PeopleSoft CRM ¨ Vantive CRM
Technical ¨ Application Engine ¨ Peoplecode ¨ PTools/Security
¨ Integration Broker ¨ Component Interface ¨ Application Messaging
¨ Application Designer ¨ nVision/Crystal/Reporting ¨ PS Query
¨ Allocation Manager ¨ Data Manager ¨ Datamarts / Cube Manager
¨ SQL/SQR ¨ Tuxedo/Web & App Server ¨
Data Mover
Operating ¨ UNIX/Linux/DOS ¨ Mac OS ¨ Windows 95/98/NT/2000/XP
Systems
Databases ¨ SQL Server 6, 7, 2000 ¨
Oracle 8.x, 9i ¨ DB2 OS390/UDB
Initial Koncepts, Inc. (03/04
to 04/04)
Principal Consultant: Entergy Corporation,
Technical
Consultant for Allocation Manager development efforts.
·
Created SQL
scripts for Metadata migration effort for over 2000 custom metadata
customizations.
·
Created custom
SQL scripts to identify and resolve data discrepancy issues.
·
Created custom
SQL views involving complex calculations with rolling 12 month averages,
multiple effective dated rows, and more.
·
Developed/Constructed,
configured, and unit tested allocation rules involving copy/pro rata/spread
even method for multiple rules.
·
Supported and
extensive troubleshooting efforts for metadata created for over 800 custom
allocation rules.
Initial Koncepts, Inc.
(01/04 to 02/04)
Principal Consultant: GMAC Residential Funding Corporation,
Lead
EPM/Budgeting Technical Consultant for a Budgeting 8.8 pilot demonstration.
·
Resolved
multiple BAM issues including BP Export App engine process, Excel spreadsheet
“add-in” functionality when checking out models, SMTP email functionality, FTP
file attachment functionality, and more.
·
Allocation
Manager – setup and configured multiple rules for the pilot demonstration. Included creating new views to serve as
source definitions, record definitions, record stubs, and other metadata to
support requirements.
·
Identified
performance bottlenecks and tuned as necessary:
conducted performance tuning on certain page hyperlinks (analysis on
peoplecode trace file), tuned application server and web server, and
application engine processes, such as the Budgeting stage, publish, and refresh
security.
·
Assist in
preparation for successful initial budgeting pilot, which can lead to a full
implementation.
PeopleSoft
Inc.,
Senior Consultant:
Lead EPM/Enterprise
Scorecard Consultant for an Enterprise Scorecard/Workforce Scorecard 8.8
implementation involving Human Resources Warehouse (HR Warehouse).
·
Developed and
outlined Project Plan, Fit Gap Document, Requirements, Configuration Document,
and others to assist in the implementation of Enterprise Scorecard and
Workforce Scorecard 8.8.
·
Setup and
configured metadata including but not limited to: Record Metadata, Tablemap,
Datamap, Filter, Constraint, Data Element, Assessment, KPI Definition,
Calculation Definition, Calculation Rule, KPI Objects, Target Rules, Strategy,
Strategy KPI, Trees, Scorecards, and Security.
·
Assisted in
development efforts for Datamarts, Reporting, and Ad
Hoc Reporting using PeopleSoft HR 8.8 as our source data.
·
Migrated
existing metadata, identified delivered OOTB (out of the box) KPIs to use during Phase 1 of the implementation effort.
·
Assisted in
troubleshooting any ETL and Data Loader technical related errors.
·
Created custom
SQL scripts to change SETID ‘SHARE’ to custom SETID defined in our environments.
·
Created datamover scripts to facilitate ease in setting up new
environments (test, sandbox, production).
·
Identified and
resolved existing issues with software to insure a smooth and on time go live
production environment.
·
Created customizations
as necessary, per fit-gap and configuration document.
·
Provided
recommendations on technical architecture of environments and deployment.
PeopleSoft
Inc.,
Senior Consultant:
Lead EPM/Budgeting Technical
Consultant for a Budgeting 8.8 implementation.
·
Successfully
managed all technical aspects of implementation from fit gap to go live which
lead to a successful implementation and extremely satisified
and referencable client for PeopleSoft, Inc.
·
Developed Informatica ETL mappings and Data Loader definitions in the
Enterprise Warehouse based on the client’s requirements.
·
Reconfigured
multiple Informatica Servers on UNIX instead of the
NT environment and took advantage of using aliases for ease of development
migration.
·
Identified
possible issues with the BAM Logic Server installation throughout the project
and troubleshooted all BAM errors; resolved all
outstanding issues to insure a smooth production environment.
·
Allocation
Manager – setup and configured several rules to fulfill custom requirements,
including the creation of new metadata definitions to support the custom
rules.
·
Assisted in
troubleshooting any functionality gaps with the Budgeting module, working
closely with the Functional Lead.
·
Developed custom
Informatica ETL Maps and Data Loader definitions as
specified by the requirements of the customer.
·
Created many
deliverables including Technical Project Plan, Customization Effort Level
Document, ETL Processes Definition, Enterprise Warehouse Outlined, End-to-End
Documentation, and Setting Up Source Environments,
Setting up a New EPM Environment, End to End Document, Test Scripts, SQL
Scripts, Issues and Resolutions Document, Problem Log, Informatica
Management Document, Migrating Metadata Between Environments, and others.
·
Developed
customizations in PeopleTools as necessary (Views,
Indexes, App Engine, etc.)
·
Created
Reconciliation process (SQL scripts, Word Doc, etc.) in order to validate and
verify the accuracy of the results.
·
Identified
bottlenecks in the Informatica ETL and Data Loader
process and tuned as necessary resulting in an
decrease of over 200% processing time.
·
Performed DBA
activities including monitoring lock levels, contention possibilities,
conducting explain plans as necessary, etc.
PeopleSoft
Inc.,
Senior Consultant: PeopleSoft Product Development,
Technical
Lead for development of new product and retrofitting previous base codeline for release to all customers.
·
Designed and
coded in peoplecode extensively for integration between CRM 8.8 to HRMS 8.3 and
CRM to HRMS 8.0SP1 using PeopleTools 8.42 and PeopleTools 8.19.
·
Configured portal
technology to acquire content from the HCM database and pages displayed in CRM
8.8.
·
PeopleCode using XMLLinks to parse the XML Request message and wrap the
response and send it back using synchronous communication; Facilitated
communication using BiDocs data type for XML
Integration.
·
Employed
Integration Broker XML Technology for synchronous communication with Tools
8.19, which then responded using peoplecode, and bypassed Application Messaging
technology.
·
Registered all
XML Links created for the HRHD Project in Tools 8.19.
·
Employed the switchUserID function to change users and authenticate
users between CRM and HCM using the token passed from CRM 8.8 to HR
environment.
·
Installed and
Configured Single Sign on for several environments.
·
Unit tested the code
that was developed for the HRHD 360 Degree View product.
·
Managed and
maintained the multiple environments during the full development cycle.
·
Assisted in
development of the Technical Design Document.
PeopleSoft
Inc.,
Senior Consultant: CB Richard Ellis,
Technical
Lead for customizations per client’s request.
·
Customized the
KPI Detail Page to filter the number of rows being returned per client
requirements, changed several columns in the grid, sorted the KPIs in a specific order, changed objects being displayed
on the page, and more.
·
Customized the
Strategy Page to change the grid, several objects on the page, and the list of
the KPI’s on the left side navigation bar.
·
Led and
developed reconciliation strategy and efforts to insure data validation and
referential integrity.
·
Worked closely
with the customer to validate and insure the expected results were displayed on
the pages.
·
Assisted in
applying the latest application patches, fixes, and updates.
·
Reconfigured and
setup the Informatica ETL mappings to go to the ODS
layer of the Enterprise Warehouse.
·
Created multiple
documents including requirements, scope, customization analysis, etc.
PeopleSoft
Inc.,
Senior Consultant: Children’s Hospital Los Angeles,
Technical
Lead for EPM/Business Planning 8.3 implementation.
·
Developed Informatica ETL Maps and Data Loader definitions as
specified by the requirements of the customer.
·
Reconfigured the
Informatica Server on UNIX instead of the NT
environment.
·
Identified
possible issues with the BAM Logic Server installation.
·
Lead a team of
developers to apply code changes to the development and test environments.
·
Applied all
necessary patches, fixes, and updates to the environments.
·
Assisted in
troubleshooting any functionality gaps with the Business Planning module,
working closely with the Functional Lead.
·
Created several
deliverables including Technical Project Plan, Customization Effort Level
Document, ETL Processes Definition, Enterprise Warehouse Outlined, End-to-End
Documentation, and several others.
PeopleSoft
Inc.,
Senior Consultant:
Technical
Lead for EPM/Balanced Scorecard 8.3 implementation.
·
Provided
solutions to Executive Management Team to determine KPI's
and establish expectations for functionality of the Balanced Scorecard product.
·
Setup,
configured and trained technical developers how to create and setup Informatica ETL Sessions.
·
Setup,
configured and trained technical developers how to create and setup Data Loader
definitions.
·
Setup and
configured the Enterprise Warehouse including PF Business Units, SETID, etc.
·
Created trees as
necessary; assisted in importing trees from multiple sources including home-
grown inventory system and financials 7.5.
·
Analysis and
extensive performance tuning for Data Loader conducted resulting in a faster
processing time.
·
Created KPI
definitions and all other related metadata object definitions.
·
Setup Security
Role Definitions for Balanced Scorecard.
·
Collaborated
closely with PeopleSoft Global Support in identifying possible issues with the
delivered product.
·
Identified and
created “work-arounds” for enhancements to the “out
of the box” product.
PeopleSoft
Inc.,
Senior Consultant: Bonneville Power Administration,
Technical
Lead for EPM/Budgeting 8.8 implementation.
·
Successfully
managed technical aspects of implementation from fit gap to go live which lead to
a successful implementation and client satisfaction.
·
Developed Informatica ETL Maps and Data Loader definitions as
specified by the client’s requirements.
·
Developed
customizations in PeopleTools as necessary (Views,
Indexes, App Engine, etc.)
·
Created numerous
deliverables as necessary (Technical Team Project Plan, End to End Document,
Test Scripts, SQL scripts, Issues and Resolution Document, Problem Log, Informatica Environment Management Document, Migrating
Metadata Between Environments, etc.)
·
Created Reconciliation
process (SQL scripts, Word Doc, etc.) in order to identify the accuracy of the
results.
·
Identified
bottlenecks in the Informatica ETL and Data Loader
process and tuned as necessary resulting in a decrease of over 200% processing
time.
·
Performed DBA
activities including monitoring lock levels, contention possibilities,
conducting explain plans as necessary, etc.
·
Worked closely
with development in order to ascertain whether the functionality of the
Budgeting Module was processing the data correctly - assisted in creating hot
fixes.
·
Created all
scripts as necessary including SQL, datamover, tree
mover scripts, metadata migration, etc.
·
Assisted in
production cutover process including the plan, deliverable, process, and effort
involved.
·
Facilitated and
conducted numerous meetings in order to drive a successful Budgeting
implementation.
·
Provided Go Live
and post-production support to insure a smooth transition with a new product.
PeopleSoft
Inc.,
Senior Consultant:
Lead Technical Consultant,
member of SWAT Team for tuning Time and Labor product extensively.
·
Resolved
deadlock issues on Microsoft SQL Server 2000 and also temp table allocation
issues.
·
Provided
suggestions as to how to facilitate faster Time Administration processing on
the application and database level (including setup/configurations and
statistics, indexes, identifying bottlenecks, etc.)
·
Identified
problems and issues with Prior Pay Period Adjustments and provided possible
solutions to remedy the issues.
·
Trained both
Administrators and Users on site to efficiently use their Time and Labor
system.
PeopleSoft
Inc.,
Senior Consultant: State Farm Insurance,
Lead Technical Consultant,
member of SWAT Team for tuning Time and Labor product extensively.
·
Successfully
processed 80,000+ employees in a 1 hour 15 minute elapsed time period by
concurrent/parallel processing (including functional and technical setup and
analysis) which before tuned took in excess of 40 hours.
·
Tuning efforts
included: seating tables with necessary data, conducting runstats,
row level locking on specific tables, partitioning tables, setting lock
escalation parameters including lock wait, etc., conducting explain plans,
checking bufferpool and system resources, analyzing
initiators and bat priority level, and more.
·
Analyzed access
paths taken by specific SQL, created additional indexes as necessary, and tuned
SQL where necessary.
·
Created JCL’s, test
data necessary, and initiated jobs to facilitate testing; used Omegemon and Ejes to monitor jobs
initiated.
·
Analyzed and
tuned online pages to be efficient in performance when many users
(15,000-20,000) are accessing the same page.
·
Analyzed,
evaluated, and reconfigured existing setup of App Server (6) and Web Server (3)
and tuned as necessary.
·
Created and
analyzed reports from Silk Performer (Performance Tool) and tuned the App
Server as necessary which involved monitoring the performance of the App Server.
·
Conducted and
led several meetings, including the functional team, DBAs,
and technical team.
·
Managed two
technical teams (performance and application) resulting in a successful
engagement because all “show-stoppers” and major issues were resolved.
·
Knowledge
transfer conducted for migration of updates, patches, and fixes to multiple
environments.
·
Created and
maintained several deliverables and reports for the management team.
PeopleSoft
Inc.,
Staff Consultant: Latter Day Saints Church,
Lead Technical Consultant,
member of SWAT Team for extensive tuning Time and Labor product.
·
Tuned Time and
Labor Module on the Oracle Database; eliminated the parsing memory overheard
(App Engine) by taking advantage of cursors, created Indexes where necessary,
and identified the slow running SQL statements.
·
Changed tablespace setups as necessary to optimize performance.
·
Discovered
issues with current customizations and suggested and delivered recommendations
to address these issues.
·
Closed all GSC
cases by resolving all issues and problems on site in a timely manner.
·
Applied bundles
of fixes, patches, and updates to all environments include demo, development,
and test including table changes, build scripts, and COBOL.
·
Determined why
the payable time created in Time Admin was not appearing in Payroll (PeopleSoft
8).
·
Setup demo,
development, and testing environment including the web server, app server,
process scheduler, and database server.
·
Evaluated
current setup, then validated proper setup of Time and Labor, and also
identified incorrect setup issues that were affecting the performance of the
processes.
·
Rule setup
analysis conducted including the rules, rule templates, and rule programs. Also troubleshooted
any rules as necessary.
·
Conducted
presentations and administered training as necessary which covered the Time and
Labor Performance enhancements, Debugging App Engine processes, and parallel
processing.
·
Identified
missing tables, indexes, and temp table instances. Rebuilt scripts and fixed as necessary.
·
Created DMS
Scripts, Test Scripts, and all Test Scenarios as necessary.
·
Fixed Run Time
Statistics (RSL) to function correctly.
·
Achieved run
time of 15 minutes processing time for 6300+ employees with parallel
processing, a reduction of 120% in processing time.
PeopleSoft
Inc.,
Staff Consultant: Western Wireless,
Lead Technical Consultant,
member of SWAT Team for tuning Time and Labor product extensively.
·
Tuned Time and
Labor Module on the Oracle Database; eliminated the parsing memory overheard
(App Engine) by taking advantage of cursors, created Indexes where necessary,
and identified the slow running SQL statements.
·
Developed better
ways of setting up the development/test/stage/training/production database
environments and made suggestions on improvements to reduce bottlenecks and
inconsistencies within the environments.
·
Conducted basic
training to technical staff on optimizing and tuning SQL statements, how to use
Oracle’s TKPROF utility, Oracle’s Explain Plan, Hints, Hash Joins, etc.
·
Worked closely
with the DBA in insuring statistics were being done on the database regularly.
·
Identified
relevant processing tables and determined if they were being updated correctly
based on the Time Admin process.
·
Identified the
slow running App Engine steps and tuned as necessary resulting in at least a
50% increase, and as much as 80%.
·
Conducted tests
to insure that Payable Time was being created correctly based on the setups of
the Rules and groups setup by the client, including prior pay period.
·
Created test
scripts to validate the Time Admin process for Elapsed, Punch, and Exceptional
Time Reporters.
·
Created Database
Import/Export scripts to allow test scripts to run more efficiently with
multiple iterations.
·
Created several
deliverables including: Change Tracking Document, Tuning Performance
Guidelines, App Engine Time Admin Process Details, etc.
PeopleSoft
Inc.,
Staff Consultant: PeopleSoft Product Development QA,
Lead Technical QA Analyst
for product development that would be used to upgrade all PeopleSoft CRM
customers.
·
Revised and
tested the “smoke test script” to document any bugs and fixes needed for the PeopleCode, App Engine processes, SQL statements, and more.
·
Created test
scripts for all possible scenarios using the Meta Data - Extraction
Transformation Load (ETL) Tool for all the database environments including SQL
Server, Oracle, DB2 Unix, and DB2 OS390.
(For use by the internal department and automation team)
·
Setup and
maintained the DB2 O390 testing environment by updating projects, applying “hot
fixes”, building tables and views, and anything else necessary to insure both
Databases A and B stayed current and running.