Resume

Sign in

Data Analyst

Location:
Baltimore, MD
Posted:
May 17, 2020

Contact this candidate

Resume:

Amanda Eke

Phone: 410-***-**** • Email: adc9n8@r.postjobfree.com

SUMMARY OF EXPERIENCE

Passionate IT Professional with experience in Data Analysis, Database Design and Development with a background in Report development. Highly analytical and detail-oriented, with strong organizational and reporting skills:

Experienced working with SQL against varied RDBMS and Excel, performing various data analysis

Experienced in Data manipulation, Report creation, Importing & Exporting Data in different formats and from various sources

Experienced in Data Modeling, Metadata Update, Analysis, and Reporting

Full Lifecycle Project Management Systems Strategy & Implementation

TECHNICAL COMPETENCIES

Operating Systems: Windows, UNIX

Databases: MS SQL SERVER (2012, 2014), Oracle 10g, 11g, MySQL, Teradata

Query Tools: SQL Server Management Studio, SQL Enterprise Manager, Query Analyzer and SQL Profiler.

BI Tools: Tableau, SSRS, SSIS, MicroStrategy, Power BI

Data Modeling Tools: ERWIN, Visio, ER Assistant, ER Studio

ADDITIONAL SKILLS

Excellent communication and project management skills

Advanced analytic skills and extensive experience with MS Excel

Knowledge of Data Quality and Data Governance best practices

Ability to define QA metrics and develop Q/A processes

Expert in gathering specifications and maintaining the metadata

Proficient in Microsoft Excel for financial modeling and analysis

Skilled in Microsoft Office (Word, Outlook, Excel, PowerPoint)

Multiple complex tasks-handling and excellence in self-audit work

Personal and group work organization coupled with time management skills

Experience and knowledge SDLC methodologies and requirement gathering documentation

PROFESSIONAL EXPERIENCE

Exelon, Baltimore, MD August 10, 2019 - Current

Data Business Analyst – Power BI

Responsibilities:

Providing technical expertise and or engineering support for maintaining performance and reliability of key IT solutions.

Contributing to project technical architecture design and development.

Developing Access tables, loaded data into the table, and manipulated the data to feed into Power BI reports.

Connecting Power BI to SharePoint for reporting data.

Creating drill down filters and provided report slicers to allow users to easily filter, slice and dice the various reports for more business insights.

Developing reports such as AUP Violations, Local Administration Access and Cyber Security Innovative Executive Scorecard.

Hands on experience in Performance Tuning and Query Optimization.

Extensive hands-on experience in several Data Flow transformations including derived- column, script, slowly changing dimension, look up, data conversion, conditional-split techniques, merge, multicast, union all.

Strong knowledge and experience in dimensional Star Schema and snowflakes schema (Power BI data modeling).

Strong knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, AWS, SQL Server

Developing DAX queries and M formulas in Power BI

Adapt in developing, publishing and scheduling Power BI reports as per the business requirements.

UnitedHealth Group, Eden Prairie, MN January 1, 2016– June 10, 2019

Remote BI Solution Architect- Tableau

Responsibilities:

Use analytical skills to design, develop and maintain reports, dashboards and visualizations that provide insight to internal partners and external clients

Interpret reports and analyses to make recommendations for internal and external audiences

Developed ETL packages to move data from disparate source systems such as flat files, excel, oracle database into centralized SQL server database using SSIS

Performed backend testing by executing SQL Queries

Performed installing, configuring, and administering MicroStrategy Intelligence Server, Web Server and Mobile Server.

Used SSRS to develop reports based on user requirements

Provide data analysis support to the fraud investigation team in support of their investigation leads.

Primarily working in reports development with MicroStrategy in addition to Tableau, Qlik or similar reporting / BI / analytics tools

Work with clients and business partners to create use cases and build supporting documentation

Work with technology teams to investigate system performance and data issues

Develop a sense of urgency when key deliverables are jeopardized; facilitate problem solving and meetings to address obstacles

Cigna, Wilmington, DE January 1, 2012 – December 3, 2015

Consulting Data Analyst/Data Architect/Data Modeler

Responsibilities:

Ability to derive data designs and identifies opportunities to re-engineer data structures, and recommends efficiencies as it relates to data storage and retrieval

Developed ETL packages to move data from disparate source systems such as flat files, excel, oracle database into centralized SQL server database using SSIS

Used SSRS to develop reports based on user requirements

Develops reports with accurate, easy to read, useful information

Tests and maintains data integrity

Experience developing data strategies, data models, databases in an Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives and demos.

Able to plan, identify and design data integration strategies, develops intuitive designs, and builds enterprise interactive dashboards with built in guided healthcare data analytics;

Ability to build intuitive interfaces, infographics, and visualizations (Tableau) to tell stories with data;

Develops and maintains SQL queries that support data warehousing joining data from disparate systems, healthcare analytics, and semantic and business logic application;

Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

EDUCATION & CREDENTIALS

Bachelor of Arts in Health Education & Administration

Morgan State University, MD

Bachelor of Science Political Science & Public Policy

Morgan State University, MD

Masters in Heath Informatics Administration

University of Maryland University College, MD

AFFILIATIONS

American Health Information Management Association (AHIMA)

Healthcare Information and Management Systems Society (HIMMS)

Upsilon Phi Delta (UPD), The Honor Society of the Association of University Programs in Healthcare Administration (AUPHA)

CERTIFICATIONS

SCRUM MASTER CERTIFICATION, International Scrum Institute

Certificate of Global Leadership and Management Development, University of the Virgin Islands, VI

LINKS

Tableau Publish: https://public.tableau.com/profile/amanda5363#!/



Contact this candidate