SUMMARY

• Over Nine years of experience in developing and implementing applications with RDBMS concepts as per Industry standards and client Requirements
• Played vital roles in all phases of SDLC, ranging from Business Requirement gathering, Designing Databases, Develop Applications, Unit Testing, System Integrity Testing and User Acceptance Testing
• Hands on experience in Normalization and De - Normalization of database design for OLTP and OLAP systems
• In-Depth Knowledge of Oracle Architecture, data dictionary, to understand Schema Objects, Schema Objects Relations, Schema Privileges, Roles and Restrictions
• Hands on experience in logical and Physical Data Modelling for Business Requirement.
• Experience in Migrating Code to different Environments from development Environment and Packaging developed code to deploy on Clients/Production Database
• In-depth Knowledge of Schema Objects (Tables, GT Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database links) and Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling, XML Type and Flashback Operation Concepts
• Knowledge of Object Oriented Programming concepts and Modifying, Troubleshooting GUI interfaces in Java Swings
• Extract, Transform and Load legacy data into Data warehouse and create analytical SQL queries with CUBE, ROLLUP, GROUPING SETS and MODEL Clause to generate reports using data in Data warehouse and Data marts
• Developing DDL and DML scripts, monitor execution of scripts which take time to execute using built in API DBMS APPLICATION INFO
• Performance Tuning application using TKPROF, DBMS HPROF, DBMS PROFILER, DBMS SQLTUNE, DBMS MONITOR and through knowledge about ADDR, AWR, cursor Cache, SQL tuning Advisor, SQL profiles, SQL tuning sets
• Good Knowledge of RULE Based Optimizer, COST Based Optimizer and Forced Optimizer Hints.
• Experience in providing production support and also client support to end users via web-ex meetings
• Active team player with commitment to work to meet deadline, strong communication, good analytical and time management skills.
• Developed ETL for data extraction, transformation and loading from legacy system into Teradata database using data Mapping, Conversions, PLSQL and shell scripts
• Used UNIX shell scripts and PERL programming to accomplish the report Generation and modification of existing reports.

TECHNICAL SKILLS

Programming Languages: PLSQL, .NET, C/C++

Markup Languages: HTML, XML

Databases: Oracle 11g/10g/9i, ACCESS

Data Modeling Tools: ERWIN, ER Studio, SQL Developer Data Modeler

IDE: SQL*PLUS, SQL worksheet, iSQL*PLUS, TOAD, PLSQL Developer, SQL Developer, SQL Navigator, Visual Studio

Source Control Software: Visual Source Safe, Clear Case, CVS, TFS

Other Tools: INFORMATICA IDQ, XML spy, Microsoft office suite, Microsoft Visio, Manugistics .

Operating Systems: UNIX (Solaris/ Confidential -UX), Windows Server 2000/2003

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Sr Oracle Developer

Responsibilities:

• Testing new mail utilities for security of end users
• Create shell script, configuration files for reports
• Gathering of business requirement and preparation of technical documentation based on business requirements
• Creation and performance tuning of sql script for reports
• Testing of the new reports based on technical documentation and business requirement regarding to different business scenarios.
• Generate adhoc reports for managers.
• Use of analytical functions in sql reports.
• Creation of procedures and function, to enhance the functionality of reports.
• Scheduling of unix reports, using crontab utilities.
• Deployment of PL/SQL scripts and Packages into production from unix box.
• ETL Packages script and process design and development.
• Using unix output format like email, gzip, gpg, ftp etc.,

Environment: Toad, Putty,SQL*PLUS,bug zilla, windows power shell

Confidential, Austin, Tx

Sr Oracle Developer

Responsibilities:

• Prepared technical documentation about the implementation of business logic, Workflow diagrams and Activity diagrams
• Understanding the business requirement Of the Business Application. Create or modify Schema Objects to accomplish them.
• Involved in creating logical and physical data model for Data modeling of application.
• To synchronize schema objects from different databases.
• Work with data modeling using ERwin data modeler
• Deploy scripts to different environments like Development, Testing (QA), staging (ITG) andProduction.
• To create package, procedure and functionfor generation of scripts for metadata of schema objects using in-built API'slike dbms metadata, dbms lobs..,
• Data integration into fact or lookup tables with Business rules.
• To resolve the data integrity issue among the upstream and Downstream applications.
• To maintain script in Git source control.
• ETL for new application lookup data from upstream Business Applications using INFORMATICA IDQ.
• Working with the front end Java developers in creating schema objects and resolving any issue related to database.

Environment: ERwin,SQL developer,SQL*PLUS,source tree, windows power shell, ALM.

Confidential, San Jose, CA

Sr Oracle Developer

Responsibilities:

• Understanding the existing business applications functionality, technology and requirements by referring through documentation, WebEx meeting records, database table and reviewing the source code.
• Understanding of data extraction, transfer and loading in existing applications
• Analysis of source code for existing applications, delegation and assignment of work with offshore team.
• Developing the PL/SQL script to extract data from database
• Developing ER diagram of existing database in reverse engineering for schema object changes.
• Data mapping for ETL.
• Performance tuning the existing procedures in the packages.
• To add metadata changes to central repository
• Co-ordinate with team to resolve the production issues in SQL scripts and suggestion for modifications.

Environment: Oracle 11g/10g/9i, SQL*PLUS, TOAD, UNIX, ERWIN, CVS, XML, WebEx, Workflow Manager, Mapping Designer, MS VISIO, Performance Tuning.

Confidential, Dallas, TX

Sr Oracle Developer

Responsibilities:

• Procuring existing documentation for knowledge transfer projects from share point, code repository like CVS and Clear case of legacy system.
• Using Dynamic SQL for Report generation purposes in stored procedures.
• Understanding the existing business applications functionality, technology and requirements by referring through documentation, Microsoft visio documentation, database table and reviewing the source code.;
• Used PERL programming and shell script for report generation to executive and field level business managers.
• Analysis of source code for existing applications, delegation and assignment of work to offshore team.
• Developing the PL/SQL script to extract data from database
• Developing ERD diagram for existing database
• Data mapping for ETL.
• To reverse engineer for generate data model for existing applications
• Understanding of data extraction, transfer and loading in existing applications
• Preparation of the Knowledge transfer documentation.
• Guiding the offshore team to contribute to the success of Knowledge transfers. Co-ordinate with them to resolve the production issues in SQL scripts.
• Worked on Manugistics for Supply chain Management.
• Update Manage on project progress.

Environment: Oracle 11g/10g/9i, Toad, SQL*PLUS, TOAD, UNIX, ERWIN, CLEAR CASE, XSL, Crystal Reports, Workflow Manager, Mapping Designer, MS VISIO, SQL Tuning/ Optimization, Manugistics (JDA supply chain software).

Confidential, King of Prussia, PA

Sr Oracle Developer

Responsibilities:

• Develop processes using PLSQL programs to validate and load data and accounting information into custom built application
• Develop generic process flow logging and error logging module to track process flow and log runtime errors
• Reverse engineering existing Informatica workflows, sessions and mappings, document process logic for future reference
• Built process to write CSV files to load in third party applications and Parse CSV files using EXTERNAL TABLES and load them
• Work with business users to understand reporting requirements and develop reports as per the user specifications
• Identifying bottlenecks in existing processes using DBMS HPROF and TKPROF, optimizing performance using forced hints and rewriting PLSQL logic
• Develop on demand refreshed materialized views to reduce network latency in distributed SQL queries
• Document technical specifications for future reference and technical manuals for users to deploy process on remote databases using DBlink
• Enhance Range Partitioned tables to use Interval Partitioning feature rolled out with 11g latest release
• Developed DDL’s to add indexes on tables to improve performance of SQL queries
• Develop mailing process using UTL MAIL built-in API to send out email notification in HTML Format
• Develop scripts to deploy jobs using oracle DBMS SCHEDULAR to gather statistics on regular intervals to get better Execution plans

