CONFIDENTIAL RESUME

KARIM ELGHOBASHY

EDUCATION:

California State University, Los Angeles, Los Angeles, CA

MS, Computer Science, In Process, Expected 2019

University of California, Riverside, Riverside, CA

BA, History, 2009

COMPUTER SKILLS:

SQL, Access, Excel (Pivot Tables), Word, PowerPoint, Outlook, SAP Business Objects, SAS, JAVA Script, SPSS, Visual Basic, MATLAB, Epic(UCLA Health), R-Statistical Software, Data Management Methods, Mathematical/Statistical Modeling, Quality Measurement Methods, Business/Finance Principles, Program Evaluation Methods, Health Insurance Business Principles, Medical Data, Strategic Insights Development

Media Analytics, Sales Data Analysis, Salesforce Administrator, Lotus Notes

EXPERIENCE:

Independent Consulting

8/13 – 12/17

Data Validation/Financial Operations Analyst Snap Inc., Santa Monica, CA (11/17 – 12/17)

Tracked monetization efforts using Data from Nielsen, Salesforce, and Internal systems in order to create Match criteria in SQL script that would accurately combine Data from different sources.

Developed automation practices in Ad-Operations team with Sales Finance, Salesforce Development group, and Advertising Managers to ensure Self-Service and Sales Business lines are able to accurately share data.

Created new Advertising Metrics for different Product lines and conducting analysis (Using SQL) on effectiveness of various advertising campaigns.

Technologies: Nielsen, SQL, Google Docs and Analytics, Salesforce.

HRIS Analyst, Activision, Santa Monica, CA (10/16)

Automating HR Reports in Oracle Fusion/Taleo, transforming Data into Excel and Access, Presenting Analysis in PowerPoint. Developing

Creating Insights into HR Data for C -Level Executives using Excel and Vizier Workforce Analytics.

Developing Automated Data Validation Processes for Government Compliance Reports in Excel.

Technologies: Oracle Fusion/Taleo, Vizier Workforce Analytics, Excel, Talent and Compensation

Business Analyst-3, Southern California Edison, Baldwin Hill, CA (7/16 – 916)

SAS Conversion, Using SAS and R to conduct extensive analysis on Call Center Performance.

Creating Quantitative and Qualitative reports. Pulling Data in SAS and summarizing in Excel or Access. R for Analysis.

Build Data warehouses in Access Project Managing Data Repository tasks.

Environment: SAS EG, PC SAS, SAS DI, SAS Visual Analytics, Excel, R, Crystal Reports.

Project Manager, IT Development, Condusiv Technologies, Los Angeles, CA (12/15 – 3/16)

Forensically Investigating IT Infrastructure, Processes (Hardware and Software ) after sudden departure of VP of IT and layoffs. Developed comprehensive documentation of all IT Processes.

Created Company-Wide Credentialing system for a multitude of Applications/Programs.

Created and managed Innovative IT Ticketing program providing root cause analysis.

Created documentation and set-up seminars to train on IT and Data Issues with solutions. Advertised as resume boosters or as new ways to become valuable to organization. Fedralized IT and Data Programs.

Created over 150 new metrics (Sales/Marketing) company-wide working with various stakeholders.

Developed product visibility and customer acquisition metrics.

Managed back-end Web-Site sales and Mainframe.

Developed different Testing environments to test products.

Leveraging integration server with 15 applications that acted as a “Virtual Product Manager”.

Salesforce, Intacct, Avalara, Akamai, and Office Suite Administrator.

Developed back-end SQL Data warehouse monitoring integration and sales.

Managed vendors and IT budget priorities, budgeting analytics.

Created IT infrastructure to test products.

Managed Google Analytics Data and creating a framework for strategic insights.

Environment: SQL, Crystal Reports, C#, .NET, Cloud-Based Applications, Google Analytics, Salesforce, Intacct, Avalara.

Project Manager, Human Resources, Amgen, Thousand Oaks, CA (9/15 – 10/15)

Developed and revised reports in SAS to better integrate with Workday within the Global HR Staffing Network.

Developed analytical tools in SAS with a focus on talent and compensation.

Created metrics by reviewing internally promoted employees through performance reviews to establish a smoother transition into role.

Created predictive analytics framework for Human Resources needs.

