SUMMARY:

• Information Technology (IT) professional with over 20 years in the field.
• Skilled with database design, querying and reporting; extensive experience sharing data among popular database platforms and proprietary HR and payroll applications.
• Demonstrated ability to resuscitate failed implement - tations and bring run-away projects under control.
• Valued as a Database Administrator (DBA), team member, and team leader. Hands-on capabilities with databases ranging from dBase, Access, db/400, MS SQL Server, and Oracle 11(g).
• Expert troubleshooter with the ability to quickly identify and correct hardware and software problems.
• Ability to lead and coordinate technical projects, including requirements definition, system development, system support, infrastructure, security, and communications SQL, T-SQL and PL/SQL; expert
• Confidential programmer Data analysis; determining impact of changes to existing systems and supporting infrastructure, identifying and correcting data issues
• Database design, optimization, reporting, and documentation development, troubleshooting Sophisticated technical expertise and public speaking communication skill SDLC

TECHNICAL SKILLS:

OS: Windows NT, Windows 2000, Windows XP, Windows Vista, Windows 7 and 8MAC Tiger; OS/400; Novell; MS DOS

DB: MS SQL Server 6.0, 6.5, 7.0, 2000, 2008, 2013 and 2016; Oracle; MS Access; AS/400; dBASE; Fox Pro.

Tools: SAS Enterprise Guide, Informatica, OBIEE; Rational, JMP, MS Query Builder; DTS; SSRS, DDL; DML; iSQL Plus; T-SQL; PL/SQL; Toad; SQL Navigator; ERwin; Crystal Reports; Query 400; Visual Basic; Visual Studio; TSF; Visual Source Safe; MS Access; MS Word; MS Excel; PowerBuilder; MS Project; Visio; COGNOS; MicroStrategy; McAfee; Norton Enterprise; SharePoint; Outook; MS Exchange Server; Redgate SQL Toolbelt; Redgate SQL Clone; Altova XML Spy and MapForce

COTS: Deltek, Kronos; Magellan; Financial Navigator

Web: DreamWeaver; Front Page; IIS; Java Script; HTML; ASP; Visual InterDev; Adobe CS3; SharePoint

Programming: SQL, T-SQL, PL/SQL, VB, VBA, HTML, JavaScript, Java, VB.net, Python, PHP, Ruby, Ruby on Rails.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

• SQL Server for 29 SQL Servers and Report Servers.
• Responsibilities include backup and restore; scheduled jobs, troubleshooting, performance tuning, security, mirroring, always on failover, and working with staff on database issues.
• Setup database mail to send automatic emails for job failure notification.
• Create custom queries to support user requirements.
• Databases analysis relating to front end application issues.
• Also create queries, stored procedures and functions to support SSRS reports.

Database Developer

Confidential

Responsibilities:

• Responsible for all aspects of 2 data warehouses based on MS SQL Server.
• Responsibilities included ETLs to import XML data, database modification to support dot Net program modification, creation and updates to stored procedures and functions.
• T roubleshooting included resolving failure of scheduled jobs and support for SAT and UAT testing.

SQL Server, Consultant

Confidential

• Creating reports with SSRS. Use Visual Studio MIS to create stored procedures, views and functions to support reporting data sets.
• Use SSAS and SSIS to create ETLs to import data from data warehouse.

SQL SSRS Report Expert/Consultant

Confidential

• Using SQL Server Management Studio, TFS, XML and Visual Studio in an Agile development environment.
• Documenting database, including use of T - SQL and stored procedures to create extended properties.
• Creating custom data sets, queries, views, stored procedures, functions and reports.
• Creating training documentation and conducting training sessions. Initial 6-month contract extended an additional 6-months.

Program Analyst

Confidential

Responsibilities:

• Responsible for creating automated processes for recurring reports with SAS Enterprise ad OBIEE.
• Located and corrected logical program and data anomalies that had been responsible for erroneous reports being produced for three years.
• Identified unknown entities in reporting and decreased unknowns in reporting and increased reporting accuracy and timeliness by 95%.
• Eliminated reporting backlog. Created ad hoc reports for senior management and Congress.
• Participated in EDW redesign. Used Agile/Scrum methodologies.

Management Information Specialist

Confidential, Washington, DC

Responsibilities:

