SUMMARY

• Business System Analyst with 8+ Years in Software Development life cycle(SDLC), business and functional requirement gathering, analyzing requirements, business process design and software validation.
• Extensive experience as a Business System Analyst for Business Analysis with hands - on project management skills in user requirement gathering and transforming Business requirements into Software Requirement Specification (SRS) using MS Office Suite,MS Visio,Rational Rose Suite and proficient in project Management responsible for the software Development Plan.
• Ability to work cross-functionally with various stakeholders and team members and Identifying-Solving Business Problems and implementing appropriate technology solution.
• Strategic Competencies to support complex Business Analysis.
• Specific software experience includes Office 365, MS SQL, MS Office, MS Exchange Server, MS Outlook, Windows Advanced Server 2012, Office ProPlus, Skype for Business.
• Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects.
• Expert in creating UML diagrams including Use cases, Activity/state chart diagrams, Flow charts, Sequence diagrams, Collaboration diagrams and Data flow diagrams using MS Visio.
• Experienced in conducting Joint Application Development (JAD) and Rapid Application Design (RAD) Sessions.
• Ability to analyze Request for Proposal, Progress Reports, Project Charter, and Business Case.
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements using User interviews, Workshops, Observation and Existing systems documentation/procedures, JAD, JAR, and Brainstorming sessions, identifyFunctional, Non-Functional, and Business Rules, and then subsequently model them.
• Exposure to Software prototyping techniques like Incremental/ Evolutionary Prototyping
• Experienced in analyzing and preparing Project Deliverablessuch as Business Requirement Document (BRD) and Functional Requirement Document (FRD)/ SRS and proposed changes for process improvement using Rational Requisite Pro.
• Efficient in making Requirement traceability Matrix, Mockups.
• Good Knowledge in developing and designing reports through SSRS and EXCEL.
• Expert at managing multiple projects simultaneously with excellent time management skill and meeting deadlines.
• Good Knowledge on Business Intelligence systems.
• Good Understanding of the ITSM and ITIL Processes.
• Good Knowledge in Insurance Products with billing, claims and crystal.
• Strong knowledge in Regulatory domain.
• Frequently collaborated with SAP transactional team for content management
• Managed various artifacts of numerous departments through SharePoint
• Handled admin account on SharePoint on several occasions
• Excellent team playerwith Result-oriented, Fast learner, excellent communication skills.
• Ability to gather requirement through Wish list and User Stories.
• Practical knowledge of Scrum Meetings, Business Model and Use Case Descriptive.
• Knowledge in Hyperion Financial Management Systems and POS.
• In depth knowledge of Property & Casualty (P&C) Insurance concepts.
• Good experience on Adobe Photoshop.
• Worked for property and casualty insurance Business and processes in both personal and commercial lines of insurance.
• Have Experience in designing and developing Databases in SQL Server 2012/2008/2005/2000 , Oracle 11g/9i/10gwhich includes the development of functions, stored procedures and triggers using Transact SQL and PL/SQL.
• Project management experience includes Client management, Customer interaction, and Scopedefinition; Project planning, and Change control, Integration and Release management.
• Ability to write Test Scenarios and Test Cases.
• Worked on Application Life cycle management(ALM).
• Good experience in Mortgage Banking.
• Involved in maintaining Test Matrix and Traceability Matrix.
• Good Experience in COTS.
• Worked as a SaaS (Software as a service) Business Analyst.

TECHNICAL SKILLS

Operating Systems: Windows 8, windows 7, Vista, Windows XP/2000/98/95, Linux

Databases & Tools: SQL Server, PL/SQL,UI/UX Design,MS Access, Oracle 10i/11g

Languages: C, C++, Java Script, HTML, CSS, PL/SQL, SQL and UML

Document Processing: MS PowerPoint, MS Project, MS Visio, MS Web, MS Excel, Office 365

Testing tools: Test Director, Win\ Load Runner, Quick Test Pro

Multimedia: Adobe Photoshop, Dream Viewer, MS office suite

Methodologies/ Frame work: Rational Unified Process (Rational Rose, Requisite Pro, ClearCase, and ClearQuest), Agile, Waterfall, JAD, Data Modeling, Business Modeling, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, and Class Diagrams, Agile/Scrum.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Business/System Analyst

