SUMMARY:

• 8years of experience as a Business Analystand Scrum Master in Banking and Insurance Industry with expertise in Business Requirements Gathering, Business Process Modeling Notation (BPMN), Business Analysis, Business Process Improvement, and Business Intelligence
• Experience in various fields like Federal Regulations, Capital Market, Trade Finance, Portfolio Management, Mortgage as well as Online Banking including financial and reporting experience with strong knowledge of Software Development Life Cycle (SDLC) and extensive knowledge of Agile methodologies like Scrum and Kanban, Waterfall, and Scrum - Waterfall hybrid methodologies.
• Strong finance & banking domain knowledge including accounting operations, banking processes & terminologies, and financial statements (Balance Sheet, Income Statement & Cash Flow Statement)
• Solid knowledge of Feature-driven Development (FDD), Behavior-driven Development (BDD) & Test-driven Development (TDD)
• Worked with PM resource management, Revenue Planning, Budget allocation, WBS, and Project Accounting and Reporting & Analysis.
• Assisted in coordination of the Agile/Scrum development process using Azure Dev Ops and JIRA
• Authored datasets and DAX measures to use in Power BI.
• Created, structured content, designed sites and was a super user in SharePoint 2013
• Consulting of upgrading/additional technologies including Google Cloud, Tableau, and AWS.
• Proficient with Business Analysis tools such as designing wireframes (Balsamiq), JIRA, and GitHub
• Created, structured content, designed sites and was a super user in SharePoint 2013
• Insurance experience includes Personal Property & Casualty and Commercial Automobile Product knowledge, Reinsurance for Auto, Billing, Claims and Home Insurance Systems.
• Experience in evaluating claims monthly by reviewing critical errors and correcting data in Plexis, claims management system
• Setup the Salesforce org, customize the app, create users, profiles, roles and permission sets, perform data loads. Work closely with average of 8 clients to extract business requirements and apply Salesforce best practices.
• Performed ServiceNow implementation tasks including but not limited to: configuration, integration, testing, requirements gathering and solution design.
• Experienced in IBM Security Identity and Access Management (IAM), and IBM Master Data Management (MDM) implementation.
• Administered Identity and Access Management (IAM), (including password management) controls for staff and vendors assigned to department-level projects.
• Providing field level mapping of elements between front end and Duck Creek needed in the service/API.
• Delivered a Salesforce Lightning demo platform for the Insurance Digital Platform within 8 weeks.
• Extensive knowledge of Policy Admin system and related operations like New Business, Endorsements, Billing and Claims in property and casualty - Personal Lines.
• Excellent knowledge of various policy administration & industry standard tools such as Guidewire Policy Center, Guidewire Claims Center, Guidewire Billing Center.
• Supported the design of ServiceNow integrations and work with business partners and technical teams for implementation
• Developed and documented Data Mappings/Transformations, and Informatica sessions
• Extensive experience in working in all phases of the System's Development Life Cycle (SDLC) namely Analysis, Design, Development, Testing & Implementation.
• Experience Preparing requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Translated Business processes into Informatica Mappings for building Data marts.

TECHNICAL SKILLS:

Modeling Tools: MS Visio, Mock-Up Screens, Rational Rose

SDLC Methodologies: Waterfall, Waterfall Scrum Hybrid, Scrum, Agile-Scrum, Agile

Business Skills: Process Modeling, Change Management, GAP Analysis, Impact AnalysisSWOT Analysis, JAD Sessions, Project Scheduling, Project Budgeting

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/DrillDown.

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

Testing Tools: HQPC, Postman

Reporting/BITools: Tableau Desktop, IBM Cognos

Methodology Tools: JIRA, HP ALM, RALLY

Databases: MySQL, Oracle, MS Access

Languages: XML, SQL

Operating Systems: Windows XP/10, Linux, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, Hopewell, NJ

Sr. Business Analyst/Scrum Master

Responsibilities:

