View Bench List Portal

Similar candidates

• Rakesh Chandra Puli
• Jaweed
• Vamsy Chinnayaagri
• Sangireddy Rajith
• Aruna
• PARAS SURI
• Harish Manthena
• Mark McHugh
• Varma

• Involved in all the stages of Software Development Lifecycle (SDLC) – design, development, analysis, testing and deployment of application.

• Gathered the Requirement from the business use and prepared the program specification and design document for the development of the Application.

• Created the PL/SQL packages, procedures, functions applying the business logic to update the database with employees’ and to calculate payroll.

• Created custom triggers to automatically populate audit tables.

• Responsible for designing and developing key ETL processes.

• Created mapping Documents and Extensively used Informatica to extract, transform data from different source systems and load the data into the target database.

• Created Informatica mappings with PL/SQL Procedures, Functions to build business requirements

• Design and developed the scripts to create table, views, indexes and sequence.

• Created the custom tables to import the employee data and insert into the database.

• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.

• Extensively used DTS package in Migration of the data from the previous database in SQL Server database to Oracle 10g.

• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.

• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders

• Used FTP to transfer the files into different servers as needed by the business users.

• Involved in preparing functional document, user document, process flow diagram and flow charts

• Involved in preparing test plans, unit testing, System integration

• Created the test scripts and complex queries to test the application and to quality assurance of the data.

• Testing, implementation and maintenance.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, Informatica PowerCenter, TOAD, Visual SourceSafe, FTP, DTS package, MS- Office, UNIX, Shell Scripts, MS Visio.