SUMMARY:

• Over 7 years of comprehensive experience in IT industry with specialization in the Business Analysis in various domain Mortgage, Loan, Capital Markets, Banking and Insurance.
• In - depth knowledge and a practical experience of using Waterfall, Agile, Scrum, Rational Unified Process, Business Process Reengineering, Unified Modeling Language, System Requirements Specification and Functional Requirements Specification, Rapid Application Development, and MS Visio.
• Worked with Analysts, Managers, Developers and Testers for complex projects during the SDLC.
• Conducted a Joint Application Development (JAD) session with stakeholders and business partners to resolve open issues.
• Highly skilled in transforming the needs of business users and stakeholders to the functional/technical requirements.
• Received awards for delivering cost effective, high performance technology solutions to meet challenging business demands and successfully completing the projects in Agile and a good understanding of stochastic calculus using Brownian motion.
• Good understanding of Mortgage Back Securities (CDO and CMO).
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• 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.
• Experience in designing and developing reports using Microsoft Reporting Services (MSRS), Crystal Reports, MS Access, and Data View web part
• Extensive knowledge in creation of Request for Proposals (RFP) for business development Software applications in JAVA, J2EE, SQL, Oracle PL/SQL within Services Oriented (SOA) business process.
• In-depth knowledge of Rational Unified Process (RUP); risk engineering; Data modeling and mapping; and design using UML, Rational Rose, and Visio.
• Knowledge of XML for analysis, review, and approval of proposed XML resources
• Strong experience in RUP Business modeling process.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Highly effective management and organizational skills with ability to prioritize.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.

TECHNICAL SKILLS:

Programming Languages: SQL, Transact SQL, PL/SQL, C, C++, COBOL, Visual Basic 6.0, HTML 4.0, XML, JAVA, .NET framework 3.0, C#,ASP.NET

Database Systems: SQL Server 2008/2005/2000, Oracle 10g/9i/8, DB2, and MS Access 2003/2000, Teradata

Modeling Tools: MS Visio, Rational Rose

Process Tools: Rational Rose Suite, RUP, MS Office Suite, MS Project, MS Visio, MS Share Point, SASV9.0., Version One, XML Spy, Pivot Tables, SSIS, Requisite Pro

Reporting Tools: Crystal Reports, Cognosv8.0., SSRS

Operating System: Windows NT 4.0/98/2000, XP, 2007, UNIX

Version Control System Tools: Harvest, Rational Clear Case

Testing Tools: Rational Enterprise Suite, QTP V9.5, Win Runner V9.2, Load Runner, HP Quality centre 10.0, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Business System Analyst

Responsibilities:

• Served as a liaison between the business team and the IT organization in order to provide analytical supports for system solutions to meet business needs.
• Worked with Subject matter experts to gather information for Business requirements.
• Involved in analyzing the System to understand the business process and rules.
• Interacted with Subject Matter Experts (SMEs) through JAD sessions to gather Business Requirements and converted to the Functional Requirements and Non Functional Specification Document.
• Assisted the database designer in data modeling through ER diagrams to identify tables, attributes and relationships between tables.
• Designed data mapping to define data transformation from source data model to target data model and ensure compliance with company standards.
• Facilitated and maintained requirements traceability from project vision through product delivery using HP Quality Center. Reviewed development and quality assurance artifacts for traceability purposes.
• Wrote SQL statements and SQL queries to retrieve and check Database contents.
• Conducted reviews with the SMEs to obtain sign off on requirements.
• Actively involved in walkthroughs and meetings with the development team to discuss project related issues.
• Work with Fiserv and testing tools to detect defects in the application.
• Participated in UAT, including results verification and release.
• Used Rational Clear Quest for defect tracking, participated in bug-review meetings with software developers, QA engineers, and managers, suggested enhancements to the existing application from Business perspectives, and provided solutions to existing bugs.
• Worked with Training & Development Specialists to develop and provide front line training prior to the Plan Rollout phase
• Design of SSIS and SSRS packages (Business Intelligence tools).
• Code SSIS and SSRS packages.
• Analyze test data to verify that testing accurately measures the system capabilities against the baseline requirements.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents.
• Write User acceptance testing documents for the mapping requirements.
• Validate the XML file based on the XSD and involved in preparing Test cases to meet client Requirements.
• Support QA resources in providing necessary details and to come up with critical testing scenarios. Also assisted in performing high level QA Activities and closing defects.
• Coordinated Systems Integration between various System testing Groups
• Report defects to the testing team and use Quality center to track the defects.

Environment: MS Office, MS Visio, HP Quality Center 9.2, SQL Server 2008, 8, Rational ROSE, SSIS packages, Requisite Pro.

Confidential, Mount Laurel, NJ

Business Analyst

Responsibilities:

• Gathered requirements from business users and analyzed them using Rational RequisitePro
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Documented functional specifications to automate the loan approval process for home Mortgage (online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review)
• Acquired in-depth knowledge of the banking industry (Mortgage, Assets, and Accounts Receivables/Accounts Payables etc)
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system
• Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design (OOD) using Rational Rose according to the UML methodology
• Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, Activity), using MS Visio
• Involved in testing all the data elements in Mortgage Account Inquiry Service, which is called to obtain Mortgage loan data from MSP
• Worked on mapping of MSP Web services to Enterprise Interface Partners and coordinated with FIS on MSP
• Sketched diagrams of proposed and existing systems using Visio
• Implemented the entire Agile Methodology of application development with its various workflows, artifacts, and activities
• Acted as a liaison between business users and system development team during development process
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro
• Supported IT & Risk Management in Business Continuity Planning for Item Processing department
• Developed and maintained the project plan using MS Project
• Conducted interviews with clients for the purpose of gathering product requirements and understanding the client workflow
• Created a RACI matrix based on the organization standards for ongoing operations and issue resolution procedures
• Gained thorough understanding of Cash Management, Liquidity Positions and Liquidity Ratios
• Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing
• Work on the Data Modeling, Entities and Attributes of the Data points and Templates. Building API in XML based on the requirements.
• Assisted QA lead in developing quality procedures and ensuring that appropriate documentation is in place
• Conducted User Acceptance Testing (UAT)
• Participated in developing of Training Materials for the new technology and User Training
• Worked effectively with Project Manager in handling the whole project

Environment: s: SDLC, Agile Methodology, Rational Clear Quest, UML, Oracle, MS Project and MS Office, Digital Docs, Filenet, MS Visio, Rational Requisite Pro, XML, MS office, Quality center, SharePoint, SQL 2008

Confidential, MT. Laurel, NJ

Business Systems Analyst

Responsibilities:

• Worked with the business Stakeholders and SME’s to define business requirements and analyze the functional requirements
• Responsible for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis with Document and Records Management
• Facilitated JAD sessions with management, users and other stakeholders to define the project and also to reduce the turn-around time of deliverables
• Prepared and presented Business Requirement Document (BRD) and Functional Requirement Document (FRD)
• Experience with end to end loan origination process, Basel and Dodd-Frank act
• Managed day-to-day project activities and coordinated tasks with other teams
• Defined requirements for all workflow activities including analysis, design, testing, and implementation for mortgage lending and loan origination systems.
• Worked closely with the UI team to model the screens for android, iPad and iPhone applications.
• Worked with Brand Management team on developing content and UI for Mobile Application
• Lead research project “Banking with social media and smart phone technology”.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements
• Reviewed prototypes, solution blueprints, and project scope to ensure that the needs of the business are being met
• Used Waterfall, Agile (SCRUM) & combination of the two Methodology on the projects
• Translated the requirements to the IT and web production teams to facilitate their HTML builds for the projects
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams using Rational Rose following the UML methodology
• Created Screen mock ups/prototype/wireframes to illustrate new requirements and alignment around project scope using MS Visio
• Involved in identifying and documenting the process of implementing MISMO standard as a Web service to our current clients which included three steps: creating the XML data set according to the standard definition, Organizing the XML data set so that it will be created or consumed consistently and then writing WSDL, Web services description language.
• Responsible for managing the documented System Requirements and Requirements Traceability Matrix using Rational Requisite Pro
• Responsibilities also included Quality Assurance Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing
• Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test
• Provided support for User Acceptance Testing with UAT cases and resolved issues with the users

Environment: MS Visio, Share point, SQL, UML, Waterfall, Test Director, MS Paint, HP Quality Centre, MS Word, MS Power point, Wire frames

Confidenti, Pittsburgh, PA

Business Systems Analyst

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities
• Responsible for the quality of all changes to Empower, the mortgage loan origination system for the Retail branches.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Followed solely RUP methodologies during the course of the project.
• 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, Use Cases, UML diagrams for overall system.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Using UNIX console commands to check database has been connected the other functionalities.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Helped with Data Mapping between the data mart and the Source Systems.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Managed Scope and change throughout the SDLC process of the product.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Suggested measures and recommendations to improve the current application performance.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, DOORS, Sybase, MS Office, Teradata, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro