TECHNICAL SKILLS

Development: HTML, XML, PHP, VB, ASP, Flash, VBScript, Javascript, CSS Scripting, C++, VBA, AJAX

GIS: ESRI ArcINFO, ArcMap 9, ArcGIS 3/8.x/10

Database: Oracle, SQL Server 2K/2K5/2K8R2/2K16, MySQL, MSAccess

Server: Apache, W2K3, W2K12, Linux

Project Management: Visio, Microsoft Project

Other: ERWin, Visual Source Safe, Photoshop, Dreamweaver, Remedy, Rational Rose, DOORS

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Responsibilities:

• Analyzing, developing, and implementing database designs, data models, and logical data specifications
• Performance tune ETL jobs and data models
• Planning, developing, implementing, maintaining and administering SQL Server SSIS packages to support database applications, feeds, and extracts.
• Provide support for development, implementation, and migration of application data, DDL and DML
• Reporting - Modification of existing reports and development of new reports using Microsoft SQL Server reporting services (SSRS)
• Business Process Review -Participation in the evaluation, design, development, testing, and implementation of technology solutions to support improvements in business processes

Applications Used: SQL Server 2014/2012/2008 R2/2005, SQL Server Reporting Services 2K8/2014, Microsoft Excel, Visual Studio 2K8

Confidential

DBA/Database Developer/Application Developer

Responsibilities:

• Administered and developed applications utilizing Microsoft Access front-end connecting to SQL Server backend.
• Designed/Maintained/Supported MS Access application with customizations coded in VBA.
• Designed/Maintained reports utilizing MS Access and migrating to SQL Server Reporting Services (SSRS)
• Planning, developing, implementing, maintaining and administering SQL Server 2016 database used to compile budget data for all the government agencies in the State of Maryland.
• Analyzed source system of record to identify and document data quality issues
• Application Support - Development, maintenance, and operation of applications supporting the business processes in the Budget Division using Microsoft SQL Server integration services (SSIS)
• Reporting - Modification of existing reports and development of new reports using Microsoft SQL Server reporting services (SSRS) and Microsoft Access 2016
• Business Process Review -Participation in the evaluation, design, development, testing, and implementation of technology solutions to support improvements in business processes
• Technical Support - Liaison between end-users and IT support service entities

Applications Used: SQL Server 2016, SQL Server Reporting Services 2K8, Microsoft Project, Microsoft Access, Microsoft Excel, Visual Studio 2K8

Confidential

DBA/Database Developer/Application Developer

Responsibilities:

• Designed/Maintained/Supported stored procedures in MySQL to write and modify data captured in PHP developed interface into MySQL database.
• Designed/Maintained reports utilizing SQL Server Reporting Services (SSRS)
• Creating ETL processes using Integration Services (SSIS) to move data from System of Record (SOR) MySQL to Reporting System SQL Server 2008 R2
• Development of an ETL infrastructure, including the use of metadata, staging, and load/reload procedures utilizing SQL Server Integration Studio (SSIS)
• Produced technical documentation such as: manual, training documentation, ER diagrams and data dictionary
• Designed/Maintained data warehouse to support reporting

Applications Used: SQL Server 2008 R2, SQL Server Reporting Services 2K8, PHP, ERWin, Microsoft Project, Microsoft Excel, Visual Studio 2K8, Windows Server 2K12, MySQL, CSS, Javascript, AJAX, Adobe Dreamweaver, MySQL Workbench

Confidential

DBA/Database Developer/Application Developer

Responsibilities:

• Administered and developed applications utilizing Microsoft Access front-end connecting to SQL Server backend.
• Designed/Maintained/Supported MS Access application with customizations coded in VBA.
• Designed/Maintained reports utilizing MS Access and SQL Server Reporting Services (SSRS)
• Planned, developed, implemented, maintaining and administering SQL Server 2008 database used to compile and analyze benefit application data that consists of millions of records annually from the FDNS-DS System (system of record)
• Creating ETL processes using Integration Services (SSIS) (Moved data from SOR - Oracle to Reporting System SQL Server 2008 R2)
• Wrote complex stored procedures using T-SQL
• Development of an ETL infrastructure, including the use of metadata, staging, and load/reload procedures utilizing SQL Server Integration Studio (SSIS)
• Produced technical requirements and design documentation for ETL processes
• Designed/Maintained star schemas and dimensional models for supporting reporting
• Wrote and tuned complex SQL queries
• Analyzed source system to identify and document data quality issues
• Utilized ArcGIS 10.0 to geo-process applicant locations to assist with Citizenship and Immigration analysis.

