SUMMARY

• Around 8 years of experience as a Business / Systems Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems, Health Insurance, Auto Insurance Home Owner Insurance and Crop Insurance.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile. Have good experience working on the Guidewire Policy Center system. Excellent knowledge of various policy administration industry standard tools such as Guidewire Policy Center and ACORD standards.
• Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
• Good understanding of different business processes used by Debit/credit card companies including but not limited to developing offer population, soliciting customer, defining and building product, accepting and processing payment, servicing customer.
• Experience in Business Process Analysis, Business Modeling, Business Intelligence, Data Warehousing, Data Modeling, User Acceptance Testing (UAT) and Implementation.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems, Master Data Management (MDM).
• Expert in the Property, Casualty, Home/ Auto insurance, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS. Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence). Experienced in manual and automated testing for both front - end and backend.
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• Diverse experience in Audit, Tax, Online Banking and Financial Services. Diverse experience in Banking and Financial Services.
• Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Experience in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server .

TECHNICAL SKILLS

Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, Quality Center, MS Project, MS Visio, MS Office Suite, Bloomberg, VBA for Excel, SQL, PL/SQL, Java, J2EE, C#, VB.NET, C++/CLI, Adobe Acrobat, PhotoShop, AutoCADDatabases Oracle, MS SQL Server, MS Access

Environment: Windows, UNIX (Sun Solaris, AIX, HP-UX), Linux, Mainframe.

PROFESSIONAL EXPERIENCE

Confidential, Plano,TX

Business Analyst

Responsibilities:

• Conducted meetings to understand the workflow, their processes and assisted in gap analysis to derive requirements for existing systems enhancements. Responsible for complete Domain Knowledge Gathering of the Property and Casualty segment.
• Interacted with the Underwriters for a formal understanding of the Premium Allocations for the respective Business opportunities. Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, and Commercial).
• Synthesized User Interface and Business Process Requirements and translated it into the Business Requirement Document (BRD), to be used as input to the functional design specifications. Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Work as a liaison between business and IT, eliciting and translating external and internal customer needs into solutions
• Defined AS IS and TO BE systems, Use Cases and Use Case Scenarios using Rational Rose.
• Created Use Case Diagrams, Activity Diagrams, Flow Diagrams. Conducted JAD Sessions aimed at transferring knowledge pertaining to Premium Calculations and Ratings.
• Interacted with the Claim Adjusters and the Claim Validation departments for building up a fool proof Claim Process Docket and conducted 1 on 1 session with the developers to transfer these details in technical validation points.
• Identified gaps in the business process. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Facilitated with JAD sessions with the management groups, vendors, users and the IT Group for open and pending issues to develop specifications.Executed SQL queries and joins using TOAD to validate the data.
• Worked closely with Business stakeholders to facilitate User Acceptance Testing and worked with the developers internally to resolve the issues by providing clarifications/feedback as suggested by business.
• Directed and managed the Change Control process for the project as a whole by facilitating group meetings, one-on-one interviews and corresponding through emails with work stream owners to discuss the impact of change request on the project. Extensively worked with MS Project
• Explore different phases in the lifecycle and then created the system in a way that the riskier claims could be easily identified and monitored. Used TOAD to retrieve results from the database and compare it with test results.
• Designed functional specifications for customization ofcredit cardfunctionality in Accounts Receivables.
• Responsible for preparing Process flows and Sequence diagram to capture the current state process in consensus with stakeholders.
• Investigate and link fraudulent onlinetransactionsin order to stop fraud rings.
• Reviewed alerts to determine if a true match to a suspect name will include, the results of periodic systematic accountholder screenings, real-time review ofonlinetransactionsand the review of specific issues escalated from business units
• Carried out regular meetings and walkthrough with development team members, Project Managers and Quality analysts to better understand system functionality in order to improve quality.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.
• Carried out UAT by developing test plans, test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications of the product.
• Documenting the RSS for future reference.

Confidential, River woods, IL

Business Analyst

Responsibilities:

