Business Analyst /Project Manager Resume

SUMMARY

Dedicated IT business analyst/project manager with extensive experience in fixed income securities, risk management, technical specs, and application development.
Effective communicator with proven aptitude for relationships building with professionals across industries and levels of seniority.
Detail - orientated analyst with a talent for problem solving, debugging, and recommending fixes within applications in a quick and effective manner.
Strong technical background in developing SQL queries to research, analyze and troubleshoot data and to create business reports. Hands-on experience with MS BI stack.

AREAS OF EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst /Project Manager

Responsibilities:

Interview with company leaders from multiple areas to gather and understand requirements.
Translate stakeholder requirements into functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
Direct team members on building a GUI application for users to insert/update/delete data into database.
Organize scrum meetings to trace progress and report status to relevant parties.
Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify deliverable meets user expectations.
Build various numerical reports for tracing profit, cost, amongst others with SSRS and MDX queries
Design and implement ETL process, archive process, etc., with SSIS
Generate lab environment related reports and ad-hoc reports using SQL.

Confidential

Assistant Vice President

Responsibilities:

Covered 50% of total company risk. Obtained requirements from traders to form framework to build SQL templates and job scheduler.
Analyzed risk value to make query modification via MDX for correct results. Developed various risk and regulatory reports including Volcker/PAA via Excel using Macros, pivot tables, VLOOKUP, index, match, cell formulas, and add-in function calls.
Enhanced Simpliciti reporting system for generating compliance reports by debugging and modifying stored procedures and python scripts.
Saved about 10% of analysis and development time by importing/exporting data from global data centers.
Established new functionalities (i.e. allowed users to mark spread curves over OIS, Fed Fund, etc., curves) to make application more flexible and easy to use. Designed GUI, defined user entitlements, analyzed legacy system functions by reviewing programing code and DB tables, and documented results for BRD and FRD.
Created test scenarios to perform unit testing, integration testing, and reports recon.
Wrote user guides for several GUI screens. Provided support and walked through functionalities with US and AP traders until obtained traders’ sign-off for production release.
Recommended application design and sprint task generation.
Utilized new curve to calculate risk in Excel. Collaborated with quant analyst to address issues. Documented process to provide reference to LN development team. Created Runbook and coordinated release with LN development team.