Sr. Data Analyst Resume Profile
Arlington, VA
Summary:
- Access 2010 SharePoint Web Database Development Lead:
- Provided expert consultations on migrating a MS Access 2010 emergency equipment database to a SharePoint-linked Web database tracking AED's portable defribrillators aboard trains, police cruisers, and facilities.
- Maintained development focus where previously none existed
- Coordinated Database development activities.
- Highly Qualified Data Analyst-Programmer with 23 years' of experience in Government and IT Seeks Programming-Analytics position. Please see my expanded resume on LinkedIn
- Access Database Temporary Consultant Amtrak, Emergency Management Corp. Security: 05/2014 8/2014. Key Accomplishments:
- Lead development of SharePoint-linked Access 2010 web database designed to provide web data capture, management, and decision support capabilities pertaining to Amtrak's 1000 Automatic External Defibrillators AED's devices placed aboard trains, police cars, and facilities nationwide for life support purposes. Provided Access 2010 programming, requirements analysis, user testing, troubleshooting,and overall lead team of 2-3 developers.
Application
Sr. Data Analyst
Confidential
Accomplishments:
- Improved Weekly Excel Metrics Reporting: Developed VBA Code to automate processing of weekly reports extracted from Cognos 10 BI Business Intelligence reports
Data Modeling:
- Identified gaps between Datawarehouse source target data via IBM Cognos 10 BI Analysis Studio
- Cracked Black-Box Java App Source Code to Map ePEB Data Elements to Cognos 10 BI warehouse to Provide Reporting
- Map Data Elements in Cognos BI Data Reporting Model to DB2/FileNet Data and Content Stores
- Business Intelligence-DW: Setup Initial Cognos report environment: Completed Quarterly report within deadlines
- Test, Quality Validate, and Analyze gaps between Java and Cognos-based reports: Review latest Java/JPA source code.
- Lead Data Mapping effort to validate Cognos DataWarehouse models against FileNet P8 Content Server DB2 Database. Filenet Process Analyzer
- Configure and Automate Weekly Excel Reports from Cognos 10 BI report output. Process source data into optimized Excel workbook format included Pivot Table generation via VBA Code. Created documentation to capture the procedures involved.
Confidential
Data Modeler
Key Accomplishments
- Assist in Mapping Legacy MS Access database data elements from Legacy database to ASP.Net web app
- Architect Automated MS Access Excel Apps for Public Health Personnel Across 23 Hospitals Clinics OCONUS to HQ
- Test C /ASP.Net Web and MS Access Pan Flu/H1N1, TB, and Infectious Disease Database - Apps
- Designed ArcGIS Geospatial Maps and Map Templates Visualizing ICE/ERO Provider Resources
Architect, Develop, and Test solutions to manage and partially automate patient-level Detainee Health Records via Access and Excel VBA, SQL Server, Technologies: SQL, Access and Excel VBA, Functions, Charts, and Pivot tables. Troubleshoot user and data issues in Access-SQL Server: ODBC/DSN, firewall, DOS Ping and Tracert, and application log file inspections. Extract and manipulate data ETL : Familiarities: SQL Server: SSMS, Import/Export, DTS, Jobs, Procs. ASP.Net Public Health web applications testing: Test epidemiology web applications built in C ASP.Net, Visual Studio. Systems and Business Analysis, and technical documentation. ArcGIS/GIS maps and templates: Designed ArcGIS maps of IHSC provider resources across 23 federal detention centers. Familiarities: Detention Healthcare, Electronic Medical Records CaseTrakker/MedEz Public Health Epidemiology SOAP Notation
Consultant-
Confidential
Key Accomplishments
- Developed OaktonVa.Net Highlighting The Oakton, Virginia Community Using Googlemaps GIS Technology
- Developed International Environmental Consulting Firm Website Highlighting Environmental Studies