Sudha Rani

acyjnr@r.postjobfree.com Ph.: 857-***-****

Sr. Oracle Database Administrator / Developer

A dynamic Oracle Certified Professional Having More than 11 years of strong experience in requirement gathering, analysis, design, development, testing, implementation, support and maintenance of client/server applications using Oracle PL/SQL/ SQL Server. Currently working as a Sr. Oracle Database Administrator at Santander Bank, Greater Boston, MA. Core competence in Oracle Technologies including Informatica and Developer tools, Administration and Performance Tuning. Good in Oracle Back-End Programming and Relational Database Management System concepts. Developed complex business logic using Oracle PL/SQL (Functions, Procedures, Packages, Cursors and Triggers) and good in UNIX Shell Scripting. Possess very fair understanding of ETL Process. Strong interpersonal skills in interacting with End-Users, Excellent work ethics, self-motivated, quick learner, team player and team oriented.

SUMMARY

Over 11 years of experience in Application and Product development using Oracle PL/SQL as Oracle Database Developer.

More than 5 years’ extensive experience as Database Administrator. Working extensively on maintaining highly transactional, highly available, large Oracle Database.

More than 5 years of experience in leading the team which includes assigning the task, assist the team technically and functionally.

Expertise in RDBMS Concepts, Oracle SQL, PL/SQL, Store procedures, Functions, Packages, Triggers, Cursors.

Expertise in Data modeling by identifying tables needed for the project based on the requirement and creating related tables with required relationship.

Expertise in Oracle Materialized Views, Bulk operations, Collections, Dynamic SQL, Object Types, Records and Exception Handling.

Expertise in table partitioning, sub-partitioning, creating local index for the partition and managing the partition like drop, truncate, move.

Expertise in Explain plan, Performance tuning, Query Optimization, TKPROF and passing hints and analyzing the table to collect table statistics for improving performance.

Expertise in Oracle table indexing by analyzing various fields will be used to query the table and creating unique, non-unique, bitmap, b-tree, function based indexes as required.

Extensively worked on Oracle Advanced features ACS, Histograms, Baseline Plan and pinning SQL.

Expertise in creating and maintaining large Tables, Views, Synonyms, Sequences, Global Temporary Tables, Oracle Jobs, Scheduler, DB Links, EXPDB, IMPDB, External Tables, Java Objects and XML.

Schedule and manage Oracle RMAN incremental and full backups and recovery, proactively maintain and manage OS, DB and Tablespace storage, Create, alter, and drop users and roles, Monitor and audit database access.

Develop, implement, and manage a security strategy (or security policy), including use of users, roles, privileges, and authentication.

Implement the physical database from the logical design, create and maintain database.

Allocate and manage physical storage structures (data files, redo logs, control files), Allocate and manage logical storage structures (tablespaces, schemas, extents). Perform capacity planning, tuning and troubleshooting.

Performing Exports and Imports of database objects as required, Backup and recovery of mission critical databases.

Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports, v$ Dynamic performance view and providing recommendations.

Assist in the configuration and manage oracle databases in data guard environment

Good experience in using SQL Loader for loading millions of records. Experience in working Database of size more than 5 terabytes

Migration of database from one server to another server.

Good experience working with various FTP protocols like FTP, SFTP, LFTP and SCP

Good experience managing files in UNIX Shell Script and batch processing

Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.

Extensively worked on data replication tool to load large volumes of data from source to target data warehouse.

Hands on experience in developing ETL mappings using tools like Informatica Power Centre consisting of data sourcing, transformation and loading into OLAP systems.

Developed various mapping using ETL Informatica Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sorter and Sequence Generator transformations.

Extensively used Agile Methodologies, it helps teams respond to unpredictability through incremental, iterative work

Experience in Production on call 24/7 Support and working as BAU

Over 5 years of experience in Banking and Financials domain, around 4 years’ experience in Telecom and more than 1 Year experience in Healthcare Domain

