PROFESSIONAL SUMMARY:

• 8 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis, and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting, and Drafting Remedy Procedures.
• Experience in facilitating Joint Requirement Planning JRP sessions with Business User Groups, conducting Joint Application Development JAD sessions with IT Groups and Conflict Management with Project team members.
• In depth knowledge of Rational Unified Process RUP methodology, Use Cases, Software Development Life Cycle SDLC processes, Object Oriented Analysis, and Design OOA/D
• Competent in Creating Unified Modeling Language UML diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, and Sequence Diagrams.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, and Risk Analysis.
• Extensive experience in configuring data mapping between different Databases.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Responsible for Tracking, Documenting, Capturing, Managing, and Communicating the Requirements using Requirement Traceability Matrix RTM which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution, and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Proficient in DMAIC
• Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Programming Languages :C,C ,C ,VC ,VB,VB.NET,C .NET, ASP.NET, Java, SQL, PLSQL

Operating Systems : UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases : MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers : IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet : HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools : MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro,

Documentum

Bug Tracking Tools : Mercury TestDirector, Rational ClearQuest

Utility Tools : MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools : Crystal Reports, SQL Server Reports SSRS

Data warehousing Tools : Informatica, Business Objects, Cognos, Erwin

Testing Tools : Quick TestPro QTP , TestDirector, WinRunner, LoadRunner

Professional Summary:

Confidential

Role: Sr. Business Analyst

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, IBM Websphere Business Process Modeller, VBScript, Adobe Photoshop, MIS-IP, C . NET, ASP.NET, Business Objects, TestDirector, LoadRunner, Niku Project WorkBench, AVPN.

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Used IBM WebSphere Business Modeler to fully visualize, comprehend, and document the business processes. To model and optimize the business-critical processes. Define and refine process models through the company's best practices.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Created job schedules to automate the ETL process.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design UI screen using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Confidential

Role: Business Analyst

Environment: Windows XP Professional, Oracle9i, MS Access 2000, MS Excel, RUP, Oracle, UML

Responsibilities

• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Performed Cost benefit, ROI and ROM studies
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, and Activity Diagrams using Corporate Modeler
• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Involved in creating business processes and modeling diagrams using Rational Unified Process RUP .
• Created use case scenarios and documented work flow and business process.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Documented requirements, associated change requests with requirements and connected requirements with Use cases.
• Interacted with the client and the Technical Team for requirement gathering and translation of Business Requirements to Technical specifications.
• Incorporated Rational Unified Process RUP to create Requirement Document Specifications using Visible Analyst.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Served as conduit for managing system requirements between the business and the software development team.
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Queried database using SQL
• Presented the mapping document with all business logic applied for the system to Project Manager.
• Worked directly with users of the Multi-Channel Desktop to gather and document their business requirements. Followed up with the users to test the implementation, achieved sign-off and continued to move the system toward go-live.

Confidential

Role: Business Analyst

Environment: MS Visio, MS Project, UML, SQL Server, PL/SQL, .NET, Clear Case

Responsibilities

• Involved understanding the current business process, defining scope of the project along with position statement.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews group and one-on-one along with JAD sessions.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Created business use case, functional FRS and technical specifications for trading system.
• Helped document the rational and requirements behind the XML architecture that encompasses data origination, secondary market and servicing data for implementing MISMO standards
• Assisted in preparing a data dictionary to provide business definitions and corresponding architecture data element tag names for MISMO
• Applied Unified Modeling Language UML methodology to create use case diagrams and sequence diagrams in Rational Rose.
• Worked with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application.
• Designed the UI web interface of the application, along with prototyping.
• Resolved issues and improvised the process to ensure a stable and accurate solution.
• Performed cost-benefit analysis, generated reports for analyzing various investments and their profitability and also for analyzing various lost opportunities due to time delay in investing.
• Worked with financial services as part of support for the application.
• Validated business rules and all artifacts with users, approval and sign off.
• Provided technical and business knowledge to clients.
• Working with the architect, developers on business and technical issues, helping in designing of the system and testers to ensure all requirements are correctly translated.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked with the team on security features: web, encryption, authentication and SSO possibilities.
• Updated and modified progress and resources allocation in MS project for the team.
• Created job schedules to automate the ETL process.
• Suggested process and product improvements for the application.
• Created test plans, scripts and facilitated user acceptance testing.
• Performed manual front-end testing to check all functionalities of different modules.
• Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
• Identified areas of risks, assessment, monitoring, having security and audit controls in place.
• Ensured that the application met user and management expectations.

Confidential

Role: Business Analyst

Environment: RoboHelp, Microsoft Word, Project, Excel, PowerPoint, Visio, GIS tools, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, DOS and UNIX Sequential Files, MS Access, CSV Files, XML File,

Responsibilities:

• Prepared project plans using MS Project and coordinated timelines as guided by the Project Manager
• Collects, verifies accuracy, aggregates, and submits to the Office of Special Education Programs all data required under part B section 618 of the Individuals with Disabilities Education Act. Current data includes six tables, child count, personnel, environments, exiting, discipline, and assessment
• Collaborate with the National Center for Special Education Accountability Monitoring, Office of Technology, and Special Education software vendor to improve statewide data reporting and verification system
• Collects, analyzes, reports and tracks all data required as a part of the Partnership Agreement between the South Carolina Department of Education and the Office of Civil Rights Conducted extensive Joint Application Development JAD sessions for all business related issues.
• Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Prepared High Level Logical Data Models and BRD's Business Requirement Documents supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Used Rational Clear case for version control and Used Rational clear quest for defect management
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Extensively used Ms SharePoint a content management platform, for managing content across the organization within a shared repository.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Documented the dimensional models of ETL system.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Configured the Data mapping between Oracle and SQL Server 2005.
• Documented the meeting minutes with issues of about discussed and solutions resolved.

Confidential

Business Analyst

Environment: UML, RUP, Power Designer, Oracle 9i, Requisite Pro, ClearCase, ClearQuest, MS Project, MS Word, MS Excel, Java, Web Logic, DB2.

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.
• 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.
• Used Power Designer to develop Use Case diagrams, Activity Diagrams and Sequence Diagrams.
• 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
• Documented and evaluated test cases/test results/feasibility study of various ETL tools like DataStage/Informatica.
• Used RUP methodology to analyze and translate business requirements into system specifications, communicating with the business on a broader scale and with an in-depth view too.
• Involved in creating disaster recovery plans
• Used Rational Rose and UML to produce models like context, use case, sequence, activity etc.
• Used ClearCase to keep different versions of the documents and ClearQuest to report bugs or defect.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• 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.