SUMMARY

• Over 7+ years of experience in teh IT industry, involved in analysis, design, development, testing, Implementation & maintenance of databases in Client/Server and Internet/Intranet environments.
• Well versed wif Software Development Life Cycle (SDLC)
• Strong development and support knowledge on Oracle, SQL, PL/SQL queries programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views
• Experience in Oracle database and database structures
• Has good working experience wif ETL
• Experience in SQL*loader, UTL FILE, Import and Export utilities and UNIX Shell scripting.
• Expertise in using tools such as TOAD, PL/SQL Developer, and SQL*Plus.
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Expertise in Optimizing Database performance, Indexing, Materialized View, managing locking scenarios for multiple users.
• Strong writing and documentation skills for teh management, development.
• Outstanding problem solving and customer focus skills.
• Excellent interpersonal and communication skills, very good team player, quick learner and capable of working independently.

TECHNICAL SKILLS

Databases: Oracle 8i, 9i, 10g, 11g

Languages: SQL, PL/SQL, Shell Script, C++,Java, HTML

Operating Systems: Windows, Unix, Linux, MAC OS

Application Software: Ms Office (Word, Excel, PowerPoint)

Database Development Tools: Toad, SQL*Loader, SQL*Plus, SQL Developer

Scripting Languages: Unix Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Oracle Developer

Responsibilities:

• Participated in teh Database Analysis, design and Interacted wif teh business users and participated in requirement collection.
• Analyzing teh requirements - designing and developing teh maps for extraction, transformation and loading of data into warehouse.
• Development of complex mappings related to dimensional and fact tables.
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Developed control files for SQL*Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables from different systems and validating teh data.
• Extensively worked on teh ETL mappings, analysis and documentation of OLAP reports requirements
• Involved in Performance tuning of teh programs and ETL processes
• Used Data Stage Designer for developing various ETL jobs to extract, cleansing, transforming, integrating and loading data
• Strong understanding of Data Modeling in data warehouse environment such as Star schema and Snow flake schema.
• Created and used Table Partitions to further improve teh performance while using tables containing large number of columns and rows.
• Created database objects like Tables, views, procedures, functions, packages, materialized views, Index and sequences using SQL and PL/SQL.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase teh performance and to make teh database objects more manageable.
• Used Bulk collect and Forall in stored procedures to improve teh performance and make teh application to run faster.
• Involved in system study and preparing teh System Requirement Specification.
• Implementation and post-implementation support of teh system
• Used Data modeling tools for mapping teh parent child tables before creation of new objects for a specific business requirement
• Supported teh application when in production and exercised strong debugging skills in resolving time sensitive issues
• Documented System requirements, Technical specifications, Use cases, activity diagrams, workflow diagrams and release notes
• Regularly interacted wif DBA and QA teams to in corporate all standards.
• Developed SQL*loader control files to extract data from different text files received from upstream systems into tables.
• Performed SQL and PL/SQL tuning to improve teh performance wif teh help of SQL Trace, Explain Plan, Indexing and Hints.
• Developed administrative tools using UNIX Shell scripting.
• Created multiple Unix shell scripts to import data into Oracle using teh SQL*Loader
• Used Collections like variable arrays, nested tables extensively.
• Documented all teh work assigned.

Environment: SQL Navigator, Erwin, SQL*Plus, UNIX, 10.5,WindowsXP, SQL*Loader

Confidential, La Grangeville, NY

Oracle PL/SQL Developer

Responsibilities:

• Involved in teh data transfer and creating tables from various tables.
• Wrote PL/SQL Packages, Stored procedures and Triggers.
• Wrote around 60 functions to get teh percentage of time spent by each employee on each project.
• Wrote PL/SQL packages of around 85 consisting of procedures and functions.
• Utilized SQL*Loader to load flat files in to database tables.
• Coordinated wif DBA in creating and managing tables, indexes, db. links and privileges.
• Involved in gathering user requirements, detailed design of E-R Diagrams, Data Flow Diagrams, Data Dictionary, and System flow Charts.
• Used Data Stage director to schedule running teh server ETL jobs, monitoring scheduling and validating its components.
• Involved in writing shell scripts on Unix for Informatica ETL tool to run teh sessions
• Implemented teh ETL process and business logic by using SQL
• Wrote SQL scripts and debugged several during ETL process
• Involved in teh design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Conducted data modeling and database design using ER diagram.
• Involved in designing logical and physical data models using Erwin.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, SQL*Loader, Erwin, UNIX, Informatica, Windows NT/XP

