Ayan Roy

Client Name: Multiple pharmaceutical companies - Bristol-Myers Squibb, Boehringer Ingelheim, Eli Lilly, Merck, Pfizer and Roche

Project Name: Shared Investigator Platform

• Understand data related across heterogeneous system by discovering data transformation rules and application relationships.
  Identified and described relationships between data fields in application database.
• Work with relational databases installed on AWS RDS.
  Analyzed application database architecture to reduce redundancy of data within existing systems or improve conflation of datasets from one system to another.
• Identify Application Level dependencies and created lookup and reference tables.
• Provide an easy-to-use, highly consumable and reusable process for users and test practitioners to obtain testing data that is complete and accurate.
• Prepared variety of different written communications, reports and documents.
• Monitoring data request status through various tools / analysis and implementation of corrective actions.
• Used Microsoft Word and other software tools to progress and maintain official description of enterprise datasets.
• Prepare Work Breakdown Structure document for the data synthesis team.

Client Name: Multiple pharmaceutical companies - Bristol-Myers Squibb, Boehringer Ingelheim, Eli Lilly, Merck, Pfizer and Roche
Project Name: Shared Investigator Platform

• Coordinated scheduled releases and updates and set release management lifecycles according to internal business goals and ongoing development realities.
• Planned and orchestrated end-to-end processes.
• Chaired daily project meetings using Agile methodologies and Scrum formats.
• Monitored resolution of defects, tested fixes and helped developers tackle ongoing problems by providing QA perspective.
• Collected, modeled and analyzed data in order to make proactive adjustments to plans and meet all milestones.
• Monitor defect aging, execution progress and prepare reports of execution candidates.
• Created presentations and infographic for platform release enhancement communications.
• Planned and arranged meetings with external organizations and internal leadership, enabling parties to meet and discuss project progress and roadblocks.
• Improved customer satisfaction by quickly and effectively addressing inquiries and complaints.
• Collaborated with software development project departments to align engineering efforts towards prescribed release schedule deadlines.
• Managed simultaneous and multiple releases across various platforms and within diverse portfolios.
• Trained and supported new team members, maintaining culture of collaboration.

Client Name: Multiple pharmaceutical companies - Bristol-Myers Squibb, Boehringer Ingelheim, Eli Lilly, Merck, Pfizer and Roche

Project Name: Shared Investigator Platform

• Trained and guided team members in validation techniques, methods and testing processes.
• Documented entire validation process, noting changes or alterations completed.
• Analyzed pre-release software titles for compliance with User Requirement Specifications (URS), referring any deficits to appropriate personnel.
• Led risk assessment meetings, offering input on assessments such as system impact, component criticality, data integrity and other factors.
• Collaborated on Standard Operating Procedure (SOP) and process flow diagrams development, incorporating input from cross functional workstreams to reduce liability and enhance successful deployments.
• Generated validation plans for GxP projects, authored validation protocols for computer systems, verifying compliance with internal policies and external audit requirements such as OQ reports and requirement traceability matrix.
• Authoring a Software Qualification Report and a Risk Assessment Report for any new software tool developed or considered for validation.

Client Name: American Express, USA

Project Name: AMEX US MYCA Online Disputes

• Adhered to internal release development guidelines and processes to mitigate liabilities and align with business goals.
• Managed release validation through development, testing and production phases.
• Handling End to End Test Management Activities like on-boarding/off-boarding resources and effort estimation.
• Responded to emergent issues in production releases to quickly iterate and remediate weaknesses in subsequent releases.
• Collaborated with project owners and team members to set ambitious but achievable goals.
• Worked with leadership and reviewed project specification documentation to improve testing processes, methodologies and capabilities.
• Managed and motivated project teams to promote collaboration and keep members on-task and productive.
• Documented testing procedures for developers and future testing use.
• Delivered KT sessions on testing techniques, tools and protocols to new team members.
• Provided reports on milestones, issues and test concerns to project managers for assistance.
• Conducted Impact Analysis for both Corrective (Bug Fixes) and Adaptive (Enhancements and Change Requests) type maintenance testing for the application.

Client Name: American Express, USA

Project Name: AMEX US MYCA eStatement

• Analyzing and gathering requirements, results & root cause and identifying the appropriate approach for the testing.
• Executed test cases and documented defects, confirming resolution and mitigation of defects.
• Collaborated with developers and business analysts to stay current on intended functionality.
• Produced and maintained technical documentation for project reference.
• Identified and resolved complex issues by applying advanced analytical and troubleshooting strategies.
• Achieved client satisfaction and loyalty by establishing collaborative relationships, facilitating needs assessment and recommending suggestions to the business users by analyzing the end user point and estimating the cost standpoint.

Client Name: Hon'ble High Court, Calcutta
Project Name: E-Courts of National Informatics Centre, India

• Served as a Single Point of Contact for Information and Communications Technology implementation in a court district.
• Identified computer hardware and network system issues, performing troubleshooting techniques for remediation.
• Oversaw development and implementation of improvements to support and network operations.
• Configured, deployed, maintained and supported hardware, office tools and applications.
• Troubleshot network communication, software and user account trouble calls, successfully resolving multiple calls per day.
• Set up and configured secure wireless access points to extend client connectivity.
• Improved overall user experience through support, training, troubleshooting, improvements and communication of system changes.
• Updated department documentation such as license databases, infrastructure maps and FAQs to maintain consistent response levels.
• Led development of internal education curricula for new staff, designing instructional programs to rapidly onboard information systems users.
• Oversaw user provisioning efforts, verifying credentialing policies, security and maintenance to encourage safe sign-ins.
• Supervised vendors for software engineering services, installation of LAN and hardware and collaborated with them in development efforts, establishing standards, determining specifications and creating SLA and OLA.
• Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting.
• Prepared and maintained regular system assessment and evaluation documents, informing District Informatic Officer, Nodal Officer and Central Project Coordinator of discovered faults or discrepancies in operations.
• Drove continuous improvement of IT governance processes.
  Migrated data from legacy system to MySQL databases.
• Performed software installations and upgrades to SUSE Linux operating systems.