We provide IT Staff Augmentation Services!

Sr. Business Analyst/ Systems Analyst Resume

Milwaukee, WI

SUMMARY:

  • Accomplished over 8+ year experience in highly qualified Investment & IT Professional with strong business analysis, data analysis and quality assurance experience in driving investment asset management business systems initiatives; specialized in the public markets domain, trade, operations, technology and accounting.
  • Extensive experience with Confidential.
  • Very strong in converting the systems from one vendor product to the other. Experience migrating trading systems, data management systems and investment accounting systems.
  • Experience working with the inbound and outbound feeds around various investment accounting systems like CAMRA, PAM and Confidential Accounting.
  • Experience interacting with investment accounting and finance teams and system interfaces.
  • Experience working on accounting platform migration from CAMRA to PAM.
  • Worked on implementing data governance for asset management and Confidential data domains.
  • Worked with Confidential branch offices and financial advisors in cleaning up the data and implementing Confidential data repository.
  • Experience in gathering requirements for cash and position reconciliation.
  • Very strong in using Excel API tools for Confidential market and reference data.
  • Strong Experience in Data mapping, Data Lineage and Data Quality.
  • Strong in Confidential modules installation/configuration/administration/development/Analysis.
  • Extensive experience in writing business requirement documents, user requirements, functional requirements, non - functional requirements, Current State, Future state flow charts, Solution option comparison, test case documentation.
  • Worked with enhancing the rebalancing processes for Confidential accounts.
  • Assist with the Confidential Trading Inbound and Outbound feeds analysis.
  • Experienced in Eagle reference data center, Pricing center and Integration workflows.
  • Strong in various SDLC methodologies, agile, waterfall frameworks and various tools like JIRA, HP Quality Center/ALM, Microsoft Project and Clarity PPM.
  • Experience with regulatory projects like Sarbanes Oxley and Dodd-Frank.
  • Experience working with mutual fund accounting vendor packages like Confidential.
  • Extensive experience with SharePoint, Visio, Power Point, Microsoft Project and Microsoft Office tools.
  • Strong in metadata and data quality implementations.
  • Participated in grooming sessions and created user stories on TFS.
  • Strong with Market Data management and vendor relationships.
  • High proficient with SQL against SQL Server, Sybase, Oracle and DB2 databases using tools like Toad, SQL Programmer and Rapid SQL.
  • Strong experience in testing coordination and working with various stakeholders like traders, investment operations specialists, accountants, infrastructure teams, developers and tests through project initiation, solution definition, solution design and solution execution phases.
  • Strong with testing life cycle to include, systems testing, integration testing, User Acceptance testing.
  • Extensive experience with Eagle Data Management.
  • In depth knowledge, support and training of the complete trade life cycle to the team and the business users.
  • Part of several major upgrades of Confidential functions.
  • Complete redesign of FX Workflows on Confidential to assist Front, Middle and Back Office functions.
  • Good Functional expertise on Trade Life Cycle of Equity, Fixed Income, FX and Cash.

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst/ Systems Analyst

Confidential

Responsibilities:

  • Worked on trading platform migration project from Confidential Confidential to Confidential Aladdin.
  • Documented business requirements, user requirements, functional requirements and non-functional requirements on trading platform migration from Confidential to Confidential Aladdin suite.
  • Worked on Back Office Transformation Project from CAMRA Accounting System to Eagle Accounting System.
  • Worked on mapping daily interface files from Confidential Aladdin to Confidential Accounting system.
  • Managed requirements for documenting Investment process flows, data flows and system flow diagrams.
  • Assisted with Aladdin Business Process review for Front office.
  • Worked on Data conversion activities working with Confidential Aladdin teams.
  • Implemented Transaction cost analysis (TCA) program trading and portfolio rebalancing for Equity Investments.
  • Created the requirements for the inbound and outbound feeds around Confidential Aladdin.
  • Supported Equity, Fixed Income and various Asset Classes.
  • Worked on 3rd party data feeds from Confidential.
  • Maintained Data analytics for daily transactions during UAT Testing and Reporting them to higher level Executives.
  • Worked with Eagle team for setting up model offices and transform data from Aladdin to Eagle Accounting system.
  • Worked on Fixed Income, Equities, Mortgage backed securities and Alternative Investments.
  • Worked on Eagle Reference Data center.
  • Worked on setting up Entity and composites in Eagle Accounting center (EDC).
  • Worked with data governance office to implement various data procedures and associated ARTEFACTS.
  • Created business metadata/Business Glossary for security Reference data.
  • Experienced in creating Reports and Report packages in Eagle Reporting Center.
  • Responsible for FX workflow automation from front middle and back office using Confidential .
  • Worked on validating Security master, Issuers, Trade data during SIT and UAT Testing phases.
  • Worked on loading Ratings, Security Xref files during daily process of operations into CAMRA Accounting system.
  • Used Collabra as a part of data operations support.
  • Worked on supporting camra Accounting system PROD and Test Environments.
  • Worked on issue log tracking, patches installation and ticketing issues on Camra environment through ticketing portal.
  • Experience in Setting up Security master, Portfolio and Accounts manually in CAMRA Accounting System.
  • Experienced in CAMRA Transaction processing and clearing daily holdings.
  • Worked on Security master recon using CAMRA RECON vendor package.
  • Created VBA macros for automating validation between Confidential Aladdin Security Master data and Camra data.
  • Used HP ALM and JIRA tools to manage the project issues.
  • Used Crystal reports to pull daily transaction data and various daily investment operations reports.
  • Expensively used SQL to pull the custom data from database for daily reporting.

Environment: CAMRA Accounting System, Confidential, Confidential Aladdin, Eagle Pace, MS SQL server, Eagle ML,Share Point, SSRS Reports, Crystal Reports, MS Visio, Win SCP, MS Office, SQL.HP ALM

Sr. Business Analyst/ Data Analyst

Confidential, Milwaukee, WI

Responsibilities:

  • Documented business requirements, user requirements, functional requirements and non-functional requirements on Trading platform migration from Confidential Aladdin suite to Confidential Trading system.
  • Involved in implementing FACTSET and associated inbound/outbound feeds to support the performance and attribution.
  • Worked with Markit EDM tool in supporting the trading platform migration.
  • Worked on data conversion Data Mapping, Data validation for mapping security master fields with Confidential required fields.
  • Created the current state and future state diagrams using Microsoft Visio.
  • Worked on transforming daily interface files from Aladdin to Confidential trading system.
  • Design and develop Custom Security Reference master.
  • Worked on coordinating with QA team, Developers on transforming the business requirements.
  • Worked on validating security master file to validate the data between test and production environments.
  • Requirements gathering across multiple functions and systems to include, accounting, performance and attribution, reporting, external clients, subadvisors
  • Trade Life cycle automation using Confidential Confidential, for front, Middle and the Backoffice functions
  • FX workflow automation from front middle and back office using Confidential . FX Connect integration with Confidential OMS screens.
  • Used TFS tool to manage the project issues.
  • Designed and developed SSRS reports and report packaged for custom report data pull for operations team based on business user requirements.
  • Worked on development of crystal reports for daily transactions and daily validation of transactions.
  • Configure Confidential data License security and pricing information.
  • Setup Data Governance policies, and metadata and perform lineage for critical data elements
  • Involved in reviewing business requirements and analyzing data sources from Excel/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Worked on share point to manage project documents.
  • Worked on SSRS and SSIS report packages.
  • Wrote complex sql queries for reports and for pulling data from database for custom reporting.
  • Confidential Fixed Income workflow setup, Data License configurations, Excel API and TSAPI (Trading system API) applications. Compliance engine rules configuration and setup.
  • Confidential Order Management framework: Comprehensive Order Management flows for all the asset classes.

Environment: Confidential, API, Confidential trading System, Eagle pace, Confidential, Aladdin Trading System, Markit EDM, FACTSET, SSRS, SSIS, Share Point, FX Connect, MS Excel, MS Visio, MS Project, TFS, SQL Server 2008, Oracle 11g, OBIEE, HPALM.

Sr. Business Data Analyst

Confidential, Jersey City, NJ

