Anudip Ray ORACLE, SQL, PYTHON
No reviews yet

• Having 5 years of experience in PL/SQL Development and Production Support.
• Expertise in optimizing ETL processes to handle any performance related issue.
• Strong proficiency in SQL programming and writing complex SQL with proficiency in SQL analytical functions.
• Experience in Writing SQL Queries using functions, joins, sub queries.
• Involved on SQL development of Table Structures, Constraint, Views, Indexes and Sequences.
• Experience in writing complex SQL queries, nesting of functions, joins, sub queries, pseudo columns, set operators, Analytical function, and Dynamic SQL.
• Excellent experience on PL/SQL that includes Cursors, Ref-cursors, Procedures, Functions and Packages, Triggers, View, and Collection.
• Experience in code changes in the Existing Packages as per the Business Requirements.
• Expertise in Oracle SQL and PL/SQL, PL/pgSQL with PostgreSQL.
• Expertise in Database performance enhancement by creating/rebuilding/re-organizing indexes and Partitioning objects.
• Excellent in client-facing and have expertise in troubleshooting their issues.
• Expertise in Database Maintenance and Administration Backup and Recovery. Currently Managing 20TB of Database size.
• Expertise in Designing /Testing/Validating and troubleshooting the PENTAHO ETL jobs and DB stored procedures of the Risk Management system.
• Expertise in PENTAHO ETL Job Scheduling and provide the Production support end to end.
• Expertise in optimizing PENTAHO ETL processes to handle any performance issue.
• Expertise in Extracting data from various ERP/DB systems and incorporate logic to generate the information for the customers risk scores data.
• Design and implementation of the Replication process of the EWS in replica server using various methodologies like DB backup and restore using SQL server Agents and FTP client i.e WinSCP, under a SQL Server disaster recovery plan (DRP).
• Data Recovery and Data sync plan using DB Backup shipping between source and target servers.
• Basic understanding of Data Modelling and exposure to Data Quality assessment.
• Data validation and customization of the whole process of Risk Management to run efficiently and smoothly end to end.

Current Project Details:
Project Name: Early Warning System (Frauds – Classification and Reporting for Banks)
Description: Early Warning System is designed to proactively monitor various indicators that signal a
borrower's deteriorating financial health or an increasing likelihood of default. These indicators typically
include factors such as late or missed payments, declining credit scores, high debt-to-income ratios,
significant changes in spending patterns and negative economic trends in a specific industry or region. By
closely monitoring these warning signs banks can take timely action and take data driven decisions.
Scope: Include data processing workflows, data migration, system integration, testing and support.
Stakeholders: Bank Risk and Bank Credit-Monitoring Team.
Technology Stack: ORACLE, MSSQL, PostgreSQL, Pentaho PDI for ETL Process, SQL for reporting, read
data, validating data from different RDBMS sources, ORACLE PL/SQL for Business Logic Design and Implementation, POWER BI for Reporting.

Company – Project Name : Cognizant Technology Solution- Oracle E-procurement
Date : 11th Jan 2019 to 30th Jun 2020.
Role : Associate
Environment : Supply Chain Management
Responsibilities
• Engaging BP stakeholders, e.g. seller, buyers, etc., to finalize the purchase decision.
• Solving Issue with PR approvals in Oracle system ensure to have PO generation successful.
• Generating Purchase Order documents & confirming acceptance by the supplier
• Resolving operational issues with the suppliers and BP stakeholders related to the quality, delivery or receipt of good / services; invoice payment; return of materials; etc.
• Managing required changes to and closure of the PO.
• Developing SQL Queries as per client requirement, extensive working on SQL JOINS on Procurement Objects.
• Extensive use of Advance MS-Excel Function like V-lookup, Pivot table, SUMIF and COUNTIF.
• Strong knowledge in writing SQL Queries that varies from single table simple SQLs to multiple table complex SQLs
• Generating PO Open Close Cancel RICO spend report in YTD, Monthly and Weekly basis for the users so they would make better business decisions.
• Wanted to come out from the comfort zone and work really hard which value the company growth and profit.
• Should take the decision as a visionary and work under the tight deadlines.
• ORACLE SQL DEVELOPER for extracting Procurement Data from Remote Oracle using SQL query as per client and user requirement for Reporting and Audit purpose.

Subjects

  • Python Expert

  • Oracle 12c Expert

Experience

  • Sr Software Engineer (Jun, 2021–Nov, 2024) at BCT DIGITAL
    Overall 10 years Experience which Include 8 years in IT with extensive experience in
    Data Validation and Data Migration Projects. Experienced in developing migration
    strategies, creating migration scripts, and executing large-scale data migration
    projects.Adept at collaborating with cross-functional teams to translate bussiness
    requirements into efficient and scalable database solutions.

Education

  • MCA (May, 2009–Apr, 2011) from annamalai university, Chidambaram–scored 66.9

Fee details

    ₹500–1,000/hour (US$5.90–11.79/hour)

Reviews

No reviews yet. Be the first one to review this tutor.