We provide IT Staff Augmentation Services!

Senior Oracle Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Senior Oracle Developer with 15+ years of specialization in Oracle based Client - Server Computing, Database Administration, Implementation, Maintenance and Quality Assurance. Worked in the Banking and Financial Domain 5+ years
  • Web applications and dashboard development for 5+ years using LAMP server (Linux,Apache,Mysql,PHP/PERL)
  • Experienced in data warehousing projects in the financial industry. (UBS and Bull Run Financial)
  • Experienced in data warehousing and data modeling projects using star schema and Erwin tool.
  • Over 10 years of experience in experience in Design, Development, Enhancement and Maintaining applications using Oracle 7.x/8.0/8i/9i/10g, /11g/12 C SQL, PL/SQL, Perl, PHP
  • Experienced in identifying business requirements, technical requirements, database design and troubleshooting.
  • Extensive experience in Oracle Technologies in back-end oracle database design, development, testing, performance tuning, production migration and production support.
  • Extensive experience in Oracle Development in table design, writing stored procedure, database triggers, functions and PL/SQL packages. Strong knowledge in Oracle Cursor management and Exception Handling.
  • Used data modeling tools like ER-WIN and ER diagrams, Normalization Techniques for designing database with Relational technology
  • Good command over creating and managing database objects like Views, Clusters, Indexes, Sequences, partitions etc.
  • Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
  • Used ETL features like Merge, SQL loader, external tables, pipelined/table functions.
  • Used Oracle Data Integrator to move data from text files to Oracle database.
  • Used partitioning and sub partitioning to improve performance.
  • Experienced in development through the full life cycle at CMM level 3
  • Involved in preparing Release Notes and Implementation Plans.
  • Involved in doing unit test, system test, acceptance test and Shakeout test.
  • Used Teradata in a data warehousing environment with APRIMO Workflow tool
  • Worked in Production support and participated in solving production issues at ETS and other projects.
  • Exposure to BI tools Tableau, Web Focus, Microstrategy, Business Objects
  • Worked on MF COBOL for 8+ years

TECHNICAL SKILLS

Relational Databases: Oracle 9i/10g/11,DB2,SQL Server 2000,Mysql, MS Access, Teradata, SSIS,Netezza

Programming Languages: C, COBOL, C#, PL/SQL, SQL, PERL, PHP 4/5, ASP, Java

Database Modeling: Erwin, Oracle Warehouse Builder, Pentaho ETL tool

Operating Systems/Frameworks: Sun Solaris, Windows XP/NT, Linux, Unix, .NET.LAMP, cakePHP, Ruby on Rails, JBoss, Web 2.0

Oracle Tools: PL SQL Developer, SQL Developer, Toad, SQL Navigator, Knowledge of ODI

Web Servers/Tools: IIS, Apache, Coldfusion, Tomcat Apache, WebFocus, Business Objects, HTML, XML, SOAP, Webservices, oXygen XML editor, websphere 2.1,weblogic 8 server

Scripting: K shell, Bourne Shell, JavaScript

Version Control: CVS, SVN, Clearcase

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

  • Develop views and sql scripts with partitioning and pivot for Remic Tax Reporting Project
  • Use SVN to check in Code
  • Create mapping documents and involve in analysis of data.
  • Design daily aqsn application for migration project from ADW (Oracle) to EDW(Netezza)
  • Create shell scripts for the application
  • Used sqlldr to perform ETL
  • Participate in Code Reviews
  • Use sqlldr and shell scripts to perform batch ETLs for CCFA Load
  • Use shell scripts to automate FFHA process
  • Interact with other teams and design and code script to generate profiles for PRISM tool.

Environment: Oracle 11G,Netezza 7.2,Unix

Confidential, Newark, De

Senior Oracle Developer

Responsibilities:

  • Develop pl/sql procedures and modify packages
  • Support DBA activities for Agile Releases for Integrated Credit Decision platform
  • Automate the install process using Unix shell script
  • Maintain Database trackers
  • Create and maintain ICDP Data Model using Power Designer
  • Use Oracle 12 OEM tool to monitor performance
  • Develop and test PL/SQL code for the project
  • Maintain Business Glossary in Domain Tables
  • Create and maintain Meta Data Dictionary
  • Generate Data Models using Power Designer

Environment: Oracle 11G,Oracle OEM Tool, Power Designer,Unix,Toad

Confidential

Senior Oracle Developer

Responsibilities:

  • Design pl/sql ETL Processes to load data into Oracle 10G/11G tables for different education streams like Toefl,GRE and other state exams conducted in various states in US. This data is consumed through the Enterprise Data Manager tool: by the end users. Worked in a team of 15 professionals.
  • Implement the SDLC life cycle for the projects
  • Develop pl/sql procedures and packages
  • Used Autosys for scheduling and monitoring the ETL processes
  • Used shell script for encapsulating the etl processes.
  • Migrate existing 10G applications to new servers and 11G environment
  • Used Oracle dbms comparison to develop process to compare data. Between mirrors and local database.
  • Used svn for version control.
  • Develop data mapping document for applications
  • Resolve production issues
  • Work with other teams to resolve issues.
  • Took initiative to develop process for monitoring Autosys jobs.
  • Took initiative to convert syncsort application to process using Oracle package and procedures.

Environment: Oracle 10G, Oracle 11G,Linux,Autosys,Shell Scripting

Confidential

Senior Oracle Developer

Responsibilities:

  • Design application to generate database ACL (Access Control List) Files using Control-M,Oracle 11G.
  • Develop Unix shell scripts for launching the application and generate reports and execute them in k-shell.
  • Developed code to generate Database access list of users (Profile,Role,SysPriv,TabPriv)
  • Worked in a team of 10+ consultants including off shore team and releases consisting of 300+ scripts
  • Involved in design of application to generate Access Control List for Remote Access Users
  • Develop Test Cases for the application
  • Update SDLC tool with design document artifacts
  • Developed pl/sql procedures to load data into temp table for ACL creation
  • Used SQL loader to load data into the temp table from text file
  • Use Control-M Agent to mon itor jobs in QA environment
  • Use Win CVS to check in and tag the code

Environment: Oracle 11G, Unix, Control -M

We'd love your feedback!