Saipriya Katipelly

Jr. Data Analyst/Data Migration Engineer

ADIRA Tech Services Pvt. Ltd.•  September 2021 - September 2024•  hyderabad

Transforming data files (.csv, excel and tables dump) into Akken Cloud Source database. Creating mapping sheets for source database files to target database based on different modules. Cleaned and transformed raw data using SQL queries to prepare it for analysis and reporting. Writing SQL Scripts for source data tables to appropriate matches for Akken Cloud target database synchronization. Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Involved in the development backend code, altered tables to add new columns, Constraints and Indexes as per business requirements. Using Toad for MySQL tool we debugging the code and unit test. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Slow Queries Optimization and fine tuning based on database Application log files through Explain plan.