Data Analyst Resume
Sunnyvale, CA
SUMMARY:
Accomplished and results - oriented individual with many years of experience in consistently meeting specified work deadlines by utilizing a great work ethic, building business relationships, applying sense of urgency, and being detail-oriented. A quick learner who can absorb new ideas and communicate clearly and effectively.
CORE COMPETENCIES:
- Strong Communication Skills
- Applied Mathematic Skills
- Trilingual (Hindi/Punjabi/English)
- Superior Management/Leadership Skills
- Experienced in Financial Modeling
- Proficient in Statistical Modeling
- Complex Problem Solver
- Financial/Business Reporting Expert
- Superior Research Skills
- Sales and Marketing Abilities
TECHNICAL SKILLS:
Operating Systems: UNIX, Linux, MS-DOS, Windows
Tools: /Utilities/Methodologies: MS Visio 2007, MS Project, SQL Developer 3.2, CCM(Trouble Ticket Management), BMC Remedy IT Service Management 7.0, Waterfall, Six Sigma, Business Process and Data modeling, Oracle OBIEE, Business Objects, Tableau, HTML
Testing Tools: Quality center, Clear Quest
Languages: SQL,PL/SQL, C++
Databases: Oracle 9i, MS Access
Software Packages: MS Office 2003/11, MS Project 2000, SAS, SPSS, SAP, NOTEPAD++
PROFESSIONAL EXPERIENCE:
Confidential, Sunnyvale, CA
Data Analyst
Responsibilities:
- Perform Back-End testing with Data Analysis to validate database contents by writing and executing SQL Queries.
- Experience in Data Analysis, Business Modeling, Requirement Gathering and Analysis.
- Perform and help in daily ETL (Extract, Transfer, Load) data duties.
- Collect product quality data, audit, create reports and monitor all data for accuracy.
- Experience in Data query language (DQL), Data manipulation language (DML), Data Control language (DCL), and Data Definition language (DDL) for SQL and SAS.
- Study raw data, draw conclusions and develop recommendations.
- Understanding business processes and functionality and converting these into functional requirements and system requirement specifications (SRS) and preparing Business Requirements Documents (BRD).
- Develop a theoretical solution aimed at defect preventions and product improvement. Research and test accordingly and collect data to prove or contradict the theory.
- Analyze and report the data using advanced Microsoft Excel skills. Frequently used Vlookup, Hlookup, Linear Single and Multiple Regressions, Pivot Tables, Macros and other functions to map data to informative reports.
- Performed Statistical analysis to determine if the desired changes are profitable to the company.
Confidential, Rocklin, CA
Data Analyst/Administrative Assistant
Responsibilities:
- Analyzed data in company’s database using SQL queries and came to data-based conclusions regarding firm’s profitability.
- Create documentations and PPT presentations for end users.
- Processed mail, performed inventory, researched and ordered materials for future projects, and updated company’s PO system. Analyzed raw data, created reports, and developed strategic recommendations.
- Entered, deleted, and updated the material costs, inventory, and other product related changes in the company’s Centralize Data system using SAP.
- Conducted Requirement analysis using Data analysis & Gap analysis.
- Understand and articulate business requirements and perform detailed analysis to map them to technical and functional requirements.
- Maintain integrity of financial systems through appropriate structuring of entities and values.
