• Develop stored procedures, ETL processes, extract reports for Sharecare clients who participate in wellness programs. This includes collection of participant encounter data as well as biometric data, both self-reported and lab results.• Conduct testing with SQL Server Integration Services (SSIS) and ad hoc T-SQL queries to ensure completeness and accuracy of encounter data and lab data, and success of downstream reporting to the client.

· Set up and maintained customer/client interfaces from a variety of client ERP systems to enterprise data warehouse and proprietary expense-tracking software, for reporting and data insight. · On-boarding new clients, installing and configuring synchronization tools on the client system, and setting up SFTP connections, to ensure smooth Extraction, Transformation, and Loading (ETL) of ERP data from client systems to the FleetCor data warehouse. · Designed field mapping between the client ERP system and the enterprise data warehouse, configuring custom interfaces for each client and ERP system. · Develop, adjust, and customize SQL queries for import and export datasets, to produce effective and accurate raw data extracts and external reports. · Monitor client data exchange, to ensure all connectivity, data transfer, and transaction processing continues to function smoothly and efficiently.

• Develop stored procedures and SSRS reports for a parts distribution start-up company, offering Business Intelligence insight for growth plans.• Exported T-SQL queries and reports to Excel for further management evaluation.• Developed formatted reports in Excel with SQL Server as backend.• Designed SQL Server Integration Services (SSIS) packages for file transfer tasks.• Imported raw data from Excel into SQL Server database tables.• Gathered requirements and developed T-SQL queries and stored procedures, producing several SSRS reports and charts for local church library inventory and check-out system (SQL Server back-end data).