SUMMARY:

• 8+ years of Industry experience as aBusinessAnalystwith solid understanding ofBusiness Requirements Gathering,Financial and Insurance BusinessProcess Mapping, Business Requirements Analysis, Risk Analysis and the Software Development Life Cycle Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• In - depth knowledge of USAProperty&CasualtyInsuranceMarket, Large Account Risk Pricing Tools, Reinsurance market,Businessreporting (both Facultative and Treaty), Ceded - Assumed, RetroBusiness, Reinsurance Accounting, CAT Bonds, ART (Alternative Risk Transfer) Tools
• Well-versed with all the phases of SDLC, including methodologies’ like Waterfall approach, IBM RUP, Agile and Scrum.
• Worked in ETL environment involving Informatics/Data Stage and Business Intelligence tools like Cognos, Business Objects
• Experience in multiple-line insurance organization offering predominantly personal automobile and Homeowners
• Excellent writing skills inBusinessrequirements document (BRD), Functional requirements Specification (FRS), Systems Design Specification, Systems Requirements Specification (SRS).
• Expertise in broad range of technologies, includingbusinessprocess tools such as Microsoft Project, MS Excel, MS Access, MS Visio, Data Modeling and Design.
• Worked withBusinessIntelligence (BI) Tools like Micro Strategy and Informatics
• Expertise in RDBMS concepts, SQL queries and PL SQL functions, stored procedures and triggers
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored ProceduresKnowledge of Data-warehouse and ETL process
• Experience in Microsoftbusinessintelligence(MSBI) tools- SSIS, SSAS and SSR
• Familiar with Client-Server architecture, Service Oriented Architecture (SOA) and Model-View-Controller (MVC) paradigm
• Experience diverse and challenging problems that have effects on thesupplychain. Identify and point out key areas of interest for discussion at working group sessions
• Experience working in various domains like Accounting Auditing, Loan Mortgage, Financial (Banking) Homeowner and well-versed in Fixed Income, Equity Income and Derivatives (Futures, Forwards, Options and Swaps)
• Experienced implementing Operational Risk Management and Mitigation strategies.
• Possess an understanding of the trading and settlement process to be able to put the activities of front, middle and back office into perspective.
• Knowledge in Salesforce.com SFA, Force.com Apex Classes, Apex triggers, Integration, Visual force, Force.com API, SOQL, and SOSL
• Experienced in writing test plans and defining test cases involving GUI Testing and Prototype Testing, Regression Testing and User Acceptance Testing (UAT).
• Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Experience in building an Enterprise Reporting System to support asset management and credit risk management.
• Worked as a team lead/business analyst for the project from the SFDC team
• Extensive experience in developing Use Cases, creating Screen Mock-ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis and Risk Analysis.
• Experience on working in Commercial Lending in a bank or in IT projects with a bank.
• Experience in facilitating Joint Requirement Planning (JRP) sessions withBusinessUser Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.

TOOLS AND TECHNOLOGIES:

Methodologies: Rational Unified Process (RUP),Agile, SDLC (waterfall).

CASE Tools: UML 2.0, RationalRequisite Pro, Rational Rose,DBVisualizer

Tracking Tools: Clear Quest 2002, Clear Case, Quality center, Jira

Workflow Tools: MS Visio, MS Project, MS PowerPoint, MS Word

Databases: ORACLE (9i), SQL Server 2000(7.0/6.5), MS Access

Languages: SQL, HTML, XML, C

Analytical Tools: SAS, MATLAB, MS Excel

Operating Systems: Windows (XP/NT/2000), Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Orange, CA

Sr. Business Analyst

Responsibilities:

• Created as is process workflow and to be process workflow, and conducted GAP analysis.
• Analyzed more complex CCAR issues and provided recommendations to ensure compliance and risk reduction.
• Transformed legacy claims, Billing Centre and policy administration systems to Guidewire insurance product suit
• Experience in working in Market leading CRM software, such as Sales Force, Oracle on demand, Siebel, SAP and other open sources. Hands-on and Technical experience required
• Worked under the direction of a lead SAS Developer and capacity engineer
• Finalized new loan origination system to replace the existing one.
• Worked in data mapping, data visualising and creation of logical data flow for data transformation from source to target.
• Human Capital Management (HCM) recruiting and staffing logistics including payroll submission performance management, backgrounds, Drug Screening,
• Provided administration of enterprise mobility accounts utilizing multiple MDM platforms like Mobile Iron, Air Watch, McAfee and Toggle
• Experience in wealth management, trading systems, brokerage money movement and/or FDIC insured money market products.
• Involved in full life cycle of building a Data Warehouse including Dimensional and Fact Table Data Modelling.
• Planning, developing, documenting and testing the programs by applying SFDC technical knowledge
• Experience in building an Enterprise Reporting System to support asset management and credit risk management.
• Prepared Business Requirement Documents (BRD) for Enterprise Risk Case Management (eRCM) functionality of Actimize
• Good experience and expertise in Design and Implementation of PLM Solution
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Measured, Monitored and managed credit risk, thereby offering a broad range of analytical Capabilities and user control.
• Drive various internal strategic initiatives regarding new and existing capital markets solutions, providing the business development team with market research and analysis.
• Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master Data. Experience in flow testing, application testing and commercial lending.
• Effectively conducted JAD sessions to gather cross function information and different opinions.
• Performing weekly maintenance activity of Agile PLM server.
• Created a file of ACORD Forms for both Personal andCommercialLinesofBusinessused as the standards in all Property and Casualty markets
• Actively involved with training and mentoring new analysts with commercial lending, business process, and quality control.
• Manage or participate in several Special Projects teams involving customer progress tracking, global support resourceHuman capital management (HCM)
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Experienced and versatile with the concepts of Data Modelling / Data Warehousing and RDBMS Concepts
• Assisted the database team in understanding the ETL requirements. Promoted Cross Selling Wealth Management Products & Cash Management Products
• supported IBM Antivirus brand team managing inventory and marketing communications
• Appian based BPM applications to deliver management capabilities using Appian 7.5 SAIL.
• Assisted the business team in Business Case Modeling, Use Case Modeling using Rational Unified Process for preparing Functional Requirements documents
• Provided Sales Measurement reporting and analysis for national and regional teams in Business Continuity and Recovery Service division of IBM
• Liased with the CCARM project team to ensure that the US Market risk scenario team is aware of and can meet all project deliverables
• Experience in IT Business Analysis in the financial services areas, especially with OTC Derivatives
• Created reports connected to various databases like Guidewire Policy,GuidewireClaims and MDM as per business requirements
• Complete Software Development Lifecycle experience including requirements gathering, designing, implementing and supportingSharePointPortal Solutions.
• Responsible for the general administration and maintenance of the CRM database and insure that applications meet user's needs while keeping abreast with updates
• Interviewed Subject Matter Experts (SME’s) and carefully recorded the requirements in a format that could be reviewed and understood by both business people and technical people
• Experience in Coding SAS routines using native SAS and SAS Enterprise Guide interfaces
• Facilitatedjoint requirements planning sessions to gather requirements using UML and BusinessProcess Modeling Notation (BPMN).Definedrequirements forvalidations to be builtin theapplication
• Analyzed test data to detect significant findings and recommended corrective measures.

Environment:Agile, MySQL, SQL, MS SharePoint, UML, MS Visio, HTML, Load Runner, MS Office - (Word, Excel, PowerPoint), Windows XP.

Confidential, Hartford, CT

Sr. Business Analyst

Responsibilities:

• Worked closely with Subject Matter Experts (SME) to ensure appropriate technology provision to comply with standards and requirements for the new billing and pricing system.
• Ensure efficient, accurate and timely generation of reports to enable capital planning and adherence to CCAR regulatory guidelines
• Worked and enabled institutions to estimate and stress credit risk measures and rating estimates by using scorecards/models.
• Strong knowledge of Agile PLM processes and experience in redesign of product development process as per the business requirement.
• Responsible for installing, modifying and making basic repairs to microcomputer hardware and software systems in theHumanCapitalManagement(HCM)system
• In depth knowledge of OTC and Exchanged traded derivatives trade life cycle and trade
• Prepared logical data models, BRD, supporting document indoors containing essential business elements, definitions and descriptions of the relationships between the actors to analyse.
• Managed projects to support five person wealth management team and senior financial advisors.
• BusinessAnalystat Corporate loan Department, a dedicated credit processingpolicy sfor the Small & Medium enterprises with in the graps of policy center’s
• Experience in defining source-to-target mappings for loading operational system data into the data warehouse.
• Create Tableau software (BI), dashboards, data analysis, visualization and reports.
• Created reports connected to various databases like Guidewire Policy,GuidewireClaims and MDM as per business requirements
• Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master Data
• Provided Support to Equity Sales & Research Team of Investment Banking Department
• Research and analyze business processes of different projects as part of Capital Markets consulting division
• Thorough knowledge of treasury operations Match Funding, Fund Transfer Pricing, FATCA reporting, Forex, DebtMarket, Capital market, MoneyMarket, Interest rate risk management.
• Developed loading processes and scripts to combine data from disparate systems using ETL (Informatics) for Data warehousing purposes
• Provided Support to Equity Sales & Research Team of Investment Banking Department
• Technical knowledge of the Microsoft Office and the FITS Market Data Inventory System
• AnalyzedBusinessProcess Management (BPM), Service Oriented Architect (SOA), Industry Standards (BPMN, BPEL, WSDL) andTools(BizTalk, Lombardi)
• Developed webpage for user registration for loan origination process.
• Developed a web-to-lead functionality to vertrue.com site which directs leads to Salesforce CRM.
• Createdactivity report, logical components to extract business process flows and workflows involved in the project using Rational Rose, UML and Microsoft Visio
• Worked closely with Configuration and Theater teams to identify any risks and changes happening in SFDC and accordingly preparing a backup plan for the same
• Businessanalystsupporting commercial lines ofbusinesswithin a nationalproperty&casualty insurer..
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
• Applied Unified Modeling Language (UML) methodologies to design Use Cases, Use Case Diagrams, Activity Diagrams, and Sequence Diagram.
• Used Tableau Desktop and Tableau Server extensively in this project to deliver analytic solutions
• Assisted in Design and development phase of the implementation of Enterprise risk Management
• Meetings with developers and subject matter expert (SME) for project Pre-analysis
• Involved in doing data validation by writing SQL queries.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Tracked Demand Management to ensure that IBM staffing levels were maintained at proper levels to meet
• Software Development Life Cycle (SDLC) steps were followed in the application development process
• Presented the status of projects to clients
• Experience setting up new technology and competency including IBM BPM competency.
• Prepared requirement traceability matrices (RTMs) and managed all components Facilitated JAD Sessions among the different stakeholders, process owners and the IT team
• Maintained accurate tracking of alllossmitigationoptions applied as well as declined.
• Create Users and Groups Admin data for the Policy Center Application according to business needs.
• Facilitated Joint Application Development (JAD) sessions, as well as conducted interviews of appropriate business/technical stakeholders
• Wrote and executed Test cases while participating in User Acceptance Testing (UAT) Environment

Environment: Rational Unified Process (RUP), Rational Suite (Rational Test Manager, Rational Robot, Rational Clear Quest), Win Runner, Test Director, Windows XP, J2EE, MS Project, MS Outlook, Share Point, Microsoft Office, Word, Excel PowerPoint and Visio. UML, Windows NT, Java Script

Confidential, Duluth, MN

Business Analyst

Responsibilities:

• Experience as a Senior Data Analyst for Wealth Management area of large Financial Services firm
• Making recommendations to approving committees, strictly adhering to Banking norms and Credit through policy centers
• Maintained the administration tool to control user access to Agile-PLM client services.
• Obtained knowledge and wrote specifications for configuring business rules and functionalities in Guidewire
• Create and maintain data model/architecture standards, including master data management (MDM).
• BI Reporting andDashBoardswith SAS EBI 4.3 (SAS EnterpriseBusinessIntelligence
• Generated various requirements for Capital Markets (Fixed IncomeInvestmentManagement Business,
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modelling and Design.
• In-depth knowledge of USAProperty&CasualtyInsuranceMarket, Large Account Risk Pricing Tools, Reinsurance market,Businessreporting (both Facultative and Treaty), Ceded - Assumed, RetroBusiness, Reinsurance Accounting, CAT Bonds, ART (Alternative Risk Transfer) Tools
• Assisted the business team in Business Case Modeling, Use Case Modeling using Rational Unified Process for preparing Functional Requirements documents
• Worked with non-technical users in understanding their requirements, interpreting them to concrete reports using Tableau
• focused on the detailed process flows and data involved in regulatory reporting of the OTC Derivatives businesses
• Create and maintain data model/architecture standards, including master data management (MDM).
• Application ofassetmanagementmethodologies, evaluation of performance indicators among others
• Promoted Cross Selling Wealth Management Products & Cash Management Products
• Acted as liaison among the working partners of the project (vendor, users, developers, testers).
• Documentbusinessoperations, tools and functionalities forinvestmentmanagementprocesses
• Hands-on development, deployment and production support experience with IBM-BPM
• Created groups and roles in Guidewire Claim Center system, activating / deactivating Users in Guidewire Claims system.
• Created Use Cases using RUP/UML approach and validating with development using SDLC approach.
• PortfolioManagement, and Hedge funds), Brokerage and Trading Model within the front and middle office
• Conducted JAD sessions to resolve issues pertaining to development and testing.
• Active involvement in managing the requirement changes and validation.
• Conducted User Acceptance Testing (UAT) using Quality Center.
• Performed integration testing and system testing.
• Trained users on the implemented system and validation usability of the system.

Environment: RUP, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Rational Requisite Pro, UML, Java, Oracle, PLSQL, Windows XP, Quality Center.

Confidential

Business Analyst

Responsibilities

• Interacted with Subject Matter Experts (SME's) like Online Banking Managers, Mortgage and Equity Managers and IT Group to understand Business process, gather Business Requirements and Identify Enhancements.
• Backlogs pertaining to various issues were worked upon very extensively.
• Worked on the enhancement of the loan origination system to minimize the risk of default and foreclosures in future by revamping the existing credit evaluation and pricing engines.
• Developed and trained the COOS Department reps on the D-35 process and monitored quality of calls.
• Used ETL to mitigate the problem of database isolation level lock contention in transaction processing systems caused by attempts to run large, long running, analysis queries in transaction processing databases
• Demonstrated working knowledge of data integration tools such as Secure FEL servers
• Responsible for mapping and testing data requirements for futures, options and other derivative instruments into existing trade order management system and back-office accounting.
• Provide Business Support for the Enova PLM system and PDM Oracle applications utilizing Web-based, Internet and Oracle RDBMS technology
• Developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams using UML and MS Visio.
• Prepared various artifacts such as workflow diagrams, business process models, functional requirement specifications (FRS) and System requirements specifications (SRS) by interacting with end users, development team, the subject matter experts(SME’s) and other project team members.
• Prepared requirement traceability matrices (RTMs) and managed all components Facilitated JAD sessions among the different stakeholders, process owners and the IT team.
• Conducted User Acceptance Testing (UAT).
• Collaborated with the QA team to ensure adequate testing on software, maintained quality procedures, and ensured that appropriate documentation is in place.

Environment: Requisite Pro, Rational Rose, Clear Quest, Test Manager, SQL, PL/SQL, EDI, MS Visio, MS

Confidential

Business Analyst

Responsibilities:

• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Prepared estimates by interacting withbusiness, development and QA team.
• GatheredBusinessRequirements, analyzed data/workflows, and defined the scope, financial projections and Cost/Benefit analysis.
• Interviewed Subject Matter Experts (SMEs) and Stakeholders to develop detailed step by step use cases for functionality and process flow.
• Created Requirements Traceability matrix and used RACI matrix and analyze the requirements.
• Wrote as is- to be documentation for data mapping and conversion process.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the newbusinessrequirements for the mortgage LOS.
• Applied the RUP model throughout the entire development and testing process.
• Created wire-frames of Front-End design for the credit card application.
• Wrote SQL queries to extract data from Oracle databases and performed data analysis.
• Followed the UML based methods using Rational Rose to create Use Case Diagrams, Activity and Sequence Diagrams.
• Participated in performing Integration and Regression Testing for the LOS project.
• Maintain timeline and project schedules, using MS Project. Participate in complete project development life cycle.

Environment:Agile, MySQL, SQL, MS SharePoint, UML, MS Visio, HTML, Load Runner, MS Office - (Word, Excel, PowerPoint), Windows XP.