SEADA UMER

A highly motivated and energetic BI/SSIS/SSRS/ETL/Power BI developer with over 4 years of experience in the field, wonderful experience in Agile work environment, and with proven background in inter/intrapersonal communications skill and working relationships at all business levels with having the following sets of professional experiences: Over 4+ years of experience in reporting solution development, ETL development, business intelligence solutions, and enterprise data warehouses development involving multiple industries. Expert Knowledge in building and managing relational databases and tables normalization using SQL Server Management Studio (SSMS) Expert with producing highly efficient and project-oriented T-SQL query statements. Goal-oriented usage of features such as Dynamic SQLs, Cursors, Views, Stored Procedures, User-Defined Functions (UDFs), Triggers, Indexes, Temp Table in SSMS to provide convenience for front-end applications or reporting purposes. Proficient in tuning performance of query statements using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor Profoundly experience in feature design and flexible usage of tabular charts, donut charts, histograms, and maps to express business solutions comprehensively using visualization tools including Tableau, Power BI, MS SQL Server Reporting Service (SSRS) and Excel Excellent knowledge of MS SQL Server Integration Service (SSIS) to perform ETL solutions for Data Migration, Data Conversion, Data Validation, Data Management, Reporting and supporting other analysis. Profound understanding of Enterprise Data Warehouses and Data Marts including OLTP/OLAP, Dimension/Fact Tables, Top-down/Bottom-up models, and Star/Snowflake Schemas using Landing and Staging stages Strong Skills in using SSIS Control Flow (Execute SQL task, For each Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.) Substantial experience using Event Handlers, Checkpoints, Breakpoints, and Debugging in SSIS Proficient in using skills like Slow Changing (Type 0/1/2/3) and Change Data Capture to load and transform data dynamically. Highly skilled with Agile/Scrum/Waterfall working methodologies along with phases of Software Development Lifecycle (SDLC) Effective problem solver with thorough analytics added to credible and concise presentations. Wonderful experience in working with customers or departments on technical issues including software system design and maintenance. Excellent inter/intrapersonal communication skills with a mindset of embracing new challenges and working conditions. Conducted training sessions for end-users to educate them on how to use Power BI reports and dashboards.

• Microsoft Certified: Data Analyst Associate in Power BI
• Cloud - AWS Certified Cloud Practitioner
• Microsoft MTA: Database Fundamentals
• SQL Programming