Sign in

Sql Developer

Alpharetta, Georgia, United States
June 12, 2018

Contact this candidate


Tejovathi Amasa


Professional Summary:

Having 12+ Years of of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications(Oracle CRM,POS,Oracle Applications 11ie) 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(RAC DB)/11g/10g/9i, 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.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Expertise Knowledge in Oracle Golden Gate replication set up between more number of Data bases.

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/list partition techniques.

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.

Extensively worked on AutoSys jobs Creation and Monitoring.

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.

Experience in the area of analysis, design, development, testing, implementation and Production Support of complex Servers with applications using Oracle Applications (CRM,AOL,SYSAdmin.),JDA Manugistics and Redprairie.

Having Good Knowledge in Point Of Sale(POS) .

Expertise in developing and customizing Forms and Reports using Oracle Forms 6i, Reports 6i and developing concurrent programs using SQL, PL/SQL and Unix Shell Scripting.

Hands on Experience on Redprairie Warehouse Management System Inbound/Outbound Process.

Developed complex Redprairie Reports and MOCA commands.

Experience in working with JDA Manugistics Modules like Supply and Transportation Management.

Developed complex SQL queries for Cognos Reports and Jasper Reports.

Proficient work experience in Developing IReports 4.0.1 and Cognos.

Worked with query tools like Toad, SQL*Plus, SQL Developer.

Extensively used Version control tools PVCS, Kintana.

Hands on implementation experience in industries like Media and Entertainment, Customer Relationship Management, Communications, Supply Chain Management, Warehouse Management System and Transportation Management.

Having good experience in interacting and working collaboratively with cross functional teams.

Involved in preparing the SQL and PL/SQL coding convention and standards.

Involved in preparing the functional specification, technical documentation, schema

Documents, flow charts and user support documents.

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

Technical Skills:

Operation Systems

MAC OS,Windows 10/08/07/Vista/XP/2003/2007 Server/2000/NT/98, UNIX and LINUX


SQL, PL/SQL, C, C++, UNIX Shell Scripting,WebQL,COBOL


Oracle 12c/11g/10g/9i/8i, MySQL.


Oracle Application (CRM)11i,JDA Manugistics, Redprairie,Oracle Transportation Management and POS.

Version control Tools



Developer 6i/2000, Oracle Applications 11i,Cognos Reports,iReports and Redprairie.

Application Servers

Oracle 9iAS, Oracle Application Server,JDA Application Server,POS.


SQL*Net 2.1/2.3, Net 8 and Net Manager (oracle)


PL/SQL Developer, SQL Loader, SQL Developer, MS Office, TOAD, LextEdit, TWS, Magic, Kintana, PVCS, Oracle Forms and Reports Builder, SecureShell.RADAR,ESPRESSO and Golden Gate.

Work Experience:

AT & T, Alpharetta,GA March’14-Tilldate

Role : Oracle Developer and Application DBA

Description: Point of sale Dot Com Suite. PDC Suite provides a retail POS application used by indirect partners to do activation and customer maintenance for ATT products. PDC supports wireless, U-verse IPTV, High Speed Internet Access, VOIP, and home phone products and services for consumers and small businesses and a back-office application used by Company Owned Retail employees and Indirect partners to support the capture and retrieval of customer provisioning information for offline sales and manual orders.


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

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

Creating and modifying several UNIX shellScripts 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.

Creating AutoSys Jobs and Monitoring on daily Basis.

Involving in the continuous enhancements and fixing of production problems.

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

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

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

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

Creating 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.

Generating HTML Output with PL/SQL.

Passing Parameters to a PL/SQL Web Application

Performing Network Operations within PL/SQL Stored Procedures

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

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

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

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

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

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

Using 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.

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

Coordinating with the front end design Java team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Dealing with Huge Data base upto 32 TB.

Environment: JAVA,Oracle 12c RAC /11g/, POS,SQL,PL/SQL, SVN, Linux,TOAD,Oracle Golden Gate .

Apple Inc,Sunnyvale,CA July’13-Mar’2014

Role :Senior Oracle Developer

Description: An Apple POS System features the Apple Point-of-Sale application, which runs in all Apple retail stores. This software automates sales by enabling comprehensive functions vital to the Apple retail marketplace, such as reporting, processing of returns, sales, discounts/exceptions, and receipt printing and configuration.


Developed Advance PL/SQLpackages, 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.

Created management analysis reporting using ParallelQueries, Javastoredprocedure, HTPPackage and WEB.SHOW_DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.

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.

Handling AutoSys Jobs.

Hands on experience on GOLDEN GATE 11g and 12c administration and configuring all the necessary parameter required and troubleshooting abending issues.

Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.

Used SQL Server SSIStool to build high performance data integration solutions including extraction, transformation and load packages for Datawarehousing. Extracted data from the XML file and loaded it into the database.

Designed and developed Oracle forms & reports generating up to 60 reports.

Performed modifications on existing form 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/SQLCollections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.

Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.

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. Developed UNIXShellscripts to automate repetitive database processes.

Environment: Oracle 10g, POS,JAVA,SQL,PL/SQL, SVN,Expresso,Linux,SQL Developer.

Mars Information Systems,Mount Olive,NJ Oct’11- June’ 13

Role: Senior Developer


Mars Inc.,s an American manufacturer of confectionery, pet food, and other food products. It is ranked as the 5th largest privately held company in the United States. Mars operates in six business segments in the U.S. Like Chocolate, Pet care, Food, Drinks, Pet Food and Snacks.


Developing PL/SQL Packages, Procedures and Cursors to validate and apply Business Rules as per the Customer Requirement.

Involving in defect fixing, change request and release maintenance of the application.

Developing complex analytical queries for the Reporting tools like Congnos,Redprairie Report Designer and iReports.

Developing PL/SQL Functions, Cursors for various calculations in the application.

Developing Triggers for Data Audit Log.

Worked with Bulk Collects to improve the performance of multi-row queries

Tuning SQL queries for optimum performance, also responsible for performance Tuning Database.

Providing Production support for all Code related Issues.

Implementing MOCA Commands with SQL Queries for new Customizations.

Providing Adhoc solutions to User reported issues.

Developing the SQL*Loader scripts to load data into the staging tables from the flat files.

Created users, roles and granted privileges according to the business requirements.

Involving in capacity planning required, creating and maintaining database environments.

Participated in project planning, documentation, testing, and validation procedures.

Creating and Tracking CRs and Incident Tickets for the issues reported by Users in Magic Tool.

Sending E-Mailfrom PL/SQL

Getting a Host Name or Address from PL/SQL

Working with TCP/IP Connections from PL/SQL

Retrieving the Contents of an HTTP URL from PL/SQL

Working with Tables, Image Maps, Cookies, and CGI Variables from PL/SQL

Creating and Monitoring scheduled jobs in TWS.

Environment: Oracle 9i, JDA Manugistrics,TWS,TOAD,Redprairie,LextEdit,SQL,PL/SQL,Magic, Cognos Reports and Jasper Reports.

Cisco Systems,CA May’10-Oct’11

Role: Module Lead

Description: The main objective of CCW is to provide cisco customers with a single integrated, scalable, intuitive workspace to engage with Cisco throughout the purchasing process. Online Contract Management processes enable internal and external customers to perform data changes on service contracts. With CCW 4.0, Services are attached to either Major line level and/or attached to Minor line level. With CCW 6.0 Redesign the Product Upgrade Tool Process and With CCW 7.0 enhance the capabilities surrounding Disti Reseller model by capturing Order BID on the Contract.

CCW Applications are part of Oracle ERP Software Platform and the primary modules are IB, SA.


Developed Oracle CRM Interfaces like Pending Automation and Install Base with PL\SQL Objects like Procedures, Functions, Packages and Triggers etc.

Collaborated with business analysts, business users and other developers in conceptualization, design and development of the application within the Oracle database environment.

Evaluated requirements from functional specifications and created efficient technical designs.

Developed code by using Advanced PL/SQL concepts like External Tables to Export data from external sources.

Worked with Advanced PL\SQL concepts like Autonomous transaction, Ref Cursors, Bulk Collect, PL\SQL Collections etc.

Developing and Modifying AOL objects like Users, Responsibilities, Menus, Functions, Request Groups, Forms, Concurrent programs, Request Sets in front end as well as by creating scripts at backend.

Tuned database SQL statements and procedures by monitoring run time and system statistics.

Maintained accurate Version Control process Using PVCS tool

