Home

Pavithra - Oracle Pl/Sql

[email protected]

Location: Houston, Texas, USA

Relocation: yes

Visa: H1B

Resume file: Pavithra_Kothavollu_Resume_1772653190628.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Pavithra Kothavollu Dallas, Texas PROFESSIONAL SUMMARY 8 years of experience in the Software industry as Oracle PLSQL developer/Oracle Database Developer. Worked as Database developer in Finance application and have good understanding of Finance terminologies. Involved in implementation, Testing and Support in Oracle Retail application. SME for Oracle Retail RMS Items and have worked extensively on Oracle SQL, PL/SQL, UNIX shell scripting and Pro*C with strong Oracle Database concepts, OIC data Integration, Oracle BI Publisher. Skilled in developing program modules using PL/SQL, UNIX shell scripting, Pro*C and tools like Oracle Forms builder, in Agile methodology with rich experience in documentation of deliverables. Performance tuning using Indexes, Table Partitioning, DBMS Profiler, AWR reports, Gather Stats, CTE, Oracle HINTS, Optimizing SQL Queries. Knowledge data management/visualization tools. Hands on Experience on BI Reports, OTBI, Power BI. Very good knowledge on Oracle EBS Modules. Have worked with DBA for Database cleaning and scheduling jobs using Autosys, Automic, Control M. Performance tuning of existing programs/interfaces to increase the system stability. Rich experience in support, maintenance, analysis, and enhancement of Oracle Retail Enterprise applications including RMS (Retail Merchandising System), RPM (Retail Price Management) and ReIM (Retail Invoice Matching), POS (Point of Sale), PPM (Project Portfolio Management), WMS (Warehouse Management System). Prepared Technical documents for business processes followed in projects and presentations over the solutions and bug fixes. Experience in developing applications using different IDEs like SQL developer, Toed, and Oracle forms builder. Expertise in all phases of SDLC (Software Development Life Cycle). Extensively used repositories like GIT and JIRA for issue tracking and project management. Experienced in developing applications in Agile methodologies, Waterfall, SDLC, Sprints, DEVOPS principles. Worked on business requirements building Functions, Procedures, Triggers, Packages, View, Materialized view, Oracle JSON, Indexes, Sequences, Tables. Worked on improving code coverage and increasing code quality using SonarQube. Experience in loading data files into the oracle DB objects. Proficiency in using Microsoft Office. Worked on Full Stack development for Application enhancements, Solid knowledge on Data structure algorithms. Worked with MS Office, Azure DevOps Server, TOAD, SQL Developer, JDeveloper. TECHNICAL SKILLS Programming languages: C, C++, Java, Java 11 SQL, Python, PLSQL, Oracle forms, Basics of ADF, Shell Script, Pro*C, Angular JS, MS SQL, Power BI, WebFocus, R, Control M. Applications: RMS, RPM, REIM, Oracle Cloud Fusion HCM Operating Systems: Windows, Linux, UNIX Database systems: Oracle, MySQL, Google Cloud, SQL Server, AWS Version Control Tools: HPALM, GITHUB, Tortoise Git Domain: Retail, Human Capital Management, Finance Other Tools: JIRA, MS-Office, Google Sheets, Toad, SQL Developer, SQL Developer, Oracle Forms Builder, Putty, WinSCP, JDeveloper, Eclipse, TeamCity, Harnaas, Bit Bucket, Oracle SQL Developer Data Modeler. ERWIN, Talend, CyberArk, DataDog. EXPERIENCE Company: Cerebra Consulting Client: Fidelity Investments Feb 2025 Till date Role: Oracle Database developer Responsibilities: Worked with prime brokerage Workstation and Prime Locates Workstation application technical team as Database Developer. Worked as critical resource in team doing enhancements to the critical application functionalities and addressing the production issues. Develop, optimize, and maintain PL/SQL stored procedures, functions, and triggers, packages for efficient business logic execution. Participate in data modeling activities to ensure that database structures are well-organized, efficient, and scalable. Analyze and optimize SQL queries to improve performance and reduce execution time, especially for complex financial queries. Implement indexing strategies to enhance query performance for large datasets. Work with DBA to optimize database resource usage Provide support for resolving production issues by identifying database-related problems and collaborating with other teams for quick resolution. Participate in root cause analysis for database-related incidents, collaborating with infrastructure and application teams to resolve issues. Good understanding of backend, Middle tier and front-end application integrations. Worked closely with clients setting up there b2b urls for sending the locates. Company: Cerebra Consulting Client: ABM Feb 2024 Feb 2025 Role: Oracle Cloud Fusion Developer and Oracle PLSQL developer Responsibilities: Working as Oracle HCM Implementation in Oracle fusion HCM Cloud SaaS application. Worked on analyzing data to maintain integrity of the system functionality and right flow of data to peer systems. Validate production deployments and provide post live support as required. Handling Core HCM modules PTO, Benefits, pay policies, Time and Labor (OTL), and Absence Management modules, Pay Roll. Good at Problem solving and trouble shooting. Working to create PLSQL objects like Packages, Procedures, Functions, Tables, View, Triggers, Indexes, Triggers. Strong SQL knowledge Knowledge in any of the data tools like TOAD, SQL Developer, Oracle Performance tuning using Indexes, Table Partitioning, DBMS Profiler, AWR reports, Gather_Stats, Explain Plan, DBMS jobs Scheduling. Worked in implementation of custom module EMS (Entitlement Management System). Developing data integrations and conversions for sending the data to the legacy systems through translators. Worked very closely with Business team in analyzing requirement, fit gap analysis developing, troubleshooting Oracle HCM PaaS extensions. Extensively worked on ETL data integration workflows. Build and deployment CI/CD pipelines for data warehousing. Worked on Oracle Platform as a Service (PaaS) with a focus on Database Cloud Service, PL/SQL. Worked on OIC for Oracle HCM cloud integrations to the peer systems. Converting functional requirement to Technical and building the Reports using SQL Server Reporting Services. Integrating JSON and XML data with relational database. knowledge on Oracle ERP Cloud /Oracle HCM Cloud SaaS application. Validation and Reconciliation of Reports. Used Post Man and Oracle Enterprise Manager for API testing. Worked on translating business requirements and designed technical solutions. Worked on Researching, learning, troubleshoot, and supporting complex system customizations. Have good Communication and Collaboration skills. Working on building and enhancing the Oracle BI Reports, OTBI Reports. Worked with analyzing data by debugging the code and tracing, and fixing bugs, identifying the performance problems and optimizing. University: East Texas A & M University Role: Web Focus Report /Oracle PLSQL Developer Apr 2023 Dec 2023 Responsibilities: Data-gathering tasks, and research projects. Helping IR (Institutional Effectiveness and Research) department offices and individuals internally and externally to maintain data/report integrity and quality to fit for their intended uses in operations, decision making and planning. Creating graphs for reports using Microsoft Excel. Accessing and fetching data from the Oracle database. Windows and Linux/Unix; editor experience with PL/SQL Developer. Generating reports using Web Focus. Maintaining the data integrity and creating dash boards using Power BI, Excel. Developing KPI dashboards and reporting and presenting dashboards. Company: Deloitte Consulting Client: Kroger.Co Aug 2021 Aug 2022 Role: Oracle Technical Developer Responsibilities: Handling Oracle retail RMS implementation involved in Data conversions to integrations for RMS. Validate production deployments and provide post live support as required. Root cause analysis & troubleshooting of complex incident management tickets. Support business on ad-hoc data requests and queries. Involved in development of various complex integrations and conversions in Retail Modules like Cost and Deals, Item Master, Supplier, Inventory management, and Purchasing modules. Providing support to QA during DIT and UAT, resolve defects raised by QA team within SLA. Worked on Dynamic SQL, Exception handling. Identifying system bugs & automation scopes in existing business procedures, fix them to reduce overall manual effort. Automating the business process with python coding. Worked on various technical design documents. Involved in performing regression testing, Load testing. Worked on implementing PLSQL packages for Data Integration between RMS and Legacy systems and Oracle cloud. Involved in migrating various developed objects using migration tools like TeamCity and Harnaas. Used SQL *Loader to load large data into tables for testing. Have extensively worked on creating PLSQL packages, procedures, triggers, Indexes, functions, Data modeling. Have efficiently debugged PLSQL packages for bug analysis. Used PLSQL concepts like BULK binding. Very good experience working on SDLC. Have made changes to the existing base PLSQL package code for specified requirements. Worked on RICE objects for the Oracle RMS application implementation. Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQLLOADER, UTL_FILE, Oracle packaged APIs etc. Environment: Oracle Retail Merchandising system, Oracle Retail Pricing management system, Oracle 12c, Oracle 19c, SQL Developer, Putty, Kafka, WINSCP, GITHUB, SharePoint, SonarQube, MS VISIO, TeamCity, Harness, Oracle ERP, RedShift, Data Modeling. Company: Tata Consultancy Services Jun 2018 Aug 2021 Client: Woolworths Role: Oracle Techno Functional Developer Responsibilities: Independently handled technical change requests, development requests and testing. Performed Root Cause Analysis for various Oracle Retail MOM modules, Oracle RMS, Oracle RPM, Oracle REIM. Involved in Data Purging, Data Modeling, Table Partitioning, Creating Tables, Trigger, Procedures, Functions, Packages, Generate Rows, Views, Cursors, PIVOT, CASE, with Clause, Dynamic SQL, Recursive SQL, Aggregate Functions, Analytical Functions. Worked on Tableau, Oracle reporting tool building reports for custom requirements and scheduling and presenting to stalk holders. Have modified Oracle Forms and tested end to end. Managing the reviews for efficient and timely delivery of tasks and projects from Client. Worked on creating Process Documents, Technical specification Documents. Design, development, or enhancement in Oracle retail applications using PL/SQL, Pro*C, UNIX shell scripting, Bash Shell, Korn Shell. Worked on client requested customizations and enhancements to the existing RMS application. Worked on change requests which involve PL/SQL package creation/modification, Oracle form modification, Pro*C code modifications and tested the same. Know the end-to-end flow of Price Changes, Promotions, Clearances, Cost Changes in RMS (Version: 10). Worked as L3 Oracle Technical Support resource supporting the Oracle Retail application, Batch monitoring, On call Production Data support. Know how to read the EDI files and analyzing the issue and loading the files. Defect Tracking and Reporting in JIRA, SERVICE NOW. Troubleshooting and bug fixing issues during testing of developed interfaces. Worked on performance improvements and testing and have good understanding of HINTS, AWR Reports, Explain Plan, SQL Trace in Oracle and scheduling jobs using DBMS_SCHEDULER. Helped and mentored team members in developing their objects. Used JIRA for maintaining and updating the progress of production issues and sprint tasks. Collaborated with Functional team for creating testing Promotions, Clearances and Price Changes in Live environment. Reading EDI files from legacy systems and making sure the data is getting integrated. Presented the Retail solutions to the client team. Worked on resolving the application user raised tickets. Involved with functional team for the functional testing. Experienced in ensuring the data quality initiatives, aligning business processes with data, implementing technology solutions, supporting data standards/policies, and data-related issue management and remediation efforts. Developed data modeling preparing ER diagrams using UML for the business process., automation scripts using Python. Environment: Oracle Retail V10, Oracle Retail Merchandising system, Oracle Retail Pricing management system, Oracle Forms Builder, Oracle Retail Invoice matching, Oracle 11g, Toad, SQL Developer, Putty, WINSCP, Automic and App Worx, Sonar cube Version control tool, WebLogic API, RIB middleware application, Oracle WMS. EDUCATION Master of Science in Computer and Information Science Texas A & M University- Commerce December 2023 GPA: 3.58 Bachelor of Engineering - Computer Science and Engineering Sri Siddhartha Institute of Technology, Tumkur - 2018 GPA: 8.9 CERTIFICATIONS Oracle Cloud Infrastructure Foundations 2021certificate Associate. Retail Reference Library Access and Installation. Retail Merchandising Cloud Service 2020 Technical Implementation Specialist. Oracle fusion technical Certification. Keywords: cprogramm cplusplus continuous integration continuous deployment quality analyst javascript business intelligence database active directory rlang microsoft mississippi procedural language Colorado