Summary:

• QA Tester with extensive and diversified experience in the Financial, Telecom, Insurance and Pharmaceutical Industries, particularly has expertise at requirements gathering, data analysis, data mapping and user acceptance testing.
• Abundant hands on work experience with Oracle SQL, PL/SQL.
• Worked extensively on database objects like tables, views and synonyms.
• Expertise in using Oracle 8i/9i/10g databases
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and Indexes.
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Good Knowledge in RDBMS concepts and worked extensively on Oracle databases like Oracle 8i/9i/10g
• Working Knowledge on Unix Shell Scripting.
• Expert in automation tools like, Quick Test Professional, Win Runner, Load Runner, Rational Robot
• Expert in Test Management tools like Quality Center, RequisitePro
• Expert in Defect tracking Management tools Remedy, QC, ClearQuest PVCS
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Knowledge on DBA activities such as Performance Tuning, Backup and Recovery.
• Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management and issue escalations.
• Proficient in all cycles of test life cycle from test planning to defect tracking and managing defect lifecycle
• Experience on Logical Physical design of Databases, Data Modelling, Conceptual Design and Data Architecture and extensive use of Erwin and MS VISIO as a modelling tool. Understanding of Star Schema and Snowflake Schema.
• Sound understanding of other Relational and Normalized databases such as MS SQL Server, Sybase and MS Access.
• Excellent understanding in the working of the Data Warehousing Environment, its Components and Architecture.
• Technical documentation of different lifecycle deliverables and user manuals.
• Expertise in all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance.
• Proficiency in using MS Office including VBA Products and familiarity with SAS.
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
• Good team spirit and organized working habits with a willingness to learn new concepts.

Technical Skills:

Testing Tools : Quick Test Pro, Win Runner, Load Runner, Quality Center, Astra Quick Test, Rational Robot, Clear Quest, Rational Test Manager.

Languages : SQL, PL/SQL, Shell Scripts, XML, HTML, DHTML, C/C , Java, VBA, VB.Net

Databases : Oracle 8i/9i/10g, SQL Server 2000, MS Access, Sybase.

Packages : MS Office Word, Excel VBA , Access, PowerPoint, Visio, Front Page

Data Warehousing : Informatica, Congos, BO, SAP BW

Operating Systems : Windows NT/9X/2000/XP, UNIX, LINUX, MS-DOS

Oracle Tools : PL/SQL Developer, TOAD, PC Anywhere, SQL Loader, Oracle Reports 6i/9i/10g, Oracle Forms 6i/9i/10g, Erwin 4.1.

Open Source Tools : CVS, PVCS, VSS

PROFESSIONAL EXPERIENCE

Oracle Developer

Confidential

Responsibilities:

• Estimate scope of testing for Rapid Rewards Program project within Agile methodology environment. Participate in functional requirements reviews and Identify existing and/or potential issues.
• Reviewed Test Plan and written Test Cases, Test conditions based on the Functional Specifications and Technical Design Document. Conducted System Component Testing, Regression Testing, Integration Testing, and End-to-End testing. Used Clear Quest and Quality Center for Defect tracking and Management
• Managing change management cycle through Remedy
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• Analyzed, designed, developed Forms and reports and procedure and functions for billing modules to bill the Pay per click customers.
• Worked on complete SDLC system development life cycle including system analysis, high level design, detailed design, coding and testing
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL Plus and PL/SQL.
• Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.
• Converting all the Custom Reports to work on Oracle Applications 10g using Oracle Reports 10g.
• Developing Custom Oracle Forms for Oracle Applications 10g using Oracle Forms 10g
• Developed various complex stored procedures, packages, and triggers in PL/SQL.
• Created numerous web based Forms and Reports using Oracle Developer 10g.
• Troubleshooting, 24x7 Production support
• Defined Editors, Created List of Values and Record Groups in Oracle Forms 10g.
• Design, development and testing of Reports using Report 10g.
• Created Complex Dynamic / Static / parameterized reports and Charts using Report 10g.
• Did oracle data loading into oracle database from flat files using Kron shell scripts
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, I used these tools with EXPLAIN PLAN.
• Created Kron shell scripts for automating some production tasks.

