Oracle Developer Resume

SUMMARY:

Improves performance of high - volume databases by tuning SQLs; designs, develops, and maintains ETL codes.Database Development & Testing Data Warehousing Performance Enhancement Technical Documentation
Streamlines data warehouse procedures through automated solutions: Saved 2 hours’ daily escalation time by automating a job scheduling application’s status notification for business users using UNIX shell scripts.
Speeds up applications performance by identifying and fixing errors: Reduced data extraction time from 40 to 3 hours at FI by rewriting client application code to avoid unnecessary processes; streamlined systems data analysis.
Improves standard testing process by developing Oracle-related packages: Developed customized application “pass-fail” reports for management at FINRA; enabled report generation at a click of a button and uploaded results for the team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.1/7.1

Databases: Oracle 11g/10g/9i/8i, Sybase, PostgreSQL

Languages: SQL, PL/SQL, UNIX, Shell scripts, Python 2.6, Perl, HTML5, Java Scripting, PHP, CSS3

Scheduling Tools: Autosys, Control-M, JAMS

Other tools: JIRA, Eclipse, GIT, SVN, Junit, Splunk, Cucumber

Key Skills: OLAP, Tuning/Query Optimization, Mapping Designing, Repository Management, Workflow Management, Repository Server Management, Data Processing, Process Automation, Regression & Performance Testing, API Testing, Project Management, CRM

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

Automated and tested Postgres code changes by developing test frameworks using Cucumber; generated color-coded HTML reports. Collaborated with a senior architect to automate the time-consuming uploading of HTML reports onto Jira.
Replicated data from the external source using materialized views; validated codes to ensure data conversion from Oracle to Postgres. Enabled large data transfer from one database to another by using complete and fast refresh methods.
Created and monitored alerts and reports from AWS logs using Splunk; customized queries to visualize machine data. Tests the performance of web applications using JMeter.

Confidential

Oracle Developer

Avoided lengthy and troublesome data restoration process by developing a web application for users to upload files and get notified 2 weeks prior to data removal; added modifications based on client feedback. Won an award of appreciation.
Eliminated 10 man-hours/week spent on uploading client data by developing a front-end page for clients to upload data easily. Established front-end validations and customized technical errors.
Utilized ETL/Informatica to process data from various vendors and used UNIX scripts for file transfer protocol.
Accelerated lengthy data extraction process by creating partitioning tables and local/global index on partitioned tables.
All the Online applications for business users were managed with the help of Exchange Partition.
Utilized Toad to develop PL/SQL objects including tables, indices, packages, triggers, sequences, and stored procedures.
Collaborated with architects to upgrade information systems to retain existing data and accommodate new one.

Confidential

SQL Developer

Led a team of 4 and tracked performance through traceability matrix; updated manager.
Automated job scheduling processes using Autosys and reports generation using PERL.
Enhanced systems performance using various tools including Explain Plans, Hints, DBCC Traceon, and Force Index.

Confidential

Oracle & ETL Developer

Developed Informatica mappings to load data files sourced from various clients on the Oracle databases.
Accommodated Basel’s new risk mitigation plans for UK banks by writing new codes, creating new mappings, tables, triggers and packages in compliance with new rules. Broke down complex technical documents into easier terms for clients.
Supported technical teams with overnight batch processes and addressing escalated queries.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship