EXECUTIVE SUMMARY:

• 10 years’ experience in Data Warehouse Steward specializing in Database Design/Modeling of relational DB and multidimensional data cube, with different EDW architecture choices.
• 10 years’ experience in Data Modelling activities and Business Intelligence Tools
• Hands - on experience on Data Warehouse schema / Data Marts design, including dimensional modeling, DW star and snowflake schema design and slow-change dimension solution design.
• Designed and implemented Delta data management solution.
• More than 15 years database design and development experience, strong knowledge about general relational database design, development and implementation.
• 15 years data analyst experience on Data Profiling/Data Quality Control and Metadata Management.
• Expert in Metadata management, naming convention design, Delta process solution and data governance process.
• 15 years ETL development/design experience with PL/SQL, Datastage and SSIS tools.
• Strong PL/SQL programming experience against Oracle8i/9i~Oracle11g, SSIS/SSRS development experience with SQL Server Database.
• Experienced on SQL performance tuning and execution plan analysis.
• More than 10 years’ experience with Enterprise Data Warehouse Reporting and Production management ad-hoc reporting in the Financial Investment and Insurance industry.
• Seven years WebFocus7i (BI tool) development experience on Enterprise reporting, Including BI Dashboard development, MRE report design, ReportCaster schedulingdistribution method design and report application development.
• Successful experiences with multiple major system migration/conversion projects on data mapping, data cleansing and validation, plus a few Operational system integration to process highly integrated data flow between source and target systems on a daily basis.
• Extensive experience on business requirement gathering and solutioning, providing impact analysis and effort estimate.
• Strong experience on regular development life cycle timeline planning.
• Strong experience on enterprise reporting production support, including daily batch process monitoring, data quality and user access
• More than 10 years Web application development experience based on J2EE and Spring Framework technical standard with HTML, JSP, VB Script, Struts, Torque3.0~4.0 (Hibernate3), Tomcat/JBOSS
• Good understanding and practices with both Agile and Waterfall development methodologies.

TECHNICAL SKILLS:

RDBMS: Oracle9i~11g, MS SQL Server 6.5/2008R2, MS Access 97-95-2.0, MySQL, DB2

Languages: PL/SQL 8.0-2.3-2.1, SAS, FOCUS language,Java, JavaScript, VBScript, Visual Basic, ClearBasic, XML 1.0, Unix shell script, Python

Tools: SQL Server Management Studio 2008, DB visualizer, TOAD10, Quest SQL Developer, SQL Navigator, SQL Loader, SSIS, SSRS, WebFocus Developer Studio767~7703, Seagate Crystal Reports 5.0 ~ 9.0, SAS, MS Visio, ErWin 3.x/ 4.x/7.x/9.x, MS Visio, SQL*Report Writer1.1, Rational Rose, Rational TeamTest, Eclipse, MyEclipse, SVN, GIT

Utilities: WebFOCUS67~77xx Developer Studio, DataStage, Tidal, JBuilder, JDK 1.3~1.4, Tomcat3.3, Tomcat4.1, Tomcat5.x, JBoss-3.2.7

Applications: GuideWire CC/CM/PC/BC, Sim Corp, MetaSolv TBS 4.0.x~5.1.x, CBP, Eftia, Clarify, NetDoc

Operating Environments: Windows XP, Windows NT 4.0 /98 /95 /3.11 , Unix Sun OS 5.x, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead/Data Modeler

Technology: Erwin 7.x~9.x, DataStage 8.5, SAP Service 4.2, SAS, Mainframe, Cognos 10.1/10.2.2 , SQL Server Database, Oracle Database, DB2 Database, GuideWire ClaimCenter, GuideWire AccountManager, GuideWire PolicyCenter, GuideWire BillingCenter.

Responsibilities:

• Production Support Incident Management/Monthly Release
• Working as a Technical Lead for BI Reporting Production Support, my main responsibility is incident management with ServiceNow.
• Incident triage/analysis - requiring information from business and technical/data analysis to identify if the incidents are existing production issues or potential enhancements
• Presenting investigate result and incident root cause
• Providing possible solution and impact analysis
• Planning implementation schedule based on resource/effort estimate
• As production DW data modeler, responsible for production Data Warehouse schema update and maintenance for business scope expanding and functional enhancement.
• Helped data query and ETL performance at DB definition level.
• DW schemas including star schema, aggregated multidimensional data cubes and daily captured delta storage.
• ER Diagram upgrade and maintenance
• Troubleshooting and optimizing current data flow design

Confidential

Senior Data Analyst / Data Modeler

Technology: Microsoft SQL Server 2008, Microsoft SQL Server Integration Services, Microsoft SQL Server Management Studio 2008, MS SSIS/SSRS 2008, DB2, DbVisualizer 9.0.9, Microsoft Visio 2010, ERwin Data Modeler9, Datastage8.5.

Responsibilities:

• Data profiling per business requirements
• Data mining based on different business units
• Data extraction and validation
• Supported De-Identification risk analysis at the enterprise level as data modeler, my job including
• Evaluating existing Legacy systems
• Updating and optimizing metadata model
• Developing better practices for data coding to ensure the consistency within the system

Confidential

Senior data analyst

