Lavanya Arumugam
Chennai
Summary
Techno-functional Business Intelligence professional with 15 years of overall IT experience, including 7 years in BI tools, 6.5 years in Life Sciences & Middleware (BPI), and exposure to Healthcare, Insurance, and Aerospace domains. Proven expertise in BI development, administration, migration, and team leadership, with strong experience in Spotfire, Tableau, Power BI, SQL, and Redshift. Highly experienced in project management, incident/problem/change management, and stakeholder engagement across global customers.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Associate Manager
DXC technology
Chennai
01.2024 - Current
- Manage BI deliverables across multiple business units, ensuring timely and high-quality analytics solutions.
- Oversee design, development, and deployment of interactive dashboards and reports for executive and operational stakeholders.
- Act as a bridge between business users and technical teams to gather requirements and convert them into scalable BI solutions.
- Manage BI platform administration, user access, security, performance tuning, and version upgrades.
- Establish data governance standards, KPI definitions, and best practices for reporting consistency.
- Mentor and guide a team of BI developers and analysts, conducting code reviews and performance feedback.
- Drive automation and optimization initiatives, reducing manual reporting effort and improving data reliability.
- Collaborate with infrastructure and support teams to troubleshoot production issues and ensure high system availability.
Technical Lead and Admin; Spotfire
Wipro
Chennai
10.2021 - 01.2024
- Technical Lead handling Spotfire Administration work.
- Hands on experience in migrating Spotfire dashboards.
- Hands on experience in upgrading the Spotfire server from 11.4.1 to 12.0.0 LTS version
- Hands on experience in handling adding user and groups, configuring licenses, preferences and deploying new packages.
- Handled Spotfire library administration and automation services. Created scheduling updates on it.
- Experience in Spotfire MODS and its migration to Spotfire Server 12.0.0 LTS version
- 100% success rate in delivering the reports to the user after the upgrade.
Technical Lead; Tableau and Spotfire
Innova Solutions
Chennai
04.2019 - 09.2021
- Technical Lead handling Spotfire and Tableau dashboard Developments.
- Hands on experience in converting Tableau to Spotfire dashboards.
- Hands on experience in converting SAP BO to Spotfire and Tableau dashboards
- Designing and Developing Information Links and Filters
- Handling tableau advanced functionalities and exposure in Datawarehousing techniques.
- Developing various type of Visualizations like bar chart, Line chart, scatter plot, Cross table, Tree map, KPI and Combination chart.
- To Unit test the Dashboard data with SQL
- Creating UTC documents and other support documents.
- Using Limit Data Expressions, LODs based on Client Requirements.
Technical Lead; Spotfire and Tableau
Cognizant Technology Solutions
Chennai
01.2018 - 02.2019
- Technical Lead handling Development Enhancements of Tableau and Spotfire Dashboards.
- Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
- Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
- Created Parameters to achieve desired functionality.
- Created Doughnut charts, Line graph, Bar charts in Tableau.
- Created Filters, Groups, Sets on Tableau Reports.
- Created and modified some of the existing reports and dashboards.
- Publishing sheets and dashboards on server Using Tableau Desktop.
- Created conditional filters and Action links to filter the data on dashboard.
SME; Testing
CareFirst
Coimbatore
09.2017 - 12.2017
- SME for Benefit testing and PCS platform.
- Handled execution for Regression testing of PCS.
- Manual execution of cases for Workflow management in Medical and Hospital Claims.
- Coordinating in working with multiple teams to support hectic schedule
- Worked in Facets for claim processing.
- Responsible to pass the cases in ALM efficiently.
- Prepared, designed and led the Test strategy and Test plan for all the projects, reviewed activities such as requirements Review, Design Review, Test Strategy review and Test plan review.
Test Lead; Testing
Sanofi
Chennai
04.2017 - 05.2017
- Single POC- for Sanofi Win 10 Migration Testing and validation from Chennai.
- Data Validation and verification of Applications of Sanofi.
- Handled 1500 applications data validation and verification.
- Collaboratively worked with different application tower leads and team members to collect data in a very short span of time.
- Responsible to maintain all the applications tracker in place with all the current changes.
Spotfire Tester/Developer
AstraZeneca UK Pvt Ltd
Chennai
10.2014 - 11.2015
- Worked as Spotfire Tester, responsible for gathering requirements, developing TestCases during analysis, design, development and production phases.
- Developed internal Spotfire Dashboards and worked on SQL.
- Responsible for Testing business requirements to spotfire reports.
- Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system.
- Tested Informations links.
- Involved in testing of Spotfire Reports with different visualizations.
- Coordinated Weekly status calls/ meetings with team and Business team.
- Responsible for ensuring that all Changes are appropriately documented, approved & accurate in Light-Weight Document Management system for validated applications.
- Provide Production Support in Hypercare period.
- Responsible for QC Defect logging and closures.
- Prepared, designed and led the Test strategy and Test plan for all the projects, reviewed activities such as requirements Review, Design Review, Test Strategy review and Test plan review.
- AstraZeneca UK Pvt Ltd is a world leading pharmaceutical company with a world-class biologics capability. AZ is active in over 100 countries with a growing presence in important emerging markets including China; corporate office in London, UK; and major R&D sites in Sweden, the UK and the US. They have around 12,000 people in the R&D organization and 17 principal R&D centers in eight countries. They have 26 manufacturing sites in 18 countries.
DataPower Technical Lead and Tester
AstraZeneca
Chennai
11.2013 - 10.2014
- The Datapower Refresh Project was initiated by AstraZeneca to migrate all services in US region from Datapower XI50 Appliance to XI52 Appliance since the existing appliances will be out of support effective Q2 2014 and will not be supported by IBM. The services will be migrated from Wilmington Data Centres (WDC) to the Primary Data Centres (PDC) that is managed by HCL.
- Single POC- for DataPower Upgrade Migration and its Testing
- Handled Device basic Setup –DataPower devices for US region
- Decommissioning of 6 DataPower boxes/appliances from Wilmington Data centre
- 5 DataPower boxes setup at Philadelphia Data centre.
- All migration activities related to DataPower and its testing of around 1000 services(WSP, XFW , MPGW and WAF)
- Complete analysis on pre migration activities and coordination with multiple vendors to migrate/setup the new devices
- Worked on internal Firewall opening for almost 50 different IP’s and host with HCL firewall team
- Third Party firewall opening for 20 different hosts and its coordination with vendor and firewall team
- SOAP UI testing for all the services migrated (preproduction and production)
- FTP/SFTP of files testing and its coordination with vendors
- Post migration support related to DataPower issues and its migration issues
- Ensured the DataPower versions used across the globe are in sync as AZ had already migrated the EMEA and Asiapac devices to Xi52
- Followed the security policies by AZ IT strategy to host servers in Primary Data center (PDC)
- Developed web application firewall (externalization of an Application) for the first time in AZ successfully and delivered for a SharePoint application.
- Handled certificate algorithm upgrade from SHA1 to SHA2 for all the DataPower SSL certificates used across all regions and the same was installed into all the application platforms and its servers by vendors and application owners.
- Created Reference Architecture, Solution blueprint and service design document for DataPower Xi52 devices deployed for AZ
DataPower Technical Lead
AstraZeneca
Chennai
02.2013 - 06.2013
- Emerald was a project initiated by AZ to improve the optimized usage of infrastructure, migration and virtualization of possible infrastructure
- Single POC- for DataPower Emerald Migration programme
- Handled DataPower Device Setup – Sweden, Singapore and UK
- All migration activities related to DataPower- Firewall, service migration, new URL setup, coordination
- Complete analysis on pre migration activities and coordination with multiple vendors to migrate/setup the new devices
- Successfully delivered all the new devices and its components on time and got appreciated for the same
- Post migration support related to DataPower issues
Support Analyst /Developer
AstraZeneca UK Pvt Ltd
Chennai
09.2011 - 02.2013
- Designing web sites for commercial sites for AZ using HTML and CSS
- Trained in DataPower - IBM tool
- Developed around 100 WSPs, 10 MPGWs, and 10 XFWs.
- Providing end – end support in DataPower application
- Handled many complicated/ bulk SERs in DataPower leading the DataPower team
- Good knowledge in remedy tool – incident management, problem management, change management, and knowledge management
- Worked on remedy on demand tool, managing all problems in accordance with the Problem & Change Management processes.
- Responsible for the creation, coordination, consolidation and monitoring of change schedules.
- Responsible for ensuring that all Changes are appropriately documented, approved & accurate in Light-Weight Document Management system for validated applications.
- Responsible for ensuring that all Changes are accurately implemented on time.
- Fun activities, outreach, team managements
Support Analyst
AstraZeneca UK Pvt Ltd
Chennai
12.2010 - 09.2011
- Providing the Project Management Operations support
- Handling project resource allocations & client Invoicing
- Project Metrics & Project tracking.
- Worked as technical analyst providing analysis, design and implementation for application enhancements with cost estimations
- Co-ordinate a rapid and effective cross-sectional response to all Project related including SER assignments and SLAs
Education
B.Tech - Bio-technology
Kumaraguru College of technology
TamilNadu, India01.2010
Skills
- Business intelligence
- Dashboard development
- Data governance
- Performance tuning
- Data visualization
- User access management
- Project management
- Team leadership
- Critical thinking
- Mentoring skills
- Effective communication
- SQL Server
- AWS Redshift
- BI tools
- TIBCO Spotfire 78,711,X, 11, 12 LTS, 14 LTS
- Power BI
- Tableau
- Remedy
- Service-Now
- IBM Websphere DataPower
- ALM
- Facets
- OneClaims
- Lifesciences
- HealthCare
- Insurance
- Quality Assurance and Testing
- Aerospace
Certification
- Cognizant Certified Professional (CCP) in ITIL & ITIL v3
- Six Sigma Yellow Belt Certified by Cognizant
- Cognizant Certified Professional (CCP) in Life Sciences
Accomplishments
- Received the ‘SPOT Award’ from Cognizant for the year 2010.
- Note of Appreciation from Managers for successfully streamlining all the Project Related works.
- Received the ‘Associate of the month’ from Life Sciences practice in the year 2011.
- Show Stopper award during fun activities on the floor.
- Note of Appreciation from DataPower architects for successful setup and migration of DataPower without any issue on several occasions.
- ‘Outstanding Leader’ award for successfully completing “Emerald Migration Programme-2013” single handedly.
- ‘Phoenix Award’ for the project DataPower Run Services, for handling critical issues successfully.
Languages
- Tamil
- Telugu
- English
- Tamil
- Telugu
Summary Of Experience
14, 6, 6, 5, Tableau, Spotfire, SQL, Redshift, DataPower, Incident management, Problem management, Change management, Project management
Personal Information
- Pan Number: AFOPL7269K
- Date of Birth: 10/24/89
- Nationality: Indian
- Marital Status: Married
Timeline
Associate Manager
DXC technology
01.2024 - Current
Technical Lead and Admin; Spotfire
Wipro
10.2021 - 01.2024
Technical Lead; Tableau and Spotfire
Innova Solutions
04.2019 - 09.2021
Technical Lead; Spotfire and Tableau
Cognizant Technology Solutions
01.2018 - 02.2019
SME; Testing
CareFirst
09.2017 - 12.2017
Test Lead; Testing
Sanofi
04.2017 - 05.2017
Spotfire Tester/Developer
AstraZeneca UK Pvt Ltd
10.2014 - 11.2015
DataPower Technical Lead and Tester
AstraZeneca
11.2013 - 10.2014
DataPower Technical Lead
AstraZeneca
02.2013 - 06.2013
Support Analyst /Developer
AstraZeneca UK Pvt Ltd
09.2011 - 02.2013
Support Analyst
AstraZeneca UK Pvt Ltd
12.2010 - 09.2011
B.Tech - Bio-technology
Kumaraguru College of technology