Summary
Overview
Work History
Education
Skills
Certification
ACHIEVEMENTS & AWARDS
Handsonexperience
Publications
Personal Information
Languages
Hobbies and Interests
Activities
Timeline
Generic
Ravi Kumar Koduru

Ravi Kumar Koduru

Summary

An experienced and self-driven Data Analyst with a strong foundation in Data Stewardship, Master Data Management (MDM), and Data Quality. I am passionate about leveraging advanced data analytics, ETL processes, and visualization techniques to solve complex problems and deliver data-driven insights. Seeking a challenging role in a dynamic environment where I can contribute to data-centric projects and collaborate with cross-functional teams to drive business value.Being self-learner, and Data Steward with a keen interest in the latest technological development such as Analytics, Visualization, and Data Science, with a high affinity towards Data Analysis, looking for a responsible full-time career opportunity in data analysis where I can work with experienced professionals and reach my full potential. Being ambitious and hard working, I am looking forward to challenging my potential and be worthy of management trust and confidence.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Tech Analyst

Roche Products (India) Pvt Ltd
05.2023 - Current
  • Led process improvement initiatives across all DCR and non-DCR activities, resulting in enhanced efficiency and effectiveness
  • Updated existing Standard Operating Procedures (SOPs) for DCR activities and developed new SOPs for non-DCR activities
  • Implemented Pyspark automation for Non-DCR activities, including output validation and validation of manual stewardship activities performed by teams
  • Spearheaded the Geo Tracking (Gsnapple) Proof of Concept (POC) project, leveraging Pyspark automation and manual stewardship automation
  • Developed SOPs for both processes
  • Designed and developed Google Locker Studio dashboards to visualize key metrics and facilitate data-driven decision-making
  • Engineered a Google Appscript to automate data movement within Google Drive, complemented by Pyspark automation for seamless data processing
  • Created SOPs, resolutions, and reports generation processes for Salesforce PACT DCRs, ensuring adherence to best practices and compliance standards
  • Developed Data Quality reports to monitor and maintain data integrity and governance on a periodic basis
  • Conducted domain knowledge transfer sessions for teams within Data Management and Architecture, facilitating cross-functional collaboration and skill development
  • Identified and reported data issues in Reltio platform, in addition to daily DCR and non-DCR activities, ensuring data accuracy and consistency
  • Utilized a wide range of technologies including AWS cloud services (Athena, S3), Python, Pyspark, SQL, Sage Maker notebook and studio, Google Cloud Platform, and Appscript to deliver innovative solutions and drive business objectives.

Software Developer

Circulant Software Private Limited
10.2021 - 05.2023
  • Data Change Request processing, inputs to add new daily Data Quality checks, Enhanced the existing SOPs and Worked on multiple Data quality reports i.e
  • Duplicate identifier report ( merged the records in Reltio MDM), Missing Identifier Report ( adding missing key details to accounts in Veeva), Data Quality report, Custom DQ checks, Ad- hoc requests to ensure data quality and data integrity
  • Enhanced/improved the Data Change Request processing, added multiple steps to ensure data quality and to avoid creating duplicate records in Veeva CRM
  • Utilized such technologies as Advanced MS tools, SQL Server and Tableau for Data Analysis and Reporting
  • Understood the role and responsibilities of data steward, assists with the team and coordinated meetings, agendas, trainings and trained team data stewardship tasks, Clinical Trails Concepts and accountable for delivering daily tasks and reports
  • Participated in a project strategy development meetings, assisted in GPO roster DB development, data validation, python fuzzy mapping and manual mapping
  • Performanced data profiling and webscrping for HCP conferences data
  • Worked on Incentive Compensation payroll adjustments data validation and analysis, solving field team questions and problems by teaching out the provider
  • Complete Incentive Compensation Roster file validation, Contest plan proposal, presenting and making changes on field team requirements
  • IC plan document validation, correction and updating in the Mainsail and sending dashboard report to field
  • Handling Ad hoc requests, client communication and handled the client independently, etc.

Education

Master of Science - Pharmaceutical Technology

Shri Vishnu College of Pharmacy
Bhimavaram, India
09.2021

Bachelor of Science - Pharmacy

Bapatla College of Pharmacy
Bapatla, India
03.2019

Skills

Technical Skills:

  • Programming: Python, SQL
  • ETL & Data Warehousing: SSIS, SQL Server, Alteryx, Dataiku
  • Cloud Platforms: AWS Athena, S3, SageMaker, Google Cloud Platform
  • Data Visualization: Tableau, Google Looker Studio, Excel
  • Data Management: Master Data Management (MDM), Data Stewardship, Data Quality
  • Methodologies: Agile, Data Quality Governance, SOP Documentation
  • Domain Expertise: Pharma, Life Sciences, Incentive Compensation, Data Quality Management

Soft Skills:

  • Excellent communication, presentation, and stakeholder management skills
  • Strong leadership and team coordination abilities
  • Problem-solving and analytical reasoning

Certification

  • Solutions Architect Foundation Certification from Reltio
  • Dataiku Core Designer
  • Looker Studio for Beginners and Makers
  • Data Analyst Foundation Certification
  • Data Stewardship Foundation Certification
  • Coursera verified certificate for IBM data science specialization
  • EdX verified certificate for statistical thinking for data science and analytics
  • Explore and analyze data, create views and dashboards in tableau

ACHIEVEMENTS & AWARDS

  • Raising Star award in the GATE Excellence Mid Year Awards - 2024
  • Performer of the month in GATE excellence award: April 2024
  • Game Changers award in the GATE Excellence Mid Year Awards - 2023.
  • Handled Client Independently and worked independently on Incentive Compensation project, gSnapple PoC and Data Stewardship tasks as well.

Handsonexperience

Tools & Technologies:

  • AWS: Athena, SageMaker, PySpark, S3
  • Advanced MS and google tools, SQL Server, Python, Tableau, Reltio MDM, Veeva CRM, Mainsail IC Dashboards
  • IDEs : Jupyter Notebook, MS SQL Server

Publications

  • A Paradigm Shift in Ocular Drug Delivery to Posterior Segment: Review on Current drug Delivery Approaches, https://doi.org/10.9734/jpri/2021/v33i40A32226
  • The Art and Science of Flirting: A comprehensive guide to communication, human biology and phycology.

Personal Information

  • Date of Birth: 10/05/1997
  • Marital Status: Single

Languages

English
Bilingual or Proficient (C2)
Telugu
Bilingual or Proficient (C2)
Tamil
Bilingual or Proficient (C2)
Hindi
Intermediate (B1)

Hobbies and Interests

  • Data Science & Analytics, Reading Books, Writing Stories

Activities

  • Trainer for Data Stewardship tasks and DCR Processing
  • Organized and led workshops on pharmacology at national conferences

Timeline

Tech Analyst

Roche Products (India) Pvt Ltd
05.2023 - Current

Software Developer

Circulant Software Private Limited
10.2021 - 05.2023

Master of Science - Pharmaceutical Technology

Shri Vishnu College of Pharmacy

Bachelor of Science - Pharmacy

Bapatla College of Pharmacy

Similar Profiles

CREATE PROFILE
Ravi Kumar Koduru