Rajani Roopanagudi
Benguluru
Summary
Highly skilled BI Data Analyst with strong background in deciphering complex data sets and creating strategic business insights. Known for comprehensive knowledge of database languages, data mining, and predictive modeling to support decision making processes. Possess effective problem-solving skills, ability to meet tight deadlines, and commitment to maintaining highest standards of data integrity. Made significant contribution in previous roles by identifying business opportunities through meticulous data analysis and reporting.
Overview
17
17
years of professional experience
1
1
Certification
Work History
GSP Analytics Team Lead
Applied Material India Pvt Ltd
India
07.2022 - Current
- Working as BI Data Analyst and Data management Operation all data related roles , like database handling , data mining ,data cleaning and Developing the Tableau Dashboards and metrics .Working on Tableau Server activities Automated QBR process reducing weeks of manual effort
- Work with GIS to ensure accuracy and update as needed
- Procurement Ops analytics lead Managing the Offshore Team and assigning the works
- Combined multiple data sources by joining tables using Data Blending for difference bigdata sources like presto, hive and Impale, Etc
- Developing Machine Leaning Algorithms using python for analytics data process use cases(Vendor matching , spend forecast using ARIMA, resume text parser) Handling Procure to pay ECC and SRM report and data maintenance
- Working as Tableau Server admin for G2P reports Developing the models from extracted data by applying various concepts predictive analysis which could make a prediction with high probability and less error
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
- Created customized interactive dashboards in Tableau using Marks, Actions, filters, parameters, and calculations
- Connected Tableau server to publish dashboard to a central location for portal integration
- Maintained Test log and Wrote test Evaluation, Summary Reports
- Extensively involved in doing user acceptance testing (UAT)
- Generated Test Cases for each specification in Requirement Specification Document corresponding to each module
- Analysed user and business requirements attended periodic meetings for changes in the application requirements and documents
- Participated in the User Acceptance Warranty Testing
- Involved in doing security and negative testing of the application.
BI Data Analyst
ICONMA
Bangalore
06.2020 - 07.2022
- Working as BI Data Analyst and Data management Operation all data related roles , like database handling , data mining ,data cleaning and Developing the Tableau Dashboards and metrics .Working on Tableau Server activities Combined multiple data sources by joining tables using Data Blending for difference bigdata sources like presto, hive and Impala,..etc
- Developing the models from extracted data by applying various concepts predictive analysis which could make a prediction with high probability and less error
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
- Created customized interactive dashboards in Tableau using Marks, Actions, filters, parameters, and calculations
- Connected Tableau server to publish dashboard to a central location for portal integration
- Maintained Test log and Wrote test Evaluation, Summary Reports
- Extensively involved in doing user acceptance testing (UAT)
- Generated Test Cases for each specification in Requirement Specification Document corresponding to each module
- Analysed user and business requirements attended periodic meetings for changes in the application requirements and documents
- Participated in the User Acceptance Warranty Testing
- Involved in doing security and negative testing of the application.
Bigdata Data Analyst and DMO Analyst
Altimetric
Bangalore
01.2019 - 06.2020
- Working as Data management Operation all data related roles , like databse handling , data mining ,data cleaning and Developing the Tableau Dashboards and metrics .Working on Tableau Server activities Combined multiple data sources by joining tables using Data Blending for difference bigdata sources like presto, hive and spark,..etc
- Working on Annotation service recommendation system using elastic search
- Developing python programs for creating index and exporting data into elastic search
- Analysis of Information can be extracted from the unstructured source code of twitter APIs
- Developing the models from extracted data by applying various concepts predictive analysis which could make a prediction with high probability and less error
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
- Responsible for interaction with business stake holders, gathering requirements and managing the Delivery Developing report level logic as per the requirement, DB constraints and creating POC for client approvals
- Created customized interactive dashboards in Tableau using Marks, Actions, filters, parameters, and calculations
- Connected Tableau server to publish dashboard to a central location for portal integration
- Maintained Test log and Wrote test Evaluation, Summary Reports
- Extensively involved in doing user acceptance testing (UAT)
- Generated Test Cases for each specification in Requirement Specification Document corresponding to each module
- Analysed user and business requirements attended periodic meetings for changes in the application requirements and documents
- Participated in the User Acceptance Warranty Testing
- Involved in doing security and negative testing of the application
- Developed the Dashboards for Sentiment analysis based on user reviews
BI Data Analyst, Tableau consultant
Altimetrik
Bangalore
01.2017 - 12.2018
- Developing the Tableau Dashboards and metrics .Working on Tableau Server activities Combined multiple data sources by joining tables using Data Blending
- Preparing Web Data Connectors and generating the tableau dashboards
- Used Annotations (Point, Mark and Area) to highlight the views
- Implemented various KPI’s in the Dashboards for better analysis
- Performed YOY, QOQ, YTD, QTD and MTD calculations in the Dashboard
- Developed Tableau Scorecards, Spotlights using logical calculations
- Created and modified guided navigation links within Interactive Dashboards
- Published Workbooks & Data Sources to Server and exporting the reports in different Formats
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
- Responsible for interaction with business stake holders, gathering requirements and managing the Delivery Developing report level logic as per the requirement, DB constraints and creating POC for client approvals
- Created customized interactive dashboards in Tableau using Marks, Actions, filters, parameters, and calculations
- Connected Tableau server to publish dashboard to a central location for portal integration
- Maintained Test log and Wrote test Evaluation, Summary Reports
- Extensively involved in doing user acceptance testing (UAT)
- Generated Test Cases for each specification in Requirement Specification Document corresponding to each module
- Analysed user and business requirements attended periodic meetings for changes in the application requirements and documents
- Participated in the User Acceptance Warranty Testing
- Involved in doing security and negative testing of the application.
BI Data Analytics Internal development
Altimetrik
Chennai
04.2015 - 11.2015
- Architecture Design and development Analyzing end user requirements and developing technical solutions
- Strong analytical database design and data modeling skills
- Data extraction from Oracle 10 g/ SQL Server / MS Excel and load data into QVDs (Raw QVDS)
- Using ETL Techniques to Extract, Transform and Load the data into QlikView Application
- Designed dashboard & building business logic for creation of reports
- Creation of unit Test cases and Review
- Update the project status during weekly Presentation
- Architecture Design and development Analyzing the data and generating various metrics in Tableau
- Publishing the Tableau dashboards in server
- Creating the POC on various data using BI reporting tools qlikview and Tableau
- Creating design documents for mentor mentee dashboards Configure the tableau servers.
Technical Lead
Mastercard International
Malaysia
01.2012 - 03.2015
- Design and Development of Web FOCUS reports as per the business requirements and this project deals with corporate data fetched from huge application called Smart Data Generation 2, which stores and updates the transaction data worldwide happened through Master Card
- SDG2 offers reporting services for public and private users
- Analysis of the specifications provided by the clients Analysis of the specifications provided by the clients Design and Development of Web FOCUS Reports Developed the Web focus Reports in PDF, HTML and Excel2k format Developed the Dashboards in Managed Reporting Environment
- Creating launch pages for Reports using HTML and JavaScript
- Involved in System Testing and also helped user for UAT testing
- Fixing any issues raised by testers
- Involved in unit testing.
Technical Lead
Ericsson
Sweden
01.2010 - 01.2012
- Ericsson is using ISPTOOL application to collect In-Service Performance data from AXE, AXD, CPP, IS, TSP & WPP nodes in customer network World Wide and stored in a database from where useful In-Service Performances statistics like “Average System Downtime/node/year” and event statistics like ”Down Time by Event” and ”Small Restarts/Exchange” etc can be generated
- ISPTOOL is used to store and processing of ISP data from system logs derived from different network elements
- It’s primarily used by Ericsson internal users to monitor product performance that includes data for node disturbances and focused on node availability
- Analysis of the specifications provided by the clients Involved in requirements gathering from the business users to build the Graph in ISP Tool application
- Created Graphs & Reports by using WebFocus desktop in all Formats like PDF, Excel2k and HTML
- Handled off-shore team from onsite
- Interacted with other vendors for wind-up KT Migrating data from Classic tool to Evolved tool Involved in System Testing and also helped user for UAT testing
- Prepared deployment document for production Releases
- Loading Data in to Focus Database using Web Focus.
Technical Lead
TCS
Minneapolis
09.2007 - 03.2010
- Target has different projects to cater to different wings of retail operation like, Guest Credit, Common Order, Sales History, General Merchandise System etc
- Development Support Services is the main technology group which does the research and makes decision on which technology fits best to Target’s software system requirements
- Also this group works on emerging new products, extends support to the developers involved in developing systems using Development Support Services approved technologies
- The scope of the project is to develop the RIP Application reports using Web focus and maintain vendor support
- These applications consists of some core solutions for specific business use
- Solutions can also be added to the application with respect to their requirements
- Being a member of Target DevTech RIP (Repeatable Infrastructure & Pattern) project I’m mainly involved in developing the reports for RIP Applications which comprises of application, solutions, services, deployment details and contact details
- This application includes developing the business Oriented report Screens in the Web Focus Language ,java script with having the Oracle Database as back end .This application basically maintain the Application ,solution, services ,deployment details and contact details
- As of the support/maintenance phase I have to fix bugs which arise in the existing code as it was moved to production
Education
Master of Computer Application (MCA) - Computer Application
JBICT
Tirupati,India05-2005
Bachelor of Computer Applications - Computer Application
Sri Venkateswara University
Tirupati,India05-2001
Post Graduate Diploma in Applied Statistics (PGDAST) From IGNOU -
Igno
Bengalore, IndiaSkills
- Data Visualization
- Data Engineering
- Data Analytics & Science
- Data management
- Data Modeling
- Data Mining
- data Cleansing
- tableau Desktop and Server
- Hadoop
- Python
- SQL,Hive,Impala
- Machine Learning
- BI Tools Expertise
- AI and LLM
- pandas, NumPy and scikit, prophet, ARIMA Models and Rapid Fuzzy/fuzzy wuzzy algorithms
Accomplishments
- Data Wizard
- Data Guru
Certification
- Sun Certified Java Programmer(SCJP) Certification
- Oracle Certified Associate(OCA)
- AI For everyone(CSRDATA366)
- Generative AI And LLM's
Languages
English
First Language
Telugu
Proficient (C2)
C2
Tamil
Intermediate (B1)
B1
Hindi
Intermediate (B1)
B1
Hobbies
- Travel
- Learning New Cultures
- Yoga
Timeline
GSP Analytics Team Lead
Applied Material India Pvt Ltd
07.2022 - Current
BI Data Analyst
ICONMA
06.2020 - 07.2022
Bigdata Data Analyst and DMO Analyst
Altimetric
01.2019 - 06.2020
BI Data Analyst, Tableau consultant
Altimetrik
01.2017 - 12.2018
BI Data Analytics Internal development
Altimetrik
04.2015 - 11.2015
Technical Lead
Mastercard International
01.2012 - 03.2015
Technical Lead
Ericsson
01.2010 - 01.2012
Technical Lead
TCS
09.2007 - 03.2010
Master of Computer Application (MCA) - Computer Application
JBICT
Bachelor of Computer Applications - Computer Application
Sri Venkateswara University
Post Graduate Diploma in Applied Statistics (PGDAST) From IGNOU -
Igno
- Sun Certified Java Programmer(SCJP) Certification
- Oracle Certified Associate(OCA)
- AI For everyone(CSRDATA366)
- Generative AI And LLM's
Similar Profiles
Manish RathiManish Rathi
Senior Finance Analyst at Applied Material at IBM India Pvt LimitedSenior Finance Analyst at Applied Material at IBM India Pvt Limited
MITHUN S HariMITHUN S Hari
Tech Lead at APPLIED MATERIAL INDIA LTDTech Lead at APPLIED MATERIAL INDIA LTD
Prarun T GPrarun T G
Senior Engineer - Design at Applied Material India Private Limited - (Under Tech Mahindra)Senior Engineer - Design at Applied Material India Private Limited - (Under Tech Mahindra)