SUMMARY

• 15 years IT experience, solid experience in application development and involving all phases of the software development life cycle SDLC , including project scope definition, user and system requirements analysis, system architecture configuration, existing system evaluation, design and development, testing plans creation, implementation, and maintenance.
• Implement and achievement systems including OLTP, OLAP, Data warehouse, ETL, Web application most environments are Oracle database and UNIX Systems.
• Experience in writing technical proposals, planning project tasks, estimating and controlling developers' schedules, defining coding standards and naming conventions to team members, providing technical specifications and system documents .
• Possess expertise in Oracle PL/SQL programming including complex SQL query or complex object type with ref cursor, collection, function, package, procedure, trigger, exception and error handling etc., also with other language such as Pro C, Core JAVA, UNIX Shell Script.
• Superior in Performance tuning and SQL optimization.
• Expert in UNIX system and UNIX Shell Scripts, especially Korn Shell.
• Extensive experience in data modeling including relational data modeling conceptual/logical and physical data modeling and dimensional modeling Star schema and Snow Flake Schema in Oracle, Sybase IQ, and DB2 database.
• Extensive experience in Data Warehouse implementation including data investigation and integration, scope definition, data warehouse infrastructure building, data modeling, large database design partition indexes and tables and database data files storage configuration, and Data mark or OLAP cubes generation by OLAP tool.
• Strong skill in ETL process design, including integrating multiple source data from different platforms, different systems and different databases and flat files in different OS into target Oracle database
• Experience in Oracle DBA, including Oracle installation, database creation, database storage configuration, database monitoring, backup, performance tuning and migration etc.
• Experience in 7/24 critical maintenance and production support.
• Adept at speedy troubleshooting, problem analysis and solution providing.

TECHNICAL SKILLS

• Database: Oracle 11g, 10g, 9i, 8i, DB2, Sybase IQ, Sybase SQL Anywhere.
• Language: Oracle PL/SQL, Core JAVA, C, Oracle Pro C, DB2 SqC, UNIX Korn Shell, Perl, Python, ASP, JSP, WSH Windows Script Host .
• Tools: IBM WebSphere Java development tool , Toad, SQL Navigator ,Sybase PowerDesigner modeling tool , Sybase PowerJ Java development tool and Oracle JDevelopor Java development tool , Cognos Impromptu and PowerPlay OLAP tool ,Brio OLAP tool , and DB2 OLAP OLAP tool ,.
• Platform: HP-UX, Sun Solaris, and IBM AIX.

EXPERIENCE

Confidential

App Development Specialist

• Achieve multiple enterprise compliant projects that related to HIPAA 5010, ICD10, PPACA Essential Health Benefits, systems including EDI pre-processor, Payment, Benefit and Accumulator systems and other internal systems.
• Serve as but not limited to a developer including design processes flows, providing technical solutions, creating technical specification, data modeling, design and coding, also providing testing scenarios to QA team members in each project.
• Analyze functional requirements in depth work closely with BA to improve and correct the requirements, address unconsidered situation, also provide resolutions to simplify complicated requirements.
• Implement cross duplicate claims checking function to fix 10 years issue and save company millions of dollars per year.
• Design new methodology and create new translator to reformat variable length inbound file to fixed length data file and loaded into database.
• Designing and developing both Oracle PL/SQL and Core JAVA programs.
• SQL and Store Procedure performance turning and query re-write the best record is improving processing time from one and a half hours to 2 minutes.
• Using different new technology in different projects to improve coding.
• Deliver quality programs on time or ahead of schedule.
• Troubleshoot production issues quickly.

Environment: Oracle 11g, Oracle PL/SQL Store Procedure, Oracle SQL Loader refer cursor, object type, collection type, UNIX Korn Shell, AWK, Core Java, IBM AIX, XML, XSD, Mainframe COPYBOOK layout, X12 layout, IBM MQ.

Confidential

Application/SW Development/Support

• Project: Sales Management And Revenue Tracking SMART System
• SMART system is a web-based application that serves as a portal for AT T's thousands of alternate sales channel vendor.
• Designed and developed the application to meet end user requirements.
• Implemented front end web application using PL/SQL and mod plsql.
• Query statements and store procedure performance tuning.
• Redesigned and created multiple core processes and replaced existing manual processes to reduce process time and prevent manual processes mistakes.
• Designed and implemented new translators and loaders to transform different formats inbound flat files and load into Oracle database table and replace the existing inconvenient manual preformat processes.
• Processed vendors' commissions and adjustments.
• Restructured over 100 batch jobs and made batch jobs easier to maintain.

Environment: Oracle 9i, Oracle Pro C, Oracle PL/SQL Store Procedure, UNIX Korn Shell, Perl, JSP, Oracle mod plsql, Sun Solaris, HP-UX.

Confidential

Study MS degree in Computer Science

Confidential

Senior Software Engineer / Oracle developer and Oracle DBA

