We provide IT Staff Augmentation Services!

Business System Analyst Resume

Troy, MI


  • Business Analyst with 7+ years of proven work experience in agile environment leading all Scrum ceremonies and have been versatile working in different environments using agile.
  • Acted as a liaison between technology and 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, 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).
  • Extensive experience in Guidewire configuration and integration experience with claim center, policy center and Billing Center.
  • Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home, and Marine.
  • Holds strong domain experience across Digital Banking, Core Banking, Retail and Business Banking, Payments, Mortgages, Loan Life Cycle, ITIL, GRC and CRM.
  • Strong working experience and familiarity of emerging regulatory standards including Basel, Dodd-Frank Act Stress testing, CCAR, KYC and AML.
  • Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Personal Property Casualty, Group and Life Insurance Systems
  • 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
  • Setup and configure Authoring and Publishing environments, replication agents, Apache rewrite rules for routing the calls to Adobe Experience Manager (AEM).
  • 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 Sitecore 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).
  • Developed, implemented and configure web content management solutions using Adobe Experience Manager (AEM) (Adobe CQ5) and technologies such as Java, HTML/DHTML, XML, JavaScript, and web services and Strong knowledge on MSM, Security, Authentication.
  • Experience in using Teradata tools and utilities like BTEQ, SQL Assistant, Teradata Manager, Teradata Workload Analyzer, Teradata Visual Explain, Teradata Index Wizard and Informatica Work flow design.
  • Verified that Risk-Weighted Assets (RWAs) were adequately measured against Tier 1 capital to ensure AIG's capital ratios meet regulatory capital requirements.
  • Expertise in creating databases, users, tables, views, functions, Packages, joins and hash indexes in Teradata database.
  • Unit Testing, Database testing, Data verification and validation of the code developed and compare the results with Oracle and Teradata systems
  • Experience using an Automated Clearing House ( ACH) production scheduling system
  • 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 all phases of Product Lifecycle Management (PLM).
  • 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.
  • Worked on market risk, credit risk, interest rate risk, counter- party risk, liquidity risk, operational risk, inflation risk, and systematic risk
  • Performed gap and risk assessments for two separate organizations across the entire infrastructure for CCPA and GDPR compliance as well as for all data categories.
  • 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).
  • 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.
  • Advanced and expert skills in various BI tools like Tableau, Power BI, Qlikview, NPrinting and MS Excel including PowerPivot and PowerQuery
  • 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
  • Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems
  • Good Communication skills and capable of working independently and as well as a part of a team.
  • Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment


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: Rational Rose

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, Balasamiq. ETL,Teradata

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

Web Languages: HTML, XML


Confidential, Troy, MI

Business System Analyst


  • performing privacy related risk management activities related to the enactment of the European GDPR regulation.
  • GDPR, CCPA and HIPAA compliance consulting for large healthcare/genetic research, digital media, and software development clients in Europe and the United States.
  • Capturing the requirements by breaking down regulations and based on the scope writing the requirements
  • Driving requirements which are applicable and actionable to bank for all 3 counties regulations and find and nuance in regulations
  • Conducting readiness assessments that result in recommendations, gap analysis, and implementation timeline.
  • Overlapping regulations which are actionable and applicable setting of meeting with all department which are in scope such as consents management, data mapping, systems, marketing teams
  • If Requirements overlap with 3 scopes of project the requirement gathering will be done by facilitating all departments into place
  • From scope we must derive requirements for policy, procedures, governance, Risk assessment
  • Conducted a GDPR vs CCPA comparison to ensure all aspects of both regulations are followed, enforced and compliant.
  • Privacy governance - Identified best suitable operating model for the client and updated RACI matrix to occupy GDPR and CCPA required roles
  • Customized GDPR and CCPA assessment framework to the client's requirements
  • Experience with Privacy Technologies such as OneTrust & TrustArc
  • Implemented OneTrust data privacy application tool, CCPA Implementations roadmap, CCPA Charter, recommendations target operating model (TOM), and recommendations on PI categories.
  • Monitor and analyze the results, trends, patterns, and events from Data Security and Privacy Compliance Tool OneTrust to enforce Data Privacy and Security requirements.
  • Implementing recommendations to achieve GDPR compliance such as creating consent and privacy notice solutions, writing internal policies and procedures, designing cookie solutions, designing records of processing activities, setting up third-party management programs, and conducting privacy and security risk assessments.
  • 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
  • Conducting HIPAA Security Rule gap assessments, privacy and security risk assessments, third-party security and privacy risk assessments

Confidential, Wayne, NJ

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.
  • Created complex reports, list reports, cross tab report and various drill through reports according to the customer requirements using Cognos 8 reporting tool.
  • Worked on building the PowerPlay cubes, PowerPlay reports and converting the PowerPlay cubes into Cognos 8 and utilize them using analysis studio.
  • Participated in Infor CloudSuite EAM (Cloud Based Application) optimization and customization through review and deep analysis of users' needs and building solutions.
  • Provided end-user technical assistance and ; assist in problem solving related to custom reports and Infor EAM application.
  • 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
  • Maintain relationships, and execute Bid, P&P, and Commercial Bonds for Surety clients.
  • Manage bonding/ surety relationships and information reporting.
  • Created Single Sign On (SSO) Process Flow Diagram's utilizing Microsoft Visio tool by discussing with Technical Leads and Lead Process modeling and optimization, SWIFT Messaging (both MT & MX Based), SWIFT GPI, Canonical message definitions, Data Migrations, Interface configurations, Dashboards and other large scale integrations with a deep understanding and hands on domain experience especially on payments processing, trade processing and settlement, custody, fund accounting and fee calculation.
  • Create User Stories from stakeholder’s requirements and translate those into a technical design document for the ServiceNow team to develop
  • Develop and configure PLM solutions supporting customer requirements
  • Deliver system to customer supporting roll-out of PLM system
  • 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.
  • Spearheading, designing and implementing company wide compliance efforts regarding the GDPR and the CCPA.
  • Created strategies and supporting documents for enhancing and streamlining the following privacy program components to GDPR and CCPA.
  • Worked on Lawson integrations with vendors on projects in the corporate systems.
  • Wrote data privacy policies and procedures on GDPR, CCPA, and general data privacy at the company.
  • Handle ACH exception items, processing issues, required information, limits, authorizations, errors, disputes, OFAC suspects and/or possible fraud.
  • Maintain ACH Claims inbox, responding to cancelled disputes and other inquiries.
  • Special assignment to complete development and compliance of Enterprise wide GDPR- CCPA compliance program.
  • Established processes for GDPR cookie compliance with OneTrust and internal auditing.
  • 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.
  • 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.
  • Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
  • Actively worked with the Capital Market and financial trading team to develop Equities, Futures, Forwards, Options, Derivatives online trading facility.
  • Utilize Microsoft Excel to create spreadsheets that require sorting, organizing, and manipulation of data in accordance to project specifications (pivot tables, vlookup, and IF nested statements)
  • I lead in delivering traceability analysis to Systems Owners for review and later baselined in CMS ALM.
  • I lead in documenting CMS Tracking Management System (TMS)
  • Used Application Management tools for managing requirements and defects, specifically ServiceNow and HP Quality Center.
  • Provide feedback and requests for the development and maintenance of the Agile PLM system
  • Always looking to develop new skills, discuss best practices and new ideas by attending annual ServiceNow Knowledge Conference and participating in ServiceNow user group meetings and webinars.
  • Integrate ServiceNow and other applications using REST and SOAP API, for real time monitoring and data migration to eliminate manual maintenance. Built logic for detailed logging and error check.
  • Manage new requirements in ServiceNow from the across the organization.
  • 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.
  • Develop operational policy requirements documents and health insurance operational instructions (standard operation procedures and workflows) according to CMS regulations.
  • Participated in requirements gathering, high level design, as well as low level design for the new (IBM product) check processing (IPD - Image payments director) slated to replace existing CPCS. This effort was to implement a more scalable check processing system using more current language's (JAVA), and distributed hardware.
  • 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.
  • Offered data support and checking using SQL/Query and developed complex spreadsheets using VBA\SQL.
  • Worked with requirements analysts and Subject Matter Experts to identify, understand, and document business needs for the data flow to create market risk and credit risk modules.
  • Partner with internal brokers and other intra company groups, and manage internal exposures through Credit Risk
  • 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.
  • Supporting Agile PLM platform with day to day activities such as Document and communicate changes throughout the user organization, Customizations, New Enhancements.
  • Involved in content management change control and Version Management. Performed regular updates to various static web pages.
  • Process ACH files and electronic payments and Reconcile ACH General Ledgers
  • Research and resolve ACH related disputes and process unresolved ACH returns
  • 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.
  • Coordinated with existing team members to deliver migrated AEM sites based upon agreed schedule.
  • Attended scrum and sprint planning meetings as AEM subject matter expert, documented best practices and guidelines using confluence.
  • Provided analysis of integrations between AEM WCM, DAM and Adobe Creative Cloud Applications such as Illustrator. And FrameMaker
  • Performed rapid prototyping and screen Mock-up utilizing I Rise
  • Used SAS and SQL to retrieve, validate and manipulate data
  • Assisted Testing teams to build test plans, approved test cases for functional requirements verification and to check the functionality of the application
  • 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.
  • Work with Development team to build/test the application/s on ServiceNow platform based on business requirements.
  • Tested the call flows for the IVR (Interactive Voice Response) System
  • Review possible check fraud and unauthorized withdrawals. Identify red flags related to the various fraud types for retail banking or credit card products.
  • Supported and mediated implementation of the bank's digital products for retail line of business and Managed consumer digital banking platform Involved in migration and enhancements to the Online and Mobile Banking platform.
  • Manage and implement strategic enhancements, ongoing maintenance, and future roadmap for various Digital Banking products.
  • Collaborated with business and risk partners to assess and problem solve risk issues for the Online and Mobile Banking Team.
  • Recognized for Business Analyst efforts for successfully delivering one the very crucial projects on the Mobile banking roadmap.
  • 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)
  • Involved in the migration activities, where some part of SAP EP was migrated to JAVA
  • Examines and evaluates the purpose and content of current business reports to identify opportunities for improvement and automation through macros, VBA, or SQL.
  • Created Data Lake by extracting customer's data from various data sources into HDFS. This includes data from Teradata, Mainframes, RDBMS, CSV and Excel.
  • Involved in scheduling Teradata and UNIX objects to run the jobs on daily/weekly basis depending on business requirement
  • Creating SQL and BTEQ scripts in Teradata to load the data into EDW as per the business logic.
  • Extensive experience on interaction with system users in gathering business Expertise in analyzing/troubleshooting and providing technical support for Teradata/Unix applications and their interfaces.
  • Extensively Used Teradata Utilities as FASTLOAD, MULTILOAD, FASTEXPORT etc.
  • Experience in SAS, creating data sets and migration from SAS data set to Teradata.
  • Collaborate with the business operations and ensure compliance with CMS model notice configurations, changes and mailings.
  • Responsible for generating quick excel reports using Pivot Tables, and Advanced Formulas (Vlookups, Countifs, Sumifs, Sum product, match, offset, lookup, Hlookup, if conditions) Excel Macros (recorded, modified and executed) to automate some of the testing and reporting tasks.
  • Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
  • Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables in Tableau.
  • Expertise in Performance Tuning of Tableau reports by following best practices in source data like data blending, custom SQL etc.
  • Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology & Working with departments creating Project Plan, Timelines and Executive Summaries to upgrade to Lawson LFS for HR/PR, Procurement and Financial suites.
  • Created UAT test plan (for AP & eBanking modules) that included test approach, test security, development & execution of complex use case user acceptance test scripts, scheduling of testing efforts, defect tracking for regression, considerations
  • Developed User Manuals, presentations and manuals as per project specifications and timelines
  • Provided status update to the Project Manager of progress made on work products and milestones achieved
  • Reviewed by scrum team and BA team to improve their performance.

Environment: Agile, Windows, MS SharePoint, Oracle, .NET, IVR, Minitab, QI Macros, PowerBI, OBIEE, Cognos, Tableau, SWIFT, 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, Short Hills, NJ

Business System Analyst


  • 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.
  • Analyzed business and technical process to determine process issues and coordinate resolutions, translating those requirements to either the ServiceNow development team or the project stakeholders
  • 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 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.
  • Created complex Metrics Packet for the PMO team, Updated databases and amended documents
  • Triaged, remediated, researched, tracked and helped resolve Quality Center defects assigned to the LPT Loan IQ Conversion team through all the environments
  • Participated in Infor CloudSuite EAM (Cloud Based Application) optimization and customization through review and deep analysis of users' needs and building solutions.
  • Worked on Table Maintenance, Adhoc query modules.
  • Act as lead for desktop installation of NetX360 system of over 200 users
  • Direct efforts for development of entitlement services for NetX360 system users by leading a selected team including access control/provisioning staff.
  • Enhanced functionality across Lawson applications(S3), including Enterprise Financial Management, Supply Chain Management and Human Capital Management.
  • Utilized Lawson Business Intelligence (LBI) for publishing and maintaining custom Crystal Reports for end- users.
  • Provide Compensation, Benefits, HRIS, and Payroll information and data expertise related to all organizations merging & Provide daily support and data management, data integrity, and reporting related to the talent management and Lawson.
  • Worked on Maintenance and updating of policies and procedures for time and attendance processes and implemented in Infor Lawson HCM.
  • Assist in the design definition of PLM Change Management process resulting in time saved and enhanced software change awareness.
  • Ensured data accuracy by authoring scripts that verified form values set for Lawson batch to run.
  • Developed Ad hoc Reports, Master Detail Reports, and Bursting Reports using Cognos 8.
  • Utilized Framework Manager for metadata modeling and created reports and published packages to the Cognos connection.
  • Gather requirements, configure, support, and train on Agile PLM for this company. Will also support other applications. Extensive experience with configuring Agile PLM.
  • Experience in installing Agile PLM software in standalone as well as Clustered environment.
  • Json Worked on SR Creation Follow up on Agile PLM related issues.
  • Designed & Developed 951 GPI Payment Tracking Services for the Treasury services.
  • 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.
  • 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
  • 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.
  • 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).
  • Data entered info via use of Calyx Point & DU & LP to prepare for underwriting
  • 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.
  • Analyzing, documenting and decisioning Bank Secrecy Act/Anti-Money Laundering (BSA/AML) related cases, reports and alerts.
  • SME in Handling E-CIF/CRM functionality testing and queries individually or with surround systems such as internet banking, FEAS, IVR, CAPS, RLS.
  • Used SQL to query data from the Security Master Database and gathered data from multiple live data feed sources such as Bloomberg, Thomson Reuters.
  • Perform Sprint Demo during Sprint review ceremony and record feedback
  • Identification of Performance Scenarios/Interfaces in the application based on the NFRs.
  • Design and build orchestration workflows for business process automation, by executing activities in other systems like Active Directory, VMware vCenter from ServiceNow.
  • Worked with business & IT users to identify and refine business requirements and workflows, as well as determine where ServiceNow can fit into business processes to improve services.
  • Created ServiceNow reports, dashboards & homepages and use the data gathered to work with process owners to determine KPIs and room for improvement in the platform.
  • Investigated software bugs and interacted with Development team to resolve bug issues using MTM. Effectively involve in logging bugs, reviewing solved bugs and analyzing test result using MTM
  • 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.
  • Assisted development teams in Testing for Bug Fixes in the daily builds and turn around for immediate fixes.
  • 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.
  • Create weekly Status reports for Business to track the progress of the project and highlight any deviations from the proposed plan.
  • Processed wires and ACH transactions for various departments such as Tax, Treasury, Payroll, and Fuel Accounting.
  • Complete wire/ ACH documents, with the approval of Treasury Management, to ensure positive balances remain in the account when sites process large dollar value transactions.
  • Analyzed Java, J2EE environments and platforms that currently ran the organizations different locations. Identified and optimized Process Flows and underlying processes. Prepared business case documents for each location
  • 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.
  • 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
  • Used Rational Clear Case, Configuration Management Tool to maintain different builds of the application with description about all changes and versions.
  • 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 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, Clientworks, 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, CT

