SUMMARY

• TEMPHas more than Eight years of experience in Banking, healthcare clinical, system management, and support
• Wide scope of Payments, Credit Limits, Medical Informatics experience includes Medicare and Medicaid Claims workflow analysis; upgrade testing processes, Payments/Credit Limit/Revenue Share and Electronic Health Record enhancements for leading Banks and academic medical centers
• Posses full life cycle product knowledge in both Client/Server, Service Oriented Architecture and Legacy Mainframe development environment
• TEMPHas facilitated working relationships wif SME’s, Technical team, physicians and hospital administrators and worked across organizational boundaries to validate complex workflows
• Is an energetic, team - oriented, and process-focused professional wif excellent communication skills.
• 6+ years of hands-on experience in Client/Server and Legacy systems wif various databases in Banking and Healthcare Information systems.
• Complete understanding of all phases of Software Development Life Cycle from project planning up till deployment; exposure to both RUP and Agile development methods.
• Hands-on experience on Customer Initiated Wire Payments Processing, Credit Limit processing, BACS/scheduled Payments processing.
• Extensive experience on Main frame systems like TSYS, AFS/LN, TSO, and CICS screens.
• Worked on Revenue Share Agreement set up, Accrual calculations, Payouts.
• Experience on generation of Debit/Credit statement using MDE (Manual Data Entry).
• Hands on experience in calculations of Payments, Credit Limits, Credit Refunds and BPS(Basis Points) calculations based on Payout frequency, Revenue Share Agreements.
• Integrated knowledge of Hospital Billing, Charge, Revenue Codes, and Eligibility
• Experience in reviewing and understanding EDI Claims (837) and Eligibility workflows.
• Worked on different Enrollments, Re-enrollments and Manage Change Requests (MCR) of different Providers, Used PEGA for approving the Providers.
• Worked in important phases of Testing Life Cycle like Business Smoke, UI, Security, Functionality, System, Integration, Regression, and User Acceptance Testing.
• Ability to create Detailed Test Plan from Master Test Plan, Functional, and Design Documents.
• Participated in discovery phase of ICD-9 to ICD-10 changes and Participated in discovery & involved in testing Batch/Real Time updates of HIPAA EDI-4010 to 5010 conversion changes.
• Experience in developing Test Plans and Test Cases to ensure proper quality testing.
• Worked closely wif vendors, business analysts, project managers, and developers to understand requirements, business processes for testing and attended walkthroughs.
• Sound working background wif Test methodologies, formal Test planning, Test case design, Test procedures, and Test scenarios.
• Hands-on experience in executing and scheduling the Informatica jobs using UNIX Shell Scripting.
• Used HP Application Lifecycle Management (ALM), Quality Center, Silk Central as Test Management and Defect Management Tool.
• Working knowledge in validating Client requests and web service responses transmitted as Simple Object Access Protocol (SOAP).
• Used SQL for querying large Databases by writing Joins, Aggregate, and Single Row Functions.
• Hands on experience wif Java, .NET based Web Applications, and legacy Mainframe systems.
• Performed Data-Driven Testing, and worked towards synchronizing the test sets.
• Self-starter, fast learner and team player wif excellent communication, and problem solving skills.

TECHNICAL SKILLS:

Testing Tools: Application Lifecycle Management 11.00, Quality Center, Rational Clear Quest, SoapUI, Silk Central

Software Testing: Test Planning, Test effort estimation, Test Strategy, Test Lab Setup Test processes definition, implementation and improvement, Test process assessment, and Test Documentation Review.

Methodologies/Technologies: Rational Unified Process, Agile, Rational Rose, Waterfall

Data Warehousing Tools: Informatica, Data stage

Operating Systems: UNIX, Solaris, IBM Mainframes, Windows 2000/XP/Server 2003, Firefox, IE

Reporting Tools: Cognos, Microstrategy, Business Objects XI R2

DBMS: Oracle, MS Access, SQL Server, DB2, MainFrames

Documentation Tools: Microsoft Project, Excel, Word, Access, PowerPoint, Visio

PROFESSIONAL EXPERIENCE

Confidential, San Fransisco, CA

Systems Quality Analyst

Responsibilities:

