Oracle Project

Christie Y. Wang-Banerjee

******@*****.***

408-***-**** (M)

Experience Summary

Functional/Technical Analyst Specialized in Oracle EBS

• 16+ years of hands-on functional/technical experience in Oracle HRMS Suite,

Oracle Financials (AP, AR, GL, CM, iExp), and Oracle Manufacturing (PO,

INV, Cost, BOM, OM, iProc, iSup) modules. Extensively engaged in A2H2T

(Applicant to Hire to Term), P2P (Procure to Pay), O2C (Order to Cash) full

implementation cycles, as well as a couple of major system upgrades.

• Currently undertaking Oracle Financials R. 12 training (July thru August).

• Ability to excel in organizations large (IBM, Oracle, VMware), medium (Xilinx) and

small (Synaptics) as a global cross-functional team lead exercising good

communication & interpersonal skills, strong problem solving and analytical skills,

smooth group collaboration skill, and high levels of initiatives.

• Proficient in AP, PO, AR, GL, CM, iExpense, iProcurement, iSupplier, HRMS

(Core, SSHR, CWB, iRecruitment), OM, Alerts, Workflow, AME, etc.

• Experienced in requirement gathering, system analysis & design, design review,

process flow analysis, gap analysis, implementation, upgrade, Project

Management, configuration, support, maintenance, testing, development,

customization, patch application, documentation, building interfaces or extensions,

conversion, system administration, data fixing, bug tracking, month-end-closing,

problem-solving, and other consulting functional and technical activities.

• Knowledgeable in advising global Finance and HR groups in their automation

needs by providing various feasible options.

• Knowledgeable in Semiconductor chip product making process and CM (Contract

Manufacturer) Business Model’s impacts on Oracle Application’s system designs

and configurations.

• Familiar with SDLC (Software Development Life Cycle) methodology and SOX

(Sarbanes-Oxley) security compliance standards and audit control procedures.

Some knowledge in full project life cycle management and IT development life

cycle management.

• Experienced in facilitating business process workshops, creating business

requirements documents, business process flows, functional specifications, use

cases, and test plans. Self-motivated with an ability to work with minimal direction

in a complex and dynamic environment to drive consensus amongst diverse

business stakeholders.

• A strong team player with good written, verbal communications and leadership

skill. Experienced in working in a global environment with cross-functional teams

and out-sourcing service providers.

___________________________________________________________________

Skills Synopsis

• Applications

Oracle HRMS (Human Resources) – Core HR, iRecruitment, HR Self Services,

Compensation Workbench, Fast Formula, Approvals Management (AME);

Oracle Financials - AP, AR, GL, FA, CM, iExp; Oracle Manufacturing - COST, INV,

BOM, PO, OM, iProcurement, iSupplier; Oracle Alerts, Oracle Workflow, System

Administration, OIM, and AOL, etc.

• Tools

Oracle RDBMS 10g, SQL*PLUS, PL/SQL, TOAD, SQL*Loader, Discoverer Plus,

Discoverer 6i, Reports 6i, Agile ITCO; Kantana, Service Now, Success Factor,

Clarify, Zimbra, Microsoft Excel, Microsoft Exchange, Microsoft Outlook, and

Microsoft PowerPoint etc.

______________________________________________________________________

Professional Experience

VMware Inc., Contractor, Sr. Business Systems Analyst (Dec 2010 – July2011), Palo

Alto, CA

.

• Successfully managed HR Comp CWB projects. Designed, configured,

implemented, and administered Oracle CWB (Compensation Workbench) tool for

2010 H2 Bonus Review, 2011 Focal Merit/Adjustment Review, and 2011 H1 Bonus

Cycles on Oracle R.11.5.10 HRMS Suite for 20 plus currencies/countries.

• Familiar with using Oracle Fast Formula and OAF web page personalization

technology.

• Closely worked with, advised, and supported HR Comp and HRIS teams.

Provided various reports, and advised HR Comp and HRIS teams on best

practices of Oracle EBS system, tool, reports, or software usages.

• Assisted in running daily integration jobs from Workday to Oracle HRMS and

Investigating/resolving data reconciliation issues related to the integrations.

• Assisted in resolving all Oracle HRMS related trouble tickets and VMware custom

on-boarding/ex-boarding HR2R and XR2R application related problem cases.

• Supported all Oracle HRMS Core problem issues and problem resolutions.

• Wrote SQL scripts to generate various reports in response to users’ ad-hoc

