Business Technical Analyst Resume Profile
Houston, TX
SUMMARY
- Professional with 7 years of diverse experience as an IT Business Analyst in the fields of Oil Gas, Telecom, Insurance, and Investment.
- 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.
- Solid understanding of different business management strategies in Business Processes such as Business Process Automation, Business Process Improvement and Business Process Re-engineering.
- Hands on experience on Oracle Business Process Management BPM 11g.
- Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
- Experience in Agile Scrum and Waterfall methodologies and knowledge of RUP. JAD
- 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.
- Created Business Requirements Documents BRD , Functional Requirements Documents FRD , and Technical Requirements Document TRD based on the role in the project
- Proficient in Business Objects tools Web Intelligence, Crystal Reports, and Universe Designer.
- 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
| Business Modeling and BI Tools | RUP, UML, SDLC ,Microsoft Visio, Agile, Waterfall, Power Designer, Quality Analyst QA ,Business Objects, Web Intelligence, Live Office, Rational Rose, Rational Clear Quest, Tableau, UML, RUP , UML, Oracle BPM, |
| Project Management | MS Project, Requisite Pro, Dashboard Manager, Crystal Reports |
| Programming Languages | MySQL, PL SQL, Visual Basic |
| Databases | MS Access, SQL Server, Oracle DBA |
| Operating Systems | Windows 95/98/NT/2000/XP/Vista/7/8, UNIX, MS Dos |
| Software | MS Office Suite Word, Excel, Access ,Visio, PowerPoint Outlook |
| Management Tools: | MS Office 2010, MS Visio, SharePoint 2010, Enterprise Architecture 6.1, MS Project |
PROFESSIONAL EXPERIENCE
Confidential
Business technical 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 .
- Prepared Business Requirement Document BRD and then translating into functional specifications, use case scenarios and workflows using MS-Visio. Worked closely with both business users and developers to arrive at a mutually acceptable solution.
- Developed Business Requirement Documents BRD's using Interviews, Brainstorming Sessions, Surveys and Questionnaires.
- Extensively prepared Technical documents to make the application easy to understand and maintain.
- Conducted Joint Application Development JAD sessions with business unit owners and technical team to capture business requirements and system behavior.
- Converted business requirements into functional requirements, created Functional Requirement Document FRD , managed and maintained requirements traceability using Rational's Requisite Pro.
- 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.
- Validated the database schema created by the development team against the functional specifications
- Developed Use Case Scenarios using MS Visio and ensured that Test Cases and Test Plans developed were in accordance with the Use Cases.
- Created Data Flow Diagrams using MS Visio to better explain Business Users the process flow.
- 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.
- Worked as a Team lead for offshore for providing support in making project plan.
- Involved in drawing process flow diagrams and work flow diagrams in all phases of the SDLC.
- Conducted walkthroughs with Development Team and facilitated UAT with Business Stakeholders/Users.
- 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.
- Managed the stakeholder expectations and facilitated clarifications between project stakeholder and technical teams throughout the duration of the project.
- 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 .
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.
- Design Develop BPM process using BPEL workflow, interfaces, connectors, adapters required for the 837 EDI applications.
- Worked as a domain expert to gather business and technical requirements from the customer.
- 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.
- Authored design documentation, which included: traceability matrices, functional specifications and complex process and data flow diagrams using Visio.
- Worked with different IT Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects
- Performed gap analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
- Performed requirement analysis including data analysis and gap analysis.
- 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.
- Worked on Electronic health record system as a CRM web based application.
- Mediated discussions, influenced, negotiated as needed to make progress towards achieving solutions.
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
E-commerce /Business Systems Analyst
Responsibilities:
- Responsible for documenting business requirements for AT T website through all phases of the Software Development Life Cycle SDLC .
- Developed Use Cases in Microsoft Visio along with Activity Diagram to present the workflow in a visual form.
- Worked closely with the business team, stake holders and technical team to gather accurate business requirements for the project.
- Established a business analysis methodology around the Rational Unified Process RUP .
- Developed UML use cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
- Responsible for requirements gathering by facilitating and scheduling Conference Calls, Business Interviews, and Joint Application Development JAD sessions and developed business models.
- Performed a GAP analysis by laying down in detail using MS VISIO to depict the scenarios.
- Provided Agile project management controls, project plans, timeline schedules, facilitated JAD sessions, and reviewed software defects.
- Wrote functional specification documents and user documentation for company's point-of-sale system.
- Specified standard system functionality and retailer-specific system requirements.
- Involved in various discussions with end user to analyze Meta data Scheduling, Interacting, Business-Technology management strategy oversight of SOA Internet/Web applications API frameworks
- Identified internal and external system requirements, design and configuration set-up, also created User Documentations.
- Involved in Inception Phase and prepared data models that contain BRD's and supporting documents containing business elements and detailed definitions.
- Involved in Requirement Analysis, use case development, UML modeling using Rational Rose and MS Visio.
- Extensively used Rational DOORS to manage the project requirements and promote communication and collaboration among the members of the team.
- Used SQL queries to gather and analyze data then created reports in excel for our client services team.
- Developed and deployed a test case and defect tracking tool in MS SharePoint.
- Developed Executive Dash Board using Web reports, Web items and customized web templates using Web Application Designer WAD .
- Developed Web Intelligence reports making use of several Queries Union, Intersection, Minus .
- Documented defects found throughout UAT and mitigated their resolution with IT.
- Effectively communicate project expectations, project goals and scope to the team.
Environment: Agile, MS Visio, MS Office Suite Word, Excel, Power-Point, Access , SharePoint, Business Objects Web Intelligence , Dashboard, MySQL Server, MS Project, Rational Doors.
Confidential
Business Analyst Retail 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
