SUMMARY

• Over 13 years of IT experience focusing on Business Analysis, Quality Assurance, Data Analysis and Data management.
• Experience in fields of Clinical trials (Pharma), Auto Industry, banking industry and Insurance organizations. Developing business requirement documents and functional specification documents for web based applications.
• Experienced in conducting Rapid Application Development (RAD) and Joint Application Development (JAD) sessions for communicating with Project directors and Stakeholders.
• Highly proficient in developing graphical depictions of Use Cases including State diagrams, Activity diagrams, Sequence diagrams, Use Case diagrams, Component - based diagrams, Collateral diagrams, Class diagram, Collaboration diagram, based on UML methodology using CASE tools like MS Visio.
• Scenario evaluations and sensitivity analysis through Endur.
• Software Development (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications, Development and Testing.
• Worked with project stakeholders to identify, model and then document their requirements and business domain details.
• Validated stakeholders requirements and analysis models via techniques such as reviews, walkthroughs and play acting.
• Experienced at leading BA/ QA teams, coordinating among different stakeholders, creating testing strategy and processes, overseeing the testing cycles, training and mentoring junior QA staff.
• Experience as a QA Analyst in Client/Server, Web Applications using Manual Testing and Automated Testing Tools with emphasis on Functional, System, integration, Regression & Performance Testing. Experience testing in an Agile environment.
• Solid experience in Business Analysis of business applications in diversified industries.
• Manage all testing resources (staff and tools); work with off-shore and on-shore staff and ensure that departmental policies and procedures are followed.
• Elicitation - Discovering the underlying business need to be addressed and information related to the product and project requirements, often through conversations with stakeholders.
• Analyzing Requirements - Organizing, specifying and modeling the requirements to ensure they are complete and unambiguous.
• Specifying Requirements- Documenting the requirements in a format that can be shared with stakeholders.
• Validating and Verifying Requirements - Ensuring the requirements map to the real business need, are approved by all relevant stakeholders, and meet essential quality standards
• Demonstrated excellence in creating and developing Test Plans, Test cases and Test scripts.
• Proven experience in Manual testing tool like Quality Center.
• Expertise in writing, maintaining and executing Test Strategies, Test procedures, Test plans, Test Cases, Test Results and generating Software Defect Reports.
• Strong B2C analytical, troubleshooting and debugging skills understanding the business requirements, business rules/processes, and detailed design of the application.
• Specialized in testing Web, GUI (Graphic user Interface) and On-line client server GUI applications.
• Team player with an excellent interpersonal, verbal and written communications skills, and ability to work well with a diverse team as well as ability to work independently and with minimal supervision.
• Results oriented, with an ability to work with aggressive timelines and deliverables and to see any assignment to successful completion within the established project schedule.
• Extensive work experience on SQL.
• Experience in working on WINDOWS-98/2000/XP and Windows NT environment.
• Testing Experience with Requirement Gathering/analysis, Development and Maintenance Projects
• Extensive Experience in White Box and Black Box Testing
• Experience with Test Director
• Experience in Testing Database Applications of RDBMS in ORACLE 8i, MS SQL Server2000/2005 and MS Access
• Experience in automated testing using ALM & QTP
• Expertise in Test Cases Development and Test Suite Development (Win Runner)
• Expertise in Defect Reporting/tracking until closed status using Defect Tracking Tools
• Experience with Object Oriented Programming, UML concepts, design patterns, and web Technologies
• Experience with QA Methodology and QA functions
• Possessing domain knowledge in Insurance, Banking and Financial, Pharmaceutical, Reporting products
• Quick Learner and Active listener with analytical and programming skills.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, Teradata V2R6, SAS, SQL, MS Access, SMART (Study Management and Recruitment Tool)

Tools: Test Director 7.6, HP ALM, Quality Center, SQL Assistant 6.1.0, MS Office (Word, Excel, PowerPoint), MS Visio, MS Projects, QTP.

Environment: HP-UNIX 10.20, AIX 4.2.1, Window 95/98/NT/XP/Windows 7, HP-9000, Endur 10.0

PROFESSIONAL EXPERIENCE

Confidential, MI

BA

Responsibilities:

• Work with Product Owner(PO) and Program Management(PM)
• Involved in development of web based project along with development team.
• Serving as the conduit between the customer community (internal and external customers) and the Software Engineering(SE) team through which requirements flow
• Gather the requirements from the PO and end client(Nissan)
• Developing Business Process Model, BRD’s and FSD’s
• Worked on Live data feeds that featured real time tacking position through Endur.
• Created:
• Use Cases
• Work Flow Diagrams
• Requirement Document(to get the sign-off from the end client), and
• Screen Mocks
• Translate each requirement into a user story
• Performed and lead processes related to quality assurance of the data warehouse processes
• Prepared Test-Scripts and Carried out System Integration Testing (SIT) to verify the functionality of the project
• Identify, model and then document requirements and business domain details
• Regularly following up with Development Team to discuss discrepancies identified during testing and performance tuning
• Organizing the status and defect tracking meetings with various teams as a program/project test lead and providing the status/defect reports to Program/Project Mangers, VP, QA managers etc. depending on the scope of the project/program for System, UAT, and End to End test phases
• Work with QA help QA with the:
• Test scripts
• Execution of tests, and
• Preparation of traceability matrices
• Stress testing through Endur.
• Attended the daily standup meeting
• Weekly status meetings
• Served as a liaison between PO and Software Engineering(SE) group

Environment: JIRA, TFS, MS Office, MS Visio, IDN, .Net, ASP, Agile

Confidential, MI

Marketing Operations Business Systems Analyst

Responsibilities:

• Work with IT & Business Test Manager and other Test Analysts to plan and track testing tasks, plan, traceability, ALM updates, daily status reporting
• Developed Business Process Model
• Coordinate with the project work streams and application teams in the creation, maintenance and execution of test cases and end to end business scenario
• Ensure requirements traceability to test cases and test results
• Communication of test metrics for Testers, Coordinators, Project Managers, Vendors, Lines of Business and IT and Business Test Manager
• Escalate testing defects, problems, and issues to Project Manager and Vendor
• Ability to navigate through operational systems. (CASS, CARS, LeMans, WebAMS Bekon, Lotus Notes, InfoLease, TFAM.
• Preparation of Business Requirement Document for FAW, CASS, CWB, Doc Management Portal, Western union phone pay and Online Pay, e forms, and other Marketing Functionalities.
• Documenting the requirements in ALM, that can be shared with stakeholders.
• Modeling the requirements to ensure all local landscapes are ambiguous and complete in all respect.
• Coordinating with large group of diverse resources like IT, Nexus, ALFA and Business.
• Driving and challenging business units on their assumptions of how they will successfully execute their plans.
• Serving as the conduit between the customer community (internal and external customers) and the software development team through which requirements flow.

Environment: HP ALM 11.0, Excel, MS Office, SQL, MS Project 2010, Bridgit, MS Visio

Confidential, San Diego, CA

Lead BA/ QA

Responsibilities:

• Accumulated customer requirements from various end users through surveys, interviews and JAD sessions
• Performed and lead processes related to quality assurance of the data warehouse processes.
• Lead daily BI stand up meetings.
• Presented BI to the daily Production stand up meeting and brought back the list of issue to the BI team.
• Validated stakeholders requirements and analysis models via techniques such as reviews, walkthroughs and play acting
• Assigned the issue using FIT Issue Management System to the concerned personnel and followed until FIT closure.
• Responsible for leading all the testing related activities including writing Test Plan, Test cases and SQL Script and execution of those script in EIS, and all test environment.
• Coordinating with the team members to make sure the preparation of test cases, functionality test and regression test will be completed as per the schedules.
• Training the new personal (Employees/Contractors) on board with Test Planning process and methodologies.
• Representing the Test planning team for the approvals of Technical requirements, detailed designs, Test plans etc.
• Used Toad to write scripts.
• Wrote SQL scripts to validate Data records, Control Total, Table structure, between OLTP to DWH.
• Monitored Classic and Refusion database.
• Performed day to day O&M.
• Verified extracts generated in Production which is automated by cron job.
• Monitored ETL jobs for any failure.
• Found root cause of the ETL failure and fixed that issue. And re-run the affected ETL job.
• Re-Run the affected extracts which was failed during ETL issue.
• Generated billing reports for ILI incentives.
• Write scripts for DCPS integration, test in all test environment and assigned to DBA to run in Prod.
• Validated ETL scripts with requirement documents to make sure ETL completes the requirement.
• Write SOP for Monitoring job, billing reports.
• Performed regression testing.
• Running batch job (Refusion) in Pentaho SE and validate that job ran successfully.
• Present any Production Data modification to CCB for approval.
• Validated DM records to make sure that dataflow from DWH to Cognos is in sync

Environment: SQL, HP ALM, Oracle 11g, Toad, Pentaho, MS Visio, QC, Excel

Confidential, NY City, NY

Business Analyst

Responsibilities:

• Performed analysis for the feasibility of the projects
• Interacted with the business users, stakeholders to define the Scope and Objective of the project, identify assumptions, constraints and dependencies
• Gathered the information and requirements from the user. Derived Business Requirement document (BRD), and Functional Specification Document (FSD)
• Facilitate JAD (Joint application development) sessions
• Worked closely with the SME’s (subject matter expertise) to identified elements that contribute risk
• Prepared Test-Scripts and Carried out System Integration Testing (SIT) to verify the functionality of the project
• Helped the users with UAT Test Scripts and in UAT
• Adhere to the Projects Time Lines and Delivery Dates
• Analyzed firm’s business processes using Work Flow Diagrams, Process Diagrams and GAP analysis
• Organizing the status and defect tracking meetings with various teams as a program/project test lead and providing the status/defect reports to Program/Project Mangers, VP, QA managers etc. depending on the scope of the project/program for System, UAT, and End to End test phases.
• Preparing the BRD’s, Test plans/Test Cases, conducting walkthroughs, taking approvals from clients and project teams.
• Assisted junior QA staff, reviewing test cases and execution results, providing feedback, training, and mentoring.
• Performed Manual System Testing & Regression Testing.
• Performed Navigational testing, usability testing and security testing.
• Prepared Defect Report.
• Responsible for developing test scripts using Win Runner and involved in regression testing by executing the automation test scripts.
• Analyzed user requirement document and developed test plans, which included the objectives, testing strategies, test environment and others.
• Managing QA environment and set-up.
• Performed Functional (Black Box) and Structural (White Box) testing.
• Created, Modified and Debugged the Scripts.
• Created and Performed Data Driven Testing.
• Created User Defined functions and used for automation testing.
• Conducted Distributed and multi-user testing.
• Conducted System and Regression testing identified application errors and interacted with developers to resolve technical issues.
• Wrote and recorded TSL scripts for automating the Functional testing procedure using Win Runner and Quick Test Pro.

Environment: Sybase, Oracle, MS Visio, MS Word, UML, IBML Messaging, Java SQL, Test Director, Toad, QTP 9.1, QC.

Confidential, Washington DC

Lead QA Analyst

Responsibilities:

• Gathered and analyzed user/business requirements and developed System test plans.
• Performed both Manual/Automated Testing.
• Regularly following up with Development Team to discuss discrepancies identified during testing and performance tuning.
• Quality Center was used to create the Test plan, store Test cases and run the Test sets.
• Involved in Analyzing, Validating and Verifying Business Requirements, writing and implementation of the Test Plan, various Test Cases and Test Scripts.
• Wrote and executed basic SQL queries for testing and report/ data validation.
• Managed the project using Quality Center, added test categories and test details.
• Created test scripts using QTP.
• Performed execution of test cases manually to verify the expected results.
• Performed Functional Testing using QTP.
• Used structural query language (SQL) for database operation and manipulation.
• Used QTP to conduct Data Driven Testing by pulling data from a table.
• Performance, Stress and Load testing using Load Runner.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Involved in Regression Testing, Backend testing, Functionality and Security testing.
• Used QTP for bug tracking, reporting and analysis.
• Meet with the developers and technical content writers on a daily basis to update the test documents.
• Follow up with developers on defects status on a daily basis.

Environment: QTP 8.2, Quality Center 8.2, MS SQL Server, Load Runner 8.1, UNIX Shell Scripting, Visual-Basic, Toad.

Confidential, Northbrook/IL

QA Analyst

Responsibilities:

• Analyzed the Business Requirements Document (BRD), modified the Test Plan and prepared detailed Test Cases.
• Established and executed test procedures, used defect tracking software packages, logged all defects, analyzed test results and defect data, reported on the status of project.
• Developed various test cases for data validation and business function validation of AUT.
• Used Putty to connect to the AS/400 server.
• Executed UNIX commands to invoke batch file processing.
• Participated with user groups to perform extensive User Acceptance Test (UAT).
• Went into server logs for the invoked batch job and logged exception errors found for that job.
• Once batch files were processed wrote issues found in statement validation between the PDF statements received through email and statements received from core (AS400), using the test cases in Test Director for those issues.
• Wrote issues found in notice validation between the PDF statements received through email and notices received from core (AS400), using the test cases in Test Director for those issues and reporting them.
• Maintained test records, provided ideas for improvement, assisted in maintaining client's change control system, developed documentation, including procedures used by other departments, reviewed documentation, specifications, test procedures, validated documentation, including operator manuals.
• Created, maintained and analyzed a product release testing, recommended process improvements, implemented and complied with client's quality system.
• Participated in the establishment of general system standards and rules for system testing.
• Tracked Bugs and Reported using Defect Tracking and Maintenance Tool.

Environment: Manual Testing, Test Director 7.6, QTP, Silk Test HTML, XML, VB.Net, ASP.Net, AS400, C#, SQL, Server, UNIX and Windows NT/2000

Confidential

Clinical Trial Tracking Manager/ CRC

Responsibilities:

• Creating, implementing, and upholding standard operating procedures (SOPs) for trial execution
• Act as the key operational interface with internal and external services to develop, implement, maintain and improve operational processes for clinical trial conduct.
• Adequate knowledge of clinical trial development (protocol development through submission)
• Interface with corporate CTMs, European CRA Team
• A quality scientific and medical design of the protocol
• Facilitate development of study tools and appropriate tracking systems for coordination of trials, grants, enrollment status and clinical supplies.
• Responsible for weekly status updates showing the progress of the project development effort and open issues to be resolved, interact with developers and users for any update and change in the application.
• Advanced understanding of SDTM including trial design / subject domains.
• Drug studies Tracking Data from all around Europe.
• Tracking subjects, avoiding lost-to-follow-up
• Creating scripts on the data and providing results to study teams.
• Expertise in Clinical Data Management Systems and in the use of data management applications.
• Adequate recording, validation and reporting of data in different formats
• Ensuring data quality through complex SQL statements against Oracle database.
• Plan, Do, Check and Act strategy.
• Data Integrity and Risk Management.