SUMMARY:

• 20+ years experience in Database/systems analysis, design, development, testing, implementation, support and maintenance. Strong life cycle development skills in client/server system and web - based multi-tier applications with Oracle Database 7x/8/8i/9i/10g/11g/12c,
• Oracle Application Server 4.5/6i/9i/10g/Weblogic, Oracle Forms/ Reports, PL/SQL Web Toolkit, PSP, JDeveloper/ADF, Data modeling and database design (Erwin, Oracle Designer), ETL(Informatic,ODI), Cognos 10 /OBIEE 11, Data Warehouse, UML, Visual Basic4/5/6,Visual Studio. NET, Crystal Report, Powerbuilder, MS SQL Server, MS
• Access with ActiveX/DLL/EXE/OLE, COM/COM+, OOP, Fortran, C, C#,
• Java/JSP/JSF/J2EE/JAVA EE, Struts/SpringFramework, ANT, Hibernate, ORM, Web
• Services, ASP/JSP/JSF/PSP/PHP ASP.net, JavaScript, HTML/DHTML/XML, CSS/ IIS,
• Hadoop, Hive, PL/SQL/T-SQL, on Windows 95/98/NT/2K/XP, UNIX/LINUX, Python etc.
• Cisco Composite 6.2.0 (CIS), IBM Netezza database, Aginity app for Netezza
• 5+ years researching/teaching experience in Mechanical Engineering (at National Aerospace Lab. of Japan and Universities in China). Published over 10 researching papers in professional Journals and International Conferences.
• Strong skills in data modeling, database design, database administration, and data warehouse.
• Strong analytical skills; innovative problem-solving skills; excellent communication skills;
• Excellent attitude; fast learner; hard worker; team player and leader.
• High potentials in learning new technologies.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, IBM AIX 5.3, Red Hat Linux 6.2, LINUX, Windows 95/98/NT/2000/2003/XP. VSM, Mac OS.

Database: Oracle7x/8x/9i/10g/11g/12c, OLAP, ESSBASE, Sybase, Teradata SQL Server6.5/7/2k/2005/2008, MS Access, IBM DB2, MYSQL, IBM Netezza

Programming Languages: PL/SQL, SQL*PLUS, T-SQL, Oracle Forms/Reports, PL/SQL Web Toolkit, Crystal Reports,Java, J2EE, Servlet, JSP, JSF, JavaScript, VBScript, PSP, Python, Unix/Linux Shell Programming, C, C#, Asp. NET, Cold fusion, PHP, HTML, XML, Fortran. Cisco CIS Applications.

Web Servers: Oracle Application Servers 3/4.5/9i/10g, OC4J, Apache, MS IIS, Tomcat, WebLogic 9/10/11g JBOSS, Websphere Application Server.

Other Skills: OracleDesigner/Discoverer/WarehouseBuilder, ODI/OBIEE11g, JDeveloper,/ADF, SOA, Oracle Portal/SSO/OID, Erwin, UML, Oracle WebDB/XE, OEM,OracleAPEX4.0,Exp/Imp,RMAN/DBUA TKPROF/STATSPACK,Eclipse,JPA,Hibernate, ANT/Maven and Spring, Informatica, Cognos, Data Virtualization platform(CIS). Aginity workbench 4.3 for Netezza .

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database DBA/Developer

Responsibilities:

• CME Database Modeling (Physical Data Model) using SAP Powerdesinger 16.5
• Create CME Database and all schemas and staging/master tablesin SQL Server using SSMS.
• Document the system design specification (SDS) document.
• Generate csv files from sources (CMOD/FileNet/ECF/BSP/FORMS/REF).
• Create DB stored Procedures to load all csv files into CME staging and master tables.
• Setup schedules(jobs for automatically) to run the loading stored procedures in CME DB.
• Setup the CME DB backups/Recovery plans.
• Development of the ETL code for CME mapping/Transformation.

