We provide IT Staff Augmentation Services!

Sr. Business/systems Analyst Resume Profile

Richardson, TX

Professional Summary:

  • Over Seven 7 years of diversified IT experience in complete Software Development Life Cycle SDLC process including System Analysis, Design, Development, Testing, Implementation and Documentation.
  • Skilled in performing Gap Analysis and Impact Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
  • Extensive experience in requirement elicitation techniques like JAD sessions, Document analysis, Prototyping, Reverse Engineering, Brainstorming, Requirement Workshop with Users, Subject Matter Experts SMEs and business aStakeholders.
  • Excellent Analytical skills in understanding and identifying the Business Process and conducting feasibility studies to develop Scope and Vision Document.
  • Thorough understanding of the Software Development Life Cycle SDLC and their variants with Waterfall, Agile Scrum , RUP.
  • Extensive knowledge in creation of Request for Proposals RFP for business development Software applications in JAVA, J2EE, SQL, Oracle PL/SQL within Services Oriented SOA business process.
  • Experienced in tracking, documenting, mitigating and resolving Project Risks and Issues.
  • In-depth working knowledge of Cost/benefit analysis.
  • Experienced in writing Business Requirements Document BRD and Functional Requirements Document FRD .
  • Adept at creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Context, Use Case, Sequence, Activity Diagrams in Enterprise Architect , MS Visio and Rational Rose.
  • Excellent experience in preparing project related documents like Field Mapping, Requirement Traceability Matrix, Project Management Plan, Weekly/Daily Task Reports and Status Reports.
  • Experience in Data Extraction, Transforming and loading ETL between Homogenous and Heterogeneous System using SQL tools SSIS, DTS, Bulk Insert, BCP, XML .
  • Hands-on experience in design and development of ETL solutions for data warehouses and data marts, using different architecture, design techniques.
  • Extensive experience in writing SQL Queries and in-depth knowledge of Database Management Systems.
  • In depth knowledge of web services and XML.
  • Extensive working experience with SharePoint 2010.
  • Extensive experience in creating and maintaining source to target data mapping documents.
  • Experience with Data Modeling ETL process using Erwin, Data Stage, Informatica SQL Loader, Cognos.
  • Strong experience in conversion and re-engineering project for Legacy applications.
  • Experience in Release Management.
  • Strong experience in SOX control and audit process.
  • Excellent experience in Technical standards and processes.
  • Proficient in interacting with Stakeholders, Subject Matter Experts SMEs , System Analysts and Technical team with excellent communication and interpersonal skills.
  • Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration and Scheduling.
  • Experienced with Manual as well as Automated Testing Strategies.
  • Skilled in Unit/System/Integration/Regression/Smoke Testing as well as Users Acceptance Testing UAT .
  • Expertise in creating the Test Plans, Test Cases and Test Scripts and efficiently prioritize and manage the defects using the Defect Tracking system.
  • Experienced in training and mentoring team members with product knowledge and business processes.
  • Strong experience in performance tuning.
  • Outstanding organizational skills including ability to multitask, prioritize, and manage complex issues.

Technical skills:

Requirements Gathering Tools

Rational Requisite Pro

Designing Tools

Rational X De, CMMI Models, Dream Weaver, Adobe Photo

Shop, MS Front Page, Paint Shop Pro, Home Site, Visual Studio

Management Tools

MS Project, MS Visio, MS Word, MS Power Point

Tools

Rational Requisite Pro, Clear Quest, Clear Case, MS Office Suite GAP Analysis, CICS CMMI, Adobe Acrobat Reader

Operating Systems

Windows 95, 98, 2000, NT, XP, Vista, 7, 8, Unix

Languages

C, C , COBOL,JAVA, J 2EE, VB.Net, C VB, PHP

Data Bases

DBMS Concepts, MS SQL Server, Oracle, DB2, MS Access ADO.Net, ETL, Business Objects 6.5.1, ETL, Erwin

Application Servers

MS IIS, Web Sphere, Web logic, MS Exchange Server, Share Point

Scripting Languages

