Software Business Analyst
• Translated requirements for user warehouse workflows and analytical operations into technical specifications, identifying initial SQL and other data sources , describing the alteration of data, and describing the output to be stored• Provided data design requirements for a real-time warehouse management system (WMS) built to support lot and serialized tracking compliant with the Drug Supply Chain Security Act (DSCSA)• Created user interface wireframes and user testing scenarios and ensured software met drafted acceptance criteria • Established user feedback loops throughout the requirements solicitation process, design, and development• Diagnosed and repaired faulty data extract, transform, and load (ETL) undocumented procedures responsible for data warehousing and reporting• Produced documentation detailing business-critical SQL Server Reporting Services (SSRS) reports and subscriptions detailing purpose, parameters and their meaning, and impacted clients• Establish documentation cataloging all legacy data stores dating back to 2000, their purpose, and subscribed services• Evaluated complex regulatory requirements established under FDA’s Title 21, including the Drug Supply Chain Security Act (DSCSA), current goods manufacturing practices (cGMP), Part 11 – Electronic Records; Electronic Signatures to deliver comprehensive requirements• Gathered requirements for prescription drug claim repricing systems, which upon delivery was used to win sales exceeding $5 million in annual recurring revenue. This involved: ◦ Reverse engineering of drug pricing algorithm written in C used to deliver customer specific and agnostic pricing based on over 13 factors in over 30 code files ◦ Establishing mapping requirements for data ETL pipelines required to stage data used to create pricing ◦ De-identifying protected health information (PHI) in accordance with the Health Insurance Portability and Accountability Act (HIPAA)