Technical Skills

OLAP Tools OBIEE 10.1.3.4/11.1.1.6/11.1.1.7 Oracle BI Publisher 11.1.1.6 MS SQL Server 2008/2010 SSRS

ETL Tools Ascential ETL datastage Server v7.5 DAC and Informatica 7

Report Tools Adobe Acrobat 10 and 11

CRM Product Accenture CAS 7 8 9

Databases Oracle 11g/10g/9i/8i/7 MS SQL Server 2005/2000/2008/2010 Teradata InterBase SyBase MS Access Paradox.

Languages SQL PL/SQL .NET 2.0 and 3.5 VB and C ASP.NET Java AWT Swing JDBC Servlet Applet Application EJB J2EE JavaBean JSP HTML XML JavaScript Perl ASP Delphi Visual Basic Pascal C/C Fortran Lotus Notes IntraBuilder.

Platforms Windows XP Windows Vista Windows NT/2000 Windows 95/98

Windows 3.x UNIX DOS Novell Netware SGI IRIS workstation

SUN workstation and Unisys Mainframe.

Web Technologies ASP.NET JSP HTML XML JavaScript Perl ASP

Overall Qualifications

Over 20 year IT experience on analysis design development and testing of enterprise applications. Strong background in OOP database and data warehouse design business intelligence process and reporting web design and multiple programming languages.

Hands on experience in OBIEE 10.1.3.4 and OBIEE 11.1.1.6/11.1.1.7 Oracle BI Publisher 11.1.1.6. Experience in OBIEE/BIP environment installation and setup. Experience in data model design and building and deploying OBIEE metadata repository Physical Business and presentation layer using OBIEE administration tool. Experience in creating Dashboards and Answers. Have sound knowledge on OBIEE BI Server Oracle BI Delivers Administration Tool and Catalog Manager. Experience on Installation Configuration and Administration of OBIEE 10.1.3.4 standalone. Have good knowledge of migrating from one OBIEE environment to another such as from DEV to UAT. Experience in ETL job creation. Strong SQL/PL-SQL with complex queries. Strong analytical and problem solving skills.

Hands on experiences in .NET 2.0 and 3.5 VB and C ASP.NET Delphi Java AWT Swing JDBC Servlet Applet Application J2EE JavaBean JSP HTML XML Oracle InterBase SyBase MS SQL Server MS Access Paradox JavaScript Perl ASP SQL Visual Basic Pascal C/C PowerBuilder Fortran Lotus Notes IntraBuilder and MS IIS server.

Ability to work both independently and with team members.

Aggressive learner and able to adapt to new programs systems and challenges.

Fluent in Chinese and English.

Certificates and Training Certificates

Accenture CRM CAS 9 Trade Promotion Management TPM Trade Promotion Optimization TPO

Accenture CRM CAS 8 Generic Customizing Basics

Accenture CRM CAS 8 Basic Modules

CPG Overview

Accenture CRM CAS 8 Fundamentals

Training for Certified Siebel Analytics Application Developer

Training for Certified Siebel Analytics Server Architect

Training for Certified Siebel Analytics Data Warehouse Developer

Sun Certified Programmer for Java2 Platform

PhaseForward s InForm EDC software Architect moduole.

Teradata data modeling.

Ascential ETL datastage Server v7.5

Enterprise Java Beans

XML Programming

Java Servlets

JAVA Advanced Programming

Advanced Delphi 4.0

Advanced Application Development In Delphi 3.0

Application Development In Delphi 2.0

Intermediate C

InterBase 4.0

Introduction to Oracle PL and PL/SQL

Oracle 8 Database Administration

Advanced Perl Programming

Lotus Notes Application Development I

Lotus Notes System Administration I

Lotus Notes CBT

7th and 9th Borland Conferences

Project Management For Team Leader

Experience

Confidential

Technical Consultant/Associate Manager/Architect

Currently working on an OBIEE project at Federal Government in Washington DC as an OBIEE Architect/Consultant. Design the data model according to the technical requirement document. Design the RPD technical design document. Work with ETL developer to define the data. Configure the RPD file. Build the dashboards and reports. Do performance tuning to speed up the reporting process.

Worked on EBI project at Cox Communication in Atlanta as an OBIEE Architect. Design the data model according to the technical requirement document. Design the RPD technical design document. Lead the offshore team to configure RPD and report building.

Lead the Time/Resource Tracking application development at Cox. Design the data model according to the user requirement. Design and build the Access database and SQL-Server database for the application. Design the views and Stored Procedures to prepare data for the reporting. Design and build the reports. Work with the offshore team to make sure the front end developers understand the backend process. Lead the ETL effort to load the data to database system. Do the performance tuning to speed up the process.

Lead the Iowa CCB development efforts for Iowa state government on OBIEE platform. Lead the reporting development using BI Publisher Adobe Acrobat Pro 10/11g and Microsoft Word. Design PDF and RTF report templates. Deploy PDF and RTF reports on BI Publisher 11.1.1.6 and OBIEE 11.1.1.6 platform. Design database model for the reporting data of PDF and RTF reports. Design and develop data structure using Oracle 11 analyze the functional and technical requirements. Design Proof of Concept OBIEE dashboards from scratch. Design the middle layer RPD Repository. Design and develop the requests and graphs and all the other contents for the dashboards.

