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.
• UNIX Shell Scripts for cron jobs and batch programs to generate reports. Defined the security rules in GL to control the financial information each group of users can print in the financial reports. Implemented summary accounts and used them in FSG reports.
• 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.
• Provide resolutions to time-sensitive ad-hoc requests for information from management. Optimization of SQL queries, and performance tuning by using Explain plan and Analysis, Mainframe CICS. Used the Power Builder to build the application Fixing the problems in PL/SQL code and any problems with DDL scripts for tables and indexes and escalating the issues in severe cases to the development and other support teams about possible impact on the application functionality. Responsible for Unit level testing, Module level testing and Application testing. Tuning Database and SQL for Optimal Performance, Redesign and build the Schemas to meet optimal Performance measures. Provided production support and resolved production issues in a timely and efficient manner, WMS/Labels-R12. Monitoring and management of the applications in the Solaris box. This is to ensure the 24 7 online - as part of maintaining the availability management.
• Environment: Oracle 11g, PL/SQL, SQL Plus 10.1, SQL Loader, Erwin 4.1.4, Toad 10.1, UNIX, Solaris, Linux, Red hat Linux, Shell Scripting, Windows, Informatica Power Center 7.x/6.2/5.1, OLTP, SQL Navigator 6.3, Oracle Forms 6i, Reports 6i.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with business analysts to understand the business requirements and created technical requirements document. Responsible for development activities at the back-end side as well as actively participated in analysis and designing part.
• Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, and Transformations.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements. UNIX Shell Scripts for cron jobs and batch programs to generate reports.
• 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.
• Identifying performance bottlenecks, suggesting and implementing alternative approaches like range partitioning of tables, use of global temporary tables. Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules, Mainframe CICS. Developed code using advance features of 10g such as Regexp , analytical functions, used UTIL package and functionality to send emails to team members and department about the progress of conversion every hour. Provide resolutions to time-sensitive ad-hoc requests for information from management. Optimization of SQL queries, and performance tuning by using Explain plan and Analysis. Fixing the problems in PL/SQL code and any problems with DDL scripts for tables and indexes and escalating the issues in severe cases to the development and other support teams about possible impact on the application functionality. Responsible for Unit level testing, Module level testing and Application testing. Tuning Database and SQL for Optimal Performance, Redesign and build the Schemas to meet optimal Performance measures.
• 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.
• Provided production support and resolved production issues in a timely and efficient manner. Environment: Oracle 10g, PL/SQL, SQL Plus 10.1, SQL Loader, Toad 10.1, Erwin 4.1.4, Toad 10.1, Informatica Power Center 7.x/6.2/5.1, OLTP, SQL Navigator 5.0, Oracle Forms 6i, Reports 6i.

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.
• 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
• UNIX Shell Scripts for cron jobs and batch programs to generate reports. Used ERwin as the data-modeling tool to re-engineer the existing database, to define relationships, implement business rules as constraints

Environment: Informatica 6.2, Oracle 9i/8i, PL/SQL, SQL Navigator 5.0, SQL Loader, Erwin and Windows

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Participated in logical and physical database design and developed the logical dimensional model s using Erwin 4.0.
• Documenting business requirements, functional specifications and test requirements.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse, Oracle Warehouse Builder OWB , OBIA/OBIEE.
• Involved in user requirement and requirement specification from users for outbound calling and Campaign Management modules
• 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.