PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in analysis, design, development, Implementation and testing of applications in data warehousing and client/server environment.
• Strong experience in Wealth management or Finance /Banking,Health Insurance, Auto Insurance, Telecommunications Domain.
• Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
• Familiar with SQL*Loader to load data from external source like flat files into database tables.
• Experience in Oracle SQL and PL/SQL including Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, Views, Materialized Views, PL/SQL collections.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.
• Possess good communication and inter - personal skills, able to adapt quickly to new technologies and environments.
• Experience in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Experience in Data Analysis and managing data warehouse and data marts. Used Erwin tool for data modeling. Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques. Oracle data loading into Oracle database from flat files using SQL loader.
• Experience in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
• Good understanding of Oracle data dictionary and normalization techniques.
• Experienced in Oracle 11g/10g/9i/8i systems. Created new databases and users: set up backups, export and other monitoring scripts.
• Excellent problem solving skills with a strong technical background. Creative, adaptive and result-oriented professional with avidness to learn. Proficient at working as a team player with an aim of contributing towards the team's success.
• Preparing for Amazon Web Services (AWS) .

SKILL:

FUNCTIONAL AREAS: Wealth management or Finance or Banking system, Health Insurance, Auto Insurance, Tele Communications Media Domain.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, Shell Programming, C, C++, Core Java, PHP, Javascript, VB.NET

Development tools: Oracle Developer (Forms 4.5/5.0/6i, Reports 2.5/3.0/6i), Forms 6i, Forms 9i, Oracle Forms 10G

RDBMS: Oracle11g/10g/9i/8i, SQL Server 2005, DB2, MS Access.

Database tools: SQL*PLUS, SQL*Loader, TOAD 8x/9x/10x, SQL Navigator

Operating Systems: Windows 95.98/2000, Windows NT, HP Unix, MS-DOS, Red Hat Linux.

Reporting Tools: Business Objects, Crystal Reports 8.0/XI, Reports 6i, Reports 9i, Oracle Reports 10G

Web Development: HTML, JSP, Java Script, XML, ASP 3.0, VBScript 5.x, UNIX SHELL Scripting

Tools: Defect Management Tool: Test Director 8.0

Version Control: Subversion

Infomatica Tool: ETL

Data Modeling: Erwin 3.5.2,4.0

PROFESSIONAL EXPERIENCE:

Confidential, Edison, NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Completely delivered projects under “Agile” methodology, JIRA was used for version controlling as an agile tool and have good knowledge of Git stash.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 10g database.

Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, SQL*Loader, SQL Navigator, GIT Stash, Quality Center, Dimensions, Windows 2000 server.

Confidential, Wilmington

Oracle PL/SQL Developer

Responsibilities:

• Participate in User meetings and work closely with Business analysts to understand and analyze the requirements.
• Create technical specification documents based on the requirements.
• Responsible for loading data from source systems into target tables using SQL *loader.
• Create database objects like tables, views, materialized views, procedures and packages using Toad, PL/SQL Developer and SQL* plus.
• Partition the tables and materialized views to enhance the performance.
• Extensively use bulk collection in PL/SQL objects for improving the performing.
• Write UNIX shell scripts to process files like renaming the file, extracting date from file and removing junk characters from the file before loading them into base tables.
• Created PL/SQL records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Develop Oracle PL/SQL stored procedures, functions and packages.
• Write test plans, test the PL/SQL components and prepare test results.

Environment: Oracle 11g/12c, TOAD 8.6, DB2, UNIX Shell scripting, SQL, PL/SQL, Windows XP/2000, PL/SQL

Confidential, Huntvalley, MD

PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Part of a development team for creation and maintenance of custom apps/reports.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 9i/10g, Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential , Quincy, MA

Oracle Developer / PL/SQL Developer

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source - staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Responsible to write scripts which identify the legacy data and the valid data.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Wrote UNIX Shell scripts for performing development and DBA activities.
• Tested the ETL process in testing environment and created test cases.

Environment: Oracle 9i/10g, SQL, PL/SQL, Redhat Linux 2.1/3.0, Windows 2000 server, TOAD, SQL LOADER, ETL, EXPORT, IMPORT.

Confidential

Oracle Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Windows 2000, Toad.

Confidential

Oracle Developer /Analyst

Responsibilities:

• Involved in data acquisition from business users and project planning.
• Involved in Requirement Analysis, Data Warehouse design, Loading of data in warehouse under ETL phase using Informatica
• Data delivery and Information Analysis.
• Creating and Maintaining Universes, querying and planning scope of analysis.
• Analyzing and presenting data in Drill, slice and Dice mode
• Developed and created classes with Dimension, Detail & Measure Objects, user-defined objects.
• Resolved loops by using Aliases and Context, specified Joins and cardinalities checking.
• Analyzing and presenting data of product sales.
• Creating reports of all the four regions using Business Objects to analyze data of distributor and connect centers movements.
• Escalated technical and management issues to Project Leader at right time.
• Users on the various issues of reports.
• Reports into the market variations, comparisons with its earlier movements and move with different schemes so as to make it unique in the market by analyzing and report the activities of the sales and marketing.

Environment: Informatica Power Center5.1, Business Objects, Oracle9i, Erwin4, WinNT.