Mandula P

acrz4s@r.postjobfree.com

732-***-****

Summary

Over 7+ 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, and Informatica.

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.

Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.

Facilitated Joint Application Design (JAD) and Rapid Application Development (RAD) teams with all IT group members.

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).

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 flake schemas to create fact and dimension tables.

Created tabular, matrix, pie, bars and column reports to meet client requirements.

Performed GAP and cost-benefit analysis as required.

Worked extensively with application programmers to develop proposed solution prototypes.

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.

Resolove conflicts and break-down high-level information into details.

Articulate, confident, and able to communicate comfortably with all levels of the company.

Education

Bachelor of Science (Commerce)

Osmania University, Hyderabad, India

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

Experience

Bank of America - Oct 2013 –Present Business Analyst/Business System Analyst

1.Global Commercial Banking Referrals Project

The focus of Global Commercial Referrals project is to establish enterprise wide principles that will be used by LOB’s in creating or modifying their point to point referral processes and also to create new partnerships and develop a broader repeatable enterprise model for client coverage and relationship deepening.

Global Commercial Banking Enterprise Referrals project involves building an Enterprise referrals solution between multiple lines of business including Global Commercial Banking, Global Wealth Investment Banking and US Trust.

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).

Lead requirements gathering from multiple lines of business and various legacy systems.

Lead functional design specification and facilitate Business Partner design sessions.

Evaluate, analyze and document business processes, use cases, functions, data and legacy application usage.

Design wireframes, participate in User Experience reviews and facilitate prototype demonstrations and storyboards.

Assessed the flaws in the existing as-is system and made recommendations of Business process improvements, incorporated them in the future to-be system design.

Identified, researched, investigated, analyzed, define opportunities for business process improvements and documented business processes.

Worked with application developers and designers to make sure development understands the business model and detailed user and functional requirements.

Design, prepare, and lead project testing and end-to-end Enterprise level system testing.

Query Oracle tables to review data to ensure test case results meet expected results.

Designed and implemented stable procedures, processes yielding better throughput and templates for test and production environments. Tracked testing issues, maintained test matrix, ran daily status meetings, and met the exit criteria for UAT. Performed as a senior member of the core team during UAT and Production Deployment.

Conducted training sessions for the end users and documented various training manuals.

2.BACT

The primary goal of Bank of America Compliance Technology (BACT) 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. BACT 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 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 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), Bank of America 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 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 Bank of America Mainframe and Bond trading platforms.

3.Global Commercial Banking Sales Tools Usability and Performance

The GCB Enhancements project is to address CIBR tools (Sales Tools) user and Business Validation Team feedback priorities regarding the speed and design of GCB's current sales tools. The goal of the project is to reduce the number of views, simplify user interfaces, enhance CMP reporting, and improve system responsiveness by turning off unused or lightly used functionality, and reducing pick lists and values within pick lists.

Deals Update Project was the part of overall GCB Enhancement effort. The goal of this project was to automate the active Deals Team Update for any change in Coverage Team data on CIBR Client Management application.

Responsibilities

Performed requirement analysis by gathering both functional and non functional requirements based on interactions with process owners & stake holders.

Identified, researched, investigated, analyzed, define opportunities for business process improvements and documented business processes.

Prepared Functional specification document as per the process flow and Business requirements.

Developed UML Use Cases for various Business Case scenarios.

Worked with application developers and designers to make sure development understands the business model and detailed user and functional requirements.

Design, prepare, and lead project testing and end-to-end Enterprise level system testing.

Environments: UML, Windows 2000, MS Visio, Oracle 8i, MS Word, MS PowerPoint, Test Director 8.0, MS Office, SOX, SQL, Archer, Access, CESAR, PAR, TOAD, Mainframe

Ally Capital Markets – Detroit, Michigan Dec 2012 –Oct 2013 Business Analyst/Data Analyst

Ally Financial Inc has more than 15 million customers worldwide and provides a range of financial services including auto financing, corporate financing, insurance, mortgage services, and online banking.

Ally Trading System: 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.

Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.

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

Sears Holdings - Burbank, CA Mar 2009 – Dec 2012

Business Analyst

Sears Holdings the fifth-largest American department store company by sales as of October 2013 and it is the twelfth-largest retailer in the country overall. Worked on e-commerce projects involving new content packages, site updates and enhancements for sites serving Sears. Worked on Data Warehouse BI implementation for email campaigning and digital marketing.

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.

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.

Built 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.

General Insurance Company (GIC) – Hyderabad, India Mar 2008 – Feb 2009

Business Analyst

GIC is the sole reinsurance company in the Indian insurance market with over four decades of experience. GICRI 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.

Contact this candidate