ROMA VACHHANI

San Diego, CA https://www.linkedin.com/in/roma-v-2b393414/ US Citizen

With a proven track record in clinical systems management, data engineering, and healthcare analytics, I bring over 8 years of diverse experience in leveraging technology to drive operational efficiency and improve decision-making processes in the pharmaceutical and healthcare industries. As a Clinical Systems Manager at Ionis Pharmaceuticals, I spearheaded the development and deployment of numerous studies on BioClinica OnPoint application and the CTMS SharePoint site, alongside initiating and supporting integration jobs crucial for data initiatives. My role extended to actively designing and implementing automated Power BI dashboards, ensuring real-time insights into clinical data, and streamlining processes through comprehensive data flow diagrams. I take pride in maintaining and enhancing clinical data systems support processes, driving efficiency and accuracy across various departments. Prior to this, my tenure as an Analyst in Clinical Data Systems underscored my ability to monitor integration jobs, resolve data issues, and develop new studies, contributing significantly to operational effectiveness. My expertise in documentation and process improvement was evident in the creation of CTMS process documents and integration issue handling documents, laying a strong foundation for seamless operations. In my remote role as a Data Engineer at Premier Healthcare Management, I demonstrated proficiency in EDI file processing, business intelligence tools, and Python scripting, delivering solutions that optimized data management and reporting processes. Similarly, my experience as an EDI Analyst at Community Health Group honed my skills in analyzing and troubleshooting healthcare transactions, implementing automated reporting solutions, and ensuring compliance with regulatory standards. Furthermore, my engagements with Inland Empire Health Plan, Common Securitization Solutions, CVS Health, and Hewlett Packard Enterprise enriched my expertise in healthcare data analytics, project management, and stakeholder collaboration. I successfully led projects, streamlined processes, and delivered actionable insights through advanced data analysis and visualization techniques. I thrive in dynamic environment where I can leverage my technical acumen, analytical skills, and collaborative mindset to drive organizational success. I am passionate about harnessing data-driven insights to optimize processes, improve patient outcomes, and contribute to the advancement of healthcare. Looking ahead, I am eager to explore new opportunities where I can continue to make meaningful contributions at the intersection of technology and healthcare.

Let us connect to explore potential collaborations or discuss how I can support your organization in achieving its objectives.

AREAS OF EXPERTIZE

• Languages: Python Scripting

• IDEs: Eclipse, Microsoft Visual Studio, IBM Rational Application Developer,

• Business Intelligence Software: Tableau, PowerBI

• DB Tools: SQL Server Management Studio (SSMS), SQL Server Reporting Services, (SSRS), SQL Server Integration Services (SSIS), TOAD

• Microsoft Tools: MS Office, MS Project, MS Visio, MS SharePoint

• Other: VMWare, Jira, Rally, Teams, Slack

• Operating Systems: MS-DOS, MS Windows (XP, Vista,7, 8), Windows Server (NT, 2008,2012), Linux

• Methodologies: Scrum, Agile

ROMA VACHHANI 626-***-****

Data Science Professional ad4ww0@r.postjobfree.com EDUCATION

Bachelor of Science, Computer Science (2015)- Kean University, NJ CERTIFICATIONS AND TRAINING

• PowerBI Fundamentals Training

• PowerBI Advanced Training

• Programming for Everybody (Getting Started with Python)

• Python Data Structure

EMPLOYMENT HISTORY & DETAILED WORK EXPERIENCE

Clinical Systems Manager, Ionis Pharmaceuticals, CA (06/22- Present)

• Designed and developed 8-12 new studies utilizing the BioClinica OnPoint application and the CTMS SharePoint site, including 5 Phase 3 Trials, 3 Phase 2 Trials, and 3 Phase 1 Trials.

• Initiated 20-30 new integration jobs annually (CRO, IXRS, EDC) to bolster data initiatives within the CTMS.

• Provided support for over 75 integration jobs (IXRS, CRO, eDC & RAVE) and meticulously monitored their schedules and data loading processes.

• Implemented 7 Natural History studies within the CTMS, overseeing the manual monitoring and weekly updates of Subject and Visit data.

• Ensured Ionis personnel had requisite permissions and security access to Clinical Operations systems and processes.

