SUMMARY

• Over 8+ years of experience as Oracle PL/SQL developer and implementation of applications are using Oracle Applications.
• Strong experience in Oracle RDBMS, PLSQL Development, Oracle 11g, 9i, 10g, SQL, PL/SQL, Developer Suite 10g/9i - Forms and Report, Java, HTML, UNIX and Workflow.
• Excellent working and conceptual knowledge of Oracle 9i, 10g,11g PL/SQL, Java, HTML, and Java Script.
• Extensive experience in writing PL/SQL packages, stored procedures, functions, Views and database triggers using SQL and PL/SQL in oracle.
• Involved in the Analysis and Data Modeling (Logical to Physical data models).
• Good working experience of using AWK programming in UNIX shell scripting
• Experience in developing logical and physical modeling of a database using ERWIN.
• Analyzing of SQL statements using EXPLAIN PLAN to improve the performance.
• Used Oracle Forms 9i, 10g and Reports 9i and 10g as GUI for Oracle Applications.
• Design Skills: UML (Visio), Object Oriented Analysis and Design (OOAD).
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects
• Expert in PL/SQL tuning for high performance
• Strong experience in working with application development environment JDeveloper.
• Experience in Web Development Using HTML, JavaScript and PL/SQL.
• Extensive knowledge on creating star schemas, snow flake schema.
• Extensive knowledge on data warehouse concepts like ETL, reporting, Data mart, data warehouse
• Extensive knowledge inwriting formulasusingcrystal /Basic syntaxandshared variables.
• Experience with data extraction, transformation and loading from different data sources into a common analytical data model using Data stage.
• Good team player and ability to work independently.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Extensive knowledge on creating Star schemas, snow flake schemas.
• Used Oracle Forms and Reports as GUI for Oracle Applications.
• Excellent analytical and communication skills those are required effectively to work in the field of applications development and maintenance.
• Expertise in working with Oracle 11g/10g/9i, TOAD, SQL Navigator and SQL * Loader for both development and customizations as per client specifications
• Used SQL Trace, Explain Plan and TK Prof for Better performance.
• Good experience in understanding and designing solutions for complex integration scenarios. Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies in a fast paced environment.
• Refine conceptual systems design requirements into the technical design Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS

Operating Systems: DOS, Windows XP/NT, Linux, UNIX, OS X

Languages: SQL, PLSQL, C, C++, Java

Scripting Languages: JavaScript, HTML and XML

GUI’s Technologies: Oracle Forms 11g, Developer Suite 10g/6i(Forms, Reports), Crystal Reports 9/10, Discoverer10g, Erwin, ODI, J2EE (Servlets, JSP, JDBC), Oracle APEX

Databases: Oracle8i/9i/10g/11g, SQL server 2000, Oracle XML DB, Oracle AIX, Oracle AQ, MS Access

Utilities: SQL* Plus, SQL* Loader, SQL Navigator, Toad, ETL tools Informatica.

PROFESSIONAL EXPERIENCE

Confidential, SANTA ANA, CA

Sr.Data Architect

Responsibilities:

• Involved in Understanding the Data Models and creating Entity Hierarchy Worksheet.
• Worked on different defects of Drug data load which have to generate a Daily Impact Report which indicates impact on the drug data.
• Worked with QA team in testing these reports, understanding the issues and fixing it.
• Created VIEWS and TRIGGERS for Reference data, Transactional data and Content attributes which are used to fetch the Specialty data.
• Involved in DB Structure changes that were requested by developers.
• Worked with Packages and Stored Procedures which were used in the Daily Impact data load generation.
• Worked on Comparing different Schemas with compare option in TOAD and DDL & DML Sync up between different environments.
• Modified Views according to the business logics and business requirements.
• Used Import and Export options in TOAD for import and export of data into different tables.
• Automated the Reference data synchronization across databases and saved 1000$ for the client avoiding monotonous manual efforts in synchronization.
• Used Oracle‘s export and import utilities for moving of data across the Environments.
• Owned the synchronization of Data model based on approved change request from business.
• Worked with Tortoise SVN and owned the versioning of Data Model and Data synchronization scripts.
• Worked on Pl/SQL extensively for Data synchronization and other generic processes and developed many packages and procedures.
• Worked on Performance tuning of long running SQLs with the help of Toad Analyzer utility.

Environment: Oracle 11g, SQL PLUS, PL/ SQL, SQL*Loader, TOAD 12.1.3, RedGate Data compare tool for Oracle - 2.1, DBeaver 3.4.0, Erwin Data Modeler 9.2, Tortoise SVN 1.8, SQL Developer Oracle - 3.1.7, Microsoft Visio 2010.

