Education

Project Management Leadership Program

M.B.A major in CIS

Hardware& Software 

Oracle 11g, 10g, 9i, RMAN, OEM(Enterprise Manager), MS SQL Server ,IIS, Oracle 11g Weblogic 11g, 10g Application Server 9iAS, Apache, WebLogic 8.1, 9.0, Unix (Solaris, HP, AIX), Oracle Warehouse builder 9i, 10g. IBM DataStage Quality Stage. Windows (NT, 2000, XP), Java (JSP, JDBC, EJB, Applet), PL/SQL, Visual Basic, XML, UML, Rational Rose, Unix Shell Script, JDeveloper, TOAD, SQL loader, Unix Cron job, Windows scheduler, LoadRunner, Winrunner and TestDirector

Certifications

Java 2 Certified Programmer
Microsoft Certified Database Administrator
Oracle Certified Professional for Oracle DBA (OCP)

Experience

Mar 2011 to Now Confidential
Senior Analyst

• Developed OBIEE Repository at three layers (Physical, Business model and Presentation Layers). Developed interactive Dashboards and drill down capabilities for Wireless Technology Group.
• Supported Oracle CRM and BRM application. Tuned SQL queries and improved performance of existing reports. Delivered new reports for various group such as finance, operations and marketing.
• Wrote complex PL/SQL programs to extract data from five different billing systems and compare data to reconcile these transaction amounts among these different systems to make sure that no payments are missing.
• Support all the reports related to third party vendors.
• Designed and developed ETL job to extract data and load external data from outside vendors into our reporting database.

Sept 2008 to Mar 2011 Confidential
SENIOR DATABASE ADMINSTRATOR

Projects and Task Related Oracle Application E-Business Suite (11i and R12)

• Monitor database and application performance using different tools and tune database and application as needed. Control workload through concurrent manager. Automated routing jobs such as rebuilding tables and index and monitoring database usage to reduce and simplify daily tasks. Add space and data files when it is necessary.
• Worked with a team upgrade E-Business Suite from 11i to R12. Went through multiple cycles of testing and deployment starting from installations,
• Perform regular DBA duties, such as apply patches for Database, E-Business Suite. To streamline of testing and deployment, merge multiple patches together. Trouble shoot and solve issues related to the patches.
• Clone production database to setup development and test instances. Support developers in test environment and helped them write PL/SQL scripts.
• Supported functional team and end users in production environment. Work with both end users and developer to resolve complex problems and issues. Sometimes also get Oracle support involved.
• Wrote detailed documents procedures and processes so other people can perform the same task when it is necessary. Also draw diagrams to describe architectures.
• Installed 10g RAC Environment to host mobile application. Utilized ASM technology. Perform and monitor backup using RMAN.

Projects and Task Related Data Warehousing (OBIEE OWB & Discoverer)

• Installed Fusion Middleware 11gR1, including Weblogic 11g. Upgrade Oracle Discoverer from 10g to 11gR1 (11.1.3) in 2010.
• Installed OBIEE 11g on Linux system, setup development and test environment for upgrade OBIEE from 10g to 11g. Integrated Weblogic LDAP authentication with Microsoft Active Directory Authentication.
• Set up brand new Oracle Data Warehousing Environment by using pure Oracle Technology in 2008. Installed Oracle Business Intelligence Enterprise Edition (OBIEE formerly Siebel Analytics) 10gR3 independently including Oracle Application Server configured authentication integration with E-Business Suit R12. Users can launch dashboard and drill down the results within E-Business Suit.
• Upgrade data warehouse environment from Oracle 10gR2 to Oracle 11gR2, including Oracle Ware house Builder and Oracle Discoverer.
• Wrote detailed documents about data warehouse environment, draw diagrams to describe architectures

Projects and Task Related Oracle Application E-Business Suite (11i and R12)

