PROFESSIONAL SUMMARY:

• 5 years of experience in Business Analysis, Business System Analysis, Marketing Analysis, and Project management in various domains
• Experienced in various domain and system including: Life & Health Insurance, P&C Insurance, Life & Annuities, Derivatives, web - based application, and E-commerce
• Strong experience in all insurance such as Property and Casualty Insurance including Home, and Auto and through understanding of insurance laws, regulation and policy administration system (PAS)
• Excellence in working with both clients and technical teams to bridge gaps and produce the most effective workplace
• Experienced in gathering and eliciting requirements from stakeholders and working on various documents, which include BRD, FSD, Use Story and Use Case specification
• Experienced in User Acceptance Testing, unit testing with QA and verifying performance, reliability and fault tolerance issues
• Experienced in conducting Gap Analysis, Cost benefit and ROI Analysis
• Hands on experience on using UML diagrams - Use Cases Diagrams, Activity Diagrams, Class Diagrams in MS Visio
• Exposure to Data Cleaning, Data Mining and good understanding of ETL process using SQL Sever Integration Service (SSIS)
• Deep technical background and solid working experience with SAS Enterprise Guide for data manipulation and data visualization
• Be familiar with various Relational Database Management Systems (RDMS) such as MS SQL Server and Oracle. And be able to write basic SQL queries to generate data report for different levels of management
• Experienced in various analyze and reporting tools including Tableau, MicroStragety, Google Analytics, Access and able to generate reports for different levels of management
• Good familiarity with Salesforce.com (Creating new user, Account Team setup, Tracking a Deal in the Sales Pipeline, Marketing Campaigns, Running Dashboard and Configuration - Administration Responsibilities, Setting up and Managing Users, Creating Custom Fields)
• Good understanding of various programming languages such as SAS, Python, JavaScript and VBA
• Experienced in various SDLC methodologies such as Waterfall and Agile

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Business System Analyst

Responsibilities:

• Collaborated effectively with various business units, project Manager and sales executives and other integral teams to identify project priorities and ensure successful completion of goals
• Responsible and accountable for various project implementations including coordinated multi-area sales process and issues
• Established project plans, budgets and monitored all phases of project management through timely completion
• Led team BAs to prepare interview questions for Stakeholders and Subject Matter Experts (SME) to gather requirements and maximum information
• Organized and led agile prioritization and confirmation meetings for each sprint
• Conducted meetings to align business values from the view of business stakeholders and technical values from the view of developers
• Led other BAs in the team to develop user stories then uploaded to product backlog in JIRA
• Developed, prepared and maintained monthly, quarterly and annual production revenue forecasts, pipeline, and dashboard reports for various departments, projects and regions
• Collaborated with UI/UX and developers to modify application menu and implemented relative API such as log in API, Merchant Service API, On-Demand Printing and Manufacturing API, Transitional and Payment Services API etc
• Performed Drupal platform to support RWD (responsive web design)
• Cooperated with developers to simplify checkout process, such as reduce time and steps for returning customers to make the payment
• Collaborated with data analyst team to design model and generate data mapping documents and participated in data analysis using SSAS (SQL Server Analytics Service) in MS Visual Studio and create reports with business objects using Tableau
• Collaborated with QAs to hold A/B testing and analyze website traffic using Google analytics in order to improve the design and content of the website
• Involved in Test Planning, Test Perpetrating, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a project meets Business Requirement.
• Created test plans and test cases, and conducted UAT as well as validated actual results against expected results
• Involved in achieve robust inventory control such as real-time stock alarms

Environment: Retail/eCommerce, Agile, MS Office (Word, PowerPoint, Excel), MS Visio, MS Visual Studio, Agile Scrum, Axure RP, HTML, JavaScript, CSS, JQuery, BootStrap, PHP, Java, SQL, Google Analytics, Salesforce.com

Confidential, OH

Business Reporting Analyst

Responsibilities:

• Analyzed the existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in the future to-be system
• Worked with Agile methodology, organized daily scrum sessions with offshore team to resolve Legacy System issue by coordinating with SME’s
• Managed the migration of Legacy System to GuideWire Policy Center and Billing Center
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for design and development of SSIS Packages
• Prepared Business Requirements Documents (BRD’s) after collection Functional Requirements from System Users
• Performed GAP analysis to identify gaps between the current situation and the future state
• Researched, retrieved and delivered organized analytics and reporting of customer service call center data
• Jointly responsible for monitoring the progress of the system development by preparing status reports, charting out schedules by utilizing MS Excel
• Provided support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, File Claims
• Highly interacted with the development team and assisted subject matter expert (SME) on customer trends as well as operational resource needs and performance
• Performed daily tasks including backup and restore by using SQL Server 2012 tools
• Created reports and Dashboards utilizing Excel and Cognos
• Assisted with development of XML, resource and database files
• Validated metadata within XML and developed XML files containing metadata
• Converted all legacy databases into SAS 9.1 Reporting adjacent to Crystal Object Reporting
• Created different degrees of data flow diagram, use case diagram, class diagram and activity diagram in MS Visio
• Analyzed and decomposed business requirements to extract test requirements and execute test plans and test cases
• Participated system and integration testing for multiple applications on provider system and claims system
• Provided training to actual end users and improved customer experience with escalating system and new features

