SUMMARY

• Business/System Analyst, with over 7+ years of extensive experience in Business Requirement Gathering, Business Process Flow, Business Process Modeling, User Acceptance Testing, Business Analysis, Enterprise Data ware house, 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 Modeling Language (UML), and Rational Suite.
• Experienced in the Insurance- Property & Casualty, Reinsurance & Banking domain.
• Experienced in Accounting & Financial Analysis and performing GAP Analysis
• Knowledge of Federal and State billing regulations and tax compliance
• Adept with Office Automation tools (PowerPoint, Excel 2007 Pivot tables/VBA, Word, Access and Visio )
• Knowledgeable in GAAP, FAS, A/R, A/P, G/L, SOX methodologies and standards.
• Experienced Business Requirements Management and documentation in DOORS
• Experienced in Data Analysis, Accounting & Financial Analysis and performing GAP Analysis Extensive project management experience and knowledge of SOA methodologies and Lifecycles.
• 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.
• Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.
• 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).
• 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.
• Experienced in Trade Order Management System (TOMS) and Trade Life Cycle (TLC)
• Created User Requirement Specification (URS), Functional Requirement Specification (FRS), business process flow System.
• Expertise in liquidity risk reporting, treasury operations.
• 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.
• 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 and 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 assisted in post - Production support.
• 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.
• Creative and Enthusiastic Self-Starter.

TECHNICAL SKILLS

Process Methodologies: RUP - Rational Unified Process, UML - Unified Modeling Language, Waterfall, SAFe, Agile, Scrum, Six Sigma, CMMI, BPM, Smarter Process

Object-Oriented: Rational Rose

Data-Oriented: Erwin, PL/SQL

Universal: VISIO, Irise Studio

Quality Management: JIRA, Mercury Quality Center, Track Wise, VersionOne, RTC, HP ALM/ QualityCenter

Reporting: SSRS, Cognos, MSAccess, Irise Manager, OBIEE, Tableau, Tamarac

Project Management: MS Project, Excel Spreadsheets

Change Management: Bugzilla, Clear Quest, SharePoint, Rational Clear Case

Configuration Management: PVCS, CVS, Clear Case, SharePoint

Testing: SIT, UAT, Unit test, Rational Robot, Rational Test Director, Win Runner, Load Runner and Manual Testing

Requirements Tools: Rational Requisite Pro, Irise Manager

Web Languages: PowerBuilder, CSS, HTML, XML

Languages: C, C++, Java, Visual Basic, J2EE

Databases: Oracle (9i), MS SQL Server, MS Access, ETL Informatica, Teradata, TOAD

Office Tools: Office 365,MS Word, Excel, PowerPoint, Project, Outlook

Business Intelligence Tools: Tableau, Cognos, OBIEE

PROFESSIONAL EXPERIENCE

