SUMMARY

• A Technology driven IT professional with over 7 of years of experience in designing and developing Complex applications, developing Reports for Internet/Intranet based applications using Oracle.
• Experience using SQL in a large-scale relational database environment complex queries, across multiple databases, stored procedures, user defined functions, triggers.
• Expertise in writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, fine tuning of SQL Queries using Explain Plan, SQL Trace on Oracle 9i/10g/11g databases.
• Expert in creating appropriate Triggers to facilitate efficient data manipulation, data consistency and data validation.
• Wrote dynamic SQL queries to generate inserts statements to populate tables.
• Wrote DML statements insert, update, delete using FORALL statement to reduce loop overhead.
• Wrote stored procedures to automatically create tables depending on their existence in the database.
• Developed in line Views, in built Packages, Functions and clauses.
• Experience in gathering business requirements and converting them into functional, technical specifications and developed mapping documents to map source systems to the Data Warehouse Model.
• Business intelligence solutions using ETL,BI reporting, ETL mappings and OLAP applications.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files using Informatica.
• Strong experience in Data Warehousing using Informatica Power Center 8.6.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 8.x.
• Experience creating Informatica mappings to extract, transform and load data from Oracle and SQL Server Sources onto the data warehouse.
• Working experience in Dimensional Data modeling using Star and Snow Flake schema
• Entity Relationship diagrams and Data modeling using Toad and Visio.
• Experience in Performance Tuning sources, mappings, targets and sessions , SQL Tuning, Table Space Partitioning, creation of indexes for faster database access and better query performance.
• Database monitoring and tuning using Explain plan TKPROF and oracle optimizer hints and SQL Query tuning, DBMS scheduler.
• Planned, Designed and Implemented Table Partitioning for improving performance.
• Expertise in utilizing oracle Utility tools SQL Loader, Import and Export.
• Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• Excellent Analytical, Programming and Reporting skills.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
• Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Programming Languages : PL/SQL, SQL, C, C , Core Java

Web Technologies : HTML, HTML5, XML

Scripting Language : Shell Script, XML, CSS, Java Script,

Database : Oracle 10g/11g, SQL Server, Ms Access 2000.

ETL : Informatica

Operating Systems : Windows 95/98/NT/XP/Vista, Windows 2007, Windows 8,

UNIX, Linux

Versioning Tool : SVN, Team Foundation server 2010 / 2008, Rational Clear

Case

Tools/Utilities/IDE : Oracle Warehouse Builder, Tableau 5/6.0, Qlikview, SQL

Developer, SQLNavigator, SQL Plus, SQL Loader, TOAD, AQT Advanced Query Tool , Oracle forms and reports 9i

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the requirements of the client and wrote design specifications for program enhancements.
• Involved in complete SDLC of the new project.
• Involved in preparing technical documentation for development of code and process flow.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Created Tables, Synonyms, Sequences, Used Database trigger for making history of insertion, updating, deletion and all kind of Audit Routines Enforced database Integrity using primary keys and foreign keys.
• Involved in SQL Performance tuning using Oracle hints and Parallels in order to get the faster output.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance.
• Extracting, Transferring and Loading the data for the Warehouse using UTL FILE and Sql Loader.
• Responsible for writing SQL scripts in SQL Developer.
• Exported data from different sources into the database using External Table method.
• Developed the code as per the client's requirements using SQL, PL/SQL and Data Ware housing concepts.
• Worked extensively on Exception handling to trouble-shoot PL/SQL code.
• Involved in designing and developing oracle forms and reports for both oracle applications and custom development.
• Involved in DBA activities like creating users, roles and granting, revoking privileges.
• Created and Modified existing functions and procedures based on business requirements.
• Handover the final code and output to the client within the time line.
• Communicating the client about project related queries.
• Assuring the client with 100 Quality and Accurate output.

