SUMMARY:

• Provided innovative ideas to improve an enterprise level cloud based data capture system.
• Instructed end users how to submit, download, and query data through proprietary software.
• Progressively worked in the realm of data from data entry and data analysis to developing business requirements for capturing data from disparate sources to finding and working with client subject matter experts to resolve systemic data quality issues that adversely impact reporting.
• Demonstrated the ability to quickly learn new data warehouses and subsequent databases.
• Demonstrated the capability to provide trend analysis and statistics for client relationship managers to provide insight for high level business decisions.

TECHNICAL SKILLS:

Databases: SQL Server, MS Access

Operating Systems: Windows 7, XP, Mac OS X

Professional tools: MS Office, Word, Outlook, Excel, PowerPoint, Qlikview

PROFESSIONAL EXPERIENCE:

Confidential

Operations Analyst/Data Analyst

Responsibilities:

• Provide operational/technical support for Department of Defense and National Institute of Health funded traumatic brain injury researchers to facilitate quarterly data submissions.
• Initiate software changes through the change control board and provide requirements.
• Complete user acceptance testing leading up to software releases in an Agile environment.
• Support production releases by testing modules in conjunction with QA team and developers.
• Convey end user issues to production support via JIRA and work with both parties to troubleshoot
• Lead weekly webinars to educate researchers and end users how to use multiple modules of the proprietary software.
• Act as a liaison between DOD and NIH stakeholders, Science Officers, and principle investigators to implement policy.
• Curate and review data elements for entry into the data dictionary for National Institute of Neurological Disorders and Stroke recommended case report forms.
• Verify quality of data using formulas in Excel to provide gap analysis. Utilized If/Then and V - lookup formulas. Used pivot tables for reporting.
• Use SQL for querying JSON database for user outreach and validation of data transfer.

Confidential

Data Migration Analyst/Data Analyst

Responsibilities:

• Migrated Macintosh hard drives from one server to an instance of iManage, a document management system, to support case management for a division of a law firm.
• Analyzed file names to ensure proper migration. Utilized proprietary software to remove special characters from names of folder structure and individual files for successful imports. Developed PowerShell scripts to make the process more efficient.
• Confirmed completion of the data migration via Beyond Compare software to ensure the data structure and all supported file types were successfully migrated.
• Tested databases to ensure correct transfer of metadata and completeness of files.

Confidential

Data Analyst

Responsibilities:

• Developed an Access database to track instances of help desk tickets from USDA food safety inspectors, public health veterinarians, and district managers from food warehouses nationwide.
• Wrote SQL code to find data quality issues in the database behind the Public Health Information System web interface.
• Worked with subject matter experts to verify data quality issues to make recommendations for solutions.
• Developed SQL code to fix or remove numerous data quality issues. Coordinated with the database administrator to run SQL code in production after going through CCB.
• Reported recommendations for long term system modifications in the PHIS web interface and in the database to avoid data entry and data quality issues in the future.

Confidential

Data Analyst

Responsibilities:

• Received files from project managers, loaded files into a staging database after formatting files to correspond to SQL table columns via Qlikview.
• Provided weekly metrics for project managers using Qlikview automated reports. Imported files into a production database using SQL Server Management Studio.
• Used templates for survey websites to launch new sites for new surveys. Edited template HTML code in Microsoft Visual Studio to convey new titles for new surveys as well as change the directory location for survey answers for views in a database. Script new views in SSMS for new surveys.
• Performed QC by searching the production database for errors such as spelling errors, duplicates, and Null values.
• Worked with Operations team to ameliorate errors. Custom reports were created in Excel for ad hoc requests using pivot tables, V-Lookups, and other formulas.

Confidential

Data Analyst

Responsibilities:

• Retrieved incoming files from third party vendors for 40+ clients containing incentive completion data, eligibility information of employees, and biometric values via sFTP sites.
• Manipulated files utilizing SQL scripts in the business intelligence software Qlikview and/or Excel for upload into a database for processing incentives for biometric screenings, health challenges, and various other medical screenings.
• Generated reports for challenges where data comes from multiple data feeds such as mobile apps, FitBit devices, or surveys on SurveyMonkey via web based Qlikview dashboards.
• Provided quality assurance for other data analysts ’ SQL and Qlikview scripts to insure accuracy and justify the logic.
• Worked with CRMs and client point of contacts to define new or improve existing business requirements for ETL processes and delivered weekly, monthly, and quarterly reports utilizing automated reporting tools.
• Compared eligibility files from health insurance companies to self-reported activities from employees to deliver incentive files to end clients.
• Used Excel for reporting. If/Then statements, V-lookups, pivot tables, Macros recordings, and CountIfs were all pivotal for timely deliverables.

Confidential

Data Analyst/Health Data Entry Assistant

Responsibilities:

• Managed and audited access to protected Electronic Health Records for veterans ’ power of attorney nationwide.
• Updated and input data as required ensuring quality of mission critical information in a health information access database.
• Prepared reports and provided ad hoc data analysis as requested to track monthly work flow and find trends.
• Provided national help desk service to research doctors and lawyers with access to the EHR in regards to access and verify codes as well as software support.
• Tracked and coordinated input from other program offices in the nationwide veteran network.

Confidential

Database Specialist

Responsibilities:

• Coordinated with the Deputy Director of the division to centralize specifications of licensed products and new drugs under investigation in a novel Access database.
• Researched several pharmaceutical companies ’ upstream and downstream processing to discover common practices and outline them thoroughly in Excel to demonstrate patterns and trends in the pharmaceutical community.
• Excel was used to track work loads of the drug review team. Complex formulas were used to assign work. The data validation tool in Excel was used to assign work fairly.
• Extrapolated data from several databases to provide statistics of workload in the division, which lead to individual workload scores for over 40 reviewers.
• Tracked a Continuing Resolution budget allotment. Accepted purchase requests, completed market research for requested items, and delivered compiled lists to the director for approval.