Overview
Work History
Education
Skills
Websites
Timeline
Professional Experience
Academic Projects And Paper
Certifications Extra Curricular Activities
Professional Summary
Academic Projects
Certifications Extra Curricular Activities
Generic

CHANDRAHAS REDDY ONTEDDU

Binghamton,NY

Overview

5
5
years of professional experience

Work History

Business Intelligence Developer Intern

Mindspace Networks Inc
Irving, TX
02.2023 - 02.2024
  • Utilized various Relational Database Management Systems (RDBMS) including MySQL, PostgreSQL, SQL Server, and Oracle for data storage and retrieval.
  • Assisted in ETL (Extract, Transform, Load) processes using SSIS (SQL Server Integration Services) to efficiently integrate data from multiple sources into a centralized database.
  • Contributed to data modeling efforts for improving data organization and structure, enhancing data warehousing capabilities.
  • Created visually appealing reports and dashboards using SSRS (SQL Server Reporting Services) for effective data visualization and analysis.
  • Engaged in Business Intelligence (BI) activities, including utilizing PowerBI for generating insights and facilitating decision-making processes.
  • Proficiently operated SQL Server Management Studio (SSMS) to manage databases and execute queries for data manipulation and retrieval.
  • Gained exposure to SSAS (SQL Server Analysis Services) for multidimensional data analysis and reporting.
  • Assisted in ETL tasks utilizing Informatica and Talend for data integration and transformation.
  • Developed proficiency in Tableau for creating interactive and insightful data visualizations.
  • Utilized DAX (Data Analysis Expressions) for advanced data analysis and manipulation within PowerBI.
  • Conducted data migration tasks using T-SQL scripts to ensure seamless transfer of data between different systems.
  • Collaborated with team members to troubleshoot and resolve data-related issues efficiently.
  • Actively participated in meetings and presentations to discuss project progress and findings.

BI Developer

Infosys Pvt LTD
Mysore, India
12.2018 - 11.2021
  • Led seamless data migration projects for new databases, like Snowflake and Oracle, ensuring data integrity and minimal downtime.
  • Optimized SQL queries and SSRS reports across SQL Server, Snowflake, and Oracle platforms, boosting performance significantly.
  • Collaborated with stakeholders to design interactive Tableau dashboards, facilitating data-driven decisions.
  • Mentored junior team members on BI best practices, fostering continuous learning.
  • Conducted training sessions for end-users on Tableau, Power BI, and Oracle Analytics.
  • Developed Power BI Reports and data models, recommending best practices for efficient analysis.
  • Integrated dashboards into applications using Embedded Analytics, streamlining data access.
  • Provided guidance on gathering business requirements for Analytics and Reporting.
  • Troubleshooted reporting issues and tuned performance across databases.
  • Implemented security controls on dashboards for data confidentiality and compliance.
  • Stayed updated with new tools and trends in BI development, Snowflake, and Oracle.
  • Experienced with Enterprise Data Warehouses and financial systems.
  • Demonstrated excellent interpersonal, organizational, and communication skills.
  • Proficient in TSQL for efficient data management.

SQL Developer Intern

Growton Martech Pvt Ltd
Hyderabad, Telangana,India
05.2017 - 09.2018
  • Developed and tested stored procedures, functions, triggers, and views in SQL Server to gain hands-on experience in database development.
  • Created database objects such as tables, indexes, constraints, and sequences under the guidance of senior team members to understand database schema design principles.
  • Monitored the performance of queries using query optimization techniques, learning to identify and address performance bottlenecks effectively.
  • Implemented data integrity rules to ensure the accuracy of data in databases, gaining insights into maintaining data quality.
  • Designed complex SQL queries for retrieval and manipulation of data from multiple sources, enhancing proficiency in SQL query writing.
  • Analyzed and evaluated existing database systems to identify areas for improvement or modification, contributing to ongoing database optimization efforts.
  • Provided technical support for applications related to SQL server databases, gaining exposure to real-world database management scenarios.
  • Developed scripts for automating administrative tasks related to databases, learning to streamline database management processes.
  • Prepared detailed documentation including diagrams, flowcharts, entity relationship models to describe system functionality, improving communication and documentation skills.
  • Collaborated with other developers to develop efficient solutions for business requirements, fostering teamwork and collaboration.
  • Tuned T-SQL code to optimize performance by identifying inefficient queries and recommending changes accordingly, gaining insights into performance tuning techniques.

