Summary

• Relevant job knoweldege and expertise
• 8 years of experience as a Business Analyst/Business System Analyst in industry domains including Financial, Healthcare, Property Casualty Insurance, Retail Banking, e-Commerce, Pharmaceuticals, and Supply Chain.
• Experienced within Individual Retirement Accounts IRA , Employer Sponsored Retirement Plans ESR , Fixed Income Investments, Capital Market, and Wealth Management domains.
• Articulate, confident, and able to communicate comfortably with all levels of the company.
• Experience with re-engineering and implementation projects.
• Extensively involved in Data Governance process.
• Worked in various technologies such as XSLT, XPATH, CSS, XML, and HTML.
• Key contributor to projects by leading the analysis, design, and implementation of solutions.
• Experience/understanding of business process re-engineering and business modeling concepts, business systems development and analysis.
• Proven experience with end-to-end business process mapping, business and technical requirements analysis, business planning, modeling, verification and methodology and product development.
• Ability to coordinate with user groups to provide training, resolve issues, assess user needs and recommend alternative solutions to meet their business requirement.
• In-depth experience on migration of legacy applications using parallel and phased adoption methods, understanding the big picture, and ensure scope and requirements of projects are met through the implementation.
• Experienced with Medicare, Medicaid, Medicaid Expansion, Duals, Marketplace, Healthcare Benefits Administration, Affordable Care Act/Health Care Reforms.
• Experience in Medicaid Management Information System MMIS . Expertise in various subsystems of MMIS- Claims, Provider, Recipient, Procedure Drug and Diagnosis PDD , Explanation of Benefits EOB .Experienced working on EDI file protocols and transactions in implementing eligibility, Confirmation, Claims and Remittance Advise systems.
• Conversant with industry standards such as HL7, x12N, DICOM and NCPDP.
• Capable of independently and proactively leading/facilitating efforts to identify opportunities to leverage technology to enable business success.
• Experienced in IBM Security Identity and Access Management IAM , and IBM Master Data Management MDM implementation.
• Ability to effectively communicate across multiple levels Executives to team members .
• Ability to communicate technical issues to non-technical individuals.
• Strong understanding of Retail Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative OTC Back-Office operations.
• Knowledge of Anti Money Laundering AML and Bank Secrecy Act BSA . Working knowledge and understanding of Suspicious Activity Reporting SAR ,and OFAC reports.
• Extensive hands-on experience in eliciting, defining, documenting, business, functional, non-functional requirements, decomposing high-level information into details and in critically evaluating information gathered from multiple sources.
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements using Joint Application Development JAD , Rapid Application Development RAD , and Brainstorming sessions, identify Functional, Non-Functional, and Business Rules, and then subsequently model them.
• Skilled in business process analysis use case, user experience design, storyboards, wireframes, user profiles and user stories and mapping gap analysis techniques, conducting Joint Application Development Sessions, SWOT analysis, Cost Benefit analysis and ROI analysis.
• Skilled in Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Unified Modeling Language UML using MS Visio and Rational Rose.
• Demonstrated ability to work actively with different Design Tools to create Use Cases and UML diagrams such as Use case diagrams, Work Flow Diagrams/Process Flow Diagrams and Entity Relationship Diagrams, Swim Lanes, and Data Flow Diagrams.
• Extensive database experience using Relational Database Management Systems RDBMS Oracle, PeopleSoft, MS Access and SQL with solid understanding of primary, foreign key constraints, strong and weak entities attributes.
• Strong SQL knowledge for querying the database and proficient in developing External Tables, Joins, Indexes, Data Modeling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.
• Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing.
• Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing UAT .
• Proficient in understanding of the customer's needs and defines a Product Backlog re-prioritizes the Product Backlog based on customer feedback, market changes and business priority.
• Experience with various Software Development Life Cycle Methodologies such as AGILE Scrum , Iterative Incremental Development, RUP Iterative, and Waterfall Model etc.
• Excellent ability to converse, negotiate and liaise between the business units, technology teams and support teams.
• Knowledge of Business Intelligence and Data warehousing tools

