SUMMARY

• Business Analyst with 9+ years industry experience in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose MS Visio.
• Experience in Capital Markets, Derivatives, Commodities, FX, Equities and Fixed Income, Front - office, Treasury, Finance and Operations, and trading.
• Strong knowledge in design, development, integration and change requests as per the business changes in DDA (Demand Deposit Account), Time Deposit Accounts and TDA (Trade Development Account) systems and did testing in different scenarios.
• Understanding of different Money Market Investment Tools including Fixed Income. Treasury Bills, Bonds, Notes, CDs, and Commercial Papers.
• Good knowledge of payment domain, Cash Management and Treasury Management services (Account Reconcilement Services, Positive Pay, ACH, Lockbox, Sweep Accounts, etc.) and tools (Fiserv, Check Free, Fidelity Systems, etc.).
• Process Knowledge of AR/AP/GL, Credit management, Fixed income analysis, Risk management, Mortgage Banking basics (Mortgage cycle), Mortgage Underwriting and (Unsecured Loans) Personal Loans Operations
• Experience in designing and developing Enterprise Applications using BEA Web Logic, IBM Web Sphere Studio, MQ Series.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC)
• Expertise in using Microsoft Visual Studio Team System for requirement management and work item tracking.
• Having excellent understanding of Financial Accounting. Comprehensive knowledge of Balance Sheets, General Ledger, Trial Balance, Income Statement.
• Experience with TFS (Team Foundation Server) for documenting the requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Proficient in developing all types of technical diagrams including Behavior Diagrams (Use Case Diagrams, Sequence diagrams, Collaboration diagrams, State chart diagrams and Activity diagrams), and Structure Diagrams (Class Diagrams) based on UML methodology using Rational Rose and MS Visio
• Extensively uploaded test cases from MS Excel, MS Word to Test Director Quality Center.
• Excellent facilitation skills in conducting JAD and JAR sessions.
• Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.
• Proficient in the implementation of production change management techniques and service delivery disciplines
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Familiarity with Lean principles and Six Sigma methodologies.
• Extensive knowledge of IBM and Tandem Mainframe, AS400, and ASP Client Server
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile Scrum.
• Expertise in data driven testing and setting parameters with the Performance Session Scripts.
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying the performance issues due to inefficient Database Administration.

TECHNICAL SKILLS

• Rational Rose
• Rational Enterprise Suite
• MS Visio
• MS Project
• Rational Requisite Pro
• WebLogic
• Crystal Reports
• Lotus Notes
• SDLC
• Test Director
• WinRunner
• LoadRunner
• Quick Test Pro
• SQL
• Oracle
• MS-Word
• Quark Express
• Load Runner
• MS PowerPoint
• GUI
• UI
• Erwin
• HTML
• DHTML
• AJAX
• PHP
• CSS
• MQ Series
• Quality Center
• Dream Weaver Java
• Java Script
• Apache interwoven
• AS400
• C#
• .Net
• Silverlight
• Ajax
• Sharepoint
• Documentum
• E-Commerce
• Visual Studio Team System
• MS SharePoint
• ASP
• CaliberRM
• XML
• Web Application Server
• Internet Transaction Server
• Business Explorer

PROFESSIONAL EXPERIENCE

Confidential, Warren, PA

Sr Business Analyst

Responsibilities:

• Preparing the Business Solution Document for automating the short-term pricing process for Money Market funds. The short-term securities included commercial paper, repos, time deposits, commercial bills, treasury bills etc. The objective of automating the new money market application is to centralize and standardize the receipt and delivery of short-term prices.
• Worked on developing Traceability Outline and Traceability Matrix in CaliberRM based on requirements specifications for all systems
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on MS Access.
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Design and Architecture using BEA WebLogic’s latest features like Portal, Page Flow, Process Control, Java Control and Web-Services using WebLogic development IDE Workshop on Oracle database
• Dealt with the Society for Worldwide Interbank Financial Telecommunication (SWIFT) in creating the criteria for the auditing of the TQR and Q-Gate review processes.
• Conducted JAD JAR sessions to synchronize the different stakeholders on their objectives
• Interacted with Business owners to understand the current process and to provide suggestions to optimize using Autosys and DataStage.
• Worked on designing, analysis, and integration for DDA (Demand Deposit Account) and TDA (Trade Development Account) subsystems and did testing in different scenarios.
• Enhancements and amendments of the existed online programs in CICS and for the BMS coding.
• Analyzed SWIFT and MQ Series data volumes to derive data mapping. Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Used Microsoft SharePoint server as a central repository to store different versions of BRDs and Use Cases to avoid duplicate versions of the document propagating in the team
• Successfully transitioned the Operation Information Systems department to ISCM (Information System Change Management) tool by streamlining change processing.
• Gathering Business and Functional requirements based on the project scope and SDLC methodology.
• Managing overall testing process and project to production change management life-cycle.
• Developed the Use Cases, Sequence Diagrams, Activity Diagrams and Class Diagrams using Rational Rose
• Prepared UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements.
• Analyzed requirements recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, SWIFT for treasury and asset management documentation.
• Utilized Popkin System Architect case for business procedures, processes, requirements, data dictionary and data modeling.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Conducted user interviews and documented business and functional requirements.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio. Reports were displayed and derived through the use of .NET technology (ASP and VB), Crystal Reports, AS 400, SQL, and Excel spreadsheets.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Doing quality Assurance using Swift MT/MX, ISO20022, TWIST & doing Normalization & Renormalization of tables.
• Form the requirements and using technologies such as JavaScript, XML, LDAP, AML language (similar to XML), and TIBCO configure and provide custom enhancements to the client
• Performed manual front-end testing to check all functionalities of different modules. Installing, patching and administering Oracle 10g database server.
• Wrote Triggers and Stored Procedures using PL SQL for Incremental updates
• Generated XML documents using the XML Output Stage.
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Facilitated JAD sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system.
• Responsible for converting the business requirements into technical specifications and mapping documents, translated requirements into highly reusable services.
• Wrote test plans and test cases in accordance with the business requirements document.
• Associated extensive backend testing to verify correctness of the report data using SQL scripts and data comparison.
• Testing was done using Expeditor. Used tools like QMF and SPUFI on weekly basis to query the database update and delete as necessary to ensure the correct operation of the system.
• Developed the weekly, monthly reports that would be used to aid in business decisions using EasyTrieve Plus programming.
• Involved in design, development, integration and change requests as per the business changes in DDA (Demand Deposit Account) and TDA (Trade Development Account) systems and did testing in different scenarios.
• Designed and developed project document templates based on SDLC methodology.
• Developed Data Conversion Strategy for converting data from the existing site to the new site.
• Acted as a liaison between Risk Managers and Analysts, data warehouse technical group, source system technical support and downstream business users of the data to assure compliance with project requirements.
• Identified processes and collected data from end-users, and analysts for developing and documenting detailed business requirements
• Conducted a detailed and comprehensive business analysis by working with the business user, SME and technical team to identify system requirements and improvements.
• Worked on Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Design continuous data quality monitoring services to identify data quality exceptions as they enter the data flow.
• Prepare master data quality reports and take appropriate action to correct deficiencies.
• Created a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel.
• Initiated Use Case using UML, which provided the framework for potential use case deliverables.
• Created Business Process Model, Activity Diagrams using MS Visio.
• Solved impediments that popped up and were reported in the agile-scrum meetings and efficiently carried out time boxed meetings of all the scrum ceremonies
• Used Rational Requisite Pro to document and structure requirements that is easy to understand for the team members.
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Proficiency in preparing Vision Document and User Interface Specification to define system boundary for the project.
• Gathered requirements through interactions and meetings as well as periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
• Conducted Use-Case reviews and identified gaps in the existing system, which lead to improvements and enhancements resulting in a more robust, functional system.
• Created and maintained the Requirements Traceability Matrix (RTM) using MS Excel and made updates to it along the course of the project.
• Collaborated with line of business stakeholders of Loan Originating systems to standardize and identify gaps in KYC/KYA questionnaires by carrying out a comparative analysis of the questionnaires of various loan products for better alignment with BSA/AML, risk scoring and OFAC requirements
• Utilized Actimize engine for transaction risk scoring and detecting anti money laundering and fraud activities
• Analyzed reporting requirements for KYC/KYA data and Demand Deposit Account packages to facilitate data tracking and analytical requirements for developing the BRD.
• Involved in process analysis and defined executed data migration plans for local data for global applications.
• Worked with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues.
• Ensured Use-Cases were consistent and covered all aspects of the Requirements document.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Worked Closely with Portfolio management and analysis, fixed income trading.
• Extensive experience in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
• Analyzed FX rates for monitoring currency movements across the market for business development and management purposes.
• Implemented partial termination of FX trades and supported the team for complete testing of related changes.
• Organized JAD sessions to allow stakeholders express their views and communicate with the other members of the team and resolve any issues that have and might come up later.
• Developed functional specifications, data flow diagrams, data mapping, flow charts, data dictionaries, and functional mapping for automated solutions in support of business process operations
• Writing documentation (High Level Design Documents) that drove decisions, approvals, development, testing and business process improvement initiatives
• Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Worked on Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Implemented and Used SWIFT messaging system to test the flow of messages from and into the new system and was also involved in ETL process
• Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.
• Efficient in MS Project for planning and status reporting.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Set up market data including zero curves, correlation matrices, dividend curves, etc., and the underlying financial instruments and then set up derivatives pricing parameters and trade capture options that drive the valuation of trades based on the market data to configure and test the system
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Expertise in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems integration testing and performance testing.
• Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle
• Created various UML models like Use Case diagrams, Activity Diagrams and State Diagrams in MS Visio.
• Engage functional testing of the applications through use of SQL tools such as TOAD to mine data for investigations
• Performed extensive requirement analysis including data analysis and GAP.

