Shruti Gupta (immediate Joiner)

Project: ECHO

Project Description : Led a comprehensive project to streamline and optimize reporting processes for multiple ministries and over 50 hospitals, enhancing efficiency and accuracy in data management.

Role and Responsibility:

• Data Extraction and Analysis: Extracted data for ad hoc analysis based on business requests.
• Reporting and Visualization: Designed and maintained reports, dashboards, and visualizations to communicate findings.
• Data Aggregation: Aggregate data from diverse sources for comprehensive analysis.
• Data Integrity: Ensure data integrity through rigorous cleaning and preprocessing.
• Analysis, Documentation, and Validation: Conduct thorough analysis, documentation, and validation of business requirements to ensure alignment with stakeholder expectations.
• Project Leadership: Managed data analysis projects, including requirements gathering, data modeling, validation, and visualization.
• Stakeholder Communication: Simplified complex technical and architectural information for stakeholders, providing clear project schedules and estimates to ensure alignment and transparency.
• Service Management: Managed tasks, incidents, changes, and requests within ServiceNow application, guaranteeing timely resolution and uninterrupted service delivery.

Project: San Marcos

Project Description : Led healthcare data archival using Cerner CCL and SQL for migrating data to Harmony EMR, replicating Cerner EMR for clients. Possess extensive experience in patient data workflows, Developed reliable data pipelines and utilized ETL tools like SSIS for data conversion and transformation. Worked with prominent clients such as San Marcos Christus and Froedtert Holy Family.

Role and Responsibility:

• Data Migration and Archival: Facilitated accurate data transfer and storage for hospital records.
• Patient Data Workflow Management: Extensive experience with patient data workflows, including encounters, guarantors, self-pay, and claims.
• Team Leadership: Supervised a development team focused on view development and performance optimization.
• Client Collaboration: Worked closely with healthcare facilities to ensure successful project delivery.
• Customized Reporting: Delivered tailored patient data reports to clients, addressing their specific needs effectively.
• Software Enhancement: Continuously refined and upgraded existing software to improve performance.

Project: Consulting, AMS

Project Description : Introduced methodologies to enhance product customization in software development, working closely with clients to understand their reporting needs and automate report generation. Gathered and analyzed client requirements for new and enhanced reports, collaborated with the team to create a Power BI dashboard for KPI.

Role and Responsibility:

• Custom Report Creation: Developed over 10 custom reports to enhance scalability.
• Automated Reporting: Automated client report generation tailored to specific needs.
• Code Enhancement and Custom Report Development : Improved existing code and developed new custom reports to enhance scalability.
• Client Engagement: Delivered product demos and managed client interactions.
• Technical Issue Resolution: Debugged scripts to resolve client issues.
• Code Review and Testing: Reviewed code and performed functional testing weekly using Crucible software to ensure compliance with coding standards.
• Go-Live Support: Provided Go-Live support to clients.

• Developed and optimized procedure code for daily operations.
• Designed and modified database objects, including tables, views, and procedures.
• Automated monthly and daily reports using VBA macros in Excel, improving efficiency and reducing costs.
• Fulfilled ad-hoc data requests for internal business units and trusts.

Project: 813 - Bank of America

Role and Responsibility:

• Report Automation: Automated multiple reports, enhancing performance and reducing costs.
• Ad-Hoc Data Provision: Provided data support for internal business units and trusts.