SUMMARY:

• Project Manager /Financial Business Analyst/Data Analyst with 8 years of experience in Finance Industry
• Including Offshore/Domestic Mutual Fund, Investment, Retail & Commercial banking, Brokerage Operation, Trading, Wealth Management, Asset Management and Fixed income
• Experienced in Sanction Screening, AML, 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 BRDL and derived SRS
• Designed 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 queryforidentifying databases involved in the application development
• Created defect tracking using HPQC and VersionOne, JIRA and reviewed them in subsequent iterations of the application development process
• Experienced 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, Tableau

Financial Databases: Aladdin, BlackRock, Bloomberg, Standard & Poor’s, 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, Use Cases, UML diagrams, Process Flow Diagram, UAT, RTR

PROFESSIONAL EXPERIENCE:

Confidential

Project Manager/Business Analyst

Responsibilities:

• Offshore Mutual Fund, foreign and domestic accounts with MGD FGN STATUS=Y/N, then CGPS and IPT will perform the WorldSky/BlueSky check for address validation
• Described the changes to be done to support offshore funds in Order Generation, Order Browse, Batch Process module accelerator in Lydia trading platform (BAU)
• MFT Offshore calendar API to Trade and Settle date for Offshore MF orders
• UMA batch will collect all MFT orders proceeds for that day and feed into MFT
• Worked on multiple Offshore Mutual Fund trading applications including Lydia for portfolio management group (PM), CGA for CGA, trading and accelerator trading for UMA clients
• Updated daily Unify SRS to see the SRS maturity complete, SRS review, SRS approval status on several Work Streams
• Unify Platform: Entity and Sequence accounts, Investment Attributes for SOLR
• Worked on RTM in Platform Specifications s in entity and sequence under several work streams
• Proposed and compared current view VS proposed view of the applications for SME
• Worked on Aladdin portfolio risk platform integrating BlackRock’s analytics into risk frame work of the firm for asset manager
• Assisted Financial Advisors to build and managed better portfolios by Aladdin, enhance the firm risk management across Wealth Management
• Real time risk calculations through Morgan Stanley/BlackRock technology connectivity
• Managed multiple projects at a time including Health Check, Unify Supervision Control Panel, Portfolio Level Supervision, Variance Dashboard, and Investment Screener

Environment: UMA/PM/CGA Accounts, AIUT, Investment Screener, UMAX, CGPS, Accelerator, Lydia, CGAT, CGTC, Vendor Feeds, ETF’s SMA’s, TRAK, FundSource, SOLR, 3D Desktop

Confidential, Somerset, NJ

Business System Analyst/ SCRUM MASTER

Responsibilities:

• Actively worked on WFA programs were considered, Brokerage, FA Directed, Separately Managed Account, Client-Directed, Fund Source-Mutual Fund Advisory and other
• 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) & Bloomberg Terminal
• Enrolments & Switched 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
• Ensured accuracy, timeliness of date for complex decision making within Brokerage Operation
• Managed and maintains smaller Brokerage Operation specific reporting systems such as system that track Associates productivity metrics
• Analyzed and interpret data regarding productivity, service levels, staffing forecasts and key performance metrics for various target audiences across all level of Brokerage Operation
• Conducted 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
• Worked 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, Tableau, 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
• 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.
• Used IBM DOORS Tool for requirement gathering & documentation
• Experienced 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
• 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
• 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, Tableau, Oracle, MS Office Suite, HP ALM, MS.SharePoint

Confidential, Cincinnati, OH

Business Systems Analyst/Data Analyst

Responsibilities:

• Interacted with product owners and business users and cross-functional teams for requirements gathering for RM53
• Experienced with Software development life cycle (SDLC) methodology, Framing out Business Transaction rules and related Documentation, creating Test Plans based on Functionality and Business rules
• 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
• Documenting the requirements into Requirement Doc. and listing out details functionality for the system in the Functional Spec.
• Maintained Change Request from the business and passing accurate information to the dev team
• Experienced in (ETL) data from Excel, Flat file, XML to MS SQL by using Tableau, SSRS, 2014.
• Weekly interacted 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
• Created, analysed and validating the requirements and then documented steps in the BRD/FRD

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

Confidential, Minneapolis, MN

Business System Analyst

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 Bloomberg Terminal

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

Confidential, Detroit, MI

Business System Analyst

Responsibilities:

• Reviewed portfolio, conducted 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.