SUMMARY

• 8+ years of experience in Business Analysis for application development, working in the diversified domains such as Banking & Finance, Health Domain & Broadcasting.
• Excellent communication & interpersonal skills.
• Outstanding organizational skills including ability to multitask prioritize and manage increasingly complex issues.
• Strong work ethic, taking ownership of all duties and responsibilities and meeting management skills.
• Expertise with SDLC, Visual Modeling, Requirements/Business Rules Management, Process/Data Mapping, UML and Rational Unified Process (RUP) methodology.
• Exceptional knowledge of Microsoft Office Suite that includes Project, Word, Excel, Power Point, Visio and Access.
• Facilitated Requirements workshop, Joint Application Development (JAD) sessions with Subject Matter Experts (SMEs), Business User Groups, Top Management Groups and Technical Groups.
• Proficient in creating Business Requirement Documents (BRD), UAT Documents and Training manuals.
• Experience in preparing Requirements Traceability Matrix (RTM)
• Knowledge of Business Process Analysis & Business Process Modeling, and Workflow Automation.
• Participated in Test Plan Preparation, Test Case Preparation, and Manual Testing and performed User Acceptance Testing (UAT) working with team members.
• Good exposure/understanding in Profiles/Roles and Sharing Rules, Page Layouts, Email Services and Custom Objects, Relationships, Customized several Validation Rules, tasks, Workflow rules, Reports and Dashboards to achieve the complex business functionality.
• Knowledge of SQL
• Exclusive analytical, problem solving, Leadership Proficiency, interpersonal communication skills and quick learning abilities.
• Good knowledge of BABOK.
• Experienced in Onsite - Offshore Co-ordination, Test Management, Test Automation, Onsite Offshore Model Process Consulting, Requirements Management, Defect Management, Release Management and Team Management. Has performed planning and testing of Client/Server and Web applications
• Performed Black Box, White Box, Smoke Testing,IntegrationTesting, System Testing, End-to-End Testing, Regression Testing, Adhoc Testing, User Acceptance Testing (UAT), Data and Database Integrity Testing, Interaction Testing, Configuration Testing, Performance testing, use ability testing and security testing
• Extensive experience in writingSQLandPL/SQLscripts to validate the database systems and for backend database testing.
• Good understanding of industry process like Mortgage loans, Appraisals and able to quickly respond to request for data analysis and manipulation of large amounts of data with thorough attention to detail visualization to see a broader picture.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame...
• Experience inMercuryQualityCenter-Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Extensively strong on databases including Oracle 10g/9i/8i, MSSQL Server2000/7.0 and DB2
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizingPL/SQL.
• Excellent programming and problem solving skills on C, C++, VB,SQL,PL/SQL.
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writingSQLandPL/SQLscripts to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• ExcellentCommunication,AnalyticalandInterpersonalskills.

TECHNICAL SKILLS

• UML
• SDLC
• Agile
• Waterfall
• QA
• WAP
• CVS
• TEAMMATE
• MS Access
• Guidewire
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• Java
• Windows … basic UNIX
• HTML basic DHTML basic XML
• MS Office Suite-Excel Macros
• MS Project
• MS Visio
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Clear Quest
• Rational Omniture
• Crystal Reports various NIKU products
• C
• C++
• Sharepoint
• Docushare
• BASIC
• Intermediate level-Visual Basic
• Quality Centre
• Quick Test Professional
• TSL
• Java Script
• VB Script
• Shell Script
• Oracle 8i/9i
• SQL-Server2005/2008 and MS-Access
• MS-Word
• MS-Excel
• MS-PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Greensboro

QA Analyst

Responsibilities:

• Supporting in planning, designing, and development of business processes.
• Provided Retail functional design documents for development team including full life cycle implementation.
• Assisted in post go-live documentation to aid in the continuing support of the Confidential Application implementation.
• Work with Customer Service and Expeditors in day-to-day operations
• Involved in User Acceptance Testing with Business Partners and IT.
• Coordinate/collaborate with architecture teams, development teams and business partners.
• Troubleshoot production problems in Retail area.
• Configured purchasing structure, goods receipt, MRP, stock movements in IMG.
• Created many Enhancements in order to Customer specific requirements.
• Worked on Customer, Vendor and Material configuration.
• Worked with all the downstream system to check the Master data is processed successfully from MDM application.
• Providing recommendations in enhancing and expediting business activities.
• Collecting, compiling, and interpreting business data and drafting reports.
• Conducting clients' meetings, understanding and integrating their business needs into technology.
• Analyzed and documented all client requirements and business processes.
• Implemented master functionality and analysis for existing business.
• Maintained detailed documentation of process flow diagrams and operational support.
• Formulated standard operating processes and resolved sales field inquiries.
• Prepared and updated presentations for Sales IT departments.
• Reviewed existing requests from sales fields and updated ITEM database records.
• Evaluated security pricing data for quality control purpose.
• Developed MDM strategies and solutions utilizing SQL server MDS tools.
• Trying to gain an in-depth understanding of the company’s customers.
• Delivering presentations to Senior & Executive Management.
• Identifying the company’s goals and objectives.
• Putting together procedures manuals and system documentation.
• Participates in user acceptance testing programs.
• Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
• Participated in frequently held Defect Meetings which included Project Management, QA, Developmentand Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.
• Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing.
• Executedtest cases for data validation, link verificationand content verification.
• Involved in backend testing withSQL, check the data integrity and referential integrity.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive (non-batch) mode which will write to the main test.
• Responsible for computing apatchto update or fix problems within a supporting data.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participate in weekly meeting with the management team and walkthroughs.
• CreatedTest Casedocuments in MS Excel template from theTest Planand the Business Requirements documents.
• All the issues that came up during this process wereloggedinQualityCenterasDefects.
• Exported ManualTest Cases from MS Excel template directly to Mercury Test Director and executed 100% of theTest Cases in Test Director with Pass/Fail/Blocked status.
• Performed database integrity check usingSQLand Unix Shell Scripts.
• Updated QA Manager and Leadweekly with the testing statuswhich included Test Task Plan, Defect Managementand Test Metrics.
• VerystrongSQLskillsand experience withOLAP.Expertise in data-driven testing, drill down applications, writingtest cases and test scripts
• Used T-SQLfor Querying theSQL Serverdatabase for data validation and data conditioning Experienced in data analysis usingSQL,PL/SQLand many other queries based applications.
• Extensively used T-SQLto verify and validate the data loaded to theSQL Server2005
• Did complex data validation usingSQLqueries.
• Set-up of Test Environment forGUI testingand Back-end testing.
• RanSQLqueries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression andintegrationtesting with multiple departments.

Confidential, TX

Business Analyst/QA Analyst

Responsibilities:

• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
• Co-Authored the BRD using Use Case Diagrams, Use Case (Flow of Events) and Market Models.
• Conduct Joint application development (JAD) sessions with relevant Subject Matter Experts (SME's) to assess and document current configuration
• Using business analysis techniques as described in the BABOK; Requirements were gathered and translated to show the addition of new lines.
• Constructed a Requirement traceability matrix for the each requirement depicted the Requirement number, description, type, Use Case reference, priority, source and Impacted Business Units.
• Gathered requirements from stakeholders, developed Process Model and detailed workflow diagrams in order to implement the Advantage program. Prepared the Business Workflow using MS-Visio.
• Analyzed the impact and changes created due to the promotions on the billing systems. Worked with the billing team in restructuring the existing system in order to implement the promotion.
• Helped create the "As Is" and "To Be" Analysis Report of the project impact on the billing system with the use of data flow diagrams and sequence diagrams.
• Followed the Agile and Waterfall hybrid methodology for the entire SDLC.
• Created tangible timelines that meet project goals and adjusted accordingly. Monitored the progress of the project and updated the Project Status weekly on SharePoint indicating dates, deliverables and risks.
• Planned and coordinated efforts with both the On-Shore and Offshore teams. Interacted with 3rd party vendors to describe project goals and to get their commitment to the timeline.
• Worked with the clients on final signing process in the User Acceptance Testing (UAT) stages, the UAT testing was done using Templates as per the organization methodology.
• Involved in documenting test cases, scripts and resolving User Acceptance Testing (UAT), conducting SWOT Analysis, Cost Benefit and ROI analysis invoice management system.
• Experienced in internal training sessions though technical/non-technical presentation to the management and documented training manual for business users using Adobe acrobat.
• Performed Data Driven testing using QTP. Performed Cross Browser testing using IE and Fire fox on Windows Environment.
• Coordinating Functional testing,Integrationtesting, UAT and Regression testing.
• Creating test scripts usingQualityCenterand performing regression testing on new versions of the software.
• Worked on issues with migration from development to testing
• Solid testing experience in working withSQLStored Procedures, triggers, views and worked with performance tuning of complexSQLqueries.
• An extensively used ComplexSQLstatement for retrieving data using TOAD and it is used in TSL scripts
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Load new or modified data intoback-end Oracle database.
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-endIntegrationTesting to ensure data consistency on front-end by writing and executingSQLstatements
• Detailed repeatable end to endtest cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizingSQLPlus.
• Involved in fixing invalid mappings, testing of sessions and the target data.
• Extensively createdSQLscripts during pre and post load of data.
• Scheduled several workflows for its execution.
• Checked the data flow through the front and backend and usedSQL queriesto validate the output data with the database.
• Performed PreMigrationAssessment,Migration& PostMigration
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Tested several reports and automated using Quick Test Pro.
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Extensively executedSQLqueries in order to view successful transactions of data and for validating data.
• Based on the business requirements, createdTest Plan,Test Cases, and Test Script documents to test the Business Objects reports.
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• UsedSQLqueries and custom programs to perform data validation.
• Preparedtest cases by understanding the business requirements,DataMapping documents and technical specifications.
• Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
• Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
• Extensively involved with backend testing by writing complexSQLqueries.
• Worked closely with the development teams to replicate end user issues.

Confidential, St. Louis

BA Analyst/QA Tester

Responsibilities:

• Gathered requirements from stakeholders, developed Process Model and detailed workflow diagrams in order to implement the Advantage program. Prepared the Business Workflow using MS-Visio.
• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
• Co-Authored the BRD using Use Case Diagrams, Use Case (Flow of Events) and Market Models.
• Conduct Joint application development (JAD) sessions with relevant Subject Matter Experts (SME's) to assess and document current configuration
• Using business analysis techniques as described in the BABOK; Requirements were gathered and translated to show the addition of new lines. The data flow for order placement from various portals to the DirecTV servers where the orders were received.
• Followed the Agile and Waterfall hybrid methodology for the entire SDLC.
• Designed and developed QA test strategy and test plan based on the requirements documentation.
• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, Detailed Design Documents and Requirement Matrix.
• Involved in testing the workflows of scheduling.
• Involved in testing reviewing and acknowledging the orders for inpatients.
• Involved in writing test cases and scripts on Hospital & Professional billing in Resolute, registration in Cadence and prelude.
• Created Test Scenarios from use cases based on Functional Requirements Document and Design Requirement documents.
• Working knowledge on ADT (Admission, Discharge and Transfer) and Ambulatory work flows in EPIC
• Participated in test execution, issue identification, review and resolution process during QA/Integration phase.
• Conducted peer reviews for high-level test scenarios, test plan and test cases
• Tested the connectivity of the interfaces and triggering of the key HL7 message types from Legacy Mainframes to EPIC Products.
• Developed test cases and test scripts for all EDI Transactions.
• Responsible for writing and executing the test cases for corporate web portal and communication interfaces using Mercury Quality Center.
• Manually created EDI transactions based on Interface mapping specifications for system testing.
• Inserted various types of Checkpoints like GUI( and record), bitmap, Text and Database Generated the test tree while recording to represent each operation performed in the browser.
• Tracked problems/bugs and fixes. Reported bugs, created and provided metrics on bugs, resolution turnaround and testing processes, including test cycle times.
• Work closely with the interface team to support for different modules like
• Responsible in application testing: unit, regression, stresses testing in order to prepare systems for migration into production.

Confidential, Oklahoma

BA Analyst/QA Tester

Responsibilities:

• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
• Co-Authored the BRD using Use Case Diagrams, Use Case (Flow of Events) and Market Models.
• Conduct Joint application development (JAD) sessions with relevant Subject Matter Experts (SME's) to assess and document current configuration
• Using business analysis techniques as described in the BABOK; Requirements were gathered and translated to show the addition of new lines. The data flow for order placement from various portals to the DirecTV servers where the orders were received.
• Prepared detailed business requirement documents.
• Reviewed the Business Requirement Documents and the Technical Specification.
• DevelopedTest Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed System Testing and Integrity Testing using Win Runner.
• Developed, tracked and managed Issues Log created during the test phase using Excel.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• PreparedTest Planfrom the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Performed data integrity testing by executingSQLstatements and manually verifying the contents.
• UsedSQLon UNIX platform to perform Backend Testing on databases.
• Performed extensivedatabase testing.
• Performed Load Testing, Stress Testing and Performance testing using Load Runner.
• Involvedin writing testing methodologyby following standards for test documentation, test requirements and test procedures.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design thetest plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.
• MaintainSQLscripts for creation of database objects.

Confidential

QA Tester

Responsibilities:

• Developed Test Plan and Test Cases for Manual Testing.
• Performed black box testing of the application and GUI.
• Created Test Scripts based on business requirements for the GUI, functional, Integration, System and end-to-end testing
• Conducted numeric, non-numeric and limits data validation using positive and negative data.
• Wrote, maintained, and executed automated test scripts using Segue Silk Test for the Regression testing.
• Wrote test procedures for other test engineers to apply.
• Executed back-end testing using SQL queries.
• Found, logged, verified and analyzed bugs.
• Performed manual testing of the feature individually to complete black box testing of the application.
• Developed a regression-testing infrastructure for ensuring the quality of the application.
• Investigated the software bugs, provided clear and concise bug reports to the development team using bug-tracking system “Bugzilla”
• Coordinating Functional testing,Integrationtesting, UAT and Regression testing.
• Creating test scripts usingQualityCenterand performing regression testing on new versions of the software.
• Worked on issues with migration from development to testing
• Solid testing experience in working withSQLStored Procedures, triggers, views and worked with performance tuning of complexSQLqueries.
• An extensively used ComplexSQLstatement for retrieving data using TOAD and it is used in TSL scripts
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Load new or modified data intoback-end Oracle database.