Database Temporary Consultant Resume Profile
4.00/5 (Submit Your Rating)
Washington, DC
Summary:
Senior Data Scientist with 23 years' of Data Science, Programming, Microsoft Office experience in Government , Healthcare, Scientific, Regulatory and Enterprise Content Management - Imaging settings
Experience
Database Temporary Consultan
Confidential
Key accomplishments:
- Coordinated database development activities of 3 developers and maintained development focus
- Provided expert consultations on migrating a MS Access 2010 emergency equipment database to a SharePoint-linked Web Content Management System tracking AED's portable emergency defribrillators
Duties:
- Lead development of SharePoint Content Management System-linked MS Access 2010 web database to track Amtrak's 1000 AED devices used in emergency life support.
- Access 2010 programming Macros
- User requirements analysis and testing
- Access and SharePoint Troubleshooting
- Process Modeling and Visualization
- MS Word documentation
Sr. Data Scientist
Confidential
Key Accomplishments:
- Setup Initial Cognos user and reporting environment
- Facilitated completion of Quarterly report within deadlines
- Configured and Automated via Excel VBA Macros Weekly Excel Reports used from Cognos report output.
- Cracked Black-Box Java-JPA Source Code to Map ePEB Data Elements to Cognos 10 BI warehouse for Reporting
- Identified and Visualized gaps between Datawarehouse source target data via Analysis Studio
Duties:
- Provided Ad-Hoc Scheduled Cognos Reporting via use of : Report Studio, Admin, Analysis Studio
- Lead Data Mapping effort to validate Cognos DataWarehouse models against FileNet P8 Content Server Workflow Processessing and DB2 database.
- Lead initial setup and provided training on PDA's SharePoint 2007 Content System: Out-of-The-Box , Permissions, Lists, MS Office Synch, Discussion, Wiki
- Test, Quality Validate, and Analyze gaps between Java and Cognos-based reports via review of Java/JPA source code
- Process source data into optimized Excel workbook format, automated pivot table generation via Excel VBA Macros.
- Created MS Word documentation to capture data modeling andgeneral content workflow technologies and processes
- MS Access Query Development Temporary Disability Database and Data Import into database .XLS,.CSV
Sr. Health Data Scientist Programmer
Confidential
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
Duties:
- Architect, Develop, and Test solutions to manage and partially automate patient-level Detainee Health Records via: MS Excel VBA and Macros, Functions, Charts, and Pivot tables.
- SQL Server 2005, SSMS, Extract, Transform, and Load ETL basics, Import/Export, DTS, Jobs, Procs.
- Troubleshoot user and data issues in Windows, Access-SQL Server: ODBC/DSN, firewall, DOS Ping and Tracert, and log file inspections
- Test Epidemiology web applications built in C ASP.Net, Visual Studio.
- Systems and Business Analysis, and technical documentation in MS Word
- Design ESRI GIS/geospatial mapping products and templates using ArcGIS for visualizing IHSC resource distribution across 23 federal detention centers