We provide IT Staff Augmentation Services!

Business Analyst Resume

Allentown, PA

SUMMARY

  • Versatile Business/System Analyst, with Around 9 years of extensive experience with in - depth knowledge of Business Requirement Gathering, Business Process Flow, Business Process Modeling, User Acceptance Testing, Business Analysis,Enterprise Datawarehouse,Data Analysis, Data Mapping and Data Modeling. Successfully bridged the knowledge and communication gap between Business and Technology channel groups in various situations. Proven ability to understand a customer’s business and use cases and know how to deepen relationships and trust to ensure retention and growth.
  • Hands on experience and involvement in phases of Software Development Life Cycle such as Waterfall, Scrum, Hybrid (Scrum-Waterfall) environment and extensive knowledge on Extreme Programming, and Rational Unified Process.
  • Experienced in user requirements gathering, Use Case design and analysis, Use Case specifications, Scenarios, Business processes, Workflow diagrams, process flows and technical documentation, using Unified ModelingLanguage (UML), and Rational Suite.
  • Experienced in B2B and B2C Omni channel (Both portals and order Management) .
  • Experienced Data Warehouse Analyst who is well-versed in several database platforms and proficient in several kinds of extraction tools.
  • Adept in delivering project requests ahead of schedule working with database architects to maintain the efficiency of the database and utilizing a wide variety of database support tools. Specializes in data migration and database architecture management.
  • Experience managing/working with both onshore and offshore teams at multiple locations.
  • Experience in information security management and governance-risk-compliance management.
  • Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.
  • Managed and delivered Legal Records Automation project combining indexing, bar coding, image capture and desktop management of digital assets integrated with Iron Mountain systems.
  • Good understanding on Capital market such as Equities, Equity Derivatives Fixed Income - Corporate Bonds, Government Securities, Mortgage Backed Securities (MBS), Collateralized Mortgage Obligation (CMOs), Asset Backed Securities (ABS), Collateralized Debt Obligation (CDOs).
  • Expertise in Commercial Property and causality, Claims and Deposit Operations Representative; with focus in risk mitigation
  • Understanding of OTC derivative products such as Options, Futures, Forwards, Swaps, Credit Derivatives, Credit Default Swaps, Credit Linked Notes .
  • Highly experienced in various areas of Investment Banking: Portfolio Management, Fixed Income, Annuities, Trading Life Cycle, Stocks, Bonds, Futures, Options, Hedging, Equity Research, Mutual Funds, Securities trading and Commodities.
  • Knowledge of Anti Money Laundering (AML), Bank Secrecy Act (BSA), Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act. Working knowledge and understanding of Suspicious Activity Reporting (SAR) and OFAC reports.
  • Created User Requirement Specification (URS), Functional Requirement Specification (FRS), business process flow System.
  • Sound Proficiency in analyzing and Creating Use cases, Use Case Diagrams, wireframes for UI Design, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams and Navigational flow diagram and Sequence diagrams using MS Visio and Rational Rose.
  • Experienced in conducting Daily Scrum meeting, Planning Sessions, Backlog updates, User Stories updates
  • Exceptional ability to research, analyze and translate technical information to end-users at all levels.
  • 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.
  • Organized many Joint Application developments (JAD) and Joint Requirement Planning sessions (JRP), Interviews, workshops and requirement Elicitation sessions, sessions with end-user/clients/stakeholders and the development group.
  • Proficient in developing & automating reports, iteratively build & prototype BI dashboards using Tableau to provide insights at scale, solving for analytical needs of business team.
  • Involved in GUI testing, Functionality Testing, Regression testing, System Testing, Unit Testing, Integration Testing, Performance Testing, and Stress Testing.
  • Subject Matter expertise in Investment Banking, Fixed Income, Trade Life Cycle, Mortgage Origination, Mortgage Service, Secondary Mortgage Market, Loan, Credit Cards, Insurance, and Portfolio Investment Analysis.
  • Strong understanding of Mortgage Backed Securities, Capital Markets, Retail Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.
  • Strong knowledge of Finance, Accounting, and Sox Compliance.
  • Recognized as being dynamic, result-oriented, analytical and organized in managing multiple priorities.
  • Cross functional experience in Financial Services Industry Investment Banking, Retail Banking and Brokerage Services Banking.
  • Extensively interacted with the QA Team in executing the Test Plans, Providing Test Data, Creating Test Cases, Issuing STR’s upon detection of bugs and collecting the Test Metrics.
  • Thorough knowledge of Requirement analysis, Planning, Scheduling & Tracking projects.
  • Excellent knowledge in Asset Management, Wealth Management, Investment Banking, Derivative products such as Options and Futures, Credit Card, Insurance and Bonds.
  • Broad Knowledge in reviewing Test Procedures, creating Test plans and detailed test plans for UAT, Test scenario, defining Test cases, both System & Integration and executed many test cases Test Data reviewing and maintaining and executing detailed Test scripts for UAT, analyzing bugs,interacting with team members in fixing errors and User Acceptance Testing (UAT) and also assisted in post - Production support.
  • Expertise in managing project portfolio, project finance, risk analysis and mitigation, conducting market research, benchmarking, root cause analysis, trend analysis, and tracking using MS Project.
  • Insurance experience includes Commercial Automobile Products and Retail Automobile products and Property Casualty knowledge.
  • Mortgage experience includes Consumer Mortgage Lending, Wholesale Mortgage Lending, Warehouse Mortgage Lending and Commercial Mortgage Lending.
  • Experience with Oracle SQL and Toad, Teradata DW and Teradata SQL Assistant.
  • Extensive experience in creating screen mockups, conducting Gap Analysis, Stakeholder analysis, Impact Analysis, SWOT analysis, Feasibility analysis, Risk analysis, modeling Businesses Processes, and preparing Training manuals and Knowledge Transfer manuals.
  • In depth Knowledge in Data Warehouse including Data Mart, Dimensional Modeling (Star schemas& Snowflake Schemas), ER (Entity Relationship) Modeling, Normalization, De-Normalization, Logical Model and conceptual model.
  • Proactive with excellent interpersonal and communication skills, experienced in working with different personalities, and with developing positive and cooperative working environments.
  • Strong problem-solving, team-building, leadership, critical thinking, business acumen, strategic thinking, presentation, negotiation skills and adept at creating, editing, and coordinating extensive communication networks.
  • Maintained and created test cases for Subject Matter Expert Testing, NICE Actimize testing and System Integration Testing (SIT).
  • Creative and Enthusiastic Self-Starter.
  • SolidExperiencein Salesforce CRM, Salesforce Sales, Salesforce Service Clouds.

