Summary:

Senior Data Scientist with 23 years' of Data Science, Programming, Microsoft Office experience in Government , Healthcare, Scientific, Regulatory and Enterprise Content anagement - Imaging settings

Experience

• Confidential Access Database Temporary Consultant/Amtrak Emergency Management Corporate Security. : 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 t 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 t 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

Confidential

Sr. Data Scientist- Programmer IBM Cognos 10 BI Reports Developer

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 t Map ePEB Data Elements t 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 t 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 int optimized Excel workbook format, automated pivot table generation via Excel VBA Macros.
• Created MS Word documentation t capture data modeling andgeneral content workflow technologies and processes
• MS Access Query Development Temporary Disability Database and Data Import int database .XLS,.CSV

Confidential

Sr. Health Data Scientist Programmer

Key Accomplishments

• Assist in Mapping Legacy MS Access database data elements from Legacy database t ASP.Net web app
• Architect Automated MS Access Excel Apps for Public Health Personnel Across 23 Hospitals Clinics OCONUS t 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/ER Provider Resources

Duties:

• Architect, Develop, and Test solutions t 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
• Familiarities:
• Detention Healthcare, Electronic Medical Records CaseTrakker/MedEz
• Public Health Epidemiology
• SOAP chart notation

Confidential

Website Consultant President

Key Accomplishments

• Developed OaktonVa.Net Highlighting The Oakton, Virginia Community Using Googlemaps Technology
• Developed International Environmental Consulting Firm Website Highlighting Environmental Studies
• Duties:
• Developed OaktonVA.Net, for the Oakton, VA community. This site incorporates GoogleMaps Apps script t promote public awareness of the Oakton locality, as well as provide useful information.
• Past website projects have included the design of an environmental company website, a church website developed an ASP-MS Access Event planning tool .
• Website and Design Tools used :
• MS Visual Studio/Web Developer 2005 Express
• VB Script ASP
• FTP
• Photoshop
• HTML
• CSS

Confidential

Key Accomplishments

• Assisted in Architecting New Kofax Kofax-Certified Imaging Workflows with Distributed Users via Kofax Ascent Capture 6.1 ACIS Web Server module
• Enabled Distributed Image Capture, Validation, and Release int OpenText-LiveLink 9.1 9.5 ECM Content Management System
• Duties:
• Supported GD Intranet Knet And Livelink 9.1/9.5 Document Portals Comprising 70,000 GD User Base With Issues Encompassing Permissions And Data Disruptions, Oracle Access Management LDAP-Oblix Netpoint , And Troubleshooting Production Kofax Imaging and LiveLink Image and Data Payroll and Tax Forms Release For SRI, GD's Financial Branch.
• Installed and Configured LiveLink Release Script Software, Setup Configuration of LiveLink Metadata Attributes, Test Image/Data Release int LiveLink
• Tested Troubleshooted Network Connectivity, and Insure Kofax Client-Server Synchronization During New General Dynamics Configurations
• Certified As Kofax Specialist, Assisted In Architecting And Integrating Kofax-Livelink Workflows For New GD Accounts Interested In Image Capture And Storage Within GD's Livelink Content Repository .
• Developed Livelink LiveReports T Assist In Providing Business Intelligence T Client And Project Management.
• Assisted In Managing GD.Com internet website presence, Content Publication T A Sharepoint Intranet Portal, And Developed ASP Web Applications In The Intranet Portal, Including An Environmental Health Application.

Confidential

Key Accomplishments

• Developed An MS Access Database With Reports T Better Track Software Defect Records
• Defects Were Instantaneously Identified and Traceable
• DUTIES:
• MS Access VBA code and macr step-throughs
• UAT Test Documentation in MS Word and MS Excel
• MS Word documentation of a large MS Access legacy database of DoD parts equipment inventory database.
• Manually Tested a .Net version of the database
• Trained on Cognos 8 BI reporting software

Confidential

Key Accomplishments

• Developed SQL Scripts, SQL Server DTS Tasks, And Other Structures
• Enable Data Reconciliation On A Test Database
• Created Crystal Reports from a SQL Server - Access-Linked Database
• Pinpointed Inconsistencies During Data Reconciliations.
• Tested And Programmed A DOD Inventory Management Tool In ASP-VB Script ASP.NET 2.0
• Data could be submitted and viewed online in-house
• DutieS:
• Provided SQL Server 2000 Database Support on a DoD Inventory Management Biometrics Equipment Project t include:
• Import-Export ETL
• SQL Queries and t-SQL Basics
• Jobs
• DTS Tasks.
• Troubleshooted Data Connectivity with SQL Server and MS Access Databases
• Data Reconciliation via Crystal Reports And MS Access
• Provided Light ASP-VB Script And .NET Programming.
• Familiarities:
• Biometrics Identity Hardware
• Government Inventory and Logistics Concepts.

Confidential

Key Accomplishments

• Created Visi Workflow Diagrams Attended Strategy Meetings In Efforts T Redesign HR Document Tracking Process via e-OPF Imaging Test Pilot
• Developed A MS Access Document Tracking System T Assist In Tracking Batches Handed-Off T An Imaging Contractor
• Programmed MS Excel Visual Basic Macros VBA For Daily Production Metrics
• Reports now delivered via Outlook Email Client
• Duties:
• As Sr. Coordinator, In A Records File Center Housing 65,000 Official Personnel Folders OPF's For Aviation Security Screeners, Automated Metrics Reporting via Excel VBA Macros via Outlook Client
• Participated in TSA HR Document Imaging discussions.
• As Jr. Coordinator, Managed Document Inflow, Reported and Recorded Daily Metrics Using MS Excel Spreadsheets And Charts.
• Located And Tracked OPF's Using An Acorde Barcode System and Filed Government HR Documents Bound For Screener OPF's.
• Siebel End-User CRM Training.

Confidential

Key Accomplishments

• Automated Grant Metadata Validation Excel VBA Macros
• Quadrupled Manual Quality Control Speed as Hundreds of Rows QC'd Immediately
• Improved a MS Access Employee Time Entry System
• Doubled Utilization of Management Reports as Reports Were Made More User-Friendly
• Duties:
• Supervised and Partially Automated an NIH medical grant document imaging project.
• Documents were scanned , metadata entered and extracted, data uploaded int a MS SQL Server and Oracle NIH IMPACII database for use by NIH reviewers.
• Insured data and image availability of 4 Doculex Tiff-to-PDF image conversion PC's.
• Resolved Doculex image conversion and Adobe Acrobat issues.
• Indexed and validated biomedical metadata and images.
• Automated grant metadata quality control and image production metrics using Excel VBA macros.
• Provided staff training in Adobe Acrobat, Document Imaging, Excel and Acrobat validation, QC, and metadata indexing.
• Manual Acrobat PDF capture and OCR was a backup means for image conversion during an outage.