PROFESSIONAL SUMMARY:

• Solution - Oriented and Innovation Driven Business Analyst with 8+ 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 integratedBusinessSystems, translatingbusiness processes into requirements andsystemsolutions 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 likeWaterfall, Scrum, Kanban, and Waterfall-Scrum Hybrid. Profound knowledge of Extreme Programming, RUP and Spiral Methodologies.
• Adept inthe 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 inClaims Processing, Billing, Quote and Bind operations, Quality Management and Risk Management. Hands on experience in working with project management techniques likePERT and CPM.
• Experience in analyzing, designing, managing, implementing, and testing software products/projects. Involved inBusiness 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 likeInterviews, Brainstorming, Focus groups, Requirement workshops, and Joint Application Development (JAD)sessions.
• Elicited requirements using techniques likeSurveys/ 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 likeBusiness Requirement Documents and Functional specification Documents (FSD), Use Case Models, User Stories, and Data Flow Models.
• Expertise in creatingprototypeslikeScreen Mockups and Wireframes, and developing UML models likeUse case diagram, Activity diagram, and Sequence diagramwith a solid understanding ofClass diagrams.
• Analyzed and maintained triple constraints in a project. Skilled in handling Change requests and analyzingimpact 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 SQLProfiler 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 ofSQLprocedures 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.
• Frequently used Data Definition Language, Data Modeling Language, and Data Requirement List in SQL to perform Create-Read-Update-Delete (CRUD) operations on DBs including joins, triggers and stored procedures.
• Adept in Data Warehousing concepts likeOLTP, OLAP, Conceptual modeling, logical modeling, Star Schema, Snowflake schema, Facts, Dimensions, Measures, Top-down and Bottom upapproaches.
• Proficient in creatingData Mapping Specification document, Entity Relationship (ER) models, and dimensional models. Worked ondata profiling, data cleansing and data validationin Data Warehouse projects.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Microsoft SSIS, Informatica Power Centre and Informatica DVO.
• Skilled in Quality Control (QC) activities like developing and reviewingTest plans, Test Scripts and Test Cases. CreatedRequirement Traceability Matrix (RTM)to make sure that all the requirements are tested. Involved inTest Execution, Test Automation, Issue tracking, Issue Resolution and Report Generation.
• Experienced in supervising and assisting inBlack Box Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing (Load/Stress) and User Acceptance Testing (UAT) using Load Runner, Bugzilla, JIRA, cucumber, Test Director, Selenium, HPALM/QC and HP QTP.
• Experience in preparing and documenting theUser Acceptance test (UAT) plan, UAT test casesand obtaining the necessary sign-offs from Subject Matter Experts (SME) and other concerned business units.
• Expertise in developing documents for different web services likeSOAP (WSDL, XML) and REST (XML & JSON)under various architectures likeThree-Tier ArchitectureandService Oriented Architecture (SOA).
• Proficient in SDLCs best practices in Extreme Programming (XP) such asTest-Driven Development (TDD), Behavior Driven Development (BDD) and Acceptance Test Driven Development (ATDD).
• Excellent understanding ofScaled Agile framework (SAFe)and Scrum framework including Scrum Roles and Scrum Artifacts. Facilitated Scrum ceremonies likeDaily Scrum, Sprint planning, review and Retrospective. Used severalPrioritization (MoSCoW, Kano)andEstimation techniquesin backlog grooming sessions.
• Involved in training of end users and documentingand drafting of training manualsfor end users.
• Experience handling multiple projects in a fast-paced cross functional environment, Efficient team player with strong leadership skills, excellent interpersonal skills and strong verbal and written communication skills.

TECHNICAL SKILLS:

Methodologies: Waterfall, Agile-SCRUM, Scrum-Waterfall Hybrid, Kanban, SAFe

Business Modeling Tool: MS VISIO, Mock-up Screens, 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, Ohio

Sr. Business Systems Analyst

Roles and Responsibility:

• 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.
• 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.
• Emphasized on understanding the project’s requirements from business perspective. Translated them into functional deliverables and provided detailed specifications 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 integrationtesting, web servicesAPItestingusing 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.
• Identified and analyzed data sources thoroughly before performing data profiling and Worked with the Database team and DBAs to update the existing data model of the Enterprise Data Warehouse.
• Assisted ETL developers in creating workflows and scheduling of batch processes using Informatica PowerCentre, based on Data Mapping Document. Assisted in Data Cleansing and ingestion into staging area.
• Assisted during the creation of reports, cubes and datasets using MSI and Web Services invoking the SDK.
• Gathered and documented API requirements for integrating reports with JSP and accessing external and internal Web-Services using JAX-RS (Java API for XML services) and AJAX (Asynchronous Java and XML).
• Used Tableau to generate effective reports providing Business Intelligence (BI) to visualize Risk Exposure from the Data obtained from the CAT model and increase the accuracy of Risk Assessment.
• Validated the reports generated by analyzing data contained by the databases using Structured Query Language (SQL). Used Tableau to confirm the accuracy and integrity of Data in various reports.
• Created Test Cases, imported them to Informatica PowerCentre DVO to validate and test the loaded data.
• Used Cucumber and HP ALM and worked with the QA team to create Test Plan, Test Scenarios and Test Cases for reports integrated with client web-portal and application and facilitated UAT sessions for testing web-applications and web portal functionalities.

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, Swagger UI, JIRA v6.4, Confluence v6.0, Jenkins, Gherkin, HP ALM and Tableau.

