Data Analyst Resume Example Crossmark

DATA ANALYST

Summary

I am an IT professional with more than 5 years' experience in various domains such as Finance, Insurance, Retail and Healthcare. I am present with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources. I pride myself in my ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and utilize that in completion of my tasks on the job. I can perform multiple duties in business analysis, project or program management, and functional leadership. I am also a great team player who can relate and work efficiently with diverse groups.

TECHNICAL SKILLS

Operating Systems

Win XP, Vista, 7,10, Windows Server 2003, 2008, 2012, Unix

Databases

MS SQL Server 2008R2/2012/2016, Teradata 12/13, MySQL 5, Oracle 9i, 10g, 11g,12c, DB2

ETL/Other Tools

Informatica Power Center 8/9, SAS Base 9.x, SAS Enterprise Guide, SSIS, Alteryx

Querying Tools

SQL Management Studio 2008-2017, SQL Plus, SQL Developer, PL/SQL, PSQL

Querying language

SQL, PL/SQL, TSQL

Business Intelligence Tools

Tableau, Cognos, Excel, PowerPivot, SSRS, SSAS, SSIS, Power BI, QlikView

Skills

Ability to utilize business intelligence tools such as data warehousing, reporting, querying tools and excel.
Experience in Data Analytics and ETL techniques for loading enormous amounts of data.
Experience with DATA MINING.
Ability to identify issues when reports are created from several and complex data sources.
Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
Strong ability to write SQL queries.
Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
Excellent knowledge and usage of reporting tools such as Tableau and Crystal Reports.

Experience in data scrubbing and cleansing.
Great understanding of SDLC methodologies (specifically SCRUM).
Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
Good knowledge of portfolio analysis, management and customer segmentation.
Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
Exceptional organizational and time management skills and the ability to work independently.
Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

Experience

Data Analyst | 08/2019 to Current
CrossMark - Houston, TX

Designed the Reports as per client Requirement and created the reports using Excel file, SQL Server and Oracle databases.
Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracleand SQL Server.
Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
Extracted, manipulated and built complex formulas in Tableau for various business calculations.
Involved in resolving reporting issues and design issues throughout the reporting life cycle.
Developed SQL queries to manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
Ensured all project requirements and objectives are properly documented and pursued.
Created conditional filters to filter the data on dashboard.
Creating Parameters for desired functionality.
Responsible for developing, analysing 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.
Work with client and team members to understand and clarify visualization requirements
Written complex SQL queries and optimized queries for performance tuning.
Exporting data to MS Access and Excel for periodic and exception reporting; creating various types of graphs and summaries.
Interacting and communicating with colleagues as required for routine and ad hoc tasks to achieve objectives effectively

Senior BI / Data Analyst | 03/2018 to 08/2019
JP Morgan Chase - New York, NY

Maintain Structured Query Language (SQL) and extract, transform and loading processes established to aggregate various data sources across the Bank used in analysis and modeling.
Complete quality assurance on data feeds, rectifying inconsistent or erroneous data to ensure the accuracy of data used in these analyses; research and respond to ad-hoc data requests.
Maintain the data structures through proper change management for use by multiple risk practice groups.
Document and maintain data process procedures to serve as reference; adhere to established controls to ensure data quality.
Use appropriate analytical software to develop custom balance sheet and risk reports.
Provide financial analysis and data support to other groups/departments across the Bank as needed.
Support presentation and visualization of data through standard tools (e.g. Tableau).
Support Treasury Division contributions to bank wide efforts (e.g. Stress Testing).
Create Technical / design specification based on business requirements in clear and concise formats.
Designed and use of Tableau Analysis/Reporting tool.
Proven ability to manage and analyze large data sets, with careful attention to detail.
Strong interpersonal skills, with an equally strong desire to learn Advanced computer skills and strong knowledge of pertinent word processing, spreadsheet and database software.
Experience using SQL, SAS or related language.
Designing automated processes to move, format, standardize and scrub large amounts of data.
Building databases for data standardization, data archiving and reporting.
Creating, maintaining and managing SQL Server Integration (SSIS) packages

Well Care, Contractor | 04/2016 to 03/2018
DATA MINING - Tampa, FL

Creating KPIs for various lines of businesses for decision making purposes.
Supporting various departments such as Med Management, Customer service, and Finance with their daily ad-hoc data needs.
Writing and maintaining stored procedures to keep track of Monthly spending on, and MLR of patients and groups.
Creating reports to track ED Utilization and measures to reduce Utilization.
Utilizing knowledge of ICD codes, Procedure Codes, and Rev Codes to provide useful reports on utilization and Finance.
Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases.
Utilize SISS for ETL data modeling, data migration, and analysis.
Prepare high level analysis reports with Excel.
Provides feedback on the quality of data including identification of billing patterns and outliers.
Analyze and Assess invalid and missing data in the Claims Data.
Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts.
Documenting the extent to which data fails to meet threshold reporting requirements.

Education and Training

University of Benin

BACHELOR OF SCIENCE

2016

information technology.

Resume Overview

Companies Worked For:

CrossMark
JP Morgan Chase
DATA MINING

School Attended

University of Benin

Job Titles Held:

Data Analyst
Senior BI / Data Analyst
Well Care, Contractor

Degrees

BACHELOR OF SCIENCE

Data Analyst Resume Example

Resume Score: 80%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes