SUMMARY

• A hands - on, goal oriented business professional, with over 10 years of wide-ranging and varied experience in developing, support, testing and maintaining corporate technical applications.
• Demonstrated ability to analyze processes, systems requirements, business requirements, operational issues, and provide recommendations to optimize and improve processes.
• Proven success in leadership, team building dynamics and individual mentorship.
• Expertize in functional, system, UAT and product testing.

TECHNICAL SKILLS

Database: Oracle, DB2,SQL,MDM

Tools: Quality Center, TOAD, Test Director, JIRA, ClearQuest, DB Visualizer, IBM WebSphere MQ Explorer, Oracle SQL Developer, Excel Macros, BUGJILA, Postman, Soap UI

Retail Packages: Sterling Commerce OMS, COM, PEOPLESOFT

EDI: Gentran, Mercator and Extol in AS400, XNSI-12

ETL tool: Informatica, MDM, Power Centre, REST, Soap UI, Postman

SOA testing Web service testing: (ESB and TIBCO)

Mainframe: COBOL,DB2 and JCL

Methodologies: Black box testing methodologies, White box

Automation tool: Selenium and HP service

Reporting tools: SRS and Micro-strategy reporting

PROFESSIONAL EXPERIENCE

Confidential, MN

Software Quality Analyst

Responsibilities:

• Analysis of system design document and creating stories and test scenarios.
• Preparation of test strategy document, test cases and reviewing it with client for closure.
• Preparation of test data, execution of test scenarios and tracking the result in JIRA and QC.
• Reporting the defect to all stake holders and taking it to closure.
• Creating stand up meeting for testing update and defect tracking.
• Participating in kick off meeting, developer review meeting and project requirement as well System design document review meeting.
• Assisting client in UAT testing.
• Doing functional, system, ETE, UAT and release testing.
• Doing regression testing with every release. The regression testing includes running the iteration suite of last time scenarios once again find out no new bugs occurred. Keeping a set of scenario or automation suite to re run again and again every functional or release is part of regression testing
• Documenting the final result, daily status report with respect to completion and issues and also the project closure report with all data with respect to testing perspective.
• Technical responsibility include working in Putty, Soap UI, REST, oracle, SQL, Jenkins, JIRA, QC, TOAD, Web services.

Confidential, Eagan, MN

Consultant - Software Quality Analyst

Responsibilities:

• .Getting the business requirement and user requirement
• Creating test plan, test cases, strategy and scenarios
• Execution of test scenario and raising defect in case issue.
• Defect tracking, logging and prevention during the testing.
• Daily, Weekly and Monthly Status report of the execution.
• Uploading the test result in QC.
• Act as configuration Controller, Knowledge Management and Defect prevention anchor for the project.
• E2E testing, System testing and also UAT support to client.
• Doing regression testing
• Worked in MDX, CUBE technology and UI to test
• Defect were logged in BugZila for tracking purpose

Confidential - MN

Test Lead

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Defined data requirements and elements used in XML transactions.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the 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
• Executing and monitoring jobs through Control - M.
• Reviewed Informatica mappings and test cases before delivering to Client
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Ensured that the mappings are correct and conducted data validation testing.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• . Regression testing
• E2E testing, System testing and also UAT support to client.
• Worked in Sterling order Management tools, Informatica, Control M,MDM, SQL, Unix,FTP, Teradata and Mainframe

Confidential, Mooresville

Responsibilities:

• Worked in complete ESB migration of client from AIX to Linus platform
• Running various data file for as many as 50 application in AIX and registered the response data for the same
• Running the same files in new Linus environment and comparing the response with AIX environment
• Preparing data comparison report and logging the defect if the output is not same
• Doing regression testing in both AIX and Linux
• Defect tracking, logging and prevention during the testing.
• Daily, Weekly and Monthly Status report of the execution.
• Uploading the test result in QC.
• Worked in Queue, Listener, web UI and load tester and LISA ITKO tool for automation testing.

Confidential

Technical Analyst

Responsibilities:

• Involved in Business analysis and requirement gathering
• Preparation of High level design, low level design and system definition document
• Review technical artifacts with client.
• Coding and unit testing the code in Mainframe and ETL
• Assisting independent testing team in SIT,
• Assisting client in UAT and bug fix
• Daily, Weekly and Monthly Status report of the project development.
• Worked in Mainframe, COBOL, ETL, TIBCO, Informatica, JCL

Confidential

Software Engineer

Responsibilities:

• Involved in Business analysis and requirement gathering
• Preparation of High level design, low level design and system definition document
• Review technical artifacts with client.
• Involved in coding and enhancement of program
• Involved in testing, map creation and AIF layout for EDI transaction like 834, 835, 837,820
• Involved testing, map creation and AIF layout for of inquiring EDI like 270/271
• Involved in testing, map creation and AIF layout for status and acknowledgement EDI Like 276/277
• Analyzing and Providing solution for the various production issues
• Monitoring system job, Data and mailbox.
• Act as technical as well as level 2 supports.
• Tracking and maintenance of the bugs in the code.
• Assisting independent testing team in SIT for enchantment and development of application
• Assisting client in UAT and bug fix
• Daily, Weekly and Monthly Status report of the project development.
• Worked in Mainframe,ETL, Remedy, Kintana,JIRA