Sql Server Power Bi

AMEHA G. ESHETE

**** *** ****** ** **** *

Washington DC, MD 20011

*******@*****.*** Cell: 202-***-****

SUMMARY

Astute Database Administrator with diverse experience managing teams on Administration, Datamining, Development, Creating Reports, and Database tools that support government agencies, communities and giant retail stores as well as leading manufacturers. Proven track record of leveraging technical skillset of plan implementation. Core competencies include:

Design, Develop, Install, Administer, And Implement Complex Data Delivery Systems

Test, Development and Cluster Server Environments.

MS SQL Server, PostgreSQL & Oracle 19c

R Studio, Tableau and Power BI

MongoDB and NoSQL

Eclipse Java

New Product Development

Analyze Business and Technical Requirements Data Warehouse Data Models (SSIS, SSAS & SSRS).

System Administration – Data Center

T-SQL Programming Skills Creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, ETL, Triggers, and Cursors.

Forecast and Prediction

Create New Pattern and give Insight

Test, Development and Cluster Server Environments.

TECHNICAL EXPERTISE

Languages

T-SQL, MDX, VBA, XML, HTML, R, Mongosh and Shell Scripting.

RDBMS

MS SQL, Oracle, PostgreSQL, and MySQL

Big Data

NoSQL, Big SQL and MongoDB

DWH / BI Tools

SQL SSRS, SSAS, SSIS, Excel, Tableau, Power BI.

Operating Systems

Windows 2003 - 2012, and Unix and as well as Azure Cloud

PROFESSIONAL EXPERIENCE

Garud Technology Inc. February. 2023

DBA/Developer

I’m responsible in administrating, developing, maintaining multiple Dashboards

Conduct Training and hold meetings with stakeholders

Develop, maintain and administer SQL Server, Tableau and power BI dashboards.

Developed T-SQL and R scripts for ETL and analysis as well as file preparations for Dashboard

Prepare after action, checklist and SOP’s documentations.

Installed, Configured, Test, and Administered R studio, Tableau, Power BI and SQL Server environments

Neuma Consulting LLC February. 2023

DBA

I’m responsible in administrating, developing, maintaining multiple Databases

Maintain and administer MS SQL, Oracle, PostgreSQL and MangoDB.

Developed and prepare scripts for project initiation using Pl SQL and T-SQL and Mongosh.

Installed, Configured and managed, Test and Administered multiple RDBMS systems:

MS SQL Server, PostgreSQL, Oracle 19 & 23C and MangoDB

BioTsquare Jan. 2022 – Dec. 2022

DBA/Developer

I’m responsible in administrating, developing, maintaining the Covid-19 clinical trial databases.

Administrate Master Control - Clinical Trial Tracking system

Installed, Configured, Test, and Administered SQL Server environments

Installed, Configured and managed multiple RDBMS systems.

Advise on setting up company clinical trial network and databases

Planned and implemented deployment strategy, system integration and acceptance testing operations.

Consult different stake holders on many aspects of the data managing, migration and disaster recovery. I worked with partners and team members to provide professional consultation services on technology best practices, standards and policies.

Attended senior level meeting

DOD Army Nov. 2020 – Dec. 2021

DBA/ Developer

I’m responsible in administrating, developing, maintaining, enterprise SQL Server database environments.

Install and Configured Oracle 19c, and SQL Developer. Build and optimize multiple databases.

Installed, Configured, Test, and Administered PostgreSQL and SQL Server 2012/2014/2016 and 2019 and Window Servers.

I implemented security patches and SQL Server and Window Server (STIGs).

disaster recovery: Maintained Fail-Over Cluster Servers in SQL Servers and Monitoring and Performance Tuning:

Utilize Government Cloud portal – AWS and AZURE

Experience in creating the database maintenance plan tasks including on Azure Automation.

Work on ETL, SSRS, SSAS tools and experienced working on Azure SQL Database.

Configured Long Term Retention (LTR) backups for Mission critical databases.

Managing Datacenter, Security, logins, and reports

NOAA/NASA/Raytheon, River Dale, Maryland July 12, 2018 - 2020

DBA/ Developer

I’m responsible in developing, maintaining, and in general managing 100’s of enterprise SQL Server database environments by implementing SQL Server best practices with a focus on functionality, Security and scalability.

I manage and perform installation, migration, & access privileges on MS SQL Server 2012/2014/2016 and 2019.

Mange and install Oracle 12 and 19c, SQL Developer and toad.

