We provide IT Staff Augmentation Services!

Sr. Business Analyst/ Sr. Data Analyst Resume

New York City, NY

SUMMARY:

  • A creative and dynamic Business analyst/Data analyst with over eight years of experience in business process analysis/modeling, business requirements, database design and development of web based and client/server applications.
  • Good understanding of financial accounting concepts and post trade settlement of accounts.
  • Highly experienced with financial instruments for Capital Market, Investment banking and brokerage environments (equity, financial investors, foreign exchange, derivatives, mutual funds, options, swaps, asset backed securities, hedge funds, trading, settlement and clearing).
  • Expert knowledge of trade life cycle of stock brokerage firm, finance, claims management system.
  • Strong subject matter expertise and experience in the domains of Banking, Global Custody, Payables, Receivables, Equities, Fixed Income, Derivatives, Financial Statement Analysis Balance Sheet, Income statement, Cash Flow statements, Transaction analytics, Data mapping, data analysis, Equity Analysis, Reference data, LBO & DCF Modeling, Trade Finance (Letter of Credit, Bank Guarantee), Record Keeping Systems, Corporate Actions, Investment Banking, front, middle and back office banking software.
  • Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
  • Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP), Agile: XP, Scrum.
  • Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, use cases and the rational tools.
  • Extensive experience in conducting Joint Application Development (JAD) sessions.
  • Performed gap analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Expert in creating report with the help of SQL and also wrote PL/SQL queries for data manipulation.
  • Expertise in broad range of technologies, including business process tools such as Microsoft project, MS Access, MS Visio, technical assessment tools, data warehousing concepts.
  • Expert in writing system specifications, translating user requirements to technical specifications, writing business requirement document, test plan, and test scripts.
  • Experienced in implementing normalization/demoralization techniques for optimum performance in OLTP/OLAP database environments.
  • Extensive understanding of business processes & interface with IT.
  • Experience in system conversions (Mapping, Migrating, Enhancement) such as HIPAA X12 4010 codes to X12 5010 codes and ICD-9-CM codes to ICD-10-CM & PCS codes in Medicaid, Medicare, Procedural and Diagnostic codes and Claims processes.
  • Excellent track record as a leader and team player with effective communication skills.

SKILLS:

Operating systems: Windows 98/XP/Vista/2000/2007, UNIX

Programming Language: PL/SQL, MySQL, JAVA, CSS, HTML, .NET

Databases: MS SQL Server, PL/SQL Server, MS Access, Oracle, Toad

Testing Tools: HP Quality Center, QTP, Win Runner, Load Runner

Tools: MS Office Suite, MS Project, MS Visio, Rational Rose, Rational RequisitePro, PeopleSoft, MS Access, UML, Erwin, Share Point

EXPERIENCE:

Sr. Business Analyst/ Sr. Data Analyst

Confidential, New York City, NY

Description:

Confidential Holdings plc is a British multinational banking and financial services company headquartered in London, United Kingdom. It is the world's second largest bank. It was founded in London in 1991 by the Hongkong and Shanghai Banking Corporation to act as a new group holding company. Aim of the Project is implement Regulation W implement section 23A and 23Bof the Fedral Reserve Act, implementing a target Operating Model to ensure comprehensive and sustainable control process for the compliance and Confidential I Norms.

Responsibilties:

  • Involved in doing impact analysis for Reg 23A and Reg 23B requirements and coordinated with business users and Project Manager for prioritizing the testing/release of the changes.
  • Worked on reviewing and modification of the BRD for the enhancement of OTC Derivatives, Product control and Private Banking based on Confidential I norms and Reg W Affiliates.
  • Identification of the Reg W Affilates and monitoring and reporting of 23A covered transactions.
  • Involved in testing for the Post Transaction data sourcing through 23A covered transaction for OTC Derivatives (including Futures/ Options clearing, FX Fwd, Metal Fwd, etc), Product control (US Treasury Securities and Non US Treasury Securities purchase, Repos, Rev Repos, Securities underwritten etc) and Others Assets for Global Finance.
  • Involved in working with DQ&G for doing the testing and Unit testing for Reg W Transactions based on TreatsCodes, Rew W Flage, etc.
  • Involved in creating the Test Scripts and Test Scenarios for Global Finance for OTC Derivatives, Private Banking and TCS to Reg W Transactions.
  • Involved in Testing of Regulatory Analytics and Financial Calculation (Reg W Exposure, Gross Profit, Gross Loss, NPV, Credit Exposure, etc) for the daily and Monthly feeds of OTC Derivatives exposure details and Credit Collateral files for Reg W Affiliates based on Confidential I Norms.
  • Involved in giving the presentation for using the MIS reports for OTC Derivatives, Product Controls and Private Banking based on the 23A and 23 B covered transactions.
  • Involved in doing the GAP Analysis to identify and meet the requirement for Reg 23A transactions.
  • Analysis and reversed engineering PL/SQL procedure and functions and involved in writing necessary PL/SQL code to analyze the data prior to sending the data FRWO (Finance Reg W Officer) to view and collateral usage and 10%/20% Capital limits.
  • Provide SQL to tollgate and data quality check to ETL to test the data inserted by the Java rules engine into staging table as per requirement and logic to automate the process.

