Data Analyst Power Bi

SHAHRAM HASSAS

Irvine, CA ***** 949-***-****

*******.******@*****.***

• DATABASE DESIGN & DEVELOPMENT: EXPERTISE IN DESIGNING, DEVELOPING, VALIDATING, AND IMPLEMENTING DATABASE SYSTEMS.

• BUSINESS & SYSTEM ANALYSIS: COLLABORATE WITH PROJECT MANAGERS, BUSINESS UNITS, AND SENIOR LEADERSHIP TO GATHER REQUIREMENTS, CREATE BUSINESS REQUIREMENT DOCUMENTS (BRDS), AND ALIGN SYSTEM DESIGN WITH STRATEGIC GOALS.

• TECHNICAL SPECIFICATIONS: DEFINE FUNCTIONAL AND NON-FUNCTIONAL REQUIREMENTS, ENSURING SYSTEM PERFORMANCE, SECURITY, AND SCALABILITY.

• DATABASE ARCHITECTURE: DEVELOP AND IMPLEMENT DATABASE STRUCTURES, INCLUDING TABLES, COMPLEX STORED PROCEDURES, VIEWS, USER-DEFINED FUNCTIONS, AND DDL TRIGGERS.

• ETL & DATA INTEGRATION: BUILD ETL PIPELINES USING SNAPLOGIC TO STREAMLINE DATA FLOW BETWEEN UPSTREAM AND DOWNSTREAM SYSTEMS.

• SYSTEM OPTIMIZATION & VALIDATION: ENSURE DATA ACCURACY, INTEGRITY, SECURITY, AND PERFORMANCE THROUGH FUNCTIONAL AND NON-FUNCTIONAL QUALITY CONTROL.

• DEPLOYMENT & REPLICATION: MANAGE DATABASE REPLICATION FROM TEST TO PRODUCTION ENVIRONMENTS.

• CUSTOM BUSINESS APPLICATIONS: DESIGN, DEVELOP, AND DEPLOY MICROSOFT POWER PLATFORM APPLICATIONS.

• EXCEL AUTOMATION & VBA: DEVELOP EXCEL-BASED APPLICATIONS USING VBA, ENABLING DATA ENTRY, UPDATES, AND AUTOMATION FOR OVER 50 ANALYSTS.

• DATA VISUALIZATION & REPORTING: CREATE INTERACTIVE DASHBOARDS IN TABLEAU AND POWER BI, DELIVERING REAL-TIME INSIGHTS FOR DECISION-MAKING. Principal Developer, Software Development (Sys) Data Analyst Western Digital, Irvine, CA Jan 2018 – Feb 2025

• DESIGNED SYSTEM ARCHITECTURE, DATABASE STRUCTURES, AND DATA FLOW DIAGRAMS TO MEET BUSINESS AND TECHNICAL REQUIREMENTS.

• DEVELOPED AND OPTIMIZED SQL DATABASES (SQL SERVER, ORACLE, REDSHIFT) FOR TAM, SAM, SOM, PORTFOLIO PLANNING, AND FINANCE.

• CREATED AND FINE-TUNED STORED PROCEDURES, USER-DEFINED FUNCTIONS, TRIGGERS, VIEWS, AND INDEXES TO ENHANCE PERFORMANCE AND DATA INTEGRITY.

• BUILT ETL PIPELINES IN SNAPLOGIC AND SSIS FOR SEAMLESS DATA EXTRACTION, TRANSFORMATION, AND LOADING (ETL).

• DEVELOPED INTERACTIVE DASHBOARDS AND REPORTS USING TABLEAU, POWER BI, AND EXCEL VBA, SUPPORTING ENTERPRISE-WIDE DATA ANALYSIS.

• AUTOMATED EXCEL REPORTING WITH SQL AND VBA, CREATING 300+ PARAMETERIZED REPORTS AND ENABLING REAL-TIME DATA ACCESS FOR 50+ ANALYSTS.

• DEVELOPED POWER APPS FOR DATA MANIPULATION AT VARIOUS GRANULARITY LEVELS.

