PROFESSIONAL SUMMARY

• Created, maintained and implemented database backup and recovery plan.
• Supported daily operation and monitored database and application performance.
• Hand-on experience in data warehouse development and implementation, and reports generation.
• Proven abilities of data integration and manipulation from complex data sources Data Warehouse, Data Mart, SQL Server, Oracle, SSAS Cube, MS Access, flat files, Excel files .
• Professional experience with BI tools, such as MS BI suite, Business Objects.
• Familiar with various BI tools, MS BI suite, Informatica, MicroStrategy, Oracle OBIEE.
• Proven abilities to develop ETL, SSIS, SSRS, SSAS packages and perform data validation/verification.
• Microsoft Certified IT Professional MCITP in SQL Server Database Development and Administration.
• Large dimensional database structure and design experience.
• Hands-on experience in data integration, manipulation and transformation processes.
• Hands-on experience in ERP system installation, configuration, customization and user trainings.
• Professional experience with ERP system implementation life cycle.
• Professional experience of most advanced Oracle 10g, 11g Database server installation, user account setup, PL/SQL, SQL Plus , SQL Loader, load variety of data into Oracle database tables, generating reports.
• Professional experience with data migration, integration and loading into databases and data warehouse on disparate platforms.
• Strong analysis, conceptual, communications, and technical skills to translate business requirement into solutions.
• Master of Business Administration in Management Information Systems with over 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, CRM, ERP systems, Business Objects, data warehousing and data mining.
• Expertise in Microsoft SQL server database administration, database design, data modeling, performance tuning, writing complex T-SQL queries and generated various business reports.
• Creative and adaptable team player as well as individual contributor with excellent people skill.

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, Oracle E-Business Suite, SQL Plus, SQL Loader. Toad. Oracle SQL Developer. MS BI suite, Microstrategy, Informatica. Data warehousing and data mart. Business Objects/Crystal Reports. CRM system. ERP system. Language: SQL, JavaScript, HTML/XHTML, CSS. MS Office: Word, Excel, Access, PowerPoint, Outlook, Publisher, Project, Visio, SharePoint. Operating Systems: Unix/Linux, Windows 98/2000/XP/Vista/7/8, Windows Server NT 4.0/2003/2008.

PROFESSIONAL EXPERIENCE SUMMARY

Confidential

Business Database System Analyst/Database Administrator

• Reviewed project requirements to define system specifications and develop project documentation and operating guidelines.
• Analyzed and implement advanced web-based programs and applications for complex information data management systems.
• Evaluated project requirements for new or modified programs to determine feasibility and compatibility with existing systems and capabilities.
• Monitored data communications to ensure the enterprise data systems are available to all users.
• Maintained integrity of data through implementation of security scheme and disaster recovery plan.
• Implemented cross-system interfaces and software engineering solutions for data management systems.
• Analyzed and solve system integration and compatibility issues among service management applications, platforms and browsers.
• Integrated enterprise data management applications with 3rd party applications.
• Utilized various Business Intelligent Tools to integrate, analyze and consolidate data.
• Performed application configuration changes and customize application and program functionality to meet clients' demands for improved efficiency in database system operations.
• Developed enhancements to existing enterprise data management processes, features, workflow and functionality.
• Provided technical support for complex network traffic and system performance management.

Confidential

ERP Database Administrator

• Performed system administration functions for ERP.
• Designed and implemented system personalization and customization.
• Developed and maintained SQL database programs, scripts, and DB Objects.
• Developed and modified new and existing reports using SSRS and ERP tools.
• Provided end-user support in testing of interfaces and conversion issues.
• Provided end-user training and support for ERP modules, forms, and reports.
• Performed software error investigation, and support incident submittal, monitoring, and resolution implementation.

Confidential

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.

Confidential

Information Technology Support Specialist

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