• Software: MS Visual Studio, MS SQL SERVER v2000 v2008, MS SQL Server Integration Services, Gupta SQL WINDOWS v4.0, MS Access 97/2000, Pro C OCI , MS Team Foundation Server, FrontPage 2000, ASP, Cold Fusion, Dreamweaver, Pro Cobol, UNIX, Microsoft C , Clipper, PowerBuilder 5.0, ProComm Plus Script Language, C-Scape, ORACLE/SQL v5-8, SQL Forms 3.0, SQL ReportWriter 1.1, MS EXCEL v4.0, Sybase, DB2, Crystal Reports, Arachnophilia, MS Visual InterDev 6.0, Visual Basic 5.0, MS IIS, OS/JCL, AZ7, CICS, Cobol, Basic, Pascal, dBase III , ADA, ISPF, TSO, VMS-7, MS-DOS, CITRIX. Familiar with PVCS and ClearCase
• Computer Aided Software Engineering: Information Engineering Workbench IEW v.3.5.2, Picture Oriented Software Engineering POSE , ORACLE CASE Dictionary and CASE Generator for SQL Forms and SQL ReportWriter, Erwin v2.1-3.5.2
• Systems Development Methodologies: Gane Sarson, James Martin, Parks

Confidential

SQL Database Administrator/Developer

• Leading the migration effort for the Washington D.C. Office of the Attorney General's OAG legacy databases and .Net C front-end software from SQL 2000 environment to SQ 2008 R2 platform. Migration includes database redesign, implementation of database audit trails, system audit trails and Transparent Data Encryption TDE , mandated by the federal government.
• Maintaining OAG databases which include: database monitoring, database backups, analysis, redesign, SQL procedures, ad-hoc and monthly reports and ETL scripts.

Confidential

SQL Database Specialist/Lead DBA, Head Start Program

• Developed and maintained MSSQL 2005 and 2008 Head Start nationwide databases used by the Office of Human Service OHS to track compliance. Duties included peer-to-peer database replication, database administration, database analysis and maintenance, database design, implementation, development of ETL scripts, SQL procedures, Configuration Management MS Team Foundation Server , MS SQL Server Integration Services SSIS and triggers.
• Led efforts related to database schema designs and installation, tuning, troubleshooting, performance and maintenance. Established Danya database standards. Developed test procedures, system documentation delivered training internally and to external clients. Constructed OLAP Cubes and Data Marts to improve integrity and consistency of data, reports and database designs.
• Managed all database in-house migrations throughout different platforms from analysis, development, testing, implementation and into production.
• Provided Help Desk support for subcontractors, including security control, complex updates and migration schedule. Also provided Help Desk support for Head Start testing team.
• Directed team and played key role as an internal consultant on major decisions.
• Recognized by internal and external clients for superior customer service.

Confidential

Lead Analyst

• Led maintenance and redevelopment on Department of Defense Small Business Innovation Research SBIR/STTR application Advance Resource Technologies Inc., 2006 . Redesigned MSSQL 2003 database, coded SQL triggers and procedures, programmed in VB, ASP.Net, Access data conversion and development of VB and SQL scripts.
• Led database development for the United States Coast Guard's Waiver application Towers Technology 2005-2006 , an intranet application that tracked the acquisition of computer equipment for Coast Guard's employees. SQL programming of procedures and triggers developed scripts. Database conversion from Access using DTS, requirements analysis and Visual Studio ASP.Net front-end development.
• Performed all DBA functions, MS Access coding, program analysis, database design and enhancements for the Alexandria Department of Human Services Vistronix, 2005 . Developed Triggers, T-SQL, procedures, queries, front-end entry forms, database conversion from ACCESS and mainframes, and intranet maintenance using XML. Database conversion included database administration, data analysis, development of schema, use of DTS, SQL programming of procedures and triggers, and script development.
• Directed all activities as IT Technical Manager to purchase and manage system hardware, software and database applications for Connections Training Services 2004-2006 , concurrent with other consulting projects. Reported to the Corporate President and General Manager planned and maintained IT architecture. Wrote procedures and system specifications Oracle, MS Access and MSSQL . Managed and implemented multiple projects, analyzed requirements, designed, developed, tested, documented, installed, trained and demonstrated the Student Tracking Application ACCESS 2000 and MS SQL Server v2000 .
• Analyzed Maryland's Housing Authority HABC tracking application Robert Half Technology, 2005 to design a solution to a complex multi-user issue. Used Visual Basic. Created proposal outlining the task and estimated completion time.
• Analyzed, developed and maintained MSSQL v2000 tables, procedures, triggers and SQL scripts, VB v6 and ACCESS 2000 applications for Maryland State Department contract Force 3 Inc., 2004 .

Confidential

Senior Database Architect/Lead Analyst/Help Desk Support