Environment: Oracle 11g/10g, SQL, PL/SQL, Oracle SQL Developer, Unix Shell scripts, Sql Loader, TOAD, Windows.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Studied user requirements and converted them into formal Functional specifications while interfacing with the client.
• Worked to define the project implementation strategies.
• Responsible for System Analysis, Development and support for ATLAS.
• Involved in Designing and Partitioning of the tables in the database along with DBA as a part of performance tuning.
• Involved in writing PL/SQL Packages, Functions and Stored Procedures and DB Triggers and Developed database objects like tables, views, indexes, and sequences.
• Responsible for back end stored procedures development using PL/SQL predefined Procedure.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Extensively developed PL/SQL sub-programs with features like FOR ALL, bulk collection for high performance of stored procedures.
• Understood complex performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Loading of the data from different data sources like CSV, XML, FLAT files etc, to oracle database using SQL Loader.
• Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
• Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL Loader.
• Created indexes, materialized views to improve the system performance.
• Used different oracle utilities such as explain plan, Sql trace, Oracle hints for Cost based optimization of the query to increase the system performance.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting.
• Used RAISE APPLICATION ERROR, PRAGMA EXCEPTION INIT to capture error Messages.
• Used PL/SQL Built-in Packages DBMS STANDARD, DBMS OUTPUT
• Developed forms and reports using Oracle Forms and Reports Builder 10g
• Wrote SQL Scripts for reports and creating views for reports.
• Involved in Developing and Customizing Forms and reports based on the requirement
• Prepared Technical specifications documents and Application Design documents

Environment:

Oracle 10g/11g, PL/SQL, SQL LOADER, Oracle Streams 10g Replication , SQL PLUS, Oracle Forms 10g, Reports 10g, SQL Server SSIS, TOAD, XML.

Confidential

Oracle SQL Developer

Responsibilities:

• Hands on experience for performance tuning on existing SQL to improve application performance.
• Involved in all phases of SDLC as active participant.
• Has a very good exposure on technical documentation.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Expertise in creating functional/technical specifications, testing scenarios, preparing test cases.
• Involved in project plan and Risk plan.
• Hands on experience on database design, detailed design, and ETL development.
• Created Materialized views for summary reports and extracts for better query performance.
• Used various Indexing and partition techniques to improve the query performance.
• Strong experience to analyze the existing and proposed systems.
• Based on requirements estimations provided for new development and enhancements.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Implemented SQL and PL/SQL stored procedures.
• Exposed on UNIX scripts and environment.
• Hands on experience to create views, stored procedure, Packages.
• Interacted with business analyst and software developers for bug reviews and participated in QA meetings.
• Used Explain Plan to tune the complex queries and debug the queries to provide exact solution.
• Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
• Prepared test case, test results and reviewed.

Environment: Oracle 10g, UNIX, PL/SQL, Shell Script, Windows XP, Clear Case, Clear Quest, Unix Shell scripts, SQL navigator, Sql Loader, Microsoft Visual web developer 2009.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed complex applications using PL/SQL, Oracle Forms and Reports to suit business needs
• Responsible for creating stored procedures, packages, functions and triggers.
• Generated PL/SQL packages with dynamic SQL queries as per the requirements.
• Successfully created various Database Objects such as temporary tables, PL/SQL tables, views, materialized views, Indexes, sequences.
• Performed Database Application Level Tuning and Coordinated directly with the end users to understand the Business Requirements and convert them into functional and technical specifications.
• Proved to be a responsible resource to handle performance tuning of SQL queries and PL/SQL stored procedures using Indexes and optimizing hints.
• Drew ER diagram and workflow chart for better understanding.
• Extensively used the Oracle utilities such as Export/ Import, SQL Loader, SQL Trace, TKPROF and day-to-day activities of different databases.
• Design and Developed Customized Reports.

Environment: Oracle 10g, PL/SQL, Oracle For 10g, Oracle Reports 10g ,Oracle SQL Developer, SQL Plus, SQL Loader, TOAD.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement Gathering and Business Analysis for creating a data warehouse
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Monitored Workflows and Sessions using Workflow Monitor.

Environment: Oracle 9i, Windows 2000, SQL Developer 1.1, Oracle forms 9i, Erwin Data Modeler, Informatica Power Center Tool.