PROFESSIONAL SUMMARY PROFILE

• More than Seven years of experience as a Financial Systems Support Analyst with strong understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis.
• Excellent Business writing skills in writing Business requirements document BRD , Use Case Specifications, Functional Requirement Specifications FRS , Software Design Specification SDS , Software Requirements Specification SRS , Software External Specifications SES , Software Requirement Document SRD , Data Dictionary, Business Continuity Plan BCP , Workflows and Unified Modeling Language UML diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Expertise in Business Analysis/ Data warehousing/Data Modeling and Business Intelligence reporting.
• 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.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language UML in an SOA environment.
• 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, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc.
• Manage full life cycle implementation of Oracle R12 and 11imodules like Accounts Payables, iExpense, Purchasing,iProcurement.
• Proficient in the use of tools like Tele logic DOORS, Rational Rose, Requisite Pro, Rational Clear Case, Tele logic System Architect and MS Visio.
• Strong experience with Bloomberg trade order management system. Wrote requirements for receiving end of day and mid day prices from Bloomberg and the business rules around pricing and p L calculations.
• Good exposure to XML, SOAP, Web Services
• Experience in conducting GAP analysis, User Acceptance Testing UAT . SWOT analysis, Cost benefit analysis and ROI analysis.
• Extensive experiences in Investment Banking projects specialized in Securities Trading stock trading, fixed income trading, and derivatives trading , wealth management and risk management.
• Have good understanding with entire phases of Software Development Life Cycle SDLC .
• Experience with Data Extraction, Transforming and Loading ETL using various tools such as Data Transformation Service DTS , SSIS and Bulk Insert BCP .
• Good exposure to XML, SOAP, Web Services
• Full understanding of Rational Unified Process RUP using Rational Rose, Requisite Pro, Unified Modeling Language UML , Object Modeling Technique OMT .
• Knowledge in the Informatica/ ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence .
• Experience in Scrum Process and thorough understanding of Extreme Programming XP , Agile Software Development Methodology and Object Oriented Analysis OOA .
• Hands on experience as an expert user of MS Excel, MS PowerPoint, MS Access, Business Objects.
• Strong experience with Bloomberg trade order management system.
• Skilled in User Acceptance Testing UAT at the implementation phase.
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Basic understanding of Business architecture Zachman and POLDAT frameworks and Service-oriented Architecture SOA .
• Exposure to SAP Finance FI module.
• Experience in Competitive Analysis, Data Analysis, Gap Analysis and understanding of ROI Analysis, P L Analysis, SWOT Analysis, Impact Analysis and Cost-Benefit Analysis.

TECHNICAL SKILLS

• Languages / GUI: C/C , SQL
• Databases: Oracle10g , Oracle 11i, Sybase, PostgreSQL, DB2
• Modeling Tools Languages: Rational Rose, MS Visio, UML
• Project Management Tools: MS Project
• Requirement Traceability Matrix: Rational Requisite pro, MS Excel
• Change Management Tools: Rational Clear Quest , DOORS, MS Office, Snag-It
• Testing Tools: LinkScan, QTP, Win runner, LoadRunner
• Web Technologies: HTML, CSS, XML, LAMP, AJAX
• Operating Systems: MS-DOS, LINUX RH 9.x
• Banking Protocols: FIX, SWIFT
• Financial Terminals: Bloomberg , Reuters, Capital IQ

PROFESSIONAL EXPERIENCE

Confidential

Sr. Systems Analyst

Responsibilities:

• Garnered insights on present framework and laid out the client centric application Presentations .
• 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
• As a Business Analyst, developed business process flows, Use Cases, and other documentation for expansion of Fannie Mae's MBS loan servicing, securitization, and trading model while coordinated with Development Team in translating business requirements in
• In CDM project, analyzed traditional Swaps and Credit Default Swaps and their trading and allocation processes.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Credit Profiling, Treasury /Cash Management, and Marketing Analysis. Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Built Web services hosted on a database to connect to Web application using SOAP,XML,WSDL,ASMX
• Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
• Assisted in building a Business Intelligence Process Model using Rational Rose and Visio.
• Assisted the IT team to develop service oriented architecture SOA , and data warehouse system to utilize data mining for data analysis.
• Excellent skills in Business Intelligence, Data Warehouse, Data Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Analyzed and documented the system specifications, Business requirements used the tool DOORS for documenting, tracking and analyzing the requirements.
• Improved design for R12 implementation by analyzing legacy data, identifying gaps in processes, creating project plans, mapping documents and management presentations, ensuring completion and accurate communication.
• Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Performed Data scripting and mapping between the LaserPro and ARTA loan origination applications to FiServ CBS and other banking applications.
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Implemented the stored procedures to modify/adjust the posted P L values.
• Designed rich and user friendly interfaces for the web using HTML, CSS, XHTML, XML, XSLT.
• Field Service Conversion from Legacy System to Oracle 11i.
• 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.
• Knowledge of Trade Life Cycle as well as the Order Management System OMS
• Assisted in ROI, ROM and GAP analysis.
• Directed the creation of software test plans and coordinated UAT sessions with the client documenting detailed results.
• Responsible for business units consolidated general ledger inclusive of preparation month end closing, including adjusting, closing and balancing accounts, journal entries, account reconciliations, inter-company analyses, and balance sheet, income statement, and cash flow analyses
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked in 2 full life cycle implementation of Oracle 11i Financials including General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, including hands on Configuration of these applications.
• 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
• Apply custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products
• Designing, developing and tuning Oracle Forms 6i for an enhancement to Oracle 11i OPM.
• 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.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language UML in an SOA environment.
• Performed Competitive Analysis on different online trading applications like GS, MS, SCHW etc,
• Reviewed/evaluated four loan origination systems to determine the best system to be integrated into new front-end system.
• Performed SAT, UAT, Production testing, and Report and track the defects in HP Quality Center.
• Define and control requirements baselines in the program's requirements management system DOORS
• Conducted User Acceptance Testing UAT .
• Facilitate product/content reviews for assigned projects to ensure accuracy and market sensitivity of programs. Perform project management duties for internal service management and client reporting initiatives and other projects as needed, inclusive of the entire project management lifecycle.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio BIDS including SSIS and SSRS.
• Collaborated with business leaders to gather requirements for Oracle r12 Cost Management rollout and advance the project.
• Providing Planning solution that focuses on financial statement derivation including P L, Balance Sheet and Statement of Changes in Cash Flow for the purposes of Budget and Forecast.
• Focused on Pre-Conversion, Conversion and Post Conversion support for roll out of Oracle 11i Applications.
• Conducted ROI, Technical feasibility and operational feasibility studies
• Involve in preparation of report template for daily and weekly reports based on requirements.
• Generated requirements from Feedback from FA's / Users' requirements via CRM SFDC or Salesforce.com
• Managed Cross Team Collaboration and Offshore Testing team.
• Other areas include enhancements in Portfolio, Account setup, Content management, E-delivery and prepared Quick reference guide for CPB clients.

Environment: Windows 2000, JAVA, XML, XSL, DOM, SAX Parser, HTML, ASP, Rational Suite Rose, Clear Case, Clear Quest , MS-Project, MS-Office, MS SQL Server, DOORS, Oracle 11i, PL/SQL, Quick Test Professional, Win Runner and Load Runner.

Confidential

Sr. Systems Analyst

Responsibilities:

• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Having a common order management system to eliminate shadowing of trades from different system.
• 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.
• Possess understanding of the Structured Finance with a focus on Asset Backed Securitization including MBS, credit card receivables securitization, insurance risk securitization, auto loan securitization etc.
• Responsible for Leading the Business Process Reengineering effort and for the SRS Software Requirements specifications documentation of the build out of the FWA dashboard and for client reporting.
• Liaison between business units and IT Department to ensure the delivery/enhancement/maintenance of loan securitization management system
• Proficient in Unit Test Plans UTP , Integrated Test Plans ITP Extensive experience in User Acceptance Testing UAT .
• Managed the production of cash flow, P L and balance sheet reports
• Complete the breakdown of printed reports to be packed, labeled, and distributed to various clients and Fiserv's user departments
• Worked on loading and writing XML files using a Dataset, Standard Monthly, Weekly and Daily reports were saved as XML files. These XML files were formatted using XSLT files into XHTML for viewing in a web browser.
• Implement the business intelligence plan that supports key long-term strategic needs and obtain all resources necessary for their execution.
• Designing and developing the user interface using JSP/HTML.
• Been a part of Architecture and modeling team and have used SOA Service Oriented Architecture
• Strong understanding of the securitization process and structured finance products such as mortgage and asset backed securities, interest rate products, credit products. Involved in the pre-trade as well as post-trade valuation of products, calculation of P L and risk valuation.
• Determined and Drawn the preferred flows for OMS Charles River , TMS figuration, BOSS and MEO for financial instruments Stocks, bonds, Options, Mutual Funds, Preferreds, etc with the consideration of Web discounts, daily trading account value, margin requirements, IRA accounts, trading limits, Lead-Ins and Lead-Outs, GLAS Gain Loss Analysis Systems , Confirms, Settles, Trade multiplier, etc. on MS Visio.
• Depending on the ISR and meetings, Scope and high level estimates were sent for approval.
• Once Scope is approved, Draft SRS master document was prepared and detailed business requirements were captured.
• Responsible for cost estimation and timelines for various Business Intelligence reports
• Implemented new integrated Savings, CD, IRA system new Leasing system first Consumer Loan Securitization numerous acquisitions new Credit Scoring system new Commercial Loan Accounting system new Collections system
• Involved depth understanding of Credit Risk management for the application
• Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Designed the front end in adobe flex using adobe flex LC services
• Involved in Service Oriented Architecture SOA .
• Financial Implementation of Oracle 11i, 11.5.9, including All CRM, GL, AR, AP, FA, Purchasing Inventory, I-Supplier, MRP and WIP.
• Transform disjointed data from several different sources including Business Objects, Spreadsheets, Remedy and other management tools.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Academic Experience in conducting SWOT analysis, Gap analysis, Risk analysis, Net present value NPV analysis, Return on investment ROI analysis.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Charles River CRD gap analysis review sessions for order management selection.
• Coordinated various kinds of User Acceptance Testing UAT including regression testing, system testing, integration testing, functional testing, alpha beta testing.
• Performed Data scripting and mapping between the LaserPro and ARTA loan origination applications to FiServ CBS and other banking applications.
• Created test cases, test plans for Charles River compliance rules for the algorithm tools.
• Worked on Trade Life Cycle as well as the Order Management System OMS
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• 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
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Responsible for creating Use Cases, Business Process Modeling and Work Flow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
• Prepared year-end financial statements P L, Cash Flow, Balance Sheet and budgets for the company.
• Prepared test scripts and conducted testing in 11i.
• Collaborated with Oracle Product Development and QA teams to test the integration of Oracle Demantra with Oracle E-Business Suite R12.
• Wrote test scripts for User Acceptance Testing UAT .
• Maintenance on a Work Order Management System.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Created customized reports in Charles River such as commission analysis report, boxed position report, take-over report, and compliance report etc. using Crystal Reports, Excel VBA and SQL.
• 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
• Also, helped the testers with automated testing in higher environments, QA-NR, TEST and QA.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Created use case scenarios and documented work flow and business process using Rational Rose

Environment: Windows XP, Enterprise Architect, SharePoint 2007, Requisite Pro, Oracle 11i, MS-Office Suite, MS Visio, MS SQL Server, XML, XSL, DOM, SAX Parser, DOORS, Maximo and Maximo Spatial, Arc GIS, Test Director.

Confidential

Business Analyst

Responsibilities:

• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Successfully managed the production support team for mortgage servicing application.
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Responsible for the data cleansing in Quick Base, as per the court orders.
• Validated the test data in DB2 tables on Mainframes and on Tera data using SQL queries.
• Wrote custom DOORS DXL scripts to perform periodic quality checks on database content.
• Developed small applications with Tera data at the backend.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Completed requirements analysis for Loan Origination System LOS project and Compliance Engine project. Documented the same in the form of Requirements documents and Use Cases.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Used Visual Basic Editor VBE for developing and testing Macros in Excel
• Developed business intelligence reports using Business Objects BO tool for the updated results to the stake holder
• Captured and documented system level SSS and software level SRS requirements in DOORS supporting the SOW and system design for the SCL3S Airborne Communcations program.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Used DOORS to link requirements to test cases, business rules, design items to maintain traceability.
• Coordinated UAT, Regression and Integration testing schedules and completed the same.
• Worked as a business systems analyst for developing a Microsoft .NET-based loan origination application that handles all the complex tasks of loan origination, including credit request, credit underwriting, loan approval, facility booking, and credit administration processes through the entire development process.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio BIDS including SSIS and SSRS.
• Writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in Data Stage, and creating ETL jobs in Data Stage.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Performed all phases of end to end testing like UAT, functional testing, regression testing, GUI testing, boundary testing, negative testing and system testing.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Performed User Acceptance Testing UAT and was fully involved until implementation.
• Prepared system Test Plan and scenarios for Test Scripts.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Rational Enterprise Suite Rose, Clear Case, Clear Quest , RUP, Tera data, Visual Basic, SQL, SQL Server, Oracle, C , PL/SQL, HTML, Unix, Agile/Scrum, MS Visio, MS Office, Load Runner, Win Runner, DOORS

Confidential

Business Analyst

Responsibilities:

• Worked with the core team to design business requirement collection approach based on the project scope and SDLC Methodology.
• Designed and developed Project document templates based on SDLC methodology
• Work closely with Business Owners and Stakeholders to outline Business Requirements.
• Work with System analyst and IS teams to understand the flow of data.
• Reviewed and analyzed data from various sources.
• Facilitate risk management workshops, recording risk and assigning risk for mitigation. Research and resolve system issues and perform application testing as necessary. Produce metrics reports from data derived from database as necessary for the project.
• Identified gaps and performed gap analysis with respect to CMS requirements
• Involved in Expanded executive awareness by providing tactical briefings to the Site VP and Senior Managers with increased participation in correctiveaction screening, outage management and space allocationteams.
• Servedasmentorand visionary while improving communication/transparency.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language PL/SQL .
• Developed business process models in RUP to document existing and future business processes.
• Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
• Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Duties included maintenance of existing and development of new Unix Korn and C shell scripts for sales/marketing EDI data extraction and uploading to Excel spreadsheets and MS Project files
• Managing EDI changes and customizations.
• Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend the most efficient solution for system design.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications Data Mapping, and process flows.

Environment: Windows XP, Oracle/SQL Server 2000, SQL, Telelogic DOORS 8.1, Telelogic System Architect 10.6, Mercury Quality Center , RUP, UML, MS Visio, MS PowerPoint.

Confidential

Systems Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Conducted extensive requirement analysis using Rational requisite pro
• 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 and overall system.
• Gathered Business/Functional Requirements from Business/R D Users.
• Managed internal R D and client sponsored web based projects.
• Used Test Director, PL/SQL for testing the application
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design UI screen using Microsoft Visio.
• Supervise and manage projects throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project and NIKU Workbench.
• Modeled PowerOn Electricity Outage Management System using MS Visio
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process RUP methodology in all areas of the software development life cycle SDLC .
• Used ClearCase for creating documents repository and sharing the documents across the team.
• Created traceability matrix to ensure that the requirements are traced to the test cases.
• Ensured that extremely thorough, effective and organized test process is implemented and delivered the highest quality product.
• 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: MS Excel, MS Visio, MS-Project, Power Point, Windows XP professional, Share point.