Seasoned professional boasting 20+ years of data analysis, software engineering and programming expertise.
工作经验
Senior Data Reporting Analyst
在
Centers Plan for Healthy Living
(2 年
1 月)
美国, New York
目前受雇于该公司自从 20181210 12:00 上午
- Creates KPI dashboards and analysis reports for finance, care management, regulatory and membership stakeholders
- Troubleshoots database content to ensure data accuracy
- Creates verification processes for data warehouse ETL loads
- Data analysis: analyze and visualize data to provide insights into KPI’s using tools including SiSense, SQL and SSRS
- Data curation: integrating data from different sources including internal applications, third-party data and public data
- Data validation: build processes to reconcile data used in BI tools with the system of truth
Senior Software Engineer
在
Freelance
(2 年
8 月)
中国, Shanghai
从 20160328 12:00 上午 直到 20181130 12:00 上午
Freelance Software Engineer, providing technical expertise on a variety of development projects.
- Developed and implemented ETL processes for a US-based healthcare information solution provider, DocEnable. Project was completed ahead of schedule and under budget.
- Built Mandarin flashcard app, enabling students to learn Chinese characters, pinyin, pronunciation, meaning and stroke order.
- Oversee the transition of IT responsibilities for AlphaCare (Magellan Health), providing guidance to former colleagues on project statuses, next steps, operational issues, and assisted with on-going development.
Director, Information Technology
在
AlphaCare (Magellan Health)
(2 年
11 月)
美国, New York
从 20130415 12:00 上午 直到 20160318 12:00 上午
Delivered technology support for the successful launch of four health insurance products within a five-month period. Support during the start-up phase included the setting up of AWS, development of custom ETL processes, execution of 3rd party software, and the purchase, configuration and installation of network and desktop hardware.
- Created and implemented cloud applications for AlphaCare, enabling field staff to spend more time with patients and less time on administration.
- Forged the development of a data warehouse that enabled actuaries and accountants to rapidly project future costs based on patient utilization, membership roster and claim cost rates.
- Designed dashboards, summaries, detail and reconciliation reports, maps and charts for management and staff of the Finance, Marketing, Claims, Enrollment and Provider Network departments; built utilizing SSRS, Crystal Reports and HTML/CSS/PHP/JavaScript/jQuery.
Vice President of IT
在
US Imaging Network
(4 年
2 月)
美国, New York
从 20090119 12:00 上午 直到 20130412 12:00 上午
Responsible for setting up all ETL processes and 3rd party applications for a new start-up, ensuring readiness for the first client implementation.
- Led the development of a browser-based financial modeler application, significantly reducing the amount of time taken to produce savings proposals based on customer membership rosters and claim data.
- Developed an application allowing Customer Service Representatives to update information from four different systems within a single browser window; built using jQuery, Google APIs, MS-SQL and MySQL databases along with a myriad of other tools.
- Directed the development of an application that automatically calculates commission payments, improving tasks which previously took days into a process that now takes minutes.
- Recruited, trained, and mentored a team of developers, experienced programmers, recent college graduates, and interns.
教育
Falkirk College of Technology (Forth Valley College)
SHND in Computer Data Processing in Computer Data Processing
(1 年
10 月)
英国, Falkirk
从 19830815 12:00 上午 直到 19850621 12:00 上午
Subjects included Practical Computing
Business Systems Analysis and Design
Computer Organisation
Computer Systems Design
Business Systems
Management Information Systems
Data Processing Management
Mathematics in Data Processing
Programming Languages and Techniques
System Design and Programming Project
Communication and Report Writing
Programming Languages and Techniques (Practical)
志愿者经验
Raised Guide Dogs
(4 年)
美国, New York
从 20101004 12:00 上午 直到 20141031 12:00 上午
Raised guide dogs from 12 weeks old to 18 months old. Attended weekly training classes and followed the training protocols.