SUMMARY

• Over 8 years of professional experience as a Business Analyst in Financial Services industry with Extensive experience in analyzing, gathering requirements and writing system functional specifications including use cases.
• Excellent in Developing and evaluating business process Models and ensure that the development team understands business requirements to guarantee the delivery of effective solutions that meet the business demand.
• Deep understanding of enterprise data warehouses.
• Strong experience in RUP Business Modeling process.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Highly proficient in using advanced UML modeling tools like Rational Requisite Pro and Rational Rose, MS Project, MS PowerPoint, MS office and MS Visio.
• Solid understanding of Business Process definition, Risk Analysis.
• Full life cycle Software Development(SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications, Development and Testing.
• Key Team player in conducting Peer reviews, Brainstorming, walkthroughs sessions to confirm and playback business requirements for a project.
• Excellent quantitative and analytical skills combined with pragmatic interpersonal and communication skills.
• Experience in facilitating and moderating Joint Application Design (JAD).
• Proficient in technical writing & documentation such as Business Plan, Vision and scope document, User Requirements, Business Requirement, and Functional & Non Functional Requirements.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/datamart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Web Intelligence).
• Experience in writing SQL queries to retrieve information from databases.
• Extensive experience in Dimensional Data Modeling using Star/Snowflake schema, Fact and Dimensions tables.
• Experience in creating Requirements Traceability Matrix (RTM).
• Experience in creating test plan and test procedure development and review, project customization and administration, defect management, configuration management and version control, and also business documentation.
• Experience identifying, implementing and tracking organizational change management tasks.
• Coordinate business department with technical teams to resolve issues.
• Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) Extensive experience in User Acceptance Testing (UAT).
• Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing.
• In Depth understanding of the AS - IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Ability to work well in a team and open to Team related tasks, team meetings, team interaction and also conference calls.
• Translated and provided training to end users.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit.
• Help team to resolve conflicts constructively and ability to communicate when help is needed. A Self starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS

Business Analysis: MS Visio, MS Office, iRise, Requisite Pro, Rational Rose

Methodologies: Waterfall/Spiral, RAD, JAD, RUP, Agile, UML, Prototyping

Languages: SQL, UML, HTML, XML, Java Script, Java

Testing: Manual Testing, Automated Testing, Quality Center

Databases: Oracle, SQL Server, My SQL, MS Access

Tools: Informatica, Cognos, Business Objects

Operating Systems: Windows 7/Vista/XP/NT/98/95, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, CA

Business Analyst

Responsibilities:

• Collaborated with all the stakeholders and clarified client requirements, business needs and project objectives via feedback sessions and client meetings.
• Analyzed requirement documents by identifying ambiguous, incomplete and inaccurate requirements.
• Involved in requirement analysis, use case development, UML modeling using Rational Rose and MS Visio.
• Produced a traceability matrix by tracking, managing and tracing all requirements.
• Created and reviewed Business requirement document (BRD) and Functional Specification Documents (FSD).
• Worked on creating the business requirements for Data Migration from Legacy system to new Oracle database.
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Reduced the number of user clicks to the website by streamlining the application to improve usability.
• Prepared test plans, test scripts and participated in the review of QA Test Plan and assisted the QA Team and performed UAT.
• Utilized MS SharePoint to centrally store, manage and access business artifacts across all platforms.
• Analyzed user requirements, attended change request management (CRM) sessions to create, track and schedule change requests using Rational ClearQuest.
• Maintained different versions of project documentation with Rational Clear Case.
• Prioritized outstanding defects and system requests based on business requirements.
• Organized and Performed functional testing, regression testing and support for User Acceptance Testing.
• Involved in assisting project manager in planning, scheduling, and controlling projects based on schedules and requirements outlined by the business.

Environment: Windows XP, Rational RequisitePro, Rational ClearQuest, Rational Rose, MS Visio, Oracle 9i, Quality Center, SharePoint 2007, MS Visio and MS Excel.

Confidential, NJ

Business Analyst

Responsibilities:

• Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC.
• Represented the IT team in the requirements session to discuss and review theBusiness Requirement Document (BRD).
• Proposed new design suggestions and identified risks involved with the business.
• Used MS Visio for Process modeling and business Process Flow Diagrams.
• Conducted Application Simulation usingiRiseto assist Business Stakeholders with a preview to the actual Application Development.
• CreatedFunctional Specification document(FSD) to explain the detailed Functionality of all new requirements or enhancements in the Business Requirement Document (BRD).
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Conducted review sessions of FSD with the QA and Development teams for understanding of business process/requirements.
• Managed Scope and change throughout the SDLC process of the product.
• Acted as a liaison between technical and business teams.
• UsedMicrosoft SharePointfor document management and as a common repository for project documents and deliverables.
• Worked extensively with the QA team for designing Test Plan and Test Cases for User Acceptance Testing.
• Collaborated with Development team to ensure requirements, enhancements and defects for the particular release have been developed and properly implemented.
• PerformedRoot Cause Analysisof Defects found during Unit Testing.
• Conducted GUI, functional and end-to-end testing of the applications.
• UsedHP Quality CenterforDefect management, Requirements module, Test Design and execution.

