Project Technical Support

Elaine Y. Zheng

Cell: 312-***-****

Address: **** *. ******* *** *******, IL 60608

Email: **********@*****.***

Objective Apply for the Finance Systems Lead position.

Statement of Qualifications

I am an expert in financial analysis and information technology and finance. I have worked on many projects include working on such as Enterprise Resources Planning (ERP) systems including Oracle, PeopleSoft, Hyperion, Essbase, Siebel CRM, Lawson. I manage and conduct internal and external audits. I manage external outsource consultants, vendors and contracts. I am involved in many projects which include Software Development Lifecycle (SDLC), testing and requirement gathering for various applications.

Education University of Illinois at Chicago

Bachelor of Science

Majors: Management Information Systems and Finance

Skills

Languages: C, Visual Basic, Java, SQL, PL/SQL, SQL plus, HTML, JavaScript, Siebel,

and Webfocus

Database: Oracle, MS SQL, Access

OS: MS-DOS, UNIX, and Windows 9x, NT, 2000, 2003 and Windows 7

Applications: Microsoft Suites, Outlook, Access, DreamWeaver, Photoshop, Visio, MS Project and SharePoint, MainFrame Environment, Peoplesoft HRMS, CRM, Lawson, SAP-BPC

Training: PeopleTools I, II VS. 7.5 & 8.1x, Structure Query Reports, PeopleSoft 8.0 Delta, Siebel Essential 7.5, Siebel Case Study 7.7, Siebel 7.7 Migration, and Siebel Escript, Actuate Reports, Essbase, Hyeprion, Smartview

Experience

Chicago Transit Authority

Financial Systems Administrator III 4/2013 – 9/2017

Manages and maintains day to day operation of Hyperion application tool to

support budget and financial planning initiatives throughout the organization.

Administers system applications, databases and security for Hyperion and support department users.

Provides support on month end closeouts, forecast, human capital and expense and

revenue analysis and support in Hyperion application.

Evaluates, enhances and improves system functionalities and efficiencies.

Assists with budget preparation and financial reports and transactions via Hyperion Planning and Reporting application.

Implementation of system upgrades to 11.1.2.3 and patches. Evaluates system modifications and user enhancement requests. Updates metadata and performs data updates, and data validation.

Maintains system security and grants user access to system. Migrates data between various environments. Reviews and updates Business rules.

Updates and creates new financial reports and SmartView reports. Provides research and analysis for budget preparation.

Liaises with Technology, Oracle, and vendor to provide technical support for system users within the department and other departments such as payroll and accounting.

Manages task list with Oracle host management, create Oracle service request

and request to change tickets.

Manages Oracle off-shore consultants and Oracle contracts.

Worked on integration project Oracle EBS R12 and Hyperion. Successfully integrated Oracle Human Resources and Oracle General Ledger to Hyperion.

Run SQL queries for position data, inventory files and audit information.

Worked with both internal and external auditors to audit overall systems and financial data.

Conduct training on Hyperion planning workspace, SmartView and overall budget process to department users.

Create, manage and perform system/integration testing activities for releases,

upgrades and patches.

Created technical and functional documentations for user reference and training.

Update and manage SharePoint website documents for the department.

CareerBuilder Corporation, Chicago IL 4/2012 – 01/2013

Financial Systems Analyst II

Supported various accounting teams including Tax, Accounts Receivable, Accounts Payable, Revenue, Sales Incentive, Financial Planning and forecasting, and International finance and accounting.

Maintained and troubleshot applications such as Lawson financial, SAP-BPC10, ImageNow, Document Express, SharePoint, and Velocity. Worked with vendors to resolve issues.

A key participant in system implementations and upgrades; Developed and lead UAT

activities with end users to support release of new versions or functionality, such as

upgrade SAP from BPC7 to BPC10 and update to Lawson LSO.

Wrote database queries Microsoft SQL and Microsoft SSRS reports.

Prepared for periodic security review quarterly audit by Ernst and Young. Responsible for systems security and audit requests for Sarbanes-Oxley compliance. Sent management

financial systems reports to ensure up-to-date security access for users and groups.

Developed and maintained Finance SharePoint sites such as developed new wiki libraries,

pages and maintain user security access.

Provide financial system support during month-end close.

Investigated and identified root causes of errors. Re-engineer processes using lean

methodology to ensure that client needs are met.

TransUnion Corporation, Chicago IL 08/2010 –4/2012

Data Engineer

Setup financial credit data information to financial institutions in a timely production

environment by executing in batch fulfillment systems in both a mainframe and web based environment.

Collaborate with Technical Consultants on translating system designs into system

configurations. Review specifications, interpret and code criteria and backend using JCL, SynSort and others data systems to furnish credit data to customers.

Develop and execute test plans, and validate batch fulfillment system setup and output data, develop and validate reporting output, audit forms, final static and make sure data flow and

data accuracy.

Analyze data during all steps of the setup to ensure integrity, troubleshoot and resolve

issues that occur.

Write up summaries and sent email notification of marketing promotions to customers.

Ensure data are ready for customer download in timely manner as indication in customer

order specification letter.

Audit test results, and ensure desired output is attained and validate data accuracy before

jobs are submitted.

Health Care Service Corporation, Chicago IL 03/2008-6/2010

Technical Support Specialist

Managed and supported PeopleSoft HRMS system, was the liaison between IT, HR,

Finance, Payroll and external Venders such as ADP, Northern Trust and others.

Documented requirements, created test plans and scoped documents for various

projects such as PeopleSoft upgrade implementation team from version 8.8 to 9.0.

Ensured PeopleSoft HRMS systems met customer satisfaction by creating queries, reports,

