Vidhya Manivel
Summary
Senior Application Support and Database Engineer with 18 years of Microsoft Dynamics CRM experience across Windows, Linux, and Azure. Architect and optimise SQL Server and MySQL infrastructures to improve performance and reliability. Lead Tier 3 support, complex cloud migrations, and high-availability disaster recovery.
Overview
1
1
Certification
18
18
years of professional experience
Work History
Application Support & Database Engineer
RaymondJames Investment Services Ltd
London, City of London
10.2019 - 01.2025
- Delivered L2/L3 Application, Production and Database Support for bespoke financial-services applications across Development, UAT and Production environments, supporting Windows Server 2014/2017/2019, SQL Server 2014/2017/2019 and Microsoft 365.
- Performed SQL Server DBA activities, including database backup and restore, user and permission management, database maintenance, Availability Group configuration, upgrades and troubleshooting.
- Delivered SQL Server upgrades and application/database migrations to Windows Server 2019 for IMIX and JAMS, including environment configuration, connectivity validation and post-migration testing.
- Managed application environment setup, server configuration, installations, deployments, maintenance releases, hotfixes and configuration patches across Development, UAT and Production, covering Windows Server, IIS, SQL Server and Azure/IBM Cloud components.
- Resolved 150+ incidents and operational tasks within the first 10 days of joining, demonstrating rapid technical understanding and effective problem-solving.
- Delivered JAMS Scheduler upgrade and migration from versions 5 to 7.2 and 7.5, managing configuration, job/workflow validation, troubleshooting, and post-upgrade testing to enhance operational efficiency.
- Managed business-critical JAMS jobs and workflows, creating, configuring, scheduling and monitoring daily, weekly, fortnightly and monthly processes using PowerShell, Unix/Linux and PHP to ensure timely execution and reliability.
- Resolved a year-old pending service task by replacing a workstation-based Perl process with PowerShell and JAMS automation to convert raw Pershing TXT/CSV feed files into business-readable XLSX files every 15 minutes during business hours.
- Developed JAMS reconciliation and monitoring jobs to compare incoming files with successfully converted files, identifying discrepancies and notifying the support team for prompt resolution.
- Automated file conversion, PDF protection, printing, archiving, and bulk uploads/imports using PowerShell; designed solution integrating PowerShell, JAMS, and SQL Server for automated bulk loading of high-volume transaction files, streamlining processing tasks.
- Configured and monitored WhereScape data warehouse workflows and ETL jobs; administered Azure Resource Groups, Service Bus, Queues and Logic Apps; deployed/refreshed Power BI packages to facilitate data accessibility and reporting.
- Designed an Excel VBA-based audit file discovery utility to search approximately 16,000 folders and 48,000 files using predefined keywords and naming criteria, reducing a previously three-day manual audit search to a minimal-effort automated process.
Application Support Consultant
eKapital Logistics Services
01.2019 - 07.2019
- Installed, configured, and supported web applications across SIT, UAT, and production environments, ensuring seamless functionality and user access.
- Monitored SCM (Service Management Console) and resolved environment-related issues across application, database and infrastructure layers.
- Implemented maintenance releases, hotfixes, and configuration changes on application and database servers.
- Coordinated resolution of design, build, and network-related defects/issues with technical teams, ensuring timely fixes.
- Maintained application installation, configuration, and operational service documentation according to build guides, supporting knowledge transfer and continuity.
- Restored and configured databases from backups, establishing messaging and scheduling service databases.
- Key Responsibilities & Achievements:
Application Support Analyst
Dentsu Aegis Network
11.2015 - 05.2018
- Provided L2/L3 application and server-side support for enterprise applications including Tableau 9/10, JIRA, Confluence, SCM, SharePoint, SAP NetWeaver/BPC and MS SCCM.
- Managed 100+ Tableau sites, overseeing server administration, user/group/project management, workspace configuration, and HA Proxy setup on UNIX proxy servers, ensuring efficient access and functionality for users.
- Supported SAP BPC/NetWeaver by monitoring jobs, restoring backups, installing NetWeaver, and troubleshooting Excel Add-in issues to ensure application reliability.
- Monitored SCM Service Management Console and SSIS/ETL processes, resolving application and environment issues and coordinating design, build and network defects.
- Implemented and supported mobile intranet applications for Android and iOS, managing deployment and configuration across UAT and production environments to enhance user accessibility.
- Configured and managed Active Directory Group Policy Objects (GPOs) for role-based access to Interactive Market Systems (IMS) studies, automatically mapping network folders/drives for 500+ users across 20+ AD groups in the UK and UAE, streamlining access configuration and enhancing resource control.
- Developed VBA-powered Excel tool to automate extraction of Interactive Market Systems (IMS) study information from .DAT files, replacing manual screenshot sharing with structured reports, streamlining compilation time for 60–100+ studies.
- Developed a VBA-based Excel automation tool to generate Active Directory group membership reports in one click, eliminating repetitive manual requests from the HR team and saving significant team time while improving productivity and turnaround time.
- Key Responsibilities & Achievements:
Senior Application Analyst / Tech Lead
RiO Application Build – BT Health
08.2011 - 10.2015
- Developed a PowerShell deployment validation script to perform one-click Go-Live checks of Application.xml, database connections, IIS and application configuration files across 100+ servers for multiple NHS Trust deployments, replacing time-consuming manual validation and accelerating Go-Live readiness checks.
- Installed and configured RiO application (versions V5, R1, R1.1, R2) across SIT, V&P, UAT, data migration, disaster recovery, and production environments on 100+ servers, ensuring reliable application performance.
- Implemented maintenance releases, hotfixes, and configuration patches on web and database servers.
- Coordinated service, design, and testing teams alongside external vendors to troubleshoot and resolve design, data, and code issues, ensuring project delivery timelines were met.
- Monitored Quality Center to resolve environmental test issues, collaborating with third-party vendors to address code and data discrepancies, improving testing outcomes.
- Developed VBA Excel automation tool to extract monthly QC test issues and analyse team contributions, automating report generation to enhance efficiency and reduce manual effort.
- Restored and configured the database from the backup and created supporting databases for services such as messaging and scheduling.
- RiO is a Microsoft-platform based application that makes use of SQL Server, Java Script, XML, ASP, COM+, IIS, .NET technologies etc. Access to the application is made via web-browser interface.
Senior Test Analyst | NHS Functional & Non Functional Testing BT Health
BT Health
04.2008 - 07.2011
- Performed functional, integration and module testing across PAS, CDS, CAB, DBS, PDS, PIEDW and front-/back-end applications.
- Conducted HL7 V2/V3 message testing, DBS testing, data entry and analysis, supporting end-to-end NHS application workflows.
- Analysed design documents, certification guidelines and CCNs, translating requirements into detailed test specifications, execution plans and test scenarios.
- Managed defect identification, root-cause analysis, and retesting of CRs/SIs, collaborating with development, design, and release teams to ensure swift resolution of critical issues.
- Coordinated with stakeholders during release planning and defect resolution, ensuring thorough investigation and prompt resolution of testing issues.
- Developed VBA Excel automation tool to extract patient CDS and DBS data from fixed-length text files, enhancing efficiency of data preparation for automated-process testing.
- Cerner Millennium provides the electronic patient recording system which enables authorized HCP to access PAS to review past medical tests, capture new information, schedule appointments, order tests and review results.
- Description:
- Key Responsibilities & Achievements:
Test Analyst | Customer Centric Platform – BT Retail
BT Retail
12.2006 - 04.2008
- Executed user acceptance, end-to-end, regression, customer acceptance and functional testing to ensure high-quality product delivery.
- Prepared, reviewed and executed test specifications for new functionality and existing modules, ensuring comprehensive coverage of requirements.
- Developed a VBA Excel automation tool to align and format QC Expected vs Actual Test Results, eliminating manual report preparation. The solution personally impressed the Senior Project Manager, who regularly approached me to understand how I had developed it and showed genuine interest in the approach.
- Outlined key duties and accomplishments, showcasing contributions to team goals and project objectives.
Education
Master of Computer Applications - Computer Applications
Madurai Kamaraj University
IndiaBachelor of Science (B.Sc.) - Mathematics
Bharathidasan University
IndiaSkills
Database management: SQL Server 2000–2019
SQL Server administration
Windows infrastructure: Server 2003–2019, Windows 7/8/10
Cloud platforms: Azure, Microsoft 365, Dynamics CRM
Data scheduling: JAMS Scheduler, ETL workflows
Process automation
Automation tools: PowerShell, T-SQL, VBA scripting
Monitoring solutions: Datadog, Dynatrace, Splunk
Application support
- Incident management
- Technical leadership
- Root cause identification and continuous improvement
- ITSM tools: ServiceNow, Jira, Confluence
- Stakeholder communication
- Data analysis
- Workflow development
- Root cause analysis
- Root cause identification and continuous improvement
- Quality assurance testing
- Risk Assessment
- Project management tools
- Stakeholder communication
- SQL Server administration
- Windows server support
- Root cause analysis
- Data analysis
- Project management tools
Accomplishments
- Service 1st – “Above and Beyond” Award | RJ
- Recognised for resolving a critical Q4 2020 valuation data requirement, enabling the 31 December production run to proceed on schedule and preventing disruption to client quarterly reports and downstream distribution processes.
- Received appreciation emails from Global Applications Director during couple of occasions for finding an alternate way to address the customer issue and client support etc
- Received Letter of Appreciation from Tech M for valuable contribution, dedication & commitments in various projects such as NHS Live Support Testing & CCP
Certification
- ITIL Foundation Certificate – IT Service Management (ITILF)
- ISTQB - ISEB Certified Tester – Foundation Level (CTFL)
- Linux Essentials 010-160 Certificate – Linux Professional Institute
Workshops / Trainings
- Pershing Nexus Basics Training given by Pershing Training Team Professional
- SAP BPC Technical Deep Dive 10.1 NW Training given by OpalWave professional
- SAP EPM Training given by itelligence
- Tableau Desktop and Server side training given by Tableau Consultants
- CERNER Applications - Cerner Core Foundation & CRS Admin training given by Cerner professional
Hobbies and interests
- Travelling, Reading Books, Puzzling, Quizzes, Craftworks
WORK EXPERIENCE
1 year and 4 months,3 years and 3 months,4 years and 2 months,2 years and 6 months,6 months,5 years and 3 months
Timeline
Application Support & Database Engineer
RaymondJames Investment Services Ltd
10.2019 - 01.2025
Application Support Consultant
eKapital Logistics Services
01.2019 - 07.2019
Application Support Analyst
Dentsu Aegis Network
11.2015 - 05.2018
Senior Application Analyst / Tech Lead
RiO Application Build – BT Health
08.2011 - 10.2015
Senior Test Analyst | NHS Functional & Non Functional Testing BT Health
BT Health
04.2008 - 07.2011
Test Analyst | Customer Centric Platform – BT Retail
BT Retail
12.2006 - 04.2008
Master of Computer Applications - Computer Applications
Madurai Kamaraj University
Bachelor of Science (B.Sc.) - Mathematics
Bharathidasan University