SUMMARY:

• Over 9 years of Business Analysis experience with the ability to work independently and manage business expectations with a delivery - focused approach to work; ability to build and maintain strong working relationships with senior and junior business sponsors, as well as technical specialists
• Comprehensive knowledge of Business Analysis methodologies and Iterative Software Development Life Cycle (SDLC)
• Efficient in gathering, detailing, documenting and validating the requirements in a format that is useful to their business area experts and the technical developers
• In depth knowledge of UML in visualizing and documenting the artifacts using Use Cases diagrams in Rational Rose and MS-Visio
• Worked in several projects extensively with Erwin and ER studio in both OLTP and OLAP applications and ETL processes.
• Ability to understand the Business process, and capture the Business rules in Models and documents
• Expertise in data modeling for data warehouse/data mart development, data analysis for Online transaction processing (OLTP) and data warehousing (OLAP)/Business Intelligence application (BI)
• Effectively used Rational Requisite Pro to organize, track and change requirements of the system
• Extensively used RUP for effective implementation of Requirements management under all phases of RUP from Inception to Transition
• Experience in conducting Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions and Rapid Application Development (RAD) sessions with committee of SME s, business groups, senior management and IT groups.
• Efficient in documenting data models, data flows for new and existing applications
• Proficient in working knowledge of Unified Modeling Language (UML), Use Cases and Activity diagram
• Provided application level support for EDI transactions such as EDI 204, 210, 214, 215, 850, 855, 856, 812, 990 and 997s.
• Extensive knowledge in XML mappings.
• Extensive experience in mentoring and training other Business Analysts
• Highly motivated, organized and results oriented with excellent interpersonal, communication and presentation skills with capability of adapting to new and fast changing technologies
• Experience developing Test Plans, Test Approach, Validation Plans, Test Cases, Test Scripts, Traceability Matrix and Test environments.
• Experience in HP Quality Center 10.0.
• Experience working with offshore teams (development and QA) to review requirements and test cases.

TECHNOLOGY SKILLS:

Software Development Methodologies: Waterfall, Rational Unified Process (RUP), Agile, SCRUM, Waterfall

Documentation Tools: Requisite Pro, MS Visio, Rational Rose (UML), MS Word, MS SharePoint.

Modeling Languages: Unified Modeling Language (UML)

Project Management Tools: MS Project

Change Management/Tracking Tools: Quality Center, Rational Clear Quest

Languages: Visual Basic, C++, Java, JavaScript, VB Script, HTML, SQL, XML.

Other Software Tools: MS Excel, MS PowerPoint, MS Word

PROFESSIONAL EXPERIENCE:

Confidential, OR

Sr Business Analyst

Responsibilities:

• Created AS - IS and TO-BE process flow for Confidential FAM Project.
• Worked with other members of the team to identify the business requirements and formulate BRD, Use Case document, and requirements traceability matrix (RTM).
• Monitoring Sprints with Burn down charts
• Gathered user/business requirements using Requirements Planning sessions
• Participated in daily stand up meetings.
• Developed a conceptual model using Erwin based on requirements.
• Worked with end users to identify business requirements recorded the requirements in a format that can be reviewed and understood by both business and technical people
• Reviewed the Business Requirements Document (BRD) with the business users and
• SME s, including representations from the technical team as well
• Assisted in presenting reports and analysis to help guide the management
• Helped nurture collaborative coordination environment with Jr Business analyst for effective goal achievement.
• Developed SOAP based xml message interaction infrastructure.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL server database systems. Performed validation of use cases to address the need of the business.
• Involved in major part of Software System Development Life Cycle (SDLC).
• Applied change request, versions and addendums
• Documented Business Rules, Non-Functional Requirements and Data Elements
• Co-ordinate with technical team for business requirements
• Extracted data from databases (Oracle, DB2 and flat files) using Informatica to load it into a single data warehouse repository.
• Documented Use cases from the functional requirements and reviewed the same with technical team
• Liaised with project manager and client using MS Project.
• Identified Use Cases and generated UML diagrams.

Confidential, MA

Business Analyst

Responsibilities:

• Created the TO - BE process flow for Confidential Project.
• Actively participated in Release Planning with Project Manager and Business Owner.
• Monitoring Sprints with Burn down charts
• Gathered user/business requirements from using Requirements Planning sessions
• Conducted JAD sessions with users for requirements
• Participated in daily stand up meetings.
• Worked with end users to identify business requirements recorded the requirements in a format that can be reviewed and understood by both business and technical people
• Reviewed the Business Requirements Document (BRD) with the business users and SME s, included representations from the technical team as well
• Documented Functional Requirements Specifications (FRS/FRD) based on the business requirements and reviewed the same with the technical team
• Designed STAR schema for the detailed data mart and plan data marts at the lowest level grain for each of dimensions involved.
• Created and maintained the data mart repository as per company standards.
• Worked on the Snow-flaking the dimensions to remove redundancy.
• Generated UML diagrams and identified Use Cases.
• Assisted with building the EDI 204, 214, 215, 210, 855, 856, 812, 850. 990 and 997 transactions processing flow from trading partners.
• Performed validation of use cases to address the need of the business.
• Involved in major part of Software System Development Life Cycle (SDLC).
• Involved in requirement Analysis, Testing, Implementation and Support.
• Created ETL jobs and custom transfer components to move data from Oracle source system to SQL Server using SSIS.
• Developed test case scenarios and implemented the test plan.
• Documented Business Rules, Non-Functional Requirements, Glossary and Data Elements
• Co-ordinate with the technical team for the business requirements
• Documented Use cases from the functional requirements and reviewed the same with technical team.
• Understand rules and regulation of FAA imposed during electronic data interchange (EDI).
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the master Data Management Architecture involving OLTP, ODS and OLAP.
• Documented Test Cases from the use cases using Rally.
• Worked with the off-shore teams in reviewing requirements and test cases

Environment: Agile team foundations, UML, Use Cases, MS Visio, MS Excel, Use Cases, HP Quality Center 10.0 MS Visio, MS Excel, MS Word. Rally

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Liaised with business, development and testing teams.
• Developed Use Cases, work flow mock - ups and conversion requirements.
• Utilized RUP to configure and develop process, standards and procedures.
• Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve issues.
• Created User Requirements Specification (URS) and Functional Requirements Specifications (FRS) documents.
• Applied change request, versions and addendums.
• Validated technical design created by IT developers against functional specifications.
• Worked with QA team to design test plan, test cases for user acceptance testing.
• Liaised with project manager and client using MS Project.
• Worked with SQL queries for data manipulation.
• Created GAP analysis and specified all business data for XML messages for submission in web platform.
• Created documentation for training and help desk teams.

Environment: MS Project 2007, MS Office, SQL, XML, MS Access, Test director.

Confidential, NY

Business Analyst/Data Analyst

Responsibilities:

• Liaised between the development, testing and management.
• Participating in JAD sessions and preparing documentation across the software life cycle using Rational SoDA.
• Worked with other members of the team to identify the business requirements and formulate the BRD, Use Case document, and requirements traceability matrix (RTM).
• Advising developers and test engineers in understanding business requirements, and adhering to project plan.
• In pre - testing phase, extensively used Requisite Pro for understanding/analyzing project vision, goals, specifications and requirements.
• Worked with test team in formulating project test plan, and test case documents.
• Performed UAT and Created Data Driven Tests in SQA Basic by creating data pools in Rational Test Manager.
• Performed Performance testing for the application and collected data to calculate
• Mean/Median values used in Test Metrics by the stakeholders.
• Used SQL and SAS against SQL server to produce end user data set of customer data for transmission to marketing vendors.
• Produced daily, weekly and monthly reports from SQL server that reconciled data and file transfer to its marketing vendors.
• Executed regressing test cases through the Rational Test Manager and analyzed the results of verification points using the Comparator.
• Developed database driven marketing messages using XML.
• Worked on Clear quest for defect tracking and maintained the training history of the bugs

Environment: SQL Server, HTML, Rational Unified Process (RUP), UML, XML,CSS

Confidential, Irving, TX

Business systems/ Data Analyst

Responsibilities:

• Gathered business and user requirements by conducting interviews with SME s across different teams.
• Mapped current business process, helped in documentation of Business Requirement (BRD).
• Designed and developed Use Cases, Use Case Diagrams, Process Flow DiagramsClass Diagrams and Sequence Diagrams using MS Visio.
• Identified, investigated, analyzed, defined and documented business processes and Critical Success Factors (CSF).
• Utilizing SQL Server Enterprise tools including SSIS, Notification Services and Reporting Services.
• Developed policies and procedures to assure operation of a cost effective revenue collection process, credit card processing, and cash management & account receivables.
• Investigation and documentation of local and international payment vehicles for ecommerce utilization, in relation to their associated institutions and operational processes for acceptance, capture and reporting
• Worked on accounts payable, accounts receivable and data relating to credit card payments.
• Created User Requirement Specifications (URS) and Functional Requirement Specifications (FRS) documents.
• Execute simple SQL queries to query the test Databases and perform minor database changes and assist in Database Unit Testing activities.
• Developed test plans, test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge
• Worked on both the technical and functional specific documentation for the project of Sum Total Tool
• Assisted in development of training materials for new technology and process improvements and was responsible for all project documentations. Also prepared end - user manual for better understanding of the designed system for the user

Environment: MS-Office Suite, MS Visio, XML, Agile, MS Access, SQL, Mercury Quality Center,CSS.

Confidential, Melbourne, AU

Business Analyst/Data Analyst

Responsibilities:

• Facilitated Joint Application Development (JAD) / Joint Requirement Planning (JRP) sessions for requirements gathering
• Interviewed SME (Subject Matter Experts) with detailed questions and carefully documented the requirements in a format that can be reviewed and understood by both Business and Technical teams
• Involved in the formulation of the Business Requirements Document (BRD)
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules and information needs to ensures that critical requirements were not missed
• Experience creating table synonyms in SQL server to run complex relational database queries.
• Documented and delivered Functional Specification Document to the project team
• Implemented custom grid views, repeaters, Data Tables and Datasets for Data manipulation
• Documented Use cases and developed Use Case Diagrams and Activity Diagrams using MS Visio
• Performed the validation of use cases to address business requirements.
• Involved in major part of Software System Development Life Cycle (SDLC) Requirement Analysis, Testing, Implementation and Support
• Developed test case scenarios and implemented the Test Plan
• Participated in Change Control Board at the front end when change request was raised
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT)
• Worked closely with QA and Developers to clarify/understand functionality resolve issues and provided feedback to nail down the bugs.
• Led the change requirements of XML schema.
• Interacted with the business users to resolve conflicts
• Assisted in presenting reports and analysis to help guide the management

Environment: MS Visio, Java, Quality Center, Agile, SCRUM, XML, MS Project, Excel.