• Reviewed the FSD (Functional Specification Document) to understand the UI screens, User Flow, Process of the application.
• Performed Smoke, UI, Functional, UAT (User Acceptance testing), Security testing, Manual testing, Regression testing.
• Expertise on Customer Initiated Wire Payment processing, Credit Limit processing, BACS (Bankers Automated Clearing Services)/Scheduled Payment processing for both EUR/GBP customers.
• Generated Statements using TSYS for all the EE Customers.
• Hands-on experience wif TSYS (Total Systems) TS2, AFS/LN (Automated Financial Services) CICS screens(Main Frame Systems)to generate/deliver Statements, check the postings of Payments, Credit Limits performed on front end C3P screens.
• Conditioned Statement(Debit/Credit) and Payment due date data in TSYS (TS2) through MDEs (Manual Data Entry) using Tran Codes.
• Hands-on experience on preparing test data, written test scenarios, test cases, test steps, and used HP Application Life Cycle management (ALM) as a Test Management tool and Defect tracking tool.
• Worked on GL Group Mapping: Mapped the AU (Accounting Units) to RM (Relational Manager) and GL (General Ledger) and performed the UI testing for GL accounts.
• Worked on UI validations on Payments, Credit Limits, Credit Refunds, Rebate Calculations against back end using Mainframes
• Validated Reports against the front end and the back end data in C3P.
• Worked on Delinquent Customers and Delinquency Reports.
• Prepared Complex data in Excel macros to test against Delinquent Reports..
• Participated in Business meetings along wif Stake holders, Project Managers, Business team, Product team, Technical Managers, and other interfacing application Partners.
• Participated in daily, weekly status meetings, defect meetings and worked closely wif technical team and business users.
• Prepared training materials and trained team members on EE application logic.

Confidential

Responsibilities:

• Reviewed all the Functional Requirements for Revenue Share Agreements' set up, Manual/Automatic Accrual calculations, Payout processing, Reporting, and Email notifications.
• Set up Revenue Share Agreements for both Domestic and European customers. Entered Manual Accruals, Manual Payouts, Accrual True-Ups.
• Data conditioning: Worked on Complicated data setup to cover all aspects of Revenue share. Worked on complicated test scenarios dealing wif the Spend data, ATS (Average Transaction Size), AST(Annual Spend Tier)
• Created and utilized complex data spreadsheets containing macros and formulas to validate values displayed in C3P.
• Worked on YTD spend(Year-to-date), Accruals To Date, Payouts against values displayed in C3P.
• Validated the Accruals (Manual/Automatic) generated in C3P against depending on the Agreement set up, Payouts generated.
• Hands on experience on Accrual Calculations, Payout Calculations based on Agreements set up.
• Worked wif Accounting and Finance Teams to validate entries in the General Ledger (GL)
• Worked on calculations of BPS (Basis points) depending on ATS (Average Transaction Size), AST (Average Spend Tier) and ADH (Average Date held) on different QLT/Non-QLT (Qualified Larger Ticket) transactions using STD(standard)/QLT/Early pay/ Early pay wif QLT schedules.
• Wrote test scenarios, test cases, and test steps based on the FSD provided and used ALM as a Test management and Defect tracking tool.
• Participated in weekly Technical troubleshooting sessions, status meetings, and defect meetings.

Hardware/Software: Windows, IE, Main Frames: TSYS(TS1 and TS2), AFS/LN, HOGAN, TMS, RCS, C3P, PI, ALM 11.00, Share point. DCM (Document Collaboration Management), CICS, ALM.

Confidential, Raleigh, NC

Quality Analyst

Responsibilities:

• Reviewed the PDD(Project Design Document) to get the better understanding about the project .
• Involved in writing and implementing test cases for UI testing of the Provider’s portal, Operations portal and Recipient portal.
• Prepared test data and Involved in writing test cases for Functionality, Validation, end-to-end and Database testing .
• Prepared the data using XQMF (xtended Query Management Facility) by running the queries and executed the test cases.
• Worked on different Enrollments, Re-enrollments and Manage Change Requests of different Providers, Used PEGA for approving the Providers.
• Worked on different Non-Electronic Submissions and Electronic submissions of PA’s (Prior Approval) to get the information about the recipient, medical history, enrollment wif the Medicaid
• Worked on different CSR’s(change service request )to meet the changes required by the Medicaid.
• Worked on different Enhancements to meet the enhancements done to the functionality of Web portals .
• Used Mainframes to run the batch jobs and generate reports
• Used File net to view these reports and letters.
• Participated in daily status meetings, weekly status meetings along wif the Test Lead and team members.
• Participated in Business meeting and worked closely wif the developers, stake holders, SME’s.
• Used Silk central to write and execute the test cases as a Test Management Tool and also used as a Defect Management tool.

Harware/Software: Windows, FireFox, IE, PEGA, XQMF, Mainframes(TSO), Silk Center, NC Tracks, Provider portal, Recipient portal, Operational portal, File net .

Confidential, Tampa, FL

Quality Assurance Analyst

Responsibilities:

• Translated Business Documents into Test strategy and written EDI transaction test cases.
• Reviewed Source-to-Target mapping document to link between different source systems and data warehouse for loading data into Oracle tables.
• Documented EDI 4010-5010 Test cases, prepared (test files), executed and maintained the test results.
• Extracted data from source systems Oracle, SQL Server and flat files to cross check data in target tables.
• Used TOAD to connect to the SQL server and PL/SQL tool for accessing the claims data in Oracle tables.
• Involved in validating the tables in source tables and target tables after each workflow is completed.
• Participated in defect meetings wif team members and developers to get timely updates and resolution for defects in Quality center.
• Used Putty to access the UNIX files and Autosys to schedule the Informatica workflows to run.
• Used Quality Center for writing the test cases, defect management and logging the defects.
• Used Informatica Powercenter 8.6 to view the log files after each workflow execution.

Hardware/Software: Informatica 8/8.6, SQL *Loader, SQL Server 2008, Oracle 10g, Sequential files, Flat files, SQL, PL/SQL, UNIX, Windows, XML, EDI X12, HIPAA 4010/5010, Autosys, Putty

Confidential, Pasadena, CA

Responsibilities:

• Actively participated in the Team meetings to gather business requirements from users.
• Involved in testing EDI implementation for mirroring the application transaction and reporting database to support COB (Continuity of Business).
• Involved in the partner testing of HIPAA 4010-5010 version conversion project for inbound and outbound EDI transactions and workflows.
• Participated in discovery phases of ICD 10 workshops to understand the impact of current workflows.
• Prepared test EDI files(X12 837P/me, 276/277) for positive/negative test scenarios in the test plan.
• Worked wif Test Lead to draft Test Strategy and developed test cases and files for Claims workflow.
• Involved in life cycle testing, functionality, regression, defect tracking and test results reporting.
• Reviewed Source-to-Target mapping document to link between different source systems and data warehouse for loading data into Oracle tables.
• Extracted data from source systems Oracle, SQL Server and flat files to cross check data in target tables.
• Analyzed data discrepancies through Informatica Monitor using error files and log files.
• Extensively used Quality Center for Defect Management and reporting issues.
• Involved in User Acceptance testing and Post-production testing of the application under test.
• Facilitated System Testing and Workflow Integration Testing Sign-off by communicating test and defect metrics and Exit Summary document to the Business.

Confidential

Test Analyst

Responsibilities:

• Conduct end-to-end workflow, functionality and integrated testing on mainframe and client-server applications, wif on-going implementations at national and regional levels.
• Translate Business requirements into Test scenarios to effectively use in creating workflow testing.
• End-to-end testing involving conception at Admission, Discharge, & Transfer module (ADT).
• Has strong knowledge of ADT functionalities, Revenue Locations, Bed Management, and Encounter Creation, while incorporating different lines of business.
• Thorough understanding of Inpatient and Outpatient workflows based on different departments of healthcare; Ambulatory, OpTime, Emergency departments.
• Integrated real-life scenario testing involving Clinical Documentation and Physician Order Entry.
• Responsible for coordinating and performing functional and data-related testing.
• Involved in database testing by generating SQL queries and checking for data anomalies.

Hardware/Software: Informatica 8/9, SQL *Loader, UC4, IBM DB2 7.2, SQL Server 2008, Oracle 10g, Sequential files, Flat files, SQL, PL/SQL, Shell scripts, UNIX, Windows, XML, EDI X12, HIPAA 4010/5010, Facets, EPIC.

Confidential, New York, NY

EDI Test Analyst

Responsibilities:

• Created Test Strategy document that defines test environment, phases of testing, time lines, entrance and exit criteria for different phases and resources required to conduct the testing effort.
• Involved inwriting Test plans and Test Scripts for EDI X12 837 Claims and performed Test Execution.
• Documented traceability between Requirements and its specifications and Test cases.
• Worked extensively on Member Conversion from four Legacy systems for states to FACETS.
• Executed the Integration and Package test scripts and performed regression testing of EDI transactions.
• Responsible for data warehouse, dimensional data mart, and enterprise report testing.
• Performed Package and Integration System testing of most of the Business Objects reports.
• Performed extensive back-end testing to pinpoint, analyze and identify reporting issues.
• Developed SQL queries/scripts to validate the completeness, integrity and accuracy of data wifin an ETL process testing cycle.
• Wrote SQL joins to retrieve the data to test the validity of reports generated.
• Communicated and recorded test results effectively and worked wif other teams responsible for supporting test issue resolution.
• Reported, recorded and tracked defects using JIRA until closure wif weekly defect status calls.

Hardware/Software:Agile Methodology, JIRA, Business Objects XI R2, SDK, Oracle 9i, XML, WinSQL, TOAD, Windows XP, Netezza, Informatica, Siebel CRM, EDI X12, XML, SOAP UI, Claredi, Facets.