Data Civil Engineering
Resume:
John Adewumi
857-***-**** *************@*****.***
Professional Summary
Experienced Data Analyst with 6+ years of diverse experience in database design and administration, data modeling, data warehousing, Enterprise Systems Architecture and Business Intelligence (BI). Extensive technical skills and advanced understanding of Metadata, SQL Server, Data modeling. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.
Skills
Data Analysis
Data Modeling
Agile project delivery
Tableau Developer
Project Management
SQL
Python
Vertica data warehousing
Extract, Transform, Load (ETL)
Business Analysis
Power BI
Activity diagrams
Work History
Database Analyst/Development Manager, 09/2016 to Date
Concierge Services, Inc – Boston, MA
Used SQL & Python to fetch different data for the business report from the database.
Provide technical assistance with respect to data input, reports, reporting tools and grants management systems
Data analysis with Tableau for creating forms of dashboards and worksheets.
Use Power BI to transforms and model data needed for business decisions
Design data models and statistical frameworks integrating financial and operational performance data
Improved Business profits by critical analysis of business reports.
Transferred between spreadsheets to SQL and Tableau dashboards for analysis use
Identifying ways to save money by analyzing business processes
Acquire data from primary or secondary data sources and maintain databases/data systems
Design and develop Scripts and Programs required to extract, transform, clean, and move data, in a manner that quality data can be loaded into the Data Warehouse
Execute monthly executive reporting and visualization, locate and define new process improvement opportunities.
Develop and maintain analytic content for individual contributors, managers and executives
Organized Sprint top analyses problems and backlogs in ongoing projects.
Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas
Data/Site Development Engineer, 07/2015 to 07/2016
Huawei Technology – Enugu, Nigeria
Prepared diagrams, charts and surveys showing information about job locations and project scopes
Execute monthly executive reporting, and effectively communicate trends through visualization.
Used Python to assess database and customizing different database
Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems
Data/Site Engineer, 01/2012 to 07/2015
Kayalot Konsult Ltd – Ondo, Nigeria
Used SQL to query detailed records of daily progress, incidents and issue resolutions
Recorded daily events and activities in site diary to evaluate process and improve productivity
Prepared site reports and organized subcontractor invoices, codes documentation and schematics
Prepared master schedule to track project deliverables and meet key milestones
Credit Risk Analyst, 09/2009 to 09/2011
Zenith Bank Plc – Lagos, Nigeria
Used Tableau to create approval presentation of over 500 clients.
Conversion of all collateral document to virtual data base vault for easy access to work on loan approvals
Created vault file database by matching all documents for each customer together
Created loan quarterly review database
Optimized credit approval and collection processes, improving operational efficiencies by over 60%
Education
UDEMY: Introduction to Python, Python for Beginners, Tableau Training for Data Science, Master Tableau in Data Science
365 Data Science: SQL, Introduction to Data and Data Science, Git and GitHub
Harvard Online University (HarvardX): Data Science Visualization
ScrumStudy: Scrum Fundamentals Certified
American Academy of Project Management: Masters Project Management
Federal University of Technology, Akure - Master of Engineering M.Eng: Structural Engineering, 2016
Federal University of Technology, Akure -Bachelor of Engineering (B.Eng: Civil Engineering, 2009)
Contact this candidate