Profile

An innovative, results oriented and forward thinking IT professional with fourteen years of extensive and diverse experience comprising Database Management Systems , System Administration, Project Management, Systems Analysis and Design, Programming, Internet Application Development, Networking, User Support, Testing for Multi-user Systems and System Integration.

Experience and Qualifications Summary

Working and functional experience: -

• Database Administration, Modeling ERDs and Development, Performance Tuning, Backup and Recovery with SQL Server, Oracle, MySQL, DB2, Postgres, Sybase
• Data Extraction, Transformation and Loading ETL
• Data Mining and Business Intelligence
• Information Systems Risk Analysis and Disaster Recovery Planning
• Information Systems Security Analysis and Auditing
• Project Management
• Developing dynamic intranet based database applications using VB.NET, C , Java, ASP.NET, PHP, ASP, ColdFusion, Perl CGI and JavaScript
• Windows, Linux and Unix, Mac OS operating systems
• Networking and System Administration
• Usability analysis and implementation

Skills Summary

• Databases : SQL Server, Oracle, Sybase, DB2, Postgres, MySQL, MS Access
• Programming : VB.NET, C , PHP, Perl CGI , ASP, SQL, ColdFusion, JavaScript
• Tools : ERWin, Visio, Visual Studio.NET 2005, SQL Server Business Intelligence Studio
• Others : Project Management, Data Mining and Business Intelligence, IT Risk Analysis, Portfolio Analysis, Disaster Recovery Planning, IT Auditing, User Support and Training

Experience and Qualification Details

Confidential

Database Administrator and Architect

• Administering of Performance, Backup, Security and Disaster recovery Planning for SQL Server 2005, Oracle, and DB2 database servers
• Planning, maintenance and development of a databases for enterprise solutions
• Performing requirements analysis for database architecture, physical and logical models
• Performing database related application design and code review
• Providing analytical support for various projects
• Upgrading database servers from SQL Server 2000 to 2005
• Implementing standards for database design and software applications testing
• Developing SQL Server Integration Services for Extracting, Transforming and Loading data from AS400 DB2 and MS Access and client FTP site to SQL Server 2005
• Upgrading database servers from SQL Server 2000 to 2005

Confidential

Database Administrator and Senior Analyst

• Lead Full Development Lifecycle for Members Information Management System integrating modern information system solution with legacy flat file data sources
• Architected the agency's enterprise database resources resulting in a consolidated repository of disparate data elements and eliminating data redundancies
• Lead an initiative to implement secure inter-departmental information data sharing and reuse with appropriate security and performance controls
• Introduced and implemented a standardized approach to database design, development and documentation which decreased development time for IT solutions
• Lead a data mining project which mitigated the failure rate of a document migration project by reducing it from 864,000 out of 8 million to only 23 out of 8 million
• Implemented service desk solution which saved the state agency 30, 000 and improved IT department's incident response time and turnaround time
• Designed and developed a database for agency's web based communication portal
• Lead Data Migration ETL projects from MySQL database, AS400 DB2 database and Legacy VSAM flat files to SQL Server 2000
• Performed internal auditing of databases in preparation for external independent auditing
• Upgraded database servers from SQL Server 2000 to SQL Server 2005
• Implemented Change Management procedures for system development staff which eliminated IT solutions conflicts and errors in production environment
• Worked with directors from other departments to identify needs and opportunities for alignment of information systems initiatives with overall business objectives of the agency
• Lead a full redesign and improvement of the agency's website, introducing dynamic content and web usability best practices

Confidential

System/Network Administrator and Database Manager

• Developed an internet based database solution enabling elimination of surplus inventory
• Managed enterprise IT security, data backups and recovery

Confidential

Data Manager

• Implemented call center's call tracking database solution
• Designed Knowledge database for Support Solutions Representatives and Technicians

Confidential

Senior Support Analyst

Developed and maintained database of issues and product FAQs for call center support

Confidential

Graduate Teaching Assistant

Lectured a course in Essential Computer Concepts, Databases and Web Development

Confidential

Data Processing and Database Manager

• Developed and Managed Inventory Management Database
• Designed and developed warehouse fulfillment database using Access and Oracle
• March 1995 May 1997 Concurrent Engineering Research Center Morgantown, WV, USA System and Network Administrator II
• Developed and managed inventory management system using Oracle Unix
• Managed backups, file recovery and user on Unix, Windows NT 4.0 and Novell servers

Confidential

Systems Analyst / Programmer

• Developed Foreign Currency Exchange Control System which improved the turnaround period for foreign selection transactions from 6 months to 5 days
• Developed a database which helped Central Bank better track local currency stocks
• Developed central bank's Asset Management database on AS400

Confidential

Teaching and Computer Laboratory Assistant

• Taught in Computer Applications and Introductory Database Systems course
• Installed and managed Novell and UNIX networks

Confidential

Management Services Blantyre, Malawi

Database Systems Programmer

• Implemented database programs using dBase III and dBase IV
• Created payroll database security modules using dBase IV