Education

Master of Science - Computer Science

Thomas J. Watson College of Engineering And Applied Science, Binghamton University, SUNY
Binghamton, NY
12.2023

Bachelors of Engineering(B.E) - Computer Science

Anna University
Chennai,IN
04.2019

Skills

  • SQL
  • Relational Database Management Systems (RDBMS) - MySQL, PostgreSQL, SQL Server, Oracle
  • ETL (Extract, Transform, Load) - SSIS (SQL Server Integration Services)
  • Data Modeling
  • Data Warehousing
  • Data Visualization - SSRS (SQL Server Reporting Services)
  • Business Intelligence
  • PowerBI
  • SQL Server Management Studio (SSMS)
  • SSAS (SQL Server Analysis Services)
  • ETL Tools - Informatica, Talend
  • Tableau
  • DAX
  • M Query
  • Python
  • Data Migration
  • T-SQL
  • SnowFlake
  • Oracle

Timeline

Business Intelligence Developer Intern

Mindspace Networks Inc
02.2023 - 02.2024

BI Developer

Infosys Pvt LTD
12.2018 - 11.2021

SQL Developer Intern

Growton Martech Pvt Ltd
05.2017 - 09.2018

Master of Science - Computer Science

Thomas J. Watson College of Engineering And Applied Science, Binghamton University, SUNY

Bachelors of Engineering(B.E) - Computer Science

Anna University

Professional Experience

  • Seasoned Business Intelligence (BI) professional with over 3 years of experience as a Power BI developer.
  • Proficient in developing robust data models and efficient ETL processes.
  • Skilled in extracting, transforming, and loading data from diverse sources into BI platforms.
  • Experienced in designing and implementing interactive dashboards using Tableau.
  • Proficient in creating visually appealing reports and KPIs in Microsoft PowerBI.
  • Collaborative approach in working closely with stakeholders to identify key performance indicators.
  • Strong foundation in SQL, configuring databases, cubes, and queries for optimal performance.
  • Expertise in data analysis to uncover valuable insights and trends from large datasets.
  • Keen eye for optimization, successfully enhancing the performance of SQL queries and SSRS reports.
  • Provides reliable technical support to users for the smooth operation of BI platforms and toolsets.
  • Commitment to documentation and adherence to industry standards in maintaining comprehensive records of the BI environment.
  • Conducts informative training sessions for end-users to empower effective utilization of BI platforms.
  • Proficient in data migration, backup, and recovery procedures to ensure data integrity and continuity.
  • Skilled in building OLAP cubes using SQL Server Analysis Services (SSAS) for advanced analytics capabilities.

Academic Projects And Paper

Designed and implemented a PowerBI dashboard for online harassment analysis. Utilized Python for backend data processing and Flask for API development. Developed HTML, CSS, and Bootstrap for frontend UI. Utilized MongoDB for data storage. The dashboard allows for the analysis of explicit language across social media platforms like Twitter, Reddit, and 4Chan within specified date ranges. Achieved an accuracy rate of 90% in content monitoring.

SQL-based Reporting System, HTML, CSS, Node.js, Bootstrap, SQL Server

Developed a comprehensive reporting system using SQL Server, Node.js, and Express.js. Led the redesign of the reporting portal, ensuring a user-friendly interface with intuitive navigation and responsive design. Enhanced the system's efficiency by leveraging SQL Server for data management. Demonstrated proficiency in SQL for database querying and management, as well as front-end technologies like HTML, CSS, and Bootstrap for UI development.

Certifications Extra Curricular Activities

  • Infosys Certified Database Developer
  • Infosys Certified Microsoft Power Bi Developer
  • An avid photographer with a keen interest and moderate proficiency in photo and video editing, especially in tools like Photoshop, Lightroom, and Premiere Pro.

Professional Summary

With over 4 years of combined experience in internship and full-time roles, I have developed a deep understanding of business intelligence concepts and practices. This experience has equipped me with the skills necessary to drive data-driven decision-making processes within organizations.

Through hands-on experience of around 5 years in developing and testing stored procedures, functions, triggers, and views in SQL Server, I have gained proficiency in database development. This foundational knowledge enables me to efficiently manage and manipulate data to meet business requirements.

I possess a robust understanding of relational database management systems (RDBMS), including MySQL, PostgreSQL, SQL Server, Oracle, and Snowflake. This expertise allows me to effectively store, retrieve, and manage data across diverse platforms, ensuring data integrity and accessibility.

I have assisted in ETL (Extract, Transform, Load) processes using SSIS (SQL Server Integration Services) to integrate data from multiple sources into centralized databases. This experience has honed my skills in data integration and transformation, facilitating comprehensive analysis and reporting.

I have contributed to data modeling efforts aimed at improving data organization and structure, enhancing data warehousing capabilities. By designing efficient data models, I have facilitated better data accessibility and advanced analytics within organizations.

Through creating visually appealing reports and dashboards using SSRS (SQL Server Reporting Services), PowerBI, Tableau, and Oracle Analytics, I have developed a knack for effective data visualization and analysis. These visualizations empower stakeholders to make informed decisions quickly and effectively.

I have actively engaged in Business Intelligence (BI) activities, including utilizing PowerBI and Oracle Analytics for generating insights and facilitating decision-making processes. This experience has enabled me to leverage BI tools to extract valuable insights from data and drive strategic initiatives.

I am proficient in operating SQL Server Management Studio (SSMS), Oracle SQL Developer, and Snowflake web interface to manage databases and execute queries for data manipulation and retrieval. This proficiency enables me to efficiently navigate SQL Server, Oracle, and Snowflake complexities and optimize database performance.

I am detail-oriented, self-motivated, highly organized, resourceful, and reliable. As a proactive team player, I actively collaborate with cross-functional teams to troubleshoot and resolve data-related issues efficiently, ensuring project success and stakeholder satisfaction.

I am committed to continuous learning and staying updated with emerging trends in BI development. By staying abreast of the latest tools and technologies, I ensure that I can deliver impactful solutions aligned with organizational objectives and industry best practices.

Academic Projects

InfosysMindspaceTalendTalend

PowerBI Dashboard for Online Harassment Analysis

  • Developed a PowerBI dashboard for analyzing online harassment using Python for backend data processing and Flask for API development.
  • Implemented HTML, CSS, and Bootstrap for frontend UI, allowing users to analyze explicit language across social media platforms like Twitter, Reddit, and 4Chan within specified date ranges.
  • Achieved an accuracy rate of 90% in content monitoring.

SQL-based Reporting System

  • Contributed to the redesign and development of a comprehensive reporting system using SQL Server, Node.js, and Express.js.
  • Collaborated on the enhancement of the reporting portal, ensuring a user-friendly interface with intuitive navigation and responsive design.
  • Applied expertise in SQL for database querying and management to optimize system efficiency.

Certifications Extra Curricular Activities

  • Infosys Certified Database Developer
  • Infosys Certified Microsoft Power Bi Developer
  • An avid photographer with a keen interest and moderate proficiency in photo and video editing, especially in tools like Photoshop, Lightroom, and Premiere Pro.

Similar Profiles

CREATE PROFILE
CHANDRAHAS REDDY ONTEDDU