SUMMARY:

• Financial Business Analyst/Data Analyst with 7 years of experience in Finance Industry including Retail & Commercial banking, Brokerage Operation, Trading, Wealth Management, Asset Management, Investment, and Fixed income
• Experience in Sanction Screening, Anti Money Laundering, Tuning Models, False positive alert analysis, Alert Threshold and Segmentation
• Effective at Requirements gathering, Data Analysis, Data Mapping, Data Cleaning, Data Mining, Data Warehousing, and User Acceptance Testing (UAT)
• Created Business Requirements Document (BRD) and derived FRD and SRS
• Design corporate banking process model with proficiency in Use Case development, UML Modelling with Sequence Diagrams & Workflow Analysis using MS Visio
• Strong working knowledge in writing SQL query for identifying databases involved in the application development
• Created defect tracking using HP QC and VersionOne,JIRA and reviewed them in subsequent iterations of the application development process
• Experience in creating test cases using HPQC, HP ALM and participated in QA and User Acceptance Testing
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income & Derivatives

TECHNICAL SKILLS:

Operating Systems: Windows7, XP

Application Software: MS Office suite, Rational Suite, MS Project

Databases Tools: SQL Server, Oracle, MS Access - SSIS, SSRS, SSAS

Financial Databases: BETA, Standard & Poor s Net advantage, Thomson Reuters

Financial Compliances: AML, KYC, Dodd-Frank

Methodologies: Agile (SCRUM), Waterfall & RUP(Rational team concept)

Requirements Management Tools: Requisite Pro, Quality Center, MS Visio

Defect Tracking Tools: VersionOne, JIRA, HPQC, ALM

Process Modeling: MS Visio, Rational Rose

Documents & Processes: SRS,UseCases, UML diagrams, Process Flow Diagram, UAT, RTR

CRM: Salesforce CRM, eFinance

ERP Solution: SAP FICO, General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Cost Center Accounting, Profit Center Accounting

PROFESSIONAL EXPERIENCE:

Confidential, Somerset, NJ

Business System Analyst

Responsibilities:

• Lead end to end testing to ensure correct data and process flows, data integrity and time efficiency between Thomson Reuters back-office system used by (BETA Systems)
• Actively worked on WFA programs were considered, Brokerage, FA Directed, Separately Managed Account, Client-Directed, Fund Source-Mutual Fund Advisory and other
• Enrolments & Switches programs and Asset manager for Clients FBAR/DMA/MAST accounts to commission based accounts
• Worked with different types of technology solution and Financial Industry Regulatory Authority including (FINET/FINRA/FRA/FiServ)/DOL
• Changed current behaviour to proposed behaviour based on Financial Advisor (FA) needs
• Worked with both Advisory Product Discretionary /Non-Discretionary Matrix
• Ensure accuracy, timeliness of date for complex decision making within Brokerage Operation
• Manages and maintains smaller Brokerage Operation specific reporting systems such as system that track Associates productivity metrics
• Analyze and interpret data regarding productivity, service levels, staffing forecasts and key performance metrics for various target audiences across all level of Brokerage Operation
• Conduct analysis of complex metrics for all of Brokerage Operations, including identification of positive and negative trends, potential root cause and provide recommendation to drive execution and manage risk against the firm goals
• Work with all levels of Leadership within Brokerage Operations and our partners in Technology Institutional, and retail to collaborate, resolve issues, provide status and updates, escalate, plan and prioritize multiple initiatives that follow the firm goals
• Understand clients needs and refer to other partners when appropriate, including brokerage

Environment: VersionOne, SIGFIG, InfoMax, SmartStation, Wisdom, ZMAN, GreenShot, Oracle SQL, MS Outlook, Visio, Lync, Office, Word, PowerPoint

Confidential, Boston, MA

Business Analyst/ Data Analyst

Responsibilities:

• As a Business Systems Analyst conducted weekly meeting with the core sanctions team and platforms team and provide them detailed project status
• Ensured smooth settlement via different clearing facilities: Euroclear, Clearstream, Fed Wire, Domestic, physical, and DTC etc
• Ensured that all settlement processes complied with regulatory guidelines.
• Reconciled banking operations transactions related to settlements.
• The project consisted of developing a comprehensive DDA, CD and Savings account system,
• Worked on documenting detailed specifications and conducting end to end testing of sanctions tool Multi List Manager which helped manage official blocked-entities lists (OFAC, DPL, EU, OSFI, DFAT, etc.) as well as user-defined lists
• Mortgage experience includes Consumer Mortgage Lending, Wholesale Mortgage Lending, Warehouse Mortgage Lending and Commercial Mortgage Lending.
• Experience in Validating and testing at all stages of SDLC in accordance to Basel II, US GAAP, and MiFID II.
• Worked on implementing Multi Laws Manager which helps reduces the amount of false positive hits and unnecessary manual review from the client side
• Conducted daily Stand-up meeting with offshore developers to get updates, assign task and clear doubts
• Worked with SQL Joins, Stored Procedures, Functions, Triggers, Index, ETL packages
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS)
• Lead weekly Triage Calls bi-weekly Triage calls with onsite and offsite SQA team
• Developed optimized data collection and qualifying procedures
• Managed, assigned and tracked issues in HP Quality Center
• On a regular basis ran queries in SQL developer & Squirrel (client tool) to do in depth Data Analysis
• Created and maintained Data Mapping documents which identified the backend tables that were related to the GUI
• Prepared Use Cases. Test Cases and Test data for system simulation purpose
• Analyzed and Prepared multiple, Technical Specification documents for the benefit of the DEV team
• Responsible for developing SOP and provided KT to the Business Support Team on the product

Environment: Windows XP, SQL Developer, MS Visio, HPQC, Oracle, MS Office Suite, HP ALM, MS.SharePoint

Confidential, Cincinnati, OH

Business Systems Analyst/ Data Analyst

Responsibilities:

• Interacting with product owners and business users and cross-functional teams for requirements gathering for RM53
• Account holders enter their ID and password to access their personal accounts, which includes checking and savings and money market account.
• The application provides the Checking, savings and DDA account lists, account summary, notification, account transactions for various accounts and the ability to transfer funds between the various accounts using fund transfers.
• This project dealt with various lines of business such as Commercial Lending, Consumer Mortgage Lending and Commercial Finance,
• Collaborated with internal teams to collect data required for account maintenance, Commercial lending servicing, and new product recommendations
• Strong understanding of the rules and regulations related to commercial lending
• Documenting the requirements into Requirement Doc. and listing out details functionality for the system in the Functional Spec.
• Maintaining Change Request from the business and passing accurate information to the dev team
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, XML to MS SQL Server by using SSIS 2014.
• Weekly interaction with the line of business and product owners and provided briefing on project progress and updates
• Prepared elaborate Data Mapping documents to link multiple internal source system to RM53
• Conduct daily stand-up meeting with onshore and offshore team to get updates and delegate work
• Supported the Business activities for RM53 application
• Created, analysed and validating the requirements and then documented steps in the business requirement and functional requirement document

Environment: Windows 7, AQT, MS Visio, MS Project Plan, HP Quality Center, JAVA, MS Office Suite

Confidential, Minneapolis, MN

Premium Wealth Management Tool

Responsibilities:

• Interacted with Stakeholders and Subject Matter Experts from front office and middle office to understand client business processes and gather information related to trade capture and execution details, order validations and confirmations, trade settlements & compliance.
• Actively participated in design review and change review meetings with the vendor.
• Analysed the impact of the new tool on processes specific to different business groups, write decision analysis and resolution documents(DARs) and project change request(PCRs) documents.
• Created test plans including test cases, test data and expected results
• Involved in the User Acceptance Testing (UAT), executing test cases for accounts rebalancing, various aspects of mutual funds and equities trading in a retail brokerage environment and Regression testing
• Participated/Lead team meetings to discuss test plans, current testing and defects statuses.
• Conducted reviews with business for sign off at the end of each milestone like creation of use case documents, test cases and test results.
• Lead end to end testing to ensure correct data and process flows, data integrity and time efficiency between new trading tool and Thomson Reuters (BETA Systems)
• Lead mock conversion task to validate real-time data integrity and accuracy.

Environment: Windows XP, SQL, MS Visio, MS Project Plan, MS Office Suite, DOORS, Quality Center.

Confidential, Detroit, MI

Business System Analyst

Responsibilities:

• Reviewed portfolio, conduct analysis and present wealth plans of action on a daily basis
• Created roadshow presentation for potential investors and assisted client management in developing concise and effective messaging for investor meetings
• Followed agile methodology of SCRUM Project Management and Sprint release implementation model.
• Gathered and analyzed Business Requirements from requirement sessions and created User stories, Acceptance Criteria as per agile methodology Life Cycle.
• Provided Mockups as additional support documents to User stories as Functional understanding document for the IT Development team.
• In Agile Environment, interacted on a daily basis with the project manager and development team to translate the business requirements to technical requirements.
• Identified Roadblocks to mitigate project risks to complete the project and created process improvement plan.
• Created UML diagrams such as use case diagrams, activity diagrams and Sequence diagrams.
• Communicated and interacted on a regular basis with the project manager and development team during different stages of the life cycle.
• Worked with Banking Compliance Teams and Fixed Income investment management Business Teams for gathering and implementing compliance regulatory requirements.

Environment:: Agile, JIRA, Microsoft Office (MS Word, MS Excel, MS PowerPoint, MS Visio, MS Access), XML, Java, Oracle, UML, SQL, Quality Center