Senior Oracle Developer Resume
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