SUMMARY

• 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.

TECHNICAL SKILLS

• BI 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, Splunk 6.2.1,
• ETL Tools: Ascential ETL datastage Server v7.5, DAC and Informatica 7/9,
• Report Tools: Adobe Acrobat 10 and 11,
• CRM Product: Accenture CAS 7,8,9,
• Databases: Oracle 11g/10g/9i/8i/7, MS SQL Server 2000/2005/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/7/8,
• 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,

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA,

Responsibilities:

• Work on a Big Data Demo project using Splunk on AWS Amazon Cloud Space. Load machine data into Splunk, build knowledge object for search result. Build dashboards and reports and charts for different business cases using the dynamic search result.
• Worked 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.
• Lead the reporting development using BI Publisher and Microsoft Excel for LA County. Design Excel report templates. Deploy Excel reports on BI Publisher 11.1.1.7 and OBIEE 11.1.1.7 platform. Design database model for the reporting data of MS Excel reports. Design and develop data structure using Oracle 11, analyze the functional and technical requirements.
• 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.

Confidential, Atlanta, GA,

Responsibilities:

• 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

Confidential, Atlanta, GA,

Responsibilities:

• 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.

Confidential, Atlanta,Jackson, MS,

Responsibilities:

• 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.