Summary

Over *+ Years of experience as a Business Analyst/Business System Analyst/Data Analyst in various domains including Banking Finance, Mortgage, e-Commerce, Pharmaceuticals, Life Insurance, Asset Management, and Pension Management.

6+ years of experience working with Business Intelligence (BI) and Data warehousing tools like OBIEE, SSIS, and Informatica.

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.

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.

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.

Technical Skillset

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Caliber RM, Enterprise Architect

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, SSIS, OBIEE 11g

Education

Bachelor of Science (B.S.)

Jiwaji university, India - 2008

Professional Experience

Key Bank, Cleveland, OH Sep 2015 – Present

Business System Analyst/Data Analyst

KeyBank is an American regional bank headquartered in Cleveland, Ohio. It is the 22nd largest bank in the United States based on total deposits. It is the 29th largest bank in the United States by total assets. Since 2008, KeyBank has been the only major bank based in Cleveland.

The project involved a new Mobile Retail Banking application for all homeowners, providing loan pre-approval application facility, loan approval facility, and helping clients to choose the right kind of loan. The other areas of the project focused on adding features in Mechanics website to check their balance, depositing checks through Mobile devices, transferring funds, and paying bills online. 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 Retail banking, Credit Cards, SOX, Basel lI, PCI compliance and Mortgage Applications.

Responsibilities:

Work closely with project stakeholders, business SME's for gathering requirements and specifications for the applications and preparing business requirements document.

Conduct requirement gathering, walkthrough sessions with business requestor, testing and Development team.

Review Business Requirement Documents (BRD) and prepare Use-Case Specifications and Functional specification documents (FSD).

Chair Requirement Gathering Sessions, Joint Application Development (JAD) sessions and lead the effort to get Business and System requirements baseline (stakeholder approval).

Utilize agile software development methodology SCRUM as a lightweight process we used to manage and control software and product development.

Take a major part of the Change Control process and followed up all the Change Request (CR) with impact analysis on Scope, Schedule and Budget constraints and worked with the Change Control Committee.

Create Use Cases to document alternate business scenarios and designed UML diagrams.

Gather and Document PCI regulations and requirements for credit card payments.

Propose requirements for the future state system by applying payment domain knowledge and information collected by interacting with legacy system users.

Develop the Business Requirement Document based on the research & analysis of PCI Standards.

Develop prototypes and screen mock-ups using MS Visio to facilitate interactive discussions with stakeholders and developers.

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

Optimize the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.

Review Logical and physical database design using Erwin Tool.

Using Business Intelligence development studio (BIDS) create Dynamic ETL SSIS Packages to validate, extract, transform, and load data from different sources like web services and also involved in checking data quality, data cleansing and data transfer.

Worked on huge data transfers from & to SQL Server Databases using SSIS and used configuration files for production deployment.

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

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

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

Clarify QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested the same.

Initiate and Exercise various strategies involved in website Usability, Functionality, and Compatibility testing.

Conduct User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues. Also familiar with testing tools to design and develop test plan and test scripts.

Environment: UML, Agile (SCRUM), Use Case Analysis, MS Word, MS Power Point, MS Excel, MS SQL server, MS Outlook, T-SQL, SSIS 2012, MS Visio, MS Project, Quality Center

Merck & Co. – Kenilworth, NJ Jan 2015 –Sep 2015

Business Analyst/Data Analyst

Merck & Co., Inc. is an American pharmaceutical company and one of the largest pharmaceutical companies in the world. The company was established in 1891 as the United States subsidiary of the German company Merck, which was founded in 1668 by the Merck family. Merck & Co. was nationalized by the US government during World War I and subsequently established as an independent American company in 1917. Merck & Co. is the world's seventh largest pharmaceutical company by market capitalization and revenue. Its headquarters is located in Kenilworth, New Jersey.

The main purpose of the project is to build a DataMart on Sales and Marketing to enhance the business strategy and operations for the Sales and Marketing Department. The DataMart consists of all the data that will be fed in from various source departments, external data and various platforms of the company and construct the DataMart to generate reports for Sales Growth, Sales Forecasts, Market Share, Compensation Packages, Sales Force Alignment & Deployment, Sales Force Size Analysis, Exploratory Analysis, Compensation Analysis, Product/Competitor Analysis, Cluster & Segmentation Analysis, Physician & Account Targeting, Market Share.

Responsibilities:

Involved in gathering requirements and documenting the gathered requirements/Involved in meetings with the Team members to discuss the requirements.

Gather requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for user stories creation and obtain timely sign-off by all respective parties.

Prepared Test Plan from the Business Requirements and Functional Specification.

Lead Sprint Planning & Estimation sessions, Sprint Retrospectives and Reviews.

Develop detailed level process maps to facilitate requirements gathering for projects and trainings.

Developed Logical and Physical Data Model using Erwin, followed Star Schema to build the Data warehouse.

