SUMMARY

• Solution - Oriented and Innovation Driven Business Analyst with 9+ years of Professional IT experience in all phases of SDLC. Well-versed in bringing clarity to complex situations in any challenging environment with a diverse skill set in managing, designing and implementing integrated Business Systems, translating business processes into requirements and system solutions utilizing Waterfall and Agile methodologies. Well experienced and knowledgeable in the fields of Property & Casualty Insurance, Life Insurance, Auto-Insurance and Health Insurance.
• Experienced and well versed in Software Development Methodologies like Waterfall, Scrum, Kanban, and Waterfall-Scrum Hybrid. Profound knowledge of Extreme Programming, RUP and Spiral Methodologies.
• Adept in the Workflows of Insurance Industry with solid knowledge about Property & Casualty, Life Insurance, Health Insurance and Reinsurance concepts with CRM (Salesforce), ETL tools (Informatica), Content Management Systems, Master Data Management (MDM) and management of Metadata Repositories.
• Expertise in Claims Processing, Billing, Quote and Bind operations, Quality Management and Risk Management. Hands on experience in working with project management techniques like PERT and CPM.
• Experience in analyzing, designing, managing, implementing, and testing software products/projects. Involved in Business Process Re-engineering, Business Process improvement, elicitation, requirement analysis, planning, monitoring, change management and validation using various management tools and techniques.
• Expertise in GAP Analysis, Impact Analysis, SWOT analysis, Cost Benefit Analysis and Project Feasibility study.
• Skillful in networking with individuals at various levels while organizing elicitation sessions like Interviews, Brainstorming, Focus groups, Requirement workshops, and Joint Application Development (JAD) sessions.
• Elicited requirements using techniques like Surveys/ Questionnaires, Document Analysis and Interface Analysis.
• Worked with Subject Matter Experts’ to understand Key Performance Indicators (KPIs’) and Service Level Agreements (SLA) to enhance application performance through data exchange between external Web services.
• Skilled in converting requirements gathered to standard documents like Business Requirement Documents and Functional specification Documents (FSD), Use Case Models, User Stories, and Data Flow Models.
• Expertise in creating prototypes like Screen Mockups and Wireframes, and developing UML models like Use case diagram, Activity diagram, and Sequence diagram with a solid understanding of Class diagrams.
• Analyzed and maintained triple constraints in a project. Skilled in handling Change requests and analyzing impact of the change, creating Impact Analysis Report, and processing it through Change Control Board (CCB).
• Experience working with database environments like Oracle SQL Server, MS Access and MySQL. Worked on SQL Profiler acquiring performance data. Worked on Backup and restore databases, code promotion, grant user access by determining the Atomicity, Consistency, Isolation and Durability (ACID) properties.
• Involved in performance tuning of SQL procedures for execution-using Indexing, Oracle Hints, Materialized views, and also used aggregate and analytical functions. Created and maintained objects including tables, views, synonyms, indexes, Table Partitioning and sequences and extensively used select statements.

TECHNICAL SKILLS

• Methodologies: Waterfall, Agile - SCRUM, Scrum-Waterfall Hybrid, Kanban, SAFe
• Business Modeling Tool: MS VISIO, Mock-up Screens, Balsamiq, Lucid Chart
• Project Management: Rally, JIRA, SharePoint, TFS, HP ALM, Trello, Confluence
• Operating Systems: Windows, Mac OS, Ubuntu
• Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot
• Database/ETL: MS Access, Oracle DB, SQL Server, Informatica- Power Center and Data Quality, SSIS, Erwin.
• Reporting/BI: Tableau, Oracle s Business Intelligence Enterprise Edition (OBIEE), SSRS, IBM Cognos, Microsoft Power BI, Talend.
• Language: Java, C++, HTML, XML, SQL version 2014, VB Script
• Defect Tracking/ Testing Tools: HP QC, Load Runner, Bugzilla, JIRA, Test Director, Soap UI, Cucumber, Gherkin, Selenium, HPALM, HP QTP, XSLT
• Miscellaneous: Microsoft Office, NetMeeting, Adobe Photoshop, SSH, Salesforce, Google Sketchup, Ansible, RedHat JBoss BMP suit, draw.io, Zoom, HipChat, Guidewire, Duck creek

PROFESSIONAL EXPERIENCE

Confidential, Springfield, MA

Sr. Business Systems Analyst/Test Manager

Responsibilities:

