SUMMARY:

• Experienced in planning, managing and controlling resources to achieve specific application workflow.
• Worked in different domains such as Finance including Investment banking, Retail Banking, Commercial Banking and infrastructure projects.
• Good knowledge of the SDLC process and methodologies such as Agile and Waterfall.
• Competent in extracting, documenting, organizing and tracking the requirements.
• Proficiency in conducting Joint Application Development JAD , Joint Application Review JAR sessions to develop and agree upon a system focusing on business requirements.
• Adept with scripting Business Requirement Documents BRDs , Functional Specifications Documents FSDs .
• Worked on Gap analysis
• Familiar with working autonomously and in a team environment building preserving strong relationships with senior and junior business sponsors, as well as technical specialists adhering to a delivery focused approach while managing business expectations.
• Facilitated User Acceptance Testing UAT with the business users.
• Adept in Requirements Engineering describing them in Hierarchical Task Analysis, Task Descriptions, Data Flow models Data Diagrams Class Diagrams .
• Strong Analytical and Problem solving skills, excellent planning and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises make critical decisions.
• Wrote extensive SQL queries during UAT and data validation.
• Excellent communication and presentation skills
• Good documentation and Process management skills with an ability to effectively understand the business requirement to develop a quality product
• Good judgment skill to access high risk areas on which to focus testing efforts and analyze business processes to suggest improvement.

Confidential

Business System Analyst

Confidential is an IT consulting firm that is into development of banking and payment technology. I currently work as a Business Analyst and I have been working on about five projects to date. The projects include the encryption of PCI Payment Card Industry data within for my department, development of purge process for unwanted sensitive data, development of a new application for conversion of paper bills to electronic, integration of a new CSR task management tool with the internal tools for service request resolution, and finally development of real time web services call for electronic billing.

Responsibilities:

• Involved in developing a solution framework for securing PCI data.
• Define the different forms of data and appropriately categorizing them for a better solution approach.
• Analysis of files and data to for proper classification and assessment of PCI data content.
• Gather requirement for the development of decryption framework and U.I for accessing encrypted date.
• Developed a requirement document and functional design for the project.
• Involve in developing a solution framework for purging unwanted data.
• Defined the functional requirements for the replacement application for the paper bill conversion.
• Gathered requirement for the replacement of Talisma CSR task management tool with AVAYA.
• Discuss with team members about solution framework for projects.
• Assisted in the development of quality assurance activities including Quality Assurance Plan, Product Acceptance Plan, Test Plan, and Test Cases.
• Participated in sessions with the domain and technology specialist to collect and define user requirements.
• Interviewed subject matter experts and application owners from different business lines to gather information, understand the user's needs, define requirements, and develop specifications.
• Involve in meetings with the scrum team in terms of prioritizing of tasks PBI Product Backlog Items , creating milestones and providing business context to development efforts.
• Created activity diagrams, use cases and sequence diagrams using MS Visio to view the system from different perspectives.
• Extracted data from different sources like flat file Excel data sheet, wrote SQL queries and processed data to upload in to the target database.
• Created data model that visually represents the nature of data, business rules governing the data, and how it will be organized in the database.
• Interfaced with the developers to provide all kinds of support and resources needed to resolve domain and technical issues.
• Conducted functional walkthroughs and User Acceptance testing sessions and assisted the development of User Manuals for customers.
• Participated in daily stand-ups and weekly status meetings.
• Trained Internal Users and their partner management employees in the new web Based online applications.
• Adept in the use of Team Funder Server for requirement management.

Confidential

Business System Analyst

Project: Prudential Financial project involves a web based brokerage application which provides their clients, various financial services like Brokerage Services such as Stocks Trading, Mutual Funds evaluation of mutual funds using criteria such as performance and risk parameters, fees and expenses, and thereafter Buy and Sell the Funds , Fixed income Investments Choose bonds and CDs from large fixed income inventory and purchase CDs, Municipal and Government securities online , Annuities etc. I was part of the BA team which gathered requirements for the trade life cycle and I was involved in order initiation and delivery, risk management and order routing. The application enables the retail and institutional clients to check their portfolios online, real time access to accounts, get electronic copies of statements, trade fixed income and equity securities along with providing real time quote information etc.

Responsibilities:

• Gather requirements for automating Fact Sheets, Shareholder Reports and Web Site by analyzing data points for Performance, Risk, Portfolio Holdings and other information required from various data sources including Trading Systems like Charles River and Market Data / Reference Data sources like Bloomberg, Reuters and Thomson Financial consolidated into Eagle PACE and the General Ledger system
• Worked with Front Office Traders and Portfolio Managers to Validate Market valuation / Pricing and performing Data Analysis using SQL Queries and Microsoft Excel of various Equity, Derivative and Fixed Income Securities like US Treasuries, Munis Bonds, CDO, CMO, Corporate Bonds, Money Market Instruments and other Derivatives like Interest Rate Swaps, Forward Rate Agreements FRA and Interest Rate Caps/Floors that were part of various portfolios. This included validating various Bond measures like Yields, Coupons, Total Return for various Funds and the Internal Rate of Return of the Bond Portfolio
• Perform Mutual Fund Structure analysis by analyzing data in Eagle PACE for establishing relationship between various entities like Fund, Share Classes and Portfolios
• Validate Mutual Fund Performance information by testing and creating Reports using Oracle Business Intelligence Suite OBIEE to be sourced into Eagle Pace and do Data Gap Analysis of data required on various reports.
• Responsible for getting Agreements and Approvals for Requirements and Implementations from Technology System Partners and Business Owners
• Work directly with Portfolio Managers and Product Managers to understand the current process for reporting and marketing, create current and Future Process Flow Diagrams, perform Gap Analysis and present the same to Management using Microsoft PowerPoint
• Direct and guide Development and Quality Assurance teams for various aspects of the project
• Lead the development and QA team in terms of prioritizing of tasks, creating milestones and providing business context to development efforts and preparing test cases and test scenarios

Confidential

Business System Analyst

Management Group and actively engaged Project Sponsors and Business users to scope out the project objectives and present analytical and design inputs to the team on various projects for meeting Reporting and Analytical requirements:

Responsibilities:

• Actively engage and collaborate with Developers, QA team and other stakeholders to discuss deliverables, timelines and risks and issues
• Perform Data Analysis for profiling
• Worked with Front Office and Middle Office Users to gathered and analyze Reporting requirements and formulated Business Rules for Securities Transaction, Position and Sales Reporting of various Trades including Fund Trades, Equity Trades, Fixed Income Trades Treasure Bill, Treasury Notes, Corporate Bonds, CMOs, CDOs and Derivative Trades for the Institutional Services Group as part of the Eagle PACE Data Warehouse Initiative with BI Tool Oracle Business Intelligence Suite OBIEE as the front end reporting tool
• Worked on various Market Data / Reference Data sources like Bloomberg, Reuters, Thomson Financial etc. for sourcing trade related data in the Security Master Database about various financial instruments in the portfolio
• Gather requirements for automating the process of creating Fact Sheets, Shareholder Reports and Web Site by understanding the Current Process, brainstorming the proposed new design with the Marketing Team of the Reports and then analyzing data points for Performance, Risk, Portfolio Holdings and other information required from various data sources consolidated into Eagle PACE
• Performed Mutual Fund Structure analysis to identify gaps in Eagle PACE for establishing relationship between various entities like Fund, Share Classes and Portfolios and propose a solution to resolve the same
• Validate Mutual Fund Performance information using Oracle Business Intelligence Suite OBIEE to be sourced into Eagle Pace and do Gap Analysis of data required on various reports.
• Brainstorm the design and impact of the data models with the Data Modelers and Data Architects based on the Reporting and Analytical Requirements of the Business
• Actively participated in the resolution of day-to-day Production reporting needs and issue resolution requests from business users and worked with the development team to resolve the issue with very limited resources and time in hand to resolve the issues
• Actively worked with the Business Users in the UAT phase by helping them build test scenarios, test cases and resolving any anomalies in the results of the reporting elements

Confidential

Business Analyst

Investment Banking and Asset Management services in USA. I was involved in the enhancement projects for Private Banking USA's online portal for clients to manage and monitor their assets, including re-designing of Client's portfolio section, fixed income, FX, tax lots, adding more asset details, cash equities and online trading modules.

Responsibilities:

• Gathered and documented requirements for the Master Data Management perspective with the help of various Tools including but not limited to Use Cases, Process Flow Diagrams, Business Rules for Source-To-Target Mapping
• Involved in detailed discussions for End-to-End Process for various business processes like Account level Reporting, Balance Transaction Reporting, Payments and Statements Processing
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Gathered requirements for sourcing and delivering the data and Interface requirements between various Partner Systems for Payments Processing for Corporate Banking purposes which involved detailed understanding of Payments and Processing Standards like IBANs, SWIFT, ACH etc.
• Coordinated and hosted meetings with multiple cross-functional groups involving Users and Product Managers from distinct Business Groups to understand business requirements, formulate a solution and discuss timelines
• Conducted internal Technology meetings with Data Modelers, Architects and Developers to formulate a design including Data Models and the ETL Process to source the data and to distribute data to downstream partners through XML interface
• Served as a Subject-Matter-Expert for the Master Data Management's project to provide Cash Management Services for scoping and analyzing future requirements
• Collaborated with the QA Team to help build test scenarios and test cases and also do some ad-hoc manual testing using SQL
• Responsible for getting Agreements and Approvals for Requirements and Implementations from Technology System Partners and Business Owners
• Lead and monitored the development team in terms of prioritizing of tasks, creating milestones and providing business context to development efforts
• Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue

Business Analyst

Lending Risk Repository OBIEE as the BI Reporting tool and perspective which included products such as various types of Commercial and Consumer Loan Products offered by the Bank. I was involved in the Credit Approval and Reporting project and worked with the Business users to scope out the project objectives and determine impact and timeline of various deliverables, helped build and track the Project Milestones and intricately involved in the project from inception, requirements gathering to approving QA test scenarios and UAT Testing.

Responsibilities:

• Met with Credit Risk Analysts and Loan Officers to gather Credit Approval Process and Reporting Requirements Credit Exposure Data, Loss Data for Credit Cards TSYS , Currency Swaps, FX Forwards, REPO, Equities, Fixed Income instruments like Bonds, US Treasuries, Mortgage Backed Securities, and Asset Based Lending Products according to the Basel II compliance guidelines
• Validate pricing of securities and formulae for calculating Accrued Interest, Fees and Charges and Loss Given Default LGD and Probability of Default PD based on Market data available from various sources like Bloomberg and Reuters and referencing from the Security Master Database
• Engaged and collaborated closely with the appropriate Business Subject Matter Experts for understanding the Business Processes behind the Small Business Loans Provenir and Credit Cards TSYS1 / TSYS2 from Loan Origination and Collateral Management to Account Maintenance and Settlement
• Developed Source-To-Target Mapping for the Data Mart incorporating various Business Rules
• Analyzed and verified the integrity and reliability of the Loss Data, Exposure Data and Risk rating calculations in the Lending Repository
• Actively collaborated with the Business users in the UAT phase to reconcile the reports from the old system with that of the new system by building appropriate test cases and test scenarios

Business Analyst

registered customers had online access to their accounts. When the customer logged on to the website, he/she could view the account details, made transfers, enrolled in bill pay, added Payees, manage any risks involved, and viewed any messages from Customer Service. The website also had a Customer Service Message Center where the customer could report any problems. The web application used extensive security features to safeguard the privacy and interests of customers and to check and verify the information provided by the customers. Processing Automated Clearing House payments that were done with debit cards and recurring charges. Also collecting data on electric payments and direct deposit of customers.

Responsibilities:

• Interviewed client employees and application owners from different business lines to gather information, understand the user's needs, define requirements, and develop specifications.
• Participated in Join Application Development JAD and Rapid Application Development RAD meetings with the domain and technology specialist to collect and define user requirements.
• Assisted in the development of quality assurance activities including Quality Assurance Plan, Product Acceptance Plan, Test Plan, and Test Cases.
• Coordinated work plans between the project manager and clients using Microsoft Project.
• Created activity diagrams, use case diagrams and sequence diagrams using MS Visio to view the system from different perspectives.
• Conducted detailed study of existing database and worked out a detailed migration plan for transforming disintegrated database from multiple platforms in to single integrated data source.
• Extracted data from different sources like flat file Excel data sheet, access database and SQL Oracle relational databases and processed data to upload in to the target database.
• Using Excel to create Macros and record Macros using VBA.
• Created data model that visually represents the nature of data, business rules governing the data, and how it will be organized in the database.
• Involved in validation of created data model to make sure that all data objects provided by the functional team are completely and accurately represented.
• Interfaced with the developers to provide all kinds of support and resources needed to resolve domain and technical issues.
• Conducted functional walkthroughs and User Acceptance testing sessions and assisted the development of User Manuals for customers.
• Trained Internal Users and their partner management employees in the new web Based online applications.