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

• 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 AED portable emergency defribrillators
• tracking database t SharePoint 2010

Duties:

• Lead development of SharePoint 2010-linked MS Access 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 / Dept. of Homeland Security, Immigration Health Service Corps DC 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 Access 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

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

Webmaster-Developer-OpenText ECM Analyst

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

SQL Server 2000 Database Analyst

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 Sr. HR Records Coordinator - MS Access and Excel Developer 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 Grants Data-Imaging Supervisor Excel- Access Developer 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.
• Confidential Webmaster Content Manager Tech Writer Key Accomplishments
• Redesigned The User-Interface Of A Severe Weather Website Using Frames And Homesite
• Improved Site Navigation Incorporated Section 508 Accomodations for Disabled Users
• Duties:
• Managed several Federal Aviation Administration FAA websites:
• Published content using NetObjects Fusion Homesite
• Developed and edited graphics via PaintShop Pr and Adobe Acrobat
• Scanned images for publication t Fly.FAA.Gov, and several FAA intranet sites.
• Experimented with Open-Source Image and Document Scanning automation including 3rd party bulk imaging and OCR engines.
• Created charts and reports, produced PowerPoint presentations -some including animation
• Produced MS Word 2000 user manuals

Confidential

COGNOS Series 7 Impromptu Reports Developer

Key Accomplishments

• Assisted in Automating MS Word Macros VBA for custom formatting
• Improved report readability as reports were formatted on-the-fly
• Duties:
• Developed, Scheduled, And Distributed Cognos Impromptu Reports t DoJ Staff including: Attorney-Time-Use reports, Dollar Cost Attorney Litigation reports, and Ad-Hoc reports.
• SQL query development and familiarity with MS SQL 2000 were keys t success.
• Confidential Clinical Research Associate-Tech Writer
• Interfaced regularly with DoJ SQL Server personnel t gather reporting requirements and examine SQL Schema.
• Cross-Trained in Cognos Powerplay Transformer in Datawarehousing-BI and Analytical Processing OLAP topics

Key Accomplishments

• Developed an ASP 1.0 Website MS Access back-end T Web-Enable NIH Research Protocol Submissions
• Users can instantly submit and display research studies on a local intranet
• Duties:
• Monitored Clinical research protocols of vaccine and biologics from study initiation t closeout under development by NIH/NIAID sites.
• Reviewed monitoring and vaccine accountability reports for adherence t FDA regulations
• Prepared reports of clinical studies and drafted routing FDA submissions in MS Word
• Assisted in maintaining site and physician participation data
• Developed an ASP 1.0 VB Script Website MS Access back-end T Web-Enable NIH Research Protocol Submissions

Confidential

Team Lead, Sr. Nuclear Document Indexing Analyst

Key Accomplishments

• Considered a Subject Matter Expert on Radioactive Waste topics for indexing metadata int a Nuclear Regulatory
• Database
• Duties:
• As Team Lead, Managed indexing and coding duties of the division RFLC :
• Ensured indexing metadata quality control of Nuclear, Regulatory, Engineering documents including Reactor Emergency Security plans , Site Maps, and Drawings
• Managed the team as needed by interfacing with with RFLC and NRC Project Staff in daily duties and at times of issue resolution
• Coded Nuclear, Radioactive Waste, and Regulatory documents for entry int a NRC Regulatory Database
• Prepped documents by recording workload, sorting documents int batches
• As an onsite NRC Business Analyst, studied improved document workflow operations at the Document Control and File Centers
• As Document Analyst: Indexed, abstracted, and entered nuclear regulatory and engineering documents metadata int an NRC database

Confidential

Document Analyst Visa Information Specialist

Duties:

• Promoted t Public Relations unit: Provided Telephone Support T Callers Of A National Visa Center Hotline Requesting Case Status And General Immigrant Visa Information and tracked case information by querying a Visa Information System
• Responded t telephone written inquiries of case status
• Indexed visa applications for permanent residency in French per INS and State Department regulations.
• Languages:
• Bahasa Indonesia Semi-Fluent spoken French beginner spoken and written