SUMMARY

• Over 6 years of experience in IT, designing and developing oracle based applications.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Extensive experience in writing SQL queries, PL/SQL procedures, functions, packages, triggers, exception handlers, cursors, collections, PL/SQL tables in 11g RAC,10g RAC, 9i, 8i and 7i, Mainframe CICS.
• Expert in Performance Tuning, SQL Tuning, Data optimization, query optimization, UNIX Shell Scripting in UNIX environment and Unix Cron Shell scripting and job scheduling.
• Proficient in Data modeling using Erwin and logical and physical database design.
• Experienced in Using Power Builder to build the application.
• Experienced in developing batch programs by using PL/SQL and shell scripts and in using SQL Loader for loading data from flat files into Oracle tables.
• Well verse with Explain Plan, SQL Trace and TKPROF for high efficiency.
• Strong skills in using ETL, Datastage tools like Informatica Power Center 6.0/5.1 and Power Mart 5.1/5.0/4.7 Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations , Oracle Warehouse Builder OWB , OBIA/OBIEE, Business Objects, WMS/Labels-R12, OLTP.
• Proven ability to plan co-ordinate and implement Full Life Cycle Software Development and Maintenance projects.
• Highly motivated conceptually strong individual with outstanding oral and excellent communication, analytical, technical, problem sloving and interpersonal skills.

TECHNICAL SKILLS:

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD Business Requirement Document that provides detailed information about the requirements.
• Inbound Conversion Customers, Open AR, Vendors Forms and Report New Custom FSGs Customizations.
• Created/Modified Informatica ETL, Datastage mappings in various stages folders like Staging area and production area for development and production environment that transfers data from SQL Server, Oracle Source systems to Oracle Target system.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, and Transformations. Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as INV, OM, BOM, SO SHIPPING. Designed the ETL, Datastage processes using Informatica to load data from Sybase, Oracle, Flat Files, XML Files and Excel files to target Oracle Data Warehouse, Oracle Warehouse Builder OWB , OBIA/OBIEE, Business Objects. Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD Business Requirement Document that provides detailed information about the requirements.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections Nested Tables and Arrays , and Error Handling.
• Designed the ETL, Datastage processes using Informatica to load data from Sybase, Oracle, Flat Files, XML Files and Excel files to target Oracle Data Warehouse, Oracle Warehouse Builder OWB , OBIA/OBIEE, Business Objects.
• Used Power Builder to build the application
• Developed Unix shell scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Involved in the development of Informatica mappings, sessions and workflows.
• Configured and managed Informatica Repositories using Informatica administrator console, Oracle Warehouse Builder OWB , OBIA/OBIEE.
• Conducted meeting with System Analyst to explain the application functionality.
• Involved in 24 x 7 production support for any adhoc or hot fix requirements.

Environment: Oracle 9i, SQL, PL/SQL, SQL Navigator 5.0, Erwin 4.0, SQL Plus, SQL Loader, UNIX, Windows XP, XML, 6.3, Hyperion, Oracle Forms 6i, Reports 6i.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in logical data modeling, including developing and maintaining data model diagrams E-R Diagrams , implementing physical designs, and facilitating data model requirements gathering
• Worked in PL-SQL code tuning System Analysis, Design, Coding, Testing, Development and Documentation
• Worked on both proactive and reactive SQL Tuning and Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of databases.
• Involved in the creation of new users and controlling and administering the access privileges to Informatica Power Analyzer.
• Created and maintained all database objects such as Tables, views, indexes, sequences, constraints, procedures, functions.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse.
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Data warehouse, Oracle Warehouse Builder OWB , OBIA/OBIEE, Datastage
• Designed and Developed Triggers and Packages using PL/SQL
• Created indexes on tables and Optimizing Stored procedure queries
• Wrote Scripts for batch processing and data loading using SQL Loader
• Involved in user requirement and requirement specification from users for outbound calling and Campaign Management modules
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse, Oracle Warehouse Builder OWB , OBIA/OBIEE.
• Documenting business requirements, functional specifications and test requirements.
• Participated in logical and physical database design and developed the logical dimensional model s using Erwin 4.0.
• Optimized and tuned SQL and PL/SQL script using EXPLAIN PLAN and TKPROF.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers for the ETL, Datastage processes.
• Wrote loader scripts using SQL Loader to load large tables.
• Developer to develop mappings and design workflows.
• Involved in development and unit testing of Informatica Power Center mappings and Workflows.
• Implemented Performance Tuning logic on Mappings, Sessions and Data loading using SQL loader, to provide maximum efficiency and performance.

Environment: Oracle 9i, Toad, SQL Loader, UNIX Shell Scripts, Windows XP, Erwin 4.0.