SUMMARY

• Experienced in planning, managing and controlling resources to achieve specific application workflow.
• Worked in different domains such as Finance including Mortgage, Retail Banking, Commercial Banking, Bill pay application and infrastructure projects.
• Good knowledge of the SDLC process and methodologies such as Agile and Waterfall.
• Extensively used Agile Scrum methodology and its process to manage projects.
• Competent in extracting, documenting, organizing and tracking the requirements.
• Proficiency in conducting Joint Application Development (JAD), Joint Application Review (JAR) sessions to develop and agree upon a system focusing on business requirements.
• Adept with scripting Business Requirement Documents (BRDs), Functional Specifications Documents (FSDs).
• Worked on Gap analysis
• Familiar with working autonomously and in a team environment building & preserving strong relationships with senior and junior business sponsors, as well as technical specialists adhering to a delivery focused approach while managing business expectations.
• Facilitated User Acceptance Testing (UAT) with the business users.
• Adept in Requirements Engineering describing them in Hierarchical Task Analysis, Task Descriptions, Data Flow models & Data Diagrams (Class Diagrams).
• Strong Analytical and Problem solving skills, excellent planning and multi - tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises make critical decisions.
• Wrote extensive SQL queries during UAT and data validation such as joins, development of store procedures, views, temporary tables (including CTE).
• Proficient in the use of Excel such pivot table and V-lookup.
• Experienced in ETL (SSIS) and data validation processes and proficient in reporting services such as SSRS as well as SSAS.
• Excellent communication and presentation skills
• Good documentation and Process management skills with an ability to effectively understand the business requirement to develop a quality product
• Good judgment skill to access high risk areas on which to focus testing efforts and analyze business processes to suggest improvement.

TECHNICAL SKILLS

Methodologies & Tools: Business Objects, TFS, UML, Use Cases, SDLC, MS Visio, HP Quality Center, MS Word, MS Excel, MS Powerpoint, MS Access

Industry Knowledge: Detailed understanding of various securities - Equity, Fixed Income, Derivatives, Securities Trade Processing, Payments and Transaction Processing, Insurance

Regulatory Knowledge: BASEL II, GAAP, SEC, FINRA,CFTC

Bug Tracking/Reporting Tools: Rational ClearQuest, Quality Center, IBM Rational Doors

Database: Oracle, MS SQL Server

BI Reporting Tools: SSRS, SSIS, SSAS

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee

Business System Analyst

Responsibilities:

• Involved in developing a solution framework for securing PCI data.
• Define the different forms of data and appropriately categorizing them for a better solution approach.
• Defined security levels users which are implement using active directory.
• Defined the processes for integrating the encryption and decryption tools (Voltage) into file processing flow.
• Defined redaction rules for data at rest and files.
• Analysis of files and data to for proper classification and assessment of PCI data content.
• Gather requirement for the development of decryption framework and U.I for accessing encrypted date.
• Developed a requirement document and functional design for the project.
• Involve in developing a solution framework for purging unwanted data.
• Defined the functional requirements for the replacement application for the paper bill conversion.
• Gathered requirement for the replacement of Talisma CSR task management tool with AVAYA.
• Discuss with team members about solution framework for projects.
• Involve in meetings with the scrum team in terms of prioritizing of tasks (PBI - Product Backlog Items), creating milestones and providing business context to development efforts.
• Interviewed subject matter experts and application owners from different business lines to gather information, understand the user’s needs, define requirements, and develop specifications.
• Participated in sessions with the domain and technology specialist to collect and define user requirements.
• Assisted in the development of quality assurance activities including Quality Assurance Plan, Product Acceptance Plan, Test Plan, and Test Cases.
• Created activity diagrams, use cases and sequence diagrams using MS Visio to view the system from different perspectives.
• Extracted data from different sources like flat file Excel data sheet, wrote SQL queries and processed data to upload in to the target database.
• Created data model that visually represents the nature of data, business rules governing the data, and how it will be organized in the database.
• Interfaced with the developers to provide all kinds of support and resources needed to resolve domain and technical issues.
• Conducted functional walkthroughs and User Acceptance testing sessions and assisted the development of User Manuals for customers.
• Participated in daily stand-ups and weekly status meetings.
• Trained Internal Users and their partner & management employees in the new web Based online applications.
• Use of Team Funder Server for requirement management for the scrum the Agile Scrum methodology.

