Aghastya Reddy

Master's

Business Analytics

HCL TECH

Data Analyst

- Involved in every phase of the SDLC process starting from Inception to Transition - Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on - Created Data mapping, and logical data modeling coordinated with data architects, created class diagrams and ER diagrams, and used - SQL queries to filter data within the Oracle database - Involved in the below phases of Analytics using R, Python, and Jupiter Notebook - Wrote PL/SQL statements and stored procedures in Oracle for extracting as well as writing data - Used SSIS for data population from different sources and created SSIS packages for data conversions and loaded data from flat files and vice versa - Built multifunction readmission reports using Python pandas and Django framework - Worked on MongoDB database concepts such as locking, transactions, indexes, Sharing, replication, schema design, etc. Performed - Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh. Worked extensively with advanced