Sead S. Email & Phone Number

Los Angeles, California, United States

• Conversion of existing Crystal Reports to SSRS.Ability to gather requirements based on users, develop, test and deploy reports.
• Testing / debugging reports and SQL statements.
• Maintain Crystal Reports Server (2016) and our standard report library until all reports are converted.
• Learn our business processes and operations to be able to provide support to business applications users.
• Follow up on all production issues and customer inquiries to ensure they are resolved in a timely manner.
• Document functionality and designs of reports.

Los Angeles, California, United States

• Responsible for gathering project requirements from the users for designing and developing data warehouse as needed Responsible for Dimensional modeling.
• Designed and developed SSIS (ETL) packages to extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Developed Complex stored Procedure using dynamic sql technique to import multiple tables from SQL Server data sources to SQL Server data warehouse.
• Created SQL Server Agent Job for the automation of data import to the data warehouse.
• Responsible for creating Databases, Tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.

Anaheim, California, United States

Worked with database objects like Stored Procedures, User Defined Functions, Triggers and Indexes using T-SQL to create complex scripts and batches. Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning. Involved in adding Dimensions and Facts for insurance policy (Auto.

Ethiopia

• Gathered business requirement from users and involved in designing conceptual, logical and physical model of the relational databases and multi-dimensional cubes(OLTP and OLAP)
• Created database objects like tables, views, stored procedures, performance tune them to facilitate reporting
• Implemented Key Performance Indicator Objects, Actions, Hierarchies and Attribute Relationships for added functionality and better performance of SSAS Warehouse.
• Defined different Calculations and Named Sets in cubes using MDX queries
• Designed and created SSRS reports from SSAS cubes using SSAS cubes and connections and MDX to query the data
• Created complex Tabular Model cubes where data is pulled from different sources like tables, and different cubes. Wrote DAX calculations

Bachelor Of Applied Science - Basc, Computer And Information Sciences And Support Services

Certificate, Sql Databases Developer

High School Diploma, A