Responsibilities:

  • Worked on data enhancement initiative to support and asset and Confidential .
  • Worked with market data vendors like Confidential.
  • Worked with business data Glossary and data quality rules.
  • Worked with data stewards and data owners in implementing data governance policies and procedures
  • Worked with Confidential branch offices and financial advisors in cleaning up the data and implementing Confidential data repository.
  • Worked with various Confidential data domains like Security Master, KYC, Investment guidelines, holdings and pricing.
  • Implemented Collabra as a part of data governance.
  • Worked with enhancing the rebalancing processes for Confidential accounts.
  • Extensively used Uploaders and exporters for Eagle Pace process
  • Worked on data feeds by automating using Eagle ML for Confidential
  • Extensively used PL/SQL features such as database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Had a good understanding on Eagle Pace data tables to retrieve the data from database by writing complex SQL queries.
  • Worked on Fixed Income, Equities and Mortgage backed securities.
  • Worked on Eagle Reference Data center and on setting up data models for Datamart for all kind of Asset classes.
  • Worked on EJM monitoring tool for executing scheduled jobs in Confidential accounting.
  • Designed Data flows for Incoming data from External managers Confidential, Confidential, Confidential .
  • Created and maintained Eagle trade log and reconciliation reports.
  • Scheduling events and automating process using Eagle Automation Center.
  • Worked on setting up Entity and composites in Eagle Accounting center (EDC).
  • Supported investment data quality team by trouble shooting and identifying the root cause issues.
  • Worked on setting up Equity, Fixed income, Mortgagees in Eagle transaction processing center.
  • Worked on creating Eagle systems Business Glossary for referencing security master data and worked on date models for setting up Eagle Pace data base.
  • Developed SSRS Reports for custom Data extract for business users used for daily performance

Environment: Confidential Accounting and Eagle pace, Data Governance, SQL, Share Point, MS Project, Excel, MS Word, HP Quality Center, Informatica Quality Center, SQL Server 2008, Confidential Confidential, CAMRA, PAM, Confidential API, Confidential Data License, MS Office suite, MS Visio, SQL, PL/SQL. Oracle 11g

Business Analyst

Confidential

Responsibilities:

  • Authored the Business Requirement (BRD), User Requirements, Functional Requirements (FRD)
  • Gathered requirements by working with the relationship managers, wealth managers and field agents.
  • Worked on account onboarding, KYC and digital platform for the Confidential business enhancements.
  • Worked on Use Case diagrams in gathering requirements
  • Worked with development team to implement technical solutions the client
  • Used SQL to analyze data on data bases
  • Performed Backend Testing by executing SQL queries.
  • Generated Data Driven scripts that access the backend database.
  • Involved in developing test plan for the entire application. Developed test cases after analysis of the Business requirements and Business Use cases.
  • Participated in various meetings and discussed Enhancement and Modification Requests.
  • Interacted with all the developers to report defects and also to get the build status of the application.
  • Wrote Microsoft Excel Macros. Worked with the share Point sites.

Environment: MS Office, SQL, VBA Macros

Business Analyst

Confidential

Responsibilities:

  • Define and document customer business requirements, functions, and processes.
  • Provide support to technology teams serving as liaison between the business and IT.
  • Capture, analyze, and document business and end user requirements.
  • Assist in the preparation of the testing strategy and testing the execution plan.
  • Document requirements, status, and changes to existing configurations.
  • Gather, analyze, and document practices and workflows to identify efficiencies, alternatives, and gaps.
  • Create Use Case Documents, rules, and workflows.
  • Facilitate and document QA test plans and specifications, UAT, and post-production roll out.
  • Strong experience in conducting UAT and documentation of test cases.
  • Provide detailed weekly executive updates.
  • Developed Test cases to cover the entire functionality of the site.
  • Identify bugs by performing functional and usability testing.
  • Designed and developed schema data models.
  • Coordinated statistical data analysis, design, and information flow.
  • Transformed project data requirements into project data models.
  • Participated in requirements meetings and data mapping sessions to understand business needs.

Environment: MS Office, SQL, VBA Macros

Hire Now