PROFESSIONAL SUMMARY

• Master of Business Administration in Management Information Systems with six years’ experience of data analysis, relational database development and implementation, OLTP, OLAP, Oracle database, MS SQL database, DBA, ETL, SQL programming, business intelligence solutions, Business Objects, data warehousing and data mining.
• Professional experience of most advanced Oracle 10g, 11g Database server installation, user account setup, PL/SQL, sqlplus, SQLLoader, load variety of data into Oracle database tables, generating reports.
• Microsoft Certified IT Professional.
• Expertise in Microsoft SQL server database administration, database design, performance tuning, writing complex T-SQL queries and generated varieties sorts of business reports.
• Ability to develop data ETL process, SSIS, SSAS, SSRS, and perform data validation and verification.
• Experience with pulling data from multiple data sources (Data Warehouse, Data Mart, SQL Server, Oracle, SSAS Cube, MS Access, flat files, Excel files).
• Hand-on experience in data warehouse development and implementation, and reports generation.
• Supported daily operation and monitored database and application performance.
• Created, maintained and implemented database backup and recovery plan.
• Ability to prioritize and complete multiple tasks and detail oriented.
• Creative and adaptable team player in fast-paced technology environments.

TECHNICAL SKILLS

Database:
RDBMS design and management including MS SQL, ETL, data analysis, data mining and reporting using T-SQL, SSIS, SSRS, SSAS. MS Access.
Oracle 10g, 11g, sqlplus, SQLLoader. Toad. Oracle SQL Developer.
Data warehousing and data mart.
Business Objects/Crystal Reports.
CRM system. ERP system.
Language: SQL, Java, HTML/XHTML, CSS, Asp.net.
MS Office: Word, Excel, Access, PowerPoint, Outlook, Publisher, Project, Visio, SharePoint.
Operating Systems: Windows 98/2000/XP/Vista/7, Windows Server NT 4.0/2003/2008.

EDUCATION
Master of Business Administration in Management Information Systems

PROFESSIONAL TRAINING AND CERTIFICATIONS
Oracle 11g
Microsoft SQL
Microsoft Certified IT Professional: Database Developer
Microsoft Certified Technology Specialist: SQL Server
Microsoft Certified IT Professional: Database Administrator
Shenandoah University Certificate in Information System and Computer Technology

SELECTED ACHIEVEMENTS:

• Supported business decision making process by planning, preparing and deliver accurate analytical reports.
• Supported day-to-day development by creating processes for data extraction, integration and transformation based on business requirements.
• Utilized various Business Intelligence tools and create complex SQL queries to produce analysis reports from various data sources, including different database platforms, SSAS cubes, data warehouse and data mart to support business operations and decision making process.
• Successfully managed and maintained company’s SQL server, designed and implemented business flow database including over 100 tables, 300 constrains supporting tasks in reporting, calendar scheduling, assignments, orders, tracking, accounting, and payroll models.
• Independently designed and implemented IT support SQL database with 20 tables and completed data migration from Access to SQL 2005 database utilizing ETL process, SSIS.
• Conducted database analysis, data mining for client’s National Authorized Service Center database; proposed and implemented database migration from MS SQL to Oracle platform; designed and implemented data warehouse.

PROFESSIONAL EXPERIENCE SUMMARY

Confidential,June 2011 present
Database Administrator/Communication Specialist

• In charge of over all database administration.
• Developed and managed data reporting system to support business operation.
• Generated various analysis reports based on business requirement.
• Designed and executed ETL processes, interface, and complex SQL queries.
• Developed and maintained company websites.
  

Confidential,November 2010 June 2011
Database Administrator/Database Developer

• Designed data solutions to improved applications and procedures for company and company’s clientele.
• Analyzed existing systems and applications and provided integration technical recommendations.
• Designed, created and modified databases and data warehouses; conducted data modeling, data mining and performance tuning based on specific business needs.
• Tested databases and made necessary modifications to correct errors.
• Planned, coordinated and implemented data update, extraction, transformation and database migration.
• Planned, coordinated and implemented security measures to safeguard information in databases against accidental damage or unauthorized access, modification or disclosure.
• Wrote database scripts to generate various analytical reports against databases and data warehouses on different platforms.
• Provided consultations on software demonstration, user training and support services.
• Developed and maintained company websites.
  

Confidential, May 2006 October 2010
Information Technology Support Specialist

• Conducted business data analysis for company and its clientele.
• Developed, and implemented MS SQL database, SSIS, SSRS, SSRS packages and data warehouse.
• Extracted data from MS SQL, Oracle databases, data warehouse into flat data files and excel sheet.
• Loaded data from flat file and excel sheet into MS SQL and Oracle database tables.
• Generated varieties kinds of business analysis reports and supported marketing campaigns.
• Developed and deployed ETL packages, complex T-SQL queries, stored procedures, functions, constrains and triggers to enhance business rules and database security.
• Provided demonstration, installation, training and technical supports to staff and clients.
• Developed and maintained company websites.