SUMMARY:

• I have been working for Confidential in Seattle as Senior Database Administrator/Developer for 5 years plus 4 months.
• I often assumed multiple roles, as solution architect, data modeler as well as team leader.
• Main tasks includes but not limited to: business requirement gathering; data analysis; logical & physical data modeling; architecture design; detail design (such as source - to-target mapping specification and/or loading job design) etc.
• I use SQL extensively to query the data mostly in Oracle and MS SQL Server database.
• Also do programming task (such as ETL scripts, SQL scripts, PL/SQL or stored procedures, triggers).
• I often use Microsoft Office (MS Word, Excel, and PowerPoint) to produce all documentations or presentations needed when doing my job, and use Erwin and/or Visio to do data modeling and architecture design job.
• I sometimes become instructor too, conduct IT trainings for clients and/or business partners.
• The topics covers product trainings (such as CA Advantage Data Transformer - ETL tool, CA Service Desk, CA Erwin Data Modeler, etc), data modeling (introduction or related to data warehouse), etc.

LATEST TECHNOLOGY FOCUS:

• SQL Server 2008R2
• SSRSe
• SSIS
• SSAS

PROFESSIONAL EXPERIENCE:

Senior Database Administrator/Developer

Confidential

Responsibilities:

• DBA tasks (backup/restore, maintain indexes, etc)
• Data modeling/database design
• Maintain data quality
• Data import/transfer/migration
• Data replication
• Failover thru database mirroring
• Build data warehouse and business intelligence reporting system
• Report creation (operational and analytical)

Confidential, Seattle, WA

Senior Database Administrator/Developer

Responsibilities:

• Having the database administrator and developer role, the responsibility includes all the DBA tasks such as backup/restore, maintain indexes and statistics, maintain data quality, data migration/transfer/import from various systems and types of data storage, build and maintain database mirroring, build and maintain data replication, do programming tasks (mostly in SQL) to support application systems.
• With this position, I also perform data modeling/database design task, reports creation using SSRS, design and build data warehouse with several subject areas using stored procedures and SSIS, and build statistical/analytical reports using SSAS.

Confidential, Bellevue, WA

Data Migration Specialist

Responsibilities:

• Main tasks are to gather requirements, to produce architecture design, and to guide the developer team during the implementation phase.
• Covers 8 types of metadata sources from 2 application systems. Metadata model and architecture design are produced using Visio (UML).
• Data Warehouse Project for Confidential Insurance in Malaysia, as the data warehouse architect as well as team leader.
• Main tasks is to produce the DW blue print, ODS and DW data model, architecture and detail design (including ETL source-to-target mapping design), and to lead the project team throughout the whole project phases.
• The software used are MS SQL Server database, SQL Server scripts, CA Advantage Data Transformer (ETL tool), Erwin (data model), CA OLAP (BI tool).
• Data Warehouse Project for Nanyang Polytechnic in Singapore, as DW architect, to design the data model for their data warehouse. Data model is produced using Erwin.
• Data Warehouse Project for MPA in Singapore, as DW architect, to do requirement analysis and provide the high level design (blue print) of their enterprise DW.
• Metadata management project for MHA in Singapore, as Oracle SQL developer.
• Creating hundreds triggers on hundreds tables in order to create an audit trail mechanism and report on who create/update/delete records in the database.
• Involved in the whole project cycle, from requirement analysis till the user acceptance test phase.
• Main task is to design the data warehouse which covers 6 subject areas, i.e.
• Inventory Management, Account Receivable and Rebate Management, Prepaid Card Management, Prepaid Network and Revenue Management, Fraud Management, Post-paid and Roamer Network Management. This project used Oracle database, Infopump and PL/SQL as ETL Tool, BusinessObjects as BI tool, Erwin as data modeling tool.
• Involved in the full life cycle, to design and develop the data warehouse which covers 7 subject areas, i.e. Customer Retention, Customer Acquisition, Channel Fraud, Billing Analysis, Customer Loyalty, Network usage, Service Planning.
• This project used Oracle database, Infopump and PL/SQL as ETL Tool, BusinessObjects as BI tool, Erwin as data modeling tool.

Confidential

Senior System Integration Specialist

Responsibilities:

• Data Warehouse Project for Confidential Excelcommindo Pratama, a mobile phone company in Indonesia as DW consultant.
• Involved in the full life cycle, to design and develop the data warehouse which covers 3 subject areas, i.e. Customer Activation, Billing and Payment, and Call Data Record. The technology used for this project is Informatica, BusinessObjects and Oracle database.
• Migration/Conversion Project for Confidential, the central bank in Indonesia, as Deputy Project Manager and System Analyst.
• This project is to rewrite their foreign loan administration application from Confidential, FMS and RMS flat file, to Pro* Confidential, Oracle database and Oracle tools. Both old and new applications are running on VAX/VMS platform.
• Retail Banking System Project for Pacific Bank in Malaysia, as consultant. The project goal is to build teller front-end system using Digital Confidential (Financial and Banking System), and connect to banking back-end system.
• Retail Banking System Project for Confidential in Malaysia, as consultant.
• The project goal is to build teller front-end system using Digital Confidential (Financial and Banking System), and connect to banking back-end system.
• Main tasks are to assist the bank to do migration of their Ingress application from HP/UNIX platform into VAX/VMS platform, and to produce Standard Operation Procedure.
• Retail Banking System for Confidential Rutji in Indonesia, as system analyst and project team leader.
• The project goal is to develop retail banking system using COBOL running on VAX/VMS platform.