Environment: Rational Rose, Rational Requisite Pro, Rational Clear Quest, PL/SQL, Microsoft Visio, Test Director, HP Quality Center, MS SharePoint, MS Project, ER-Win, MS Office.

Sr. Business Analyst/ Sr. Data Analyst

Confidential, New York City, NY

Description: Confidential is a health maintenance organization (HMO) and health insurance company based in New York City. It is a $10 billion company with 3.4 million members . Worked on ICD-9 to ICD-10 conversion Project is also undertaken for making the system compliant for the ICD-10 codes from the current ICD9 codes.

Responsibilties:

  • Conducted Joint Application Development (JAD) sessions and walk in interview with the business users to gather requirements.
  • Did impact analysis for changing requirements and coordinated with business users and Project Manager for prioritizing the testing/release of the changes through CAB.
  • Work as part of an Agile team to solve problems and deliver projects in a fast paced environment
  • Helped creating Reports for Claims processing, Provider and Member.
  • Prepared the Business requirement Document for the enhancement of the existing services. Wrote TRD for the requirements and RTM for testing and defect tracking.
  • Modeled the AS-IS system and performed GAP Analysis for the existing system in order to map it to the TO-BE system.
  • Worked on improvement of Claims Reimbursement User Interface for a better experience and incorporate changes as per HIPAA guidelines using the gap analysis.
  • Assisting business users in defining UAT test cases and plans; Established and maintained test cases and test data in Quality Center.
  • Coordinated with the QA Team for testing activities across multiple systems and managed Conversion test execution.
  • Helps in conducting User Acceptance Testing (UAT), and System Integration testing (SIT) and SWOT analysis.
  • Performed GAP Analysis for HIPAA 5010 transactions and Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
  • Provided PL/SQL queries to developer as source queries to identify the data provided logic to assign.
  • Responsible for providing the Data Mapping document and rewrite of the PL/SQL queries from As-Is To-Be and validating the data through PL/SQL.
  • Lead through UAT procedure and also conducted training sessions for the end users along with the necessary documentation
  • Created test plan and facilitated its implementation, create Test cases and assisted manual testing
  • Used SharePoint to ensure all team members have easy access to all the documents created
  • Lead through UAT procedure and also conducted training sessions for the end users along with the necessary documentation

Environment: Rational Rose, Rational Requisite Pro and UML, Rational Clear Quest, PL/SQL, Microsoft Visio, Test Director, HP Quality Center, MS SharePoint, MS Project, ER-Win, MS Office.

Sr. Business Analyst/Sr. Data Analyst

Confidential, New York City, NY

Description: S&P is known for its stock market indices such as the U.S.-based S&P 500, the Australian S&P/ASX 200, the Canadian S&P/TSX, the Italian S&P/MIB and India's S&P CNX Nifty. The project was to build new rules, rules engine which proposes the rating type, rating codes, outlook and credit watch and to aggregate the entire ID’s in one with same participants and other parity’s involved to identify the rating providers, BO reports to identify the changes in rating and the risk to build the Java based engine and rules.

