Data Analyst Resume
4.00/5 (Submit Your Rating)
Santa Clara, CA
SUMMARY:
- Data manipulation reporting: Understand database systems, data models and components, BI concepts, and its application, data management, reporting and dashboards. Experienced with reporting tools like Excel, Tableau, Crystal Reports, and OBIEE.
- Software experience: Five years of database application development experience as system engineer, application developer; understand SDLC. Designed database to meet business requirements. Experienced with programming languages such as SQL, R, C+ and Java.
- Strong interpersonal skills: Warm, positive personality with the ability to communicate effectively both verbally and in written form, to address issues and to provide solutions.
- Superior work ethic: Committed to achieve excellence, efficiency and productivity. Take initiative. Motivated to work in changing environment. Open - minded aptitude to quickly grasp new concepts and tools that help improve the quality of work or solve problems.
PROFESSIONAL EXPERIENCE:
Confidential, Santa Clara, CA
Data Analyst
- Created analytical supply chain sales, marketing and financial reports using advanced Excel Pivot table and Tableau which slices and summarized data from different aspects.
- Created and presented insightful dashboard with market trends to the sales and financial stakeholders for implementing strategic marketing plan and optimizing operation.
- Facilitated communication among multiple parties, designed and developed statistics business reports and Ad-Hoc inquiries according to user requirements using SQL, R, and Crystal Reports.
- Performed data quality management; clean, reconcile, and make consistent codes, rules and guidelines to business procedure to ensure data accuracy. Implemented automatic process.
- Gathered requirement from operation team. Collaborated with IT team to Initiate Assemble-To-Order module. Helped develop, communicate and implement end-to-end business process.
- Provided Accounts Receivable Turnover KPIs to and helped initiated action items, which not only increased current AR ratio from 65% to 98%, also brought in additional 2% financial fee income.
- Developed Expense Analysis on contracts, spotted outdated, low activity contracts, resulted in saving 24% contract expense.
Database Application Developer
- Implemented web-based database application project management system in Oracle using HTML, Java, SQL, C+, UNIX shell scripts and CASE tool . Required detailed knowledge of relational database, application development, infrastructure, and programming languages.
- Designed and implemented Human Resources system and ticketing system using Informix SQL, 4GL. Required detailed knowledge of relational database and application development.
- Conducted internal SQL training for software development team and supported team members with effective problem solving in application development.
- Took initiative to automate 90% manual work using UNIX Shell scripts with accuracy and efficiency. Saved the cost on three months extended manpower and advanced in schedule.