SUMMARY:

• Around 11 years of experience in Information Technology with extensive background of Quality Assurance conception, development and implementation phases of the software development life cycle, Data warehousing project life cycle.
• Over 8 years of Software Quality Control experience in Shipping industry & Finance Industry.
• Extensive experience in ETL testing and Database Testing.
• Experience in .Net applications testing.
• Experience in People Soft modules AP and Project Costing.
• Extensive experience in SSRS and Cognos Reports Testing.
• Extensive experience in User Acceptance Testing.
• Experience testing eCommerce Systems.
• Experience in interacting with Business & Development teams.
• Prepared Test Plans, Test Design Specifications, weekly reports & Traceability Matrix.
• Extensively involved in Test Case and Test Data Reviews.
• Experience in Functional Testing, Regression Testing, System Testing and Integration in with Client/Server and Web based applications
• Experience with the relational Databases like Oracle, SQL Server and Sybase.
• Experience in maintaining bug database for Production, staging and development sites for different releases.
• Experience in ALM. Extensively used ALM for Requirements, Test Plan, Test case Execution, Traceability Matrix and Defect tracking.
• Experience in Automation of the Web Applications using HP QTP 11.0 /11.5.
• Experience in using TFS for Defect Management.
• Experience in working both Agile and Waterfall Methodologies.
• Experience with Share Point.
• Experience with Shell Script.
• Experience with Unix.
• Experience in testing the tool Sungard Aventgard Integrity for Treasury. Worked on versions 7.6 and 8.0
• Experience in maintaining test script database using Bug Tracking Tool (Quality Center).
• Strong analytical and conceptual skills in database design and development using Oracle 11G/10G/9i & SQL Server 2008 & Visual Studio.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Strong Team working spirit, communication and relationship management skills.

TECHNICAL SKILLS:

Business Intelligence: SSRS, Cognos Report Net, Oracle Discoverer 4.0, 10g, Crystal Reports.

RDBMS: Oracle 10G/9i/8i/7.x, Sybase 12.5 / SQL Server 2008, Visual Studio

GUI: Oracle Forms 6i/9i, Reports 6i/9i, Visual Basic 6.0

Testing and bug tracking: Quality Center, ALM, TFS, QTP

Languages: PL/SQL, C, C++, Java.

ETL Tools: Oracle Data Integrator, SSIS, Informatica

Environment: WIN 95/98/NT/2000/XP, UNIX, Linux.

Design Tools: Rational Rose

Treasury tool: Sungard Avantgard Integrity 7.6 / 8.0

PROFESSIONAL EXPERIENCE:

Confidential, NJ

ETL, Database, .Net, People Soft & SSRS Tester

Responsibilities:

• Conducted requirements walkthrough with business teams. Performed data analysis on source tables to help business teams for capturing requirements.
• Involved in writing test plans (where ever applicable) and assisting / preparing test data, test cases etc.
• Created the Traceability Matrix.
• Extensively tested source to Target accounting data transmission using Oracle, SSIS, and SQLServer.
• Tested different ETL mappings/transformation rules by executing ETL jobs, validating business logic and also extraction logic after job execution.
• Extensively tested Functional, Regression and END - to-END testing for the Application
• Extensively used SQL queries to perform back end testing to check data integrity.
• Worked on .Net Application.
• Extensively worked on User Acceptance Testing.
• Conducted triage meetings with business team and development team to resolve the issues and generated benchmark reports.
• Interacted with business and technical teams to analyze the Enhancements and Bug Fixes
• Ensured all requirements are met, through population of a trace matrix
• Tested Data base table’s data for all the Queries that are associated to the test case scenarios. Prepared and executed PL/SQL queries to verify source data and transmitted.
• Extensively tested the SSRS Reports.
• Extensively worked on People Soft modules AP and Project Costing.
• Extensively used ALM to manage test suit (Test Plan, Test cases, scheduling, executing tests, TM and defect management).
• Prepared Test Summary Reports and distributed to all the business stake holders
• Tested the Sungard Avantgard Integrity upgrade from v7.6 to 8.0
• Tested the Sungard Avantgard Integrity in both GCL 4 and GCL 5 machines for compatibility.
• Created jobs, executed and monitored the jobs

Environment: Oracle 11, SQL Server 2008, SSIS, SSRS, Sungard AvantGard Integrity 7.6 / 8.0,TFS, ALM, TOAD, MS office 2010, Windows XP / 7, Unix, .Net, people soft, Informatica, Share Point, QTP 11.5.

Confidential, NJ

ETL & Cognos Reports Tester

Responsibilities:

• Conducted requirements walkthrough with business teams. Performed data analysis on source tables to help business teams for capturing requirements.
• Involved in writing test plans (where ever applicable) and assisting / preparing test data, test cases etc.
• Extensively tested source (ODS) to Target (CDW) accounting data transmission using Oracle data integrator (ODI)
• Verified extraction and transformation rules like qualified transactions, document type, posting dates, posting keys, cost centers, profit center, document currency, exchange rates etc.
• Tested different ETL mappings/transformation rules by executing ETL jobs, validating business logic and also extraction logic after job execution.
• Extensively tested Functional, Regression and END-to-END testing for the Application
• Extensively used SQL queries to perform back end testing to check data integrity.
• Conducted triage meetings with business team and development team to resolve the issues and generated benchmark reports
• Interacted with business and technical teams to analyze the Enhancements and Bug Fixes
• Ensured all requirements are met, through population of a trace matrix
• Tested Data base table’s data using SQL Analyzer for all the Queries that are associated to the test case scenarios. Prepared and executed PL/SQL queries to verify source data and transmitted.
• Extensively used Quality center to manage test suit (Test Plan, Test cases, scheduling, executing tests and defect management).
• Prepared Test Summary Reports and distributed to all the business stake holders

Environment: Small Talk, Gemstone, Oracle Data Integrator (ODI), SAP R3, Sybase, Oracle, HP Quality Center, TOAD, Rapid SQL, MS office, Windows XP and UNIX, Cognos Reports

Confidential

System Analyst

Responsibilities:

• Responsible for system study and database design.
• Interacted with business users to gather requirements.
• Prepared the technical specifications.
• Written the database scripts for the requirements.
• Develop and execute test scenarios, test cases, test scripts based on Business Requirements
• Involved in Front End, Back End, Integration testing by combining the code modules and individual applications
• Involved in user training.
• Responsible for the development of reports using Oracle Reports 6i.
• Developed user interfaces using Forms 6i to serve the requirements.
• Written scripts to extract and load data into reporting schema from legacy databases using Oracle Gateway.
• Created stored procedures & triggers.

Environment: Oracle 6i/9i SQL, PLSQL, Forms6i, Reports6i, Windows 2000.

Confidential

Visual Basic and Crystal Reports Developer

Responsibilities:

• Involved in requirement analysis and system design.
• Involved in the screen designing using VB 6.0
• Developed database packages.
• Generating the MIS Reports
• Involved in the Unit testing

Environment: VB 6.0, Oracle, Crystal Reports