Vijayshankar Reddy

Key Responsibilities:

• Data Validation and Dashboard Management: Conducted rigorous validation by comparing dashboard counts against ETL source counts, ensuring data integrity and reliability for decision-making purposes.
• Good in Data Cleaning, Data extraction, analysis and visualization using SAS, GCP & Tableau.
• Process Optimization and Issue Resolution: Proactively monitored and ensured all processes met stakeholder requirements, troubleshooting and resolving issues promptly to maintain operational efficiency, completeness, and accuracy.
• Worked on Weekly, Monthly, Quarterly and Annual Generated Reports.
• Specialization in Retail and Commercial Banking: Played a pivotal role in retail and commercial banking processes for a top 30 bank in the USA, leveraging deep domain knowledge to deliver insights and support strategic initiatives.

Achievements:

• Successfully optimized operational processes, resulting in improved efficiency and accuracy in data reporting and analysis.
• Collaborated closely with stakeholders and managers to implement solutions that enhanced overall process reliability and stakeholder satisfaction.
• Contributed significantly to the success of retail and commercial banking projects, demonstrating strong analytical skills and industry knowledge.

Key Responsibilities:

• ETL and Data Integration: Proficiently managed ETL processes, including understanding data sources, transforming data, mapping data flows, and loading data into targets using Informatica. Ensured seamless data integration across multiple platforms and systems.
• Error Handling and Exception Management: Implemented robust error handling mechanisms, capturing error records and loading them into exception tables to maintain data integrity and facilitate troubleshooting.
• SCD Type 1 and Type 2 Mapping: Developed and implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 mappings to manage historical data and accommodate changes in dimensional data over time.
• Transformation and Mapping Development: Extensively involved in developing mappings using various transformations such as Source Qualifier, Expressions, Joiner, Aggregator, Lookup, Filter, Rank, Sequence Generator, and Update Strategy. Implemented efficient data processing logic to meet business requirements.
• Testing and Quality Assurance: Conducted rigorous testing and validation of ETL processes, leveraging SQL queries to verify data loading accuracy and performance.

Achievements:

• Successfully streamlined ETL workflows, reducing processing time by 25%.
• Developed and implemented efficient SCD mappings, enhancing data handling capabilities and improving historical data management.
• Played a key role in the successful implementation of Informatica mappings across various ETL stages, contributing to enhanced data integration and operational efficiency.