• Monitor database and application performance using different tools and tune database and application as needed. Control workload through concurrent manager. Automated routing jobs such as rebuilding tables and index and monitoring database usage to reduce and simplify daily tasks. Add space and data files when it is necessary.
• Worked with a team upgrade E-Business Suite from 11i to R12. Went through multiple cycles of testing and deployment starting from installations,
• Perform regular DBA duties, such as apply patches for Database, E-Business Suite. To streamline of testing and deployment, merge multiple patches together. Trouble shoot and solve issues related to the patches.
• Clone production database to setup development and test instances. Support developers in test environment and helped them write PL/SQL scripts.
• Supported functional team and end users in production environment. Work with both end users and developer to resolve complex problems and issues. Sometimes also get Oracle support involved.
• Wrote detailed documents procedures and processes so other people can perform the same task when it is necessary. Also draw diagrams to describe architectures.
• Installed 10g RAC Environment to host mobile application. Utilized ASM technology. Perform and monitor backup using RMAN.

Sept 2007 to Confidential

SENIOR DATA ANALYST
Credit Identity Verification Project for Telecom Industry

• Analyze, design, and develop Data Warehouse database and application to host data from different Telecom Companies and match customer’s data with Equifax credit files for the purpose of credit and identity verification. The application produces multi-million dollar revenue each year.
• Load data from flat text files sent by customers each day. Using an ETL Tools to do data validation and transformation.
• Write Oracle queries for large-scale and sophisticated data analysis and reporting required by the clients and internal customer using Oracle PL/SQL, Toad, SQL/Loader, SQL/Plus.
• Mentor junior staff in Oracle PL/SQL, UNIX Shell Scripting writing, and Oracle query tuning.
• Work with team set up standard on naming and implementation conventions.
• Wrote UNIX Shell Scripts to read files from file system and call Oracle PL/SQL procedures and Oracle WorkFlow from the UNIX operating system. Served as key resource for software developers on database questions and PL/SQL issues.

Apr 2007 to SeptConfidential

ORACLE DBA/DEVELOPER

• Developed and modified existing response file to install Oracle 10g software silently on clients’ sites, also wrote scripts to upgrade database from 9i to 10g automatically.
• Supported Clients’ database remotely, such as purge unwanted data or trash data and re-build indexes. Now and then, have to recover databases for them.
• Wrote test cases, test scripts and related documents and facilitated QA department to do testing.
• Designed and Implemented new features to existing administration tools using PL/SQL and JavaScripts.

Nov 2006 to 2007 Apr Confidential

ORACLE Application DBA 
Broadband Project

• Installed Oracle 10g software and created new reporting database. Also upgraded existing database to 10g.
• Designed and Implemented Reporting Database Using Star Schema. Performed data modeling and logical Oracle database designs using ER Studio and coding of PL/SQL, Stored Procedures.
• Analyze, design, and develop Oracle PL/SQL applications and programs, and Oracle queries for large-scale and sophisticated data analysis and reporting required by Broadband Application using Oracle PL/SQL, SQL/Navigator, SQL/Loader, SQL/Plus.
• Mentor junior staff in Oracle PL/SQL, UNIX Shell Scripting writing, and Oracle query tuning. Write instructions on how to use Oracle Warehouse Builder and WorkFlow.
• Work with team set up standard on naming and implementation conventions.
• Wrote UNIX Shell Scripts to read files from file system and call Oracle PL/SQL procedures and Oracle WorkFlow from the UNIX operating system. Served as key resource for software developers on database questions and PL/SQL issues.
• Upgrade Oracle Warehouse Builder and WorkFlow from 9iR2 to 10gR2 on both development and production servers.

Training 

OBIEE 11g Feb 2011 Atlanta

Unix – Georgia Institute of Technology
Unix Operating System and Shell Scripting

Java - Sun Educational Services
Java Programming Language Workshop 
Object Oriented Programming (UML and Rational Rose)

Oracle – Oracle Corporation DBA Track (All five classes)
Developer Track
2006 Oracle Database 10g: New Features for Administrators Ed 2