Data Analyst Sql Server
Resume:
MAJAY ZACKPAH ********@*****.*** +1-302-***-****
LinkedIn URL: https://www.linkedin.com/in/majay-zackpah-433845186/
PROFILE
Experienced as a Data Analyst in various industries with emphasis in IT, Financial, Insurance and Healthcare Management. Extensive Experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources. Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work. Able to perform multiple duties in business analysis, project or program management, and functional leadership. Extensive experience with design and development of Tableau visualization solutions. Excellent analytical, problem solving, and time management skills.
EDUCATION
A.S. Healthcare Management, Cumberland County Community College August 2006 – May 2008
TECHNICAL EXPERTISE
Project: https://public.tableau.com/profile/majay.zackpah#!/
Microsoft Suite (Excel, Access, PowerPoint, Word), MS Outlook.
Data and Business Analysis using SQL Server 2008/2012, Tableau, BI, SSIS, SSRS.
EXPERIENCE
CONTATA SOLUTIONS(Healthcare), (remote for three months) January,2021 to Present
Data Analyst
Design and develop various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Utilize advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
Test, and maintain Tableau functional reports based on user requirements.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Gather requirements by interviewing users from multiple internal departments.
Publish Power BI Reports in the required originations and made Power BI Dashboards Build Data Dictionary in SQL Server from new Data Warehouse migrated from HPCC to SQL Server.
Work with Data Architect on Star and Snowflake Schemas utilized.
Perform Data Analysis on both source data and target data after transfer to Data Warehouse.
Identify Data discrepancies and worked with database programmers to find better solutions.
Make reports using Tableau Desktop Developer.
AETNA HEALTH INSURANCE March 2018 to December 2020 Data Analyst
•Utilized SQL to develop stored procedures, views to create result sets to meet varying reporting requirements.
•Used Visual Studio report builder to design report of varying complexity and maintain system design documents.
•Data analysis, reporting using Tableau and SSRS.
•Built and supported the transformation of various data inputs into the SQL server companies Data Warehouse.
•Analyzed and designed solutions create technical integration and consult with QA personnel on their tasks related to the imports and extracts.
•Designed and developed Insurance, Claims and Financial Reports Using SSRS.
CITIZENS BANK October 2017 to February 2018
Data/Business Analyst
•Created ETL solution to read Product and Order data from files on shared network into SQL Server database. Solution validated incoming data and performed notifications when jobs were complete. Loaded order data into SQL Server to generate SSRS reports, which were set up for automatic delivery based on standard report subscriptions.
•Used various sources to pull data into Power BI such as SQL Server Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
•Wrote calculated columns, measures queries in Power BI desktop for data analysis techniques.
•Weekly presentation to the business users about the Power BI reports, and their changes as required.
•Implemented functionalities of application according to business requirements through stored procedures, functions, and triggers.
•Gathered and managed Data in SQL server 2012, MS Access.
•Made business recommendations based on data collected to improve business efficiency.
•Demonstrated team cohesiveness and organizational commitment.
Contact this candidate