Jagan Mohan Kalluri
Denton,Tx
Summary
As a recent master's graduate in Data Science from the University of North Texas with a strong academic record and practical experience, I am eager to leverage skills in data analysis and visualization technologies, including Power BI, to deliver insightful data-driven solutions. With over a year of hands-on experience in data analytics, and ETL processes, and a robust technical background in database management and programming, I am committed to enhancing data accessibility and business intelligence in an innovative data analyst role. Experienced Scrum Master with proven track record of successfully leading teams in developing high-quality software solutions on time and within budget. Skilled in multiple Agile methodologies, stakeholder management and sprint planning. Highly organized in managing complex projects with multiple deadlines.
Overview
2
2
years of professional experience
Work History
Data Analyst
Infosys
01.2021 - 08.2022
- Gathered requirements from business users worked on large datasets in Microsoft SQL and wrote store procedures and views
- Designed and developed POCs for projects using SQL and Power BI
- Developed Power BI reports for 15 million records of data by cleaning and converting data to represent Microsoft sales every month
- Designed a relational data warehouse with constraints for importing data
- Implemented multiple types of database objects such as primary keys, foreign keys, stored procedures, triggers, views, and functions.
- Presented MBR reports for clients using DAX and functions and worked closely with clients
- Created Azure pipelines, logic apps, and function apps and monitored applications in thedata factory
- Executed API and web service testing for data interfaces using tools such as Postman.
ETL Scrum Team
Infosys Ltd.
01.2021 - 08.2022
- Worked on a Proof of Concept (POC) initiative to design and develop Python-based ETL workflows.
- Developed a versatile Python script to automate the extraction and loading of data from various flat file formats into the CCW (Common Cloud Warehouse) landing zone area.
- Successfully implemented the end-to-end process of loading raw data from .txt files, into a SQL database, including data cleansing and validation.
- Demonstrated proficiency in creating and managing temporary tables for intermediate data storage during multi-phase transformations.
- Leveraged CA Workstation to manage ETL workflows, utilizing ESP APPLs to automate scheduling and monitor execution.
- Perform user acceptance testing, unit testing of the data extracts to meet the requirements.
- Participated with team to implement CI/CD.
Education
Master of Science - Data Science
University of North Texas
Denton, TX05.2024
Bachelor of Science - Computer Science
National Institute of Technology
India05.2022
Skills
- Git
- Google Collab
- Jupiter
- Power BI
- Tableau
- Selenium
- SOAP UI
- Postman
- Maze
- CA Workstation
- Spring
- Spring Boot
- Spring Data JPA
- Ruby on Rails
- MySQL
- PostgreSQL
- SQLite
- Neo4J- NoSQL
- NumPy
- Pandas
- Matplotlib
- Seaborn
- Streamlit
- Langchain
- TensorFlow
- Pyspark -30
- Kafka topic
- Azure fundamentals
- AWS EC2
- S3
- Knowledge of GCP
- Airflow
- Maze
- Streamlit
- Langchain
- TensorFlow
- Pyspark -30
- Kafka topic
- Azure fundamentals
- AWS EC2
- S3
- Knowledge of GCP
- Airflow
- Maze
Projects And Studies
- Adversarial Trajectory Prediction Study, The focus of this paper is to explore the reactions of Autonomous vehicles in the presence of an external adversary. It delves into the challenges and potential solutions when an unexpected external adversary is introduced or created.
- Langhian Project using Google Analytics Data and SQL, Worked on a project using the Langhian, made front end to communicate with LLM models to retrieve natural text of a SQL table. Worked on data cleaning and transformation of Google Analytics data sourced from Kaggle. I have deployed the application on to server with Digital ocean droplate
- Ride Share and Shipment Service Application, Designed and implemented a basic service application for ride-sharing and shipment. The application was built on top of an SQL database, ensuring efficient data storage and retrieval.
Projects
Software Engineering Project, Ecommerce Application, Ruby On Rails, 2023, Developed an ecommerce application using Ruby on rails.
Used PostgreSQL for database connectivity and implementation.
Features implemented are Product Categories Page, Products Page, View Product, Add to Cart, Payment page, Ads, Write Blogs, provide review, Sign-In, Sign-Out and Sign Up. Advance Database Systems, Anomaly Detection with Apache Kafka and Python, Fall 2023, Trained a unsupervised Machine Learning Model and save the data for predictions
Generate Fake Streaming data and send the data to Kafka topic using producer
Kafka consumer will read the data using multiple subscribers and predict using trained model.
If data is detected as anomaly send them to another Kafka topic using producer.
Finally created another Kafka consumer that reads anomalies and send notifications to Slack channel. Data Mining, Sentiment Analysis of Amazon Alexa Revies, Python, Data Mining Models, Fall 2023, Performed Sentiment analysis, predict whether a review is positive or negative in sentiment.
Implemented several Data Mining Models and evaluated them based Accuracy, Recall and F1-Score.
Used model with high accuracy for prediction. Database systems, Design Twitter like Database, MySQL, Neo4j, Summer 2023, Created a relational database using MySQL which involves constructing ER diagram, tables, attributes, perform forward Engineering and insert data.
Created a NoSQL database using Neo4J which involve writing queries with relationships and data.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
ETL Scrum Team
Infosys Ltd.
01.2021 - 08.2022
Data Analyst
Infosys
01.2021 - 08.2022
Master of Science - Data Science
University of North Texas
Bachelor of Science - Computer Science
National Institute of Technology