Senior Data Analyst Resume

SUMMARY

7+ years experience working with data analytics/business intelligence and data visualization tools.
5+ years demonstrated experience integrating and performing ETL processes
Advanced MS Excel skills that include creating pivot tables, macros, utilizing v/h lookups and/or VBA
Familiarity with writing SQL (and/or SAS) queries for analyzing data and establishing business rules and requirements
Understanding of SQL Server relational database and its tools SSRS, SSIS, SSAS
Proven experience with MS Power BI, DAX formulas
In - depth understanding of RDBMS and Datawarehouse theories principles and practices
Utilized BI tools such as Power BI Desktop, Tableau for data visualization and creating dashboards
Experience with ERP applications such as Oracle NetSuite
Proven expertise in using Base SAS for data extracts, as well as to transform data
Installation, testing, configuration, maintenance, and troubleshooting of all SAS components
Experience in healthcare related software information to ensure data security
Demonstrated ability to thrive in a fast-paced agile environment

TECHNICAL SKILLS

Advanced Microsoft Excel
Power BI
SQL/SAS
Data QA
SSIS, SSRS, SSAS
MS SQL Server
Oracle
Microsoft Access

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

Analyzing trends and patterns to answer key questions from customers, strategic partners, and internal stakeholders to guide decision making processes.
Leverage strong Power BI/Excel expertise using the Power Query, Power Pivot, Pivot Tables to perform data analysis and transformation
Automated the existing Sales & Marketing Reports using SQL Stored procedures which accounted for the reduced resource requirement by 28%.
Performing Gap and Root Cause Analysis
Interpreting data presented in models, charts and tables and transforming it into data visualizations to deliver value to the business decision making processes
Using SQL to extract data from the SQL Server database as well as the data warehouses for reporting and facilitating sharing between multiple data systems.

Confidential

Data Integration Analyst

Responsibilities:

Maintaining data integrity and also performing data quality analysis by applying the 7 dimensions of data quality
Analyzing data and identifying variances and gaps on various data stores and systems.
Working with cross-functional teams to understand their challenges, gather and create requirements for improvement.
Performing User Acceptance Testing (UAT) to ensure system designed as per client requirements
Assisting in monitoring the performance of conversion objects during stress testing and helping the team in improving the performance
Write and run basic/intermediate SQL queries, using JOINS for common database tasks.
Assisting to create and/or modify stored procedures, functions and other SQL database objects.
Migrating data from existing Excel databases into SQL Server using SSIS. I was heavily involved in analyzing data for quality check of submitted load files
Built custom tools and reports using MS Excel and MS Access to assist other departments in analyzing data
Preparing Ad-hoc reports (SSRS, Power BI) to help business development teams discover new revenue streams and also answer other specific questions from higher management
Translating business requirements into ETL designs and mapping specifications
Analyzing complex internal/external data and identify anomalies, outliers and trends
Working with team to manage a full cycle ERP or software implementation from an organizational, functional and technical change management standpoint as well as communicate any difficulties to the development team.
Working with the application development team to implement data strategies, build data flows and develop conceptual data models
Coordinating activities with data source application owners to ensure integration, data integrity and data quality using the Scrum Process Agile Methodology
Working independently, preparing project status reports and formal presentations as required using PowerPoint, Excel and Tableau.
Identifying sources of data and data fields for reports, mapping, and computations required to create metrics for reports using Tableau.
Developing, implementing, and maintaining change control and testing processes for modifications to data models.
Ensuring compliance with Federal and State required data policies/best practices.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship