SUMMARY

• Over 8 Years of experience as a Business Analyst/Business System Analyst/Data Analyst in various domains including Finance, Banking, Mortgage, e-Commerce, Mobility, Insurance Property Casualty/Worker's Compensation
• Expert communicator written, verbal and presentation involved in high level interaction and influence with variety of audiences Senior Executives, Clients PMs, developers, SME as well as PMO
• Experience analyzing and documenting project scope documents and SOWs, project plan, project/requirement change request forms, BRD, FRD, SDD, requirement traceability matrix, use cases/sequence diagrams, UML, wireframes/mockups, end user documentation and BPM notations
• Worked extensively with teams for development of Business Rule Engines to support SOA architecture and web services.
• In depth knowledge of the Software Development Life Cycle SDLC using Agile and other methodologies such as Rational Unified Process RUP and Waterfall
• Experienced working with Business Intelligence BI and Data warehousing tools like Cognos, Hyperion Essbase, and Informatica.
• Experience in design, configuration, development and deployment of Business Intelligence applications using OBIEE.
• Proficient in IBM Security Identity and Access Management IAM
• In-depth knowledge of Project Management Book of Knowledge PMBOK
• Proficient in creating and managing Requirement Traceability Matrix RTM for tracking and managing changes based on project's evolving needs.
• Facilitated Joint Application Design JAD and Rapid Application Development RAD teams with all IT group members for communicating managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy.
• Working knowledge in writing SQL query for identifying databases involved in the application development.
• Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative OTC Back-Office operations.
• Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income, and Title functionalities
• Understanding of investment banking, asset management and other fund management functions.
• In-depth knowledge of Anti Money Laundering AML and Bank Secrecy Act BSA . Worked on Suspicious Activity Reporting SAR , OFAC reports, Currency Transaction Report CTR , Foreign Bank Financial Accounts FBAR and CMIR reports.
• Understanding of different mortgage instruments like Mortgage Backed Securities MBS , Collateralized Mortgage Obligations CMO , Asset Backed Securities ABS , including the tranche structuring and credit enhancement processes to manage prepayment and credit risk. Knowledge and understanding of the functions of mortgage agencies like Ginnie Mae, Fannie Mae and Freddie Mac.
• Understanding of Dodd-Frank Act and the implications of its various key provisions like Volcker rule, Collins Amendment on bank's trading activities and capital requirements including Basel II, Basel III.
• Extensive experience in developing and enhancing applications for financial processes including Hedge Funds Pricing, Trade and Settlements operations.
• Worked with star and snow flat schemas to create fact and dimension tables.
• Created tabular, matrix, pie, bars and column reports to meet client requirements.
• Performed ETL and analyze different sources of incoming data and performed various transformations.
• Performed GAP and cost-benefit analysis as required.
• Worked extensively with application programmers to develop proposed solution prototypes.
• Wrote use cases and Developed Test Plans and created Test Cases.
• Obtained expertise in performing System, Acceptance, Regression, Integration and Functionality Testing.
• Exceptional understanding of the QA life cycle, from test plan, test scripts, issue resolution to User Acceptance UAT , System Integration SIT and end-to-end testing
• Performed financial analysis such as cost analysis, NPV, IRR, and ROI as well as risk analysis
• Worked on Reports based on the requirements and Test driven development TDD
• Experience using DMAC and RASCI methodologies, root cause analysis etc.
• Proficient in Creating and Transforming Business Requirements into software requirement specification SRS using MS Word and Rational Requisite Pro.

SKILLS

• Project Methodologies: RUP, Waterfall, Agile SCRUM
• Business Modeling Tools: MS Visio, Rational Rose
• Requirement Management Tools: Rational Requisite Pro, Caliber RM
• Quality Management: DevTrack, Bugzilla, Jira, Quick Test Professional
• Defect Tracking Tools: Rational Clear Quest, Quality center
• Languages C , Java, HTML, .NET, XML
• Operating Systems: Windows NT/XP/2000/7
• Web dev tools: Dreamweaver, FrontPage
• Databases: Oracle 11g, Oracle 8i/9i/10g , SQL Server, MS Access
• Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office
• BI/ETL Tools: Informatica, Cognos 8.4, Essbase, OBIEE 11g

EXPERIENCE

• First Mercantile provides retirement plan recordkeeping and investment management services. The Project encompassed of providing a new platform for First Mercantile Recordkeeping and Investment services after acquisition by Mass Mutual. The Investment Data Tec strategy IDT platform has 7 independent functionalities which allow the accessibility of data and financial information as needed.
• As a Business Analyst I was responsible for two of them, Reconciliation and Reporting. The basic understanding of Reconciliation was to have independent check points and data verifications automated for internal compliance purpose. The Reporting module was complex and had to address in manner that none of FMT reports are missed as it is an active business. Hence for generating these reports in same manner the acquisition of data was important. This was done by feeding the data to BIF Business information factory: data ware house and then retrieving the data when needed.

Responsibilities

• Interacted with the Subject Matter Experts SME's and stakeholders to get a better understanding of client business processes and gathered business requirements for Reconciliation and Reporting functionalities
• Created detailed Business Process Models BPM and documentation during the initial discovery phase of the project.
• Defined and updated BPM Business Process Models for various applications by interacting with the application owners and Subject Matter Experts SME's .
• Prepare project progress reports and status reports for management on an ongoing basis.
• Collect and analyze existing customer data and external market data, to identify market trends and opportunities.
• Manage OBIEE technical requirements based upon SME information and determine optimal development approaches.
• Develop OBIEE metadata repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer. Work on customizing Repository and configure metadata objects Subject Area Table Column and Web Catalog Objects such as Dashboards, Pages, Folders, and Reports.
• Use Data Modeling Physical Logical , Data Analysis and wrote High level and Low level Design Specifications for ETL and Business Intelligence BI . Work with ETL team for data mart modeling to design complex OBI repositories BI solutions.
• Collaborate with project and client leadership to configure interactive dashboards to track progress.
• Create iBots to send preprocessed reports using OBIEE Delivers.
• Generate tables, listings, and graphs using Excel, also used Excel to generate end of day reports for input into OBIEE.
• Utilize OBIEE Administration Tool components in both Application and Business modeling.
• Responsible for developing/converting over 200 discoverer reports using OBIEE 11g.
• Validate reports using OBIEE and Oracle data warehouse in comparison to current FMT reports.
• Lead requirement reviews with business and technology teams.
• Critically evaluate information gathered from multiple sources.
• Reconcile conflicts and break-down high-level information into details.
• Distinguish user requests from the underlying true needs for Reporting Functionality.
• Performed extensive requirement analysis including data analysis and GAP.
• Design detailed Use Cases to then derive Functional requirements from detailed Use Cases.

Environments: OBIEE 11g, Oracle 11g, Oracle BI Answers, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher MS Visio, SQL, PL/SQL, InteGREAT, SharePoint, Lync, WebEx.

• M T Compliance Technology MTCT the primary goal of MTCT was to enable surveillance of firm and client activity, support the customer identification process, and help ensure that the firm is not transacting with sanctioned entities. MTCT would also support the disclosure of firm and client holdings and trading activities, as required by laws and regulations across the jurisdictions in which the firm is active, and support assessing, monitoring and testing firm regulatory obligations and controls. Further it would also enable control and approval of employees' outside activities and interests and oversight of employee trading activity, and support regulatory and compliance documentation needs in accordance with the Bank Secrecy Act BSA and Anti-Money laundering AML compliance program.
• The project encompassed various M T applications including mutual funds, Bonds, Bond trading, Retail banking, Credit Cards, SOX, Basel lI, PCI compliance and Mortgage Applications. This project is a result of a global directive from CIOs and above. Aim was to fill the corporate compliance gaps within some of the current embedded security functions. These Security functions include provisioning user IDs creating, deleting, and modifying entitlements , adding profiles, managing groups, entitlement reviews.

Responsibilities

