PROFESSIONAL SUMMARY:

• Accomplished professional with 20 years of experience in the Information Technology field including 15 years of experience as a SQL Server Database Administrator providing expert knowledge in the design, development and delivery of high performance relational database management systems (RDMS).
• Qualified Project Team Lead with excellent leadership, organizational, interpersonal and problem - solving skills capable of managing and completing project tasks on time and on budget; capable of mitigating technical issues and managing work assignments for technical support personnel including Systems Engineers, Network Administrators, DBAs and COTS vendors.
• Managed the production, development, and test databases including database monitoring and tuning, capacity planning, maintaining database security configurations; implementing and maintaining database continuity using SQL Server replication, SSIS and DTS; and maintaining a high availability clustering environment.
• Designed and implemented logical and physical data models using database modeling tools and Visio diagrams.
• Hands on working experience using T-SQL to construct tables, views, triggers, user defined functions, and data conversion scripts.
• Developed and optimized stored procedures and T-SQL scripts. Developed complex data migration processes (DTS and SSIS packages) and managed nightly jobs to ensure successful transfer of data both inside and outside secured networks.
• Created and modified reports for Data Mart reporting tool using SQL Server Reporting Server and CIZER Reporting tool.
• Worked with multiple development teams to provide full SDLC process support including QA functional and performance testing.
• Managed source control for multiple software projects and defect reporting using Rational ClearCase and ClearQuest.
• Ability to communicate technical and complex information easily and concisely to all audiences including providing status updates to users and senior managers, as well as, providing training to users and Helpdesk staff on new software development.
• Awarded Information Resources’ “Partners in Excellence Award” (2006) and “Values in Principles Award” (2007).

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Consultant (Self-Employed)

• Provide computer consulting and repair services to various small businesses and individuals throughout the Washington Metro area. Advised customers on hardware and software purchases for new system installs and upgrades to existing systems.

Confidential , Washington, DC

Confidential

SQL Server Database Administrator

• Attended weekly meetings with government staff, IT staff and project managers to finalize user requirements for new software development and defects reported for the agency’s legacy applications. Attended daily Scrum (Agile SDLC ) meetings to identify, prioritize and select tasks for new project development and defect resolutions. Provided status of database tasks in progress and completed.
• Developed all database objects for new software development including creating logical and physical data models, tables, views, stored procedures, triggers and user defined functions.
• Resolved defects reported for legacy applications including analyzing legacy stored procedures; modifying code to optimize and tune to improve performance; and developing new database objects to correct defects.
• Developed scripts used to import data from various DOJ systems including XML data, flat files, bulk import and SQL Import/Export tool.
• Setup and monitored database maintenance tasks including backups, database consistency checks, index rebuilds and event logs.
• Configured and troubleshoot replication between multiple database instances within and outside DOJ’s secured network.
• Completed system testing including unit testing and quality assurance testing of new applications and defect resolutions.
• Provided updates and project status reports to CGI Federal Systems’ Project Manager.

Confidential, Silver Spring, MD

Application Developer/SQL Server Database Administrator

• Designed and coded a project management application used by one of Verizon’s engineering teams. This application was used to manage installation of fiber cable throughout the District of Columbia for Verizon’s FIOS service. It was also used to manage permits issued by the DC Department of Public Works and all work performed by vendors in support of the cable installs and repairs.
• Led weekly meetings to gather user requirements for the PM application’s functionality and the database’s logical data models.
• Met with each team member to review the processes and documentation required to complete their job duties. Created Visio diagrams which outlined, thru flowcharts, the tasks identified by each team member to complete FIOS fiber installations from start to finish.
• Developed mockup screens which illustrated the application’s functionality and interface; developed logical database models for management review and approval during requirements gathering stages.
• Documented other Verizon systems and applications used to design hubs, routes, conduit and pole placements. Created nightly processes to import data from these systems in order to update designs used during excavations and fiber installs
• Developed complex data conversion and validation scripts to import data from financial applications into SQL Server databases.
• Provided instructions to network engineers to install and configure SQL Servers; implement security and configure hardware.
• Developed physical database models, tables, views, stored procedures, triggers and user defined functions.
• Developed VBA application code, forms (screens), queries and reports using MS Access 2003 as the graphical user interface.
• Integrated MS SQL Server’s RDBMS (backend) with MS Access 2003 (front end) to create Verizon’s project management application.
• Created user and management reports which included conduit installations/repairs, DC permits, scheduling and costs analysis.
• Implemented database maintenance plans including backups, database consistency checks and index reorganization/rebuilds.
• Provided weekly updates and project status reports to Rangam Consultants, Inc’s Project Manager.

Confidential, Suitland, MD

Consultant (Self-Employed)

• Provided computer consulting and repair services to various small businesses and individuals throughout the Washington Metro area. Advised customers on hardware and software purchases for new installs and upgrades to existing systems.

Confidential, Bethesda, MD

SR SQL Server Database Administrator/Project Team Lead

