SUMMARY

• Six plus years of experience as a Business Analyst/ Program Manager across various Industries.
• Extensive experience of Project Planning, Business Requirements Gathering/Elicitation, Liaison, GAP Analysis, Risk Analysis, Data Analysis, Subject Matter Expert, Business Analyst Body of Knowledge (BABOK), Business Process Modeling, and Testing.
• Have sound understanding with entire phases of Software Development Life Cycle (SDLC) and its various methodologies including Waterfall, RUP, RAD, Prototyping, Iterative and Agile Software Development Methodologies (SCRUM).
• Created and tracked bugs in bug tracking systems such as TFS (Team Foundation Server), Team Vermilion and JIRA.
• Extensive experience in User Acceptance Testing (UAT), Post Production Validation and Production Support issues.
• Extensive experience with Business Intelligence Environment/Documentation (Business Objects/Crystal Reports/Reporting).
• Have hands on experience of Project Management Office (PMO) tools (MS project, Gantt chart, and Project Status Reports, Issues Log), and great comfort level with resource planning in Project Plan.
• Conducted and lead JAR/JAD sessions and documented requirements professionally.
• Hands on experience in advanced data analysis techniques in Excel (Nested VLOOKUP, Nested If else statements, Macros, and Pivot Tables etc.), VBA programming in MS Access and Excel.
• Great comfort level with Relational Databases, Database warehousing, Data mining, and Data Analysis (Oracle, MS SQL Server).
• Hands on experience in writing SQL queries using tools such as SQL Developer, MMSS, Toad, Rapid SQL, and DBVisualizer.
• Extensive experience in creating Project Scope, Project Charter, Business Requirements Documents (BRD), Functional Specifications/FRD, Use Case Documents, Use Case Scenarios, Technical/System Specifications, Screen Mock - ups, Wireframes, Site Maps, Requirements Traceability Matrix (RTM), Work Flow Diagrams (WFD), Data Flow Diagrams (DFD), Business Process Flow Diagrams (BPFD), Business Intelligence Functional and Technical Specifications (BI Tech Specs), Technical system and Data Specifications, Test Plans, Test Scripts/Test Cases, User Manuals/Guides and Release Notes documentations.
• Proficiency in creating Business Process Modeling including Use Case diagrams, Activity diagrams, Sequence diagrams, Data-Flow diagrams using UML Methodology, in MS Visio as crucial project deliverables.
• Experience in developing Story Boards, Screen Mockups, and Screen Flows for design feedbacks.
• Work in Excel (filtering, VLOOKUP's, pivot tables, formulas, working across files, creating joint data sets, etc.)
• Understanding of FACETS data modules such as Billing, Provider, Claims and Membership.
• Experience in preparing Test Plans, writing Test Cases.
• Excellent Unified Modeling Language (UML) skills and have hands on experience in creating Activity Flow Diagrams, Use Case Diagrams, Class Diagrams (Object Oriented Analysis) and Sequence Diagrams using modeling tools such as MS Visio.
• Worked as a team lead in many projects and have ability to work independently and with minimal supervision.
• Enthusiastic, passionate and adaptable team player with excellent verbal/oral communication, avid reader, initiative-prone, self-directed, collaboration, facilitation, conflict resolution, multi-tasking, problem solving, analytical and lateral thinking skills.
• Fair knowledge on LIBOR transactions
• Managed UAT process and identified defects and worked with the development team to resolve them. Also performed Go live after smoke testing was done.
• Hands on experience in Java with Restful and Microservices applications
• Extensive knowledge in the CC life cycle including payments
• Strong knowledge on Demand planning, Production Scheduling, Forecasting, Supply chain collaboration, Replenishment process, and Order management

TECHNICAL SKILLS

Up Screens: MS Visio, Rational Rose, SmartDraw, Mock

SDLC Methodologies: Waterfall, Waterfall Scrum Hybrid, Agile (Scrum)

Business Skills: Process Modeling, GAP Analysis, Impact Analysis, Risk Analysis, JAD Sessions, SWOT Analysis.

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Data Dimensions.

Project Management Tools: MS Project, MS SharePoint Server

Requirement Management: JIRA, Rally, HP ALM, MS Office, Confluence, ClearQuest.

Testing Tools: HP QC, HP ALM, Bugzilla, Selenium

Reporting/ ETL Tools: Informatica, Tableau, IBM Cognos, MS Excel, Talend

Requirement Management Tools: JIRA, AP ALM, RALLY

Databases: MS SQL Server, Oracle, MS Access

Languages: HTML, XML, SQL, .Net, Java

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Gathered High Level Business Requirements (HILBERs) from client and stakeholders through interview process.
• Created and developed Business Requirement Document (BRD) and Functional Requirements Document (FRD).
• Analyzed and managed cross-functional existing/planned business processes impacts.
• Developed feasibility and Project risk analysis to ensure requirements can be met.
• Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams, activity diagrams, Sequence Diagrams using MS Visio according to UML methodology.
• Wrote Use Cases descriptions including pre-conditions, assumptions, normal flows, alternative flows, post-conditions, notes, and issues.
• Coordinated Virtual Meetings with business clients, stakeholders, end users and various development teams including testers to discuss project progression reports and to gather new requirements.
• Identified and created Use Case diagrams with business process workflow diagrams including Activity, Sequence and from the requirements.
• Working on understanding different Modules of Facets such as Members/subscriber, commissions, provider, billing, and plan.
• Worked on developing the business requirement and use cases for FACETS batch process, automating the billing entities and commission process.
• Used detailed knowledge of application features, architectures, and functions to assess scope and impact of business needs throughout analysis and through the completion of all enhancement specifications.
• Conducted Joint Application Design (JAD) sessions for communicating with all project sponsors and stakeholders.
• Documented Requirements, Test Plan, Test Cases, Defects and Change Controls in Quality Center.
• Communicated the project status to clients bi-weekly, highlighted changes made in requirements and gathered new requirements.
• Conducted User Acceptance Testing (UAT) with users and project team member

Environment: Unified Modeling Language (UML), Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Project 2010, Microsoft Visio, Adobe Reader, Rational Unified Processes (RUP) methodology, SDLC, Agile, FACETS.

Confidential

Business Analyst

Responsibilities:

• Conducted interviews/meetings with business teams to understand various reporting requirements gap and other regulatory requirements.
• Performed gap analysis on the new requirements and identified 50 plus possible source systems that could source relevant data for those requirements' gaps.
• Documented all the new requirements related to gap and created tracker with daily and weekly progress.
• Conducted meetings with various source systems to clarify the requirements and bridge the gap among system teams to finalize the data requirements.
• Created project plan for data sourcing effort to track the progress and follow the weekly release plan.
• Created and tracked various JIRAs for ALM and EDS (Enterprise Data Service) data sourcing items.
• Follow the JIRAs workflow appropriately till the items were closed.
• Created Business Functional Specs and Test plans/cases for various data sourcing efforts.
• Follow the proper procedures and processes to document all the steps from DEV to QA to UAT to PROD phases.
• Extensively wrote SQL queries in MS SQL Server Management Studio.
• Performed data analysis using advanced SQL like Inner Join, Left Join, Right Join, Subqueries and Union etc.
• Extracted the data using the advanced SQL like Select
• Managed/worked with offshore DEV and QA teams and worked with them to ensure successful implementation of the requirements.
• Worked with the architect team to design staging and slowly dimension tables
• Worked with development team to create the ETL processes for data loading and moving data to SCD tables.
• Created work flows and Operational Meta Data on EDS (Enterprise Data Service) environment to source outbound files
• Created end to end work flows for outbound feeds.
• Worked with business on sourcing customer data. Performed data analysis and identified the gaps.
• Performed extensive data analysis on available MKT data in ALMIS and identified the data gaps (Securities Reference data).
• Performed monthly No Harm test for MKT APIs and closely worked with business and development teams.
• Created test cases for MKT No Harm test and updated the JIRAs appropriately till the post production validation.
• Performed validations on various reporting data elements and worked independently on the data quality and data remediation.

Environment: Waterfall, Java, Spring, Hibernate 3.0, JSP, JavaScript, Tiles, CSS, Web sphere 5.1,6.1,7.0, SQL, Apache, MS Office (MS Word, MS Excel, MS PowerPoint), Rational Rose, MS Visio, HP QC, Rally, Swagger, Postman.

Confidential - Houston, TX

Business System Analyst

Responsibilities:

• Create and maintain communication plans between business and IT teams during development and implementation.
• Work with business and IT teams to develop and verify systems based on business requirements.
• Determine operational objectives by studying business functions; gathering information; evaluating output requirements and formats.
• Provide appropriate IT direction to support the day-to-day and strategic operations for the account.
• Responsible for delivering to stakeholder requirements and timelines as well as tracking and managing project risks and issues, including identifying impact and resolution plans.
• Develop, document and facilitate user acceptance test plans to ensure fulfillment of requirements and successful project implementation.
• Develop user stories and to-be process flows to support the design and development of solutions for our clients.
• Collaborate with developers to test and verify that solutions will meet the business requirements.
• Participate in key meetings with clients including requirement sessions, system demos, user acceptance testing, and end user training.
• Communicate effectively using strategies such as group sessions or one on one interviews to capture and document requirements.
• Participate in daily scrum call meetings to discuss the project, report issues, and ways to solve those issues.
• Independently and collectively create appropriate project documentation while managing change for the entire life of the project using the Software Development Lifecycle model.
• Maintain strict security guidelines to safeguard data.

Environment: Agile Scrum, Rally, UML, Quality Center, MS SQL Server, Excel, Word, MS Visio, Nice Actimize

Confidential

Business Analyst

Responsibilities:

• Interacting with the stakeholders in order to perform document analysis and GAP analysis . Also assist the Product Owner and Project Manager in planning the transition.
• Researched on the Fair Credit Reporting Act (FCRA), Check 21 Act and also Fair Debt and Collection Practices Act (FDCPA), for better understanding of the required functionality .
• As a Moderator, facilitated the JAD sessions and conducted interviews with various SMEs, conducted process reviews and policy & procedure reviews to elicit requirements.
• Analyzed and validated the Business Requirement Document (BRD) and Software Requirement Specification (SRS).
• Assisted in analyzing and building the Use Case Diagrams, Activity and Sequence diagrams using MS Visio .
• Assisted Data Modeling process by creating Conceptual and Logical ER diagrams and designing Database Schemas to help development of an accurate Data Warehouse Structure .
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries .
• Proficient in writing SQL queries using Joins, Group-by, Order-by and aggregating functions to join data from multiple tables and also created tables using DDL and manipulated tables using DML . Also used pre-executed SQL queries like Stored Procedures, functions and Triggers .
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as a Reporting tool. Whilst maintaining the Bill Inmon and Ralph Kimball Paradigms .
• Worked on Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Performed ETL analysis, designing, developing, testing and implementing ETL process including performance tuning and query optimizing of databases.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
• Worked with the QA to design and develop the Test Plan and Test Cases to perform User Acceptance Testing ( UAT ), Functional testing and Regression testing by utilizing HP QC and HP ALM .
• Performed manual testing for the system, integration and User Acceptance Testing (UAT).

Environment: Waterfall-Scrum, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, Informatica, MS Visio, HP ALM, HP QC, My SQL Server, Swagger, Postman.