SUMMARY:

• Business/Requirement Analyst with seven years of experience; proven to work with tight schedules and deadlines.
• Strong knowledge of business/process dataflow in organizations and experienced in data ware housing.
• Expertise in data ware house modeling during project blueprinting and implementation cycle.
• Strong knowledge of business content data sources, extractors and post processing of data sources by various tools.
• Acquaintance with Extensive configuration and extension of Generic extraction and LO Cockpit functionalities.
• Extensive experience working on Ad - hoc report with the collaborating teams.
• Capable of Open-Hub and InfoSpokes configuration and Data extraction through DB and UD Connect.
• Experience working on Gherkin for Documentation and later on helpful for automated testing, mostly in Agile environment.
• Worked on Process chain management and Production support as an Analysis Process Designer.
• Experience in process modeling using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, and Data Modeling using Erwin.
• Excellent experience with different languages such as SQL, PL/SQL, HTML, XML, etc., Web Services, Windows and Reporting tools like tableau, IBM Cognos.
• In depth understanding of the business process modeling and experience in converting these requirements into technical specifications for preparing test plans.
• Extensive experience in MS office: Word Processing, Excel Spreadsheet, MS PowerPoint, MS Access MS Visio and Ms Project software.
• Experienced with business reviews, functional and system level requirements reviews, and design reviews.
• Possess sound knowledge of various Software Development Life Cycle (SDLC) methodologies such as Waterfall, Agile, Rapid Prototyping and the Rational Unified Process.
• Experience in the documentation of system and business requirements and specifications, design and development of use and test-case scenarios and root-cause analysis, GAP analysis, developing test plans, test scripts using SQL, conducting System Integration testing (SIT), user acceptance testing (UAT), training, and implementing new processes and technology.
• Excellent organizational, communication and interpersonal skills while being Self-motivated, adaptive and able to work in a team or independently in a deadline-driven environment.

TECHNICAL SKILLS:

Methodologies &Concepts: RUP, Agile, Waterfall, Wireframes, UML, Root cause Analysis, Segmentation, Project Management, Projection, Forecasting analysis.

Testing Tools: Rational Enterprise Suite, WinRunner, LoadRunner, Quick Test Professional

Business Applications: MS Office suite, Star Office suite, Gherkin Documentation

RDBMS: Oracle 8i, 9i, 10g, MS SQL Server, MySQL 5.6, MS Access

Version Control Systems: Rational Clear Case, PVCS.

Project Management: Microsoft Project, Microsoft Office.

Programming Languages: SQL, PL\SQL, Visual Basic, HTML, XML

Databases: Oracle 8i/9i/10g, MS SQL Server, MS-Access, IBM DB2

Web Technologies: Microsoft FrontPage.

OS & Server Environments: Windows NT,XP 95/98, Outlook, Unix, Oracle Application Server, Oracle Web Server, IBM Websphere Application

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Business Consultant

Responsibilities:

• Played the role of a Requirement Analyst in a RUP environment by eliciting Business Requirements from business users by conducting various meetings.
• Maintained and kept track of stakeholders request for system enhancements and changes.
• Used Rational Requisite Pro to analyze and document requirements.
• Prepared Wireframes using MS Visio for User Experience design.
• Used Test Director for essential aspects of test management, Test Plans and Defects Management.
• Worked with development and testing teams to accomplish timely release objectives.
• Analyzed the system functionality in relation to impacts of the change requests and other system modifications.
• Documented the change requests providing the reasons and root cause of change while conducting Root Cause Analysis.
• Created and Modified the Use Cases for the incoming change requests and system enhancements using MS Visio.
• Developed the test conditions and test cases to be used in testing the system based on business requirements, technical specifications and/or product knowledge.
• Reported reports weekly, monthly using IBM Cognos, as per the team and client requirements.
• Controlled and tracked defects and change requests using Test Director.
• Used Test Director to create reports and graphs to help review the progress of planning tests, running tests, and tracking defects.
• Designed screen mockups for changes in system functionality using MS Visio and MS Paint etc.
• Prepared data analysis, reported using IBM Cognos and wrote Test Scripts using SQL on quotes and claims data.
• Provided ROM for various projects and system enhancements.
• Worked with accounts team to analyze the financial risks.
• Reviewed test objectives to make sure that all the possible scenarios causing no risk, are tested for the system enhancements.
• Documented Meeting Minutes of various meetings and Brainstorming Sessions.
• Prepared test plan to accomplish timely release objectives.
• Developed project delivery schedule, managed projects and identified resources to successful completion.
• Have excellent technical writing skills with self-motivation and punctuality.

Confidential, San Diego, CA

Business & Requirement Analyst

Responsibilities:

