SUMMARY

• Resourceful and dynamic Business Analyst with over 7 years of experience with strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP), Waterfall, V - Model and Agile methodology.
• Broad experience in various domains including Finance, Mortgage, Auto/Home Insurance, Property and Causality Insurance, Utilities, Marketing & Advertisement, and Education.
• Expertise in broad range of technologies including business process tools such as MS Project, MS Excel, PowerPoint, MS Visio, technical assessment tools, Data Warehousing concepts, Infrastructure, and web design.
• Proficient in developing Use Cases, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, and Activity diagrams), Swim-lane diagrams and Class Diagrams based on UML using MS Visio and Rational Rose.
• Strong experience in client interaction and understanding business applications, business data flow and logical/ physical data modeling using Dimensional/ER Modeling and Star and Snowflake schemas.
• Extensive experience in using the change management tools like Rational Clear Case, Rational Clear Quest, and Perforce & requirement management tools like Rational Requisite Pro.
• Extensive success in translating business requirements, reporting requirements, and user expectations into detailed system specifications employing Unified Modeling Language (UML).
• Expertise using Business Objects tools such as Supervisor, Designer, BCA, Web Intelligence and Info view.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mappings for Operational Data Stores, Enterprise Data Warehouse, Data Marts, other databases.
• Proficient in Data, UML Modeling and Data Warehouse reporting tools.
• Expert in facilitating and defining the entire Testing Life Cycle including test strategy, test planning, test case preparation, test execution and defect management.
• Experience in conducting Automation and Performance testing using various tools including Rational Suite Tools, HP Quality Center
• Experience in Manual Testing using Mercury and Rational tools and in writing Test Scripts using Test Scripting Languages.
• Strong customer/user advocate, apt negotiator with excellent analytical, communication, decision-making and organization skills.

TECHNICAL SKILLS

• MS SQL Server 7.0/2000/2005/2008
• MS Access iRise
• Oracle 9i
• SQL
• C/C++
• HP Quality Center
• Serena Open Project
• Rational Requisite Pro
• Rational Clear Case
• Rational Clear Quest
• Rational Rose
• Dream weaver CS5.5
• HTML
• XML
• Enterprise Architect
• MS Office
• MS Outlook
• MS Share Point
• MS Visio
• MS Project
• MS OneNote
• Photoshop
• MS-DOS
• Windows Vista/XP/9x to 2k.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Test Manager/Business System Analyst

Responsibilities:

• Created functional design documents based on the Mortgage LOB approved requirements and supported the Enterprise Interface partners in creating Technical Designs.
• As a Business Analyst, was involved in the analysis of source data and created detailed Data mapping document between the new servicing system (MSP) and the various middleware and front-end applications.
• Worked on mapping of MSP Web services to Enterprise Interface Partners and coordinated with FIS on MSP Web Services environment access and connectivity related tasks/issues.
• Conducted Data analysis includes loading data in tables and accessing databases, Data warehouses and writing sequel to analyze the data using MS Access and TOAD.
• Coordinated Requirements gathering sessions with the Line of business (LOB) and made sure the requirements were clear and un-ambiguous.
• Conducted IT Reviews of the gathered requirements with the Enterprise Interface IT Partners and developed Mock-ups and Wire-frames using Adobe Dreamweaver to help them understand it better.
• Planned and conducted feasibility and impact analysis on the gathered requirements based on resource, timelines, and the budget and helped build the project plan.
• As the IT Coordinator for front-end (CA/BOE/CIS-SBS/CIS-Index) and middle-ware applications (RSI/HMS/CMU) on the Voyager Program, was involved in conducting weekly review meeting with various cross-functional teams including the Enterprise interface partners & LOB regarding requirements, technology related issues, project announcements/updates, testing support, defect triage/resolution and other deliverable related responsibilities.
• Tracked Project Requests in the Enterprise Releases and helped resolve issues/risks arising out of that.
• Involved in developing Test Strategies and effectively implementing them for Requirement traceability, Test Planning, Test Execution and Defect Management for the entire Enterprise Integration team and used Quality Center to achieve the same.
• As the Test Manager, managed and provided aid to the test team with the build related information, cycling/loading of account data, developing/ tracking metrics and other testing related information via weekly status meetings.
• Worked on doing End-to-End testing, and other complex database testing using Toad/ Oracle and supported Black box testing by the LOB.
• Worked extensively on Quality Center all the way from requirements loading, creating/updating test cases and tying them back to requirements, test execution and defect logging/tracking.
• Worked on developing the Implementation plan using XL Macros for the entire Enterprise Integration Team supporting multiple enterprises wide applications during Conversion time-period and supported all the Enterprise applications for a smooth transition from the old to the new system.
• As part of project close-out activity was involved in documenting various functional specs for future reference and cleaning-up the WS Data Mapping doc for any errors.
• During post-production was instrumental in improving performance of the MSP system by 35% by collecting information from various front-ends to monitor/observe the transaction volumes/ trend-lines of the system and recommending infrastructural/ coding changes to the various systems/services used.

Confidential, Bentonville, AR

Lead Business Analyst

Responsibilities:

• Coordinate with the business constituents and technology teams to refine requirements and translate them into technical specifications/ functional requirements so that they leverage existing technology.
• Developed and maintained a thorough understanding of the needs of the walmart.com user group from the business and design perspective
• Responsible for providing business requirements within anAGILEsoftware development in scrum environment.
• Performed the role of the Scrum Master, facilitating daily scrum meetings and scrum of scrums knowing the status of the development and testing of the product on a daily basis.
• Work with engineering and operations staff to ensure 24x7 operations of all web analytic systems.
• Executed DDL and DML queries (like Select, JOINS, Alter) to validate data integrity.
• PerformedGap Analysisto check the compatibility of the existing system enhancements.
• Defined Business processes, business rules and evaluated change requests for the application.
• Worked with multiple merchandising and inventory control and tracking systems.
• Implemented Cost Benefit Analysis for deciding whether adding new modules would benefit the project.
• Created basicwireframes prototypes for graphical user interfaces to visually demonstrate the proposed application.
• Extensively usedRational Requisite Proto document and manage requirements.
• Created and managed project templates, use case templates, requirement types and traceability Matrix (RTM)
• Developed successful online marketing strategies to drive organic website traffic.
• Compiled, tabulated and coded statistical reports using pivot tables to produce spreadsheets, graphs and databases.
• Provided overall project management to multiple projects successfully completing them on-schedule and on budget.

Environment: Scrum, UML, MS Project, MS Excel, MS PowerPoint, MS Visio, HTML, Dreamweaver, JSP, J2EE, Java, HP Quality Center

Confidential, Fort Worth, TX

Business Analyst/Business Intelligence

Environment: MS Word, Excel, PowerPoint, Visio, Agile, MS SQL Server 2005, SQL, Crystal Reports XI R2, ASP .Net 2.0/1.1, C#, VB. Net, HTML/DHTML, XML, Windows XP, Flash Player, Adobe Flex.

Responsibilities:

• Conducted a thorough analysis and understood the requirements gathered through the previous phase in the project.
• Gathered the business requirements for the new phase through Interviews and JAD sessions.
• Analyzed the requirements and prepared the Vision documents for the different modules to get the approval sign-off from the client.
• Created the mock-ups and screen shots using Adobe Dreamweaver to help the development team better understand the requirements.
• Prepared the Use Cases for various functionalities in the enterprise system and performed Business Process Modeling using Sequence diagrams, and Activity diagrams using MS Visio.
• Communicated with the Stakeholders and SME’s through JAD sessions and E-mails to gather the reporting requirements used in the software solution.
• Performed data mapping from Operational data store to the Enterprise Data Warehouse.
• Prepared the Reports Standard documents and the Reports Design Documents to help the reporting team effectively understand the requirements.
• Led and coordinated with the off-shore reporting team of four on a daily basis in completing the reporting requirements using Crystal Reports.

Confidential, Irving, TX

Business Analyst/Data Analyst

Responsibilities:

• Involved in gathering Business Requirements for new models through JAD sessions, E-mails and Surveys.
• Performed extensive Use Case analysis for insurance claims.
• Performed extensive Business Process Modeling using Swim-Lane diagrams, Sequence diagrams, Workflow diagrams and Activity diagrams using MS Visio.
• Conducted Feasibility Analysis to study the benefits of using the application thro’ Data Flow Diagrams and used Trace-ability Matrix to find out the best possible technologies to be used.
• Coordinated with all Allstate agents to gather requirements under property insurance for the application and managed them using Rational Requisite Pro.
• Involved in Gap Analysis of existing policy management system with the Enterprise system.
• Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.
• Analyzed the final requirements of data and authored the Source To Target Mapping (STTM) Documents to help ETL team in extracting and processing data before loading to the target database.
• Created Data Dictionary as descriptions for the mock-ups screens and wire frames for the development teams.
• Studied and Analyzed the Reporting requirements of agents so as to include them while building the application.
• Developed Test Plan and Test Cases in co-ordination with Quality Analyst to perform manual and performance testing.

Confidential, St. Louis, MO

Business Analyst/Systems Analyst

Environment: Rational Rose, Rational Clear Case, Rational Clear Quest, MS Office Suite, MS Project, Business Objects 6.5(Supervisor, Designer, Reporter), Java, Broadcast agent server, ERWin 3.5.2, IIS Web server, SQL, Oracle 9i, Mercury Test Director.

Responsibilities:

• Gathered user and business requirements through interviews, surveys and prototyping. Stored and modified requirements in MS Word.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Conducted Change Analysis for the improvement of the existing system and recommended the required changes using Rational Clear Case.
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using Rational Rose.
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Involved in the entire project life cycle (SDLC) from evaluation, installation, configuration and development of end user reports.
• Gathered and analyzed the business reporting requirements with the existing Data source and suggested the changes in the data source.
• Created the universes based on the user classes and their hierarchy in the organization at different aggregations.
• Specified the standards for universes, Classes, Aliases, Help text, Simple and complex objects.
• In Info View, implemented customized logins at application level and provided password reset options to the users.
• Created user groups and managed access privileges using Business Objects Supervisor.
• Designed, built, and maintained Business Objects universes.
• Created the Test cases and SQL scripts to verify the results and performed bug tracking using Clear Quest.