SUMMARY

• Over 6+ years of programming experience in the development of client/server applications using Oracle Database, SQL and PL/SQL on different platforms like Windows2000/XP, UNIX, Linux including Data Warehousing using Informatica Power Center.
• Experience with SDLC process of performing detailed analysis, collecting use cases, documenting requirements and creating design of Object - Oriented applications.
• Expertise in developing business applications using Oracle SQL,PL/SQL 9i, 10g, 11g, 12c and Forms 6i, 9i, 10g, 11g.
• Hands on experience in SQL and worked on stored Procedures, Functions, Packages and Triggers.
• Strong knowledge in Oracle 12c/11g/10g/9i database programming using PL/SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built-in Oracle Packages
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Highly motivated with excellent interpersonal, communication and leadership skills
• Skilled in Performance Tuning, Error Handling and Production Support.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels and quick adaptability to new technologies.
• Trouble shooting and problem solving applications with Informatica Debugger, used debugger to test the data flow and fix the mappings.
• Identified the errors by analyzing the session logs.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Proficient in translating business requirements into logical data models, creating modularized enterprise applications
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing technical design specifications.
• Strong experience with Unix Shell Scripting, worked on Production Support, receiving production calls, troubleshooting the application and resolving bugs.
• Excellent analytical, problem solving skills, with ability to interact with individuals at all levels.
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Good experience in building Web and Windows applications.
• Good understanding of Object Oriented Programming (OOPS) & Software Design Patterns.
• Expertise in extraction, transformation and loading of data directly from different heterogeneous source systems like SQL Server, Oracle, Flat files (Fixed width & Delimited), XML files.
• Used various kinds of the transformations to implement simple and complex business logic. Transformations used are: Lookup, Router, Expressions, Source Qualifier, Aggregator, Filter, Union, and Sequence Generator Update Strategy.

TECHNICAL SKILLS

Databases: Oracle 8i, 9i, 10g, 11g,12c, MS Access, MS SQL Server 2012/2008/2005

Programming: SQL, PL/SQL, C, UNIX Shell Scripting

Data Modeling Tools: Erwin 7.4, Designer 2000, Microsoft Visio 2003, Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, OLAP, OLTP.

ETL Tools: Informatica 9.x/8.x/7.x-Power Center

Operating Systems: UNIX, Windows 7/8/XP

Front-End: Oracle Forms and reports /6i/9i/10g/11g, Crystal reports 9/10

Database Tools: TOAD, SQL*PLUS, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, NY

PL/SQL Developer

Responsibilities:

• Involved in design and development of business requirements and prepared requirement specification document.
• Exposure to the entire process of Software Development Life Cycle.
• Participated actively in user meetings and collected requirements from users.
• Provided support for sustained projects in production environment in case of any errors or glitches.
• Developed optimized SQL queries and PL/SQL procedures, functions to implement business logic.
• Extensive experience in creating and maintaining Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link based on business requirements.
• Designed Informatica ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the existing system.
• Designed Mappings, Sessions and Workflows using Informatica Power Center Tool to load the data from Sources such as Oracle, Flat files, XML files into Data Warehouse (DWH) model.
• Involved in handling Errors and Transaction Processing in the Procedures.
• Modified the existing reports to suit the new requirements.
• Used SQL*Loader to download the data into database from the text files.
• Participated in the DBA activities like Creating Users, Granting and Revoking Privileges on database objects and taking backups.
• Testing the Performance of the database.
• Enforced database integrity using Primary keys and foreign keys.
• Involved in code reviews and acceptance testing of the application
• Involved in analyzing the table statistics and Table partitioning.
• Participated in daily status update meetings with the team.

Environment: Oracle 11g, 12c, Informatica Power Center 9.5.1/9.0.1, SQL, PL/SQL, UNIX, SQL*Loader, SQL*Plus, SQL Developer, TOAD, SQL Server 2012, Flat files, XML files.

Confidential, VA

PL/SQL Developer

Responsibilities:

• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated in the Design Team and user requirement gathering meetings.
• Worked on Star Schema approach throughout the project.
• Responsible in data migration and data corrections from old systems to new systems.
• Responsible for development, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Analysis and design for software using industry standard modeling tools.
• Translated business requirements into Technical Design and documentation.
• Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
• Created and running the shell scripts to run the Processes at time scheduled according to business rules.
• Prepared and scheduled Reports for printing and sent Reports with emails.
• Generated Complex Packages, Procedures, Functions and Triggers for Business Logic Using PL/SQL.
• Troubleshooting applications and resolving bugs/issues.
• Monitor production jobs and if there is any issue then investigated the root cause of the issue and resolved it within service request deadline.
• Coordinated team efforts like handing over, tracking the timelines and reviewing the code and performing testing sessions and met the business requirements and client standards.

Environment: Oracle 11g/10g, Informatica Power Center 9.1/9.5, MS SQL Server 2008/2012, UNIX, TOAD, SQL*PLUS, SQL, PL/SQL.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in gathering the requirements and documented high level documentation for the project.
• Developed and implemented database triggers, stored procedures within Oracle database.
• Involved in database design, tuning, triggers, functions, materialized views, Oracle Job Scheduler.
• Created stored procedures, functions, Packages, Database triggers, constraints, indexes, grants, materialized views, sequences based on business requirements.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Applying constraints and writing triggers to apply the business rules.
• Imported various Sources, Targets using Informatica Power Center.
• Involved in handling Errors and Transaction Processing in the Procedures.
• Worked extensively to build and run Work flows with Informatica Workflow Manager and monitored the statistics using Informatica Workflow Monitor.
• Involved in code reviews and acceptance testing of the application.
• Involved in Data migration using SQL* Loader from flat files in to data base tables.
• Developed and optimized SQL queries and PL/SQL scripts to implement business logic.

Environment: Oracle 10g, Informatica Power Center 8.6/9.1, SQL developer, TOAD, PL/SQL, SQL*Loader, MS SQL Server 2008

Confidential

Oracle Developer

Responsibilities:

• Coordinated with the team to study and gathered system requirements.
• Involved in designing the necessary table structures and table relations.
• Developed mappings using transformations like Filter, Joiner, Expression, Aggregator, Router and Lookup transformations.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures, functions, database links, reports and packages.
• Integration with other systems like Purchase & Inventory, Marketing, Raw material etc.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained the data integrity and security using integrity constraints and Database triggers. Involved in the application tuning of database by identifying the suitable Indexes.
• Solved day to day issues raised with SQL * Loader. Wrote Unix Shell scripts in UNIX.
• Assisted in production support and also transferred knowledge to the other team members.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Designed the business logic to eliminate problems and to ensure efficient system functioning.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
• Tested the entire application in testing environment and exported to Production.

Environment: Oracle 9i, Informatica Power Center 8.1.2, DB2, SQL, PL/SQL, UNIX, TOAD, SQL*Loader, SQL*PLUS.