Created and Executed Unit and SIT cases in Quality Control.

Performed Thorough Unit and Integration Testing.

Migrating Code Successfully using PVCS and Kintana Tools.

Involved in PL/SQL code Fix Reported by QA while executing test cases in Stage and Production Environments.

Responsible for Go-Live activities and Post Production Support.

Responsible for Knowledge Transfer to Support and Maintenance People on the Changes Incorporated as part of current Release.

Environment: Oracle database 10g, PL\SQL Developer, JAVA, Oracle Applications 11i,Oracle CRM(SA,IB).

Cisco Systems,CA Apr’08 – May’10

Role: Oracle Developer

Description: This Synergy enables the next level of Cisco’s business growth, by transforming commerce capabilities. It will accelerate Cisco’s ability to provide its customers and partners with a world-class configuration, pricing and user experience for all of Cisco s offerings. Cisco’s customers and partners require new or improved commerce capabilities such as usage-based pricing for software, network-level pricing for services, and a dramatically improved configuration and pricing experience.


Modified Oracle CRM Service Agreements standard Interfaces like Contract Status Change and RMA process.

Creating Packages that enable the grouping of related PL/SQL objects, such as Procedures, Variables, Cursors, Functions, Constants, and Type Declarations.

Involved in creation and updates of several SQL packages and Procedures.

Worked on Triggers to provide a way of executing PL/SQL code on the occurrence of specific database events.

Maintained an audit log by setting triggers to fire.

Involved in designing Data flow diagrams, ERD’s, Use case diagrams, Process flow diagrams.

Modified existing codes and developed Oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.

Created Concurrent Programs, Responsibilities, Data Groups in Oracle Applications.

Worked with $U team to Schedule jobs.

Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.

Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Performed system integration testing and coordinated with the Testing team during UAT.

Participation in weekly design reviews and walkthroughs with project manager and development and QA teams.

Environment : Toad, SQL loader, SQL Developer, SQL * PLUS, Oracle Applications 11i, Oracle PL/SQL,SQL,PVCS,Kintana, Quality Control,$Universe .

McGraw-Hill, NJ Oct’06 - Apr’08

Role: Oracle Developer

Description: McGraw-Hill Construction connects people, projects and products across the design and construction industry. From project and product information to industry news, trends and forecasts, it provides industry players the tools and resources that help them save time, money, and energy.


Analyzing the Issues reported in Remedy tool by Client.

Understanding the Client Issues and prepare code Fix

Identifying and implementing the code changes to resolve the Issues.

Developed new procedures, functions, packages and triggers as part of Enhancements and Change Requests.

Documented application business process, Created functional and technical design and user guides.

Developed and modified the Webql scripts as per the Client Requirement.

Monitoring the Live applications daily and providing solutions for issues.

Used Indexes and Hints for fixing the performance issues.

Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.

Coded packages for Updating, Insertion and for Audit and Trial.

Worked with java application client through web server.

Environment: Oracle database 9i, PL\SQL Developer, TOAD, SQL, PL/SQL,Unix and Java.

Andhraprabha, India. May ’04 - Sep ‘06

Role: Software Developer

Description: This system helps a building a system with enterprise-wide connectivity capability to effectively manage and improve the efficiency of process involved in the area of advertisement. This system can be conceptualized in terms of the following modules.

1) Advertisement Booking 2) Advertisement Scheduling 3) Accounting & Receivables Management 4) Bill Dispatch & Branch Office Collection Monitoring.

Worked on Form triggers and Built-in packages.

Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.

Migrated Forms from Forms 4.5 to 6i.

Proficiently worked on Program Units, Object Libraries and different levels of Triggers.

Developed new Forms and Reports as per the Business Requirement.

Created Forms, Pop-up Menus and maintaining Master Detail relation-ship.

Tested all forms, PL/SQL code for logic correction.

Creation of Data base Objects like Tables, Views, Synonyms, Indexes and Sequences.

Generating Periodical Reports.

Education :

M.B.A. – Master of Business Administration From Srikrishnadevaraya University-2004.

B.Sc. –Bachelors in Computer Science –Srivenkateswara University-2002.

Certifications :

(1Z0-007) Introduction to Oracle9i:SQL

(1Z0-147) Oracle9i: Program with PL/SQL

Contact this candidate