SUMMARY:

• Business Analyst with 7 years of proven work experience in agile environment leading all Scrum ceremonies. Have been versatile working in different environments using agile. Acted as a liaison between technology and the business. Worked in all phases of SDLC with proficiency in Requirement gathering, Analysis, Design, Documentation, Data Analysis, Data Mapping and Data Modeling, Testing, Implementation managing business analyst functions and providing executive level support to principals. Superior interpersonal and analytical expertise with a flair for increasing organizational cohesiveness and profitability through talent assessment and employee management. Utilize management experience to align financial and business activities with organizational goals, fostering business growth.
• Comprehensive knowledge and experience in Software Development Life Cycle (SDLC) with business process models: Waterfall & Agile (Scrum) methodologies, Scaled Agile Framework (SAFe).
• Good understanding of the AS - IS and TO-BE business processes (GAP analysis) and experience in converting these requirements into technical specifications for preparing test plans
• Participate in various Agile Ceremonies; identify/define business processes/ User goals/User stories. Managed various stakeholder's groups, gather & manage Business, functional & non-functional requirements.
• Proficient in creating various documents like Business Requirements Document (BRD), Functional Requirement Document (FRD), Functional Specification Document (FSD), Systems Requirements specifications (SRS), Object Oriented Analysis and Design (OOAD).
• Worked in various healthcare functional areas like Enrollment/Membership, Benefits, Claims, Providers, Eligibility, Encounter, Estimator, Payment solutions, Population Health Management.
• Strong working experience and familiarity of emerging regulatory standards including Basel, Dodd-Frank Act Stress testing, CCAR, KYC and AML.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) and established service level requirements which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Integrated Pershing's NetX360 Web services for opening Brokerage and Managed Account for Private Bank Customers via Straight Through Processing
• Working Knowledge of Equities, Fixed Income, securities, investment performance, IRA's, foreign exchange, bonds and derivatives, insurance, mutual funds and check processing, trading & risk environment, credit, interest rates, Treasuries, alternative investments - Commodities, Foreign Exchange Trading.
• Responsible for the Integration, Functional, System and Acceptance testing of the IVR applications.
• Extensive working experience in Site core platforms like Web Content Management.
• Expert at interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate and validate requirements using Joint Application Design (JAD), Joint Application Review (JAR) sessions
• Assisted teams in creating different SSIS and SSAS packages in different Control Flow and Data Flows.
• Experienced in writing User stories with acceptance criteria or User stories with Use case
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling (BPM).
• Verified that Risk-Weighted Assets (RWAs) were adequately measured against Tier 1 capital to ensure AIG's capital ratios meet regulatory capital requirements.
• Experience developing various state, activity, class and Use Case Diagrams to better understand the process dataflow
• In depth knowledge of Rational Unified Process (RUP) methodology
• Developed various Flowcharts, activities, Use cases, state charts and process flow diagrams to better communicate and visualize the business flow using Unified Modeling Language (UML) tools
• Proficient in ensuring that business goals are met throughout the product lifecycle. Proficient in creating Behavioral and Structural UML diagrams including Activity, Sequence, Data Flow and ER Diagrams.
• Performed rigorous testing with QA team to prevent potential production issues and ensuring that the application is functioning as per the business requirements
• Involved in GUI testing, Functionality Testing, Regression testing, System Testing, Unit Testing, Integration Testing, Performance Testing, and Stress Testing.
• Monitored UAT and regional teams testing plan to match BRD and lead bug triage sessions.
• Effectively communicated with testers and management in TRIAGE meetings to decide priority (P1-P3) and severity (S1-S3) of bugs and work items based on end user feedback from User Acceptance Testing (UAT)
• Hands full of experience in MS Office Suite, MS Project for Project Plan, MS Visio, Rational Suite Rational Rose, Rational Requisite Pro, Rational Clear Case and Rational Clear Quest.
• Expert in UAT during solution implementation Phase (manual testing). Also interacted with team of QA to convey business requirements
• Good knowledge of Wealth Management Accelerator (WMA), Wealth Management
• Wrote Process approach documents and SIPOC mapping for TL 9000 quality compliance
• Proficient in developing & automating reports, iteratively build & prototype BI dashboards using Tableau to provide insights at scale, solving for analytical needs of business team.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Knowledge of all Commercial Insurance Rules and State Filing Requirements/ISO/NCCI
• Coordinate deployment of IT solutions on Clouds (AWS, Microsoft Azure)
• Have strong knowledge on fraud and anti-money laundering applications.
• Design, documentation and review of business documents like business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specifications (SRS).
• Advanced and expert skills in various BI tools like Tableau, Power BI, Qlikview, NPrinting and MS Excel including Power Pivot and Power Query
• Strong experience on various P&C insurance modules including Claim Management, Bill Management, Policy Management, Payments, Claim Offline Tool and Medicare Claim Reporting Tool.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis and ROI Analysis.
• Organized weekly project status meetings and task review meetings documented and disseminated meeting minutes effectively

