| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEObjective20+ years experience in information technology, specifically in software development and database administration.SAS developer with systems and software engineering expertise. As a SAS Developer, he performs all aspects of the software lifecycle - analysis, design, development, testing and documentation, implementation, and maintenance currently on the DHA TOC contract. Supported DHA and MHS forthe past 20+ years. He has technical expertise in SAS, SQL, PROC SQL, PROC FREQ, PROCSORT, Shell Scripting, using SAS Enterprise Guide 7.1. Server Integration Services (SSIS),HealtheAnalytics, AVHE, Tableau, RedShift He is adept at translating complex business requirements into customized reports using SQL and Excel.I currently hold a TOP Secret ClearanceAbility Summary Installed SAS Enterprise Guide and Maintenance on Laptop Computers. Member of SAS team of analysts involved in software upgrades and deployment capacity planning hardware and software integration and back-up strategies. Determined storage growth and implemented measures to maintain it. Extensive use of PROC SQL, PROC FREQ, PROC SORT to perform queries, join tables. Develop routine SAS Macros to create tables/libraries for inclusion in daily, weekly, and monthly Analytical Reports. Developed reports per Business Requirements and created various reports like Summary reports, Tabular reports, etc. Conducted research to enhance programming techniques SAS usage and data access. Exported data to Excel and Access for reporting, summarizing, and created bar graphs and charts in Excel, and integrated data from different systems into an Access database. Assisted with redesigning TRICARE Operations Center (TOC) website using SharePoint and migrated the site to the Health.mil website.Employment History04/2019 - CurrentSenior Business Process EngineerAegis Corps, Chantilly, VADeveloped SQL Server Integration Services (SSIS) included designing new programs to ingest data into MHS Information Platform (MIP).Installed SAS Enterprise Guide and Maintenance on Laptop Computers.Member of SAS team of analysts involved in software upgrades and deployment capacity planning hardware and software integration and back-up strategies.Determined storage growth and implemented measures to maintain it.Extensive use of PROC SQL, PROC FREQ, PROC SORT to perform queries, join tables.Develop routine SAS Macros to create tables/libraries for inclusion in daily, weekly, and monthly Analytical Reports.Developed reports per Business Requirements and created various reports like Summary reports, Tabular reports, etc.Generated output using SAS/ODS in CSV, XLS, and DOC formats.Conducted research to enhance programming techniques SAS usage and data access.08/2015 - 01/2019Systems IntegratorIrving Burton Associates, Falls Church, VAInstalled SAS Enterprise Guide and Maintenance on Laptop Computers.Member of SAS team of analysts involved in software upgrades and deployment capacity planning hardware and software integration and back-up strategies.Determined storage growth and implemented measures to maintain it.Extensive use of PROC SQL, PROC FREQ, PROC SORT to perform queries, join tables.Develop routine SAS Macros to create tables/libraries for inclusion in daily, weekly, and monthly Analytical Reports.Developed reports per Business Requirements and created various reports like Summary reports, Tabular reports, etc.Generated output using SAS/ODS in CSV, XLS, and DOC formats.Conducted research to enhance programming techniques SAS usage and data access.Exported data to Excel and Access for reporting, summarizing, and created bar graphs and charts in Excel, and integrated data from different systems into an Access database.01/2011 - 08/2015System IntegratorLeidos, Falls Church, VAInstalled new 8.0 SQL Servers and maintained eight servers. Performed all aspects of database administration, including data modeling, backups, replication and recovery. Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) included designing new programs and debugging existing programs. Maintained, debugged and optimized existing data warehouse system and streamlined batch process. Wrote stored procedures and Transact SQL code as well as VB script. Created Perl, SQL queries and scripts to update and create tables, extract data for uploading, reporting, analysis and data consistency checks. Exported data to Excel and Access for reporting, summarizing, and created bar graphs and charts in Excel, and integrated data from different systems into an Access database. Converted and modified existing matrix reports from Crystal to a more dynamic reporting tool utilizing Excel Pivot Tables and Power Pivot. Redesigned TRICARE Operations Center (TOC) website using Dream weaver and migrated he site to the Health.mil website. Redesigned all of TRICARE Operations Center's (TOC) numerous reports from basic Excel to Pivot Table style reports.Education HistoryInformation Systems TechnologyMaster's DegreeGeorge Washington, DC |