Java Script, Jscript, VBscript, HTML, XML, CSS

Testing Tools

Win Runner, Load Runner, Test Director, QTP, Actuate, Crystal Reports

Web Technologies

ASP, ASP.NET, JSP

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Business/Systems Analyst

Responsibilities:

  • Involved in all phases of Software development life cycle SDLC using Agile Scrum methodology.
  • Conducted GAP Analysis to show current and proposed functionalities for the Data Migration Project.
  • Followed Agile, and Waterfall SDLC methodologies for project execution, and used Storyboards as one of the requirements elicitation technique.
  • Gave walkthroughs to the product owners after completion of every sprint cycle
  • Conducted and participated in sprint planning meeting to define the Sprints and the duration of each sprint and prioritized the requirements and placed them into the sprint backlogs
  • Experience developing storyboard and user stories to elicit requirements from the product owners.
  • Managed and tracked change control process of requirements and design changes. Documented the changes, issues and their impact on the system design and delivery.
  • Used SQL queries to extract data from database to perform data analysis.
  • Participated in daily SCRUM meetings to discuss the bottlenecks and the tasks status
  • Documented User Requirements Specification URS and Functional Requirements Specification FRS by working as a liaison between the business Stakeholders and the Development teams
  • Involved in writing the Data Dictionary for different processes and their file layouts
  • Conferred with Business Users to elicit requirements and worked with the Design and Development teams on the Solution Design for the project
  • Prepared BRD and FRD, and simultaneously managed the documents using Rational RequisitePro
  • Created Use case diagrams, using MS Visio, by performing Use-Case Analysis on the requirements
  • Facilitated JAD sessions with the End-users ensuring that the system met all business needs
  • Performed Walkthroughs with the SMEs for requirements approval and baseline business architecture
  • Worked with GUI team for designing the screens, and assisted in Prototyping the User Interface UI
  • Utilized MS SharePoint as the central repository for requirements management and communication
  • Analysed information gathered from multiple sources to resolve system, process or data conflicts, decompose high-level information into details, and distinguish user requests from the true needs
  • Assisted the Project Manager in project management support: developed project plans, work breakdown structures WBS and task dependencies, project schedules, risks, and reports
  • Executed Test Cases for UAT of the application, and reported bugs to the development team through defect tracking and rectification process
  • Drafted and analysed project Deliverables, and created Checklists for Checkpoints in the project
  • Developed Requirements Traceability Matrix for maintaining system requirements using MS Excel
  • Interacted with Production and Design teams for change requests and problem report documentation
  • Performed Knowledge Transfer of the elicited requirements to the DB Architect for Database Design
  • Assisted the Database team in Data Migration, from MS Excel to SQL Server Reporting Service, using SQL Loader for the future system
  • Retrieved data from database for Data Validation and Data Integrity tests using SQL queries
  • Analyzed User requirements in Stakeholder meetings to document changes, and implemented procedures to test changes using Rational Clear Quest
  • Assisted the Testing team in creating Test Plans, Test Scenarios, Test Cases and collect Test Data for successful completion of Integration Testing and Functional Testing
  • Performed process mapping, data mapping and created artifacts for data requirements and data mapping
  • Assisted the database architect in designing data flow model, data modeling and also in workflow analysis, functional decomposition analysis.
  • Assisted the project manager in change management activities through analysis of requirements effort, and resources
  • Work on the Data Modeling, Entities and Attributes of the Data points and Templates. Building API in XML based on the requirements.
  • Used SOAP UI to test various web services based on SOAP.
  • Assisted the database team in understanding the ETL requirements
  • Communicated with management concerning development process within areas of assigned responsibilities using MS Share point MOSS

Environment: Oracle 8x/9i/10g/11g, Asp. Net, SQL, DB2, AS400, MS Project, MS Office Suite, Agile , UML, CA Clarity, Rational Rose, JIRA, Rational Clear Quest 2002, MS office suite 2003, MS Visio 2003.

Confidential

Role: Sr. Business/Systems Analyst

