Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
Generic
Sandeep Ranage

Sandeep Ranage

Pune

Summary

Accomplished data professional with over 10 years of experience in data warehousing, integration, and product support within the Clinical Trial, Pharma, Life Science, Health Care, Insurance, and Sales sectors. Expertise in ETL/ELT processes, data modeling, and performance tuning, with hands-on proficiency in Informatica PowerCenter and MDM. Demonstrated problem-solving abilities and process optimization skills, complemented by effective stakeholder communication, using advanced tools like Excel and ChatGPT. Versatile experience across multiple domains, including telecom, insurance, and sales, with familiarity in methodologies such as Waterfall, Agile, and Scrum.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Principal Support Engineer

AstraZeneca
10.2023 - Current
  • Company Overview: AstraZeneca is a global, science-driven biopharmaceutical company, renowned for its innovative medicines that benefit millions of patients around the world
  • We manage clinical trial data across numerous studies, applying business logic to transform this data effectively
  • Following the transformation process, the data is updated in various dashboards within Patient Insights, ensuring timely access to critical information
  • Leading the Customer Support Meetings
  • Carefully take care of data pipeline to ensure all expected source data is ingested successfully for transformation without any failures
  • Managing Customer Escalations and Stakeholder Escalations
  • Taking care of downtimes activities
  • Also available on weekend support for upgrade/deployment activities
  • Playing mentor role for new team members
  • Managing RCA and CAPA documents
  • Also handling account decommission activities and communication
  • Monitoring Ticket Queue & Ticket Assignments Daily basis
  • Taking care of the SLA & responsible for No breach of Support Process
  • Leading Daily Standups call with the Team to Review support tickets and helping for ticket analysis
  • Handling the Major Incident Management process for P1 Issues
  • Ticket analysis and troubleshooting
  • Collaborated effectively with the team to solve the issues
  • Managing Shift Schedules, Leaves and corresponding Backups
  • Conducting monthly 1:1 meeting with team to understand the pain points, suggestions and improvement ideas
  • Connecting with other support Leads to known latest Product features, issues, ideas, suggestions etc
  • Actively Learned our 24R1 LSAC products Data hub, Patient Insights and SDQ application
  • Learning and understanding of Clinical trial domain
  • Coordination with QA and bug fixing
  • AstraZeneca is a global, science-driven biopharmaceutical company, renowned for its innovative medicines that benefit millions of patients around the world
  • We manage clinical trial data across numerous studies, applying business logic to transform this data effectively
  • Following the transformation process, the data is updated in various dashboards within Patient Insights, ensuring timely access to critical information
  • Tools: DWH, Postgres SQL, GitHub, Airflow, Grafana, ZooKeeper, AWS Cloud (S3 Buckets)
  • Environment: Production and UAT

Technical Lead

Taiho, Kura Oncology, Incyte, Pathalys, Opthea, Eli-lily, Tscan, DayOneBio, Astex, Faraday
11.2022 - 09.2023
  • Company Overview: The Clinical Trial domain encompasses a diverse range of SaaS customers
  • We are successfully retrieving data from various source systems and performing load transformation
  • Following this transformation, the data is refreshed across multiple dashboards in both Patient Insights and Operational Insights
  • Leading the Customer Support Meetings
  • Carefully take care of data pipeline to ensure all expected source data is ingested successfully for transformation without any failures
  • Managing Customer Escalations and Stakeholder Escalations
  • Taking care of downtimes activities
  • Also available on weekend support for upgrade/deployment activities
  • Playing mentor role for new team members
  • Managing RCA and CAPA documents
  • Also handling account decommission activities and communication
  • Monitoring Ticket Queue & Ticket Assignments Daily basis
  • Taking care of the SLA & responsible for No breach of Support Process
  • Leading Daily Standups call with the Team to Review support tickets and helping for ticket analysis
  • Handling the Major Incident Management process for P1 Issues
  • Ticket analysis and troubleshooting
  • Collaborated effectively with the team to solve the issues
  • Managing Shift Schedules, Leaves and corresponding Backups
  • Conducting monthly 1:1 meeting with team to understand the pain points, suggestions and improvement ideas
  • Connecting with other support Leads to known latest Product features, issues, ideas, suggestions etc
  • Actively Learned our 24R1 LSAC products Data hub, Patient Insights and SDQ application
  • Learning and understanding of Clinical trial domain
  • Coordination with QA and bug fixing
  • The Clinical Trial domain encompasses a diverse range of SaaS customers
  • We are successfully retrieving data from various source systems and performing load transformation
  • Following this transformation, the data is refreshed across multiple dashboards in both Patient Insights and Operational Insights
  • Tools: DWH, Postgres SQL, GitHub, Airflow, Grafana, ZooKeeper, AWS Cloud (S3 Buckets)
  • Environment: Production and UAT

Senior ETL Consultant

Regeneron Pharmaceuticals
05.2020 - 10.2022
  • Company Overview: Regeneron Pharmaceuticals, Inc
  • Is an American biotechnology company
  • We are monitoring the analytical applications for the life science domain supporting the leading pharmaceutical companies like Regeneron
  • The Raw data adapters retrieve the various customer data sources and insert the data within the customer’s database
  • This data is then what is referenced within the CQS adapter mappings
  • We troubleshoot the adapters and handle the adapter’s failure
  • Responsible for ensuring our customers can maximize the benefits of the platform by assisting them through issues they may encounter in app
  • Taking care of the whole data pipeline load end to end
  • Closely monitor the LSAC Data Pipeline Adapter and troubleshoot the adapters
  • Analyze the mapping issue for the Adapter failure, find out the route cause analysis
  • As per user requirement enhancing code and submitting in GitHub by PR’s
  • Validating system data with user source systems like EDC, Rave Medidata, Veeva etc
  • Involved in SQL query to analyze the data
  • Coordination with QA and bug fixing
  • Involved in various dashboards / reports and taking appropriate actions as per customer or user demand after business approval
  • Grant or remove the user access to the application and visual objects
  • Regeneron Pharmaceuticals, Inc
  • Is an American biotechnology company
  • We are monitoring the analytical applications for the life science domain supporting the leading pharmaceutical companies like Regeneron
  • The Raw data adapters retrieve the various customer data sources and insert the data within the customer’s database
  • This data is then what is referenced within the CQS adapter mappings
  • We troubleshoot the adapters and handle the adapter’s failure
  • Responsible for ensuring our customers can maximize the benefits of the platform by assisting them through issues they may encounter in app
  • Environment: DWH, Postgres SQL, GitHub, Airflow, Sales force, Chronos, Messos, Sumo Logic, ZooKeeper
  • Environment: Production and UAT

ETL Consultant

PCYC LLC
09.2016 - 05.2020
  • Company Overview: Pharmacyclics LLC is an American biopharmaceutical company based in Sunnyvale, California
  • Its primary focus is upon the development of novel therapies for the treatment of cancer and immune-mediated diseases
  • Handled all EDW operation tasks
  • Analyzed the business requirements and functional specifications
  • Extracted all Sales, dispensing and inventory data from oracle database and flat files (txt or .csv) as Source to load it in Database
  • For extract JBI call by using Sales and maintaining all call details which is very essential for callers to meet prescribers or non-prescribers
  • Extract all spend data by flat files and generate report for each quarter which is sent by business to Federal Govt
  • Doing migration and unit testing for Informatica Power Center 10.1 up gradation activity
  • Extensively used Transformations like Router, Filter, Joiner, Expression, Lookup, Update strategy and Sequence generator
  • Developed mappings in Informatica to load the data from various sources
  • Delivering change requests (CR’s) on time without any error, debug
  • Interacting with MDM team in EDW-MDM data flow and validating master keys
  • Parameterized the mappings and increased the re-usability
  • Extensively used Informatica debugger to figure out the problems in mapping
  • Also involved in troubleshooting existing ETL bugs
  • Deployment activities of the code to Prod environment
  • Pharmacyclics LLC is an American biopharmaceutical company based in Sunnyvale, California
  • Its primary focus is upon the development of novel therapies for the treatment of cancer and immune-mediated diseases
  • Tools: Informatica Power Center 9.0.1, 10, 11, Informatica MDM, Oracle 11g, Toad, SQL Developer, Sales Force, Automic
  • Environment: Production and UAT

