Pradeep R

Custom Software Engineering Analyst

Accenture

Chennai

01.2021 - Current

Implementing best practices and adhering to industry standards during the development phase is crucial for minimizing defects in the upper environment.
Enhanced SQL query performance through a meticulous analysis of execution plans and implementation of optimization techniques, including the extraction of frequently used queries into a new WITH clause.
Additionally, successfully addressed and resolved issues related to data integrity, security, and performance tuning in Oracle databases.
Developed SQL queries for more than 120 fields, ensuring accurate data extraction and transformation. This involved creating complex queries to handle large datasets efficiently.
Conducted parallel testing alongside query development to achieve a 99% accuracy rate. Focused on identifying and addressing mismatches, missing, or orphan records.
Worked closely with the data load team and business team to resolve any issues that arose during testing. Collaborated to fix identified problems and ensure data integrity.
Incorporated high-level logic into SQL queries as needed, based on the specific requirements of the data and project.
Created an automated framework with scripts designed to facilitate data validation, capable of handling various case conditions.
This framework efficiently identifies reasons for data mismatches, allowing for quick error diagnosis and reducing the need for manual validation.
In the event of discrepancies, I promptly address and rectify the issues in the affected fields, maintaining a commitment to robust and error-free query performance.
I used Informatica Power Center to design and implement ETL workflows, applying transformations to efficiently load and integrate data from multiple sources into the target data warehouse.
This involved analyzing source data, defining structures, and creating mappings with transformations like lookups, aggregations, filters, and joins.
I ensured data quality, optimized performance, and developed reusable components.
By collaborating with analysts and stakeholders, I validated transformation rules and managed workflows to ensure smooth execution.
This approach improved data integration efficiency and accuracy, enhancing decision-making and reporting while honing my ability to deliver robust ETL solutions.
Learning TABLEAU to prepare comprehensive reports tailored to business requirements, focusing on employing appropriate charts and visualizations to effectively represent key metrics and insights. This includes designing interactive dashboards to enable stakeholders to make data-driven decisions, ensuring that the reports are both informative and user-friendly.