SUMMARY:

• Over 7 years of experience in the development of client/server and multi tired applications using SQL, PostgreSQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX, Greenplum.
• Involved in design, development, implementation, testing, support and documentation of business applications using Oracle technologies.
• Strong knowledge on oracle architecture and database design concepts like Normalization and ER Diagrams.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and needed business rules.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views and Table Joins.
• Knowledgeable in client - server technology, GUI design, and Relational Database Management.
• Experienced with DBA activities like granting and revoking privileges on database objects.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Strong knowledge on Oracle Forms and Reports.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Worked in Manufacturing Process, Banking Information Systems, and Health Care Management domains on various applications.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Tested deliverables for conformance with requirements and specifications, including Unit, Module, Integration and System testing.
• Quick learner with ability to master new concepts and applications.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS:

Databases: Oracle 11g/ 10g/ 9i/ 8i, MY SQL, DB2, MS ACCESS, Greenplum

Languages: SQL, PL/SQL, C, C++,Java, Visual Basic

Tools: TOAD, SQL Developer, Oracle Enterprise Manager, SQL*Plus, SQL*Loader, Crystal, Xcelsius, Erwin, Maestro, MS Office, Microsoft Visio, Informatica Power Center, PgAdmin, TFS, Tableau

Scripting: Unix shell scripting, Java Script

Operating Systems: UNIX, LINIX, Windows VISTA/XP/2000/98, MS DOS, MAC

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

PL/SQL Database Developer/Greenplum Developer

Responsibilities:

• Understanding logical modeling and physical modeling of application.
• Involved in meetings with end users on enhancement issues for gathering the requirements and communicating the same to development teams.
• Customized SQL scripts, packages, procedures, cursors, tables, views, Reports, Forms, materialized views and functions as per the business requirements.
• Developed PL/SQL packages and database triggers in both Oracle and Greenplum.
• Testing of production fixes in the test environments to ensure they have resolved given issue as well as ensure production fixes do not cause other issues.
• Extensive knowledge and experience in Team Foundation Server including re-designing the old methodology used.
• Ability to design, develop, and conduct unit test plans to ensure application code is functioning correctly.
• Monitor operational environment to ensure internal and customer Service Level Agreements are met.
• Worked in Visual Studio to maintain the code changesets.
• Worked on all type of Analytical Functions (RANK, DENSE RANK, LAG, LEAD etc.)
• Designed the ETL processes using Informatica tool to load data from Legacy systems into the target Oracle database.
• Developed mappings in Informatica Powercenter to load the data from various sources.
• Conducted peer design and code reviews and extensive documentation of standards, best practices.
• Worked in cross function teams based in various parts of the globe.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks as well as performance tuning.

Environment: Oracle 10g, SQL Developer, Informatica Power Center, TOAD, Query Direct, SQL Plus, SQL * Loader, Aginity, PgAdmin, Tableau

Confidential, Timmoniu, MD

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views, table joins and functions as per the business requirements.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Used the standard Oracle package DBMS SCHEDULER to automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.

Environment: Oracle 10g, SQL Developer, Erwin, TOAD, Query Direct, SQL Plus, SQL * Loader

Confidential, Florence, SC

Pl/Sql Developer

Responsibilities:

• Customized various Forms and Report according to the requirements.
• Analyzed Financial Markets Data and mapped Source Systems Data to Finance Data warehouse.
• Created system design document with high-level design and requirement document. Conducted walk through for requirement and system design.
• Created and modified SQL, PLSQL and SQL*Loader scripts for data conversions to load data from flat files into oracle interface tables.
• Developed SQL Queries to fetch complex data from different tables from different databases using database links and inserted the results into the newly developed tables.
• Created views, materialized views and synonyms for developers to hide the complexity and secure the direct access of DB Tables.
• Developed various Oracle sub functions like Stored Procedures, Functions, Table joins and Packages using PL/SQL as per the Design Documents.
• Involved in uploading and downloading of the flat files from UNIX server using FTP.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.
• Worked on Data Modeling tool which includes both Logical and Physical Models.
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.

Environment: Oracle10g/9i, SQL, PL/SQL, Toad,SQL*Loader, WinXP, UNIX.

Confidential

Pl/sql developer

Responsibilities:

• Reviewed and Analyzed Business Specification Documents.
• Extensively involved in the requirement analysis, development, writing test cases, and unit testing.
• Designed and created Database objects and used oracle for logical grouping of tables & views.
• Created a new work book and opened an existing workbook.
• Wrote PL/SQL procedures and packages as per requirement.
• Implemented complex SQL queries and created views for better performance.
• Performed indexes for faster access of tables, worked on Materialized Views and Query Rewrite.
• Wrote scripts to merge data from one system to another system.
• Used SQL*Loader to load data from flat files (excel/access) to Oracle database.
• Explain plan to improve database performance.
• Involved extensively in the analysis and tuning of the Application code (SQL).
• Increased performance by fine-tuning PL/SQL Procedures.
• Wrote shell scripts for scheduling jobs.
• Assisted in testing and deployment of the application.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, UNIX