Responsibilities:

  • Responsible for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis with Document and Records Management.
  • Organized and driven morning scrum meetings and obtained status from each team.
  • Interacted with the project team to define system objectives and scope, identified constraints and the measures of success for the system to be developed.
  • Developed and managed Software Development Life Cycle SDLC methodology which includes Configuration Management, Requirements Management, UML Analysis and Design.
  • Facilitated JAD sessions with management, users, subject matter experts SME and other stakeholders to define the project and to reduce the time frame required to complete deliverables.
  • Prepared and presented Business Requirement Document BRD , System Requirement Specification SRS and Functional Requirement Document FRD .
  • Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the client end requirements.
  • Implemented agile methodology for rapid delivery of the high quality application and acted as a scrum master to organize sprint process.
  • Created data mapping templates and aided the development team to reduce the bandwidth of the project.
  • Review prototypes, solution blueprints, and project scope to ensure that the needs of the business are met.
  • Participated in and contributed to as-is and to-be Process Modeling Sessions, and build process models responsible for analysis and reporting.
  • Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams, activity diagrams, Sequence Diagrams using Rational Rose according to UML methodology.
  • Created Screen Mock ups using Visio.
  • Maintained various versions of the documents generated during the project using Rational Clear Case.
  • Defined testing objectives and verify requirements are testable.
  • Responsible for managing the documented System Requirements and Requirements Traceability Matrix using Rational Requisite Pro.
  • Responsible for Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing.
  • Created detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test.
  • Extensively worked with requirement management tool and test management tool such as Mercury Quality Center.
  • Provided support for User Acceptance Testing, writing test plans and developed different testing strategies like Black Box testing, and Load testing.
  • Generated SQL queries for data-analysis and bug fixing.
  • Involved in DB2 database upgrade project.

Environment: UML, RUP, Windows 2000, Oracle 9i, Rational Rose, Requisite Pro, ClearCase, ClearQuest, MS Project, MS Word, MS Excel, Java, Web Logic, DB2.

Confidential

Role: Business Analyst

Responsibilities:

  • Extensively worked on various trading applications, credit risk management systems, market risk and Asset management systems.
  • Lead the functional requirements gathering team in eliciting, verifying, organizing and documenting business, functional and non-functional requirements.
  • Worked directly with internal customers to understand the business environment and needs.
  • Extensively worked on version control and change control management.
  • Generated Traceability matrix for high-level requirements through detail-level requirements.
  • Provided user requirements analysis. Documented requirements using various tools, including Requisite Pro as directed.
  • Generated various business process workflows using Visio.
  • Run ad-hoc queries to provide data to users.
  • Generated various documents for project maintenance and documentation.
  • Generated clear business, technical, operational and user requirements using Rational RequisitePro and System Design Specifications.
  • Design strategies for capacity monitoring, short term and long term capacity planning.
  • Worked with the DBA's to tune SQL Queries to improve the overall performance of the database.
  • Implement required security controls to meet audit requirements.
  • Provide data from production databases to stage/dev environments for various testing purposes.
  • Worked with the DBA's to develop database monitoring strategies.
  • Worked with the DBA's to resolve day to day database related issues.
  • Design backup and disaster recovery strategies.
  • Worked with the DBA's for fail over test and disaster recovery.
  • Standardize and document the naming conventions for file systems, instances for any new UDB applications.
  • Mentored new comers with the current internal architecture.
  • Provided 24/7 on-call support for various production databases.

Environment: UML, RUP, Windows 2000, Oracle 9i, Rational Rose, RequisitePro, ClearCase, ClearQuest, MS Project, MS Word, MS Excel, Java, Web Logic, DB2.

Confidential

Role: Business/Systems Analyst

