Data Customer Service
Resume:
Katarina Surjadi
San Jose, CA **129
********@*****.***
SUMMARY
Data Analyst/Reporting Analyst with data analysis, reporting, business analysis, data warehousing, business intelligence, technical and end-user support experience. Considerable experience in a wide range of functions that includes software system implementation, business process improvement, technical training, and user support. Strengths include problem solving and analytical skills.
SKILLS
Team player, self-starter, project management/coordination, customer service.
Reporting Tools/Technologies – Excel, Access, Excel Macro, Tableau, Power Point, Business Objects, SalesForce, Hyperion Intelligence Brio, Hyperion Essbase.
Database Systems/ Programming - SQL Server, Oracle, SQL
Web/Programming technologies – Visual Basic for Application (VBA), JavaScript, HTML, and Visual Basic.
PROFESSIONAL EXPERIENCE
Sr. Data Analyst – Pricing Strategy
Cisco, San Jose CA Mar 2015-October 2016
Support Finance Dept. with their reporting and data analysis need. Create report for Bookings, Gross Margin, Discount analysis, etc.
Query building, data extraction from Enterprise Data Warehouse, data analysis/ trends/metrics, data validation, root cause analysis.
Extensive manipulation of large volumes of data in MS Access, SQL Server, SQL.
Create reports/dashboards, report packages, ad hoc reports using Excel, Pivot Tables, Visual Basic for Application (VBA) to navigate and display result using dropdown menu, chart, etc. Create reports on Tableau.
Report distribution and report automation, streamline and automate monthly, quarterly reports
Sr. Business Analyst – Services Sales Strategy & Planning
Cisco, San Jose CA Dec 2011-Mar 2015
GAP Accounts Goaling/Analysis. Pulling data from Data Warehouse to get bookings number, upload to Access DB. Applied the required mappings, identified the records that are added/remove for FY15 goaling, export them to excel and upload them to the goaling workbook.
Supported Get Refreshed Analytics, including creating reports for partners, PAMs (Partner Account Mangers), create ad-hoc report/high touch report, providing access to the reports.
Sr. Data Analyst – Strategic Pricing and Analytics
Cisco, San Jose CA May 2007 – Dec 2011
Design and implement monthly dashboards for Strategic and Analytics project using SQL Server, Access, Excel VBA, Pivot Tables
Report streamlines and automates weekly, monthly dashboards.
Business Analyst/Data Analyst
Mervyn’s, Hayward CA October 2005 – February 2007
Manage implementation of Retail Idea Data Warehouse Reporting System. Work closely with the Subject Matter Expert s to analyze, gather business processes and requirements. Work closely with the vendor to make sure the implementation is on the right track.
Work on data conversion mapping, validate and verify the conversion data are correct, analyze data discrepancies and provide solutions. Support end users with data and report problems, analyze the problems, identify the root cause, and document the problems and the solutions.
Information Analyst
Pacific Gas and Electric, San Francisco, CA January 2002 – April 2005
Business Analyst/Report Developer on 3 Terabyte Data Warehouse, supporting Customer Information, and Billing for over 500 users.
Worked closely with Subject Matter Experts to fully understand existing and changing business processes, initiatives and data reporting needs. Provided expert guidance on best approach based on knowledge on Report System capabilities.
Develop management and adhoc reports for various departments, including gathering requirements, documenting requirements, analyzing and extracting data from database, and creating reports. Tools: Business Objetcs, Oracle, SQL.
EDUCATION
Northeastern University, MS in Information Systems, Boston, MA (GPA 3.79/4.0)
Awarded Graduate Assistantship
Maranatha Christian University, BS in Electrical Engineering, Bandung, Indonesia.
Contact this candidate