Technologies: SQL Server 2012, Visual Studio 2010, SSMS, DB Stored Procedures,SAP PowerDesigner 16.5, ETL/Data integration,Batch scripts, Data Modeling,SQL/T-SQL, DB backup/recovery, DB Administration,VB coding.

Confidential

Sr. Oracle Database Consultant

Responsibilities:

• Review/analysis the business requirements to design in logical and physical models (DB ERDs) .
• Create Database schema and entities (tables/views) in the MTAD oracle database.
• Setup Database data encryption provisions and rules for some sensitive data in tables.
• Setup Databases Backup/Recovery rules.
• Using PL/SQL to create DB pkgs(procedures and functions), triggers and scripts to handle business rules for generating market data to publish to business users to analysis.

Technologies: Oracle Database 12c, Oracle Database Cloud services, Cloud Database 12c, JDeveloper 12c, SQL Developer, SQL &.PL/SQL, Oracle pkgs/procedure/functions/triggers

Confidential

Sr. Application Software Consultant

Responsibilities:

• Review/suggest the mapping design docs, and implementation Composite codes.
• Create LRM Mapping docs and test cases, and code the mapping views in CIS.
• Unit testing for the Composite views by using UNIX scripts, JAVA and CIS scripts.
• Analysis data source entities (DB tables/Views) for the Composite views.
• Create full/Incremental Tables/views Cached in Composite and refresh them in Netezza DB and CIS by scripts and tools.
• Introspect/re-introspect new data source in CIS Composite applications.
• Code performance tuning in DBs and Composite.
• Create/follow up Cisco support for the Cisco Ticket for the Composite Applications and Netezza DB issues.
• Prepare /build packages for the CIS package (XX.Car)to deploy applications in SIT/UAT/PROD envs.
• JIRA tickets handling and bug fixing.
• Support and Administration of Composite Data Virtualization Platform.
• Use NZPLSQL to create Zetezza procedures to handle L1 data in ETL processes against NETEZZA DB.
• Migration Composite views to IDP (from L1 to L3 in Netezza DBs).
• Development L3 mapping and data integration in IDP for All projects.
• Use Python/Java scripts to handle files in data migration processes.
• Create IDP L1 data loading PKG in SSIS for DEV/SIT/Prod in IDP
• Create IDP L3 package in SSIS .
• Using PL/SQL to create DB Procedures/Functions and handle the procedures code tuning and enhancement in the APMS Oracle applications.
• Code review for most applications.

Technologies: Data Virtualization Platform, Oracle Database 10/11g, PL/SQL/Triggers, Oracle PL/SQL tuning. DB2, SQL Server, IBM Netezza 6.0/7. 0 Databases, Composite (CIS) Studio 6.2 (modeler/Manager/Discovery), Aginity workbench, Composite procedures, Java, Python 3.5, ETL, JIRA, Testing scripts, Data Cleansing/mapping/Migration, Unix (shell scripts). SVN. PuttyTFS, PowerDesigner, Autosys/ESP.

Confidential

Responsibilities:

• Review/suggest the migration design docs, and migration codes.
• Create CCRD4.0 data migration design documents.
• Prepare/setup target Database structure migration approaches and ETL scripts.
• Working with Confidential DBA team to build the Databases for DIT/SIT/UAT data migration envs.
• Backup databases (physically and logically for preparing migrations in envs ). exp/imp (empdp/impdp) source/target database objects and data in DBs.
• Implementation DB structures and ETL data migration on DEV/SIT/UAT/mock Prod/Prod by working with Confidential DBA team.
• Prepare PL/SQL scripts and fix any issues while migration steps.
• Generate DB AWR/ADDM reports on UAT and CERT Databases to check and analysis overall performance.
• Analysis /validation objects/data after migration by pl/sql scripts and procedues.

Technologies: Oracle Database 10/11g, RMAN, data bump(expdp/impdp), Data Modeling/TuningData Cleansing/mapping/Migration, Database build, Toad/SQLDEVELOPER, UML.