I implemented security patches (STIG) per Application detection and Security Technical Implementation Guides.

Utilize Government Cloud portal – AWS and AZURE

Data Center Management, Service Organization Control (SOC) audits and develop SOP’s.

Consult different stake holders on many aspects of the data managing, migration and disaster recovery and VMware configuration. Schedule, plan, and oversee database / system upgrades.

I worked with partners and team members on best practices, standards and policies/guidelines.

Manage and monitor cluster fail over, log shipping and other high availability settings for many weather support satellite flight and orbit activities.

Developed overall testing plans, criteria, periodic password rotation and specifications (SOP’s).

Conduct meeting, and traveling

DHS/FEMA/Trillion, New Carlton, Maryland 2016 - 2018

DBA/ Developer

I’m responsible in managing, developing, maintaining, and designing enterprise SQL Server database environments by implementing SQL Server best practices with a focus on database optimization, functionality, Security and scalability. In addition, Window services and application modification and connection.

Devops - Determine the most effective way to increase performance

Performing Data cleaning and comparison analysis.

Design, Implement, and maintain complex RDBMS system.

Maintain database dictionary, SOP and quality control as well STIG

Support planning of system/environment requirements on different projects

I installed PostgreSQL and SQL Server with minimum access privileges service account to improve security and to attain high ratings in Service Organization Control (SOC) audits. MS SQL Server 2012/2014 and SharePoint

I implemented security patches on PostgreSQL and SQL Server and Window Server (STIGs). TDA encryption, Window extended protection (registry change) and Application modifications.

I performed DB maintenance, DB monitoring and space management to utilize resources efficiently and improve database performance. SQL objects, Stored Procedures, Views, Indexes, defined data types and functions

I involved in configuring, patching, testing, monitoring, and supporting multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.

IRi, Bethesda, Maryland 2015 - 2016

BI Developer

Developed and administer, and tested, validated (QA) prior to deployment. Coordinated with developers, account managers and other IT personnel and engineers.

Ensure delivery of quality software products.

Design, Implement and maintain complex database

Data structure/architectures, database programing to support an update and process

Administrate systems/database environment solutions for multiple projects with varying schedules

Installed, configured SQL Server 2008 & 2012 in development, test, and production environment

Administration of MongoDB: Optimization, Backup, Deployments, Monitoring, Hardware and Replication.

Write T-SQL, MDX and VBA codes for Report Development as well as Create, Monitor and review SSIS Packages

In charge of developing, Monitoring, optimizing and delivering hundreds of reports

Utilize SSRS with MDX code, Excel, Market Master and ProClarity

Perform data quality reviews and data validation. Trend analysis and evaluate statistical methods and conduct technical research techniques

AMEHA G. ESHETE page 2

Northrop Grumman 2014 - 2015

BI Developer SME

Developed various reports, conducted gap analysis for mapping data elements. Performed legacy system analysis, designed Use Case specification, and developed data conversion specifications (T-SQL and Excel).

Develop various Reports, conduct gap analysis for mapping data elements, Legacy system analysis, Design Use Case specification, and develop data conversion specifications (T-SQL and Excel).

Provide technical writing support for functional requirements and data conversion specifications

Develop integrated action plans and issue technical bulletins with implementation instructions.

Develop specifications for user instruction manuals based on customers' needs.

Develop web service specifications for interface between multiple applications

Conduct meeting, Coordinate the preparation of testing and implementation plans.

Oversee the migration of systems to the production environment and monitor systems for stability, accuracy and performance. – SME

MTM, Chillum, MD 2013 - 2014

Data Analyst

Prepared weekly & monthly quality assurance reports (38 executive reports & charts)

Administer and optimized Oracle 12 database utilize TOAD for retrieving data.

Improved report performance by optimizing queries and settings.

I created ad-hoc reports per provider’s performance metrics, and maintain data Integrity. Runs and maintain store procedures, UDF, triggers.

Developed tabular, matrix, and graphical reports from multiple data sources using excel and SQL Server Reporting Services and other similar tools.

Analyzed, validated, data reconcile data submitted by service contractors using; Excel, SQL SSRS, Trapeze, Crystal, and CMS (Call Management Center).

AMEHA G. ESHETE page 3

EDUCATION and Certification

MS, Master of Science: Database admin, Data analysis, & Development UMUC. December 2017

BS, Information Technology, University of the District of Columbia. 2009-2012 Rec. May 2013Certificates: CASP, Azure Fundamental, and Microsoft Certified Technology Specialist.

Contact this candidate