Sr. Business Analyst Resume
St Louis, MO
SUMMARY
- Around 7 years of Business Analyst experience in various fields such as Manufacturing, Banking, E - commerce, Pharmaceutical, Healthcare, and Insurance
- Strong Experience in preparing project deliverables such as Software Project Charter, Business Requirements Documents (BRD), Functional Requirement Documents (FRD)
- Experience in Software Development Life Cycle (SDLC) models such as Waterfall, RUP and Agile methodologies (SCRUM)
- Excellent hands on testing such as Functional, Regression, System, and UAT.
- In-depth knowledge of SQL, UNIX, XML, XSD, Web service, Data warehousing
- Very proficient in Data Modeling, Data Flow Analysis, Transaction Flow Analysis, Alternative Path analysis and Data Security
- Adept in creating and transforming business requirements into software requirement specification(SRS) and designing business models using business intelligence, use case models, analysis models, class diagram and activity diagram
- Experience in working on DB front end like TOAD, DBVisualizer and SQL Server Studio including installation through remote site, setting up logins to different databases and different schemas
- Excellent hands on experience in conducting GAP Analysis to get a clear picture of AS- IS and TO- BE Scenario. Talent in analyzing problems through SWOT Analysis
- Chaired Requirement Gathering Sessions (RGS), Joint Application Development (JAD) sessions and Joint Application Requirement (JAR) sessions and interviewed Subject Matter Experts (SMEs), and updated the requirements
- Excellent knowledge of implementing N- Tier Architecture in web application
- Excellent working experience in TIBCO Business Works, Administrator, Hawk, Adapters, and Rendezvous and Active MQ
- Extensive experience of workflow and process modeling using Use cases and UML Diagrams
- Excellent knowledge Determining Task Dependencies, Identifying Milestones & Monitoring Critical Paths using Gantt Charts, Resource Plans (Schedule & Allocations), Entity Relationship Diagrams (ERD) and Requirements Traceability Matrix
- Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation
- Worked closely with both development and testing teams to improve quality of the application by actively participating in regression analysis and User Acceptance Testing (UAT)
- Excellent understanding of business processes, proven skill set in Business Process enhancement and their documentation.
- Experience in developing Test Cases from Use Cases, reviewing Test Plans and implementing Manual and Automation Testing using Quick Test Professional.
TECHNICAL SKILLS
Application Packages: MS Word, Excel, outlook
Operating System: Windows XP/Vista/7, Linux
Web Development Tool: HTML, Photoshop, JSP, .Net, Visual Basic
Business Analysis: Crystal Reports, Rational Rose, UML
Reporting Tools: Crystal Reports, SQL Server Reporting Services
Project Tools: MS Project, RationalRose, MS Visio
Testing Tools: QuickTestProfessional, Quality Center
Methodologies: SDLC, Waterfall, Agile, RUP
Middleware: TIBCO BusinessWorks, RV, Hawk, Adapters, Designer
Programming Languages: SQL, Oracle, C,C++, Java, J2EE
Database: Crystal Reports XI, Microsoft SQL Server 2005, Oracle 9i/10g, DB2
PROFESSIONAL EXPERIENCE
Confidential, St. Louis, Mo
Sr. Business Analyst
Responsibilities:
- Involved in business requirements analysis for development and creation of business and functional requirement documents based on the project scope and SDLC methodology
- Facilitated meetings with SME’s from various business areas, interviews with stakeholders to gather requirements.
- Performed extensive requirement analysis including data analysis and ‘as is’ and ‘to be’ gap analysis.
- Involved in gathering requirement for a project from scratchplanned and implementation of system enhancements and conversions.
- Handled multiple Projects, new projects and supporting existing projects for globally dispersed users.
- Involved in developing hybrid application on I-pads, the app was developed using Sencha tool.
- Responsible for testing the entire application that was developed to make sure Requirements are met.
- Involved in UAT to walk-through the whole system and resolve any questions or defects arise and take sign offs.
- Coordinated with the 3rd party off shore development from overseas for the Ios based hybrid apps.
- Responsible for performing the deployments on QA and Prod servers. Responsible to lead the deployments including multiple websites, handheld builds, console apps, sync services etc.
- Functioned as the liaison between the business and technical groups during the project.
- Designed and created User interface and documented the functionalities for current process as well as giving operational flexibility for future enhancements.
- Conducted JAD sessions to refine prototypes, prioritize and time-box use cases.
- Designed Prototypes using Axure pro to develop application called as FIDO for Mobile devices.
- Created ER diagram and also created conceptual, logical and physical database layouts
Environment: SAP, MS Visio, Axure, Windows XP/7, SharePoint, MS SQL Server 2008, Agile, Waterfall, Mobile device
Confidential, San Francisco, CA
Sr. Business Analyst
Responsibilities:
- As an Business analyst, involved in gathering all the requirements for the project by interacting and holding sessions with Business group
- Identified, and provided suggestions on improving the application to make it more user friendly
- Managed the development team to ensure coding is done on time, Unit testing is done and codes have been deployed in the respective testing environment for system testing, performance testing, and UAT
- Reviewed Test Plans and recommended changes to update the TP per business needs and made sure those were incorporated
- Identified defects that were locked for the release for the performance and translation related QCs ROI
- Identified Key Risks, impact and change readiness.
- Wrote complex SQL queries to query the DB using Toad to retrieve date required for testing
- Hands on experience on Unix server to run basic commands and scripts and capture log files
- Created document for the testers as to what verbiage need to be validated for translations related QC’s
- Helped in moving from waterfall SDLC to Agile methodologies
- Created AS-IS and TO-BE documents for business review by taking the screen shot on developers local machine
- Conducted daily stand up meeting with dev team for any roadblocks to ensure the progress of the project was on track and on time.
- Responsible for reviewing the RI to make sure all defects have been assigned to the testers for TP writing and execution (both onshore and off shore)
- Implemented cross testing method to improve the Quality of testing
- Involved in the code review comments along with the tech leads
- Developed time lines for project delivery and managed projects and resources to successful completion
- Responsible for weekly status meetings with executive business showing progress of the application.
- Responsible for making sure the business requirements are understood by the dev team and reflects in the application
- Responsible to make sure the estimates given by the Tech leads and QA leads are not very high or low for each release
- Chaired JAD sessions and made sure that the application is built as per the business needs
- Assisted the QA team in designing the test strategy, test cases and test scenarios for system testing and user acceptance testing
Environment: Quality Center, JIRA, UNIX, TOAD, MS Office, JAVA/J2EE, GWT, SQL, Windows XP
Confidential, Chicago, IL
Business Analyst
Responsibilities:
- Gathered core Requirements and done thorough framework Analysis.
- Supported and provided deployment of product enhancements and new functionality. Identified resistance to change through responsive listening skills, pointed out relevant software advantages, provided positive feedback, and follow up support.
- Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
- Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
- Responsible for identifying and documenting business rules and creating detailed Use Case, Conducted User Acceptance Testing.
- Worked with business users for requirements gathering and understanding of user needs.
- Maintain current knowledge of data relationships and system interfaces
- Wrote requirements for high, intermediate, and low-level requirements
- Reviewed and analyzed the business requirements document to derive the functional specifications.
- Designed mock screens for UI screens, reports based on User stories extracting the business process flows and workflows involved in the project using MS-Project, Word and Excel
- Reviewed technical analysis to ensure predefined business requirements were met.
- Considered impact to current and future business environments and processes, assessing the size of the tasks, technical and application complexity, risk analysis.
- Coordinated work plans between project manager and client using MS Project
- Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the application.
- Participated in different management scenarios like Quality Assurance, Defect tracking, system integration, people management and scheduling.
- Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met
- Documented specifications for enhancements by using existing system documentation and procedures.
- Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR)
- Worked with SQL queries for data manipulations as needed
- Configured and used MS-Share Point to maintain all the project related documentation like Project Plans, Requirement documents, Testing documents, Meeting Minutes, Acceptance and Sign-off documents
- Participated in risk analysis, conducted feasibility study and performed impact analysis for proposed enhancements.
- Gathered core Requirements and done thorough framework Analysis.
- Coordinated and conducted Review sessions with the Design and QA team for all test phases: product testing, bug fixes, integration and system testing. Implemented test phase entry and exit quality (UAT) criteria for Release Management.
- Participated in the Application UAT planning Provided Test Scripts and designed the Report outputs to ensure accuracy.
Environment: MS Visio, UML, MS Office, Windows XP/2000, SQL, Java/J2EE, HTML, XML, XSL, MS Project.
Confidential, IL
Sr. Business System Analyst
Responsibilities:
- Involved in Pre-Definition of Project (PDP) calls with Stake Holders and technical team to adopt the project.
- Attended calls with Business Partners to understand the specifications and the end technology that they use.
- Performed risk analysis of the requirements to identify the key business risks areas.
- Coordinated the downstream teams to gather Requirements and prepared Business Requirement Document (BRD)
- Managed Requirements in HP Quality Centre.
- Prepared Functional Requirement Document (FRD) and Technical Requirement Document (TRD).
- Interacted with System architects and prepared Method of changes for this Project.
- Drafted AS IS and TO BE for all the requirements in BRD.
- Prepared Project plan and chaired calls to ensure the dates are realistic.
- Delivered high level estimation and actual estimation
- Actively involved in Test Plan and Test Strategy calls
- Prepared Test Scripts and reviewed the Test Plan.
- Reviewed the test results of testing phases i.e., System Testing, Integration Testing, Regression Testing and User Acceptance Testing
- Updated test results in HP Quality Centre.
- Chaired the Conference calls in UAT Phase
- Actively involved in Deployment and Post Deployment Validation.
Environment: MS Project, HP Quality Center, MS Visio
Confidential, Sacramento, CA
Business Analyst
Responsibilities:
- Gathered requirements for improving cash flow management by enabling the ability to send payments electronically, collect payments and move money across accounts
- Responsible for tracking and recording requirements for transferring money in and out of business and consumer accounts across financial institutions (Dealing with B2B money transfer)
- Supported the design of the payment gateway & reporting gateway.
- Experienced working both independently and in a team-oriented, collaborative environment
- Designed the business requirement collection approach based on the project scope & SDLC Methodology
- Prepared custom reports and performed SQL query, data analysis and verification on MS Access
- Gathered requirements and embedded in BRDs and use cases in Functional Specification Document
- Followed a structured approach to organize requirements into logical groupings of essential Business Processes, Business Rules and Functional specifications, thus ensuring that Critical Requirements are met thoroughly
- Documented test cases during requirements, analysis and design phases
- Designed and developed all Use Cases and UML models using MS Visio and Rational Rose
- Involved in the testing of the application to ensure the right output is gained when executed
- Performed extensive requirement analysis including data analysis and gap analysis
- Conducted several meetings between members of different IT groups and representatives of the higher management to make the “Build or Buy” decision
- Involved in hiring decisions for resources for the project
- Translated the priority requirements into specific goals, objectives, critical success factors, priorities, action plans and deliverables at each iteration using MS Excel, PowerPoint, MS Project, Visio and other MS Office products
- Conducted Sprint Planning Meetings with Project Sponsor, Scrum Master, Team, SMEs/Product Owners, User Representative and Focus Groups to prepare the Sprint Backlog and communicate deliverables
- Co- ordinate with the offshore team that was developing the application
Environment: Rational Rose, Java, HTML, XML, JavaScript, Oracle 10g, MS Visio, MS SharePoint, Windows XP, .NET Framework, Agile Environment, Quality Centre
Confidential, Emeryville, CA
Business Analyst
Responsibilities:
- Business Analysis and modeling activities by interviewing business users from Vaccines Service Centre, Trade, Operations and IT to identify business requirements, workflows and business rules for processes that included Customer Registration, Vaccines Pre Booking, Order Pull Through and Vaccines Ordering database.
- Created wire frames design for clear understanding of the website that needs to be developed
- Excellent ability to maintain complex workflows and field configuration
- Suggested changes in the Architecture of the ordering process by using MS Visio to create a Gap analysis from AS-IS to TO-BE Scenario
- Created use cases and business use cases model after accessing the scope and status of the project and understanding the business processes from USER perspective
- Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues, and come to an agreement quickly
- Developed the Project plan for the phased implementation of the website
- Prepared the BRD for the website novartisvaccinesdirect.com using use cases obtained by in from the stakeholders
- Developed time lines for project delivery and managed projects and resources to successful completion
- Assisted the QA team in designing the test strategy, test cases and test scenarios for system testing and user acceptance testing
- Addressed change management issues during website development and after it went live, prepared the Application Transition Plan for transfer of the application support from the vendor to the support team
- Prepared training material on the website and conducted training for Confidential users that comprised of administrators, sales representatives, Vaccine support Center team
- Created Documentation for future use by the Training and Help Desk teams
Environment: Oracle 9i, MS Office, MS Visio 2003, Windows XP, J2EE, Quick Test Professional