Responsibilities:

• Developed and managed the formal SDLC implementation using Agile Methodology.
• Worked with Project Manager for creating detailed Project Plan and assisting in developing, scheduling and tracking project timelines, which helps in the attainment of project goals, and implementing corrective actions.
• Gathered, analyzed detailed Requirements from Business Users and documented Use Cases, Business Rules, created and maintained Requirements/Test Traceability Matrices.
• Assisted in creating Project Plan, Project Tracking, Designed Requirements Planning and Management document, Project Reporting.
• Maintained Audit readiness and maintained accuracy of software during all scheduled upgrades.
• Prioritized the gathered requirements and managed the requirements using Rational Requisite Pro.
• Prepared Workflow diagrams to analyze AS IS and TO BE scenarios, designed new process flows using MS Visio and documented the business process and various business scenarios.
• Conducted GAP analysis to regulate the gaps in the requirements and conveyed to various modules of the project.
• Provided technical support for Sprint Cycles and testing with Rally tool.
• Responsible for digital product development and execution of digital marketing programs for all digital self-servicing to expand digital capabilities.
• Liaison between business, technical teams and other stakeholders to identify business processes, systems, and product requirements to the 3rd party solution provider.
• Involved in Business Process improvement (BPI) to identify the operations that could be improved.
• Interact with internal partners, Enterprise services and support teams, the field sales organizations and Office 365 business groups in support of customer needs.
• Functioned in an Agile environment and used JIRA to track team progress and document various bugs.
• Work with other scrum masters in Scum of Scrums facilitating continuous process improvements.
• Maintained documentation in support of business processes, as well as managed the gathering and documentation of business requirements to help design and develop new processes and improved LMS.
• Performed accounting functions, such as accounts receivable, and payable, payroll, monthly financial statements, balance sheet, cost analysis, and account reconciliation.
• Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule.
• Managed software artifacts for the suite of investment products such as Online Banking and Brokerage, BIDS, Insurance etc.,
• Assessed the current environment and made recommendations to decrease vulnerabilities via risk mitigation as appropriate.
• Responsible for execution of all digital channel products to enable cardholders to better self-service online, deflect contacts into call centers, and increase retail partner sales and credit opportunities through closer digital integrations.
• Daily Matrix report creation based on application usage across the Organization, Create the project support related documents, Update and Maintain Project Cycle Management (PCM).
• Observe the standards and procedures established by the project office and Track business needs during development phases in Business Life cycle.
• Involved in the periodically held JAD sessions for the purpose of project updates as well as involved in the weekly meetings to discuss the current project status.
• Involved in Data base design, writing stored procedures, functions, views and triggers. (T-SQL) on SQL Server2012.
• Responsible for developing monthly reports on database needs and issues.
• Assisted several important teams in backing up financial projections with real data.
• Developed testing strategies and verification scenarios and assisted the Testing team to understand the Business process and the BRD (Business Requirements Document) and System Requirement specifications (SRS) and Data Requirements Document (DRD).
• Prepared test case document and came up with a testing strategy fortesting the Banking Application by analyzing the Business requirementsand theAccounting, Budget, and Procurement systems.
• Involved inmanual, functional, system and regression testing in an agile development environment, data using SQL Queries manually.
• Worked on creating POC's for portals using Oracle Webcenter 11g Portal Framework and Oracle Composer 11g with respect to customization.
• Used TFS for source code control, project related document sharing and team collaboration.

Environment: Client servicing, User monitoring, Blueprint, MS project, User acceptance testing (UAT), Rational clear case, Clear quest, Use cases, UML, Office 365, MS Office, Requisite Pro, Excel, SQL Server 2012, JIRA,TFS.

Confidential, White Plains, NY

Sr. Business/System Analyst

Responsibilities:

• Wrote test plans and test cases based on the business requirements which involved market risk analysis, structured products, documentation, value at risk, risk and return optimization.
• Worked on Agile Methodology for the software implementation.
• Work with Product Owner and Scrum Team to create user stories.
• Documented the Business Requirement Specifications and developed the requirement Traceability Matrix.
• Used SAS Visual Analytics to generate SAS Dashboard, reports and analytics.
• Interface with the vendors for gathering requirements and development of application documents.
• Involved in handling the work flow between different departments such as accounts payable, procurement and audits.
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Detailed design of some of the key aspects of the accounting application.
• Developed requirement reports for day-to-day to reduce duplicity of work.
• Involved in documenting the requested changes and to ensure that no unnecessary changes are made (Change Management).
• Worked with cross functinal teams to generate backlogs,capture them in JIRA, and work against the committed backlog items for the scheduled sprint.
• Worked directly with the project managers, and Internal security team to ensure clear communications on requirements and defect reports.
• Prioritize requirements and negotiate on deployment timeframes on behalf of the development team along with Data analysis.
• Prepared quarterly financial plans, monthly forecasts and actual reporting.
• Involved in writing complex SQL Statements to validate data and ensure system integrity and security in SQL Server 2012(T-SQL).
• Developed Stored Procedures, Functions, T-SQL Queries, Indexes and Triggers in SQL Server for fetching Transaction details, Customer Details, and Product Configuration data.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Implemented test procedures and testing methodologies, wrote Test Plans according to Business Specifications and design documents.
• Involved in manual, functional, system and regression testing in anWaterfall development environment, data using SQL queries manually.
• Performed data validation, data integration, and database testing.
• Monitored progress against business functionality, requested objectives to ensure that projects meet the specific release criteria .
• Involved in Data feeding using SharePoint and custom creations for data analysis in Excel, Access and SAS.
• Used Microsoft team foundation server (TFS) for version control and file sharing.
• Managed the accounting for Atlas Group Cash accounts.

Environment: Client servicing, User monitoring, MS project, User acceptance testing (UAT), Rational clear case, Clear quest, Use cases, UML, Office 365,MS Office, Requisite Pro, Excel, JD Edwards, SQL server 2012,TFS,JIRA.

Confidential, Armada, MI

Sr. Business/System Analyst

Responsibilities:

• Collected the requirements from business users and analyzed based on the requirements.
• Used Agile Product Lifecycle Management (Agile PLM) tool to drive product innovation process.
• Created FRS (Functional Requirement Specification) accordingly.
• Planned and defined system requirements to Narrative use cases and Use Case Scenarios using the UML Methodologies.
• Created Use Case Diagrams and Activity Diagrams Using MS Visio.
• Created Wireframes to explain the requirements to the technical team.
• Conducted Interviews, to understand the client needs and gather and analyze the requirements as well as JAD sessions with stakeholders throughout SDLC to resolve open issues.
• Worked with Digital Operations and development to investigate new software and processes to standardize and automate reporting responsibilities and increase capabilities.
• Worked onERP (Enterprise Resource Planning) software for taking customer orders and keeping inventory records.
• Drafted and submitted proposals for change management plans.
• Enhance the regional business productivity by managing/supporting PLM systems and processes.
• Performed database operations on SQL Server2008 to create and maintain customer’s information by creating SQL queries, stored procedures, functions, and views.
• Contributed in creating ETL designs and provided end users an easy accession to data marts.
• Integrate new versions of EAI to maximize the organizational utility.
• Based on Business requirements extensively involved in developing Test plan and Test cases.
• Involved in Black box testing and user acceptance testing (UAT).
• Assisted the team by developing daily reports of defects and test case execution progress, and pro-actively helped analyze from systems and applications and contributed immensely in the development of User Acceptance Test plan including traceability, development of test scenarios and data, and execution of test cases.
• Program management experience, including cross team coordination, leading testing efforts andEnforcement of project deadlines.
• Developed functional specifications and system design specifications
• Generated prototype solutions and devise, build, test, and document end user computing by consulting with business partners concerning application and implementation of technology.
• Implemented Source control using TFS.

