SUMMARY:

• Certified IT Professional with 8 plus years of core competency experience in Manual Testing, Automated Testing, End to End Test Coordination for Distributed, Client Server, Web (ASP, .NET, Java & J2EE) based applications for the clients in Government, Healthcare, Financial, Travel and Telecom sectors.
• Extensive knowledge in Selenium WebDriver, Selenium Grid, MTM (Microsoft Test Manager) and other test automation tools.
• Extensive experience in an Agile/Scrum and Waterfall models/ methodologies, and automating application development.
• In - depth experience in Defining Testing Methodologies; creating Test Plans and Test Suites, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Core Java technical expertise including JEE, O/R Mapping, SQL, UNIX scripting, UML, Eclipse, Frameworks (Struts, Spring), HTML, CSS, multi-threading, SOAP/REST and MVC, object oriented design and design pattern.
• Expertise in Unit Testing tools such as Junit, TestNG, Cucumber, conducting System Testing, Functional Testing, Integration Testing, Performance Testing, Regression Testing and User Acceptance Testing (UAT).
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, Data Cleansing, Data Verification, identifying data mismatch and BI applications integration using SQL, PL/SQL, OLAP, XML, SQL Server 2008/2012, Oracle, MySQL and Informatica.
• Solid Back End Testing experience by writing and executing SQL Queries using MicroStrategy, SSRS, ORACLE BI Publisher, Business Objects.
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Knowledgeable on the HIPAA policies and procedures and awareness of HIPAA breach process.
• Experienced in 508 Compliance testing utilizing tools JAWS and FSReader .
• Good experience with healthcare applications and business functions.
• Creative and out-of-box thinker who can discover product anomalies and helps improve the test efficiencies and effectiveness.
• Strong interpersonal, oral and written communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/Vista/7/8/10, Unix

Databases: Oracle 8.0/9.0/10g/11g, SQL Server 2005/2008/2012, Siebel, Sybase

ETL Tools: Informatica 6.1, 7.1, 8.1, 8.6, SSIS, Data Stage 6.x/7.x/8.x

Reporting Tools: MicroStrategy 9/10, SSRS, Business Objects 5.0/6.5/XI R3/R2/R1, Crystal Reports, Oracle BI Publisher

Query Tools: PL/SQL, Toad SQL Query Analyzer, SQL Plus, SQL Developer

Scripting Languages: XML, HTML, XHTML, JavaScript

Languages: Java, T SQL, PL/SQL

Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables, Erwin 4.0, ER studio

Packages: MS-Office, Visual Studio. 2005/2010/2013

Bug/Defect Tracking: Jira, MS TFS 2013, Bugzilla

Testing Tools: MS Test Manager, Selenium WebDriver, HP-ALM(Quality Center), QTP, LoadRunner, TestNG, Cucumber

Version Control: MS Visual SourceSafe, Microsoft TFS (Team Foundation Server), MS SharePoint, IBM RTC, Maven

Java Technologies: J2EE (1.3/1.4), Servlets, JSP 2.0, JDBC, JUnit, Log4J, Eclipse

OOAD METHODOLOGIES: Agile, eXtreme Programming, UML

PROFESSIONAL EXPERIENCE:

Confidential, Washington, D.C

Sr. QA Analyst

Responsibilities:

• Supported all aspects of quality assurance testing from requirements understanding to test execution by following Agile/Scrum SDLC methodology.
• Managed relationships with BS&R project stakeholders, interfacing application customers, peers, and the department’s information technology group for maintenance of ITIM / C-SCAPE applications.
• Executed test scripts for requirement validation, integration, regression, performance, and usability testing
• Developed quality assurance standards and track quality assurance activities.
• Attended meetings with stakeholders and communicated effectively with clients and all levels of management, peers and organizations within the Federal Reserve Board.
• Participated in test strategy, test estimation, and planning discussions to learn and apply detailed business requirements.
• Drafted automated testing artifacts that included Test Suites, Test Plans, Business Test Scenarios using build management tool Maven and implemented CI (Continuous Integration) through Jenkins.
• Created and maintained change tickets related to testing initiatives.
• Created and executed SQL scripts used for database testing validation.
• Logged defects, and verified their fixes; produced status reports related to testing process, including test results and defect tracking through MS TFS (Team Foundation Server .)
• Performed analysis related to enhancements for the C-SCAPE application.
• Interacted with all stakeholders to analyze, interpret and verify Business/Technical Requirements associated with data migration during application upgrades.
• Reviewed and maintained all project documentation in MS SharePoint repository in accordance with department procedures.
• Acted as SME (Subject Matter Expert) for all integration and downstream applications testing through project life cycles.
• Supported testing of application and environmental upgrades as well as resolution of production issues.
• Prepared databases and environments for testing.
• Assisted with technical artifacts (such as Use Cases and User Interface Specifications) and engaged in technical discussions.
• Participated in Lessons Learned or Project Review sessions, and identified potential work process improvements.
• Lead and supported contingency testing efforts.
• Tested Canned/Ad-hoc reports using MicroStrategy functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Provided on-call, after-hours and weekend tier-II helpdesk support for the product (C-SCAPE.)
• Worked directly with the business analysts and developers to translate functional requirements into executable test cases for section 508 compliance.
• Performed Section 508 compliance testing on applications utilizing tools JAWS 16.0 and FSReader 3.0.

