PROFESSIONAL SUMMARY:

• 7+ Years of experience as PL/SQL developer in design and development of Oracle 9i, 10g, 11g and 12c
• Extensive experience in Oracle RDBMS design and developing Stored Procedures, Packages, Triggers, Cursors using SQL and PL/SQL
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Strong work experience in developing using Scrum, Agile methodology.
• Excellent experience with Database normalization theory techniques, Entity relational modeling and design techniques.
• Created various types of Indexes such as BITMAP Index and B - Tree indexes.
• Extensively used Views, Inline Views, Sequences and Synonyms.
• Experience with working with Subqueries and Correlated Subqueries.
• Extensively worked with DDL, DML and TCL statements.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan, HINTS.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Extensively used Nested Loop Join, Hash Joins during Performance Tuning.
• Expertise in Tuning of Procedures, Packages, SQL Statements.
• Expertise in data warehouse and implementing ETL operations.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification and archival techniques.
• Expert in data migration techniques using Oracle External Tables, SQL * Loader, Import/Export Utilities, UTL File Package and batch processing.
• Strong hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Excellent analytical and problem solving skills and can work independently.
• Excellent Communication and responsible team player.

TECHNICAL SKILLS:

Operating Systems: Windows98/XP/2000/2003/NT, DOS,UNIX, Linux

Database: SQL/PLSQL, Oracle 11g/10g/9i, MS SQL Server, MS Access 2000

Programming Languages: PL/SQL programming, ANSI C, C++, C#, Unix scripting

Web Technologies: HTML, AJAX, XML

Script Languages: JavaScript

Tools: Toad, PLSQL Developer, SQL Navigator, SQL Tools, Informatica

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

Reporting Tools: Cognos (Report Studio, Query Studio, Analysis Studio, Framework Manager),Oracle Reports

WORK EXPERIENCE:

Confidential, South Portland, Maine

Database Developer (Oracle, PL/SQL, Informatica ETL, Deployment)

Responsibilities:

• Gather data from clients and prepare software requirements and specifications
• Worked on complete SDLC from requirement gathering till maintenance
• Implemented the code, debug and closely worked with QA to meet the data standards and policies
• Improved efforts in enhancing performance and provided increased functionality
• Assisted in the development of project plans and adhered to project timelines
• Worked and assisted on complex SQL, PL/SQL, ETL using informatica
• Added database triggers to some history tables of the database.
• Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Implemented the ETL process and business logic by using SQL
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Wrote SQL scripts and debugged several during ETL process
• Developed various mappings using Informatica Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sorter and Sequence Generator transformations.
• Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql.

Environment: Oracle 11g, 12g, Toad 11.6, SQL, PL/SQL, UNIX, SQL*Loader, TOAD, SQL*PLUS, Informatica 9.6, Putty, WinSCP, Bamboo (Deployment), Tortoise SVN, Bit Bucket

Confidential, New Jersey

Oracle PL/ SQL/ ETL Developer

Responsibilities:

• Data acquisition, data ETL, data cleansing, data mining, data integration
• Oracle database design, database development, data structure indexing, database partitioning, database performance monitoring and tuning. Developed complex custom and ad-hoc reports using SQL/PLSQL
• Analyzes, designs, programs, debugs and integrate new complex data sets
• Created D&F charts using Macros in VB on MS Excel for the reports
• Created database objects likepackages, triggers, procedures, functions, partitions, views and handled errors using Exceptions.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Utilized bulk binding techniques to improve query performance.
• Tuned the queries usingExplain Plan and packages, procedures and functionsusing SQL trace.
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
• Extracted data fromFlat filesand transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Created indexes which improve overall performance.
• Tuned heavy data loads. Monitoring and performance tuning.
• Modified existing forms and reports and registering those in application.
• Wrote complex queries involving multiple-joins for generating user reports.
• Extensively developed complex PL/SQL packages for ETL.
• Used Data Stage Designer for developing various ETL jobs to extract, cleansing, transforming, integrating and loading data.
• Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager with multiple data sources.
• DevelopedUnix Shell Scriptsto create parameters to automatically connect mappings to defined sources and targets of different schemas.

Environment: Oracle 11g, Toad 11.6, SQL, PL/SQL, UNIX, SQL*Loader, TOAD, SQL*PLUS, Putty, WinSCPEnterprise Consulting Services, New Jersey Apr’10-Feb'13

Confidential, NJ

Oracle Developer

Responsibilities:

• Gathering the requirements from the business users and analyzing them to implement
• Analyzing the business needs to make it better than what it is now
• Creating and implementing the various interface programs that act as integration tools between the different systems
• Extracted the data from the legacy systems and performed the validation of data
• Extracted data from legacy systems to create new reports to support the business users’ activities in the system
• Maintaining the data to be available to generate reports on back end tables
• Extensively used the Procedures, Functions, Views, Materialized views, Packages, Triggers, and Indexes etc. to fulfill the business requirements.
• Created the various Shell scripts to interact with the back-end databases
• Extracted the data from various servers by using UNIX commands and performed the data validations
• Automated the various jobs to run on the servers on specific day and time
• Developed Oracle scripts with cursors to manipulate database data
• Scheduling the various jobs and testing them until it will work fine in the production
• Developed the various scripts to read and write the data to files
• Upgraded the current version of the system to higher levels
• Performed the tuning of queries to run faster and get the data from back-end tables
• Extensively used data warehousing concepts in development
• Created and tested various complex reports in different styles in oracle 10g
• Developed the reports to view account holders’ expenditure to track the most valuable customers’ needs.
• Wrote SQL queries to access data from Oracle 10g database
• Developed SQL*Loader scripts, Oracle triggers and stored procedures
• Reports showing Customer Call Back Required - which is used to identify situations where the CCW setup or waiting order routes were closed by the SCRA specialists when they opened a customer call back route
• Customized the various reports to meet new requirements

Environment: Oracle 10g, SQL Developer, PL/SQL, UNIX, SQL*Loader