Environment: Taleo, Workday,Talent and Compensation, Global HR Benefits, SAS, SAP.

Database Analyst, VS Associates, Canoga Park, CA (4/15 – 6/15)

Developed applications in Visual Basic Studio, Python, Java Development, and Ruby on Rails to create mobile and cloud based applications.

Developed Access database for investment Services Company.

Mapped data between Excel and Access. Data Scrubbing.

Wrote Macros and Formulas for both Excel and Access to deal with complex financial calculations.

Created dashboard and developing Marketing Analytics Reports for President.

Created and improved infrastructure for process improvement. Established workflow via Visio.

Wrote SQL code to extract legacy data and establishing data lineage for data warehousing.

Translated sales and marketing requests to technical development.

Environment: SQL, Excel, VB, Java, Access Product Management, Sales and Marketing.

Business Analyst, Kaiser Permanente, Burbank, CA (1/15 – 3/15)

Customized insurance benefits for Account and Sales Managers.

Used Access and SQL to pull benefits information. Ensured process integrity of benefits selections.

Created benefits tools to assist in analysis, and presented benefits analysis to Account and Sales Managers.

Analyzed and assembled insurance packages while assuring the following of company guidelines and state compliance.

Environment: SQL, Access, Executive Account Management.

Data Quality Analyst, UCLA Health-Office of Health Informatics and Analytics, Westwood, CA (8/14 – 10/14)

Identified and developed framework for picking Data Stewards. Explained Data Lineage process.

Developed standardization techniques and data definitions by working with various stakeholders throughout UCLA Health.

Tracked legacy data movement into EPIC using customized Data Forensic tools.

Developed Data warehouses for various departments in SAP. Created Data Lineage materials.

Created a frame-work from how to collect data from various front end resources, established front-end controls, and used various vendor tools such as IBM Initiate to accurately combine data.

Established a Master Patient Index. Created training materials for staff.

Environment: SQL, Excel, IBM Initiate, Multiple EPIC Modules, Gathering Business Requirements.

Product Management Analyst, Farmers Insurance, Hancock Park, CA (11/13 – 6/14)

Created scorecards, running weekly, and monthly report and created Macros to run reports from SAS EG to Access Database to Excel while utilizing extensive SQL.

Earned Kudos award from Farmer’s for report catching agent manipulation and saved the company over $100,000 alone in California and still in the process of calculating nationwide.

Maintained and archived reports on SharePoint and internally developed database.

Imported/exported data from data warehouse in SAP to Access tables creating multiple data sets based on ad-hoc requests.

Created and maintained tables, reports, and forms that are the basis of weekly, daily, monthly, and quarterly reports from Access.

Conducted extensive statistical and data analysis using SAS EG and R.

Conducted Forensic Data Analysis and transactional data analysis.

Built recurring reports and scorecards for directors and managers reflecting underwriting analysis trends.

Exported queried results from SAS EG to Access, transforming the data.

Wrote a high volume of SQL code and extensive use of SAS EG and SAP Business Objects to query data from company database.

Utilized MS Office to present data.

Conducted qualitative and quantitative analysis and creating reports of data via ad-hoc requests and provided business insights in an accelerated environment.

Forecasted trends within reports.

Collaborated with different departments to gain insight into business needs to develop strategy as well as operational improvements.

Presented to Business Users.

Trained staff to query using SAP Business objects.

Developed Universes in SAP.

High volume use of pivot tables, R to conduct and present analysis.

Environment: SQL, R, SAS EG, SAP, Macros, Excel, Access Database, SharePoint, Lotus Notes.

Data Conversion Specialist, Disneyland, Anaheim, CA (8/13 – 9/13)

Operational and Strategic planning to comply with OSHA regulations.

Moved data from Proprietary Database to Access Database into new Vendor Database. Establishing Data lineage.

Data scrubbing and developing a standard nomenclature for 12,400 items by researching manufacturer specifications for each unique product in Access Database while maintaining inventory of items.

Database tracked who had been using items, where it was located upon pick-up and return.

Conducted Statistical Analysis to monitor staff performance and compliance.

Created cogent queries to clean out database of errant items. Data Reconciliation.

Developed queries for inspection procedures provided by Cal-OSHA. Used SQL to extract data from 72 vendor databases including data mining and SQL reporting services into Access Database.

Environment: Access, Data- mining, SQL, Forensic Data Analysis, Data Conversion

