Richard Frimpong: Database Developer in Dumfries, VA
Richard Frimpong
Database Developer
Dumfries | United States
Skills
No information
Interests
No information
Industries
No information
Summary
Activity
Projects
No information
Work experience
Dumfries Health Center
Database Developer | 08/2019 - Current
• provided hospital staff after Cerner Go-live support.
• Creating patient list, creating, and preparing patient discharge.
• Support in a primary care ambulatory setting.
• Actively troubleshoot any issues that arise during testing and production, catching and solving issues before launch.
• Test our system integrity, implemented designs, application developments and other processes related to infrastructure, making improvements as needed.
• Update our processes and design new processes as needed.
• Deploy product updates as required while implementing integrations when they arise.
• Automate our operational processes as needed, with accuracy and in compliance with our security requirements.
• Specifying, documenting, and developing new product features, and writing automating scripts.
• Manage code deployments, fixes, updates, and related processes.
• Offer technical support where needed, developing software for our back-end systems.
• Transform business requirements documents into technical specifications.
• Assisted the front desk on how to scan in epic using the media Manager.
• Using Epic super user supporting nursing staff and provider support with inpatient cliindoc, and Ambulatory clinic, applications along with providing elbow to elbow support to nurses for clinical documentation during Epic, Cerner, and McKesson conversion.
• Designed built and maintained backend database using Azure SQL Databases
• Developed Database Triggers, Views, Stored Procedures and Functions.
• Assisted with validation of the clinical workflows.
FVCbank
Data Analyst | Database Developer | 01/2017 - 08/2019
• Collaborate with customers (internal and external) to provide EDI solutions.
• Provide technical expertise and support for all company EDI.
• Define and implement strategies for eCommerce and for integrating EDI and non-EDI operating environments.
• Spreadsheet EDI migration from EDIHQ tool to a sterling b2b integrator.
• Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques.
• Responsible for Backup and Recovery, Monitoring, creating data from multiple systems and databases including SQL Server and Oracle to bring it into a centralized system.
• Created and populated Customer data using advanced SQL
• Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs
• Performs data analyzes and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using ERWIN.
• Maintained data consistency, SQL database integrity and reported instances of data corruption.
• Performed numerous data extraction requests involving SQL scripts.
• Performed data migration between different environments and Third-Party Databases.
• Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models.
• Performed data migration between different environments and Third-Party Databases.
• Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models.
Biogen Neuroscience
Tableau Developer | Data Analyst | 04/2015 - 01/2017
• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Vast experience with the design and development of Tableau visualization solutions.
• Ability to work independently or in a team setting.
• Generated advanced Tableau dashboards that allowed business to track and improve customer units KPI.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables, and Global Temporary tables.
• Developed dashboards in Tableau Desktop and published them in Tableau Server.
• Fulfilled numerous data requests for financial profiling.
• Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
• Creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
EXPERIENCE
Vinakom Communications
BI Developer | Data Analyst | 03/2013 - 04/2015
• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
• Used SAS to import and export data from and into SQL Server tables.
• Planned, analyzed and designed Universes using SAP Business Objects as per Business needs.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables and Global Temporary tables.
• Developed dashboards in Tableau Desktop and published them in Tableau Server.
• Fulfilled numerous data requests for financial profiling.
• Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2014 Reports Services (SSRS).
• Write reusable, testable, and efficient code using python.
• Design and implement of low-latency, high-availability, and performant applications
• Design and implement of low-latency, high-availability, and performant applications
Education history
No information
Connections
Companies (0)
No information