PROFILE:

• An analysis with over seven years of progressive experience in various fields including Aviation, Finance and Education industries with specific expertise in Investment, Administration, EDI and Consolidation/Integration of business processes procedures to improve transactional efficiency and betterment of business processes.
• Proven performance in linking corporate vision with the delivery of desired results through empowerment, development and utilization of people, process and technology.
• A strong motivator and team player with effective leadership, communication, decision making, problem solving and interpersonal skills, together with corporate focus and result driven attitude.
• Extensive involvement in Project Life cycle from inception to final delivery of training manuals.
• Extensive knowledge of Business Analysis methodologies including Agile, Rational Unified Process (RUP) and Iterative Software Development Life Cycle (SDLC). Visualization/Documenting of artifacts using Use Cases diagrams in accordance with UML using Rational Rose and MS - Visio. Expertise in analysis of data for data warehouse/data mart development for Online transaction processing (OLTP) and data warehousing (OLAP)/Business Intelligence application (BI). Effective utilizations of project management tools like Rational RequisitePro and Jira.
• Extensively used RUP for effective implementation of Requirements management using Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions and Rapid Application Development (RAD) sessions SME’s, business groups, senior management and IT groups. Proficient 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.
• Experience developing Test Plans, Test Approach, Validation Plans, Test Cases, Test Scripts, Traceability Matrix and Test environments using HP Quality Center 10.0.

TECHNOLOGICAL SKILLS:

Software Development Methodologies: Iterative Software Development Lifecycle Rational Unified Process (RUP) Agile

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

Modeling Languages: Unified Modeling Language (UML)

Project Management Tools: MS Project, Rational RequistePro, Jira

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

Languages: HTML, CSS, JavaScript, C, 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 Project.
• Worked with other members of the team to identify the business requirements and formulate BRD, Use Case document, and requirements traceability matrix (RTM).
• Identify multiple source systems from which Confidential receives data, create detailed mapping documents includes join conditions, business field explanation and its impact on Confidential system.
• Participated in daily stand up meetings.
• Developed a conceptual model using Erwin based on requirements.
• Creation and adherence to project plan timelines for Confidential module wise development and delivery.
• 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
• Documented Use cases from the functional requirements and reviewed the same with technical team.
• Identified Use Cases and generated UML diagrams.

Confidential, Boston, MA

Business/Data 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
• 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.
• Involved in major part of Software System Development Life Cycle (SDLC).
• Developed test case scenarios and implemented the test plan.
• Documented Use cases from the functional requirements and reviewed the same with technical team.
• Understand rules and regulation of Confidential 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 use cases using 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 on web platform.
• Created documentation for training and help desk teams.

Confidential, NY

Business/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.

Confidential, Irving, TX

Business/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 Diagrams, Class 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.
• 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

Confidential, Melbourne, AU

Business Analyst

Responsibilities:

• Facilitated Joint Application Development (JAD) / Joint Requirement Planning (JRP) sessions for requirements gathering
• 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