Adam Quane Email & Phone Number

Denver, Co, Us

Amarillo, Texas, Us

Cleveland, Ohio, Us

Tech: Python, SqlAlchemy (ORM), PostgresQL (PSQL), Docker, Amazon Web Services (AWS), Google Cloud Platform (GCP), Kubernetes, Elastic, MSSQL, SSRSBuild and maintained proprietary ETL pipelines and backend software to support file exchange and API integration for healthcare data and financial accounting systems. Worked as senior engineer on the core dev team, while managing our integration pipeline and building the requirements and architecture for programming our client and vendor integrations. Worked to scale and find solutions for a high volume of inbound/outbound jobs through caching patterns, file/row checksums, profiling/indexing, and other performant design patterns.

Cleveland, Ohio, Us

Waltham, Ma, Us

Built and maintained backend claims processing ETL application for 30+ Fortune 500 companies processing millions of claim lines / week· Built framework and pipelines for outbound enrollment/eligibility formats (csv, xml, json) in industry standard and custom formats.· Built framework and pipelines for inbound claims formats (cleansing, transformation, metadata) in industry standard and custom formats.Built, maintained, and consulted on hundreds of integration touchpoints with Alegeus platforms· Flat file inbound / outbound touchpoints with banking partners, health plan claims vendors, and third-party administrators to integrate funding, settlement, claims, eligibility, and other near real-time integrations.· API Integrations supporting real-time client and vendor web and mobile applications from administrative portals to account holder mobile experience.· Architecture, development, and consultation of ETL/API/SSO solutions with clients and third parties to develop and support internal and external integration requirements. Built, mapped, and maintained Enterprise Data Warehouse (EDW) for ops reporting and analyticsIdentified, analyzed, and built automation to remove redundant work across operations and other business areasDatabase and Systems Administration (Windows Server 2012 R2 | SQL Server 2017) Shifted data development team from waterfall SDLC to Sprint/Agile Methodology utilizing Azure DevOps tool and concepts of Kanban, scrumming, swarming, and sprint/PI planning.Primary technologies: SSIS, SSRS, SQL Server, T-SQL, Python, Rest APIs, Power BI, and PowershellSecondary Technologies: Linux, Docker, Tonic, C#, ASP.Net SOAP, PostgresQL, MongoDB

Waltham, Ma, Us

· Consult on software releases with product, development, and QA and document business requirements and test plans· Develop and maintain ETL solutions via SQL, SSIS, Python and other tools · Discovery, authentication, and mapping of SOAP and Rest API projects to standup and support client and third-party real-time web, mobile, and IVR applications· Architecture of useful and efficient solutions to conform or adapt client data models to internal models· Data cleansing, warehousing, architecture, and modeling for enterprise level ETL, file exchange, file transformation· Maintain data integrity through validation, auditing, and general process improvements· Manage batch file integration with bank / investment partners and other third-party partners· Write/manage SQL stored procedures and ad-hoc queries for ETL, dashboard, metric, and custom reporting.· Work with product to determine and build short term data solutions to bridge current functionality and road-mapped functionality for strategic clients

Waltham, Ma, Us

· Consult on software releases with product, development, and QA and document business requirements and test plans· Develop and maintain ETL solutions via SQL, SSIS, Python and other tools · Discovery, authentication, and mapping of SOAP and Rest API projects to standup and support client and third-party real-time web, mobile, and IVR applications· Architecture of useful and efficient solutions to conform or adapt client data models to internal models· Data cleansing, warehousing, architecture, and modeling for enterprise level ETL, file exchange, file transformation· Maintain data integrity through validation, auditing, and general process improvements· Manage batch file integration with bank / investment partners and other third-party partners· Write/manage SQL stored procedures and ad-hoc queries for ETL, dashboard, metric, and custom reporting.· Work with product to determine and build short term data solutions to bridge current functionality and road-mapped functionality for strategic clients

Waltham, Ma, Us

⦁ Work closely with engineering, development, and product management teams on technical escalations and product improvements.⦁ Review source code and application architecture to confirm application logic and identify defects⦁ Write advanced SQL queries for reporting and troubleshooting

Waltham, Ma, Us

⦁ Provides end-user support across the multi-tiered application ranging a wide variety of web and mobile applications.⦁ Writes advanced SQL queries and to both troubleshoot and audit database activity⦁ Analysis and troubleshooting of SOAP and Restful WebServices for internal and external applications. ⦁ Assesses needs of clients and internal employees to find creative solutions and identify defects in application code and logic.

Waltham, Ma, Us

⦁ Diagnose, troubleshoot, and resolve software application, data transfer, and connectivity issues related to service and product offerings.⦁ Work closely with engineering, development, and product management teams on technical escalations and product improvements.⦁ Document recurring technical issues to support product quality programs.⦁ Create documentation around support processes and issues usable by technical and non-technical users.⦁ Manage multiple customer cases simultaneously, ensuring all case-related information and activities are accurately documented, and providing timely progress updates to customers and account managers.

Us

· Data mapping of ambulatory patient medical record data from LMR (longitudinal medical record) to new Epic system.· Setup, implementation, and troubleshooting of networking and hardware needs at a variety of pop-up sites.· Developed and managed workflows for team to systematize workload across a variety of different schedules and roles.

Us

· Set-up and maintenance of decentralized inventory throughout hospital areas, including ICU, OR, and ED areas using EMR records, systems data, and a customized EDI process.· Used SQL to write and customize pharmacy database queries and generate specific reporting needs of the department.· Performed administrative functions to manage pharmacy systems user/permissions roles throughout the hospital to facilitate safety and security.· Maintenance and troubleshooting of pharmacy software/hardware systems as level I support.· Secondary Rx Systems Administrator covering vacation/absences and secondary support during go live days. Achievements· Going the Extra Mile GEM award for 2012 for excellence in pharmacy service.· Elected member of lean concept driven Rapid Cycle Process Improvement Committee from its induction May 2013-January 2015. Elected Committee Vice President September 2014.

Master Of Music, Jazz Guitar Performance

Bachelor Of Music, Music Theory And Composition