Responsibilties:

  • Part of the data solutions & operations group involved in leveraging data management best practice to improve the sophistication of S&P's analytical & data capabilities in areas such as surveillance, quantitative analysis, product development and risk management.
  • Analyze and evaluated information and business process requirements. Created practical solution to fulfill the business needs that comply with quality standards and technical requirements.
  • Ensure business requirements / application functionality is consistent with regulatory mandates from Dodd-Frank Act, SEC Issued Proposed Regulations, and Finalized EU Regulation for CRAs.
  • Managed portfolio maintenance, preparation and delivery of Evaluation Pricing reports and files for over 700 Domestic and International Fixed income, equity, mutual fund and statement accounts for a variety of clients in the national and international arena.
  • Participated in JAD session for requirement, feasibility and risk analysis with various stakeholders, including designers, developers, QA and management identify critical and high-risk areas of application for development of rules and rules engine.
  • Work as part of an agile team to solve problems and deliver projects in a fast paced environment and was involved Scrum, Sprint Planning, Product Backlogs, Sprint Backlogs and TFS to manage Sprint Cycles.
  • Interacted with clients and business users for the requirements, design and deliverables.
  • Accumulated business requirements from various business users and translated into business requirements document(BRD). Documented all the discussions, stored the requirements and tracked the changes maintaining the updated versions of document on the SharePoint.
  • Worked closed with data modelers based on business requirement to develop the new tables in USPF APR database and provided the key information for data modeling such as logical and physical attributes, primary key and foreign key relationships.
  • Created models based on the business requirement for rule based credit rating system using technical and fundamental analysis.
  • Logic and mapping to Java developers to create 100 plus rules for credit rating including primary, secondary, bond insurance, unenhanced and housing based on the requirement.
  • Provided the logic and mapping to developers to create a staging and primary tables based on the model and logic to populate those table based on the source output.
  • Created the hyperlink/ macros in excel to identify the participant that provides the rating.
  • Provided PL/SQL queries to Java developer as source queries to identify the data provided logic to assign the rule based on the participants from source PL/SQL query.
  • Logic and mapping for USPF data base staging tables and to insert the data in all the staging tables via Java engine and to PL/SQL developer to aggregate the data into primary tables and group them according to the logic provided.
  • Defining the end to end operational parameters for the set ups based on the projected business plans and developed data flow diagrams, illustrating the flow of data from source to target (USPF Staging- USPF Primary- Core Staging- Core Primary- RRDW Staging- RRDW Primary- RRDW Reporting) along with checkpoint for testing and verification.
  • Worked as a liaison between business users and the developers to submit requirements and changes clarify questions and issues.
  • Wrote the PL/SQL in Oracle (TOAD) to validate the data and to validate UAT defect to identify and extra logic to Java developer if need or its and data issue.
  • Logic and mapping and PL/ SQL queries to BO for building the reports and the triggers to identify the changes in ratings or change in participants who provides the rating and validated the reports based on requirements.
  • Analysis and reversed engineering PL/SQL procedure and functions and provided necessary PL/SQL codes to development team and logic and mapping for the calculation of low, medium, high correlation for them credit rating and for BO report SQL procedure.
  • Provide SQL to tollgate and data quality check to ETL to test the data inserted by the Java rules engine into staging table as per requirement and logic to automate the process.
  • Worked extensively with MS office for preparing status reports and excel reports by extracting the data from the USPF data base based on the Rule Id’s and created the hyperlink to check the participants providing the credit rating for the issue in multi tab of excel.
  • Created the macros to combine the tabs in excel and create the reports from staging table.
  • Collaborated with QA team in reviewing test plans and test cases ensuring that a final application catered to the user requirement.
  • Involved in daily scrum meeting for daily status updates of the project and the issues.
  • Performed the requirement walkthroughs with Dev team and QA teams with the aim to develop the testing strategies and test plans such that test case reflect user needs.
  • Developed a User Acceptance Test (UAT) plan and test scenarios to guide a select group of key end users in testing the user interface and functionality of the rules development application.
  • Worked as a BAU team for enhancement made to the rules as well as rules engine logic to identify the rules and to assign the appropriate ratings.
  • Ensured all applications were tested in test and development for functionality and were adequately controlled in production.

Environment: Rational Rose, Rational Requisite Pro and UML, Rational Clear Quest, Test Director, HP Quality Center, MS Project, ER-Win, Expertise MS Visio, MS Access, PL/SQL Server, Oracle, TOAD, SDLC, Agile, MS Office, UML, SQL, Windows XP/ 2000/ 2007 Server & Professional, CSV files, Erwin, Share Point Service

Sr. Business Analyst/ Sr. Data Analyst

Confidential, Memphis, TN

Description: Confidential is a financial services company based in Memphis, Tennessee. It is a subsidiary of First Horizon National Corporation. The project was to work with a team to enhance their web based portfolio management/ asset management system for Capital Market (equities, fixed income, Derivatives) for customers to access their accounts, update market information, Watch trends with Forecasting, trade online and evaluate their investments.

