Sql Developer Software Development

Janaki Talari

Summary:

Over ** years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.

Experience with Data flow diagrams, Data dictionary, Database normalization theory

techniques, Entity relation modeling and design techniques.

Expertise in Client-Server application development using Oracle 12C/11g/10g/9i/8i, PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Strong experience in Data warehouse concepts, ETL.

Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

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

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Technical Skills:

Programming: C, C++, SQL, PL/SQL

Cloud Technologies: Microsoft Azure

Database: ORACLE (Versions 8i/9i/10g/11g/12c), SQL Server 2019, MySQL

Platforms: Windows family, DOS, UNIX

Tools: SQL*Plus, SQL Loader, SQL Developer, Oracle Developer, TOAD, Putty, TKPROF

Rational ClearCase (Version Control tool), SQL Trace and SQL Analyzer

Scripting: Java Scripting, UNIX Shell Scripting

Education:

Bachelor’s in Computer Science and Engineering

Chevron – Sr. Oracle PL/SQL Developer Jun’ 2019 – Present

Description:

Chevron Corporation is an integrated energy company with operations in countries located around the world. The Company produces and transports crude oil and natural gas. Chevron also refines, markets, and distributes fuels, as well as is involved in chemical and mining operations, power generation, and energy services.

Responsibilities:

Participated in Requirement gathering from the clients.

Responsible for Analysis and Database design as per the project requirement.

Developed Shell Scripts to extract the data from Intelligent Network.

Generated Stored Procedures and Packages in PL/SQL.

Developed UNIX Shell Scripts to alert users in the event of failures and to automate jobs.

Performed Disaster Recovery Testing.

Involved in Migration and Maintenance activities.

Worked on creating User defined Data Types, Rollback Segments.

Implemented Database Tuning using various Normalizations. Worked on Tuning using Explain Plan and tuning tools like SQL Trace and SQL Analyzer.

Integrated the mailing system to alert various groups on the status of Data extraction and Data Processing.

Created Database Objects (Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views) in the Development and Production environment of PL/SQL.

Developed SQL Loader, Export, and Import Utilities to load the data into the custom tables.

Developed and Scheduled UNIX Shell Scripts to check the status of the Batch jobs and to trigger the fail events in regular intervals of time.

Tasks Allocation and coordinating with team for completion on time.

Reviewed Code and suggested improvement solutions.

Generated Adhoc Reports using SQL Queries and Procedures as per Business Needs.

Developed SQL Queries to fetch complex data from different tables in remote Databases using various Joins and Database Links.

Environment: Oracle 12c, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

CHASE- Oracle PL/SQL Developer Jan’ 2014 – May’ 2019

Description:

CHASE Bank is one of the leading banks in the world with a base in US and spreading its services across the world. The database links static historical data with actual client performance and acts as a comprehensive information warehouse that gathers stores and analyzes the data necessary to facilitate target marketing.

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.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Involved in the continuous enhancements and fixing of production problems.

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and

manipulate files.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context

switching between SQL and PL/SQL engines.

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

Creation of database objects like tables, views, materialized views, procedures and

packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Partitioned the fact tables and materialized views to enhance the performance.

Extensively used bulk collection in PL/SQL objects for improving the performance.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

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

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, UNIX shell scripting.

TCS- Oracle Developer/Analyst Jun’ 2006 – Jun’ 2012

PREPAID-AIS-3G and MNP services Launch

Description:

This project dealt with launching 3G services for DOCOMO customers, providing options to customers for changing the speed on network, developing Multi Number Portability (MNP) functionalities.

Responsibilities:

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Automated manual process of triggering events in Database at regular intervals using UNIX Shell Scripting.

Guided the team members for production support using the latest available processes avoiding much of manual work.

Analyzed User requests for CRs (change requests) and coordinated with upstream and downstream systems.

Developed PL/SQL Procedures and Database Triggers for the validation of Input Data and to Implement Business Rules.

Created Database Objects like Packages, Procedures and Functions according to the Client requirement.

Understanding the PL/SQL code for issues in the database and advice the development team with logs.

Writing shell scripts to automate the data loading.

Involved in various stages of development like Analysis, Design, Coding and unit testing.

Responsible for managing the reports and Alerts from the database using scheduled UNIX Shell Scripts and responsible for UNIT Testing.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows 2000, Toad.

Contact this candidate