PROFESSIONAL SUMMARY

TECHNICAL & DOMAIN SKILLS

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.

* * * * *