Summary:

• Experience in Performance tuning of targets, sources, mappings and sessions, SQL Query Tuning, Creation of Indexes for faster database access and query performance.
• Experience in writing the stored procedure to implement as per business requirement.
• Experience in utilizing oracle Utility tools SQL Loader.
• Experience in retrieving the data by writing simple/complex SQL Queries
• Experience in End-End application development using Oracle 11g/10g/9i, PL/SQL, SQL PLUS
• Knowledge in using Normalization and De-Normalization Techniques for Data modeling logical and Physical .
• Experience in reducing loop overhead by writing DML Select, Insert, Update Statements using FORALL statement
• Experience in fine tuning of SQL Queries using Explain Plan, SQL Trace on Oracle 11g/10g/9i databases.
• Experience in developing complex database objects such as: Functions, Packages, Stored Procedures, Database, Materialized Views using SQL, PL/SQL.
• Experience in using PL/SQL in writing complex queries, across multiple databases, stored procedures, user defined functions, triggers in large-scale relational database environment.
• Involved in SDLC like analysis, design, development, testing, implementation and maintenance providing timely delivery against strict deadlines.
• 7 Years of experience as IT Professional in designing and developing Applications according to Business Requirements using Oracle RDBMS Relational Database Management System .
• SQL Performance Tuning using Cost Based Optimization, Rule Based Optimization.
• Experience in handling various errors using exceptions
• Experience in application development of the database using TOAD.
• To improve performance: Planned, Designed and Implemented Table Partitioning.
• Worked on Informatica Power Center tools Repository Manager, Designer, workflow Manager and Workflow Monitor.
• Good experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, XML, Oracle.
• Experience with Data Warehousing concepts -Star Schema, Dimensions and Fact tables.

Technical Skills:

• RDBMS Oracle 11g, 10g, 9i
• Operating Systems/Platforms UNIX, Windows XP/7/8/8.1
• ETL Tools Informatica Power Center 9.0
• Programming Languages SQL, PL/SQL, C, C .NET
• Web Technologies HTML, XML
• Scripting Language XML, Shell Scripting
• Other Tools SQL PLUS, SQL Loader, MS Visual Studios

Experience Summary:

Confidential

Oracle Developer

Responsibilities:

• Hands on experience for performance tuning on existing SQL to improve application performance.
• 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.
• 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 and AWR reports 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 11g, SQL, PL/SQL, SQL Plus, SQL Loader, SQL Developer, Shell Scripts, UNIX, Windows.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Converted user requirements into formal Functional specifications while interfacing with the client.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g, UNIX, PL/SQL, Shell Script, Windows, Clear Case, Clear Quest, Unix Shell scripts, SQL navigator, SQL Loader.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Design and develop PL/SQL procedures/functions/triggers which carry out data flow to respective schemas meant for different client data models.
• Logical and Physical Data modeling and designing, writing server side stored procedures/ triggers.
• Develop PL/SQL procedures to perform business validation checks on the data for master-detail, default value integrity constraints. Developed code using collections, cursors and file search.
• Analyze the Existing code and make new Enhancement as per different customer's request. Developed complicated SQL queries and database performance tuning. Bulk DML operation, Dynamic cursor, Ref Cursor, Partitioning, SQL tuning using explain plan, Tkprof and autotrace.
• Developed and maintained purging data for different level of pricing aspects by PLSQL developer and passed through the shell scripts in application level for user interface.
• Created several UNIX shell scripts calling various PL/SQL packages and procedures to perform the business rules.
• Create and manage work orders forms/reports .Allow customers to directly enter work requests online by web based application .Assign subcontractors to work orders and track status of work orders online
• On the job field benefits such as scan in customer signatures, work request reports, online document storage and more. Fully customizable applications available in addition for a complete business solution. The data in XML format transferred by JDBC connection to oracle.
• Developed Business objects with backend function in PL/SQL called by scheduled UNIX shell scripts.
• Implementation and Testing involved in data integration, unit testing and integration testing.

Environment: Oracle 10G, SQL, PL/SQL, UNIX, XML

Confidential

Informatica Developer

Responsibilities:

• Developing the mappings using needed Transformations in Informatica tool according to technical specifications to populate the data into VDS tables from Source systems.
• Developing and implementing the coding of Informatica Mapping for the different stages of ETL Extraction Transformation and Loading .
• Developing various Mappings to load the data from various sources by using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Sequence Generator to load the feeds data.
• Fixing the invalid Informatica mappings and troubleshoot the technical problems of the database.
• Development of Informatica Mappings to accomplish Auditing and Error handling of VDS load.
• Developing Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Debugging the Informatica sessions by utilizing the logs of the sessions.
• Creating UNIX shell script for the start and stop procedures of the sessions. Performing unit testing at various levels of the ETL.
• Experience in identifying the bottlenecks and fine-tuned the mappings.
• Optimizing performance tuning at source, target, mapping and session level.

Environment: Informatica 9.0, Oracle 9i, SQL, PL/SQL, windows and UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 8i, Developer 2000 and PL/SQL.
• This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database.
• Define database structure, mapping and transformation logic. Creation of External Table scripts for loading the data from source for ETL Extracting Transforming and Loading Jobs.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Developed new and modified existing packages, Database 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.
• Used TOAD and SQL navigator extensively.

Environment: Oracle 8i, SQL, PL/SQL, UNIX, ERWIN