• Working as Data Engineer for the project LABVANTAGE• Gathered requirements from clients and stakeholders.• Worked on data ingestion to AWS S3 and Snowflake from different data sources (on cloud).• Used SnowPipe, Steams, tasks for CDC.• Worked on SnowSQL to load data from local to Snowflake.• Created snowflake procedure to automate data process.• Conducted performance tuning to optimize queries• Created data models for different modules & designed and… Show more • Working as Data Engineer for the project LABVANTAGE• Gathered requirements from clients and stakeholders.• Worked on data ingestion to AWS S3 and Snowflake from different data sources (on cloud).• Used SnowPipe, Steams, tasks for CDC.• Worked on SnowSQL to load data from local to Snowflake.• Created snowflake procedure to automate data process.• Conducted performance tuning to optimize queries• Created data models for different modules & designed and implemented tables, synonyms, sequences, and views• Transform the data while loading into the table using DBT and Snowflake as per requirement.• Leveraged collections for efficient data handling & generated complex reports for daily client communication. Show less

• Developed database objects such as packages, procedures, and functions.• Conducted performance tuning to optimize queries & transformations for data loading.• Extensively worked on data modeling for different modules.• Designed and implemented tables, synonyms, sequences, and views.• Worked on Account Registration, Returns, and Payments modules & utilized external tables and SQL*Loader for data loading.• Conducted performance tuning to optimize queries• Created data… Show more • Developed database objects such as packages, procedures, and functions.• Conducted performance tuning to optimize queries & transformations for data loading.• Extensively worked on data modeling for different modules.• Designed and implemented tables, synonyms, sequences, and views.• Worked on Account Registration, Returns, and Payments modules & utilized external tables and SQL*Loader for data loading.• Conducted performance tuning to optimize queries• Created data models for different modules & designed and implemented tables, synonyms, sequences, and views• Utilized external tables and SQL*Loader for data loading• Leveraged collections for efficient data handling & generated complex reports for daily client communication. Show less

• Developed database objects such as packages, procedures, and functions.• Conducted performance tuning to optimize queries & transformations for data loading.• Involving in Data Conversion/Migration from legacy system of various source Oracle, Flat file, Non-oracle database to oracle system using UTL file, SQL Loader, External Table and calling appropriate interface table and API's.• Extensively worked on data modeling for different modules.• Designed and implemented tables… Show more • Developed database objects such as packages, procedures, and functions.• Conducted performance tuning to optimize queries & transformations for data loading.• Involving in Data Conversion/Migration from legacy system of various source Oracle, Flat file, Non-oracle database to oracle system using UTL file, SQL Loader, External Table and calling appropriate interface table and API's.• Extensively worked on data modeling for different modules.• Designed and implemented tables, synonyms, sequences, and views.• Worked on ACL, Registration, Returns, and Payments modules & utilized external tables and SQL*Loader for data loading.• Conducted performance tuning to optimize queries• Created data models for different modules & designed and implemented tables, synonyms, sequences, and views• Utilized external tables and SQL*Loader for data loading• Leveraged collections for efficient data handling & generated complex reports for daily client communication. Show less

Worked on the banking domain in OFSS. I was primarily working for FLEXCUBE product for multiple countries. Oracle FLEXCUBE Core Banking helps banks overcome the challenges of intense competition, reduced margins, and increased customer expectations by creating a unique competitive advantage built upon improved profitability and an extended customer reach. With Oracle FLEXCUBE Core Banking, banks gain a cost advantage through straight-through processing and exception handling. Involved in… Show more Worked on the banking domain in OFSS. I was primarily working for FLEXCUBE product for multiple countries. Oracle FLEXCUBE Core Banking helps banks overcome the challenges of intense competition, reduced margins, and increased customer expectations by creating a unique competitive advantage built upon improved profitability and an extended customer reach. With Oracle FLEXCUBE Core Banking, banks gain a cost advantage through straight-through processing and exception handling. Involved in understanding the client's requirements and functionalities. • Involved in database design and implementation. • Created tables, views, constraints, synonyms, and sequences. • Responsible for designing the advanced SQL queries, procedures, cursor, Trigger, and batch file. • Interacting with the business user and understanding the request. • Extensively used the advanced features of PL/SQL like Records, Tables, Object types, and Dynamic SQL. Show less

Worked as a Senior Software engineer on Financial project called LCD(Last Calendar Day). LCD is project under GE Capital wherein financial data consolidation was done on basis of last day of calendar as per rule by US federal. So the report/BI environment for GE Capital had to be modified accordingly.• Involved in understanding the client requirement and functionalities. • Involved in database design and implementation. • Created tables, views, constraints, synonyms, sequences… Show more Worked as a Senior Software engineer on Financial project called LCD(Last Calendar Day). LCD is project under GE Capital wherein financial data consolidation was done on basis of last day of calendar as per rule by US federal. So the report/BI environment for GE Capital had to be modified accordingly.• Involved in understanding the client requirement and functionalities. • Involved in database design and implementation. • Created tables, views, constraints, synonyms, sequences. • Responsible for designing the advance sql queries, procedures, cursor, Trigger, batch file. • Interacting with the business user and understanding the request. • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. Show less

Worked as a Software Engineer on banking project called Banc724. This is Retail banking application software used to automate bank’s day-to-day operations. The entire software is parameter driven that enable customers to define their own menus and schemes according to the requirements. This application is primarily intended for Nationalized, Grameen banks and Co-operative banks. The software has modules like SB, Current, Loans, Term Deposits, Clearing, Locker, Bills, Remittance, Daily deposit… Show more Worked as a Software Engineer on banking project called Banc724. This is Retail banking application software used to automate bank’s day-to-day operations. The entire software is parameter driven that enable customers to define their own menus and schemes according to the requirements. This application is primarily intended for Nationalized, Grameen banks and Co-operative banks. The software has modules like SB, Current, Loans, Term Deposits, Clearing, Locker, Bills, Remittance, Daily deposit scheme, Suspense, Cash management, reports, ALM, Asset Management, Bank guarantee, reconciliation MIS Reports Etc.• Involved in understanding the client requirement and functionalities. • Involved in database design and implementation. • Created tables, views, constraints, synonyms, sequences. • Responsible for designing the advance sql queries, procedures, cursor, Trigger, batch file. • Interacting with the business user and understanding the request. • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. Show less