PROFESSIONAL SUMMARY

• 8+ years of BA and IT experience across project life cycle (Analysis, Design, Development, Testing, Deployment and Documentation) with in - depth financial knowledge across Healthcare and Banking (loans, credit cards etc).
• Thorough understanding of SDLC methodologies from traditional Waterfall to RUP to Agile/Scrum
• Experience in organizing and facilitating Joint Application Development (JAD) sessions, interviews and workshops with user(s), subject matter experts (SME’s) and business stakeholders.
• Excellent skills in Business Analysis, Object Oriented Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Proficient in producing Business Requirement Development (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS) across the deliverables of a project.
• Exposed in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Prototypes and documenting them using Microsoft Visio.
• Expertise in managing Kanban boards and inventory in focus factory and good knowledge on continuous improvement activities that drive KPI’s.
• Good understanding in managing key stakeholders and risk identification by utilizing RACI charts during requirement elicitation and project planning.
• Conducted User Acceptance Testing UAT, by creating test cases in Rally for the testing team and stakeholders to deliver the end product after every sprint.
• Conducted sessions with end users/clients to gather business requirements and translatingthe same to the development teams.
• Providing traceability across the project by analysis and review of existing test cases in Rally and share the traceability by creating documentation and training materials.
• Well versed in conducting GAP analysis, SWOT analysis, Impact analysis, Cost benefit analysis, Risk analysis.
• Strong knowledge of Scrum Values, Scrum Team, Scrum Events (sprint planning, daily meeting, review and retrospective).
• Extensive experience in creating Scrum Artifacts (Product backlog, sprint backlog, Burnup & Burndown charts and Team velocity).
• Aiming to use project management skills and business analytics experience to achieve project goals of the company.
• Good interpersonal and communication skills, ability to work in a diverse environment and highly desired to learn client’sbusinessrequirements.
• Highly motivated with multitasking capabilities and analytic thinking. Efficient in working alone and in a team, with a proven ability to work under pressure and meet deadlines.

TECHNICAL SKILLS

Methodologies: Agile, Scrum, RUP, Waterfall

Front-End Tools: MS Excel, MS Office, MS Project

Bug Tracking Tools: Rational Clear Case, Jira, CA Rally, TFS

Modeling Tools: Rational Rose, MS Visio, Caliber RM

Project Management Tools: MS Visio, MS Project, Share Point 2010, Version One

Languages: UML, XML, HTML, SQL C, C++, JAVA

Databases: IBM Mainframe, Oracle 12, FACETS, SQL Server, PL/SQL

Web Services: XML, XSD, JASON

Testing Tools: Quality Care, HP ALM, HP Mercury Quality Center, Quick Test pro, SOAP UI, Log defects

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

Senior Business Analyst

Responsibilities:

• Implemented and integrated RUP solutions with complete line of traceability for all the artifacts of web development projects.
• Involved in designing End to End Agile methodology for the mobile and web based projects.
• Gathered Business and Technical requirements through interviews and brainstorming sessions with Stakeholders, Development Team, Data Base Administrators and Services Team.
• Writing and executing system integration test (SIT) cases, modifying documentation system updates, supporting client User Interface Testing (UAT)
• Documented all requirements gathered in JAD/JAR sessions into Business Requirement Document (BRD) and Technical Requirement Document (TRD)
• Developed detailed Use Cases, Functional and Non Functional Specifications using UML notations.
• Acted as a Scrum Master for the Mobile and Web enhancements projects, where some of the daily responsibilities include sprint management, organizing scrum meetings, allocating story points and creating release notes.
• Worked on MS SQL Server environment closely with the Development, QA and Architecture teams to create physical database designs.
• Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level. Followed top down technique for building Business Process Models.
• Developed Use Case Models using Rational Rose to depict Actor and Use-Cases in various Business processes and identification of Basic/Alternative flows and definition of preconditions and post conditions of the System.
• Expert in Excel and strong Experience in data analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.
• Worked with UI team to create the User Interface screenshots to be presented to the Business.
• Examined, analyzed Test plans, Use Case Model, Test procedures based on RUP methodology.
• Performed GAP Analysis for the modules in production, conducted feasibility studies and performed impact analysis for proposed enhancements.
• Created User Interface document (UID), Wireframes, and Prototypes to help developing user interfaces.
• Assisted development teams in Testing for Bug Fixes in the daily builds and turn around for immediate fixes.
• Worked very closely with Developers and resolved any issues they have during development cycles and co-ordinate with Business for any clarifications.
• Create weekly Status reports for Business to track the progress of the project and highlight any deviations from the proposed plan.
• Implemented SQL queries for QA testing and Report / Data Validation.
• Created UAT test cases and assisted team in conducting UAT tests.
• Co-ordinated some minor and major Releases and created Status Reports to communicate with top tier management heads.
• Worked with Project Manager and Development Leads in creating Project Plans and updating the daily tasks.
• Assisted Testing Teams in translating use cases to Test Cases. Also worked closely with Testing Lead in creating and validating Test Plans.
• Involved in developing internal and public mapping tools to assist in pipeline replacement and monitoring. Tasks include managing databases, gathering requirements, designing a user interface and supporting applications post production.
• Tracked all major and minor Bug fixes through completion. Validated production reports and escalated production bugs for immediate fixes.
• Maintained and kept track of stakeholder's request for enhancements and changes using Unified Change Management Tool (UCM) such as Rational ClearQuest and JIRA.
• Used Rational ClearCase, Configuration Management Tool to maintain different builds of the application with description about all changes and versions.
• Created User Manuals and provided User Training for the changes made to Mobile and Website.