Responsibilties:

  • Helped initiate and implement Agile (Scrum) as software development methodology
  • Designed the GUI to trade Derivatives, equities and fixed income instruments
  • Worked on developing an analysis engine used to forecast the individual stocks and entire portfolios based on data mining techniques
  • Interacted with stakeholders, business users and subject matter experts to finalize the business requirements for the application and prepare BRD and converted it to technical requirements (TRD) for the developers.
  • Closely interacted with designers and software developers to understand application functionality, navigational flow and updated them about end-user sentiments
  • Defined system requirements to use case, use case scenario and use case narrative using the UML Methodologies
  • Prepared process flow diagrams and Sequence diagrams for the application
  • Produced the visual models for the application using rational rose to create use cases, state charts, sequence diagrams, and activity diagrams
  • Developed detailed ER diagram and data flow diagram using modeling tools following the SDLC structure
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product
  • Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
  • Provided PL/SQL queries to developer as source queries to identify the data provided logic to assign.
  • Logic and mapping for staging tables and to insert the data in all the staging tables and to PL/SQL developer to aggregate the data into primary tables and group them according to the logic provided.
  • Responsible for providing the Data Mapping document and Validating the data through PL/SQL.
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
  • Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders
  • Created test plan and facilitated its implementation, create Test cases and assisted manual testing
  • Used SharePoint to ensure all team members have easy access to all the documents created
  • Lead through UAT procedure and also conducted training sessions for the end users along with the necessary documentation

Environment: Windows NT 4.0, Rational Rose, Rational Requisite Pro and UML, Rational Clear Quest, SQL, Microsoft Visio, Test Director, HP Quality Center, MS SharePoint, MS Project, ER-Win, Unix, MS Excel, MS Visio, Rational Rose, Requisite Pro, Rational Clear Quest, Rational Clear Case, RUP, MS Access.

Business Analyst

Confidential, New York City, NY

Description: Confidential is provider of financial services for corporations, institutions and affluent individuals around the globe. The scope of the project was to develop an application that enables potential customers to perform searches for the stock rates, bonds, and derivatives and track the market and portfolio performance. Giving complete insight of the recent events related to their Investment and Capital Market (such as Stocks, Bonds etc).

Responsibilties:

  • Involved in requirement gathering using Rational Requisite Pro, which included interviews, brainstorming and meetings with stakeholders, and SMEs.
  • Extensively involved in all the waves to make sure that documented functional requirements are met.
  • Maintained and kept track of stakeholder’s requests for enhancements and changes using Rational Clear Quest.
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly and converting all the requirement technically for the developers..
  • Identified and created all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams and Sequence Diagrams using Microsoft Visio.
  • Created cash Management flow models and developed the processes for record keeping of the data for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, FX, Currency Forwards, Cross-Currency Interest Rate Swaps, Mutual Funds, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds and Hedge Funds.
  • Documented trade order lifecycle for all instruments: equities, equity options, structured products, FX, equity derivatives, Fixed Income, treasury bonds, Auction Rate securities including corporate and municipal bond debt instruments, Variable rate Demand and Preferred, Dutch Auction Securities, OTC derivatives, Structured products, Money Market instruments, FX, Asset-backed securities, alternatives investments with exposure credit risk involved.
  • Expertise in Performance Management, Asset Management, Credit Management, Client Reporting and implementing their benefits.
  • Provided PL/SQL queries to developer as source queries to identify the data provided logic to assign.
  • Logic and mapping for staging tables and to insert the data in all the staging tables and to PL/SQL developer to aggregate the data into primary tables and group them according to the logic provided.
  • Responsible for providing the Data Mapping document and Validating the data through PL/SQL.
  • Developed test plans, test cases, and test case execution using Test Director from the business logic, User Requirements and test-objectives.
  • Participated in Bug-Review meetings with software developers, QA team, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
  • Assisted in Conducting UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
  • Involved in preparing a simple and detailed User manual for the application, for an intended user.

Environment: Ascential Data Stage 7.5/7.0 (Server Edition), Parallel Extender PX, SQL, Erwin, Oracle 9i, Version controls, Windows NT, Unix, MS Excel, MS Visio, Rational Rose, Requisite Pro, Rational Clear Quest, Rational Clear Case, RUP, MS Access, DB2, Oracle 8i,CSV files, XML files.

Data Analyst

Confidential, Providence, RI

Description: Confidential Investments provides brokerage subsidiaries, combines innovative trading technology, easy to use and understand trading tools, investment service, investor education and outstanding client service to create the ultimate financial services experience. The project was for investment banking division and it was portfolio analysis and portfolio rebalancing based on the impact of the risk for Capital Market on different securities and derivatives.