Confidential

Sr. Oracle Developer

Responsibilities:

• Create Control and transaction tables/triggers/Indexs.
• Prepare/setup control tables data and load them into DB control tables
• Create Import validation DB packages for checking imported data.
• Create ETL packages to load data from Oracle Financial DB
• Create Export Packages for build xml file from RSSTAGE DB tables.
• Create PL/SQL DB Procedure/Functions and handle code tuning and trouble shooting.

Technologies: Oracle Database 10/11g, Data Modeling/Tuning, ETL, PL/SQL,Sqlldr, Data Migration/Mapping, Toad/SQL, XSD/XML, SLT, DTD And XPath Queries. Asp.net, Visual Studio and Team Foundations Server

Confidential

Sr. Oracle Consultant

Responsibilities:

• Working with SAs to make the business logic processes correctly.
• Analysis and Tuning DB tables (very large tables) transactions and DB pkgs and Application Forms
• Design and Create WEB APP data mart.
• Data conversion/migration from JAVA application XML files to DB tables/Collections.
• Create and update DB pkgs and functions/Procedure as Business Requirements.
• Data loading and ETL for among CDW, OOD and ODS /CDB data systems.
• Analysis CRM ODS, CDB, DAS system and enhancement of data integration/Migration among Data warehouse, DAS, OOD,MOE, and ODS systems.
• Create/ Update, TEST and Debug Oracle Forms for FSDM systems.
• Create and test new Oracle reports for FSDM systems
• Support FSDM System Form/Reports Application.
• Migration Oracle Form/Reports 10g to oracle Forms/Reports 11g with WLS and Oracle Fusion Middleware.(Dev)

Technologies: Funds systems, Oracle Database 10/11g, Data Modeling/Tuning, PL/SQL, Oracle Application Server (10g), Oracle Form /Reports 10g/11g.Data Warehouse (CDW), Oracle CRM (OOD), Cognos BI, ETL, Sqlldr, Data Cleansing/Migrations/Mapping/Integration, XML/XSD, WLS 11g, Oracle Fusion Middleware 11g, SOA, TOAD, LDAP.CVS.

Confidential

Technical Leader)

Responsibilities:

• Working with BAs to make sure K246 (Business Requirements) correctly.
• Analysis of all impacted objects including Database objects, B2B mod files, API, Batch Files, UNIX shell scripts and Oracle forms.
• Design work object class diagrams, sequence diagrams, screen modified docs.
• Develop/Build APIs,DB pkgs,Unix scripts(including to use sql loader to load files data to DB stage tables) to handle data transformations.
• Analysis and create scripts to data cleaning and data integration for specific market DBs.
• Update, Create and Debug Oracle procedures/pkgs and Forms.
• Create database tables, types, view and modify database physic data model.
• Prepare the promotion forms for deploying to test and production markets
• Diagnose incidents, restore data and ensure data integrity, and liaise with physical DBAs to backup, and optimize data base performance.
• Support STAR LSP Oracle Form-Basis web applications
• Manage / Support on /off-shore team members in developing/testing/maintaining

Technologies: Knowledge of multiple-tiers architectural design, Data Modeling/Tuning,. Pl/sql, Sqlplus, Oracle Database 10g/11g, sqlldr, oracle Packages/Procedures.Data Cleansing/Mapping/Intergration, Oracle Application Server (OAS), Oracle Form10g, Data Models, Unix Scripting (ksh) and Batch processing,Java B2B, Web servers. API, Web Services. XML, DTD, IBM AIX 5.3, ksh/bash, Putty/ftp, TOAD and PL/SQL Developer. SVN Source Control/BundlenTool.

Confidential

Senior Technical Analyst/Oracle Consultant

Responsibilities:

• Develop, and support logical data models of packaged applications.
• Management and support of large Oracle databases(8TB 10g).
• Diagnose incidents, restore data and ensure data integrity, and liaise with physical DBA’s to backup, restore, and optimize data base performance.
• Analysis and create scripts( Unix and oracle plsql ) to handle data loading and data clean/transformation between applications and DB.
• Create scripts to analysis missing/discard data records and reload cleaned data into DB.
• Analysis and Tuning procedures to handle very large tables (table size >100g with 36 partitions, 7 yrs history records) performance in batch jobs.
• Support JDA applications that support forecasting, planning and replenishment .
• Deploy JDA patch on WebLogic Cluster servers.
• Interact and work with ISS/TSV resources to manage ‘physical’ and infrastructure DB functions (e.g. install, maintain, and operate Oracle SW)…..
• Develop a broader ‘architectural’ view/knowledge of the IPFR solution pertaining to infrastructure and application aspects, be the prime liaison with ISS/TSV.
• Take part in trouble shooting and issue resolution.
• Develop, Test, Build and Deploy new pl/sql, and Unix shell scripts/codes to DB and productions servers.

Technologies: Knowledge of 3 tier Client/ middleware /Server architectural design . Pl/sql, Sqlplus, Oracle Database 10g/11g, oracle Packages/Procedures.Data loading, cleansing/migration/transformations, Toad, sql developer. Oracle Web Logic 9.2 with clustering (12 app servers in the cluster ),Working and supporting package applications in Oracle/AIX environment, Large AIX infrastructure in a logically partitioned (8 lpar- 2 for DB serversand 6 for App servers) environment, Unix, Risk 6000 environments, Unix scripting (ksh), Java, JDA Application package. Management of Web Servers. IBM AIX 5.3, ksh/bash, Putty/ftp.

Confidential

Senior Oracle consultant/Form Developer

/Responsibilities:

• Create new oracle forms for the project.
• Migration old form system (SQL* Form 3.0 on VMS system) to Oracle FORM 10g on UNIX and Linux system.
• Change the codes in all forms matching Form 10g specification.(i.e. field ->item)
• Modify the form structures based on company standards and business rules.
• Update pro*C code and create external procedures used in the forms.
• Create packages and proc/funs in database used for oracle forms.
• Create packages to write/read, transfer files between ftp server and email report errors
• Create a job and schedule to handle the upload files on everyday.
• Create Oracle reports and run reports using srw.run report, email reports running status.
• Convert OpenVMS scripts into oracle database package,functions/procedures.

Technologies: Database 10g/11g, Oracle Application Server 10g, SQL, PL/SQL, OC4J, Oracle Forms/Reports 10g, Pro*C, VMS, IBM AIX, Linux, ksh/bash, emacs, FileZilla FTP, Putty, pl/sql developer/Toad.

Confidential

Senior Oracle consultant

Responsibilities:

• Create all functions, procedures and packages used in oracle reports
• Setup/Configuration/Maintenance Oracle Application Server 10g
• Create samples and temples of oracle reports for junior oracle report developers
• Manage all report data in Database level (i.e. use Cursor Variable to handle all query data in oracle report 10g)
• Deploy packages/Oracle reports on OAS 10g server and Test them.
• Modify the database structure based on business rules changes using Erwin.
• Call Oracle reports using WEB services from JAVA Based Front End.

Technologies: Oracle Application Server 10g, Database design, PL/SQL, Oracle Report 10g, Web Service, J2EE, TortoiseSVN (SVN).

Confidential

Oracle Support Specialist

Responsibilities:

• Extract Balance updated and non-Balance updated files from WW(Wageworks) data to MV (Meta Vante Database).
• Load daily card transaction data from MV site and load data into WW database staging tables, then post to WW database tables.
• Create packages/procedures/function and scripts to update or adjust all data in WW DB tables to synchronize the data between WW site and MV site.
• Fix bugs for PSQ cases. Using VPN, Oracle 9i/10g, PL/SQL, SQL*Plus, Oracle
• Responsible for Design, development, testing website Page/ files/pictures for the DoubleWei travel Inc. Using HTML, JavaScript, PHP, MYSQL, FTP, and Unix.

