SUMMARY

• Over 9.4 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in Client - Server application development using Oracle 11g/10g PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Data migration using golden gate
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Proficient using ETL informatica power center tools (designer, workflow manager, workflow monitor, repository manager) and oracle database.
• Expertise in developing and running mappings, sessions/tasks/Workflows, Worklets
• Experience in designing reusable transformations in informatica such as joiner, sorter, aggregate, expression, lookup, Router, Filter
• Experience in creating several workflows using informatica PowerCenter
• Experience in identifying bottlenecks in ETL processes and performance tuning of applications using database tuning, partitioning, Index usage, Load strategies, commit interval
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Languages: SQL, PL/SQL , Unix shell scripting, Java basics

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL , Stored Procedures, Triggers)

Database tools: TOAD,SQL manager for Oracle, SQL developer, Golden gate

ETL Tools: Informatica Power Center 9.5.1

Operating Systems: Windows /Unix

Other Tools: TOAD, Eclipse, Dimensions

Statistical Tools: IBM SPSS

Automation tools: UI Path

PROFESSIONAL EXPERIENCE

Confidential

ETL and PLSQL developer

Responsibilities:

• Extracted data from excel files, high volume of data sets from data files, Oracle using Informatica ETL mappings/SQL PLSQL scripts and loaded to staging area
• Created Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded to different targets.
• Created re-usable transformations/mapplets and used across various mappings
• Reviewing the work and submitting the work to client with sufficient documentation
• Created timelines for project completion
• Writing the complex SQL queries to retrieve and update the data along with the stored procedures in Oracle 10g databases.
• Responsible for Planning and Tracking and able to manage multiple projects.
• Apart from working on resolving support tickets, my duties involve constantly monitor all existing systems and actively identify ways to semi-automate or automate existing processes with quick turnarounds.
• Participated in project team discussions on product design and presenting test results to engineering teams and management.
• Providing support for the development and support activities.
• Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements into technical specifications and coordinating with the offshore team for development.
• Understanding changing business needs and providing the impact analysis.
• Provide all technical support during the implementation of new features and modules as needed.
• Conducted code review for fit gap done by the team members.
• Acquires, monitors and uses client feedback.

Environment: Oracle 10g, Informatica PowerCenter 8.5.1, Putty, Rational clear case, Autosys

Confidential

ETL and PLSQL developer

Responsibilities:

• Interact with Business users to get business requirements.
• Gathering information from various source system applications and preparation of the data conversion and technical design documents.
• Involved in liaising with the clients for requirement understanding and timely delivery of project
• Extracted data from excel files, high volume of data sets from data files, Oracle using Informatica ETL mappings/SQL PLSQL scripts and loaded to staging area
• Created Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded to different targets.
• Created re-usable transformations/mapplets and used across various mappings
• Handling of CR's (Change Requests) and enhancements for existing application and followed change management process
• Reviewing the work and submitting the work to client with sufficient documentation
• Created timelines for project completion
• Writing the complex SQL queries to retrieve and update the data along with the stored procedures in Oracle 10g,12C databases.
• Responsible for Planning and Tracking and able to manage multiple projects.
• Apart from working on resolving support tickets, my duties involve constantly monitor all existing systems and actively identify ways to semi-automate or automate existing processes with quick turnarounds.
• Participated in project team discussions on product design and presenting test results to engineering teams and management.
• Providing support for the development and support activities.
• Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements into technical specifications and coordinating with the offshore team for development.
• Understanding changing business needs and providing the impact analysis.
• Provide all technical support during the implementation of new features and modules as needed.
• Conducted code review for fit gap done by the team members.
• Acquires, monitors and uses client feedback.

Environment: Oracle 10g,12c, Informatica PowerCenter 9.6.1, Putty, Eclipse, Dimensions, Putty, BMC remedy, Service now

Confidential

ETL and PLSQL developer

Responsibilities:

• Requirement analysis, creating architecture and design for the application, analysis and implementation of enhancements to the existing system, providing suggestions on add-ons, supporting, testing and monitoring the application for the client.
• Involved in liaising with the clients for requirement understanding and timely delivery of project
• Writing the complex SQL queries to retrieve and update the data along with the stored procedures in Oracle 10g,11g databases.
• Responsible for Planning and Tracking and able to manage multiple projects.
• Apart from working on resolving support tickets, my duties involve constantly monitor all existing systems and actively identify ways to semi-automate or automate existing processes with quick turnarounds.
• Participated in project team discussions on product design and presenting test results to engineering teams and management.
• Providing support for the development and support activities.
• Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements into technical specifications and coordinating with the offshore team for development.
• Understanding changing business needs and providing the impact analysis.
• Hands on experience on designing the new interfaces.
• Provide all technical support during the implementation of new features and modules as needed.
• Conducted code review for fit gap done by the team members.
• Acquires, monitors and uses client feedback.

Environment: Oracle 10g, Informatica PowerCenter 9.6.1, Putty, Eclipse, Dimensions, Putty, BMC remedy, Service now

Confidential

ETL / PLSQL developer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Mapping & Mapplet Designer and Transformation Designer.
• Interact with Business users to get business requirements.
• Worked with different Informatica transformations like Aggregator, Lookup, Joiner, Filter, Router, Update strategy, Transaction control, Union, Normalizer in ETL development.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support. scheduling Informatica jobs using Informatica, Windows scheduler and with Unix.
• Installation, Configuration, and Administration of Informatica Power Center 9.6
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Performance tuning of Informatica (sources, mappings, targets) and tuning the SQL queries.
• Parsing high-level design specification to simple ETL coding along with mapping standards.
• Perform data population tests against target system to ensure accuracy and quality of data
• Perform unit testing on deliverables and documenting the UTC
• Identify source data quality issues and resolve discrepancies
• Migrating the etl workflows, mappings and sessions to QA environment and providing instructions for production deployment.
• Writing unix scripts to extract data from other sources to a flat file
• Involved in Development of the applications through Oracle using Pl/SQL created Tables, views and SQL Queries.
• Well acquainted with Oracle base technologies like SQL, PL/SQL.
• Have written PL/ SQL scripts (indexes, Procedures, Sequences, Triggers, and Packages).
• Involved in analyzing the changes and enhancement requirements and preparing the required technical specifications.
• Involved in the preparation and updating of system & project related documents
• Involved in unit testing, system integration testing and user acceptance testing of the system
• Involved in coordinating the testing team and support team and providing solutions when needed
• Involved in writing and executing scheduled job scripts and coordinating with report generating teams in times of necessity for data fetch and data accuracy
• Created PL/SQL database triggers to implement the business rules in the application.
• Created materialized views for performance reasons.
• Used Toad, PL/SQL developer tools for faster application design and developments.
• Worked on developing oracle forms 11g for invoice creation module.
• Specified which users can access databases and what data can be accessed by user.
• Responsible for creating various application usage reports based on the data available in DB tables.
• Experience in application development and production support of large and critical network with 24/7 uptime.

Environment: Tools and Technologies: TOAD, SQL manager for Oracle, SQL Developer, Informatica power center 9.5, Informatica power center 9.6, Dimensions, Putty, BMC remedy, Service now