SUMMARY:

• I have developed expert level skills on Oracle database application system design and PL/SQL programming and I was a certified Oracle PL/SQL developer.
• I have five years experiences on ETL process design and program development for data warehouse and data mart in financial business.
• I conducted new requirement analysis, solution design for application enhancement and system improvement.
• I have eight years experiences as a primary developer on solution design for new request and customization on workflow, CMDB and system integration on HP Project and Portifolio Managemet application.
• I have perforemed on Oracle database design, data model and data mapping to import and process master and transaction data in various ITSM applications and industries.
• I want to pursue a career in database appplication system developer, data engineer, data scientist, BI specialist, ETL and data warehouse deveoper. Work status: US Citizen.

TECHNICAL SKILLS:

• Oracle Database PL/SQL Programming Data Warehouse/ETL UNIX Shell Script HTML/ XML Java Script
• TOAD/SQL Developer ERWIN Data Model RDMS Tuning SQL Server Database T - SQL CMDB ITIL ITSM
• ServiceNow HP Project and Portfolio Management HP Asset Management BMC Atrium System POB G6

PROFESSIONAL EXPERIENCE:

Confidential

Database Developer

Responsibilities:

• Lead HP PPM application development and administration on solution design for customization for all new business requests. Achieved near perfect application up time with dedicated efforts, proactive monitoring and system improvement.
• Created database PL/SQL programs for system integration, workflow activity and database back end automation processes. Created Oracle database stored procedures for CMDB data validation and importing process. Oracle certified SQL and PL/SQL Program developer.
• Managed software upgrade, changes request and full life cycle of application, including operational support, database archival and decommission.
• Performed master data management and CMDB implementation for dozens of customers in ServiceNow. Conducted steady state support for incident, change, service request, catalog item, category set up, report creation and sharing, defect detection and other areas in ServiceNow. ed a Silver Accolade for my outstanding performance and contributions.
• Worked as a team leader on new requirement and analysis for healthcare sector customers for ITSM applications. Performed solution design for system enhancement to improve operation efficiency and system availability, data quality, on time report delivery through adding new processes to monitoring and automation.

Confidential

MIS Lead Developer

Responsibilities:

• Performed application and process design as well as data analysis for online banking session and transaction portal sites to collect statistics on customer transaction activities.
• Created high level and detailed technical design specification and document for new MIS project based on business requirement and lead application design and programming.
• Designed ETL process and streamlined daily data warehouse loading to reduce operation time to meet reporting time requirement.
• Created stored database procedures and packages in both Oracle 9i and 10g to process a large volume of data loading and transformation. Enhanced existing data processes and improved program performance with database architecture design optimization, updating data flow, SQL tuning and table partitioning.
• Designed and developed database system migration plan for new data warehouse system platform from Oracle 9i to 10g and worked with DBA for new database objects creation.
• Lead offshore team for application development and provided technical leadership and guide on MIS applications and validated their work against specification and work schedule.

Confidential

ETL Analyst

Responsibilities:

• Worked as a leading developer in data warehouse process design and program development. Conducted process improvement and performance enhancement according new business requirement and provided support for data warehouse maintenance.
• Carried out data warehouse and data mart loading with SQL loader, PL/SQL program and UNIX shell scripting. Performed SQL tuning and bug fixing to improve data quality and data loading process efficiency.
• Designed data mart in data warehouse and analyzed data structure for policy premium and claim loss to provide a large volume of data for analysis in actuary department.
• Performed process design for data extraction, transformation and loading into data warehouse to build data mart and prepare data for business intelligence report.
• Coded a large number of PL/SQL programs in Oracle 9i to build various data mart and transform data into format specified by business requirement.
• Analyzed data quality issues inside data warehouse and performed troubleshoot the cause of data irregularity.

Confidential

Technical Consultant

Responsibilities:

• Performed system analysis and data architecture design for P&G pharmaceutical safety application using Oracle XDK and XML technology for data extraction and processing.
• Created numerous stored procedures or package in database server to improve program performance for front-end application. Created java stored procedure to perform operating system command for enhancement of database server process and integration.
• Completed data model design and designed process specification for electronic submission for medical case report to FDA.
• Designed and developed numerous application extensions for Argus Safety system using Oracle Forms 6i with advanced features in Oracle database environment. Integrated Active X control into Forms application as an application extension and enhancement. Created dynamic HTML document inside Forms 6i application. Incorporated complex business requirement into front and back end programming.
• Created UNIX shell script for file system management, data file editing, SQL loader and interaction between shell and database operation.
• Designed and developed database schema for financial transaction control process at Financial Service client. Created stored procedures to improve reporting performance and to facilitate other reports in one program so that huge amount of data can be retrieved. Designed complex financial revenue recognition and commission expense reports with Report 6.0 for accounting auditor.
• Worked as Oracle Manufacturing ERP technical consultant to customize major reports for customer invoices, GL account analysis, sales order acknowledgement, purchasing order and picking and packing slip for shipping to fit client’s business requirements.
• Designed imaging application forms as an extension for Bills of Materials in a three-tier application environment. The program can auto invoke standalone imaging software application or plug-in in web browser by downloading script from application server.