SUMMARY

• 8 + years of experience in Business Analysis with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design, data mapping, business process re - engineering, object-oriented designing, unified modeling language (UML), SDLC methodology (RUP, Agile, SCRUM, XP) and project management in diverse domains like financial services banking, mortgage and insurance domain, very good team player with excellent communication and presentation skills.
• Experience working in all phases of Software Development Life Cycle (SDLC).
• Proficient in preparing Business Requirement Document (BRD), Software Requirement Specification (SRS), System Design Specification (SDS), Functional Specifications, Functional Specifications and User Manuals.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions with IT Groups and Conflict Management with Project team members.
• Expertise in supporting the projects with Effort Estimation, Risk Tracking, Decision Analysis, Defect Management and usage of Metrics to track Projects.
• Experience working with Rational Unified Process (RUP), SCRUM methodology, Use Cases, 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 static prototypes, Wireframes conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• 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 to Track, Document, Capture, Manage and Communicate the Requirements using ALM, Rational Suite.
• 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. Experience with Regression and Black Box Testing.
• Strong Experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Expertise in designing and developing Test Plans and Test Scripts.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools like Spotfire and Cognos. Proficient in designing multiple enterprise level Spotfire Analytical solutions
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Self-motivated, diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships.

TECHNICAL SKILLS:

Business Modeling Tools: UML Modeling using Rational Rose, UML, MS Visio, Lucid Chart

Requirement Management: Rational Requisite Pro, EMC Documentum, Caliber, MS Word

Testing Tools: HP Quality Center, Rational Clear Quest

Automation Tools: MOSS-2007, Rational Rose, Rational ClearCase

SDLC Methodologies: Rational Unified Process, Agile Methodologies- SCRUM, Waterfall

Languages: HTML, XML, PL SQL, SQL

Business Tools/Reporting tools: MS Project, TABLEAU DESKTOP 8.2, MS Visio, MS Excel, MS Word, MS PowerPoint, MS Access, Design Expert, JMP, Crystal reports, MS SharePoint

ETL tools: IBM Cognos, Tibco Spotfire, Informatica 7, Informatica 9.0.1Testing Tools Quick Test Pro(QTP), Requisite Pro, Test Director

PM Tools: Lean Management, SWOT, CBA, Clarity PPM, Impact, GAP, MS Project 2010, MS Office, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr Business System Analyst

Responsibilities:

• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Conducting user interviews for requirements gathering, analysis, and design.
• Created functional and non-functional requirement documents and technical specification documents and delivered within project timelines.
• Conducted user sessions, created user stories using the requirements gathered in user sessions.
• Used MS Visio to create GUI elements, Workflow Diagrams, Activity Diagrams.
• Facilitated JAD (Joint application development) sessions and walkthroughs between technical and regulatory teams for meeting requirements.
• Created high level list of user requirements (Product Backlogs) and prioritized the list of product backlog items (PBI’s).
• Created SharePoint workflows using SharePoint Designer 2010
• Organized and conducted product-planning meetings, sprint planning meetings, mid-week meetings
• Facilitated daily scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the s and issues.
• Created sprint burn down charts and release backlogs for effective Project Management
• Involved in reengineering of the application to increase performance and accuracy of the system
• Created classes and dimension and measure objects according to business requirements.
• Involved in System, Regression, Performance, Integration and UAT testing and documentation of the project life cycle
• Responsible to analyze and supervise the organizational function of data warehousing.
• Experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling.
• Extensive Experience in Creating Repository, Source, Target Databases for Extraction, Transformation and Loading (ETL) using Informatica.
• Created Spotfire Dashboard and visualization using Spotfire Professional.
• Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team

Environment: MS Office Suite, SDLC, Agile/Scrum, RUP, SQL Server, UML, MS Visio, Quick Test Pro, MS SharePoint, HPQC, Project Management, Tibco Spotfire

Confidential, Herndon, VA

Sr Business System Analyst

Responsibilities:

• Analyzed business needs/requirements, incorporating regulatory changes, ratings, re-engineering processes.
• Studied system feasibility and provided information to the stakeholders with benefits, cost savings and risks.
• Assisted the PM in preparing the WBS for the project’s workflow.
• Conducted Joint Application Development (JAD) sessions with business user subject matter experts (SME’s) to collect requirements.
• Wrote and executed clear and concise support documentation such as Test Plans and Test Cases.
• Analyzed the existing Conventional system and proposed SOA (Service-oriented architecture) approach for flexibility, quick response to changes in the business environment.
• Created Workflow scenarios, designed new process flows, documented the Business Process of the business from the conceptual to procedural level using MS Visio.
• Documented requirements, technical, help documents for the end user across the application stakeholders.
• Acted as a Scrum Master by creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings.
• Utilized SharePoint 2010 as an administrator for document management, version control and creating team dashboards on the team site.
• Created the Product backlog with help of user stories collected through requirements gathering and gap analysis.
• Created the data mapping document for the integration of existing credit card holders.
• Assisted in formulating test documentations like Test Plans, Test Cases and Test summary report.
• Involved in implementing IT security architecture in co-ordination with the Sr. Architect.
• Used Informatica to Extract, Transform and Load (ETL) data for the project.
• Communicated directly with Clients to understand their business needs and to resolve business issues.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Experience in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Analyzed cross-functional applications and met requirements for MIS reporting of cancellations, corrections and amendments performed on the existing systems.
• Performed analysis and design of product enhancements for rollout of the new application and established a business analysis methodology around the Scrum Methodology.
• Acted as a Scrum Master by creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings.
• Researched the various steps in the lifecycle and then constructed the system in such a way that the riskier claims could be easily identified and monitored.
• Data cleansing, data quality tracking and process balancing checkpoints.
• Collecting business rules, data mapping, template designing (included using SQL queries) for RMS reports and requirements for batch processing systems.
• Played a key role in the planning, User Acceptance Testing and implementation of system enhancements and conversions.
• This application was developed using Visual Studio.NET and Visual Studio.NET, VB.NET and ASP.NET.
• Worked with SQL queries to extract application data to perform application validations.
• Created models using Framework Manager in multiple namespaces by creating shortcuts, joins, star schema groupings, Calculations and filters.

Environment: Visual Studio.NET, VB.NET, ASP.NET, Oracle 11g, SQL, PL/SQL, Windows, MS SharePoint, MS Visio, IBMCOGNOS,MS Project, MS Office Suite (MS Word, MS Excel, PowerPoint), and Test Director

Confidential, Pittsburgh, PA

Sr Business Intelligence Analyst

Responsibilities:

• Responsible for creating UML diagrams (Use Cases, Activity Diagram, and Class Diagram) in order to capture the dynamic behavior of different applications.
• RUP and SCRUM was used as the hybrid methodology for software development focusing on its best practices; iteration, requirement management, uses component-based structure, visually model the software, verify quality and change control.
• Used MS-Visio for creating high-level process flow diagrams for management and mapping the logical aspects of the process.
• Responsible for creating and maintaining functional design document and deployment plan document.
• Facilitated and organized different meetings; planned and ad-hoc, within the team and with the stake-holders.
• Responsible for managing (logging, tracking, and closing) defects in ClearQuest
• Identified and Analyzed key potential Risks along with the entire Project Development Life Cycle, Developed Risk Mitigation Plan, and assisted PM in Risk Management..
• Performed Project planning & requirements gathering by using RUP methodology
• Created the following types of required documentation: Validation Specifications, Validation Plans, Functional Requirements Specifications, Installation Qualification Specifications, Functional Test Plans (OQ/PQ), Installation Qualification Summary, Functional Test Summary, Validation Summary, SOPs, Various Guidelines and Instructions, Change Control Documentation.
• Formulated the operational risk metrics and this involved coming up with plans for business continuity and technician methodologies.
• Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS).
• Conceptualized a new IT application to emphasize better internal controls on accounts payable and accounts receivable business processes.
• Created Business Objects by referring to the company’s customer database and logically grouping different business components.
• Maintained and kept track of stakeholder’s requests for enhancements and changes using Rational Clear Quest. Written SQL scripts to pull the data from the existing database based on the business rules.
• Conducted Risk Analysis such as VaR and Standard Deviation for different financial products used by the company.
• Worked with the data modelers, DBA's and QA teams to resolve issues to that of BRD.
• Created documentation for as well as the Help Desk teams.
• Developed Executive Dashboard reports, Spotfire workbook using Spotfire Professional
• Created dashboards, reports, analytics and advanced graphical virtualizations by using the key concepts filtering scheme, Data on demand, property controls etc.

Environment: Hyperion, Rational Rose, SQL Basic, Rational ClearQuest, MS Office, MS Project, MS Visio, spotfire

Confidential

Business Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts..
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Maintained and managed various versions of the documents generated during the project using Rational Clear Case and performed defect tracking using Rational Clear Quest.

Environment: Visual Studio.NET, VB.NET, ASP.NET, Oracle 11g, SQL, PL/SQL, Windows, MS Visio, MS Project, MS Office Suite (MS Word, MS Excel, PowerPoint), and Test Director.

Confidential

Business Analyst

Responsibilities:

• Facilitated collection of requirements from system users and preparation of Business/Functional requirement documents utilizing UML & RUP methodology to provide appropriate scope of work for technical team to develop prototype and overall system.
• Analyze and prioritize requirements and use them to outline timeline for completion of goals.
• Performed GAP Analysis with system functionality and existing Business Processes.
• UML and RUP process for productivity in communicating specifications to design & development team. Analyzed and designed Use Case Diagrams using UML/Visio.
• Managed scope and requirements throughout the project life cycle.
• Discuss and propose conversion / interface solutions with the clients and users.
• Performed Functional Testing, Integration Testing, System testing and Regression testing.
• Wrote Test cases, test scripts and test plans for UAT

Environment: Rational Requisite Pro, RUP, UML, SQL, MS-Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Visio and Crystal Reports.

Confidential

Business Analyst

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Conducted interviews with project managers, business users to collect requirement and business process information.
• Developed PowerPoint presentations for monthly meetings with upper management.
• Teamed up with Insurance advisors to perform market survey and learn client requirements to assist technical team in Software development.
• Participated in SLA (Service Level Agreement) writing for different financial products in banking application.
• Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
• Created Data Flow Diagrams, Activity diagrams and Use cases for the audit planning process.
• Coordinated in developing test scenarios, test cases and implemented test plan with QA team.
• Assisted in development of materials for new technology and process improvement.

Environment: UML, RUP, SDLC, Rational Requisite Pro, Rational Rose, Windows 2000, MS Office, MS Project, MS Visio.