SUMMARY

• 7 years of Software industry professional experience in development of object oriented, n-tiered distributed and client/server applications and Web applications.
• Developed and designed the applications based on the n-tier architecture specifications. Experience with SDLC process of performing detailed analysis, collecting use cases, documenting requirements and creating design of Object-Oriented applications.
• Ability to interact at all levels in an IT organization to assess, evaluate, recommend a different and robust solution and lead through the development.
• Well proven track for achieving the timelines for deliverable in requirement changing environment.
• Experience working directly with customers to identify their business processes, rules, application user requirements and business process re-engineering.
• Expertise Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports and UNIX Shell scripting.
• Strong knowledge in Oracle 10g/9i/8i 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. Strong experience with Unix Shell Scripting worked on Production Support, receiving production calls, troubleshooting the application and resolving bugs.
• Good experience in building Web and Windows applications.
• Good understanding of Object Oriented Programming OOPS Software Design Patterns
• 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.
• 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.
• 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.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Ability to work in teams and independently with minimal supervision to meet deadlines.

Work Summary

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Design and developed EDI Manager Process to load files in real-time in VHOS system using SQL LOADER, PL/SQL Package, UTL File. These files provide twelve month historical data that need data cleansing, wrote API's in PL/SQL to upload the data in staging tables, later processing and enhanced error logging and reporting system using DBMS MAIL and custom API's.
• Modified Amendment reporting process and created multi-threaded job process design, using DBMS SCHEDULER and Advance Queuing AQ . This process is also tuned to perform optimal in 11g environment.
• Process Tuning of various Nightly jobs that we rarely analyzed for the use BULK collect and optimizing parameters and adjusting hint and index by reviewing the Trace files, after upgrade to 11g data base.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer, SQL Plus, Toad
• Developed ability for users to re-forecast job for specific contract and/or customer and generate variance report by creating materialized view that run through nightly job. Other support work
• Review and Fix open Bugs as reported from Phase-1 of LCF trueup.
• Fix open ticket as created by users that includes code modification and issue analysis.
• Provide support to user with Ad hoc queries for day to day business requirement.
• Provided test support for System Integration Testing SIT , Live and End to End testing to VHOS retails users.
• Troubleshoot performance issues and bugs within packages using traces file, explain plan and oracle database parameter tuning.

Environment: Windows 7, Oracle 11g, 9i, SQL, PLSQL, SQL loader, Toad, Visio, SQL Developer, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Worked on TFS ticketing system.
• Worked on procedures and packages.
• Made the Tree structure program to ensure data is flowing from database to database.
• Wrote complex SQL queries and sub-queries for faster data retrieval.
• Enhanced modified database objects like tables, views, stored procedures, functions and triggers.
• Used Bulk Collect and FOR ALL to insert/delete multi-row from table.
• Loaded data from various databases using SQL LOADER utility.
• Testing and debugging the existing procedures.
• Assisted in documentation of the Tech Specification and Use Case Specification.
• Implemented database triggers based on the business rules and requirements.
• Used exception-handling methods along with RAISE APPLICATION ERROR in order to associate our own created exception names.
• Worked with Bulk Collect collections to improve the retrieval of multi row.
• Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.
• Created Unit Test plans and involved in primary unit testing.

Environment: Oracle Solaris 5.8, PL/SQL, SQL Loader, Toad, Erwin 4.14/4.0, HP-UX 11i v3

Confidential

Oracle PL/SQL Developer

Responsibilities:

Designed the tables according the requirements Wrote Cron-Jobs for downloading the source files from sFTP Upload flat files to database using ETL tools like Informatica and SQL Loader Developed procedures to check validity of data according the business rules and fix them Write Script for data updating Daily Report Generation of Telephone Migration Project Status Production Support and Quality Control Oracle objects creation scripts DDL for database development to Test and Production environments Oracle PL/SQL design and tuning of stored procedures ETL Extraction Transformation Load of data from Oracle tables to flat files and from flat files to Oracle tables Prepared test environment for QA team to test the developed application from end-end PERL script conversion to Oracle PL/SQL package Developed tools to populate test data for Quality Assurance team Developed a framework for extensible automated production support in PL/SQL Attended business conference call with NEUSTAR team to understand the changes to the system Developed a framework to build restart ability in the system. Single point of contact for development and technical enhancements Documented the user guide for the system.

Environment: AIX, HP-UX, Windows, Oracle 9i,10g and 11g, UNIX, Toad 11.0, ETL, Git