• Worked on various applications to support pre trade compliance on various settlement platforms including M T bond trading platform
• Worked with the Remediation team to identify and analyze the ISA Information Security Administration functions to check for compliance and open CAP Corrective Action Plan , RA Risk Acceptance or RE Risk Exception for AML Anti Money Laundering , M T Bond trading and Fraud prevention applications.
• Selected and implemented agile development practices according to the application requirements for every project
• Worked on various credit card applications to ensure PCI compliance and perform other ISA functions Information Security Administration .
• Analyze the new regulatory requirements of Dodd Frank and Basel Accord III for Pillar 1, 2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
• Administered Identity and Access Management IAM , including password management controls for staff and vendors assigned to department-level projects.
• Design detailed FRD according to BRD and Basel regulatory requirements using Power Designer.
• Interacted with the Subject Matter Experts SME's and stakeholders to get a better understanding of client business processes and gathered business requirements.
• Created detailed Process Control Manuals PCM and documentation for various M T third party applications during the initial discovery phase of the project.
• Defined and updated PCM process control manuals for various applications by interacting with the application owners and Subject Matter Experts SME's .
• Lead requirement reviews with business and technology teams.
• Critically evaluate information gathered from multiple sources
• Reconcile conflicts, and break-down high-level information into details
• Distinguish user requests from the underlying true needs.
• Built strong client and User relationships
• Performed extensive requirement analysis including data analysis and GAP
• Analysis on various M T Mainframe and Bond trading platforms

Environments: MS Office, SOX, SQL, Archer, Access, CESAR, PAR, TOAD, Mainframe

Daiwa Derivatives Trading System DDTS : The project involved in design and implementation of a global derivatives trading platform using Java front end. The application allowed traders and portfolio managers to trade multiple derivative instruments exchange traded and OTC with a common front end execution platform. The application interfaced with Reuters and Market for real time data, the accounting system and multiple VBA applications. System captures all market data needed to price trade these products, including Recovery Curves, Default Probabilities Correlations. It also generated credit-related risk reports P L, Industry Exposure, Counterparty Exposure and Issuer Exposure.

Responsibilities

• Performed business specification BRD and data requirements, use case models, GUI, use cases, functional specifications and data flow diagrams, ER diagrams, unit testing and beta testing to create a library of financial modeling tools for our applications for the analysis and modeling of derivatives for valuation, pricing and simulation, interest rate risk assessment, cash flow forecasting, intraday quotations from data feeds, contract specifications, trade capture, trading, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications for various trading platforms including Bond trading.
• Collaborated with Change Management Group and IT to prepare a detailed derivatives infrastructure for trading for implementing the derivatives trading application a diagrammatic flow of investment process , trading , data transaction between application, pricing and analytics , database , data feeds and back office integration trade confirmations, processing, settlement, collateral management, market data , portfolio valuation including bond rating and accounting
• Made detailed research analysis prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, and Exotic Options.
• Coordinated with various data feeds Reuters, Bloomberg, Markit for market data, reference data, counterparty data, and credit data mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics
• Performed detailed analysis and work flow diagrams for derivatives trading which included - preparation of market reference data, analysis decision support, modeling a contract, preliminary instrument setup on the application
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Extensively worked on Validating and Testing report in Query Studio and Analysis Studio, which included trading data portfolio performance, holdings reports, end of day reports, broker summary reports, prime brokerage reports, risk analytics reports, TCA cash forecast report
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.
• Analyzed systems and data to identify functionality gaps for front end module, Trade Worksheet and Back office Module for various CDS and asset management platforms which includes fixed income, annuity, mutual funds and bonds.
• Involved in manual trade data reconciliations, analyzing the chart of accounts, tracking the GL transactions and validating them from their mainframe systems.
• Worked closely with the business users to build the models and delivered based on the sign-off.

Environments: Business Objects, Cognos 8.4, Informatica, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer

LoanDepot, LLC, a mortgage lender, provides residential loans to home buyers and homeowners in the United States. It offers fixed rate, adjustable rate, jumbo, federal housing administration, and veterans administration loans. Prime function of the project was to Automate Mortgage Loan Origination Process beginning with the customer initiation to title transfer. The system performs all the business functions of the loan process such as the Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, and Credit, Income, and Title functionalities by extracting credit data from external agencies. Also worked on the mobile application that was developed specifically for their Mortgage business

Responsibilities

• Gathered requirements from business users and analyzed them using Rational RequisitePro
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Documented functional specifications to automate the loan approval process for home Mortgage online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review
• Acquired in-depth knowledge of the banking industry Mortgage, Assets, and Accounts Receivables/Accounts Payables etc
• Gathered business requirements through interviews, surveys, and observing from account managers and UI User Interface of the existing Brokerage Portal system
• Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design OOD using Rational Rose according to the UML methodology
• Developed use cases/diagrams, conceptual model, behavior diagrams sequence, collaboration, state chart, Activity , using MS Visio
• Involved in testing all the data elements in Mortgage Account Inquiry Service, which is called to obtain Mortgage loan data from MSP
• Worked on mapping of MSP Web services to Enterprise Interface Partners and coordinated with FIS on MSP
• Sketched diagrams of proposed and existing systems using Visio
• Implemented the entire Agile Methodology of application development with its various workflows, artifacts, and activities
• Acted as a liaison between business users and system development team during development process
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro
• Supported IT Risk Management in Business Continuity Planning for Item Processing department
• Developed and maintained the project plan using MS Project
• Conducted interviews with clients for the purpose of gathering product requirements and understanding the client workflow
• Created a RACI matrix based on the organization standards for ongoing operations and issue resolution procedures
• Gained thorough understanding of Cash Management, Liquidity Positions and Liquidity Ratios
• Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing
• Tracked changes using Rational Clear Quest
• Assisted QA lead in developing quality procedures and ensuring that appropriate documentation is in place
• Conducted User Acceptance Testing UAT
• Participated in developing of Training Materials for the new technology and User Training
• Worked effectively with Project Manager in handling the whole project

Environments: SDLC, Agile Methodology, Rational Clear Quest, UML, Oracle, MS Project and MS Office.

• Walt Disney Parks Resorts Online WDPRO
• Project1: Worked on e-commerce projects involving new content packages, site updates and enhancements for sites serving Disney's flagship family destinations, including DisneyParks.com, Disneyland.com and Aulani.com.
• Project2: Worked on Data Warehouse BI implementation for email campaigning and digital marketing.

Responsibilities:

• Served as a liaison between the business and technical developers to define problems, enhancements, and solutions.
• Facilitate Work sessions and Solution discussions across business units to understand reported problems and to drive acceptable solutions / workarounds.
• Working with clients to better understand their needs and present solutions using agile approach.
• Interacted with the agile team to gather requirements from the customer and documented for use by the developers through Story Card.
• Created best-practice requirements deliverables, such as use cases, system process flows and context diagrams
• Gathered requirements, developed Process Model and detailed Business Policies.
• Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
• Review Use Case History to identify existing requirements that support claimed functionality performance.
• Documented the FRDs and BRDs for Ecommerce projects.
• These specifications included UML-based use case models and activity diagrams, and usability analysis/user interface
• Managed requirement activities using an iterative and incremental methodology such as Agile using User stories and Acceptance Criteria.
• Conducted Gap Analysis for the system considering AS IS and TO BE features.
• Develop user manuals, presentations and training manuals as per project specifications and timelines.
• Created the Traceability Matrix to ensure that all the user stories are being tested and covered in the testing plan.
• Drive Problem Resolution by holding resources accountable for delivery dates and pursuing continual follow through as necessary, this can include additional technical team meetings to brainstorm ideas.
• Conducted UAT sessions to approval.
• Facilitated the design and development of Business Rule Engines to support SOA architecture and web services.
• Worked closely with System Architect to implement Service Oriented Architecture SOA , Client side Validations, Server side Validations, Web Method definitions and data modeling.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Partner with Release Management areas to insure any potential issues or road blocks are avoided and approved Release Candidates are deployed on time.
• Proficient in writing good SQL queries.
• Develop and foster relationships with business and development teams to ensure transparency of processes to resolve more Critical / high priority problems that meet our business and ultimately our Guests expectations.
• Provided overall project management to multiple projects successfully completing them on-schedule and on-budget.
• Build and managed a cohesive team to meet deliverables per project / track assigned.
• Provided customer support as required to meet service level agreements.
• Prepared the Business Workflow using MS-Visio with input, output, and Pre and Post conditions.

Environments: SharePoint, MS Office, MS Project, Oracle Agile PLM, SharePoint 2010, Informatica, Java, XML, MS Visio, Agile, Quality Center, SOA, SQL.

Cabrillo General Insurance Agency is an MGA who works on behalf of Insurance Company who will design the rates, Collect the premium, Issue the Policy and Settle the claims. Client is operating in 2 States California San Diego and Florida Jacksonville . PREMIA is the core insurance product which handles Policy Issuance, Policy Servicing, Claims and Billing.

