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