Experience in Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools like TOAD, SQL Develop, PL/SQL Developer, SQL Tools

Thorough experience on software development methodology, worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation.

TECHNICAL SKILLS

Technical Skills

Details

Operating Platforms

Window NT/2000, Windows XP, Unix, Linux

DBMS/RDBMS

Oracle 9i, 10g, 11g, 12c, DB2, SQL SERVER, MySQL, TSQL, Teradata

Programming Languages

SQL, PL/SQL, Advance PL/SQL, JAVA, J2EE, JAVA Script, HTML, HTML5, CSS (2.1/3), XHTML, JQUERY, ANGULAR, BOOTSTRAP, JSON, XML, XML, C, C++, Putty, WinSCP

ETL Tool

Informatica, ODI

Scripting

Shell Scripting, Perl Scripting

Configuration Management Tool

SVN, CVS, JIRA, GIT

Case Tools

TOAD, PL/SQL DEVELOPER, SQL DEVELOPER, SQL*Loader, SharePoint, ERWIN

SDLC

Agile Methodology, Waterfall Model

CERTIFICATIONS

Oracle PL/SQL Developer Certified Professional

Oracle SQL Developer Certified Associate.

EMPLOYMENT HISTORY

Graviton Solutions Inc. (Client - Santander Bank, Greater Boston MA) : Aug,2016 to till date

Graviton Solutions Inc. (Client – Superflex Medical Systems) : Jan,2016 to Jul,2016

Sonata Software, Bangalore, India (Client - TUI Travel USA, UK) : Sep,2011 to Jan, 2016

Wipro Technologies, Bangalore, India (Client - Cisco Systems, USA) : Apr,2010 to Aug, 2011

Wipro Technologies, Bangalore, India (Client - Yell Ad-works, USA) : Oct,2007 to Apr,2010

Finch Software India Pvt Ltd, Bangalore, India (Client – IGEFI) : Jul,2006 to Sep,2007

CD9 Info Networks Pvt Ltd, Bangalore, India : Feb,2005 to Jun,2006

WORK EXPERIENCE

Graviton Solutions Inc. August 2016 – Present

Client: Santander Bank, Boston, MA (Moodys Analytics)

Role: Senior Oracle Database Administrator

PROJECT DESCRIPTION:

CCAR Regulatory Reporting Project - Moody’s Analytics, a unit of Moody’s Corporation, helps capital markets and credit risk management professionals worldwide respond to an evolving marketplace with confidence. Moody’s has unique tools and best practices for measuring and managing risk through expertise and experience in credit analysis, economic research and financial risk management. CCAR Financials part of the Strategic Capital Planning, SHUSA is building a Moody’s CCAR Risk Foundation (RFO) DataMart and the Model Execution (ME) and SAS Forecasting Engine (FE) systems to automate the CCAR 14A data sourcing process and the consumption of the GL reconciled contract level data by the downstream(ME) process. Main goal is to develop seamless interface connectivity between Moody’s RFO and Model Execution (PPNR and LOSS) system (MATLAB, Python, SAS)

ENVIRONMENT:

Oracle 12c, Forms 10g & Reports10g, ASP, SQL PLUS, PL/ SQL, Pro*C, SQL*Loader, UNIX Shell Scripts, Data Stage, Business Objects, SQL Navigator, TOAD, JAVA, J2EE, JAVA Script, HTML, HTML5, CSS (2.1/3), XHTML, JAVASCRIPT, JQUERY, ANGULAR, BOOTSTRAP, JSON, XML

RESPONSIBILITIES:

Working in the financial domain, as database administrator to create, validate and deliver monthly, quarterly and annual CCAR (FR Y-14) reporting requirements with Moody’s Analytics Regulatory Reporting Module.

Interacting with business users in understanding business application, business data flow, data relations and the various logistics processes.

Arranged meeting with business/Business analyst to understand application requirement and provided provided suitable technical solution for development.

Strictly followed Agile method for software development and attend scrum call and sprint planning meeting.

