PROFESSIONAL SUMMARY:

• Over 7+ years of diverse experience working with various domains which includes Banking, Mortgage, Financial and Insurance
• Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, design, development, testing and deployment.
• Competent in analyzing the current business process and creating future state business process flows using industry standard BPM notations
• Exceptional working experience in GAP analysis and understanding of the AS - IS and TO-BE business processes
• Expertise in conducting Stakeholder Analysis to define process stakeholders, and their roles & responsibilities towards the project.
• Adept with different software development methods like Water Fall, Rapid Application Development (RAD), Rational Unified Process (RUP) and Agile (SCRUM) Method
• Proficient in analyzing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio
• In-depth working experience implementing various elicitation techniques like, Document analysis, Interface analysis, Prototyping, Reverse engineering, Brainstorming, Requirement workshop.
• Excellent skills in facilitating Joint Application Development (JAD) for eliciting functional requirements that support the High Level business requirements
• Knowledge in Data Modeling and Process Modeling using a structured approach using MS Visio, Enterprise Architect.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), High Level Design Document (HLD), Requirement Traceability Matrix (RTM) and testing documents.
• Extensive experience in gathering business and application requirements, business processes, identifying risks, impact analysis, UML modeling, sequence and activity diagrams using Rational Rose and Microsoft Visio.
• Proficient in writing and executing simple SQL queries against the database to check for the ER relations with the requirements document
• Expertise in assisting the Testing Team in creating and reviewing the Test Plans and Test Cases
• Efficient in prioritizing and managing the defects using the Defect Tracking system like JIRA, Quality Centre and Bugzilla
• Expert in writing detail system use cases, developing business test cases, and working with QA teams during testing phase thereby facilitating acceptance testing with stakeholders and business users
• Experience in giving presentation on the completed modules of the project and also to provided status update to the stake holders
• Working knowledge of Change management and Release management
• Outstanding written and verbal skills with explicit attention to detail during requirements elicitation.
• Involved in of end users, documented Manuals for the new product release
• Excellent Interpersonal, and Analytical skills, with ability to handle challenges under pressure with ease.

TECHNICAL SKILLS:

Requirement and Document Tools: Rational Requisite Pro, Rational Clear-Quest, DOORS

Business Modeling Tools: Rational Rose, Enterprise Architect, Visual Paradigm, Microsoft Visio

Databases: Oracle, DB2, UDB, SQL SERVER, MS ACCESS, Oracle Siebel

Methodologies: Agile, Waterfall, JAD UML, RUP, BPMN

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Confidential

Sr. Business Analyst

Responsibilities:

• Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, Mortgage consultants, brokers, stakeholders and subject matter experts
• Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements
• Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications
• Communicated with Line of Business and created Business Requirements Document (BRD), High Level Design Documents (HLD), and part of Low Level Design Documents (LLD)
• Conducted and participated in JRP/JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS) analyzed the feasibility of their needs by coordinating with the project manager and technical lead
• Identified and documented risks and their impacts and provided recommendations to mitigate the risk.
• Worked in Agile environment playing an active role in Iteration planning, Sprint Review, Lesson Learned and resolving roadblocks
• Documented and tracked all product defects with use of SQL (reporting).
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
• Writing Complex SQL queries and optimizing SQL Queries
• Developed process diagrams to elaborate on the flow of information between Web forms, Credit check system, Loan Origination System and Client application database
• Helped conduct business risk analysis to identify the qualifying standards for Mortgage applicants and ensure effective risk mitigation strategies
• Communicated risks to Legal and Compliance department
• Reviewed and logged help desk tickets and determined avenues for improvements and enhancements
• Helped develop Estimates of the proposed enhancements to system understanding and helped determine ROI
• Coordinated multiple projects modules assigned to multiple teams in an Agile environment constantly tracking and configuring different versions, variants and managing changes to the software
• Used ClearCase to keep different versions of the documents and ClearQuest to report bugs or defect
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing (UAT) to improve overall quality of the Application.

Environment: RUP (Loan Origination), Agile (Enhancement), Rational Requisite Pro, SQL, Rational Rose, UML, MS Visio, Oracle, Mercury Quality Center

Confidential, BIRMINGHAM, AL

Business Analyst

Responsibilities:

• Gathered analyzed, documentedbusinessand technical requirements from both formal and informal sessions and validate the needs of thebusiness stakeholders.
• Conducted user interviews and documentedbusinessand functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• A series of meetings / JAD sessions were conducted to gather requirements from business system users for reporting purposes.
• Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
• Facilitated four extensively used Star Schema methodology in building the design of the logical data model into the Dimensional data modeling.
• Modeled AS IS and TO BE processes using MS Visio for the Mortgage origination system.
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Identify and document, business functions, activities and processes, data attribute and table meta-data, and general and detail design specifications.
• Created walkthroughs and validations on logical model and created physical data model using forward engineering.
• Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
• Wrote SQL queries to retrieve data from databases after data migration.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Focused on development of integrated data environment with minimal Data Redundancy.
• Design, plan and program data conversion procedures from old to new databases.
• Worked with Business Analyst to create hierarchies and design reports using OBIEE (Oracle Business Intelligence Enterprise Edition).
• Coordinated bug fixing activities related to issues raised during end - User Acceptance Testing (UAT).

Environment: Informatica Power Center, OBIEE, Oracle, SQL, MS SQL Server, UML, Microsoft Visio and Erwin.

Confidential

Systems Analyst

Responsibilities:

• Assist the BA team in presentations to top management on e-commerce business solutions for inclusion in overall business plan
• Carried out queries from customer data base using SQL, data mapping, field mapping, data integration and sorted extracts as per insurance application status, age, gender, time services, demographics, lead aggregator sources, agent IDs, and call-center division to help design an effective, efficient and theme oriented online quoting engine.
• Understand and articulate business requirements thru user interviews, JAD Sessions and convert them into Technical Specifications. Conducted joint requirements planning sessions as a facilitator to gather requirements from the business area.
• Create Use Cases for requirement documentation and deployment.
• Analyze and integrate processing with database systems for Underwriting, Actuary, Insurance Agents and Customer Service deploying Web Services and Service Oriented Architecture
• Consult with consultants/project managers to streamline the lead aggregation and lead delegation process to boost firms’ conversion rate
• Facilitate JAD Sessions with the system architects, developers, database developers, QA team thru SDLC for defects’ resolution
• Coordinate with the Release Manager in defining scope/ planning releases.
• Analyze Business Requirements and create Use Cases, high and low level Activity/ Sequence/ State Chart Diagrams
• Collaborate with the User Experience / UI Development team to in designing applications for effective and efficient production of front end data-intake interfaces (User Interfaces), Customer Profiling, Lead Generation Reports, Conversion Rate Reports, for Executive Committee, and Board Meetings, to forecast quarterly analysis.
• Participate in meetings with Developers, PMs and QAs to discuss BRs, test planning, resource utilization, and defect tracking
• Work closely with the UI team to model the screens, as per BRD’s usability requirements
• Coordinate model office cycle runs in different test regions before implementing them into the live production environment.
• Facilitate test review sessions on a weekly basis and delegate them, as needed.
• Create Use cases, activity reports, logical components to extract business process/ work flows involved in the project
• Develop user manuals, presentations and manuals as per project specifications and timelines.

Environment: Web Sphere Business Modeler, Quality Center, UML, MS Project, J2EE, EJB, JSP, Servlets, HTML, SQL, Data warehousing, Web sphere,.Net Technologies, Cobol.

Confidential

Business Analyst

Responsibilities:

• Responsible for Gathering Requirements from the Quantitative Analysts, Portfolio Managers and Technical Team to produce Business and Functional Requirements for a Risk Management Application from Data Warehouse.
• Prepared (BRDs) to document all existing Files and Data elements to be converted from source system to Target Pre-staging.
• Prepared ‘Statement of Work’ documents based on defects or change request documents submitted by the production support/QA team during UA testing.
• Prepared Business Requirement Design Specification and determined in scope and out of scope aspects of the process.
• Served as liaison between IT and business users including Accounting and Claims on reporting requirements and system information.
• Performed GAP Analysis, conducted walkthroughs and acted as a liaison between the business users, stakeholders and the team to perform the requirements, quality and risk analysis
• Conducted JAD sessions, analyzed and documented the business requirements from various teams and stakeholders.
• Identified the limitations users currently experience in the operational reports obtained from current systems and recommended solutions to overcome these limitations.
• Suggested measures and fine-tune queries to improve the performance of each Interface and the quality of the output files.
• Used daily contribution and payroll reports to create and update expanded schedules for each employer to be used in Trustee reporting and arbitration procedures.
• Communicated with the accounting personnel to ensure that contract reporting and payment requirements are met.
• Performed complex analysis of accounts receivable, contributions received, and payroll data; determine accuracy, identify exceptions, trends, and estimate future contributions; maintain Delinquency Report
• Coordinated the activities of subordinates in the Interface Team and organize weekly status Meetings.
• Performed financial research and analysis as necessary and respond to data requests and additional projects and responsibilities as assigned.
• Crystal Reports was used to generate reports from different databases of different asset classes like equities, bonds, derivatives, and commodities, for all business needs.
• Environment: MS Visio, Rational Requisite Pro, Rational Rose, SQL, UML, Rational Unified Process, FIX, Crystal Reports, MS Office