SUMMARY

• 8+ years of experience in Application development and Production support using Oracle SQL, PL/SQL.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER.
• Worked in Client - Server application development using Oracle 11g/10g/9i FORMS10g, REPORTS 10g, Oracle Import and Export Utilities.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Experience in ETL transformations using Oracle Data Integrator 12g(ODI).
• Proficient in Application and SQL statement tuning usingoptimizer hints, Explain plan, SQL trace, TKPROF, Auto trace,Parallelism, Stored Outlinesand Partitioningetc.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge inmaster-detail blocks,forms triggers,system variables, multiple form applications, menus, alertsandLOV's.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Carried out testing in test database for upgrading/migrating from Oracle 9i to Oracle 10g.
• Experience in developing logical and physical database design, data modeling using Erwin & Informatica (Power Center 6.1).
• Involved in creating mappings, transformations in Informatica, tuning & monitoring workflows.
• Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.
• Experience with DBA activities like creating table spaces, granting and revoking privileges on database objects.
• Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, Hints in Oracle 9i.
• Experience in Installing Software’s and Configuring Databases.
• Experience in UNIX Shell Scripting for batch processing.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Comfortable to work with a team or work individually.
• Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i

Oracle Tools: SQL * Loader, TOAD, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g), SQL*Plus, Discoverer, Power Builder 12.

ETL Tools: Informatica Power Center 8.6.X/6.1, Datastage, Oracle Data Integrator 12g.

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration, Tableau 7.0.

Programming Languages: Unix Shell Scripting, Perl Programming, XML, C, C++,Java, HTML,XML

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, Monroeville PA

Oracle SQL, PL/SQL Developer

Responsibilities:

• Worked for Production Support and troubleshooting data quality and integrity issues.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Worked closely with Business users, interacted with ETL developers, Project Managers, and members of the QA teams.
• Scheduling and monitoring of Data loads.
• Created Master detail, Charts and Cross-tabs reports to view data in an analysed way.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Modified PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the lower environments to the Production database.
• Designed/ Developed/Modified Business Rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created Dynamic SQL queries to retrieve large amounts of data, which run with optimal performance and easy maintainability.
• Extensively used Global Temporary Tables for data processing both staging and session based.
• Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Used UTL FILE package to extract and write data from OS files to TEXT/CSV file formats.
• Created automated jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking PL/SQL Procedures.
• Created Packages for custom designed functionality using 3rd party tools like TOAD and Oracle SQLDeveloper.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Handling the defects using Clear Quest from the user applications based on the priority level.
• Used Exception Handling extensively to debug and log/display the error messages in error logging tables or the application respectively.

Environment: Oracle 10g/11g, Oracle Forms10g, Oracle reports 10g, Tableau 7.0, Toad, SQL Developer, PL/SQL Developer, Perl, UNIX Shell Scripting, Rules Engine, Rational Clear Case.

Confidential, Chelsea, MA

Oracle SQL, PL/SQL Developer, ETL Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the lower environments to the Production database.
• Performed Extract, Transform and Load operating for processing the legacy data.
• Designed and developed Business Rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created automated job to clear the generated worksheets based on user-defined risk engine and clearance rules.
• Created Dynamic SQL queries to retrieve large amounts of data, which run with optimal performance and easy maintainability.
• Extracted, transformed and loaded the mainframes data into COMETS HD tables using Oracle Data Integrator 12g.
• Extensively used Global Temporary Tables for data processing both staging and session based.
• Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Developed Mappings, reusable mappings, scenarios and load plans to automate the loading process.
• Created Packages for custom designed functionality using 3rd party tools like TOAD and Oracle SQLDeveloper.
• Utilized standard Change Management techniques using Rational’s ClearCase and ClearQuest Tools.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Handling the defects using Clear Quest from the user applications based on the priority level.
• Used Exception Handling extensively to debug and log/display the error messages in error logging tables or the application respectively.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: OracleODI 12g, Oracle 10g/11g, Toad, SQLDeveloper, PL/SQL Developer, Perl, UNIX Shell Scripting, Rules Engine, Rational Clear Case and PAC 2000 Tool.

Confidential, Charlotte, NC

Oracle SQL, PL/SQL Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the lower environments to the Production database.
• Developed an automated process that generates Audit Tables, Triggers, sequences, Grants and Synonyms for a particular table.
• Designed and developed Business Rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created automated job to clear the generated worksheets based on user-defined risk engine and clearance rules.
• Created Dynamic SQL queries to retrieve large amounts of data, which run with optimal performance and easy maintainability.
• Extensively used Global Temporary Tables for data processing both staging and session based.
• Worked on various aspects of Wealth Management like investment management and other banking features.
• Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Used UTL FILE package to extract and write data from OS files to TEXT/CSV file formats.
• Created automated jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking PL/SQL Procedures.
• Assisted in integration of Exadata applications.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Created Packages for custom designed functionality using 3rd party tools like TOAD and Oracle SQLDeveloper.
• Utilized standard Change Management techniques using Rational’s ClearCase and ClearQuest Tools.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Handling the defects using Clear Quest from the user applications based on the priority level.
• Used Exception Handling extensively to debug and log/display the error messages in error logging tables or the application respectively.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g/11g, Toad, SQLDeveloper, PL/SQL Developer, Perl, UNIX Shell Scripting, Rules Engine, Rational Clear Case and PAC 2000 Tool.

