SUMMARY:

• Expert in Managing Manual and Automated QA Projects| Prior Software Development and Testing Experience.
• Over10 yearsof IT experience in Analysis and Testing of Business Intelligence solutions using Conversion Data,Data Warehouse/Data Mart Design, Manual,ETL, OLAP, Client/Server applications.
• Experience with ACSR(CSG), ICOMS, OSM, UIM, OFGW, Postman, WinScp & Splunk.
• Created test scripts, test cases for Selenium Web Driver, test execution and test results for members claims
• Worked on variousDomainslikeTele Communications, E - Commerce,Health Care and Pharmacy.
• Experience in writingSQL QueriesusingOracle,SQL ServerandTeradatain validating data into Data Warehouse/ETL applications.
• Strong working experience in theData Analysis,Data Verification and Validationof an ETL Applicationsusing Backend/Database Testing.
• Experience with working tools likeTOAD, MS SQL Server Management studio,Win SQLfor creating and executing SQL Queries.
• Experienced in complete Software Development Life Cycle(SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle.
• Extensive experience inBlack Box TestingFunctional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing on Warehouse Applications.
• Involved in preparation ofTest Plans,Test Casesbased on High level requirements and make an ensure detailed/system level process wroteTest Scripts
• Involved in preparation ofTest Datato test the functionality of ETL Sources Mappings and Targets.
• Worked under testing methodologies likeAgile-SCRUMandWaterfall Model.
• Involved in testing of Business Objects reports by executing the SQL Scripts.
• Expertise inDefect management,Bug tracking,Bug Reportsand generating the graphs using Test Management Tools such asQuality Center,MS Visual Studio & TFS (Team Foundation Server).
• Involved in preparation ofTraceability Matrixbased on High/Detail requirements and Test Cases.
• Experience in maintaining support documents,QA Sign offDocuments and maintainingWeekly StatusReports.
• Familiar withPL/SQLCoding, Normalized Database creation in relational.
• Software QA Software Team Leadwith full system development lifecycle experience including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault-free audits.
• TestedFull load & Incremental loadby entering the sample test data to couple of entities and making sureInserts & Updatesof loading the data is done correctly.
• Backed by strong credentials, advanced command of various testing suites, Scrum Methodology and monitoring tools; and cross-platform skill.
• Responsible to oversee the functional, integration and user acceptance testing of the enterprise healthcare solution. Testing scope included: Member enrollment, Claims processing, EDI 834 Benefit Enrollment and Maintenance file processing using HIPAA 5010 standards. Key responsibilities included.
• Collaborate with the rest of IT on the development of best practices that provide continuous integration and delivery.
• Measure and monitor progress to ensure application releases are delivered on time and within budget, and that they meet or exceed expectations.
• Worked with the Quality Assurance Analysts to create test cases and conducted Functional and User Acceptance Testing (UAT) with business users.
• Experienced in Software development life cycle(SDLC), C++, C#, .Net and other Microsoft products TFS / MTM / Visio / Visual Studio / Microsoft Project / SQL Server / SharePoint / WorkFront .
• Experience in developing PL/SQL and SQL statements in databases such as ORACLE.
• Hands On experience with SoapUI and Web Service.
• Heavily involved in Integration, Regression, Smoke and Functional Testing.
• Tested EDI solutions, utilizing a solid understanding of structure and processes including 834, 878, 879 file types, MedImpact proprietary layouts and First Data Bank International drug database.

TECHNICAL SKILLS:

Databases: Oracle RDBMS V7, 8i, 9i, 10g, 11g

Languages: JAVA, JAVA Script, VB Script, COBOL, BASIC, PL/SQL, SQL*PlusHTML, XML, Cucumber

Tools: Oracle Portal, PL/SQL, SQL*PLUS, Application Object LibraryDeveloper2000, Developer 6i (Oracle Forms 10g, Form 6iForms 5.0, Forms 4.5 & Reports 10g, Report 9i, Reports 6iReports2.5), Oracle SQL*Loader, Oracle Enterprise ManagerSQL Developer, PL/SQL Developer, TOAD, HP ALM (Quality Center), QTP, SOAP UI, JIRA, WinSCP, JSON, BridgGateConfluence, Web Services, UC4, Jenkins, GIT, Stash, StarteamWinSCP, QTP, Eclipse, Selenium, BPM, SoapUI, Filenet, .Net workshop and other Microsoft products TFS / MTM / Visio / Visual Studio / Microsoft Project / SQL Server / SharePoint / WorkFront, PuTTy,Postman, Kafka

Applications: BPS, OSM, UIM, OFGW, BPM, KFS (Kuali Financial System), SciQuest, TSM (Total Supplier Management), Oracle (A/R, AP, GL, PA, PO, HR, CRM)

Operating Systems: UNIX (SUN Solaris, HP-UX), Windows 7, Windows XP, Windows 2000, Windows NT, Windows 98, Windows 95

Methodologies: Agile, Scrum, Water Fall, Oracle AIM 3.0

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Software Technologist / Team Lead

Responsibilities:

• Provide leadership, guidance and support in the development of progress at all system layers, including data, processing, and front-end systems.
• This position is responsible for design, development and implementation of information technology systems, as well as consulting with project owners to resolve issues regarding operations, implementations, and system status.
• Research and recommend strategies for department direction on Operational. Management Systems, technical interfaces, automated system solutions, and server-related topics.
• Provide technical leadership on complex projects and research new technology for use by department.
• Experience in Json, Postman, Kafka, XML, SQL Queries, SOAP Utilities, Automated and Manual Testing.
• Actively and consistently supports all efforts to simplify and enhance the customer experience.
• Actively and consistently supports all efforts to simplify and enhance the customer experience.
• Research new technology products and make strategy recommendations to management and leadership.
• Coordinate and perform routine operating system and application reconciliations maintenance, including backup and recovery processes for applications and databases.
• Act as a technical expert to provide technical support and software upgrades for applications.
• Manage relationships with hardware and software vendors.
• Experience with ACSR(CSG), ICOMS, OSM, UIM, OFGW, WinScp & Splunk.

Confidential, Rancho Cucamonga, CA

Software Quality Assurance Manager

Responsibilities:

• Responsible of migration from legacy system to new system.
• Responsible for implementing of QA tools and process improvements.
• Recruited and mentored a world-class QA team of 15.
• Established and introduced QA process for Confidential enterprise.
• Implement and introduced Automation QA process for Confidential .
• Established and introduced TFS/MTM for Confidential enterprise.
• Introduced several key processes that improved project schedule integrity and product quality, such as templates for test plans, RTM, code reviews, and formal technical reviews.
• Organized SQA team into functional roles to inject focus into overall efforts and eliminate historic inconsistent ad-hoc testing.
• Experienced in TFS/MTM(Writing/Executing Test cases, RTM, Defect tracking and so on)
• Responsible for testing methodology, processes and test automation at Information Recovery Management.
• Hired QA engineers, conducted performance reviews, and developed job descriptions.
• Introduced and supported documentation of functional requirements as use cases.
• Improved quality of Healthcare Enterprise Solutions Plus Healthcare application through requirements test coverage and traceability.
• Made a successful presentation 'Organizing Test Data for Reusable Scripts’.
• Delivered feature, systems test cases and results. Provided technical QA leadership and career guidance.
• Enhanced team's performance and bug find rate by re-prioritizing team's test efforts.
• Improved defect find rates by introducing feature test plans, detailed test cases and driving regression testing automation initiatives.
• Contributed towards development and execution of test cases for various stages like Smoke, Integration, End-to-End, Regression, User Acceptance, Usability and Ad-hoc testing.
• Developed system integration and acceptance test strategy in deadline-driven environment.
• Planned and managed the test phases of all team projects, worked collaboratively with software development and project management to develop test requirements and plans to ensure thorough coverage for each project.
• Maintained relationships with internal and external partners to ensure the delivered services meet the needs of the stakeholders.
• Managed the QA validation initiative, keeping stakeholders apprised of risks and contingencies. This contributed to the project being completed ahead of schedule and improved the external image of the company.
• Initiated strategic plans to improve test coverage and efficiency of the department utilizing/designed metric measurements and tracking of process and resource.
• Improved Test Process in the areas of Test Strategy, Test Planning, Test Design & Execution and Test Environment promoting the maturity level from Initial to Managed according to the new System.
• Coordinated with developers to establish thorough test procedures that helped meet deadlines.
• Produced and distributed weekly progress and bug status reports for all active test cycles.
• Perform defect analysis and review to correct and improve the software quality.
• Create test environment and test tools to facilitate the integration testing.

Environment: Window 7, SQL Server, Oracle Database, Microsoft Office Professional, SharePoint, Workfront, SQL scripting, Water Fall & Agile software development life cycle(SDLC), C++, C#, .Net workshop, Visual Studio, Visio, Microsoft Project, TFS/MTM, EDI 834, 835, 837

Confidential, San Diego, CA

Team Lead Software Quality Engineer

Responsibilities:

• Worked with Business /Technical Analyst in analysis of functional design specifications of ETL/Data warehouse .
• Tested loading of Source data (Transactions, Invoice, Orders, Payments etc) to ERP & EDW target Oracle systems.
• Involved in creation ofTest Plans, Test Cases, and Test Executionbased on mapping specs to validate the platform data.
• UsedTOAD for Oraclein creating & executingSQL queriesfor testing ETL process.
• TestedFull load & Incremental loadby entering the sample test data to couple of entities and making sureInserts & Updatesof loading the data is done correctly.
• Ensured internal and external customer requirements were met by verifying product functionality and performance against product requirements and specifications.
• Executed and tracked testing of assigned MedImpact proprietary products, including new products and modifications to existing systems.
• Created test scripts, test cases for Selenium Web Driver, test execution and test results for members claims
• Validated MemberID for members and verify member’s eligibility for claims approval.
• Developed and involved with end-users to establish UAT test scenarios.
• Developed and verified testing documentation, including test plans, estimates scope and work effort, procedures, test scripts, test cases, test execution and test results.
• Created and executed Grey Box test cases.
• Developed and executed quality assurance test scripts, tests plans and checklists in HP Quality Center.
• Mapped the business requirements with the test cases in HP ALM and maintained a complete traceability matrix between the requirements and test cases to ensure every requirement was covered by test cases.
• Executed the test cases in HP ALM and generated reports useful for the “Testing Status Meetings”.
• Established and maintained structured testing methodology and environments and respond to inquiries from users and technical support regarding functions and operations of software programs.
• Identified process improvements, error trends and/or the root causes and made recommendations for remedies to colleagues and management.
• Responsible for presenting data too, and working with, non-technical MedImpact cross-functional team members.
• Highly proficient in analyzing and reading the functional specs.
• Use standard testing methodology including regression and performance for new and enhancement products.
• Work closely with business analysts in support of documenting functional requirements.
• Provided time estimates for completion of tasks and provides status reports to management.
• Worked with the Developers on issues and enhancements.
• Analyzed test results and generated summary reports.
• Arranged and attending regular meetings to discuss the outstanding, critical and high defects.

Environment: Window 7, UNIX,SQL Developer, Oracle Database 11g,QC(ALM),Confluence, Microsoft Office Professional, SQL scripting, Agile software development life cycle, BridgeGate, WinSCP, CSV, JSS, Json, Java, Web Services, Soap UI, Eclipse, Selenium, Git, Stash, StarTeam, BPM, Filenet

Confidential, Los Angeles, CA

Team Lead Software Quality Engineer

Responsibilities:

• Developed test strategies, wrote test plans, developed test scripts for Accounts Payable& PurchaseOrders.
• Managed test tasks and conducted tests on assigned projects using QTP.
• Use standard testing methodology including regression testing for new and enhancement products.
• Reviewed, enhanced, and created the deliverables during the whole SDLC/SLC.
• Wrote and executed test cases for JIRA.
• Developed and executed quality assurance test scripts, tests plans.
• Extensively used JIRA and reported defects.
• Provided defect documentation, tracking and reporting; ensure that incidents are entered with adequate information to fully describe and reproduce the issues.
• Maintained test logs and document test results; analyzed test results to ensure the integrity of the applications functionality.
• Work closely with business analysts in support of documenting functional requirements for Accounts Payable and PurchaseOrders.
• Oversee and mentor onshore and offshore QA testers on testing efforts.
• Worked with the Developers on issues and enhancements.
• Highly proficient in analyzing and reading the functional specs.
• Highly experienced in performing backend testing using complex SQL queries.
• Experienced managing project using tools like JIRA (Defect Report) and Confluence.

Environment: Window 7, UNIX, MySQL,SILK, Web Services, XML, Java / J2EETechnology, Accounts Payable, Purchased Order,KFS (Kuali Financial System), HP ALM 11.0, SciQuest, TSM (Total Supplier Management), QTP, VB Script, JIRA (Defect Report)