Data Analyst Resume

SUMMARY

5+ years of Data Analyst experience.
Experience using MS Excel, SQL sand/or other applications to perform various types of analysis.
Installation, testing, configuration, maintenance, and troubleshooting of all SQL Server components.
Experienced using 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.
Experienced using Power BI and Tableau to import and analyze data from various sources such as SQL Server.
Experienced creating various filters and parameters for reports using PowerBI and Tableau desktop.
Experienced in data migration tasks using MYSQL, T - SQL, and Data transformation, Data conversion and Data Loading

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

Extract data with the use of complex SQL queries and uncovering meaningful insights from the underlying data for better management decisions.
Help create dashboards with the use of Power BI and present to the stakeholders as required.
Provide data analysis and data visualization support to derive actionable insights using BI tools like Power BI and Tableau.
Elicit and produce data requirements based on research and client interaction
Create and maintain metadata for targeted data stores across platforms
Develop and document the data domain models with appropriate version control and configuration management controls
Engage proactively with customers to define data quality and develop data quality metrics for targeted data sets
Identify and perform detailed analysis of all data sources for each application and subject area.
Play a vital role in the evaluation of data solutions.
Cleanse, validate, interpret, and analyze data using various analytical tools.
Append and reconcile various data using Microsoft Access
Cleanse, validate, interpret, and analyze data using various analytical tools.
Use Power BI and Excel for extracted data and data analysis, generating reports, graphics and statistical analysis.

Data Analyst

Confidential

Responsibilities:

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.
Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using MYSQL, and T-SQL.
Improve query performance, and data Profiling for accurate and better reporting and analysis.
Built data visualization dashboards and reports based on the business need using BI tools like Power BI, and Tableau

Data Analyst

Confidential

Responsibilities:

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