SUMMARY:

• Over 6 years of I.T. experience as Business Analyst in industries such as Banking, Financial Services, working with the technical staff to implement management and staff's business requirements into the software application in IT Industry.
• Extensive experiences in business relationship, budget management, risk management and wealth management, by working for world's leading companies.
• Adept at SDLC methodologies (RUP, Agile, SCRUM, XP, Waterfall), Risk Assessment & Management, & Project management in diverse domains such as Financial Services and Banking.
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server database.
• Experienced with the procedures of banking & Regulatory Compliances - Anti Money Laundering (AML), Customer Identification Program (CIP/KYC), CCAR regulation report, Dodd Frank Act, Basel II/III.
• Implemented business logic, data lineage mapping and traceability for Dodd Frank regulatory reports: Monthly and Quarterly FR Y-14 and Quarterly Call Reports (FFIEC031, FFIEC 041, FR Y-9LP & FR Y-9C) for Federal filing 2015 & 2016.
• Working knowledge of Case Management Applications (e.g. Actimize) and Strong product knowledge on financial instruments and payment/Treasury products Understanding of AML, KYC process, and Trade Life Cycle Working knowledge of AML/Financial Data (e.g. Wires, checks, ACH, Accounts)
• Strong Knowledge of BPM and BPMN and Creating dishoarding and data visualization skills using Excel, Tableau, or similar tools
• Deep knowledge of Bank Secrecy Act (BSA); Anti-Money Laundering (AML); Foreign Assets Control (OFAC) Laws.
• Extensive experience in Risk Management, Risk Assessment & Business Valuation by creating spreadsheet models in Microsoft Excel and using advanced statistical methods such as multi-variate regression, p-value, z-value, Null & Alternate Hypothesis.
• Experience in Financial Statement Analysis, Accounting Principles, Revenue Forecasting, Inventory Management, Variance Analysis, and Profit & Loss Analysis.
• Knowledge of different asset classes, Asset Management, OTC Derivatives (Futures & Options), cost & competitive analysis, and pricing techniques.
• Knowledge of UI/UX design concepts, experience in building wireframes for all screens of the application.
• Experience in HP Quality Center, ALM, Team Foundation Server, Gherkins, Rational ClearQuest and JIRA.
• Experience in creating enterprise data models, ER modeling for OLTP & dimension modeling for OLAP.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart. Expert in Dimensional modelling and ETL development.
• Strong skills with SQL and MS BI suite - SSAS/SSIS/SSRS. Highly proficiency with data visualization (SSRS, Power BI and R).
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema.
• Strong Experience in GRC (Governance, Risk and Compliance) Tools, GRC Consulting Risk Compliance Assurance Technology, GRC Technology and GRC Process.
• Extensive experience and knowledge on Cloud Computing, Cloud Server Architecture, Cloud Space and Services within SOA.
• Experience with SOX Expertise in developing QA Test Plan, Test Conditions, and Test Cases.
• Experienced in techniques such as SPRINT planning, Product Backlog management, Agile estimation, daily SCRUM, metrics such as Burn-down & Velocity charts, Sprint summary report, Sprint review/retro meetings etc.
• Strong Knowledge in integrating Aha and JIRA (two-way)
• Proficient in MS Suite, in particular Excel, SharePoint, Visio and PowerPoint, Provision, DOORS, HP Quality Center, etc.)
• Experienced in Unified Modeling Language (UML) & modeling (Process Mapping, Sequence diagrams, Activity diagrams, entity relationship diagrams (ERD), data flow diagram (DFD)) using tools such as Microsoft Visio and Rational Rose.
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) and creating business flow diagrams, user stories, use cases and prototypes across the deliverables of a project.
• Conducted and facilitated Joint Application Development (JAD) sessions or Elicitation Sessions with SMEs to better understand the business process and the interface requirements, where needed.
• Quality Assurance (QA) Experience with developing and reviewing test plans, test scripts, test cases, test reports, and using defect tracking tool to address bugs/issues as required by the project.
• Extensive experience in customization of Work Items, Transition Matrix in TFS (Team Foundation Server).
• Worked closely with Change Management team to update the requirement changes and implementing it in the project using tools like Rational Clear Quest.
• Excellent Written, Oral Communication skills and Conflict Resolution skills with the ability to communicate appropriately in business and technical situations at all levels.
• Team builder with proven capabilities of leadership, supervision, and training.
• Hands-on experience working within established global networks, and establishing new contacts internationally.

TECHNICAL SKILLS:

Programming Languages: XML, VB Script, Java, C++, .NET, HTML, ASP.NET, Java, SQL, PLSQL

Operating Systems: UNIX, Windows, Linux.

Methodologies / Frameworks: Agile, Waterfall, RUP, Scrum, XP.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM WebSphere, ATG Dynamo, BEA WebLogic.

Automation Tools: MS Visio, Rational Rose, Rational Clear Case, Rational RequisitePro, Documentum, Caliber RM, DOORS.

Project Management Tools: Mercury Test Director, Rational Clear Quest, HPALM, Team Foundation Server, Gherkins, MS Project professional, MS Project Server, JIRA, RALLY.

Content Management Tools: Documentum, SharePoint, Interwoven, FileNet.

Utility Tools: MS Office Suite, UML, MS Visio, BPMN, MS Project, Snag it, TOAD, Adobe Photoshop.

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS), OBIEE, Micro strategy, SAP Crystal Reports, Cognos, Tableau.

Data warehousing Tools: Business Objects, Cognos, Erwin, IBM Data stage, Informatica Power Center, SSIS, Data Marts, OLTP, OLAP, ROLAP, MOLAP, Oracle, Query/Reporting, Multidimensional Analysis.

Testing Tools: HP QC, Quick TestPro (QTP), Test Director, Win Runner, LoadRunner, Niku Project Workbench, MS Test Manager 2013, Selenium.

WORK EXPERIENCE:

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Gathered requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for user stories creation and obtain timely sign - off by all respective parties
• Involved with regulatory submission and internal audit requirements which were properly gathered and identified from the Subject Matter Entities (SMEs) via meetings, phone interviews, workshops, surveys, site visits, and JAD sessions.
• Collaborated with upstream/downstream data consumers, SMEs, QAs, Release managers and PMs to monitor test plans, test cases, UAT, post-implementation checks and future enhancements.
• Conducted one-to-one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• A result-oriented and dynamic business analyst in the Capital Market and Money Market.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Functioned as a primary liaison between the Business Line, Operations, and the Technical Areas throughout the Project Cycle.
• Understand and analyze the Business, Functional and Technical requirements and documented them in HP ALM and assigned them to the developers.
• Extract daily reports from HP ALM about the development and testing status.
• Ensured application development team meets design specifications to provide for a better UI/UX experience for the end user.
• Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
• Extensive knowledge of financial statements, accounting principles, derivatives, capital market, portfolio analysis, amortization, cash, deposits, risk management, credit risk, market risk.
• Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
• Worked on CCAR 14Q report for new FRB requirement like Disposition Loans, Disposed Scheduled Shift & Syndication Loan.
• Interacted with country user, operation, risk management, product control, finance and other stakeholders to capture business requirements and involved in creating enterprise level flows and timelines.
• Maintained audit controls for SOX compliance and GAAP accounting and business practices.
• Reviewed and updated DFAST process enhancements for presentation to examiners.
• Conduct independent and comprehensive tests of Pre-provision Net Revenue (PPNR) models for CCAR.
• Worked and conducted meetings with SOX and Internal Audit teams to implement SOX controls.
• Performed analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST).
• 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.
• Designed and implemented basic SQL queries for QA Testing and Report/Data Validation.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.

Confidential, Birmingham, AL

Responsibilities:

• Analyzed and documented Business Requirement Document (BRD), Functional Specification
• Documentation, and System Requirement Documentation, using UML methodologies.
• Involved in development phase meetings for business analysis and requirements gathering.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Analyzed and created Business Requirements and Functional Requirements for 14Q/A Actual for various schedules.
• Developed Functional Specification Document and Supplementary Specification (Non - Functional) Document.
• Designed and developed Project document templates based on SDLC methodology.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Strong Exposure on JIRA and Confluence.
• Responsible for working a queue of JIRA tickets to address system issues, user requests, etc. on a daily basis.
• Managed product backlog within JIRA and Used JIRA for issue tracking issues.
• Created custom workflows, screens and Custom fields for Jira.
• Worked with developers to made sure that they understood the Use Cases.
• Expertise in using Rational ClearQuest to open bugs, create tasks and user stories, initiate change requests.
• Assisted the 14A Projection team in the analysis for PPNR schedules - PPNR Submission, NII, and Metrics.
• Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
• Developed BPMN process flows for areas identified for enhancements.
• Generated reports detailing daily Trading flow through the SMARTR, VWAP, and TWAP routes
• Developed, tested, and implemented new proprietary trading system for NYSE and NASDAQ stocks
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
• Experience in the area of planning, administrating, developing and delivering automated GRC solutions using various GRC tools (RSA Archer eGRC Framework, Metric Stream).
• GRC (Governance, Risk and Compliance) duties - Work with Audit, IT, Governance, Risk, & Compliance, and the Lines of Business to standardize provisioning and recertification processes to ensure proper Data Security Administration practices.
• Created different types of reports in AXIOM- Control Report, Adjustment Report, and Manual Upload template
• Assisted Front Office with identifying KYC deficiencies, potential BSA/AML concerns and obtaining KYC requirements pertaining to borrowers, co-borrowers and other related parties according to Global KYC standards
• Consulted clients on Basel III regulation and introduced plans for FRTB compliance
• Importing and exporting Data from MySQL/Oracle to HiveQL using SQOOP.
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards
• Performed KYC due diligence, AML and OFAC/Sanctions program analysis for Third Party Payment Processors (TPPP).
• Communicate with clients and front office staff in order to obtain necessary AML requirements
• Maintained managerial surveillance reports, ensuring that client information was in good standing with the KYC/AML program
• Assisted in implementing the Liquidity Module of OFSAA (Oracle Financial Services Analytical Applications) for LCR / Federal reporting.
• Developed and lead team for Liquidity Risk Management (LRM) application on OFSAA.
• Developed good practices for risk modelling procedures related to CCAR/DFAST.
• Performed AML analysis and work with the business line to complete the documentation requirements to create the Customer Due Diligence (CDD).
• Complied with Anti-Money Laundering (AML) and Anti-Terrorist Financing (ATF) laws and regulations.
• Developed User Manuals and Training Manuals as per Project Specifications and timelines.
• Created Test Data requirements and coordinated and communicated with data team to load required test data in the Test, QA, and UAT (User Acceptance Testing) regions.

Confidential, Boston, MA

Responsibilities:

• Performed GAP analysis of business rules, business and system process flows, user administration and requirements and developed Requirement Traceability Matrix to find out if the current project requirements are met and ensured its timely update.
• Evaluated business processes & vendor outsourcing engagements to build a more sustainable business models for organizations.
• Created Requirement Traceability Matrix to list all the requirements and make sure all the required documents like Use Cases, Test Cases, are written and compiled.
• Worked in implementation and integration of strategies within a team - oriented environment, utilizing quantitative and qualitative analytical skills, conducting Cost-Benefit Analysis.
• Performed Impact Analysis of new functional changes and devised the development and testing plans.
• Setup TFS (Team Foundation Server) reporting server and built various reports and Customized TFS work items to fit business needs.
• Responsible for Bug reporting and tracking using Gherkin.
• Coordinated with business users to prepare and update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD). Created Use Cases documents for requirements using IBM Doors.
• Conducted status meetings and presided over the Changed Control Board meetings to discuss Defect, and ensure changes. Conducted risk analysis in case of defects in the product.
• Worked with Project manager and other users and created Work flow diagrams, Activity Diagrams on MS Visio/MS Project using Project Evaluation and Review Technique (PERT).
• Performed Strengths, Weaknesses, Opportunities and Threats (SWOT) analysis and implemented it in the business process. Conducted project planning according to the results.
• Provide budgeting support & decision support to executive management by analyzing financial statistics, trends & competitors.
• Helped manage commercial credit portfolio, identify risk-related issues and undertake appropriate risk-related measures to mitigate loan losses.
• Simulated customer growth scenarios using models based on selected pricing strategy to forecast revenue and company valuation.
• Assisted in compliance of risk management guidelines set forth by NIST (National Institute of Standards and Technology).
• Knowledge of different asset classes, Asset Management, OTC Derivatives (Futures & Options), cost & competitive analysis, and pricing techniques.
• Experience with Business Rules Management Systems (BRMS).
• Knowledge of Web Content Management (WCM) and WCM Solution Design patterns.
• Knowledge of NetSuite and harnessing it's power to achieve business goals.
• Performed Usability Testing and worked on UI Feature Specifications.
• Assisted with User Acceptance Testing with prospective users. Developed and maintained Standard Operating Procedures (SOP).
• Performed GAP analysis to identify the AS-IS and TO-BE business process to improve the process in the project.
• Conducted JAD sessions for requirements gathering with Business Stakeholders, SME's, Users and refined it through interviews, Story Board Sessions and Use Case Diagrams.
• Developed Swim Lane Diagrams, which helped in Rapid prototyping and pinpointing potential problems early in the process.
• Created Mock Up screens and Templates using MS Visio for better visualization and understanding of the software application.
• Improved the documentation of QA testing practices to enhance their repeatability, saving time and money and encouraging testing standardization and best practices.