Tested different detail, summary reports and on demand reports.

Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Wrote the test scripts for manual testing.

Extensively Used SQL and PL/SQL Scripts and worked in the both UNIX and Windows Environment.

Assisted in the process of preparation of the document Informatica Transformation Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.

Used Debugger to troubleshoot the mappings.

Implemented Slowly Changing Dimensions Type 1, Type 2.

Troubleshoot post production defects. Analyze the existing flow and prepare BRD documents for the defects and Change requests.

Involved in Code fixes and migration of code from Dev to SIT and Production.

Used SQL query to analyze the Pfizer source systems and existing data warehouse data. Prepared data mapping documents to build the new data mart and Tableau reporting.

Prepared Visualization Reports for quarterly and yearly reports for Supply chain higher management.

Supported SIT and UAT testing and documenting user acceptance criteria.

Monitoring SIT cycles and involved in Production support.

Handled change requests from the client.

Environment: Workflow Manager, Workflow Monitor, Repository Manager, Metadata Exchange, HP-UNIX, FTP, Oracle 11g, Erwin, SQL, PL/SQL, Unix Shell Scripting, Tableau, Quality Center

Toys R Us – Wayne, NJ Feb 2014 – Jan 2015

Business Analyst/Data Analyst

Toys R Us is headquartered in Wayne, NJ and sells merchandize in 856 Toys "R" Us and Babies "R" Us stores in the United States and Puerto Rico, and in more than 755 international stores and more than 250 licensed stores in 38 countries in addition to their online storefront.

Toys R Us recently launched a new website with enhanced features such as Buy Online Pick up in Store (BOPUS), Buy Online Ship to Store (BOSTS), Auto Refill, Compare Products and Product Bundling etc. I was a part of Project Redesign and worked closely with business stakeholders and the entire development and testing team.

Responsibilities:

Worked with IT leads, business stakeholders and development teams to define detailed UI requirements for customer profile; My Account, Baby Registry, Shopping Cart, Checkout and OMS for Toys "R" Us and Babies "R" Us online storefront.

Documented detailed level requirements in the form of User Stories for various functionalities like Promotions, Product Detail Page, Shopping Cart and Checkout.

Worked on UI and data requirements with vendors and development team to successfully implement tax calculation, single use coupons, gift cards and payments (Credit Card and PayPal) with third party vendors like DMA, BAMS (Bank Of America Merchant Services), and PayPal to ensure that customer data flowing through the process is PCI compliant.

Led requirements clarification session with business stakeholders for shipping calculations and shipping charge in order to provide a direction to IT team to move ahead with development of key components of checkout process.

Worked on requirements to implement "R" Us brand credit card provided by third party vendor Synchrony Financial. Synchrony implementation provided Toys "R" Us shoppers with the ability to apply for a credit card and buy with the same card during checkout.

Worked closely with various business stakeholders to come up with wireframes and get functional requirements for Buy Online Pick up in Store (BOPUS), Buy Online Ship to Store (BOSTS), Auto Refill, Product Comparison and Product Bundling for desktop and mobile platforms.

Conducted process workshops to analyze AS IS process and define To-Be process to meet new business requirements.

Documented use cases, workflow diagrams, screen mock-ups and functional requirements specification documents for various functionalities like Site Search, Product Detail Page, Shopping Cart and Checkout Process for desktop and mobile platforms.

Worked as a single point of contact to integrate with Aisle 411, a third party vendor providing real time inventory availability and store maps that provide exact aisle location for products in Toys "R" Us and Babies "R" Us stores.

Assisted development and testing teams by providing clarifications on front end and back end requirements throughout the project.

Facilitated meetings to resolve conflicting business and development requirements with different third party vendors providing various functionalities to Toys "R" Us.

Worked with offshore developers to walkthrough wireframes and FRS on various functionalities like Site Search, Product Detail Page, Shopping Cart and Checkout process for desktop and mobile platforms.

Responsible for tracking bugs and replying to any clarifications needed by development, QA and business teams to get those bugs fixed via JIRA.

Worked with external front end vendor Sequence to get new visual design and HTML pages for the new Toys R Us redesigned website.

Identified risks for incoming bugs and work with business owners and project managers to mitigate risks in time before Go Live of big enhancements like Guest Checkout.

Environment: JIRA, MS Office, MS Visio

Nationwide Financial, Greenwood Village, CO Nov 2012 – Feb 2014

Business Analyst/Data Analyst

Nationwide Financial is 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.

The project was on the Intranet Credit Risk management enhancement, which will help Northern Trust to make centralize lending information, for the businesses, including: approval data; financial statements analysis; credit risk grading, mortgages; balance and debts information and reporting in a single intranet platform. The use of credit risk models offered a framework for examining credit risk in a timely manner, centralizing data on global exposures and analyzing marginal and absolute contributions to risk. My role as a Business/Data Analyst was to work on Data Quality, Data Validation, and Reporting to analyze business processes to identify areas of reducing operating costs and improving efficiencies. This project aimed to improve Northern Trust's overall ability to identify, measure, and manage risk.