Confidential, NEWPORT NEWS, VA

Oracle SQL, PL/SQL Developer

Responsibilities:

• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Initialized utilization of Data Warehouse ETL software during conversion of data to Oracle DB.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Used UNIX Shell Scripts to automate backend jobs.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Used performance tuning utilities like EXPLAIN PLAN to improve the performance by reducing the run time of queries on the database.
• Based on the data loaded in the target database (oracle) various business reports are developed.
• For the reporting purpose extensively used REF cursors.
• Wrote complex SQL queries using Joins, Sub queries, Inline views and Group functions.
• Worked as an application DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
• Trouble shooting performance issues within packages using DBMS OUTPUT
• Coordinating with the business users for System Test and User Acceptance Test.
• Developed scripts for validating the UAT deployment for the schema objects.
• Responsible for Documentation of all the project developments and methodologies followed for the defect-fix, as per the standards defined and the system requirements.
• Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting.

Environment: Oracle 11g, Oracle Application Servers, UNIX Server 4.3, Power Builder 12, Windows NT, SQL*LOADER, and TOAD.

Confidential, Dallas, TX

Oracle SQL, PL/SQL developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to develop interfaces to transfer the data from the intermediary database to the main database.
• Designed and Developed several reports using Oracle Reports 10g.
• Developed Procedures, Functions and Triggers to be implemented in the Reports.
• Created UNIX Shell scripts for automating the execution process and ftp the files to several UNIX servers.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Involved in SQL Tuning by creation of indexes and materialized views and also by making use of Hints and EXPLAIN PLAN and TKPROF.
• Created Dimensional Data model in data warehouse using the star schema.
• Used ETL process to identify the new or the changed data in order to make better decisions in the project.
• Involved in storing and tracking changes to the individual files using PVCS to manage and monitor the project and maintain versioned work files.
• Handling the trouble tickets which come into an application from the users based on the priority level.
• Developed Complex queries to retrieve the data as per client requests based on certain parameters and restrictions.
• Used Exception Handling extensively to display the error messages in the application.
• Involved in transferring the files from Windows environment to UNIX environment to be used by the host application/programs.
• Involved in creating Test Cases for the Reports based on detail design.
• Involved in creating Design and Technical Specifications (DATs) for each of the reports developed using Reports Builder 10g.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g, Oracle Developer Suite 10g, PL/SQL Developer, Pro*C, SQL *Plus, LINUX shell script, Serena PVCS- project version control system, Reflection for UNIX and Digital.

Confidential, SAN FRANCISCO, CA

Oracle SQL, PL/SQL developer

Responsibilities:

• Database design and development including Tables, Primary and Foreign Keys, Indexes, Stored Procedures and Database access policies for the company’s education system.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and self-joins.
• Tuned SQL statements using hints for maximum efficiency and performance, created and Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Created complex Stored Procedures and Views to be used for the Reports.

Environment: Oracle 11g/10g, Oracle REPORTS Developer (11g), UNIX Server 4.3, Rational Clear Quest, and TOAD, SQL NAVIGATOR.

Confidential

Oracle SQL/ PL-SQL developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions using REF cursor, Collections and Dynamic SQL.
• Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.
• Incorporated bulk incremental inserts in PL/SQL procedures.
• Created Database Trigger to audit search events.
• Embedded SQL queries in PL/SQL procedures and ran them dynamically.
• Operated BLOBS, CLOBS and BFILES using PL/SQL (DBMS LOB) packages.
• Enhanced database functionality using Oracle supplied PL/SQL packages.
• Developed Java Stored Procedures and loaded Java Classes into Oracle.
• Designed Data Model Diagram using Designer 10g.
• Designed and Developed logical and physical database using Designer 10g.
• Created views, table, sequences, indexes and synonyms database objects.
• Created partitioned tables and indexes.
• Tuned PL/SQL packages to improve performance of the application.
• Created User Interfaces for search functionality using Oracle FORMS 10g.
• Created Menus, Object Libraries, and Properties Classes and integrated in application using Oracle FORMS 10g.
• Created and developed REPORTS for financial reporting using Oracle REPORTS 10g.
• Created Designed Documents and technical documents.

Environment: Oracle 9i/RAC, Oracle FORMS 10g, REPORTS 10g, Designer 10g, TOAD,SQL DEVELOPER, UNIX SHELL Scripting.