Oracle Developer

Eswar

1-862-***-**** *****.******@*****.***

Professional Summary:

Experienced Oracle Database developer and well versed in various technologies to help the clients achieve their goals as per the complex business demands. An avid follower of different technologies like Oracle PL/SQL, Oracle Forms, Oracle Reports, UNIX, XML, Informatica Powercenter (ETL) and Data Science. Ability to interact and effectively communicate with people from diverse backgrounds, good team player and problem solving mindset.

Core Competencies:

10 Years of IT experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and in providing business intelligence solutions in data warehousing using Informatica Powercenter (9.x versions) as ETL tool.

Expertise in Software Development Life Cycle from Requirement Gathering, Analysis, Design, Conversion of business requirements into high level Functional Specification, Coding, Testing, Deployment to Production Support.

Strong work experience in Oracle Database (11g) Stored Procedures, Packages, Functions, Tables, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Dynamic SQL, Table functions, Collections, analytical functions.

Oracle Retrieve data from XML Document using XMLTable

Undergone internal training on Oracle Fusion Forms in Honeywell.

Expertise in Dynamic SQL, Collections and Exception handling.

Hands on experience in SQL Query fine tuning and utilizing SQL Loader utility.

Working experience in ETL phases in data migration using Informatica Powercenter ETL tool (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow Monitor, and Worklet Designer).

Designed and developed mappings from varied transformation logic like source qualifier, unconnected and connected lookups, router, filter, expression, aggregator, joiner, update strategy and more.

Hands on Experience in Shell scripting.

Exposure in using tools like TOAD, SQL Developer for writing PL/SQL programs.

Hands on Data Modelling using Toad.

Experience in estimating the requirements, delegating the work to the team and also maintaining a good rapport with the clients as well as my managers.

Proficient in Machine Learning Algorithms with Supervised and Unsupervised learning in data science.

Proficient in understanding the domain and analysing the insights of data; and building the best fit model based on data and providing the appropriate insights to business problem.

Efficient team member with excellent work/time management skills, excellent leadership, communication and interpersonal skills and ability to work under strict deadlines.

Experience in working with Waterfall and Agile methodologies.

Area of Expertise:

Data Bases

Oracle 10g/11g, SQL *Plus, SQL * Loader, TOAD, SQL Developer

Operating systems

UNIX, Linux, Windows 98/2000/XP

Languages

PLSQL, SQL, SQL*Plus, C, C++, XML, Core Java, R.

Front End Tool

Oracle Developer 6i/11g (Oracle Forms Oracle Reports 11g)

ETL Tool

Informatica Power Center (9.x)

Machine Learning

Supervised & Unsupervised techniques, Time Series Analysis, Decision Trees

Data Visualization

R, Tableau

Education & Training:

EDUCATION

Masters in Computer Applications from Sri Krishna Devaraya University – Passed out in 2003.

Bachelors in Computer Science, Bachelors in Mathematics from Sri Krishna Devaraya University - Passed out in 2000.

TRAINING & CERTIFICATIONS

Six sigma Green belt.

Oracle Certified Associate.

Professional Experience:

Honeywell International, Arizona May 2015 to Till Date

Technical Lead

Project Name: Core Processing Tools (CorePT)

Environment: Oracle SQL, Oracle PLSQL, UNIX and Informatica.

Description:

CorePT is the Tool which produces navigational data based to general aviation aircraft’s throughout the world. Almost 60% of the general aviation aircraft’s are getting data using this tool. Honeywell NavDB production group turns ARINC 424 formatted source data into FMS Formatted NavDBs. NavDBs produced every 28 days (1 cycle).

Responsibilities:

Designed and developed database packages, procedures, functions and triggers on Oracle databases.

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

Performed Data Modelling for schema design for the new tables using TOAD.

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

Used Pragma Autonomous Transaction to commit the child transactions without affecting the parent transaction commit status.

Creating Stored Procedures to delete existing data from the tables before loading in Staging area.

Part of the PL/SQL team to perform the ETL tasks.

Designed and developed mappings using transformations such as Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Union, SQL, Filter and Router to incorporate business requirements.

Parsing XML file in Oracle

Oracle Retrieve data from XML Document using XMLTable

Extracted around 200 tables from CorePT and loaded into BMS using ETL tool.

Drive reviews with Product Managers and execute test plan with the product manager to verify that acceptance criteria is met and/or verify that existing functionality of modified module works.

Automated the compilation of all forms and reports on production server at a time.

Script to take the QA back up by-weekly on to the local repository.

Completing the unit, system, user acceptance testing, and implementing the changes in production.

Documented the process and the problem resolution RPS (Rapid Problem Solving) using fish bone process.

Involved in conducting knowledge transfer sessions with other counterparts who will also be supporting the applications.

Worked on support requests/tickets regarding the applications. This involved investigation and enhancements/modifications to the code.

Served as a coach and mentor to help more junior team members develop their technical skills.

Received a special appreciation certificate from the client for the excellent work done by me at the client location.

Honeywell International, Arizona May 2013 to Apr 2015

Technical Lead

Project Name: B787-9

Environment: Oracle SQL, Oracle PLSQL, Unix, Oracle Forms and Oracle Reports.

Description:

A database of Aeronautical Data like the Airport Reference Points, Runways, Navaids, Waypoints, Procedures (SID, STAR, Approach). Custom Data like the Company Routes, Custom Procedures etc. NAVDBs are designed to be used by the Flight Management Computer through the interface of the FMCs, the Navigation Database access software. FMS functional areas the navigation data for automatic Navigation and guidance, Flight Planning and performance management.