Confidential, ROCKVILLE, MD

Sr.Database Developer

Responsibilities:

• Developed Stored Procedures, Packages, and Functions using PL/SQL to implement day to day modified business rules into the current system.
• Involved in creating System documentation such as Technical Specification, Unit Test Plan, System Flow Diagram and Data Flow Diagram using MS-Word, Visio
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Generated files on the using UTL FILE, DBMS XMLGEN
• Used Autonomous transactions extensively to handle errors at different levels.
• Used Database triggers for making tacking history of insertion, updating, deletion of certain tables for audition purposes.
• Created & Scheduled Batch jobs using DBMS SCHEDULER.
• Major responsibilities include getting requirements from the user, writing reportsinCrystal Reports XI.
• Involved in writing UNIX Shell scripts for automation.
• Involved in the optimization of process performances using Hints on SQL queries, creating indexes on tables, reducing context switching by using Collections.
• Worked along with the development team to integrate the Crystal Reports with the Prompt Screens.
• Developed various complex PL/SQL packages, using Oracle's features such as NESTED-OBJECTS, VARRAYS, TYPES-WITHIN-TYPES.
• Generated XML files for data transfer. Used XML parser to parse the data.
• Involved in managing code through Clear Case, and defects through Clear Quest. Also designed Flow Diagrams using MS Visio.
• Worked on table Partitioning (Range and List) and deploying local indexing on partitioned tables.
• Involved in processing of large data using PL/SQL Bulk processing techniques
• Recommended the Normalization and De-normalization of certain tables to Data Modeling team to improve loading and reporting performance
• Assist in developing test scenarios, test scripts, and test data to support unit and system integration testing.
• Developed and modified UNIX scripts to wrap PL/SQL code, FTP files, send emails, automate batch processing and upload data.
• Developed PL/SQL interfaces to import data from staging tables into Base tables.
• Involved in Star Schema modeling - fact and dimension table design, physical and logical Data modeling using Erwin 3.5.
• Imported Source/Target Tables from the respective databases and developed jobs using Joiner, Lookup, Filter, Transformer, Aggregator, Funnel and Oracle Enterprise stages.
• Implemented data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment.
• DevelopedForms Screensused by Oracle Developer Suite forforms procedures, functions and packagesgenerate to end product of Forms.
• Provided database support to testing and Java team in writing complex SQL queries.
• Used JCAPS to translate the IRL files to HIPAA files and wise versa.
• Extensively used EDIFECS Spec builder to validate the HIPAA files.

Environment: Oracle 11g, SQL PLUS, PL/ SQL, SQL*Loader, XML, Windows XP, MS-Excel, Solaris, TOAD, SQL Navigator, Reports Builder 6i/9i, Crystal Reports10.0/9.0/

Confidential, Redwood City, CA

Oracle Developer

Responsibilities:

• Written PL/SQL packages and stored procedures for the application to be developed on the database side.
• Created Detail design Document for the Ebill Enrollment for PLSQL, JAVA
• Extensively used cursors, Collections and PL/SQL tables.
• Used oracle inbuilt packages, analytical, aggregate functions
• Used Unix Shell Scripts for scheduling the jobs.
• Developed performance benchmark scripts.
• Using SQL Loader direct path method for populating static tables and fact tables from CSV Files.
• Involved in various Data warehousing techniques like logical and physical database design, Star Schema design, Identified Fact Tables, Dimension Tables.
• Created Different type of Index’s to improve the performance.
• WroteCrystal Reports as business intelligence applicationto design and generate reports from a wide range of data sources.
• Utilized Oracle’s bulk processing techniques like Bulk Collect and FORALL.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Extensively worked on Unix Shell scripts for the support and server based tasks.
• Developed all the OLTP backend processing using PLSQL packages and cursors.
• Extensively used Analytical functions in the business application development
• Involved in the continuous enhancements and fixing of production problems.
• Worked on Different type of Performance Issues.

