SUMMARY

• Professional with 7 years of diverse experience as a Business Analyst in the fields of Oil Gas, Telecom, Healthcare Insurance, and Finance.
• Experience with applying data warehousing and business intelligence concepts to practical business applications.
• Experience working in all phases of Software Development Life Cycle SDLC , involving User requirements study, Business requirement document, Application Design, Coding, Unit Testing Integration Testing. Possess excellent technical, analytical Problem solving skills.
• Proficient in understanding Business Requirements, gathering Business Process Modeling, Business Process Flow, and Business Analysis.
• Solid understanding of different business management strategies in Business Processes such as Business Process Automation, Business Process Improvement and Business Process Re-engineering.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
• Certification on Microsoft Database Administration fundamentals MTA: 98-364.
• Excellent documentation of requirements gathered using interviews, Brainstorming Sessions, Surveys and Questionnaires Evaluating Data Sources, Translating Requirements into Specifications and Application Design.
• Design, documentation and review of business documents like Business Requirement Document BRD , Functional Requirement Document FRD and System Requirement Specifications SRS
• Proficient in Business Objects tools Web Intelligence, Crystal Reports, and Universe Designer.
• Worked on Metrics Dashboard, Business Collaboration and Workflow, Process Optimizations, Mobility Solutions and the Campaign Management Projects.
• Competent in creating Unified Modeling Language UML diagrams for Business Process Modeling like Use Case Diagrams UCD , Activity Diagrams AD , Sequence Diagrams SD , Data Flow Diagrams DFD , and Flow Charts.
• Highly proficient in the use of SQL and Relational Data bases for querying and reporting purposes
• Expert in Tracking and managing the requirements using Requirement Traceability Matrix RTM that links and controls numerous artifacts produced by several teams across the deliverables of the project.
• Developed Test Scripts using Test Director/Quality Center and coordinated with developers to quickly resolve the defects associated with them.
• Resolved issues solved within the Enterprise and provided solutions to meet the desired business outcomes.
• Assisted QA team in generating test plans, test scenarios, test cases, and managed complete defect tracking life cycle using various defect tracking tools
• Expertise in Functional Testing to ensure a quality product and rich experience in conducting User Acceptance Testing UAT to guarantee all the business requirements have been fulfilled by the application
• Knowledge in the ETL Extract, Transform and Load of data into a data-ware.
• Exposure to Client/Server, Web Application Development tools and Software Development and Design.
• Excellent analytical and problem solving skills listening, oral, and written communication/presentation skills

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities

• Served as a liaison between project managers, stake holder team, and software development team to gather requirements and documented workflows and results into the Business Requirement Document BRD .
• Developed Business Requirement Documents BRD's using Interviews, Brainstorming Sessions, Surveys and Questionnaires.
• Prepared Functional Specification Documents FSDs for various business functionalities by translating BRD's.
• Documented and delivered Functional Specification Document FSD to the project team.
• Conducted Joint Application Development JAD sessions with business unit owners and technical team to capture business requirements and system behavior.
• Conducted Joint Requirements Planning JRP Sessions as a Facilitator to gather requirements from the group.
• Captured and made executive presentations of the issues and risks inherent in as-is process for review by senior management.
• Evaluated task captured through data analysis, application walk through, business process reviews, surveys, and workshops.
• Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance
• Created and applied Unified Modeling Language UML methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram in Rational Rose for upstream Oil and Gas business flows.
• Ensured requirements specifications are formatted for ease of consumption by project stakeholder and technical teams.
• Conducted walkthroughs with Development Team and facilitated UAT with Business Stakeholders/Users.
• Interacted with the US development team which used Agile/Scrum whereas another team internationally UK based team used Waterfall methodology. Ensured that the requirements were delivered and communicated to both teams in a timely manner.
• Interacted with business team to identify business Entities and created Conceptual Data Models using Visio Rational Rose.
• Worked with developers in design/development activities in converting SSRS reports into the SQL database and manage all the electronic records in the system.
• Developed activity diagrams AD , sequence diagrams SD and object oriented design OOD for the software development team.
• Tracked and managed all change requests using Rational Clear Quest and maintained logs for the Action Items.
• Traced and informed business requirement changes through the lifecycle of the project using Rational RequisitePro while maintaining customer needs and maintain a Requirements Traceability Matrix RTM .
• Managed the stakeholder expectations and facilitated clarifications between project stakeholder and technical teams throughout the duration of the project.
• Identified, escalated and resolved project issues to achieve smooth process flows.
• Applied influence, negotiating and mediating discussions needed to make progress towards achieving solutions.
• Performed gap analysis between current performance and desired performance i.e. critical customer requirements .
• Provided implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.