Confidential, Chicago, IL

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, management, SME (Subject Matter Expert), stakeholders, lenders, underwriters.
• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Acted as a liaison between the account teams in the various regions and the lenders
• Analyzed operating procedures and policies on an ongoing basis and recommended and implemented improvement plans where appropriate.
• 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.
• Prepared Business Requirement Documents (BRD) and used Requisite Pro to manage, analyze, and convert business requirements into functional specifications.
• Conducted and participated in JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS)
• Analyzed business requirements and segregated them into high-level and low-level Use Cases, Activity diagrams / State Chart Diagrams using MS Visio according to UML methodology, thus defining the Data Process Models.
• Identified high-level requirements for developing and documenting detailed business requirements using DOORS.
• Created and managed project templates, Use Case project templates, requirement types and trace-ability relationships in Requisite Pro.
• Maintained project documents such as the risk management plan, action Item list, project benefits list, monthly updates and reviewed with the project manager at regular time intervals.
• Prepared the Business Workflow using MS-Visio with input, output, pre and post conditions.
• Communicate the status of the request to the account teams as and when they are processed.
• Responsible for all other SOX compliance controls associated with the pricing rules team
• Supporting the day to day operations of the pricing rules team
• Used MS Project to schedule deadlines, resources, and facilities
• Used Rational Clear Quest for bug tracking and reporting.
• Conducted the final user-acceptance testing (UAT) and usability testing.

Environment: UML, RUP, Windows 2000, Oracle 9i, Rational Rose, Requisite Pro, ClearCase, ClearQuest, MS Project, MS Word, MS Excel, Java, Web Logic, DB2.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Scoped out new functionalities and came up with time and effort estimation.
• Analyzed and documented the pros and cons of the project using SWOT analysis.
• Conducted Gap Analysis of client requirements, generated workflow process and necessary documents for the project by interacting with mortgage processing specialists, stakeholders, and valuable customers.
• Used OO (Object-oriented) concepts extensively and was involved in the design of the application
• Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships, and allow for maximizing software reuse.
• Developed an Analysis Model that includes entity classes, business workflow diagrams use case diagrams, sequence diagrams, object collaboration diagrams that provide the development team a view of the requirements for Development phase using Microsoft Visio
• Analyzed and optimized the process. Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite Pro.
• Used MS Visio to create, analyze and implement business workflow diagrams like use case diagrams, activity diagrams, state diagrams, sequence diagrams, collaboration diagrams and deployment diagrams
• Implemented Cost Benefit Analysis technique for deciding whether to make a change and used it to simply add up the value of the benefits of a course of action, and subtract the costs associated with it.
• Priced and initiated structured products and transactions employed for trading, market and credit risk management.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Interacted with analysts, system staff and developers.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.
• Discussed the Test Cases and Test Plans and select Test Data for Software Testers
• Involved in weekly walk through and inspection meetings to verify the status of the testing effort and the project as a whole.
• Used Rational Unified Process (RUP) methodology to augment software development