Environment: Oracle 10g, SQL, PL/SQL, Designer / 2000, Developer 2000 Forms 10g, Reports 10g , Sun Solaris, TOAD, XML, HTML, UNIX, TKPROF, TRACE, EXPLAIN PLAN, and Windows XP/2000/NT, Sql Loader, Reports.

Confidential

Responsibilities:

• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
• Produced Scripts to cleanse source data, ETL process Extract, Transform Load data with business rules, and built re-usable Mappings.
• Used Toad Pro for developing Stored Procedures as IDE to interact with the Oracle 9i/8i Database.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions
• Responsible for Test Automation Design and implementation. Used TSL in QTP to code generic project specific User Defined Functions. Performed System, Security and Regression Testing using QTP. Evaluated Quick Test Pro to be used for Automation testing. Created Data Driven Test Scripts to test the application within positive and negative set of Test Data.
• Wrote Test Plans, Test Scripts and Test Cases for end to end testing of various Investment applications which include: Front End Sales Credit Card Processing Application over the phone , Store Vision Platform-which processes applications like Express Consumer Open, Qualify Individual/Business Customers,
• Responsible for assessing the end-to-end performance and regression testing strategy.
• Analyzed and verified the Testing Documents with the Functional System Design FSD and Business Requirement Design BSD .
• Developed views, functions, procedures, triggers, packages using PL/SQL SQL to transform data between source staging area to target staging area.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote SQL, PLSQL, SQL Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Optimized critical queries to eliminate Full Table scans.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in Gathering and Analyzing Business requirements with product management for new release cycles
• Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
• Used Rational Unified Process in obtaining the generic code samples and determining the key processes.

Environment: Oracle 9i, Oracle 8i with Data-Warehousing on HP-UX and Sun Solaris with Windows NT/2000/XP workstation, XML, SQL, SQL Plus, PL/SQL, SQL Loader, Export/Import, TKPROF, Apache Server, Oracle Web Application Server 4.0, CVS, Toad.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in the data transfer and creating tables from various tables, coding using PL/SQL, packages, stored procedures and triggers.
• Coordinated with DBA in creating and managing tables, indexes, db links and privileges.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
• Developed screens and reports using Oracle Forms/Reports 6i/9i and PL/SQL.
• Utilized SQL Loader to load flat files database tables.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Responsible for performing code reviews.
• Developed user documentation for all the application modules.

Environment: Oracle 9i, UNIX, PL/SQL, SQL PLUS, SQL, TOAD, C, SQL Loader, Forms 6i, Reports 6i.

Confidential

Oracle Programmer/Analyst

Responsibilities:

• Customized and developed Oracle Forms and Reports using Oracle Forms 6i and Reports 6i
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL LOADER.
• Worked on logical and physical data modeling and created Materialized views.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Coordinated with the business users to collect requirements.
• Developed Reports to extract the monthly sales information
• Participated in performance tuning, unit test case preparation and execution.
• Utilized tools like TOAD during development of the application

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL Loader, SQL Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

Oracle Programmer/Analyst

Responsibilities:

• Tuning database and SQL statements and schemes for optimal performance.
• Developing and Tuning SQL, PL/SQL triggers and stored procedures
• Develop and maintain scripts for monitoring, troubleshooting and administration of the databases.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Responsible for requirements analysis, design and development of the system.
• Involved design and development of user interfaces using Visual Basic.
• Designed and enhanced the GUI using Visual Basic tools like input fields, buttons, menus etc.
• Tested programs to ensure proper functionality doing unit testing.

Environment: Oracle 7.0, SQL, PL/SQL, SQL Loader, SQL PLUS, Visual Basic 6.0,Windows 98.