Shruthi Kotra

Professional with over 9 years of experience in Oracle PL/SQL development, Data Modeling, Data management, Development and Performance tuning solutions and architecture.

Professional Summary

• Oracle Pl/sql Development and Performance Tuning– Over 9 years of experience supporting applications. Expert in incorporating complex business logics inside PL/SQL procedures/functions with very short processing time.
• Data Modeling - Created Logical Data Models (LDM) and Physical Data Models (PDM) for Anti Money Laundering - Case Management project from scratch successfully which replaced the product tool - ACTIMIZE thus saving millions of dollars for the firm which usually goes into product license. It also included the data model for entitlements which screens the users for the required custom privileges to access any object. The data model has been created dynamically which eases the development from Agile methodologies perspective.
• Create high-level process models (activity hierarchy diagrams, data flow diagrams, workflow diagrams, system interface diagrams) to represent business processes for the area under analysis.
• Support for Enterprise Java and Java script applications - Experience in database modeling and design for enterprise Java and Java script applications which includes react JS and Angular JS.
• Domain Knowledge - Over 5 years of knowledge in Anti money laundering (AML), Employee Compliance and compliance regulatory frameworks, Transaction & Trade fraud typologies.
• Data Management – Good experience in building large scale data integration, data validation, data cleansing frameworks.
• Data Reporting – Good knowledge into data reporting.
• A bright, talented and self-motivated Senior Oracle Developer who has excellent analytical skills, a quick learner, is highly efficient and has a good eye for detail.
• Expert in Oracle SQL and PL/SQL Development and performance tuning techniques such as Explain Plan, Indexes, Query Optimizer, TKPROF, DBMS-Profiler and AWR report.
• Enhance (or create - if new system) system logical data model to meet requirements, applying the Data Modeling Standards and the logical Data Naming Conventions. Apply the same enhancements in the physical data model, using the Data Modeling Standards and the physical Data Naming Conventions appropriate for the oracle database.
• Experience in mapping of Logical to Physical Data Models and vice versa.
• Expert in incorporating complex business logics inside PL/SQL procedures/functions with very short processing time.
• Tuned SQL queries from more than 8 hours to just 5 minutes. Optimized and tuned long running queries and views using various techniques.
• Redesigned an existing 10-hour + daily process down to 3 hours. This also allowed the application to scale to more than double the amount of records processed.
• Automated the analysis of records of an application using a PL/SQL package thus saving 60 man hours per month.
• Expert in developing the server side Frameworks using PL/SQL Packages and scripts for identifying the data discrepancies/issues in production thus reducing the number of INCIDENTS by 30%. Involved in continuous enhancements and fixing production issues.
• Using the concept of Data Analytics, identified cases where there is a deviation from commit compliance with respect to the commit dates promised to the customer for various services offered.
• Experience in Creating views using nested tables to create virtual data sets without having the need of storing the entire data physically in Tables thus reducing the need for maintenance. Developed a PL/SQL procedure to be used in customized Calendar applet to replicate the pattern of recurring appointments in Microsoft Outlook as per the user preferences.
• Able to play a key role in analysing problems and come up with innovative solutions as well as producing methodologies and files for effective data management.
• Worked with Oracle Supplied Packages, Records and PL/SQL Tables. Loaded data into Oracle Tables using SQL Loader.
• Identify, design, and implement process improvements: automating manual processes, optimising data delivery, re-designing infrastructure for greater scalability.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with Reporting tools such as Oracle BI Publisher and Microsoft Power BI.
• Experience in developing shell scripts in UNIX. Created Shell scripts for invoking PL/SQL blocks and SQL queries and scheduled them using crontab.
• Created Tables, Views, Constraints, Indexes (B Tree, Bitmap and Function Based).
• Expert in developing PL/SQL packages, procedures, functions, triggers, Views,Objects. Experience in Dynamic SQL, Collections , bulk collect, Global Temporary Tables, Cursors and Exception Handling.
• Complete knowledge of SDLC and Agile Methodologies.
• Experience in coming up with Unit test cases and also executing them.
• Worked with the source control Tool - SVN, GIT
• Good at communicating with the cross functional teams, stakeholders etc to come up with optimal solutions.

Oracle Certified Associate (OCA)