Data Analyst Tableau

`EGABOU, KENNETH AKPOS

#****Eaves Drive, Owings Mill, MD, 21117

***************@*****.*** Mobile: 443-***-****

•4+ years of Data Analyst experience.

•Experience using MS Excel, SQL and/or other applications to perform various types of analysis.

•Skilled in Microsoft Access, PowerPoint, SQL Server and various RDBMS.

•Installation, testing, configuration, maintenance, and troubleshooting of all SQL Server components.

•Experience with BI tools such as Tableau and PowerBI.

•Proficient in Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.

•Skilled in writing Business Requirement Documents (BRD), Use Cases, Functional Specifications; well versed with Use Case Diagrams, User stories, Process flow charts and UML modeling tools such as MS Visio.

•Expert in Agile Methodology of SDLC for implementing Business projects.

•Experience with collaborative tools such as SharePoint and JIRA.

•Knowledge on Power BI and Tableau to import and analyze data from various sources such as SQL Server.

•Create various filters and parameters for reports using Tableau desktop.

•Skilled in Microsoft Excel (e.g., formulas, pivot tables, graphing).

•Experience in data migration tasks using PL/SQL, SQL Loader.

•Experienced in Data Migration, Data Transformation, Data Conversion, and Data loading.

•Experienced in Sales force Customer Relation Management (CRM) application.

•Experienced working with Amazon Web Services (AWS)

•Experience in Python Programming

Applications

T-SQL, PL-SQL, Excel, access, Tableau, PowerBI, Micro Strategy, JIRA

Professional Experience

Data Analyst

United Healthcare,

Washington, DC April 2018 to Present

I work as part of the data analytics team on a process improvement project. My role as a data analyst is to report and uncover meaningful insights on the activities of the various providers.

•Create and run queries as necessary for project deliverables using SQL

•Work closely with the Risk, Team Leads, and stakeholder to come up with a plan to effectively find the correlation of at-risk enrollment behaviors.

•Evaluate data pulled for accuracy and relation to data requests

•Support leadership team in explaining and disseminating information to appropriate stakeholders

•Develop statistical methods to evaluate and analyze numerical data using computer software, including MS Access, MS Excel, Oracle, SQL and/or other applications, for assigned projects

•Develop innovative analytical approaches and predictive modeling techniques for reactive or proactive data analysis, sampling, and study design

•Develop trend reports to identify potential program or systematic vulnerabilities

•Provide expertise and guidance to unit and corporate staff as required.

•Represents and participates in group or committee discussions.

•Involve in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.

•Improve query performance.

•Data Profiling for accurate and better reporting and analysis.

Data Analyst

Navy Federal Credit Union,

Vienna, VA June 2016 to April 2018

The project was an enhancement project. My role was to work as a data analyst in the customer management team to help enhance the online account manager. In this role, I was solely responsible for the monthly and weekly reporting of various customer activities.

•Extracted, compiled and tracked data, and analyzed data to generate reports

•Participated with troubleshooting, and problem resolution efforts

•Performed daily data manipulation using SQL and prepared reports on weekly, monthly, and quarterly basis.

•Used Excel functions to generate spreadsheets and pivot tables

•Identified, analyze, and interpret trends or patterns in complex data sets

•Cleansing and Blending multiple data sources to allow for different views on application data in a single dashboard

•Aided team in data collection to be used for Tableau visuals

•Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool

•Perform data manipulation operations like import/export data from various external file formats using SQL

•Generated variety of business reports from SQL server using excel with pivot table and pivot chart

•Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality

•Checked for invalid/out of range data

• Perform data manipulation operations like import/export data from various external file formats using SSIS

•Develop, update, and maintain current SQL programs

•Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality

•Acquire data from primary or secondary data sources and maintain databases/ data systems

Education

University of Wales, United Kingdom 2012

MBA General Management

Cavendish College London, United Kingdom 2011

Postgraduate DMS [BTEC Extended Diploma in

Strategic Management and Leadership]

Rivers State Polytechnic, Bori, Nigeria 2003

Contact this candidate