OBJECTIVE

Award-winning Database Professional with credential in MCDBA, MCITP-BI/DBA/Dev, Microsoft Certified System Engineer, and IBM Certified XML Developer have architect and develop over 10 yearsexpertise on database, network, and enterprise client-server

PROFESSIONAL PROFILE

Talent, self-motivated, results-driven design from scratch and delivered 10 Data Warehouses for 3 industries form scratch using Kimball's methodology to build Cubes with MDX. To provide analytic platform for analysts with automated reports via SSRS covering parallel period financial calculations, such as Default, Cash Flow, Drifts, Month-over-Month ,YoY Comparison, treading & forecasting

Experience in systems/network architecture, integration, security, deployment and administration in mixed UNIX and Windows environments for clients using SharePoint, WebService with Clustered SQL Servers for distributed OLTP, SSAS, and embedded database applications with LAN/WAN connectivity, security peripherals, and multi-platform design of Internet- and client/server/database-related applications in a heterogeneous environment with DB2, Oracle, SQL Server over 80 TB data

Recognize by peers and award from supervisors consistently, able to guide motivate, top-performing technical and application support teams in the Design, Testing, PM, Documentation, and support of client/server hardware, software, peripherals, and network operating systems. Lead SCURM meetings. Integrate well and have excellent communication skills with people from multi-national cultural backgrounds and fluent in English and Chinese

TECHNICAL SUMMARY

Database Management Systems: SQL Server 2000 - 2008, IBM AS400, Oracle, SYBASE IQ
Network Operating System: Windows Cluster Servers, HP-UX, IBM AIX, Linux, Solaris
Network & security: Active Directory, Centrex, DHCP, DNS, NIS, and ssh
Programming Languages (3GL/4GL): C, C#, HTML, VB, Java, Pascal, SQL, UNIX shell script
Integrated Dev Environments:pSOS by WindRiver, and Visual Studio.NET
Tools: EXCEL, Erwin, Embarcadero, DTS, SSIS, SSAS, SSRS, SQL Enterprise Manager, SSMS, SQL Profiler, sqlio, Dell and EMC Disk/Server Administrator, Rational ClearCase;Rose; ER/Studio, NETMON, PerfMon, traceroute, nslookup, ping, WinDBG, ODBC, SQLdm, OLEDB API, Sharepoint, Source Control , Visio, Total Advance Server and Service and Samba
Web Servers: Apache and IIS for Sharepoint
UNIX Windows Integration: Total Advance Server and Service and Samba

CERTIFICATIONS

• Microsoft Certified IT Professional: Business Intelligence Developer / Database Administrator / Database Developer 2005 - 2008 , Microsoft Certified System Engineer (MCSE), Microsoft Certified Trainer (MCT), MCDBA. IBM Certified Developer - XML and Related Technologies
• Microsoft Certified Business Management Solutions Specialist for Microsoft Dynamics GP
• Engineer-In-Training Certification from Texas State Board of Professional Engineering
• Certified Oracle Associate 11g

EXPERIENCE

Data Warehouse III (Lead)

Confidential, Arlington, TX

2010- present

Architect and administrate cutting edge analytic and reports Patient Encounters and Financial using Kimball data marts and Inmon Data warehouse

• Hardware performance tuning & capacity planning on SAN, CPU, memory, network, & licensing with SQL 2005 and SQL 2008. Migrate databases. Mentor other DBA and IT staffs
• Maintain data dictionary, implement database mirroring and snapshot
• Author SSRSreports with grid, charts, line delivery via subscription using .NET 3.0
• Automate and redesign existing Data Quality Auditing on Patient Encounters from EPIC etc
• Work across departments to gather requirements and ETL via DataStage and SSIS
• Migrate data across SAN and migrate physical model from SAS to Oracle

Principle DBA Architect

Confidential, Atmore, Alabama

2009- 2010

Architect and administrate solutions for multiple casinos to integrate databases such Bally One, CMP, Eatec, Microsoft Dynamics GP, GenetecSynergis using Kimball's approach

• Custom design Windows applications for data entry to databases using .NET on froms and web services
• Architect custom payroll with ETL using SSIS on the IP enabled security data result into recuperating $10,000/month and provide dash board report with parallel period metrics
• Architect Integration of OLTP to Data warehouse, SSAS cube, optimize and tune stored procedures, create constraints, triggers, function and develop and Pivot data with Excel
• Architect custom SSRS solution to identify run away meters which causes $1,000,000/ month by using linked servers to pull and parse XML data into relational and incorporate multiple time formats with reverse lookup of current Customer, demographic, tenure, market segment
• Design single version of truth with content push to Sharepoint for corporate web site
• Architect custom alerts from scratch with T-SQL, database mail, and IderaSQLdm for OLTP
• Last level support to supervisor and to C-level from multi sites servers to Win Mobiles