• Designed auto backup system to automatically back up database data and large images files using RMAN and UNIX korn shell script.
• Served as Oracle DBA and UNIX administrator in different client sites and maintain 5 times client sites than other engineers.
• Implemented ETL processes to collect and transform data from multiple source data including DB2, flat files into Odyssey database.
• Project: Odyssey EDA system OLAP for semiconductor manufactory
• Designed database monitor processor to detect database spaces and automatically add data files.
• Designed database configuration and data files storage structure.
• Planed and built up failover processes to keep the 7/24 system no down time.
• Assisted client site IT to turn query statements performance.
• Customized systems to meet different client requirements.
• Implemented auto daily Microsoft PowerPoiner reports generator to save customers reports creation times.

Environment: Oracle 8i, 9i, 10g, C, Oracle Pro C, Oracle PL/SQL Store Procedure, Oracle RMAN, UNIX Korn Shell, DB2 Sqc, Sun Solaris, HP-UX, Windows NT, WSH, ASP, IIS,.

• Project: Oracle Database/UNIX System Migration
• Designed minimize downtime migration plan and provide the proposal to customers.
• Planed and constructed the new system framework including estimation storage size, arrange file systems, network setting.
• Implemented ETL Process to extract, clean and translate database data from existing database into new database
• Designed the programs to parallel run old and new systems using UNIX Korn Shell.
• Accomplished system migrations for whole Taiwan's customers in one person and the migration plan also became company standard.

Environment: Oracle 7, 8i, 9i, 10g, Oracle PL/SQL Store procedure, UNIX Korn Shell and Sun Solaris, HP-UX.

Confidential

Senior Software Engineer

• Served as both a team leader and a developer, including:
• Accomplished multiple dimension analysis reporting system OLAP system , data warehouse, ETL processes, and JAVA application in multiple client sites.
• Provided technical proposal to PM, including project's objectives, project's scope, hardware and software requirements, system configuration, tasks list, and schedule and developers estimation.
• User requirement evaluation and analysis, system integration, system architecture design.
• Assigned tasks to team members and controlled development schedules, created testing and implementation plans.
• Created JAVA utility classes and PL/SQL common functions, packages to team members.
• Dimensional data modeling in OLAP and Data warehouse projects, and database design including dimension tables and fact tables, partition tables, partition indexes creation.
• Relational data modeling in JAVA application projects including conceptual/Physical and database design
• ETL processes design and implementation including data mapping, data cleaning and data translation to integrate engineer data, equipment data, yield data from the different departments and multiple customer existing systems into data warehouse database.
• Multiple dimensional analysis design in OLAP reporting project including the hierarchy of dimension attributes, drilling up, drill down and drilling anywhere definition and design.
• OLAP Cubes generation with different analysis views using OLAP tool, Brio/Cognos PowerPlay.
• Designed training classes and as an instructor in classes.
• Project: Equipment Status Analysis Reporting System OLAP for semiconductor clients.
• Environment: Oracle 8i, DB2, Sybase IQ, UNIX Korn-Shell, DB2 SQL, Oracle Store procedure and Sun Solaris, HP-UX, POSIDON, Power Designer, Cognos/ Brio.
• Project: Semiconductor Data warehouse project in UMC Fab8.
• Environment: DB2, Sybase IQ, Sybase Power Design, Brio,UNIX Korn Shell, UNIX crontab and IBM AIX.
• Project:Enterprise Supply Chain data translation ETL project in UMC HQ
• Environment: Oracle 8i, Oracle Store procedure, UNIX Korn Shell, UNIX crontab and HP-UX.
• Project: Membership maintenance system of Taiwan Pediatric/Surgery Association.

Environment: Sybase SQL Anywhere/Oracle 8i, JAVA applet, Sybase/Oracle Store procedure, Windows NT, Apache web server.

Confidential

Software Engineer/ Oracle DBA in client sites

• Project: NEDA System: yield analysis system for the semiconductor manufactory
• Designed ETL processes to integrate data in client multiple systems into NEDA database.
• Created C utility libraries and provided to team members using.
• Served as Oracle DBA in multiple client sites including Oracle installation and Database creation, data files storage estimation and allocation, database maintenance and backup.
• Installed and maintained NEDA systems, and provide training classes at customer sites.
• Speedy troubleshooting and provided short term solutions to keep system available.
• Served as interface of customers and USA HQ development team.

Environment: Oracle7, 8i, Oracle Pro C, Oracle PL/SQL Store Procedure, DB2 Sqc, C, UNIX Korn-Shell, HP-UX, Sun Solaris, Windows NT.

Confidential

System Analyst and Oracle Application Developer

• NHI project was an ISO 9000 standard project. The project has over hundreds subsystems to maintain whole country people's population: 23 million healthcare data, medical data and medical payments.
• Involved multiple subsystems design, including user requirements analysis, system configuration, data modeling, and coding and testing plan providing.
• Design ETL process to integrated data form multiple subsystems into multiple views statistic reporting system.
• Developed translators and loaders to translate whole country's hospitals and clinics' electronic claims into NHI database
• Wrote system documents including system configuration, process flow chart, data flow chart, data dictionary and program spec, etc.

Environment: Oracle 7, C, Oracle Pro C, Oracle PL/SQL Store Procedure, Dynamic SQL, SQL Loader, UNIX Korn Shell, X/Motif and UNIX system.