SUMMARY

• A QA professional wif around 8 years of experience in manual and automation testing.
• Excellent understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Test Methodologies from project definition to post deployment documentation.
• Experienced in Waterfall, Agile, Kanban, Spiral and SCRUM SDLC methodologies.
• Experienced in SSIS - ETL testing in Data Mart and Data Warehouse applications.
• Experience working on e commerce and e business websites.
• Experience in mobile testing on Android and iPhone devices.
• Proficient in multiplatform (Windows. Linux, MacOS) and cross browser testing (IE, Firefox, Chrome, Safari, Opera) as well as Mobile testing on different devices (Android, Iphone, Windows Phone).
• Experience in performance of Build Validation and Verification, Positive and Negative, Boundary Values Analysis, Equivalent Classes partitioning, Smoke (Sanity), Functional, Integration, System, Regression, Ad-hoc (Exploratory), Cross - Browser, User Interface and User Acceptance tests.
• Analyzed requirements, design documents, functional specifications, use cases and data experiences in preparing and executing teh Test Plans, Test Scenarios, Test Cases and Test Procedures and Defect Management.
• Extensive work experience and expertise in Black Box Testing, User Interface (UI) Testing, Integration Testing, System Testing, User Acceptance Testing (UAT), Performance Testing and Regression Testing.
• Experienced in developing SQL queries and stored procedures using PL/SQL to perform backend testing.
• Performed System, Functional, Regression, Integration, GUI, Usability, International, end-end, Positive, Negative, Data Driven Testing and UAT.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Excellent analytical and logical programming skills wif a good understanding at teh conceptual level and possess excellent presentation skills wif a strong desire to achieve specified goals.

TECHNICAL SKILLS

Testing and Defect Management tools: HP Quality Center, JIRA, Clear Quest, HP ALM 11.5, Bugzilla

SD Methodologies: Agile, Scrum, Waterfall, Kanban

OS and platforms: Window Server 2003, 2000, NT 4.0, 98, DOS, and UNIX

Database Technologies: Oracle 11i/10g,MS-SQL Server 2005/2008/2008 R2, MS-Access

Languages: HTML, Visual Basic, T-SQL, SQL, HTML, C#, PL/SQL

Reporting Tools: Excel, SQL Server Reporting Services 2005/2008/2008 R2/2012, Tableau, Power BI, QlikView 10.0x

ETL Tools: Informatica, SSIS

Configuration Management Tools: Microsoft Team Foundation server(TFS), Microsoft Visual Source Safe, CVS, GIT

PROFESSIONAL EXPERIENCE

Sr. Quality Analyst

Confidential, Huntersville, NC

Responsibilities:

• Worked wif Business /Technical Analyst (onsite and Offshore) in analysis of functional design specifications of ETL/Data warehouse applications.
• Worked on various projects like “CRM Project”, “BI Stabilization”, “OBIEE Project”.
• Preformed Functional, System, Integration, Regression and Database testing.
• Perfumed extensive ETL testing using Redgate tool.
• Investigated Software bugs and reported to teh developers.
• Tested ETL full load and incremental loads by running teh workflows.
• Wrote complex SQL queries to validate Target and source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Conductedsystem Integration testingin teh system test environment to detect defects,end-to-endtesting to ensure conformance wif teh requirements prior to code migration toUAT.
• Expanding existing system tests to facilitate testing at teh lowest level of granularity.
• Investigating and querying data by writing complex SQL scripts (T-SQL) to halp development team fix teh defects.
• Designed and executed test plans and test cases according to teh business specification, generate test scripts and test cases.
• Tested Micro strategy reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Metric Calculations, Drill down Reports.
• Analyze data trends, draw conclusions and recommend direction as it applies to defect resolution.
• Setup JIRA-Jam Plugin setup for teh team for Defect mappings between teh tools.
• Tested Applications like “CRM Project” and “BI Intelligence” an ETL oriented testing.
• Validated and Verified teh Mobile CRM both on IPhone and Android
• Coordinated wif Dev and BA teams and OPS teams for teh projects to avoid communication gaps and resolve issues.
• Created training material for offshore team as well as trained teh new hires on application and bringing them up to speed

Environment: MS SQL Server 2008, HP ALM, MS Office, MS Excel, Jira, Outlook 2013, Microsoft Dynamic CRM, CMR, SQL developer, Oracle EBS, Microsoft Team Foundation server(TFS)

Sr. Test Analyst

Confidential, LA, CA

Responsibilities:

• Worked wif Business /Technical Analyst (onsite and Offshore) in analysis of functional design specifications of ETL/Data warehouse applications and Sales Order Processing
• Gathered business requirements and analyzed and designed software solution for teh Data migration from teh Microsoft GP databases into teh Warehouse and also to Windows Azure for AX Dynamics.
• Took a leading role in functional and integration testing of web-based E-Commerce web portal wif back-end custom applications used for consumer and wholesale business accounting & company’s manufacturing systems.
• Tested Security and Single Sign On feature of application for internal applications.
• Tested functionality of e-Commerce web application including but not limited to: shopping items, purchase orders and transactions.
• Analyzing Data Processing implementing Data Mart applications mainly transformation processes using ETL tool and understanding of ETL workflows and ETL mappings and also monitoring teh Production Environment.
• Involved in creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate teh platform data.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise wif System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix for each entity and marking down Test requirement, Test Head line, Actual result & Expected result.

Environment: SQL Server 2014, SQL Server Integration Services 2014, T-SQL, SQL Query Analyzer, IIS (5.0), Visual Studio 2012, TFS, Qlik View, MS Visual Studio, SQL Server Reporting Services, MS Excel, AZURE, Quality Center 10.0, QTP

Test Analyst

Confidential, SFO, CA

Responsibilities:

• Gathered teh Client requirement and analyzed teh Strategy and Workflow.
• Involved in all phases of testing such as System testing, Data validation and User Acceptance Testing.
• Managing offshore and onshore QA team, providing estimates, work allocation and progress tracking & reporting.
• Documented Test Plans for Test scripts and mostly involved in scenario based testing.
• Verified and validated teh custom functionalities and enhancements implemented in oracle financials and supply chain modules such as PO, AP and Order Management.
• Gathered business scope and technical requirements.
• Worked closely wif development team during teh testing phase and fixed bugs that were reported.
• Tested all approval workflows in P2P process.
• Performed unit testing/system testing and supported user acceptance testing (UAT).
• Scheduled Sessions on teh Server using workflow jobs.
• Implemented performance testing on jobs sessions to provide maximum efficiency and performance.
• Involved in fine-tuning queries for better performance.
• Responsible for testing teh Counters, Quotes, Pricelists. Tested various customized and standard Reports pertaining to OM, OPS, WMS and Shipping.
• Analyzed, tested and documented teh conversion and customization of oracle Apps.
• Converted data from legacy system to Oracle Applications. Teh conversion includes Customer information and Receipt information in AR through Auto lock box, Customer interface.
• Major responsibility in testing teh customization and supporting teh Workflow (2.6) (PO Approval, Requisition Approval, PO Account Generator) Workflows as per teh business requirements. Also tested teh following..,
• Purchase Order Detail Report.
• Purchase Requisition Status Report.
• Cancelled Purchase Order.
• General Ledger - Define chart of accounts, enable currencies, validating accounting periods and calendar periods. Set of books and its structure.
• Work Flows - Validated teh email notification and approval notifications for workflows created for settlement and rollover accounts.
• Reports: Validated Hedging reports, Settlement reports, Revaluation reports, Bank Statement reconciliation report etc.
• Worked on teh Defect to Resolution lifecycle.
• Creating Test Cases and Test Plan for New Enhancements for SCN Project in HP ALM.

Environment: Oracle Application 10.7/11i, PL/SQL, Forms 6i/4.5, Reports 6i/2.5, SQL*Loader, HP UX Server, Windows NT.

Test Engineer

Confidential

Responsibilities:

• Gathered teh Client requirement and analyzed teh Strategy and Workflow.
• Involved in all phases of testing such as System testing, Data validation and User Acceptance Testing.
• Involved in preparingTest Plans, Test ScriptsandTest casesfor internet banking - personal & NRI pages, mobile banking,SiebelCRM as well asWeb based applications.
• Co-coordinated testing efforts to high-level management and isolated root causes to resolve teh issues.
• Performed Manual Testing and identified bugs and interfaced wif developers to resolve technical issues.
• Tested teh Type1, Type2 and Type3 slowly changing dimensions.
• Used SQL Queries for checking database tables.
• Performed Alpha testing for Bank's internal CRM software: customer management and transactions.
• Used GUI testing to check for appearance of teh website
• Documented teh test results and changes.
• Performed Black Box testing from end user's perspective.
• Provided weekly updates status report.
• Interacted wif team lead and developers to resolve teh bugs.
• Involved in Black box and White box testing.
• Participated in team meetings, presentations and code walkthrough.
• Used Quality Center for Defect reporting, tracking & change management

Environment: SQL Server 2000/2005 Enterprise Edition, MS PowerPoint, MS Access 2000 Siebel CRM, Outlook, Popelsoft, Finacle