Environment: Selenium Webdriver, TestNG, Maven, Eclipse, Java, Junit, XML, HTML, Jenkins, Log4j, Cucumber, MS SQL Server 2012, MS TFS, MS SharePoint, C#, .Net, MicroStrategy Reporting Server 9/10, Informatica, Agile/Scrum Methodology TASMEA, Inc. March ‘06 - September ‘15

Sr. QA Analyst

Confidential, Atlanta, GA

Responsibilities:

• Project followed Agile/Scrum methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards.
• Participated in requirement review meetings, daily stand-ups, peer-reviewed test cases for consistent quality test coverage.
• Created test data and executed functional, and system test cases and performed extensive regression testing to assure quality.
• Estimated, Developed and Executed Tests Scripts of all the modules.
• Documented Test cases corresponding to business rules and other operating conditions.
• Prepared test procedures and test strategies such as examining application, testing environment and testing resources to test the application in a given timeline.
• Deeply studied the business requirements and then created appropriate and in depth test plan and test cases using Selenium WebDriver and TestNG.
• Interacted with Developers and System Analysts to understand the severity of the defects and assigned priorities accordingly using Jira.
• Prioritized Manual test cases based upon the Business Requirements and managed them accordingly in Jira.
• Extensively used SQL queries to verify data in Database Tables. Performed regression tests on batch jobs for (ETL) data transformation and loading and analyzed the quality of the data.
• Executed and enhanced test cases for cross browser testing using Selenium Webdriver and TestNG .
• Performed and assisted QA teams with documentation of all phases of the QA process.

Environment: Selenium WebDriver, TestNG, Jira, Java, Log4j, J2EE, Eclipse, Oracle, SQL Server, HTML, Maven, Windows and Agile Scrum Methodology.

Automation QA Engineer

Confidential, Norcross, GA

Responsibilities:

• Project followed Agile/Scrum methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards.
• Participated in 2-week sprints, daily stand-ups, peer-reviewed test cases and code quality for consistent quality test coverage.
• Reviewed Business Requirements document with the business and development teams to understand the architecture and functionality of the application.
• Actively Involved in Software Development Life Cycle, Test strategies, Methodologies and Process Improvements. Performed White Box Testing of the application.
• Developed test plans and strategies for testing web applications and e-commerce solutions. Documented test cases for various modules of the application.
• Performed Functional and Regression Testing utilizing Manual and Automated Test Scripts.
• Executed test scripts against various releases and validated the actual results versus the expected results.
• Debugged Test Scripts created Batch tests, verified Test results and reported the defects using Jira.
• Verified functionality and integration of Web Services and XML data transfers using API. Created a Shared Object Repository for dynamic applications. Coordinated UAT test cycle with UAT team. Wrote SQL, PL/SQL queries as part of database testing.
• Performed Business functionality testing, which involved testing of all core functions of the application. Categorized bugs based on severity and coordinated with developers to resolve them.
• Responsible for Regression testing after bug fixes and verified those fixes. Directly worked with the development team to resolve problems and provide technical content for product documentation.
• Participated in Enhancements meeting to distinguish between bugs and enhancements.

Environment: Java, J2EE, Eclipse, Maven, Selenium Web driver, Selenium Grid, TestNG, Junit, Firepath, Firebug, JIRA, XML, SQL Server, Oracle, Html, HTTP, Windows, ASP.NET, BO Crystal Reports and Agile/Scrum Methodology.

ETL TESTER

Confidential, Atlanta, GA

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined data requirements and elements used in XML transactions.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validated reporting objects in the reporter against the design specification document.
• Validated data files from source to make sure correct data has been captured to be loaded to target tables.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Deleted the target data before processing based on logical or physical primary key.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Wrote Test Cases for ETL to compare Source and Target database systems.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from legacy systems using Informatica and provided technical support and hands-on mentoring in the use of Informatica for testing.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validated the Archive process to purge the data that met the defined business rules.
• Validated OLAP cubes generated in SQL Server Environment.
• Wrote several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008/2012 and Oracle 10g/11g.
• Prepared test plans/test schedules with inputs from Project manager and development team.

Environment: Informatica … (Power Center/ Power Mart), SQL, PL/SQL, Quick Test Pro 9.2, Business Objects XIR2, UNIX, Shell Scripts, Mercury Quality Center 9.2, Control-M, Teradata V2R6, SQL Assistant 12.0, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, Sybase, Oracle, SQL Plus, MS Access, SOAP, XML and Agile/Scrum Methodology

ETL TESTER

Confidential, Cincinnati, OH

Responsibilities:

• Identified field and data defects with required information in ETL process in various jobs and one to one mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Validated data in the reports by writing simple to complex SQL queries in the transactional system
• Executed Test cases for BO, SSRS and Oracle BI Publisher.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Oversaw historical loads in UAT and PROD environments.
• Optimized/Tuned several complex SQL queries for better performance and efficiency.
• Prepared test cases after thorough analysis of business requirement document.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Reviewed ETL mappings (Informatica) to ensure correct application of transformation rules.
• Created and executed SQL queries to perform source to target testing on SQL SERVER database. Performed following tests:
• DATA COMPLETENESS
• VALIDITY
• UNIQUENESS
• DATA INTEGRITY
• DATA TRANSFORMATION
• DATA QUALITY
• INITIAL AND INCREMENTAL LOAD TESTS
• Coordinated with different users in UAT process.
• Performed Unit Testing for all reports and packages.
• Day-to-day SQL Server administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained data integrity and security using integrity constraints and Data base triggers.
• Worked on issues with migration from development to testing.

Environment: SQL, PL/SQL, TOAD 7.0, HP Test Director, Control-M, Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), SQL *Loader, BO Crystal Reports, Oracle8i, SQL Server 2005, Bugzilla

Reporting Analyst

Confidential, Miami FL

Responsibilities:

• Installed Report Application Server and later upgraded the RAS Reporting environment to Crystal Enterprise 9.0.
• Created Several Reports for Radix Reservation System for Confidential
• Developed Reports from ERP Databases.
• Created and customized complex Stored procedures for Radix Reports
• Created several complex Cross-Tab Reports using Crystal Reports 9.0
• Installed the Crystal Enterprise and set up the NT Authentication as well as Enterprise Authentication for all the users
• Monitored the default APS Database created in SQL Server while Installing Crystal Enterprise
• Created user specific Reporting folders in CE and gave the permissions to corresponding users
• Customized the E-Portfolio as per the users requests
• Deployed multiple Reports into Crystal Enterprise using Crystal Publishing wizard
• Used Crystal Configuration Manager to completely administer the various servers like Web Component Server and Crystal Input/output File Repository Server, Job Server, Report Application Server.
• Used APO’S Object Manager for dynamically populating the Parameter Values of each Individual Report from the database in Crystal Enterprise.
• Deployed all the Crystal Analysis Reports in to Crystal Enterprise for browsing the Cube’s data.
• Scheduling and Exporting and E-mailing of various reports were completely administered in CE.
• Extensively used the Object Manager for dynamically pulling the values for the CASCADE Parameters for all the Reports.
• Customized the E-portfolio and administered the CE-Reporting environment.

Environment: SQL Server 2000, Crystal Enterprise 10.0, Crystal Reports 10.0, Crystal Analysis 10.0, Active Server Pages, C.S.P., Bugzilla

IT Consultant

Confidential, Atlanta, GA

Responsibilities:

• Generated reports using Crystal Reports 8.0.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments
• Created different type of reports including Cross-tab, Conditional, Drill-down, and Sub reports.
• Worked closely with business Analysts, gathering data from business and management groups.
• Created reports include formatting options such as Grouping, Sorting, and Drill-down.
• Performed team leader role in few projects
• Modified report content and export reports in multiple formats based on user input.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2000.
• Involved in all team meetings involving users and other team members.
• Designed Complex reports including sub reports, cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.

Environment: Crystal Reports 8.0, SQL Server 2000, Visual Basic 6.0, MS Access, MS Excel, XML and Windows NT

Confidential, Atlanta, GA

DBA, System Administrator, Report Writer

Responsibilities:

• Managed and administered a pre-paid administration system (PPAS Software), which was based on CA-Ingres 6.4/05 database and mainly, used for subscribers’ voucher handling and recharges.
• System administered VMS 7.1-H2 software on Clustered Alpha 4100 and 8100 platform.
• Produced reports for Management using Ingres Report writer.
• Participated in Migration of data from Ingres to Oracle database.
• Executed all special promotions awarded to different subscribers in a more than one million subscribers database.
• System administered SDPs in Intelligent Network environment which is a UNIX based system running on Sun Sloris2.6 with Enterprise 4500 servers accompanied with Ultra 10 machines configured in a Satellite orientation.
• Tier-II engineer in IN operations environment, including technical support to all nodes including SCP, SDP, HLR, SMAS & IVRs.
• Participated in all PPS upgrades implementation starting from PPS 3.1-3.4MP2.
• Involved in Acceptance, Testing and implementation of SDP and SCP nodes.
• Actively carried out all migrations b/w SDPs.
• Carried out all daily routines like running back-ups and responding to alarms and trouble-shooting problems escalated to Tier-II.
• Hands-on experience with Remedy ticketing system as well as with Confidential ’s fault finding system, Net Expert.
• Loaded different software corrections ACA/ECA on SCPs in an AXE-10 environment.
• Installed IN service scripts using SMAS.

Environment: CA-Ingres database, Sybase 11, VMS 7.1-H2, UNIX, MS Access