• Independently troubleshooted and resolved 40+ integration data issues in collaboration with internal and external stakeholders.

• Managed the initiation and termination of studies post-DB review by liaising with relevant vendors.

• Proactively monitored and updated Site/Subject Planning projections, Country Milestones, and missing Expected Screen Fail Rate/Expected Early Term Rate within the CTMS.

• Actively designed, developed, and supported an automated Power BI dashboard for MRL data analysis.

• Updated and maintained CTMS process documents as required, creating new documents when necessary.

• Constructed a data flow diagram of the Clinical Operations Dashboard to enhance understanding of the back-end process.

• Revised CTMS and Clinical dashboard reference guides, training materials, and data-entry specifications for Clinical Operations.

• Designed and monitored a "weekly integration report update" to track integration job schedules and unresolved errors.

• Developed and managed a "Data Issue Tracker" to monitor active, pending, or resolved data issues and communications with stakeholders.

• Collaborated in the transition of Files.com migration to an internal sFTP solution (Azure sFTP), ensuring seamless data transfer processes.

• Assisted in the CTMS decommission process by mapping source-to-target data between the new system and Enrollment studies files.

• Contributed to the Sitero migration process by creating test plans and testing the new URL with a new domain name.

ROMA VACHHANI 626-***-****

Data Science Professional ad4ww0@r.postjobfree.com Hardware/Software: On-Point (BioClinica), CTMS SharePoint Site, BioClinica Integration report, Veeva Vault, Power BI

Analyst, Clinical Data Systems, Ionis Pharmaceuticals, CA (06/21- 06/22)

• Provided daily support for over 40 integration jobs, ensuring smooth operations, and promptly addressing any data issues or job interruptions with vendors.

• Successfully resolved more than 20 data integration errors, ensuring seamless flow of data within the system.

• Designed and implemented 4-6 new studies on the BioClinica On-Point application and the CTMS SharePoint site, contributing to the expansion of research initiatives.

• Initiated 8-10 new integration jobs (CRO, IXRS) to enhance data management capabilities within the CTMS.

• Developed a standardized template for the implementation of Natural History studies in the CTMS, streamlining the study setup process.

• Created comprehensive documentation for CTMS processes, including:

- Study intake sheet based on relevant study protocols.

- Study documents for the Bioclinica On-Point application and the CTMS SharePoint site.

- Program document for the CTMS SharePoint site.

- Integration issues and error handling documents to address any integration errors efficiently.

Hardware/Software: On-Point (BioClinica), CTMS SharePoint Site, BioClinica Integration report, Veeva Vault, Power BI

Data Engineer (Remote), Premier Healthcare Management, CA (05/20- 02/21)

• Developed mapping and parsing algorithms to efficiently handle 837 EDI files sourced from diverse medical practices.

• Utilized Business Intelligence tools such as Tableau to cater to the analytical requirements of the business.

• Engineered a Python script to parse raw roster CSV files, cross-referencing expected labels with in-house mapping spreadsheets to promptly identify and notify staff about missing labels.

• Conducted quality assurance checks on four Uniform Data System (UDS) instances, ensuring that each metric adhered to the correct parameters of age, CPT codes, and date of service for patient qualification.

• Implemented a systematic process of downloading monthly member rosters from various portals and seamlessly uploading them to AWS S3. Subsequently, orchestrated ETL cycles to retrieve data from S3 and store it in the Business Intelligence database, facilitating diverse reporting needs.

• Executed a monthly process through a Python script to exclude providers flagged by the Office of the Inspector General (OIG) from federally funded healthcare programs, ensuring regulatory compliance.

• Formulated intricate and dynamic SQL queries using Workbench to extract dental claims, tailored to meet specific business requirements.

Hardware/Software: Tableau 2020.2.1, Python 2020.1.2, Jupyter notebook, Tableplus (Version 3.12.0), MySQLWorkbench 8.0, AWS S3, Navicat for MYSQL

ROMA VACHHANI 626-***-****

Data Science Professional ad4ww0@r.postjobfree.com Electronic Data Interchange Analyst (EDI), Community Health Group, CA (09/19- 05/20)

• Conducted thorough analysis, processing, and troubleshooting of HIPAA/EDI X12 ANSI 5010 healthcare transactions, encompassing a wide array of transaction types such as 837, 999, 277CA, 835, 834, 820, 274, 278, 270 – 271, 276 – 277, Type 110, and Type 23-24.

