Printing tool Download PDF

Chien-I Annie Chen

Application Development / Data Consultant

Skill Summary

More than ten years of application development and data analysis experience in health care, benefit management and information technology industry. Specialize in various programming languages and developing applications in Windows environment including SAS 9, SQL, Microsoft Access, Calligo Author (aka Oracle Insurance iStream), Visual Basic, Crystal Report, Macros for MS Office (Word, Excel and Access), Lotus Notes, Domino Designer, VBA and VMWare.

Education and Certification

Sep 1997Dec 1999

Master of Science in Applied Computer Science & Technology

Azusa Pacific University, Azusa, California
Sep 1989Jun 1993

Bachelor of Science in Animal Science

National Chung Hsing University
Mar 2015Present

SAS Advanced Programming for SAS 9 

Jan 2015Present

SAS Base Programming for SAS 9 

Work experience

Jan 2009Sep 2014

Application Development / Data Consultant

Kaiser Foundation Health Plan
  • Served as Project Manager for deploying and releasing Kaiser Foundation Health Plan(KFHP) compliant group contract documents for California members.
  • Planned, implemented, documented, maintained and operated KFHP group contract related applications' implementation processes to meet California regulatory and Federal legal requirements.
  • Designed, developed, programmed, coded, debugged, and applied QA/validation macros in MS Word, Excel and Access using Visual Basic programming and SQL to assure the quality of contract change deployment and release to production.
  • Analyzed and interpreted multiple large KP database environments including DB2, Oracle, SQL Server and Access, and transferred analysis results to membership and business departments for eliminating compliance issues.
  • Provided technical leadership and analytical consulting to initiate new database and enhancement to meet business needs.
  • Automated data mapping batch process for KFHP contract print system and collaborate with Kaiser Permanente Information Technology(KPIT) to ensure the accuracy and timely provision of compliance requirements.
  • Designed, developed and created ad-hoc analytic reports and coordinated activities with stakeholders such as benefit design management, sales and account management operations(S&AM), CSC group contract operations(CSC-Contracts/CSC-BSMS) and KPIT Foundation System team.
Jan 2008Dec 2008

Project Manager

Garnetex Network Service
  • Created customized software of client-server application for inventory management and sales presentation system.
  • Developed the application using VB, C#.NET and Access.
  • Included topics such as structured query languages(SQLs), end-user database issues, database maintenance, inventory data import and export, development and programming application.
  • Built Visual Basic project into automatic installation software using Visual Studio package and deployment tools.
Sep 2002Dec 2007

Application Developer

Bishop Systems Consulting
  • Developed Visual Basic applications, maintained database and created analytic Crystal Reports for benefit administration company Dexheimer-Erickson Corporation in insurance industry, using Visual Basic 6.0, MS Access and Crystal Report.
  • Designed, developed, programmed and deployed VBA to store employee demographics, payroll deductions and benefit plans of large-scale companies. The companies included The Insurance Brokers and Agents of the West(IBA), Radian Communication Services Corp., and Intelsat.
  • Customized data migration functions using VB macro and SQL to automate data interpretation and map to employee open enrollment packet among various databases.
  • Managed benefit account administration and billings conciliation.
Jan 2000Aug 2002

Programmer/application Developer

Berland Technologies, Inc
  • Developed the VB application to generate pension, profit sharing, 401K plans to satisfy complex government regulations using Visual Basic 6.0, Access as system database and MS Word as virtual plan document.
  • Designed, developed and programmed multi-tier Client-Server/Database for stock market application for asset management system which was for hedge-fund asset management reporting and analysis software-including a sophisticated algorithm that allocates trades across client accounts. Integrated external online systems which Advent, Bloomberge and Monis used in stock market and converted data to Berland Technology's database system using Visual Basic 6.0, MS SQL server 2000 and Crystal Reports.
  • Involved and tested in team popular teenage e-commerce web retailing store using the latest technology from Microsoft and Macromedia; provided full support of B2C using MS Site Server and Visual Constructor.

Text Section