SUMMARY

• Experienced in working wif Data Management projects, Basel and CCAR regulatory, Credit Risk Management System, Fixed Income trading systems, Anti - Money Laundering (AML) Transaction Monitoring System, and Stock Trading System
• In-depth knowledge of wide array of financial products including Stock, Options, Bonds and Treasuries (Equities, Fixed Income and Options) equity, fixed income derivatives, portfolio analysis, forecasting, budgeting and cost benefit analysis
• Managed the rollout of compliance projects wifin deadlines, facilitate training sessions on compliance related topics wifin company staff, and ensure that changes and modifications made are compliant wif all regulations and laws
• Profession in Use Cases on functionalities for stock pool allocation and optimization, pool substitutions, pair-offs, trade assignments, account allocations and broker give-ups
• Familiar wif Basel II&III, Fixed Income Clearing Corporation (FICC) and FINRA's rules and CCAR regulations
• Proficiency in data analytics wif emphasis on credit scoring, credit risk, behavioral models, loan loss and general purposerisk/profitability models
• Strong data analysis experience wif Microsoft Excel, Pivots, Macros, Formula and data crunching
• Knowledge and experience of Metadata management and familiarity wif Data Governance
• Highly experienced wif Requirements gathering, data modeling, System Architecture. Feasibility studies, Scope Documents & Requests For Proposal (RFP)
• Experienced in conducting Joint Application Development (JAD) sessions. Expertise in drafting technical documentation - Business Requirement Document (BRD), Functional Requirement Document (FRD), System Design Specification, Requirement Traceability Matrix, Test Plan
• Strong analytical, debugging, troubleshooting skills and quick learning abilities
• Strong interpersonal skills, extremely adept at diplomatically facilitating discussions and negotiations wif stakeholders

TECHNICAL SKILLS

• MS SQL Server 2012
• Oracle 11g
• SAS
• Metadata
• Teradata
• Informatica
• UNIX
• Microsoft Office Excel
• Word
• PowerPoint
• Access
• Visio
• Rational Rose
• Rational Requisite Pro
• RUP
• Agile
• Rally
• Axiom
• QTP
• Win runner
• Load Runner
• Quality Center
• Visual Basic
• UML
• MVC Framework
• Toad
• ERwin 4.1
• Actuate 6.0
• Jira
• Test Director
• Microsoft Excel
• Pivots
• Macros
• Formula data crunching

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

Data Governance Analyst/ Risk Data Steward

Responsibilities:

• Responsible for identifying Data Elements along wif accountable for defining the entire lineage of each Critical Data Elements back to the System of Record (SOR)
• Managed Critical Data Elements under the policies, standards and procedures of the Data Management Council (DMC)
• Supported to generate regulatory report such as Basel 3, Anti-Money Laundering and CCAR
• Worked closely wif stakeholders to assess current state, perform gap analysis, and develop requirements for business process
• Reviewed data elements wif the Business Owner to ensure requirements were completed
• Provided data definitions, data lineages and valid values for critical data assets wifin the area
• Identified where the elements was located and understood the transformation logic as to how the element was created
• Used Informatica to perform data profiling and data lineage verification
• Conducted data analysis in support of critical data elements to be reported for reporting
• Managed the rollout of compliance projects wifin deadlines, facilitate training sessions on compliance related topics wifin company staff, and ensure that changes and modifications made are compliant wif all regulations and laws
• Provided advice on improvement of Data Governance policies and procedures
• Initialed test of the data element to discover and identified whether the data was aligned to the required Business Rules and where potential data issues existed
• Proactive Data Quality and monitored ongoing quality of data assets
• Involving in MRDX conversion effort, reformatted data files, created initiatives, uploaded data files, reviewed and certified the data
• Raised Jira tickets when issues were spotted, tracked and managed issue wif Jira
• Involved in MRDX QA (Quality Assurance) Process, validated fields wif defined values contain values that are valid, validated the information in the request is consistent
• Provided walkthrough to other data stewards for MRDX introduction
• Assisted wif standard reports and presentations and escalate project issues and risk appropriately

Environment: Microsoft Office 2013 (Excel, Word, PowerPoint, Outlook, Lync, SharePoint, Access), Agile, CCAR, Basel III, AML, MetaTracker, Teradata SQL Assistant, Teradata, Informatica, Ab Initio, Qlikview, MDRX(Metadata Reference Data Exchange), MDR(Metadata Repository), ICDW(Integrated Customer Data Warehouse), Jira

Confidential, Princeton, NJ

Business Analyst/Data Analyst

Responsibilities:

• Identified, understood and documented business needs for new market risk and credit risk module or re-usability of an existing module by performing a GAP analysis
• Performed data analytics wif emphasis on credit scoring, credit risk, behavioral models, loan loss and general purposerisk/profitability models by brainstorming
• Evaluate requirements of US Basel III standardized approach for Credit Risk
• Mitigated extreme technology risk by retiring unsupported applications for the Fixed Income Trading platforms
• Integrate multiple reference data masters for securities to eliminate manual entry and operational risk
• Developed trade-related work flows for fixed income trades flowing through tothe settlementand accounting systems
• Developed business requirements for proprietary bond allocation models to be processed on Perform
• Leading identification and resolution of issue/risk/dependency by promoting collaboration wif SMEs and other stakeholders
• Generated Business Requirements Documents (BRD) by using MS Visio
• As Scrum Master involved in creating and prioritizing the Sprint Backlogs in Rally Scrum Sprint Planning Sessions, conducting Sprint Retrospectives and Reviews, sharing metrics to identify and implement improvements
• Constantly interacted wif stakeholders to develop release backlog and Functional Requirement Documents (FRD) into use case for the IT team
• Provided specifications for Data Models, Logical and Physical Database design
• Performed data analysis using SQL server in addition to implementing ETL wif the direct correlation to the data warehouse and data marts
• Tracked and managed project wif Jira when issues were spotted
• Documented Test Plan, Test cases and performed functional and stress testing
• Reported all the defects in Quality Center while conducting UAT and stress tests
• Managed all the requirements wif Rational Requisite Pro, making requirements available to all team members
• Designed Trade-Break, Aggregate report formats and evaluating COGNOS as an strategic reporting tool
• Facilitated UAT and recorded the user feedback for future changes
• Conducted training sessions to make the users comfortable wif the functionality and provided support on maintenance issues

Environment: Microsoft office, Agile Scrum, Basel III, Basel II.5, Rally, MS Project, MS Word, MS Excel, MS Visio, Cognos, SQL, Quality center, Jira, Microsoft Excel, Pivots, Macros, Formula

Confidential, San Antonio, TX

Sr. Business Analyst/ Data Analyst

Responsibilities:

• Extensively interacted wif both user group and development team, conducted JAD session to gather requirements for conceptual model
• Involved in extensive analysis and decision making wif the stakeholders to identify and realize relative value opportunities wifin and across multiple portfolios and trading accounts
• Reviewed and analyzed Fixed Income Clearing Corporation (FICC) compliance rules for Trade Processing Module which provides real-time submission, management and reconciliation of MBS trades and pools as required by FICC’s trade processing, risk management, trade netting and pool netting programs.
• Responsible for developing requirements for customization and enhancement of fixed income trading applications
• Documented specifications on Settlement risk mitigation through flexible, integrated workflow management throughout the entire MBS trade lifecycle
• Developed User Story on functionalities for MBS pool allocation and optimization, pool substitutions, pair-offs, trade assignments, account allocations and broker give-ups
• Designed the logical and physical models and came up wif structured charts, Class and sequence diagrams and activity Diagrams wif Design Team
• Frequently communicated wif the Data Architect team regarding the data mining, Data mapping and Data modeling and ETL processes
• Actively involved in developing Test Plan. Test Cases, Test Reports and Defect tracking
• Used Rational ClearQuest for all types of change requests, including defects, enhancements, issues and documentation changes wif a flexible workflow process
• Involved in data analysis using SQL Server in addition to implementing ETL wif the direction to the data warehouse
• Involved wif reviewing defects reported from UAT/B-Testing efforts and analyzed for root cause and took actions based on the findings
• Conducted training sessions to make the users comfortable wif the functionality
• Provided support on maintenance issues

Environment: Microsoft Excel, Agile Scrum, MS Visio, Jira, Base Clear case, Erwin, Oracle, DB2, MS Project, MS office suite.

Confidential, Atlanta, GA

Business Analyst/ Data Steward

Responsibilities:

• Conducts reviews of client documentation/information obtained by client contacts wifin the business units
• Ensures that information obtained is consistent wif BSA/AML Policy and Procedures and satisfies regulatory requirements
• Assisted project manager wif creating detailed project plans assisting in developing, scheduling and tracking project timelines
• Responsible for the data management ofboth the content andmetadata elements
• Assisted in building a business analysis process model using Rational Rose and Visio
• Conducted JAD sessions for communicating wif Stakeholders and SMEs
• Assist in the administration and review of Client Risk Scoring, Client Identification and KYC documentation oversight/management requirements
• Communicated extensively wif the clients and wif different levels of management to identify requirements, use cases and to develop functional specifications
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes
• Specialized in incorporates processes, policies, guidelines and responsibilities for administering organizations' entire data in compliance wif policy and/or regulatory obligations.
• Studied the existing KYP/CIP system and prepared the test data for the CDD and EDD based on the inputs
• Tested the application manually by executing Test Cases in Quality Center
• Developed UAT and specifications wif guidance from AML Compliances
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
• Monitored client expectations and conducted user interviews
• Prepared the report publishing frequencies and the media in which it shall be published(SharePoint), also prepared the document for filing frequency and filing format of the SARs, CTRs to the regulatory agencies and internal systems
• Involved wif reviewing defects reported from UAT efforts and analyzed for root cause and took actions based on the findings
• Conducted training sessions to make the users comfortable wif the functionality and provided support on maintenance issues

Environment: Waterfall, SDLC, Basel II, Teradata, Erwin, Microsoft Office 2010 (Word, PowerPoint, Access, Excel Pivot, Macro, Formula and VLookup, Outlook, Project, Visio), Rational Clear Quest, QTP, Mercury Quality Centre, Jira, RequisitePro, NICE Actimize

Confidential

Business Analyst

Responsibilities:

• Identified and communicated dependencies and potential risks to the completion of the sprints including resources, costs and systems
• Mapped and tested data requirements for Listed Derivatives like futures, options and other interest rate derivative instruments into existing trade order management system and back-office accounting
• Actively involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Standups, User Stories and Acceptance Criteria
• Constantly partnering wif project leads to ensure the team is producing solutions that meet established standards, procedures and practices, address issues, risks and mitigation plans
• Handle the operational process of determining and confirming derivative trade terms and regulations wif other professional clientele
• Prepared the final requirements document for peek and peer review and designed the process flow diagram
• Organized and conducted meetings and brainstorming sessions relating to database design and data assessment
• Coordinated in writing Test Plan, Test Cases and Test Scripts in Quality Center
• Involved in Creating and Executing Test Scenario based on User/Functional Requirements
• Defined QML components for defining the UI design
• Involved in various testing types like User Acceptance Testing, GUI Testing, Ad hoc Testing, Load Testing, Sanity and Smoke Testing, Integration Testing, Navigation Testing and Regression Testing, Security Testing on the Application under test
• Tested the Application Manually by executing Test Cases prior to Automation
• Automated Test Cases using QTP and enhanced scripts in QTP using Checkpoints, Parameterization of Data and inserting Synchronization points
• Performed on Automation Framework like Data Driven Test
• Developed and maintained the issues’ log during the length of the project
• Prepared traceability matrix from the requirements, for testing purposes
• Involved in designing test plans for UAT and Regression Test Suite
• Reported all the defects in Quality Center while conducting UAT & Regression tests
• Responsible for updating db tables and designing SQL queries
• Lead derivatives research and analysis teams and train members on using different computer softwares and applications as required
• Generated XML Schemas, XML DOM/SAX Parsers, XSLT
• Designed GUI, Validation files, Tag libraries and Resource Bundles.