Anagha Tasgaonkar
Plainsboro,NJ
Summary
Results-driven professional with over 7 years of experience in data warehousing and business intelligence technologies, specializing in a comprehensive range of BI skills. Expertise in gathering requirements, analysis, design, development, testing, and production rollout of reporting and analysis projects. Proficient in designing and deploying data analysis reports and enterprise dashboards for diverse data volumes. Strong foundation in application software development using Oracle and SQL Server, with a deep understanding of data warehousing methodologies such as star schemas and dimensional modeling. Skilled in creating solution-oriented dashboards utilizing various chart types such as bar chart, scatter plot, heat map, cross tables , drill downs , KPIs in Tableau and Spotfire, enhancing interactivity through HTML, CSS, and JavaScript to deliver visually compelling reports. Optimized report performance following best practices. Worked with cross functional teams keeping seamless communication to increase user engangement.
Overview
17
17
years of professional experience
Work History
Senior Data Analyst
Merck & Co., NJ
11.2019 - Current
- Project 1: PPDM Dashboard
- Scientists were looking for a centralized solution (one stop shop) to view and analyze all the PPDM (Pharmacokinetics, Pharmacodynamics and Metabolism) Assay Data so they can spend lesser time in finding and merging disparate assay results and more time into analyzing the results.
- Responsibilities:
- Collecting business use cases by connecting various PPDM Scientists.
- Searching and locating data based on Use Cases.
- Configured data visualizations in Spotfire using views of centrally stored results. (ORACLE, Redshift)
- Provisioning permissions to different user groups and individuals. (Library administration responsibilities)
- Attending weekly standup meetings providing weekly updates and status report.
- Continuous improvements of Spotfire Dashboards by Adding newly registered PPDM Assays.
- Conducted on demand trainings for stake holders demoing dashboard functionality and Spotfire Usage.
- Project 2: In-Vitro Analysis aka DR. FIT
- DR fit as Spotfire application supports in-vitro scientists performing plate-based assays. Dose-response analysis is a type of curve-fitting analysis that uses non-linear regression—an iterative mathematical model that fits your Data.
- Connect with various business teams to understand the requirements and business rules.
- Prepare the raw data supplied by in-vitro scientists into appropriate format acceptable and processed by Spotfire (Block format -> Single readout)
- Generate various visualizations as heat map providing Bird’s eye view of the screening results and overall quality of the screen.
- Perform non-linear regression analysis (effects of a drug on cells grown in vitro, helps to identify good compound profiling and potency of the drug) with 4 parameter logistic regression model to generate 4 parameters.
- Face lifting of existing dashboard, Added new features.
- Analyzed and created dose response curve.
- Explored and implemented “Display and Search of Structure” functionality of available in Lead discovery module.
- Other Tools / Technologies: Chemcart.
Data Analyst
Bristol Myers Squibb, New Brunswick, NJ (BMS)
11.2015 - 09.2019
- Project 1: Business Continuity Management
- Risk assessment in order to reduce the potential threats and vulnerabilities that could impact Sites process / operations.
- Responsibilities:
- Involve in Planning, Defining and Designing data based on business requirements and provide documentation.
- Collate of data coming from multiple sites and brands.
- Highlight key brands and sites prone to high risks tiers by various risk categories.
- Develop Interactive dashboards in Spotfire, published and shared with end users.
- Provide ad hoc support with requests and worked on monthly refreshes.
- Create detailed documents such as requirement documents and operation tasks.
- Project 2: Product quality Complaints
- Analysis of complaints and complaint categories received from patients.
- Classify and monitor the trends of product quality complaints
- Efficiently bridged Trackwise system (external system that collects the patient’s complaints) with other data sources such as SAP BI Sales orders in ORACLE.
- Developed and maintained the analytical reports by connecting oracle database objects like tables, views, stored procedures or through Spotfire information links.
- Spotfire dashboard with valuable complaints trend analysis giving snapshot of past and idea about the future.
- Provided on demand training to end users about the usage of capability.
- Project 3: Inventory Obsolescence / Usability.
- Provides visibility into potential obsolescence risk analysis based on drug expiry date and usability date.
- QlikView Bar chart priority brands getting obsolete in next one-year timeline. Heat maps showing hot spots of various products, markets and materials.
- Wrote iron Python scripts in Spotfire to dynamically switch from numbers to currency, reset zoom functionalities.
- Worked closely with business team to validate various scenarios.
- Published and collaborated with end users on training guide document.
- Project 4: Customer Service Inventory availability
- Customer Service Inventory Availability measures performance of Sales Orders at line item level from Distribution Centers to External Customers.
- Worked closely with product owner regarding business requirements.
- Transformed business requirement into functional specs.
- BMS is a global pharmaceutical company whose mission is to discover, develop and deliver innovative medicines that help patients to prevail over serious diseases such as cancer, hepatitis, diabetes, and AIDS. The Goal of this project was to do analysis of various data sets related to supply chain as well as risk assessment and provide solutions that will help clients to achieve business driven solutions.
- Tools & Technologies: Chemcart.
.Net/ SQL Developer
Radiology Oncology systems (ROS), San Diego, CA
10.2010 - 10.2011
- Responsibilities:
- Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.
- Worked closely with end users in designing and creating the Data warehouse for management group using Erwin.
- Implemented logical and physical database modeling using Erwin tool.
- Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
- Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
- Created UI with Windows Forms with numbers of Visual Studio standard controls and components
- Developed the Form Classes, Objects and Interface using C# for code-behind depending on the business logic.
- Performed T-SQL tuning and optimization of queries for reports that takes longer execution time using MS SQL Profiler in MS SQL Server.
- Tools & Technologies:
- Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio (SSMS, SQL Server Analysis Services(SSAS), Oracle 10g, Microsoft Visual Studio, IIS.
- ROS is committed to lowering the cost of healthcare worldwide by offering high technology, affordable equipment-solutions to the radiation therapy and diagnostic imaging communities. The Goal of the project was to perform cash flow analysis of different projects undergoing.
- Tools & Technologies: Tableau Desktop (Version7.0.3 – Version8.2.3), Tableau Server, Spotfire 6.7, 7.4, Oracle 11g, MS Excel, T-SQL.
.Net Developer & SQL Server Programmer
Design tech Systems LTD, India
12.2008 - 09.2010
- Responsibilities:
- Worked on design, coding, testing, debugging, documentation and maintenance of software solutions.
- Created Windows Forms with numbers of Visual Studio standard controls and components for UI.
- Modeled, designed and implemented various relational databases in SQL Server.
- Developed the Form Classes, Objects and Interface using C# for code-behind depending on the business logic.
- Managed roles and security using Windows Authentication and Authorization.
- Implemented .Net 2.0 data controls for Data Binding and Data Access.
- Wrote complex SQL queries, Functions and Views in SQL Server 2000 as well as tuning up the database by creating the proper indexes on the tables
- Involved in providing technical support and maintenance for the application
- Supported the end user in the Production phase by debugging existing software solutions in response to Problem Tracking Records (PTR) and Change Requests (CR) issued from Product Management or Product Definition.
- Tools & Technologies:
- C#, Microsoft SQL Server 2000 & 2005, Microsoft Access2005, Microsoft Visio2005, Visual Studio 2000, .NET Framework 2.0, 3.0 and 3.5
- Design Tech Systems Ltd. is India Based Software Product Development and IT Consulting Service Company. It provides effective software development. This project was about developing a comprehensive and scalable ERP for any kind of hospital and clinics. This project was about requirement analysis, data modeling, database designing and reports generations.
- Tools & Technologies: C#, Microsoft SQL Server 2000 & 2005, Microsoft Access2005, Microsoft Visio2005, Visual Studio 2000, .NET Framework 2.0, 3.0 and 3.5
Education
Master of Science - computer science
Motclair State University
Montclair, NJ01.2015
Bachelor of Science - Electronics and Communications
PVG
India01.2008
Skills
- Proficient in Spotfire , Experienced with Visualization tools
Timeline
Senior Data Analyst
Merck & Co., NJ
11.2019 - Current
Data Analyst
Bristol Myers Squibb, New Brunswick, NJ (BMS)
11.2015 - 09.2019
.Net/ SQL Developer
Radiology Oncology systems (ROS), San Diego, CA
10.2010 - 10.2011
.Net Developer & SQL Server Programmer
Design tech Systems LTD, India
12.2008 - 09.2010
Master of Science - computer science
Motclair State University
Bachelor of Science - Electronics and Communications
PVG