Confidential, TX.

Sr. Business Systems Analyst

Roles and 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 theDataMart via staging layer using ReferenceDataManagement(RDM) and modeled Data Flow into Metadata Repositories.
• DevelopingDataMapping,DataGovernance, Transformation and Cleansing rules for theMaster DataManagement(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.
• UsedDataQuality validation techniques to validate CriticalDataElements (CDE). Analyzed data contained by the databases using SQL and used Tableau for data accuracy and created reports to ensure Data Integrity.
• Generated reports by employing complex data manipulation, creation and conversion of datasets from tables, flat files and analyzing the datasets and employed Informatica Power Center to perform Data Cleansing and create a Golden copy of Data matching with the single source of truth format prescribed in the Mater Data Management (MDM) architecture and structure of Metadata Repositories.
• Monitored and tracked ongoing data quality levels regularly. Identified and established optimal approaches to resolve data quality issues. Supported Data Owners with resolution of data quality issues using Talend.
• Managed source codes, software builds, software versioning and defect tracking on software maintenance tasks/projects using GIT Version control system and documentation using Confluence.
• Worked with Informatica Support forMaster Data Management and Metadata Repository issues and upgrades.
• Troubleshoot the automation of Installing and configuring applications in the test environments. Verified the results through automation testing using Selenium by scripting in Gherkins format. Logged defects using Jira.

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.

Confidential, MA.

Business Systems Analyst

Roles and Responsibilities:

• Worked closely with core sales team and performed detailed analysis ofbusinessand technical requirements. Customized various standard objects ofSalesforce.com (SFDC) on Sales, Service and Marketing offerings.
• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback. Implemented SFDC Sales Cloud, Created Group, Deal Rooms provisioning and marketing teams.
• Elicited requirements from the Business stakeholders and created automated workflows and approval processes for lead routing, opportunities, quote discounts, binding operations and claims handling.
• Worked on Service cloud, tracking customer inquiries, escalating issues requiring specialized support and monitored client's productivity. We used Apache Kafka connects to process real-time Data feeds from several external systems and maintain transaction logs to aide in determining Performance Distribution.
• Gathered and documented API requirements and used Epsilon for technical scripting of XML and JSON.
• Migrating Applications withSalesforce.com using an ETL tool to make sure that the migrations take place without any loss of Data and it is stored in correct Database.Document RESTful APIs using Swagger UI.
• Used Data Loader for insert, update and bulk import or export of data fromSalesforce.com Objects. Used it to read, extract, migrate and load data from comma-separated values (CSV) files.
• Responsible for Data load and migration operations and, complete bulk imports and migration of data using Force.com Apex Data Loader.Migrated Data from traditional software toSalesforce.com
• Designed and deployed Custom objects, Entity-Relationship data model, validation rules, Page layouts, Custom tabs, structured and unstructured data Components and Data flows to suit client’s application needs.
• Aided in the design of Page Layouts, Record Types, Profiles, Permission sets, security and sharing, Cases, Report Types, Reports and Dashboards, master-detail and look-up relationships.
• Worked with QA team to design and develop Test Plan, Test Scenarios and Test Cases to perform User Acceptance Testing (UAT) in Alpha and Beta environments, Functional Testing and Regression Testing.
• Performed automated testing of the end-to-end functionality as well as individual workflows using Selenium.
• Involved in training of end users and documentingtraining manualsfor end users.

Environment: Agile-Scrum, JIRA, Confluence, RedHat JBoss BPM Suit, MS Visio, MS Project, Salesforce.com (SFDC), Salesforce Lightning, Kafka, XMLSpy, REST API, Cucumber, Jenkins, Bootstrap, Junit, Selenium, HTML5, CSS3, JavaScript, AngularJS, AJAX.

Confidential Wilmington, DL

Sr. Business Systems Analyst

Roles & Responsibilities:

• Interacted with business users, stakeholders, Subject Matter Experts (SME) and performed documents analysis and GAP analysis to assist Product Owner and Project Manager in planning the transition.
• Facilitated JAD sessions as Moderator, conducted interviews with various SMEs and stakeholders and reported feedbacks by calling meetings to process reviews and policy & procedure reviews to elicit requirements.
• Documented requirements by creating BRD, FSRD, SRS and Source Target Mapping Document (STMD).
• Worked on MS Visio to write Use Cases and create UML models along with Use Case diagrams, Sequence diagrams, Activity diagrams, State chart Diagrams, User Interaction Diagrams and Class diagrams.
• Actively participated in Ceremonies such as Sprint Planning, Daily Stand up, Sprint Review and Sprint Retrospective and Product Backlog Refinement. Managed and tracked requirements using Jira.
• Identified various source systems, types of data and created Data Flow diagrams. Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure in a multilayer set-up inclusive of Metadata Layer.
• Integrated various Online Transactional Processes to the Online Analytical Processes by using Informatica as an ETL tool and used Tableau as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Data Validation processes to maintain accuracy and effectiveness of data and curb Data leakages.
• Generated periodic data reports for reconciliation, reporting using Excel & SQL Joins, views, and procedures & visualize and maintained documents using SharePoint Document management tool to record the progress.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional testing, load testing, Regression Testing as well as smoke and sanity testing.
• Was involved in using Tableau for effective reporting to provide Business Intelligence (BI) analysis in facilitating expenditure tracking and resource optimization using various matrices critical to decision making.
• Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
• Assisted Sr. Business Analyst, while facilitating Requirements Workshops, Focus Groups, Job shadowing, brainstorming sessions and conducting interviews to elicit requirements and reported results.
• Under the supervision, guidance and support of Sr. Business Analyst created the BRD, SRS, FSD, RFP, Use Cases, Use Case Diagrams, Activity Diagrams, Sequence diagrams and Class diagrams
• Gathered requirements for the GUI and created UI prototypes and mock-ups using Mock-up Screens.
• Worked on creating Data Models, ER Diagrams for the new Databases along with Database Objects such as Tables, Stored Procedures, Views and indexes, Triggers, Rules, User defined data types and functions.
• Prepared project related presentations to provide a clear view of the tasks to be performed and targets to be met within the time frame. Worked on updating the progress of the project on Requirement Traceability Matrix.
• Created indexes and DB links and Re-worked on the BAD Filesthat were generated by SQL Loader.
• Created various Packages, Stored Procedures and Functions as a part of the Data Validation and Cleansing.
• Generated reports like drill down reports, tabular reports using SQL Server Reporting Services on SQLServer (2008) and performed testing for the data in Test Environment for client validation and issues resolution.
• Assisted Sr. Business Analyst in preparing Test Cases, Test Plans and Test Scenarios.

Environment: Waterfall, MS Office (MS Excel, MS word, MS Power Point), Java script, JQuery, MS project, Mock-up Screens, MS Visio, MySQL 5.1, SQL loader.

Confidential

SQL Developer/ Jr. Business Analyst

Roles & Responsibilities:

• Worked with the business analyst to performed Create-Read-Update-Delete (CRUD) analysis to analyze existing database and collect the functional and technical capabilities of the current system.
• Worked with Project managers, business owners, analyst and clients in building database prototypes to validate system requirements from analyst teams.
• Performed Data Modeling and created Entity-Relationship Diagrams for the new Databases and created Database Objects like Tables, Stored Procedures, Views, Clustered and Non-Clustered indexes, Triggers, Rules, User defined data types and functions.
• Generated Tableau combination charts using Tableau visualization software and published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Performed and fine-tuned Stored Procedures andSQLQueries and User Defined Functions using Execution Plan for better performance.
• Created and scheduledSQLjobs to run SSIS packages daily, using MSSQLServer Integration Services (SSIS) and performed query optimization and tuning, debugging and maintenance of stored procedures.
• Creating Staging Database and Import Tables in MSSQLServer. Monitored, tuned and analyzed database performance and allocated server resources to achieve optimum database performance.
• Developing reports on SSRS onSQLServer (2008).Testing the data in Test Environment, client validation and issues resolution.
• Assisted in Installing, Configuring, Patching and Upgrading SQL Server Database Servers and creating Database Objects such as tables, views, sequences and clusters.
• Performed Data Modeling and created Entity-Relationship Diagrams for the new databases and monitored and supported the availability on Database server including Availability Groups and Replication.
• Defined primary keys and foreign keys for tables while designing and used constraints in order to maintain referential integrity, domain integrity and column integrity and done normalization of tables in the database.
• Participated in Performance Tuning and Query Optimization using native SQL Server tools and writing extensive SQL queries to determine what data must be sent to various applications.
• Frequently used Data Definition Language, Data Modeling Language, Data Query Languages in SQL to perform CRUD operations on database including joins, order by, group by, procedures and functions.
• Create functions and stored procedures to provide custom functionality as per the requirements and performed troubleshooting of performance issues impacting production databases.
• Generated reports like drill down reports, tabular reports using SQL Server Reporting Services.

Environment: MS SQL Server, MS Office, MS Excel, MS Power Point, MS Access and SQL Server Reporting Services.