Responsibilities

• Analyzed client systems and Business processes.
• Organized Joint Application developments JAD , Joint Application Requirements sessions JAR , Interviews and Requirement Elicitation sessions.
• Conducted and Managed JAD sessions with SMEs and Business departments, for planning and requirement gathering
• Gathered Business Requirements, created Functional Requirements FRD and analyzed data/workflows to define the scope, project financials and progressed from problem statements to well documented designs.
• Documentation of the AS-IS and TO-BE process for current and future phases of the Claims Management System
• Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
• Gathered requirements for Policy Admin, Claims and Billing module for Non-Standard Auto, Home Owners, and Worker's Compensation policies.
• Worked as a Personal Lines Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
• Documented and delivered Functional Specification Document, DD Documents and various other documents needed for the project team
• Conducted JAD sessions for communicating with Stakeholders and Project delivery heads.
• Developed business requirement specification documents as well as high-level project plan
• Developed timelines for Project delivery and Managed projects/resources
• Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
• Provided Training, UAT and Product support
• Involved in the creation for Manual Raters for Auto products
• Monitoring the Configuration and Customizations activities
• Change Management
• Worked as a Single point of Contact for Offshore and Onsite Model.

Environments: Windows NT/2000, MS SQL Server, Rational Unified Process RUP , Facets 4.21, UML, Rational Rose, Mercury Test Director and MS Office Tools.

EBanker was a web portal application used by bankers to manage relationship with their client contacts. EBanker also allows relationship ranking of contacts and has feature to setup notification for lonely contacts. Through various subsidiaries, the company provides brokerage, Credit Derivatives, Mortgages, Retail Banking, Assessment Management and capital markets services.

Responsibilities

• Worked with different business users to develop Vision Document and Business Requirement Specifications by gathering Business and Functional Requirements. Experience supporting the full Software Development Life Cycle SDLC in Agile Scrum methodology.
• Documented the AS-IS Business Workflow adhering to UML standards. Comprehensively performed requirement gathering for enterprise reporting system-using Requisite Pro.
• Participated in JAD Sessions for gathering requirements from SME'S. Played the role of a Facilitator in the JAD session.
• Developed BRD Business Requirement document , ORD Operational Requirement Document and FRD Functional Requirement Document , HLD High level Design Document , LLD Low Level Design Document .
• Identified Use cases from the Functional Requirements and wrote Use Case Specifications and created TO-BE Business Process Workflow diagrams Activity diagrams in MS VISIO.
• Investment banking financiers work with businesses to help them with budgetary issues. Involved in raising money for new ventures or streamlining business costs by identifying areas of excessive spending.
• Understanding of Trade Life Cycle Middle office functions. Responsible in the back office operations such as accounting and human resources are in place to hold the business together from a financial and legal standpoint.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Created Use Case Diagrams using MS VISIO and Rational Rose in order to show the interaction between the Actors and Use Cases as well as showing the relationship between the Use Cases.
• Performed extensive business process analysis including Data Mapping, Data analysis and GAP analysis. Involved in version control management for storage and distribution of documentation using Rational Clear Case.
• Performed data integrity and balance sheet verification procedures, as well as contributing to process improvements in the product control function.
• Maintained a Traceability Matrix to ensure that all Functional Requirements are addressed at the Use Case Level as well as the Test Case Level.
• Performed Functional and GUI Testing to ensure that the user acceptance criteria are met. Created User training materials. Co-coordinated the User acceptance testing UAT with the SME'S to make sure that all the Business Requirements are addressed in the application.
• Wrote SQL Queries, such as Joints, Sub Query, correlated sub query and nested queries to retrieve data from various tables in the database.
• Conducted User Acceptance Testing UAT and System Integration Testing SIT to certify that the functionality designed and developed meets the business requirements and expectations
• Worked on the ETL process used by the Data Stage System designers used for extracting data from heterogeneous source systems, transforming and loading the data into the data warehouse/ data marts

Environments: Hyperion Essbase, Oracle, .Net, Windows 7, Acrobat Pro, iRise, Lotus Notes, MS Suits 2010, SharePoint server 2010, MS Showcase, Rational RequisitePro 7.1, Rational Rose 7.0, SQL Server 2008R2, Quality center 10 and Load Runner 9.5.