• Implemented system requirements for Maryland Schools Department of Education's MSDE Special Education Dept. Visual Basic, Requirement Analysis, Database Design using Platinum Erwin ERX ver 3.5.2, MSSQL implementation, and Testing of Special Education's NTPAP Ver.2 and Maryland Aptitude MA GRANTS applications.
• Defined database objects and developed prototype using Microsoft Access 2000 and migrated to MSSQL V2000 development and production platforms. Provided architecture design, data modeling and database conversion. Developed and maintained database tables, triggers, stored procedures and views. Led troubleshooting and performance tuning. Final implementation used CITRIX platform. Delivered Help Desk support by phone, email, and on-site.
• Led a team of five developers in support of MSDE system upgrade including database designs, conversion, and redevelopment of MSDE's legacy applications. Provided design consultation to the Director of Information Processing and end user clients.
• Gained proficiency in various design methodologies, incorporated in tools such as ERWIN v3.5.2 , Web support for FTP and Web servers, HTTPS development, Microsoft's Database Replication, design and execution of database conversion schemes, Access 97 2000, VB Programming, MS Internet Skills IIS , FrontPage 2000, ASP, MSSQL v97 , and ORACLE v8.0 .

Confidential

Senior Database Management Specialist

• Lead architect for the Small Business Administration's development of their Small Disadvantaged Business application using PowerBuilder v.5.0 PFC front end and a SQL Anywhere v.5.0 database engine, which later migrated to Sybase. Designed database architecture and application.
• Supported conversion effort from Sybase to ORACLE for the Department of Health and Human Services Program Support Center HRSA . Migrated the HEAL Information Processing application HIP and data from a M204 mainframe to ORACLE on Microsoft's NT network. Responsibilities included database administration, data conversion, C coding and developing ORACLE PL/SQL script. System converted on UNIX platform.

Confidential

Senior Systems Analyst/DBA

• Provided ORACLE v7.2.2 Database Administration expertise for the Defense Logistics Agencies DLA Defense Personnel Support Center's DPSC Subsistence Prime Vendor Interpreter SPVI redesign effort for the Subsistence Total Ordering and Receipts system STORES . Duties included database redesign using Erwin v2.1, database configuration and creation, data conversion, Cursor and PL/SQL script modification and enhancement, documentation and validation.
• Functioned as the onsite Project Manager with five senior analysts, for the Defense Information System Agency's DISA Management Information Systems MIS development effort. Developed and maintained all MIS CIO financials managed staffing and tracking applications. Led customer relations, resource scheduling and planning, and staff evaluations and development. Additional duties included development, design and maintenance of database tables, indexes, cursors, triggers, stored procedures and views. ORACLE's v7.0 RDBMS, PowerBuilder v4.0 and Paradox v4.0.
• Led the post development phase of the Internal Revenue Service's IRS Counsel Automated Systems Environment CASE Phase II application. Supported programming for Quality Assurance of CASE Phase II. Attended project and configuration management meetings, generated monthly status reports, scheduled staff, and administered personnel evaluations. Created technical direction and managed module implementation, module unit testing, developing data conversion programs and database validation. Assisted the CASE testing phase by developing and implementing PL/SQL scripts and reports for data validation and by performing module maintenance as a result of Problem Reports PR from Integration Testing and System Acceptance Testing SAT .
• Assigned to the IRS's CASE Phase II development effort as the Team Leader. CASE was designed using ORACLE's Version 6.0 database and CASE Dictionary Version 5.0 for implementation in ORACLE Version 7.0. Oversaw the direction and progress of four analyst and their use of ORACLE's CASE Dictionary Version 5.0, SQL Forms Version 3.0 and SQL Report Writer Version 1.1 for the validation, migration and completion of the CASE Phase II design. Led design validation and module development, managing for four Analysts.
• Completed the Department of Treasury, Financial Management Service's Electronic Benefit Transfer EBT Cost Model application. The EBT COST MODEL facilitated the comparison of current paper-based benefit payment methods to Electronic Benefit Transfer methods and assisted in the planning of future systems. This application used Gupta's SQL Windows and database and Excel.
• Led the Federal Aviation Administrations FAA National Airports Grants Information System NAGIS development task and the FAA's system integration effort. NAGIS is a National Wide Area Network WAN information tracking system developed on ATT's Starlan network ORACLE's Version 6.0 UNIX RDBMS and SQL ReportWriter with Microsoft C, Oakland's C-scape and Oracle's ProC on DOS . Integrated the four remaining airport systems currently. Produced project schedules and provided technical guidance. Used Gane Sarson's methodology and the CASE tool Picture Oriented Software Engineering POSE .
• Designed, developed and implemented software required to collect and process rail transit vehicle operational data for the Washington Metropolitan Area Transit Authority WMATA 's On-Board Carborne Microprocessor, developed in Pascal. System provided on-car analog and digital data collection and conversion as well as off-line data analysis.

Confidential

Systems Analyst

• Maintained United Kingdom's Submarine Supply software using DB2 to Oracle's V5.0, SQL Forms 2.3, Pro Cobol, UNIX script language, Information Engineering Workbench IEW CASE tool, Cobol, JCL, Pascal, CICS, Basic, and AZ7 computer languages.
• Harris HCX, Harris 700 and IBM 3033, IBM PC/AT.