We provide IT Staff Augmentation Services!

Data Analyst Resume

3.00/5 (Submit Your Rating)

OBJECTIVE

Dedicated IT professional with expertise in data analysis and reporting, seeking a Data Analyst position where my analytical and methodical skills will be of great value in achieving the company’s missions and goals.

SUMMARY OF QUALIFICATIONS

  • Extensive knowledge in modeling organizational data and business rules; logical and physical designs of relational databases, writing stored procedures, creating views and indexes using MS SQL Server.
  • Proven background in analyzing data through MS Excel and creating reports using pivot tables, charts and macros.
  • Advanced extensible reporting skills in SQL Server Reporting Services, ETL development using SQL Server Integration Services and dimensional data modeling and cube development through SQL Server Analysis Services.
  • Performed advanced data mining and data analysis tasks like data preparation, integration and predictive modeling with segmentation, clustering etc. using SAS Enterprise Miner.
  • Well-developed communication and interpersonal skills and ability to quickly master new software/hardware.
  • Self-motivated, customer-focused, teamwork oriented and strategically focused, recent college graduate with strong analytical, pattern detection and problem solving abilities.

EDUCATION

Masters in Management Information Systems
Bachelors in Computer Engineering

TECHNICAL COMPETENCIES

Databases : SQL Server 2005/2008, MS Access, Oracle 11g, RDBMS, PL/SQL, MySQL
Skills : SSAS, SSIS, SSRS, Crystal reports, Business Intelligence, MDX
Tools : MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Project, SAS, VBA
Operating System : Microsoft Windows 2000/2003/2007/XP/Vista, 7, Linux, Ubuntu

ACADEMIC PROJECTS

  • Online Airline Reservation (SQL Server): Formed an online airline reservation system with the necessary customer services functions with advanced SQL queries, created reports, wrote stored procedures using Microsoft SQL server 2005.
  • NHL 2009 Analysis (Business Intelligence): Analyzed all the NHL players and generated reports using excel and pivot tables, macros, V-Look-ups to find out the most undervalued player through Microsoft Excel.
  • Hospitality Services (SQL Server Reporting Services): Created reports based on the available customer data to find out why there is a dip in sales for Chick-fil-a at Texas Tech using SQL server 2005.
  • Dashboards (MS Excel 2010): Created dashboards for the purpose of company analysis using slicers, pivot tables, sparklines and graphs and presented data using Microsoft PowerPoint.
  • Mammography (Enterprise Miner, SAS – Data Warehousing and Text Mining): Performed analysis on a dataset related to mammography to find out the factors responsible using different data mining models.
  • K-12 Education System (System Analysis and Design): Analyzed the business needs, performed data gathering and designed a subsystem using domain models and various component designs.

WORK EXPERIENCE

Confidential,Aug 2009- April 2011

  • Manage and oversee a team of approximately 20 culturally diverse students and other employees.
  • Assist in the interviewing, hiring, and training of the work force and responsible for enforcing safety rules.

We'd love your feedback!