Environment: Microsoft Visio, Microsoft Office Suite, RUP, Rational Tools, Brio, and Oracle.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Followed all the phases in the project management life cycle.
• Acted as a liaison between the business users and technical teams to build applications based on the business requirements - provided a single point of contact for user communication (managed issue tracking, prioritization and resolution).
• Organized meetings and worked together with PM to discuss Project Requirements.
• Participated in sessions to define the solution approaches, and identifying assumptions, constraints, risk and issues. Analysis and specification of system changes.
• Revealed unidentified requirements, evaluated changes to requirements, and assessed impact of changes.
• Recommended process or system changes intended to eliminate identified risks or gaps.
• Worked with Finance and IT department to operate across functions and worked with resources external to the Project Team.
• Developed functional requirements and specifications document.
• Refined the requirements (use-cases) and Business Process Models to detailed level appropriate for technical analysis and system design.
• Wrote Requirement Documents (define user and system interfaces with the help of Use Case diagrams).
• Provided regular verbal and written status reports to IT management and business community; published meeting minutes and maintained project plans.
• Coordinated with the project team and testing team to revise project artifacts (such as use-case specifications, test scripts, and so on) to reflect requirement changes.
• Worked independently with minimum supervision as part of a dynamic IT team.
• Implemented CMS (Content Management System) in automating various aspects of Web and Publication Content Creation, Document Management and Delivery.
• Team lead for eight people in QA including two regression analysts and six functional testers. System Lead, interface and integrate UAT testing teams. Review test plan and results. Co-ordinate with other business analysts and client for reviewing test results.
• Participated and led sprint planning meeting to prioritize and determine level of work for PBIs in line with Agile Scrum methodology.
• Participated and led daily stand-up meetings in line with Agile Scrum methodology.
• Participated and led sprint review meetings in line with Agile Scrum methodology.
• Assisted the PM in managing the Agile Scrum process to ensure smooth delivery of projects.

Environment: Windows XP, Rational Rose, Rational Unified Process, Rational Clear Quest, Microsoft Project

Confidential, Pasadena, California

Business Analyst

Responsibilities:

• Studied the Business Process Flow and draft documentation through various conferences, meetings, workshops, and previous documents.
• Worked on the various phase for development of web-based systems.
• Rapid Application Development (RAD) principle was used in acute functionalities to design, document and manage requirements throughout the lifecycle of the project, i.e. definition, design and testing phases.
• Attended and conducted meetings and workshops to discuss high level requirements and developed User Requirements Specification Document.
• Developed business Use Cases and also extensively worked on Rational Requisite Pro in gathering the requirements.
• Created BRD and Functional Requirements Documents for documenting business needs. FRD contained detailed requirements, which were formatted such a way that a set of traceability could be matched from features to test cases.
• Responsible for implementing the Key process areas and Impact analysis. Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model using Visio, to depict process flows and PowerPoint presentations.
• Understood Vendor delegation module process flow of the company and added column for vendor delegation for Claims.
• Used SharePoint outlook express for office assistance, time and schedule management.
• Supervised and maintained open and clear communication regarding Change Request.
• Updated requirement document as per business user feedback and changed the functionality of the application
• Responsible for tracking issues that were detected and updated requirements based on daily meetings with on-site team.
• Responsible for requirement and design documentation review, test plans, identifying and reporting software anomalies and test results.

Environment: Microsoft Visio, Microsoft Office Suite, RUP, Rational Tools.

Confidential - South Portland, ME

Business Analyst

Responsibilities:

• Met with Credit Risk Analysts and Loan Officers to gather Credit Approval Process and Reporting Requirements (Credit Exposure Data, Loss Data) for Credit Cards (TSYS), Currency Swaps, FX Forwards, REPO, Equities, Fixed Income instruments like Bonds, US Treasuries, Mortgage Backed Securities, and Asset Based Lending Products according to the Basel II compliance guidelines
• Validate pricing of securities and formulae for calculating Accrued Interest, Fees and Charges and Loss Given Default (LGD) and Probability of Default (PD) based on Market data available from various sources like Bloomberg and Reuters and referencing from the Security Master Database
• Engaged and collaborated closely with the appropriate Business Subject Matter Experts for understanding the Business Processes behind the Small Business Loans (Provenir) and Credit Cards (TSYS1 / TSYS2) from Loan Origination and Collateral Management to Account Maintenance and Settlement
• Developed Source-To-Target Mapping for the Data Mart incorporating various Business Rules
• Analyzed and verified the integrity and reliability of the Loss Data, Exposure Data and Risk rating calculations in the Lending Repository
• Actively collaborated with the Business users in the UAT phase to reconcile the reports from the old system with that of the new system by building appropriate test cases and test scenarios