We provide IT Staff Augmentation Services!

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

  • MYSQL
  • T-SQL
  • Microsoft Access
  • Microsoft Excel
  • Tableau
  • Power-BI
  • MicroStrategy
  • JIRA

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

Hire Now