PROFILE

Over 15 years of experience in IT including Oracle / SQL Server Database Administration, Business Intelligence Analysis / Data Analysis / Modeling / Design, Data Warehouse, EDI Electronic Data Interchange , System Analysis, Architecture design and Integration, Network deployment, UNIX/ Linux Installation and Maintenance, Software Application Development, and Project Management.

TECHNICAL SKILLS

• Database Administration in SQL Server 2012/2008 R2/2005/2000 over 8 years, in Oracle11g/10g/9i 2 years
• SQL Server 2000/2005/2008R2 failover cluster design, deployment, installation, upgrade and migration database configuration, performance tuning monitoring, replication, backup and disaster recovery
• Work flow, Data flow, Data Modeling, Database and Data Warehouse Architecture Design over 8 years
• Strong data integration, data validation skills with SSIS, DTS and ETL stored procedure
• PL/SQL,T-SQL programming and performance tuning with large-scale, complex datasets over 5 years
• Business Intelligence Analysis MicroStrategy 4 years , Reporting Service SSRS, SSAS over 5 years
• Project development over 8 years. OLAP,OLTP skills
• System Analysis, Integration and Architecture design, Network deployment Technical Support and Troubleshooting over 10 years
• Mentor customer and entry level technician. Documentation Visual Paradigm, CA Erwin 9
• OS: Windows 2012/2008 R2/ 7 /Vista/XP/2003, UNIX/Linux IIS configuration
• Tools: VMware, MS Office suite, Visual Studio, Toad, Python, Putty, DOS scripts
• Knowledge: MYSQL, SharePoint 2010, ASP.Net/C , Cognos 8,OBIEE, Korn Shell scripts,SAP

WORK HISTORY

Confidential

Business Intelligence Analyst / DBA

Responsibilities

• Worked as DBA to install, design, create, migrate and maintain SQL Server database 2012/2008 R2/2005
• Analyzing data from Sage 500 and SalesLogix, synchronizing data among different databases, built Microsoft Report Server and creating Microsoft BI reports based on requirements
• Accomplishments
• Monitored Database SQL Server and implemented performance tuning. Improved performance 10 times
• Improved maintenance plan with the stable backups
• Extracted, transformed and loaded data for reporting purpose
• Built reporting Server and generated about 30 reports. Such as Commission report reduce time from 12
• Hours to 1 minute , Project Profitability report reduce time from 24 hours to 1 minute , Rebate report reduce Time from 16 hours to 1 minute , Invoice validation, Purchase Order validation, and so on
• Consulting with the external vendor to move data to a cloud based solution
• Created DBA database to manage complicated vendor prices and projects information
• Skills Used
• DBA monitor, performance tuning and Troubleshooting skills
• T-SQL scripting, SSIS, SSRS skills
• Business Analysis, requirements collection, data analysis, database design and physical database creation.
• Business Intelligence Analysis skills include reports generation skills

Confidential

Database Administrator/Business Intelligence Analyst

Responsibilities

• Worked as a DBA and provided technical support, 3NF, data modeling and database design
• Monitored database activity, integrity, security, and troubleshoot locks for high availability
• Database optimization, performance tuning, backup and recovery
• Worked as Business intelligence analyst, designed architecture, hierarchy, generated BI reports and dashboards
• Accomplishments
• Consulted Project Manager and Programmer for project solution, mentored junior staff for project expertise
• Established failover clustered SQL Server, Migrated database from 2000, 2005 to 2008 R2
• Created SQL Server 2008 R2 transactional replication
• Created database backup and disaster recovery solutions
• Accomplished projects TMS Transportation Management System and VMI Virtual Management Inventory ,
• Improved business performance up to 600 times
• Created data validation solution: proactively identified bad or dirty data into exception tables, scheduled jobs
• to automate fix data issue by using experience learned methodology, reloaded corrected data into database,
• improved data consistence and accuracy to 99.999
• Extracted, transformed, and loaded data from multiple data source EDI data, DB2 data, Excel file, etc. by SSIS and stored procedures
• Generated Web page for clients to load data into database
• Generated complex reports and dashboards on MicroStrategy 9.3.1 for management
• Documented all information into repository
• Skills Used
• Converted business requirements information into technical specifications and data model
• Programming skills to receive alert E-mail when redundant data identified or the scheduled job failed. Provided functions to rerun job from broken point and kept data consistent
• Designed and created logical, physical database and data warehouse with partition tables
• Best practice on database installation and configuration SQL statements and stored procedure optimizing and performance tuning
• Capacity and storage plan, Troubleshooting, back-up and recovery skills
• Documentation skills by Visual Paradigm
• Webpage design skills by Microsoft visual studios 2010 and ASP .Net
• Technical Environment