• Designed, tested, and implemented EDI components facilitating seamless communication between QNXT and CHG systems, ensuring optimal functionality and data integrity.

• Played a pivotal role in the planning and implementation of HL7 FHIR, contributing to the enhancement of interoperability and data exchange within healthcare systems.

• Engaged in the development of RAPS and RISK Score Ad-hoc reports, providing valuable insights to inform strategic decision-making processes.

• Automated Tableau dashboards to visualize and analyze CHG revenue calculations, streamlining reporting processes and enhancing data-driven decision-making capabilities.

• Utilized Tableau to generate reports and implemented automation to streamline report generation processes, improving efficiency and accuracy.

• Developed stored procedures for daily production reports, leveraging Visual Studio 2017 and deploying reports on SSRS production servers for dissemination to relevant business teams.

• Designed complex dynamic SQL queries for the Drg_Audit report, utilizing Visual Studio to accommodate various parameters and deploying reports on SSRS production servers for auditing purposes.

• Automated production reports using SQL Server V18.2, optimizing reporting workflows and ensuring timely delivery of critical information.

• Converted and automated the ClaimEdit & Claim Refresh query into a stored procedure automated through SSRS with scheduled delivery to facilitate efficient reporting.

• Played a key role in the rewrite project for DHSC - 834, creating data mapping documents and testing against established mapping standards to ensure data accuracy and compliance.

• Developed data mapping documents for NCPDP using the NCPDP Post-Adjudication Payer Sheet – Implementation Guide version 4.2, contributing to streamlined data processing and adherence to industry standards.

• Created an interactive Excel dashboard to monitor and track daily 837 file status, utilizing pivot tables to provide actionable insights into file processing status.

• Provided detailed research and analysis on Finance team's concerns regarding duplicate data, facilitating informed decision-making and process improvements.

• Collaborated with trading partners, including Clearinghouses and Providers, to ensure data accuracy and processing efficiencies, fostering strong partnerships and adherence to industry standards.

• Coordinated EDI trading partner implementations, ensuring compliance with guidelines, specifications, and policies to facilitate seamless data exchange.

• Assisted in configuring SFTP accounts, enhancing data security and facilitating secure data exchange processes.

• Monitored Core Administrative Payment Software Vendor's site for updates and defects, ensuring system integrity and functionality.

• Provided ad-hoc data and reports as requested, supporting organizational decision-making and operational requirements.

• Tested Information Systems (I.S.) monthly maintenance system, ensuring system reliability and performance.

Hardware/Software: BizTalk, QNXT, TIBCO, Tableau, SSRS, MS SQL Server V18.2, Visual Studio 2017 – Version 15.9, Ultra Edit

ROMA VACHHANI 626-***-****

Data Science Professional ad4ww0@r.postjobfree.com Healthcare Data Analyst, Inland Empire Health Plan, CA (10/18- 09/19)

• Generated and curated reports to bolster support for IEHP’s clinical and provider units, leveraging an array of analytics and data mining tools such as Microsoft Applications (including MS Access), and system-specific reporting tools like MedHOK.

• Employed timely and precise data mining techniques to develop new reports or refine existing ones, ensuring that data analysis consistently led to actionable insights.

• Applied analytical acumen to identify and implement solutions for various challenges, contributing to the resolution of issues and optimization of processes.

• Assessed report requests to ascertain the requester’s needs and objectives, meticulously determining the appropriate methodology for data extraction, including selecting data sources and criteria. Ensured that delivered reports were accurate, delivered on time, and formatted appropriately to meet stakeholders' expectations.

• Designed and implemented an MS Access database for the internal team, facilitating the management of doctor appointments and the collection of patient charts from doctor's offices. This database enabled the generation of appointments, compiled lists of patients assigned to doctors, and provided the team with the capability to fax documents individually or in bulk to doctor's offices prior to appointments. Hardware/Software: MS Access, Tableau, MS SQL Server, T-SQL Data Analyst Consultant, Common Securitization Solutions, CA (03/18- 09/18)

• Utilized Rally to craft User Stories/defects, addressing emerging business needs and operating within the SCRUM methodology.