Environment: Windows XP/2000, MS SharePoint, MS SQL Server, RDBMS, MS Office Suite (Word, Excel, Power Point, Outlook), JIRA, Rational ClearQuest, MS Visio, Java, .NET, SQL server 2012, SQL, HTML, UML

Confidential, Richardson, TX

Senior Business Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Involved in testing the Pharmacy Claims adjudication and Billing processing is done through PBM (Health Trans) and Claims Accumulation and Adjudication is done through Diamond.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Handled Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes using Business intelligence development studio.
• Performed analysis on ANSI ASC X12 TRANSACTIONS for example 270, 271, 276, 277, 835, 837 and NCPDP VER 5.1 Claim Submission & Claim Response Files to and from PBMs.
• Responsible for architecting integrated HIPAA, Medicare solutions, Facets.
• Documented process flows, process dependencies, and production environment configuration.
• Responsible for understanding pharmacy benefit management (PBM) and pharmacy claims data.
• Played a substantial role in the process definitions and business and functional requirements gathering,in an effort to develop a practical technology solution for automating sales methodology.
• Participated as a core team member of a Clinical Development initiative to create an architectural business end-to-end solution for clinical trials as a standard for all remote data capturing clinical trials.
• Worked with SQL queries using MS Access for data manipulations.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Created macros for preparing test cases in Excel for validating process of P&L tool, order management, Allocation Strategies and Modelling.
• Lead the effort of Data Migration from disparate data sources into normalized data to eliminate redundant information and organizing the tables to easily maintain the table structures.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Managed upgrades for Pharma R&D IM's O/S (AIX, UNIX, and Windows) environments and oversee the successful migration of system data migration requirements.
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Used MS Project to manage project time lines.
• Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Business Objects 6.5.1 & XI R2 are used for Reporting duties.
• Managed internal R&D and client sponsored web based projects.
• Provided data modeling support to each logical data model according specifications of EDM.
• Was responsible for the hardware, software, upgrades, and patching of SharePoint equipment.
• Developed Project Iteration plans using functions and macros.
• Upgrading and Patching of SharePoint and its' related systems.
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Preparation of Tollgate Documents to gather information about the flow of the Purchasing system by visiting various departments in the Plant, interviewing people, meetings with stakeholders.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Created presentations explaining the entire report development process, while drawing a comparison between the legacy & the new report.
• Communicated (formally and informally) with the team regarding PMO Deadlines, Dependencies with other teams and Milestones.
• Modified System flow diagrams using SDLC.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, PL/SQL, Business Objects, MS Visio, RUP, SQL Server, Agile, UML, XML, ASP.Net, Rational Rose 2002, Rational Clear Quest, Rational Clear Case, Rational requisite pro, rational test manager, Rational Robot, Omniture.

Confidential, St. Louis, MO

