Aravinda Swamy Maya

CNO - 40|86 Advisors

• Interacted with Clients or Manager and participated in user requirement sessions to analyze and gather requirement.
• Developed and Enhanced PL/SQL Packages, Functions, Stored Procedures, Views, Materialized views, dynamic queries, cursors and Exception handling, triggers.
• Strong Experience on Advanced SQL, wrote complex Queries, window functions, CTE, hints, indexes and Worked on DDL and DML. Good in Query Optimization and Performance tuning.
• Developed UNIX Shell scripts to automate repetitive daily processes i.e getting files from SFTP or windows drive path and load files data into DB warehouse.
• Developing Python Scripts to load files data into warehouse using Pandas.
• Created Oracle BIP reports and Dashboard Queries for end users to check details and errors.
• Prepared test scenarios and performed unit and regression tests on PL/SQL programs adn Automation Scripts.
• Involved in continuous enhancements and fixing of production problems and prepare documents on new developed processes/ fixes for future reference.
• Experience on both GITLAB/ GITHUB to push the code components and had experience in using CI/ CD pipeline Jenkins tool to release DML/DDL.
• Delivered well-documented code that simplified ongoing maintenance efforts by other developers working on future iterations of projects.

MLC Limited

• BaNCS is TCS product to provide customer to maintain policy lifecycle from New Business till Policy Settlement (Claim).
• Expert in Data extraction, Analysis, correction and Validation.
• Wrote SQL Complex Queries, Expert on SQL Joins, Views, CTE, WITH clause, CRUD Operations, Indexes, Sub Queries, Aggregate and Analytical/ Window Functions, Oracle Hints, etc.
• Developed, Implemented and Optimized Stored Procedures, Functions, Packages, cursors, exceptional handlings, etc..
• Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
• Enhanced database performance by optimizing SQL queries and indexing strategies.