We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

2.00/5 (Submit Your Rating)

Detroit, MI

SUMMARY:

  • Over 7+ years of experience in business analysis, project risk and quality management, investments assets and business systems initiatives. Highly proficient in Business intelligence, Visualization, Management reporting, Data Analysis, SQL, Advanced Excel, Visio and SharePoint.
  • Extensive experience with Bloomberg Trading System, Aladdin and Charles River Trading.
  • Experienced in CAMRA accounting system.
  • Good experience in handling security master rejects and uploading feeds into Camra accounting system.
  • Well experienced technical and resourceful Tableau Developer in analyzing data, creating and compelling visualizations to support business decision making. Possess strong training and presentation skills. 
  • Extensive experience working on Camra recon for security master reconciliation.
  • Extensive experience using SSIS and SSRS in generating financial data reports for accounting.
  • Experience with Bloomberg Data License & Terminal Services functions.
  • Strong in Bloomberg modules installation/configuration/administration/development/Analysis.
  • Assist with the Bloomberg AIM and Charles River Trading Inbound and Outbound feeds analysis.
  • Extensive experience in writing business requirement documents, user requirements, functional requirements, non - functional requirements, Current State, Future state flow charts, Solution option comparison and test case documentation.
  • Worked on various components of CADIS.
  • Complete redesign of FX Workflows on AIM to assist Front, Middle and Back Office functions.
  • Extensive training of trading systems training to all the portfolio managers, analysts, traders and IT.
  • Very strong skills in using Excel API tools for Bloomberg market and reference data.
  • Good Functional expertise on Trade Life Cycle of Equity, Fixed Income, FX and Cash.
  • Experience with Program Trading, Rebalance of Equity portfolios and assist with other portfolio management functions using Bloomberg.
  • Strong in metadata and data quality implementations.
  • Strong with Market Data management and vendor relationships.
  • Highly proficient in working in VBA macros for generating custom reports.
  • Extensive experience with SharePoint, Visio, Power Point, Microsoft Project and Microsoft Office tools.
  • High proficient with SQL against SQL Server, Sybase, Oracle and DB2 databases using tools like Toad, SQL Programmer and Rapid SQL.
  • Strong with data modelling, database management and stored procedures.
  • Strong with testing life cycle to include, systems testing, integration testing, user acceptance testing.
  • Strong in implementing and training data governance policies, procedures and roles (Stewards, owners, authoritative originators, custodians).
  • In-depth knowledge, support and training of the complete trade life cycle to the team and the business users.
  • Vast experience in disciplined requirements gathering and documentation using QUEST framework.

TECHNICAL SKILLS:

Variety of Programming, Databases, Networking, Utilities, Severs, Operating Systems, and Reporting Packages Vendor Software installation/Integration/Configuration/Upgrades/Support for Excel, MS Office products, Crystal Reports, Tableau, Informatica Power Center, Informatica Data Quality, ETL, Adobe Acrobat, MS Access database and reports, Relational Databases, Windows/UNIX/Web based operating systems, Java, .Net, FTP, TCP/IP,: MySQL, Wireshark, Adobe Photoshop, Adobe Premier Pro, Burp suite, MS word, MS Excel, MS Visio, MS Access, PHP Scripting, SQL, FIX, Autosys, HTML, Rapid SQL, Change/Incident Management tools, SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. Business Analyst

