Plsql Developer Production Support
Resume:
Mythili Guntipalli
Oracle PLSQL Developer
****.*******@*****.***
https://www.linkedin.com/in/mythili-guntipalli-360211180/ SUMMARY
• Around 9 years of IT Experience in Agile Analysis, Design, Development of database applications using Oracle 19c/12c/11g/10g SQL, PL/SQL, Production Support, ESP.
• Expertise in Objects creation such as Tables, Views, User Data Types, Indexes, Stored Procedures, Cursors, Triggers, Functions, Packages and more.
• Expertise Debugging Stored Procedures, Triggers, Cursors and SQL coding.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types and Analytical Functions.
• Experienced in Bulk Collections, PL/SQL Collections and Exception handling.
• Created External tables as part of data load process to load external data into Oracle database tables.
• Experience in Query optimization, Performance Tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and tables partitioning.
• Extensive experience working with DB Links and creating materialized views, Sequences and Synonyms etc.
• Good experience in writing SQL queries to perform DDL,DML operations, data analysis, debugging.
• Perform Pseudo Columns and OLAP Functions based on business requirement.
• Created and Monitored scheduling jobs using ESP WA workstation tool.
• Experience in PL/SQL Tables, Cursors, Ref Cursors and Exceptions to process huge volume of data and used bull Collect for mass update as performance improvement process.
• Experienced Dynamic SQL to build SQL statements dynamically at runtime.
• Maintained Data Integrity by applying Constraints at column level and table level.
• Extensive experience in SQL queries using Sub queries to retrieve data from the database.
• Analyzed functional design documents for technical feasibilities.
• Experienced in deployment activities on Cloud environments using GIT, IBM RTC and CLOUD.
• Extensive experience working with Set Operators.
• Experience in creating database users, roles, users. Database monitoring, job Scheduling.
• Extensive experience with all phases of the Software Development Life Cycle Including analysis, Resource Planning, coding, testing, implementing and maintenance.
• Created PL/SQL, SQL*Loader and Unix /Java /python scripts as a part of data load process to load external data into Oracle database tables.
• Developing and debugging complex SQL queries in order to perform critical data analysis and investigation of the technical support queries and accordingly work closely with the business partners to maintain the stability and smooth. TECHNICAL SKILLS
EDUCATION: Bachelors of Information Technology (IT) from JNTU Anantapur, 2012 WORK EXPERIENCE:
Verizon, Atlanta Apr 23 to Till date.
Description: A CCRS (Commission Calculation Revenue System) is a pure Telecom system which is mainly used to calculate the commission that is to be paid for Verizon employees or the resource who work directly or indirectly to Verizon, based on the targets (such as Activations, Deactivation, Contract Renewal Deactivations, Discrepancies, Exception etc) what they achieve on regular of time.
Role: PLSQL Developer
Software : Oracle PLSQL, ESP, SQL Developer, Toad, JIRA, WinScp, Putty, Unix Responsibilities:
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers, and procedures to troubleshoot any database problems.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Created Materialized Views and partitioning tables for performance reasons.
• Created External tables as part of data loading from files to Database tables.
• Worked on creating, scheduling jobs in ESP WA work station scheduling tool.
• Created Sequences and Synonyms based on requirement.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization
• Worked on Production support.
• Worked on Query Optimization and Performance tuning .
• Developing and debugging complex SQL queries in order to perform critical data analysis and investigation of the technical support queries and accordingly work closely with the business partners to maintain the stability and smooth.
• Responsible for Analyzing and Implementing the Change Requests.
• Worked on writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements. Programming
languages:
Oracle SQL, PLSQL
RDBMS : Oracle 10g/11g/12c/19c, SAP HANA DB
Oracle Tools SQL *PLUS, SQL*Loader, Toad
Ticketing/Bug Tracking
Tools:
JIRA, Servicenow, AYS
Deployment Tools : IBM RTC, Jenkins.
Platform Unix/Linux
• Responsibilities included taking ownership of the project, worked closely with the business group to understand their requirement, and make recommendations as required.
• Involved Grooming and Backlog refinement sessions. StateStreet Corporation, Hyderabad, India Aug 21 to Mar 23 Description: The StateStreet Corporation is a American financial services and bank holding company. Current project deals with investor management that provides asset management and research and advisory services to mutual funds, insurance companies and institutional investors. Global Markets is State Street's securities business that offers research, trading, and securities lending services for foreign exchange, stocks, fixed income, and derivatives. Role: PLSQL Developer
Software : Oracle 11g/12c, Toad, SQL Developer, SVN, Putty, SQL*Load, Service Now Responsibilities:
• Involved to determine business/technical requirements, analyzing business process and workflows and suggest improvements.
• Define roles, privileges required to access different database objects.
• Analyze functional design documents for technical feasibility.
• Modification in existing code according the business requirements.
• Wrote SQL queries using joins, sub queries and co-related sub queries to retrieve Data from the database.
• Development of Stored Procedures to encapsulate Business processes, procedures, functions and package.
• Maintained Data Integrity by applying Constraints at column level and table level.
• Creating Tables, Indexes, and Views etc.
• Writing Queries using Joins and Sub-Queries.
• Involved to Writing SQL Queries for Client Requirement.
• Extensively worked on Stored Procedures, Functions and Packages.
• Writing Packages and Triggers using PL/SQL.
• Involved to writing Exceptions.
• Involve data loading into tables from Data files using Oracle External Tables Concepts.
• Extensively Use PL/SQL Tables, Cursors, REF Cursors and Exceptions to process huge volumes of data and use bulk collect for mass update as performance improvement process.
• Perform deployment activities using GIT, RTC and CLOUD.
• Involved in fixing various issues related to data quality, data availability and data stability.
• Worked on writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements. MetricStream InfoTech. Bangalore, India Feb 2020 to Aug 2021 Description: The MetricStream Enterprise GRC Solution provides a single, integrated system to manage, coordinate, and track multiple types of GRC activities. The solution cuts across organizational silos, enabling a holistic and collaborative approach to GRC. Users can efficiently roll up risk and compliance data from across the enterprise, and transform it into actionable business intelligence to support decision-making. With support for mobility, real-time reporting, advanced risk analytics, and regulatory notifications, the MetricStream Enterprise GRC Solution is comprehensively designed to meet the GRC needs of today’s complex, global enterprises. Role: PLSQL Developer
Software : Oracle 11g, Toad, SQL Developer, SVN, Putty, Jenkins Responsibilities:
• Responsibilities included taking the ownership of the project and function as the lead, worked closely with the business group to understand their requirement, and make recommendations as required.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Implemented Triggers, Views, Synonyms, Hints, Partitioning of Tables, Clustered and Non-clustered indexing. Extensive work on the performance tuning process.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the data.
• Created relevant staging tables to load data, identified the business validation rules.
• Improved performance of PL SQL program units by using Bulk collect and Bulk bind
(ForAll) and other advanced tuning performance techniques.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Virtusa Consultant Services Pvt Ltd, India Dec 2014 to May 2019 Client : British Telecommunication Plc. (BT), UK
Project Name : Revenue Assurance (RA+)
Description: Revenue Assurance management systems and operations that are concerned with the direct capture, processing and collection of revenues. The process of guaranteeing that the revenue management chain is functioning as specified. Revenue assurance is a business process to detect, probe correct revenue leakage, to minimize opportunity loss, to minimize/ avoid costs. My role as a pl/sql developer involves around building oracle data objects to achieve Data acquisition and data exploitation .Data Acquisition involves in consuming billing data (Usage/Non-Usage) data in huge amounts from the Mediation and Billing teams. As the data acquired are in the huge volumes hence data management activities like partitioning, compressing the data objects are implemented. Data exploitation involves in creating data objects like packages/procedures to derive the statistical/logical data from the raw data received from the source systems and the same is projected in graphical views to the stake holders. Deployment process is done by via Unix, install shell script with the respective rollback shell script are prepared along with accurate post deployment check shell script. The Sherwin- Williams Company is an American Fortune 500 company leading companies in the manufacture, distribution, sale of paints and coatings. One of the main objectives of this project is to take the legacy Customer Processing Repository Mainframe application into an ORACLE based system.
• Involved to determine business/technical requirements, analyzing business process and workflows and suggest improvements.
• Coding of stored procedures, triggers, packages, functions and complex queries at an advanced level; SQL loading using SQL Loader, external tables.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Involved in performance tuning of databases and applications by optimizing database code utilizing.
• Worked on PL/SQL collections, Bulk collections and Exception handling.
• Modification in existing code according the BT business requirements.
• Wrote SQL queries using joins, sub queries and co-related sub queries to retrieve Data from the database.
• Maintained Data Integrity by applying Constraints at column level and table level.
• Creating Tables, Indexes, and Views etc.
• Writing Queries using Joins and Sub-Queries.
• Involved to Writing SQL Queries for Client Requirement.
• Writing Packages and Triggers using PL/SQL.
• Involved to writing Exceptions.
• Data loading into tables from Data Files using Oracle External Tables Concept.
• Perform unit testing in dev environment and coordinate testing in test environment and in Production.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions. Along with Code development worked on impact analysis of fix, unit test case preparation and unit testing.
Contact this candidate