Pl Sql Developer

SIRISHA CHIKKA

Oracle PL/SQL Developer

*******.******@*****.*** 201-***-****

Professional experience:

● Having more than 8 years of programming experience as an Oracle PL/SQL developer in analysis, Design, implementation and testing of business applications in OLTP, web based, Client/Server architectures using Oracle Relational Database Management System.

● Extensive experience as Oracle Developer in developing and utilizing PL/SQL procedures, functions, packages, triggers incorporating advanced PL/SQL techniques like analytic functions, Dynamic SQL, BULK techniques, Collections, regular expressions and Ref cursors etc.,

● Well-versed in development and deployment of applications using Oracle Database 11g/10g/9i/8i and Oracle D2K.

● Experience in Database design using Normalization and E/R Diagrams

● Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.

● Strong knowledge of Extraction, Transformation and Loading (ETL) processes using UNIX/Linux shell scripting, SQL, PL/SQL and External Table/SQL Loader.

● Highly knowledgeable in SDLC methodologies (Agile).

● Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, HINTS, DBMS_PROFILER etc.

● Proficient in building, migrating and customizing Oracle Forms using Forms Builder 6i/9i/10g.

● Proficient in building, migrating and customizing Oracle Reports using Reports Builder 6i/9i/10g.

● Enormous capability in development of Oracle SQL objects like Tables, Views, Constraints and Indexes, etc.

● Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB, UTL_FILE, etc.

● Experience in Database modeling and database object definitions using tools like Oracle Designer.

● Expertise in using tools such as SQL*Plus, TOAD, SQL Developer and Rapid SQL.

● Knowledge on XML Publisher

● Experience in Error handling and debugging ycoding issues and troubleshooting production problems.

● Experience in writing technical design documents and developing unit test documents.

● Good at gathering requirements from clients, designing, developing, debugging and deployment of Oracle database objects, Forms and Reports.

● Strong communication, interpersonal, analytical skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.

● Energetic and self-motivated team player, quick learner. At ease in high stress and fast-paced environments requiring the ability to effectively handle responsibilities. Technical Expertise:

Databases Oracle 12c/11g/10g/9i/8i/7.3, Cassandra

Primary

Tech Skills

Oracle, SQL, PL/SQL

GUI Forms 10g/6i/4.5, Reports 10g/6i/2.5, Oracle Discoverer 6i, Core Java.

Tools and

Utilities

TOAD, SQL*Plus, SQL Navigator, UTL_File Packages,

SQL*LOADER, PUTTY, XML Publisher,Radar,CST

Web

Technologi

es

HTML, DHTML.

Application

s Software

Developer2000, Forms 6i/9i, Reports 6i/9i, Oracle Developer Suite 10g, Oracle Designer

Version

Controls

VSS, SVN, GIT

OS Windows NT/XP/2000, HP-Unix, Mac,Linux

Domains Banking, Telecommunications & Manufacturing Education, Awards, Appreciations & Certificates:

● Bachelor of engineering (B.Tech) from Jawaharlal Nehru Technological University (JNTU), India.

● Attended functional training on Finacle and Banking Domain in Infosys

● Completed Core Retail and Core Technical Certifications in Infosys. Project Details:

Citi Bank, USA July 2022 – Aug 2023

Specialist - Software Engineering

Citi is a preeminent banking partner for institutions with cross-border needs, a global pioneer in wealth management and a valued personal bank in its home market of the United States. Citi does business in more than 160 countries and jurisdictions, providing corporations, governments, investors, institutions, and people with a broad range of financial products and services.

● Triage major incidents, perform root cause analysis, and implement corrective actions on technical issues.

● Involved in designing, developing, and implementing the CRP new functionality.

● · Create Oracle SQL/PLSQL sophisticated procedural for data analysis and report generation.

● · Provide technical support to end-users and resolve database-related issues.

● · Collaborate with project managers and business analysts to ensure project deadlines and objectives are met.

● Use Agile SCRUM principles: business analysis, story writing, acceptance testing, end user certification.

● Automation of manual activities through Shell scripting.

● Setup monitoring and alerting to proactively identify potential issues in the application.

● Involved in server migration activities which requires good understanding of the application and various technologies involved in architecture.

● Perform deployments during release and oversee post release checkouts to ensure system stability after every major and minor release.

● Implement ITIL concepts of Incident/Problem/Change/Capacity/Knowledge Management to ensure the highest level of services are provided to the global customer base.