Consultant

AAA (America Automobile Association)
08.2015 - 08.2016
  • Company Overview: America Automobile Association, Inc is one of the most renowned firms in America which provide Insurance on Automobiles, Home and many more applications
  • The project is supposed to prepare an ETL design for consolidating data from the entire AAA legacy systems (like SIS, NPOS, AS400) spread across different regions of US and merge them with the new centralized schema (EXIGEN)
  • Analyzed the business requirements and functional specifications
  • Extracted data from oracle database and flat files (txt or .csv) as Source to load it in Database
  • Used Informatica Power Center 9 for extraction, transformation and load (ETL) of data in the data warehouse
  • Extensively used Transformations like Router, Filter, Joiner, Expression, Lookup, Update strategy and Sequence generator
  • Developed mappings in Informatica to load the data from various sources
  • Parameterized the mappings and increased the re-usability
  • Extensively used Informatica debugger to figure out the problems in mapping
  • Also involved in troubleshooting existing ETL bugs
  • Deployment activities of the code to Prod environment
  • America Automobile Association, Inc is one of the most renowned firms in America which provide Insurance on Automobiles, Home and many more applications
  • The project is supposed to prepare an ETL design for consolidating data from the entire AAA legacy systems (like SIS, NPOS, AS400) spread across different regions of US and merge them with the new centralized schema (EXIGEN)
  • Tools: Informatica Power Center 9.6.1, Oracle 11g, Toad
  • Environment: Production and UAT

ETL Developer

CISCO
03.2014 - 07.2015
  • Company Overview: CLIP stands for the Collaboration – Learning - Intelligence - Platform, an enterprise-wide collaboration and knowledge sharing platform
  • CLIP provides this visibility and understanding by bringing together data related to (customer and employees) escalations and continuous improvement efforts to improve the customer experience, on a single platform
  • To understand & analyses the business requirement documents and resolve the queries
  • Participating in SDR/SSA document preparation activities; to identify new entities which must be brought in as part of the release and leveraging existing entities
  • Participating in LDM activities to verify if the new model is as per the requirement
  • Based on the LDM and PDM, developing ETL’s with LRF and ELT passion
  • Preparing Unit Test cases for ETL and Report, validate the data from Source to Target 3NF
  • Prepared Unit Test cases for Reports and validated the data as per Business Requirement
  • Created and updated number of mappings, reusable sessions, and workflows
  • Also scheduling jobs by using $ Universe
  • Used Informatica features to implement CDC, SCD Type-1/2/3, versioning as well as mapping / workflow variables in the ELT logic
  • Created different documents like TSD, FSD, and SDR as well as unit testing documents
  • Created KPs and upload documents as per code drop requirement
  • Also supported code drop and deployment process at stage/production environments
  • Also to build various one to one or derived materialized Physical view (PV) & Business view (BV) as per business requirement for the reporting purpose like Tableau and (BO)
  • Give post-production support with monitoring jobs and validating incremental data
  • CLIP stands for the Collaboration – Learning - Intelligence - Platform, an enterprise-wide collaboration and knowledge sharing platform
  • CLIP provides this visibility and understanding by bringing together data related to (customer and employees) escalations and continuous improvement efforts to improve the customer experience, on a single platform
  • Tools: Informatica Power Center 9.6.1, Teradata, Oracle 11g, $Universe, KP
  • Environment: Production and UAT

ETL Developer

CISCO
01.2015 - 02.2015
  • To Enable Dashboard and Metrics for PEP (Partner Engagement Platform), this new partner engagement platform will help AS to interact with Subcontract Partners through this tool to Search/ Add/ Submit Requirements, Select Partner, and Raise PO requests for Pre-approval in providing exceptional delivery on customer projects
  • Tools: Informatica Power Center 9.6.1, Teradata, Oracle 11g, $Universe, HP Kintana Package
  • Environment: Production and UAT

