We provide IT Staff Augmentation Services!

Business Analyst Resume

Houston, TX

Summary of experience:

  • Masters in Business Administration with 6+ years of work experience as a Project Coordinator/Business and QA Analyst in the IT industry, with extensive experience in project management best practices, processes & methodologies.
  • Strong domain knowledge of IT, Healthcare, Finance, Taxation, & Banking industries with excellent verbal and written skills
  • Microsoft Certified Technology Specialist in Project, Project Server, SharePoint and SQL Server
  • IBM certified Rational Unified Process(RUP) Solution Designer
  • Proven Ability to plan, track and manage multiple projects.
  • In depth knowledge of the Software Development Life Cycle (SDLC)
  • Expert in handling all phases of a Project- Initiating, Planning, Executing, Monitoring & Controlling and Closing
  • Extensive experience of Project Management methodologies like RUP, Waterfall, Agile.
  • Extensive experience with Project Management techniques like Work Breakdown Structures (WBS), Project scheduling, Gantt Charts, milestone tracking and PERT charts, Resource Leveling
  • Proficient knowledge of MS Office applications, Project , Visio, Office Suite
  • Strong analytical skills and excellent at identifying root causes and executing corrective actions
  • Conducted Joint Application Development (JAD) sessions/meetings to coordinate with everyone involved in the project
  • Experience in creating a project plan, understanding the business process, defining the scope of the project, understanding user requirements and articulate them into Business Requirement Documents (BRD)
  • Extensive experience in Domain Modeling, gathering business requirements, defining scope and application requirements, Facilitations, Business Process Reengineering (BPR), Traceability Matrix, Documentation, Process Review, Process Modeling, identifying risks
  • Experience in conducting Enterprise Analysis by creating and maintaining the business architecture (Zachman and POLDAT frameworks) and conducting feasibility studies
  • Strong working knowledge in creating component business models, activity models/business process models, class models, use case models, business scenarios and knowledge management during business architecture creation.
  • Experience conducting feasibility analysis by brainstorming, using process and data flow diagrams, technology architecture diagrams and domain modeling.
  • Identify potential solutions thru business process re-engineering and cause and effect diagrams/fishbone diagram
  • Experience in conducting benchmarking and competitive analysis, cost benefit analysis and decision analysis, documenting and communicating the results
  • Experience in developing business cases by qualitative benefit analysis models like SWOT analysis and financial profitability models like financial valuations(discounted cash flow, NPV, IRR and average rate of return), cost-benefit analysis and activity based costing
  • Experience in working with cross-functional teams and acting as a liaison between the developers, analysts, testers and the management team to resolve any conflicts in terms of requirements.
  • Creating and executing Test Plan, Test Scripts and Test Cases based on Design document and User Requirement document for testing purposes
  • Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing
  • Proven ability to deliver substantial productivity & Quality improvements through well-managed on time projects.
  • Skilled at interfacing with the stakeholders & resolving their issues with a quick turnaround time.
  • Demonstrated success many times under aggressive project schedules and deadlines.
  • Experience in data warehouse architecture and database design in client/server environment
  • Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes
  • Managing documentation of projects; Requirement Traceability Matrices (RTM), Risk Management plans, updating the requirement repository.

BUSINESS SKILLS

  • Requirements Elicitation, Business Domain Modeling, Enterprise Analysis, Use Case Modeling and documentation
  • Software Requirements Specification, Prototyping, Storyboards and Flowcharts, RFP’s

TECHNICAL SKILLS

  • Requirements Management Tools: Rational RequisitePro
  • Business Modeling Tools: Rational Rose, MS Visio, MS Excel
  • Change Management Tools: Rational ClearQuest
  • Languages: SQL, C, C++, HTML, XML
  • Scripting Languages: HTML, UML, VB Script, TSL
  • Operating Systems: MS-DOS,UNIX, Windows 95/98/2k/NT/XP/Vista
  • Databases: Oracle, SQL Server 2005, MS Access
  • Tools : QTP, WinRunner, Quality Center, Test Director, Load Runner, Crystal Reports
  • Web Technologies: ASP.NET, Java, J2EE
  • Processes/Technologies: Rational Unified Process (RUP), Use Cases, Workflow

