SUMMARY:

• Around eight years of consulting experience in all phases of Software Development Life Cycle involving design, development, testing and data analysis in various areas of Software Quality Assurance and Data Warehousing.
• Specialized in Healthcare, Financial and Credit monitoring, Public Services, ECG - Cardiac and Pharmaceutical application design and development.
• Experience in planning, designing, developing and deploying testing strategies for large-scale Cloud applications, Web applications, Java Applications, Web Services, Mainframe, Client/Server, Data Warehouse and Database systems.
• Extensively worked in Load Testing, Stress Testing, Regression Testing, and Functional Testing.
• Involved in System Testing, User Acceptance testing (UAT), Black Box Testing, White Box Testing, Integration Testing and Data Driven Testing.
• Experience and knowledge working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Expertise in ETL (Extract, Transform and Load) processes and concepts.
• Worked with Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalizer, Union, Sequence Generator and XML Source Qualifier.
• Worked with Informatica B2B Data Exchange and Data Transformation components.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling.
• Developed mappings for Slowly Changing Dimension (Type1/Type2/Type3) loads.
• Experience in debugging mappings, identified performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Automated file transfer setup for various kinds of file systems by coding and scheduling job runs.
• Gained expertise working as MFT administrator for setting new MFT environment including setting up profiles, file transfer processes and server configurations as needed for data exchange.
• Responsible for migrating existing MFT profiles and file transfer processes from one SharePoint location to another.
• Experience with industry standard methodologies like Waterfall and Agile methodology within the Software Development Life Cycle.
• Good knowledge and experience of DevOps methods and practices in Software Development, Continuous Integration and Continuous Delivery operations.
• Working as part of onsite-offshore model, developed abilities of seamless project coordination along with strong adherence to client processes and meeting deadlines.
• Very good team player and also have ability to work independently in time sensitive environment.
• Self-starter with ability to adapt to new environments and learn new processes quickly.

TECHNICAL SKILLS:

Testing Tools: HPE UFT 12/11.5, HP Quick Test Professional 8.2/9.0.9.5/10/11, Test Director 7.0/8.0, HP Quality Center 8.0/9.0/9.2, HP ALM 11.0/11.5, Selenium WebDriver, Cucumber

Data Warehousing tools (ETL): Informatica Power Center 9.5.1/9.1.0/8.6.1/8.5.1/8.1.1/ 7.1, Informatica B2B DT Studio, Informatica B2B DX, VLTrader MFT, Cleo Harmony MFT

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000, DB2, MS Access

Languages: SQL, PL/SQL, T-SQL, XML, UNIX Shell Scripting, VBScript, VB.net, HTML

Operating Systems: UNIX (IBM AIX/HP-UX/Sun Solaris), Windows XP/2000/2003/Vista 7

Reporting tools: Cognos 8

Packages: MS Office, MS Visio, MS Project, MS Visual Studio 6.0, Matlab

Others: Web Services, TOAD, UltraEdit, Lotus Notes, Citrix, COBOL, BugZilla, Bugzero, Team Tracker, Jenkins

PROFESSIONAL EXPERIENCE:

Technology Lead

Confidential, Atlanta, GA

Responsibilities:

• Interacted with business users for requirement analysis and understanding business and functional specifications.
• Performed exhaustive impact analysis by identifying various impacted jobs based on requirements and developed a detail document listing all the job details and test components.
• Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.
• Analyzed and reviewed use cases, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies).
• Configured and setup UFT framework to automate the identified regression test scenarios
• Extracted and validated data from various sources like Mainframe datasets, DB2 tables by using parameterization feature in UFT.
• Worked with Type2 and Type4 SCD processes in maintaining and validating Historical data.
• Worked with global and action data sheets in UFT framework.
• Worked with importing and exporting of the datasheets into the scripts during run-time.
• Enhanced the script capability by utilizing the Recovery scenario feature of UFT.
• Validated Lookup files that are updated as per the project requirements.
• Worked in Onsite-offshore model, attended daily meeting with offshore team to coordinate and get progress updates.
• Experience working in Agile methodology attending daily Stand Up Scrum, planning & grooming (like Project Kick-off, weekly project planning) meetings.
• Performing testing activities (Unit Testing, System Testing, UAT) based on the plans and in line with defined processes.
• Used HP ALM to maintain requirements under Requirements tab.
• Maintained and executed test cases under Test Plan and Test Lab tabs respectively.
• Maintained and generated Requirements Traceability Matrix for reporting and analysis purposes.
• Defect Tracking was performed using HP ALM and Defects were linked back with Test cases and Requirements to maintain coverage.
• Prepare estimations and plan for the release by following the standard processes of Client.
• Participate in and prepare content for KT sessions and document the understanding.
• Code Walkthrough - Conducting code reviews for the automated test scripts within the team to ensure that all standards and best practices are followed
• Responsible for delivering Test Plans, Test Scenarios, ETL Test Validation Plan, Test Case document & Test Scripts.
• Responsible for On-time Delivery and obtaining Test sign off from Business Teams.

Environment: HP UFT 12.1, HP ALM 11.5, PuTTY, DB2(Server Version 10.5.7), Toad, Mainframe, MS Office, MS Project, MS Visio, Internet Explorer and Windows XP

Confidential, Newark, NJ

Responsibilities:

• Interacted with business users for requirement analysis and understanding business and functional specifications.
• Reviewed Business Requirements, Technical Specification Document, Process flow diagrams, Mapping documents etc.
• Actively involved in writing Test Plans, Test Cases and identified Test Scenarios for automation.
• Involved in reviewing and validating Informatica ETL mappings for the enterprise Data Warehouse environment
• Worked on the HIPAA 5010 transaction 837 I, P and D X12 Files.
• Experience working with HIPAA 5010 834 (Enrollment) transaction to convert the file from X12 to XML and store date in Oracle tables for further analysis and reporting.
• Created reusable functions and Sub routines and built the function library.
• Used the Stored Procedures shared by developers and worked extensively in PL/SQL for validating the data loaded to Target Tables.
• Included data from different sources like Oracle Stored Procedures and data files (file system) in the same report.
• Worked with UFT API test for validating XML data and X12 format of file using SOAP WSDL.
• Created and configured new MFT Provider profiles on demand as per the Service Request.
• Setup HTTP and/or SFTP process and validated for each Provider as per the requirement.
• Automated file transfer setup by coding and scheduling job runs.
• Performed MFT administration activities and server configurations for both EDI and non-EDI files.
• Performed migration of MFT profiles of various provider groups consisting of around 400 providers from one SharePoint location to other.
• Code Walkthrough - Conducting code reviews within the team to ensure the test scripts adhere with all standards and best practices followed
• Configured HP ALM and used in test case execution and maintaining test results.
• Requirements Traceability and Defect Tracking was maintained and performed in HP ALM.
• Attended Project Kick-off meetings and weekly status meetings.

Environment: Informatica Power Center 9.5.1, Informatica B2B DT studio, Informatica B2B DX Console, HP ALM 11.0, UFT 11.5, VLTrader MFT, Cleo Harmony MFT, Oracle 10g, DB2, SQL, Flat Files, UltraEdit, HTML, MS Visio, MS Project, Mainframe, CITRIX, Internet Explorer and Windows XP

Confidential, Washington, DC

Sr. Consultant

Responsibilities:

• Interacted with business users for requirement analysis, defining business and functional specifications.
• Reviewed Project documents like Use case documents, Process flow diagrams.
• Worked closely with Test team in developing various testing artifacts like Test Plan, Test Cases and Test Scripts.
• Worked with Architect in understanding physical database design which involved Star schema model.
• Extracted data from various sources like Mainframe, Flat Files and Oracle.
• Maintained and practiced standard processes while working with warehouse metadata components, naming conventions that are used for future application development.
• Extensively worked and maintained QTP test scripts by utilizing advanced feature like Descripting Programming, Smart Identification, Recovery Scenarios and Error Handling.
• Worked in fixing and debugging Mapping errors during Unit and Integration Testing Phases.
• Involved in migration of QTP Test framework and scripts from Version 10.0 to 11.0
• Worked on testing mobile apps developed for Handheld devices.
• Tested and automated API tests for SOAP messages using WSDL paths in SOATest tool.
• Analyzed and reviewed Defect Life cycle, updated Defect status and generated Defect Reports in HP Quality Center.
• Experience working in Agile methodology attending daily Stand Up Scrum, planning & grooming (like Project Kick-off, weekly project planning) meetings.
• Responsible for building Stories for Sprints and implementing based on the project deadlines.
• Created and configured new MFT consumer and vendor profiles as per business requirements
• Updated and modified existing MFT profiles as per the requirement changes.
• Setup HTTP and/or SFTP process and updated contact information as requested by Business.
• Extensively involved in coding file transfer setup and scheduled job runs for automating the process.
• Performed MFT administration activities and server configurations complying with security standards between client and Third Party Vendors.
• Supported migration activities of MFT profiles of various consumer and vendor groups and validated them.

Environment: Informatica Power Center 9.1/8.6, Cleo Harmony MFT, Oracle 10g, DB2, SQL, Flat Files, TPump, Toad, HTML, WSDL, Web Services, Mainframe, QTP 10.0/11.0, SOATest, Quality Center 9.2/10.0, Selenium Webdriver 2.25.0, SOATest, MS Office, MS Project, MS Visio, Bugzero, Internet Explorer and Windows XP

Confidential, Owings Mills, MD

Test Automation Engineer

Responsibilities:

• Analyzed business requirements, functions specification documents and use case documents.
• Actively involved in writing Test Plan and building test strategies.
• Designed the architecture and test framework of the test scripts based on the dataflow involved in the applications.
• Completely involved and familiar with Claim Submission, Claim Adjudication processes.
• Involved in migration testing of Facets (NASCO) 4.3 to Facets 4.5 (TriZetto) and good understating on different domains (Enrollment, Provider, Claims, Pricing and Customer management).
• Familiar and understand X12 file format for HIPAA 4010A 834, 837(I, P and D) transactions.
• Familiar with various CPT codes using in Claims processing systems.
• Worked with Biz-Talk tool in converting the X12 file to XML.
• Involved in various phases of testing like System, Integration, UAT and assisted business users in production validation.
• Involved in database testing by writing and executing SQL queries to validate data.
• Identified and automated reusable test scenarios using QTP Test scripts.
• Java and Web Services add-ins of QTP are extensively used in automation testing of COTS applications, Portico and NetworX Pricer.
• Test objects of Portico are handled and added into shared object repository using Java add-in of QTP.
• Using Web Services Wizard feature of QTP, the WSDL file/URL and web service objects of NetworX Pricer are captured into the object repository.
• Perform the action of validating WSDL using the feature available in QTP.
• Object Repository merge tool of Object Repository manager is used to merge the local repositories and handle it as a whole Shared Object Repository.
• Extensively used parameterization feature of QTP within the test scripts to test for huge amounts of data.
• Implemented various Checkpoints, Output Values and synchronization.
• Reusable functionalities were identified and coded as sub-functions and procedures to be stored into the Function Library.
• VB scripting was extensively used to enhance and customize the QTP scripts.
• Used main/non-reusable, reusable and external actions in QTP.
• Configured Quality Center with Excel using Excel add-ins.
• Used Quality Center to maintain requirements under Requirements tab.
• Maintained and executed test cases under Test Plan and Test Lab tabs respectively.
• Configured Quality Center with QTP by using QTP add-in and used in test case execution and maintaining test results.
• Attended Project Kick-off meetings and weekly status meetings.