Environment: Oracle 10g, SQL, PLSQL, Java, Java Script, J2EE, TOAD, Reports. Crystal Reports 9.0/8.5.

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Created Detail design Document for the different Interfaces for PLSQL, JAVA.
• Embedded HTML and Java Script in PL/SQL Program units using HTP package.
• Developed a new interface will be built from where the reductions and miscellaneous transactions files will be generated.
• Used Object Oriented Analysis and design (OOAD) to Develop New system.
• Created Procedures, Functions and packages using PL/SQL.
• Created Oracle and Java Objects.
• Created packages and Stored Procedures Using Java and Oracle.
• Used Collections and Nested Tables, Materialized views and Arrays Types.
• Used Extensively Exceptional Handling.
• Evaluated the data quality using developed Pl/Sql stored procedures and UNIX shell scripts.
• Written JavaScript functions to load data from XML files to display on the web browser.
• To load the data into data base using SQL Loader,
• Developed UNIX Scripts to create FTP Jobs and data upload.
• Created Test cases for all the Test scenarios and involved in end to end testing.
• Participated in design and code reviews with client.
• Used java JDBC connection to execute procedures, and mapped PL/SQL objects to java objects.
• Strong experience in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow-flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling and worked extensively with slowly changing Dimensions.
• Created Reports for Displaying Reduction and Miscellaneous Files.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, Java, Java Script, J2EE, XML, TOAD, Reports, Clear Case

Confidential, Rosemont, IL

Sr. Oracle Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
• Extensively supported production for all the UNIX, Oracle and Reporting issues.
• Involved in Category and Performance Reports.
• Created KORN Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Analyzed, designed and developedOracle Forms9i queries, layout,reporttriggers, parameterform, data models etc.
• Prepared ER Diagrams, Data flow diagrams based on the requirement.
• Written SQL scripts to create database objects like tables, views and sequences.
• Involved in ETL processes to load data from Flat files, XML, SQL Server, Access and Excel spreadsheet into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Created UI using JSPs, JavaScript, HTML and DHTML technologies
• Written JavaScript functions to load data from XML files to display on the web browser.
• Used Forms Tool to identify the differences between two versions of Forms.
• Involved in understanding of Java Classes, JSP, JDBC and Database Connection Pooling for increasing application performance.
• Identified the calls to PL/SQL functions and procedures in the java code to replace them with SQLJ.
• Used SQL*Loader to load bulk data from various flat files.
• Participated in Integration testing and user acceptance testing.
• Designed the screens through which the end users could control the quote. Sold case details using Oracle FORMS 10g.
• Involved in the continuous enhancements and fixing of production problems.
• Performance-Tuning on various time-critical scripts using TK-PROF to ensure efficiency.
• Involved in making enhancements to the current Forms & Reports systems.
• Technical support for data mart involves creating, scheduling and maintaining various oracle objects using SQL, PL/SQL.
• Involved in logical and physical database design and Star Schema design, Identified Fact Tables, Transaction Tables.
• Created partitions on the tables to improve the performance.
• Developed User interface using Oracle Forms and Reports.
• Performance tuned the queries using TKPROF, DBMS PROFILER.

Environment: Oracle 10g, SQL Server 2005,SQL, PLSQL, SQL*Loader, KORN Shell script, TOAD, Erwin, HTML, Java, J2EE, Oracle 9i Forms9i, Reports9i, PVCS, Pro*C, Oracle Discoverer T-SQL.

Confidential, Philadelphia, PA

Oracle Developer

Responsibilities:

• Responsible for developing the capacity plan for the database, estimating the table sizes.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL developed by various developers.
• Responsible for analyzing tables and indexes to keep the STATS up-to-date.
• Design and development of supplier database by using Visual Basic.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Job responsibilities included creating database objects like tables, indexes, views etc.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed various UNIX Shell Scripts to automate the routine tasks.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning.
• Responsible for SQL tuning using Explain Plan and SQL trace facilities.
• Segregated customers into various risk levels based on their previous promptness in paying of bills.

Environment: Oracle 10g, TOAD, SQL, SQL *Loader, Visual Basic, C, KORN shell scriptingWindows NT, UNIX.

Confidential

PL/SQL Programmer

Responsibilities:

• Actively involved in full life cycle of the project, which includes analysis, design, modeling, table design and preparation of user manual and development of the program using Oracle.
• Created Oracle schema i.e., tables, indexes, constraints, triggers, synonyms, database links, roles etc. in development database.
• Extensively used PL/SQL, Stored procedures, Functions, Triggers, and Packages to augment the application logic.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Conducted extensive performance tuning using TKPROF, EXPLAIN PLAN, and DBMS PROFILER.
• Loading the data from the MS Access 2000 file and flat file to Oracle database.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Involved in Code Review, Code Walk Through, and Unit Testing.
• Involved in creation of Implementation and Testing Documentation.

Environment: Oracle 8i, DB2, SQL, PL/SQL, SQL*Loader, MS Access 2000, Windows NT.