Responsibilities:

  • Communicated business requirements in a clear and unambiguous manner with team members.
  • Conducted JAD/ JAR Sessions to develop an architectural solution that the application meets the business requirements, resolved open issues, and change requests.
  • Developed Business Use Cases/ System Use Cases and the User Interface Diagrams using UML.
  • Built the prototypes for the claims application and worked on GUI screens.
  • Present in the Software development life cycle SDLC from analysis, design, and implementation.
  • Worked on the spread sheets and graphs using MS Excel.
  • Worked with Subject Matter Experts SMEs to identify high level requirements related to the Claims Process.
  • Involved in Service Oriented Architecture SOA of the claims processing system
  • Involved in creating Stored Procedures for the claims application.
  • Worked with the project manager to estimate best/worse case scenarios, progress with weekly estimates of remaining work to do, mentoring the team members regarding and project and conducting informal meetings ad hoc and as needed.
  • Involved in writing test cases, test scripts and test plan for the application.
  • Used CMMI models to define the best practices of the application.
  • Participated in gathering the essential requirements of the project and performed requirement analysis, modeled using UML.
  • Involved in creating reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
  • Performed business evaluation, user requirements analysis, story development, requirements definition, use case development, acceptance testing, usability testing.
  • Worked on Oracle, Advanced Collections in managing the data between the Data management support team and the Claims support System for the customers.
  • Involved in gathering, analyzing business rules, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Worked on the Business Objects Data Insight to analyze and monitor the claims reports.
  • Worked on data modeling and produced data mapping and data definition documentation by interacting with ETL programmers and ensured the implementation of the business requirements.
  • Analyzed Business Requirements to produce System Requirements for the technical team using Rational X De.

Environment: Requisite Pro, Rational X De, MS Project 2002, Clear Case, RUP, UML, HTML, MS Exchange Server, VSS, Crystal Reports, Business Objects X1R2, Windows XP, MS word, PowerPoint, MS IIS, MS Excel.

Confidential

Role: Business Analyst

Responsibilities:

  • Worked for gathering, analyzing and verifying business requirements and analyzed business technical processes.
  • Worked throughout the SDLC for detailed understanding of requirements, data interfaces, processes deployment.
  • Followed a hybrid of egic planning of budget forecasting and proposed enhancements Waterfall, RUP and Agile approach of development throughout the project.
  • Facilitated stake holders stratto the project through analysis, decision process facilitation, report preparation and tracked defects.
  • Facilitated and conducted JAD Joint Application Development Sessions to determine business requirements by bringing the stake holders and IT team on a common platform and created target questionnaires for both of them.
  • Conducted technical/non-technical presentations to the management and training workshops for the clients.
  • Illustrated the progress and flow of the project to management methodologies using UML and data modeling techniques.
  • Brain stormed the business users and worked as a web site developer to develop, design and code the front end GUI of the application.
  • Made decisions based on the limitations and capabilities of the latest technology.
  • Solved business and technology problems independently and created innovative business solutions.
  • Tracked and maintained Stakeholder requested enhancements and changes using Traceability Matrix.
  • Conducted User Acceptance Testing UAT of the final product with the business users.

Environment: UDAP, MS Project, MS Office 2007, VISIO, DB2, RUP, UML MS-VSS, Quality Center, MS Share Point, NEXUS, QTP, REXX, JCL, EZYTRIEVE, SQL.

Confidential

Role: Business Analyst

Responsibilities:

  • Involved in gathering and documenting the requirements that were critical to the business process and using those requirements to design application software using a Use Case approach.
  • Responsible for writing Functional Requirement Specifications FRS and User Requirement Specifications URS for the IT people and Business Personnel.
  • Verified the business scenarios on new builds to allow extended testing by the QA team and also helped the testing team to expedite User Acceptance and regression testing to meet the production date
  • Responsible for converting the User requirements into business requirements and functional requirements respectively. Managed the Requirements using Rational RequisitePro.
  • Designed the business process model by grouping Use cases and other diagrams into sequence and collaboration diagrams with Rational Rose
  • Used Rational Clear Quest for defect tracking and prioritizing defects and for enhancements after base lining the requirements

Environment: UDAP, MS Project, MS Office 2007, VISIO, DB2, RUP, UML MS-VSS, Quality Center, MS Share Point, NEXUS, QTP, REXX, JCL, EZYTRIEVE, SQL.

Hire Now