SUMMARY

• Demonstrated achiever with exceptional knowledge of international markets, business practices and trade regulations.
• Skilled at learning new concepts quickly, communicating ideas clearly and effectively. Extensive computer training, including knowledge of multiple networking environments and business software packages.
• Enthusiastic and experienced in overseas travel communication.
• Researched, wrote, and delivered oral presentations on various topics including work ethics, cultures, and values. Exceptional analytical, communication, and interpersonal skills developed through various customer service opportunities

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma

QA

Responsibilities:

• PerformedFunctional,Negative,Positive, Integration,Regression,End to EndandUser Acceptance Testing.
• Extensively involved in writing and designing templates for theTest PlansandTest cases
• Identified theTest Casesand documented them inQuality Centre.
• Worked with the Developers and the Test Lead to verify theTest Cases.
• Experienced in testing financial applications. End to end testing for various applications in integrated environments.
• Knowledge in working on testing tools like QC, QTP, Performance center.
• Designed and AnalysedTest casedesign document basing on theFunctional Requirement Specificationsto implement through testing process.
• Analysed and DevelopedTest Plan, Test Cases, Test Scripts, Expected Test ResultsandTest Procedurefromfunctional requirement
• Involved in creating theTraceability matrixbased onFunctional requirementin each module.
• Base - lineandRegressiontests were scheduled and performed on every Release and build.
• SupportedEnd-to-endtesting for downstream systems. Developed SQL Stored Procedures and Queries for Back end testing.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Worked extensively with MS Excel and MS access
• Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose / MS Visio / BPMN towards facilitating clear understanding of the business process.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Involved in the production support team for planning cycle after production implementation.Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Conducted JAD sessions for communicating with Stakeholders and Project directors
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

.

Environment: Agile, MS Word, MS PowerPoint, MS Excel, MS Visio, SQL with ETL process.

Confidential, Schaumburg, IL

QA

Responsibilities:

• Responsible for requirement gathering, conducting the risk calls for production integration. Reviewing created test plans, test cases and responsible for executing the Test Scripts. Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, and Commercial). Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Responsible for Quality Management Life cycle. Developed Data Flow Diagrams and Data mapping, illustrating the flow of data from the front end Claim Centre into the Application database Tables.
• Responsible for timely delivery of projects estimating the time required for requirement analysis, coding, testing. Wrote specifications for tasks, activities.
• Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, Commercial)
• Helped with data modelling and defining the conceptual and logical model of the data warehouse. Worked heavily on Union workers compensation obligations and their processing with thorough investigation.
• Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Wrote Test Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using SQL.
• Followed solely RUP methodologies during the course of the project.
• Performed Smoke, Integration, functional, Regression, and system testing.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Responsible for timely Code delivery of the Team Members.

Environment: MS Project, MS Visio, Visual Basic

Confidential, Florida

BA

Responsibilities

• Gatheird analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Met with individual departments to communicate SharePoint purpose, application and vision for the future.
• Completed the documentation of Claims Scenario's for the source system
• Was responsible for the hardware, software, upgrades.
• Understood the requirements of the Sales and Marketing team
• Updated the impacted MS Access tables.
• Worked hands on with the Multi-Channel Desktop to test it to ensure it meets the business requirements.

Environment: Windows XP Professional, Oracle9i, MS Access 2000, MS SharePoint, MS Excel, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, UAT/BAT, MS Office suite, MS Visio 2003.

Confidential

Office Assistant/BA

• Review files, records, and other documents to obtain information to respond to requests.
• Maintain and update filing, inventory, mailing, and database systems, either manually or using a computer.
• Organizing, Planning, and Prioritizing Work - Developing specific goals and plans to prioritize, organize, and accomplish your work
• Design using UML, Rational Rose and Visio.
• Ability to conduct JAD sessions with stakeholder throughout SDLC to resolve open issues.
• Strategized implementation of RUP effort throughout SDLC
• Knowledge of data modeling and mapping.
• Utilize RUP to configure and develop process standards.
• Develop prototype of new information for processing application.
• Develop use cases, workflow and requirements Responsible for creating a business process and workflow documentation using BPMN standards.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application. Designed and developed Use Cases and UML models using Microsoft Visio. Was responsible for requirement managing and database design and implementation of star-schema, dimensional data warehouse using Erwin. Extensively Used ETL to load data from different databases and flat files to Oracle.
• Created job schedules to automate the ETL process. Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.