TECHNICAL SKILLS

  • RUP - Rational Unified Process, UML - Unified Modeling Language,Waterfall, SAFe, Agile, Scrum, Six Sigma, CMMI, BPM, Smarter Process
  • JIRA, Mercury Quality Center, Track Wise, VersionOne, RTC, HP ALM/ QualityCenter
  • SSRS, Cognos, MSAccess, Irise Manager, OBIEE, Tableau, Tamarac
  • MS Project, Excel Spreadsheets
  • Bugzilla, Clear Quest, SharePoint, Rational Clear Case
  • PVCS, CVS, Clear Case, SharePoint
  • SIT, UAT, Unit test, Rational Robot, Rational Test Director, Win Runner, Load Runner and Manual Testing
  • Rational Requisite Pro, Irise Manager
  • PowerBuilder, CSS, HTML, XML
  • C, C++, Java, Visual Basic, J2EE
  • Oracle (9i), MS SQL Server, MS Access, ETL Informatica, Teradata, TOAD
  • Tableau, Cognos, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Allentown, PA

Business Analyst

Responsibilities:

  • Created functional & technical specifications for an in-house front office trading application whose main products were related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages. Excellent knowledge in Component-based Development (CBD) and Commercial Off-the-shelf (COTS).
  • Reviewed, implemented, and maintained policies and procedures to ensure compliance with all federal (including FCRA, Fair Lending, OCC, and CFPB) and agency requirements.
  • Extensively involved in migrating the fields of financial instruments such as Fixed Income, Derivatives Securitized Products such as MBS on Trading Platform.
  • Imported the transformed data to design dashboards that aided business processes on Oracle OBIEE. 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.
  • Performed SQL queries using TOAD software. Wrote SQL statements to extract data from the Tables
  • Built and automated ETL processes using SQL, PL/SQL, UNIX shell scripting, Excel and VBA.
  • Prepared for GAP Analysis; identified and documented improving areas to meet capital markets requirement regulations.
  • Worked with traders on defining compliance requirements for trading MBS, ABS, Bonds and ELNs.
  • Requirements of migrating of Content from legacy system to Adobe AEM and functionalities including Multi-site management and multi channel management and Digital Asset Management.
  • Performed requirement gathering and knowledge extraction about the Investment banking and Capital markets using both formal and informal sessions through JAD sessions
  • Created test cases and provide testing along with coordinating UAT.
  • Constant interaction with Capital Market business users for job shadowing, understanding certain issues which I need to deal with for completing Proof of Concept and BRD.
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Reviewed data & respond in a timely manner to various, numerous lender & vendor questions/ requests in connection with closing loans and/or ongoing loan covenants; loan document review
  • Assisted the principal consultant with Application Rationalization and IT Portfolio Management.
  • Worked with mortgage originations, servicing, loss mitigations and loan modifications
  • Worked on the new Wealth Management Accelerators (WMA) which will enable private banks and wealth managers to provide a superior digital banking experience.
  • Performed periodic searches in the Orchestria System to identify e-mail addresses that could be added to the restricted list or "blacklist"
  • Assisted the Confidential Personal Wealth Management business in updating its various regulatory policies in conjunction with their recent conversion to the Pershing platform
  • Worked closely with Mortgage Specialist and Sales Opener to ensure that all information obtained on application is complete, legible and ready for underwriter review. • Worked on Client Onboarding Platform, business processes and functions including Risk/Regulatory, Credit functions, Tax functions, legal functions of Client Lifecycle management
  • Conduct audit trail reviews, trade practice surveillance, market surveillance, and real-time monitoring
  • Implement the firm’s global trade surveillance strategy which provides oversight and controls to reduce risk.
  • My current engagement also involves the design recommendation of current system, heading weekly meetings with IT and support team on any Actimize issues.
  • Also worked on resolving/ detecting any issues/ failures in the Actimize job and deep analysis before contacting Actimize support and try resolving any issues that can be at client end.
  • Participated in data modeling, data analysis and requirement documentation. Extensive experience in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR
  • Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
  • Executed treasury products as options, swaps, futures, forwards, swaps and debts.
  • Thorough knowledge of treasury operations Match Funding, Fund Transfer Pricing, FATCA reporting
  • Assist Director of Treasury and Cash Management with corporate credit card maintenance and fraud detection
  • Helped document the rational and requirements behind the XML architecture that encompasses data origination, secondary market and servicing data for implementing MISMO standards
  • Developed Order validation and Order management web services for order entry web tickets.
  • Drew visual workflow diagrams using formal notation such as the Business Process Modeling Notation (BPMN).
  • Compiled a performance report for the Wealth Managements primary SIBEL CRM system, which was reviewed by senior management. The report listed new objectives, completed tasks, and a status update on current projects.
  • Studied existing KYC/CIP system and prepared test data for CDD and EDD based on inputs.
  • Remediation of FATCA tax-related documentation.
  • Worked with the Remediation team to identify and analyze the ISA (Information Security Administration) functions to check for compliance and open CAP (Corrective Action Plan), RA (Risk Acceptance) or RE (Risk Exception) for AML (Anti Money Laundering), Bank of America Bond trading and Fraud prevention applications.
  • Tested Trade Cycle (Front end) for Equities, Fixed Income, Bonds, Treasuries and Credit Derivatives to verify the alerts at different stages of a trade.
  • This module included Online Bill Payments, Transfers, Online Bank Statements & Check Images, email & Wireless Alerts Conducted multiple gap analysis against Basel II, II.5 and III rules. Validated Basel II framework, including internal rating systems (PD, LGD, EAD models) and RWA calculation.
  • Worked on multiple projects across Billing and Marketing domains.
  • Participated in Request for Proposal (RFP) and selection of new systems vendor
  • Resolved all the issues pertaining to Point of Sales (POS) and the various transactions made at POS are checked and processed using the Debit Cards and Credit Cards.
  • Developed business requirements, GAP analysis, use case diagrams and data flow diagrams.
  • Involved in Defect Reporting, Defect Tracking and in Preparation of Defect Report using HPQC.
  • Performed User Acceptance Testing of Phase I build of Basel III system.
  • Developed wireframes and mock ups using Adobe Dreamweaver for UI Design Teams.
  • Wrote SQL queries to understand data relations and variances from other source systems.
  • Devised BRD after collecting Functional Requirements for Salesforce implementation from System Users which provided appropriate scope for the technical team to develop prototype and overall system.
  • Provided end user support. Created and delivered end user training on application functionality.
  • Strong use of security and customer reference data across domains to ensure transactional efficiency, regulatory compliance, and profit maximization.

Environment: Scrum, Oracle, OBIEE, PL SQL, HP ALM/ QualityCenter, Rational Requisite Pro, Rational ClearCase, SharePoint, Business Objects, Rational ClearQuest, Mercury WinRunner, Microsoft Visio, ERwin3.5.2, JIRA, Java.

Confidential, Fort Washington, PA

Business Analyst

Responsibilities:

  • Developed custom InfoPath interface to streamline the process workflow for Project Feasibility, Resource Allocation and Capital Assessment of the Confidential billing department
  • Worked on Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
  • Conducted interviews with key business users such as product management teams and SME's to collect requirements and business process information.
  • Gathered business requirements through interviews, surveys, and observing from account managers and product management teams and UI (User Interface) of the existing Web Application.
  • Designed ReplicaDB for promoting Database Marketing of Leads across Salesforce CRM.
  • Worked on LMS of CRM Sales force for lead generation campaign
  • Identified business and functional requirements through JAD sessions, operational evaluation, RFP and proposal
  • Developed wire frame diagrams for GUI that helps developers to prepare real time easily accessible screen layout. Ensure operational excellence by facilitating backlog grooming, sprint planning, retrospectives, daily scrum, and sprint reviews.
  • Excellent communication and teamwork skills utilized through written communication, phone and sales meetings. Licensed through the State of CT to write Property and Casualty, Life and Health and Commercial Insurance as well as provide bank and notary services.
  • Involved in creating user stories/tasks and translating them to technical specifications on Github Software. Observed and implemented mortgage originations, servicing, loss mitigations and loan modifications.
  • Obtained and verified financial information, such as applicant's credit rating and income level.

    Analyzed and evaluated applicant's finances to decide if applicant qualifies for a loan.

  • Communicated directly with mortgage banker, customers, agents and attorneys to achieve an ideal customer experience
  • Engage with stakeholders to gather, consolidate, and analyze requirements for each tool, business process and for the overall Decline Curve Analysis (DCA) application rationalization
  • Prepared and reviewed of closing documents for purchases, refinances and construction loans.
  • Trade surveillance and post trade analysis to ensure trades are executed and cleared correctly through STP.
  • Utilized PL/SQL coding and debugging skills to identify data integrity issues and recommend an optimal solution.
  • Utilized SQL*Loader, PL/SQL and Putty to create ETL packages for data uploading and error handling into error tables.
  • Implemented of recommendations from Basel Committee on Banking supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel II
  • Carried adjustment in operations of values of Credits, Debits, i.e. CVA/DVA, Fixed income security and credit derivatives.
  • Facilitate the setup of North American ABS/MBS securities on the Bloomberg terminal including other asset types such as CMO, CMBS, CLO, RMBS, student loans and other various ABS.
  • Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on progress, issues and deliverables of project.
  • Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non-financial transactions and trading operational processing in Comerica's global wealth platform.
  • 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, and Risk Identification.
  • Generate and coordinate client portfolio performance reporting through Tamarac software .
  • Worked with Release Management, PMO, Executive Management, along with managers/staff in Development, ETT, UAT, Core Business and other areas, to plan, delivers, and track testing progress.
  • Identified different risks such as credit risk (default risk), prepayment risk, inflation risk, and market risk. Project requirements for cash management practices adhered to accounting principles or GAAP.
  • Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
  • Conduct surveillance of SEF trades across multiple asset classes (rates/FX/credit/equities /commodities)
  • Master Data Management, including on-going data integrity and validation of system changes and enhancements.
  • Enhanced revenue and tax reporting by integrating the billing system with the general ledger
  • Determine how new rules, regulations or policies affect surveillance activities.
  • Tracking down issues and problems faced by customers in existing applications, analyzing them and providing effective solution.
  • Generating reports based on common user issues and making modifications in applications to enhance user experiences.
  • Reviewed Stored Procedures for reports and wrote test queries against source system (SQL Server) to match results with actual report against Data mart (Oracle).
  • Understanding and review of various documents including Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
  • Prepared requirement traceability matrices (RTMs) and managed all components of the business requirements.
  • Conducted Mortgage relevant training to off-shore teams so future releases are delivered defect free. Used Apex Data Loader and workbench mapped data sources and loaded data from legacy systems to Salesforce.
  • Involved in data mapping and migration of data from legacy systems to Salesforce Objects and fields.
  • Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
  • Worked as a liaison between developers and QA team in creating Test Plan and Test Cases using Rational Test Manager. Generated test data, and assisted QA team with manual testing whenever possible
  • Created class diagram, sequence diagram, and collaboration diagram using MS Visio.
  • Supported development team in unit testing by providing testing data during User Acceptance Testing (UAT) phase.

