SUMMARY:

• With 10+ years of Industry experience as a Business Analyst and Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Diverse experience in Banking, Financial Services, Mortgage and Insurance.
• Extensive work experience in Agile and RUP Methodologies, executing SQL queries for database management, creating Business Requirements Document (BRD), Use Case Specifications, Traceability Matrix, Functional Requirement Document (FRD), Customer Requirement Documents (CRD) and Workflows. 
• Deep understanding of enterprise data warehouses.
• 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.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, navigational flows, story boards, UI specifications and Sequence Diagrams.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Extensive experience in configuring data mapping between different Databases.
• Knowledge in broad range of financial practices and principles ranging from financial analysis, corporate valuation, equity/capital market research, financial modeling, forecasting, and budgeting to trend analysis, investment banking, asset allocation, portfolio management, risk analysis and derivatives. 
• Knowledge of the Fair Debt Lending and Collections Laws, Excellent oral and written communication skills.
• Analyzed large data sets to quantify regulatory compliance and present results to company leadership. 
• Experienced 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. In addition to this, Experienced in regression, smoke testing and end - to-end functional testing.
• Well acquainted with delivery methodologies like Agile and Waterfall.
• Highly motivated team player with excellent Interpersonal, Customer Relational Skills, and Problem solving 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

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

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

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

Internet: HTML, XML, VB Script, ASP, JavaScript, JSP, J2EE.

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

Bug Tracking Tools: MercuryTestDirector, 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, Niku Project Work Bench

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Lead System Analyst

• Extensively involved in every phase of the RUP process starting from inception to transition.
• Performed Data Profiling to examine the data available in an existing database.
• 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.
• Created Correspondence Requirements Document (CRD), Correspondence Mock ups, Fulfillment Data mapping documents etc. required for the correspondence. 
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation.
• Wrote business rules in source to target data mapping document to make it easy and clear for developers and testers.
• Analyzed default risk, liquidity, credit rating, maturity, and other factors to determine the fair value of non- investment grade and term loan securities.
• Sign Off from the business for the documented BRD's and CRD's. 
• Started off by setting up business overview meetings from Senior Analysts and Subject Matter Experts to gain existing Capital Markets business knowledge.
• Using MDM i have worked on integrations and Enhancements of Data Warehouse and Business Intelligence
• Responsible for developing processes and procedures for governing data movement, data integrity, metadata and various other components of data management. 
• Lead project team of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere and Cognos. 
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin. Defined Functional Test Cases, documented, executed test script in Facets system.
• Involved with Master Data Management (MDM) for Customer Data Integration using Siperian tool.
• Worked closely with UAT team for User Acceptance Testing (UAT) and collaborated with the QA team.
• Generated server side SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2000 environment
• 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.
• Maintained specific companies and transactions to enhance communication across Loan Capital Markets and provide team members with easy access to relevant data.
• Worked on Data transformations, Normalization, rule administration and data classification using Master Data Management (MDM)
• Conducted brain storming sessions and collected information from committee of SMEs from various business areas such as Mortgage servicing, loan monitoring and asset management.
• Provide data mappings (source to target), data modeling, user interface specifications, processing logic as per business requirements to the developer.
• Responsible for integrating SAS applications with other SOA compliant applications using SAS Web Services.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.  Interface with internal customers. 
• Worked on Data Validation and Data Integrity during UAT.
• Responsible working on Sybase and SQL Server Database analysis, design and development skills, including extensive Shell scripting and stored procedures.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
• 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.
• The Internal Audit recommended a comprehensive review of the Loans Portfolio with specific focus on loan documentation with the emphasis on loan loss provision and the processing of loan securities.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Environment: Microsoft Office Suite, Microsoft Visio,, Unix, Windows NT/XP, ETL, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, VBScript,Agile, Dreamweaver,MDM, Teradata SQL Assistant 7.2, SharePoint, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, TestDirector, LoadRunner.

Confidential, Auburn Hill, MI

Business Systems Analyst

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liaison between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• Reviewed CRD - Configuration Requirements Document to ensure all functionality is captured. 
• 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.
• 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.
• 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.
• Served as the link between software development team and internal teams working on regulatory requirements such as Dodd Frank and Sox.
• Worked with SME's of different groups to gain detailed knowledge of Investments and Capital Market and also to understand the cross impacts of the system.
• 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.
• Prepare for and support regulatory compliance and audit remediation.
• Wrote Dodd-Frank specifications for swap-execution facility (SEF) trading & compliance.
• Review and finalize materials for Executive Steering Committee Meetings covering Dodd-Frank regulatory implementation.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Understands impact & nuances of different asset classes as they relate to regulatory requirements and consequently how desks/LOBs& risk management function will be impacted.
• Experience in developing work flows, business requirements documents, gap analysis, roadmaps and related documents.
• Able to craft deliverables to meet specific compliance / change management objectives of the business.
• Familiar with operations and technology functions in capital markets environments.
• Independent thinker and can evaluate impact of regulatory compliance requirements to ops/technology footprint.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Written business rules, requirements, functional and non-functional requirements in Doors.
• Advanced to increasingly responsible positions, culminating in Business Analyst role with primary focus on system enhancements and compliance with regulatory guidelines.
• Analyzed and documented information system requirements and the corresponding impact on business processes.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Involved in full life cycle of Business Objects reporting Application.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• 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, Agile, COTS, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, IBM WebSphere Business Process Modeller, VBScript, Adobe Photoshop, MIS-IP, ACORD, C#. NET, ASP.NET, XML, Business Objects, TestDirector, LoadRunner, Niku Project Workbench, AVPN.

Confidential, Warren, PA

Business/ Systems Analyst

• AnalyzedUser Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Excellent understanding of Risk and Finance Data
• Advised IT management on Dodd-Frank proposals for trading, clearing & reporting. 
• Captured business requirements from all major project stakeholders in an effort to draft a business requirement document for a major international investment bank.
• Proficient in Financial, Banking and trading concepts such Mutual Funds, Check Processing.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Generated Data 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.
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with Capital Markets and Investment Banking solution
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Discussed with SME’s 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.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Wrote test scripts for User Acceptance Testing (UAT).
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Designed and developed Project document templates based on SDLC methodology.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Worked with developers to make sure that they understood the Use Cases.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Designed the universes by creating the Business Objects data model.
• Responsible to import the parts of the existing reports using Business Objects Live Office to develop the required reports in Microsoft Excel and Word.
• Performed functional, integration, regression, system, and acceptance testing
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), COTS, Agile, Visual Basic, SQL, SQL Server, Oracle, C#.Net, XML, WebLogic, WebSphere business Process Modeller, IPFR Services, HTML, ACORD, Dreamweaver, Adobe Photoshop, Windows Forms, Web Forms, LoadRunner, WinRunner, Niku Project Workbench, Project Management.

Confidential, Wayne, NJ

Business Analyst/ Data Analyst

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Complete study of the in-house requirements for the data warehouse. Analyzed the Data Warehouse project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Performed functional, integration, regression, system, and acceptance testing
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Developed estimates, project plans (Microsoft project), training material, BI reports using MicroStrategy
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers credit
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software using a Use Case in Requisite Pro.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), IBM WebSphere, XML, Java, J2EE, JSP, VoAVPN, Oracle, MS Visio, DB2,UAT, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Santa Clara, CA

Business Analyst

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Design, development, implementation and rollout of Micro strategy Business Intelligence applications.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Performed functional, integration, regression, system, and acceptance testing
• Wrote test scripts for User Acceptance Testing (UAT).
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Used SDLC (System Development Life Cycle) methodologies like the Agile, RUP and the waterfall.
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Involved in creation and reviewing of Functional Specifications and created a Functional Requirement Document.
• Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
• Work with the full SDLC, elicit, analyze and define requirements.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Designed and developed Project document templates based on SDLC methodology.
• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Involved in full life cycle of Business Objects reporting Application.
• Involved in Data Modelling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Worked with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, DreamWeaver, SQL, PL/SQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, UAT,WinRunner, LoadRunner