Confidential, Tampa, FL

Sr.Oracle developer (Team Leader)

Responsibilities:

• Responsible for development Oracle10g web based forms/reports, enhancement and bug fixing, database triggers/ procedures/functions/packages.Bugs fixed and implement the solutions into the existing OE oracle web based Forms/Reports system;
• Created new database procedures/functions/packages used in the OE forms for enhancements of new functions and business rules;
• Created/tested/migrated new oracle web based forms and reports to the OE Application;
• Create business requirement database tables, views and triggers for the maintenance and enhancement of the OE System, etc. using Oracle Datebase10g, Oracle Developer Suite 10g(Form 10g/Report 10g), Oracle Application Server 9i/ 10g, OC4J, PL/SQL Developer, WinSCP, Putty, Linux shell Scripts, Team track, Version Manager, Document Management.
• Gather and analysis the extracted text file data and load the data into the OE Oracle Database;
• Created/tested/migrated new oracle web based forms and reports to the OE Application using Oracle SQL*Loader, PL/SQL Developer and Oracle Database 10g, Oracle Developer Suite 10g(Form 10g/Report 10g), OAS 10g, OC4J, WinSCP, Putty, Linux shell Scripts, Team track, Version Manager.

Confidential

Oracle Programmer Analyst (Consultant)/DBA

Responsibilities:

• Setup Oracle developing/testing environment.
• Modify the database structure (Physical Model) based on the business requirements using Oracle Designer.
• Updated/Migrated Oracle Form 4.5 to web based Oracle 6i forms using Oracle forms4.5/6i, OAS9i, PL/SQL, SQL*PLUS and Oracle Database 7.3/8i/9i.
• Resolve the missing data, saving data and incorrect data issues.

Confidential

Software Developer/DBA

Responsibilities:

• Setup testing environment including install oracle DB and pl/sql tools;
• Create procedures for business users to generate business data;
• Created testing packages including test scripts and input test data;
• Tested all business cases and data for the Crown system;
• Create Oracle 6i reports for business users, etc using Oracle 8/8i, PL/SQL, SQL*Plus, XML, Oracle Report6i, ODBC, iRIMS Façade, MS Excel, Test Bug Track.
• Tuned the Oracle database and Oracle application servers (OAS) based on the tuning Procedures for the web based application using Oracle application Server 4.5, PL/SQL, UTLBSTAT/TLESTAT, OEM tools.
• Provided the web application supports for updating web pages to meet business needs;
• Modified a US presentation to Canadian and added French support;
• Built and maintained web based Blue pages project using Oracle DB 8i, OAS 4.5, XHTML, CSS,JavaScripts, ColdFusion and PL/SQL, PL/SQL Web Toolkit etc.
• Developed Oracle Stored procedures for translating data from other databases into Oracle Database and then generated Crystal reports using Oracle DB8, PL/SQL, SQL*PULS and Crystal report
• Supported and enhanced the Learning Administration and Plan System .
• Designed database schemas and developed stored procedures.
• Developed presentation layers using JSP and Struts framework
• Involved in system testing and documentation.

Technologies: WebSphere 4.0, TogetherJ 6.0, Sybase 12.0, EJB, Struts, Servlet, JSP, HTML, Javascript, Python, XML, PowerDesginer

Confidential

Responsibilities:

• Developed a Marketing System with a team size 10 for Norwich Union insurance company to check the policy holders and processing using PowerBuilder6.5/PFC, PL/SQL, Sybase.
• Designed and developed the Report module for the system to automate policy package printing and mailing in regular base.

Confidential

Oracle Developer

Responsibilities:

• Analyze, data modeling, enhance, maintain, test and implement systems;
• Create oracle database procedures/functions/triggers/packages and tables/views, forms (4.5) and report (2.5) by user using Oracle designer, Oracle DB 7.3/Forms4.5/Report2.5, PL/SQL, SQL*PLUS, Unix Server, Telnet, etc.