PROFESSIONAL SUMMARY

• Over 9+ years of experience inApplication Development, Data Warehouse Development and Implementation using ODI, OBIEE, Oracle 11g/10g/9i, SQL, PL/SQL, Java technologies, Query Optimization, Performance Tuning and Troubleshooting
• Extensive experience in writing SQLqueries and PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Database Objects and Collections, by using PL/SQL
• Implemented ETL logic for Oracle DB using ODI by building Packages, Procedures and Interfaces.
• Created Dimension, Facts Measures, and Derived Measures as well as administering all layers in OBIEE Admin Tool.
• Developed Reports and Dashboards in OBIEE based on Requirements.
• Monitoring and optimizing the Database Performance through Database Tuning using Explain Plan and TKPROF
• Monitoring and optimizing the Database Performance through Database Tuning, and Application Tuning
• Developed Shell scripts in Korn/Bash and used Cron Jobs for Automation
• Developed Perl Scripts for working with Oracle Objects and handled error logic
• Proven ability to plan, coordinate and implement Software Development Life Cycle processes.
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security
• Managed Release cycles in Development, Testing and Production environments.
• Ability to handle multiple tasks and to work independently as well as in a team, experienced in interacting with Business/Technology groups
• Multi-talented with excellent communication skills, strong decision making, organizational, coordination, planning, and execution skills.

TECHNICAL SKILLS

Languages:PL/SQL, SQL, Java, UNIX Shell Scripting, Perl

RDBMS : Oracle 10g/9i/8i, SQL Server 2000/7.0, MS Access

Database tools : Oracle ODI 11g, Oracle OBIEE 11g

Operating Systems : Windows 7/NT/XP, UNIX (HP, Solaris), Linux

Other Tools/Utilities : ERWIN Data Modeling, Informatica Power center

Web Development Tools : HTML, Java Script, XML, ASP 3.0, VBScript 6.0ls.

Work EXPERIENCE

Confidential

Glendale, CA

Role: Sr. ETL Developer

Responsibilities:

• Participated in requirement gathering session with business users to understand and document the business requirements as well as the goals of the project.
• Analyzed the source system (Claim Center) to understand the source data and table structure along with deeper understanding of business rules and data integration checks.
• Created the normalized logical and the physical model with transactional facts, aggregated fact tables and the dimensions.
• Developed ODI interfaces for loading the dimensions and facts.
• Developed ODI variables and Packages for creating monthly snapshots.
• Developed ODI Procedures and Packages an implemented the data integrity rules for the load.
• Created ODI Agent and configured it for automating the jobs through the ODI Studio and Weblog Application Server.
• Developed new ODI Package, interfaces, procedures and variables for Policy Monthly Snapshot.
• Assisted in Developing the Report Logic based on the Warehouse data in OBIEE Admin tool.

Environment: Oracle 11gR2, ODI, Oracle OBIEE 5.2, Weblogic, Windows 86x, Windows

Dallas Texas

Role: Application Architect

Responsibilities:

• Developed new ODI Package, interfaces, procedures and variables for Policy Monthly Snapshot.
• Developed new ODI Package and multiple Interfaces and implemented ETL and data Validation for Historical load of Claims Data.
• Developed custom reports using Oracle Answers and assigned them to application specific dashboards.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer .
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
• Developed new logic and ODI Package, interfaces, procedures for Earned Exposure.
• Developed new Data Model for OII for 8.0 release based on Requirement by Business.
• Fixed bug regarding Earned Premium join for LOB and Transaction based tables for WP Agent using Java.
• Fixed Performance Bug using Oracle database techniques and also implemented Application level logic to reduce ETL load runtime.

Environment: Oracle 11gR2, ODI, Oracle OBIEE 5.2, Java 1.6, Windows 86x, Windows

Houston, TX

Role: Oracle Application Consultant

Responsibilities:

• Worked on FBW conversion project to implement new GRA to old GRA conversion e-Hub. Moved over 100k transactions during the change.
• Developed new Oracle Packages, Procedure, and created new staging tables for FBW conversion to implement the logic.
• Developed new Perl scripts for FBW conversion for implementing the loading process and the running Oracle Procedures and scripts handling the complex transactions processing for the conversion process.
• Developed Packages for bulk updating of transaction table.
• Incorporated validation process along with Oracle tuning incorporated in the packages.
• Developed New Packages for updating of User Validation tables implementing data validation process along with different criteria’s for update process for different tables.
• Developed a Perl script to load the data as well as handling validations and errors.
• Developed Shell scripts for reporting new files in the specified directories and also implemented email functionality and automation using Cron Jobs.
• Worked with the Business team for gathering requirements for providing High level estimations and precise logic was applied and converted into Functional Documentation and Technical design documentation.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, Perl, UNIX Shell Scripts, Remedy 7.5,

