EXPERIENCE SUMMARY

is a professional BPM Engineer/Information Architect/DBA in the Enterprise Application Practice such as ERP, CRM, SOA and BPM. She has very rich experiences in various industry segments including Oil & Gas Service, Consultant Firm, Bank, Telecom, Financial and Economics. She has strong hangs on experience with software installation, maintenance, capacity planning, performance evaluation, upgrade and migration, as well as replication. Her industry exposure is in BAO/BPO.

EDUCATION
MS in Computer Science
BS in Industrial Electronic

CITIZENSHIP US Citizen

SKILL SET:
System: UNIX(AIX, Solaris, HP), Mainframe Linux/Intel Linux, DELL/EMC SAN, Tivoli, Windows(NT/2000/XP), VMWare, Apache, VPN, ESB
Database: Oracle8i/9i/10g/11g, MS SQL2005/2008, DB2, MS Access/Excel, ETL
Languages: JAVA/JDBC, J2EE/ESB, Javascript, C++, SQL, PL/SQL, Shell, HTML, XML, ODBC
Applications: SQL*Plus, OWB(Oracle Warehouse Builder), grid control(OMS), RMAN, Oracle Data Guard, Oracle RAC, ASM, Streams, Arcsight, Remedy, Oracle ERP, FTP, telnet, Erwin/Rational Rose, Websphere WMQ, Lotus Notes, PowerPoint, Putty, TOAD, MacAfee, MS Visio, MS project manager, Quest SportLight, WinSCP, Track-IT, IBM Symphony, WegLogic, IBM BPM 7, Golden Gate

Confidential, TX 05/11 - 08/11
Role: consultant BPM engineer with IBM BPM Advanced 7.5

• Coordinate and participate in activities related to BPM process design, build, test and deployment.
• Installation, configuration and administration of IBM BPM Advanced 7.5.
• Perform routine administrative tasks including snapshot and toolkit deployments, user/group management. Experience with Blueworks.
• Support daily monitoring of the BPM infrastructure and application performance.
• Creating BPD with playback included services creation, activities implementation, variables assignment, triggers and Coaches creation.
• Hands on experience with SQL, PL/SQL, XML, HTML, JavaScript.
• Management and troubleshooting both BPM application and Oracle databases.
• Knowledge of the IBM BPM and SOA product stack including WebSphere Application Server, ESB, Process Server, Modeler, Monitor, iLog etc.
• Strong knowledge in IBM BPM Architecture.

Confidential, TX 01/11 - 04/11
Role: consultant BPM system admin/developer with Oracle 11g database

• Installation, configuration and administration of WLE 7.2 with Oracle 11g, jboss, WebSphere application server/apache on windows and Linux/Unix.
• Master WLE 7.2 Topology, and deploy WLE 7.2 in various environments such as DEV, QA, and Production with its integrated systems.
• Lombardi infrastructure administrative tasks including maintenance releases, starting/stopping servers, performance analysis and tuning of Lombardi Teamworks.
• Support 24x7, working with Lombardi support for good troubleshooting in needed.
• Hands on experience with authoring management in user/group, import/export processes, deploying/promoting snapshots.
• Good knowledge of Modeling Business Processes for Lead Management, Opportunity Management, and Order Fulfillment using Lombardi Blueprint (WLE - Lombardi7).
• Experience of load balancing, clustering and failover.
• Enjoy to lean new technologies and pickup it quickly.

Confidential, TX 11/10 - 12/10
Role: Consultant of an Oracle Application DBA in Confidential

• Troubleshooting Oracle E-Business Suite R12/11g Finance via Track-IT.
• Working with Oracle support for Oracle E-Business Suite R12 bug.

Confidential, IA 06/10-10/10
Role: Consultant of an Oracle DBA in Confidential

• Developed automatically software applications for B2B, B2C and C2C applications on SAP, CRM, SOA with SAS and ROI.
• Ability to understand business requirements, map them to the solution and deliver relevant and compelling demonstrations.
• Experience in Marketing Automation such as campaign management, email marketing and database marketing with plan, execution, measurement and analytics.
• Identification and elimination of *root cause* problems in application SaaS and cloud environment, experience in data analysis and reporting.
• Installation VMware on Windows XP.
• Implement monitoring in database alerts, file systems, listeners and database status on more than 300 servers, 780 oracle databases in 9i, 10g, 11g with cluster, data guard and data warehouse, total databases size is 76TB.
• Optimize RMAN for Archive log automatically management. Troubleshooting complicated RMAN backup problem.
• Strong working experience of network management, storage management, webSphere and webLogic with TCP/IP, servers, routers, switches, TMS, load balances, clustering, RAID and J2EE, ODBC and JDBC.
• Working understand of website design and functional integration.
• Strong working experience with SQL, DML, DDL, data mart, data mining.
• Tracking existing oracle CPU on 120 databases.
• Strong customer service skills, good problem solve skill through experience and research.
• Knowledge in IBM Lombardi7 and Marketing Management tool Unica.
• Knowledge in OBIEE.

Confidential, TX 01/10-03/10
Role: Consultant of an Oracle 10g/11g support DBA in Confidential

• Testing export/import for complicated database refreshes on AIX.
• Migrating legacy applications into a conforming domain model on Oracle RAC systems.

Confidential, TX 02/06-04/09
Role: Software Engineer/Information Architect in Confidential

