SUMMARY:

• Over all 9+years Professional Experience as Business Analyst.
• Systems Analyst with strong knowledge of Insurance, Finance, Retail, Marketing and Banking domain.
• Excellent communication and presentation skills.
• Acted as a liaison between business users and technical team.
• Strong Knowledge of business Architecture.
• Worked individually, as well as in team environment, to achieve project quality goals.
• Thorough knowledge of SDLC, RUP methodology, Requisite Pro, Clearcase and Rational Rose.
• Deep understanding the knowledge of Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, etc.
• Experience in designing and developing project document templates based on SDLC methodology.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting.
• Deep understanding the knowledge of Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, and Basel II Compliance etc.
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T - Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
• Expertise in Performance Management, Asset Management, Credit Management, Client Reporting and implementing its benefits.
• Extensive experiences in Investment Banking projects, specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Good Knowledge of Capital Markets.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Experience in designing and developing reports using Microsoft Reporting Services (MSRS), Crystal Reports, MS Access, and Data View web part.
• Comprehensive knowledge in Derivatives including Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives
• Extensive experience in analyzing models and optimizing business processes, data flows, document business requirements and functional specification documents.
• In depth knowledge of Entity Diagrams, Sequence Diagrams, collaboration diagrams, activity diagrams.
• Strong Project Management skills including Requirements Gathering, Risk Management and Mitigation, Effort Estimation and Constructive Cost Modeling (CoCoMo).
• Comprehensive experience in Root-cause analysis, SWOT analysis, Feasibility studies, GAP and Variance analysis, Impact analysis, Risk analysis.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Highly skilled in developing stored procedures, functions, triggers, DTS and SSIS.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Knowledge of futures and options strategies for hedging investments
• Facilitated Joint Application Development (JAD) sessions, one on one interview and meetings with business users and SMEs.
• Strong Subject Matter expertise in Web applications, Mutual funds, Retail/ Investment Banking, Risk Analysis, Loan Servicing.
• Experience in Developing Reports using Crystal Reports in .Net
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Developed the QA test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge by using Test Director.
• 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.
• Proficient in writing SQL queries for data analysis and validation
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Assisted in building a business analysis process model using Visio.
• Experience in conducting Feasibility Studies, Data Analysis, System Analysis, Gap Analysis, Risks Analysis and Root Cause Analysis (RCA).
• Change Management and Impact analysis.

TECHNICAL SKILLS:

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

Development Methodologies : RUP, AGILE, Waterfall, ESDM, STV

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

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

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

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

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

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Sr. Business System Analyst

Responsibilities:

• Worked on Health Insurance, Mutual Funds, Asset Management, Portfolio Management, Wealth Management, and Sales and Marketing.
• Captured requirements for Capital Markets - Mutual Funds, Retail, Marketing, Portfolio Management, Hedge funds, corporate actions, Brokerage in Model within the scope of both the Front and Middle Office.
• Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Insurance, Capital Markets and Marketing - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
• Responsible for developing and supporting requirements for aquiservice flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non financial transactions and trading operational processing in Comerica’s global wealth management platform.
• Understood all aspects of a claims processing lifecycle starting from identifying a claim right up to closure.
• Performed White Box testing by using Expediter tool and updated some of the PROCs, JCLs and SAS programs in the Test region. Submitted batch JCLs in order to create output datasets for verification.
• Developed backend calculations required to produce volatility and correlation matrix using SAS.
• Perform Financial Statement Analysis (FSA) relating to Fund of Funds (FOF) Portfolio Valuations in comparison to the financial statements of the underlying securities & brokerage reports.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk.
• Provide customer service and support for Property & Casualty risk management needs.
• Assisted with project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
• Extensive experience in business integration in analyzing requirements gathering and writing system functional specifications including use cases.
• Involved depth understanding of Credit Risk management for the application
• Conducted User Interviews and Work Shops to gather accurate Business Requirements
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Worked on brokerage applications for trading, risk management and processing. Wrote BRD & FRD by gathering requirements from SME's using Murex Mx Asset Manager, to build up.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Collected information and requirements about different Entities and attributes from FDS.
• Completed GAP analysis in detail on all entities in CCL for a source system.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Worked as a representive in the field Mortgage securities trade life cycle.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.

Environment: Fidelity IMPACS, Fidelity Savings Time, SAS, MS PowerPoint, MS excel, Fidelity Finance Management, Agile, Mainframes, COBOL, Monarch, JCL, SQL.

Confidential, Miami, Florida

Business Analyst/ QA Lead

Responsibilities:

• Extensively worked with SMEs in Formalizing and analyzing Trading Tools and Functions, including Market Order, Limit Order and Daily Trading Volumes
• Worked with SMEs in the analyses of Efficient Frontier, Risk Factors, Alternative Returns and CAPM and P/E Asset Valuation Method.
• Driven the Offshore Team.
• Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director
• Assisted client in development of business requirements, including identification of opportunities for Improvement and Optimization of Business Processes.
• Documenting business requirements for re-engineering the Customer Profile System to accommodate the new employee benefit trust account infrastructure.
• Identifying and establishing retirement plan account identifiers for the Customer Profile System.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Wrote detailed specifications for various reports generated using Cognos
• Developed and maintained programs in SAS for UNIX in a user support environment.
• Extensive experience with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS/Stat, including thorough knowledge of SAS Macro.
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution
• Identifying and designing new account opening screens to be used for a re-designed front- end system.
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution.
• Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan
• Maintained a close and strong working relationship with teammates, developers, testers and management staff by conducted regular one-to-one sessions and group meetings.
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Gathered and Documented Business requirements for the Risk/Return Analysis, and Portfolio Optimization and Diversification.
• Developed Business Requirement Documentation, Functional Specification Documentation and High Level Testing Plan.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Conducted and Documented High level System Design
• Prepared both simple and detailed User manuals and assisted training session of the new and improved system.

Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, Rational Unified Process (RUP), Windows NT/XP/2000, UML, UNIX, MS-Project, MS-Office 2000, MS Outlook, MS Access, MS Excel, MS Word, Internet Explorer, MS Visio, Casewise Corporate Modeller, WinRunner, Test Director

Confidential, NY

Business Analyst / System Analyst

Responsibilities:

• Obtaining a detailed knowledge of the business process being followed in the project environment.
• Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Extracted the business requirements from the stakeholders keeping in mind their need for the application and documenting them using Rational ReqPro.
• Involved in put or call options that protects an investor from foreign-exchange risk for a future sale or purchase of a specified foreign-equity portfolio.
• The Credit Risk Evaluator Project is an integrated customer - controlled platform for credit risk management. It is a powerful tool for measuring and monitoring and managing credit risk, thereby offering a broad range of analytical Capabilities and user control.
• The platform enabled institutions to estimate and stress credit risk measures and rating estimates by using scorecards/models.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Interacted with database developers for formulating the ER diagrams and data flow diagrams.
• Created cross-functional flow chart using MS Visio.
• Used 3rd tool Crystal for ad-hoc reporting.
• Undertook back end testing using SQL and wrote queries.
• Effective communication made possible between the developers and the end-clients to guarantee that development efforts were within the scope of the project and the development was as expected.
• Supported traders for front office operations like order management.
• Held regular JAD meetings with the system architects, developers, database developers, and quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
• Carried out defect control and change control in ClearQuest.

Environment: Windows, Oracle 9, SQL, Microsoft Office suite, Microsoft Visio, Clear Quest, Rational Unified Process (RUP), RequisitePro, Clear Case, UML.

Confidential, Princeton, NJ

Business Analyst

Responsibilities:

• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Involved in development phase meetings for business analysis and requirements gathering for the Common Claim Layout (CCL).
• Involved depth understanding of Credit Risk management for the application
• Conducted User Interviews and Work Shops to gather accurate Business Requirements
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Designed and developed Project document templates based on SDLC methodology
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Run the SQL queries using TOAD and SQL Navigator.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel Compliance requirements.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Organized various UAT sessions and made presentations to the users on the project and the changes implemented.
• Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Configured the Data mapping between Oracle and SQL Server 2005.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Created the test cases for all the Use Cases using EA tool.
• Created test scripts for all the test cases in PL/SQL.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, Autosys 4.1, WinCVS 1.3,Microstrategy, Enterprise Architect 4.5, Sybase, Visio, Toad 8.0, Erwin, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, DOS and UNIX Sequential Files, MS Access, CSV Files, XML File.