Skills and Competencies

Greater than * years of experience in SharePoint online and power platform (Power BI, Power Apps, Power Automate, and Power Virtual Agents)

SharePoint Developer with over 2+ years of IT experience in Analysis, Design, Development, Implementation, and Testing of Web-Based

Greater than 2 years of experience in Power BI report development and support

Greater than 6 Years of experience in designing and deploying SQL server databases

Consulting and sharing technical skill for client on Business Requirement.

Motivated and detail-oriented with strong organization and analytical skills

Good interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies

Technical Expertise

BI Reporting tools

Power BI, SQL Server Reporting Services (SSRS)

Database Tools

MS Access, MS Excel, SQL Server 2005/2008/20012/2014, Oracle, Maximo

Programming

T-SQL, JQuery, HTML, CSS

SQL Server Tools

MSBI (SSIS, SSRS, SSAS)

Operating System

Windows, Unix, Linux

Microsoft office

Office 365 SharePoint online, SharePoint 2019, SharePoint designer 2013, Infopath, Power Automate, PowerApps, Power BI, Planner

Other Applications

Kanban, Sharegate 2013, Git, GPT-4, SPSS, Adobe Photoshop, Adobe Primer Pro, AutoCAD

Professional Experience

Mercedes-Benz, MI Dec 2021 – Sep 2023

Role: Technology Lead/ SharePoint Online

Working on User profile Management, managing user permissions and roles, defining search scope, and customizing the search features

Working on the branding and chroming of the Sites using CSS, Page Layout, JQuery, Master Pages for SharePoint Site

Creating Document Libraries, List Features, Site Features, Site Templates, version control, Content Types, Lists, Views, Announcements, and Tasks

Customize SharePoint sites using JQuery, HTML & CSS

Gathering requirements, designing and implementing Custom web parts and workflows

Give guidance as to how to co-author project documents and versioning among team members

Creating a linked data source in SharePoint Designer

Create and configure various web-parts, such as data view, content query, content editor, and table of content web parts

Designing information architecture; customized OOTB navigations; migrated sites, lists, libraries and documents

Configuring security and site permissions using SharePoint groups and Audiences

Creating and managing Custom Site Definitions, Site Templates, Site Columns, Document & Picture Libraries, Lists, List Views, User Alerts, Links, Events, and Content-Type on SharePoint 2019

Partner with our IT Team to provide support, maintenance, plan for future growth and development, and manage the SharePoint environment

Responsible for SharePoint site management support activities, resolve incidents in a timely manner

Review the sites with the business user for permission update and decommissioning site if no longer needed

Build advance SharePoint workflow and workflow-based solutions

Develop customized form and flow to automate business process

Communicate with the business owners for requirement, enhancement/changes or update

Production deployment keep management informed of testing progress status regularly for review/sign off

Work closely with colleagues to find solutions to business issues/problems

Freddie Mac, VA Mar 2021 – Nov 2021

Role: Technology Analyst/ SharePoint Online

Worked on Nintex form and workflow migration to SharePoint online rebuilding the form with PowerApps and workflow with Power Automat

Build advance SharePoint workflow and workflow-based solutions with Power Automat

Build advance SharePoint form with PowerApps

Develop workflows using Power Automate in different projects along with complex workflow actions like the Approval & Task process

Migration of Nintex workflow and form to Power Automate and PowerApps

Migrate SharePoint Site/List/Library using Sharegate tool

Created SharePoint sites / pages, list, Documents, Libraries

Develop customized form and flow to automate business process

Migrated SharePoint Site, List, Library, Documents, page, using ShareGate tool

Communicate with the business owners for requirement enhancement/changes

Production deployment keep management informed of testing progress status regularly for review/sign off

Work closely with colleagues to find solutions to business problems

Eversource Energy, Berlin, CT April 2019 – Feb 2021

Role: Data Analyst/ Power BI

Analyzing data and present data through reports that aid business decision-making

Created dashboards and interactive visual reports using Power BI

Understand business requirements in BI context and design data models to transform raw data into meaningful insights

Created relationships between data and develop tabular and other multidimensional data models that are compatible with warehouse standards

Design, develop, test, and deploy Power BI scripts and perform detailed analytics

Performed DAX queries and functions in Power BI

Redefine and make technical/strategic changes to enhance existing Business Intelligence systems

Designed, developed and deployed business intelligence solutions as per needs

SQL querying for best results, use of filters and graphs for better understanding of data

Connect to data sources, importing data and transforming data for Business Intelligence

Adept in development, publishing, and scheduling Power BI reports as per the business requirements

Created workspaces, dashboards, apps, gateway connections

Managed access to the workspaces, dashboards, apps, gateway connections

Resolved issues related to power bi data source, report refresh, gateway, gateway connection

Communicate with Microsoft support team, for bugs and defect on the power bi tools

Automate schedule refresh, and support in case of issues/failures

Azure Devopes for report pbix/pbit version control

Worked with users and team members at all levels for performance improvement and suggestions

Follow development processes, coding standards, and methodologies

Keep management informed of testing progress status regularly for review/sign off

NM, Milwaukee, WI May 2018 – Feb 2019

Role: Technology Analyst

Batch job, migration from Unix to Linux using CICD Automation

Modified Shell scripts to migrate to Linux

Created unit test case for every Script, testing the job

Using Version control (GitHub) with team reviewable code

Jenkins is our pipeline workflow engine

Worked with CICD, Autosys jobs, shell scripting, Version control system GitHub

Test, commit the change on GitHub, migrate to Production

Follow development processes, coding standards, and methodologies

Keep management informed of testing progress status regularly for review/sign off

Deployment to production

Hawassa University, Ethiopia Aug 2017 – Nov 2017

Role: Consulting/SQL development

Upgrade SQL server databases,2008R2 to 2014

T-SQL programming

Created table, stored procedures, functions, trigger

Query optimization using Statistics IO and execution plans

Setup and manage database backups using maintenance plans along with update statistics, database integrity check.

Deloitte, Harrisburg, PA Jun 2016 – Jul 2017

Role: SQL/ETL Developer

Performed upgrading & migrating of SQL server instances and databases

Experience in SQL Server tools, including Management Studio, Query Analyzer, Profiler, SQL Server Agent, and database tuning adviser

Built database schemas and objects such as tables, stored procedures, triggers, views, and indexes

Set up database maintenance plan, back-up & recovery strategies, and procedures

Managed database backup and disaster recovery

Restored database from backup and implemented Point-In-Time Recovery solutions

Performed data Extraction, Transformation & Loading (ETL)

Configured, deployed, and executed SSIS package

Performed reviewing, optimizing, and deploying of database scripts

Education and Certification

Education: B.Sc. Electrical Engineering Addis Ababa University Mekelle Campus, Mekelle, Ethiopia

Certification: 70-461: Querying Microsoft SQL Server 2012/14

Certification: DP-900: Azure Data Fundamentals

Certification: DA-100: Analyzing Data with Microsoft Power BI

Certification: PL-900: Power Platform Fundamentals

Certification: Photo Editing Adobe Photoshop cs6

Certification: Video Editing Adobe Premiere pro cs6

Contact this candidate