Data Analyst

Valentina Georgieva

Phone: 408-***-**** **************@*****.***

Summary: Fast learner with quick grasp of complex data models. Thorough and precise worker with:

Over 10 years of experience in reporting design and data analysis

Working knowledge of BI reporting tools and data mining - Hyperion/Brio, Business Objects, Tableau, SPSS Modeler, QMF, Cognos, Qlikview, OBIEE

Proficient in Microsoft Windows and Office (Windows XP, MS Excel, MS Word, Power Query, Power Pivot, Power BI, MS Visio, MS PowerPoint, MS Project, Outlook);

Databases: Oracle, MS Access 2013, Siebel, dBase

Programming languages - SQL, VBA, JavaScript, Pascal

Proficiency with specialized software: Salesforce.com, Oracle CRM (Installed base, Service Request and Quality Modules), FileMaker Pro, Agile, Weibull (Reliability and Life data analyses), Minitab, R; Cisco experience with CSCC, SNTC Portal, 360IB View, KTN;

Experience in accounting

PROFESSIONAL EXPERIENCE

IBM, Worldwide Software Group (WSG Sales Channels), San Jose, CA since April 2014

Data Analyst/Business analyst

Summary: Global Reporting, metrics creation, dashboards visualization, trending of financial data and sales opportunities; auditing incentive payments, modeling, impact analysis.

Analyzing financial results, creating metrics, KPI for measuring performance in support of business partners’ initiatives for three of the incentive programs. Presenting information in ready-to-use format – dashboards;

Providing impact analysis using financial data, during the restructuring of the incentive programs; modeling using SPSS

Providing Support to incentive programs community- by maintaining backlog reports and creating ad hock reports for them

Auditing payments of two of the incentive programs before sending to operations. Project lead and executor for conversion of payment reports from Hyperion to SPSS. Resolving issues with unpaid transactions and inquiries from BPs or internal teams;

Responsible for providing eligible payment transactions for one of the incentive programs. Working on Automation during the search process that speeds up the verification. Data mining for researching potential sales opportunities by tracking revenue and relationships in different applications;

Preparing weekly and quarterly metrics summary for distribution among sales regions.

Direct update in SAP tables for incentive eligibilities by regions

Juniper Networks, Product Marketing, Sunnyvale, CA July 2013 – February 2014

Data Analyst

Summary: Global Reporting, price modeling, automation, visualization, trends on sales and install base information.

Supported marketing executives and manufacturing units with analysis and reports on price changes, financial trend analysis and business impact by products and regions;

Created price models to reflect the changes of different price components and forecast the outcome based on historical data for the product;

Offered visual presentation of discount behavior and proposed metrics to monitor it by creating dashboards in Tableau using Siebel Quote information as a source;

Cisco Systems, Grow Smart Services Organization, San Jose, CA May 2012 – July 2013

Data/Business Analyst

Summary: Global Reporting, automation, visualization, trends on financial data and sales opportunities.

Created and automated global financial reports using BO for a specific service (SNTC-Smart Net Total Care) to reduce manual sales order collection and increase accuracy to 95%;

Supported global tracking of SNTC pipeline business by creating reports and dashboards in Salesforce.com;

Created customer-oriented dashboards using contract data from install base application (360IB View) to support incremental growth initiative for conversion from SNT to SNTC customers;

Collaborated with business development manager teams from different regions to focus on process improvement of core projects through automation and process enhancement

Coherent, Reliability Department, Santa Clara, CA October 2007 – March 2012

Sr. Data Analyst

Summary: Design of reports, custom dashboards, and metrics; data extraction and analysis using multiple sources; research and cleanup of data discrepancies; analysis of OBQ and in-warranty behavior of products; Pareto charts and analysis using Service data; Weibull statistics, User Acceptance Test (UAT) participation

Automated monthly reporting, data visualization by creating customer-specific dashboards of open Service cases and installations using Hyperion/Brio;

Gathered and analyzed business requirements and created reports for internal customers (Service, Quality and Manufacturing departments), worked on special projects and ad-hoc reports as needed;

Performed Reporting and Analysis on failures and Corrective Actions- using extraction from Oracle CRM, FileMaker Pro and Vantive. Analyzed results to categorize failures and define Service strategies

Visualization and data mining in connection to warranty and OBQ data- reducing business units prep time for audits by 50%

Forecasting failure rate on a different laser models using Weibull (Reliability and Life data analyses;

Supported the Quality department and their work with suppliers by identifying the metric for supplier performance, collecting the data and presenting reports; Running report from FileMaker Pro for corrective actions;

Developed a MS Access database application for tracking changes in the structure of the laser configurations during their life cycle;

Played an active role in User Acceptance Tests during implementation of Oracle CRM, with responsibility for tracking discrepancies in the data, and assessing integrity and quality of provided reports;

TiVo Inc, Service Operation Department, Alviso, CA October 2006 – October 2007

Data Analyst

Summary: Design of reports, custom oriented dashboards, data manipulation, extraction and automation, UAT participation, financial trend analysis, data flow diagrams

Developed and updated reports using Hyperion for internal customers;

Consolidated data from various sources and performed data analysis;

Processed UAT, audited and analyzed data from Data Warehouse (DW) tables for discrepancies to assure data integrity; worked close with IT to create new tables in DW necessary for reporting;

Worked on marketing surveys: created queries based on different criteria and prepared data pulls;

Supported the marketing team by creating dashboards with Sales and Retention data;

Automated monthly financial reports using Hyperion reporting tools;

Department of Commerce, Sofia, Bulgaria

Senior Data Analyst 1998 -2003

Analysis on domestic production and consumption of different commodities and relations of their import/export to the current trade agreements; Proposed measures (additional custom duty, import taxes) to protect local production in alignment with Safeguard and Antidumping legislation;

Reporting/Analysis of import/export licenses issued for sensitive goods (textile, metals);

EDUCATION:

MS in Mathematics, Sofia University "St. Kliment Ohridski", Sofia, Bulgaria

Classes and certificates:

AA Degree in Accounting with emphasis on practice, De Anza College, Cupertino, CA;

MS Access Certificate, UC Berkeley Extension

Languages: English, Bulgarian, Russian

Contact this candidate