Chandrakanth S C

Experience

• 

  Oracle in Financial Services

  Aug 2017 - Jul 2019

  Technical Analyst

  Project Name: Financial Year EndLanguage Used: SQL, PL/SQLTools Used: SQL developer, PL/SQL developer.Responsibility: Wrote SQL queries for retrieving the data that should maintained for the financial cycle using joins, inner join, outer join.Have written sql queries for generation of the banks Profit and loss statement for the financial cycle using joins, sub queries, inline query.Wrote sql queries as requried by the bank for the various report generation using view, cursors, synonyms table, procedures, function.Convert the functional requirements into technical document as per the business standards.Wrote SQL queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.Wrote SQL queries on Analytical Functions, Indexes, and Partition Tables.Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors as per the Business requirements.Involved in modifying various existing packages, Procedures, functions according to the new business needs.Involved in modifying forms, reports using Oracle 10g.Experience in interacting with Bank clients.Language Used : SQL, PL/SQLTools Used : SQL developer, PL/SQL developer.Product: FlexcubeResponsibility : Gathering the information from the bank Customer for solving the reported issue.Working on different Modules like CASA, IC, CL, LC, etc.Analyzing the issue reported, debugging for finding the function error occurred and providing the solution as per the customer requirement. Writing the SQL queries using analytic functions as per requirement by the customer.Written SQL queries using cursors, functions, sub query,inline query,correlated query for the data correction.Used tables, views, cursors, joins, inner join, outer join, correlated sub query, sub queries, procedures, function while writing the sql queries. Show less

• 

  Fragma Data Systems

  Jul 2019 - Dec 2019

  Data Engineer

  Project Name : Data Analytic Dashboards.Language : Hive.Responsibilities : Have use hive to query the required data for the creation of the Dashboards.Also have experience in writing the spark queries.Have written hive queries to fetch the data into hadoop environment.

• 

  ORACLE FINANCIAL SERVICES SOFTWARE LIMITED

  Jan 2020 - now

  Associate Technical Analyst