SUMMARY:

• IT professional with 20 years of experience and specialize in SQL programming and database engineering for large enterprises and US government. Proficient to use the major skills and developing tools from Microsoft technology systems. Have efficacious knowledge to analyze data for social culture, health care, retail and financial business. Good tracing history for building high requested business solutions.

TECHNICAL SKILLS:

• SQL Server
• PLSQL
• Stored Procedures
• Dada Modeling
• Data Warehouse
• ETL
• SSAS
• SSIS
• Replication
• TSQL
• SSRS
• .Net 3.0
• Metadata
• Data Mart
• TDE
• Normalization
• Data Performance
• Cube
• Oracle
• Full - text search
• OLAP
• Failover Cluster
• MDX
• ADO

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta GA

Sr. DBA/BI Architect/Data Warehouse Developer

• Data Modeling: Create relational database for retail raw data. Physical design with primary key and foreign key. Design DataWarehouse with Fact tables and Dimensional tables.
• BI Architect: Design application interface to meet business requirement, and build co-related query to reflect the action between the application and human being.
• ETL Process: Build ETL included TSQL, PLSQL, and SSIS package to transfer large size of data from MySQL, Excel, and CSV file to MS SQL, with Slowly Change function.
• DataWarehouse: Design star schema for cubes. Create cube with SSAS.
• Data Analysis: Design high level SSRS report by CTE and MDX. Create Excel Pivot table by pulling data from cube with Power BI, Pivot Query.
• Administration : Database backup and restore, SQL server agent and jobs execution plan. Database security control. System performance with index, partition and environment clean. Set up Cloud environment with Window Azure. Running the special query against Hadoop.

Confidential, Atlanta GA

Sr. SQL DBA/Developer

• Data Modeling: Collected data from different sources. Reorganized and consolidated data in a cloud environment with Azure.
• Administration: backup and restore. Cleaning up transaction log, removing duplicate and checking accuracy on data.
• Data Report: Complicated scripts with CTE, Stored Procedure and functions. Big data running performance.

Confidential, Atlanta GA

Database Administrator

• Data Replication: Setup data publisher and subscriber to disturber data between environments.
• Administration: Database application maintaining; data import and deleting.
• Dashboard and Report: CTE for complicated data join and Hierarchical relation to dig in.

Confidential

Database Administrator

• Administration: Transparent Data Encryption (TDE). Back up and restore encrypted data files to different SQL Servers. Troubleshooting database issues and clean database to optimize database performance for large size of database.
• Support: Suggest the technical teams to use right tools to find the SAN related database issue.

Confidential

Senior SQL DBA

• Administration: Tuning SQL server hardware resources and programming coding. Optimal database and application performance with MS SQL Server 2008 R2.
• Support: Troubleshooting database issues for large application. Apply complicated business rules

Confidential

Database Engineer

• Architecture: Design entire decision support system with Microsoft technology. Setting and apply technique standard on each develop ing phase. Provide project doable presentation.
• Modeling: Data architecture for Cloud Database. Logical and physical modeling on data which can be process by SSAS .
• Database Development: TSQL, ETL process (SSIS), SSRS. Full-text search with index. Data analysis with cube, matrix as a BI role.
• Programming: Full-text search with index service. Setting developing and programming environment to generate system metadata. Build document searching application by Microsoft Reporting Services.
• Server Administration: Perform job function for Data Center Administration; Maintain Cluster environment; Server tune up to enhance system performance with MS SQL Server 2008 R2.

Confidential, San Antonio TX

Senior SQL DBA/Architect/BI

• Data Modeling: Datawarehouse architecture with star schema for building cube, matrix.
• Systems Design: SQL server architecture with SAN and RAID 5 for stage, product, develop and testing environments.
• Production DBA: Database security, data performance, data replication with MS SQL Server 2008 R2. Perform database disaster recovery by back up and restore.

Confidential

Senior SQL DBA

• Data Mining: DB2, Oracle, and SQL server environments. ETL process with SSIS, Informatics.
• Migration: Convert DTS packages to SSIS packages with MS SQL Server 2000 and 2008 R2.
• Development: Design new SSIS packages to implement the business solutions.
• Normalization: Complicated query for mainframe database clean.
• Consulting: Technique opinion on SQL server installation, administration, and standards on database developments.

Confidential, Arlington VA

Database Engineer/BI Developer

• Database Model: Participation in designing related database architecture. Dataflow diagram and data query with Oracle.
• Reporting: PLSQL. RDL, XML for complicated finance report design. Setting security environment for report server.
• Data Analyze: Finding the best solution to present and analysis the finance information and business mode to clients.
• Ad Hoc Report: Build ad hoc report models. Training user for build report.
• Documentation: Writing business document for project implementation.

Confidential

SQL DBA/BI Developer

• ETL process: Create and modify SSIS packages to convert and transfer data from outside of MS SQL server 2008 R2 with Cursor and configuration file.
• Data modeling: Dataflow diagram for data logical modeling. Snowflake schema
• Replication: Data copy distributed by transaction log from developing environment to testing environment. Perform database disaster recovery by back up and restore.
• Reporting: Stored Procedures. TSQL. RDL, XML for customizes report design.
• Data Analyze: Create cubes and dimensions with SSAS.

Confidential

SQL DBA/Developer

• Reporting: Stored Procedures. TSQL. RDL, XML for customizes report design. Administration for MS Reporting Services. Enhance existing reports. SSAS.
• Database: SQL 2005/2008. SSIS. Design query to apply complicated business rule and data calculation by stored procedure. Temp Table. Data Warehouse. Data converting and clean up.
• Analyze: Finance data analysis to meet business management’s requirements on report’s design.