Technical Skillset

• Web Technologies HTML, DHTML, XML, CSS, XSLT, JavaScript
• Software Applications MS Office, MS Project, MS Visio, MS FrontPage, Dreamweaver, Adobe PhotoShop
• SDLC Methodologies Waterfall, RUP Rational Unified Process , Agile Scrum
• Requirements Management Rational ClearCase, Requisite Pro, Use Cases, User Stories,
• QA/Testing Rational Clear Quest, Team Foundation Server, HP Quality Center 11, Quick Test Professional, LoadRunner
• Project Management MS Project PERT, Gantt charts , Excel spread sheets
• Operating System Windows 95 2007, NT/2000/XP, LINUX, UNIX, DOS
• Design Tools Rational Rose, MS Visio UML
• Database Microsoft SQL Server, Oracle 10g 11g, PeopleSoft, Lotus Notes, MS Access
• Change Management Stakeholder Analysis, Change Classification, Prioritization, Implementation

Professional Experience

Confidential

Business System Analyst

Responsibilities:

• Gathering requirements from Business Line Mangers and SME's for the redesigned Great West Client Portal, Client Database and to Digitize the Transactions
• Perform system and document analysis to understand the current systems
• Develop Process Model and detailed Business Policies and documenting the same in Business Requirement Document
• Prepare High Level Process Flow Diagrams and Business Process Flow diagrams for Great West Client Portal functionalities in Visio
• Develop Use Case diagrams, Use case Narratives and User Stories.
• Administered Identity and Access Management IAM , including password management controls for staff and vendors assigned to department-level projects.
• Prepare Wireframes, Prototypes and Mock up screens for different web pages.
• Develop Customer Database Mapping Document and Digital Transactions Mapping Document to map all Policy Administration Systems
• Identify the required fields for Client Database from Client extracts and Contract extracts from different Policy Administration Systems
• Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints, also created a Business Requirement Document for management.
• Created and Managed User Stories in Epics, Themes and Sprints also calculated velocity and Story-points in TFS. I was also part of the team that assessed and analyzed TFS, HP Agile Manager and Green Hopper as Agile ALM tool
• Coordinate with offshore team in documenting the gathered Requirements in to BRD's and FRD's
• Interact with SOA architects for developing Integration Service Bus ISB Enterprise Service ESB
• Worked closely with System Architect to implement Service Oriented Architecture SOA , Client side Validations, Server side Validations, Web Method definitions and data modeling.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Develop Service Mapping Documents to map UI Literals to Administration Systems
• Help developers understand Business Requirements and design for Graphical User Interface GUI , Client Database and Digitize Transactions
• Coordinate with QA team to determine and develop Test Plans, Test Cases and methods for Unit Testing, Integration and Functional Testing based on testing requirements
• Participate in User Acceptance Testing UAT and developed Training Manuals
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.
• As part of MDM implementation, involved with validating and testing user accounts validating the suspect and collapsed data Created dummy accounts to validate against the back-end and the front-end data.
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data.
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.
• Perform data validation using SQL queries and run ad-hoc queries to show data to the business users

Environment: Business Objects, Cognos 8.4, Informatica, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer, IBM Master Data Management MDM

Confidential

Business System Analyst

Responsibilities:

• End to End working experience of Medicare, Medicaid, Duals, Hospice, LTSS, Vision, Dental, Pharmacy and behavioral health benefits projects from Patient/Member Eligibility, Patient/Member Registration to Patient/Member departure.
• Experience with Patient Billing, Payer Compliance, Payer Reporting and Analytics.
• Worked with HIPAA 4010 implementation in designing EDI X12 837,834,278,270 transaction to the newly implemented Duals System.
• Propose strategies to implement HIPAA 4010 in the new MMIS system and eventually move to HIPAA 5010
• Interviewed the stakeholders to gather high level requirements.
• Responsible for gap analysis in changing old MMIS to new MMIS.
• Performed workflow analysis toward automated disability claims process.
• Experience with Clinical, HL7, CCDs, EMR and EHR projects.
• Assisted in re-engineering the company's core claims adjudication processing following BABOK standards and extensive use of the BABOK guidelines and practices as commissioned
• Implemented Healthcare Enterprise Core Administration Platforms such as FACETS and Electronic Health Record Practice Management applications such as NEXTGEN. Also involved in migrations and customizations of these systems.
• Experience in migration of clinical data from ICD 9 to ICD10.
• Designed and Developed various Business Intelligence reports against ODS, Claims systems such as Facets, HER systems such as NEXTGEN and Care Management systems, Network Management systems, Revenue Cycle Management systems.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services SSAS .
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI's in SSRS.
• Developed solutions in compliance with the industry models / standards and implementation of Quality Management Systems and HIPPA regulation.
• Converted the logical request and response documents into the physical XML schema, compile a Data Dictionary and convert the logical data model into a physical data model that will be implemented within SQL Server RDBMS.
• Develop interfaces to third party system and create business rules and data transfer mappings using XPath, XSLT,and XML.
• Designing and Implementation of XSD schemas using XML Spy Tool keeping reusability in view across the systems.
• Responsible for Change Management Processes Identify, Analyze, Evaluate, Plan, Implement, Review and Close .
• Analyzed customer needs and existing functions in the area of HIPPA transactions to determine feasibility, consistency with the established scope of work.
• Clearly understood coding standards required for all Medicare Part D Users transactions involving electronic data interchange as provided by department of health and human services and incorporated at every stages of the project wherever found necessary.
• Aided management in standardizing web applications by preparing GUI standards and recommending alternatives for incorporation in a phased, iterative manner.
• Performed Requirement Analysis and developed Use Cases and Activity Diagrams.
• Prepared user stories using JIRA. User stories are dissolved to the granular level and are supported by acceptance criteria which are in turn used by both development and QA team for both development and testing throughout the iterations. Also was involved in writing test cases for checking the functionality of the processing system constructed.
• Used teamcenter to track the deadlines of different versions.
• Uploaded all the sign off documents on teamcenter so it can be accessed by any team when required.
• Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Created SSRS reports from raw data to answer executive management questions on many topics.
• Developed Test Strategy and Test Plan to ensure that test cases reflect user needs for functional, performance, and usability and security requirements.
• Performed Functional Testing, System Testing and Regression Testing by executing all the prepared Test Cases.
• JIRA has been thoroughly used for maintaining the Test Plans, Test Cases repositories along with the Defects.
• Understood the business logic, user requirements, and test-objectives to develop test plans, test cases, use-case scenarios. Tracked and assigned defects to the associated teams.
• Involved in writing SQL queries to test the mappings and to track the requirements as per the user requirements.
• Co-authored functional specifications, business requirements specification BRS , use-case specifications, and systems requirement specification SRS with the business group, and the IT team members.
• Performed defect tracking and bug reporting using Quality Center and coordinated defect fixes in specific build releases with the Development and Project Management teams.
• Created the Requirements Traceability Matrix RTM by mapping the Test Cases to ensure all the Business Requirements are fully covered by the Test Cases
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Validated the following: 837 Health Care Claims or Encounters , 835 Health Care Claims payment/ Remittance , 270/271 Eligibility request/Response , 834 Enrollment/Dis-enrollment to a health plan .
• Involved in creating requirements that comply with HIPAA and HL7 regulations to protect the privacy of the employee insured under any policy and also regulations for claim submission that is required by Medicare and Medicaid policies.
• Used SDLC System Development Life Cycle methodologies such as the Agile Scrum and the waterfall.

Environment: Sybase Power Designer, MS Visio, MS SQL Server, Team Foundation Server, C , Visual Studio, Biz talk Server, MS Office Suite,MS Project Professional, MS SharePoint Services, Visual C , Web Services, XML, XSD, XPATH, Spy 2010, XSLT, EDI X12, Trizzetto FACETS, Mainframe, DB2

Confidential

Business System Analyst

Responsibilities:

• Liaison between stakeholder's system users, clients and managers, software development team and the QA team to gather requirements.
• Created targeted Questionnaires for SMEs to gather requirements.
• Facilitated JAD Joint application Development sessions to identify the business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Involved in Requirement Scoping and analyzing high priority requirement for implementation.
• Studied and analyzed competitor's applications and brainstormed to gather effective requirements for a quality product.
• Extensively used MS Visio to create Mockups, screenshots and Wireframes based on the requirements elicited for the mobile application
• Created Business Requirements Document and converted them into System Requirement specifications Document.
• Followed the RUP methodology right from inception to the projects transition.
• Participated in Design walk-throughs with SMEs to baseline the business architecture.
• Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application. Created reports using formulas such as Vlookup, goal seek and pivot tables
• Analyzed Requirements and created Use cases, Use Case diagrams, Activity Diagrams using Enterprise Architect
• Created and managed project templates, use case project templates, requirement types and traceability relationship in RequisitePro.
• Coordinated with the development team, database team, data warehousing team and QA team throughout all phases in the RUP methodology.
• Assisted QA Team in writing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were catered to by the application.
• Coordinated with test team with Data Mapping to articulate better transfer of data and performed backend testing using SQL queries for data validation.
• Made detailed research analysis prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, Exotic Options.
• Coordinated with various data feeds Reuters, Bloomberg, Markit for market data, reference data, counterparty data, and credit data mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics
• Performed detailed analysis and work flow diagrams for derivatives trading which included - preparation of market reference data, analysis decision support, modeling a contract, preliminary instrument setup on the application
• Archived all project documents and implemented the UCM model for activity-based configuration management using Used Rational Clear Quest for defect tracking and change management request and reported them.
• Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Environment: Rational Rose, Requisite Pro, MS-Visio, MS-Excel, Microsoft Project, Oracle10g

Confidential

Business Analyst

Responsibilities:

• Gathered, analyzed, refined, and interpreted business requirements Business and converted them into functional requirement specifications.
• Documented business rules, understood the business need, added new Customer experience features Update Content for Enrollment, Add Payees and provided Screen Layout Specifications for the SRS document.
• Selected the appropriate elicitation technique to efficiently identify critical requirements and prioritized requirements by conducting brainstorming sessions with the back office portfolio management and sign offs on requirement artifacts from project managers.
• Determined the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.
• Executed two week iteration and worked with the cross-functional mobile application team to ensure that all the requirements were compliant with overall project goal and scope for mobile and web based products.
• Led numerous JAD, mitigation, and negotiation sessions with key stakeholders to discuss alternate solutions for Process improvement.
• Worked with the Remediation team to identify and analyze the ISA Information Security Administration functions to check for compliance and open CAP Corrective Action Plan , RA Risk Acceptance or RE Risk Exception for AML Anti Money Laundering , Bond trading and Fraud prevention applications.
• Participate in knowledge transfer meetings and discussions with consumer management and BSA/AML Officer.
• Worked on various credit card applications to ensure PCI compliance and perform other ISA functions Information Security Administration .
• Analyze the new regulatory requirements of Dodd Frank and Basel Accord III for Pillar 1,2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
• Facilitated group meetings, one-on-one interviews, and correspondence through emails to manage change control process and to discuss the impact of change request on the project.
• Conducted Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current AS IS environments versus the Target TO BE environment
• Used Enterprise Architect and exercised UML methodology in creation of UML diagrams such as, Activity and Use Case, Context diagrams.
• Initiated and exercised various strategies involved in website Usability, Functionality, and Compatibility testing.
• Closely interacted with developers and System Architect to understand customer site navigational flow, to identify bottlenecks, enhance site navigation, and increase customer satisfaction.
• Assisted the project team to enhance the Personal Loans, Credit Card, Internet Services, Mortgage Services divisions and Mortgage payments functions.
• Created Test Plan document, test cases, test scripts and expected results for UAT.

Environment: RUP SDLC, Risk Management, Enterprise System, Core Banking, MS Project, MS Access, Dreamweaver, Mobile Application, MySQL database, IBM Requisite Pro.