Responsibilities:

Designed application components in an AGILE environment utilizing a test driven development (TDD) approach.

Created and maintained project tasks and schedules.

Performed data profiling in the source systems that are required for New Customer Engagement (NCE) Data mart.

Manipulated, cleansed & processed data using Excel, Access and SQL.

Responsible for loading, extracting and validation of client data.

Analyzed raw data and developed recommendations.

Wrote SQL scripts to manipulate data for data loads and extracts.

Involved in defining the source to target data mappings, business rules, business, and data definitions. Responsible for defining the key identifiers for each mapping/interface.

Responsible for defining the functional requirement documents (FRD) for each source to target interface.

Coordinated with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.

Documented data quality and traceability documents for each source interface.

Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.

Involved in Data warehouse and Data mart design. Experience with various ETL, data warehousing tools and concepts.

Worked with internal architects, data warehouse developers by assisting in the development of current and target state data architectures.

Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.

Also worked on some impact of low quality and/or missing data on the performance of data warehouse client. Identified design flaws in the data warehouse.

Developed OBIEE metadata repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer.

Worked on customizing Repository and configure metadata objects (Subject Area Table Column) and Web Catalog Objects such as Dashboards, Pages, Folders, and Reports.

Worked with BI/ETL developers to perform Data Modeling (Physical & Logical), Data Analysis and wrote High level and Low level Design Specifications for ETL and Business Intelligence (BI).

Created iBots to send preprocessed reports using OBIEE Delivers.

Generated tables, listings, and graphs using Excel also used Excel to generate end of day reports for input into OBIEE.

Utilized OBIEE Administration Tool components in both Application and Business modeling.

Responsible for developing/converting over 200 discoverer reports using OBIEE 11g.

Validated reports using OBIEE and Oracle data warehouse in comparison to current reports.

Environment: Oracle10 & 11g, MS-Office, Enterprise Architect, Informatica, ER Studio, XML, Informatica, OBIEE11

Daiwa Capital Markets - NYC NY (Offshore) Oct 2011 – Nov 2012

Business Analyst/Data Analyst

Daiwa Capital Markets America Inc. was formed in 1964 as a wholly owned subsidiary of Daiwa Securities Co. Ltd. It started its business focusing mainly on the sales of Japanese equities to U.S. institutional investors. Currently, it focuses mainly on sales and trading of Japanese, Asian, and U.S. equities, fixed income instruments, financial futures, and investment banking.

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

Provided detailed FpML API specifications of various products on trade submissions for higher volume clients.

Responsible for Fixed Income and OTC Options part of the project. Involved in the Monte Carlo simulations using market data and to value the trades. Simulated yield curves with different spreads under various scenarios and used these curves to simulate the P/L path.

Analyzed the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows for the proposed system.

Business flows documented contained information flowing from upstream applications to the downstream applications and any impact made using GUI by the users.

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.

Involved in the trade submission to ICE, CME from MarkitSERV for clearing through MarkitWire APIs avoiding clients to build to multiple bespoke CCP interfaces.

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

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

Environment: Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer

Loan Depot - Foot Hill Ranch, CA (Offshore) June 2010 – Oct 2011

Business Analyst

LoanDepot, LLC, a mortgage lender, provides residential loans to home buyers and homeowners in the United States. LoanDepot 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. This project also involved the mobile application that was developed specifically for their Mortgage business. It implemented the automation of document upload functionality from legacy system to Easy loan application, and ensured the documents uploaded by customer were updated automatically without manual intervention. The project also reengineered the closing cost functionality for based on new compliance rule implemented by TRID (TRILA- RESPA Integrated disclosure).

Responsibilities:

Worked as a business analyst to build Strategy Web application for financial statements and inspections.

Identify, research, investigate, analyze, define and document business processes.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.

Conducted user interviews, gathered requirements, analyzed the requirements using Rational Rose requisite pro – RUP.

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

Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.

Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

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.

Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.

Developed timelines for project delivery and managed projects and resources to successful completion.

Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.

Assisted in development of training materials for new technology and process improvements.

Participated in developing of Training Materials for the new technology and User Training.

Worked effectively with Project Manager in handling the whole project.

Environment: SDLC, RUP Methodology, Rational Clear Quest, UML, Oracle, MS Project and MS Office.

Dr. Reddy’s Laboratories Ltd (CSC Client) - Hyderabad, India Jun 2008 –Jun 2010

Jr. Business Analyst/Intern

Dr Reddy's is one of the largest pharmacy companies in India. The company has a number of divisions each of which produce different products pertaining to medical supplies for use within India and different parts of the world.

In order to keep track of the huge amounts of data generated in clinical trials and with respect to sales and expenses, a data warehouse was developed. Based on the

Contact this candidate