Hanup Kumar Kolipaka

Extract data from ERP systems, such as Oracle Financial Systems, and load it into on-premise databases. Create views to allow BI analysts to easily connect and generate dashboards. Implement failure detection steps in ETL processes to ensure data accuracy and reliability. Design and build reusable Power Bl data models to empower BI analysts to create insightful reports and dashboards. Develop and optimize data pipelines to load data from multiple source systems into Microsoft Fabric Lakehouses for centralized data storage and analysis as part of ongoing cloud data warehousing efforts.

Extract data from ERP systems, such as Oracle Financial Systems, and load it into on-premise databases. Reverse engineer databases to develop data models as part of documenting different entities and relationships, enhancing the understanding and usability of the databases.

Documented and recorded videos of installing various Oracle software such as Database 19c, SQL Data Modeler, SQL Developer and Forms & Reports. This helped around 140 students with their installation issues. Debugged an old version of Airline Reservation form which required changes to the PL/SQL code for almost 18 clickable buttons. The form was later demonstrated to graduate students as an example of the project they had to complete. Facilitated around 140 students to date with their questions related to databases. Took one-on-one sessions for students who needed extra help and by the end of the semester they had almost 60% increase in their scores.

Conducted IEEEXtreme, a 24-hour coding competition with 200 participants at my college. Took the responsibility of overseeing if resources like desktops and software required were functioning properly being a 24-hour challenge. Arranged a course on Very Large Scale Integration (VLSI) for approximately 150 students by getting permission from the Electronics department. This was beneficial to the club members as it helped them gain industry level practical experience.

I worked on a project that detects accidents and delivers text messages and GPS locations to contacts that are stored when an accident occurs. Developed the code using an IDE that is C++-based.