Resume

Sign in

Data Assistant

Location:
Sacramento, CA
Posted:
October 19, 2019

Contact this candidate

Resume:

Evans Adjei Ashong

adamny@r.postjobfree.com **** Sutterwoods Way, CA 95827 916 - 513-3600

Graduate student working on a Master's degree in Information Systems. Confident team player with excellent interpersonal and leadership skills, seeking a consulting position to design and develop secure applications.

Education

Master’s degree in Computer Information System Dec. 2019

Middle Tennessee State University Murfreesboro, TN

GPA 4.0/4.0

Bachelor of Science May, 2010

University of Ghana Accra, Ghana

Technical Skills

Business Intelligence

Tableau, Excel, Microsoft office, Lucidchart

Database Management

Oracle, MS SQL, PLSQL

Application / Web Development

C#, Python, HTML/CSS

Experience

MIDDLE TENNESSEE STATE UNIVERSITY Jan 2018 – Dec 2019

Graduate Research Assistant Murfreesboro, TN

•Translated business requirements to entity relationship diagrams and constructed a logical database

•Mapped the entity relationship diagram in Visio and ER Assistants for analysis

•Created triggers to update database systems as and when changes occurred.

•Drafted stored procedures to transform data using char, conversion, and date functions, such as regular expressions, concatenating, trimming, and padding values.

•Tutored students in Database management (SQL and Data Modeling)

•Transformed, cleansed, and validated data to be used for research

•Integrated data from multiple Excel sources into a master data set for report building

•Tutored students in Microsoft Access

•Tutored students in Math and Statistics

ONE GLORY FOUNDATION Oct. 2014 – March 2016

Business Intelligence Analyst Accra, Ghana

• Analyzed and utilized data to identify potential business opportunities as well as report outcomes.

•Involved in analytical projects that relate to business opportunities, financial reconciliation, and outcomes research.

•Translated business requirements into data driven reports/applications.

•Performed quantitative and qualitative analysis of data.

•Developed, enhanced and maintained data processing platforms and identified data disparities and actionable resolutions.

•Performed quality checks of all analytics queries, reports, and applications and identifies disparities and actionable resolutions.

NEWMONT GHANA GOLD LTD. Sep 2010– Sep. 2014

Database Administrator/Environmental Analyst Accra, Ghana

•Managed tasks and deliverables in accordance with company policies.

•Researched database issues and provided resolutions.

•Created and Managed the Database system

•Developed analytics for strategic decision making and to address deficiencies

•Suggested and made improvements to processes and tools used by the team.

•Followed-up and communications with vendor’s consultant to ensure timeliness and deliverables are met.

•Implemented WSF (Water Storage Facility) Special Livelihood Project.

•Carried out Environmental studies on the impact of the Subika Underground Mining on its surrounding areas.

•Supported in Land Acquisition

•Supervised BFMT (Business and Financial Mgt. Training)

•Conducted Safety Training and ensured the compliance of all safety regulations on site.

•Developed business development strategies to improve business performance.

Projects

Analyzed Government and company’s projects Using Excel and Tableau

•Cleansed large data sets and prepared for analysis

•Organized large data sets using V-Lookups and aggregated data using pivot tables

•Constructed reports and dashboards pinpointing sales trends with Tableau

System Analysis

•Developed use cases and test cases for software development

•Developed ERD’s (Entity Relation Diagram) and DFD’s (Data Flow Diagram) for software development

•Developed functional and non-functional requirements for software development

•Development of wireframes and Design Interphase Structure for software development

Database Design and Data Modeling

•Translated business requirements to entity relationship diagrams and constructed a logical database

•Mapped the entity relationship diagram in Visio and ER Assistants for analysis

•Created triggers to update database systems as and when changes occurred.

•Drafted stored procedures to transform data using char, conversion, and date functions, such as regular expressions, concatenating, trimming, and padding values.



Contact this candidate