• Performed document analysis of the As-Is PEGA system. Captured Business rules for the functional divisions of Whole Life, Term life and Disability Income Insurance in the Business Requirement Document (BRD).
• Analyzed the Decision Tables of the As-Is system and performed data analysis on data from Admin Systems in the lower environment, created a Mapping Table for the Document type and corresponding Activity in the DMS.
• Created Mapping document for the DMS’s Data Model from origination sources to the Business Case Workers.
• Modified the PEGA design of XSD to accommodate changed functionalities and enhancements by including additional parameters to pull information through EOL calls for Data Enrichment from Lower Environment.
• Re-designed the functionalities of Production Support Portal as per the requirement of the new .Net solution to include Work Baskets with Pending Exceptions and Customizable report generation and Report Re-runs.
• Demonstrated the additional features and changes of the Prod Support Portal by creating Mock-Ups and Wire frames in Balsamiq. Designed the options and tabs to enhance the usability and effectiveness of the site.
• Created a Data Dictionary to standardize & align the fields of Business Intent, Sub-Intent, Work Event generation, P8 Stager Address, Notification data and Customer Activity Tracking Work Object for all the ingested documents.
• Drafted Business rules to segregate the Work Objects created by Policy, Document Control Number, Producer ID, Document Serial Number and Group ID. Created a cross referencing Solution to retrieve data based on activity steps.

Environment: Waterfall, PEGA &.2.2, Ms Office tools -Word, Excel, PowerPoint, .NET, XML, XSD, XMLSpy, HTML5, CSS3, GIT hub v2.0, MS Visio v15.0, MS SharePoint v6.0, MySQL DB, DynamoDB, AWS, Confluence 6.12, Balsamiq 3.2.4, Swagger UI and Tableau.

Confidential, Fairfield, NJ

Sr. Business Systems Analyst

Responsibilities:

• Ensured compliance with various compliance regulations such as HIPAA and PCI DSS.
• Assisted the Program managers and other Business stakeholders in modifying the business rules to fit into the framework of the compliance requirements of the HIPAA and PCI DSS and drafter requirements around these to raise red-flags and create a non-compliance report.
• Interacted with stakeholders to analyze and manage Change Requests, and created a standardized procedure to receive change requests to be implemented through Release Management through Cost Benefit Analysis of the triple constraints of scope, time and Resources.
• Drafted the business rules provided by program managers into functional and non-functional requirements, and created prototypes and screen mockups using Balsamiq to depict the UI of the Patient/Provider facing portals. Worked using business process modeling methods and techniques and created business flows using MS Visio
• Interacted with Subject Matter Experts (SME), Service partners and Clients in eliciting detailed information about the requirements and translated them into a format through technical documentation, User stories and business flows which can be referred by technical teams, business teams and other stakeholders.
• Prioritized and groomed the product backlog by analyzing the business value and dependency of the requirement presented through the user story. Translated them into functional deliverables and provided detailed specifications.
• Developed a vision plan to streamline the business process related to Enrollment, Claims Adjudication, Payment Processing and Correspondence and implemented that to the program migrations that followed.
• Worked with production staff to map detailed current As-Is processes and detailed the To-Be processes. Identified third party services, feature analysis, developed Request For Proposal document. Cost Benefit Analysis helped choose the right services for implementation. Integrated Third Party services for Patient and Healthcare provider enrollment for all the public facing portals using Representational State Transfer (REST) APIs.
• Involved in systems integration testing, web services API testing using POSTMAN. Used Swagger UI to Document RESTful APIs of Java Simple Object Notations (JSON).

Environment: Waterfall-Scrum Hybrid, RedHat JBoss BPM Suit, Ms Office tools -Word, Excel, PowerPoint, Java EE 7, JSP, XML, XSD, JSON, AJAX, XMLSpy, HTML5, CSS3, GIT hub v2.0, MS Visio v15.0, MS SharePoint v6.0, PHP, GOlang, DynamoDB, AWS, Confluence 6.12, MicroStrategy 9.x, MicroStrategy Web SDK, R version 3.2.5, Epsilon, Eclipse, Balsamiq 3.2.4, Swagger UI, JIRA v6.4, Jenkins, Gherkin and Tableau.

Confidential, Columbus, Ohio.

Sr. Business Systems Analyst

Responsibilities:

• Ensured compliance with various compliance regulations such as Dodd-Frank, FIO Act and NRRA act.
• Assisted the ALM team in generating Non-compliance report concerning the FIO Act, NRRA act, National Association of Insurance Commissioners and Financial stability Oversight Council in case of red flag in process.
• Interacted with stakeholders to analyze and manage change requests. Studied the triple constraints - scope, time & resources of the change, Performed impact and cost benefit analysis to validate the change requests.
• Analysis, documentation of business requirements into functional and non-functional, created application prototypes and screen mockups. Worked using business process modeling methods and techniques.
• Interacted with Subject Matter Experts (SME) eliciting detailed information and carefully recording the requirements in a format that can be understood and reviewed by technical teams, business teams and other stakeholders.
• Identified and categorized all relevant stakeholders involved in the project using RACI Matrix. Conducted one-on-one interviews, JAD sessions to study new enhancement requirements. Documented them through RTM.
• Drafted the project’s requirements from business perspective. Translated them into functional deliverables and provided specifications by creating Mock-Ups and wire frames in Balsamiq to avoid ambiguity in understanding.
• Developed a vision plan that defined PAS processes and procedures as primary goals of the project.
• Worked with production staff to map detailed current As-Is processes and detailed the To-Be processes. Identified third party services, feature analysis, developed Request For Proposal document. Cost Benefit Analysis helped choose the right services for implementation. Integrated Third Party services for Lead Scoring on our onboarding customers, companies and ID documentations using Representational State Transfer (REST) APIs.
• Involved in systems integration testing, web services API testing using SOAP UI. Used XSLT to generate XML/HTML code from XML. Worked on Epsilon to do technical scripting of XML and validated using the same. Used Swagger UI to Document RESTful APIs of XML and Java Simple Object Notations (JSON).
• Integrated Red Hat open source Business Process Management (BPM) Suit that combines Business Process Management as well as Business Rule Management to configure and add Business Rules as per need.
• Created the Data Mapping Document as per the requirements of the stakeholders, business users and financial analysts to match with the Specification for source to target mapping and Data Dictionaries in Excel.

Environment: Waterfall-Scrum Hybrid, RedHat JBoss BPM Suit, Ms Office tools (Word, Excel, PowerPoint, Java EE 7, JSP, XML, XSD, JSON, AJAX, XMLSpy, HTML5, CSS3, GIT hub v2.0, Oracle 11g, MS Visio v15.0, MS SharePoint v6.0, Cucumber v2.3.3, Informatica PowerCentre 10.1, Informatica DVO, MicroStrategy 9.x, MicroStrategy Web SDK, R version 3.2.5, Epsilon, Eclipse, Balsamiq 3.2.4, Swagger UI, JIRA v6.4, Confluence v6.0, Jenkins, Gherkin, HP ALM and Tableau.

Confidential, Brenham, TX.

Sr. Business Systems Analyst

Responsibilities:

• Performed Carrier and Customer Analysis through Document Analysis by considering new Customer Enrollment Data, Product Data, Transactional Data, Demographic and Geographical preferences and created reports to identify Potential Risks and aide in Price Analysis and forecasted results for users.
• Enhanced the Policy Administration system by adding elements taken from the Guidewire Policy center, Duck Creek ECM and Bridge Policy Administration system to Property and Casualty Insurance workflows to streamline the functional processes and aide in optimizing Automation in Underwriters functioning.
• Technical aspects to create Deployment plans, Contingency Plans, resolving Blockers using Jenkins.
• Continuously managed and improved build infrastructure for development teams, implementation of build scripts, continuous integration, infrastructure and deployment using Ansible and Trello for Project Management.
• Worked with the Scrum Team and Product Owner to negotiate delivery of Minimum Viable Product. Assisted team in making achievable task commitments through user story selection and resizing, thereby reducing development time and facilitating the delivery of Potentially shippable product increment by the end of Sprint.
• Tracked the team progress during sprint through Sprint burndown charts, task boards and defect matrix.
• Defined the list codes and code conversions between the source systems and the Data Mart via staging layer using Reference Data Management (RDM) and modeled Data Flow into Metadata Repositories.
• Developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management (MDM) Architecture involving OLTP, Operational Data Stores and OLAP.
• Worked using a Decision Tree model to rank input variables based on the priorities set by Business owners.
• Created work flow diagrams, SWOT and cost-benefit analysis report to help support Product initiatives.
• Actively involved in reading data from varied file types like into Statistical Analysis System (SAS), created standard and Ad-hoc reports using Erwin. Generated delimited files and SQL script to load data into SQL tables.

Environment: Informatica Power Center, Erwin, Confluence, Talend, Microsoft SQL Server 2013, MySQL Workbench, MDM, JIRA, Trello, GIT VCS, Jenkins, Ansible, Selenium, Gherkins, Guidewire, Duck Creek.