Environment: Oracle 10g RAC, Toad, SQL*PLUS, TOAD, UNIX, ERWIN, HTML, XSL, INFORMATICA Power Center, Workflow Manager, Mapping Designer, .NET

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Prepared technical documentation about the implementation of business logic, Workflow diagrams and Activity diagrams
• Involved in creating logical and physical data model for the application
• Developed inbound and outbound interfaces to load data and to extract data from database into flat files
• Developed ETL for data extraction, transformation and loading into data warehouse using PLSQL and Shell Scripts
• Developed a consolidated application exception package to handle Oracle exceptions, application exception and data exceptions
• Developing Style sheets using XSLT to Parse and convert XML files and generate XML files using DBMS XMLGEN
• Fine Tuned Procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain Plans and Trace Sessions for cost based optimizer
• Worked closely with Subject Matter Expert (SME’s), quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to fix bugs
• Prepare Technical designs, Data Model diagrams, Process flow diagram, Data flow diagrams as per industry documentation standards

Environment: Oracle 10g RAC, PLSQL Developer, SQL Developer, SQL plus, UNIX, Shell Scripts, MS Office Suite, MS Visio.

Confidential, West Lebanon, NH

Sr PLSQL Developer

Responsibilities:

• Fine Tuned several slow running database queries with Explain plan, SQL trace and Hints to improve the performance of the application
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Developed various procedures and functions in PL/SQL for doing the ETL
• Developed a package containing several procedures and function using oracle concepts such as ref cursors and bulk collects are used to improve performance
• Developed several manual forms which collects the information regarding different vascular procedures entered by hospital managers, surgeons
• Created various types of triggers like table triggers, DDL triggers, Instead off triggers in PL/SQL
• Created Various Partitions like list, range, harsh, composite partitions on very large tables to improve the performance
• Involved in gathering the requirements from the users and write the specs for the projects.
• Developed several HTML based printable reports for the end users that can get forms in printable format.
• Created Materialized Views to reduce query run time for the end user
• Worked on calling several third party web services from the APEX applications
• Developed several templates depend on the requirement of the application
• Developed the scripts for creating tables, sequences, indexes, triggers, views, constraints on the tables that are required for the application
• Developed various oracle reports according to the user requirement and integrated to the APEX application so that they can directly access the reports from the application.

Environment: Oracle 10g/9i, TOAD, SQL plus, UNIX, Shell Scripts, MS Office Suite

Confidential, Virginia

PLSQL Developer

Responsibilities:

• Involved in designing of Dimensional model (Start Schema), Preparing ETL standards, Naming Convention and ETL flow documentation
• Developed ETL for data extraction, transformation and loading from legacy system into Teradata database using data Mapping, Conversions, PLSQL and shell scripts
• Develop DDL to Create schema objects like table, views, external tables, stored procedures, triggers, database links and non-schema objects like Directories, restore points to use Flashback
• Develop queries to fetch data from remote database using database links
• Involved in Configuring Crystal reports 10 with Oracle database and Developed several reports for monthly and yearly statements
• Develop scripts in Shell to automate jobs in and schedule resource intensive jobs and log detailed results
• Plan to gather stats, collect histograms for columns with high cardinality for tables with high data manipulation operations when low resource intense jobs are running and monitor performance
• Responsible for application unit testing, production Support, Version Control, Production Staging, implementation, Planning and Training

Environment: Oracle 10g/9i, TOAD, SQL plus, Teradata, UNIX, Shell Scripts, MS Office Suite

Confidential

PLSQL Developer

Responsibilities:

• Involved in data gathering to update and maintain database
• Created several wizard based forms using HTML DB as Per the requirement
• Involved in RDBMS design related issues such as development of Entity Relation diagrams using ERWIN
• Analyzed and wrote various stored procedures, functions, Triggers to be created at the backend database to cater for the entire application
• Involved in electronic data capture, retrieval and management of clinical data pertaining to patients
• Developed and designed case report forms subject to customized protocols created by in house CTS staff
• Developed reporting applications, which provide users with canned and open queries to produce customized reports Using Oracle Reports
• Developed Oracle 9i Forms applications for user access to DSS data and Oracle 9i
• Developed and written triggers for validating user input using Oracle Forms 6.0/9i

Environment: Oracle 9i, SQL*PLUS, UNIX, ERWIN, HTML, Developer 2000