Environment: Android, Waterfall, MS Office, MS Visio, BRD, UAT, Traceability Matrix, HTML, Java, UML, SQL Server 2013, DBMS, Mobile App, Claim Processing

Confidential, IA

Business Analyst

Responsibility:

• Served as a liaison between business units, technical staff, and/or solution vendors to ensure clear understanding and effective interpretation of information
• Partnered with product and business teams to identify and prioritize requirements from the business side
• Analyzed, documented, and tested new development, configuration, process flows, and functional specifications
• Acted as a scrum master and facilitated meetings (online and in person) and JAD session
• Utilized A/B testing with developers to design best performance web design
• Interpreted customer business needs and translated them into application and operational requirements
• Utilized T-SQL to write ad hoc reports and complex queries in order to perform data analysis
• Documented and communicated requirements via business process, user stories, and workflow diagrams
• Validated customer requirements, contracts, purchase orders and invoices for accuracy, pricing verification as well as management and legal approval
• Experienced using data (big and small) to come to actionable conclusions
• Worked with project manager and technical team to prepare product backlog and sprint backlogs
• Grouped User stories to product backlog and kept update with developers via JIRA
• Conducted technical review sessions and participated in weekly defect review meetings with QA
• Created various UML diagrams of business process including Sequence Diagram, activity Diagram to segregate high-level and low-level requirements using MS Visio
• Assisted test team to design test scenario and test case and participated in UAT
• Monitored, tracked and documented the progress of the project by use requirement traceability matrix

Environment: Agile, MS Office, API, MS VISIO, MS SQL Server, Business Intelligence, ecommerce, User Interface, Google Analytics, Tableau, HTML5, Bootstrap, C#, Axure RP, JIRA

Confidential, IL

Business System Analyst

Responsibilities:

• Gathered requirements from stakeholders and healthcare provider through multiple meetings and personal interviews
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert
• Performed requirements gathering, use case, along with Test Architecture at all levels throughout the software development life cycle (SDLC) component service based structure methodology
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Performed fit/gap analysis of current state healthcare processes then produced and documented process improvements to reduce patients overcrowding persists times
• Performed workflow analysis toward automated disability claims process. Detailed comparison of two competing proposals, including HR interfaces. Facilitated requirements definition for new system
• Processing of new business, renewal, cancellation, reinstatement, billing for various lines of business (Fire, Auto, Commercial)
• Created mock-up forms in MS Visio for better visualization and understanding of the software solution
• Provided instantaneous feedback and improved project cycle time through computerized scenario analysis
• Maintained a traceability matrix for all requirements and mapping to various Data Reporting Manuals, user guides analyzed and defined business and functional requirements by creating global metrics, trend charts in Tableau
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed

Environment: Waterfall, MS Office Suite, MS VISIO, SQL Server, SAS, Java, Asp.net, JIRA, Tableau, Active Directory, Testing, Insurance Claim and billing processing

Confidential

Business Analyst

Responsibilities:

• Communicated with stakeholders to identify, document and analyzed existing business workflows and processes to support AS IS documentation
• Supported wide system that completely replace 4 legacy applications within CPIC
• Worked with SMEs to make business decisions for policy rating, billing and imaging with products supported by IDP (Insurance Data Processing)
• Created plan to support departmental collaborations, enterprise wide workflows and system that will replace existing manual workflow and multiple system interface
• Wrote a VBSciprt macro to screen customers information to eliminate duplicate keying and saved processor 3 minutes on each notice created
• Assisted with technical teams for system security administration with different applications for clients
• Developed and prepared Functional Specification Documentation covering system solutions, training course materials, FAQ’s session
• Delivered system test scripts to facilitate testing and risk mitigation issues

Environment: Waterfall, MS Excel, VBA, PivotTable, BRD, FSD, JAD

TECHNICAL SKILLS

Requirement Management Tools: MS office suite (Excel, word, PowerPoint), Pivot table, JIRA

Business Modeling Tools: MS Visio, Axure RP

Relational Databases: MS SQL Server, Oracle

Programming Language: Python, HTML5 (JavaScript, HTML, CSS), C#, Java

Data Analysis and Statistics: SAS, R, VBA, Google Analytics

Reporting Tools: Tableau, Excel, IBM Cognos