Environment: Agile PLM, Use cases, JAD, Interview, Clear Quest, Clear case, MS EXCEL, MS Access, MS power point, DOORS, MS Visio, BPR (Business Process Reengineering), MS Project, UAT, TFS.

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Assisted PM in preparing project plan, time lines, scope document, stakeholders and resource identification.
• Created a project initiation document with project scope, goals, and execution methods.
• Closely Collaborated with PLM Product Development Coordinators to re-engineer numerous business processes.
• Focused on gathering and documenting business requirements, use cases and providing our sales and marketing teams support during software demonstrations.
• Working directly with Scrum Master to follow agile processes of moving new application through multiple sprints.
• Worked with PM to prepare Project charter, Project plans, daily, weekly and monthly team deliverables for each phase, drafting WBS (Work breakdown structure)and RBS (Resource breakdown structure) systematically using MS Project.
• Participated in iteration reviews, retrospectives, sprint and release planning, demos and other Agile meetings.
• Conducted Joint Application Development (JAD) sessions with the development team to develop and understand the business requirements and created work flow diagrams using Visio.
• Articulated Business Requirements from user interviews then converted to Use Cases &technical specifications (SRS).
• Interacted with the customer and program team to evaluate and prioritize the stated user requirements and analyzed complex issues and provided comparative analysis of alternatives leading to a solution recommendation, action plan.
• As Subject Matter Experts(SME’s) of different divisions (Information Technology, Risk and Operations) and established a business analysis and design methodology around the RUP (Rational Unified Process).
• Created use case diagrams, activity and process/application work flow diagrams using Rational Rose to demonstrate the functional requirements.
• Performed aspects of the pre and post approval process for brokerage, annuity and life insurance trades.
• Utilized a variety of reporting tools such as SQL for querying underlying database tables and resolve data issues for Business Process Management.
• Involved in writing complex SQL Statements to validate data and ensure system integrity and security in SQL Server2008 (T-SQL).
• Tested and documented application bugs following major version upgrades of reporting and ETL tools.
• Performed User Acceptance Testing. Developed atraceability matrix to map where each Business Req. is mapped to Functional Req. and where each functional Req. is captured
• Involved in SDLC Process consisting of Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project.
• Periodic Meeting and matrix tracking to update and status along with cost of project. Weekly project period tracing with report analysis
• Rational Clear Case was used to manage all the changes and change requests in the projects. Clear Quest was used for the bug tracking.
• Assisted in development of training materials for new technology and process improvements.
• Clarified QA (Quality Assurance) with Mercury Quality Center and Tester team to identify issues and Reviewed test plans to make sure that all requirements will be covered in scripts and tested
• Worked closely with developer for schema design, database design and development and created process development documentation
• Coordinated in performing Unit testing and Integration testing.
• After successful development and testing of the product, participated in product release and deployment to end-user.
• Used Tortoise Sub Version (SVN) a free/open-source version control system.

Environment: MS Office Suite, Office 365,MS Visio, Windows XP, Win Runner, MS project, Excel, Dream Viewer, SQL Server 2008, SVN.

Confidential

Business Analyst

Responsibilities:

• Worked closely with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
• Using waterfall model did implementation of SDLC.
• Responsible for meeting with Business Process Owners and SME (Subject Matter Experts) and gathered requirements for creating the system using prototypes and document analysis.
• Develop and implement core supply chain functions of inventory management, materials requirements planning, launch management, and bill of material creation and maintenancefor both the lettuce and the hydroponic technology equipment production.
• Worked closely with business users and build up strategies to increase the client base profits.
• Created and maintained Requirements Traceability Matrix (RTM) and involved in system analysis and design.
• Involved in Data Mapping and Mining with ETL tools.
• Identified and defined actors, made use cases and grouped them and prepared data flow diagrams, activity diagrams, sequence diagrams, state transition diagrams in MS Visio.
• Worked with EHR (Electronic Health Records) to generate a complete record of patients.
• Performed database operations on SQL Server2005 to create and maintain customer’s information by creating SQL queries, stored procedures, functions, and views.
• Held walkthroughs with the developers and QA teams and communicated interface requirements, Manual testing knowledge with Query run.
• Used Rational Clear Quest to manage and track defects,prioritized defects with each build and made sure that they were communicated to the affected teams and make enhancement requests
• Described Business laws for the universal Compliance Engine, the Credit Suisse proprietary trade compliance engines.
• Maintained the requirements traceability matrix as linked to code in order to keep the clients and all the teams up-to-date with the current progress of the project.
• Worked closely with the QA - Quality Assurance team during the functionality testing and helped in the User Acceptance Testing.
• Validated the scripts to make sure they have been executed correctly and meets the scenario description.

Environment: Requisite Pro, UML, MS-Project, Share Point server, SQL Server 2005, Visio, Clear Case, Clear Quest.