TECHNICAL SKILLS:

Process Methodologies: RUP-Rational Unified Process, UML- Unified Modeling Language, Waterfall, Agile, Scrum process, Kanban

Project Management: MS Project, Excel Spreadsheets

Languages: C, C++, SQL, Oracle, Java, AML Language

Universal: VISIO

Quality Management: JIRA,Rally,Confluence, Mercury Quality Center, Analysis SDLC process Clear Management Clear Quest, SharePoint Object- Oriented

Office Tools: MS Word, Excel, Power Point

Testing: Unit Test, Win Runner, Load Runner, and Manual Testing, UAT-User Acceptance Testing, Selenium

Databases: MS SQL Server, MS Access, ETL

Business Intelligence Tools: Alteryx 9.x, SSIS,SSAS, Tableau 8.x, 9.x, 10.x, Cognos, TIBCO

Web Languages: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, St.louis, MO

Business System Analyst

• Thoroughly studied the capital market structures and account reconciliation systems to have a clear understanding of the Financial business processes and associated system workflow
• Interacted closely with stakeholders and Subject Matter Experts (SME) for gathering requirements and created Product backlogs
• Collaborated with Scrum Master and Scrum teams in Sprint Planning meeting and Sprint review meetings. Prioritized Sprint backlogs and managed changes to Product backlogs
• Actively tracked the ROI for various components of the project
• Used ETL Process to map data from different sources to the target data-mart in IBM Cognos Data Manager, thereby reporting and analyzing events and metrics.
• Documented REST API via JSON using documentation tools(Swagger), used Swagger Specification and converted it API documentation and used Plugins for integrating with JAVA.
• Extensively used BI for analyzing securities including equity, foreign exchange, bonds; building analysis flow for portfolio rebalancing and monitoring asset class performance
• Communicating key risks metrics as well as analyzing and providing commentary on daily and weekly movements to senior management through regular Meetings and Presentations.
• Extensively involved in the deployment of Data Warehousing System.
• Established processes for GDPR cookie compliance with OneTrust and internal auditing.
• Experience with Privacy Technologies such as OneTrust & TrustArc
• Monitor and analyze the results, trends, patterns, and events from Data Security and Privacy Compliance Tool OneTrust to enforce Data Privacy and Security requirements.
• Implement a consent management tool that will help us manage consent from our clients and employees, to ensure we use their data as per the consent they have provided. Informatica, OneTrust, TrustArc are the leading systems in this space.
• Running adhoc reports and SQLs for data imports from different departments to BI platform for data analysis.
• Good experience in creating PL/ SQL Procedures, Functions, Packages, Triggers.
• Bulk data Collecting, Performance tuning of huge data with use of PL/ SQL collections and records.
• Worked with SharePoint developers and stakeholders from 9 different teams to document requirement to migrate content from SP 2010 to SP 2013 and get UAT signed off post migration.
• Knowledge of Oracle, SharePoint, Visio, IBM Rational Clear Case, Requisite Pro., UML/XML models.
• Used Microsoft SharePoint as a Web-based Content Management System as well as a Document/ Project Management tool.
• Worked as a SharePoint Online & OneDrive Technical Consultant while resolving technical issues faced by Office 365 Administrators related to SharePoint Online
• Maintained documents on SharePoint, Wiki and Jive to facilitate seamless interaction with multiple teams.
• Extensive experience in Guidewire configuration and integration experience with claim center, policy center and Billing Center.
• Worked on the Guidewire Policy Center 8.0/7.0, Claims Center 8.0/7.0/6.0
• Also worked on GAP analysis between COTS application GUIDEWIRE and currently existing system to elaborate the changes required to me made on the policy creation system.
• Worked on Enterprise content management (ECM) used for store valuable content from all over the enterprise to provide ease of use for controlling and organizing files.
• Developed ECM system is used to manage the content from other applications from across the organization such as from ERP’s, CRM systems and portals.
• Developing SQL queries for the manipulation of data and transferring data.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Generated server side PL/ SQL scripts for data manipulation and validation for remote instances.
• Actively worked with the Capital Market and financial trading team to develop Equities, Futures, Forwards, Options, Derivatives online trading facility
• Create data mapping documents to define required elements on inbound SWIFT, XML or FpML messages, as well as to define the expected data format; specific to OTC derivatives, ETD's, Commodities and FX transactions.
• Worked in ARGO Sales & Service (SNS) & Loan Origination System (LOS) application for the defects and enhancements for the releases.
• Experienced in API Integration and Single Sign On (SSO) into a Service Oriented Architecture (SOA), web orchestrating service applications through the SSO services.
• Managing Service Now Integration with vendors system for Incident, Problem, Request and Change modules.
• Involved in all phases of Product Lifecycle Management (PLM).
• Creating PLM/XML action to add pre action check if required datasets is present or not before exporting business object.
• Have proficient understanding on Agile Methodology and PLM
• Experience in implementation of Service Now ITSM modules like Incident, Problem, Change, and Service Catalog.
• Analysis of as-Is business processes, mapping the To-Be Processes for SAP PLM-DMS & ECM implementation.
• Responsible for Integration, UAT Activities, Configuration done for PLM business process.
• Conducted performance studies of newly deployed PLM systems & UAT across sites
• Consulting and implementation experience for Product Lifecycle Management ( PLM) solutions with expertise in the Aerospace, Automotive & Semi-con verticals
• Offered data support and checking using SQL/Query and developed complex spreadsheets using VBA\SQL.
• Created data sources, import sets, transform maps to map data from excel/csv to Service Now tables.
• Involved in the hands on design and development of the Scripts, CataLog, Workflows and Reports on a showcase Service now instance
• Monitored and performed service Now admin activities which involves group, user & administrator.
• Leveraging knowledge and experience to deliver end-to-end methodologies within Service Now, which includes architecting technical and coordinating effort of administrators.
• Worked with requirements analysts and Subject Matter Experts(SME) to identify, understand, and document business needs for the data flow to create market risk and credit risk modules
• Played a lead role in conducting JAD/JAR sessions, got requirement specification documents including Project Objectives, Business Requirements, and Business Rules sign off
• Consulted the business users and SMEs, helped to create Product Backlogs to prioritize features and subsequently created Sprint Backlogs
• Involved in content management change control and Version Management. Performed regular updates to various static web pages.
• Participate in JAD sessions with cross impacted IT teams to help ensure they have the information they need to determine their involvement (including PPL hours and commitments) and get the information needed for the cross impacted teams to plan their work efforts.
• Participated in JAD sessions with the reporting team to determine requirements for data that will be sent from AEM to report environment to meet the business reporting needs.
• Create functional specifications for the data files that will be sent from AEM to report environment team, based on the data models created by the architectural and reporting environment teams.
• Designing the Workflow Structure which involves to automate the Specific Process in AEM.
• Used SAS and SQL to retrieve, validate and manipulate data.
• Worked as an AEM Module Lead and responsible for creating a High-Level Design model for migrating AEM from Vignette Web Content Management.
• Work on Proof of concepts with vendors and clients in order to make the conversion of XDPs from ES4 to AEM better.
• Establish accountability and monitor implementation of risk management across the company, including, implementation of risk appetite and tolerances, risk identification, assessment, and mitigation processes.
• Performed the responsibilities of planning compliance and IT security and risk management activities by following the work instructions of the senior staff.
• Risk management: Market Risk using VaR, Historical Simulation, Variance-Covariance and Monte Carlo Simulation, Option Greeks, Credit Risk using Sensitivity analysis, Break Even analysis, Duration/Complexity Analysis, Scenario Analysis, Stress Testing and Back Testing.
• Prepare Risk Management dashboards and provide inputs for governance meetings.
• Extensively working with Strategy and Analysis experience in Consumer Credit Risk Management
• Tested the call flows for the IVR (Interactive Voice Response) System
• Focused in Comprehensive Capital Analysis and Review (CCAR) Reporting, Governance, Risk & Compliance (GRC) and Dodd-Frank Regulatory Reporting, including FRY 9C, FRY 14M/Q/A.
• Conduct surveillance of SEF trades across multiple asset classes (rates/FX/credit/equities /commodities).
• Worked in Property &Causality (P&C)- Commercial lines & Homeowners surety insurance
• Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home, surety insurance and Marine.
• Insurance experience includes Personal Property &Casualty(P&C) and Commercial Automobile Product knowledge, Reinsurance for Personal Property &Casualty(P&C), surety insurance, Group and Life Insurance Systems.
• Developed and maintenance of Automation Test Scripts for Web based application in Agile Models

Environment: Agile, Windows, MS SharePoint, Oracle, .NET. IVR, Minitab, QI Macros, PowerBI, OBIEE, Cognos, Tableau, BABOK, MS Office Suite (Word, Excel, Power Point, Outlook), V-Lookups. Pivot Tables. JIRA, MS Visio, TL 9000 metrics, SQL server 2012, SQL, Mercury Quality center

Confidential, Beachwood,OH

Business System Analyst

Responsibilities:

• Implemented and integrated RUP solutions with a complete line of traceability for all the artifacts of web development projects.
• Supported the implementation, and ongoing improvement for a portfolio of ITOM processes for continuous tracking, reporting, and data quality
• Served as the 'AFS to Loan IQ' data mapping SME for the LIQ (Version 7.4) Conversion project.
• Worked closely with LPT team members, onshore and offshore developers, and business SME's and IV&V testers to ensure that all Loan IQ API data mapping documents were accurate and up to date.
• Wrote and maintained the 'Data Lineage Document', a comprehensive, high level data mapping document which captured every donor field being converted to Loan IQ and was used as a reference by the entire project.
• Responsible for ensuring accuracy, efficiency and timely flow of trade data between Loan IQ and Trade Settlement platforms as per LSTA guidelines.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Have Good Knowledge in PEGA-PRPC applications of Business Process Management (BPM) applications.
• Worked in a fast-paced atmosphere SCRUM and studied business processes, legacy application, and the corresponding Guidewire functionality and conducted requirements sessions.
• Hands on coding experience in Guidewire, ClaimCenter Product implementation in Configuration as well as Integration modules.
• Product Integration and Configuration experience and knowledge on Guidewire Policy Center 7.x, Guidewire Claim Center 7.x. Strong experience in working with agile lifecycle, and/or tracking, and process management tools like Rally and JIRA.
• Prepared Source to Target mapping documents in Excel. Understanding of WSDL, XML, and XSD for creating the mapping documents for 'Guidewire-ESB layer-Vendor' and vice versa.
• Expert in using PEGA debugging tools especially Tracer, Clipboard.
• Created complex Metrics Packet for the PMO team, Updated databases and amended training documents
• Implementation of BPM (Business Process Management solutions) Applications using Pega RULES Process Commander
• Good understanding of Pega Process APIs.
• Creation and management of the GDPR traceability matrix to ensure all articles are implemented
• Analysis of current business procedure to ascertain GDPR gaps and means of bridging said gaps
• Design of the current processes that relates to GDPR personal data definitions
• Experience in creating Created Customer, Deal, Facility, Outstanding and many other transactions in Loan IQ.
• Integrated Pershing's NetX360 Web services for opening Brokerage and Managed Account for Private Bank Customers via Straight Through Processing
• Ensuring all brokerage agreements are in place for electronic settlement of brokerage commission.
• Assisted the Performance Management team to make a tool to automate the Brokerage process
• Worked on several LIQ interfaces, writing business, functional and data mapping documentation for several new Loan IQ batch and real time interfaces.
• Build Macros in Excel, using the record macro feature to automate sorting and filtering of large data sets. Created Pivot Tables making data user friendly for front end users, helping to manage a pipeline
• Providing Execution & Clearing services within Middle Office ETD Operations for Listed Derivatives products, reconciliation of Give-up brokerage fees for receivables as well as payables side of business.
• Merger related tasks included creating and maintaining data and process flow charts, as well as complex data mapping / data transformation spreadsheets.
• Worked with various teams to create 'As-is' and 'To-be' flows for identified critical data elements using MS Visio and PowerPoint.
• Acted as a liaison between Business users and project team (SME's, developers, testers, data team, Architects) to define business requirements and analyze the functional requirements for Personal Lines P&C Insurance.
• Acted as a liaison between Business users and project team (SME's, developers, testers, data team, Architects) to define business requirements and analyze the functional requirements for Personal Lines P&C Insurance.
• Designed various report layouts of different source systems that are built on the data marts based on the user requirements for different line of Business (Investment Management, Investment Services, Wealth management and Regulatory reporting teams).
• Analyzing and enhancing the sales and marketing strategy of a major US Property & Casualty (P&C)Insurance company and providing business optimized solutions.
• Gathered functional requirements and wrote BRD's, FRD's (functional requirements specifications) and FSD's (functional system designs) for numerous Loan IQ downstream applications.
• Responsible for SIT (System Integration Testing) test planning, data validation and defect analysis using HP AML Quality Center.
• SME in Handling E-CIF/CRM functionality testing and queries individually or with surround systems such as internet banking, FEAS, IVR, CAPS, RLS.
• Microsoft Dynamics CRM 2015, CRM 2013, CRM 2011, 4.0 Business Analyst, Technical Analyst, System Administrator, CRM UI Configuration Manager, and CRM Reports, View Workflows, Dialogs, SSRS design expertise.
• Experience in configuring Dynamics CRM application by creating entities, fields, business rules, business process flows, security roles and extending the functionality by writing JavaScript, plug ins, custom workflows, web services and integration with third party legacy systems.
• Strong experience in CRM implementations using Agile as well as Waterfall methodologies
• Created Custom Entities, Custom attributes for individual Business Units in MS Dynamics CRM 365 as per the Business Process.
• Involved in upgrading from CRM 2011 to Dynamics 365 Online and Involved in requirements gathering, analysis and project planning.
• Worked on Dynamics 365 Sales and service module on data migrations and integrations. Solved different type of issues and tickets according to priority wise.
• Involved in Microsoft Dynamics 365 data capture, integration, auditing, data mapping, importing data and Creation of interfaces.
• Used SQL to query data from the Security Master Database and gathered reference data from multiple live data feed sources such as Bloomberg, Thomson Reuters.
• Development of the Content Management system and followed up closely with the development team for successful completion of the Content Management System
• Conducted daily scrum meetings to coach and mentor the self-organized, cross-functional Agile Project team on key principles of Scaled Agile (SAFe) competencies & practices including team ownership, commitment, effective user stories, agile estimation, and transparency.
• Compare current reports against new LOS functionality to identify reports that can be retired due to new system integrated workflow processes.
• Sent weekly dashboard reports to management with updates of the development process of the Content Management System.
• Performed requirements modeling and developed Analysis Diagrams, Activity Diagrams, Sequence Diagrams, and State Diagrams, Data Models, and Use-Case relationships using RUP tools in Agile Methodology.
• Gathered Business Requirements from Product Owners to document requirements for mobile applications updates.
• Developed and expanded agile processes within the team such as estimation, task breakdown, sprint review, showcasing, and retrospective
• Designed various report layouts of different source systems that are built on the data marts based on the user requirements for different line of Business (Investment Management, Investment Services, Wealth management and Regulatory reporting teams).
• Worked very closely with Developers and resolved any issues they have during development cycles and co-ordinate with Business for any clarifications.
• Provided coverage for AML compliance monitoring, CIP, KYC and OFAC. Assisted the Internal Audit Analyst for various work-streams within CCAR Audit - e.g. Basel III, Treasury/Liquidity, RWAs, Capital Policy/Planning, Risk Identification.
• Involved in the BRD, FSD and DDR reviews with Business, Developer and Mapper.
• Worked as a liaison among stakeholders to elicit, analyze, communicate, validate and document requirements for changes to business processes, policies on information systems including User Accounts Management (UAM), TDA Web, and Investment Portfolio & KYC Admin tools.
• Worked with Project Manager and Development Leads in creating Project Plans and updating the daily tasks.
• Manage Identity Access Management of Azure Subscriptions, Azure AD, Azure AD Application Proxy, Azure AD Connect, Azure AD Pass through Authentication.
• Experience in Microsoft Dynamics CRM Data integration towards import/export of data using SSIS and Custom application development.
• Extensive knowledge in Azure AD connect, Multi Factor Authentication (MFA), Active Directory Trusts, Dynamic Access Control, Office 365 best practices.
• Assisted Testing Teams in translating Use cases to Test Cases. Also worked closely with Testing Lead in creating and validating Test Plans.
• Tracked all major and minor Bug fixes through completion. Validated production reports and escalated production bugs for immediate fixes.
• Maintained and kept track of stakeholder's request for enhancements and changes using Unified Change Management Tool (UCM) such as Rational Clear Quest and JIRA
• Interacted extensively with customers and UI designers to determine ways to improve the UI feel and the user experiences. Documented the gathered business requirements into detailed Business Requirement Documents (BRDs) for BASEL III and its Addendum.
• Created User Manuals and provided User Training for the changes made to Mobile and Website.

Environment: Windows, MS SharePoint, BosWeb, Kofax Thin Client, VEO Admin, Adobe Acrobat X Standard,SSQ, QC, Contact, NETX360, OFA (One for ALL), Laser Fiche, Policy Decisions, SNAP, PayPro, PMS (Mainframe), HP Application Life Cycle Management, DevInt, Documentum, Appway, Client works, BranchNet, AXA, Microsoft Lync, PGP,MS Office Suite (Word, Excel, Tortoise SVN,Power Point, Outlook), RDMS, JIRA, Rational Clear Quest, MS Visio, Java EE7, SQL server 2012, SQL, HTML, UML

Confidential, Rockford, IL

Business Analyst

Responsibilities:

• Worked closely with the program manager and Project managers to define the scope and high-level requirements for the program
• Worked on the Claim Center integrations - Acuity(Litigation Management), Contact Manager, External Accounting Systems, ISO, OFAC
• Performed analysis of published Circulars from ISO/NCCI and other regulatory Bureaus for system impact and prepared detailed business and functional requirements.
• Worked in developing the wireframe and mock-ups for the prototype of the web-based portal application in MS Visio
• Created Process blueprints for Cost and Time estimates for migrating existing Savion Business Process Applications to IBM BPM.
• Provided detailed walkthroughs to all stakeholders Strategic Team, Business Users, development and testing teams and ensured functional adherence for Guidewire Policy centre implementation.
• Create mapping documents for ETL implementation; Create mapping documents from data source to Teradata target tables.
• Significant experience serving as a BA in the Property and Casualty projects with expertise in Underwriting, PAS, and, Claims systems.
• Analyzing and enhancing the sales and marketing strategy of a major US Property & Casualty Insurance company and providing business optimized solutions.
• Having deep understanding of US Property and Casualty industry in all aspects like insurance operation principles, Policy/Claim transactions, Underwriting, Agent/Broker, ISO Rating, Coverage, Forms etc.
• Significant experience serving as a BA in the Property and Casualty projects with expertise in Underwriting, PAS, and, Claims systems.
• Manipulate advanced Excel spreadsheets and data using intermediate to advance skill levels
• Worked on various User Stories related to Claim Center(Financial Summary, Reserves, Payment Exceptions, FNOL Process, Recovery, Vendor Ratings, Modular Reporting, ISO Claim Search, Internal Drafts, Reallocation, Payment Allocation, Reserve Allocation, Work Matter Summary, Maintain Work Plan, Maintain Activities, Executive Dash board, Special Investigation Unit, Claim Metrics and Cash Flow Management)
• Experience in Guidewire Claim enters, Policy center and Billing enter, claim center Integrations and Configuration User Stories.
• Excellent skill in creating Unified Modeling Language (UML) standard diagrams including Use Cases, Activity Diagrams, Data flow diagrams and Sequence diagram.
• Defined logic to correct many funds in AIS Dashboard for Master-Feeder Fund Structure for the fixed income instruments like Hedge Funds.
• Involved in preparing and reviewing Test Plan, RTM, Test Cases, Test report and resolving UAT issues. Involve in extensive data analysis on Teradata, and Oracle Systems Querying and Writing in SQL and Toad.
• Gathered business requirements for Auto Finance stakeholders.
• Scheduled and led requirements gathering through JAD sections for elicitation and documentation
• Document detailed business requires, Business rules, rating requirements, and coverage requirements
• Analyze surety Insurance forms and document forms requirements
• Compared actual and expected test results, discussed the defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called Rally (Bug, Issue and Project Tracking tool).
• Conducted JAD sessions and interviewed SMEs, asking detailed functionality aspects of Business Process (BPM) and carefully updating the information to the requirements in an easily understandable format.
• Provided testing documents including test plan, test cases and verifications
• Performed GAP analysis and traceability matrix to trace missed requirement and variations in the actual results(As-is) as against the expected(To-be) software product states
• Used Rational Requisite PRO and DOORS in various P&C projects for requirements management and traceability among requirements, uses cases, business rules and test cases.
• Compared actual and expected test results, discussed the defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called JIRA (Bug, Issue and Project Tracking tool).
• Compiled detailed documentation for technical teams (architect and QA) involved to be clear on the nature and item being worked on
• Create wireframes using Axure RP Pro based on collaboration with use cases and Visio flows
• Laid down the guidelines for a smooth flow of the different project elements in P&C domain, in different iterations and phases of the Software Development Life Cycle (SDLC)
• Provided hands-on instruction and guidance on how to prototype various JSON producing RESTful web-services and database systems using PHP, Node.js, and Python Django web frameworks during the senior project experience.
• Worked on various Guidewire integration concepts like Messaging, Batch Processes, Plugins, and Web Services and worked with Technical and Business leads during Guidewire Policy Centre implementation.
• Developed UAT and System Integration Testing (SIT) plan, facilitated UAT and SIT testers as well as Triage defects periodization and solutions
• Elicited and drafted requirements for financial system transaction posting for SAP FS-CD (SAP for insurance collection and disbursement).
• Configuration of SAP Production Planning Process (Discrete and Process industries).
• Have good functional knowledge and experience in different business scenarios and configuration of production planning module related parameters.
• Worked with data analysts to identify, design and implement solutions for extraction and integration of data for creating reports, decision making with using SSRS and SSIS
• Assisted in issues resolution and escalation as well as patronization and tracking
• Actively involved in brainstorming and JAD session with the client in order to identify all the business requirements for P&C project development.
• Carry out Metadata and data quality control for market risk, credit risk, interest rate risk, counter-party risk, liquidity risk, operational risk, inflation risk, and systematic risk data.
• Used Waterfall methodology of SDLC to manage projects

Environment: Agile Scrum, HTML 5, SAP CD,CSS,Adobe Photoshop, Windows Forms, Web Forms, Doors,IBM BPM, MS Visio, Arena, SQL Server, Win Runner, Rally, Clear Quest, SSRS, SSIS Load Runner, Window 8.

Confidential

Business Systems Analyst

Responsibilities:

• Worked with end users to Map Business Processes (BPM) to technical specification.
• Created daily, weekly and summary reporting and performance insights for the following programs: even performance for tab, including Advertised vs. non-advertised sales, Power Hours, Early Birds, BOGO and like-themed events.
• Generated dashboards, metrics, analytics, goals, alerts using Business Objects XI enterprise edition to streamline processes and procedure.
• Responsible for POS installation in the metro-city area.
• Worked with system Analysts to create application's Functional and Non- Functional requirement document.
• Developed USE Cases for the application and prepared the detailed Workflow Diagram based on the proposed enhancements, business logics and rules and translated them to Use Cases for Live Archive.
• Expertise in creating reports/Dashboards and visualizations using Tableau & Alteryx with hands-on SQL working experience, monitoring workflows through Autosys along with system expertise in middleware technologies.
• Creating, Altering and monitoring Alteryx workflows to generate tableau extracts for multiple data layers
• Established Analytics capabilities and introduced Tableau/ Alteryx & Python capabilities.
• Drive capabilities with Alteryx & Python for efficient processing of high volumes data.
• Organized JAD sessions with Business stakeholders/SMEs for gathering requirements for the new upgraded platform: estimated project resources, timing, and sequence of deliverables.
• Lead analysis planning and execution and authored business requirement, process diagrams (BPMN), and UI Designs for new web-based order management system.
• Design and create business process classification frameworks with various levels of detail and levels of decomposition for both end-to-end sector and cross-sector process models using BPMN modeling standards.
• Researched system architecture of proprietary PCPO (PC Purchase Order) and SSO (Store Specific Order) applications in the replenishment department, with the aim of converging the features of both applications onto a single .NET platform that could function on Windows 7.
• Designing the integration of BI data to implement Order management & consumer systems with workflow and dataflow from various sources like GMF, DNB.
• Accomplished logistics management featuring strategic planning in many Supply Chain Management programs.
• Developed management reports to measure KPIs (Key Performance Indicators) and effectiveness of business processes within the customer's supply chain.
• Responsible for end user training and P&Ps and Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.

Environment: MS- Project, Visio, Word, Access, Power Point, Excel, SharePoint, Office 365, Quick Base, Jira, Confluence Wiki, Outlook, Quality Center, MS Access, Oracle, SQL Server, Windows, Server.

Confidential

Business Analyst

Responsibilities:

• Form the requirements and using technologies such as JavaScript, XML, LDAP, AML language (like XML), and TIBCO configure and provide custom enhancements to the client
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Extensively conducted JAD sessions to understand the business requirements
• Involved in generating various reports using the SQL Server Reporting Services (SSRS).
• Created dashboards through Power-BI and effectively showed trends in our portfolio
• Managed ERP and EPM SaaS Applications with a background in Oracle On-Premise Solutions. Engaging Upmarket Accounts providing solutions for ERP and EPM applications in the Cloud.
• Tracking and reporting budget and cost allocation variances and performing cost/benefit analysis.
• Custom tools upgrade client had created marketing, merchandising production, batch support tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite.
• Experience in Oracle Apps as ERP consultant(Functional/Techno-Functional)
• Testing functionalities in ERP & CRM application, finding bugs and have technical co-ordination with developers to resolve it.
• Participates in Change Request process to approve, document, test and certify all changes to the ERP system.
• Used CSS, HTML and JavaScript for GUI front end designing and validations.
• Responsible to design, develop and test the software (Informatica, PL/SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub Queries, Set Operators, Psudo Columns, Analytical Functions and having knowledge on regular expressions.
• Maintained the product catalog, search and navigation, search engine optimization (SEO), Business Intelligence (BI) and personalization, etc.
• Extensively worked on Backend Programming using PL/SQL stored Procedures, Functions, Packages, Database triggers, Exception Handling.
• Hands on experience in writing Triggers, Procedures, Functions, Cursor, XML and PL/SQL Packages, Bulk Collect, For ALL clause, REF cursor, DBMS packages, SQL Loader, Analytical functions, Dynamic SQL, Collections, Views, Materialized views, data cleansing, UQT reports and Exception handling.
• Developed Complex Database Objects like Stored Procedure, Function, Package, Triggers using SQL, PL/SQL Scripts.
• Extensively involved in Business Process Modeling. Created the AS IS and TO BE business processes
• Worked with third party integration, Google Analytics, Ruby/Watir, data verifications/backend testing, defect management, SQL, API implementation, UNIX shell commands, process modeling.
• Creation of business and functional requirement documents and use cases supporting them with wireframes and other visual documentation as required.
• Experience in all phases of Full Life-Cycle Oracle E-Business Suite Financials implementation i.e. Requirements Definition, GAP Analysis, Process Modeling and Implementation.
• Designed the screen mockups using Balasamiq.
• Analyzed, cleaned and reorganized data by using tools including Excel, Alteryx and Pivot in Tableau
• Developed Business specification diagram to understand the whole work flow.
• Worked on setting permissions and refresh schedules on Alteryx server.
• Designing complex workflows, macros, wizard applications and custom Alteryx tools using tools like Preparation, Join, Parse, Transform, Reporting, Spatial Analysis, Documentation and UI Interface.
• Developing Tableau dashboard using pre-processed data of Alteryx workflows.
• Working on all round consultation on alteryx service, alteryx gallery workflow execution and alteryx environment settings in Dev/UAT/ Prod environments.
• Involved in development and testing of POS Point of sale systems and applications for Payment Card Industry (PCI) Compliance initiative.
• Create the wireframe of Functional work flow using the Balasamiq tool
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Used Invasion in enhancing the user experience; worked closely with the technical and programming team to prepare Screen Mockups, User Interface designs using wireframe prototype for this Ecommerce mobile/web redesign.
• Perform Teradata (Enterprise Data Warehouse) validation and analysis to identify the accurate data source and to track data quality to detect/correct the invalid data.
• Responsible for end user training and P&Ps and Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain
• Got involved in the User acceptance Testing (UAT) and SIT and documented the test scenarios and outcomes.

Environment: RUP, JavaScript, Oracle, Red Hat Enterprise Linux Server, COBOL, CSS, HTML,Google Analytics, R, R Studio,Alteryx, Tableau XML, LDAP, AML language, Balasamiq, TIBCO, MS SharePoint, MS Office Suite (Word, Excel, Power Point, Outlook), Unit testing