SUMMARY:

• Having 9 Plus years of IT Industry experience as a Business/Data Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources and Translating Requirements into Specifications.
• Designed and reviewed of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Having very strong experience in Oracle PL/SQL and SQL and around five years of experience in Unix Shell scripting and Perl programming.
• Have analysed,documented functional requirements and identified gaps between FRTB and FINMA, PRA, and IHC requirements.
• Worked with the Business lead to streamline conversion of business requirements to functional specifications. Perform gap analysis, elicit requirements
• Having very good understanding of financial products and processesed existing framework knowledge and strong subject matter expertise in Fixed Income, Derivatives, Equities, Bond Pricing, Mortgage Backed Securities (MBS), Annuity.
• Having good experience in data warehouses, data marts for business intelligence reporting and Debt & Equity financing, Pricing & Revenue analysis, SWOT, ROI and Capital Investment analysis.
• Possess strong domain expertise in the US Mortgage space (Origination, Servicing, Secondary Mortgage)
• Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment .

TECHNICAL SKILLS:

Programming Languages: C, C++, C#, 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, RationalRequisiteProDocumentum, Caliber RM, DOORS, Sharepoint

Bug Tracking Tools: JIRA,MercuryTestDirector,HP ALM, Rational ClearQuest

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

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

Testing Tools: TestDirector,IBM Clear Quest,HP Quality Center and X-Planner

PROFESSIONAL EXPERIENCE:

Confidential, New York, Domain

Business/Data Analyst

Responsibilities:

• Have worked on SQL developer tool to run SQL queries against databases for data analysis .
• Effectively analyzed and leveraged the data to provide input for various Compliance and Regulatory systems.
• Performed Impact analysis,Regression testing of the changes done in the existing system.
• Have Successfully delivered key projects within stringent timelines and delivered with utmost quality as a lead Business Analyst and UAT Lead for various projects.
• Hands on experience in Competitive Analysis, Data Analysis, Gap Analysis and understanding of ROI Analysis, P&L Analysis, SWOT Analysis, Impact Analysis and Cost-Benefit Analysis.
• Worked with offshore teams and co-ordinated development team and validation team.
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Developed work flows for system entities, parameter driven processing, data and functional entitlements.
• Responsible for user training and developing documentation for raining guides.
• Prepared test Data sets and performed data testing using the PL/SQL scripts.
• Have worked in MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Business Analysis:
• Analysed and validated multiple business unit needs into requirements to support the Retail Money In business strategy.
• Planned business requirements deliverables with business, delivery partners and have met commitment dates.
• Contributed to the delivery of effective Retail Money In solutions by gathering and analysing business requirements.

Confidential, NewPort, N.J

Sr. Business/Data Analyst

Responsibilities:

• Worked as a business analyst to build enterprise reporting system to Risk Management, Credit Risk,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.
• Effectively involved in Shell scripting and Perl programming Language.
• Created cash flow models for Mortgage Backed Securities, Whole Loans, Structured Securities using Bloomberg, Intex and ADCO data
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities
• 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.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Worked on data modelling and produced data mapping and data definition documentation
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, DreamWeaver, RUP,SQL, PLSQL, XML, VB, ASP, UNIX, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner

Confidential, Detroit, MI

Business/Data Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• 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.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Checked the web server’s specific logs in Linux environment to debug the issues and validate the server’s health after any JVM level change or DB change.
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
• Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities, and Megas& Tranches
• Controlled and maintained monthly reporting hierarchy change for all Asset Management businesses
• Involved in all phases of software development life cycle (SDLC) in RUP framework.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web sphere and Cognos.
• Worked as business analyst to support the re-design of the Mortgage Asset Management System.
• 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
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Strong knowledge of Centralized data management or Knowledge Management System, scrubbing process components supporting all asset data need on the Comerica’s GWM platform involving securities data load from multiple vendors.
• Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, Activity), using MS Visio.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Developed demonstrated prototypes including data models, business objects universes, reports and business dashboards and received their feedback to define the information access strategy for an integrated data warehousing and reporting solution.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• 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 Clarity.
• Worked on 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
• Prepared Use Cases, Activity Diagrams, Sequence Diagrams, and Class Diagrams according to the UML methodology.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Strong knowledge activities involving corporate actions data integration, Entitlement calculation, notification and reconciliations with custodian through SWIFT, management of Tax/ Market claims to be paid or redeemed.
• 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.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• 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: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, VBScript, Dreamweaver, SharePoint, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, UNIX, Business Objects, Test Director, Load Runner.

Confidential, Irving, TX

Business/Data Analyst

Responsibilities:

• Performed GAP Analysis to analyze the current system and worked with internal users to help define system requirements.
• Extensively involved in every phase of the RUP process starting from Inception to Transition
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• 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.
• Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Responsible for scheduling meetings with users, SMEs and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows development involved in the project. Carried out defect tracking using Clear Quest
• Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analysis, Mutual Funds, Securities trading
• Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
• Produced and managed documentation on release activities to support problem resolution and post-release analysis.
• Creation of Data Comparison Utilities and Excel Macros for IDW to Data Mart Comparisons
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
• Wrote complex SQL code with business logic for Production Data Maintenance (PDM) Impact Analyses and fallow up with implementation monitoring.
• 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.
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Defects found tracked and managed in Quality Center and disposition in defect scrub meetings.
• Developing workflows for system entities, parameter driven processing, data and functional entitlements.
• Responsible for user training and developing documentation for raining guides.

Environment: Windows XP Professional, Oracle9i, SQL, MS Outlook, MS Access, MS Excel, MS Word, Internet Explorer, MS Access 2000, MS Excel, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office 2000, MS Visio 2003.

Confidential, Columbus, OH

Junior Business Analyst

Responsibilities:

• Managed the output requirement project for various Life insurance products.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Conducted JAD sessions for communicating with Stakeholders and Project directors
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Applications tested were integrated to mainframe Vantage system which included business applications for new sales, policies, quotes, and web based applications.
• Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
• Used Unified Modeling Language (UML) for process modeling and use cases.
• Coordinated participation and sign-off of various business partners and customers.
• Interfaced between Business new product builders and System platform builders.
• Worked with systems area to translate business needs into system requirements.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Interfaced with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest),RUP,Casewise modeller, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro