SUMMARY:

• Over 7+ Years Professional Experience as Business Analyst in Banking and Financial Industry.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Excellent in Developing and evaluating business process Models.
• Proven success as a data analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD Experience in Software Development Life Cycle (SDLC)-Waterfall, V-Model and Prototype and worked on reporting tools ( Crystal Reports & Microsoft Reporting Services).
• Comprehensive knowledge of the Student Loan industry and Commercial Lending.
• Strong experience in RUP Business Modeling process.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a data analysis methodology for application functionality designs using IBM’s Rational Rose.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Excellent in Developing and evaluating business process Models.
• Knowledge of Commercial Lending Systems like Loan IQ. Familiarity with Consumer Lending Processes. and review 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
• Proven success as a data analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML for investment, banking, insurance and mortgage sectors.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Modeling and Design.
• 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.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
• Experienced in with SQL and PL/SQL with familiarity in RDBMS such as MS SQL Server and Oracle.
• Advised management on improvement strategies, Competitive & Profitability Analysis.
• Financial products involved: Fixed Income, Equities, Bonds, Mutual Funds, Fund of Funds, Insurance, Retirement Planning, Generation Planning and complete Financial Planning
• Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.

TECHNICAL SKILLS:

Software/Hardware: OOAD (OOA/OOD), RUP, UML, SDLC, Waterfall, QA, WAP,CVS,TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA,DB2. ATG, Windows 98/2000/XP, basic UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, Project, Visio, Adobe Photoshop, Flash, Rational- Rational Rose, Rational XDE, DOORS, Cobol,RequisitePro, CaliberRM, Crystal Reports, various NIKU products, C, C++, Sharepoint, Docushare, BASIC, Intermediate level-Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

Sr. Business Analyst

• Provided End-user support by supplying effective product, efficient process and functional solutions to resolve and enhance currant user application functionality in agile Environment.
• Developed Business Process mapping of process areas/steps, data utilization, and systems map.
• Designed the target end state of the process and the right way to measure performance.
• Documented the processes and defining the respective control standards in capturing business requirements and in documenting user requirements into functional & non-functional requirement.
• Provided advice as a 'virtual' SME to the programmer & testing unit & associated teams.
• Documented functional and non-functional business requirements as identified through the system process mapping and vendor liaison sessions including JAD sessions.
• Documented UAT test case scenarios and detailed test cases accurately.
• Involved in pre and post go-live activities and end user training where required.
• Facilitate and contribute to workshops, JAD and participate in one-to-one meetings to enable the clarification of requirements and ensure logs are taken in each meeting or workshop or JAD and that these were communicated to the team using daily stand-ups.
• DataEnsured that meetings and issue resolution with SME's as part of the continuous, iterative review process are facilitated.
• Possess a high level of technical ability with SQL Server Management Studio, SAP Crystal Reports, Microsoft Visual Studio, Adobe LiveCycle 4.0, Excel, Word, and Visio.
• Worked closely in liaison with IT to collaboratively deliver the front to back solution.
• Proactively highlighted issues and risks, and recommending solutions or mitigating actions as appropriate.
• Provided strong analytical skills, proven track record in business requirements analysis and specification writing for projects in a financial industry / banking / risk/finance environment.
• Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Delivered support or ensure suitable escalation on Business issues for the SWIFT conversion.
• Worked closely with Developers on data integration and Work Flow issues Brokers/Custodian and 3rd Party SWIFT messaging interface.
• Defined user acceptance criteria accurately for the change management process in agile environment.
• Coaches and mentors agile team members including technical staff and the users (staff and management) and provide constructive performance feedback.
• Created and maintained artifacts by evaluating needs, clarifying requirements, and analyzing use cases and dependencies to recommend a course of action.
• Used MS Visio to create product maps and sequence diagrams.
• Worked closely with project manager and gave inputs in the strategic development of detailed project plans, work assignments, target dates in MS Project.
• Involved in writing complex SQL queries & Involved in the enhancing the web services by managing the JAVA Scripts.

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Crystal reports, RUP, UML,Loan IQ, Visual Basic, SAP, Mainframe, Win Runner

Confidential, Atlanta, GA

Business Analyst

• Analyzed the Business, Functional Requirements and Streamlined the Testing Activities
• Developed Test Plans, Test Scenarios, and Detailed Test Cases based on the Use Case Documents, Business Requirements, and Functional Specifications.
• Tested Loan IQ operations related to the commercial loan trading system
• Testing and delivery of enhancements to Loan IQ to meet business requirements
• Responsible for complete Loan IQ Business Support, including troubleshooting all issues
• Examined application for testing, data validation, and workflow of customers.
• Helped analyzing business processes and created Business Requirement Definitions for new Loan IQ functionality to accommodate specific regulatory and business requirements.
• Performed initial manual testing of the application as part of sanity testing
• Customized the scripts according to the requirements by inserting conditional statements and loops.
• Extensively used Database checkpoints, GUI Checkpoints using Win Runner.
• Analyzed the results, tracked the defects and generated reports using Quality Center. Performed Regression test to ensure product integrity after modification and enhancements.
• Worked with technical staff to validate test requirements, resolve design issues and software defects.
• Executed queries in test databases using SQL queries.
• Involved in creating UAT Test Plan and subset of Functional test cases for UAT test Conducted walkthroughs and inspection meetings with the stakeholders and other management teams in the finalization of the User Requirement Documentation
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Prepared Use cases and Activity flow diagrams and Work flow diagrams with MS VISIO
• Source Business analysis, analyzing and Designing mappings for data extraction
• Performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data
• Using UNIX console commands to check database has been connected the other functionalities.
• Documented business, process, work, system, information flows using modeling techniques Unified
• Tested the Performance of the database (SQL queries) in real world workloads.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Participated in the support of BI applications with IT applications and technical staff.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Drafted Business Requirements Documents, Business Requirement Specifications, Business Work Flow Diagram, Use Case Diagram, Data Flow Diagram, Cross Functional Diagram to represent Business requirements.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Facilitated JAD sessions with end users, development and QA teams.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: MS Office (Microsoft Word, Excel, Access, PowerPoint and Visio ), Server, UNIX, MS Visio, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot

Confidential, Phoenix, AZ

Business Analyst

• Extensively involved in every phase of the RUP process starting from Inception to Transition
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Established centralized QA processes at the corporate level designed and implemented QA processes and procedures
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Provide insight, guidance, and reporting on default mortgage options to optimize operational revenue
• Worked with key members from various cross-functional teams to analyze various third-party CRM solutions to make a ‘buy vs build’ decision. Conducted cost/benefit and impact analysis.
• 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).
• Selected Automation tool, test lab and established QA Automation standards
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Worked closely with the project team in planning, coordinating and implemented QA methodology on various phases of the application
• Used Rational Rose to designed and develop Use cases Scenarios, Use cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML.
• Used DOORS for requirement management to capture, link, trace, and analyze and manage.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used Lean Six Sigma and CMMI (SDLC) to ensure applications are delivered on time and on budget with optimum accuracy
• Elicited, documented, verified, and validated all Pega Modification Portal letter requirements

Environment: MS Office (Microsoft Word, Excel, Access, PowerPoint and Visio ),Rational Rose, Rational Req Pro, RUP, WinRunner, ETL, SQL, Load Runner, XML, Java. .Net

Confidential, NY

Business Analyst

• Design & lead the loan rescinding (borrower right to decline) workflow initiative within ELS with the help of business users to automate the current manual process, resulting in fully automated and centralized workflow
• Lead data quality initiative for downstream document printing & reporting interfaces for various internal department & government regulatory bodies
• Written complex SQL queries for querying data against different data bases for data verification process.
• Designed and developed project document templates based on SDLC methodology.
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Gather, define and document custom fields & screen requirements in ELS based on various business teams for capturing data for downstream interfaces
• Work with compliance on system wide audit fields that are required to be monitored for changes within the ELS system, resulting in better quality of data for internal application audits
• Assist in pricing new deals for purchasing Mortgage Servicing Rights for Residential Mortgage Portfolios in US
• Developed straightforward RDBMS queries, knowledge of xml interface messaging.
• Worked closely with business users, developers (both onshore and offshore), and QA testers.
• Track Encompass support issues and resolutions in order to identify possible training needs or system changes.
• Managed and participated in commercial and residential real estate mortgage underwriting and due diligence projects with varied scopes and transaction sizes, loan file audit reviews, credit and default risk analyses models, and securitization agreed-upon procedures accounting projects
• Researched requirements to comply with new legislation requiring registration and background checks for all residential mortgage loan originators (MLOs)
• 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.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Performed initial manual testing of the application as part of sanity testing
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Developed reports including line and pie charts, trend analysis and sub-reports using SQL Server Reporting Services (SSRS).
• Exclusively used SQL, T-SQL for designing modifying and maintaining the SQL Server Tables, Views and Stored Procedures accordingly
• Generated XML documents using the XML Output Stage.
• Assisted in developing test scenarios, test scripts, and test data to support unit and system integration testing.
• Involved in testing of the system to check it satisfies functional specifications.

Environment: Windows XP, Oracle/SQL Server, UNIX scripting, SQL, MS office, Rational Rose, Rational Requisite Pro, OOAD, .Net, MISMO standard XML, Test Director, ClearCase, UML, Rational Suite, MS Visio, MS Project.

Confidential, MN

Business Analyst

• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Experienced in mobile device testing with Android, iOS operating systems and Win7/IE8 Tablets.
• Facilitated JAD sessions with end users, development and QA teams.
• Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
• Interacted with the business and technical team to create front-end and back-end FSD’s and communicated these to the stakeholders while co-coordinating approvals.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams with MS VISIO
• Developed a consistent reporting system cash flow, P&L and balance sheets.
• Perform relevant project management processes and supporting processes e.g. scope, cost, time, issue, risk, resource, communication, stakeholder management
• Tested the application on mobile devices like iPhone & iPad.
• Developed Test Plan, Master Test Strategy, Test Agreement, and Test Scripts
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Analyzed the business and functional requirements of the application and also helped in developing detailed test plan and test cases.
• Responsible for 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
• Gathered requirements for cash management practices adhered to accounting principles or GAAP.
• Prepared Business Requirement Document and then converted the business requirements into Functional Requirements Specification.
• Developed Business rules for the equity trading system based on technical chart analysis and fundamental analysis and trends.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system.
• Performed UAT based on Requirements Document and prepared the Test Cases using Quality Center.
• Exposed to SQL queries while churning out relevant information from company’s database.
• Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
• Participated in entering and tracking system defects in Rational ClearQuest

Environment: Windows XP, UNIX, JAVA, Rational Requisite Pro, UML, Rational Rose