Business Intelligence Information Technology Data Analytics

Mebrahtu Grmai

240-***-**** ******@*****.***

Professional Summary

Application support subject matter expert with experience within the Acquisitions environment, including contract management application, financial application, congressional financial reporting, business intelligence tools, and report generation. Self-motivated experience with process automation through the Microsoft Power Platform to improve business processes and tracking. Combining technical and communication skills to achieve the goals of the organization.

Work Experience

U.S. Dept. Of Transportation/General Dynamics Information Technology/Global Executive Staffing

Job Title – Management and Program Analyst/PRISM System Analyst (05/2015-Present)

Liaison to the FAA Enterprise Services Center (ESC) for the Department of Transportation’s Pipeline and Hazardous Materials Safety Administration

Support of ESC PRISM (Procurement Request Information System, a FedRAMP moderate SaaS product)

oMaintaining 1000+ active awards (contracts, purchase orders, grants, interagency agreements, etc.)

oActive user base of 40-50 specialists, requisitioners, and approving officials

Other system support within the Integrated Acquisitions Environment:

oFPDS-NG: Site Administrator, ad hoc reporting

oSAM.gov/beta.SAM.gov: ad hoc reporting

oDelphi (Oracle Financials): eInvoicing, OBIEE

oG-invoicing Project Champion

Assemble scrum-like teams to tackle specific tasks and make analyses that support decision making

Develop ad-hoc reporting via Discoverer Plus (200+ reports developed), ETRS-SplashBI, and PL/SQL queries

Testing PRISM and Delphi patches/upgrades (quarterly upgrades, special releases/patches)

Develop guidance for PRISM/Delphi functionality and business process best practices

Develop and coordinate training seminars for PRISM functionalities/modules

Develop automated processes with Microsoft Power Platform, including:

oIncident Request System with automated e-mail reminders

oPowerApps/PowerBI development

oPersonnel Offboarding Process

oAd-Hoc Report Request System

Access Control Officer: manage all ESC PRISM User Access Requests

Assisted with the transition to an integrated acquisitions system environment, including cleanup, configuration, and analysis of conversion metrics, and legacy PHMSA PRISM support

Manage all new Supplier requests, Vendor Novation requests, Assignment of Claims requests

Jacobs Engineering, ISSG

Job Title – Testing Lead (01/2013-05/2015)

Responsible for Quality Assurance on all development, including reviewing code logic and black-box testing

oPL/SQL

oHMTL/XHTML/CSS

Testing all PRISM upgrades to ensure no detrimental impact on functionality as well as determining how changes will affect internal procedures, reports, etc.

Attend and participate in conference discussions of PRISM bugs and change requests to be implemented

Responsible for submitting and tracking all user-provisioning requests

Delegate testing to provide further experience for technicians

Continued all responsibilities as an Acquisitions Support Tech (below)

Job Title – Acquisition Support Technician (12/2009-01/2013)

Provide Tier 2 level support to PRISM end-users in several agencies, observing and adhering to SLA requirements.

Reviewing data and working with liaisons from outside systems to ensure accuracy with the PRISM application

oUFMS – financial management system (commitments, obligations, invoicing, and billing)

oDCIS/FPDS – systems that report spending and other regulatory information

Utilize the in-house PSC Acquisitions portal to track all incidents and provide detailed resolutions to provide a better resource for recurring issues

Create dynamic pages and forms from tables to develop additional tools for end-users using Oracle portal

Develop ad-hoc reports for users as needed

Develop PL/SQL queries/scripts to assist with diagnosing PRISM issues or update back-end PRISM data

Perform weekly database diagnostic checks to ensure proper backups and check error logs for any potential issues

Education

University of Maryland, Baltimore County – Baltimore, MD

B.S. in Information Systems

Certificate in Decision Support

Coursework Completed

Project Management

User Interface Design: HTML/XHTML/CSS

Object Oriented Programming: Python, PL/SQL, Java

Database Design: Oracle, SQL

Management Information Systems/Decision Support Systems

System Development Life Cycle

Competencies

PL/SQL

Python

Data Visualization:

Python (Matplotlib, Seaborn)

Excel

Tableau

Oracle SplashBI

HTML/XHTML/CSS

Microsoft Power Platform

Microsoft Forms

Microsoft Sharepoint

Microsoft Power Automate

Microsoft PowerApps

Microsoft PowerBI

Enterprise Resource Planning

UiPath Citizen Developer

ITIL Certified

Microsoft Office Suite

Discoverer Plus Ad-Hoc Reporting

ETRS-SplashBI Ad-Hoc Reporting

Excellent writing/communication/mathematics skills

Ability to work cooperatively and collaboratively with multiple offices within and external to my organization

Leveraging Emotional Intelligence to work more efficiently and effectively with others

Problem-solving and prioritization in time-sensitive environments

Clearance

Public Trust

References Available Upon Request

Contact this candidate