Professional Summary:
*+ years of experience as a Business Analyst/Business System Analyst in industry domains including Healthcare, Property & Casualty Insurance, e-Commerce, and GIS. Experience with re-engineering and implementation projects. Extensively involved in Data Governance process.
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.
Worked in various technologies such as XPATH, CSS, XML, and HTML.
Key contributor to projects by leading the analysis, design, and implementation of solutions.
Proven experience with end-to-end business process mapping, business and technical requirements analysis, business planning, modeling, verification and methodology and product development.
Clear understanding and innovative in designing the Burndown Charts.
Experienced with Medicare, Medicaid and Duals.
Extensive hands-on experience on Health Care Claims processing.
Experienced with High-level knowledge of both ICD 9&ICD 10; Initiation, Planning, Execution, Control and Project Closure; Ability to plan and implement information technology strategies and build teams for large-scale technology implementations.
Experienced working on EDI file protocols, performed detailed analysis of inbound and outbound interface data feeds and transactions in implementing eligibility, Confirmation, Claims and Remittance Advise systems.
Preparing, interpreting, inspecting and revising drawings, plans, diagrams, maps and charts using ‘ArcGIS software’, which is a GIS tool.
Collect, store and analyze data needed for supply chain metrics in identification of root cause for continuous performance improvement.
Create supply chain performance reports, ad-hoc analysis, and dashboards.
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.
Worked on several RFP projects for various companies. - Managed, researched, wrote and edited multiple product responses for Request for Proposals (RFP), Request for Information (RFI), Request for Quotation (RFQ), Statement of Work (SOW) and Standard Operating Procedures (SOP).
Skilled in Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, Sequence Diagrams, Unified Modeling Language (UML) using MS Visio and Enterprise Architecture.
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 E-R Diagrams, Swim Lanes, and Data Flow Diagrams.
Experience with databases like Relational Database Management Systems (RDBMS),Oracle, PeopleSoft and MS Access.
SQL with solid understanding of primary, foreign key constraints, strong and weak entities & attributes. SQL tools with a working knowledge of relational databases and structure.
Proficient in executing Test Plans, providing Test Data, documenting Test Cases and in performing User Acceptance Testing (UAT).
Experience with various Software Development Life Cycle (SDLC) Methodologies such as AGILE (Scrum), Iterative & Incremental Development, RUP Iterative, and Waterfall Model.
Technical Expertise:
Domain
Healthcare, Property & Casualty Insurance, e-Commerce, and GIS
Methodologies
Agile, Agile/Scrum, Waterfall
Requirement management tools
Blueprints, Rational Requisite Pro, DOORS
Business Modelling tools
MS Visio, Enterprise Architecture, Balsamiq, Pencil, Rational Rose
Testing Tools
Selenium Web Driver, TestNg
Bug Tracking Tools
HP Quality Center/ ALM, Jira, Clear Quest, BugZilla, Rally
Document Creation/Management
MS Office - Word, Excel, Outlook, PowerPoint, MS Project, O365
CRM
Salesforce, PeopleSoft
BPM tools
Pega
Content management
MS – Share Point
BI/ Reporting tools
Crystal reports, Cognos, Informatica, Business Objects
Database
Oracle, MySQL, SQL
Language
HTML, XML, Java, SQL
Operating System
Windows, Unix
Experience:
Client: AIG, NY 2014 Aug-Till Date
Role: Sr. Business/Systems Analyst
Project: Enterprise Insurance Risk Management.
Project Description:
AIG is leading insurance company providing insurance for commercial, institutional and individual customers. Insurance underwriting activities are performed globally directly through AIG Underwriters and third party brokers. The project objective is to build a Data warehouse that integrates AIG existing policy management systems. This application was to integrate the property and casualty policy management systems and extend functionality for Enterprise Risk Management.
Responsibilities:
Extensively worked in Agile frame work throughout all the phases of Software Development Life Cycle (SDLC)
Worked with the business to document and develop formulas for the calculation of premiums and losses statistics in the marts.
Performed requirement gathering using both formal and informal sessions through interviews, NetMeeting, questionnaire, video conferencing, JAD sessions and conference calls.
Performed requirement analysis by gathering both functional and nonfunctional requirements based on interactions with the Users.
Worked on risk reporting requirement for Commercial casualty lines of business, Product Liability, CGL Package and Pollution Legal Liability
Experienced on working as SharePoint Admin, Manage Permissions and create Sub Sites in SharePoint
Created Workflows in SharePoint to help Project manager's route documents for automated approval process
Knowledge on creating Web Parts in SharePoint Sites and Organizational Structures
Creating Standard Operation procedure and updating some existing Standard Operation procedures for SharePoint O365 sites
Assessed and documented the flaws in the existing AS-IS system and made clear recommendations of Business Process Automation and incorporated them in the future TO-BE system design to perform Gap Analysis.
Made Screen Mockup, Wireframes and screenshots for the application to easily communicate it to the users, developers, and testers.
Created UI Design Diagrams and consulted users as well as developers using Just in Minds prototype.
Developed various UML Diagrams such as Timing diagrams, business flow diagrams, Activity diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
Used MS Project and assisted project manager in making Project Plan with necessary modifications.
Actively participated in, group and individual based, problem solving and decision making throughout the different phases of Agile. Authored progress and completion reports, which were then submitted to project management on a weekly basis.
Wrote SQL statements to extract data from the tables to validate data flow
Gained expertise on Change Management by performing Impact Analysis for Change Requests obtained during Scope creep.
Worked closely with the QA team in defining defects and planning necessary test cases for resolving the defects within the given time box.
Conducted User Acceptance Testing (UAT) to ensure all the business requirements have been fulfilled by the application.
Conduct a smoke testing after each build and Post Production Validation after each release.
Prepared user manuals and conducted training sessions.
Environment: O365, Windows 08/10, Java, Oracle 10g, HP ALM system Informatica, SharePoint 2013, Salesforce.
Client: RSA Medical – Naperville-IL 2012 May-2014 June
Role: Sr. Business/Systems Analyst
Project: ACA project of the HCR system & enhancements for ICD -10
Project Description:
RSA Medical is a leading provider of medical assessment and medical management for patients interacting with life and health insurance companies. By combining both medicine and sophisticated proprietary technology, clinicians are improving the manner in which insurance carriers grant services to patients and interact with providers. This project’s objective is to identify the data elements deemed to PHI (Protected Health Information) as HIPAA Regulation, Created Meta data for encryption engine. I provided ongoing support and expertise to insurance companies and medical professionals through comprehensive assessment, planning, implementation, and overall evaluation of individual patient needs.
Responsibilities:
Worked extensively on HCSC system, which is a Blue Cross Blue Shield medical management system (Similar to HEDIS Management System).
Good Understanding of BCBS FEP and its claims processing for both in & out of Network Providers.
Decent knowledge of FEP yearend Benefits comparing with Patient’s Out-of-Pocket Expenses.
Data analysis to support 4010 to 5010conversion.
Trends break analysis and History data conversion to new layout.
Data Analysis related to ICD9 to ICD10 qualifiers.
Worked in ImagineIS project management environment for updating the codes.
Experience and working knowledge of local, state and federal laws governing medical records, health insurance dealing with CMS and DOM rules, deadlines and turnaround times.
Maintain ongoing communication with state agencies to determine state-specific requirements for health information exchange (HIE) and Medicaid EHR Financial Incentive programs.
Reviewed existing system manuals, design documents and user guides and created As-Is Business Process flows.
Facilitated JAD sessions to confirm understanding of the As-Is Business Process.
Interviewed business users, SMEs, end users and gathered requirements for To-Be Systems.
Defined Project Scope and created Business Requirements Document (BRD).
Facilitated Requirements walkthrough with Business and IT stakeholders and prioritized requirements across releases.
Assisted the Project Manager in building the product release roadmap.
Created Detailed Functional Specifications based on the high level requirements.
Traced Business Requirements (BRD) to Functional Requirements using Requirements Traceability Matrix.
Coordinates the preparation of the annual medical record review project which includes MOCK refinement, test run and analysis.
Assists in the preparation of the annual HCSC Compliance audits.
Works with the corporate HCSC team (similar to healthcare systems like HEDIS) to monitor accuracy of data and methodologies when assigned.
Participates in scheduled meetings with the corporate HCSC team and vendors, HCSC auditors.
Coordinated with the offshore development teams and acted as a primary point of contact for Requirements/Business Rule clarification.
Assisted Quality Assurance Testers in preparing System Test Cases and clarified Requirements.
Prepared User Acceptance Test Cases and ensured that all Business and Functional Requirements are adequately covered by the UAT Cases.
Perform detailed analysis of inbound and outbound interface data feeds
Performed Business Requirements, Functional Specifications, and UAT walkthroughs with the team members and incorporated modifications and obtained Sign-off.
Produced clear user manuals & training guides for User Acceptance Testing (UAT) and deployment with step-by-step instructions and created appropriate GUI screenshots.
Interacted with the Data Modelers and Data Warehouse teams to understand the designing of the new data warehouse.
Used SQL to query the existing data warehouse. Required data was exported to an excel sheet which was then provided t+o the Business Intelligence team for their analysis purposes.
Created Data mapping documents to support migration of data from Legacy to New systems in cross-platform environment.
Environment: EDI, Java, MS Visio, ImagineIS, MS SharePoint Services, MS SQL Server, MS Project, MS Office, Windows 2000.
Client: Cardinal Health - Dublin, OH 2011 March -2012 April
Role: Sr. Business/Systems Analyst
Project: EDI Enhancement.
Project Description:
Cardinal Health is a leading provider of products, services, and technologies supporting the healthcare industry. The Medi Pharma online service was designed to deliver refill medication to follow-up, disabled and elderly patients at their homes without the necessity to visit the physician. I was involved in implementing HIPAA EDI transactions in the application; also involved in modules: Pre-pricing claims, Claims Adjudication, Claims Payment, Coordination of Benefits (COB) and Adjustments.
Responsibilities:
Conducted meetings with business process owners, SME (subject matter experts) and Trading Partners for requirement gathering during the Definition Stage.
Analyzed data/workflows, defined the scope, and performed GAP analysis.
Analyzed the data movement between systems, validated the business requirements.
Worked on data mapping to bring data from one system and reside in another system.
Created use cases and maintained traceability matrix.
Worked on claims processing, payment adjustments, claims inquiry, benefits.
Conducted JAD Sessions to understand the detailed requirements.
Actively participated in status report meetings and interacted with developers to discuss the technical issues.
Conducted walkthroughs and defect meetings sporadically to assess the status of the testing process.
Created Process Models for (a) initial enrollment, first billing and payment and (b) post enrollment - subsequent recurring billing and payment.
Created Swim Lane Diagrams and business spreadsheets for various business processes.
Followed Workgroup for Electronic Data Interchange standards for testing
Conducted UAT (user acceptance testing).
Environment: EDI, Java, MS Visio, MS SharePoint, MS SQL Server, MS Project 2007, MS Office, Windows 2007.
Client: eBay 2010 March– 2011 Feb
Role: E-commerce Business/Systems Analyst
Project: Web Commerce E retail.
Project Description:
The purpose of the project is to manage and enhance the eBay.com and provide an optimized seamless user experience across web and mobile channels. Assigned to multiple engagements based on demonstrated skills in business analysis and customer relationship management. I worked on various aspects of the project including Project Management, Business Analysis, Systems Analysis and Testing.
Responsibilities:
User Requirements gathering by interacting with stakeholders and other management personnel to get a better understanding of the Business Process.
Worked with Subject Matter Experts by asking detailed questions in the form of questioners and carefully record the requirements in a format that can be reviewed and understood by both business and technical people
Collect, store and analyze data needed for supply chain metrics in identification of root cause for continuous performance improvement.
Create supply chain performance reports, ad-hoc analysis, and dashboards.
Actively participated in CRM sprints and daily stand up meetings.
Accurately measure and evaluate effectiveness of CRM targeting strategies across a year, season, piece, channel, or customer group.
Conducted walkthroughs and inspection meetings with the stakeholders and other management teams in the finalization of the User Requirement Documentation
Prepared Business Requirement Documentation based on URS, and converted the Business Requirement Documentation to Functional Requirement Specification
Wrote Use Case Specifications after identifying the Business requirement
Conducted Joint Application Development sessions to gain consensus on various issues related to the project. Acted as a facilitator and also as a scribe on different occasions
Involved with the management, Development and the QA Team members in the Project Planning Phase
Proposed and formulated use of an internal recommendations engine to power personalized content and targeted audience.
Launched A/B testing platform & processes.
Involved in the gift registry initiative and roll out for POS.
Managed all the requirements in JIRA, making requirements available to all teams
Involved in the formulation of Test Plan that contained test scenarios for the all phases of Quality Testing including functional, navigation, security, recovery and performance testing
Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
Monitor client expectations through client involvement and communication throughout the lifecycle of the project, educate clients and stakeholders on the benefits and risks associated with the project
Lead and provide strong direction to development team in understanding and implementing requirements
Involved during the User-Acceptance Testing of the application and interacted with end-users, management and development team in order analyze the risk involved in the updating of the existing system
Environment: JIRA, Confluence, Visio, Lucid Chart, MS Word, Excel, PPT, QC
Client: Google India Pvt. Ltd 2007 Sept - 2010Jan
Role: Project Coordinator
Project #1: Ground Truth Tool Application
Project Description:
This web application that was developed in ‘ArcGIS software’ and ‘N-tier architecture’ aims at providing best possible directions and the address for user queries. It also aims at writing the test cases and providing the best quality as per look and feel of the GIS application and for the product. This is a Web based application acts as an interface for adding the Geo data on Google maps Database. Recommend best practice solutions. Study and examine attributed information wherever needed to enhance the quality of maps.
Responsibilities:
Preparing, interpreting, inspecting and revising drawings, plans, diagrams, maps and charts using ‘ArcGIS software’, which is a GIS tool.
Work closely with end users to identify GIS requirements. Document, review, analyze and evaluate business processes, systems and user needs.
This ‘ArcGIS software’ is a designing tool which can model Google Earth to visualize them within their larger landscape context. It is very easy to go back and forth for designing of Google Earth using ‘ArcGIS software’ which keeps a track of the development of your site & further development of navigation, maintaining and database-related applications on Google Maps and Google Earth.
Update spatial data and load new GIS data into the geo-database. Ensure attributed information is properly saved and written as per the rules, regulations and policies of the company.
Worked on statistical analysis and GIS analysis for entire Google Earth.
Followed both Agile methodology.
Developed business requirements document (BRD), User stories and functional requirements
Conducted feasibility study and performed GAP analysis for the proposed enhancements
Performed complex design computations, field, and quality tests and recording the results.
Reporting map issues is to resolve maintenance request, submitted by users on Google Maps. These RMI’s (Report Map Issues) are reported on Google Maps.
Writing test cases on a regular basis during a change or writing the entire test case from beginning when a tool is added
Liaise with team members (Development Team, Technical Support, & Business Support) in order to resolve the issues
Involved in Test reporting on daily, weekly basis through company prescribed format.
Environment: ArcGIS software, ArcGIS Toolbox, ArcMap Toolbar, Windows XP, SQL Server, MS Visio, MS Project Plan, MS Office Suite, MS Word, Excel, PPT, QC.
Role: Quality Assurance Analyst
Project #2: Auto checks
Project Description:
These are Lint checks for a geographic space that use algorithms to detect possible data problems and drop issues so that they may be manually reviewed. Auto-checks are a group of algorithms (or checks) that run against our map data to identify patterns that suggest a possible error.
Responsibilities:
Compile bug reports and requests for new feature updates that could increase productivity.
Prepare weekly and monthly reports summarizing the performance statistics of the team. Responsible for maintaining the productivity and efficiency scores of the entire team
Prepared newsletter reports for completion of work before the deadline.
Conducted feasibility study and performed GAP analysis for the proposed enhancements
Created UML Models such as Activity Diagrams and Flow Diagrams using MS Visio
Preparing presentations based on business requirements.
Accountable for formulation & execution of Test Cases
Perform Regression testing, Re-testing, Exploration testing
Involved in the preparation of Negative test cases
Generated Test Reports
Liaised with developers to resolve the defects
Involved in developing and executing system and UAT test plans; developed and maintained the test scripts with the necessary screenshots for reporting purposes.
Reporting Bugs on Buganizer overseen the validation cycle
Environment: ArcGIS software, ArcGIS Toolbox, ArcMap Toolbar, Windows XP, SQL Server, MS Visio, MS Project Plan, MS Office Suite, MS Word, Excel, PPT, QC.