SUMMARY

• 5 years’ experience working as SQL/MSBI/Power BI Developer and have solid experience in managing large database, creating different database objects(like tables, views, indexes, stored procedures, functions and triggers), Data modeling, data integration( Using SSIS), Data visualization, configuring and managing reports using different technologies .
• Used Power BI different components/functionalities like power query DAX, data models, Datasets, Dashboards, KPI Scorecards, Implementing row - level security.
• Experienced in building a Data warehouse using stat and snowflake schema.
• Familiar with agile methodology and the different agile ceremonies.

TECHNICAL SKILLS

RDBMS: Azure SQL database,SQL Server 2019/2016/2014/2012/2008 R2

Languages\Tools: Visual Basic, PowerShell, C#, T-SQL,python,.Net.

Modeling Tools: MS Visio and Oracle SQL Server Data Modeler.

ETL Tools: SSIS, Azure Data Factory, Informatica Cloud

Visualization: Power BI Desktop,Power BI service,Tableau, Report Builder, Visual Studio,SSRS

Analysis Tools: SQL Server Analysis Server (Tabular and Multi Dimensional)

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

SQL/Power BI Developer

Responsibilities:

• Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes
• Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2012/2017.
• Experience in Power BI and with different BI component like (Oracle, SQL, SSIS, SSRS, SSAS).
• Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog.
• Imported data from Oracle DB, SQL Server DB and Azure SQL DB to Power BI to generate reports.
• Cleaning up datasets using merge queries, append queries, and sort data columns to properly fit our reports.
• Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.
• Good Knowledge Installed and configured Enterprise gateway in Power BI service.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Experienced on how to publish, schedule reports and dashboards to meet business requirements.
• Developed visual reports, dashboards, and KPI scorecards using Power BI desktop.
• Good Skilled of calculated columns, Measures queries in Power BI desktop to show good data analysis techniques and Generated reports in Power BI Modelling and usage of DAX.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Implementation of Row-level security with Power BI (RLS).
• Deployed and Created Compute on Azure Cloud Service.
• Implemented on Azure Analysis Service, Azure Data factory, Azure Blob, Data Lake.
• Designed, implemented, and supported platform providing ad-hoc access to large database.

Environment: SQL Server 2019/2016/2012 , SQL BI Suite (SSIS, SSRS), T-SQL, Power BI, SQL Profiler, MS Office, Erwin, Windows Server 2016.

Confidential, Fairfax, VA

MSBI / SQL Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Wrote custom T-SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Used Crystal Reports to tracked logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Used SSIS to upload amortization schedules sent by the client in . CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Managed Alerts for successful or unsuccessful completion of scheduled Jobs.
• Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the project.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Developed incremental loading using MERGE statement in SQL server 2008R2.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.
• Optimized the database by creating various clustered, non-clustered indexes and index views.
• Ensured to generated and delivered quality reports to customers in timely and accurate manner.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Developed standard reports and functional dashboards based on business requirements.
• Generated reports for internal and external customers for business performance monitoring and business decision making.

Environment: Microsoft SQL Server 2008/2008R2, MS Sql integeration Services 2008, SSRS 2008, SSAS, Microsoft Excel, C#, XML, ASP.NET, MS Office.

Confidential, Addis Ababa,Ethiopia

Junior Database Developer

Responsibilities:

• Work as an SQL/Java Developer and establish strong relationships with end users and technical resources throughout established projects
• Work closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review
• The SQL Server Developer will work closely with Application Developers to ensure proper design and implementation of database systems
• Database administration including performance monitoring, access management and storage management
• Partners with development teams/vendors to provide reporting on in flight software development projects
• Create, develop and maintain SQL processes for channel performance data warehousing
• Closely working with development manager and onsite team to deliver solutions

Environment: SQL Server 2008/ R2/2012, BIDS, Visual Studio 2005/2008/2010 , T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, SSMS, Report Builder 2.0/3.0