Covenant House, Hollywood, CA

9/10 – 12/13

Data Analyst/Specialist (2/12 – 12/13)

Strategic and Operational implementation of Data Governance goals.

Maintained Data integrity organization-wide by training front-line staff on definitions provided by County and developing training materials. Project Manager on Clinical Data Compliance.

Developed databases in Access, Excel, and ETO for First Place for Youth at Covenant House.

Created SQL Queries, using mathematical/statistical modeling, and translating analysis for program evaluation.

Transferred data from Excel Data, Crystal Reports to Access Database. Created Access database to establish weighted index to balance out client needs and organizational resources.

Made presentations in PowerPoint for use by Development Department.

Used Data mapping to properly identify unassigned data. Data Reconciliation.

Extracted, analyzed, and managed data including statistical analysis from the last five fiscal years to present to potential donors reflecting organization's outcomes as it related to our resources, modeling the trend in outcomes as it relates to resources.

Designed aesthetical and functional forms. Managed daily data inputs.

Coordinated and streamlined data into wider organizational database.

Collaborated with and training various department directors on quality assurance and government compliance issues.

Created spreadsheets and setting queries to ensure data integrity. Monitored staff and client performance to ensure compliance. Trained staff on software. Ensured documentation compliance.

Environment: Excel Data, Crystal Reports, Access Database, SQL Queries, PowerPoint, Project Management

Resident Advisor (1/11 – 2/12)

Gained insight to building singular database for the goal of establishing weighted index. Created trust and advocated for homeless youth with risky behaviors to ensure following of organizational rules and standards.

Established self- economics workshops and events to create solidarity between staff and youth. Provided paraprofessional counseling and gained an understanding of human nature in the context of organizational dynamics. Quality assuring Outreach department data.

Quality Assurance Administrative Assistant (FTE) (9/10 – 1/11)

Created data infrastructure, set queries to begin analysis to retrieve lost data, ensured integrity of current data, and facility. Established quality measurement methods to help retain highest quality data. Established Access Databases for Director for their recurring reports to the Board of Governors. Trained them on some basic analysis.

Led the Forensic Auditing of data in preparation for reports to Grantors. Created new data collection system involving coordinating and managing different department data needs into one database using Access and Excel.

Project Managing the re-organization of Clinical Department Data ensuring transparency and integrity of Data submitted to grantors via Access. Training staff on how to create Access queries and monitoring their performance.

Environment: Project Managing, Access and Excel, Forensic Data Analysis

Independent Consulting

3/10 – 7/10

Benefits Analyst, Mastro's Restaurant LLC (6/10 – 7/10)

Analysis of benefits packages using SAS to determine third-party retention. Creating multiple data sets for Director of Human Resources and Executives.

Broad knowledge of business/finance principles to properly interpret data. Conducting presentations to CEO and Controller presenting analysis.

Environment: Business/Finance principles, SAS.

Administrative Clerk, United States Census Bureau, Burbank, CA (3/10 – 5/10)

Interviewed up to 35 candidates daily in Spanish and English daily for positions for the large-scale temporary project. Provided orientations for new hires.

Conducted payroll entry for 800 staff daily. Worked in an accelerated environment that required versatility and flexibility.

Environment: Payroll, new hire orientation.

INTERNSHIPS:

COPE Health Solutions, Van Nuys, CA

8/10 – 11/12

Intern/Clinical Care Extender

Project with Cardiac Catheter Lab: Assembled data for procedures conducted in catheter lab to determine insight into the relationship between staff performance and procedure punctuality using HEDIS.

Project with Corporate Office: Developed database with Alumni data from the last 10 years. Set queries for predictive analysis of potential Alumni who may act as mentors. Personally cold-calling 600 Alumni to collect data then conducted analysis which was then reported to Director of Health Talent Innovations.

Used knowledge of Health insurance business principles helped establish new SQL database using unassigned finance data to evaluate health insurance payments to client hospitals and using healthcare quality measurements to track staff performance and patient health outcomes.

Basic Duties: Assised Nurses, Doctors, and allied health care providers in various departments with responding to patient and staff needs ensuring timely and accurate assistance while advocating patient needs and concerns. Provided administrative help to hospital staff and executives.

Environment: SQL database, data, analysis.

Contact this candidate