Data Analyst Resume
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.