Solution Architect and Application Architect for Rackspace revenue process and reconciliation project. Design the Technical Blueprint and Solution Plan for Rackspace s BI and Reporting process using OBIEE OBIA/ODCM Essbase and EBS.

Lead the BI/Reporting effort on CalHEERS project. Design the OBIEE/BIP architecture. Set up and install the OBIEE/BIP Environment. Work with security group to integrate BIP with the security model. Analyze the data model for CalHEERS. Design and develop the technical design and BI/Reports. Customizing the OBIEE/BIP platform.

Implementing and Customizing Accenture s CRM product CAS for different clients such as RJ Reynolds Anheuser-Busch InBev and Church Dwight. Customizing the product using Modeler. Work on the TPM/TPO Modules. Design and develop the server process for the application. Work on the BI and reporting for the application using SQL Server SSRS. Analyzing the data model.

Confidential

Lead System Consultant

Design and develop dashboard reports for finance department using OBIEE 10.1.3.4 Teradata and Oracle. Design and develop BI Answers Delivers and Interactive Dashboards. Involve in data model design and the BI repository design and development.

Analyze the specifications provided by the client review the business requirements. Involve in the design of Star schema for fact dimensional tables. Develop Physical Layer Business Model Mapping and Presentation Layer using Oracle BI Administration Tool. Merge RPD using Oracle BI Administration Tool. Specify Dimensional hierarchy Aggregate levels for the dimensions.

Involve in merging webcat using Catalog Manager. Involve in Configuration of of Web Catalog Security and Cache Management

Develop Reports Filters and Prompts using Oracle BI Answers. Use Filters Global and Local and provide customized prompts. Created various reports and Dashboards to fulfill the Financial Department needs and customized the views using Oracle BI Answers. Design and Configure Interactive Dashboards for different groups of users. Involve managing Security privileges for each Subject area and Dashboards according to user requirements.

Design and develop the revenue analysis reporting and posting system called RACE using VB.NET 2.0 and Visual Studio 2005 and infragistics controls and Oracle. Design and develop the data structure and data process in Oracle using PL-SQL. Design and develop the data layer using vb.net. Design and develop web service functions for RACE. Design and develop complex window based RACE user interfaces using VB.NET and infragistics controls.

Design and develop web based reporting system for RACE using DNN module and ASP.NET.

Design and develop work flow internal site OneSource using ASP.NET 3.5 MS SQL Server 2005 IIS and Visual Studio 2008.

Confidential

Lead Application Developer

Design and develop the revenue reporting system called CloseAssist using VB.NET and Oracle. Design and develop the security maintenance module for CloseAssist. Close Assist is primarily used for research and investigation it is also a query tool that offers a visibility to account and trend revenue and traffic information that supports the monthly Close process.

Design develop and maintain a PowerBuilder application called CloseApp for MCI. CloseApp is responsible for 50 of the revenue reporting from 70 of the MCI billing platforms. The system is written in powerbuilder C web services from .NET and Oracle and Sybase database.

Design develop and maintain DCA automation program to process revenue from DCA billing system. The system is written in Delphi Oracle and Interbase.

Involve in a very large project EBI from early stage which include data profiling data modeling in Teradata design and do ETL work using Ascential datastage.

Confidential

Lead Application Developer

Design and develop a three-tiered application to processes analyzes and report the monthly revenue information from Cherokee billing system using advanced Java technology such as Servlet JSP EJB J2EE and Weblogic application server.

Continue the design development and modification of DCA automation system using Delphi Oracle InterBase and SyBase. The system processes analyzes and reports the monthly revenue information from DCA billing system.

Modify and maintain the AutoLoader system using Delphi and Informix database. The system constructs and monitors the loading process for WorldCom s financial data.

Involve in the design and development of Revenue Systems On-Line using HTML Java JavaScript and ASP.

Design and develop Debit Card Automation system using Delphi and InterBase. This system processes analyzes and reports the monthly Debit Card revenue information.

Design and develop several utility programs such as CCI automation program Airborne Application Tool Commission Upload program Budget Upload program and Lawson Upload program using Delphi InterBase Paradox and Access.

Develop Intranet database applications using IntraBuilder. Setting up and maintaining the web server for the department.

Lead the Revenue Systems Support Group. Maintain all the production codes for WorldCom s Revenue Systems Department. Conducting research for Revenue Accounting users. Assist with evaluating and editing automated systems standards documentation. Work on reconciliation for different systems.

Confidential

Sr. Application Developer / Lotus Notes Developer Administrator

Develop Purchasing Order System for Financial Systems Department using Lotus Notes. Set up Lotus Notes severs and Install Lotus Notes applications for different locations all over the country within WorldCom. Conduct both Lotus Notes application development and administration.

Develop workflow applications using Lotus Notes groupware such as Lotus Forms Novell Informs.

Setting up and maintaining the Lotus Notes network for the whole company on different platforms including Windows 95 Windows NT OS2 etc. Using different protocol such as SPX and TCP/IP.

Design and develop relational database models. Develop database client server applications using Delphi InterBase Sybase MS Access Paradox.

Develop applications for Financial Systems Department using Visual Basic and Access database.