Environment: MS SharePoint, MS Office Word, Excel, Power-point, Access , MySQL Server, OOD, UML, Agile, Waterfall, Rational Rose, Rational Clear Quest, Rational Requisite Pro, RUP.

Confidential

Business System Analyst

Responsibilities

• Acted as a liaison between system users, client managers and software development team to gather requirements and document workflows and results of Financial Analysis into the Business Requirement Document BRD .
• Converted business requirements into functional requirements, created Functional Requirement Document FRD , managed and maintained requirements traceability using Rational's Requisite Pro.
• Prepared Business Workflow models and used Agile software development methodology to build new business processes.
• Monitored actual financial performances against budgets and forecasted data to determine business needs.
• Functioned as a forecasting and budgeting for client requirement.
• Worked with other Business Analysts, Project Manager and software development team through the life cycle of the Project.
• Re-engineered the business model using data modeling tools using Rational Rose and Visio.
• Conducted and participated in JAD Sessions periodically with various Subject Matter Experts at various phases of the Development Life Cycle to discuss open issues and resolve them.
• Worked with User Interface UI team to create report mock up's from wire frames to ensure that functionalities are captured and presented on the front end as per the BRD's.
• Worked closely with the business team and stake holders to gather accurate business requirements for the project.
• Worked with different IT Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects
• Performed data analysis to prepare numerous end-of-month reports.
• Performed requirement analysis including data analysis and gap analysis.
• Created and maintained end-to-end data mapping and data conversion spreadsheet.
• Extensively worked on MS Excel, MS PowerPoint, MS Project, MS Visio and MS Word.
• Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data.
• Involved in Gap Analysis and assisted the development team to understand the process.
• Mediated discussions, influenced, negotiated as needed to make progress towards achieving solutions.
• Used SQL statements to retrieve data for reporting purposes.
• Worked on Electronic health record system as a CRM web based application.
• Involved in preparing detailed risk assessment plan.
• Used MS Project to maintain the project schedule and track its status.

Environment: MySQL Server, MS Project, MS Visio, MS Office Word, Excel, Power-point, Access , Agile, Rational Rose, Lotus Notes.

Confidential

Business Analyst

Responsibilities

• Defined, prioritized, and tracked requirements throughout the project lifecycle, software development teams are able to respond rapidly to ever-changing requirements without risking the project success.
• Provided support to loan officer and underwriter teams by ensuring the timely, judicious and accurate processing of mortgages.
• Facilitated team meetings to coordinate activities for project schedules, presented deliverables to the management, conducted to elicit requirements.
• Performed analysis on project scope parameters gap analysis, usability, cost /benefit.
• Assisted in developing Work Breakdown Structure, project schedule, project status reports and attended project progress meeting to report on project progress.
• Analyzed Business Requirements, reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.
• Created Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Worked with production staff to identify and map detailed current processes, identified gaps and failure points with the legacy data management system, performed root cause analysis and developed functional requirements that supported overall strategy, goals and objectives for the new IT Architecture.
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Applied Unified Modeling Language UML methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram in Rational Rose.
• Conducted JAD sessions to get SME's input on how to implement the application for core credit card production and billing.
• Examined and analyzed Test plans, Test Scripts, Test procedures based on RUP methodology.
• Tracked reviewed analyzed and compared defects using test director.
• Presented management reports to the project manager in handling whole project.

Environment: Rational Rose, MySQL Server, MS Project, MS Visio, MS Office Suite Word, Excel, Power-Point, Access , RUP, UML, MS Project

Confidential

Business Analyst Insurance Sector

Responsibilities

• Developed business relationships between external and internal clients, sales, managers and the development teams to establish project timelines and coordinated priorities to meet implementation deadlines.
• Translated business requirements into high-level and detailed functional specifications
• Established test methodologies, test cases, scripts and user acceptance testing.
• Elicited requirements by sessions including use of interview, document analysis, workshops, adapting in determining appropriate requirements capture and management methods including but not limited to use cases, diagrams and process flows.
• Created Project Plan, Risk Mitigation Plan, Project Scope Document, Software requirement Specification, Project Glossary.
• Collaborated with developers and subject matter experts to create proper data models and mapping the data connections between models, analyzing tradeoffs between usability and performance needs.
• Using MS Office suite components for documenting, traceability, project tracking, documentation, and presentation to senior management.
• Interfaced between Business new product builders and System platform builders.
• Worked with systems area to translate business needs into system requirements.
• Made sure the test cases and test process guarantee accountability to business and systems requirements.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Used cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: UML, MS Visio, MS Project, MySQL Server, MS Project, MS Visio, MS Office Suite Word, Excel, Power-Point, Access , Rational Rose, Oracle DBA