MicroStrategy 9.3.1 Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Office , SQL Server 2008 R2/2005, SSIS, SSRS, SSAS, ASP .Net, HTML, DB2

Confidential

Technical Support

Responsibilities

Solved technical problems in both hardware computers, network, peripheral and software Operating System and applications

Accomplishments

Solved the different issues for client

Skills Used

• Network connectivity troubleshooting
• Windows Operating System backup and reinstall, upgrading
• POS hardware replacement
• Telecom issues analysis and troubleshooting
• Data recovery
• Kill virus and prevent Trojan
• Small network and wireless configuration and wireless printer setup

Confidential

Database Administrator/ Business Analyst

Responsibilities:

• Analyzed business requirements, website contents and provided recommendations
• Synchronized data between two databases by using ASP .NET/C , SQL statements and API.
• Extracted data from website by python and API, generated reports for management

Confidential

Database Administrator / Business Analyst Educational Projec

Responsibilities

• Converted business information into data model, created and maintained database as required
• Interviewed customers and identified business requirements and defined business objects.
• Designed database architecture and created logical data model ERD with Microsoft Visio.
• Installed, created and managed Oracle databases on Unix/Linux or Windows based on requirement
• Database import and export, Administration, performance tuning and troubleshooting
• Generated business reports by Oracle APEX in website or by PL/SQL
• Backup and recovery strategies design and implementation
• Installed and configured Oracle database with version 10g.
• Created TAS Travel Agency System , loaded raw data from Excel file with SQL Loader, PL/SQL
• Created T-SQL stored Procedures for ETL and administration, practiced data warehouse and data mining
• Practiced Oracle RAC, Oracle Grid Control and Oracle Database Control
• Accessed multiple database cross platform by ODBC connectivity
• Created backup and recovery plan and implemented it with RMAN, Enterprise Manager, and auto user-managed backup scripts
• Technical Environment
• Oracle 10g/9i, MS SQL Server 2005/2000, Windows 2003 Server, Windows XP workstation, HTML

Confidential

Business System Analyst

Responsibilities

• Analyzed business requirements and provided system integration solution Installed operating systems, drivers, applications for PCs and performed technical troubleshooting
• Infrastructure design and LAN deployment, wireless configuration for home and small company.

Confidential

System Specialist volunteer

Responsibilities

• Answered user inquiries and performed network technical support and troubleshoot
• Trained clients with Microsoft office suite skills

Confidential

Database Administrator / Business Analyst

Responsibilities

• System administration and integration
• MS SQL Server database administration and project management
• Accomplishments
• Provided system architect design integration, and technical supports
• WAN/LAN Infrastructure design and deployment
• Business requirements collection and analysis, Work flow, data modeling design logical and physical database data warehouse design creation
• Database configuration, replication, maintenance and performance tuning
• SQL Server security, job schedule, troubleshooting, backup and disaster recovery
• Worked on project - IT Inventory Management System
• Data migration on SQL Server 2000, 2005 by T-SQL ETL stored procedure, SSIS, DTS
• Performed business intelligence analysis and generated reports by SSRS, SSAS and SQL query
• Managed employees payments
• Participated system integration testing and user acceptance testing
• Microsoft Windows XP/2000/2003 OS, Server - administration and support.

Confidential

System Analyst / Application Developer

Responsibilities

• Projects development, applications development, and software programming Turbo C, FoxPro
• Business analysis and system integration
• Database design and creation
• Technical support for marketing and financing