Software design & implementation of features, visualizations, dashboards, and reporting tools.

• Led feature development for QC with QC API, Visual Basic, and C# to improve productivity and efficiency. -- Batch test case review and approval tool. -- FDA Part 11 compliant LDAP e-signature for test case approval and execution plugin. -- Requirement and test coverage Excel reports via Quality Center’s OTA for progress reporting.• Plan and execute Quality Center project migration and update to the latest version and consolidate workflow processes into a single workflow template.• Automate Quality Center project and database upgrade, including backup and restorations of custom database tables and repository.• Automate data entry for releases from build information and upload release files though C# scripts in TFS.• Create live dashboard system to summarize TFS release status using HTML, CSS, and Javascript for frontend and MS-SQL for backend.• Maintain FDA validation for QC and QC related scripts and tools.• Automate Spectre and Meltdown patching for our server and workstations using Powershell.

• Own ALM Tools PTC Integrity and ALM Quality Center.• Technical support for Application Lifecycle Management (ALM) tools Requisite Pro, Clear Quest, PTC Integrity and Quality Center (QC) to resolve any issues within the tool, server, or database.• Led design, plan, and execution of installation and configuration for ALM PTC Integrity.-- Integrate with current ALM tools.-- Workflow that is FDA compliant.-- Work item templates compatible to import and consolidate other ALM tool’s data.• Automate data migration from one ALM tool to PTC Integrity.• Developed administration tool to grant access or change permissions in batches for Quality Center.

• Create bridges between different Application Lifecycle Management (ALM) tools, such as Rational Team Concert (RTC), Bugzilla and ClearQuest, using SQL, JSON, XML and XSLT that will transfer and convert information and work items from one ALM to another.• Create an online tool for bridge creation and user bridge monitoring and troubleshooting tools using MS Visual Studios, C#, Java, XML, and SQL. Which included the following -- Display bridge status based on number of transactions in the queue. -- Individual variable status bounds for each bridge -- Display latest bridge error in layman's terms with drilldown capabilities to view all errors. -- Enable, disable, and reset bridge. -- Display transaction information (in queue, completed, failed) • Used RTC daily to manage project progress while developing in Scrum framework.

• Set up Business Intelligent (BI) environment that includes SSRS (SQL Server Reporting Service), SSAS (SQL Server Analysis service) and SSIS (SQL Server Integration Service) for existing Proloq product sales system (relational database)• Designed and implemented analysis database named ProloqBI which is a Data Warehouse / Multidimensional database. Including the following-- Dimension Tables (determining the granularity needed to support biz decisions)-- Fact Tables (measures, numeric value that are summarized to make biz decisions)-- Bridge Tables (reference)• Set up SSIS package to pull data from transaction database to a BI staging database and integrated those data into dimension, fact and bridge tables• Created Report Service Project using MS Visual Studios (2008) and reports base on the requirements, which includes graph charts, generic tables, and pivot tables• Create Analysis Service Project and Set up Cube (Processed, which aggregates facts on the defined dimensions)• Created a web site to allow users view all reports in a central location• Trained users to using Excel as a user interface connect to analysis cube, drag and drop the pivot table fields to create their own reports. Documented user manual for Proloq BI system.