Ramachandra Reddy CH
Technical Consultant
Hyderabad
Summary
- Experienced and enthusiastic Consultant with track record of success across wide range of Banking OFSAA Applications and Web Applications . Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of operations, strategy and finance.
- Strong knowledge of data warehouse Concepts, OFSAA internal architecture and experienced in dimensional modelling on data modelling tool (ERWIN).
- Extensive experience in designing, developing and testing the enterprise/web applications using Java/J2EE technologies and Programming experience as PL/SQL Developer
- Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, , Functions ,Stored Procedures, Triggers
- Thorough knowledge and experience in configuring F2T rules, rules, T2T rules to transform data, DQ Rules in OFSAA through UMM DQ Framework.
- Worked on OFSAA Application for creating Meta Data like Dataset, Hierarchy ,BP, Measures for running the predefined batches process in order to populate the resultant tables.
Overview
11
11
years of professional experience
Work History
Senior Principal Consultant
Oracle
10.2021 - Current
- Strong knowledge of OFSAA infrastructure functionality.
- Technical and Business data configuration for new business enhancements or resolving existing issues.
- Implemented Excel upload functionality for business users to upload input data for processing.
- Customization of data model changes using Erwin data model.
- Strong skills in data analysis, data requirement analysis, and data mapping for ETL processes.
- Worked on BASEL and ALM batch optimization.
- Worked on ALM cash flow process configuration and optimization.
- Leading the BASEL and ALM teams to assign and resolve issues.
- Strong Communications to interact with client calls to discuss new functional enhancements and existing issues.
- Helping client to resolve audit issues.
- Supporting Basel, GL, ALM and LCR batch support
Senior Consultant
EY
10.2019 - 10.2021
- Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
- Strong knowledge on Basel workflow from pre-stage to final materialized views.
- Worked on issue fixes on RCA III reports.
- Developed exposure level reports to map RCA III report line tagging.
- Worked on RCAIII data difference issues while Intel audit.
- Created batches and monitored while running batch, and fixed issues if batch failed.
- Used Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
- Created new datasets, hierarchies, measures, business processors to design new rules.
- Created multiple rules, T2T, and DT to implement business requirements.
- Used import model to upload the warehouse data from the operational systems to database schema using Erwin XML file.
- Created batches and monitored while running batch, and fixed issues if batch failed.
Senior Software Engineer
HSBC
04.2013 - 10.2019
- Responsible for configuring business requirements in the OFSAA product as per the BRD and FSD.
- Designed new screens and workflows for many modules (Issues & Actions, Incidents, User Entitlements, Key Indicators, and Risk and Control Assessments) as part of customization.
- Responsible for designing/modifying OFSAA metadata objects, such as Hierarchies, Measures, Dimensions, and Datasets.
- Designed/modified forms using Forms Framework.
- Designed new framework using Vue.js and Spring Boot for a new application.
- Worked on JavaScript and Vue.js to design two screens and validations.
- Developed CI/CD pipelines to deploy code from UAT environments to Live environments.
Education
Master of Science - Computer Engineering
Nagarjuna University
Vijayawada 04.2001 -
Skills
Pl/SQL and Oracle database
Career Engagement
- Oracle, Hyderabad, 10/2021, Present, Principal Consultant
- EY, Hyderabad, 10/2019, 10/2021, Senior Consultant
- HSBC, Hyderabad, 04/2013, 10/2019, Senior Software Engineer
Timeline
Senior Principal Consultant
Oracle
10.2021 - Current
Senior Consultant
EY
10.2019 - 10.2021
Senior Software Engineer
HSBC
04.2013 - 10.2019
Master of Science - Computer Engineering
Nagarjuna University
04.2001 -
Similar Profiles
Paige DedmanPaige Dedman
Consultant at OracleConsultant at Oracle
Debabrata DashDebabrata Dash
Consulting Member of Technical Staff at OracleConsulting Member of Technical Staff at Oracle
Sijith VJSijith VJ
Principal Software Engineer at OraclePrincipal Software Engineer at Oracle
Mykola LaznikMykola Laznik
Senior Software Engineer at OracleSenior Software Engineer at Oracle
V V V SATYA NAVEENV V V SATYA NAVEEN
SAP Basis Consultant at Tata Consultancy ServicesSAP Basis Consultant at Tata Consultancy Services