TECHNICAL SKILLS:

Advanced skills on MS Suite of Software: Word, Excel, Access, PowerPoint, Outlook, SharePoint

Statistical and analytic experience: GIS, Stata, SAS and SPSS

Programming: UNIX, C, Quancept, HTML, Visual Basic, Tableau, JIRA, SQL, R, Alteryx

Clinical database super user: Oracle*Clinical, MedDRA, WHO - DD, EDC, AERS, Medidata - Rave

PROFESSIONAL EXPERIENCE:

Confidential, Northbrook, IL

Business Analyst

Responsibilities:

• Fulfill the hybrid Analytics - IT business role and identify and map strategic data from pharmacy customer databases using SQL queries to support the Analytics Team project creation
• Stream in data from various sources and create automated workflows in Alteryx
• Connect output data to Tableau vis and dashboards for ongoing live reporting

Confidential, Addison, IL

Data Analyst

Responsibilities:

• Mapping medical provider data across domains and assigning/reconciling primary key identifiers by comparing SAP to legacy data in Excel

Confidential, Morton Grove, IL

Data Analyst

Responsibilities:

• Map and extract company data from PDFs and compare to legacy submittal data in Excel
• Find best photos, line drawings, schematics, and curves for pump series and help create a dynamic repository in SharePoint for XOL and Windchill Global Vault
• Assist with database process schema, maintenance, macros after Excel input is completed

Confidential, Chicago, IL

Access Data Analyst

Responsibilities:

• Use MS Access, Excel, VBA and SQL to create and maintain Medical Center Provider Database.
• Perform source to target mapping to track providers across years and instill quality control.
• Use SQL queries to verify and maintain accurate metadata in the master and control files of the database Blue Distinction Link and BCBS SharePoint user environment.
• Maintains documentation on system files and reports and becomes familiar with operational, legacy data source systems in order to better understand analytic data lineage and repositories.
• May recommend database improvements or coordinate system modification with appropriate personnel.

Confidential, Evanston, IL

Research Analyst

Responsibilities:

• Use VoxCo, WinCross, Ascribe, SPSS, and MS Suite of Software to gather, clean, code, analyze, and present financial driver data for major banks, insurance companies, and financial institutions.
• Implement project design, quality control, banner and chart creation, report, and data management.
• Use critical thinking skills to work with project team managing data collection, preparing and processing data, performing quantitative and qualitative analysis, and writing and preparing report results and creating dashboards and data modeling.
• Excel utilization to utmost including vlookup, macros/visual basic, pivot tables, dashboards.
• Follow script debugging and quality validation processes to ensure workflow is clean and functional.

Confidential, Rosemont, IL

Research Analyst

Responsibilities:

• Support data integrity standards across the enterprise that can be applied consistently to critical customer information used by the entire company and provide a single source of data truth.
• Enable improved onboarding of new customers, contract management, and revenue management.
• Code customers into correct firmographic segmentation categories (Independent-Regional-National) and provide menu/restaurant types using Internet and other search techniques.

Confidential, Chicago, IL

Research Analyst

Responsibilities:

• Receive and respond to queries from Confidential and national office staff about Confidential membership, finances, programs, facilities, and manage these multiple projects.
• Participate in research-related team projects, attend meetings, and creatively contribute to departmental knowledge management initiatives.
• Use advanced knowledge of Microsoft Access, SQL joins and Excel, including building queries, crosstabs, chart creation, and macros; understanding formulas; and delineating names in worksheets.
• Listen and use effective written and verbal communication skills and have ability to acquire, interpret, and integrate information from a variety of sources, including databases, web, and people.
• Display willingness and ability to work both independently and in a highly integrated team environment.

Confidential, Deerfield, IL

Medical Dictionary Analyst

Responsibilities:

• Assist with the development of coding processes, standardized operating procedures, and guidelines, and participate in audit/inspection readiness for compliance of FDA, EMA, and other agencies.
• Assist in the development of training classes and overall training program and conduct training across functional areas for coding, coding dictionaries, and coder-browsers and recode non-current terms in Confidential ’s Oracle Clinical, Safety Database periodically.
• Assist in coding WHO-DD coding, MedDRA searches, product labels, Company Core Data Sheet (CCDS), and package inserts and use MS SharePoint to up/download Excel, Word, and JPEG files.
• Assist in the development, implementation, and analysis of Standardized MedDRA queries (SMQs) and Company MedDRA queries (CMQs) to facilitate post-market signal surveillance.
• Investigate medical adverse events during daily Verbatim Term Assignment (VTA) meetings with doctors and nurses and work with clinicians on medical dictionary terms on product reports in Pharmacovigilance & Regulatory Affairs.

Confidential, Chicago, IL

Early Literacy Evaluator

Responsibilities:

• Observe, learn, and coordinate child reading and testing techniques with Early Reading First staff.
• Follow Standard Operating Procedures (SOPs) and Data Processing Plan (DPP) and client conventions.
• Perform DCF creation, entry, and QC checks using Oracle Clinical and SQL query tools.
• Perform manual review of casebook to verify edit checks in the DMRP are working properly and to identify data discrepancies outside of the DMRP and communicate these potential issues to higher level CDMs, Project Leads and/or the client as needed.
• Maintain overall consistency and accuracy of data entry, DCF entry, and Data Management Review.