Senior Database Engineer

Confidential, Las Vegas, Nevada

2007 - 2009

Research and architect global Business Intelligence solution for the world largest slot manufacturing company and concurrently maintain high availability for customers liked Las Vegas Hilton, Hard Rock, and others

• Solution architect for SSAS and ETL from OLTP to data warehouse using SSIS and DataStage. Coordinate with various teams/customers to assistance them with the system & application\'s integration, rollout, and awareness training. Provide design support
• Trouble-shoot ETL, security, and resolve priority 1 issues at production by writing patches
• Secure & automate SSIS packages with SQL Server Agent Jobs by schedule and by events
• Deploy and configure SSRS for reports based on cube and relational sources. Enhance KPI
• Model physical and logical database on Customers, Slot, Table, Campaign into Star Schema
• Custom architect distribute data cleansing, aggregating, merging, and copying between data marts using DTS and SSIS. Map schema between the OLTP and OLAP
• Lead lifecycle of Internationalizing of data warehouse from Design to Verification
• Design Primary Key, Foreign Key, and Constraints to map to business model for Data Marts
• Design Dimension, Measure Group, partition, aggregation for MOLAP cubes with BIDS
• Work assigned projects (by utilizing various tools), allocate resource, identify risk and emerging issues, and estimated deliverable to internal teams and customers
• Assist with development & identification of process/procedures for hardware and software based systems and application. Prepare project checklist for milestones

Sr. Database Administrator

Confidential, Las Vegas, Nevada

2006 - 2007

Research and architect solutions to extend software functionality to provide database system to manage million players and thousand transactions per second from casino floor

• Model business with ER Diagram, mapping of logical model to physical tables.Refractor new architecture to support new requirements. Design cubes & global templates for report generations with Integration, Analysis, & Report Services. Lead migration from SQL 2000
• Provide extensive data analysis on business requirement, refractor existing design to support new requirement, translate functionalities to optimized queries and stored procedures, design and implement of working multi-tier casino management system
• Proficient in osql, VIEWS, and optimize T-SQL with SQL Query Analyzer using index
• Lead on database software development lifecycle from Design to Verification

Software Designer

Confidential, Richardson, Texas

1997 - 2006

Research and design solutions often from scratch with limited resources and supervision on a TDM and VoIP platform for AT & T, Motorola, Verizon, and other telecom service providers

• Define global standardize plan for implementation. Customize, define access, and distribute data cleansing, aggregating, merging, and copying between worldwide Data Marts from sources in ACCESS, flat files, Excel, Oracle, DB2
• Maintain 7x24 Cluster SQL Servers with Replication and Mirroring
• Advise, plan, and develop UNIX networks, script writing, configuration management tool, and software backup/recovery. Y2K Disaster Recovery Planning
• Lead on entire software development lifecycle from Design, Test, Patch, to Verification and quality in accordance with ISO standards with no priority 1 CR
• Develop test plan for Unit, System, Backward compatibility, Integration testing, including functional, browser compatibility, performance, installation, load tests
• Execute manual & auto test cases and report software defects in bug tracking system
• Become the representative to provide cross-departmental assist for verification & Customer Demo to Verizon's live systems. Troubleshoot issues and report quality issues
• Leverage technical learning curve and train internal groups on XML for Interactive Multimedia System (IMS) and UML for CDMA Design

Adjunct Professor (part-time)

Confidential, Arizona

2002 to 2006

Motivate and train students for degree with my real-world experiences at online university

• Lecture courses Microsoft Official Curriculum, including Programming Microsoft SQL Server Database and C# Programming with Microsoft .NET framework
• Advise in-depth of modern database system and future trends in .NET framework
• Guide, coach, and evaluate student's projects, assignment, and attendance
• Mentor students with weekly and monthly feedback to drive their strengths

EDUCATION

MS, Computer Science and Engineering received

AWARDS & ACTIVITIES

Top 20 Most Innovative Product of the Year, 2006, Casino Journal
Director of Logistic NTSSUG
Multiple Awards from Nortel Networks
Recipient of International Student Scholarship
Champion of CompuServe\'s Hang Sang Index