Oracle/PL/SQL developer
Resume:
Rajani Konakanchi
************@*****.***
Professional Summary
* ***** ** ********** ** the IT Industry, of which into Oracle, SQL & PL/SQL,PostgreSQL, Shell Scripting, Data Engineering, Unix, ETL Control-M.Experience in serving the ERP, Warehouse, Insurance, Retail, Legal and Banking systems. A motivated team player& Lead with excellent inter-personal skills. Responsible software Engineer, fast and self-learner having good technical abilities and skills developed by a hard work ethic.
Summary:
•Involved in all phases of the Software Development Life Cycle (SDLC)from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
•Domain Knowledge of Banking, Insurance, Retail and Legal sector's database environments.
•Having experience in implementing projects in USA, Europe& Canada.
•Experience in implementing data solutions in a Warehouse environment.
•Experience in interacting with Client team to understand the requirements.
•Proficient experience in RDBMS Oracle SQL concepts like Joins, Indexes and Constraints, Sub query’s, views/Materialized Views, sequences.
•Proficient experience in Oracle and Advance PL\SQL concepts like cursors, Collections and Stored Procedures, Functions, Packages, exceptions, Triggers, Bulk binds/Collect, Records Exception handling, partition management and PL/SQL Tables.
•Having experience and technical skills in Oracle SQL and object-oriented development environments.
•Strong Knowledge to Understanding of relational database concepts and experience with Linux/Unix toolsets.
•Expertise in Client-Server application development using Oracle PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
•Hands on experience in PostgreSQL database design principles, performance tuning, query optimization.
•Having experience in EDB PostgreSQLand Aurora PostgreSQL.
•Experience in Data warehousing with strong knowledge of Oracle including Oracle PL/SQL, Procedures and Performance tuning.
•Having handling experience in Query Performance Issues and AWR .
•Having support knowledge large-scale distributed applications in a mission-critical production environment.
•Using Autosys scheduled and monitored jobs.
•Experience in Unix/Linux commends and shell Scripting.
•Having knowledge in POWER BI.
•Having strong Debugging and troubleshooting skills.
•Excellent organizational and interpersonal skills with a strong technical background.
•Involved in on call for Production Support to resolve issues quickly. Strong computational, analytical problem solving and design skills.
•Well experienced with client interaction and implementation of projects within timeline and Experience in Atlassian toolset like JIRAsoftware, Confluence.
•Ability to learn new technology and acclimatize to new environment and achieve organizational integration like Snowflake, ETL.
•Having good knowledge in Azure, AWS Cloud and Data engineering.
•Certified Microsoft Data Engineerusing (ADF, Synapse, Databricks, PySpark, SQL).
Technical Skills:
RDBMS Database : Oracle 10g and above, PostgreSQL.
SDLCMethodologies : Waterfall, Agile SCURM, Test Driven Development.
Programming : Oracle-SQL,PL\SQL, SQL,Core-Java, PostgreSQL .
Cloud : Azure, AWS.
SQL Tools : TOAD, PL/SQL Developer, SQL Developer.
ETL Tools : Informatics,Apteryx, ADF.
Big Data Technologies : Exposure on Hadoop, HDFS, Hive, Spark
Cloud Data Engineering : ADF, Synapseanalytics, Databricks.
Scripting Languages : Shell Scripting, Python.
GUI Tools : SQL Developer, PLSQL Developer, Toad, DBeaver, PgAdmin.
Project Management Tools : SVN, JIRA, GitHub,Workflow.
Operating Systems : All Version of Microsoft Windows, Unix, Linux.
Cloud-database services : AWS RDS, AWSAurora, Data Migration Service
Web Technologies :HTML5, CSS3, JSON, XML.
Ssh client Tools : Putty, WinSCP, FileZilla.
IDE : Visual Studio, Eclipse IDE, Notepad++.
OS : Windows Server, UNIX, Linux.
EDUCATION:
Master of Computer Application from Acharya Nagarjuna University in 2011.
Bachelor of Science from Acharya Nagarjuna University in 2008.
Project Details –
Employers Details: Al Ansari Financial Services (26/Aug /2024- Till Now).
Project -1 Arex Application (Payments) product.
Role: Senior Oracle Developer
Client: - Al Ansari Financial Services, UAE
Environment: - Oracle SQL, PL/SQL, UNIX, Shell Script, GIT, JIRA, SQL Developer, AWS, PL/SQL Developer, Jules CI/CD.
Project Description
The Arex Application is an innovative Financial Services application aimed at revolutionizing the way users manage their financial transactions. This cutting-edge platform integrates various financial services like Money Transfer, Currency Exchange, Bill Payments, and Financial Insights etc.
Responsibilities:
Working as a Senior Database Lead, Analyze the Business requirement Documents and convert them into technical specification documents and high-level design documents.
Co-ordinate with different vendor teams for resolve issues, gathering requirement and discuss about support issues.
Work with Support team for data fix issues and application implementation issues
Developed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using PL/SQL Developer and SQL Developer.
Generated server-side PL/SQLscripts for data manipulation and validation and materialized views.
Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
Created and enhanced several PL/SQL Scripts according to the changing needs of the project and client requirements.
Involved in creating UNIX shellscripting for batch jobs.
Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuningusing Profiling, AWR, ADDM and implementation experience in complete SystemDevelopmentLifeCycle.
Performed modifications on existing code as per change request and maintained it.
Worked on SQL*Loader to upload bulk data into database from external files.
Used Advanced PL/SQL Collections and used BULK Binding.
involved in writing database procedures, functions, and packages for Front End Module.
Involved in Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
Experienced Database environments using in CLOUD like Azure.
Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and implementation experience in complete SystemDevelopmentLifeCycle.Extracted data from the XML file and loaded it into the database.
Performed modifications on existing code as per change request and maintained it.
Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
Used GIT and SVN Repository for project code Version movements.
Worked with JIRA and Confluence tools for Issue tracking.
Used bitbucket for code handling in Jules CI/CD.
Involved in the continuous enhancements and fixing of production problems. Designed, implemented, and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
Employers Details : Team lease digital Pvt. Ltd (15/May/2023-17/Aug/2024).
Project-2 BOA – DAC (Deal Accounting Support).
Role: Analyst (PL/SQL).
Client’s: - Accenture solutions pvt ltd, Bank of America
Environment: –Oracle SQL, PL/SQL, UNIX, Shell Scripting, JSON, XML, Jira, Agile, Autosys, Bit bucket and Junkins.
Project Description
BOA-DOC was established to assists bank of America Securities in the tracking and recovery of reimbursable expenses on capital Raising (Equities and Bonds) and Advisory(Services) transaction with the objective of improve recovery rates by identifying deal related expenses.
Responsibilities: -
Worked as a Senior Database Developer, coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Interacting with business analysts to analyze the user requirements, functional specifications, and system specifications.
Created and modified several PL/SQL Scripts according to the changing needs of the project and client requirements.
Involved in the continuous enhancements and fixing of production problems.
Performed SQL and PL/SQL tuning and Application tuning.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Implemented OracleStored Procedures, Functions & Triggers and Packages.
Used the AWS cloud for project specifications.
Created PostgreSQL database objects like tables, views,Indexes, Triggers etc.
Strongly involved in maintenance & troubleshooting of customized module developed in Oracle SQL & PL/SQL and PostgreSQL.
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer.
Involved in testing the application manually before automating the desired test cases.
Generation of unit test cases from Functional Specifications.
Fixed Very long pending product issues.
ETL processing’s like Data Cleansing, Integration & Transformation which involves the data extractions from different sources based on the requirement.
Analyzes, debugs and/or assists in problem solving in both development and production environments.
Resolved performance optimization problems and encountered on request any issue raised in Workflow fails.
Using Autosys scheduled the Jobs.
Used GIT Repository for project code Version movements.
Worked as a Application DBA tasks like Build INDEXs, Tuning Query’s, Profiling PLSQL objects.
Worked with JIRA and Confluence tools for Issue tracking.
Responsible for development, maintenance of the Quality and process adherence.
Gather reporting requirements from various stakeholders, architect the solution/report, Understand/analyze the source data and deliver the reports in timely manner.
Performance Monitoring, fine-tuning and optimization of data pipelines using AWR, ADDM.
Design and implement ETL solutions by extensive SQL scripting, ETL tools on cloud.
Lead code reviews and mentor junior resources.
Employers Details : Enhops solutions pvt ltd(client-CNSI)(07/Feb/2022-12/May/2023).
Project -3
EvoBrix X™ - (Core Claims, Configurations, PMIS, DRF, CORESPONDENCE)
Role: Development Engineer (Oracle, PL\SQL).
Client: - CNSI’s
Environment:- Oracle SQL, PL/SQ, AWS, JSON,XML, Jira, Unix, Shell Script.
Project Description
EvoBrix X™ - healthcare platform is regarded as the most advanced MMIS platform in the market and Claim is an invoice for health care services that a provider (such as doctor, clinic or hospital) sends to a health insurer for payment. This invoice shows exactly what services a patient had received.
Responsibilities:
Worked as a Senior Database Developer, Developed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator.
Generated server-side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
Migrated the existing Oracle code into PostgreSQL.
Created and modified several PL/SQL and PostgreSQL Scripts according to the changing needs of the project and client requirements.
Involved in creating UNIXshellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
Performed modifications on existing code as per change request and maintained it.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages and PL/SQL Collections and used BULK Binding.
involved in writing database procedures, functions, and packages for Front End Module.
Involved in Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
Experienced Database environments using in CLOUD like AWS.
Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and implementation experience in complete SystemDevelopmentLifeCycle.Extracted data from the XML file and loaded it into the database.
Performed modifications on existing code as per change request and maintained it.
Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions, and packages for Front End Module.
Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.
Used GIT and SVN Repository for project code Version movements.
Worked with JIRA and Confluence tools for Issue tracking.
Developed programs in PostgreSQL toconvert Oracle procedures and Packages.
Involved in the continuous enhancements and fixing of production problems. Designed, implemented, and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
Employers Details : Influxarena technologies pvt ltd (17/Sep/2016 - 21/Jan/2022).
Project -4 : Retail Merchandising Support.
Role:- Software Developer.
Client name: - Hudson Bay company, USA.
Environment: Oracle SQL, PL\SQL, Developer 2000 (Forms 4.5, Reports 3.0), SQL * Loader, UNIX, Shell Scripting, Oracle Reports, Oracle Exadata, PLSQL Developer, Unix, Shell Scripting, AutoSys.
Project Description
HBC is using RMS (Retek Merchandising System) to support their merchandising activities that include price / cost management, PO management / Physical inventory process management. This project involves supporting RETEK / Top Plan Key Plan Nightly batch process and support bug-fixes and enhancements. Support to RETEK system in HBC involves 24/7 support that includes the offshore and onsite team.
Responsibilities: -
Responsible for maintaining quality data on reporting layers by performing operations such as cleaning, transformation and ensuring data integrity.
Designing, creating, testing and maintaining the complete data management and processing systems.
Introducing new data management tools & technologies into the existing system to make it more efficient. Establishing data governance.
Translate business propositions into quantitative queries and collect/clean useful data. Performing data analysis for source and target data.
Handling a team of developers from Data Science & Reporting teams and Monitoring project development, interacting with clients to gather business requirements.
Implemented multiple integration process from WMS to FedEx, DHL and other carriers to achieve the Shipment and Carrier tracking solution.
Strongly involved in maintenance & troubleshooting of customized data by Oracle Exadata.
Analysing the requirements for the interfaces and checking the feasibility in the product for the development.
Using Oracle Exadata to run daily data transaction workloads with highest performance.
Monitoring and troubleshooting databases with large amounts of data (Terabytes) and high transaction rates with using Oracle Exadata.
Building interfaces for other systems, Tuning and enhancing the system, write Low Level Design (LLD) specification.
Provide team leadership for a team of engineers plus technical leadership oversight for solutions in the process.
Involved in solving Production issues as a member of the Application Support Team.
Played the role of Oracle–Software Engineer from Offshore.
Involved on –call activity with weekend support.
Developed and enhanced the Pro*c Programs for batch jobs.
Developed programs in Pro*C to process the jobs using Oracle procedures and Packages.
Used Unix Shell Scripting for program execution and jobs running.
Developed the DB script’s (PL\SQL) for Data validating and Processing.
Involved in oracle performance tuning.
Involved monitoring the batch and investigate the data issues.
Involved in weekend job support for batch issues.
Writing SQL queries and reviewing SQL queries for the other team Members.
Participated in discussion meetings about requirements.
Used SVN for version control.
Implemented PL/SQL queries and used Oracle stored procedures, and built-in functions to retrieve and update data from the databases.
Project -5 : Prepaid Host with Multi Currency Functionality
Role: -Software Developer.
Client’s Name: -Indian Bank, Corporation Bank, Indian overseas Bank, Sodexho (Germany, Austria).
Environment: Oracle SQL, PL/SQL, SQL*LOADER PLSQL Developer, SQL PLUS, HP-UNIX shell scripting.
Project Description
Prepaid Host (Registered) is a Visa prepaid card back end supporting product which receives the financial message from Switch Application (Switch Application receives the transaction from different agents like Visa, Master Card) and does all the required validations and provides auth logic to debit/credit to the customer and sends the response back to the Switch Application.
Responsibilities: -
•Developing new functionalities (like Foreign Exchange) for prepaid host module and supporting.
•Debugging the packages, functions, procedures and triggers for resolving bugs.
•Performing Unit & Integration testing and Maintenance.
•Used Unix Shell Scripting for program execution and jobs running.
•Requirement gathering from the Business Team and Participated in discussion meetings about requirements.
•Convert the functional requirements into technical document as per the business standards.
•Involved in solving Production issues as a member of the Application Support Team.
•Used SVN for version control.
•Participated in discussion meetings about requirements.
•Developed Advance PL/SQL packages, procedures, triggers, functions, and SQL Objects.
•The responsibility includes monitoring of daily UNIX jobs, Calculation of EOD transactions for customers of Bank from PPH side.
(Rajani.Konakanchi)
Contact this candidate