requests, or to aid in problem analysis and resolutions.

• Worked with HR Comp and HRIS users on finalizing their BRD (Business

Requirement Documents) and in turn created and submitted IT FRD (Functional

Requirement Document) for approvals.

• Guided or consulted with developers on technical developments in fulfillment to

FRD’s technical specs. Assisted in development, development testing, QA testing,

QA sign-off documentation, deployment stage monitoring, thru go-live.

• Managed RFC (Request For Changes) cases thru CAB review and release

deployment; Created test cases and initiated and managed change migration steps

to ensure a strict adherence of the SDLC methodology.

• Organized cross-functional team meetings and UAT testing meeting to cover

changes impacting HR or Finance to ensure a successful data migration or system

implementation.

• Delivered planned projects and solutions on time and within budget.

Synaptics Inc. – Sr. Business Systems Analyst (Sep 2006 – Sep 2010), Santa Clara,

CA

• Worked with consultants to implement the whole Oracle EBS suites successfully

from scratch.

• Implemented and refined a complex quarterly cost update process.

• Implemented Oracle R.11.5.10 HRMS Suite (CoreHR, SSHR, iREC, CWB, AME

Modules) successfully from scratch. (Note: involved in an intensive and extensive

process of requirement gathering, data analysis, mapping, migration, conversion,

validations, system design, configurations, setups, CRP & UAT testing, web page

personalization, report analysis and Discoverer report development, etc.)

• Designed and implemented various PO/OM drop-ship alerts for logistics teams.

• Supported Purchasing, Procurement, Inventory month-end closings and

reconciliations.

• Interfaced with various levels of the organization globally (US and APAC) as the

main IT Inv-Fin-Hr analyst. Oversaw business requirement gatherings, gap

analysis, all issues’ trouble-shootings and resolutions, business process

improvements and enhancements, user trainings, etc.

• Lead cross-functional efforts to bring Inventory, Finance, HR users, and/or IT Help

Desks together to identify, discuss, or solve issues or finalize a strategy for future

enhancement directions, efforts, or approaches.

• Advised various groups of Corporate users on effective or best-practiced Oracle

application usages and helped shape up some policies, procedures, and

directions.

• Went thru a couple of major upgrades, integration testing, and integrations.

• Logged and monitored TARs with Oracle to solve issues and bugs; Worked with

DBA’s and AT&T (external ASP) to analyze and implement system patches and

upgrades.

• Wrote numerous Inv, Finance, HR Alerts and Discoverer reports.

• Supported, maintained, provided root cause analysis and resolutions to issues,

documented a complete iRecruitment to Core HR hiring-cycle procedure guide,

and trained global users. Involved in countless issue analysis and resolutions,

user hand-holding and coaching, and data fixes,

• Supported and resolved daily Core HR, iRecruitment, SSHR, AME Workflow, and

CWB issues.

• Wrote various SQL scripts to generate reports for IT Helpdesk’s user account/

responsibility analysis, Internal audits and SOX audits.

• Performed various configurations, setups, or system administration functions.

• Managed various enhancement or implementation projects from design phase to

completion. (For example, Completely revamped HR New Grade and New Job

Title Structures to aid in providing a better Salary Management functionality, etc.)

• Worked with external consultants to enable the iRec external job posting

functionality.

• Maintained and supported a Hyperion HR Extract Interface Program for FP&A

group. Also maintained an Oracle-ADP Interface Program for Payroll group.

• Helped Design and Implement an automation process for massive iRecruitment

Requisition Vacancy Loads/Updates from back-ends.

Xilinx Inc. - Staff Information Systems Analyst (Sep 1997 – July 2006), San Jose, CA

11i Production Support For Oracle Financials and Manufacturing

Modules (Apr 2002 – July 2006)

• Modules - AP, GL, AR, CE, PO, Cost, Inv, BOM, OM, Self Service, iExp, QIS,

Workflow.

• Implemented a new Subsidiary Web Expense (i.e. a JP operating company.)

• Month-end Support including Data fixes or Interface Table transaction cleanups.

• Helped re-design, test, and maintained a custom COGS Trigger and resolved

issues.

• Resolved various performance/ tuning issues related to COST/BOM tables.

• Designed/ Coded and maintained Discoverer reports. Performed Discoverer

System Administration functions.

• Wrote various Oracle Alerts.

• Resolved Workflow issues (QIS and iExp); Added minor customizations.

• Fixed Daily OM issues related to E-commerce Stuck Orders or Pricing Hold.