Environment: Rational Unified Process (RUP), Rational Suite (RequisitePro, ClearQuest, ClearCase), Tamarac, Jira, MS Visio, Database Marketing, MS Project, Java, J2EE, Oracle, ALM, Mercury Test Director, MS SQL Server, Rational Rose, MS Access, iRise, Business Objects, Tableau, Power Query, Java, C, Hp quality center.

Confidential

Business Analyst

Responsibilities:

  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Coordinate the activities of subordinates in the Interface Team and organize weekly status Meetings.
  • Facilitated JAD sessions with the clients and assessed the facts of the discussion to not only gain an understanding of the issues but to drive to a solution for Data Retention.
  • Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
  • Actively interacted with different business groups to perform the Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
  • Documented existing applications with the creation of UML sequence diagram and class diagram to document.
  • Involved in development & documentation of Software Requirements Specification (SRS) using Borland Caliber RM.
  • Deeply understood and documented process flows for Credit applications in compliance with PCI-DSS to ensure deletion of cardholder data after the retention period.
  • Design wireframes, using Balsamiq, to create innovative web-based workflows for UI Design and submission reports to align with client objectives and adhere to Government section 508 compliance rules.
  • Ensured data retention period falls under Escheatment Process of SEC (Securities Exchange Commission), FinCen (Financial Crime Enforcement Network), and OCC (Office of the Comptroller of the Currency).
  • Project coordinated the new State Records Center software implementation.
  • Perform analysis of records to develop and implement records management programs and procedures
  • Performed data and admin duties for the new Secretary of State Records Center software.
  • Provide assistance to directorates on records management program to ensure that all offices are adhering to applicable laws and regulations as well as standards, procedures and guidelines from the National Archives and Records Administration.
  • Involved in BI reports development efforts by working closely with Micro strategy, Teradata, and ETL teams.
  • Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
  • Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in Requisite Pro.
  • Generate tables, listings, and graphs using Excel, also used Excel to generate end of day reports for input into OBIEE.
  • Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
  • Used MS Visio to design the process flow for data deletion utility for cardholder data which exceeds the data retention period.
  • Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
  • Detected and documented the defects using Mercury Quality Center.
  • Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
  • Jointly worked with Security Analyst in creating Incident Response Plan.
  • Developed test plans in conjunction with team leads and business personnel and performed unit, integration, regression testing.
  • Designed management and executive level communications, reports, training material related to technology incidents and a repository for the documentation, diagrammed and wrote a clear process to follow and storage for all documents/diagrams
  • Created JIRA Stories, JIRA tickets in the Ticketing System for changes to high-level signature authorities, WIKI pages and RCA Legal/Compliance Review Process
  • Execute test scripts, coordinated & conducted UAT testing.
  • Worked with the Project Manager in documenting the Project Progress to ensure deliverables.
  • Assisted the Project Manager in setting realistic project expectations and evaluating the impact of changes.

