Senior Business Analyst Resume

SUMMARY

I provide solutions. My goal is to flatten and re - aggregate your metadata into consumable data objects. I am motivated by finding creative solutions to the challenges that data presents in its raw form. I add value by learning your dataset, mastering your Business Intelligence toolbox then contributing a piece of the solution to the larger deliverable.

PROFESSIONAL EXPERIENCE

Senior Business Analyst

Confidential

Responsibilities:

Created automated SQL*Plus/Bash based ‘Suspect Data’ tool that targeted errors in historical and daily data loads. This implementation decreased historical errors by 30% and gave users more confidence in the quality of available data sets.
Approached legacy query rewrites by researching archival documentation, updating logic using advanced SQL functions (partition, over, row number, avg, sum), utilizing Toad DataPoint’s ‘Compare’ tool to establish equivalency then applying Oracle’s ‘Explain Plan’ tool to verify optimal query execution.
Supported the US Treasury's inaugural Floating Rate Note issuance by creating test xml scripts, delivering test data to Broadridge for processing, and working with downstream system stakeholders to test data flow.
Explored the quality of data stores through analysis of reference, quote, and trade data from Fixed Income data vendors such as eMBS.com, Bloomberg, Reuters and TradeWeb.
Queried Bloomberg’s Data Point function to test reference data accuracy across comparable data providers.

Senior Data Analyst

Confidential, New York, NY

Responsibilities:

Responsible for the design and development of reporting solutions to provide performance reporting for the Confidential firm wide sourcing group.
Prepared financial reference data from vendors by sourcing SAP Business Objects XI and cleansing, transforming and loading the data into the datamart through a structured ETL process involving MS Access and Oracle SQL.
Designed queries to export raw vendor data from Business Objects XI to create pivot tables, vLookups, and graphics to report on spend vs. save initiatives.

Senior Business Analyst

Confidential, Pittsburgh, PA

Responsibilities:

Initiated system development plans by building working groups to access business need of future system implementations otherwise recommending alternative applications where necessary.
Accountable for eliciting requirements from users and producing use case scenarios and functional requirement documentation to ensure that requirements were accurately specified, communicated and understood by the technical implementation team.
Identified and managed project risk by creating an open forum where both developers and business users could equally participate in the continuous improvement of fixed income trading and portfolio management technology.

Senior Business Analyst

Confidential, Baltimore, MD

Responsibilities:

Created, executed and managed regression test plans for the implementation of Charles River IMS v9 upgrade.
Participated in bug review meetings with software developers, QA engineers, managers and suggested enhancements to the existing application from business perspectives and also provided solutions to existing bugs.