Applications Used: ArcInfo 9.0, SQL Server 2008 R2, SQL Server Reporting Services 2K8, Oracle, ASP, PHP, ERWin, Microsoft Project, Microsoft Access, Microsoft Excel, SCCLAIMS, FDNS-DS, Visual Studio 2K8, Informatica, Microsoft TFS

Confidential

DBA/Database Developer

Responsibilities:

• Migrated System of Record (SOR) from a SQL Server 2K to SQL Server 2K8 R2.
• Performance tuning including source schemas, individual reports and complex database objects
• Creating ETL processes utilizing SQL Server Integration Services (SSIS)
• Created/Maintained data mapping documents
• Development of an ETL infrastructure, including the use of metadata, staging, and load/reload procedures.
• Producing technical requirements and design documentation for ETL processes

Applications Used: SQL Server 2008 R2, ERWin, Microsoft Excel, Visual Studio 2K8

Confidential

Database Developer

Responsibilities:

• Experience with medical bills /claims processing, Bill History and Prior Authorization
• IC9-ICD10 Conversions
• Creating ETL processes using SQL Server Integration Services (SSIS)
• Created/Maintained data mapping documents
• Created/Maintained data dictionary
• Writing complex stored procedures using T-SQL
• Development of an ETL infrastructure, including the use of metadata, staging, and load/reload procedures.
• Producing technical requirements and design documentation for ETL processes
• Design/Maintaining star schemas and dimensional models for supporting reporting
• Analyzing source system to identify and document data quality issues

Applications Used: SQL Server 2008 R2, ERWin, Microsoft Project, Microsoft Excel, Visual Studio 2K8

Confidential

Data Analyst/DBA

Responsibilities:

• Planned, developed, implemented, maintained and administered SQL Server 2K database used to compiled and analyzed benefit application data that consisted of millions of records annually
• Created complex stored procedures using T-SQL
• Developed ETL infrastructure, including the use of metadata, staging, and load/reload procedures.
• Produced technical requirements and design documentation for ETL processes
• Wrote and tuned complex SQL queries
• Analyzed source system to identify and document data quality issues
• Recommended the use of geospatial products to manage resources
• Planned, developed, implemented, maintained and administered geospatial infrastructure used to analyze data to manage human resources worldwide which allowed a efficient and reliable means of resource management, responses to Congressional Inquiries, business infrastructure planning
• Planned, developed, implemented, maintained and administered web portal to allow customer management of resources for 100+ field offices worldwide which also allow viewing of maps generated utilizing ArcInfo and ArcView

Applications Used: SQL Server, ERWin, Microsoft Project, Microsoft Access, Microsoft Excel

Confidential

Application Developer

Responsibilities:

• Planned, developed, implemented, maintained and administered Access database used to compile and analyze fingerprint application data (130+ daily) utilizing VBA for customizations
• Planned, developed, implemented, maintained and distributed desktop application used to process fingerprint applicants which resulted in a reduction of fingerprint applicant backlog utilizing VBA for customizations
• Create end user manuals and training materials detailing the use of desktop software applications
• Designed and presented courses for technical staff, non-technical staff and management users on desktop software applications developed for processing of applicants seen at field offices
• Provided second level support to internal Help Desk to resolve user concerns with developed desktop applications (300+ end users)
• Performed upgrades, patch maintenance and integration with customer software
• Led up to 4 team members performing Database Administration
• Developed course content in conjunction with Subject Matter Experts as identified by the Program and Project Managers. Developed and coordinated training plans and trained end users. Prepared all instructor materials, course outlines, background materials, and training aids. Prepared all student materials course manuals, workbooks, handouts, completion certificates, and course critiques. Created and published reference documents such as Frequently Asked Questions and Quick Reference Guides as needed. Trained personnel by conducting traditional sessions such as classroom training, workshops, seminars, demonstrations, brown bags and one-on-one training at the Federal Law Enforcement Training Center (FLETC) located in Bruswick, GA. Support project activities related to end user training, including organizing and scheduling classrooms and classes, creating and coordinating rosters, contacting users with training information.

Applications Used: ERWin, ASP, Microsoft Access. Microsoft Excel, VB, VBScript, Microsoft Project, Remedy