sweta jajorriya

Junior Data Analyst

Refresco•  August 2021 - Present•  Milton Keynes, United Kingdom

Collected data from multiple sources, both programmatically and non-programmatically, including SQL databases and file databases. Transformed and analyzed production data with the help of power query to maintain DAX expressions, resulting decrease in report development time. Designed and implemented real-time interactive Power BI reports with diverse charts and graphs to visualize core business KPIs (e.g., monthly production of products), saving hours per week of manual reporting work. Improved client decision-making by providing interactive and static reporting using data visualization techniques. Reduced client report creation time by 50% by developing reusable report templates. Research and implemented new Power BI features, resulting improvement in report functionality according to the need of stakeholders. Generated and Optimized Data models to create relationship between tables. Recording and Updating inspection data using SAP.

Data analyst (Intern)

Omics international pvt ltd•  September 2019 - August 2020•  Hyderabad, India

Extracted valuable insights using SQL queries (such as select, create, joins, and views) in Visual Studio with the available data, and stored the relevant information.

Bioinformatician

Eminent Biosciences•  February 2018 - August 2019•  Indore, India

Designed and developed pipeline for NGS data analysis including variant calling algorithms. Enhanced the analysis pipeline by conducting comparative assessments using multiple pre-processing tools, including Trimmomatic and FASTQC, to optimize data quality and processing efficiency. Leveraged a range of in-house and external biological datasets to address and resolve specific problem statements. Processed and analysed large biological datasets from high throughput sequencing technologies. Engaged in drug discovery project strategies by employing molecular docking and virtual screening to identify inhibitors with superior affinity for IDH2 and establish a comprehensive pharmacological profile. Extracted biological information from public databases like NCBI, Ensembl, and TCGA, and integrating into RNA-seq analyses. Maintained accurate and complete records of all findings using version control system. Facilitated the process of publishing research findings.