PROFESSIONAL EXPERIENCE

Confidential,Virginia Beach & Houston
Project Coordinator/Business Analyst Dec 08 - Present

Confidential,is a community-focused managed care company with an emphasis on the public sector health care market. The Corporate Desktop Image (CDI-2) project’s aim is to upgrade the company’s OS environment to XP SP3 and Office 07. The scope of the project involves testing all the existing applications used by the 120 departments, including all the access and oracle databases compatibility with the new environment

  • Develop project schedules, timelines, status, system schematics and process work flows.
  • Project planning - Project approach, WBS & timeline (determine level of detail needed), operations (meetings, status reporting, decision making & expectations
  • Resource management by managing resource extensions, PPM maintenance, negotiating & obtaining on-going resource commitments and working directly with the Field Service tech’s
  • Primary Point of contact from the core CDI team to the departments/stake holders involved for any and every issue
  • Conducted individual and group (JAD) sessions with business and technical units.
  • Assisted project manager with the managing of project plan covering Project Schedule, Assignment of tasks, Risk management Plan and Test Strategy
  • Act as the primary coordinator of Onsite & Offsite resources
  • To monitor Project Progress through MS Project, preparing Weekly sub-team status reports.
  • Responsible for creation & distribution of Status reports & Project Dashboard to PM
  • Issue management at various levels by ensuring resolution, communication, documentation
  • Facilitation of meetings & planning sessions, setting the agenda
  • Obtained signoffs on Code narratives and Business Rules Spreadsheets from SME’s and business side Directors.
  • Manage communication between different departments and the core project team
  • Responsible for Project sponsor communication & Executive Management communication

Environment: RUP, MS-Project, MS-PowerPoint, MS-Excel, MS –Visio, SharePoint, Microsoft ACT tool

Confidential,NY Jan 07 – Nov 08


Project Analyst/BA&QA Analyst

Credit derivative trading platform helps the front end and the backend users like the portfolio managers and the traders configure, enter, and process credit derivatives trades within the system. Types of products that are traded in this system are CDS, CLN, TRS, CDO, etc. The system allows creating a customizable trade environment by selecting the pricing environment, data to be used for the trade, accounting and legal principles, tickers, credit events, default terms and conditions, etc. Continuous risk assessment is provided based on the market data. The system is divided into four following modules - Trade capture, Trade verification, Trade confirmation and Legal Execution.
Essential duties and Responsibilities
Project Management
Gathered, defined, and documented user and system requirements. Maintained project schedule, designed, tested, and implemented a centralized management module to track and assist accounts and customized a credit management module to conduct new order credit reviews

  • Developed project Plan including Scope, Time, Quality and resources.
  • Extensively involved in project initiation, management, execution, and controlling deliverables
  • Work as an Interface between the users and the different teams involved in the application
  • Facilitated collection of functional requirements from system users and preparation of business requirement documents that provided appropriate scope of work for technical team to develop applications
  • Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle
  • Exhaustive management and documentation of project requirements and leading the Cross functional team
  • Use SQL Reporting Services to create & generate reports

Test Design

  • Create high quality test plans and condition matrices from all types of documentation for any type of application for all testing stages
  • Generate Traceability Matrix using Quality Center 9.2 to ensure that all the requirements are covered by the test cases and test scripts
  • Work with business users to clarify and elaborate business requirements
  • Perform coverage analysis to confirm the completeness of test plans
  • Use risk information and business knowledge to prioritize test plans

Test Execution

  • Pick up new areas of development work and train other members of the team when needed
  • Organize workloads and prioritize work for self and others
  • Prepared regression script suite with reusable scripts, object repository ,function library, test data repository and driver script
  • Scheduled QTP scripts to execute automatically everyday and email test results in Excel and HTML format
  • Integrated QTP9.2 scripts with Quality Center 9.2 and executed scripts from QC
  • Manage small to mid-sized projects through execution and record and follow-up issues
  • Follow standard testing procedures and give recommendations for improvement
  • Verified the data migration from DB2 database Back End to the Front End and extensively used SQL queries to extract the data from the database
  • Extracting Test Data from Mainframe using File Aid through Extra Xtreme9.0
  • Think creatively and employ best practices when faced with new work
  • Identify deficiencies and defects and extend the depth of test coverage

Test Reporting

  • Produce test plans and estimates for small and medium test phases
  • Produce regular progress reports to the QA Lead, highlighting risks and issues
  • Produce test reports analyzing coverage and status of testing
  • Collect and understand test metrics
  • Produce written and oral presentations of work planned and performed

Environment: Java/J2EE, Oracle 9i, SQL Server 2000/2005, QTP, Quality center, RUP, IBM Rational, MS Visio, Use cases, MS Project, MS Office tools, SQL Reporting Services

Confidential,Reston, VA


Project Coordinator/ BA Analyst Jan 06– Dec 06

Project Description: a) Database Migration Project
b) Disaster Recovery Project
The Data ware house project involved analyzing and creating system requirements for the iDEN and CDMA prepaid platforms for Boost Mobile. Working extensively for prepaid data warehouse project & involved in identifying and analyzing functional requirements impacting the prepaid data ware house platform. Generating rules and requirement to support & maintain the data extracts for Boost using Amdocs Ensemble and NGPP platforms.
The system integrated information into a centralized data warehousing system via ETL process. Another project involved Database migration & Disaster Recovery project involving all existing Sprint vendor companies (over 300) and Sprint internal applications (over 40) and migrating all applications & Vendors from Legacy Nextel to Sprint Encryption Gateway Server.
Responsibilities

  • Develop project schedules, timelines, status, system schematics and process work flows.
  • Review Statements of Work (SOW’s) and contracts, develop Levels of Effort, manage project through implementation and troubleshoot.
  • Involved in creation of WBS,WBS dictionary, Project Scope Statement & Project Charter
  • Interviewed business users and customers to gather business needs related to project scope.
  • Worked with multiple Sprint applications and development teams with international resources and provide liaison to Sprint Vendors.
  • Reporting to senior management and stakeholders on daily to weekly basis.
  • Ran risk assessment and mitigation strategies for contracts
  • Scheduled meetings with Developers, Systems Analyst and Testers to collaborate resource allocation and project completion.
  • Assist Sr. PM in recruiting resources required to implement the project plan. Assign individuals to sub-tasks
  • Status reporting and project planning using MS Project.
  • Working as point of contact with Amdocs to finalize the system requirements that deals with getting the rated Boost prepaid extracts into the data warehouse
  • Involved in scheduling the session\'s tasks comprising of different mappings in order to load data into different databases.
  • Conducted individual and group (JAD) sessions with business and technical units.
  • Responsible for requirements generation and analysis.
  • Identified Stakeholders and understood their requirements.
  • Reviewed vendor contracts and identified application impacts.
  • Involved in scheduling the session\'s tasks comprising of different mappings in order to load data into different databases.
  • Determined variances to find out whether they warranted a corrective action or a change.
  • Wrote test plans, test strategy and test cases for back end testing.
  • Coordinated and prioritized outstanding defects and enhancements identified during UAT, and escalated the same if necessary to achieve the deadline.
  • Responsible for day-to-day monitoring and trouble-shooting issues.
  • Composed a Disaster Recovery Document (DRD)
  • 24x7 application/infrastructure support.
  • Gained Formal acceptance of the Project in the Project Closing Phase.
  • Assured all artifacts/signoffs were in compliance with corporate policies and guidelines and archived