• Identified/ tracked/ resolved Bugs for 11.5.9 upgrades (Cost, QIS, RMA, AP);

Coordinated/ tested new features; Applied patches.

• Completed final integration testing; Assisted in OM, QIS, & RMA data fixes.

• Analyzed, resolved QIS & RMA custom program performance issues.

• Advised on J-Initiators, Web Browsers, Discoverer configuration conflict issues.

11i Implementation Project For Oracle ERP Apps (Jan 2001 – Apr 2002)

• Involved in AR, AP, CE, Cost, Inv, PO module R 11i (11.5.7) implementations.

• Planning, Analysis, User Requirement Gathering & Gap Analysis; Business

Process Flow Analysis and Documentation; Data Mapping & Conversion;

Integration Testing; System Upgrade/ Migration; Application Setups.

• Involved in a project for a custom Product Line/Sub Account Override Costing

Trigger and a custom COGS Account Generator Workflow.

• Wrote various reports (PPV, IPV, Elemental Cost, CM COGS GL Load, Inventory

In-transit Reports etc.)

• Designed a functional solution on reporting PLINE item category for all item types;

Compiled, mapped, and loaded inventory item categories into INV.

• Did INV setups for some KFF and DFF value sets, and item templates.

• Post go-live problem resolutions for Oracle Financials, Costing, BOM, INV, and

some OM.

• Participated in system requirement validations for multi-org issues (i.e. Inventory

orgs and Operating Units).

• Implemented 11i Cash Management module from scratch.

• Participated in INV Item change planning’s design and process flow analysis

activities for an item nomenclature change project.

Cost/INV/BOM/PO/OM Production Support (2001 – 2004)

• Supported month-end close including fixing unprocessed, un-costed stuck material

transactions; identifying transactions causing GL posting unbalances; researching

items with wrong product lines causing account validation problems.

• Analyzed, resolved stuck transactions caused by various external extension

systems including receiving (PO), shipping (OM), and other custom applications.

• Developed/ maintained various custom reports.

• Designed/ developed 4i Discoverer reports.

• Involved in Setups of account assignments for all orgs; Merging several sub-

inventory charge accounts into one.

• Monitored interfaces from external extensions.

• Maintained custom COGS and Product Line override trigger.

• Implemented two Cost Purge cycles achieving 25GB of disk space saving on BOM

tables.

AP Payment Automation (via Bank of America) Project (2001 & 2005)

• Implemented a custom payment-outsourcing AP extension by combining Oracle

UTL_FILE utility, EDI-824 formatting, PGP encryption software, FTP gateway,

PL/SQL procedures, C-Shell Mains, Oracle DFF’s, Alerts, and various techniques..

Other Misc Projects:

• Converted items from one old org to multiple new orgs for a third party logistics

project . Wrote programs to do item conversions. Used Item Interface programs

and other custom extensions to load and propagate many item attributes. – (2000).

• Implemented an iExpense module on Oracle10.7.0 – (2000).

• Supported and maintained AR, AP, Cost, GL, PO, INV modules on Oracle 10.7.0 –

(1999-2000).

• Upgraded AR module from Release 9 Database and merged it into an existing

10.7.0 Database where other Financials modules resided. – (1999-2000).

• Wrote PL/SQL scripts to implement AR receipt conversions by using AR Lockbox

interface programs for both upgrade and data base merge.

• Performed major upgrades from 10.6.0 to 10.7.0 on AP, PO, INV modules.

Oracle Corp – Worldwide Application Support Analyst (AR) (Mar 1996 – Sep 1997)

• Wrote test scripts; Logged bugs; Analyzed & Solved AR TARS; Closely teamed up

with developers; also worked some on AOL, AP, Sales & Marketing modules.

Orange County of Florida – Senior Programmer/Analyst (July 1993 – Mar 1996)

• Developed/ maintained the County Utility Billing System (COBOL, DB2, CICS).

GTE Corp. Tampa Data Center– Contract Programmer/Analyst (Feb 1992 – Jan 1993)

• Extensively maintained the GTE’s Telephone Billing System (COBOL, DB2).

IBM Corp – Systems Engineer in National Account Marketing Division (Feb 1985 –

Feb 1990)

______________________________________________________________________

Education

• M.S. in M.I.S. with a second major in Accounting from Texas Tech University,

Lubbock, TX.

• B.S. in Zoology with a minor in Business from National Taiwan University.

Contact this candidate