Victoria Kassa

• Over 7years of professional experience in the Information Technology field as SQL/ BI developer in MS SQL server2015/2016/2019/2012/2008R2/2008 environment covering various domains. • Experience performing high complexity analysis, design, development and unit testing of software applications from user requirements and design documents, in addition to resolving defects encountered during the various testing cycles. • Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements. • Developed EMR data transformations to process Provider Data transactions for data accuracy. • Created stored procedures, triggers, Views, CTE's, T- SQL scripts, schemas, permissions and performance issues with client/ server database design. • Experience data sources connectivity, configuration, optimization, data security and access permission Server configurations, regular updates and version upgrades Manage workspaces Publish Power BI visuals verify codes used to embed Power BI in other applications. • Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables. • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load. • Used SSIS 2014 to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Database. • Developed the SQL programs and Involved in optimizing stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS. • Involve in all phases of SDLC, create detail analysis-design document with source to target mapping. • Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS. • Design, implemented and maintained rational database including Oracle SQL server and Mysql, insuring high performance, scalability and data integrity. • Performed on extensive database normalization and denormalization for optimizing performance and simplifying queries while maintaining data consistency across large scale RDBMS environments. • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging. • Ability to measure, edit and compare business data with different queries. Good experience on KPI (Key Performance Indicators) areas. • Extensive experience in Capacity Planning,