17 + years of technical experience in Systems Analysis, Data Modeling, SQL Development and Database Administration Microsoft SQL Server 2012 and earlier. Experience with OLAP and OLTP database design, development and implementation. Experience in DBA activities such as installation, Database design, development, Administration, user management, SQL maintenance, and disaster recovery solutions including Database Mirroring, Log Shipping, and Clustering. Experience in developing, maintaining, scheduling and monitoring SSIS and DTS Packages. Hands on Experience in installing, maintaining, configuring, managing, monitoring and troubleshooting SQL Server versions. Hands - on experience in performance tuning, log files monitoring, updates statistics, ETL development, and backup and restores of SQL Databases.
Confidential, Herndon, VA
Department of Veterans Affairs - SMS, Falling Waters, WV
Experienced Senior Database Administration for MSSQL Server. Troubleshooting database problems and resolutions. Utilize Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. Design and implementation of log shipping, backups, restores and recovery models. Use of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Implementing operational automation using scripts. In depth knowledge of indexes, index management, and statistics. Highly experience working with Windows server, including Active Directory and proper disk configurations. Provides excellent communication and documentation of policy, procedures and other necessary guides. Implementation of a SCRUM environment adapted to Maintenance and development projects.
Special Projects: Implementation of Microsoft Policy Based Management; Conversion from SQL 2008R2 to SQL 2014
Applications: SQL 2008/2012, Visual Studio 2012, Microsoft Office 2013, SharePoint, SCCM, SCOM
Confidential, Washington DC
Department of General Services - CCS, District of Columbia
Conceived, Designed, and modeled a complete reporting solution for both internal and external customers. Designed full network architecture for the web application using agile software development methodologies. Analyzed requirements and convert them into conceptual, logical and physical data models, application design. Planning deployment of reporting database. Migration of data to cloud platforms. Responsible for writing all new data management policies for new data store. Responsible for security design and implementation. Redesign of front end applications to access cloud based data stores. Producing data dictionaries for existing and new data stores. Ensure accuracy of data through analysis, coding, writing clear documentation, and problem resolution. Analyze functional specifications and change requests into technical specifications. Develop, test, and implement program logic. Design, troubleshoot, and debug new ETL solutions. Translate business needs into end user applications. Creating requirements documents for application redesign. Acting as an application architect to design the front end internal and external web application. Creating reports in SSRS for application redesign.
Special Projects: Cloud Conversion of Reporting Databases; Migration of data from Legacy Applications; Document Collector Project, Access Front End Application Redesign, Survey Reporting and Collect Database and Application, NIGP to CSI Crosswalk.
Applications: SQL 2008/2012, Visual Studio 2012, Toad Data Modeler, Red Gate, Microsoft Office 2013, Erwin Data Modeler, SharePoint, iPlan, Document Collector, Prolog, PASS
Confidential, Chantilly, VA
Ventera Reston, Va.
Wrote complex SQL queries needed to profile data to support data modeling activities. Developed stored procedure per business requirements. Designed technical documentation for processes and created Visio representations of processes. Provided DMV knowledge for meeting and discussions. Reviewed high-level documentation for questions and concerns prior to development. Reviewed data model for potential concerns and suggested alterations. Updated and created reference data tables as needed.
Special Projects: HP Rhode Island DMV Project
Applications: SQL 2012, Visual Studio 2010, TFS, Microsoft Office 2010, Erwin Data Modeler, SharePoint
Confidential, Lemoyne, Pa.
Senior Business Analyst
PennDOT Harrisburg, Pa.
Provided internal on call post implementation Support. Worked with the team of developers to provide several internal and external solutions. Designed a network and security infrastructure for a forwarding facing web application. Worked closely with the customer and team to design and implement application solutions. Worked with developers to conduct technical code reviews and provides feedback. Developed Test Plans and scripts. Conducted comprehensive testing of applications and trouble-shoots concerns. Responsible for analysis of requirements to transform them into corresponding conceptual, logical and physical data models. Responsible for database design, DBA functions and ETL development. Development and testing of internal and external web services. Development utilizing FileNet APIs. Coordinated software implementations. Developed and maintained documentation for business processes and workflows. Created and modified program code, assisted users in development of test scripts, and verified system performance, prior to implementations. Responsible for development of skills and mentors other technical staff where applicable. Prepared operational post implementation period. Gathered requirements for new development. Filled in on application development as needed Created presentations for end users.
Special Projects: EDMS VB6 to .NET upgrade project
Applications: SQL Server 2000/2005/2008 , Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Office Products, IBM Rational Tools, Snagit, Adobe, Crystal Reports, and FileNet. Programming Languages: Visual C#, VB6, SQL, Java, and VBA.
Senior Technical Analyst/DBA & Developer
Confidential, Danville, Pa.
Provided 24-hour support of SQL databases and user applications. Migrated platform from SQL 2000 to 2008. Converted all DTS processes and other jobs into SSIS packages. Participated in the database design of the GHP BI data warehouse, DBA functions and ETL development. Developed complex SQL scripts and processes for Data modeling. Design high availability solutions and implemented database mirroring and replication. Documented and tested all Disaster recovery plans. Knowledge of data management standards and data governance practices. Created database and SQL scripts for Actuarial Analysis. Developed processes for data management for reporting and predictive modeling and analysis in Healthcare. SQL cube development for Actuarial and underwriting departments. Responsible for converting business requirements into technical design and develop EDW solutions. Utilized SAP Business Objects Data Integrator/Data Services software for development. Maintaining Business Objects Universe site, users, and database. Disaster recovery planning and testing. Works with management to develop and implement new Technology. Develops and maintains business processes and workflows. Develops test plans, creates and modifies program code, assists users in development of test scripts, and verifies system performance, prior to implementations. Created, Designed, and implemented a user application for the mailing of regulatory letters. Responsible for development of programming skills and mentors other technical staff where applicable. Prepared operational documentation for Data Center Operations. Assisted with planning and managing the virtualization and migration of data and application into the new Data Center.
Special Projects: Letter Generator; HEDIS/CRMS; MEDai; Lab Data, Recast; converting SQL Server & Objects from 2005 to 2008; Data Center Migration Project; Data Warehouse\BI Inception
Applications: SQL Server 2000/2005/2008 R2, SSMS, BIDS, SSIS, Query Analyzer, Visual Studio, Wisdom, Remedy, Citrix Server, CA(Quest) Technologies, NetVault, Business Objects
Confidential, Harrisburg, Pa
Business Analyst/Database Developer
Highmark. Camp Hill, Pa.
Documentation of existing Database Application utilized with in the Actuarial and Sales Departments. Responsible for database design, DBA functions and ETL development. Maintain and develop enhancements for the Access database utilized with in the Actuarial and Sales departments. Acting the capacity of mentor providing assistance and training to other developmental staff both in Camp Hill and Pittsburgh. Create table structure and relationships. Design easy to use user forms. Create reports for end users. Assist with trouble shooting issues with VBA Code. Design import specifications and data mining processes between various systems. Provide End user training on enhancements. Assist and provide input in a Java Development project.
Applications: Lotus Notes, MS Office Suite, Crystal Reports, Access, SAS, Informatix, SQL 2000