Data Analyst Assistant
Resume:
Amie Mends Cole
**********@*****.***
PROFESSIONAL PROFILE
A proactive individual with a wide range of IT knowledge and expertise gathered over the span of 5 years in fields such as healthcare and education domain. And skilled at analyzing clinical data to deduce operational efficiency, utilizing statistical and business intelligence tools to streamline workflow, and analyzing and monitoring data integrity and status.
Dedicated about projects and able to carry out tasks that are time sensitive in an efficient manner to guarantee the growth and success of the organization.
TECHNICAL SKILLS
Operating Systems
Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix
Databases
MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2
ETL/Other Tools
Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant
Querying Tools
SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata-BTEQ, PL/SQL
Querying language
SQL, PL/SQL, TSQL
Business Intelligence Tools
Tableau 9.1, 9.2, 9.3, 10.2, 10.4, MicroStrategy, Excel and PowerPivot, Power-BI, SSRS, SAS, Crystal Report
Predictive Modeling Tools
SPSS, SAS
PROFESSIONAL EXPERIENCE
Sanford Medical Center Fargo ND Mar 2018 – Apr 2020
Healthcare Data Analyst
Responsibilities:
Provided analytical/administrative support to leadership in the development of department workflows, project plans, policies and procedures
Designed and implemented clinical research studies
Investigated data to find patterns and trends
Managed research projects, formulate project plans, and review highly appraised journal articles
Performed quality improvement analysis that align with clinic/program goals to improve workflow
Collaborated with interdisciplinary team to find efficient ways to enroll the patients into the disease managed programs and optimize care of the patients
Utilized medical writing knowledge to publish scientific manuscripts
Performed statistical modeling and predictive analysis using various tools
Adhered to firm IRB policies and procedures
Clinical patient interventions
Worked with physicians, nurses, pharmacists and other healthcare professionals to evaluate current EMR functionality and developed future applications by building and using efficient decision-making processes
Researched patient data across multiple applications to resolve discrepancies and / or improve workflow
Prairie Saint John Hospital
Fargo, ND Jan 2017 –Mar 2018
Healthcare Data Analyst
Responsibilities:
●Supported project teams in matters such as solution design, primary research coordination, analysis and creative strategy formulation, reporting and presentations
●Monitored data collection, performed data queries and data analysis
●Assisted in manuscript writing and hypothesis development and testing
●Performed statistical analysis of large data, predictive modeling, data manipulation, and reporting
●Document and maintain all departmental processes and procedures
●Maintain secondary files necessary for the support of the products.
●Proactively manage the content accuracy of internal data tools as well as how this content is integrated into the solutions
●Collaborate and coordinate with internal teams to assist with content development
●Continuously monitor and stay up to date on technical, industry and business trends and take responsibility for personal development.
Bank of the West, Fargo, ND Feb 2014 - Dec 2016
Tableau Developer, Data Analyst
Responsibilities:
Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
Experienced in Data mapping, Data transformation between sources to target data models.
Analyzed reporting requirements and developed various Dashboards.
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
Responsible for developing, analyzing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
Used statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems.
Used SAS to solve problems with data and analytics.
EDUCATION
Bachelor of Art in International Relation December, 2015
West Chester University--West Chester, PA
Bachelor in French December, 2015
West Chester University--West Chester, PA
Associate Degree in Allied Health Technology December, 2011
Pennsylvania Institute of Technology
Media, PA
Contact this candidate