SUMMARY

• Over 7 years of experience Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, Client - Server Systems and Applications in Finance and Insurance Domains.
• Experience with Fixed Income, Derivatives, ecommerce and Warranty Management Tools.
• Handled multiple roles like - ETL QA Analysts, Test Analyst and Software Tester.
• Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios
• Experience in development and testing of business applications for Data Warehouse Systems using (ETL) Data stage.
• Experience on L3 Data stage Product support and CRM’s handling activities.
• Expertise in Writing Test scenarios, Test Cases in every release on all phases of SDLC and STLC.
• Experience on System Integration, Functional, Regression UAT and Migration testing of various ETL applications
• Experience in testing of Data Warehouse/ETL Applications developed in Informatics, Data stage using SQL Server, Oracle, DB2, and Linux. Ability to evaluate ETL/BI specifications and processes.
• Extensively used Automated Test Tools such as Quick Test Professional (QTP), Win Runner, Load Runner, Test Director (Quality Centre) ALM.
• Testing the application Structures and Functionality for White Box and Black Box testing. Usage of Trackers / Bug Reports, Test Director, HP Quality Centre, Rational Clear Quest.
• Familiar with concepts of SQL queries ranging from DML, DDL and DCL.
• Worked on various range of platforms such as flavors of UNIX, Linux, AIX, Solaris and Dos.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts, development team to gain a better understanding of the Business Process and Requirements.
• Good communication, interpersonal skills, self-motivated, quick learner & team player.

TECHNICAL SKILLS

Operating Systems: Windows 9.x / 2000/2003/ XP/ NT, LINUX, HP UX, AIX5.3 and Solaris

Languages: SQL, PL/SQL, C, C++, VB Script

Databases: Oracle7.x/8i/9i, MS Access, MS SQL Server2008, Sybase, DB2

Web/Internet: HTML, DHTML, XML, Fix Protocol4.4

Scripting Languages: Java Script, VB Script

Testing Tools: Win-Runner7.0 / 7.2, QTP 6.5/ 8.2, Quality Center 8.2 / 9.2, ALM, Remedy and Rational Clear Quest.

ETL: DATASTAGE 7.5X / 8.1, Informatics 8. 6, IMS and File-aid.

Reports: OBIEE Crystal Reports, SAP Business Objects, Sap BEX, Cognos Reports.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SAS developer

Responsibilities:

• Analyze product requirements, designed Test plans, Test scenarios and test script.
• Lead the User the Acceptance Testing team with the end- User and reported the Issue to developers.
• Worked with the Business Analysts to determine Business Requirements and set standards Test design documents.
• Experience in testing/validating the Source, Stage and Target (End-to-End) data systems
• Understanding the Requirements, Interacted with the On-Site and offshore development Cognizant team.
• Attended the meetings with the offshore cognizant testing and Production team.
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, and Master-Detailed.
• Performed ETL coding testing using Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested.
• Experience in creating & scheduling the jobs using Autosy.
• Extracted Data using Informatics from Oracle and flat files, Excel perform transformations and populate the data warehouse.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing
• Validated the QA Tool for Administrator, QA supervisor, Oper User and QA Auditor Module.
• Validated the data using SQL queries in Oracle for Intell imod application.
• Worked with the development team ensure testing issues are resolved.
• Proficient in HP Quality Center for Test case Designing, Test Execution and Defect Tracking.
• Created Business Risk Levels to determine Test Priorities to Test application.
• Validate the Loan Modification web application in different phase Functional, Regression testing.

Environment: Manual software and Database Testing, Informatics 8.6, FTP, Oracle 11g, Windows XP, Excel.

Confidential, Roseland, NJ

SAS developer

Responsibilities:

• Supported the Crossroads database for the migration from oracle to the MS SQL Server.
• Analyzed the Mutual Fund Trades in the SunGard Investor one System.
• Involved in extracting the data from different data sources like SQL Server and flat files.
• Supported the Crossroads database for the migration from oracle to the MS SQL Server. Analyzed the Mutual Fund Trades in the SunGard Investor one System.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL Queries.
• Generated test plans, test cases and test steps in Quality Centre 8.2 for ETL Testing.
• Tested Reports generated from Crossroad and PIT Database available to Custody Operations for moving money with the brokers/banks.
• Using the Trade Control System for controlling the Trades coming from Investor via Crossroad to the BCMS and Accounting System.
• Would be completely responsible for supporting the application during User Acceptance Testing and will actively involves developers in fixing the issues as and when they arise.
• Participate in the meetings when the trade Open, termination and Close for the Mult Funds.
• Analyze account receivable for credit, cash and Customer management in a timely manner with accurate, Up-to-the day information.
• Validated the Trade data in the BSMS BISYS Cash Management system and crossroad using different queries.

Environment: ETL Testing, Bug tracker, Data stage 7.5.2,HP Quality Center 8.2,SunGard Investor One, BCMS, Java, J2ee, LINUX, Oracle 9i, Ms SQL Server 2005,Ms Access.