Sam Yared Email & Phone Number

Sacramento, California, United States

Develop Crystal Reports, Tableau dashboards and SQL from multiple data sources including financial data for analysis and visualization. Provide analytical and technical support for complex requests, projects, or initiatives. Publish and schedule Crystal Reports to run in BI Launchpad based on supplied parameters. Publish Tableau dashboards to server. Create SSIS packages and forms in Visual Studio 2017. Set up and maintain Team Foundation Server (TFS) for Crystal Reports, Tableau, SQL and SSIS packages. Query and analyze data from Epic and Caboodle database. Create Tables, Views and Stored Procedures in SQL. Investigate data and identify any potential issues. Extract data from multiple sources, transform and load data (ETL) into SQL databases. Develop training documents and train team members. Gather business requirements from end users. Design and develop data marts. Modify SSRS reports based on user needs. Perform database testing before extracting data and ensure tables and views are optimized. Track the resolution and status of created tickets in JIRA. Developed scripts to scan and modify reports for Epic upgrade

Lincoln, California, United States

Provided financial analysis and prepare database driven reports in MS SQL, SSRS and Excel. Collected and analyzed quantitative data to evaluate special events promotions, direct email and telemarketing program analysis for Relationship Marketing Player Development and Promotions. Developed SSRS financial and revenue reports including KPI for trending and analysis. Created SQL queries, tables, views, stored procedures using MS SQL Server 2012.

Roseville, California, United States

Designed and developed online reports which include financial data for In-home Supportive Services (IHSS) program for the State of California using Crystal Reports XI, Business Objects XI and DB2. IHSS program helps low-income seniors and people with disabilities stay in own homes and is considered an alternative to out-of-home care such as nursing homes and residential care facilities