Rakesh P Available for Contract projects only

acq0ev@r.postjobfree.com

732-***-****

SUMMARY

Over 8+ Years of experience as a Business Analyst/Business System Analyst/Data Analyst in various domains including Banking Finance,, Mortgage, e-Commerce, Pharmaceuticals, Insurance (Property & Casualty/Worker’s Compensation)

4+ years of experience working with Business Intelligence (BI) and Data warehousing tools like Tableau, Cognos, Hyperion Essbase, Hyperion Planning, and Informatica., and remove the other reference.

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.

EDUCATION:

MBA,Marketing focus, Spring

Northwestern polytechnic University, Fremont, CA

B.S., Mechanical Engineering

Sardar Patel University, Gujarat,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, Essbase, OBIEE 11g,Tableau

EXPERIENCE

Mass Mutual – Enfield CT Apr 2014 –Present Business Analyst/System Analyst

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.

PNC Financial Services, Pittsburgh, PA Sep 2013 – Apr 2014 Business Analyst/System Analyst

PNC Financial Services Group, Inc. ("PNC") is an American financial services corporation, with assets of approximately $345.2 billion. PNC operations include a regional banking franchise operating primarily in nineteen states and the District of Columbia with more than 2,700 branches, online and mobile services together with 8000 ATM machines, specialized financial businesses serving companies and government entities, and asset management and processing businesses.PNC is the fifth largest bank in the United States (total branches), sixth largest bank by deposits in the United States, sixth largest by total assets, and the third largest bank off-premise ATM provider. PNC is based in Pittsburgh.

Project 1:

The project involved enhancement and re-engineering of the base product for the peer-to-peer Network Expansion. Although Online Mobile Banking service activity has existed in the past, it has been largely reactive and untargeted approach. Astoria Financial needed product changes to ensure that compelling features are enabled for its customers. I worked closely with Marketing, Customer Service Center, Operations, Legal and Compliance to help analyze, document business requirements, process flows, and data needs to leverage a smarter way which allows customers to carry out banking operations such as: Select Accounts, Credit Cards, Access electronic and wire Transfers and Payments, and Display Pending and Scheduled Transfers and Payments (Mortgage). The project encompassed various AFC applications including Retail banking, Credit Cards, SOX, Basel lI, PCI compliance and Mortgage Applications

Project 2:

Updating and maintenance of Anti Money Laundering (AML) intranet website which would identify and prevent money laundering, structuring, and terrorist financing; help conduct investigations utilizing appropriate research techniques to evaluate transaction activity which includes the use of bank systems and internal and external vendor solutions; escalate unusual or suspicious activity to AML management for review, interact with branch personnel to obtain account information which includes account opening documentation that details a customer profile; compile and document due diligence efforts which includes, but is not limited to, account activity, copies of statements, checks, photographs, Internet search results and news media. The system would store, and share Suspicious Activity Reports (SAR) in compliance with established regulatory guidelines and time frames, ensuring compliance with the Bank Secrecy Act (BSA) and the USA Patriot Act.

Responsibilities:

Gathered, analyzed, refined, and interpreted business requirements Business and converted them into functional requirement specifications.

Installed, configured, maintained Tableau Environments; DEV, QA, and Production.

Documented business rules, understood the business need, added new Customer experience features (Update Content for Enrollment, Add Payees) and provided Screen Layout Specifications for the SRS document.

Responsible for maintaining User and Group permissions across servers and dashboards.

Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.

Selected the appropriate elicitation technique to efficiently identify critical requirements and prioritized requirements by conducting brainstorming sessions with the back office portfolio management and sign offs on requirement artifacts from project managers.

Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.

Determined the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.

Executed two week iteration and worked with the cross-functional mobile application team to ensure that all the requirements were compliant with overall project goal and scope for mobile and web based products.

Led numerous JAD, mitigation, and negotiation sessions with key stakeholders to discuss alternate solutions for Process improvement.

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), Bond trading and Fraud prevention applications.

Participate in knowledge transfer meetings and discussions with consumer management and BSA/AML Officer.

Worked on various credit card applications to ensure PCI compliance and perform other ISA (Information Security Administration) functions.

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.

Facilitated group meetings, one-on-one interviews, and correspondence through emails to manage change control process and to discuss the impact of change request on the project.

Conducted Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment

Used Enterprise Architect and exercised UML methodology in creation of UML diagrams such as, Activity and Use Case, Context diagrams.

Initiated and exercised various strategies involved in website Usability, Functionality, and Compatibility testing.

Closely interacted with developers and System Architect to understand customer site navigational flow, to identify bottlenecks, enhance site navigation, and increase customer satisfaction.

Assisted the project team to enhance the Personal Loans, Credit Card, Internet Services, Mortgage Services divisions and Mortgage payments functions.

Created Test Plan document, test cases, test scripts and expected results for UAT.

