SUMMARY

• Business Systems Analyst with over 6 years of extensive experience in requirements analysis, data analysis, and business process improvement, including work/process flow analysis, functional analysis and documentation.
• Understand the business users' requirements and communicate them to the rest of the data warehouse team.
• Basic understanding of Financial Markets, Capital Markets, Money Market, Derivative Market etc.
• Experience in documentation of User Requirements, as well as organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
• Experienced in analyzing and understanding business processes and procedures to make recommendations in improving design process.
• Strong understanding of Risk, Gap, market and Cost/Benefit analysis.
• Expertise in reviewing Test Procedures, creating Test plans, defining System & Integration Test Cases, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT), analyzing bugs.
• Good experience in Data Analysis, Data Migration, Data Cleansing, Transformation, and Integration.
• Expert Microsoft Excel support for business with services such as macros, pivot tables, Vlookups, templates, charts and graphs, automation.
• Experience in performing data analysis and data profiling using SQL on various source systems including Teradata.
• Experience in working with Business Intelligence tools like Cognos, Qlikview, Microstrategy, and Tableau.
• In - depth knowledge of business analysis modeling using UML Diagrams such as use case diagrams, class diagrams, activity diagrams and sequence diagrams using Rational suite and Microsoft Visio.
• Creation, Adaptation and Deployment of Software Development Methodologies such as Agile Methodologies, Rational Unified Process (RUP) and Spiral Method.
• Worked with developers to communicate the critical defects for quick remediation and helped technical team to understand the business problems
• Experience working on Agile methodologies.
• Familiar with Data Import and Data Export using various ETL tools including Ab Initio and Informatica.
• Strategic and analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that have eluded resolution by others.
• Proven multi-tasking capabilities with ability to plan prioritize and manage complex projects under aggressive timelines.
• Excellent at developing and maintaining strong relationships in a variety of business environments.

TECHNICAL SKILLS

Business Analysis: Rational Unified Process (RUP), COTS methodologies, Agile development methodologies, Universal Modeling Language (UML), Process Engineering/ Reengineering, RAD/JAD, Requirements Analysis, Systems Analysis, Use case development, System Development Life Cycle (SDLC).

Business Analysis Tools: Rational RequisitePro, Rational DOORS, Rational ClearQuest, Rational ClearCase, Enterprise Architect, Business Process Modeler.

Business Intelligence Tools: Cognos, Qlikview, Tableau, Microstrategy.

Testing Tools: Load Runner, Win Runner, Test Director, Mercury Quality Center.

Data Modeling: Star-Schema modeling, Snowflake-Schema modeling, Pivot tables, Fact and Dimension tables.

Project Management: MS Project.

Workflow Tools: MS Visio, Excel, Word, PowerPoint.

PROFESSIONAL EXPERIENCE

Business Systems Analyst

Confidential, San Francisco CA

Responsibilities:

• Acted as the primary liaison between the client departments and the Information systems department and interact with internal as well as external clients, to collect requirements and business process information
• Successfully used Agile/Scrum Methods for gathering requirements and facilitated user stories workshop.
• Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications
• Knowledge working with Jira in creating and managing stories.
• Analyzed functional and non-functional categorized data elements for data profiling and mapping
• Performed data profiling for various sources and successfully answered business questions by providing appropriate data to business users
• Followed a structured approach to organize requirements into logical groupings and developed Business Requirement Documents (BRD) from essential Business Process, Business Rules, information needs and insured that critical requirements are not missed
• Developed Use Cases, Use Case Diagrams, UML Diagrams, Activity Diagrams & Sequence Diagrams
• Involved in Teradata SQL Development, Performance Tuning, and Unit Testing to resolve testing issues using defect reports
• Involved in various data mapping activities from source systems to Teradata
• Interviewed functional area users to collect functional requirement and business process information and facilitate meeting sessions with the Subject Matter Experts (SMEs) from various business areas
• Facilitated (JAD) Joint Application Development sessions to identify the business rules and requirements and then documented them into a well format that can be reviewed and understood by both business people and technical people
• Facilitated User Acceptance Testing (UAT) and test strategies with developers and testers and performed manual front-end testing to check all functionalities of different modules
• Participated in performing detailed non-functional requirements analysis, including usability, reliability, performance, and scalability. Transformed business requirements to technical models
• Coordinated with the business partner to define adequate funding for the project
• Prepared test cases for User Acceptance Tests (UAT) and designed test plans for system integration testing phase
• Worked with the team to validate the developed application will meet the business requirements
• Presented the application walk through to higher management, business partners, and project managers

Environment: Agile/Scrum, Jira, Rational Requisite Pro, Rational Rose, MS Visio, Test Director, Teradata, SQL

Business Systems Analyst

Confidential, Atlanta, GA

Responsibilities:

• Evaluated Rational Unified Process workflows and designed more efficient, accurate and productive process providing a disciplined approach assigning tasks and responsibilities within a development organization.
• Studied the best practices for software development including an iterative, incremental lifecycle, the use of the Unified Modeling Language, Architecture centric, Use-Case driven approach
• Involved in Domain Analysis which includes ‘As is' and ‘To be' systems study
• Major involvement in requirements elicitation, documentation and management process
• Responsible for creating Vision, Use-case specification, Software Requirement Specification (SRS)
• Use-case realization and Supplementary specification documents
• Assisted DW (data warehouse) data analyst in analyzing existing reports, identifying iteration metrics, and mapping task
• Hands-on experience in creating and analyzing reports using Qlikview
• Strong understanding of ETL processing methods, underlying data warehouse data models, security, and capabilities of the front-end delivery products
• Assisted in testing ETL mappings and sessions based on business rules and business user requirements to load data from source files and RDBMS tables to target tables
• Assisted in creating Software Development Plan (SDP), Glossary and Iteration Plan
• Identified Functional and Non-Functional requirements, Created Process Work flows and final Design
• Knowledge on Quality Center and Application Lifecycle Management (ALM)
• Conducted JAD/RAD sessions with the stakeholder, which included business presentations
• Extensive contribution in developing Use-case, Class, Sequence, Object, Collaboration and State diagrams
• Involved in risk identification, documentation, mitigation and creating Risk Management Plan
• Created Traceability matrix and assisted in creating the Work Breakdown Structure (WBS)
• Created Project management plans for managing on time delivery using MS Project along with writing test cases, unit and systems integration test plans.
• Involved in creating Test Cases and verifying and validating the test results
• Used Rational Rose and Rational Requisite Pro extensively for successful completion of the project

Environment: Windows XP, Rational Rose, Rational Requisite Pro, UML, Rational Unified Process, MS Word, MS PowerPoint, MS Project, Qlikview, ALM

Business Systems Analyst

Confidential, Wilmington, DE

Responsibilities:

• Researched and documented As-Is processes, defined To-Be processes, identified gaps and impacts to different groups and systems
• Defined and developed Scope Document and Project Charter. Developed the Requirements Management Plan
• Gathered user and business requirements through open-ended discussions, prototyping and observation of the compliance department and work environment
• Documented the user requirements, analyzed & prioritized and converted them as system requirements that must be included while developing the software
• Interacted with Project Manager, Users, Developers and other resources in understanding the requirements and writing universe, report specifications
• Conducted iterations and communicated results and milestone achievements to the stakeholders while keeping the developers closely updated on all documented refinements
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product and ensured that the developers were updated
• Created and maintained a project schedule using MS Project showing all of the deliverables target dates
• Created and maintained complete development plans that included functional specifications, requirements engineering, Use Case modeling, risk assessment and mitigation, internal and external workflow
• Authored progress and completion reports, which were then submitted to project management on a weekly basis in MS Project. Documented the deviations from the original specifications
• Developed strategies with Quality Assurance group to implement Test Cases for User Acceptance Testing (UAT)
• Communicate any final adjustments required based on user feedback, usability or deployment issues to the development/implementation team and provide feasible solutions for the same
• Helped in creating end user manuals and procedure manuals post testing/deployment
• Created active risk mitigation and management plan and tracked the same using progress reports in weekly basis
• Created design document UML diagrams and Microsoft Visio
• Created Quality Management plans and test plans
• Automated Test script using Win Runner. The concept was based on the requirements analysis of all the parties involved and developing use cases for all the integrated processes involved in the system
• Used Win Runner to approve a complete set of UAT test scripts

Environment: MS Visio, RUP, UML, Win Runner, Microsoft SQL Server 2000, MS Project, Microsoft Office, Windows 2000 Operating System, Load Runner and Test Director.

Business Analyst

Confidential

Responsibilities:

• Followed a structured approach to gathering and formalizing business requirements expressed by managers, process owners and operational users of the information systems
• Participated in JAD sessions with end-users to identify user requirements, collaborated with developers to determine how business requirements can be implemented within the current system by re-engineering
• Captured core business process information, business rules, business entities and other relevant information; Captured system requirements by writing Use Cases
• Involved in reviewing Entity Relationship, Data Flow, State Transition and Class Diagrams with the Systems Architect
• Involved in designing User Interfaces for developing prototypes using Visio and Dream weaver
• Obtained derived requirements across multiple trading systems, resolved problems due to dependencies between systems and conflicting requirements
• Developed Functional Specifications and Testing Requirements
• Identified the Business risk, prioritized Feature Sets, baseline acceptance criteria and deliverables
• Performed Feasibility, Adaptability and Risk Analysis to identify business critical and high-risk areas of the application
• Conducted research and analysis to compare available solutions providing Index update services
• Actively involved in walkthroughs and meetings with development team to discuss related issues
• Prepared User Manuals, conducted presentations on a walk-through of the new system

Environment: UML, Rational Rose, Rational Requisite Pro, Rational Clear Quest, Macromedia Suit, Microsoft Project, Microsoft Visio, Microsoft PowerPoint.