• MANAGED DEPLOYMENT PROCESSES, UTILIZING GITHUB FOR VERSION CONTROL AND APPROVALS.

• PROVIDED USER ACCESS ADMINISTRATION AND SYSTEM SECURITY MANAGEMENT.

• ANALYZED BUSINESS OPERATIONS TO OPTIMIZE WORKFLOWS, IMPROVE EFFICIENCY, AND INCREASE PRODUCTIVITY.

SUMMARY OF QUALIFICATIONS

AREAS OF EXPERTISE

Microsoft SQL

Oracle

Redshift

Snaplogic

Tableau

SPSS

Power BI

Power Apps

VBA

ASP.net

Jira

Github

OneDrive, box

Microsoft Office

Applications

Allscripts

CRM Blackbaud

Salesforce

PROFESSIONAL HISTORY

Shahram Hassas Page 1 of 2

SHAHRAM HASSAS

Irvine, CA 92606 949-***-****

*******.******@*****.***

Data and Strategy Analyst

City of Hope, Duarte, CA May 2014 – Jan 2018

• Analyzed business requirements and collaborated with leadership to develop data-driven solutions.

• Created SQL queries, stored procedures, user-defined functions, and indexes for reporting and analysis.

• Developed ETL pipelines using SSIS to extract, transform, and load data from multiple sources into SQL Server.

• Optimized SQL queries using performance monitoring and troubleshooting techniques.

• Designed and built Tableau dashboards for clinical, marketing, and fundraising data, enabling real-time decision-making.

• Utilized Google Analytics and SurveyMonkey for data mining and target analytics.

• Applied statistical analysis to philanthropic and marketing data, providing insights on donor behavior and economic trends.

• Presented analytical findings and strategic recommendations to executives and stakeholders.

• Led training sessions on CRM, Tableau, and data literacy to enhance organizational database usage. Data Analyst & Project Manager

Celestica, Oxnard, CA Aug 2004 – Dec 2008

• DESIGNED, DEVELOPED, AND DEPLOYED MS ACCESS DATABASES FOR SHIPPING, RECEIVING, SUPPLY, AND INVENTORY MANAGEMENT.

• OPTIMIZED MYSQL SYSTEM PERFORMANCE AND ENSURED DATA INTEGRITY THROUGH VALIDATION AND HYGIENE PROCESSES.

• CREATED INTERACTIVE REPORTS AND DASHBOARDS FOR PRODUCTION, SHIPPING, INVENTORY, AND AUDIT TRACKING.

• PROVIDED DATA-DRIVEN RECOMMENDATIONS TO EXECUTIVES, IMPROVING BUSINESS OPERATIONS AND DATABASE CAPACITY.

• MANAGED USER ACCOUNTS, ROLES, AND NETWORK SECURITY USING WINDOWS SERVER 2000.

• INSTALLED, CONFIGURED, AND MAINTAINED HARDWARE AND PERIPHERAL EQUIPMENT (REMOTE SUPPORT VIA LOGMEIN).

• CONDUCTED CLIENT ASSESSMENTS AND SALES MEETINGS, ENSURING CUSTOMER SATISFACTION AND KEY METRIC ACHIEVEMENTS.

• DEVELOPED TRAINING MANUALS AND INTERACTIVE VIDEO TUTORIALS WITH VOICEOVERS AND EMBEDDED ASSESSMENTS.

Bachelor of Science in Applied Mathematics Statistics California State University, Northridge (CSUN) May 2013

• ASA (American Statistical Association) Member.

• NSF (National Science Foundation) Member: conducted research and translated into analysis of the mathematical models.

• Completed software Architectural and System Design (Udemy course)

• Completed Data for Data Analyst by Tableau

• Certified Querying Microsoft SQL Server by Learning Tree International

• Completed SDK by Blackbaud

• Certified HL7 Corepoint Health Integration

EDUCATION

Professional Affiliation

Trainings

Shahram Hassas Page 2 of 2

Contact this candidate