Confidential, Houston, TX

Business Data Analyst

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Analyzed different source systems (AMLN, LoanIQ, ACBS, Credit Cards - Target, Maestro, Shaw) and identified the reporting data elements required to report to Dodd Frank and Call Reports.
• Worked on Black Knights Empower LOS for Retail, Wholesale, and Commercial Loans.
• Created custom monthly report whole sales and retail banking (First lean mortgage, home equity loans, Auto loans, Small business loans and other consumer loans) for different loan services used by the bank.
• Interacted with teams in AFS (Automated Financial Systems) and ACBS (Advanced Commercial Banking System) to extract the information for the reports. Monitored daily various financial reports to verified the loan/fee balances were properly reported in the general ledger and ACBS (Advanced Commercial Banking System).
• Assist the organization in performing data compiling, mining and analysis required to evaluate the given data
• Extensively used Remote Deposit Capture (EDS) application to capture images via desktop scanners
• Worked on Web Portal application to convert paper-based deposits to electronic format for immediate and secure delivery to Union Bank over the internet and external machines. It provides easy-to-use tools for creating, managing, and transmitting electronic deposits
• Job also includes Test Evaluation, Verification & Validations of Actual Results vis-à-vis the desired results Sent daily status reports with any issues to both the Client as well as senior management
• Creating and maintaining Tests and Test Records, Defect Management, analyzed defect data, performed testing for product release, recommended process improvements, review test procedures, maintain strict adherence to client's prescribed testing guidelines, control processes and procedures
• Performed Database Integrity Testing by executing SQL statements.
• Worked on RDC Smart and RDCO converted and unconverted DDA deposits validation in Host and IP Vision/Transaction Processing system tool
• Involved in developing all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Developed PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Maintained all the SQL documents which included installation and data conversion Procedure documents.
• Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Extracted data from Mainframe databases using Power Exchange and loaded into SQL Server Database tables.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Performed Verification, Validation and Transformations on the Input data (Text files, XML files) before loading into target database.
• Wrote complex Stored Procedures, coding and triggers to capture UPDATED and deleted data from OLTP systems.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
• Developed test cases and wrote test plans to help developers locate and fix the defects, as well as tracking issues with JIRA and discover possible gaps in corporate data warehouse on project scope.
• Effectively explored solutions within and outside the scope and brainstormed new solutions for the problems, and maintained Requirement Analysis Report, Preliminary Design Specification, Detailed Design Specification, Workflow Specification, Future Operational Procedures, and other documents.
• Utilized Oracle SQL queries to access data stored in the data warehouse for analysis and test the proper implementation of the database. Implemented ETL processes for enterprise migration system.
• Developed the mappings using various transformations according to business partners' requirements.
• Generated Matrix Reports, Drill Down, Drill Through, Sub-Reports, and Chart Reports using SQL Server Reporting Services (SSRS).

Confidential, Charlotte, NC

Business Analyst

Responsibilities:

• Created AS-IS Business Process Model and Project Definition Document (PDD) for Mobilizing ACH Payment Service.
• Facilitated JAD sessions with vendor group and the product team during requirement elicitation to prepare Business Requirement Document (BRD), Use Case Documents and Error Matrix.
• Collaborated with the Wholesale UI Design (RAPD) team to create Mobile/iPad wireframes and to develop new UI standards for the redesign of existing CEO Mobile applications.
• Created Traceability Matrix; conducted Requirement Walkthroughs, functional/device testing and led Bug Triage activities with QA and Development team.
• Products covered included FX, Rates, Swaps, Fixed Income, Equities, Commodities and Derivatives.
• Responsible for creating User Guides, Demos and Tutorial documents for internal stakeholders and wholesale customers conducting sessions for pilot/end user team.
• Performed Stakeholder Analysis to identify the key players for project success.
• Worked with development team on Microsoft .Net platform, which provided robustness, and flexibility that was really needed to various dealers.
• Identified, evaluated, and proposed Agile Methodology for solution delivery.
• Created Use Cases using UML and managed the entire functional requirements life cycle using Rational Unified Process.
• Involved in Data Migration from Legacy Systems to SQL Server.
• Prepared Gap Analysis for the Consumer Website.
• Worked with defect tracking and reporting tools like Rational Clear quest.
• Conducted extensive user interviews to evaluate the process flow and recommended alternate flows for business process improvement.
• Assisted Project Manager in managing requirements by coordinating and facilitating requirement tracking using Requirement Traceability Matrix (RTM).
• Actively monitored client expectations during all phases of SDLC and was responsible for initiating and managing change request from the client by filling Change Control document.