pg. *
Prativadi Ranga
Contact
**.*****@*****.***
Work Experience
• Worked in TCS as Data
Scientist from Dec 2000 to
April 2025
Skills
• Python (NumPy, Pandas,
Scikit-Learn) & R
• Practical Statistics (EDA,
Regression, Clustering)
• Machine Learning
(Classification, Decision
Tree, etc)
• SQL & NoSQL ( MySQL &
Postgres ) & Knowledge on
Vector Databases & ETL
tools
• Data Visualization tools –
Excel, Tableau & Power BI
• ML model Deployment
tools: Gradio, Kubernetes,
Amazon Sagemaker &
Docker
• Exposure to Deep Learning
Models
(ANN, CNN, RNN, Pytorch,
Tensor Flow, Keras, Llama 2
, BERT, GPT 4)
• DevOps tools: Jenkins,
GitHub & AWS
Certification
• Certified Advance Data
Analytics, Machine
Learning, and Artificial
Intelligence - IIIT, India
Education
• Master’s degree in
Computer Applications
(MCA), University of
Hyderabad, India
• Master’s degree in Applied
Statistics (MSc), India
Profile
Worked as a Data Scientist for the past 4+ years in the Retail domain in developing solutions from complex datasets using the latest models in AI/ML to drive data insights. Looking for opportunities to work in AI/ML/DL & GenAI platforms in developing solutions by leveraging applied statistics with 25+ years of traditional software development.
Linkedin : www.linkedin.com/in/ranga-prativadi-87082b9 Work Experience (Current Project)
Role: Data Scientist Aug 2021 – April 2025
Client : ALDI – USA, Austria, Germany, Australia
• Data Bureau is a Retail Pricing Product to Retail companies ( Food & Beverages Categories ) for comparing item prices identified by competitors. Retailers can view daily, weekly, and monthly trends to determine pricing strategies.
• Web Extraction of Price data/information and Data Cleaning / Preprocessing for SKU and prediction of the categories. Developed a Data mining tool which helped to reduce the processing time by 15 hrs per week.
• Item Matching with 75% accuracy through NLP semantic models using the Google Taxonomy Models and GS1.
• Designed a Data Model to manage the pricing history, integrated solution with the visualization tools: Power BI, Tableau, and Mobile Applications
(developed using Power app)
• Designed Dashboards for retailers for data interpretation by stakeholders / key departments.
• Worked as Domain Product Owner to integrate solutions for others customers like M&S, Walmart
• Designed and implemented a reusable solution that can be deployed across different retailers & globe through the setting of configurable / CI &CD Pipeline.
• Build a product capability for the Fashion category and demonstrate it to others retailers: M&S
• Roadmap built in to incorporate the features of Assortment intelligence Client: Amazon, USA
• Web Extraction of the Amazon Customer Reviews to develop/showcase GenAI application proof of concept for Amazon USA,
• Used Python libraries and Excel to analyze the data. Smart Digital Merchandising Suite (SDMS) for Croma
• SDMS is one platform built to provide a solution to supplier management & product management catering to the retail market. It has the following features
• Vendor Onboarding & Product Onboarding through customized templates, EDI feed, and workflows integrated with GS1 attributes.
• Define promotions with process flows, calendar, channels, promotion types, and budgets by category/campaign/event covering all phases from planning, optimization & execution.
• Define Pricing with different pricing strategies, and pricing relationships covering all phases from planning, optimization, management & execution.
• Define Space Planning ranging from macro space, micro space, store design, and planogram strategies into visual merchandising.
• Integration with internal applications Optaire & Data Bureau and also with third- party applications like SAP, Oracle Product on the pricing information and promotion data
pg. 2
Technologies & Tools
• Front end Tools: HTML,
React NS, Flutter, Angular J
Java Script, Bootstrap & CSS
• Backend Tools: Node JS,
Django, Spring boot, PHP,
Flask
• Databases: MySQL & Oracle
• IDE’s: Pycharam, Visual
Studio, Jupyter Notebook &
Google Colob.
• Testing tools: JMeter, JUnit,
Selenium & LoadRunner
• Deployment tools: Maven
& Postman
Industry Domain
• Retail & Consumer Services
• Banking & Financial
Services
• Automobile
• Human Resources
• IT Services
• Healthcare
• Electrical & Power
Software Methodologies
• Agile development
methodology ( Jira, Sprint
Planning, Kanban Boards,
Asana, Notion)
• Waterfall development
Quality Process
• Data Privacy & GDPR
• ISO 9000
• CMMI & TL 9000
Awards & Recognitions
• Special Initiative Award –
Mar 2024
• Innovista tops seeds Award
– Mar 2024
• Team Award – Jan 2023
• Best Auditor Award – Jan
2023
• Designed Dashboards for retailers for data interpretation by stakeholders / key departments.
• Implemented for customer Tata Croma, India
Optumara
• Optaire is one platform built to provide a solution to pricing solution and there is a feature to develop a Text to SQL GenAI application using LLM models.
• Automatic generation of the SQL scripts to execute text-based queries
(prompts) using the prompt engineering and RAG technique
• It is the generation of SQL queries from chat built using the Llama model, Different Prompt engineering techniques are being used to evaluate the AI model built on top of the model.
• The data schema was designed. The business rules are defined and used to build semantic knowledge.
Key Achievements ( last 10 years )
• Use of the statistical models: Logistic Regression, Random Forest, Multinomial Naïve Bayes, Support Vector Machine, Decision Tree & Gaussian Naïve Bayes. to predict the model accuracy, precision, recall & F1.
• Created text generation model for test automation using Open AI
• Integration of Visual Dashboards – Power BI with the product
• Established Printing and Imaging Centre of Excellence in collaboration with Xerox., one of the key offerings was the re-engineering of legacy code which resulted in Xerox in cost savings of $ 2 million per year.
• Executed Six Sigma initiatives in Xerox ODC, which resulted in effort saving of around 5 person-years ( ~ USD 250 K )
• Achieved 15 % YoY productivity gain on Testing and Sustenance Projects.
• Managed the integration of Network Analysis (GIS Application) and MDAS applications, successfully deployed in 4 pilot sites which has increased project profitability by 5 %.
• Developed a smart solution that reduced the number of manual data entries from 70 % to <10 % decreasing processing time to book tickets & transportation for the Campus Recruitment project.
• Designed and Implemented email package that automatically notifies about the project requirements, and travel details.
pg. 3
Project History
Period
Aug 2018 - Apr 2021
Role
Digital Operations Lead for Hiring
Business Associates and Sub-
contracting Process
Digital Product Owner Global
Business Associate Management
System
Software / Tools
Python, R tool,, Java, Share
Point, Hibernate,
Big Data Technologies: Hadoop,
Spark, Hive, Pig, Kafka,
Elasticsearch
Data Analysis Tools: Excel, Tableau,
Power BI, Google Analytics,
MATLAB
Client
TCS Internal
Team Size
30
Period
Jan 2017 - Jul 2018
Role
Digital Operations Lead for -
Trainee Engagement Program
Software / Tools
Java, Springs, Hibernate, Big Data
and Hadoop, Oracle, R Tool &
Python
Client
TCS Internal
Team Size
10
Details
Project Title
Digitization of Hiring the Business Associates under the Resource Management Group (RMG) .
Description
The scope of Business Associates Hiring is fulfilling the resource requirements for all projects/business units globally, mainly in the USA and Europe. The scope of the work as product owner for an internal tool to prioritize requirements
& publish a roadmap in coordination with stakeholders: HR Compliance & IT Implementation Team.
The scope of work in sub-contracting activities expands from vendor creation, Contract Creation, PO creation, and Vendor Payments on software sub-contracting by coordinating with stakeholders mainly: IT Teams, Finance & Third-Party Vendor The KPI are MBTA, Demand vs Fulfilled Ratio, Deployment Index, Predicting the Resource Requirements, and suggesting the top 5 possible profiles using the semantic search.
Roles & Responsibilities
Product owner - TCS Internal tool for capturing the Business Associates Requirements. Preparation of Roadmap by prioritizing and planning requirements with stakeholders.
Coordinating with Vendors on profile submissions. Tracking and coordinating the profiles with other stakeholders on closing.
Business Benefits
Developed solutions using Python and R, improving data processing speed by 30%. Supported the development of a statistical model that boosted resource prediction accuracy by 15%
Project Title
Digitization of Trainee Engagement Program under the Resource Management Group (RMG)
Description
RMG is internal support group to manage the resource requirements across all projects in TCS Hyderabad Location.
The vision of this program is to build the competency of unallocated/unmapped resource pool trainees from Domain and Technology perceptive based on the project projections/requirements.
The main KPI of this program is reducing the lead time on boarding the resources in the project. No of resources vs Competency Mapping, Trained resources vs fulfillment ratio.
Roles & Responsibilities
Build competency/technology matrix across all projects/business units. Coordinating with other stakeholders: Learning & Development Developing the Banking & Financial & Health Care Domain using the Business Domain Academy (internal tool)
pg. 4
Period
Aug 2015 - Dec 2016
Role
Digital Operations Lead for –
Campus Recruitment Lead
Software / Tools
MS Project, Share Point, Excel
Client
TCS Internal
Team Size
5
Period
Aug 2012 -Jul 2015
Role
Digital Lead – Internal Applications
Software / Tools
Java, Springs, Hibernate, Big Data
and Hadoop, Oracle, Middle ware,
TCS - Test Automation Tools (
Selenium )
Developing the PoC for Health
care domain using HEDIS
measures. Software
Development methodologies using Agile ( Use of JIRA tool ) Banking and Financial, Health Care, Domain.
Business Benefits
Groomed 2000 trainees and reduced the mean time for utilization (allocation) by 30
%
Successfully utilized Tableau and SQL for data visualization, making complex data understandable for stakeholders and enhancing decision making process Project Title
Digitization of Campus Recruitment Operations under the Human Resources Group (HR).
Description
HR - Talent Group is an internal support group to drive the campus requirements across all colleges for UG/PG graduates across the states of TG & AP of India. The objective of this program is to map the interview panels by forecasting the requirements & competency.
The KPI is planned vs actual no of panels, Average day-wise drive time, Zero Security Incidents, and Ethical Cases.
Drive Conducted in 80+ Colleges/Universities, around 10 K students participated. Identification of the Risks and Deploying Risk Mitigation Plan. Roles & Responsibilities
Planning the panel requirements for each college drive, travel & transport requirements. Coordinating with other departments like Travel, HR, CoE's & Project Owners.
Reducing the variance time between the planned vs actual no of panels. Ensuring the security/safety of the technical panels by coordinating with the TCS First Safety group.
Used digital tools for effective planning and execution in scheduling and travel arrangements.
Business Benefits
Achieved 95% On Time Delivery
Reduced the operational cost by 90 % by eliminating the waste expenditure. Minimized the cost overrun by 80 %
Project Title
Building the in-house applications, TCS - USA
Description
RMG is an internal support group to manage the resource requirements across all projects in the TCS Hyderabad Location.
This program aims to develop the applications required for this group. The main KPI of this program is 100% utilization of the resources (waiting for the project) Identifying the Integration Gaps / Requirements between the various applications and reducing the processing time.
pg. 5
Client
TCS Internal
Team Size
8
Period
Jul 2010 - May 2012
Role
Technical Program Lead
Software / Tools
Oracle CC & B Utilities Java, Oracle
BI, Oracle 10 g, Oracle MDM 2.0
Client
Power Finance Corporation, Govt
of India
Team Size
40
Period
May 2008 - June 2010
Role
Project Management Office –
Digital Operations Lead
Roles & Responsibilities
Development of the Resource Tracking System.
Development of the Attendance Monitoring System.
Development of the Transport Requirements & Tracking tool. Integration with TCS First Safety Tool. Requirements gathering and Use Case Mapping.
Business Benefits
Achieved 90% On Time Delivery
Project Title
Commission for IT enablement in Power Sector - Restructured Accelerated Power Development Reforms Program (R-APDRP) under Min of Power, Gov of India
Description
TCS was selected as ITIA partner for AP state in the implementation of R-APDRP program.Mainly it will focus on actual, demonstrable performance in terms of sustained energy loss reduction. The establishment of reliable and automated systems for sustained collection of accurate base line data, and the adoption of Information Technology in the areas of energy accounting will be essential before taking up the regular distribution strengthening projects. Applications developed under this project are:
• Centralized call center, New Connection & Disconnection
• Energy Audit, MDAS, Metering Billing and Collections & MIS Roles & Responsibilities
Responsible for setting of DC and DR centers by coordinating with various hardware vendors like IBM, HP ..etc, and distribution centers Responsible for setting of the IVR call center and web-based application to track & monitor calls.
Responsible for the requirements gathering and design of the applications across all distribution centers.
Coordination with GIS vendors on a collection of Geo Data and third-party vendors on Meters.
Integration of application of Oracle CC&B Database, Oracle MDM, third-party MDAS application, GIS Application
Business Benefits
Achieved 90% On Time Delivery
Project Title
IT Transformation – Auto Cluster
Client: Chrysler, USA
Description
US Auto1 cluster is a sub-group under the manufacturing business unit of TCS. This group supports all OEM customers based out of Detroit, USA mainly Chrysler, General Motors, Delphi, Arvin Meritor, Ford & TI Group Automotive. pg. 6
Software / Tools
Java, C++, C, Lotus Notes
Client
US Auto OEM Customers (
Chrysler, GM, Delphi, Ford)
Team Size
5
Period
May 2004 - Apr 2008
Role
Technical Solution Architect
Software / Tools
UML, Test Case
Management Tools, Test
Automation tools (Silk),
Core Java, SharePoint, C,
C++, Visual C++, ASP,
.NET, C & Network
Protocols
Client
Xerox Corporation, USA
The scope of work includes deployment of operational excellence and delivery excellence process mainly in the areas of Contract Management, Revenue Projections, Outstanding, and Delivery 25 Parameters in all accounts TCS associates deployed in this cluster should undergo a competency-building program (Automotive Experiential Learning Plan). Processes, Communication and Leadership. technology-enabled solutions in the automotive space. Roles & Responsibilities
Responsible for improving the top-line and bottom-line parameters like revenue, gross margin, and offshore leverage.
Planning and Scheduling associates to real-life environments through visits and work in Automotive Manufacturing Plants, Automotive Dealerships, Distribution centers,etc.
Intense classroom sessions on domain, industry & related concepts along with along with technology enabled solutions in automotive space. Creating the business process in the transformation of the applications Business Benefits
Reduction in the Outstanding by 50% and Increased Payables Receivables by 30% Project Title
Maintenance and Development of the Projects for Xerox Office & Production Printers.
Description
US Auto1 cluster is a sub group under the manufacturing business unit of TCS. This group supports all OEM customers based out of Detroit, USA mainly Chrysler, General Motors, Delphi, Arvin Meritor, Ford & TI Group Automotive. Xerox is US based leading peripheral equipment vendor. Xerox and TCS has undergone agreement to provide software services for the Production Support Group and Office Support divisions of Xerox. TCS has set up printer lab with about 40 printers at TCS-Hyderabad for providing the Development, Maintenance & testing services for Document management solutions and printers network controller solution projects.
Brief overview of scope of the services:
Regression & Performance Test services team for one of the Xerox core Products
– Print Controller Software. The main activities are the preparation & execution of Regression test cases, Performance & Reliability testing, and development of GUI test cases.
Developed workflow management product – Output manager and Configurations tool using core Java. Major activities are System Design, Implementation, and Upgrade/Migration test activities of the product.
Maintenance of the Windows Printer drivers for the Xerox Office suite of printers. Design, development, testing, and maintenance of Document Repository Service Adapters (SharePoint Office etc.)
Roles & Responsibilities
Responsible for Technical Solutions for the applications executed in the offshore development center
Responsible for the Quality Deliverables of this application pg. 7
.
Period
May 2003 - Mar 2004
Role
Technical Solution Architect
Software / Tools
UML, Core Java,
Client
GE Corporate, USA
Responsible for implementing TCS quality systems in the projects and ensuring to meet SLA defined by customer and TCS. Identify potential root cause analysis in case of deviations / major gaps.
Responsible for identifying the areas to improve the productivity of the team Business Benefits
Establishment of Printing Center of Excellence.
Achieved 12% YOY productivity by implementing innovative solutions and ideas. Client : GE Corporate, FL, USA
GE Corporate is responsible for developing and deploying the in-house applications required for GE companies across the USA mainly payroll, vendors, and invoice reconciliation.
Roles & Responsibilities
Creating the use cases for GE Corporate applications interacting with SMEs and offshore development centers.
Business Benefits
Developed use cases resulted in a reduction in the rework by 90%. Other Projects
• Worked as lead business analyst for Honey well, AZ, USA
• Worked as a Programmer for LEM (Electrical Product), Switzerland application developed using Visual C++
• Worked as a Programmer for Radiometer (Blood Gas Analyzer), in Denmark applications developed using Visual C++
• Worked as Solution Architect lead for NEC, Japan application developed using Visual C++
Onsite Experience
• Worked Technical Programmer for Southern California Gas Company, LA, USA
• Worked as a lead business analyst for Honey Well, AZ, USA
• Worked as lead Business Analyst for GE Corporate, FL, USA
• Worked as a Programmer for LEM (Electrical Product), Switzerland
• Worked as a Programmer for a Radiometer (Blood Gas Analyzer), in Denmark
• Worked as Technical Business Analyst for Berlinkse AG ( leading newspaper), Denmark
• Worked as Solution Architect lead for NEC, Japan
• Worked as Solution Architect lead For Ericsson, Sweden
*** end of profile ***