Overview
Work History
Timeline
Generic

Srilatha s

San Jose,CA

Overview

18
18
years of professional experience

Work History

Data Analytics Intern

DATA Glacier
02.2023 - 05.2023
  • Pharmaceutical companies face the challenge of understanding how long patients continue to take their medications as prescribed by physicians, which is known as persistency
  • To overcome this challenge, ABC pharma has sought the help of an analytics company to develop an automated system that can identify patterns of persistency in the data they collect
  • By automating this process, they aim to gain insights that can help them improve patient outcomes and achieve better business results in a competitive industry
  • Essentially, the business understanding is that leveraging advanced analytics can provide valuable insights and advantages for pharmaceutical companies.

CT Data Analyst /ETL Tester

Alexion Pharmaceuticals
NewHaven
05.2012 - 09.2014
  • Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
  • Utilized SAS and SQL to extract data from statewide databases for analysis
  • Acquired data from primary or secondary data sources and maintain databases/ data systems
  • Performed data Analysis using visualization tools such as Tableau, and SharePoint to provide insights into the data
  • Data flow check with source to target mapping of the data
  • Data matrix creation for mapping the with the business requirements
  • Data profiling to cleanse the data in the data base and raise the data issues found
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata
  • Involved with data profiling for multiple sources and answered complex business questions by providing data to business users
  • Assisted in mining data from the SQL database that was used in several significant presentations
  • Involved in SSIS packages to extract data from different sources like SQL server, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.

Data Analyst

United Health Care Ltd
05.2009 - 04.2012
  • Forecasted the ultimate claim amount based on the claim characteristics at the time the claim was filed
  • Built extremely accurate predictive models that lead to a better understanding of how much a claim will ultimately cost
  • This in turn helped the business to have an over view of how much to reserve for incurred but not reported loss amounts
  • The predicted developed loss for each claim was further used as a dependent variable for developing a pricing model
  • Gathered data from different stakeholders; analyzed data and assisted teams on the daily execution of program
  • Created and maintained spreadsheets, built quantitative models to help improve the supply chain processes in the operation theatre, for quantifiable results (at 1.6% lean improvement)
  • Generated reports and created dashboard using advanced SQL
  • Insured compliance with established internal control procedure by examining existing reports and documentation
  • Performed end to end analysis to identify gaps and proposed solution.

QA Engineer

Arizona Department of Education
09.2007 - 05.2009
  • Identified data streams and reviewed data models for testing strategies
  • Written test scripts for back-end validations and Validated mappings of correct and conducted data
  • Validating the load process of ETL, the target tables are populated according the data mapping provided that satisfies the transformation rules
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
  • Validating the Archive process to purge the data that meet the defined business rules
  • Create stored procedures for Incremental extract based on time stamp, version date and record flag
  • Wrote UNIX Shell Scripts and command line utility to interact with Informatica Server
  • Implemented SCD I, II extracts based on the business requirement and client expectations.

QA Tester

Xerox Corporation
07.2005 - 08.2007
  • Planning and executing test cases, Reported defects in A R Tool Composing and reporting daily and weekly reports Giving creative suggestions to the customer and receives customer input and instructions
  • Developed Automated Test Scripts Using DAML.

QA Tester

TCS, India Client
07.2005 - 08.2007
  • Planning and executing test cases, Reported defects in A R Tool Composing and reporting daily and weekly reports Giving creative suggestions to the customer and receives customer input and instructions
  • Developed Automated Test Scripts Using DAML.

Timeline

Data Analytics Intern

DATA Glacier
02.2023 - 05.2023

CT Data Analyst /ETL Tester

Alexion Pharmaceuticals
05.2012 - 09.2014

Data Analyst

United Health Care Ltd
05.2009 - 04.2012

QA Engineer

Arizona Department of Education
09.2007 - 05.2009

QA Tester

Xerox Corporation
07.2005 - 08.2007

QA Tester

TCS, India Client
07.2005 - 08.2007

Similar Profiles

CREATE PROFILE
Srilatha s