Fremont, CA

Role: Database Developer/Analyst

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification and development, deploying and testing.
• Analyzed customer data and loaded data into multiple tables by using ETL procedure using External Tables.
• Generate SQL and dynamic PL/SQL scripts to install, create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Materialized Views for database for faster queries.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Developed Unix Shell scripts for running jobs in Unix.
• Automated jobs by running Shell scripts in Cron Jobs.
• Performed Performance tuning using EXPLAIN PLAN and Oracle HINTS.
• Written many database triggers for automatic updating the tables and views.
• Created indexes on tables and Optimizing Stored procedure queries.
• Used Java Classes to produce Reports in Excel from Oracle Database.
• Extensively used PL/SQL in reports to perform calculation and to get desired output.
• Helped in development for front End – backend communications using JSP and Servlets on Tomcat 5.0
• Testing, Integration System test, Implementation (test with users) and documented the entire project.

Environment: Oracle 10g, UNIX Shell Scripts, PL/SQL, TOAD, Java, Tomcat Server 5.0,

San Francisco, CA

Role: Sr. PL/SQL Developer

Responsibilities:

• Worked on implementation of the new CA Tools interface by interacting with Materialized views via Data pump.
• Created complex Materialized views for CA Tools based on the different type of wholesale loans as specified by the business.
• Involved in developing a new application architecture framework that is data driven to replace the current process driven.
• Worked on Creating new PL/SQL Packages and Procedures for the AU-SU Changes for the LNU reports to run on the architecture framework.
• Developed Stored Procedures, Packages, and Functions for CMS interface using PL/SQL for the batch framework
• Worked on implementing the data movement strategy using the Oracle 10g feature of DBMS Data Pump API over the network to replace the legacy NDM and Oracle Export/Import process.
• Worked on enhancements for flat file loading from Mainframe to Oracle database.
• Responsible for loading multiple forms of data from Mainframe source using SQL*Loader.
• Involved in converting the business requirements into technical design document.
• Involved in tuning the long running PL/SQL queries for maximum efficiency in various business schemas of batch processing.
• Worked with Business teams to make sure requirements were converted to Functional Documentation and the precise logic was implemented in the technical design and code.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, SQL Loader, UNIX Shell Scripts,

Fresno, CA

Role: Sr. Application Developer

Responsibilities:

• Participated in gathering the user requirements and involved in writing technical design documents.
• Worked on ticketing system where problem tickets were assigned to the respective developers.
• Worked with more than 20 clients to deliver new products, upgrades and program fixes.
• Responsible for coding stored procedures, functions and triggers and other scripts based on functionality of the domain using PL/SQL.
• Improved Query performance by using EXPALIN PLAN and TKPOF and SQL Trace tuning tools.
• Created table partition and indexing for large tables to improve performance.
• Proactively monitor, preempt, diagnose and rectify database-related issues.
• Development of several PL/SQL stored procedures using varied table structure to generate detailed reports based on timelines.
• Developed ETL using SQL*Loader for importing data into tables.
• Developed Unix Shell scripts for production, communicating with oracle servers and other servers to run processes and automate jobs using Cron jobs.
• Developed Java code for creation of Excel based reports.
• Resolved application problems to maintain high level of customer satisfaction.
• Responsible for definition and management of schemas and objects and monitoring, tuning and troubleshooting of Oracle databases.
• Create database links between production databases.
• Migrated tables and indexes to different table spaces to store in the appropriate tables using PL/SQL and Shell Scripts.
• Participate in data sourcing, extract data investigation process, work with teams to develop PL/SQL, code to extract, clean and sort data for flat file generation.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, SQL Loader, UNIX Shell Scripts, UNIX

Hyderabad, India

Role: Database Analyst

Responsibilities:

• Participated in the requirements, designand implementation, integration, testing and documenting the system.
• Designed and developed triggers and views to support the application. PL/SQL, Oracle.
• Designed and developed a stored package and procedures to manage contract escalation. PL/SQL, Oracle.
• Designed and assisted with test procedures.
• Conducted code reviews and data model walkthroughs.

Environment: Visual Basic 6.0, ORACLE 7.x/8.0, PL/SQL, Windows NT.

Role: Database Analyst

Responsibilities:

• Created the application database using RDBMS concepts.
• Performed coding, testing, debugging and deploying.
• Designed the database using relational database management systems.
• Coded SQL, PL/SQL generating triggers and procedures.
• Developed Front-End Applications and Reporting System.
• Performed application deployment and user training .

Environment: ORACLE 7.x/8.0, PL/SQL, Windows NT