詹姆逊埃奇沃思, Developer in Birmingham, AL, United States
詹姆逊 is 可用 租用
雇佣 詹姆逊

詹姆逊埃奇沃思

验证专家  in 工程

数据库开发人员

位置
Birmingham, AL, United States
至今成员总数
2022年6月22日

詹姆逊 brings together a blend of business knowledge and mathematics. With skills in data modeling and statistical analysis, 詹姆逊 has helped companies from small businesses to the Fortune 500 understand their business operations and analyze trends through data.

数据仓库工程数据SQLBusiness Intelligence (BI)Microsoft ExcelETL数据可视化数据分析数据查询数据分析数据库Microsoft SQL ServerSQL性能t - sql (transact - sql)C++权力BIAzure数据工厂达克斯

Portfolio

英里的技术
Microsoft 权力BI, SQL, 达克斯, Azure数据工厂, IT咨询...
Auto-owners保险
Business Intelligence (BI), 应用数学, SQL...

Experience

数学- 10年统计- 10年SQL - 8年Microsoft Excel - 8 yearsBusiness Intelligence (BI) - 8 years工程数据 - 7 years数据仓库 - 7 yearsETL - 7年

Availability

兼职

首选的环境

SQL, 窗户, Relational Database Design, 数据库, Microsoft SQL Server

最神奇的...

...challenge I've faced is to build a predictive sales forecasting model using actuarial data science techniques.

工作Experience

Business Intelligence Consultant

2021年至今
英里的技术
  • Met with clients to discuss business intelligence and data warehousing solutions. Recommended software and best practices for clients' reporting needs.
  • Developed a data warehouse and reporting solution for nursing homes to track patients enrolled in Medicare and when they are paid.
  • Built a data warehouse and reporting solution from a company's internal ERP system to track sales and company productivity.
  • Created a reporting solution for an energy company to track energy prices over time.
  • Wrote documents for managing and developing a business intelligence project for clients from the consulting side.
Technologies: Microsoft 权力BI, SQL, 达克斯, Azure数据工厂, IT咨询, Relational Database Design, 数据库, 数据分析, Microsoft SQL Server, 数据可视化

高级数据分析师

2014 - 2021
Auto-owners保险
  • Created reports with SSRS and 权力BI, mainly working with the company's marketing and sales group to help analyze production numbers, determine the best marketing strategies, and analyze competitiveness in the market.
  • Developed SQL databases and ETLs around insurance quoting, including creating a data warehouse from multiple data sources so the company could request new robust reporting solutions.
  • Helped lead the project for designing and developing a new customer portal website as a business analyst. Gathered requirements from stakeholders, conducted market research on website designs, and helped developers plan Agile workloads.
  • Assisted in actuarial ratemaking by reporting on sales figures and the company's competitiveness in the market.
  • Trained newer developers in SQL Server and best BI practices and technologies.
Technologies: Business Intelligence (BI), 应用数学, SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), 保险精算, ETL, 工程数据, 数据仓库, Microsoft Excel, 统计数据, Microsoft 权力BI, Relational Database Design, 数据库, Excel宏, 数据分析, Microsoft SQL Server, 数据可视化, 数据科学, 数据分析, 数据查询, 性能调优, SQL性能, t - sql (transact - sql)

Data Warehouse for Insurance Quotes

Designed the structure and built the ETL to load a data warehouse for insurance quotes. Data involved seven different sources that needed to be compiled daily for reporting needs.

Spoke regularly with the company's users to determine the requirements of the model and eventual reporting needs.

Custom Reporting Solution for Nursing Homes

Worked on a custom reporting solution for nursing homes to track patients eligible for Medicare payments and when those payments come in.

Developed a data warehouse to track patients, medical diagnoses, and Medicare payment forms. Created several 权力BI reports that would be embedded in an extensive web application. Secured reports and sensitive data based on the user who was logged in.

Corporate ERP System to Data Warehouse

Designed a data warehouse based on a company's ERP system.

Used Azure数据工厂 to read from the system's API and transformed it into useable data for reporting. Built 权力BI reports to track the company's sales and performance daily. Communicated with company executives to gather reporting requirements and present solutions.

语言

SQL, C++, t - sql (transact - sql), Python, C#.网

工具

Microsoft Excel, Microsoft 权力BI

范例

Business Intelligence (BI), ETL, 数据科学

其他

应用数学, 统计数据, 数据仓库, 工程数据, Relational Database Design, 数学, 计算机科学, 保险精算, 达克斯, 敏捷冲刺, Excel宏, 数据分析, 数据可视化, 数据分析, 数据查询, 性能调优, 微软Azure, Azure数据工厂, IT咨询

存储

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), 数据库, Microsoft SQL Server, SQL性能, SQL Azure

平台

窗户

2009 - 2013

Bachelor's Degree in 数学

Lawrence Technological University - Southfield, MI, USA

有效的合作

如何使用Toptal

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

1

分享你的需求

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

选择你的才能

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.

开始招聘