Google Data Analytics , Google 3 years, 7 months
Software Engineer, Technossus, Ludhiana , Punjab , India 3 years
Project: Agendia Precision Oncology
A Molecular Diagnostics Company focused on Breast Cancer
Played a pivotal role in leveraging clinical trial data to advance precision oncology in breast cancer. Processed, analyzed, and interpretation of vast datasets related to breast cancer and tumors.
Key Contributions:
- Data Processing and Analysis: Processed and analyzed clinical, laboratory, and survey data, utilizing a range of statistical methodologies. Spanned from exploratory analysis to final model building, sensitivity analysis, diagnosis, and subgroup analysis.
-Data Exploration and Understanding: Conducted in-depth research and analysis using various tools to manually explore and gain comprehensive insights into complex datasets.
-Python Scripting: Leveraging Python, I developed scripts to analyze data from flat files, employing libraries such as Pandas and PySpark to extract valuable insights.
-SQL Proficiency: Crafted SQL queries to map, join, and filter datasets, enabling data interpretation and analysis of clinical trial data. My proficiency extended to SQL Server Management Studio and Microsoft SQL Server.

SAS Expertise: Harnessed SAS and PROC SQL to analyze SAS datasets, further enhancing our data analytics capabilities.
Data Profiling and Visualization: Executed data profiling and explored datasets, employing common data exploration and visualization tools, including Microsoft Excel.
*Project - CPT Mobile Application Development
Was responsible for testing the app for functionality, performance, user experience on iPhone and iPod.
Tested the app across various versions of iOS. Performed Back-end testing using SQL queries to ensure data integrity. Participated in daily scrum meetings and defect status meetings with team members.
Key Contributions:
-Raised quality escalations.
-Handled the debugging life cycle.
-Used TFS2010, 2012 for Sprint planning.
-Used MTM for defect tracking and test case creation & execution
-Create Test Cases as well as Test Plan in Microsoft Test Manager.
-Created and executed complex SQL queries to perform data completeness, data correctness, data transformation and data quality testing.
-Participated in Production issues analysis and replication for quick fix and release.*