SUMMARY

• 7+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Mapping and Data Modeling.
• Diverse experience in Banking, Financial Services and Insurance.
• 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.
• Experience with IBM WebSphere Business Modeler to understand and transform business through superior business modeling.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, 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).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, navigational flows, story boards, UI specifications and Sequence Diagrams.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• 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.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• 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, PLSQ

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

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 RequisiteProDocumentum

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 EXPERIENCE

Confidential, Waltham, MA

Sr. Systems Analyst

Responsibilities:

• Actively participated in all the phases of the life cycle
• Initiated the project with Gap Analysis and SWOT Analysis, followed by Framing document
• Planned and organized JAD sessions for drafting out the High Level Business Requirements
• Analysed BRD and created Systems Architectural Design Documents, Technical Flow Diagrams detailing Interconnections between the various Sub-Systems and their ability to handle various Failure Scenarios at each level.
• Drafted out the Work Flow diagrams, showing the cross functional dependency through SWIM lane diagrams.
• Create and review functional specification documents and organise signoff from the senior Business users and Directors
• Incorporated Rational Unified Process (RUP) and analyzed Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS) using Requisite Pro, Rational Rose and MS Visio.
• Reviewed with architect and technical team various technical design documents as well as input and output parameters for various web services.
• Understood the Business Process and the Functional Specifications of Web Sales process, Underwriting, Evaluation, Enrollment, Membership and Billing, Claims, and the Vendors Business Processes.
• Involved in the SDLC and Agile Methodology for various mid-sized projects simultaneously.
• Develop process models and use cases
• Work with project stakeholders to translate their requirements into something that developers can understand as well as to translate the resulting questions that the developers have into something the stakeholders can understand.
• Translate technical requirements - Break down technical and architectural complexities so that project stakeholders can easily understand issues that crop up.
• Apply rigorous Information Protection standards, define and design application functional and user interface requirements, develop use cases and test plans, involve with system testing, conduct testing validation.
• Assist the team in technical design and reviews of Code.
• Organized impacted systems into high, medium and low impact to help business analyze the level of effort for remediation activities and ease resource allocation work.
• Prepared and maintained requirements traceability matrix (RTM) throughout the project lifecycle.
• Create Test Scenarios using MS Excel
• Involved in UAT, executing test cases evaluating test results and preparing test summary reports Analyzed defects reported in test director.
• Assist in Development and Technical Issues
• Extensive testing - DIT, SIT and UAT
• Responsible for team leading of 25 people
• Set Objectives and do performance appraisals

Environment: MS Windows 7/XP/NT/ Server 2008, MS Project, Object-Oriented Architecture as front-end using Java/J2EE, XML, XSD, JSON, Mongo DB, VCMS (Video Content Media Suite - A Cisco Product), Cisco Search Engine, WEB-services, SOAP, RESTful Web Services, UML, SharePoint, Jira(Defect Tracking), MS Word, MS Excel, MS Power Point, MS Visio, SPLUNK.

Confidential, Columbus, OH

Sr. Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• 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
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program. Used Microstrategy dashboards for data analysis and custom reports.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005.
• Tested Performance & Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• 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
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Manage Scope and change throughout the SDLC process of the product.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• 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

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase

Confidential, Cleveland, OH

Sr. Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement
• Responsible for conducting research and root cause analysis for customers with the goal of recommending and implementing new processes and solutions to problems. Resolved issues and improve operational performance.
• Created Functional specification documents for the Agency and Membership system
• Created file layouts for the inbound interfaces and the outbound interfaces for the Agency and Membership system.
• Wrote Use Cases, prepared use case diagrams (using Rational Rose & UML) and followed Agile at every stage of the processes
• Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Demonstrated experience in Business Intelligence and/or MDM efforts through all phases of the project lifecycle (scoping, planning, requirements gathering, design, developments, testing, go live, and production support.)
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
• Involved in the day-to-day implementation of the Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Developed the Business Crosswalks for 837(P, I, D), 835 and 276/277 according to HIPAA implementation rules.
• Conducting user interviews, gathering requirements, analyzing the requirements using Requisite pro.
• Responsible for customer interface, requirements definition, general and detailed design, testing, maintenance and training programs and managed requirements using Rational Requisite Pro
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Conducted analysis of HIPAA compliance and took part in discussions for designing the healthcare transactions to be HIPAA 5010 compliant.
• Analysed the impact of new HIPAA standards on targeted systems, processes, and business-associate relationships.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Lead the Business Intelligence standardization across operating units by promoting and enforcing our BI/Portal technology framework standards
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modelling.
• Extracted the data from SQL Server, Oracle, Files, and Access into Data warehouse.
• Translate business requirements and assist IT with the development of technical specifications.
• Developed complex forecasting tools using current technology/systems (Access, Excel, Monarch, etc.)
• Recommend solutions based on data analysis to increase business efficiency and/or improve existing processes.
• Conducted User Acceptance Testing (UAT) for projects, implementations, system fixes and enhancements, etc

Environment: Clarity, IBM Mainframe (VSAM, COBOL, JCL), FTP Client, MS Access, MS Visio, RUP, OOAD, SQL, Agile, Scrum, MD 3270 Mainframe, MS Excel, MS Office, HP Open View, Windows XP

Confidential, Chicago, IL

Business Analyst/Data Analyst

Responsibilities:

• Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• 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.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Followed the adaptive RUP framework for the whole Project life cycle (PLC)
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript.
• Generated XML documents using the XML Output Stage.
• Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and Microstrategy layer.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• 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.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), IBM WebSphere, XML, Java, J2EE, Oracle, MS Visio, JAD, UAT, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Cleveland, OH

Business Analyst/QA Analyst

Responsibilities:

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Performed data analysis and ran various SQL queries to critically evaluated test results
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Designed and developed Project document templates based on SDLC methodology.
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• 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.
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Worked with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, JAD, UML, SDLC, Windows XP, DreamWeaver, SQL, PLSQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, UAT,WinRunner, LoadRunner