SUMMARY:

• MBA in Finance and Master’s Degree in Accounting with 9 plus years of experience as a Business Analyst.
• Experience working with the largest investment banks and asset management firms and gained a valuable experience in Capital Markets with a wide range of financial instruments.
• Good understanding of various products in capital markets: Mutual funds, Fixed Income Securities and its trade life cycle (AML, KYC, Compliance, Pre - trade, trade capture to clearing and settlements, corporate action)
• Knowledge of Software Development Life Cycle (SDLC) and a thorough understanding of its phases like Requirements, Analysis/Design Development and Testing.
• Experience working in retail industry dealing with the need of end customers for commercial and non-commercial transactions.
• Good communication skills with the ability to present complex technical concepts and solutions to users in an easy to understand format.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Business Process - Consultant

Responsibilities:

• Contributed to document Business Requirement Document and Functional Specification Document.
• Partner / Liaison with Business team and IT team to validate the application functionality.
• Wrote functional test cases for the IntelliMatch application.
• Verification of inbound and outbound data validation of IntelliMatch application.
• Executed test cases and verified the output as per the functional requirements.
• Executed test scripts into MS SQL environments and validated data into Dev and UAT.
• Documented and track the defects based on the test cases outputs.
• Documented data mappings for DART (Data Analytical Reporting Tool) inhouse application.

Environment: MS Office, SharePoint, Business, MS SQL Server, ALM.

Confidential

Responsibilities:

• Based on Business Requirement, worked with IT team to implement the required layout for the respective feed in the CAR database for each release.
• Validated CAR files in both test and dev environment for development of any new implementation, prior to release in prod environment.
• Wrote SQL queries in UAT environment to validate the release implementation verifying with business requirement.
• Validated the monthly and quarterly CAR reports and provided to upstream team for the internal reporting. Reconcile the records count of data files as per the control files.
• Generated month end portfolio report for total AUM and new portfolios for the reporting month.
• Executed CAR month end query to generate the output for month end portfolios and AUM.
• Ensure proper reconciliation for month-end AUM and total records between portfolio report and database for Consumer and Mortgage portfolios.
• Updated the Data Quality Exception controls for each release to ensure the output values generated as per required threshold.
• Provided comments on the month-end variances between GL Amt and DataMart Amt for consumer portfolios. (Home Equity (SHAW) and Mortgage (FEDILITY) A/Cs)
• Documented desktop process for monthly and quarterly CAR reports submission to upstream team.
• Issues were logged in JIRA and fix as per the priority working with IT team.

Environment: MS Office, SharePoint, Business, CAS (reporting tool), MS SQL Server

Confidential - Direct Charlotte, NC

Technology Liaison/Data Analyst-Consultant

Responsibilities:

• Involved in Retail Separation Project validating the data splits based on company codes and carrier codes. Performed end to end testing of data to ensure proper data split.
• Work with Data stewards to document the data definition for data governance project.
• Established monthly release process for implementation of data and production issues and keep track and control on data movement between all the applications.
• Based on compliance team query check the database and respond within the cutoff time.
• Ensure proper integrity of data and reports into Salesforce application from upstream system.
• Work with diverse teams across the company to collect data and develop plans.
• Gathered data requirements from Data stewards and worked with IT team to implement.
• Prepared Test plan for testing team to compare and validate the database structure, tables, fields and data values into new system compare to existing system.

Environment: Ms Office, SharePoint, Business, Box Access

Confidential, Charlotte, NC

Lead Metadata / Business Analyst

Responsibilities:

• Gathered risk based approach feeds from respective application managers within Wholesale Wealth Banking domain and Community Banking domain for the Priority Data Supply Chains in scope.
• Capture Business Metadata into Collibra Data Governance Center and Technical Metadata into Ab-Initio for Top Exposure Report (risk and regulatory reporting).
• Delivered Project Status to Senior Management on a weekly basis, identified and communicated risk, and ensure that a proactive response is made by the team.
• Involve in documenting the Data lineage flow for preparing Metadata deliverables into Enterprise Lineage Template. Validated the source of feeds with application manager before documenting the source and target mappings.
• Prepared on-boarding / document for the new team members on the assignment.

Environment: MS office, SharePoint, Business Metadata Tool - Collibra (DGC), Ab-Initio (Metadata tool)

Confidential, Charlotte, NC

PM Coordinator / Technical Consultant

Responsibilities:

• Gathered risk based approach feeds from respective application team within Global Wealth Banking domain for the Priority Data Supply Chains in scope; Credit Risk Disclosure and Enterprise Capital Reporting.
• Documented Data Lineage for each hop from source to End point under Liquidity Data Domain of Corporate Treasury as Business GCF for Local Priority.
• Ensure proper validation of feeds, PDEs, Business Elements during each refresh of Lineage, through ATLAS Database structure files, if any difference in the lineage will update accordingly.
• Work with ATLAS tech team, transaction (operational) application in the Corporate Treasury, to document the gaps or any updates within the Data Lineage.
• Work with LIBRA tech team, Management Reporting application in the Corporate Treasury, to document the gaps or any updates within the Data Lineage.
• Involve in documenting the Data lineage flow for preparing Metadata and Control Template as per EDM requirement. Validated the source of feeds with application manager before documenting the source and target mappings.
• Involve in documenting control Artifacts for the data controls accuracy and consistency.
• Based on EDM reports identified the intra and inter gaps testing observations. Intra observations were related to the internal line of business and inter observation are related to the feeds gaps with other line of business.
• Delivered Project Status to Senior Management on a weekly basis, identified and communicated risk, and ensure that a proactive response is made by the team. Developing and managing the direction of theproject.
• Daily log in Quality Centre to confirm on the data validation defects count and take necessary steps to remediate the same.
• Review Data Sharing Agreement report published by EDM on SharePoint and identify if any inter feeds gap between working Business GCF and other Business GCF under respective supply chain.
• Published daily / weekly scorecard on the SharePoint site for the stakeholders to review the testing observations count showing counts increase / decrease comparing previous day numbers.

Environment: MS office, SharePoint, SQLServer-2012, Quality Centre V11.

Confidential

Operations Project Manager/ Business Analyst

Responsibilities:

• Gathered requirement to capture trade into front office for mutual funds products as per SEBI regulations for Onshore Mutual Funds and route through downstream system for clearing and settlement, document upload into K-Tracker after the final sign off from all the stakeholders.
• Analyze and implemented NAV capture process for offshore fund based on business requirements.
• Verified and validated the outputs as per business requirements to confirm on exit load applicable on redemption trades. Defects were tracked manually into excel.
• Handling of daily commercial and non-commercial investor related queries on day to day basis as per the trade cut of time and time stamp.
• Wrote Test cases to verify the functionality of the trade capture application and perform testing accordingly to verify.
• Daily reported posting control report (trail balance - P&L) on day to day basis to Fund accountant for of day balance and to derive Net Asset Value (price) for a given investment strategy.
• Led teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
• Delivered Project Status to Senior Management on a weekly basis, identified and communicated risk, and ensure that a proactive response is made by the team.
• Design MIS reports as per the client requirements: Daily reports, Weekly reports, Monthly reports, Quarterly and Half yearly reports, Investor details, Unit Holder Report, recons.
• Managing teams for various functions / process like: Transaction processing, Banking, MIS, NCTs, Brokerage
• Front office: Data capturing for investors, booking of trade, KYC / AML.
• Mid / Back office: Trade confirmation and processing of trade booked in front office, Uploading & Endorsement of NAV, Allotment of units and Generation of Investor Statements, running of MIS reports as per regulatory body requirements.

Environment: MS office (Word, Excel, PowerPoint), Visio

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Requirements Elicitation, Gathering, Clarification, and Analysis for enhancement of existing system or implementation of new system as per the Business requirements..
• Participated in the creation of Business Requirements Document.
• Conducted meetings with traders and portfolio managers to understand the trade flow.
• Conducted JAD sessions with stakeholders (SME, vendors, users) for open and pending issues
• Created and maintained Data Flow diagrams, Process Flows documents and data mapping from multiple source systems transformed as per the business logics loaded into one target system. (ETL process).
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements.
• Ensure application meets business requirements, Create and Track Test Cases and scenarios.
• Defect were track into defect tracking system (JIRA, QC)
• Involved in User Acceptance Testing of the application tested.
• Tested (ETL) data Extraction from the source system, Data Transformation and Loading of data to target System TLM (Central data warehouse) and validating the data against the business rules.
• Provided Project Support (Issues Tracking, User ). Created application Documentation (User Guide, Operations Guide, Manual, etc.).
• Involved in all stages of Software Development Life Cycle (SDLC).