Sindhuja Thondapu

• Installed and configured TIBCO Statistica and its components on additional servers to enhance system performance and scalability.
• Led data migrations of qualified builds across multiple sites, supporting new deployments and platform consistency.
• Scheduled and maintained automated workflows and models to generate GMP and non-GMP reports on a daily, weekly, and monthly basis.
• Designed and developed templates and reports using TIBCO Statistica Client and Enterprise Manager, based on evolving client requirements.
• Collaborated with cross-functional teams to configure data pipelines and establish secure database connections.
• Diagnosed and resolved application-level and architectural issues, ensuring system stability and user satisfaction.
• Coordinated with internal and external stakeholders (e.g., Citrix, IS, DB teams) across global sites to ensure seamless integration and deployment.
• Applied hotfixes and supported all major and minor Statistica releases within the organization.
• Debugged complex software issues and implemented development or configuration fixes to improve product reliability.
• Utilized HP ALM for system integration and user acceptance testing (UAT) across all modules.
• Authored and maintained comprehensive documentation for all Statistica release activities and configurations.
• Engaged with clients to gather requirements and translate them into actionable technical specifications.
• Participated in code reviews and modernization of legacy codebases to align with current development standards.
• Proactively pursued continuous learning through training, workshops, and self-study to stay current with industry trends and technologies.

Environment: TIBCO Statistica, VBScript, Oracle Database, SQL Server, HP ALM, WebStatistica, SDMS, Web Data Entry

• Installed and configured TIBCO Statistica and its components on additional servers to enhance performance and scalability.
• Supported data migrations of qualified builds across multiple sites to enable consistent and efficient deployments.
• Scheduled and maintained automated workflows and models to generate GMP and non-GMP reports on a daily, weekly, and monthly basis.
• Designed and developed templates and reports using TIBCO Statistica Client and Enterprise Manager, tailored to client requirements.
• Collaborated with cross-functional teams to configure data pipelines and establish secure database connections.
• Resolved application and architectural issues reported by end users and core teams, ensuring system stability.
• Coordinated with internal and external stakeholders (e.g., Citrix, IS, DB teams) across global sites to support seamless integration and deployment.
• Applied hotfixes and supported all major and minor Statistica releases within the organization.
• Diagnosed and resolved issues in TIBCO Statistica through development and configuration fixes.
• Utilized HP ALM for system integration and user acceptance testing (UAT) across all modules.
• Maintained comprehensive documentation for all Statistica release activities and configurations.

Environment: TIBCO Statistica, VBScript, Oracle Database, SQL Server, HP ALM, WebStatistica, SDMS, Web Data Entry

• Led the installation, enhancement, and implementation of custom nodes in TIBCO Statistica using Visual Basic Script.
• Developed and maintained workspaces to store data in Oracle databases and generate analytical reports.
• Created custom scripts for spreadsheet formatting and automation within Statistica.
• Configured Statistica to execute SQL queries and ad-hoc reports, integrating data from multiple sources.
• Installed and managed Python packages to extend Statistica’s analytical capabilities.
• Collaborated with cross-functional teams to configure data pipelines and establish secure database connections.
• Diagnosed and resolved application issues through development and configuration fixes, ensuring system stability.
• Supported data migration and integration activities across Statistica environments.
• Utilized ServiceNow for change management and HP ALM for system integration and user acceptance testing (UAT).
• Maintained detailed documentation for all Statistica-related activities and configurations.

Environment: TIBCO Statistica, VBScript, Oracle Database, SQL Server, HP ALM, ServiceNow, WebStatistica

• Updated PDW mappings and created new PDW product configurations to support evolving business needs.
• Managed change control processes, including creation, tracking, and closure, in compliance with regulatory standards.
• Supported deployment, validation, and documentation of the PDW platform in alignment with local and global computerized system validation (CSV) and SPC procedures.
• Extracted and integrated data from multiple sources using robust methodologies to ensure data accuracy and consistency.
• Developed and optimized business processes to enhance system performance and operational efficiency.
• Created new material templates and managed SAP-relevant configurations in collaboration with the SAP Master Data team.
• Performed batch data updates and deletions as required, ensuring data integrity.
• Conducted annual user access audit trail analysis and authored compliance reports.
• Extracted and mapped QC test master data from LIMS and process parameters from Shop Floor Data (SFD).
• Defined genealogy, calculations, and trigger checks for new product configurations and views.
• Deployed product configurations and managed table renaming and filter setup in both validation (VAL) and production (PROD) environments.
• Coordinated with data stewards to apply master data changes in APEX-MDM.

Environment: Process Data Warehouse (PDW), PDW Visualization Tool, SAP, VBScript, Oracle Database, Master Data Management (MDM), LIMS, Shop Floor Data (SFD), HP ALM

• Implemented and supported TIBCO Statistica versions 12.x and 13.x, including the development of custom nodes using Visual Basic Script.
• Utilized Statistica MDE (Manual Data Entry) and Web Statistica for data collection and analysis.
• Identified and documented data and analytical requirements based on business needs.
• Created and executed regression scripts to validate Statistica application functionality.
• Extracted data from GMP sources using SQL queries for reporting and analysis.
• Collaborated with cross-functional teams to perform validation activities, manage change procedures, and track defects.
• Coordinated with vendors to implement hotfixes, patches, and upgrades across production and pre-production environments.
• Worked closely with business users to ensure accurate configuration, documentation, and testing of master and metadata.
• Authored and executed test scripts using HP ALM; tracked issues using Redmine and ServiceNow.
• Supported data migration and integration efforts within the Statistica environment.
• Worked with SPC engines (DRPE, ALNE, KPIE) to support statistical process control.
• Managed evolving requirements throughout the project lifecycle in coordination with the Run Team.
• Operated independently to make informed decisions and respond to urgent issues.
• Conducted unit and integration testing, generated test data and scenarios, and resolved deviations.
• Developed comprehensive documentation including functional and technical specifications, SOPs, SWIs, training materials, and system maintenance procedures.

Environment: TIBCO Statistica, VBScript, Oracle Database, SQL Server 2014, HP ALM, Redmine, ServiceNow, MDM

• Analyzed, planned, and defined data structures based on business requirements, producing detailed documentation for implementation.
• Migrated and modernized legacy stored procedures by analyzing, documenting, and recreating them in a new environment.
• Developed complex T-SQL queries, user-defined functions, stored procedures, and views to support reporting and data processing needs.
• Optimized database performance through effective indexing strategies and query tuning.
• Designed and implemented SSIS packages to load data from flat files into SQL Server using advanced transformations such as Lookup, Fuzzy Lookup, Derived Columns, Conditional Splits, Aggregates, and Pivot/Unpivot.
• Processed partner flat files into OLTP databases using T-SQL procedures and functions to ensure accurate data population.
• Created parameterized SSRS reports with dynamic filtering to improve performance and reduce data load.
• Built and deployed SSIS packages for importing/exporting data from Excel, SQL Server, and flat files, including configuration and scheduling.

Environment: SQL Server, T-SQL, SSIS, SSRS, SQL Server Management Studio, SQL Profiler, SQL Query Analyzer, DTS, VBScript

• Involved in Creation, Manipulation and Supporting the SQL Server Database.
• Installed and configured the MS SQL Server 2000 and maintenance of servers in various environments.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Created views, wrote stored procedures for Application Developers and some user defined functions.
• Created database objects for improving the performance.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in Creation/ Maintenance of Indexes for fast and efficient processing of queries.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard for improving query performance.
• Did backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management, implementation of version control with Visual Source Safe.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Environment: SQL Server, Windows Enterprise Server, Erwin, MS Office.