Responsibilties:

  • Interacted with portfolio analysts and asset managers’ heads to finalize the Business Requirements for the application.
  • Conducted JAD (Joint Application development) for the requirement gathering and used Rational RequisitePro to analyze and prioritized the requirements.
  • Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
  • Extensively used RAD (Rapid Application Development) to define user’s requirements and to design the final system.
  • Produced the visual models for the application using Rational Rose to create use cases, state charts, sequence diagrams, deployment diagrams and activity diagrams.
  • Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
  • Experienced in FX, Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments.
  • Involved in analysis of various types of risks (Credit Risk, Market Risk), which impacts portfolio management.
  • Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing the functionality, GUI and security testing.
  • Performed risk analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing.
  • Facilitated the weekly meetings with the review teams to continuously improve the QA process for the application development.
  • Used power point presentations for conduction walkthroughs with the stakeholders.
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
  • Monitored and analyzed the development of cascading style sheets in HTML at front end.

Environment: Microsoft Office suites (Word, PowerPoint, Access, Excel, Rational requisite pro, Outlook, Project, Visio), Windows, Microsoft SQL Server (2000 & 2005), Oracle (8i, 9i & 10g), UML

Business Analyst

Confidential, Boston, MA

The Confidential compliance system was implemented to calculate more accurately the capital Market provisions against credit, commercial and operational risk that allows greater business agility, lower programming costs, more visibility and control over how business decisions are being made.

Responsibilties:

  • Interfaced with stakeholders and facilitated communication between client and the IT department.
  • Involved in creating targeted questionnaires and interviews for SME’s, clients and business users to gather requirements while working in RUP environment.
  • Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the application.
  • Identified potential risk concerns within the Accounts Receivable portfolio and efficiently provided a risk assessment for the monthly Credit Watch report.
  • Identified the process flaws in the current system and recommended business process automation in the new system after analyzing and documenting as-is system and to-be system.
  • Developed needs analysis document, User Requirement Specification and functional requirement specification documents.
  • Worked on Rational Requisite Pro in Requirements Tractability Matrix (RTM) for functional coverage.
  • Worked as a liaison between business users and developers to submit requirements and changes, clarify questions and issues.
  • Extensively experienced for organizing and documenting requirements, preparing use cases, writing business documents and reports in Pre- Testing phase.
  • Prepared use case documents and utilized MS Visio to create UML diagrams including use case, activity and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the requirements.
  • Collaborated with the QA team in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements.
  • Developed a user acceptance test plan and test case scenarios to guide a select group of key end-users in testing the user interface and functionality of the application.
  • Worked extensively with MS office suite for preparing status reports.

Environment: Project Server 2007, MS Project 2007, Project Web Access 2007, MS Access, Erwin 4.1, MS SQL server 2000 tools (Enterprise Manager, Query Analyzer), MS Visio 2007, Oracle 9i, and SQL Reporting Services.

Business Analyst,

Confidential , Boston, MA

Confidential is a diversified banking; financial and secondary mortgage company that provides a broad range of financial operations. The project was to consolidate all portfolio management activity into a central workspace with top-down asset allocation and model building tools. The Application was created to ease the operations of the Portfolio Manager for Capital Market and Investment banking.

Responsibilties:

  • Captured and analyzed requirements through interactions with stakeholders.
  • Project was implemented using the Rational Unified Process (RUP) Methodology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC).
  • Established project plans and kept track of the project using MS Project.
  • Managed meetings and reviewed documents with the concerned teams.
  • Accumulated business requirements from various business users and translated them into business requirements document.
  • Documented all the discussions, stored the requirements and tracked the changes maintaining the updated versions of document.
  • Lead business initiatives including brainstorming on new functionality for current systems.
  • Created use case scenarios and documented workflow and business process.
  • Developed use case diagrams, activity diagrams and sequence diagrams with Rational Rose.
  • Created wireframes and screenshots for the application to easily communicate it to the Portfolio manager using MS Visio to assist development and engineering in understanding the requirements.
  • Created and maintained complete development plans that included functional specifications, requirements engineering, Use Case modeling, risk assessment and mitigation, internal and external workflow.
  • Participated in writing test cases and test plans for the given scope items.
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product and ensured that the developers were updated.
  • Prepared Testing Methodology for Black box testing.
  • Conducted UAT to make sure that all the business requirements were catered to the application.
  • Extensively worked with Microsoft Project to manage schedules, deadlines, and resources and collaborate on the project.
  • Ensured all applications were tested for functionality and were adequately controlled in production.

Environment: MS Office Word, Excel, Access, Visio, Rational Requisite Pro, Rational Rose, ERWIN 4.5, SQL, PL/SQL

Hire Now