Senior Oracle Developer Resume Samples

Description :

1. Worked with end users in collecting Business Requirements.
2. Created database objects like Views to handle secured data and giving grant to views for other schema in order to hide the information.
3. Developed Reports for storing of monthly sales and salaries information.
4. Used FORALL and BULK COLLECT to load large amount of data to database and retrieve data from database in large amounts without effecting the performance.
5. Used PLSQL tables and records for payroll generation process.
6. Prepared Daily Reports by collecting information from those departments.
7. Automated execution processes using UNIX Shell Scripts.
8. Used the FTP Commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.
9. Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.

Experience

0-2 Years

Level

Entry Level

Education

Bachelors

Description :

1. Worked on process to send the delta of claims, policy feed to the external systems for invoice processing using PLSQL programming and shell scripting.
2. Developed monthly, quarterly processes to feed the claims and payment information to the external reporting agencies using PLSQL and shell scripting.
3. Worked on a daily process to load data from multiple sources into staging tables using SQL loader.
4. Experienced in physical and logical data modeling.
5. Processed to validate, edit and transform the data using PLSQL package and store data in transactional tables for daily payment processing.
6. Recorded errors and send an email alert to users to reprocess the invoice.
7. Developed ETL processes to move data from the transactional tables after payment processing to data warehousing face and dimension tables.

Experience

2-5 Years

Level

Junior

Education

Masters

Description :

1. Allowed customers to shop in a virtual shopping mall, checkout items from different shops, manage accounts for each shop separately etc.
2. Provided in-depth analysis for evaluating business relationships, making decisions about important transactions, researching competitors and suppliers and planning for sales calls.
3. Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator.
4. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
5. Created management analysis reporting using Parallel Queries, Javastoredprocedure, HTPPackage and WEB.SHOW_DOCUMENT.
6. Participated in change and code reviews to understand the testing needs of the change components.
7. Worked on troubleshooting defects in timely manner.
8. Involved in creating UNIX shell Scripting.

Experience

2-5 Years

Level

Junior

Education

Bachelors

Description :

1. Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
2. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
3. Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center.
4. Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
5. Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
6. Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
7. Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
8. Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
9. Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.

Experience

2-5 Years

Level

Junior

Education

Bachelors

Description :

1. Served as a lead PL/SQL Developer.
2. Maintained data integration, data distribution and correct issues as they arise.
3. Conducted knowledge transfer sessions of SQL skills for existing staff.
4. Provided technical work estimates and task breakdown.
5. Participated in peer code reviews and provide support to QA/PROD during the test/migration process.
6. Worked with Cerner Clients to develop custom solutions to enhance clinical workflows, including financial and medical reports.
7. Coordinated projects with other team members to meet critical deadlines.
8. Successfully worked in custom proprietary languages and systems with little documentation or guidance.

Experience

5-7 Years

Level

Executive

Education

Bachelor's

Description :

1. Codes, tests, debugs, implements, and documents moderately complex programs. Creates appropriate documentation in work assignments such as program code, and technical documentation.
2. Designs systems and programs to meet complex business needs. Prepares detailed specifications from which programs are developed and coded. Ensures programs meet standards and technical specifications; performs technical analysis and component delivery.
3. Gathers information from existing systems, analyzes program and time requirements. Assists project manager in preparing time estimates and justification for assigned tasks.
4. Designs programs for projects or enhancements to existing programs.
5. Writes specifications for programs of low to moderate complexity.
6. Assists support and/or project personnel in resolving moderately complex program problems. Works with client and management to resolve issues and validate programming requirements within their areas of responsibility. Provides technical advice on complex programming.
7. Develops test plans to verify logic of new or modified programs.

Experience

7-10 Years

Level

Management

Education

Bachelors

Description :

1. Assisted with the setup and configuration of the ColdFusion environment on a Solaris UNIX platform
2. Worked with conversion specialists to develop a template for converting obsolete mainframe modules into modern ColdFusion modules accessing Oracle database
3. Completed the development and testing of several ColdFusion modules as proof of concept
4. Instructed other ColdFusion developers in this development process
5. Led a small ColdFusion team through development and testing, working closely with client staff as needed to ensure test results are correct.
6. Modified er database modeling, analysis and definition of requirements.
7. Developed and implemented application module for bank popular on new tax collection charge.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Responsible for Data Warehouse ETL processes.
2. Created and maintained the Data Warehouse specifications for data movement between source systems and the data warehouse.
3. Identified master data, data masking and data integration from multiple sources.
4. Worked closely with client and business users to identify and specify complex business requirements.
5. Created integration interfaces.
6. Provided technical expertise to junior team members and consult with senior application developers to resolve performance issues and test new and existing code.
7. Created packages, procedures, functions, and triggers as well as tables, dimensions materialized views and indexes.
8. Supported application and database development throughout the software lifecycle.

Experience

5-7 Years

Level

Executive

Education

B.A

Description :

1. Materialized views, parallelism, batch processing to improve performance due the high volume of data.
2. Developed and automation of dairy process using pl/sql, proc, packages, functions,.
3. Created database packages for applying business rules and migrate data to transactional schema.
4. Developed control mechanism for flexible processing of business feeds that allows back dated processing.
5. Developed pl/sql and shell scripts and scheduled in autosys to automatically start & stop ais services in actimize.
6. Developed loading strategy to consume feed files from source using sqlldr.
7. Created apis using procedures/functions to send the data to the java application.

Experience

7-10 Years

Level

Consultant

Education

Bachelor's

Description :

1. Scheduled materialized views using autosys to refresh every 15 minutes to make sure all the datamart was in sync with app databases.
2. Supported the ui team by writing procedures and functions to pull the required data from the datamart.
3. Developed and maintained customer-specific distribution systems utilizing the entire system design life cycle (sdlc).
4. Created financial data set for sales force, enabling 10% sales growth over prior year.
5. Managed and developed projects in oracle, access, and spaceman with primary focus on merchandise distribution and rebates and promotions systems.
6. Designed and implemented talend and pl/sql (etl) process that retrieved financial earnings, financial forecast information, and officer information, reducing entry time by 10%.
7. Modified nightly process reducing run times by 20%, ensuring information availability before start of business day.

Experience

2-5 Years

Level

Junior

Education

Bachelor's