We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume Profile

4.00/5 (Submit Your Rating)

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

We'd love your feedback!