Business Analyst


  • Application of Simulation to understand the current system and identify problematic areas
  • Used Simulation to verify the impart of Variability on the system and identified different levels of improvement
  • 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
  • Reviewed and analyzed surety and bond claims including performance bonds, motor vehicle dealer, sales tax, license and permit in a high-volume setting.
  • Processed surety bonds for clients.
  • Analyzed client financial statements for surety bonding capacity and credit.
  • Performed analysis of published Circulars from ISO/NCCI and other regulatory Bureaus for system impact and prepared detailed business and functional requirements.
  • Planned activities for the BA group and provide estimates for BA activities
  • Supported development of Project initiation, Project Charter and Project plans
  • Worked in developing the wireframe and mock-ups for the prototype of the web-based portal application in MS Visio
  • Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions.
  • 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.
  • Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
  • Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
  • Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated
  • 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 centers, 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 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.
  • Worked closely with architect team to design solution to meet business needs
  • 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
  • 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.
  • Used Rational Requisite PRO and IBM DOORS in various P&C projects for requirements management and traceability among requirements, uses cases, business rules and test cases.
  • Developed requirements and test management system utilizing IBM Rational Dynamic Object-Oriented Requirements (DOORS)
  • Used IBM DOORS Next Generation to manage user stories, backlog task, and prioritize task for projects, create test cases/test scripts, produce traceability matrix, and managed test integrations with business.
  • Administrating/supporting users, Importing and Sync Requirements in DOORS and DOORS NG.
  • 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).
  • Worked in Property & Causality (P&C)- Commercial lines & Homeowners insurance
  • Compiled detailed documentation for technical teams (architect and QA) involved to be clear on the nature and item being worked on
  • Gathered requirements for a fully electronic auto insurance contract process
  • 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).
  • 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.
  • Effectively valued and monitored credit risk exposure by developing and launching follow up action plan/ remediation plan
  • 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, Bellingham, WA

