PING-LAN Y. TREY ***-** **rd Avenue( Bayside, NY *1364 718-***-****

( acfwyg@r.postjobfree.com

SAP SYSTEM ANALYST

Skilled System Analyst with over eight years of experience with SAP

Business Warehouse (BW), Business Objects (BO)

and Oracle Database. Effective Subject Master Expert (SME) with the

ability to oversee technical projects to

specification and according to schedule, while increasing efficiency.

Experienced with System Development Lifecycles

(SDLC), BEx Analytics, BOBJ, SQL, Qlikview, certified in Oracle DBA and

Java Programmer. Fluent in Chinese (Mandarin).

TECHNICAL SKILLS

Hardware: AT&T and IBM PC, Macintosh

Network: LANs and WANs

Languages: ABAP, C/C++, FoxPro, C#, Java, Oracle 8i/9i/10g/11g SQL and

PL/SQL

Operating Systems: Linux, Unix/Solaris and Windows

Applications: SAP, Business Object/Business Intelligence, QlikView V11,

TOAD 11.0, Oracle Report Developer 9.0, MS Office.

PROFESSIONAL OVERVIEW

SAP System Analyst

2006-2014

Forest Laboratories Inc.

. Built and enhanced the BI metadata object repository including

Infocubes, DSOs, multi-providers and infoset to meet reporting needs

in SAP Sales systems.

. Extracted data; developed and enhanced codes (ABAP coding and

debugging) in transformation routines including transfer and update

rules, process chains and user exits.

. Developed data flows and BW data models to support the loading data

process into BW info-providers to translate business requirements into

Business Warehouse (BW) and Business Objects (BOBJ) solutions.

. Created BEx queries for feeding data into SAP BOBJ platform.

. Developed and delivered BOBJ platform solutions including Universe

Designers, Web Intelligence (WebI) reports, Dashboards (Xcelsius) and

Crystal Reports analysis.

. Created flash reports using Bex Analyzer to create workbooks including

BEx queries (using Query Designer) and broadcasters to be automated

and scheduled in process chains.

. Experienced with the Systems Development Lifecycle (SDLC) including

working closely with business users to gathering requirements and

business rules, implementations, unit testing, data validation and

deployment; provided production support.

. Documented business requirements (UFRS) and designs (SDS) .

. Worked on the development process of Institutional sales forces DDD,

Cycle Materials for realignment for new products and markets launches,

Goals, Incentive Compensation and President's Club systems and reports

for all sale forces.

. SAP Netweaver/BOBJ portal administration including creating iViews,

worksets, roles and transport packages (epa files) for BOBJ (WebIs

and Dashboards) and non-BOBJ portal applications for developers in the

team and also other teams.

. Troubleshooted and resolved technical issues; performance tunning.

. Worked closely with SAP Basis and Security teams to resolve

DEV/QA/Production issues and to optimize performance.

. Was the only developer in the team with hands-on experience in

designing and developing BOBJ platform.

. Worked independently and as part of a team; always met project

deadlines and delivered accurate and quality results.

. Lead team and consultants on business and technical (BW and BO) on

realignment projects.

. Analyzed, designed and implemented ad-hoc projects for managers.

. Worked on SAP ECC, SAP CRM, SAP BPC, SAP BW/BI, QlikView and BOBJ .

. Converted FoxPro programs and reports to Oracle by creating packages,

procedures and functions using SQL, (dynamic) PL/SQL, Toad and Oracle

Report Builder.

Oracle DBA

2004-2006

Compu21

. Used SQL and PL/SQL to create stored procedures, functions and

packages.

. Completed backup & recovery which included maintaining distribution

database, performance and SQL tuning.

Programmer 2003-2004

New Concept

. Developed and designed a multi-tier online shopping cart that included

a presentation, business logic and data access tier.

. Programed user authentication and authorization, new customer

creation, web front store and save order.

. Used Java, JDBC, JSP/Servlet, HTML, Java Script and JBuilder to

develop, debug and deploy.

EDUCATION

Master of Computer Science - Stevens Institute of Technology, New Jersey

CERTIFICATIONS

Oracle Database Administrator Certified Professional

Certified Java Programmer

Contact this candidate