SUMMARY:

• Over 7 years of software programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using ORACLE Relational Database Management System(RDBMS).
• Expertise in SQL and PL/SQL programming, developing complex code units
• Solid experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating and migrating data sets in Oracle.
• ORACLE SQL and PL/SQL certified.
• Worked on databases Oracle 8i/9i/10g/11g.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Cursors.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Experience in Performance tuning of SQL and PL/SQL scripts
• Experience with scheduling jobs using tools like Autosys and Informatica.
• Experience in UNIX scripts.
• Extensive experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter Tools.
• Experience working on Mappings, Transformation, Expressions and Mapplets.
• Experience integrating various data sources like Oracle, SQL Server, Flat Files, SAP into the data warehouse.
• Excellent functional and technical knowledge in addition to customization experience.
• Experienced in analyzing functional requirements and translating them into Technical Designs and Documentation.
• Good exposure to development, testing, debugging, implementation, documentation, user training & production support.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2012, DB2, MS Access, SAP

ETL Tools: Informatica PowerCenter 9.5.1/8.6.1/7.1.3/6.1

Database Utilities: Toad for Oracle10g, SQL*Loader, SQL Developer

Languages: SQL, PL/SQL

Web Technologies: HTML, DHTML, XML

Operating Systems: Windows 9X/2000/XP/2K8/Vista/7/ NT, MS - DOS, HP-UX, Unix, IBM AIX 4.3/4.2

PROFESSIONAL EXPERIENCE:

Confidential, GE

Informatica and PL/SQL Developer

Responsibilities:

• Interact with Process teams to understand the business requirements and translate them into Technical design documents
• Work closely with data population developers, multiple business units and a data solutions Engineer to identify key information.
• Designed Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source, Stored Procedure, Router Transformation to transform and load the data from and to flat files and relational tables.
• Involved in developing the technical documents from functional specifications.
• Identified requirements for Mappings and engaged in designing robust mappings and created reusable Mapplets for lookups
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager
• Involved in writing UNIX shell scripts to Transfer the files between multiple systems and to load data from files to database.
• Imported data from Excel Workbook through Informatica. Also, send daily feeds through FTP.
• Involved in Analysis, Meeting with Business Partners in Agile Development team.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Worked on database connections, SQL joins loops, aliases, views, aggregate conditions and wrote various PL/SQL procedures, Functions and Triggers for processing business logic in the database. Tuning of SQL queries for better performance.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through SQL Queries.

ENVIRONMENT: Informatica PowerCenter 8.6.1, Informatica Web Services, UNIX Shell, Oracle 10g/11g, Flat Files, XML Files, SQL and PL/SQL, SQL Assistant, Teradata V2R4/V2R6, Toad, Oracle Server, SQL Developer, HP Quality Center, Maestro Scheduler, Linux.

Confidential

Sr Software Engineer

Responsibilities:

• Major and Minor enhancements to the existing system, BUG fixing and providing Production support/ Maintenance.
• Understanding the requirements and providing better solution approach along with alternate approaches.
• Preparation of document of understanding and estimates and review of the same.
• Automated the existing manual process and implemented new process for recurring tasks.
• Implemented UAT and FUAT for the newly implemented changes in the existing system.
• Providing support for the client during FUAT testing and extensively continued the support till the Production movement.

Confidential

Software Engineer

Responsibilities:

• Requirement gathering and documenting requirements using Industry standards
• Creating data base procedures, functions and packages based on requirements.
• Design and development of forms
• Developing Unit test plan and executing it
• Production support.

ENVIRONMENT: Informatica Power Center 6.1, Business Objects 6.1,Oracle SQL, PL/SQL UNIX shell scripts,Oracle9i

Confidential

Software Engineer

Responsibilities:

• Understanding the Functionality and Detailed design.
• Developing code for integration of all the modules.
• Writing database procedures and unit testing of the new enhancements
• Integration testing for various modules
• Maintaining quality procedures related to the project.

ENVIRONMENT: Oracle 9i, PL/SQL, Excel, Windows XP.

Confidential 

Software Engineer

Responsibilities:

• Analyze functional requirements and create technical design.
• Design and Development of forms
• Creation of stored procedures for running batch process
• Testing - unit testing & integration testing

ENVIRONMENT: Toad, Oracle 8i, MS SQL Server 2000, PL/SQL, Windows NT, Windows XP