Tuned SQL queries / PLSQL code using various tuning techniques to make it perform as per the application requirement.

Analyzed Explain plan / access path of SQL query to understand the query execution to make it performance effective.

Used Oracle 12c features to limit query up to specified limit and faster execution.

Extensively used BULK COLLECT /FORALL and collection for faster PLSQL processing.

Worked on Database Links and Bulk Collections to perform bulk data loads into database tables from upstream application.

Analyzed database table partitioning strategy to create better access path for the SQL query depending on column used to fetch application data.

Performed DBA activities like, creating table, indexes, sequences, views, triggers, materialized views, grants, impdp/expdp utilities in Oracle Database12c/Exadata.

Worked on table partitioning (Range and List) and deploying local indexing on partioned tables.

Wrote PL SQL query for investment management section to retrieve data from the database create report for the executives.

Developing Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, SQL scripts to facilitate the functionality for various modules.

Experience in loading data from Flat files and XML files into database, performing business validations on the data using PL/SQL Procedures, SQL*Loader.

Created Materialized Views, Tables, Complex SQL queries, and Correlated Sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.

Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.

Tuned database SQL statements and procedures by monitoring run times and system statistics and Optimized existing complex SQL queries using utilities like Hints, Explain Plan, SQL Trace and TKPROF, improve Query Cost and CPU Utilization.

Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.

Holding teleconference calls with offshore team at nights to explain the requirements and providing technical guidance.

Used packages, functions and procedure for investment management, capital market and fixed income system database to improve system performance.

Extensively worked on Performance tuning by using Explain plans and various hints.

Performance Tuning and Optimization to improve the performance of the system using view, Materialized view, local and global Partition, Index, Index rebuild.

Regular investigation on high Load, locks, blocks, deadlock using OEM, ASH, ADDM and AWR.

Troubleshooting database using Alert log and Trace file processing.

Migration script checking, preparing and running in production including downtime estimation.

Data Backup, Restore and Recovery using Oracle DataPump, Hot/Cold Backup and RMAN.

Database Replication Maintenance using Oracle GoldenGate and DataGuard.

Data warehouse implementation, R&D on developing ETL system.

Implement data storage, archiving, database/Schema comparison.

Data conversion, mapping and related coding (java). Data migration from excel to oracle database.

Implementing Database security. Hands on experience with Oracle Database 12c with Oracle Advanced Security, Database Vault, Audit Vault, Key Vault and Database Firewall.

Responsible to unload data from client secured database using sftp and other secured utilities; ETL

Load data using Oracle SQL*Loader and other utilities

Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, STATSPACK, and manual scripts

Experience and responsible for Backup / Disaster Recovery, Replication using Oracle Data Pump, RMAN and other utilities

Knowledge in deploying, maintaining Oracle in a Data Guard configuration

Knowledge in implementing RAC (using raw devices, ASM) for test environment using Oracle clusterware

Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 10g database.

Involved in designing and implementation of pre and post processing Pro*C programs for the ETL process.

Created Stored Procedures, functions and Packages in Oracle 12c using SQL and PL/SQL for the Audit Trail using Oracle 12c as backend.

Increased efficiency of code, by using bulk collection techniques to handle large amounts of data

Involved in the Data Modeling phase of the application.

Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

Used UTL_FILE (file handler), DBMS_JOB, DBMS_ALERT and other utility built-in Packages in PL/SQL.

Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.

Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.

Created UNIX shell scripts to automate the process and scheduling using Autosys, Cron Job Utility.

Provided on call support, solved the user issues and made necessary changes.

Resolving Production Severity Issues in time and meeting the SLA.

Involved in front-end development including creation of Terms and agreement related functionalities using AngularJS, HTML5, Bootstrap

Developed HTML pages from functional specifications & wire frames also validated designs in different browsers

Applied AngularJS to achieve front-end MVC.

Applied Bootstrap to achieve Responsible Web Design.

Developed re-useable components using Angular Such as directives, factories & services.

