Pranjal Tripathi

ACS Tableau Reporting.

• Managed Tableau Server environment, overseeing user administration, access control, and site creation for effective project segregation.
• Designed and deployed Tableau Cloud dashboards to monitor key clinical performance indicators, including 30-day readmission rates.
• Created interactive dashboards that enhanced decision-making capabilities for stakeholders.
• Analyzed data across various platforms in collaboration with business and technology teams.
• Optimized reporting processes, identifying opportunities to streamline operations and improve efficiency.
• Facilitated a productive work environment by resolving blockers that hindered innovation.
• Developed advanced Tableau dashboards featuring quick filters, context filters, parameters, and calculated fields for comprehensive data analysis.
• Utilized Tableau Bridge to secure access to clinical trial data, ensuring confidentiality and data integrity.

ClinRO-ePRO AWS Reporting.

• Collaborated with cross-functional teams to integrate AWS QuickSight solutions with existing systems, streamlining data accessibility and analysis for enhanced decision-making.
• Designed and implemented a serverless data pipeline using AWS services, enabling the efficient processing and analysis of large-scale ClinRO, and ePRO datasets.
• Developed real-time AWS QuickSight dashboards to track key business metrics, providing actionable insights for informed decision-making, and operational monitoring.
• Optimized Amazon EC2 and RDS instances using auto-scaling, enhancing cost-efficiency, and ensuring high availability for critical data analytics applications.
• Implemented multi-region deployment strategies for AWS infrastructure, minimizing downtime, and enhancing the performance and reliability of data analytics solutions.
• Utilized SQL to craft custom queries for efficient data extraction from designated sources, leveraging SPICE for enhanced data processing and performance within QuickSight.
• Developed complex SQL queries, incorporating views, joins, and subqueries, to perform advanced data analysis and generate comprehensive insights from ClinRO and ePRO data.
• Performed SQL transformations within Amazon RDS (PostgreSQL) to aggregate and prepare ClinRO (Clinic-Reported Outcomes) and ePRO (Electronic Patient-Reported Outcomes) data for visualization in Tableau.
• Designed a multi-region deployment strategy to ensure high availability and reliability of ACS dashboards, guaranteeing seamless access to critical data insights for stakeholders.

USA Refinance Analytics.

• Developed Tableau dashboards for USA Refinance market analysis, facilitating data-driven strategic decision-making.
• Created Customer 360 Dashboard to consolidate engagement metrics, providing a holistic view of customer interactions.
• Built Home Sellers vs. Buyers Analysis dashboard to visualize market trends, informing refinancing and mortgage strategies.
• Designed Refinancing Options & Home Appreciation Trends dashboard to deliver insights into regional financial dynamics.
• Optimized Web Data Connectors to manage large datasets efficiently, ensuring seamless integration and optimal performance.
• Established automated alerts for tracking mortgage rate fluctuations, enabling proactive market response.
• Utilized diverse Tableau functionalities to extract insights from financial data and create impactful visualizations.

• Resolved software issues to ensure seamless operation of Practice Management software.
• Provided technical support to end-users, troubleshooting application-related challenges effectively.
• Delivered training on software utilization, enhancing user efficiency and productivity.
• Debugged and troubleshot PM software applications across various functionalities.
• Analyzed data to generate detailed reports, offering insights into demographics and clinic performance.

• I worked as a consultant on the ISG project.
• Using SQL and Linux to troubleshoot the issues.
• Handled various banking and finance applications for clients.
• Majroly worked with the downstream and upstream clients for a smooth transfer of data.
• Leveraging SQL to get the required data and reports for the client.