business Solutions Consultant Resume
SUMMARY:
- Confidential is a Senior Consultant, Project Manager, Business Analyst and Agile Scrum Master possessing 15+ years of experience in Financial Services Domain and having served diverse financial clients in areas of Asset Management, Custody, Brokerage, Corporate Action, KYC/AML, Securities Lending & Collateral Management, Transaction Reconciliation, Counterparty Accounting & Settlement, Wealth Management and, Banking (retail, loans, deposits and IRA) with fair understanding of Mortgage (Loan Origination and Servicing), Cards (Risk Management), Insurance (Life) and Banking ERP.
- Extensive experience in projects associated with Regulatory and Compliance areas with regulations from Dodd - Frank, CCAR (FRY14, FFIEC & Call reports), IHC, Basel III, SEC, FED, PRA, CFTC & FINRA on projects like Cost Basis, Dodd-Frank - Sec 165, Reg CC, Basel reporting, FDSF Retail for PRA and form N-PORT & EDGAR Online enhancements for SEC.
- Project Management expertise (4.5+ years) in managing resources, task and budgets for new initiatives and system enhancement projects with medium & large teams in onsite/offshore implementation models focusing on resources, task, schedules, milestones and burn management.
- Scrum Manager (1+ year) managing data warehouse and compliance reporting project.
- Successfully managed client expectations and executed projects worth $1.5M towards system implementation/enhancements spanning multiple modules and iterations in a fixed price project.
- Worked on critical engagements by managing and building relationships with clients and multi-vendors, displaying sound collaboration, interaction, negotiation, communication and domain skills.
- Directed matrix teams comprising of Jr. BAs, Developers, and Testers on SDLC engagements including data analyst and Enterprise Architects.
- Performed functionality decomposition for one of the critical applications in the area of wealth management with one of the biggest Investment firm s in USA and IB in Switzerland.
- Experienced in various SDLC phases with proficiency in methodologies like Waterfall, RUP, and Agile.
- Proficient in analyzing business (‘AS-IS’ and ‘TO-BE’) opportunities using GAP Analysis, Risk/Impact Assessment, Process / Project Feasibility Study to achieve end state requirements and drafting Concept/Business Case / Process Documentation.
- Experienced in conducting Requirement sessions, interviews, JAD, project meetings, document reviews, and walkthroughs.
- Expert in BA documentations like business and technical specs, Information Mapping, Use Cases, BRD, FRD, Vision and Scope Document (VSD), UI/Screen Prototyping, Standard Operating Procedures (SOP), Process Flows, User Manuals, RTM, Test Plans, Test Scripts, UAT, Product Release Notes and Project Milestone Tracker.
- Experience in Process Mapping ‘AS IS' & ‘TO BE,' Process Modelling and developing TOM models from L0 to L4 using Chevron’s Manufacturing Maintenance Model methodology.
- Extensive experience in reporting, data mapping using SQL across databases (Oracle and Teradata) and running ad-hoc queries.
- Good understanding of business processes for asset classes like Listed and OTC Derivatives, Equities, Mutual Funds and Fixed Income and exposure to Securities Reference Data Management (SRDM) sources like Bloomberg, Eagle Pace, DST HiNet, Golden Source, etc . with sound knowledge of FPML and XML.
- Extensively worked on proprietary vendor products like ‘ InvestOne' (fund accounting) & ‘ GlobalOne’ (Sec Lending) from SunGard, ‘MaxIT' (cost basis) from Scivantage, ‘Risk Analytics’ (Risk Management) from Moody’s. Also, was exposed to Actimize (AML), Fi-Serv UMA, Charles River IMS and Metavante (Trust Mgt) sub-systems during project execution.
- Good knowledge of BI tools like COGNOS and Ab-Initio plus Tableau - data visualization and analysis.
- Experience in leading business and technical teams through the complete Software Development Life Cycle (SDLC) for large projects including user training for new as well as enhanced systems.
- Successfully managed team delivery in Onsite-Offshore models with the focus on managing project, resources, risk and vendors with Client Stakeholders and Project Delivery Managers.
- Extensive practical knowledge of BABOK and Agile/Scrum principles in addition to CMMI and IEEE software standards.
TECHNICAL SKILLS:
BA Tools: Rational ReqPro, BluePrint, MS Office, Balsamic Mockups, Pencil (OS), iRise
SDLC Methodologies: RUP, Agile, Scrum, Waterfall
Agile Tools: Rally, Version-One, JIRA
Testing Tools: HP Application Lifecycle Management (ALM), IBM Synergy
Business Modeling: MS Visio, Rational Rose, Business Modeler
Languages: UML, BPML, HTML, XML
Web Technologies: MS FrontPage, Dreamweaver
Database: Oracle, Teradata, Sybase, MySQL
Reporting: Tableau (10.9), QlikView, Crystal Reports
CMS: SharePoint, Alfresco CMS (OS)
Data Governance: Ab Initio MDM, COLLIBRA GRC
Data Visualization: Tableau, QlikView
PROFESSIONAL EXPERIENCE:
Confidential
Business Solutions Consultant
- Lead client discussions and Joint Application Development sessions for requirements discovery and validation.
- Define requirements by interviewing multiple actuaries and stakeholders to understand the needs and document in the form of Use Cases and Functional Specification Document.
- Describe processes for landing, staging, calculations and reporting schema with attributes, calcs, and rules for outputs derived and processed within the OFSAA suite.
- Adopt attribute and table for inclusion into the Oracle databases after due-diligence and gap analysis with rationale.
- Uploading Oracle confirmed data to Data Management Risk Control site using Collibra tool and following up with Data Management Office (DMO) for sign-off.
- Maintaining data lineage and classification on Collibra for each release and maintaining classifications like data type, schema name, the system of record, data domain, transactional vs. dimensional vs. derived data type, etc.
- To implement and deliver mechanical calcs by deriving formulas from the business prototypes and explaining related data-mapping with calculation rules to the development team.
- Validate report decomposition approach with the team, schedule client interviews, report walkthrough, FS reviews, and handling issues/escalation.
- Defining reporting layer for generating self-serve reports using Tableau with standardized transactional data and post calc fields for user experience studies analysis covering lapse, mortality, and partial withdrawals across Annuity and CBVA businesses.
Tools: SharePoint, MS Visio, HP ALM, Oracle OFSAA, Tableau Reporting, Collibra, Version One and other internal SoR.
Confidential, Washington DCLead Business Consultant
- Decomposed the proposed regulation "N-PORT" rule into BRD, FRD, and DCS.
- Conducted requirement elicitation meetings with IM Division, Office of Information Technology (OIT ) and other business groups for file submission reporting and SEC's back office reporting systems.
- Assisted business groups in deciphering legal content with business parlance leading to analysis and insight of N-PORT regulation.
- Introduced iRISE prototyping and mockup tools in requirement phases to transition from Waterfall to Semi-Agile SDLC Methodology.
- Manage new data creation and alignment with DERA mandated data and governance process/guidelines.
- Facilitated meetings and partnered with SEC’s BA COE to develop iRise requirements, SOP guidelines and by delivering reusable master widgets across all EDGAR Online (EOL) and UI intensive forms.
- Worked with a PM on monitoring work scope, performance schedules, milestones and project deliverables for the project to ensure work is appropriately assigned, planned and performed cost-effectively.
- Applied expert knowledge on iRise prototyping definitions, data structures and data validation requirements for highly specialized regulation serving as SME to OIT and IM divisions.
- Provided cost-effective design solutions to OIT and IM on data (retention, retrieval, dissemination, reporting, security, and audit ) for market sensitive N-PORT data.
Tools: iRise, SharePoint, MS Visio, HP ALM and other internal SoR.
Confidential, NYC, NYLead BA
- To support the development of the Bank's FDSF Credit Risk solution by streamlining implementation of Moody’s Risk Analytics (RAY) platform supported by QlikView (QV) Reporting covering 7 LOB’s and 18 applications by mapping attributes & entities from MDM repository.
- To document requirements that adhere to Risk Weighted Avg (RWA) and Non-RWA reports for Mortgage & Non-Mortgage LoBs through Historical data, MI and RWA calculations following PRA guidelines.
- To Design checks, validations, mappings, calculations, data reconciliations and implement changes relevant to regulatory reporting
- Review FDSF data for RWA/Non-RWA, MI reporting by comparing against historical submissions, including quarter-on-quarter analysis, variance analysis, and other checks to identify and resolve errors originating from hosts/RAY/reporting systems.
- To query source data and calculations for monthly, quarterly and ad-hoc periods by providing decisional information to internal customers by validating calculations from the origin and target systems.
- Applied financial product knowledge and understanding of regulatory guidelines (Basel III, Confidential LCR) and liquidity measurements (LCR, NSFR) to determine their potential impact on the bank.
- Dealt extensively with data lineage for all 7 LoBs and facilitated data governance processes like data dictionary and characteristics to eliminate duplication.
- Participated in vendor software customization, configuration requirements, analysis, mapping, and s stakeholder sign off on the main documentations .
- Supported Program Management with weekly statuses on planned activities, deviations, issues, queries, milestones and escalations for reporting to senior management.
- Perform functional testing, log defects in HP QC and re-test fixes for QV.
Environment: Oracle, Moody’s Risk Analytics, QlikView Reporting, HP QC, SharePoint.
Confidential, Wilmington, DEBA
- Acquired broad understanding of Enhanced Prudential Standards (EPS), Dodd-Frank Section 165, and Intermediate Holding Company (IHC) for Foreign Banking Organization (FBO).
- To capture business requirements for the technology solution for bank's FBO-IHC program that complies with S.165 of DFAST.
- Created new data requirements and compared with other regulatory reporting to eliminate duplication from data sources/feed and maintained living documentation on Data Governance SharePoint.
- Analyzed and documented regulatory requirements, roadmap and frameworks for Reg Data-Mart program covering implementation plan, feature requirements for Data Sourcing, Extraction logics for Reg DataMart and maintaining Master Data mappings.
- As a Business Product Owner, I actively participated in daily Agile Scrum meetings, coordinated Release Planning, provided User Stories and escalated issues for schedule adherences, backlogs and plans in coordination with the Scrum Masters, Product Owners, Business stakeholders and Scrum of Scrums (SoS) .
- As a Module Project Manager, I defined project scope, goals and deliverables with project task, resourcing, and budgeting using appropriate project tracking tools, fund utilization, project burn down charts along with the project progress, risks, and challenges with contingency plans for the Steering Committee.
Environment: Oracle, RALLY (Agile Tool), SharePoint.
Confidential, Wilmington, DELead Business Consultant
- Interact with Senior Management to provide the estimate, status, and issues on report decomposition
- Onboard, train, assign and review report decomposition approach with the team members
- Validate decomposition approach with the team and schedule client interviews, story walkthrough, BRD reviews, and escalation.
- Review and analyze code across diverse systems as accountable for team deliverables.
- Collaborate with business and IT team to resolve queries, defects and mitigate escalations.
- Coordinate with various stakeholders globally for additional documents about system access, reporting logic, requirement gathering and review the reports being submitted by Chief Risk Officer (CRO) to the board of Basel Committee on Banking Supervision (BCBS).
- Compared, created and maintained data lineage of Cards LoB in Ab-Initio Meta Data Management (MDM) platform to retain consistency from process documentation by working with data stewards.
Environment: Oracle Essbase, Business Objects, SAS, Other internal SoR and Ab-Initio MDM.
Confidential, Charlotte, NCLead Business Analyst
- Interact with Marketing and other Business stakeholders to understand Voice of Customer (VOC ) and identify customer requirements that can enhance ALLY’s market position
- Conducted JAD sessions for project feasibility and business requirements
- Document Use Cases (UC), System Specifications, Navigation flows and Mobile prototypes in Azure.
- Coordinated with various BUs and stakeholders for system requirements, product integration documentation, testing and implementation of the systems.
- Validate metrics and evaluate release candidates based on Testing and Development release cycles.
- Analyzed, researched and recommended well-articulated feasible solutions for implementing new designs and suggested underlying dependencies mitigate risk.
Environment: Clarity, SharePoint, MS Visio, Azure, FIS
Confidential, Stamford, CTSenior Consultant
- Read the rules and analyze to create template for analysis of 4000+ business entities
- Coordinate with various BUs and different stakeholders globally for additional documents about in corporation, activities, purpose, trading products list, investor list and constitutional references for shell, standalone and subsidiary entities to extract records of investors, products, and positions Validate data against business entities and updated management with deliverables post analysis of BU’s located globally.
- Validate records and transactions from Legal Structure Database (LSDB) on business entity setup services offered by UBS.
- Documented Standard Operating Processes (SOP) that outlined the methodology towards assessing BU's for Dodd-Frank compliance.
Environment: LSDB, SharePoint.
Confidential, Merrimack, NHLead Business Systems Analyst
- Worked with Product Owners cum stakeholders to elicit requirements, scope definition, prioritization and the release plans.
- Socialize system design approach and collaborate with technical teams for recommended solutions; ensuring all interfaces are identified and understood with documented business processes and system workflows
- Created processes and systemic data flow for Checking, Brokerage and Sweep accounts incorporating guidelines from Reg DD for front-middle-back office functions.
- Adhered all aspects of the Anti-Money Laundering (AML) and KYC Programs including Bank Secrecy Act (BSA), Cash transaction management, suspicious activity reporting (SAR) and customer identification requirements leveraging household data for historical frauds and risk using Actimize and other market databases to derive household risk score.
- Documented flows with upstream-downstream files from Actimize, Householding and Customer databases for customer/household fraud history validations and for calculating risk assessment to determine earliest fund availability.
- Followed FSDM delivery methodology for requirements documentation, estimate analysis, establish milestones and for scope management.
- Developed mock-ups for incorporating the web and mobile messages for deposits process in iRise.
- Documented high-level test scenarios and test conditions to satisfy Reg CC requirements.
Tools: Visio, SharePoint.
Dev Environment - DB2, GRE, Actimize CDD, iRise.
Confidential, Baltimore, MDLead Business Analyst
- Documented requirements by performing GAP analysis including BRD, Use Cases and other project documentation (project charters, capacity load, budget allocation) to balance stakeholder needs and negotiate tradeoffs between scope, schedule, budget, quality, and risk.
- Documented minutes and gained buy-in from groups who may be resistant to change on project scope, constraints, approach, impact, and schedule by performing and delivering critical path analysis.
- Defined communication bridge and relations with senior management, stakeholder and PMO on performance, status reports, escalation elevation and risk mitigation/resolutions while project delivery, interacted with Product Owner, Development & Testing teams and Scrum of Scrums (SOS) to resolved Project/Operational risks and issues.
- Analyze risks by probability and forecast impact to project delivery schedules utilizing Delivery Risk Assessment (DAR) and initiate steps to mitigate risk threats.
- Designed project organization chart, governance structures, RACI and RAID Metrics to resolve issue management.
- Defined processes for Change Requests (CRs) and Requirement Prioritization Matrix (RPM) for scope definition, scheduling, and cost-benefit tradeoffs.
- Conducted stakeholders meeting and JAD sessions for Process Documentation, created Process models in Visio and created wireframes for a web application.
- Co-ordinated relationships between Global Stakeholders, Product Owners vs. Development & Testing teams by managing project and operational risks.
- Used Agile/Scrum methodologies with the development team and blend of Waterfall cum Agile with stakeholders
- Access data from Reference data sources like Eagle Pace, DST HiNet & Bloomberg for Equities and FI asset classes.
Tools: Visio, Balsamic Mockups, Dream Weaver, Blue Print, IBM WebSphere Process Modeler
Dev Environment: Dot Net, Oracle 10G, Alfresco Document Management Systems SRDM: Charles River, Eagle Pace, DST Hi-Net, Bloomberg.
Confidential, Richmond, VASr Business Consultant
- Conducted user interviews and requirements gathering sessions
- Documented and published BRD, FRD, Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object-oriented Design) using UML and Visio.
- Interacted with Product Owners for requirement gathering interviews, defining user stories, sprint cycle planning, backlog grooming, delivery management and conducting retrospective meetings.
- Conducted Product Backlog Grooming sessions to improvise the requirements, user stories, and the functionalities delivered at the end of each sprint cycles.
- Documented database source & target systems, the volume of data, staging areas, transfer methods, and reports as part of conversion activities.
- Interacted with Scrum Product Owners, Scrum Masters, Data Stewards and senior management in tracking/resolving data lineage and requirements for mortgage data warehousing program.
Environment: Teradata, SQL, Rational ReqPro, HP Quality Center
Confidential, TXLead Business Analyst & Project Manager
- Trust - Order Management System POC for Trust, USAA
- Supported initial planning, vendor identification, integration and pre-implementation study for Charles River Development (CRD) Investment Management and Compliance Solution (IMS) for the Trust BU of USAA as a Business System Analyst where facilitated walkthrough, process study and requirement sessions between business, systems (Metavante) and CRD team.
- Cost Basis Compliance (EES Act, 2008), USAA (Brokerage & Wealth Management)
- As a PM, I managed the team, scope, and deliverables, while as a Lead BA; I documented requirements that meet IRS guidelines for Cost Basis disclosure. Documented requirements for delivery channels (mobile, .com, and portal) to end users through single sign-on (SSO) by integrating solutions from Scivantage MaxitTM (Record-keeper) and SunGard’s Wall Street Concepts (1099-B reporting). Maintained project plans, RAID logs, data dictionary, scenarios/prototypes, communication and escalation channels with Scivantage (Vendor) during product implementation.
- • Online Retirement Center (ORC) for USAA (Wealth Management)
- While engaged as Lead BA, I documented the requirements to revamp design, content, calculators for the Online Retirement Center Portal and .com and introduced rules manager to display contents based on consumer/customer demographics over the Web/Mobile channels.
Lead BA QA
- Served with Trust and Securities Servicing (TSS) IT as a Lead BA QA leading team of testers for an invoicing and billing application.
- Prior engagement included working with ‘Domain Consulting Group’ (DCG) to understand and explore DB’s Investment Banking and Asset Management landscape to position for additional business growth based on capabilities.
Lead BA-QA Testing
- Lead the Software Testing Team (8 members) to execute unit and SIT and documented errors/bugs in IBM Synergy
- Responsible for test delivery including work allocation, resource management, test release management and status reports to senior management using ‘PM Smart,' a CMMI compliant proprietary tool.
Environment: IBM Synergy
ConfidentialLead Business Analyst
- Developed Process flows and application landscapes for Deutsche bank’s AM, IB, and PCB business units.
- Created landscapes and process models for Investment Bank, Asset Management and Pvt Commercial Bank using BPM tool (IBM System Architect) covering asset classes like Equity, FI, FX and OTC derivatives with reviews from SME’s, Domain Architects and clients to baseline the understanding.
Sr Business Analyst
- Documented system enhancement requirements and CR’s for Portfolio and Pricing data to calculate NAV
- Collate pricing information for Securities Reference Data (SRM) from data providers when the price has stalled due to error s in batch jobs and updated erroneously in GL / Holding statements based on client/stakeholder request
- Run reconciliation jobs for counterparty accounting and settlement providing latest Portfolio and Receivables/Payables data on demand.
- Served as Production Support BA for InvestOneTM, wherein ran ad-hoc SQL queries to determine daily health checks for Apollo (GUI of InvestOne) application
- Communicated with SMEs and Project Architects in solution definition, BR prioritization, estimation, requirements, test cases, UAT, rollout plans and documenting Product Data Management (PDM) and User Manuals.
Environment: ReqPro, QMF, and InvestOne TM, Securities Reference Data Mgt
Confidential, Boston, MABusiness Analyst
- As part of a technology upgrade, State Street had identified critical apps developed in COBOL, C, Access, and VB for migration to Java/J2EE framework.
- My role was to understand the applications, document system requirements and define test scenarios/cases to ensure replication of business functionality on the new architecture.
Environment: Web based application GUI built on Java/J2EE, Mainframe/DB2, and UNIX.
ConfidentialSr Process Analyst
- Business Analyst to study Processes for Sec Lending, Collateral Management, Corporate Actions and Class Actions for Confidential operations while in Confidential documented processes for Equity Derivatives Confirmations Accounting & Settlement.
- Responsible for Process Mapping, SOP and Risk analysis documentation based upon risk assessment with stakeholders for Investment Banking and Wealth Management groups.
Confidential
Business Analys
- Documented requirements to automate manual processes about Cash Management, Customer Onboarding (KYC & AML), Bank and Branch Reconciliation, Banking ERP for Loan Disbursement (Payables) and Settlement (Receivables) for Personal-Auto-Mortgage businesses that enhanced banking efficiencies. Deliverables included business requirements, data mappings and business automation rules that trigger overnight to generate daily and fortnightly reports for banking MIS team. Served as BA cum tester to support Requirements Gathering, Testing and UAT phases.
