Jothi L.

â?¢Worked as Software Engineer in ACCENTURE from Jan 2014 to Mar 2017.
â?¢Working as Technology Analyst in INFOSYS from April 2017 to till date.
â?¢A logical, analytical thinker with exceptional database skills possesses rich experience of 4.8 years as Oracle PL/SQL developer.
â?¢Experience in SQL, PL/SQL, ETL Scripting, Query Optimization
â?¢Experience in UNIX Shell Scripting, Control M, Cron jobs to automate process.
â?¢Experience in Actimize (AIS Modeler and Designer).
â?¢Expertise in Database designing and creation.
â?¢Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

â?¢Collected User Requirements by participating in meetings and studying existing System. Involved in Requirement gathering, analysis, design, build, testing, defect resolution, deployment, documentation and maintenance.
â?¢Increased the overall efficiency of the project by creating robust code, reusable components and scripts to reduce overhead in future deployments of the models.
â?¢My role was to analyze & create database objects like Stored Procedures, Functions, Packages and Triggers.
â?¢Involved in creation of Tables, Views, Synonyms, Sequences and constraint.
â?¢Experience in advanced PL/SQL concepts like Cursors, Global temporary tables, Bulk collect, Dynamic SQL.
â?¢Wrote complex queries using joins, sub queries and correlated sub queries to retrieve data from the database.
â?¢Experience in ETL (Extract, Transform and Load) â?? Moving data from OLTP to DMART.
â?¢Used SQL*Loader to load data from a flat file into the database. Used UTL_File packages to write data to files.
â?¢Tuning of the SQL query which takes long time to process the request using Explain Plan, Hint to reduce the response time.
â?¢Extensive use of Unix shell scripts, Cron Jobs to automate process.
â?¢Automated the monitoring activity which was performed by the team.
â?¢Worked on number of enhancements with timely delivery against aggressive deadlines.