SUMMARY

• 7+ years experience as a Business Analyst, with solid understanding of Business Process Flows, Case Tools, and Business Analysis.
• Extensive experience in gathering Business and Functional Requirements, developing Use Cases, conducting Gap Analysis.
• Experience in working with QA teams. Creating Test Plans and Test Cases.
• Experience in developing UML use cases, Work Flow Diagrams using tools including Rational Rose and MS Visio
• Excellent Business writing skills in creating Business Requirements Document (BRD), Use Case Specifications, use case development, Functional Specifications, and Systems Requirements Specification (SRS).
• Experienced in complete Waterfall, SDLC, Client /server architecture providing a well balanced understanding of business relationships, business requirements, worked for technical solutions and help the team Confidential all levels until final product release.
• Experience in applying Rational Unified Process (RUP) methodology using Modeling and requirement documentation tools such as MS Office, MS VISIO, and MS Project.
• Proficient in BA Methodologies for Agile/Scrum, Waterfall and RUP development environments.
• Proficient in developing and executing Test Plans, SQL and PL/SQL queries, performing functional, usability testing and ensuring that the software meets the system requirements
• Effective Confidential facilitating meetings and brainstorming sessions.
• In depth knowledge Rational Unified Process (RUP) methodology, use case development, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D)
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Specializes inbusinessintelligence (BI),businessprocess particularly change management and ensuring that the controls put into place forbusiness related processes are adhered to in accordance with corporate policy.
• Proficient in soliciting client requirements through interviews, workshops, existing system documentation and organizing JAD sessions.
• Import legacy data from Mainframe and upload in UDB and perform data analysis using SQL
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Expertise in co - coordinating between Top Management, Program Managers, Project Managers, Systems Developers and Business Sponsors for project implementation.
• Excellent Team player work in conjunction with testing, development and other teams in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.

TECHNICAL SKILLS

Methodologies: Unified Modeling Language (UML), SDLC, RUP, RAD, Agile

Requirements and Document Tools: Rational RequisitePro, Rational Clear-Quest

Business Modeling Tools: Rational Rose, Rational Requisite Pro, BPM, Microsoft Visio and Enterprise Architect

Version Control Systems: Rational ClearCase, Visual Source Safe

Project Management: Microsoft Enterprise Project Management, Microsoft Office Suite, SharePoint, Microsoft PowerPoint

Databases: SQL Server 2000, Microsoft Access

Operating Systems: Microsoft Windows 95/98/NT/2000, XP

Testing Tools: WinRunner, LoadRunner, Quick Test Pro

PROFESSIONAL EXPERIENCE

Confidential, California

Business Analyst

Responsibilities:

• Gathered, analyzed and documented business & technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Conducted user interviews.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation.
• Worked with Managers to understand the issues facing their programs, the resolution and ifPDO intervention is needed
• Maintained a list of Program Level Action Items, Issues and Risks Confidential thePDOlevel; followed up with the Program Managers, leads, architects to get the items resolved on a timely basis
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
• Organizing JAD sessions, personal interviews and surveys in the process of collecting requirements including that of higher management
• Partner withBIleads to identifyBIIT needs and consult onBusinessIntelligence solutions to complexbusinessproblems.
• Lead the analysis of current state and future state capabilities forBIIT, including user interfaces and delivery options and the tools necessary to support them.
• OperatedBItools calledBusinessObjectives used CPT codes in order to setup and run through models.
• Exposed to Agile methodology.
• Created and developed use case scenarios and documented work flow and business process using Rational Rose
• Developed and implemented theETLpackages /migrated packages from dev/test/prod
• Worked on Requirement Change Management System using Rational Requisite Pro
• Used VB Scripting to change and modify data and developed custom reports.
• Closely working with front end and back end developers on system design based on MySQL and PHP
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Used FileNet to maintain and manage Business workflows.
• Involved in Data modeling of both Logical Design and Physical design of Data warehouse and Data marts in Star Schema and Snow Flake Schema methodology
• Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level
• Involved in full life cycle of Business Objects reporting Application.
• Used Rational clear quest for defect management