• Received commendation from Confidential Secretary for my efforts.
• Provide leader-ship for program support, coordinating with other organizations, agents, vendors, and associated contractors.
• This includes project team leadership, instructing team members on Confidential coding, planning, coordinating among project members, and documentation development.
• Took initiative to set up a SharePoint site and to publish application to give access to Field Offices, demonstrating my sophisticated technical expertise and communication skill working with representatives of Confidential, various technical and project specialists.
• Utilize ODBC to link to MS SQL Server and Oracle tables on multiple servers and platforms and query database tables.
• Determine the impact of changes to existing systems or supporting infrastructure.
• Use analytical skills to uncover data anomalies and coordinate with CIO and contractor to correct programming and data errors.
• Lead and coordinate the selection and application of appropriate problem solving methods and techniques; provide advice on work methods, practices and procedures, and assist project teams or individual members in identifying the para-meters of a viable solution.
• Identify data inconsistencies and potential data entry errors and create programming routines to scrub those inconsistencies and errors from the data.
• Develop project plans; set priorities and deadlines for completion of work and assign work to project team members based on priorities and deadlines.
• Establish and maintain an effective working relationship with high-level personnel both within and outside Confidential to coordinate, review, and implement new system initiatives and resolve complex problems.
• Create reports used by Confidential Secretary s Office and the Vice President of the USA to report on ARRA accomplishments.
• Compile ARRA grant energy usage reports from RAMPS data for Capitol Fund and ONAP grants.
• Prepare documentation in support of PPM process for new applications including Statement of Work, Business Requirements Document and flow charts.
• Created user documentation. Lean Confidential team member

Owner

Confidential, Washington, DC

Responsibilities:

• Directed staff to define reporting needs, analyzed existing data contained in Excel files and defined database requirements.
• Work included project team leadership, planning, coordinating among project members, and documentation development; also involved the demonstration of sophisticated technical expertise and communication skill working with representatives of many agencies and companies, various technical and project specialists.
• Developed project plans; set priorities and deadlines for completion of work; and assigned work to project team members based on priorities and deadlines.
• Provided advice on work methods, practices and procedures, and assisted project teams and individual members in identifying the parameters of a viable solution.
• Architected custom database; wrote queries, created forms and custom reports based on user input to support FEC requirements.
• Determined the impact of changes to existing systems or supporting infrastructure.
• Populated Access tables by importing data from Excel files. Created pick tables for select States and corresponding Congressional Districts by querying SQL database.
• Wrote Confidential application to support user data entry and designed custom reports to include soliciting user input for exporting data to Excel files.
• Documented database using Visio. Converted dBase IV and dBase III flat files to Access tables, performed requirements analysis and design of relational database for data entry consistency.
• ETL/DTS to import data. Worked with client on existing SQL 2005 database to modify reports and support stored procedures.
• Defined data needs for new reports, created new storage procedures for query requirements for new reports. Used SSRS to create custom reports and to publish reports to SharePoint.

Senior Programmer/DBA/Systems Analyst

Confidential, Arlington, VA

Responsibilities:

• Responsibilities included the operation of mission critical programs and platforms.
• This work included project team leadership, planning, coordinating among project members, and documentation.
• Led and coordinated multiple technology projects, including requirements definition, system development, system support, infrastructure, security, and communications.
• Provided leadership for program support to include coordinating with other organizations, agents, vendors, and associated contractors.
• Served as DBA for all SQL Servers. Upgraded SQL servers from 6.0 to 6.5 to 7.0 to 2000.
• Developed SQL Server backup and maintenance plans.
• Responsibilities included all phases of SQL server operation, including hardware and software maintenance, ETL, server security and server optimization.
• Managed Kronos Timekeeping System including migration to AS/400 platform.
• Served as project lead: did requirements analysis, developed project plan, oversaw allocation of resources and time lines.
• Developed custom Query 400 queries and reports. Automated Kronos, HR and Payroll integration.
• ODS/LIS Project: this was a mission critical custom application which generated checks to owners developed by a consultant using Power Builder for the UI and SQL Server for back end processing.
• Worked with the developer on SQL Server issues: debugging and refining stored procedures and triggers, creating clustered, ETL, non - clustered indices and indexed views.
• Implemented user access and security on the SQL server.
• Established and maintained an effective working relationship with business owners and high level management to coordinate, review, and implement new system initiatives and resolve complex problems.
• This was a 6 year run-away project when I was tasked with managing it; I brought it under control and to a successful completion in 6 months.
• Served as project manager for Intranet design, development and consultant selection process. Supervised design and implementation team and consultants.