Responsibilities:

• Providing Legacy system ER diagram
• Collecting conversion scope and business requirements for migration project
• Verifying staging database capability and scalability
• Providing business subject mapping with iteration methodology
• Supporting data development job with data flow design and optimizing data process
• Updating design documentation
• Collaborating with UAT testing team for functional test and data reconciliation team for data quality control.
• Worked on migration implementation rollout plan about system capacity and volume analysis. Provided the prototype process of ETL data flow.
• Designed backfeed integration process between Legacy Billing system and new account & claim management system for daily data display.
• Based on conversion data model knowledge helped the target system functional team with gap analysis and business process designation.

Confidential

BI Specialist

Technology: WebFocus 767(MRI,ReportCaster,ReportingServer)~ 77xx, SQL Server 2008, SSIS, SSRS, Windows XP, Windows Server 2003

Responsibilities:

• Design and support client BI reporting system implementation plan, finished reporting server installation, configuration and optimization.
• Provided future upgrading options and alternative reporting solutions.
• Documented business/technique requirements for code review.
• Reviewed client Data Warehouse (data cubes) design scalability and compatibility for business growth.

Confidential rd)

BI Consultant / Senior WebFocus Report Developer

Technology: Erwin 4.x, WebFocus 767(MRI,ReportCaster,ReportingServer)~ 77xx, Oracle 10g~11g, Toad 10.5, Java, DataStage, Tidal, Eclipse5 .x, Torque 3, Windows XP, Windows Server 2003

Responsibilities:

• Designed OLAP data cubes for Risk Management and Portfolio management reporting.
• Designed BI Solutions based on the Enterprise BI standard and created BI development specifications.
• Performed and supported unit test, QA test, and responsible for performance tuning and optimization.
• Created development documentation, code promotion process, implemented manual and operational plan.
• WebFocus Reporting Application code migration and environment upgrade. Involved with Report Server configuration and Application Server (where WebFocus Utilities resides) library installation. Working with QA and performance testing to investigate the potential optimization recommendation for the entire Reporting system and Enterprise data warehouse process.
• Provided documentation for each environment findings & solutions. Reviewing test plan for functionality and performance test.
• Data preparation with SQL pass thru and HOLD file data cleansing.
• Retrofitting the process to convert into an enterprise reporting database model.
• PL/SQL data extract, Data cleansing and conversion,
• SQL performance tuning
• Partially enterprise reporting database modelling.
• Worked on application performance improvement for both application design and data preparation.
• Finished report design and programming.
• Designed the slow changing dimension storage and reporting.

Confidential

Business Intelligence Specialist

Technology: MS SQL Server2003~2005 Enterprise, Oracle 10g, PL/SQL 10g, Crystal Report, ERwin7, Tomcat 6.5, Struts1x., Informatica PowerCenter 9, Toad 6, MS Visio, Eclipse, Torque 3, Windows XP, Windows Server 2003

Responsibilities:

• Planned database storing method
• Designed management strategy for Sales Monthly Report.
• Provided auto loading process for multiple formatted client data
• Provided on-going solution for data cleansing and transformation with PL/SQL & Informatica ETL tool.
• Built Crystal Report on top of the reporting database to provide real-time data to the Sales team
• Built procedure to maintain slow-changing dimension table and daily refresh process to retrieve fast dimension change from operational system.

Confidential

Senior Programmer Analyst / Data Modeler

Technology: Oracle 8i-9i, PL/SQL 8.0, SAS, Tomcat 3.x~Tomcat 6.0, ErWin3.x, WebFOCUS 7.1.1~WebFOCUS 7.6.0, Informatica PowerCenter 7~8, Business Objects XI, SAS9i, Talend Open Studio, JavaScript, Struts, XML, ASP, Crystal Report7~9, SAS 8, Windows NT 4.0~XP, Windows Server 2002~2003, UNIX SunOS 5.6

Responsibilities:

• Provided Mid Level modeling and partial physical modeling for operational systems
• Collecting source data and preparing staging tables.
• Designed DW database schema according to business forecasting requests. Mainly using star schema to display all dimensions at one flat level for Service Delivery and Task Activity data marts.
• Evaluated DW database objects structure design normalization and denormalization degree based on physical I/O forecasting.
• Provided a diverse load window and load solution for DW fact data and dimension data refresh.
• Created partition tables plus indiscriminate data replacement for most fact data refreshment, using timestamp identification expiration flag to capture changed fact data as well.
• Used database trigger to capture changed dimension data for I/O performance and data load consideration.
• Successfully implemented 3 major system integration projects. Those are mainly related to ETL solution design and data warehouse environment building with either BI tools or PL/SQL programming.
• Defined the integration scope as data modeler for order management system operational data.
• Created data marts for different business unit data models.
• Maintained and managed Metadata to standardize workflow components. .
• Provided solutions to tag similar data from different systems, the opportunity in CRM and the real order from order management systems, and finished their integration in the warehouse environment.
• Developed reports to company Intranet dashboard (web application).
• Achieved automated account loading process with mainly PL/SQL programming.
• Responsible for company enterprise report system management tool -- Dashboard design and implementation
• Achieved from SAS reports to SQL based reporting script transformation.