Environment: Java, J2EE, Spring, Hibernate, HTML, WSDL, Web Services, Web Sphere, TIBCO, Oracle 10G, DB2, Mercury Quality Center 9.0, Quick Test Pro 9.1, ERWin5.0, MS Office, MS Project, Lotus Notes, COTS (TriZetto NetworX pricing engine, FMG Technologies’ Portico), CITRIX, Internet Explorer and Windows XP

Confidential, Paramus, NJ

Sr Analyst

Responsibilities:

• Responsible for writing test plan by analyzing business requirements, functions specs docs.
• Reviewed the test cases and executed them manually to understand the functionality of application.
• Prepared the design specifications documents of each script for review and approval by peers and Project Manager.
• Enhance and customize the QTP scripts using VB script programming.
• Test scripts for Mainframe applications were developed by installing and using Terminal Emulator add-ins in QTP.
• Used main/non-reusable, reusable and external actions in QTP.
• Extensively used various checkpoints to handle the dynamically changing /run-time data.
• Worked with parameterization to execute the multiple sets of data in QTP.
• Worked with global and action data sheets in QTP.
• Worked with importing and exporting of the datasheets into the scripts at run-time.
• Applied regular expressions to handle objects built as ‘PROTECTED’.
• Constantly used the Object Spy feature available in QTP to make a note of object unique properties and methods.
• Worked on testing mobile apps developed for Handheld devices.
• Tested and automated API tests for SOAP messages using WSDL paths.
• Experience using Quality Center to maintain test scripts, test cases and defects.
• Attended business meeting, weekly status meetings.

Environment: Mainframe, Java, J2EE, HTML, DB2, SQL server, SQL, Quality Center 8.2, Quick Test Pro 8.2, Load Runner 8.0, Merant Team Tracker, MS Office, Internet Explorer and Windows XP

Confidential, Bridgewater, NJ

QA Analyst

Responsibilities:

• Review the User requirements and Functional specifications documents for creating master test plan and test processes.
• Responsible for writing the manual test cases as well as reviewing and authorizing them for functional testing purposes.
• Identified and marked the test cases as Regression test cases.
• Involved in validating reports generated of Crystal Report developer.
• Able to populate and manipulate data from Oracle database within the Reports.
• Validated the graphs and charts built on Report with the selected data.
• Used Quick Test Pro to automate the whole functionality of the EXPeRT “eECG” web-based system.
• Performed complete Functionality and User Acceptance Testing.
• Extensively used Quick Test Pro for automating Functional and Regression test cases.
• Enhanced the QTP test script by using VB script functions.
• Fully knowledgeable with the Expert and Keyword view and used most the features of QTP to optimally test the functionality.
• Completely used the descriptive programming for handling the dynamic objects of the EXPeRT “eECG” application
• Involved in testing all the Sponsor, Protocol and Transmittal information of the application.
• Implemented various Checkpoints, Output Values, Parameterization, and synchronization.
• Traceability of User requirements and Functional specifications was managed in Test Director as well as in TMC (Test Management Console).
• Used the Quality Center connection of QTP to open/run test scripts saved under Test plan of Test Director.
• Managed Shared Object Repositories and used descriptive programming to merge the repositories such that multiple repositories are used in a single Test script.
• Implemented Data driven test and Batch tests.
• Well knowledgeable with traditional Configuration Management (i.e., checkin/checkout control of sources).
• Used BugZilla for reporting and analyzing the bugs.
• Used TestDirector for creating test plans, handling requirement coverage and saving the QTP test scripts.
• Writing and executing SQL statements, queries and stored procedures for populating the transmittal data into the application.

Environment: Java, J2EE, JSP, Java Servlets, EJB, HTML, XML, Oracle 9i, SQL, TestDirector 8.0, Quick Test Pro 8.2, PVCS Version Manager, BugZilla, Crystal Reports 8.0, TMC, MS Office.