PROFESSIONAL SUMMARY:

• With 7+ years of Industry experience as a Sr. Business Systems Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Data Mapping, Translating Requirements into Specifications, Application Design.
• Good Knowledge of various financial products like Stocks, Bonds, Mortgage Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Extensive experience in all aspects of consumer and real estate loan origination, underwriting and collections. and some experience in commercial lending, including financial statement and cash flow analysis.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Experience in TIBCO, Oracle and Microsoft SQL technologies such as Business works, Rendezvous, EMS, Hawk, Administrator and Adapters.
• Modifying existing reporting procedures to eliminate dependence on current Client Server Empower systems thus making reporting error free and accurate. It involved migrating existing processes from Client Server Empower systems to Empower.net systems.
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Strong knowledge on the Systems Development Life Cycle (SDLC), Rational Unified Process Methodology (RUP), RAD, SWOT, and CRM.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Software/Hardware: ERWIN, ETL: Ascential Data Stage (7.x, 6.x, 5.x), Star - Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4.0, Business Objects, Micro strategy, SAS, Macros, Erwin 4.x, C/C++, Java SE 1.4, TURBO PASCAL 7.0, VB.Net, HTML, COBOL, SQL Server, SOA, SAP SD, My SQL, Agile/Scrum, Oracle, PL/SQL, Visio, Sybase ASA (6 - 9).ASP/ASP.net, PHP, Microprocessors 8085 & 8086, Unix, MVS, MS Windows/95/98/NT/2000/XP, MS DOS, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Business Systems Analyst

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

Responsibilities:

• Participated as Senior BA on newloanoriginationsystem project, defining requirements, testing and facilitating meetings withSeniors Managers, vendors and subject matter experts.
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management and responsible for preparing bank deposits, which requires checking for accuracy and reconciling any errors.
• Hands-on expertise spanning across System Analysis, Software validation, Financial Data Analysis, Data Modeling, Business Function specifications, Flow diagrams and GAP analysis.
• Developed business process flows, Use Cases, and other documentation for expansion of Client’s MBS loan servicing, securitization, and trading model while coordinated with Development Team in translating business requirements into design specifications for expansion of loan securitization business.
• Followed a comprehensive set of MISMO standards and data points for all stages of the mortgage loan life cycle which supported Underwriting, Mortgage insurance application, Credit reporting, Loan delivery, Product and pricing, Loan Servicing and Secondary mortgage market investor reporting.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas of Bank. Primary duties included analyzing existing Client Server Empower platform and work towards making it better and robust. introduced project management best practices, established formal project planning, requirements gathering and scoping processes, and supported legacy Marketing applications across many platforms.
• Coordinated sales among legal, servicing, accounting, closing and originations departments.
• Executed fixed-income and equity trades for select clients-primarily municipal and corporate bonds, and mortgage-backed securities (MBS).
• Gathered closing figures, input closing information and generated loan documentation format.
• Assist in Preparation of Title and Closing Documents format.
• Used MS Sharepoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Provide insight, guidance, and reporting on default mortgage options to optimize operational revenue.
• Prepared Demo on SharePoint for various Business to get new approvals like the Therapist and Nursing divisions.
• Designed and developed complex (MS-Access) three-tiered production Audit Management application, utilizing VBA code driven security, real-time production SQL manipulation, and complex summary & detail reporting.
• Elicited, documented, verified, and validated all Pega Modification Portal letter requirements.
• Created standards / guidelines for business process modeling, File Transfer Document, Interface Specification Requirement Specification document, RRT, BRD, FRS and Report Requirement Specification.
• 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.
• Monitor the set up of loan closing to ensure compliance with all State and Federal regulations
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Used Rational DOORS for overall Requirements Management and to build the Requirements Traceability Matrix.
• Responsible to re-engineer the Loan IQ reporting solutions (Data Net) to a more reportable solution with enhanced performance and flexibility to 3rd party software integrations.
• Analyzed financial statements to identify trends and anomalies in financial data.
• Used XML, XSL and XSLT for developing a dynamic and flexible system for handling data.
• Worked closely with Business Users to enable business processes usingSFDC.
• Successfully lead projects through project lifecycle - initiation, planning, executing, monitor/control andclosing.
• Involved in building a data model which integrates Loan IQ Application to centralized Data Warehouse.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Designing the templates for the technical packages, POS and approval documents.
• Worked on a project which was to provide a web browser based reporting application for instruments such as Mortgage-Backed Securities (MBS).
• 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.
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Facilitated analysis and design sessions with business owners, middleware analyst, interfacing system analyst, application architects, and user experience analyst to finalize the user stories and to create the system design for the SOA environment
• Preparing for conducted User Acceptance Testing (UAT) before Empower.net can be released.
• Involved in testing the conversion of the application into web application using XML web services.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Developed SQL queries and created data mapping documents to validate ETL process, perform database testing and data validation testing, and generate ad-hoc client reports.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Uploaded documents produced onto SharePoint, an intranet website for all Technology Information Group members to download, revise and upload shared documents. Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and end users Change Request for enhancement and scope items are maintained and tracked using Rational ClearQuest.
• 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.

Confidential, Lakewood, CO

Business Systems Analyst

Environment: Windows XP, Oracle/SQL Server 2000, SQL, MWS, MS office, MS PowerPoint, DOORS, XML SPY, Rational Rose, Agile/Scrum, Rational Requisite Pro, OOAD, .Net, Test Director, Clear Case, UML, Rational Suite, MS Visio, MS

Responsibilities:

• Worked with the business users and with different levels of management to identify requirements, Use cases and to develop functional specifications.
• Interface with the Wholesale Commercial Loan and Mortgage user group to address issues.
• XML is used extensively to communicate with web service component and to populate data at the client side.
• Generated XML documents using the XML Output Stage.
• 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.
• Researched errors returned by MWS (Middleware Services).
• Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
• Designed and implemented a variety of applications to increase the efficiency and effectiveness of systems functionality and reporting capabilities on the Bank's Loan IQ, system. (Loan IQ, is a vendor-provided software widely used by financial institutions to track loan related data).
• Defined web service interfaces using WSDL and XML schemas
• Used Rational DOORS for overall Requirements Management and to build the Requirements Traceability Matrix.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Clear understanding of mortgage servicing industry rules and well versed in default mortgage workouts and regulations for all workout types.
• Helped document the rational and requirements behind the XML architecture that encompasses data origination and servicing data for implementing MISMO standards.
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Participated in Data Analysis and Design and data mining with the Data analyst in defining data sources and required data content for the data warehouse component.
• 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.
• Work with Microsoft SharePoint and Enterprise bank tools to record and track data warehouse project cost estimates and respond to technical questions from project team.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Involved in extracting customer information data, and converted data types and integrated data from multiple sources to target destinations by creating routings using TIBCO EMS and generated various XML schemas as per the mapping involved in the process flows from the integration perspective.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Scrum Master of development team using jQuery, Ruby on Rails and MySQL.
• Assisted in the automation of the mortgage portal with the Loan IQ system for the conditional approval.
• Authored various Use cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose.
• Developed SQL queries and created data mapping documents to validate ETL process, perform database testing and data validation testing, and generate ad-hoc client reports
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• 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
• 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.
• Logged bugs found during UAT using IBM ClearQuest. Tracked these bugs and made sure they were resolved and closed before the release.
• 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.
• Worked with command personnel to reserve data center floor space, appropriate power supplies and additional backup media to support the new equipment.
• Experience in mortgage processing, third party mortgage lending and escrow payments.
• Interacting with the developers to report and correct bugs.
• Prepared detailed reports of the Bugs, Pass-Fail report, Comparison Chart.

Confidential, Phoenix, AZ

Business Systems Analyst

Environment: Microsoft Office Suite, MS Visio, MS PowerPoint, DOORS, Documentum, Windows NT/XP, Oracle, PL/SQL, SQL Server, Sybase, SharePoint, Unix, Agile/Scrum, C#. NET

Responsibilities:

• Participated as BA on newloanoriginationsystem project, defining requirements, testing and facilitating meetings withSeniors Managers, vendors and subject matter experts.
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Hands-on expertise spanning across System Analysis, Software validation, Financial Data Analysis, Data Modeling, Business Function specifications, Flow diagrams and GAP analysis. introduced project management best practices, established formal project planning, requirements gathering and scoping processes, and supported legacy Marketing applications across many platforms.
• Coordinated sales among legal, servicing, accounting, closing and originations departments.
• Executed fixed-income and equity trades for select clients-primarily municipal and corporate bonds, and mortgage-backed securities (MBS).
• Gathered closing figures, input closing information and generated loan documentation format.
• Assist in Preparation of Title and Closing Documents format.
• Used MS Sharepoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Provide insight, guidance, and reporting on default mortgage options to optimize operational revenue.
• Prepared Demo on SharePoint for various Business to get new approvals like the Therapist and Nursing divisions.
• Elicited, documented, verified, and validated all Pega Modification Portal letter requirements.
• Created standards / guidelines for business process modeling, File Transfer Document, Interface Specification Requirement Specification document, RRT, BRD, FRS and Report Requirement Specification.
• Monitor the set up of loan closing to ensure compliance with all State and Federal regulations
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Supported User Acceptance testing (UAT) and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge.
• Used Rational DOORS for overall Requirements Management and to build the Requirements Traceability Matrix.
• Responsible to re-engineer the Loan IQ reporting solutions (Data Net) to a more reportable solution with enhanced performance and flexibility to 3rd party software integrations.
• Analyzed financial statements to identify trends and anomalies in financial data.
• Assess current data and data sources by performing data extractions using, Access, Excel, SQL and Microsoft Query to perform gap analysis.
• Used XML, XSL and XSLT for developing a dynamic and flexible system for handling data.
• Focused on .Net development of applications integrating Oracle and SQL server databases.
• Worked closely with Business Users to enable business processes usingSFDC.
• Successfully lead projects through project lifecycle - initiation, planning, executing, monitor/control andclosing.
• Involved in building a data model which integrates Loan IQ Application to centralized Data Warehouse.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Designing the templates for the technical packages, POS and approval documents.
• Worked on a project which was to provide a web browser based reporting application for instruments such as Mortgage-Backed Securities (MBS).
• 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.
• Successfully providing the designs for the project team with Activity flow Diagrams, User Stories, Storyboards, User Stories and Test Plans
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Involved in testing the conversion of the application into web application using XML web services.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• 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.
• Prepared system Test Plan and scenarios for Test Scripts.

Confidential, San Antonio, TX

Business Analyst

Environment: Rational Clear Case, Doors, XML, Java, J2EE, JSP, RUP, Oracle, MS Visio, MS PowerPoint, MS Office, Agile, SQL Server Reports, PL/SQL, Win Runner

Responsibilities:

• 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.
• 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).
• Used Rational Rose to designed and develop Use cases Scenarios, Use cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML.
• Assisted in determining needed resources and establishing overall project plans, prepared project outline.
• 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.
• Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Elicited requirements for Agile projects by documenting User stories, Product Backlog's and Acceptance Criteria.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Creation of the data mart from existing Operational data Store and other sources.
• Produced requirements and specifications to develop business software applications and streamlined processes for handling default mortgage and foreclosure transactions that considerably shortened case processing time.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• 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.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Worked on data modelling and produced data mapping and data definition documentation
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Confidential, New York, NY

Business Analyst

Environment: MS Office Suite, MS Project, MS Visio, HTML, SQL/PLSQL, Windows XP / 2000, Java

Responsibilities:

• 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 DW 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.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio. Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modelling.
• Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
• Aimed at significantly improving the efficiency and effectiveness of the firm's global credit risk, interpretation, definition and implementation of Basel II requirements, and amplifying exposure management activities.
• 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), material, BI reports using Microstrategy
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, Metadata, Data Profiling.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• 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.
• Used CSS, HTML and Javascript for GUI front end designing and validations.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO.
• Consolidated the analysis of multiple business lines after the COTS evaluation.
• 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 customer’s 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.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.