SUMMARY

• Around 6 years of experience in Analysis, Design, Requirements Gathering, Production Support, Performance Tuning, Trouble - shooting and Maintenance of databases.
• Excellent skills in Design and Development of applications using Oracle Database 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms & Reports 10g/9i/6i.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in ETL Architect/Designer, Relational Database applications design, development and Support on UNIX.
• Extensively developed PL/SQL code using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data and enforcing referential integrity.
• Experience in using tools like TOAD, PLSQL Developer, and SQL Developer.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Experience in designing data models using Erwin and Visio.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
• Experience in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.
• Experience with data warehouse design using Star Schema and Snowfla keschema.
• 24/7 on-call support for production
• Ability to work closely with clients to analyze data, determines project requirements, review functional requirements and develop detailed designs to meet requirements.
• Excellent analytical and problem solving skills with strong communication and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows98/XP/2000/2003/NT, DOS,UNIX (Sun Solaris, HP-UX), LinuxDatabase Oracle 11g/10G/9i/8i, MySQL, MS SQL Server,DB2, MS Access 2000

Programming languages: ANSI C, C++, VC++,C#, VB, Java, PL/SQL programming, Pro*C, Unix scripting

Web Technologies: HTML, DHTML, Cold Fusion, AJAX, XML, JSP

Script Languages: JavaScript, Shell, Perl scripting

Tools: Toad, PLSQL Developer, OEM, SQL Navigator, SQL Tools, Erwin

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

ETL: Informatica Power Center 8.1

PROFESSIONAL EXPERIENCE

Confidential, EI SEGUNDO, LA

Oracle Consultant / System Analyst

Responsibilities:

• Worked on PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Designed and created all the required tables, indexes, sequences and views using SQL*Plus and Toad.
• Written Procedures to Load Data into data warehouse system.
• Involved in developing Object data types and collections.
• Developed various Complex Queries, Views for Generating Reports.
• Used Hints to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
• Written SQL scripts for implementation and mentored the end users
• Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Written Shell Scripts, control files to load data into staging tables and DW tables.
• Developed and Tested applications for loading inventory data into database tables.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Involved in Unit testing PL/ SQLStored Procedures andFunctions.
• Perform analysis of key requirements and transfer knowledge accordingly to the end users
• Extensively used PL/SQL Procedures and Functions to transform data before the loading process.
• Worked on UTL file utility to transfer data from Oracle application to external systems.
• Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, andpresentation of results.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Loading data from flat files into database tables using SQL* Loader
• Expertise inUNIX environment and shell scripting. Knowledge in Batch Jobs using UNIX KORN, AWK UNIX Shell Script (csh, bash, ksh) and API’s Using PEARL Scripts.
• Optimizing database objects and streamlining applications.
• Created different database links and validate the data in databases.

Environment: SQL, PL/SQL, Oracle9i/10g, PVCS MS-Word, TOAD, Cidallic,Quality Center Unix Shell scripting, HTML, XML, Oracle Tools,Reports(6i), Forms(6i), MS-Excel, Edit Plus, WS-FTP, UNIX.

Confidential, Charlotte, NC

Oracle Developer

Responsibilities:

• Involved in Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.
• Involved in Designing data models using Erwin.
• Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for better performance.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used
• Developed, modified and optimized complex queries for data retrieval and modification.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Tuned SQL queries and complex procedures to improve performance
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges
• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica power center 8.5.
• Used SQL* Loader for Data Conversions and to load the flat files from other different sources, from flat files into Oracle database.
• Extensively used Quality center to Run test cases and to report and track defects.
• Used Relational Clear Case for source and version control.
• Involved in supporting the performance of the project in production phase
• Involved in solving day-to-day problems, giving support to the users.
• Provided 24/7 on call production support.

Environment: Oracle 10g, SQL, Erwin, SQL*Plus, TOAD, Quality Center, Sql*Loader, Relational Clear Case, Informatica Power Center 8.1.1, Sql Developer.

Confidential, Miami, FL

Oracle Developer

Responsibilities:

• Analyzed System Requirements to create high level and detail design documents with the assistance of requirements team and Architects.
• Worked closely and supported members of teams such as Architecture, Change management, Database Management, Technical operations, System Test, UAT, Requirements and Business teams during entire life cycle of the project.
• Significant use of database technology data warehousing STAR schema, SQL-Loader, Oracle Stored Procedures.
• Developed highly complex applications using Oracle 11g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, Joins and Dynamic SQL.
• Used concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions,Insert All, Global Temporary tables.
• Developed Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
• As a key PL/SQL developer, defined the required analytics to design, develop financial routines, and assisted various work streams in identifying, and resolving data irregularities, and establish management reporting processes and requisite supporting technology.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD). Created SQL scripts to perform unit and component testing financial calculations such as, Interest receivables.
• DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
• Handled code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest.
• Performed performance tuning for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.
• Document production support procedures, standards. Create production support documents for data warehouse applications.
• Participated in Design and Code Reviews enforcing Operational standards and provide inputs to development team.
• Used existing processes and procedures for application deployment and provided 24x7 production support as Primary.

Environment: Oracle 11g/10g, Clear case, Clear quest, Toad 9.5, PLSQL Developer 7, Sun OS 5.8, Windows XP 5.1.2, AB Initio, Business Objects, Sql*Loader, DOORS.

Confidential

Database Developer

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing
• Used SQL* Loader to load data into different tables
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers
• Extensively used PL/SQL to extract data from different tables with millions of records in some of the tables
• Created Materialized views& normal views according to the requirement.
• Developed, modified and optimized complex queries for data retrieval and modification.
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used
• Incorporated validation rules for promotion history table and updating tables
• Participated in status meeting and walkthroughs
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.

Environment: Oracle 9i, SQL*Plus, PL/SQL, Toad, MS Windows 2000, C, C++