• Supporting the design, documentation and deployment of Oracle RAC, grid control and data guard to enterprise domain model.
• Supporting of a large-scale databases in a mission critical environment (>=2 millions events per day) with 24x7 on call rotation.
• Work experience of Oracle with full life cycle including logical and physical data modeling, data definition, and data flow diagrams. Working experience of database design with Erwin.
• Implementing oracle RAC on Linux and EMC SAN storage with ASM; Hands on experience of installation, upgrade and integration.
• Problem resolution for SAN configurations using ASM and ocfs2.
• Hands on experience of oracle 10g grid control implement to centralize management Oracle RAC databases and SQL server.
• Performed SQL level, database level and OS level tuning using Autotrace; STATSPACK, AWR, ADDM, top and vmstat.
• Cloning and refreshing database from Production to Development or QA.
• Implementing database 9i/10g/11g backup/recovery with RMAN, flashback, data pump or export/import.
• Developed Unix shell, SQL and PL/SQL scripts to carry out routine checks on databases.
• Management database user, security and process access, physical/logical structure capacity plan.
• Planning and installing patch fixes and upgrades in both database and application.
• Building standby database using Oracle 10g Data Guard. Replication with streams.
• Good communication skills, experience in leading teams on projects.
• Experience in Linux system database administration including operating system installation and configuration and shell scripts.
• Highly self-motivation; Able to create detailed work plans, ability to work independently as well as in teams.
• Troubleshooting with TAR and Oracle support; Good problem solve skill through experience and research.
• Knowledge with GoldenGate and SOA.
• Experience with change control using remedy.

Confidential, TX 06/05-02/06
Role: Oracle/Oracle11i Application production support DBA

• Management single/multi-node oracle applications instances (11.5.8+) and Oracle databases (9i/10g) on Windows, Linux and Solaris environments.
• Maintain databases which used in the production, QA and Test environments.
• Manager database user, security and process access, physical/logical structure capacity plan.
• Implement patch, object validation and compiling.
• Cloning 11.5.8 database from production or QA to test environment.
• Plans, implements the backup and recovery procedures for the Oracle applications systems.
• Monitors and tuning in Oracle applications and oracle database with quest spotlight and OEM.
• Using OEM to perform database space growth analysis, such as table growth, memory usage, extents fragmentation, I/O contention, rollback segment contention and storage usage.
• Performed SQL tuning by using Autotrace, Explain Plan, and Tkprof. Implement distributed transactions.
• Strong communication and customer service skills. Working with Oracle support for tickets with SR's.
• Good Knowledge of Veritas NetBackup.
• Management SQL servers.

Confidential, NY 06/04-06/05
Role: Consultant migration DBA in manufacturing

• Gather and analyze business requirements, defining functional processes of database.
• Integrated business application into IT environment, data modeling using erwin, deployment of physical Oracle databases based on logical designs; design system requirement; transition of logical database models to physical databases.
• Deployment of physical construction in tables, views/materialized views, index, triggers, PL/SQL; managed tablespaces and constraint.
• Installed Oracle database; Migration MS access to Oracle.
• Optimization database; Monitor the most frequently executed SQL statement, tuning SQL using Explain Plain, trace, Tkprof. Query optimization with CBO and hint.
• Tuning Database server, proactively monitored hit ratios on different components of the SGA included tuning of the shared pool, databases buffers and redo buffers.
• Wrote script to automatically monitoring database status such as alert log checking and storage checking.
• Supporting development and test systems; performing production system certification.
• Copy databases on different servers using tools like export/import, SQLLoader etc.
• Configure client/server communications/software.
• Installation and configuration of webSphere message broker with J2EE.
• Knowledge of Oracle10g and Oracle11i System Administrator.
• Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.

Confidential, CT 06/03-06/04
Role: consultant project manager in Confidential

• Solid experience with PMI (project management lifecycle processes); and ability to plan and organize development work and deliverables.
• Project implementation in CRM\'s reporting and analytics support regarding all aspects of tasks, timelines, resources, etc.
• Understand business problems, using Oracle 11i to optimize CRM management in sales, service and marketing units.
• Created and maintained project plan to manage all aspects of acquisition; Coordinated all meetings and schedules between different department and management.

Confidential, CT 06/01-12/02
Roles: consultant Oracle9i/DB2 DBA

• Installed, configuration Oracle9i database.
• Logical/physical data modeling with normalization and demoralization of data.
• Using STATSPACK monitor database performance, collection data for both proactive and reactive tuning.
• Setup AUM and undo retention, dynamically undo management.
• Auditing oracle database including system level, object level, roles using Audit trail; customized audit by trigger and oracle scripts; controlled server-side security by securing network.
• Implement Oracle backup and recovery procedures in logically and physically.
• Tuning database in OS, SGA, parameters and SQL including instances management and TAR support.
• Development SQL, PL/SQL, OS scripts.
• Implement new or modify existing DB2 database objects such as instances, databases, tables and indexes.
• Establish and implement policies and procedures for DB2 database administration, backup and recovery.
• Proactively monitor and tune DB2 database system performance.
• High ability to work at new technology with quickly learn, translate them into business application.

Confidential,. NY 12/98-12/00
Roles: Systems Analysis and Development in Confidential

• Development lifecycle for Health Body systems from inception to release.
• Analyzed data flows and data elements, performed data modeling, create ERD.
• Assistant of Data Architecture in logical/physical design using Rational rose. Implemented the transformation of the logical data model to physical model and resulting data structures.
• Support user interface with design and implement Oracle 8i, OEM and Net; Created table spaces and database files based on the OFA model.
• Planned, organized, and conducted User Acceptance Testing (UAT).
• Maintain and cloning OLTP system on development, testing and production.
• Developed UNIX shell, SQL, HTML, and javaScripts to carry out routine checks.
• Implement ETL tool OWB, SQL*Loader, partition and PL/SQL in data warehouse.
• Analyze, perform Unit, Integrated as well as System Level testing, quick resolved any errors and bugs by Trace and Alert files.
• Authored complete set of documentation, including HTML files, user guides, started guides, web site content and system update guides.
• Strong organization ability to interact with individuals and groups at all levels.