SUMMARY

• Around 7+ years of experience as a Senior Quality Analyst (ETL Informatica) / Business analyst in IT Industry.
• Experience in interacting with clients to understand and implement requirements and leading development support teams constituting company as well as client and third party contract staff.
• Specializing in working with technical staff to create, interpret, and transform business requirements into technical specifications.
• Hands - on management experience developed and established through a host of cross-functional businesses team assignments and interaction with a diversified groups of people from technical and non-technical background.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Wrote defects using HP Quality Center, Analyzed test results using reports and graphs generated in Quality Center.
• Extensively used Quality Center to upload requirements, write test cases
• Strong experience in RUP Business Modeling process.
• Strong in ETL data validation using Informatica ETL environments.
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Actively analyzed current business processes (Claims, Recipient eligibility and enrollment etc.) and worked with management to improve and implement enterprise solutions to ensure compliance.
• Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
• Tested the data load process using the Informatica Power Center ETL tool and Tested several business reports like Dashboard, Drill Down and Detailed Reports.
• Report development experience utilizing SQL Server, Microsoft Excel
• Developed & executed several Optimized queries in SQL on the data.
• Established a traceability matrix (RTM) to keep track of various requirements and ensuring that each requirement was developed and tested.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Experience in writing complex SQL queries.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Coordinated with team members to write test plans and test cases.
• Experience in Agile and Waterfall models of SDLC
• Extensive knowledge on all phases of Software Development Life Cycle (SDLC)
• Extensive experience with Quality Center (QC)/Test Director(TD) for Test Planning, Test Execution and Defect tracking
• Experience in using Quick Test Pro (QTP) for functional and regression testing
• Experience as QA Analyst with Web and Client/Server applications using both Manual and Automated testing tools
• Experience in ETL process testing.
• Experience in Integration Testing, System Testing, Performance Testing, Functional Testing, Regression Testing, Database testing, User Acceptance testing and End-End Testing
• Extensive knowledge of QA methodology, Standards with strengths in ISO 9000, SEI-CMM Procedures, experience in ALM
• Expertise in analyzing Business Requirements, Technical Requirements, and High Level Design Documents
• Experience in ETL process testing using Informatica (PowerMart/PowerCenter).
• Extensively worked on backend testing and have very good knowledge of writing and executing SQL and PL-SQL queries to verify the data
• Good experience with Relational Database Management Systems like Oracle, SQL Server, DB2
• Strong hands on experience in testing brokerage applications
• Hands-on experience with scripting languages like Java Script, VB Script, HTML, DHTML, XML and Web Services.
• Worked extensively with Microsoft Excel (Macros and Pivot Tables). Proficient in Microsoft Word, Power Point, Access and Lotus Notes.
• Excellent knowledge of Enterprise Portfolio Management systems like Clarity, PlanView and MS Project Server. Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• The drive to grow while working collaboratively with peers in a cohesive environment.
• A Strong analytical and communication skills

TECHNICAL SKILLS

Languages: C, C++, SQL, HTML, VBScript, CSS, XML

Operating Systems: Windows 98/2000/XP/7/8 and UNIX

Browsers: IE7/8/9, Mozilla Firefox 3/3.5/3.6/4.0/5.0

Databases: MS SQL Server, MySQL, Oracle, Google Chrome

ETL tools: Informatica 9.X/8.X/7.X (PowerMart/Power Center)

Testing Tools: QTP 8.2/9.0/9.2/10.0/11.0 , Test Director, Quality Center 8.2/9.0/9.2/10.0/11.0 , ALM, UI and Clear quest

Others: MS Office, SQL Server Management Studio and VMware

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia PA

Senior Quality Assurance/ETL QA Analyst

Responsibilities:

• Effectively implementation of the System Development Life Cycle SDLC.
• Provided assistance to team members to clarify functional and technical difficulties.
• Used Quality Center to Report, track and, monitor defects.
• Test ETL software using Informatica.
• Extensive experience with Quality Center (QC)/Test Director(TD) for Test Planning, Test Execution and Defect tracking
• Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of the Informatica based ETL process.
• Tested the data load process using the Informatica Power Center ETL tool and Tested several business reports like Dashboard, Drill Down, Slice and Dice, Master Detailed Reports and Scorecard formats with process analytics
• Used QTP for functional and regression testing of the application.
• Used parameterization function in QTP
• Produced Requirements Traceability Matrix (RTM) to support the application development.
• Involved in Developing Test Incident reports/Test Metrics.
• Developed QA documentation including test plans, test cases and Facilitated Automated testing
• Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Executing Test Scripts as part of daily responsibilities.
• Involved in Keyword driven approach for automation to minimize the changes for QTP Scripts for future use.
• Prepare and deliver an in-depth presentation on agile methodologies and software craftsmanship including Scrum.
• Written SQL Queries manually for validation of data.
• Involved in User Acceptance testing.
• Provided regular status updates to the project manager on high priority issues.

Environment: Quality Center 10.0, QTP 10.0, VB Script, FIX protocol, C#, Windows 2000, Windows XP, SQL Server, UNIX, Microsoft Excel, ETL Informatica.

Confidential

Quality Assurance (Functional Test Analyst)/UAT Tester

Responsibilities:

• Followed solely RUP methodologies during the course of the project.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Experience in ETL process testing, and ETL process using Informatica
• Identified Test Conditions in according to the Detailed Design Documents.
• Executing Test Scripts as part of daily responsibilities.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Experience in writing complex SQL queries.
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Conducted Functionality testing during various phases of the application
• Prepared traceability matrix for point’s requirements from the completed test cases.
• Inserted Check Points to Check for the broken Links, Text, and standard properties of an object using QTP
• Report development experience utilizing SQL Server, Microsoft Excel
• Authored & Executed SQL queries to validate that actual test results match with expected
• Working closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues identified during the testing process.
• Tracking & Reporting of defects.
• Conducted UAT testing.
• Performed Backend testing using SQL queries.

Environment: Web Logic Server, ALM (Quality Center), QTP, SQL Developer, Oracle, DB2, Windows 7, MS Office 2010, SharePoint, ETL

Confidential, San Jose, CA

QA Tester

Responsibilities:

• Extensively involved in Electronic Data Interchange (EDI) designing and Implementations. Analyzed different HIPPA transactions such as 837 inbound/outbound, 835, 997, 999, 270,271, 276,277 etc. Involved in implantation of both HIPPA X12 4010 and HIPPA X12 5010.
• Worked on Professional, Institutional Claims. Involved in data preparation of both 4010 and transactions.
• Worked extensively in validating 837 Institutional and Professional (loop 2300 which consists the claim information) for both 4010 and 5010 and also created various test data for validation purposes.
• Extensively involved in Database Testing.
• Participated in the QA Meetings, Bug Review Meetings, Go/No-Go Meetings & responsible for updating & verification of the Project Checklist during the Deployments/Releases
• Involved in Preparation User Interface Testing Test plans and User Acceptance Testing (UAT)Test cases.
• Hands on experience in writing SQL Queries, extract data from Oracle.
• Experience on ICD 9 and ICD 10 Codes Testing.
• Used Rational Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Updated X12 837 transactions using Edifecs from compliance validated upgrade.
• Worked with ICD-9 and ICD-10 Codes.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Worked with claim and pricing engines, validated Specific internal formats.
• Performed Regression testing. Wrote defects using HP Quality Center, Analyzed test results using reports and graphs generated in Quality Center.

Environment: Quality Center, Java, SQL, Oracle, BPT, VB Script

Confidential, Wilmington, DE

QA Analyst

Responsibilities:

• Involved in different phases of SDLC.
• Interacted with Business Analysts to designed detailed test plan document for application testing.
• Provided assistance to team members to clarify functional and technical difficulties.
• Analyzed functional specifications from the front-end application with to requirement documents.
• Involved in creating Test Plan for the application.
• Extensively used Quality Center to upload requirements, write test cases.
• Used Quality Center to Report, track and, monitor defects.
• Produced Requirements Traceability Matrix to support the application development.
• Involved in Developing Test Incident reports/Test Metrics.
• Performed End-to-End testing for the entire ETL and Business Intelligence.
• Developed Test Plans based on Test Strategies and Developed scripts, utilities, simulators, data sets and other programmatic test tools as required to execute Test Plans
• Created MS Word, and MS Excel templates to upload the test cases directly to Quality Center using the inbuilt tools.
• Developed a testing strategy for all upcoming data feeds for both ETL and BI arena.
• Prepared traceability matrix for point’s requirements from the completed test cases.
• Extensively involved with ETL procedures/mappings/jobs and the testing of front-end reports.
• Used QTP for functional and regression testing of the application.
• Developed various object repositories to develop effective scripts.
• Involved in Keyword driven approach for automation to minimize the changes for QTP Scripts for future use.
• Written complicated SQL Queries manually for validation of data.
• Responsible in running Unix Shell Scripts for different server process.
• Performed browser compatibility testing using different browsers like IE, Fire Fox etc
• Validated data of the application with the SQL version in order to check the data integrity of the new version with the older version.
• Developed SQL Queries for checking the Data Transaction.
• Involved in User Acceptance testing.
• Provided regular status updates to the project manager on high priority issues.

Environment: Quality Center 10.0, QTP 10.0, VB Script, ASP.Net, FIX protocol, C#, Windows 2000, Windows XP, SQL Server, UNIX, Microsoft Excel.

Confidential, Freemont, CA

QA Analyst

Responsibilities:

• Created Test Plans and Test Scripts by analyzing the Business requirements and System Requirements of the Application.
• Worked closely with a project team for gathering the business requirements and interacted with business analysts to translate business requirements into technical specifications
• Involved in physical and logical design of the applications.
• Worked closely with Application Architects, Business Analysts, Project Managers to discuss and collect business requirements
• Developed detailed Testing Strategy for the entire application and developed various test cases.
• Functional testing the new developments / enhancements.
• Analyzed and tested various reports produced by the application.
• Developed Manual scripts using Quality Center to perform functional and regression testing.
• Conducted Functionality testing during various phases of the application
• Performed UAT Testing
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Created test data for testing specific billing functionalities.
• Work involves testing and reporting bugs using bug-tracking system (Mainframe Based System) and verification of bug reviews with Development team.
• Used Parameterization to fetch data to test the application using QTP
• Inserted Check Points to Check for the broken Links, Text, and standard properties of an object using QTP
• Working extensively towards testing the performance of the whole application

Environment: Quality Center 10.0, Team Tracker, Quick test professional, MSOffice, XML, Agile, SQL, Internet Explorer 9.0, Unix and Windows 2000