• Functioned as the liaison between the business and technical teams and involved in planning and process analysis.
• Maintained vendor relationships for the project by following legal business processes.
• Created Business Requirement Document (BRD) based on information gathered and ensured that it was completed within the defined SLAs.
• Assisted data warehousing team in performing data modeling and data mapping activities like defining data source, data target & data transformation rules to set-up the data load process using Informatica as well as analyzing & designing the data elements.
• Performed GAP Analysis by understanding AS-IS business process and TO-BE business process along with the Cost-benefit and Impact analysis.
• Document and build efficiencies in standard procedures & business processes for IAM
• Produced over 300 User Stories along with Acceptance Criteria on an enterprise wide strategic project to create a new Salesforce driven Insurance Digital Platform for a multi-million-dollar contract.
• As a scrum master facilitated the various scrum ceremonies and solved the various impediments the team faced during the sprint cycles efficiently to avoid the various blockers in the roadway.
• Performed most of the functionality T-SQL Scripts and Batches in SQL Server and Informatica and wrote SQL Queries, dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-Defined Functions, Views and Cursor
• Experienced in supporting organizational change management efforts and providing training for ServiceNowtransformation projects.
• Carried out SOX Key Performance Indicators (KPIs) and created monthly department metrics for all levels in the company.
• Familiar with Sharepoint and Workday.
• Worked cooperatively within the Accenture Duck Creek Project Management Office (PMO) to provide coordination/communication support to Delivery or Product leads and their team(s) to ensure initiatives meet schedule, budget, and quality commitments.
• Introduced to Vlocity and ClaimsVantage, native Salesforce applications.
• Assisted in building ITSM process documentations used for end-user training on ServiceNow.
• Designed and implemented series of Power BI dashboards for use in field across the globe; encapsulated specific and relevant metrics to contribute to business demands.
• Facilitated metrics meetings with the Information Security teams.
• Organized requirements into high-level Business Use Cases and low-level Use Case Specifications on the Functional Requirement Document (FRD), and prepared Activity and Sequence Diagrams.
• Prepared Business Process Model (BPM) diagrams, UML diagrams, Data Flow Diagrams, and engaged in business process analysis and mapping by using MS Visio.
• Created Wireframes and developed prototypes of the Graphical User Interface (GUI) Design; demonstrated them to the stakeholders and business users and took feedback from them by using XML language.
• Successfully managed over million-dollar Wealth & Investment technology budget with innovative risk controls focused on information protection results & OCC policy testing; using Qualys scans, IAM Risk Controls, email NPI data protection, including SailPoint IAM tool migrating into Next Gen custom built SOD dashboard
• Expertise with analytics and reporting tools such as MS Power BI and Tableau.
• Transformed data from OLTP to OLAP data sources from Informatica Repository
• Extensively worked on Cognos for publishing metrics reports and creating dashboards.
• Assisted the QA team in continuous integration as well as automated testing throughout every sprint.
• Worked on Cucumber as agile project management software for automated testing.
• As a tester, designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, System Testing, Regression Testing, and UAT testing.

Environment: Agile-Scrum, Rational Enterprise Suite (Rose, ClearCase, ClearQuest), Github, Visual Basic, MS Project, SQL, SQL Server, Power Clerk,Oracle, WebLogic, SailPoint, Salesforce, ServiceNow, Tableau,IAM, SAAS, AWS, IPFR MS Visio, Services, Dreamweaver, Power BI, Windows Forms, AEM 6.2, Oracle CPQ, Web Forms, ServiceMax, LoadRunner, Revenue cycle management, Accounting,WinRunner, DOORS, Project Management.

Confidential, Wheeling Township, IL

Sr. Business Analyst/Scrum Master

Responsibilities:

• Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
• Documented Claims assignment details in Vision and business Requirement Documents (BRDs), Functional Requirement Documents (FRDs) using Rational Requisite Pro and Power Designer.
• Elicited requirements for various Claims Integrations with Policy Center and Billing Center on activities like Policy and Billing Status retrieval, Checks Issued and Void Processes for Claims etc.
• Worked closely with Billingcenter, Customer Portfolio, Forms team to test the integration between these services.
• Build dashboards and reports in Power BI.
• My dynamic IAM process & regression testing allowed segregation of duty requirements to be deployment in a next-generation privileged access tool
• I was their SharePoint Business analyst, PowerUser and Administrator.
• Worked on Guidewire Policy Center for Policy creation and maintenance using different Policy Transactions for Auto and Property (including Homeowners).
• Created test plans, test scenarios, test cases for the Claims Center and the Billingcenter
• Analyzed defects on claims, did root cause analysis and delegated technical issues to development team
• Experience in various Insurance Policy Administration Systems (PAS) / Point of Sale (POS) applications including Insurity, Steel Card, RapidSure, and Duck Creek.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Worked with the ETL team to use Informatica Power Center/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Flat files, XML files into staging area and load into the data warehouse.
• Experience in analyzing business requirements and implementing them to Salesforce custom objects, master-detail relationships, lookup relationships.
• Worked with cross functional ServiceNow development team to build / test applications on the ServiceNowplatform based on business requirements.
• Conducted brainstorming sessions with business stakeholders to design dashboard prototypes for thePower BI developer to implement
• Worked on a project, which dealt with the Production Stabilization and Defect Tracking of the newly migrated Guidewire Billing Center.
• Involved in testing the Quote & Purchase for both Auto and Home Property Insurance ratings of the customers.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Knowledge in Oracle Data Warehouse, out-of-box ETL Informatica mappings, DAC configurations
• Worked on conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Facilitated JAD (Joint Application Development) sessions to identify business rules and requirements and then document them in a format that can be reviewed and understood by both business people and technical people.
• Collaborated with the development team to monitor and track progress of project following Agile methodology.
• Derived IAM solution requirements or development requirements by working closely with Systems
• Worked on analyzing AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Interacted with managers in Finance, Underwriting and Operations to gather requirements and create documentation using agile methodology for each report.
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Participated in discussions related to Penn National agency system migration to Duck Creek regarding reporting requirements
• Supported team members in relation to technical and design related issues with System Development Life Cycle(SDLC)
• Involved in creating Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temporary tables, flat files etc.
• Identify customer-marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Worked on User Story’s based on the discussions with SME’s for the customization of Guide wire Product for the Policy Center application.
• Prepared Test Strategy, Test Plan, test report and Gap Report

Environment: Agile-Scrum, Duck creek,Advance Plax, ServiceNow, Salesforce, GPP, AS/400, ServiceNow, Mainframe/DB2, J2EE, RUP, UML, Use Case diagrams, Microsoft Visio, CloudBees, Saas,MS Project, AEM 6.1, IAM, MS Visio, Revenue cycle management, Accounting, Postman, HP QC, JIRA, Confluence, Tableau, SailPoint, Power BI.

Confidential, Boston, MA

Business Analyst/Scrum Master

Responsibilities:

• Gathered the high-level business needs from the directors and prepared the High-level Business Needs.
• Worked with other Analysts on integration requirements with Guidewire Claim Center and Billing Center.
• Worked on Guidewire Policy Center for Policy creation and maintenance using different Policy Transactions for Auto.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Implemented various Transformations: Joiner, sorter, Aggregate, Expression, Lookup, Filter, Update Strategy and Router. Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL and date functions in Transformations.
• Work extensively on various salesforce.com standard objects like Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards.
• Analyzed the Duck Creek system in order to identify the screens and the fields to be created on different screens.
• Provide customer service and support for Property & Casualty risk management needs
• Garnered technical prowess on Change Management by performing Impact Analysis for Change Requests obtained during Claims processing lifecycle.
• Initiated meetings with Power BI developers to discuss the Issue Management dashboard requirements and finalizing on the delivery times
• Wrote stories and test scripts for testing in ServiceNow QA and UAT and get client's sign-offs
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology
• Knowledge of AWS Identity and Access Management ( IAM), Auto Scaling Group and Application Load Balancer in AWS.
• Consult with stakeholders to determine the best implementation of agile practices.
• The Data Warehouse was created around the Accord Messaging Standard with extensions where necessary (Workers Compensation, Commercial and Personal Lines Auto).
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Worked with the clients on final signing process in the User Acceptance Testing (UAT) stages.
• Responsible for managing a team of SQL Developers to produce policy and claimsreports which supported state insurance department reporting, ISO and internal reports.
• Documented reconciling financial data submitted by Servicers and Trustees for a mortgage loan servicing application.
• Acted as Guidewire Policy Center SME for Claims Center, Billing Center, Report Center and Duck Creekapplication resources
• Worked on different techniques of data masking techniques such as shuffling, substitution etc.
• Involved in creating Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temporary tables, flat files etc.
• Created Process Flow diagrams, use case diagrams (UML) using MS-Visio.
• Effectively interacted with key stakeholders and business users to understand and analyze the business needs and data to model the target business processes.
• Worked on User Story’s based on the discussions with SME’s for the customization of Guide wire Product for the Policy Center application.
• Worked on HP ALM Quality Centre Admin module to create custom fields, create new users, user groups with appropriate access level.
• Prepared Test Strategy, Test Plan, test report and Gap Report

