SUMMARY:

• 8+ years of IT experience as Oracle PL/SQL Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments
• 4+ years of experience in using Informatica PowerCenter 9.x/8.x
• 3+ years of experience in writing shell/perl scripting in UNIX environment
• Excellent experience and understanding of system development life cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database
• Strong experience in development/support of various Data Warehouse projects in Financial, Insurance, and Healthcare industries
• Expertise in development using Oracle Forms and Reports and in using tools like TOAD, SQL *Plus.
• Expert in creating complex SQL Queries, PL/SQL packages, functions, stored procedures and triggers for business needs
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors and Dynamic SQL
• Expert in performance tuning, using various Oracle utilities, including Explain plan, hints, SQL Trace, TKprof and DBMS Profiler
• Expertise in ETL development, Data Migration concepts using tools like SQL*Loader and External Tables.
• Experience in using oracle DataPump to Export and Import tables, schemas, and databases
• Significant experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE
• Experience in writing shell script on different type of shells (bash and ksh shells) for invoking SQL scripts and scheduling routine tasks using Crontab in UNIX environment
• Expert knowledge of new features in Oracle 11g, such as Virtual Columns, Interval Partition, Result Cache, Flashback Table queries.
• Working knowledge of using ERWin for creating data models and relational schema
• Experienced in Conceptual, Logical and Physical Database design and development, Normalization and Data modeling using Erwin
• Excellent knowledge of data warehousing concepts including star schema and snowflake schema, data marts used in relational and dimensional modeling
• Highly skilled in using partitioning and sub partitioning of tables to improve performance.
• Hands on experience in handling errors using Exceptions
• Experience in using TOAD, SQL Developer for debugging applications.
• Good Experience in Unit Testing, Integration Testing and Performance Testing.
• Self - motivated and results oriented person with good analytical and problem solving skills

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, SQL*PLUS), MS SQL SERVER 2000/2005/2008 , DB2/UDB, SAP Tables and MS Access

ETL Tools: Informatica (Power Center 5.1/6.2/7.1/8.6.1/9.1.0 ),and SQL*Loader.

Operating Systems: Windows XP/7, Windows Server 2008 and Linux (Ubuntu).

Languages/Utilities: SQL, PL/SQL, TSQL, UNIX shell scripts, PHP, C and HTML.

Other Tools: MS Word, Excel, PowerPoint, Publisher, Visio 2003, TOAD, SQL developer, MySQL, Oracle Enterprise Manager, Oracle Forms & Reports 6i/10g/11g, Chinese (Fluent).

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Delivered qualified reports for business team. Mapping the data requirements, build statements based on the mapping and generate reports.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Generated server side PL/SQL scripts for data manipulation and validation
• Created materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Involved in ETL process and created PL/SQL stored procedures, functions and packages for data transformation and data transfer from staging area to target tables
• Extracted data from the operational database into simple flat text files using Spool and UTL FILE package.
• Extensively used bulk collect in PL/SQL objects for improving the performing.
• Wrote complex queries and sub queries to do analysis work and generate reports to validate the results produced.
• Proficiently performed Oracle Performance tuning using tools like SQL*Trace, TKPROF and EXPLAIN PLAN.
• Extensive used PL/SQL Collections and Records for improving Query performance
• Used Partition methods for Oracle tables and indexes to make Database Faster and easier to maintain
• Extensively worked on PL/SQL Error/Exception handling.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows NT, SQL, PL/SQL.

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Analyzed requirements document and designed the technical specifications document for the database-related functionality.
• Developed ER diagrams, physical and logical Data Models using Microsoft Visio.
• Used Oracle Forms 6i to design and develop the interface for the system which facilitated creation of custom forms related to customer and supplier maintenance, bill, receipt, invoice, debit and credit notes.
• Responsible for analysis, design, development, and testing of the database involved in the application.
• Created front-end procedures and functions with Forms 6i to perform calculations related to bills and invoices.
• Developed tables, sequences and indexes necessary for implementing the business rules.
• Created new database objects such as PL/SQL Procedures, Functions, Triggers, Cursors and Packages as part of database development using TOAD and Oracle 11g.
• Developed Materialized Views with fast and incremental Refresh Rates using TOAD.
• Extensive use of PL/SQL Collections and Records, and Partition methods for oracle tables and indexes.
• Developed PL SQL stored procedures to read input from, and send output to, in the form of XML.
• Used Reports 6i to create reports related to revenue earnings and expenses.
• Performed effective Unit Testing and also offered support during the production releases.
• Created several reusable code components and communicated them to the team for future use. Used Microsoft VSS for checking in the scripts on a daily basis.
• Held training meetings for junior oracle developers to introduce the system and environment of the company.

Environment: Oracle 11g, TOAD for Oracle, PL/SQL, Developer 2000 (Forms 6i, Reports 6i), SQL *Plus, Microsoft Visual Source Safe 6.0, Microsoft Visio.

Confidential, New York, NY

Oracle Developer

Responsibilities:

• Created and managed many objects in large Oracle Databases containing millions of records.
• Coded and debugged Stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Extensive querying using SQL * plus / TOAD to monitor quality & integrity of data.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• Created Batch Jobs and UNIX Scripts to automate the process.
• Wrote PL/SQL programs to read from files, upload data, and mass updates/inserts of data based on certain business policies.
• Developed oracle Reports, PL/SQL packages to perform Certain Specialized functions.
• Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters etc.
• Involved in unit level testing, Module level testing and Integration testing at the primary level before the modules are delivered to the Quality department.
• Written korn shell scripts dat were used for checking Network stats, Disk space, Monitor Queues, Virtual Memory, Shared Memory and Control processes.
• Developed shell scripts with embedded SQL statements for batch processing and data content changes.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.

Environment: Oracle 9i, Shell Scripts, Toad, SQL *Loader, Import, Export, .NET, Informatica, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Participated in analysis, design, development, testing, and implementation of various business Systems using Oracle 10g and PL/SQL.
• Define database structure, mapping and transformation logic.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Developed new and modified existing packages, triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Extensively used TOAD and SQL developer.
• Understand the data model and ETL process.
• Develop, test and maintain all ETL maps /scripts and physical data models.
• Load data for testing throughout the project lifecycle.

Environment: Oracle 10g, Oracle Forms & Reports 10g, SQL, PL/SQL, UNIX, TOAD, and SQL developer.

Confidential

Jr. Oracle PL/SQL Developer

Responsibilities:

• Designed and developed packages for scheduling appointments, inspections and surveys.
• Developed database objects Procedures, Functions, Packages, Collections, Synonyms, Constraints, Indexes and External Tables.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Performed performance tuning (TKProf, SQL Trace, Oracle Hints and Explain Plan).
• Used the collections and bulk binding for processing billions rows and to improve the performance.
• Data transferred/migrated between two Oracle databases using DB Link.
• Involved in day-to-day database maintenance, Partition tables, Unix Job Scheduling.
• Prepared and ran scripts for creating tables, indexes, etc.

Environment: Oracle 10g/9i, SQL, PL/SQL Developer, SQL*Loader, Toad, UNIX.