• Supported the development process by assisting in the creation of conversion scripts, facilitating the seamless transfer of source files into target tables using SQL-loader, and employing PL/SQL blocks to execute scripts and manage data flow efficiently.

• Ensured data accuracy and integrity by updating the computability matrix through meticulous validation procedures.

• Contributed to business analysis efforts by assisting in the collection of requirements from diverse teams, identifying AWS tables overloaded with data using various KPIs, and presenting comprehensive reports to engineers and the data service group for archival purposes. Hardware/Software: Informatica Power Center 9.5/9.1, Oracle 11g, MS SQL Server 2012/2008, T-SQL, PL/SQL, Agile Methodology, Rally (Ticketing System)

Data Analyst/ Deployment Lead Consultant, CVS Health, RI (09/17- 01/18)

• Spearheaded the establishment of programs and processes aimed at optimizing training and documentation practices, significantly reducing stress and redundancy. Engaged closely with key stakeholders, including system owners and end-users, to define business, financial, and operational requirements, as well as system goals, effectively addressing any system issues that arose.

• Developed and delivered Oracle/Tera data-based reports to meet the informational needs of business users. Oversaw the management of UNIX jobs to facilitate the loading or extraction of data from the CVS retail data warehouse.

• Conducted comprehensive analysis to gather and document both functional and non- functional business requirements. Provided essential support to the ETL team by facilitating ROMA VACHHANI 626-***-****

Data Science Professional ad4ww0@r.postjobfree.com the creation of ETL mapping documents and assisting the testing team during User Acceptance Testing (UAT).

• Formulated project turnover kits, IQOQ documentation, and back-out plans to ensure the smooth transition of information for production support and deployment steps.

• Demonstrated proficiency in designing PL-SQL programs and traceability matrices tailored to various ETL requirements. Effectively communicated data flow diagrams to stakeholders, ensuring a clear understanding of the processes involved in maintaining the CVS retail data warehouse and pharmacy systems.

• Collaborated closely with team members to implement and deploy changes in existing data marts, subsequently submitting release notes upon the successful completion of each project.

• Experienced in the creation, issuance, and troubleshooting of tickets using Team Track, a robust ticketing system.

Hardware/Software: Informatica Power Center 9.5/9.1, UNIX, Oracle 9i/10g, Teradata 12.0/14.0, Toad for Oracle, PL/SQL, Control M, Team

Data Analyst, Hewlett Packard Enterprise, RI (04/16- 09/17)

• Developed and implemented a range of statistical reports utilizing Tableau, incorporating interactive views and diverse chart types to enhance visualization for Medicare and Medicaid managed care data. Identified and resolved data or report issues, assessed alternative solutions, and implemented effective resolutions.

• Played a pivotal role throughout all phases of project life cycles, from analysis and development to testing, deployment, post-production support/maintenance, documentation, and end-user training, ensuring project success and user satisfaction.

• Produced documents, data mappings, packages, and scenarios for all ETL (Extract, Transform, Load) routines, ensuring seamless integration of all interfaces. Streamlined and refined data processes to uphold data integrity and validity, delivering accurate reports to users.

• Designed, developed, and executed complex SQL queries using Toad for Oracle 10.6, extracting Pharmacy and Dental claims for managed care and Fee-for-Service claims as per client specifications.

• Created various extractions utilizing ICD 9, ICD 10, and CPT codes to extract pertinent claims information based on business requirements.

• Provided data extractions in compliance with HIPAA regulations to the Rhode Island (RI) Attorney General’s Office and NAMFCU, organizing dimensions and fact tables to facilitate complex data mapping and report design.

• Offered support to management in organizing universes for claims, providers, and MCO

(Managed Care Organizations) to optimize performance and resolve issues using SAP Business Objects tools like IDT and UDT.

• Collaborated with project managers, business analysts, and end-users to understand and modify universes and reports, enhancing data collection procedures and ensuring timely report generation.

• Leveraged Microsoft suites of products to create diverse flowcharts and complex financial reports, including budget and audit reports. Established, documented, and implemented data controls to effectively administer departmental online data processing systems. Hardware/Software: Informatica Power Center 9.5/9.1, Oracle 11g, PL/SQL, Toad, Tableau, MS Excel, SAP Business Object

Contact this candidate