Environment: Mercury Quality Center, SSIS, Informatica, OBIEE, SDLC, Oracle, MS Office, MS Project, MS Visio, PL/SQL, Teradata, Teradata SQL assistant, Rational Unified Process (RUP), Rational Suite (RequisitePro, Clear Quest, ClearPro), Windows XP, Java, SSIS, Jira.

Confidential

Business Analyst

Responsibilities:

  • The responsibilities involve thorough understanding the AS IS process and TO BE process, collecting requirements, creating required documentation.
  • Followed Agile Iterative development approach and was involved in all iterations of the development lifecycle and risk management.
  • Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, sponsor, and stakeholders to baseline the scope of the work and enable development of the plan.
  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Extensively worked with Project Manager to determine the current best practices for requirement gathering.
  • Facilitated JAD sessions to analyze and prioritize competing for business needs.
  • Interacted with Subject Matter Experts (SME's) and stakeholders to get a better understanding of client business processes and gather business requirements.
  • Analyzed business requirements and segregated them into high level and low-level use cases, activity diagrams, and sequence diagrams using Rational Rose according to UML methodology.
  • Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business Requirement Document (BRD).
  • Wrote clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.
  • Managed a pipeline of 'change process requests' by prioritizing requests, researching/ developing solutions, and communicating change.
  • Participating in the IT Reform/Rationalization efforts to cut cost and process time by standardizing requirements and prioritizing capability needs across services/components.
  • Project Representative on the Database Reconciliation Tools Task Force to work on Feature Usage Tracking.
  • Set up Demand deposit accounts automatically to adjust to interest rates when rate changes occur in money market accounts like mortgage accounts, bond accounts.
  • Execution of a thorough evaluation process towards Regulatory, Compliance, Risk,Surveillance, and Controls testing remediation, to ensure the data populations and samples are independently obtained and to certify that the proper sampling techniques are used and that sampling methodology and rationale are clearly documented.
  • Create wireframes using Axure RP Pro based on collaboration with use cases and Visio flows.
  • Analyzed the strategies of Risk management, Mortgage, Fixed Income and Derivatives in the investment division and conducted Portfolio Performance measurement: return, calculation, and attribution.
  • Analyzed problem incidents, debug SQL and implement fixes.
  • Used SQL to Work on developing complex data extracts, database applications, and ad-hoc queries as requested by internal and external customers.
  • Research and address compliance and risk findings for the department. Collaborate with auditors to determine high-risk processes and applications and develop controls to decrease business risk.
  • Develop process maps and procedures. Document risks and controls for process and IT assets.
  • Involved in reporting the schedule and the plan of the project using Business Intelligence.
  • Used HP Quality Center to log all the test scripts and test casesand generated the reports on a daily basis.
  • Examined, analyzed and modeled test plans, test scripts, test procedures and use case scenarios based on RUP methodology.
  • Used Test Director to coordinate and manage the master test plan, test scripts, testing resources, pass vs. fail cases and the entire testing process.

Environment: Agile, UML, Requisite Pro, Rational Rose, Clear Quest, SQL, Windows XP, MS Office Suite (Word, Excel, Access, PowerPoint, Outlook), PL/SQL, Oracle, SQL and Windows, Enterprise Data Warehouse, Ms visio, SharePoint, HP Quality Center, Java.

Hire Now