Database Analyst
Resume:
Kunle Adeyemo
****************@*****.***
Professional Summary:
A dependable and diligent professional offering several years of diversified management / IT Experience.
Dedicated to achieving client satisfaction as well as meeting or surpassing company expectations. Strong rapport with personnel, client, and associates based on knowledge, professionalism, and integrity.
Manage multiple tasks, experienced in envisioning and implementing cost effective and result oriented strategy to create and boost awareness of business products and services.
Analytical Skills:
Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues.
Quickly learn and master new technology; equally successful in both team and self-directed settings; and proficient in a range of computer systems, tools and testing methodologies.
Understand the technical aspects of database organization, and how database organization affects computer and performance.
Good communicate with users to ensure that all of the data requirements are met in the database design.
Excellent experience as a leader and a computer technician and troubleshooting.
Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues.
Coordinator and monitoring the crystal report application
Ability to work closely with other department and ability to resolve issue.
Technical Skills:
System: Windows 2000 Server, Windows 2000 Professional, Windows NT/2000/XP/Vista/7/8, Windows Server 2007, Windows Server 2010.
Software: MS Project, MS Visio, Adobe Acrobat, Microsoft Office (2007, 2010, 2013) Management studio, SQL, EXCEL., Access, MySQL, Crystal Report, Expose to Power BI, SSIS Package, Management Console, ERP
Education:
Bachelors of Science in Accounting from Nigeria in 2010
Other Trainings
Therap Application, Peachtree accounting software, Epic systems
Professional Experience:
Changing Lives Today Atlanta, GA October 2018 to July 2019
Role: Database Analyst
Responsibilities:
Design table schemes, relation and permissions to ensure database integrity.
Write SQL queries to pull information and generate reports, build a new report for the user and maintain the crystal report application
Migrated pre-existing and legacy data from Excel to MS SQL Server
I improve and normalize data by performing quality control on data and data storage and enabling data access.
Created new tables, views, functions, triggers and store procedures.
Create scheduled jobs for nightly backup of the database.
Evaluating changes and updates to source production systems, master data, including creation, updates, and deletion.
Using Power BI to analyze data for business decisions
Contribute to project team efforts to ensure operational support requirements are implemented.
Schedule, monitor, and maintain database backup and recovery procedures which will protect the business.
Work closely with operations staff to ensure stable performance for the database environments, monitors, analyses, identifies and resolves bottlenecks and resolves problems.
Ensure change management procedures and methodologies are implemented and followed.
Ensure data pertaining to the status of problems and service requests is entered into problem tracking systems accurately and promptly on a daily basis; provide an up-to-date picture of service delivery status and backlog.
Ensure client/server applications run successfully/creating packages SSIS
Establishes and maintains adequate database documentation; enabling planning, diagnostics, and efficient resource allocation and utilization
Experienced in transactional (OLTP) and analytical (OLAP) data processing
Perform data integration using SSIS
Ability to manage crystal report application and maintaining each department report.
Follow all require and ability to coordination each department and educate how to use crystal report and recovery backup on crystal report.
Provide data, processing, analysis, and data visualization support to turn data into intelligence.
Ability to perform data modelling and profiling through ETL using SSIS
Exposed to data reporting using SSRS for business decision making
RHA Health Services, Atlanta GA August 2015 to March 2018s
Role: Database Analyst
Responsibilities:
Extensive knowledge and working experience of optimizing system and database
Extensive MS SQL Server Database Administration and Windows Server experience.
Experience of 3rd Party system and database, monitoring and reporting tools (Crystal Reporting).
Responsible for designing, developing and optimizing the Company database.
SQL report visual presentation using Power BI
Power BI various sources data presentation
Working closely with the technical department that oversees company database, website, a PHP site using MySQL as the backend
Responsible for creation of technical design Functional Specification Documents for Master Data Management Database
Work with development staff to document solution approach design.
Wellstar Hospital, Atlanta, GA January 2014 to February 2015
Role: Junior DBA
Responsibilities:
Provided constant online or on-call assistance to end users for handling their queries.
Maintained a backup and recovery option to retrieve the lost data.
Draw up disaster recovery plans for critical and non-critical databases.
Assisted in building strategies for installing and improving the database
Contact this candidate