Niranjan Prasad Ranganathan

• Implemented analytics frameworks, enhancing data visualization and analysis for dynamic instantiation, trial health status, clean patient tracking, and medical review listings.
• Developed and maintained Power BI dashboards, utilizing Power Query and DAX measures to streamline data reporting.
• Coordinated kick-off meetings, gathered requirements, managed timelines, documented processes, and analyzed issues to ensure project standards were met and solutions were effectively deployed.

• Analyzed standards code and gathered requirements for a migration project.

• Programmed a broad category of listing reports that are used in Data Management activities for at least 20 Sponsors.
• Adept in understanding Clinical Study Protocol and worked in requirements from various therapeutic areas such as Oncology, Cardio vascular, Asthma, Vaccine.
• Improved ability to work on multiple tasks at the same time without compromising timely delivery.
• Learnt how standard code behaves and worked on Standard Reconciliation listings that reconcile third party data with Clinical CRF data and lead the standard programming team.
• Implemented SAS Macro Programming Expertise to effectively reduce the number of lines of code and handle a pool of requirements with a few macro calls.

• Developed complex Patient profile and summary reports for high profile domains such as Oncology.
• Worked as an SDTM programmer for Clinical Study Data Tabulation activities developing SDTM Domains and validating them using Pinnacle OCV Validator tool.
• Utilized SAS loops, arrays, system functions, and options to streamline data processing.
• Developed various kinds of reports like Patient Profile, listing reports, Manual checks and Reconciliation listings for several therapeutic areas which would aid Data Managers in Data Cleaning and other Data Management activities.
• Worked as an L3 techno-functional analyst responsible for maintenance and administration of an Application that encompasses a variety of statistical suites such as SAS Web Studio, Python and R.

• Worked in creating POC’s for a number of process improvement tools which aided in Simplification of work allocation, specification review and simplifying project management tasks.