Sean Connors Email & Phone Number

Tamworth, Nh, Us

Remote

Worked in Superset for data visualization creating charts, dashboards. Heavily utilized increasingly complex MySQL, subqueries, CTEs, stored procedures/functions, dynamic SQL.Became familiar with collaborative coding environments Jira, Slack, AWS, VsCode.Data mined large data sets such as revenue cycle management and evaluation data.Took 835 raw data tables and generated output to determine the claim(s) status and outcome. For claims that were not paid in full, we pulled out the CARC/RARC codes from several segment tables as well as the provider id/client for whom the codes were for so that the company could expedite re-submission of erroneous claims or fix issues with provider/client based insurability.Generated and utilized reusable dynamic sql function for presenting OTP line of business data allowing table(s)/column(s)/where clause(s) as parameters that allowed for expedition of new requests. Utilized this to generate highly specific biannual output format with ease. Automatically, frequently reported evaluations/consent forms missing, incomplete, or unsigned from all charts in KIPU based on complex, often recurring, timeframe requirements.

Extended systems I built for one subsidiary to all five centers under the parent company umbrella to streamline operations and extend efficiencies gained.Created census management system that Medical Record company was unable to generate due to certain demands, such as incorporating/displaying pending admissions, allowing multi-tiered bed availability/reservation, changing availability to various genders in multi gendered spaces based on current occupant(s), providing dynamic available bed listing on any given date based on genders, projected discharge dates, projected transfer dates of other in-census/pending-census clients.

Effingham, New Hampshire, United States

Completed Quality Assurance duties, such as incident reporting, audits, etc.Utilized Google Apps Script to connect medical record REST API systems and other APIs to automate and improve systems.

Effingham, New Hampshire, United States

Conducted transportation, medpass, and other direct care.Started building organizational systems during downtime.Researched Google Dev both outside of work hours and when other tasks were completed.

Effingham, New Hampshire, United States

Worked as co-supervisor for all locations.

Effingham, New Hampshire, United States

Direct care responsibilities with clients with maladaptive, unsafe behavior. Worked as location supervisor during most of this time.