Tanushree D

IT Analyst | Support | Onsite Coordinator | Team Lead

Tata Consultancy Services • Full-time

Dec 2011 - Apr 2017 • 5 yrs 4 mos

Client: Genentech (USA) – Biotechnology Leader Location: South San Francisco, USA & Bangalore, India Project: Enterprise Project Portfolio Management (Drug Development Systems) Led support, enhancement, and optimization of mission-critical applications used across drug development lifecycle phases. Key Technologies & Tools: Planisware V5/V6 (OPX2), SAP Business Objects, HP Service Manager, SQL Developer, Eclipse (Java), Google Apps Script, VBA (Macros) Key Contributions & Impact: • Led end-to-end IT support and maintenance for Planisware-based EPPM systems supporting global drug development programs. • Performed root cause analysis and resolution across modules, interfaces, batch processes, and scripts (OPX2), ensuring high system reliability. • Acted as Onsite Coordinator in the US, managing direct client communication, requirement gathering, and prioritization of critical issues. • Transitioned into Offshore Team Lead, managing team delivery, workload distribution, and SLA adherence. • Executed database analysis and performance troubleshooting using SQL tools to improve system efficiency. • Delivered process improvements and automation initiatives, reducing manual effort and turnaround time for recurring tasks. • Built and maintained knowledge base documentation, improving team onboarding and issue resolution speed. ________________________________________ Automation & Tools Developed: • Developed a Data Comparison Tool (VBA Macro Workbook) to validate large datasets, improving accuracy and reducing manual effort. • Built a Log Auto-Verification Script (Java) to streamline issue diagnostics and monitoring. • Created Google Apps Script-based automation tools for: o Task reminders and workflow tracking o Automated reporting and KPI dashboards o Document generation via Google Form Publisher • Designed semi-automated data entry tools using Excel Macros for repetitive operational tasks.