SUMMARY:

• Technical Business Analyst & Support professional with capital markets experience .
• Skilled in providing application support to various trading groups including traders, front office, middle office back office, risk, finance and operation teams. Experienced data analysis professional with a technical mindset.

TECHNICAL PROFICIENCIES:

Programming: VBS, Excel VBA, WSH, Unix Bash, SQL, Java

Operating Systems: Sun Solaris, RedHat

Database: Oracle, MS SQL, Sybase ASE & IQ

ETL: Autosys, Ab Initio ETL

Financial Technology: Order Management Systems, Electronic Trading, Bloomberg, data feeds, Tradeweb, Intex, RMDS, Market Data, Reference Data, Balance Sheet systems.

Confidential, Charlotte, NC

Technical Business Analyst

• Manage requests from upstream, downstream and data lineage teams. The requests typically involved working with database tables(Oracle, SQL server), evaluation of stored procedures logic(PL - SQL) & application source code (Java) and log analysis(Unix servers) .
• Partner with Corporate Treasure Governance and Transaction Management teams to work on business requirement clarifications and upcoming initiatives to identify development efforts and prioritization
• Prepare deliverables and contribute at audit meetings with internal compliance teams and external auditors (E&Y) to meet the application’s SOX requirements.
• Coordinate the scheduling of server patches, infrastructure updates for database & platforms
• Manage monthly and off-cycle release and validation in an Agile development environment
• Partial list of other projects include GRRP adoption, Str Confidential ht through revocation, Kansas City data center exits
• SDLC activities involved managing stories in VersionOne, daily standups for BASIS & IBSR teams, finalize release scope in QzRelease, send out release notes to line of business and release instructions to deployment teams.

Confidential, Stamford, CT

Technical Analyst

• Technical BA for Centralized Pricing suite.
• Working with business managers, developer and trading desk support developers. Common issues requiring analysis were related to market movements, incorrect auto quotes, trade latency, settlements, butterfly & curve trade issues, pricing tiers and driver spreads.
• Liaisoned with 80 Traders across Confidential. The application is built as a high availability real-time pricing and electronic trading platform. Troubleshooting issues involved analyzing price feeds from Tradeweb, pricing engines, BBG-ALLQ, YAS calculators. Confidential ributes like yields, spreads, skew, radius, tolerances were used to troubleshoot most pricing issues reported by the rates trading desk.
• Rates application support duties included treasury rolls where I lead extensive support during non-farm payroll and CPI announcements, security setups, ECN mapping for trader setups, application changes and releases.
• Maintained trader spreadsheets with use of VBA, BBG(blp) API, Centralized Pricing add-ins & quantlib libraries.

Confidential, Charlotte, NC

Trade Support Analyst

• Data Sourcing provides post-trade data to all entities of Confidential . Interacted with most teams of WFS namely, MO of various desks including Equities, Compliance, Market Risk, London MOs, Collateral management, Funding, Finance & Operations.
• Application involved analysis of Java code, Perl scripts, Sybase stored procedures and Ab Initio graphs.
• Business Analyst for front & middle office trading floor applications and technical support to Fixed Income trading desks.
• Resolved day-to-day front office issues related to trade issues - actively worked with traders on problems like stale risks due to delayed position updates, regulatory reporting delays to TRACE/MSRB.
• Trade capture - resolved breaks between external systems like Bloomberg, BrokerTec,ESpeed,ION
• Static data - customer, inventory & customer/trader/sales mapping issues on external systems
• Reference data - maintained up to date information in the security master related to maturity dates, coupon, factors, resolved breaks between security master and external systems
• Trade matching - resolved unmatched trades on Omgeo/OASYS, issues with trade allocations.
• P&L breaks - due to missed or late trades, incorrect price capture, missing marks
• ECN connectivity - represented trading technology on bridge line calls when ECN connectivity is down.
• Performed troubleshooting the technical aspects of issues by analyzing SQL stored procedures, Java/Perl code, UNIX logs, Ab Initio graphs, Autosys, etc.
• Ensure integrity of data in security master, pricing and back office information sourcing systems.
• Knowledge of order management systems for sales & trading, trading infrastructure, risk management, P&L, security master, pricing systems, market, information sourcing.
• Knowledge of Intex, Bloomberg API, Reuters EJV, market data and reference data feeds
• Automated redundant tasks like report generations and system checks using VBA/VBScript/Unix Shell/Sybase SQL
• Performed production support activities for application releases and maintenance.
• Led the coordination of disaster recovery tests for tier1 applications like the fixed income trading system and reference data infrastructure.

Confidential, Los Angeles, CA

Technical Systems Analyst

• Tested & certified the application performance before handing over environments to QA, UAT.
• Tested Web Services, Database & Citrix applications. Monitored servers, fileshares, application logs for errors using monitoring tools like Ganglia, Perfmon, Hyperic.
• Created automated load creation scripts using VBScript for Performance testing.
• Organized calls with Developers, System Admins, Application Admins, DBAs to troubleshoot environment issues related to application performance issues.
• Used TOAD/SQL to analyze DB, event log tables.
• Performance tested web & web-services protocol using Loadrunner, Performance center.

Confidential, Newark, DE

Automation Developer

• Performed end-to-end testing of the application. This involved testing & verification of back-end tables, web services, data feeds/XML, front end applications, mainframe(TSYS).
• Created “quick scripts” for QA team to reduce manual tasks during tight QA schedules.
• Tools used: Quality Center, QTP/BPT, Toad, XML Spy, Loadrunner, Performance Center.
• Developed Excel Macros, QTP automation scripts/ VBA Scripts, Loadrunner VUGen scripts to automate the testing process.

Confidential

Technical Server Analyst

• Built the test environment - ORACLE CollabSuite, ORACLE Application Server, ORACLE Database Server installation on various Windows & UNIX system configurations
• Designed & implemented functional test libraries in VBScript/WSH to enhance the functional & reporting abilities of the test automation framework
• Automated functional testing using QTP & was a SME for scripts development, automation
• Troubleshoot support tickets by replicating customer configuration & investigate server side issues
• Implementation of automated solutions using a C++ based in-house Oracle tool for performance testing

Confidential

Automation/Scripting Developer

• Designed a VBA/QTP-driven automated test framework for governance modules in Axentis Enterprise
• Integrated Excel test scripts with Quality Center using QC Open Test architecture. This helped the team use a single QC license to record & perform tests and effectively use the limited availability of QC/QTP licenses