Confidential, Mt Laurel, NJ

Oracle PL/SQL Developer

Responsibilities:

• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Extensively worked towards optimizing teh Queries to enhance teh performance.
• Analyzed Indexes on regular basis.
• Created and maintainedDatabase Objects(Tables, Views, Indexes, Sequences, Database triggers, stored procedures).
• DevelopedSQL* loaderscripts to load data in teh custom tables.
• Wrotecomplex SQL queriesusing joins, sub queries and correlated sub queries for variousreports.
• Involved in debugging andTuning teh PL/SQL code, tuning queries, optimizationfor theOracledatabase.
• Developed and optimized of SQL queries usingTOADExplain Plan utilities.
• Tuned SQL queries and performed refinement of teh database using tools likeEXPLAIN PLANandTKPROFto significantly improve teh system response, time and efficiency.
• Run batch jobs for loading database tables from flat files usingSQL* Loader.
• Designed snow-flake and star schema for ETL process
• Developed reusable ETL transformations and Mapplets
• Extensively used ETL transformations like lookup, router, aggregator, normalizer, source qualifier, joiner, expression, Update strategy etc.
• UsedVersion Control toolslike SVN for Source Control.
• Stored data in teh audit log tables using teh old and new column attributes.
• Performed debugging of teh PL/SQL codes using teh DBMS OUTPUT.
• DevelopedMaterialized viewsandRef Cursorsfor reporting purpose.
• Definedindexeson various tables to improve teh performance of teh queries for reporting purpose.
• AUTONOMOUS TRANSACTION PRAGMA is usedinthe framework procedurestolog teh status when error occurs.
• Worked closely wif users and developers team to resolve issues in teh developedreports

Environment: Oracle10g/9i, SQL, PL/SQL, SQL*Plus, SQL* Loader, Windows 2000.

Confidential

ETL/Oracle SQL Developer

Responsibilities:

• Developing new Packages using SQL Navigator and tan store them in Microsoft visual source safe.
• Creating or modifying Packages, Procedures and functions using SQL Navigator application tool and tan launching teh applications from a report console or at teh URL line.
• Developed primary database objects such as tables, Indexes and views to implement required functionality
• Involved in requirement analysis, design, implementation, testing and deployment of teh system
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Tables, Granting and Revoking privileges, Creating Roles, Creating Primary and Foreign Constraints, Unique constraints, check constraints, Indexes, Analytic functions, Hints, Partitions, Cursors etc., and Views in Development and Production environment in PL/SQL
• Used SVN for storing all teh source codes. Designed and developed teh data conversion strategy.
• Developed packages, procedures, triggers and views to bridge teh gaps between teh old and new application.
• Developed back-end PL/SQL packages, building UNIX shell scripts for data migration & Batch Processing.
• Executed teh test cases and test scripts to ensure applications were performing according to requirements.
• Prepared test plan, test cases and requirement trace matrix.
• Developed reports using Reports 9i and invoked Triggers, etc.
• Involved in design, development and testing of Forms and Reports.
• Migrated data between stage and application schemas. Wrote SQL*LOADER control CTL files for data loading.
• Worked on SQLPLUS and SQLLDR calls from shell scripts.
• Executed PL/SQL scripts on server using Unix Shell scripts.
• Extensively developed complex PL/SQL packages for ETL
• Developed reusable ETL transformations and Mapplets
• Used DataStage director to schedule running teh server ETL jobs, monitoring scheduling and validating its components
• Involved in teh design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.

Environment: Oracle9i, SQL, PL/SQL, SQL*Plus, SQL Navigator, SQL* Loader