SUMMARY

Five (5) years of experience in providing Information Technology Solutions in Oracle Reports / Forms developer, PL/SQL, SQL and in Datawarehousing which involves, gathering business requirements, develop comprehensive business solutions, that meet current and future business needs, application testing, quality assurance testing, coordination during UAT, training the users and implementation.

• Five years of Professional experience in analysis, design, development and implementation of Client/Server applications.
• Highly Experienced in SQL, SQL*Plus, PL/SQL, SQL Developer, TOAD, C, UNIX, and Reporting tools like Oracle Report Builder.
• Very strong in full suite of Oracle Tools, Developer 2000, Forms 6i, Reports 6i, PL/SQL, SQL and extensive experience in Database Development in Oracle 9i/10g.
• Sound understanding of Software Development Methodologies and Software Development Life Cycle (SDLC).
• Achieved better outcomes by debugging the code with various test cases.
• Participated in Performance tuning, Backup and Recovery, Database Design, Installation, configuration, Trouble-shooting.
• Write, review and provide input to test plans, test cases, create and execute regression and acceptance test suites.
• Provide quality assurance on product releases.
• Excellent with PL/SQL, Stored Procedures, Packages, Database Triggers.
• Maintained good interaction with business users/end users.
• Organized, Detail-minded, Trouble-shooting, Interpersonal, Analytical, Oral and Written Communication skills.
• Self-motivated and honest with a positive attitude to meet/exceed goals unsupervised and in a team oriented Environment.
• Good team player with excellent communication, written and presentation skills with strong aptitude towards learning new technologies.
• Excellent Time-Management Skills, Recognized for the Ability to handle Multiple Time-sensitive Tasks simultaneously.

Skill Set

• Oracle Tool : Forms/ Report Builder 6i/9i
• Data warehouse Tool : Oracle Warehouse Builder 10g R2
• Data Modeling Tool : Erwin
• Databases : ORACLE 10g / 9i , MySQL , PostgreSQL
• Operating Systems : Windows Vista/XP/2000/NT/9x , UNIX , LINUX
• Tools & Utilities : TOAD, SQL* PLUS, SQL Developer
• Languages : PL/SQL, SQL, C, C++, JAVA
• Web Tools : PHP, HTML, Javascript, CSS
• Web Server : Apache 2.0
• Quality Exposure : SEI CMM Level 5 & ISO standards
• Software Engineering Concepts : Software Architecture, Design, Metrics,

Software Testing and Project Management

Education

Bachelor of Technology (B.Tech

Professional Experience

Role Played : Database design Developer
Duration : Apr 08 – Mar 09
Company : Confidential,
Environment : (Financial/Insurance/Investment domain)
SQL, PL / SQL, SQL * Plus, UNIX, Toad,
SQL Developer, ETL, Oracle Warehouse Builder 10g R2 in

Responsibilities:

• As a member of database design team, participated in requirements gathering, analysis and data modeling.
• Capturing business requirements, automatic code generation and maintain database objects.
• Propose ideas for increasing coverage and work with team to develop the plan and to implement.
• Created stored procedures, functions and database triggers using PL / SQL for Code reusability.
• Solid ETL development experience with complex data transforms & derivations.
• Block level and item level validation triggers were used to validate the information.
• Participated in the development of user documentation and training manuals
• Maintained database for customer, vendor and employees.
• Master database tables like department, position, employee details etc were maintained and all the transaction between master tables were implemented using the transaction (Detail) tables.
• Analyzing the source systems requirement and providing them the data in the form of tables as part of operational data store (ODS) database.
• Involved with the design, creation, data population and maintenance of tables, views and OWB mappings.
• Design and maintain automated tests that uncover both the obvious and not-so-obvious problems
• Data from multiple source systems is Extracted, Transformed and Loaded into ODS from Staging Area by using different transformations like Filter, Joiner, Splitter, Expression, Aggregator, Constant, Lookup, Pre and Post mapping Transformations.
• Involved in creation of Star Schema, Snow Flake Schema using Erwin tool.
• Creation of SQL scripts, procedures to populate the interface tables to cater the needs of source systems.
• Actively participated in the QA process through requirements/design analysis and the development of test strategies and test plans
• Created and executed regression and acceptance test suites
• Involved in Batch Processing and Scheduling using DBMS scheduler.
• The ODS along with BI tools, provide a single repository for all information which will help monitor business performance and provide decision support.

Role Played : Oracle Reports Developer
Duration : Jun 06 – Mar 08
Company : Confidential,
Environment : Oracle 10g, SQL, PL / SQL, SQL * Plus, UNIX, Toad,
Report Builder 6i
(Banking / Finance / Investment/ Insurance domain)

Responsibilities:

• Gathering the requirement from the client and translating the business details into technical design.
• Analyzing the software requirement.
• Creation and maintenance of Oracle Developer Forms and Reports using Oracle Forms / Report Builder 6i.
• Testing and preparing data for developed Forms / Reports.
• Providing client support including bug fixing during User Acceptance Testing at client site.
• Providing Data Correction SQL scripts as required.
• Providing production support after the system was delivered to the client. Assist in maintaining test environments, Promote defect resolution
• Creating database objects such as Packages, Stored Procedures, Triggers, Views etc
• Creating collections like Nested Tables, varrays and Pl / Sql records.
• Creating the REF Cursors and using them in the procedure and Functions.
• Using the dynamic SQL in program units and blocks.
• Identifying and trouble shooting application code – related issues.
• Working with built - in packages.
• Analysis of existing SQL Queries which require tuning and modifications.
• Creating explicit cursors for data retrieval and processing of data.
• Prepare and write documentation for programs and systems.
• Creating views using complex queries on the base tables
• Creating Procedures, Functions and Packages.
• Handled pl / sql runtime errors using exceptions.
• Creating Database triggers and instead of triggers
• Controlling access to information by defining permissions.
• Creating technical documents in support of the programs developed.
• Use PL / SQL to perform various calculations.
• Created Unit Test and User Acceptance Test Plans.
• Creating complex queries using outer joins, sub queries, inline queries and views.
• Creating transactions for processing statements in pl / sql.
• Performing sql operations with native dynamic sql.

Role Played : IT Associate
Duration : Jul 04 – Oct 05
Company : Confidential,
Environment : PHP, LINUX, Postgresql, MySQL, HTML, CSS

Responsibilities

• Requirements gathering and Translation of business requirements into effective systems specifications for the development
• Designed and developed Process flow diagrams, ER-diagrams, created logical and Physical design for the application database.
• Designed the front end for the project using HTML pages.
• Designed web based applications using PHP, JAVASCRIPT, CSS and MySQL according to the client’s requirements.
• Planning the whole system to build a prototype before the actual implementation.
• Documented the project business rules, functional and technical designs, user guides hardware and software changes.
• Coding and testing at all stages in the project.
• Deployed the system successfully at the client’s location.