Environment: RUP SDLC, Risk Management, Tableau, Enterprise System, Core Banking, MS Project, MS Access, Dreamweaver, Mobile Application, SQL Server, IBM Requisite Pro.

Nationwide Financial, Greenwood Village, CO Jan 2013 – Sep 2013 Business System Analyst

Nationwide Financial is a the largest provider of Life Insurance, Pensions, and Asset Management. They had multiple Web Applications for Life & Protection (L&P), Individual Savings & Retirement (IS&R), Individual Retirement Accounts (IRA), Employer Sponsored Retirement Plans (ESR), and Employee Savings & Pension (ES&P) divisions, and Customer Contracts/ Policy information is stored in multiple Policy Administration Systems. Over the last 85 years, Nationwide has grown from a small mutual auto insurer owned by policyholders to one of the largest insurance and financial services companies in the world, with more than $158 billion in statutory assets. Nationwide provides 401(k), 401(a), 403(b) and 457 services to 7,500 plans.

My role as a Business Analyst was to continue enhancing Nationwide Financial's Client Portal. Every client had to log-in to different web applications to manage their Contracts/ Policies with Nationwide Financial. So the management decided to build a new Client Portal integrating all these services under one web portal. Clients would be able to log-in to Nationwide Financial's client portal and manage their accounts at one place and perform their transactions online through Single Sign on. A part of this is also to do with an IBM implementation of MDM (Master Data Management) by collapsing redundant user accounts. This would not only help Nationwide Financial to create a great customer experience, but also make it easier for them to market additional products and add-on services to the existing clients. The project dealt with redesign of the Client Database, Digitize the Transactions and building new ESB (Enterprise Service Bus) which includes Web Services and Message Queues to communicate with all Policy Administration Systems and integrate with the Client Database through ETL process.

Responsibilities:

Gathering requirements from Business Line Mangers and SME’s for the redesigned Nationwide Financial Client Portal, Client Database and to Digitize the Transactions.

Perform system and document analysis to understand the current systems.

Develop Process Model and detailed Business Policies and documenting the same in Business Requirement Document.

Prepare High Level Process Flow Diagrams and Business Process Flow diagrams for Nationwide Financial Client Portal functionalities in Visio.

Develop Use Case diagrams, Use case Narratives and User Stories.

Administered Identity and Access Management (IAM) (including password management) controls for staff and vendors assigned to department-level projects.

Prepare Wireframes, Prototypes and Mock up screens for different web pages.

Develop Customer Database Mapping Document and Digital Transactions Mapping Document to map all Policy Administration Systems.

Identify the required fields for Client Database from Client extracts and Contract extracts from different Policy Administration Systems.

Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints, also created a Business Requirement Document for management.

Created and Managed User Stories in Epics, Themes and Sprints; also calculated velocity and Story-points in TFS. (I was also part of the team that assessed and analyzed TFS, HP Agile Manager and Green Hopper as Agile ALM tool).

Coordinate with offshore team in documenting the gathered Requirements in to BRD’s and FRD’s.

Interact with SOA architects for developing Integration Service Bus(ISB) & Enterprise Service(ESB).

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.

Develop Service Mapping Documents to map UI Literals to Administration Systems.

Help developers understand Business Requirements and design for Graphical User Interface (GUI), Client Database and Digitize Transactions.

Coordinate with QA team to determine and develop Test Plans, Test Cases and methods for Unit Testing, Integration and Functional Testing based on testing requirements.

Participate in User Acceptance Testing (UAT) and developed Training Manuals.

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.

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.

As part of MDM implementation, involved with validating and testing user accounts; validating the suspect and collapsed data; Created dummy accounts to validate against the back-end and the front-end data.

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.

Perform data validation using SQL queries and run ad-hoc queries to show data to the business users.

Environment: 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, IBM Master Data Management (MDM).

Guggenheim Partners - NYC NY Mar 2012 –Jan 2013 Business Analyst/Data Analyst

Guggenheim Partners is a global investment and advisory firm with more than $240 billion in assets and a track record of delivering results through innovative solutions.

Guggenheim Partners Trading System (GPTS): 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.

Designed and maintained Tableau 5.1 reports used to graphically analyze business data.

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

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, Informatica, Rational Requisite, Tableau, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer

PHH Mortgage - Mount Laurel, NJ Apr 2011 – Mar 2012

Business Analyst

The PHH Mortgage is an American financial services corporation which provides mortgage services to some of the world's largest financial services firms. PHH is the biggest U.S. outsourcer of home loans, processes and originates mortgages on behalf of small banks and some of the world’s largest financial firms, including Morgan Stanley and HSBC Holdings.

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

TJX Companies - Farmingham, MA Jan 2010 – Apr 2011

Business Analyst

The TJX Companies, Inc. is an American apparel and home goods company. It is one of the largest international apparel and home fashions off-price department

Contact this candidate