Environment: RUP, Agile, Rational Requisite Pro, UML Use Cases, SQL, Connect-Direct, Oracle 9i, Use Case Documentation, MS-Project, Rational Clear Quest, Test Director.

Confidential,Houston, TX Nov 04 - Dec 05 Sr. Business Analyst

Iplan is the e-portal for Agents and Representatives in Sales and Marketing.Reps can create and track promotional programs, get programs confirmed from the Agents with the required logistics and speakers, allocate and approve budgets, sync expense from agents, track and approve rosters.
Responsibilities:

  • Gathered, defined, and documented user and system requirements, maintained project schedule, designed, tested, and implemented a centralized management module to track and assist accounts and customized a credit management module to conduct new order credit reviews
  • Developed project Plan including Scope, Time, Quality and resources.
  • Extensively involved in project initiation, management, execution, and controlling deliverables
  • Facilitated collection of functional requirements from system users and preparation of business requirement documents that provided appropriate scope of work for technical team to develop applications
  • Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of Rational Unified Process effort in different iterations and phases of the Software Development Life Cycle
  • Exhaustive management and documentation of project requirements and leading the Cross functional team
  • Documentation of system and business requirements and specifications, design and development of use and test-case scenarios
  • Reverse engineer the existing applications and facilitate (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format for inter and intra departmental review
  • Identify and document issues, risk and Gaps(Gap Analysis), their descriptions, their impact and provide recommendation and alternatives to develop the application to meet the requirements
  • Collaborated directly with business units to assess the technical impact of business requirements and to reach consensus on alternative solutions when necessary in an effort to maintain a consistent yet flexible architecture
  • Create AS IS and TO BE documents to show the current and proposed functionalities of the system. Subsequently broke them down by brainstorming with different team members to get the low level ‘To Be’ well
  • Prepare Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models
  • Interact with engineers, platform engineers and developers and document the functionality process of all the components
  • Facilitated UAT’s for the purpose of clarifying the intended functional behavior of the software. Create test scripts and test cases to test the functional compliance and validity of the developed software and software components
  • Designed and developed Test Scenarios, Test procedures, Test Cases, and Test Data according to Functional Specs and Activities of the Business Stream
  • Participated in walkthroughs of critical test cases.
  • Tested the entire functionality of the application on different browsers and operating systems.

Environment: QTP 8.2, Manual Testing, Test Director, Asp.Net 1.1, C#, VB Script, Windows 2000, SQL Server 2000, MS Visio, MS Project

Confidential,NJ Jan 04 - Oct 04


Sr. QA Analyst

Confidential, is a world leading pharmaceutical company with its branches every part of the world. Worldwide Adverse Event System (WAES) is being used by Doctors, Nurses, Patients, etc. all over the world to describe side effects experienced by them over Merck products. This application triages and categorizes adverse event data. The application supports the capture, management, reporting, and analysis of serious adverse event and product compliance cases for all medical products.
Responsibilities:

  • Accountable for Detailed Test Plan by understanding business logic and user requirements for manual and automated testing.
  • Created requirements, test cases, validated requirements with test cases in Test Director.
  • Worked closely with project teams for planning, scheduling and executing tests in the test environment.
  • Extensively involved in regression, integration and functional testing.
  • Created the environment for automation testing and design the test strategy for complete test coverage
  • Wrote and execute test cases to perform Functional, system Integration, UAT and End-to-End Testing. Converted manual scripts into automation scripts using QTP.
  • Executed and run the manual and QTP automation script in different test environments.
  • Record and update scripts in expert view using VBScript, create functions in common function library and attached required functions in each test.
  • Created different checkpoints such as object checkpoint, text checkpoint, bitmap checkpoint and Database checkpoint.
  • Created user defined functions and used library functions for easier maintenance of script.
  • Performed data driven testing to test the application with different sets of inputs data.
  • Customized Test scripts adding Programming logics, using conditional and loop statement.
  • Synchronized test scripts defined Synchronization points adding Exit and Wait statement, Modifying Time out values in QTP
  • Run and debug Test scripts, View and Analyze results.
  • Logged, Tracked and Closed defects, Changed status of defects in Test Director
  • Attended code review, project status meetings, walkthrough and inspections.
  • Defined variables, Shared object repository, Regular expression and recovery scenarios in QTP 8.2
  • Used Test Director for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
  • Prepared test cases for User Acceptance Testing (UAT)
  • Updated team with Test results report after every test run.

Environment: QTP 6.5, VBScript, Test Director, SQL Server 2000,Asp.Net 1.1, C#, IIS 5.1, HTML, Win XP

Education:

Master’s in Business Administration
Bachelors in Business Management

Hire Now