Tejovathi Amasa

470-***-****

adhk25@r.postjobfree.com

Professional Summary:

Having 14+ Years of experience as an Oracle PL/SQL Developer and Application DBA in Analysis, Design, Implementation and Maintenance of Business Applications(Oracle CRM,Oracle TM,Oracle Applications 11i,Pos,SCM and JDA Manugistics) using the Oracle Relational Database Management System (RDBMS) and Data Replication Across Applications Using Oracle Golden Gate.

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.

Developing and delivering a detailed data migration plan.

Responsible for the resource allocation and Prioritization of all DB relate work .

Lead PL/SQL Developer for Client specific applications and Oracle CRM.

Expertise in Client-Server application development using Oracle 19c/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, and Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

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.

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

Owning the quality of the migrated data and the validity of the migration processes and operation

Developed materialized views for data replication in distributed environments.

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

Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11g/R12 RAC 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/list partition techniques.

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

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

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 and GitHub.

Hands on implementation experience in industries like Media and Entertainment, Customer Relationship Management,Retail, 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

Languages

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

RDBMS

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

Applications

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

Version control Tools

PVCS,Kintana,GitHub, SVN and Bitbucket.

GUIDevelopment

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

Application Servers

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

Network

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

Tools

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

Work Experience:

DTCC, Boston,MA April’2020-Till Date

Role : Database Migration Lead

Description: Sybase IQ is Datawarehouse in Alert Sytem.It provides billing and audit functionality. The Billing Functionality is being migrated into Alert Oracle Database, while Sybase IQ Datawarehouse is being replaced by cloud based Datwarehouse,AWS Data mart .Various Alert components uses SybaseIQ data.The SybaseIQ data is fed through Goldengate Replication From various data sources in ALERT.

Responsibilities:

Creating Documents for the migration plan and strategy.

Involved in delivery of all aspects of data analysis, mapping and transfer.

Creating and Importing dump files using expdp/impdp data pump Utility.

Identifying the data migration impact of all proposed changes

Validating Objects Using different utilities after Migration.

Working with source control tool of Bitbucket while dealing with migration scripts.

Tuning long running queries using different Partition techniques.

Creating Golden gate Processes across the applications.

Setting up Data lake repository for historical data.

Environment: Oracle 19c/Oracle 12c RAC, Golden Gate,Sql Squirrel Client,SQL,PL/SQL, Linux,TOAD,Sql Developer,AWS Datamart,Jira,Bitbucket.

Apple Inc,Sunnyvale,CA May’2018- Mar’2020

Role : Lead Oracle PL/SQL Developer

Description: The Ycard deals with Apple Gift card feature of Apple Inc., which are available in Apple Stores and Retails stores.Apple giftcards can buy in online or in stores which can be send through email or Mail as requested by customers.This process includes Buy,Activate,Redeem,Exchanging and Closing the gift cards.

Responsibilities:

Evaluation of requirements and designing technical specifications.

Creating data model as per the business requirements and generating DDLs accordingly.

Creating PL/SQL Packages,Stored Procedures,Functions and Object Types.

Implementing Advanced PL\SQL concepts like Autonomous transaction, Ref Cursors, Bulk Collect, Referential Partitions,PL\SQL Collections etc.

Responsible for creating queries for Daily Reports and Ad hoc requests coming up from Business Users.

Performing Unit and Integration testing.

Creating strategy for backup and Archival Process.

Monitoring AutoSYS jobs.

Creating Unix shell scripting and scheduling Cron Jobs.

Maintaining accurate Coding Versions using GitHub version control tool.

Used AWS S3 cloud storage to access images and data files.

Populating the data warehouse tables using SQL*Loader

Create Data pipe line for data warehouse.

Responsible for Production Deployment and Post Production support activities for all Database related Changes.

Creating and maintain database replication processes Using Golden Gate.

Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.

Guiding Front End Developers while integrating application code with database objects.

Environment: JAVA,Oracle 11g,SQL,PL/SQL, GitHub, Linux,SQL Developer,Oracle Golden Gate,Radar,Central Station,Espresso.

AT & T, Alpharetta,GA March’14-Apr’18

Role : Oracle Developer and Lead 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.

Responsibilities:

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 and SQL* plus.

Creating and modifying several UNIX shell Scripts according to the changing needs of the project and client requirements.

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.

Creating and Maintaining Dev and QA Databases.

Creating and Maintaining AD groups.

Working on Single and Multi Node RAC Db with Active Data Guard.

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.

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.

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

Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).

Manage all aspects of the OGG design, implement and support in development, UAT and production environments.

Golden Gate implementation in test/production ( for reporting purpose ).

Maintenance of 100+ production / 50+ pre-production OLTP Databases.

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.

Responsibilities:

Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.

Creating and maintaining all databases required for development, testing And production usage.

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.

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.

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.

Working on Java application to expose the core data as JSON through REST API end points to other Business units.

Designed, implemented and tuned interfaces and batch jobs using PL/SQL.

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

Description:

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.

Responsibilities:

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.

Created Inbound OutBound APIs as per Business Requirement.

Creating and Monitoring scheduled jobs in TWS.

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

Cisco Systems,India. 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.

Responsibilities:

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 Custom API s for as part of new enhancements.

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,India. 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.

Responsibilities:

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.

Created New Application Interfaces and Customized Standard APIs as per the Business needs.

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 Developing multiple RICEW components.

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,India 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.

Responsibilities:

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,WebQL,Unix and Java.

Education :

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

B.Sc. –Bachelors in Computer Science –Sri Venkateswara University-2002.

Certifications :

(1Z0-007) Introduction to Oracle9i:SQL

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

Awards:

Bravo Award - Techmahindra Americas Inc., September-2017 .

For consistent performernamce in OPUS ADBA team and over the period has shown excellent skill set towards the work that is appreciated.

Bravo Award - Techmahindra Americas Inc ., April-2016.

For strong pl/sql knowledge and shows lot of flexibility and positive attitude in supporting the application and problem solving capabilities.

Contact this candidate