Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Abhijith Reddy

Toronto

Summary

Data Professional with 6+ years of experience in data warehousing, ETL development, and database administration (on-prem and cloud). Experienced Oracle DBA and Linux Administrator, managing database schemas, patches, backups, and high availability. Skilled in designing and optimizing ETL workflows using Informatica PowerCenter, SSIS, Python, and Shell scripting. Proven expertise in advanced SQL/T-SQL, indexing, and performance tuning. Proficient with AWS RDS and CloudWatch for cloud database management, monitoring, and cost optimization. Strong track record collaborating with developers, DevOps, and deployment teams to deliver secure, scalable, and reliable data solutions.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Warehouse Developer

BNP Paribas
02.2022 - 10.2024
  • Documented data warehouse architecture to guarantee capacity met current and forecasted needs.
  • Developed complex SQL and PL/SQL procedures to cleanse, validate, and standardize large datasets, improving data quality by 95% for analytics and reporting.
  • Executed end-to-end data migration from legacy systems to modern Oracle databases, with minimal downtime and 100% data integrity.
  • Created audit and reconciliation scripts post-migration to ensure accuracy and completeness of migrated data, identifying and resolving discrepancies in less than 24 hours.
  • Administer Oracle Database (11g/12c/19c) on-premises and Oracle instances hosted on AWS RDS environments, implementing high availability, disaster recovery, and cost optimization strategies.
  • Worked extensively on Linux systems to install, configure, and manage Oracle Database, Tomcat application servers, and Apache web servers, performing regular maintenance, security hardening, and performance tuning to ensure high availability and reliability.
  • Leverage AWS CloudWatch, SQL Profiler, Extended Events, and Performance Monitor for proactive monitoring and performance tuning.
  • Developed and maintained ETL workflows using Informatica Power Center to extract, transform, and load data from multiple sources into data warehouses, ensuring high data quality and consistency.
  • Increased ETL workflow efficiency by 40% by automating repetitive tasks using scripting languages like Python or PowerShell.
  • Mitigated critical vulnerabilities by applying security patches and hardening configurations for Apache servers and Oracle environments, ensuring full compliance with enterprise security standards.
  • Collaborated with cross-functional teams including developers, DevOps, and deployment to integrate cloud-based database solutions and streamline CI/CD pipelines.
  • Built robust CI/CD pipelines in Jenkins to streamline data pipeline deployments, integrated Bitbucket for source control and audit checkpoints, reducing release cycle time by 50% and minimizing operational disruptions.
  • Integrated OBIEE with Oracle Data Warehouse to provide ad-hoc reporting and self-service analytics to over 300 users across business units.
  • Integrated Oracle APEX applications with Oracle Database and RESTful Web Services, improving system interoperability and reporting capabilities.

Senior SQL Developer

Broad Ridge Financial
04.2020 - 01.2022
  • Generated 50+ complex T-SQL and PL/SQL stored procedures, views, and functions for high-volume transactional and analytical databases, improving data processing performance by 60%.
  • Deep expertise in MS SQL Server 2016/2019/2022 and related technologies for database management and optimization.
  • Implemented SQL Server High Availability (HA) and Disaster Recovery (DR) solutions, including clustering, log shipping, and Always on Availability Groups, to ensure maximum uptime.
  • Worked on AWS data integration services such as AWS Glue and Data Pipeline to build ETL pipelines for migrating and processing data from multiple sources.
  • Initiated end to end ETL workflows using SSIS and Azure Data Factory, integrating data from heterogeneous source (Flat files, APIs, Oracle) into Azure SQL databases, increasing data pipeline reliability.
  • Optimized complex SQL scripts in Azure Synapse, improving query performance by 55% and enabling faster access to large-scale data models.
  • Proven ability to solve complex problems and deliver solutions in fast-pAdapt well to changing priorities and complex systems, with a strong focus on continuous improvement in cloud-based architectures.

Business Intelligence Developer

Yes Bank
08.2017 - 04.2019
  • Developed and maintained interactive dashboards and reports using Power BI and Tableau to deliver clear, actionable insights for business stakeholders.
  • Created efficient data models, measures, and calculated fields with DAX (Power BI) and LOD expressions (Tableau) to enable accurate reporting and analytics.
  • Collaborated with cross-functional stakeholders to gather BI requirements, translating business needs into technical solutions that improved reporting efficiency by 35%.
  • Automated data refresh schedules and implemented gateway configurations in Power BI, maintaining up-to-date reports and secure data connections for on-premises and cloud data sources.
  • Used power query to pivot and un-pivot the data model for data cleansing/transforming in power BI.
  • Loaded data into snowflake Database Storage from On-Premises.
  • Utilized version control tools and collaborated in Agile teams to iterate BI solutions rapidly, ensuring alignment with evolving business needs and data strategy.

Education

Bachelor of Science -

Jawaharlal Nehru Technological University

Post Graduation Diploma - Project Management

Cegep De La Gaspesie ET Des Iles
Montreal, QC

Skills

    Informatica Power center, SSIS, Oracle, SQL Server, AWS RDS, AWS Glue, CloudWatch, Linus, Power BI, Tableau, OBIEE, Oracle APEX, Python Programming, Power Shell, Bash Shell, Azure Cloud

Certification

Azure Microsoft Power BI Data Analyst, PL-300.

Timeline

Data Warehouse Developer

BNP Paribas
02.2022 - 10.2024

Senior SQL Developer

Broad Ridge Financial
04.2020 - 01.2022

Business Intelligence Developer

Yes Bank
08.2017 - 04.2019

Post Graduation Diploma - Project Management

Cegep De La Gaspesie ET Des Iles

Bachelor of Science -

Jawaharlal Nehru Technological University
Abhijith Reddy