Environment: RUP, Agile, SiebelCRM, OBIEE11.1.1.5.0, 11.1.1.3.0, UML, Windows NT, Rational Suite (Rational Test Manager, Rational Robot, Rational Clear Quest), MySQL, FileNet, PHP, MS Project, MS Visio, Visual Basic, Win Runner, VB Scripting, Test Director, Windows XP

Confidential, Newark, NJ

Business Analyst

Responsibilities:

• Conducted analysis studies that serve as input to the strategic planning, goal setting, and approach to achieving the goals.
• Helped the PM in initiating the project, preparing the Business case and planning it.
• Attended the seminars and workshops conducted by the Client and understood the working of the different kinds of services such as Retirement Savings, Life/Property & Casualty Insurance and ther commercial and Industrial Insurance.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Defined existing business process and identified the Gap Analysis between the existing & improved business process to redefine to process (BPI) and SOPs.
• Identified and defined Business analyst work Strategy and requirements risk approach and determine planning considerations finalized (RUP).
• Collected requirements using Brain storming, Document analysis, Focus Groups, Interface analysis, Interviews, JAD, prototyping, survey, reverse engineering and user task analysis for various reporting types like CLUE (Comprehensive loss underwriting exchange, Change Report, Claim Count, Claim summaries) for Retirement Savings, Life/Property & Casualty Insurance.
• Explained the solution model, analyze the functional requirements, prepared the Use cases, defined user profiles, defined the supplementary requirements, defined assumptions and prepare the traceability matrix and validate the requirements.
• Wrote business requirements specification (BRS) and functional requirements specification (FRS) documents as per the business requirements and process flow.
• Created Business Intelligence reporting for better understanding of business process and data.
• Developed and tested data mapping, and performed QA Confidential several stages ofETLprocess including running SQL queries onOracletables
• Developing custom reports in Oracle Reports, performing back end data clean up/fixes or working with the on-site software support team to resolve software related issues.
• Development of PHP based data file creation, data file uploads into MySQL databases and extraction of data files from servers and email accounts.
• Effectively utilize customer support soft skills to maintain a positive working relationship between FileNet and its customers and partners.
• Created data mapping documents for the movement of data from production databases to the warehouse and from the warehouse to the policy and claims marts.
• Assisted System Architects and Quality Assurance Analysts in creation of various tests by using Quality center.
• Assured that all artifacts are in compliance with corporate SDLC policies and guidelines.
• Worked withbusinessunits, development, operations, and technical support groups in the testing and implementation of recommendations.
• Assisted in deletion of defects and bugs, in order to meet specific requirements and deadlines for successful execution of the project.

Environment: Visual Basic, Oracle 11i, MySQL, PHP, MS-Project, FileNet, MS-Visio Windows 2000 Server, Windows 2000Rational Tools, RUP

Confidential, Indianapolis, IN

Business Analyst

Responsibilities:

• Analyzed business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagram, using Borland Together according to UML methodology thus defining the Data Process Models.
• Design Visio process flowcharts for the enhanced Customer Complaint Handling System. Prioritize documentation schedule for multiple projects
• Prepare data models and perform data analysis. Documented metadata, including domains, definitions, and business rules.
• Responsible for designing Use Case diagrams and Class diagrams using UML.
• Conducted phone interviews with the clients for gathering requirements and evaluation/analysis of their data. Converted the business requirements into IT specifications
• Collaborated with the developers to include Health Level seven into the legacy system
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
• Facilitated function point analysis in support of the agile software development life cycle
• Gathered and documented the requirements that are critical to the business mission and using those requirements to design application software using a Use Case in Requisite Pro.
• Working with templates in Excel and other systems like Sharepoint, VI-Client, Global Document Repository, and FileNet.
• Used ArcSight Connectors to collect data from Radio-Frequency tags which were implemented by a web application using java struts and integrated into the database and maintained by Imperva Web application security
• Designed and developedOBIEE/Siebel Analytics RPD usingOBIEE/Siebel Analytics Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Variables, Initialization Blocks, & Logical & Facts / Measures objects inBusinessModel Layer, and creating the Presentation catalogs in Presentation Layer
• Defined DW Strategy/Roadmap, development life cycle process, standards, Methodology, Change Management, Source control, capacity planning, Performance planning, Performance monitoring and tuning, EDW data analysis & data modeling and DW process to load EDW from different source systems (MainframeDB2, csv, txt, mdb, oracle).
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Used MS Visio for Process modeling and Business Process flow diagrams
• Prepared Powerpoint wireframe templates using for UI designs.
• Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Created and Developed Use Cases, Workflows, and Screen Shots for the Application
• Developed the business and functional requirement specification describing and prioritizing of the requirements.
• Followed top down, leveled technique for building Business Process Models
• Identified and documented issues, risk and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements
• Knowledge of HIPPA standards and implementation of HIPPA into the database
• Extensively involved in Data warehousing administration and metadata management responsibilities of clinical data.
• Developed Project Status metrics for weekly evaluation of Project Status and impact of the Change Request on the Time line.
• Wrote test cases and test scripts and performed them.

Environment: RUP, MS Visio, Clear Quest, SQL, ArcSight, Imperva, FileNet, Oracle 8i, MS Office Suite, MS Project, Microsoft Outlook

Confidential, Saint Louis, MO

Business Analyst

Responsibilities:

• Worked as a liaison between the Business and Technology Department.
• Work closely with production underwriters to review new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Designed report templates based on the requests by account managers.
• Designed Functional Specification Documents for the reports.
• Implemented data mining tools and techniques to extract data for ad hoc reporting and automation of current operational processes.
• Implemented SDLC which included requirements, specifications, design, analysis and testing using RUP methodology.
• Documented all the changes in the initial templates and was responsible for Release Management.
• Reviewed Requirements & deliverables for delivery timeline.
• Used MS Visio to create and developed Flow diagrams and Use Case Diagrams.
• Created presentations explaining the entire report development process, while drawing a comparison between the legacy & the new report.
• Coordinated with the developer, on day-to-day basis, during the development process.
• Tested the report for its content.
• Worked on Report Re-engineering Project and made enhancements to the system flow.
• Tracked the defects in legacy reports . Compared the results and tracked the differences in excel
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• DevelopedBusinessObjects reports for reporting theETLprocess
• Involved in moving the reports from development to DEV to QA and QA to Prod environment using import wizard
• Worked with ETL team during the upload process and helped with Data Mapping between the data mart and the Source Systems.
• Worked with SQL queries using MS Access for data manipulations.

Environment: Rational Tools, MS Office (Word, Excel, PowerPoint, Visio), SWOT analysis, SQL, Test Director, QTP 8.2, Win Runner.

Confidential, Illinois

Business Analyst

Responsibilities:

• Interact with the application team to have Knowledge Transfer about the application performance test requirements.
• Developed an integrated Test Plan covering the main functions of the designated parts of the application using Test Director.
• Test data for all Business process to be ready and the same should be validated before execution.
• Parameterize and correlate the performance test scripts.
• Performed Acceptance, Usability, Cross-Platform and Regression testing during different stages of the application development using Quick Test Pro.
• Involved in generating the test scripts using Quick Test Pro for regression testing.
• Categorized bugs based on the severity and interacted with developers to resolve them.
• Used Test Director to store Test Plans, Test Cases, Test Scripts and for bug tracking.
• Extensively used Microsoft Office Suite of products for documentation and data interpretation.

Environment:Windows XP, Linux, MS Access, MS Excel, SQL server, QTP, Test Director