Farooq Agha, Developer in Cary, NC, United States
Farooq is available for hire
Hire Farooq

Farooq Agha

Verified Expert  in Engineering

Database Developer

Location
Cary, NC, United States
Toptal Member Since
August 8, 2022

Farooq has worked in healthcare and higher education for the past 20 years. His most notable work is an online solution that provides back-end technology to the Community Care of North Carolina program. It received the prestigious Annie E. Casey Innovations in American Government Award from the Ash Institute at the Kennedy School of Government at Harvard University for its work in improving health care services for Medicaid and other populations.

Portfolio

Self-employed
Crystal Reports, Data Analysis, Data Reporting, Data Visualization...
Self-employed
Crystal Reports, ASP.NET, Custom Solutions, Database Development...
Self-employed
ASP.NET, Data Reporting, Database Development, T-SQL (Transact-SQL)...

Experience

Availability

Part-time

Preferred Environment

Microsoft, Google Data Studio, Microsoft Power BI, SQL Server Reporting Services (SSRS), Crystal Reports, Office 365, Excel 365, SQL, T-SQL (Transact-SQL), ETL Tools, SQL Stored Procedures

The most amazing...

...product I've developed is an electronic prescription writing software on handheld devices, HP Jornada 820, in 2001.

Work Experience

IT Consultant

2011 - PRESENT
Self-employed
  • Worked with several universities and colleges to improve their IT processes by performing data integrations, better reporting, and implementing third-party software.
  • Developed integrations between the student information system, student housing software, early alert system, learning management system, business and finance software, financial aid software, applicant CRM software, and advancement software.
  • Automated admission department processes to improve efficiency, reduce errors, and increase enrollment. Developed admission funnel reports for management.
  • Created compliance reports for the office of Institutional Effectiveness and Research for timely submission to state, federal, and local agencies.
  • Developed dashboards for enrollment, the business office, and the registrar in Google Data Studio. Used Power BI for data reporting and data analysis.
Technologies: Crystal Reports, Data Analysis, Data Reporting, Data Visualization, Data Integration, IT Consulting, Custom Solutions, Customer Support, Microsoft Power BI, Google Data Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), API Integration, SQL, IT Project Management, Business Intelligence (BI), Microsoft SQL Server, SQL Stored Procedures, APIs, JSON, T-SQL (Transact-SQL), Data Analytics

IT Consultant | Community Care of NC

2001 - 2010
Self-employed
  • Designed and developed a web-based patient case management system to manage a set of Medicaid patients.
  • Integrated a system with the estate Medicaid system to obtain monthly patient enrollment and claims data.
  • Enhanced a system to receive and process ED information from hospitals in electronic format.
  • Designed and built multiple databases on an SQL server platform to house patient demographics and patient electronic health records and data audits.
Technologies: Crystal Reports, ASP.NET, Custom Solutions, Database Development, Data Visualization, ETL Tools, Internet Information Services (IIS), Web Services, Server Management, Web Hosting, IT Consulting, SQL, Visual Basic .NET (VB.NET), IT Project Management, Data Analysis, SQL Server Integration Services (SSIS), Microsoft Access, Database Design, Microsoft Excel, ETL, Microsoft SQL Server, Data Pipelines, SQL Stored Procedures, T-SQL (Transact-SQL), Data Engineering, Data Analytics

IT Consultant

2001 - 2007
Self-employed
  • Designed and developed a secure web-based sample requisition and lab workflow system at CellzDirect.
  • Extended system to cover their USA and European operations.
  • Designed and built an SQL database to house sample and patient information as well as products created at the lab. Created ad hoc reporting solution for users to query databases on key data fields.
  • Created specifications and developed upload and transformation processes to upload lab data, which was stored separately in Excel spreadsheets.
Technologies: ASP.NET, Data Reporting, Database Development, T-SQL (Transact-SQL), IT Consulting, Tracking, SQL, IT Project Management, PostgreSQL, Microsoft SQL Server, SQL Stored Procedures, Data Analytics, Data Analysis

IT Consultant

2000 - 2007
Self-employed
  • Developed an online learning platform for behavioral health professionals in ColdFusion. The company was later acquired and evolved into Netsmart University.
  • Built a pathology lab software for sample intake and reporting. This reduced errors during intake, allowed better tracking of samples, and streamlined report availability via a secure online portal.
  • Enabled a healthcare client in North Carolina to have real-time data availability by generating schema-based XML data files from different data sources for ingestion by a third-party vendor software.
Technologies: T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), Office 365, ColdFusion, .NET 3, SQL Server DBA, Database Development, Custom Solutions, IT Consulting, Barcoding, XML, HIPAA Compliance, Reporting, Data Reporting, VB.NET, Web Services, Web Hosting, Server Management, SQL, IT Project Management, Microsoft SQL Server, SQL Stored Procedures, Data Engineering, Data Analytics, Data Analysis

Continued Learning

Designed and developed an online certification application offering online CEU courses and tests for behavioral health care professionals. It was used by over 25 organizations with nearly 2,500 users.

This system was developed using ColdFusion, XML, VB, and SQL Server 2000. It was later bought out by Netsmart Technologies and is now converted to Netsmart University.

NCCMIS

Designed and developed NCMIS, a web-based patient case management system used by 12 organizations in North Carolina.

Over 350 case managers, social workers, nurses, and physicians used it to manage more than 850,000 Medicaid patients. The system was integrated with the state's Medicaid enrollment and eligibility as well as Medicaid claims systems.

The system also received and processed ED information from hospitals in electronic format. It could accept and transform HIPAA X12N compliant claims data.

Hepatic Research Registry

Designed and developed a secure web-based sample requisition and lab workflow system for a multinational company, which provided fresh human hepatocytes frequently as suspensions and in multi-well plates.

Tools

Crystal Reports, Microsoft Power BI, Microsoft Access, Microsoft Excel, Flash

Languages

T-SQL (Transact-SQL), SQL, Visual Basic .NET (VB.NET), XML, VB.NET

Paradigms

Database Design, HIPAA Compliance, Business Intelligence (BI), ETL, Database Development

Storage

SQL Server Reporting Services (SSRS), Data Integration, Microsoft SQL Server, SQL Stored Procedures, SQL Server Integration Services (SSIS), SQL Server DBA, PostgreSQL, Data Pipelines, JSON

Frameworks

.NET 3, ASP.NET

Platforms

Microsoft

Other

Excel 365, Data Visualization, Data Reporting, Reporting, Customer Support, Google Data Studio, Office 365, ETL Tools, Data Analysis, IT Project Management, ColdFusion, Custom Solutions, IT Consulting, Web Services, Web Hosting, Server Management, Internet Information Services (IIS), API Integration, Tracking, Web UI, Web App Development, APIs, Data Engineering, Data Analytics, Barcoding

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring