SUMMARY

Close to 7 years of experience as a Business Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.

Experience in analysis in Financial Services and Mortgage industry.

Acute understanding of concepts related to Student Lending, Consumer/Business Credit Cards and Consumer loans.

Extensive experience in General Ledger, A/P, A/R, Primary Mortgage and data migration applications.

Excellent Business writing skills in writing Business requirements document, Functional Specifications, Systems Design Specification, Systems RequirementsSpecification.

In - depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirements gathering, Analysis/Design, Development and Testing.

Knowledge of Primary and secondary Mortgage markets

Experience with Data Analysis using Oracle as a backend and TOAD as the querying interface.

Highly proficient in interacting with business users and authoring Use Cases, Use Case diagrams, Sequence diagrams, Activity Diagrams, Collaboration diagram, Class diagram, State-chart diagram, Component diagram, based on UML methodology using CASE tools like MS Visio and Rational Rose.

Experience in performing Workflow Analysis.

Full understanding of RAD, Waterfall, Spiral Methodologies Rational Unified Process.

Experience in Test Director, Rational Requisite Pro and Agile Methodology.

Used Rational Clear Quest for tracking and prioritizing defects and for enhancements after base lining the requirements.

Used Rational Clear Case for Version Control of all the requirement documents.

Experienced in conducting JAD sessions, project meetings, reviews and walkthroughs.

Experienced in performing Gap analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.

Experience in conducting User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis, Risk Analysis and ROI analysis.

Interacted regularly with the development team, database designer and the higher management to meet the deadlines of Project milestones.

Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.

Technical Skills

Requirements Management Tools: Rational Requisite Pro, Test Director, HP Quality Center

Business Modeling Tools: Rational Rose, MS-Visio.

Change Management and Version Control Tools: Rational Clear Quest, Rational Clear Case.

Environments: C, C++, Java, .NET, J2EE

Data Bases: Microsoft Access, Oracle 8i/9i/10g, MS SQL Server

Operating Systems: Windows NT, Windows 2000, Windows XP, Windows 2007, Unix

Software Utilized: Microsoft Office Suite 2007 (Word, Excel, PowerPoint and Outlook), Microsoft Project.

Query Tools: TOAD, SQL Navigator, Rapid SQL, Teradata SQL Assistant

Work Experience:

Confidential, Chicago, IL

Business Analyst

Description: A key concept of this initiative is to drive vendor specific information across three external vendors who service Student Loans on behalf of Confidential . For comparative analytics purposes, however, the Basel II data elements needed to be consistent across all vendors. The decision was reached by the Basel team to “normalize” data elements that were “inconsistent” among the vendors due to their very different operating models and consistent definitions and values when that data was used within the Basel models. The normalized data understanding and buy-in from the Student Lending Line of Business is key to maintaining proper governance to ensure data integrity on behalf of both Basel and the Line of Business (LOB). The Basel II defined data elements will be stored in ECRIS-Retail data warehouse (Enterprise Credit Risk) will also be used in other LOB and Regulatory reporting and analytics. These Basel data elements will also be used in the Retail Credit Risk Model and will drive the capital allocations for the portfolio.

Responsibilities:

Attended the knowledge acquisition sessions presented by Subject Matter Experts (SMEs) for the purpose of better understanding Student Lending process.

Involved in the complete SDLC and handled key responsibilities in Project Management.

Analyzed and reviewed business requirement documents (BRDs) for full understanding of the business and gain basic knowledge of the Basel II Accord.

Analyzed external file information and worked closely with external vendors for the purpose of gathering Basel related business requirements.

Lead weekly conference calls with the vendors to address any issues/timelines/concerns.

Documented system scope and objectives in form of High Level Design documents (HLD) and Small Project Documents (SPDs).

Involved in creating Low Level Design documents (LLD), Test plan and Test cases based on requirements identified.

Directed the testing team to execute the designed test scenarios via multiple stages of testing (Unit testing, System Integration Testing (SIT), and User Acceptance Testing (UAT).

Successfully met the defined milestones and deadlines.

Confidential, Chicago, IL

Business Analyst

Description: This Project addressed closing gaps in data availability as defined in the latest versions of the US IRB Retail Guidance and Notice of Public Rulemaking (NPR), for all Retail exposures as it relates Eligible and Ineligible Retail Guarantee attributes needed for account-level portfolio segmentation, factor analysis, and reporting. The purpose was to recognize the risk-mitigating effects of eligible (and possibly ineligible) guarantees. Confidential must be compliant with the Basel II definition of guarantees and their use in creating the risk factors as provided in the Accord, NPR, and Retail Guidance. Historically, Retail credit risk systems had little to no tracking of this aspect of loan data. Remediation of the gaps required business policy and/or process changes to obtain the data. It also required sourcing of Basel Retail historical data requirements specified in the Retail Guidance to source 5 to 7 years worth of history.

Responsibilities:

Reviewed Basel Guarantor Business Requirements Documents to get better understanding of Guarantors in the financial industry.

Understand Basel specified rules regarding their definition of eligible vs. ineligible guarantees and their usage in risk factor analysis.

Extensively involved in discussions with Line of Business to get a thorough understanding of different Guarantee types (PMI, FHA/VA, BPP, and CR-LIFE).

Involved in defining the list of legacy Confidential systems in scope of project.

Created Small Project Document documenting technical and functional specifications.

Involved extensively in finalizing the technical specifications of Basel related guarantor views and control tables.

Presented and reviewed documents to Business users for their sign off.

Attended weekly Project meetings for weekly evaluation of Project status.

Acted as a liaison between Business users and IT development team on communicating business requirements.

Worked closely with testing team in defining Test plan, Test cases and Test scripts.

Extensively involved in different testing phases (Unit testing, Systems Integration Testing and User Acceptance Testing).

Confidential, Chicago, IL

Business Analyst

Description: Confidential is expected to collect and maintain sufficient data to support Advanced - Internal Rating Based (A-IRB) systems. Purpose of the project was to ensure that the outsourced activities performed by external servicers, called LSBOs (Loans Serviced by others), are supported by sufficient data to meet IRB requirements. Confidential worked with different servicers (servicing mortgage and consumer loans as well as servicing credit cards) for the bank to source and captures all essential data elements required to calculate credit risks and exposure over the life of the loan.

Responsibilities:

Gathered new Basel requirements from business matter experts and communicated the same to external vendors.

Gained extensive knowledge on Confidential ’s different servicing systems used for capturing and processing mortgage data (2nd Mortgages, HELOC/HELOANS).

Performed data profiling and data mapping to map various source data systems to the new Basel database.

Documented and maintained requirements traceability matrix to ensure all requirements are traceable from top to bottom.

Worked closely with Technical Analysts and developers to identify any bottleneck and work together to resolve issues.

Involved in documenting technical specifications, data flow diagrams, gap analysis and data mapping documentation.

Performed Data Analysis and Data Validation by writing complex SQL queries using Teradata SQL Assistant.

Utilized Quality Center to record, track, update or close any defects related to business requirements or data quality.

Assisted Test team in drafting test strategies and test plans to verify accurately any functionality issues and successful system integration.

Confidential, Chicago, IL

Business Analyst

Description: The project was to provide LaSalle commercial and consumer account level and customer month end snapshot from January 2002 until the LaSalle systems of records are converted to Confidential ’s target system of records. The key objective was to ensure Legacy LaSalle historical credit exposure is made available in order to meet Basel II Risk Infrastructure related requirements. LaSalle was expected to deliver account level customer data, both historically and go-forward, related to:

Loan Servicing Data

Collateral Data

Guarantee/Guarantor Data

Charge off and Recovery Data

Application Data

Responsibilities:

Analyzed Project Folders and the documents for full understanding of the business and gain basic knowledge of various applications/systems internal and external to the Confidential and LaSalle.

Attended meetings with Subject Matter Experts from different Line of Business since post-merger activities were being learned by both the companies.

Worked closely with Regulatory team to better understand Basel II Accord standards and framework required to promote stronger risk management practices.

Acted as a liaison between Confidential and LaSalle team members making sure the requirements and project objectives are communicated clearly across the board.

Documented Business Requirements Document, Technical Specifications Documents, and data mapping documents.

Coordinate and lead meetings with impacted parties on both sides ( Confidential and LaSalle) to track progress of the project and resolve any issues.

Involved in documenting scope and objectives of end to end testing, integration testing and project implementation.

Used Ms Excel extensively for documenting detail status and keep track of file transmissions from LaSalle network to Confidential .

Environment: s: Microsoft Office 2007, Teradata SQL Assistant 12.0.9, HP Quality Center 9.2, Mainframe systems

Confidential, St Louis, MO

Business Analyst/Build Manager

Responsibilities:

Primary role was to work as a coordinator between the Onshore AGE team and offshore development team.

Responsible for supporting the delivery of deliverables associated with Views and IXUNLOADS required for Extracts and DBARS.

Work closely with SMEs and Data Analysts for finalizing the requirements before sending them offshore to the development team.

Make sure that the Views match with the requirements of consuming applications using ETL tool, Data stage, for creating Extracts.

Resolve all the queries raised by the offshore team while undergoing the build process.

Review deliverables along with the SMEs and Data Analysts and get sign off.

Keep track of delivery schedule making sure all the deadlines are being met.

Use TOAD to write SQL queries and review view code delivered by the offshore development team.

Make sure that the deliverables match the required standards.

Work closely with the FTP team on the availability of the application files.

Compare the view output files with the bull files on the shared server, transferred through FTP.

Assist in performing Unit Testing by performing file comparisons between the view output file and the legacy file.

Discuss the differences with the SMEs and work on resolving them.

Assist in data mapping and writing transformation rules.

Worked with Clear Case for managing deliverables and documents.

Used Clear Quest for logging and managing Issues, Defects and Work Assignments.

Also performed activities of a Release Manager by keeping track of all the deployments of views.

Work closely with the Project Manager in resource management.

Environment: s: Rational Tools, TOAD, Advance Query Tool, Microsoft Visio, UNIX, Mainframe system.

Confidential, Raleigh, NC

Sr. Business Analyst

ABN AMRO Mortgage is part of ABN AMRO Mortgage Group, Inc., one of the nation's leading home lenders. They specialize in providing online access to all aspects of mortgage lending, from origination to closing, servicing, selling the loan in the secondary market (Mortgage Backed Security) and providing customers the unique advantage of staying with the same company throughout the life of the loan. The LAP (Loan Application Process) project I worked on involved modules for Pre-Approval of Loan, Processing, Quick App, Credit review module, Underwriting and closing module.

Responsibilities:

Interacted with business heads to define and finalize the Business Requirements for the application using Agile Methodology.

Provided inputs in the strategic development of detailed project plans, work assignments, and target dates.

Wrote functional and technical specifications and communicated requirements to development teams.

Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business users.

Successfully conducted JAD sessions to gain important input from various stakeholders.

Sought continuous improvement and aimed to achieve the results which would in turn provide tremendous flexibility and organization of data and at the same time impact the bottom line by cost-cutting.

Performed process mapping showing input and output to the various modules using MS Visio.

Developed Use Case diagrams, business flow diagrams, Activity, State and Sequence diagrams so that developers and other stakeholders can understand the business process.

Created liaisons between development and database administrators in order to identify and resolve database issues.

Ensure all applications are tested for functionality and are adequately controlled in production.

Used Toad to write SQL queries against the database for data validation processes.

Utilized Extreme Programming for software development and implementation.

Performed analysis on enterprise data and report integration.

Involved in compatibility testing.

Environment: s: Java, J2EE, JSP, Oracle Financials, Extreme Programming, Microsoft Office 2003, TOAD

Confidential, Des Moines, IA

Business Analyst

Confidential is a diversified financial services company, providing banking, insurance, investments mortgage and consumer finance across North America and elsewhere internationally. I worked on Confidential ’s Financial Subsystem including modules such as Requisition module, Accounts Payable, Accounts Receivables, Invoice and Payment module. I also worked on consolidation of the GL Accounts as well as various report validation and analysis for the accounting sub-system.

Responsibilities:

Interacted with client groups to determine user requirements and goals.

Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and created a Business requirement Document.

Analyzed business requirements and segregated them into high level and low level Use Cases and designed Activity and Sequence diagrams using Rational Rose.

Derived Functional Specifications document based on the User Requirement Specification.

Used Rational Requisite Pro for requirements management and to follow configuration management processes.

Documented Requirement Traceability Matrix in Requisite Pro for traceability of requirements through test cases.

Extensively used Rapid SQL to write validation queries and to work on data analysis.

Involved in walkthroughs and meetings with development team to discuss related issues.

Used MS Visio to visually determine the proper structure, key elements and optimal design for the database and to aid efficient creation of tables.

Created Entity Relation diagrams to represent the relationships existing between designing the internal schema of a database and the relationships between the tables.

Aided management in standardizing web applications by preparing GUI standards and recommending alternatives for in corporation in a phased, iterative manner.

Assisted in performing Smoke Testing to ensure that the compiled software components of the application adhere to Project Standards, Performance Criteria and Functional specifications to ensure feasibility of testing effort.

Conducted highly interactive JAD sessions with projects stakeholders such as users, QA analysts, and project management team, identifying and resolving issues.

Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing.

Frequently updated the requirement and defect status as per the current status of the project in Rational Clear Quest.

Used Rational Clear Case as Version Control System for any changes to common documents related to project.

MS Project was used to manage the project and deliver it on time as planned.

Environment: s: HYPERLINK blank" ASP.NET, Oracle, MS Visio, Rational Clear Case, Rational Req Pro, Rational Clear Quest, Rapid SQL, Microsoft Project