Senior Business Analyst


  • Lead business initiatives including brainstorming on new functionality for current systems.
  • Worked on Advance Loan System and well versed with all phases of Software Development Life Cycle (SDLC)
  • Extensively involved in Consumer loan lending process, loan origination, ALS loan booking process, payment applications, ALS billing & coupon concepts and Citibank, specific external interfaces.
  • Execute full development life cycle for credit card projects from gathering business requirements and solutions proposal thru project implementation phase.
  • Provides the most comprehensive and adaptable digital retail banking platform and innovative solutions designed to help banks and credit unions.
  • Successfully completed multiple debit and credit card projects across Digital and Mobile banking Channels.
  • Respond to incoming cardholder and all Contact Centre Representatives' inquiries involving credit/debit cards and disputes/fees and handle escalation calls and upset supervisor calls.
  • Responsible for completing assignments based on functional/technical specifications to enhance the existing credit card system as requested by business and users.
  • Documented compliance guideline showing the data flow process for the selection and process of various Loans.
  • Documented process flow of Mortgage Default, Foreclosure and Servicing Guidelines with performing and non-performing loans.
  • Gathered and documented the requirements that were critical to the business mission and used those requirements to design application software using a Use Case in Requisite Pro
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
  • Created and maintained the process documents for the project to be used for collaboration with developers, project manager, etc. on SharePoint.
  • Created use case scenarios and documents work flow and business process.
  • Documented business workflows textually as well as in UML diagrams (State diagrams) according to RUP, for the stakeholder review
  • Analyzed and documented Business requirements and detail design of the software for full understanding of the business.
  • Experience in SQL Server Integration Services (SSIS)
  • Created and maintained fields, views, reports, dashboards, campaigns and other salesforce.com
  • Maintained, enhanced and created workflows, functions and configurations within the salesforce.com environment.
  • Completed business analysis, system analysis, prototype, design and testing for Treasury Accounting including areas of Cash Management, Investment Accounting, Debt Management, and System Security and Workflow.
  • Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders
  • Prepared the UML Use Cases using Rational Rose.
  • Created UI requirements for Mobile app online banking.
  • Used Requisite Pro to document requirements, associated change requests with requirements and connected requirements with Use cases.
  • Implemented the screen prototypes as UI mockups for application functionalities, which serves as go-to shop for Business Client, Development and Quality Control teams, using iRise.
  • Assisted in Implementing UI/UX mockups using HTML, CSS and responsive frameworks.
  • Supported IT unit creating functional specification documents for the design, development and implementation of strategic projects.
  • Supported the assigned project manager with creating detailed project plans assisting in developing, scheduling and tracking project timelines.
  • Supported project governance and provided regular project communications to the project manager and business areas.
  • Implemented Partner portal on salesforce for Partners to better connect with different business users and suppliers, thereby increasing transparency.
  • Performed feasibility, adaptability study and risk analysis to identify the business-critical areas from USER perspective .
  • Involved in IT SOX Audit project-work encompassing direct reports.
  • Prepared test cases, test plans, test strategies, traceability matrix on MS Excel for QA team.
  • Involved in CRM processes like Design, development, planning, testing and integration of Salesforce
  • Daily salesforce usage to track, update and log project status throughout the project cycle.
  • Wrote User documentation in Salesforce discussing best practices for systems support utilizing working knowledge of financial and accounting operations and applications.

Hire Now