Responsibilities:
  • Worked on migration of Treasury transformation project from Bloomberg to BlackRock Aladdin.
  • Worked on Back office RFP on migrating Investment Accounting system from CAMRA to Eagle Accounting System.
  • Bloomberg Order Management framework: Comprehensive Order Management flows for all the asset classes.
  • Document business requirements, user requirements, functional requirements and non-functional requirements on Trading platform and data hub migration from Bloomberg to Aladdin suite.
  • Design and develop Custom Security Reference master.
  • Involved in daily XREF and RTNG Reject uploads from Aladdin to CAMRA Accounting system.
  • Involved in CAMRA operations for daily process.
  • Created new security master records for processing new security trades into CAMRA Accounting System from Blackrock Aladdin.
  • Involved in Clearing hold trade on daily basis and setup Security master attributes and clear the hold trade.
  • Created the current state and future state diagrams using Microsoft Visio.
  • Thorough knowledge on gathering requirements on insurance and separate accounts.
  • Requirements gathering across multiple functions and systems to include, accounting, performance and attribution, reporting, external clients, subadvisors
  • Bloomberg admin functions support: Account/Group setup, Broker codes/commission setup, Access/Privileges.
  • 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.
  • Created requirements for Transaction Cost analysis and automation on Bloomberg.
  • Bench marks, model’s setup and benchmarks uploads trading systems.
  • Bloomberg Fixed Income workflow setup, Data License configurations, Excel API and TSAPI (Trading system API) applications. Compliance engine rules configuration and setup
  • Experienced in TBA mortgage processing automation using Bloomberg AIM, for front, Middle and the back-office functions.
  • Manage data conversion stream of trading platform migration. Used Microsoft Project extensively.
  • Analyzed Dodd-Frank regulation impacts to the workflows and created the requirements.
  • Trade Life cycle automation using Bloomberg AIM, for front, Middle and the back-office functions.
  • Used HP ALM and JIRA tools to manage the project issues.
  • Used SharePoint to manage documentation.
  • Worked on complex SSRS reports for generating accounting audit reports.
  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard
  • FX workflow automation from front middle and back office using Bloomberg. FXConnect integration with Bloomberg OMS screens.
  • Configure Bloomberg data License security and pricing information.
  • Setup Data Governance policies, and metadata.
  • Eagle Pace Data Management & Reporting: External Transactions; OM integration, Security Masters, Prices, Positions, Trades (Best data rules; Inbound and Outbound; Positions Reconciliation, Trade Log reporting.
  • Projects & Support: Support Portfolio Order Management, Trading executions, Compliance, Matching Confirm/Affirm, Settlement Operations, Accounting, Investment Research, Performance & Analytics, Investment Reporting, Data Management, Investment Risk Management, Sub-Advisory Business, Mortgage Loan Management and Real Estate administration business functions.

Environment: Share Point, MS Project Server, Excel, CAMRA, Agile, MS Word, MS Access, HP Quality Center, UML, ETL, Informatica Power Center, Oracle 11G, SQL Server, MY SQL, Aladdin Blackrock, Eagle Pace, Eagle SRM, Bloomberg AIM, Bloomberg API, Bloomberg Data License, Eagle Pace, MS Office suite, MS Visio, UNIX, SQL, and OBIEE.

Confidential, North Carolina

Sr. Business Analyst/Data Analyst

Responsibilities:
  • Created swim lane process flow diagrams for Bloomberg AIM Order management system (Fixed Income) and Charles River Trading (Equity).
  • Gathered requirements by working with the portfolio managers, traders, investment operations, investment accounting users on trade life cycle
  • Used Bloomberg API and Bloomberg Data License server to gather securities data.
  • Supported Eagle Pace data management importers, exporters, events and stored procedures.
  • Worked on different components in CADIS.
  • Worked on various components with in Cadis such as data porter, data inspector, data constrictor and so on and so forth.
  • Scheduled different jobs in Cadis based on RSS for daily batch cycle.
  • Worked on data mapping to ease the data flow from Bloomberg AIM to Camra Accounting system
  • Used Bloomberg API to extract market data.
  • Participated in the Data Governance working group sessions to create policies.
  • Used SQL to analyze data on Oracle database.
  • Created Source to target mapping Documents, business rules, and workflows.
  • Designed excel Pivot tables and V-Lookup tables to analyze large data.
  • Impressive skills in project risk and quality management. 
  • Periodically record and retrieve the data to keep track of the project.
  • Aim to ensure that the product or service of an organization provided best fits the purpose and it is consistent and meets both external and internal requirements. 
  • Readiness in notifying the government via e-mail or telephone of all urgent issues, if any. 
  • Issue noti cation includes time constraints, and impacts, which will identify the urgency issues in the project. 
  • As a responsible quality assurance personnel is to my duty to ensure that the contractor quality control (CQC) system is functioning properly.

Environment: Eagle Systems, Data Governance, Informatica Data Quality, SQL, Share Point, MS Project, Excel, MS Word, HP Quality Center, Informatica Quality Center, SQL Server, Bloomberg AIM, Bloomberg API, Bloomberg Data License, MS Office suite, MS Visio, Java, C+, UNIX, SQL, and Qlikview.

Confidential

Business Analyst

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 Use Case diagrams in gathering requirements.
  • Well experienced technical and resourceful Tableau Developer in analyzing data and creating compelling visualizations to support business decision making. Possess strong training and presentation skills. 
  • Hands-on with creating solution driven views and dashboards by developing different chart types including Bar, Stacked Bar, Line, Dual-axes, Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop versions 8.0, 8.1, 8.2 and 10.3.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs.
  • Good knowledge in building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data. 
  • Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
  • Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
  • Experience in Requirement gathering data analysis and created Derived Columns to fulfill the User Requirements and created Parameters to reports be more User friendly to End Users.
  • Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
  • Established Best Practices for Enterprise Tableau Environment and published dashboards on Tableau public.
  • Possess a very good knowledge in MySQL.
  • Thorough knowledge in the construction of SQL queries to retrieve data.
  • Good understanding on how relational databases work.

Confidential

Business Analyst

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, current 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.
  • 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.
  • Created SQL queries to retrieve patient data in the future visits.
  • Creating UML diagrams like Use case diagrams, class Diagrams to represent detailed design phase.
  • Created and managed structured objects like tables, views, stored procedures, and triggers.
  • Normalization and De-Normalization of existing tables wherever needed, for faster query processing.
  • Create/Modify SQL Stored Procedures for the data loads.

Environment: Tableau, My SQL, Java, MongoDB, HTML, WordPress, Power Press, Magneto, MS Project 2013, MS Visio, SharePoint, Wireshark, MS Office (like MS Word, MS Excel, MS Power point, and Outlook).

We'd love your feedback!