Data Analyst/Test Engineer
I am an IT professional with a focus on data analysis and test engineering in healthcare. I leverage my strong track record of confirming data accuracy, optimizing systems to better Healthcare solutions. I am passionate about learning new technologies and applying them in real-world scenarios.
Key Skills & Competencies
Database : SQL Server 2008, PostgreSQL, MYSQL.
Test Defect Management Tools : Team Foundation Server 2012, JIRA
Scripting Languages : Python, SQL, R Programming
Project Methodologies : Waterfall Model, Agile
Data visualization tool : Tableau ,Excel
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.
- 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.
-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.*
Volunteer orphanage for children. Engage in games, cooking, teaching, and offering a listening ear to the children. Ensure that they have access to essential supplies tailored to their needs.
Service: initiated and participated in a weekend volunteer group dedicated to giving back to the community
Master of Computer Applications, Institute of Engineering and Technology, India
Bachelors of Computer Applications, Guru Tegh Bahadur Institute of Technology, India
Google Data Analytics Certification