Environment: Java, J2EE, Web Logic Portal, Web Logic Server, ASP.NET, SharePoint, Oracle 9i, Unix, HTML, CSS, JavaScript, Cognos 8.x, MS Office, MS Visio, Quality Center, SQL, iRise.

Confidential, Mansfield, MA

Share Point Business Analyst

Responsibilities:

• Served as liaison between Business Owners and IT Application Development to provide solutions to help meet end users needs.
• Worked with Subject Matter Experts (SME) to determine requirements. Elicited the requirement using elicitation technique like Surveys, JAD, Brainstorming and Interviewing Sessions.
• Followed a structured approach to organize requirements into logical groupings and developed Business Requirement Documents (BRD) from essential Business Process, Business Rules, information needs and ensured that critical requirements are not missed.
• Conducted GAP Analysis between Microsoft SharePoint 2007 and Microsoft SharePoint 2010.
• Expertise in Designing, Developing and Implementing SharePoint 2007 and 2010 with the help of SharePoint Designer2007, SharePoint2010 and MS Visio 2010
• Developed and integrated effective out-of-the-box workflows and Info Path forms for project Business Requirement Document.
• Conduct training presentations through Microsoft Live meeting, for newly created SharePoint portals, and presenting instructions through the use of PowerPoint.
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Prepared Level of Effort (LOE) for particular enhancements to be done for the business stakeholders and getting approval from the project manager.
• Facilitate Joint Application Development (JAD) sessions to identify the business rules and requirements and then documented them into a well format that can be reviewed and understood by both business people and technical people.

Environment: Agile Scrum, Rational Rose, UML, Use case, Activity, MS Visio, Windows 2000/XP, MS Office, SQL, Oracle, Microsoft live meeting

Confidential, NY

Business Analyst

Responsibilities:

• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Met with client groups to determine requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Held responsibility for creating business flow diagrams and charts for E-commerce using MS Visio.
• Worked with various vendor groups to gauge the effectiveness of their solution.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Led JAD sessions with analysts, business group, developers and testers to define and document use cases, process flows, story boards, activity swim lane diagrams, specifications, data details, scenarios (primary, alternate), validation rules, screen mockups and entry and exit criteria.
• Involved in testing the conversion of the application into web application using XML web services
• Created wireframes and storyboards.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Created GUI specifications with Page flows, page business actions and screen mockups.
• Identified various frequently used modules within the application as well as the peak user volume for load testing purposes.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: Win XP, MS Office, PL/SQL, KPI, Load Runner, .Net, UAT, Rational RequisitePro, iRise, Test Plan, Use Cases, SQL, UML, Test Cases, Agile, Data modeling (Visio).

Confidential, CA

ETL/InformaticaAnalyst

Responsibilities:

• Analyzed business process and gathered core business requirements.
• Interacted with businessowners and end users and identified the potential bottlenecks.
• Used Agile software development methodology.
• Responsible for defining, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by dataanalystsand prepared functional and technical design documents.
• Extracted/loaded data from/into diverse source/target systems like Oracle, SQL Server, COBOL, XML and Flat Files.
• Created standard and reusable Informatica mappings/mapplets using Lookup, Joiner, Rank, Source Qualifier, Sorter, Aggregator, and Router transformations to extract, transform and load data.
• Worked on various workflow tasks command Tasks, Decision & Assignment tasks etc. to schedule workflows
• Session partitioning for concurrent loading of data in to the target tables to improve the performance.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Validated the data for accurate load into target databases.
• Involved in writing scripts to schedule the different workflows.
• Tested the scripts and queries according to the requirements.
• Created and executed test cases/scripts and completed unit, integration and system tests successfully.
• Worked with QA team to coordinate the testing efforts of Datamart before moving to UAT and Production.
• Deployment of Informatica Objects from Dev to QA, UAT, and Production environments.

Environment: Informatica Power Center 8.6.1/9.1.0 , Teradata, Flat files, Oracle, DB2, SQL server 2005, SQL, PL/SQL, Cognos.

Confidential

SQL Developer

Responsibilities:

• Responsible for gathering requirements, designing, developing and testing.
• Involved in creating logical and physical models using Erwin.
• Migrated data from heterogeneous data sources and legacy system to centralized SQL Server databases which involved cleansing, data mapping and data conversion.
• Responsible for the end-to-end design, development and testing of assigned reports.
• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Involved in performance tuning to optimizeSQLqueries using query analyzer, execution plans.
• Mapping Operational Repository toBusinessRepository elements and incorporating the build rules.
• For designing packages, stored procedures, functions and database triggers PL/SQL is used.
• Monitoring of statistics taken by the process, narrow down most expensive and long running queries to perform query optimization using SQl Server Profiler results and query plans.
• Checking for missing indexes, adding Clustered and non clustered indexes as required. Analyze and implement the best possible query plan
• Extensively used PL/SQL to extract data from different tables with Million records in some of the tables.
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Incorporated validation rules for promotion history table and updating tables.
• Identifying and automating repetitive tasks or processes to save time
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes

Environment: Oracle 8i, PL/SQL, SQL*Plus, Exp/Imp, SQL*Loader, Erwin, SQL developer tool.