Aravinda Swamy Maya

40|86 Advisors

• Involved in full development life cycle of planning, Analysis, Design, Development, Testing and Implementation.
• Developed and modified PL/SQL Packages, Functions, Procedures, triggers, Views, Mviews, cursors and Exception handling.
• Creating Dynamic SQL Queries to do code reuse and enhancements for inclusion in future code releases and patches.
• Developed UNIX Shell scripts to automate repetitive database processes i.e Downloading files from SFTP locations,renaming the file, and load data into stage tables and validate the data and then actual tables.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Created Oracle BIP reports and Dashboard Queries for the end users to check the details and errors.
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs.
• Involved in the continuous enhancements and fixing of production problems.
• Worked closely with clients to establish problem specifications and designs.
• Drafted documentation to detail development, logic and testing processes.

MLC Limited

• BaNCS is TCS product to provide customer to maintain policy lifecycle from New Business till Policy Settlement (Claim).
• Interacted with Client or Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Built SQL Complex Queries for Data Extraction from RDBMS on daily basis, Data Analysis and Verification.
• Expert on writing 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, Triggers, etc..
• Analyzed Existing SQL Queries, Writing and Implemented New Efficient Query. Tuned some existing queries using Hints to improve execution time of the queries
• Resolved complex business issues, proposing long-term solutions to avoid repeat problems.Applying bulk data patches in Production and fixing issues also.
• Supported user groups by handling target-related software issues/ service requests, incidents.
• Good Knowledge on Software Development Life Cycle (SDLC).