orit pasternak

• Analyze large and complex datasets using SQL to identify trends, anomalies, and business insights.
• Define and monitor business KPIs, including period-over-period comparisons (MoM / YoY) to track performance trends.
• Analyze data across a multi-level hierarchy (entity → accounts → subscriptions) and perform analysis at different aggregation levels.
• Build and maintain BI dashboards and report

* Led data analysis for a large-scale incentive program for a major client in the gambling industry
* Analyzed field agent sales performance segmented by geography, store type, and profitability
* Developed KPIs and scoring models using SQL and Excel, incorporating target achievement,
revenue growth, and trend analysis
* Conducted ongoing performance tracking and delivered actionable insights

Tasks as Product Manager:
• Application characterization, analysis, and process characterization in the current state
• Defining requirements for the application
Identifying critical capabilities for MVP
• Working with UX/UI designer and building wireframes
• Product planning with an external development company
• Data analysis
• Budget management, preparing development budget, business model ROI

 Developed strategic plans, analyzed sales pipelines, identified growth metrics, and presented to C-level stakeholders.
 Excel expert: analyzed usage data using Pivot tables, V-lookup, dynamic charts for categorization, and aggregation.
 Designed Zoho CRM dashboards to visualize and interpret sales data, optimize pricing strategies, and monitor content delivery.

 Conducted cost analysis using advanced Excel, providing accurate pricing, and leveraging research
and development efforts.
 Translated business needs to data models, identifying, trends for product roadmap

 Led team, analyzed installation plans, and applied data-analysis insights to enhance market strategies

 Managed software projects, collaborating across technical teams, and presented progress reports to c-level.
System implementor 2004-2006
 Skilled system implementor adept at deploying and documenting systems for streamlined data management.

Enrolling in the Data Analyst course at Analiza College was an absolute game-changer for me. The curriculum covered everything from mastering MS Excel, SQL, and Tableau to diving deep into statistics and visualization techniques. What truly stood out was the hands-on approach—working with real datasets honed my skills in gathering actionable insights. The practical experience combined with expert

Oct 2020 · Expired Oct 2022

Oct 2020 · Expired Oct 2022

System analysis process involves collecting and interpreting facts, identifying problems, and decomposition of a system into its components. System analysis is conducted for the purpose of studying a system or its parts in order to identify its objectives.
Becoming a professional System analyst, requires deep understanding of business and operational needs, and transforming these into system funct

Linear Algebra, statistics, math modules Matlab,