Responsibilities:

Written documents like SRD (Software Requirement Document),

CRD (Compiler Requirement Document) as per the business requirements.

Used conversions and validated the data as per the ARINC424 standards.

Implemented inbound interfaces to load the flat file data into the application.

Utilized fully oracle features like Nested Table, PL/SQL tables and analytical queries.

Tested Oracle forms and reports.

Exception handling and cursor management in PL/SQL.

Written Cursors and parameterized cursors.

Created objects like Triggers, views and synonyms etc.

Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Created the indexes to optimize the performance.

Honeywell Technology Solutions, India May 2012 to Apr 2013

Senior Oracle Developer

Project Name: Migration of the ARINC-17 to ARINC-20

Environment: Oracle SQL, Oracle PLSQL, Unix, Oracle Forms and Oracle Reports.

Description:

Honeywell NavDB production group turns ARINC 424 formatted source data into FMS Formatted NavDBs. Most NavDBs are designed using the ‘2- cycle format’. NavDBs produced every 28 days (1 cycle). Under project suppliers provides data in ARINC-20 format with lot of changes to the existing ARINC-17 format.

Responsibilities:

Implementation of PL/SQL Procedures, Functions and Packages which accomplish the ARINC-20 format changes.

Created tables, Indexes, Views.

Enforced database integrity using Primary keys and foreign keys.

Created PL/SQL functions to facilitate business functions and calculations.

Developed SQL queries for the manipulation of data.

Utilized fully Oracle features like Nested tables, PL/SQL table.

Customized the Oracle Forms where ever applicable.

Customized the Oracle Reports for the changes.

Involved in System testing and UAT.

Documented all the changes with respect to ARINC-17

Built and tested the release application components

Script to compile the respective individual forms as per developer need.

Doing and supervising enhancements. Completing the unit, system, user acceptance testing, and implementing the changes in production.

Involved in Peer Reviews and Functional Reviews.

Honeywell Technology Solutions, India Jan 2010 to Apr 2012

Senior Oracle Developer

Project Name: Forms Migration from 6i to 11g

Environment: Oracle Forms, Oracle Reports, Oracle SQL, Oracle PLSQL and Unix.

Description:

The CorePT tool is using the Developer 6i Forms and Reports. And as part of this project all the Developer 6i Forms and Developer 6i Reports are migrated to 11g.

Responsibilities:

Documented the challenges faced.

Involved in assisting the team members in understanding the business flow.

Enables the team members in bug fixing.

Provided production support all the way.

Implementation/Go-Live support & Knowledge Transfer.

Worked on Complex forms migration.

Worked on Performance and tuning of SQL and PL/SQL.

Documenting the resolution steps to the issues.

Responsible for Unit Testing, User Acceptance Testing.

Reviewing the code developed by Team members.

Involved in daily Scrum meetings.

Testing and debugging the functional flow and made the necessary modifications to meet the end user requirements.

Honeywell Technology Solutions, India Oct 2008 to Dec 2009

Oracle Developer

Project Name: Core Processing Tools (CorePT)

Environment: Oracle SQL, Oracle PLSQL, Oracle Forms and Oracle Reports.

Description:

CorePT is the Tool which produces navigational data based to the general aviation aircraft’s throughout the world.

Honeywell NavDB production group turns ARINC 424 formatted source data into FMS Formatted NavDBs. Most NavDBs are designed using the ‘2- cycle format’. NavDBs produced every 28 days (1 cycle).

Responsibilities:

Enhancements were developed using Oracle forms, Oracle reports, Oracle PL/SQL.

Created Technical Design documents for enhancements and attended Technical Design Reviews.

Designed and developed database packages, procedures, functions and triggers on Oracle databases.

Completing the unit, system, user acceptance testing, and implementing the changes in production.

Sunera Technology Pvt Ltd., Oct 2007 to Sep 2008

Oracle Technical Consultant

Project Name: Handleman – Music Stores

Environment: Oracle E-Business Suite 11i, Oracle, Oracle Forms and Oracle Reports.

Description:

Handleman is a leading distributor and store merchandiser of music, books, and computer. Handleman Company is “the Channel of Choice” for distributing pre-recorded music to leading retailers in the United States, United Kingdom and Canada.

The project’s goal was to consolidate their Data Warehouse across United States into one centralized Data Warehouse and accessing it by enterprise and also creating data marts to store product information and customer’s details.

Responsibilities:

Requirement Gathering Analysis for new business requirements & major developments. Impact analysis of proposed changes. Participated on System level requirement and activity.

Participated in Unit and System testing, benchmarking and system optimization.

Team & Module Management: Mentoring, Training, Business Induction of new members & preparation of Induction Manual.

Analysis of existing system with objective of improving & optimizing the system performance.

Implemented the KFFs with the support of my supervisor.

Production Support and user acceptance testing support.

Documentation of various activities in the project.

Professional Experience Achievements:

Individual Excellence Award – For consistent performance and pivotal role in design and configuration of BMS tool and he has a very professional approach and is very dependable in his actions.

Individual Excellence Award – For exemplary dedicated and consistent efforts towards Forms migration from 6i to 11g.

Customer/Partner Award – For part of ETL team in extraction and loading the CorePT data to BMS.

Contact this candidate