• Prepared use case models based on Business Requirement documentation gathered through interaction with users.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Performed Data analysis and Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Followed the UML based methods by using Visio to create Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Involved in creating and enhancing requirements, analysis and design using Rational Tools (Rational Rose, Rational Requisite Pro, Rational Clear Case, and Clear Quest).
• Analyzing and creating user requirements document for companywide reports by interacting with end users and developers.
• Involved with data ware house modelling and designs.
• Participated in designing the data warehouse facts and dimensions.
• Analyzed the concepts of data ware house modelling with the project team.
• For Data Analysis interacted with the developers and defined the needs to update the design of the Graphical User Interface.
• Participated in various meetings, discussed and proposed required Enhancement and Modification Request issues.
• Responsibilities also included analyzing and testing the user interface and constantly redesigning the system to increase its user friendliness for the clients.
• Worked on status checks and Ad-hoc reports, documented and tested using Gherkins.
• A major responsibility included interacting with the users and business relationship managers and implementing changes on the database in order to ensure UAT approval.
• Got appreciation for excellent communication, risk analysis and managerial skills at work with technical, non-technical and clients.

Confidential, Los Angeles, CA

Business Analyst

Responsibilities:

• Gathered requirements through interviews, meetings, and existing documentation.
• Set up meetings, conducted Walkthroughs, JAD sessions with Management, SME (Subject Matter Experts), vendors, users and other stakeholders to flesh-out issues and to resolve open and pending issues and to develop specifications.
• Identified and refined scope -- developed scope documents
• Analyzed and documented current state workflow and developed future state using MS Visio, Rational Rose
• Analyzed the requirements and created the Use Case Diagrams, Activity Diagrams, Sequence Diagrams, flow diagrams in Visio for data analysis.
• Conducted gap analysis between existing and future state systems
• Created and managed project templates, requirement types and traceability relationships in Rational Requisite Pro.
• Developed Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace each software requirement to test case.
• Worked on RW2 and Gherkins for documentation and testing of the requirements on the terms of the project criteria.
• Created mapping documents for integrating various systems through a common interface.
• Worked in cross functional teams to identify and resolve issues posed by integration.
• Worked on wire frames, screenshots to develop UI specifications.
• Logged required technical enhancements, defects, and resolved requirement issues, in Excel.
• Involved in extracting and transferring data with data ware house team.
• Participated in team meetings for data ware house concepts, facts and dimensions.
• Worked gathering requirements and used Gherkins for documentation and automated testing for data analysis in simplified notions.
• Assigned problems to appropriate software development team for fixes and resolved requirements issues.
• Attended weekly status reports for project planning and data analysis.
• Checked Test Cases and developed strategies with testing team to track and resolve defects.
• Conducted familiarization, training sessions for business users.
• Involved in Financial team audit discursions to analyze the financial risks and suggested required changes.
• Excellent communication skills and problem solving skills with the clients and non-technical persons.

Confidential, Stevens Point, WI

Sr. Data/Business Analyst

Responsibilities:

• Gathered and analyzed Business Requirements, created Functional Requirements Document (FRD) and analyzed data/workflows; defined the scope, financial projections and cost/benefit analysis; progressed from Problem Statement to well-documented designs.
• Used RUP-iterative process to Conduct Data Analysis on the Group Disability Data to find missing data fields in the application and customize those using B2B/B2C internet portals of the website.
• Followed the UML based methods by using Visio to create Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams with swim lanes.
• Used MS Word & Visio to document data flow of the AS IS process and TO BE process.
• Conducted JAD sessions to get SME’s input on how to implement the application for Group Disability Claims.
• Gathered Business requirements for Integration points and mapped them with Functional requirements. Extensively used MS Excel
• Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Conducted market research for a state, territory, or market segment and been part of audit sessions with finance team.
• Worked with Cognos reporting team and trained for better customer support.
• Worked on RW2 with the requirements in required scenario of the project.
• Analyzed Business Requirements from Black Box testing perspective; reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.
• Created sample Wire frames to make system better understandable data analysis to Business and technology teams.
• Got appreciated for easily adaptable nature and self-motivated attitude.

Confidential

SQL DEVELOPER/DATA ANALYST

Responsibilities:

• Monitor the Database for duplicate records.
• Merge the duplicate records and ensure that the information is associated with company records.
• Resolve the data issues by following up with the end user.
• Coordinate activities and workflow with other Data Stewards in the firm to ensure data changes are done effectively and efficiently
• Review and analyze the database to identify and recommend adjustments and enhancements, including external systems and types of data that could add value to the system.
• Extract the data from database and provide data analysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to report data in the format requested
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Wrote T-SQL Scripts to manipulate data for data loads and extracts.
• Utilized several Transformations like Lookup, Aggregate, Conditional Split, and Derived Column for implementing the Transformation Logic in the Packages.
• Ensured better results using Ad- hoc reports.
• Created Stored Procedures, Tables, Functions, and Triggers in SQL Server 2008.
• Analyze the large datasets to draw key marketing insights from the dataset results.
• Assist with end user in training.