Confidential

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 Mortgage.
• 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.
• 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.
• Working in Property & Casualty and Claims Insurance domain as software business analyst between technology and business to help build a customized software solution, Accenture Duck Creek Claim Components (ACC), Accenture Duck Creek Policy Components with Agile methodology Managed all areas of supply chain management and customer relations.
• Designed, created, and implemented a business plan to support company analysed and managed Supply Chain reports, dashboards and performance metrics
• Provided technical leadership and functional expertise to guide and support supply chain team members.
• Researched and documented design specifications using various UML (Unified modeling Language) diagrams in Visio to support design activities.
• Tested the current Dashboard portal to make it to accommodate Business Process Management and contributed to Implementation Plans.
• Analyzed and tested various processes of Healthcare submission and processing process functionalities including testing the corresponding web services
• Collaborated with business units and delivery teams requesting system changes to clarify business requirements and benefits of changes.
• Provided technical support and coaching to team members.
• 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.
• Maintained and developed internal systems for convertible securities transactions and ran queries to generate new transaction ideas.
• Followed Agile Iterative development approach and was involved in all iterations of the development lifecycle and risk management.
• Delivered value-added findings and addressing compliance issues to business lines. The issues include but are not limited to efficiency improvements, revenue enhancements, or cost saving metrics.
• Developed and maintained relationships with assigned internal business partners including wealth and intuitional management, mortgage, and business banking markets.
• Mentored junior level staff and reviewed work for completeness, quality and compliance with established project standards.
• Manage Identity Access Management of Azure Subscriptions, Azure AD, Azure AD Application Proxy, Azure AD Connect, Azure AD Pass through Authentication.
• Helped with Data Mapping between the data mart and the Source Systems.
• Reviewed data & respond in a timely manner to various, numerous lenders & 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.
• Assisted the SR Bank Personal Wealth Management business in updating its various regulatory policies in conjunction with their recent conversion to the Pershing platform.
• 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.
• 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.
• Worked with reporting fraud activity providing resolution to stop further fraud activity.
• Educated the field and customers on appropriate processes that support fraud prevention. Worked in various tasks within the department related to the implementation and communication of fraud-related applications.
• 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.
• Utilize existing detection tools and strategies to prevent fraud.
• Respond directly to customer inquiries regarding fraud related activities.
• Design and implemented new process and procedures to prevent fraud; improved transaction processing as well as improved the chargeback management process
• Maintenance of money movement (Deposits, transfers & withdrawals) for personal, Trust and Estate accounts.
• Worked as an AEM Module Lead and responsible for creating snowflake on High-Level Design model for migrating AEM from Vignette Web Content Management.
• Managed schedules accepted time off requests and found coverage teaching when shifts were short. Accurate money movement handling and tracked receipts, employee hours and inventory movements.
• 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.
• Tested Trade Cycle (Front end) for Equities, Fixed Income, Bonds, Treasuries and Credit Derivatives to verify the alerts at different stages of a trade.
• Setting up of complete Order to Cash cycle setups from Quoting & order entry in order management to ship confirm in shipping execution module.
• Developed test scripts & conducted CRP testing for the Order to Cash cycle.
• I was engaged on the project in the functional capacity handing the Order to Cash and Procure to pay business flows.
• Flow Testing for Finance Modules Cash Management to make sure flow is working without any issues.
• Provided operations, project management, and systems skills to manage the project activities for the Global Order to Cash.
• 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.
• Design and develop business intelligence solutions using multiple data visualization platforms, including Tableau and Domo.
• Great IT Service Management (ITSM) experience in Change Management, Incident Management, Problem Management, Service Catalog, Self Service Portal in Service Now
• Develop data visualizations, including reports, dashboards, and analyses, to distribute data insights in easily digestible formats.
• Maintained consistent communication with fire departments to adapt analysis and visualizations for current needs.
• Built Service Now forms/catalog items from scratch in Item designers, Maintain items and Record producers, along with the advance customizations at the level of UI pages as per the requirements
• Correlate data from various data sources like MySQL and Hive to perform data analytics and visualizations using Tableau.
• Created data architecture and process flow documentation with Microsoft Visio to provide high level visualization.
• Create SSRS dashboard reports to assist visualization of financial and resource data to assist the R&E processes.
• Worked as Salesforce support governing user account creation, personal information setup, password reset, Roles & Profile creation, user group creation, updating company profile, Network access setup.
• Used Salesforce Automation (SFA) for Sales Lead Management, Account and Contact Management and Approvals and Workflow.
• Developed and worked on different Salesforce environments such as production and sandbox by employing the Migration Tool and Eclipse.
• Involved in Salesforce Application Setup activities and customized the apps to match the functional needs of the organization.
• Experience in Salesforce Administration, operational analytics, project management, and quality assurance with emphasis on process improvement.
• Experience in working with the Eclipse IDE with Salesforce plug-in environment for writing Business logic in Apex Programming Language and testing.
• Experience in working with Salesforce explorer for querying Salesforce database using SOQL &SOSL queries and Data Loader for data migration, insert, update, and bulk import or export of data.
• Good knowledge in developing the documents for data model design in salesforce CRM.
• Created detailed data mapping document for integrating various systems with Salesforcecom.
• Provided technical guidance for migration, configuration, and deployment of Office 365.
• Resolved tenancy technical issues and monitored Office 365 Systems.
• Assigned and revoked licenses to user accounts for services within Office 365.
• Used to coordinate between developers and client for debugging of proxy server application using fiddler.
• 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.
• Provided end user support. Created and delivered end user training on application functionality.

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

Confidential

Systems Analyst

Responsibilities:

• Developed Confidential ’s for mobile ( Confidential Anywhere) two factor authentication process.
• Performed functional analysis of requirements and develop deep understanding of the customer intake requests and create epics with LOE details for the customer requirements & perform walkthrough of the detailed requirements to (multiple) Domain Product Management team
• Worked in Scaled Agile and Kanban methodology and ensure all works are tracked under the bi-weekly Sprint model.
• Acted as a Subject Matter Expert around customer application and potentially be a cross domain and coordinated with the Portfolio lead in customer and SOA internal ceremonies
• Responsible for programming on specific application subsets of the company's application portfolio, participating in all phases of the development and maintenance life cycle, typically for an assigned business unit or corporate department and utilizing various customer technology platforms
• Represented the Solution Architecture in requirement walkthrough sessions with the Product team, domain team and with the consumers.
• Maintained active relationships with customers to determine business requirements, leads requirements gathering meetings and reviews designs with the business.
• Reviewed Epics with PO/Analysts during Pre-PI planning and review the customer Intakes in JIRA and Perform high level top-down and bottom-up analysis.
• Estimated high level ROI and LOE for the new Business requirement/enhancements of the work.
• Assigned the intake with LOE details back to Portfolio Leads and will move forward to Delivery lead for Intake approval and execution in progress.
• Represented with Portfolio Lead in the Meta-Roadmap or Scrum-of-Scrum meetings and Engage the “Customers” for detailed requirement & perform impact analysis
• Collaborated with APIGEE teams to ensure the API endpoints are available in a timely manner for development team and are securely integrated within Confidential firewall.
• Developed REST-based JSON/XML Web Services using .NET, ActionScript, SOAP, PHP, KML, and JavaScript.
• Experience in working with the Eclipse IDE with Salesforce plug-in environment for writing Business logic in Apex Programming Language and testing.
• Worked with various teams on setting new JIRA & Confluence instances for new teams. Created custom templates for use within Confluence
• Developed and worked on different Salesforce environments such as production and sandbox by employing the Migration Tool and Eclipse.
• Worked on multiple projects across Billing and Marketing domains.
• Participated in Request for Proposal (RFP) and selection of new systems vendor
• Acted as single point of sale for customers and stakeholders in matrixed organization.
• Ensured development and QA teams understood requirements and created a quality product.
• Involved in development of Business and Technical Requirements in preparation of Design and Functional Specifications for Business Needs with Rational Unified Process methodology.
• Experienced in supporting performance tuning and Rational Unified Process tuning at all levels.
• Compliance officer for the Payment Card Industry Payment Application Data Security Standard for Point of Sale (POS) software. Worked with Qualified Security Assessors to validate Point of Sale compliance.
• 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.
• Responsible for programming on specific application subsets of the company's application portfolio, participating in all phases of the development and maintenance life cycle, typically for an assigned business unit or corporate department and utilizing various customer technology platforms
• Worked on Confidential registration data migration from CAD database to Mongo database for Confidential and, worked on the migration of the Google members to the new consumer portal.
• Published Jira gadgets and dashboards on confluence page. Ensures unit test is completed and meets the test plan requirements, system testing is completed, and the system is implemented according to plan.

Environment: Ignite, Splunk, Postman, Soap UI-5.4.0, Oracle SQL developer3.2.0, Beyond compare4, Jira, Confluence, Bit bucket, MS-Office, Putty, WinSCP 5.15.1, FileZilla 3.41.0, Visual Studio, SharePoint, Service Now.

Confidential, North Branch, MN

Business Analyst

Responsibilities:

• Developed custom InfoPath interface to streamline the process workflow for Project Feasibility, Resource Allocation and Capital Assessment of the SWMC 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 Replica DB for promoting Database Marketing of Leads across Salesforce.
• Managed the operations & delivery of Cloud/Security/Data centre/Network services for a portfolio of enterprise clients, across multiple verticals. (Retail, healthcare, Finance, Telecom, Manufacturing).
• Implemented Service Cloud including Service Console, Customer Portal & Communities, Case Feed, Entitlements and Milestones, and Live Agent.
• Implemented Salesforce Development Cycle covering Sales Cloud, Service Cloud, Marketing Cloud Call, Center, Chatter & App-exchange applications.
• Customized the Dashboards to the track usage for productivity and performance of their sales teams.
• Sparse canonical Models analysis: Studied the statistical procedure to estimate the canonical.
• Worked with Kanban triage group to discuss about the due dates of defects.
• Maintained Kanban practices in the team and Implemented Feedback loops and manage the Kanban flow, improved the collaboration and evolve expediently.
• Successfully developed Scrum and Kanban and managed multiple software projects.
• Implemented Salesforce Development Cycle covering Sales Cloud, Service Cloud, Marketing Cloud Call, Center, Chatter & App-exchange applications.
• Experienced in Identity Access Management (IDM) and development using Sailpoint IIQ and having knowledge on SUN IDM.
• Customized Service cloud with service console, Cases, Chatter Answers. Incorporated the core modules in Microsoft Dynamics GP particularly The General Ledger for audit control to reduce transaction entry steps and increase accuracy incorporating data directly from one module to another.
• As a Business analyst, responsible of installation and implementation of Microsoft Dynamics GP.
• Migrated client's old data from various accounting system to Microsoft Dynamics GP 9 through integration manager, performed Microsoft Great Plains database migrations/upgrades from SQL 2000 to SQL 2005.
• Managed the implementation of Microsoft Dynamics GP 10.0 and was solely responsible for training, maintenance and liaising with Microsoft.
• Communicated with the Customer to define, configure, implement and support Microsoft Dynamics GP.
• Provided extensive user training for all the implemented modules of Microsoft Dynamics GP (Finance, Analytical Accounting, Bank Reconciliation, Fixed assets, AP, AR)
• Created and maintained relational database queries and stored procedures within Dynamics GP.
• 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.
• Lead Business Systems Analyst overseeing the responsibility for data mapping of three de-conversions from Vision Plus to two processors total Systems (TSYS) and First Data for accounts receivable.
• Assisted in defining the product vision plus, collaboration closely with internal and external stakeholders to formalize functional specification.
• Experience in implementation of Service Now ITSM modules like Incident, Problem, Change, and Service Catalog.
• Vision PLUS consists of various modules that work together to manage the life cycle of accounts And 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.
• Efficient use of Trade Order Management to locate and allocate trades and locate client accounts.
• Trade surveillance and post trade analysis to ensure trades are executed and cleared correctly through STP by Trade Order Management.
• Successfully managed end-to-end retail accounts to customer service, merchandising, distribution, inventory management, and coordinating with sales and other internal departments.
• Managed retail schedule, day-to-day tasks, and ordering of supplies. Managed inventory reports using QuickBooks
• Established service-oriented architecture/shared services center of excellence for retail MIS, delivering services consumed across channels, driving consistency in design patterns, and improving integration of applications.
• 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.
• Develop/ Modify/Test /Implement mappings in the Informatica ETL. (Extract Transform and Load)
• Create/Modify/Test/Implement workflows in Informatica ETL.
• Data warehouse/ ETL testing to validate data been transformed correctly
• 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
• Configured Data Entities, associations, Navigations, Service Implementations for Gateway projects. Validated policy and claim data to assure every detail are populated correctly from the legacy system WINS to Guide wire Claim Centre.
• Part of integration of Billing and Policy Centre systems using the inbuilt adapter.Mentored team members on Guide wire best practices.
• Worked with the business users and product owners to modify/add requirements to address multiple enhancements that are needed to fix any issues with previously implemented functionality in Billing Centre.
• Positioned payment processing as single source provider, bundling card processing and check risk management services with payment gateway technology. Payment gateway service receives the online payment request from your website and directs it to the payment processor.
• Payment processor service validates the purchaser's credit card details and checks if they have enough funds in their account to cover the payment.
• Built Counterparty database with quarterly reporting to capture and monitor Individual Country Limits and Country Group Aggregate Limits based on newly developed International MCE calculation (Reported to Executive Credit Risk Committee).
• Lead Credit Liaison for policy initiatives including Variation and Initial Margin for Uncleared Derivatives, Single Counterparty Credit Limit.
• Managed the Daily Single Issuer Test that measured aggregated counterparty exposure to company limits.
• Conduct risk reporting functions including counterparty exposures, position and sector limits, leverage calculations and cash reserves calculations.
• Worked on the Single Counterparty Credit Limit (SCCL) project with Risk IT to identify and source of all the data and reporting requirements - for compliance with regulations from the FRB.
• Monitored counterparty level market risk limits across global Rates, FX, Equity and Commodity business.
• Conducted quarterly risk overview presentation to the leadership of the funding department explaining changes in the credit quality of covered counterparties.
• Managed with Market Risk and Counterparty Credit Risk Analytics and Reporting activities.
• Maintained relationship with practice leads and desk officers in market risk and counterparty credit risk space.
• Provide counterparty credit risk analysis and calculations using SQL and Excel.
• 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 another 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.
• Enhance existing Trade Order Management System to accommodate the growing customer base of one our clients to add new Securities/ Assets, provide equity evaluations methods and enhance the blotter view adding new reports logic.
• 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.
• Implement all changes within QRM (Quantitative Risk Management) to ensure accurate reporting and hedge effectiveness.
• Enhanced existing QRM modeling to produce product level cash flows at a line of business level.
• Validate new and modified QRM features when clients upgrade to new versions.
• 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.
• 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, Payment Services gateway, 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.