Used Angular UI grids for list out term & agreement related data from database also used other useful functionality such as sorting, filtering, pagination & export etc.

Used AngularJS Interceptors for communicate to remote HTTP server.

Graviton Solutions Inc. Jan 2016 – July 2016

Client: Superflex Medical Systems, Irving, TX

Role: Senior Oracle PL/SQL Developer

PROJECT DESCRIPTION:

A patient management system is a computerized management system. This management system has been developed to form whole management system including Employees, Doctors (consultants), Nurses, Patients, Bills, and Complaints etc. This system also keeps the records of hardware assets besides software of this organization. The proposed system will keep a track of Employees, Doctors, Patients, Account and generation of report regarding the present status. This project has GUI based software that will help in storing, updating and retrieving the information through various user-friendly menu-driven modules.

ENVIRONMENT:

Oracle 12c/11g, PL/SQL, SQL, T-SQL, MS SQL Server, PostgreSQL, SQL Loader, IBM Data stage, UNIX, JAVA, J2EE, TOAD, SVN, JAVA, J2EE, JAVA Script, HTML, CSS, Angular JS

RESPONSIBILITIES:

Created business rules, functional and technical design, test cases and user guides and worked on Database design with the team

Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms

Created stored procedures, functions, packages, data base triggers and cursors based on requirement.

Created various indexes for faster access of data partitions for performance improvement of queries. Passing hints, analyzing the table to collect table statistics for improving performance.

Managed performance and tuning of SQL queries and fixed the slow running queries with utilities like Explain Plan, Auto Trace, TKPROF and Hints

Developed complex queries to generate reports for both ad-hoc analysis and scheduling reports.

Extensively used bulk collect to fetch large volumes of data from the table.

Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL, Cursor Variables, Object Types and Records.

Used Pragma Autonomous Transaction, Pragma Exception INIT and all Pragma Inline for performance improvement.

Extensively used Oracle Advanced features like ACS, Histograms, Baseline SQL, PIN the plan

Created Materialized Views using Partition and Sub Partitions template and refresh the large volumes of data within stipulated timelines with tremendous performance measures.

Designed and successfully implemented new everyday reporting application using external tables scheduled jobs and shell scripts

Analyze and choose the best fit technology and solutions to meet application development and testing requirements

Performed detailed code review of all the requirements of the peers to ensure normal implementation

Extensively used logical modeling and physical modeling to create database objects like table’s relations, and data process flows.

Utilized in-house wiki to document data model, business rules, projects, and other information.

Involved in developing logical and physical database, Normalization, Dimension Modeling and Enterprise Manager.

Worked on SQL Tuning, Query Optimization Techniques for complex SQL Statements.

Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.

Used Oracle features like Global Temporary tables, Analytical function and Table functions.

Experience with Oracle Fine Grain Access Control (FGAC) development, configuration, and troubleshooting, and implemented VPD contexts.

Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.

Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.

Extensively worked on data replication tool to load large volumes of data from source tables to target data warehouse.

Worked on Job scheduling to tool to create schedules and make modifications as per the requirement.

Extensively used Agile Methodologies, it helps teams respond to unpredictability through incremental, iterative work

Detected and corrected bugs during system integration and user acceptance testing.

Created UNIX shell scripts from FTP batch jobs, creating SQL reports and email notifications.

Developed various mappings using Informatica Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sorter and Sequence Generator transformations

DBA activities such as Regular Backup's, Replication, Tuning, and troubleshooting performance issues.

Interacted with front end JAVA team and provided required database objects and SQL queries.

Sonata Software Ltd Sep 2011 – Jan 2016

Client: TUI Travel, Florida

Role: Senior Oracle DBA

PROJECT DESCRIPTION:

Touristic Union International (TUI) is an integrated travel group, which offer the complete range of services associated with holiday and travel. Their three business sectors TUI Travel, TUI Hotels & Resorts and Cruises form the World of TUI. In order for organization to better understand the transactions relating to travel and accommodation, this project provides to create set of reports to improve the availability of information within the organization for decision making to enhance the business. TRACS is the backend Inventory System accessible with the customized commands to Update, Add and Bar Inventory Availability, Prices.

ENVIRONMENT:

Oracle 11g, PL/SQL, UNIX Shell Scripts, SQL Plus, TOAD, PL/SQL Developer, PUTTY, WinSCP, Visio, JAVA, J2EE, Informatica, SVN, SQL Server, JAVA, J2EE, JAVA Script, HTML, CSS

RESPONSIBILITIES:

Lead team of around 10 members at onsite and offshore very effectively.

As a team lead responsible for preparing requirements document and design document.

Responsible for gathering requirements from user for reports development and interface program customizations and in analyzing business process.

Created and maintained Oracle Database Objects like tables, views, materialized view, indexes, constraints, sequence, synonyms and database link using SQL

Worked with Data Architects and ETL Developers in data warehouse design, data management, data quality, and ETL architecture.

Worked to create and maintain data warehouse management principles, understand relevant technologies, and utilize the best methods for constructing and supporting a large data factory.

Developed technical infrastructure designs, data mappings, flows and report dissemination mechanisms.

Created numerous complex queries involving joins, correlated sub-queries diverse business requirements.

Plan, design, and implement application database code objects, such as stored procedures and views, indexes.

Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.

Created Global temporary tables, packages and procedures using SQL developer.

Created partitioned tables, partitioned indexes for manageability and scalability of the application.

Involved in ETL architecture enhancements to increase the performance using query optimizer.

Analyzing performance of database objects and suggesting DBA for indexes, schema gathering, partitioning, explain plan.

Involved in coordination between development teams, business analysts, QA, internal stakeholders, vendors and the Production support organization.

Worked on SQL Tuning, Query Optimization Techniques for complex SQL Statements.

Used revers-engineering on JAVA codes from legacy system and re-wrote them in PL/SQL, TSQL for the purpose of data comparisons.

Performed SQL and PL/SQL tuning and Application tuning using various tools like SQLTRACE, TKPROF and DBMS_PROFILER.

Atomized routine jobs using DBMS_Scheduler. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL and trigger other processes.

Extensively used for all and bulk collect to fetch large volumes of data from table

Created External table functionality from scratch creating DB folders, table structure and ETL scripts.

Improved Performance by tuning using Hints, Indexes, Explain Plan, and TKPROF.

Wrote SQL Loader control file for flat file data load and scheduled then in UNIX to load every night in Production Environment.

Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder and Oracle Forms builder respectively.

Wrote UNIX Shell scripts invoke all the stored procedures, parse the data and load into flat files.

Extensively used Informatica Client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repositary Manager and Informatica Workflow Manager with multiple data sources.

Generated reports and worked extensively in developing, deploying, and testing of Oracle Forms and Oracle Reports using Oracle.

Worked with various Informatica power center transformations like connected & unconnected lookups, Router, Expressions, aggregators, filters, sequence Generator, Joiner etc. and developed complex business logic.

Developed many workflow sessions, monitored the workflow runs and debugged if any errors.

Involved in Implementing effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.

Worked with ClearSQL audit tool for providing software quality metric report for internal/external auditing.

Maintaining different source code versions using Tortoise SVN.

Testing and debugging of the applications. Implementation and end user training.

Analysis and fixing of the defects/bugs in production with high priority.

Interaction and coordination with various application teams for resolving issues, patch movements.

Wipro Technologies Apr 2010 – Aug 2011

Client: Cisco Systems, Irving, TX

Role: Senior Oracle DBA

PROJECT DESCRIPTION:

Customer Test Interface (CTI) is a development tool to generate customer and test interface coverage REPORTS. Each client is having the multiple products (example, router, switch, modem, telephone adapter etc testing team will run the automated Scripts on each product, to improve software quality and test effectiveness by focusing testing on how customers use various products and features. Test result is uploaded in TIM’s application, based on the result set development team will compare the test results, how many pass, fail based on that will generate the coverage REPORTS. The result is summarized with the help of REPORTS (ATE-Coverage/Customer/Summary, ATE-Coverage/Test-Activity/Summary and ATE-Coverage/Customer/Detail, ATE-Coverage/Test-Activity/Detail REPORTS), to the Customers on Total Coverage of various products and features across customer and test teams.

ENVIRONMENT:

Oracle 11g, PL/SQL, MS SQL Server, Oracle Forms and Reports, UNIX Shell Scripts, SQL Plus, TOAD, PL/SQL Developer, PUTTY, WinSCP, Visio, JAVA, J2EE, Informatica, SVN, SQL Server.

RESPONSIBILITIES:

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Analyzed database design requests and Created databases according to client needs

Write SQL scripts to create or modify database objects like (tables, views, synonyms, sequences etc.) to implement the business rules.

Developed Stored Procedures, Functions, Triggers and Packages using PL/SQL.

Performance monitoring and Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.

Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.

Used Global Temporary tables, Collections, Analytical Functions, Materialized Views and Query Re-write.

Tuned SQL queries and performed code debugging using TOAD.

Worked extensively on performance Tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of HINTS, and Statistics.

Improved Performance of Discoverer Reports using Materialized views.

Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Union, Union all, Intersect and Minus

Involved in database cloning for development, testing from production. Analyzed and computed statistics to improve response time for queries.

Partitioned large Tables for better performance and manageability

Ensure data quality and integrity in databases. Implemented security logging for all the important Tables.

Written backend Procedures for Dashboard metrics.

Database creation on different servers and data moved using expdp/impdp utility.

Monitor and report status of databases (capacity planning, size/limit, performance, etc.)

backup and restoration of schema. Monitoring alert log on daily basis and fixing if an error occurred in daily basis.

Schema refresh, data replication & migration

Killed inactive sessions to reduce unnecessary load on the server.

Creation of table spaces, User creation and providing necessary Roles, Privileges and quota as per the requirement.

Ensure space management on servers and user management at the database level.

Performing database Health check-ups. Decommissioning of Schema's as per approved requests.

Distribution of Table spaces among different Disks and creation of Database objects.

Performing backups using RMAN, Oracle import/export as a method of recovering data/individual objects.

Taking backups using RMAN, export/import and data pump.

Generating ADDM and AWR report for DB performance issue.

Troubleshooting DB remote connectivity issue.

Responsible for Monthly report generation, validation and delivery.

Identify any issues related to database performance and provide corrective measures.

Troubleshoot database related issues in a timely fashion

Wipro Technologies Oct 2007 – Apr 2010

Client: Yell Ad-Works

Role: Senior Oracle PL/SQL Developer

PROJECT DESCRIPTION:

Yell Ad Works is the US Company client of Wipro Technologies; this project is the Clipper Yellow Pages. Main Modules Are Front Office, Studio and Bibo (Book in and Book Out), Diad (Spec Visual or Add Visual) and Final Inspect. For each transaction represents flag as I – new, C – change required, F – Bundle change etc., there are many validation checks exists for place diad into Final Inspect, once diad send to particular studio, in studio so many modules were existing, artist validation, reader validation then finally final inspect validation etc., in this any stage add will be reject, if reject happens in any stage, then add need further work require (FWR) then diad goes to Front Office again. This is migration project, get the data from different sources and store the historical data in DWH (Data ware House) through ETL (Extraction, Transformation and Loading) using JAVA, Oracle (SQL and PL/SQL) with UNIX Environment

ENVIRONMENT:

Oracle 10g / 9i, PL/SQL, All-Round Automations PL/SQL Developer, TOAD, Control-Excel 2010, Git, Agile methodology, HP Quality Center, Crucible, Sonar.

RESPONSIBILITIES:

Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.

Designed/developed/Modified tables, views

Contact this candidate