• Analyzed clients systems and business processes. Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system
• Provide support across different domain areas such as Auto Assignment, Payments, Claims Documentation, and Appointment Logs, Auto Estimations, Fire Claims etc.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps. Wrote specifications for configuring business rules and functionalities in Guidewire. Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions. Followed Agile (XP) Methodology for the release.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users. Extensive involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts & claim counts.
• Responsible for Commercial Insurance Standards rating and risk factors for Auto and Garage commercial insurance.Worked in a fast-paced atmosphere SCRUM and studied business processes, legacy application, and the corresponding Guidewire functionality and conducted requirements sessions.
• Developed and maintained Service Oriented Architecture (SOA) governance process costing models and metrics ensuring architecture compliance.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories. Wrote several Test Plans and Test Scripts, Test cases, Test Metrics and all test deliverables
• 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.
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Created job schedules to automate the ETL process. Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification. Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Analyseonlinetransactionsto identify, recover, and prevent unauthorized activity on multiple clients.
• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Take a leading role in the valuation and development ofcredit cardproducts.
• Resolved all the issues pertaining to Point of Sales(POS) and the various transactions made at POS are checked and processed using the Debit Cards and Credit Cards.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• Implemented Agile Methodology And involve in strategic management in interacting with stakeholders' expectations and aspirations and engage in opportunities created by the stakeholders. Interacted with customers in call center environment to validate fraud/security claims
• Participated in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003. Extensively used calculations, variables and sorted inputs, drill down, slice and dice, alerts for creating business object reports.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Developed business requirement specification documents as well as high-level project plan.

Confidential, New York

Business Analyst

Responsibilities:

• Worked directly with Risk Analytics/Users to establish Business Requirements, defined and documented core business process information, business rules, business entities and other relevant information.
• Undertook back end testing using SQL and wrote queries.
• Set up market data including zero curves, correlation matrices, dividend curves, etc., and the underlying financial instruments and then set up derivatives pricing parameters and trade capture options that drive the valuation of trades based on the market data to configure and test the system
• Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non-financial transactions and trading operational processing in Wealth Management platform.
• Assisted in creating business requirements, technical specifications, implementation and test plans.
• Used Activity cost flow diagram to meet business requirements.
• Was responsible for creating the various end to end Straw man flows for the work streams and the Clearing Broker/Dealer using MS Visio.
• Evaluate the data transformed using Cognos reports
• Worked in Software development life cycle (SDLC) using Agile Scrum methodology.
• Developed the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Completed a GAP analysis to identify problems in the existing system.
• Conducted JAD sessions between the development team, business stakeholders, and end users.
• Analyzed the user requirements and translated them into functional requirements; prepared functional requirement document for Spread Matrix Phase II and product stress testing phase IV.
• Developed the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Prepared the Use Case views for a clear understanding between the vision document and the stakeholders using Microsoft Visio and Rational Rose. Prepared UML Diagrams such as Activity, logical, Component and Deployment views to assist development and engineering in understanding the requirements using Rational Rose.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Functional Analysis of Major features of AFC-BO (Refund Proposal, Card Replacement,FraudDetection, AuditingandSales certificate)
• Responsible with products like ATM transactions, Wire Transfer, Checking cards, Savings account and Credit cards.
• Assisting the customers in makingonlinetransactions and helping the customers to create theironlinePIN and password.
• Created job schedules to automate the ETL process.
• Developed backend calculations required to produce volatility and correlation matrix using SAS.
• Interacted with the developers to report and correct bugs.
• Provided test data to all the testers including UAT Business Edge team and UI testing team.
• Worked together with the development team and the Project Coordination Team to ensure client satisfaction.

Confidential

Business/Systems Analyst

Responsibilities:

• Interacting with various team and development to understand their requirements in order to in corporate in business requirement document (BRD) and ensure its implementation by working closely with internal stakeholders
• Prepare questionnaires and conduct interviews with stakeholders to understand the functionalities required to be automated / complete requirements with input and output and Business criticality of the features that would be released in iterations.
• Prepared business requirements documents by conducting client group interviews, JAD sessions and with other internal departments.
• Worked with the Scrum Team and the Product Owner to negotiate the minimum viable product for delivery
• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Analysing payment gateway system Up-time/Down-time(risk analysis), Ensuring availability of systems as per defined SLAs by intensively liaising with technology teams for RCAs
• Review the components of request for proposal (RFP) and figure out the details.
• Responsible for preparing FSD and translate into user stories as per the business need.
• Arrange the JAD session to elicit the real business needs from users and effectively manage user expectations
• Defined a Test Strategy and Prepared Detailed Test cases covering Business, Stakeholder, Functional and Technical Requirements
• Conduct Daily stand up meeting to update on the status to project owners
• Involved in execution, modification of the test cases, and bug verification.
• Performed competitive analysis of digital payment industry trends to support growth in core product Involved in performing functional testing, regression testing, visual testing, Adhoc testing, exploratory testing and smoke testing.
• Updating the test cases based on the Business Stakeholder Change Requests/Enhancements.
• Responsible for Bug management activities using Jira.