PROFESSIONAL PROFILE

Accomplished Oracle Developer (PL/SQL) with over 12 years of experience in various industries including management consulting, retail, insurance / finance, healthcare, and engineering; reliable, values-driven professional with high integrity. Specific strengths include:

• Broad skills of database design, development, and management / administration utilizing a variety of development tools and programming languages on various operating platforms
• Analytical and problem solving skills: logical, detail-oriented, model building, and able to show causes and effects and patterns / connections / correlations
• Team player with organization and project management skills
• Resilience with flexibility, prioritization skills, continuous learning attribute, and a can-do and hard-working attitude

PROFESSIONAL EXPERIENCE

Confidential,WI 01/2009 - 06/2009
Database Applications Developer
Researched, recommended, deployed new technologies, and developed top notched systems for Gallup to collect and analyze data, and provide business intelligence and consulting services to develop recommended courses of action for its clients to improve employee engagement and end-customer satisfaction.

• Developed and managed the first U.S. online survey database (in Oracle PL/SQL) of school students called "School Poll" to measure students' level of well being, engagement and hope about their educational experience. Survey was designed in partnership with America's Promise Alliance.
• Designed and developed ETL (Extract, Transform, and Load) processes to efficiently transfer data from one source to another.
• Built and implemented Oracle data warehouse for reporting and business intelligence.
• Assisted to develop API (Application Programming Interface) Web Services framework for Internal Customer Engagement project.

Confidential,Madison, WI 02/1999 - 10/2008
Programmer / Analyst / Developer
Responsible for all aspects of life cycle development of the secure and efficient retail system including system analysis, design, development, testing, implementation, maintenance, upgrade, and performance tuning.

• Supported the entire system with various applications such as: Sales, Credit Application / Payment, Purchasing, Distribution / Inventory, Services, Human Resources, Reports, Finance, and Marketing.
• Developed both front-end data capturing / displaying screens and back-end packaged procedures / functions / programs / reports to facilitate the retail business. Major development tools used were Oracle Forms, SQL and PL/SQL.
• Led some small / medium sized projects and was one of primary developers on most IT projects which included the following:
• GUI (Graphical User Interface) - Converted / installed more than 100 screens. Utilized J2EE, JavaScript, and Oracle Application Server / Web Services to
  deploy new products on internet.
• Oracle Database Upgrades: version 8, 9, 10g, RAC; code revising / testing.
• System development and implementation for new regions and stores expansions
• SIE: Service Integration Engineering - merging service database with sales database.
• STF: Send To Factory Engineering, leading role. Created screens to collect dysfunctional items with dysfunction description.
  Generated the STF document (RAR - Return Authorization Request) with
  dysfunctional items info and transferred / faxed the RAR to the vendors.

Confidential,Wausau, WI 02/1997 - 10/1998
Wausau Benefits Business Center
(A Nationwide Insurance Company, acquired by Liberty Mutual, Fiserv and United Health Group subsequently)
Programmer / Analyst
Responsible for system analysis, development, and support for Group Retirement system and Claim Management system.

• Served as a key member in systems GUI conversion from Forms 3.0 to Forms 5.0.
• Converted over seventy screens and programs.
• Planned, designed, and implemented the new GUI products to twenty agents' PCs.
• Assisted to develop a system to automate and make the sales process more efficient for the Sales Business Center.

Confidential,Waukesha, WI 08/1996 - 01/1997
System development consulting

• Ecommerce Development for GE HealthCare - online products sales.

Confidential,China 07/1988 - 01/1994
Civil Engineer
Civil Engineering design for municipal engineering constructions: highways, bridges, water plants, sewage treatments, etc.

• Collected data from construction sites
• Analyzed and processed data; designed the blueprint for the construction team
• Audited the construction processing and provided the final report for projects

EDUCATION

M.S. in Computer Science

B.S. in Hydrogeology and Geo-tech Engineering

TECHNICAL SKILLS / KNOWLEDGE ADDENDUM

Languages

SQL, PL / SQL, Perl, Java, HTML, XML, VB, and C / C++

Databases

Oracle (9, 10g,11g), SAS, MySQL, SQL Server, Sybase, and DB2

Tools

Oracle Forms / Reports / SQL Analyzer, Apex, Designer, Jdeveloper 11g, TOAD, Sql*Loader, and Microsoft Office (Excel, Access, Word)

Operating Systems

Windows NT, XP, UNIX, MAINFRAME, and LINUX

Applications

Retail, HCMS, CRM, Financial (GL, AP / AR), Clinical, and SCM (Ordering, Logistics & Transportation Management)

CERTIFICATES / TRAINING

Oracle Foundation, Forms / Reports, Performance Tuning
Access Tables & Queries; Forms and Reports
Gallup My Strengths, Our Workplace, Our Candidates