and analysis and researched production issues, logged Oracle cases, logged Clear Quest defects and assisted various functions in both business and technical aspects through support and technical related inquiries.

Supported PeopleSoft Time and Labor and North American Payroll, biweekly payroll for over 16,000 exempt, nonexempt and union employees in production and various environments.

Lead tester and support person for projects such as W-2, Tax Updates, Time and Labor bundle update, Union bonus, Payroll releases and other projects in various environments before project migrate to production.

Followed SDM methodologies for project implementation for all projects test life cycles, made sure project deliver on time within budget.

Pepsi Americas Corporation, Schaumburg IL 05/07 –02/08

PeopleSoft Application Developer

Developed PeopleSoft applications using PeopleTools, Application Designer including projects such as Holiday Alerts, Update Delivery on Off-Week Orders, Product Alerts for Same Size Orders, Customer Order Minimums and Product Promotions.

Create and maintain views and tables in Oracle and PeopleSoft databases and served as administrator to grant access to views and tables.

Technical support on all PeopleSoft technical issues supports all daily run application

engine jobs and SQR Reports.

Support clients in call center for all promotions and marketing of new product launch.

Support and maintain development, test, conversion and production environments.

Develop technical and functional documentations, PeopleSoft security, project migration and other documents on projects, and present to Change Control Group for major project migration.

Worked with individuals from various functions/levels includes business partners, users, IT

teams and business analysts to make sure projects are successful deliver on time on budget.

Provide unit and system testing on applications, enhancements to existing applications and fix bugs and errors.

Empire Home Services LLC, Northlake IL (Contract work) 05/06-10/06

Process Improvement Analyst

Gathered requirements for large-scale Siebel Analytic reports for various business functions including Order Management, Service Order, Cash Management, Order Fulfillment and Incentive Compensations. Identified Standard Operating Procedures, current and future process maps to improve business processes for Human Resources, Payroll and Company.

Allstate Insurance Company, Northbrook, IL 03/02-05/06

Application Developer

Worked on Siebel CRM application developments, technical documentations, unit and system testing, fixing product defects and maintaining and developing Actuate reports and Webfocus reports.

Implemented Siebel projects such as Allstate Recovery System, Risk Management Business Center, Call Centers, Campaign Management Siebel upgrades and other projects for various departments and Agencies.

Provide technical and functional inputs of unit test plans, requirements, and project estimations, project risks to testers, business analysts, project managements, end users and fellow teammates on project implementations. Responsible for the functionality of applications in

various environments such as development, system test, performance, and production.

Ensure accurate project estimation through resource allocation and project costs by meeting milestones and delivery dates.

Work as configuration manager to ensure all projects are Capability Maturity Model (CMM) level two compliance by meeting customer satisfactions and enable project process improvement.

Served as main coordinator in the team to maintain and implement disaster recovery planning and business continuity planning. Document backup plans, softwares and hardwares and

contact list and test emergency call trees in LDRP application.

Data and Reporting Specialist

Worked in Personal Line Finance department to develop financial reports such as agency revenue, expense and forecast reports for management, financial analysts and field agents by using applications such as Web Focus, Microsoft SQL, HTML, Javascript and Essbase.

Modified and manipulated data on Microsoft SQL, Access, Excel, Essbase and DTS.

Assisted in troubleshooting, supporting and solving problems on reports requested by clients.

Effectively interacted with individuals from various functions/levels. Interviewed clients to gather requirements. Transformed business needs into technical specifications.

Tested data and applications to ensure accuracy delivery of data and information for analyst.

Created documentations and help files on developed applications.

Managed reporting projects from the beginning to the end of the project life cycle.

Diagnosed issues and analyzed trends to explain and strengthen understanding of financial results.

Cap Gemini Ernst & Young LLP US, Chicago, IL 6/00 –5/01

Staff2 Consultant

PeopleSoft 8.1x

Developed a Service Tracking Database in PeopleSoft 8.12 using PeopleTools, Application Designer, PeopleCode and Crystal Reports to track technical and client request problems.

Helped to win a multi-million dollar client project by helping debug SQR’s and SQC’s in PeopleSoft 8.12 demo before presenting to client.

Researched PeopleSoft technical infrastructure, test cases, technical tools, security usage in client project.

Completed HRMS 8.12 Manager, Employee, and External Applicants eRecruit test cases for client demonstration and documented all test cases for client use.

Helped client develop standard Dunning Letter Crystal Reports for aging AR Billing.

Assisted clients in developing standard documentation and troubleshooting technical issues relate to SQL, Data Mover Script, import manager, application designer, and application

engine.

Developed and revised the application to increase the performance of the Payroll SQR.

Vision Care (PeopleSoft HRMS and Finance Implementation) PeopleSoft 7.5

Developed and Troubleshoot Lotus Notes application for Project Management Office, which involves tracking of project technical and functional issues.

Developed aging Crystal Reports and SQR Customer Account Sales reports to track billing inquiries of international clients.

Assisted clients on troubleshooting on technical issues and application development in

relates to PeopleSoft PeopleTools, application engines, PeopleCodes, Panels, crystal

reports and SQRs.

Debug PeopleCodes in PeopleSoft debugger to make sure is bug free before signing to production.

Healthcare (CRM Implementation, PeopleSoft Assessments)

Completed technical specification for wage verification and wage statement reporting.

Performed as a Project Management Analyst role to assist with the project Kick-Off

Presentations and Documents, create Welcome Packet, Project Charter, Project

Templates and assistant management with project planning and budgeting on

consulting hours and expenses.

Setup project management tools “Project Gateway” and instructed team members

on how to use the tools and documented it as reference source for users.

Contact this candidate