Bhanu Garg

Migration of reporting platform into AWS based Data lake and generation of Business critical reports and Dashboards

• Held Joint Application Design sessions for gathering requirements for Drug Utilization and Drug Switch Sequencing Dashboard
• Lead the business and data analysis function for a 2-to-5-person analysis team of a large data and analytics program.
• Lead the planning and execution of the analysis team, hands on creation of reporting/analytics and data requirements documentation, and initial profiling of source data.
• Perform source data analysis using PostgreSQL, understand the current data structure, find gaps and recommend solutions for reporting requirements.
• Collaborate with data architects, modelers, other analysts, and business users/stakeholders to elaborate requirements which represent project data requirements, business process models, and complex business hierarchies.
• Collaborate with delivery teams as they develop, test, and deploy solutions to ensure requirements are correctly interpreted.
• Use JIRA to articulate assigned work/tasks/stories , and provide project status to lead architects, project managers, and business stakeholders.
• Aggregate status from the team and communicating status to project leads/managers , architects, and business stakeholders.

Enhancement in the CTMS system by updating the Clinical Trip report templates and Subject Visit Templates

• Facilitated requirement elicitation sessions, fostering collaboration among diverse groups of stakeholders.
• Resolved ambiguities in requirements documentation, promoting clarity within technical teams and reducing rework efforts.
• Conducted impact assessments for proposed changes, minimizing disruptions to ongoing projects.
• Managed requirement traceability, ensuring alignment across all stages of development and testing activities.
• Increased customer satisfaction through consistent engagement and proactive issue resolution during the project lifecycle.

Automation of Regulatory Single Channel Communication process using PEGA BPM

• Conducted interviews with key business users to collect information on business processes and user requirements.
• Improved business processes by analyzing current practices and recommending optimization strategies.
• Collaborated closely with management to drive strategy through development and implementation of new processes
• Documented procedures and business processes and shared information with appropriate stakeholders.
• Collaborated with business and data migration team to migrate the legacy data into new PEGA application.
• Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.

Automation of MedDRA indication entry into Regulatory Tracking system (90% automation) using BluePrism

• Conducted interviews with key business users to collect information on business processes and user
  requirements.
• Performed gap analysis procedures and detailed data reviews to optimize implementation.
• Assessed impact of current business processes on users and stakeholders and evaluated potential areas for improvement.
  • Worked closely with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.
• Achieved 90% success rate in data entry automation by RPA Bot by analyzing exception scenarios and take corrective action.

Regulatory Content Migration from partnering/acquired organization

• Strategize data integration of acquired data by developing a Data.
• Collection template to capture a unified view of migration efforts involved including which regulatory systems, migration complexity and high-level estimation.
• Design the data enrichment approach based on excel templates to standardize data analysis and migration of data for Regulatory systems.
• Worked on various regulatory systems including Regulatory Product Registration, eCTD Submissions, Archival, Clinical Registry and TMF archival system.
• In depth analysis of client's Liquent Insight Product Registration and Submission system and become a SME for entire Regulatory migration systems.
• Responsible for submitting Status Reports to management summarizing completed Milestones and Tasks for the migration.
• Attribute mapping with legacy metadata in excel templates and data transformations based on business rules.
• Review and finalize the enriched datasheets with SMEs to be handed-off to the support team for migration

Migration content from an acquired organization to its Documentum system

• Conduct walk-through, requirements gathering meetings and work with the stakeholders to ensure business needs are met.
• Act as a subject matter expert when the business requirements changed, and determine how the changes impacted the existing business processes and workflows.
• Evaluate information gathered from multiple sources, reconciled conflicts, decomposed high-level requirements.
• Write Functional Specification Document , Business Rules, and Activity Diagrams, State Diagrams and Sequence Diagrams and support requirement traceability.
• Create use case scenarios and process model flows to support requirement documentation process.
• Prepare migration strategy including data migration plan, data mapping activities, getting approval from key stakeholders and provide support to the migration team.
• Participate in project wrap-up and lessons learned meeting.

Data Standardization of Customer data with IMSHealth HCOS Data for Salesforce

• Participated in requirements meetings and data mapping sessions to understand business needs.
• Identified and documented detailed business rules and use cases based on requirement analysis.
• Produced monthly data quality reports using advanced Excel spreadsheet functions.
• Corrected any data entry error to prevent later issues such as duplication or data degradation.
• Recommended data standardization and usage for protection of data integrity.

Designing solution for FirstDoc (Regulatory Information Management)

• Engage client to elicit requirements for FirstDoc module (Documentum Based) of Regulatory Submission solution.
• Participate in meetings with the client to clarify business requirements as mapped to functional and technical specifications and identified gaps against the user stories for the FirstDoc Module.
• Worked closely with clients to establish specifications and system designs.
• Manage the Requirement Traceability Matrix (RTM) sheet throughout the lifecycle of the release.
• Analyze business scenarios to prepare simulations and job aids training material for end users.

Analyze the gaps in As-Is process and creating the To-Be process for order fulfillment journey

• Analyze the gaps in As-Is process and creating the To-Be process for order fulfillment journey.
• OneView CRM processes improvements to enhance end customer experience.
• Provide root cause analysis for defects due to failure in order fulfillment journey process.
• Extensive use of UML diagrams using MS Visio.