About Me

PROFESSIONAL SUMMARY

Overall, I have 15 years of experience in Analyze, Design, Program and Maintain Enterprise Information by using SQL Server, DB2, MySQL and ORACLE Databases. Specifically, I have 6 years of experience in OLTP and OLAP Data Architect and 3 years of experience in SQL Server DBA. I have sound knowledge in Business Process Model, Entity Relationship Model, Dimensional Data Model and some knowledge in Unified Modeling Language with Zachman Framework.

TECHNICAL & DOMAIN SKILLS

Data Architect Tools IBM RDA 7.0, MS Visio 2010, CA Erwin
Database Applications MS SQL Server, ORACLE, DB2, MySQL
Database Administration MS SQL Server 2005, 2008 R2 & 2012
BI Tool Applications Crystal Report, DTS, SSIS & SSRS
Domain Knowledge Health Care, Health Insurance, Finance, Sales and Aviation

ROLES AND RESPONSIBILITIES

Data Analyze

  • Investigate Enterprise’s Operation through Business Process Model.
  • Educate Enterprise’s Vertical and Horizontal Operational Flow to I.T. Team.
  • Prepare System Specification with Cross Functional and Data Flow Diagram.
  • Define and Maintain Database Capacity Plan and Growth Monitoring Statics Report.
  • Analyze and Define “Data Transmission Rules” for Data Cleaning and Integration Job.

Data Architecture

  • Design Data Mart Database?s Logical and Physical Database?s Data Structure.
  • Transform UML Class Architecture into Data Architecture in Forward Engineering Job.
  • Re-engineering Legacy Database?s Physical into Logical and Conceptual Data Structure.
  • Transform XSD Structure into Database?s Conceptual, Logical and Physical Data Structure.
  • Audit Legacy Data Architecture with Transitive, Non-trivial, Lossless Join Mathematic Technique.

Database Administration

  • Installation, Configuration and Upgrading of Microsoft SQL Server 2005/2008/2012.
  • Create and Maintain Databases in Development, Staging and Production Environment.
  • Create and Maintain SERVER, DATABASE, OBJECT Level USER Role and Authentication.
  • Create and Maintain Full/Increment/Log Databases Backup and Restore based on Strategy.
  • Create, Monitor and Maintain INDEX through pre-defined Stored Procedures.
  • Re-write complex SQL Query, Stored Procedure based on SQL Query Execution Plan.
  • Analyze and design Table Partition based on Business Unit, Geographical and Transaction.
  • Create and Maintain SQL Server Agent JOB Schedule and Error Log Information.
  • Monitor and Maintain Database Performance through WINDOW & SQL Server Profiler.
  • Deploy DTS, SSIS and SSRS Project Solution in Development and Production Environment.

* * * * *


Thanks for visiting www.data-e-education.com