SUMMARY

• Analytical, enthusiastic and innovative Business Systems Analyst with about 7+ years of diverse experience in all phases of Software Development Life Cycle (SDLC) chiefly in requirements, analysis/ design, Agile methodology, testing and deploying business processes and system solutions.
• Over 4+ years of extensive experience in re - engineering of Web- Applications with proven ability to articulate business values, Data Integration and Data Warehousing using Informatica Power Center and Oracle PL/SQL.
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP).
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Experienced in RAD, RUP, Agile, Waterfall development methodologies, object-oriented programming (Java, HTML, XML, JavaScript, C++, JSP, Servlets), procedural programming (C), SQL and OOAD principles
• Develop CRM applications using Salesforce. Developed Claims support PL/SQL, T-SQL administrative Packages.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Familiarity with programming languages like .Net, XML, JSON and XML Web Services (SOAP, WSDL, and UDDI) and Service Oriented Architecture (SOA) with MS Visual Studio development platform (WCF).
• Good understanding of SOAP web services, WSDL, XML. Experienced in using SOAP UI.
• Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case, State, Activity, Class and Sequence diagrams using Rational Rose.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive experience in configuring data mapping between different Databases.
• Extensive experience with Content Management tools such as Interwoven, FileNet, SharePoint and Documentum.
• My duties were included designing the model of ODS to automate and maintain the ETL process
• Extensive use of VBA to fine tune and add value in projects.
• Newsletter Excel-VBA coding Competitive Intelligence Dynamic Dashboard Designing
• Used ERwin 4.0 to capture data by creating Entity-Relationship and Use Case diagrams.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Well-versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• Strong knowledge in creating test cases, test plans, and performing User Acceptance Testing (UAT).
• Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis.
• Working knowledge of Excel, Outlook, Word, Siebel, NetX360, Transaction Portal, and other TIAA-CREF software.
• Successful as a team player to work in conjunction with other DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects especially with Test Director.
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. Business Systems Analyst

Responsibilities:

• Gathered Business Requirements, interacted with the stakeholders, developers, Project Manager and SME's and facilitated JAD sessions to formulate Business Processes.
• Gathered requirements from the Product Owners in form of User Stories broke them down in tasks in coordination with the scrum team.
• Requirements Analyst for Delivery Solutions, this was an agile environment using Acceptance test driven development as well as Gherkin test scripts. Led and facilitated iterative application development meetings with cross-functional requirements and design teams.
• Worked with Business Users, Customers and Subject Matter Experts (SMEs) using agile methodology to understand the existing system and the current business process and methods to identify deficiencies and areas for improvement and enhancement.
• Utilized Rational Unified Process (RUP) and Agile and Waterfall methodologies to configure and develop process, standards, and procedures.
• Prepare process flow diagrams, Data Model diagrams, BRD and FRD based on the inputs from the project workshops and sign offs from the various stakeholders for the Waterfall, Agile projects.
• Identified Use cases from the requirements and wrote Use Case Specifications.
• Created Business Requirements Documents (BRD) and Functional Requirements Specifications (FRS) documents.
• Created test cases for System Testing (Development Environment), Integration Testing (UAT) in Agile/Scrum environment.
• Helped teams to adhere to the SCRUM framework, agile best practices, and process improvement opportunities.
• Conducted interviews with various business users to collect requirement and business process information and documented them using MS Visio.
• Configured and administered JIRA as the team's agile management tool.
• Collaborated with the integration team to define data requirements and structure of the XML data feed in order to meet software requirements
• Acted as the primary liaison between the business stakeholders and technical teams to make communication and development efforts more effective.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Conducted daily Scrum meeting, as well as sprint planning and sprint review meeting.
• Conducted formal and informal Sessions to develop an architectural solution that the application meet the business requirements, resolve open issues, and change requests.
• Create user stories for software development team in agile environment.
• User Stories creation with BDD (Behavior Driven Development) using Gherkin test scripts.
• Follow SCRUM practices for delivery in agile environment maintaining critical documents such as product backlog, sprint backlog.
• Worked on java code with the developers to verify table and column names from the database to be transferred.
• Involved on test planning, test cases and test scenario creation, test case execution, defect reporting, reviewing, test data preparation and Conducted defect meetings with developers to walk-through each defect in detail for quick resolutions/fixes.
• Executed test cases and tracked defects/issues into Quality Center and notified management with details.

Environment: Windows, VB, Agile Scrum, MS Excel, ASP, JSON, C#, XML, Java, JavaScript, Oracle 8, Gherkin, Rational Requisite Pro, Business Objects, SOAP, Rational Rose, GUI, MS Visio, Test Director, SAP.

Confidential - Wellesley, MA

Business Systems Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Specified quality client services including on inquiries, utilizing elements for project cost control, and performing P&L analysis against forecast and budget.
• Implemented knowledge of Distributed Web Services/ Enterprise / Web / Client- Server systems using XML and SOA Web services.
• Worked with the SME’s to define business critical needs and analyze the possible technical solutions.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Developed User Stories, Use Cases, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams using modeling tools to comply with industry standards (Microsoft Visio, Power Designer, Smart Draw)
• Creating Excel based automated Templates using Access and Excel VBA for MIS processing.
• Understanding stake holder’s requirements and creating new reports for their business needs.
• Captured and tracked Business and Functional requirements, data flows, developed Use Cases, wireframes, Process Flows, Data Modeling and Flow Diagrams, and documented Systems Specifications using RUP methodology.
• Understanding of RWA (Risk Weighted Asset) under Standardized and Advanced Basel approaches. Ability to calculate RWA from Market/Credit exposures.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Develop and maintain Portal leveraging WebLogic Portal Design, C, C++, Java and JavaScript.
• Created DataStage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Use Cases and other Process Flow Models were designed using MS Visio and Rational Rose.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Performed business analysis and project management activities. Actively practiced agile development methodology; facilitated all-day workshops with key business leaders to validate various business process models. Participated in daily stand up meetings and led scrum meetings.
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.
• Worked in developing CRM applications and Apex Interactive reports and Forms for Annual Summary Reports and CRM reports.

Environment: Rational Suite (Rose, Requisite Pro), Windows, SQL, XML, HTTP, Agile, MS-Project, MS-Office Suite, SharePoint, MS Visio, Power Designer, Win Runner, Gherkin, Erwin, JavaScript, JSON, XML, Dbase3, DOS and UNIX Sequential Files, SOAP, MS Access, HTML, Load Runner, JavaScript, Test Director (Mercury Interactive), Java, Oracle

Confidential, Chicago, IL

Business Systems Analyst

Responsibilities:

• Gathering requirements from business subject matter experts using various methodologies such as interviews, questionnaire, reverse engineering, JADs, prototyping, RFPs.
• Actively involved in validating the requirements and applying the RUP framework throughout the SDLC.
• Conducted JAD sessions between the end users and the development team. Worked with the software architects / developers to ensure that the applications confirm to customer requirements.
• Used Rational Unified Process (RUP) for streamlining the team's development activities.
• Review Business Requirement Documents and Business Analyst documentation for upcoming software changes. Write test plan. Develop test cases and SQL code for DB2, Oracle and Teradata applications. Utilize Quality Center to store and execute SQL code.
• Followed the Agile methodology for the entire SDLC.
• Worked closely with developers for analysis of the application.
• Supported theAgile/Scrum process within IT. Coordinate activities for on-time delivery of critical projects and programs. Mitigate the risks associated with a project early on by discovering problems and solving them
• Detail the user stories in gherkin language to include description of the requirement, user acceptance criteria, system validation and business rules.
• Created User Acceptance Test Plan and coordinated UAT for the site redesign project
• Extensively worked with Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Analyzed business and user needs, documenting requirements.
• Responsible for measuring the impact of product and marketing recommendations especially as it correlates to channel profitability analysis and overall revenue.
• Formulated and defined systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements following RUP.
• Conducted Cost benefits analysis and return on investments.
• Provide in-depth knowledge of loan products/programs to increase profitability.
• Involved in customer communication management, web-content management, digital asset management, forms processing, and compliance management.
• Coordinated with UX team to ensure content management submission guidelines were followed in addition to ensuring site compliance as per corporate web design standards.
• 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.
• Conducted daily scrum meetings with the development and the creative team to track the progress of the project and assign due dates for the deliverables.
• Wrote user stories in Team Foundation Server (TFS) using gherkin and conducted manual testing for both web application and mobile application.
• Helped managing project envisioning activities including the execution and documentation of project definitions, scope, deliverables, business analysis, acceptance criterion and team structure and budget.
• Participated in all testing phases - Functional (SOAP UI Webs Service Testing) through User Acceptance Testing ensuring solution is implemented as per business requirements.

Environment: Windows, Oracle 8i, MS Access, MS Office, MS-Project, Rational Rose, Agile Scrum Requisite Pro, SOAP, Clear Quest, RUP, UML, Mercury LoadRunner, .NET, JSON,MS Visio, Gherkin, JavaScript, Content Management Team Foundation Server (TFS), MS-SharePoint, Confluence.

Confidential, Indianapolis, IN

Business Systems Analyst

Responsibilities:

• Facilitated JAD sessions and design meetings with the Stakeholders, SME’s and Leads of Interfaces.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Actively conducted and participated in all the scrum ceremonies such as scrum planning meetings, scrum estimation meetings, daily scrum meetings, sprint demos and retrospective meetings
• Successfully used agile/scrum methodologies for project tracking and bi-weekly deliveries
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Planned and defined system requirements to WireFrame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Played key role in defining test automation procedure and standards, creating Win Runner and Quick Test Professional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
• Reading and modifying XML s based on the data dictionaries and mapping documents
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc. - Visio, Rational Tools, Traceability Matrixes.
• Gained knowledge on end to end Client's (Dailysis provider) value chain.
• Interacted with different stakeholders like Product Manager, OnshoreBusiness Analyst, Customers and Project Managers to elicit and manage requirements.
• Prepared UAT scenarios and conducted UAT testing.
• Conducted daily scrum meetings with the development and the creative team to track the progress of the project and assign due dates for the deliverables.
• Performed after Action/Post Milestone Reviews and quality reviews to ensure that developed software products met the business needs and are in compliance with RUP and CMMi 3.

Environment: Windows, Oracle, PL/SQL, MySQL, SOAP, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, JavaScript, MS Visual Source Safe, AGILE, JSON, Interwoven Test Director 7.6, Quick Test Pro (QTP)

Confidential, Oklahoma City, OK

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis of the workflow model.
• Work with trading desk daily in order to streamline pricing processes for all collateral
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Conducted interviews with end-users to collect requirement and business process information.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows
• Developed business process models in RUP to document existing and future business processes.
• Designed and developed project document templates based on SDLC methodology.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.
• Developed business requirement specification documents as well as high-level project plan.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
• Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts.
• Relieved pressure off the PM by maintaining artifacts and portions of the project binder.
• Documented and delivered Functional Specification Document to the project team.
• Helped prepare and document the request for information and request for proposal
• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Maintained configuration and change management using BMC Remedy Atrium
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Conducted User Acceptance Testing (UAT).

Environment: MS Office Suite(Word, Excel, Access, PowerPoint),Windows, .NET, AGILE, T-SQL, Enterprise Architect, ITIL, SQL, Crystal reports MS Project, Rational Test Manager, BMC Atrium CMDB Enterprise Manager, Data Stage.