We provide IT Staff Augmentation Services!

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

We'd love your feedback!