SUMMARY:

• Over 8 years of Industry experience as a Business / System Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Financial domain expertise with extensive Credit/Debit Card application experience.
• Expertise in Performance Management, Asset Management, Cash Management, Portfolio Management, Credit Management, Client Reporting and implementing its benefits.
• Strong Software Development Life Cycle (SDLC) experience including requirements gathering, analysis, design and review of businesses and software Development / testing as per the Agile, Scrum, Rational - Unified-Process (RUP) and Waterfall method.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Designed the ETL system for populating the Datawarehouse from the operational DBMS
• Well versed with Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\ SQL Scripts
• Experience with Data warehouse applications using Oracle, MS SQL Server on windows and UNIX platforms.
• Proficient in the use of tools like Tele logic DOORS, Rational Rose, Requisite Pro, Rational Clear Case, Tele logic System Architect and MS Visio.
• Well versed with various software development methodologies (SDLC, Extreme Programming, MSF)
• Good exposure to XML, SOAP, Web Services
• Knowledge and understanding of Futures, Options, CDO, CDS, CMO, MBS, Interest Rate Swaps, Credit Derivatives, Swaps, Bonds, Equity Swaps, Capital Markets, Fixed Income, Structured Products.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments
• Extensive experience of working in Retail and Investment Banking services (Asset management, Mortgages, Consumer Credit, Equities/Mutual Funds, Card/Loan Services, financial software applications and Insurance services (Claims Management, Property & Causality Insurance).
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Programming Languages: C, C++, C#, VC++, VB, VB.NET, C#.NET, ASP.NET, Java, SQL, PLSQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Business System Analyst

Responsibilities:

• Established a Business Analysis methodology around the Rational Unified Process.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Controlled and maintained monthly reporting hierarchy change for all Asset Management businesses
• Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.
• Prepared an analysis report based on the COTS evaluation.
• Reviewed Use Case, User Interfaces(UI), ISD, Business Rule Catalog(BRC) for elaborating the data elements.
• Worked as business analyst to support the re-design of the Mortgage Asset Management System.
• Developed project plans and managed project scope.
• Monitored Servers by using BMC Patrol Monitoring system for all servers, databases, and network devices and Foglite.
• Analyzed requirements & recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, SWIFT for treasury and asset management documentation.
• Used Agile Software Development process viz. Scrum, as this was a time bound project.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency)
• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
• Contributed on the design of mainframe batch processes using DB2, JCL, COBOL, IBM Utilities, advanced BMC Scheduling techniques, and Connect Direct processes/jobs.
• All the test scenarios which have been satisfied with the functionality are moved to automation testing using Quick Test Professional.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Monitored and maintened the entire systems of the enterprise applying the same single console used for systems and security management through LANDesk Software Management System.
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
• Analysed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, SQL, Oracle, Rose, MS Word, MS Excel, MS Visio, LoadRunnerWinRunner

Confidential, Stanford, CT

Sr. Business System Analyst

Responsibilities:

• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Analyzed business requirements and developed Use Cases, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, site map and wire frames.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Performed requirement analysis, went through all the use cases and issue logs.
• Prepared an analysis report based on the COTS evaluation.
• Participated in various vendor selection processes and conducted Cost-Benefit Analysis of COTS products and comparison between COTS and In-house developed components.
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.
• Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
• Worked on several mainframe based applications running on an AS/400 platform
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering ERWin tool.
• Experience with Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Helped in migration and conversion of the Sybase database into SQL Server database.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Created DTS and SSIS packages to load data from different file sources, such as text file, excel sheets.
• Created Informatica mappings with T-SQL procedures to build business rules to load data.
• Came up with test cases from the requirements, validated/exercised those test cases in form of integration and regression tests. Used Test Director to map the requirements with test cases (automated/manual), used QTP for automated testing.
• Prepared an ROI analysis report after evaluating the COTS product of the multiple business lines
• Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Collaborated with the Project Managers in Tracking and Managing Project Development Process.
• Maintained, documented and created Business Rule Catalog in a logical form all the required Business Rules for the business functionalities in sync with industrial standards of Financial policies and system implementation
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Assisted in development of materials for new technology and process improvements.

Environment: Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), .NET, Oracle, Crystal reports, IBM Mainframes, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner

Confidential, Norwell, MA

Business System Analyst

Responsibilities:

• Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
• Worked with PM to coordinate daily activities between applications development and Product Management.
• Successfully facilitated vendor selection process (identifying business needs vs. software features) involving 6 major departments within the Creative Production for a Digital Asset Management Tool.
• Conducted Asset Management, Risk Analysis of the Requirements and Traceability focus areas of the various projects and worked with the project team to help them identify the high-risk areas.
• Wrote SQL statements to extract data from the Tables
• 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
• Prepared an ROI analysis report after evaluating the COTS product of the multiple business lines
• Developing automated ETL processes using Excel VBA macros to convert General Ledger data (journal entries, ledger, Assets and Chatfield / indicative data) from PeopleSoft
• Assisted with project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
• Used Agile Software Development process viz. Scrum, as this was a time bound project.
• Conducted interviews with various business users to collect requirement and business process information using MS Visio, Requisite pro.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Documented existing and proposed process flow, analyzed current and target system, and conducted GAP analysis.
• Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios
• Designed and developed all Use Cases and UML models using Rational and Visio
• Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, and documented Business Requirements Document (BRD).
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Participated in entering and tracking system defects in Rational ClearQuest.
• Worked with developers and designers of BPM System to make sure development understands business process and detailed technical requirements.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.

Environment: Windows, DB2, Oracle, SQL, MS Visio, MS Access, UML, Requisite pro, Rational ClearQuest.

Confidential, Las Vegas, NV

Business System Analyst

Responsibilities:

• Offered excellent Cash Management Services including Account Reconcilement Services, Automated Clearing House, Balance Reporting Services, Cash Concentration Services and Sweep Accounts to large business customers
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Facilitating asset management and portfolio decisions, providing risk analysis requirements, looking into different aspects of a merger, providing newer areas of expansion of clientele and increasing future profitability.
• Followed solely RUP methodologies during the course of the project.
• Utilized the 80-20 rule to prioritize and in corporate the critical features. Used Time-Boxing techniques to finish within set time frames.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• 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.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Involved actively in determining the quality and quantity of data to be provided for UAT.
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user and user acceptance testing to ensure and verify system is designed according to user needs.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Suggested measures and recommendations to improve the current application performance.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Casewise modeller, IBM Websphere, XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Boston, MA

Business System Analyst

Responsibilities:

• Extensively involved in every phase of the RUP process starting from Inception to Transition
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Created context sensitive on-line help files for a wholesale banking software. This involved creating animated help screens, writing RTF files, capturing screens, creating hotspots and compiling help files.
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Interface with the Wholesale Commercial Loan and Mortgage user group to address issues.
• Developed and executed test cases for systems testing and User Interface Acceptance testing
• Was Responsible for development of somecustom componentsbased onFlexcomponentsto implement some customized functionalities.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, Use Cases, UML diagrams for overall system.
• Created User Acceptance Test Plan and coordinated UAT for the site redesign project
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Generated server side SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
• Involve in preparing Trace Matrix to design test cases
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Business Objects 6.5.1,XI R2 (CMC, CMS, CCM), TOAD, Crystal Reports XI/XI R2, Oracle 10g, SQL Server 2000, Rational Suite, XML, VBA, Crystal Reports, Oracle, UML, MS Project, MS Office, MS Visio