Business Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Created Requirements Specification Document that translated business requirements into Technical specification including business and validation logic for ease of understanding to the development team.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Creating JIRA workflows (with conditions and post functions), screen schemes, permission schemes, and notification schemes.
• Involved in Requirement Scoping and analyzing high priority requirement for implementation.
• Created Business Requirements Document and converted them into System Requirement Specifications Document.
• Providing weekly story pitches to the development team to ensure sufficient understanding of stories in the sprint backlog, and to support estimations of prioritized items.
• Acting as the product owner during backlog grooming sessions to ensure the development team understands stories to the level needed to size and estimate.
• Participating in standard scrum meetings including: sprint planning, stand-ups, story pitches, sprint reviews, and sprint retrospectives.
• Reviewing and transforming business requirements and converting system requirements into user stories based on missing or new requirements established by project stakeholders utilizing the JIRA tool.
• Performed Requirement Analysis and developed UML Use Cases, Activity Diagrams using Rational Rose to understand the requirements.
• Developed crucial functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specifications, and put in Version One tool.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Object Oriented Design (OOD) using UML.
• Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings.
• Assisted in formulating and defining small project/system scope, objectives and developing detailed systems specifications from which programs will be written and that fit with the client's system architecture standards.
• Monitored SharePoint site activity and recommended changes/updates to improve the customer experience
• Supported SharePoint developer with day-to-day operations; data analytics and reporting tasks
• Monitored content for accuracy and process improvements
• Compiled weekly reports metrics using MS Excel workbooks. Performed MS Excel work using PIVOT tables and complex formulas to manipulate large data structures.
• Worked on Tableau workbook to generate reports based on input data of products to work better on UAT testing.
• Conducted UAT with stakeholders and business users for the validation and got system approvals by conducting UAT sessions.
• Reviewed the Defects entered by the QA team and prioritized the defects and assigned them to the development team
• Prepared UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements.
• Interacted with the users and logged any defects, enhancements from the UAT.
• Used Quality Center for managing the defect flow.

Environment: Agile methodology, Requisite Pro, JIRA, UML, Version One, MS SharePoint, MS Visio, MS Project, PIVOT Tables, Tableau, UST, HP Quality Center

Confidential, Austin, TX

Business Analyst

Responsibilities:

• Gathered legacy business requirements through interviews Customer Service Representatives (CSRs), Customer Relationship Representatives (CRRs), prepared questionnaires, and identified limitations in the current system and GAPS in the proposed system.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Used Rational Rose for creating the Use Cases Diagrams, Activity Diagrams, Class Diagrams, and Sequence Diagrams, etc.
• Performed System Testing of the Claims Processing Systems (Pricing Rules, Duplicate/Limits validation, Member Eligibility, Provider Enrolment).
• Responsible for understanding the Business Process and the Functional Specifications of the entire web sales process that included Underwriting, Evaluation, Enrolment, Membership and Billing, and the Vendors Business Processes.
• Reviewed documents/templates to create BRD and implemented the RUP process, identified Gap Analysis and the AS-IS and TO-BE model.
• Met with various HMO, PPO, Medicaid/Medicare, and Tricare/Campus Representatives discussing benefits of contracts on behalf of facilities or appeals from denials and compliance issues.
• Created Mapping Documents, Report Mockups and modified existing report mockups and finalized for development.
• Created Use Cases, Activity Report, Logical Components to extract Business Process Flows and workflows involved in the project using Rational Rose, UML and Flow Chart Tools such as MS Visio.
• Collaborated with Project Manager to analyze change requests from business side to determine the change of scope and distribution of tasks between mainframe and Business Process Models (BPM) development teams.
• Prepared Business Process Models (BPM) that included modelling of all the activities of business from conceptual to procedural level.
• Presented the requirements to the Development Team and Management in the form of Mathematical Business Rules, Scenarios and User Stories.
• Created and maintained data model/architecture standards including master data management (MDM).

Environment: UNIX, .NET Framework, UML, Rational Rose, MS Project, MS Access, MS Visio, Sybase, SQL, Oracle, MS Office Suite.

Confidential

Jr. Business Systems Analyst/SQL developer

Responsibilities:

• Served as a bridge between stakeholders and technical team members.
• Facilitated meetings and arranged JAD sessions with Business users for requirements gathering.
• Responsible for preparing Software Requirement Specifications (SRS) and Functional Requirement Specifications.
• Captured as-is state of existing process through Visio.
• Created use cases diagrams and activity diagrams.
• Helped In database management and implemented sql queries for retrieving data from database.
• Involved in creation of user Databases and managing security, created stored procedures.
• Involved in up gradation from MSSQL server 7.0 to 2000.
• Created views, SQL joins DTS packages and statements for applications.
• Help maintaining and integrating data through the database.
• Involved in identifying the dependencies and entities of customer data.
• Used SSRS for report generation.