• Responsible for the day-to-day operations and subject matter expert for Marriott Execustay’s Information Resources division
• Performed the duties and responsibilities of the Project Team Lead and Senior SQL Server Administrator. Provided Production Support (24X7) for Marriott Execustay’s RDMS, reservation application and reporting software (Data Mart) used nationwide.
• Managed multiple SQL Server servers (7.0, 2000, and 2005) and databases in Development, Test and Production environments.
• Constructed triggers, tables, user functions, views, indexes, user profiles, relational database models, data conversion scripts and maintaining data integrity. Developed, troubleshoot and optimized stored procedures.
• Developed complex data migration processes (DTS and SSIS packages) and nightly jobs to ensure successful transfer of data.
• Responsible for monitoring performance, database tuning, database optimizations, database consistency checks, backups, capacity planning, disaster recovery and archiving planning.
• Designed and implemented logical and physical data models for RDMSs in development, test and production environments.
• Created and modified reports for Data Mart reporting tool using SQL Server Reporting Server and CIZER Reporting tool.
• Completed upgrades from SQL Server 7.0 to SQL Server 2000; SQL Server 2000 to SQL Server 2005; Converted DTS packages to SSIS; recreated jobs and maintenance plans from SQL Server 2000 to 2005; created data conversion scripts and data validation scripts.
• Installed, tested and documented all software release updates including COTS source code updates, security patch updates, MS Windows Server operating system updates and MS SQL Server database system updates using Rational tools (Clear Case).
• Provided T-SQL query builder training (Reporting Services) to users and mentored DBAs, Developers, and System Analysts.
• Chaired monthly User Council Meetings to review the status of issues, enhancements and project requests with business managers. Lead meetings with IR technical staff and vendors to convey requirements for Project Plans, infrastructure changes or security policy changes.
• Prioritized and managed all COTS deliverables and Information Resources Issues database using Rational tools (ClearQuest) software.
• Provided technical support for all defects, enhancements and requests for new projects assigned for Execustay’s IR project team. Troubleshoot and resolve issues within 24-hours based on IR’s Service Level Agreement with its customers.
• Managed infrastructure costs, recommended hardware/software purchases and documented server configurations using Microsoft Visio
• Researched and coordinated new infrastructure projects in collaboration with other corporate-level IR support team members
• Developed and documented company standards (Marriott’s Method1 and Rational UCM) and standard operating practices (SOPs). Accountable for Execustay’s IR annual security audits to confirm compliance and best practices as defined in the Payment Card Industry’s (PCI) data security standards. Successfully implemented the encryption of credit card data, user security profiles and audit logging to obtain an acceptable security compliance (PCI) rating for Marriott Execustay’s IR project team from 2004 to 2008

Confidential, Greenbelt, MD

SQL Server Database Administrator /Project Team Lead

• Lead project team during full life cycle SDLC application development projects at Confidential, Inc. and Bell Atlantic Corporation which included application developers, system analysts and SQL Server Database Administrators.
• Resolved all project related issues reported by project managers, provided guidance and mentoring for fellow team members.
• Managed MS SQL Server relational database management systems including performance monitoring and tuning, optimizations, database consistency checks, backups, capacity planning and disaster recovery planning.
• Designed, tested and implemented logical and physical data models for proposed (development environment) and existing database systems (production environment).
• Constructed triggers, tables, user functions, views, indexes, user profiles, relational database models, data conversion scripts and maintaining data integrity. Developed, troubleshoot and optimized stored procedures.
• Developed complex data migration processes (DTS packages) and nightly jobs to ensure successful transfer of data.
• Provided weekly updates and project status reports to Confidential, Inc’s Project Manager.

Confidential, Philadelphia, PA

SQL Server Database Administrator/Network Administrator

• Provided support for the IRS’ client/server Tax software (developed by Lockheed Martin). Provided support to IRS Tax Preparers at the IRS Service Center and two IRS field offices located in Downtown Philadelphia and Allentown, Pennsylvania. Troubleshoot and resolved issues reported for all desktop software installed by Lockheed Martin and network issues reported for hubs, switches and routers.
• Installed and maintained MS SQL Server 6.5 relational database management systems of Social Security data including performance monitoring and tuning, optimizations, database consistency checks, backups, capacity planning and disaster recovery planning.
• Constructed triggers, tables, user functions, views, indexes, user profiles, relational database models, data conversion scripts and maintaining data integrity. Developed, troubleshoot and optimized stored procedures. Developed complex data migration processes.
• Designed, tested and implemented logical and physical data models, system jobs and database maintenance plans.
• Provided weekly updates and project status reports to Alltech International, Inc ‘s Project Manager.

Confidential, Durham, NC

SQL Server Database Administrator/Network Administrator

• Analyzed the performance statistics and metrics for the Veteran Administration’s hospitals nationwide and prepared management reports.
• Provided DBA support for MS SQL Server 6.5 relational database management systems including performance monitoring and tuning, optimizations, database consistency checks, backups, capacity planning and disaster recovery planning
• Constructed triggers, tables, user functions, views, indexes, user profiles, relational database models, data conversion scripts and maintaining data integrity. Developed, troubleshoot and optimized stored procedures. Developed complex data migration processes.
• Designed, tested and implemented logical and physical data models, system jobs and database maintenance plans
• Performed network administration and desktop support for the VA’s network systems which included routers, hubs and switches.

Confidential, McLean, VA

Application Developer/ SQL Server Database Administrator

• Provided consulting services for Vantive Corporation’s suite of enterprise applications which included Helpdesk, Support, RMA and Sales.
• Modified application functionality to meet each customer’s defined requirements including installation of SQL Server and databases.
• Developed stored procedures, triggers, functions and Visual Basic for Application scripts
• Constructed triggers, tables, user functions, views, indexes, user profiles, relational database models, data conversion scripts and maintaining data integrity. Developed, troubleshoot and optimized stored procedures
• Provided support for MS SQL Server 6.5 relational database management systems including performance monitoring and tuning, optimizations, database consistency checks, backups, capacity planning and disaster recovery planning.
• Provided training on Vantive’s suite of enterprise applications to customers and vendors.