ETL Developer

CISCO
08.2014 - 12.2014
  • CISCO is having various quoting tools like ASS, AST, and ASF where quotes will be created for allocation of different projects
  • This common platform for all AS-Transaction quotes will provide consistency in creating Customer Quote across Cisco Enterprise
  • Enable the capability of various BI reports on AS-Transaction/ Subscription and Fixed Quotes
  • The main objective of this project is to create new ETL or modified existing ETL’s as per business requirements
  • Tools: Informatica Power Center 9.5.1, Teradata, Oracle 11g, $Universe, KP
  • Environment: Production and UAT

ETL Developer

CISCO
03.2014 - 07.2014
  • Eagle Eye dashboard is the single source of reporting / visualization tool which will display “As Sold” and “As Delivered” financial metrics by sourcing relevant data from different Quoting Tools
  • This dashboard displays “As Sold Bookings amount” and “As Delivered Bookings Amount” for a specific End Customer with key attributes like Deal Id, Sales Order Numbers, and Project Codes with ATB (Arch/Tech/BS) tagging
  • Tools: Informatica Power Center 9.5.1, Teradata, Oracle 11g, $Universe, KP
  • Environment: Production and UAT

Education

Master of Computer Applications -

Shivaji University
Kolhapur
06-2013

Bachelor of Computer Applications -

Shivaji University
Kolhapur
06-2010

Skills

  • Data analysis
  • ETL and ELT processes
  • Technical troubleshooting
  • Microsoft Excel
  • Clinical Trial Management, Life Science,
  • Generative AI
  • Customer support
  • Team collaboration
  • Cloud computing
  • Training and mentoring
  • Informatica PowerCenter
  • Basic of Snowflake and DBT
  • Informatica MDM
  • Tableau 80
  • SQL/PLSQL
  • Basic Python
  • Scheduler - $Universe, Automic
  • Chronos and Mesos
  • GitHub
  • Airflow
  • Zookeeper
  • Grafana
  • Rancher
  • AWS Cloud (S3)
  • ChatGPT Prompt,
  • Freshdesk and ServiceNow
  • Jira

Accomplishments

  • Best Employee Award in Saama in year 2020
  • Multiple time I received Shining Star award in Saama
  • High Impact performer Award for Q2'2019 and Q4'2024

Certification

  • Successfully completed 3 Days workshop on ChatGPT & AI with MS Office by Skill Nation in Jun’2024
  • Successfully completed 3 Days workshop on Advanced Microsoft Excel certification in Jul’2024
  • Successfully completed 2 Days workshop on Azure Fundamentals (Az-900) in Oct’2024
  • Achieved Six Sigma Assessment Certification by LearnTube in Sep’2024
  • Achieved Project Management Assessment Certification by LearnTube in Sep’2024
  • Achieved Scrum Master Assessment Certification by LearnTube in Nov’2024
  • Achieved Data Analytics Assessment Certification by LearnTube in Nov’2024
  • Successfully completed “Generative AI for All” in Nov’2024

Languages

Marathi
First Language
English
Advanced (C1)
C1
Hindi
Proficient (C2)
C2

Timeline

Senior Principal Support Engineer

AstraZeneca
10.2023 - Current

Technical Lead

Taiho, Kura Oncology, Incyte, Pathalys, Opthea, Eli-lily, Tscan, DayOneBio, Astex, Faraday
11.2022 - 09.2023

Senior ETL Consultant

Regeneron Pharmaceuticals
05.2020 - 10.2022

ETL Consultant

PCYC LLC
09.2016 - 05.2020

Consultant

AAA (America Automobile Association)
08.2015 - 08.2016

ETL Developer

CISCO
01.2015 - 02.2015

ETL Developer

CISCO
08.2014 - 12.2014

ETL Developer

CISCO
03.2014 - 07.2015

ETL Developer

CISCO
03.2014 - 07.2014

Master of Computer Applications -

Shivaji University

Bachelor of Computer Applications -

Shivaji University

Similar Profiles

CREATE PROFILE
Sandeep Ranage