Environment: Waterfall -Scrum, Duck creek SharePoint, Oracle, Service-oriented Architecture, JIRA, HPALM, Informatica, IBM Cognos, IBM Rational Rose,Saas, BPMN 2.0, Microsoft Visio, Azure, SharePoint 2013, MS Dynamics, Java/J2EE, JSON, Spring, JavaScript, HTTP, XM

Confidential

Business Analyst

Responsibilities:

• Lead Joint Application Design (JAD) sessions to gather business requirements and to identify data stewards.
• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Worked with business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the golden records to the target MDM database.
• Utilized previous experience and helped team in creation of Schema design in Erwin and implement in database and preparing the technical design document.
• Presented insights by creating visualization dashboards using Tableau, MicroStrategy and Power BI
• Experience in BI/DW solution (ETL, OLAP, Data mart), Informatica, BI Reporting tool like Tableau and QlikView and also experienced leading the team of application, ETL, BI developers, Testing team.
• Work experience with the enterprise IAM (Identity and Access Management) team to implement and automate processes.
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
• Assisted in performing Data mapping testing in Informatica Data quality at each step of ETL mapping to ensure correct data in flow and outflow.
• Provided support to troubleshoot Dashboards and generated reports using Crystal reports, Xcelcius and helped resolved the root cause of production issues and streamline the business intelligence processes
• Collaborated with team members and management to identify and solve data quality issues

Environment: MS Project, MS Visio, Informatica MDM, Informatica Data Quality, SAP BO suit, Xcelcius, Crystal Reports, SQL, Oracle 10g, MS Office, MS Visio

Confidential

Business Analyst

Responsibilities:

• Conducted brainstorming and interviews with business heads to finalize the business requirements.
• Documented requirements and cre3ated Project artifacts such as FSD, SRS and RTM.
• Prepared Data Mapping Documents for the reporting documents generated by the system.
• Led requirement elicitation & management, competently upheld business requirements on HP QC.
• Created the mocks and UML diagrams such as Use Cases, Activity, Sequence using MS Visio.
• Performed extensive business process analysis including data analysis and GAP analysis
• Assisted development team in creating prototypes based on requirements specifications.
• Prepared Data Mapping Documents for the reporting documents generated by the system.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool.
• Schema design in Erwin and implement in database and preparing the technical design document for ETL.
• Gathered requirements for Client-Side Validation, and Server-Side Validation. Gained understanding of three tire and n tire architecture, understanding of request and response flow.
• Worked with QA team in creating a test scenario, test cases, test steps. Involved in software integration testing, regression testing, UAT testing and web services API testing using SOAP UI.
• Prepared UAT test document and developed Test Scenarios for validating the Business requirements and Uploaded Test scenarios, mapped Business requirements to Test scenarios and updated defects and defect tracking in HP Quality Center.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing.

Environment: Informatica PowerCenter 9.0, Apache Tomcat, Oracle 10g, HP QC, Java/J2EE, XML 1.0, HTML MS Office, MS Project, MS Visio, UML2.2, SOA, SOAP UI