● Coordination with various internal teams such as Network, Storage, System Administration, Development, and business in ensuring that finest level of services is provided to the application. Online Store Engineering; Apple Inc., USA Nov 2019 – July 2022 Oracle Developer

Apple Inc is one of the leading product-based company in designing/manufacturing the smart phones and Accessories. The AOS team is responsible for delivering the e-commerce systems and solutions that enable and support the buying experience on apple.com. We build one of the slickest e-commerce sites on planet while keeping Apple brand at the forefront in every aspect of the engineering. AOS is present in 39 countries and transacts in 27 currencies with a full compliment of e-commerce feature suite. This team is responsible for the core transactional Apps and Services that are the backbone for omni channel Apple commerce. The domain includes price, taxation, customer account management, cart, checkout, inventory management, delivery management, order management, payments processing, encryption/security, and post order processing. The transactional workflow guides our users through a seamless ordering experience, with the ability to process at unmatched speed. Responsibilities:

● Ensure Best Practices are followed for reducing redundancy of code and major focus on improving Performance and reusability of artifacts across the projects.

● Analyzing the business requirements, setting up design review with platform team, and preparation of Minor Design Documents.

● Active participation in the data model changes and assistance to Data Modeler regarding the table structure changes and range/values for new fields.

● Provide analysis details for the Production problems encountered. Ensure the Production problems are resolved within SLA.

● Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader.

● Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.

● Using Ref cursors and collections for accessing complex data resulted from the joining of a large number of tables in PL/SQL blocks and even have experience with exception handling.

● Extensively working on SQL developer

● Good Exposure on Radar and CST.

● Coordinating with offshore team daily.

● Creating and monitoring Autosys Jobs

● Participating in project planning, documentation, testing and validation procedures

● Sound knowledge in version control tool SVN and Bitbucket Raiffeisen bank, Czech Republic Jan 2011 - Aug 2013 Technology Analyst

Project Type : Development & Support

Raiffeisen bank a.s. is a member of the Raiffeisen international financial group with its head office in Austria. The group has been active in the area of banking in the Czech Republic for over 140 years. Currently, Raiffeisen bank has 43 branch offices throughout the Czech Republic. Raiffeisen bank provides a wide range of financial products and services to all types of clientele. They are using Finacle product for their operations of Banking. The Product FINACLE is a Banking solution developed by Infosys Limited. In this Bank Implemented Finacle product for the areas like Trade Finance, Payment Systems, Loans, Liabilities, Assets etc. Finacle is an integrated, on-line, enterprise banking solution designed to provide the "e-platform" for the global banking industry. We are specifically focus on the Trade Finance module. Responsibilities:

● Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

● Performance tuning and optimizing SQL statements using explain plan, TKPROF utility, by setting database parameters, by using optimizer hints.

● Created and maintained PL/SQL packages, procedures and functions.

● Design, develop and maintain oracle database schema, tables, standard views, synonyms, indexes, constraints, triggers, sequences, cursors and other database objects.

● Write complex SQL queries with sub-queries, analytical functions and inline views.

● Prepared the Unit test plans and Integration Test plans.

● Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

● Creating Collections (nested tables and arrays) for improving Query performance by reducing context switching and Dynamic SQL.

● Creating PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

● Developed reports using complex queries as per client request as a part of production support.

● Helped Team members on Business and Technical issues and give Training and Presentation to Clients and New team Members.

Environment: Oracle 10g/11g, TOAD, SQL*Loader, SQL Developer, PL/SQL Developer, UNIX, Windows XP.

DepartmentOfPost; Infosys Hyd, India Jan 2011 – Aug 2013 Technology Analyst

Development and Production Support

The Department of Posts is one of the largest providers of financial services in the country. They are using Finacle product for their operations of Banking. The Product FINACLE is a Banking solution developed by Infosys Limited. In this Bank Implemented Finacle product for the areas like Trade Finance, Payment Systems, Loans, Liabilities, Assets etc. Finacle is an integrated, on-line, enterprise banking solution designed to provide the "e- platform" for the global banking industry. We are specifically focus ongenericreportsmodule. Responsibilities:

● Creation of database objects like tables, views, procedures, and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

● Expertise in Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

● Used the technical document to design the database tables.

● Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.

● Getting the approval for low level design and proceed towards leading the team in construction and development phase.

● Worked with all intermediate systems for Integration testing.

● Preparing Functional specs for various customized components developed.

● Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

● Utilized SQL*Loader to load flat files into database tables.

● Performed SQL tuning using Explain Plan, Hints, and indexes.

● Analyse SQL statements, reorganize database objects to improve response of queries.

● Involved in handling the changes in compiling scripts according to the database changes.

● Worked extensively on Dynamic SQL, Bulk loading, Bulk processing.

● Writing high quality and well documented code according to standards.

● Helped Team members on Business and Technical issues and gave Training and Presentation to Clients and New team Members.

Environment: Oracle 11g, TOAD, SQL Developer, Shell Scripts, UNIX, Putty, WINSCP, Windows XP, Control M.

British Telecom, Tech Mahindra, India Feb 2010 - Oct 2010 Software Consultant

Project Type: Production Support & Enhancements

BT Group plc is a British multinational telecommunication holding company headquartered in London, United Kingdom. It has operations in around 180 countries and is the largest provider of fixed-line, broadband and mobile services in the UK, and provides subscription television and IT services. Responsibilities:

● Involved in the continuous enhancements and fixing of production problems.

● Wrote complex queries using various types of joins to retrieve and store data in Oracle database.

● Developed and modified various PL/SQL Packages, Stored Procedures and Database Triggers.

● Managed performance tuning of SQL queries and fixed the slow running queries in production with database utilities like Explain Plan, SQL Trace.

● Providing weekly status to the clients on the progress of development status. Environment: Oracle 10g, TOAD, SQL Developer, UNIX, Windows XP. CFST - Citizen Friendly Services of Transport Department, India June 2009 – Feb 2010 Software Engineer

Project Type : Development and Support

Raasi soft looking after entire Andhra Pradesh's road transport Authority, computerization of 39 centers of A.P, the objective of computerization is to make the Transport Department Citizen friendly in its functioning and provide SMART services to the public. It is intended to build comprehensive database and provide on-line services to the public covering all gamut of services of Transport Department like Issue of Driving Licenses, Registration, Permits, and Taxation etc. All the offices in the state have inter- connectivity through APSWAN.

Responsibilities:

● Designed and developed complex Oracle Reports and master detail forms using Oracle Developer 2000.

● Requirement gathering, Proposing solutions and Estimates.

● Developed various Oracle SQL and PL/SQL objects.

● Analyzing the business requirements from client and designing the Technical Specification for architect's review

● Performed thorough Unit testing, System Testing and User Acceptance Testing in development environment for the result of error free and smooth migration process and provided quality work for functional users.

● Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

● Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

● Involved in knowledge transfer sessions for other dependent/cross functional and support teams to ensure that the application under development confined to the business requirements and any changes in design/requirement are communicated and shared. Environment: Oracle 9i, TOAD, SQL Developer, UNIX, Windows XP, Oracle Forms, Oracle reports. Abaadsoft Pvt Ltd, India Mar 2009 – Jun 2009

Programmer

Project Type : Development and Support

Abaadsoft Pvt. Ltd. is a software development house, currently engaged in developing Integrated Insurance Solutions for an overseas company having strong presence in Insurance arena. They are presently working on projects related to some of the renowned Insurance companies in the region. Responsibilities:

● Designed and developed complex Oracle Reports and master detail forms using Oracle Developer 2000.

● Involved in the maintenance and enhancement of the application.

● Created database objects needed such as tables, views, indexes, sequences, procedure, functions, and packages.

● Developing PL/SQL triggers and master tables for automatic creation of primary keys. Environment: Oracle 9i, TOAD, SQL Developer, UNIX, Windows XP, Oracle Forms, Oracle reports. OCV Reinforcements Manufacturing Ltd, India Dec 2007 – Mar 2009 Software Engineer

Project Type : Development and Support

Owens Corning has been supplying consistently glass Fiber products for the reinforcement of high- performance composites and our background is strong with more than 70 years of experience. They are presently working on projects related to some of the renowned Insurance companies in the region. Responsibilities:

● Designed and developed complex Oracle Reports and master detail forms using Oracle Developer 2000.

● Participated in the development of new PL/SQL procedures, functions, and triggers and also updating the old ones based on the change requests.

● Created various DML and DDL statements using Oracle SQL and PL/SQL.

● Analyzing the business requirements from client and designing the Technical Specification for architect's review

● Extensively used object libraries, PLSQL libraries, dynamic Record Groups, static record groups, LOVs, dynamic assignment for LOVs to the fields & record groups.

● Performed modifications on existing forms as per change request and maintained it.

● Using Pragma Autonomous Transaction to avoid mutating problem in database trigger.

● Improved the performance of the application by rewriting the SQL queries. Environment: Oracle 9i, TOAD, SQL Developer, UNIX, Windows XP, Oracle Forms, Oracle reports.

Contact this candidate