SUMMARY:

• In - depth understanding of Software Development Life Cycle (SDLC) and extensive experience in designing, implementing and supporting IT solutions processing Equities, Fixed Income, Client, Account, and Transaction data.
• Hands-on experience in applications and processes re-engineering in Front, Middle and Back Office environments utilizing Waterfall and Agile software delivery methodologies.
• Developed and maintained various project management documents (PIDs, Statements of Work, Roadmaps, Scope Statements, Project Plans, WBSs, Milestones and Project Trackers). Knowledgeable in variety of business and data analysis artifacts (BRDs, FRDs, DRDs, Requirements Traceability, Process/Data flow diagrams, System State diagrams, GAP Analysis, Data models, Data dictionaries, Interface agreements, Use Cases, SLAs).
• User friendly team player dedicated to meeting deadlines while remaining within scope, time and budget constraints.

TECHNICAL SKILLS

Comapping, Eclipse UML, Business Objects Reports: HP Quality Center, SDLC+ Workbench

Omgeo Alert, iMeta Assassin, Polar Lake RDD: Asset Control, Bloomberg, Reuters, Informatica MDM

iPreo, IssueNet, iSynd, IssueBook, i,Deal Debt, Symphony: Storm Bond, MicroStrategy, Datamer, Axiom, FDW, CRDS Web.

PROFESSIONAL EXPERIENCE

Confidential

JC Business Analyst

Responsibilities:

As a Senior BA in EDM Referential Data Management Office (RMO), focus on legal entity data quality issues, counterparties regulatory reporting classifications and risk ratings.

Participate in generation of Y9C adjustments due to data quality breaks. Perform cross systems counterparties data reconciliations and reg reports residual risks calculations.

Responsible for establishing RMO Analytics framework to determine bottlenecks in data quality assessments and remediations of outstanding issues. Manage RMO Scorecard, custom excel dashboard showing team activities and results.

Review and analyze Key Data Elements lineage and ownership. Verify data touch points and operational controls. Coordinate Data Scrub analysis reviews with business teams and resulting adjustments and remediations.

Tech environment: MS Excel, Power Point, Visio, Project, OFSAA, SQL Developer, Data Miner, CRDS Web, HP ALM.

Confidential

Client Reference Data

Project Manager, Business Analyst, and Data Analyst duties varied from project to project and were often performed simultaneously.

Managed projects in Client Onboarding (COB) and Know Your Client (KYC) spaces with focus on client data quality and compliance with industry regulations. Maintained project artifacts, Data Governance policies and procedures.

Prepared problem definitions, use cases, requirements, and data specifications for sourcing, cleansing, and enrichment of client referential data. Responsible for establishing end-to-end data flows and attributes synchronization from Ops on-boarding templates through IT data models to reports generation. Managed QA, UAT, and systems regression testing.

Partnered with COB Ops to ensure account opening documents collected, verified, cross-checked and properly stored. Partnered with Accounts Control team to review KYC approval and risk assessment procedures for new and existing clients. Performed quarterly Client Due Diligence reviews.

Tech environment: MS Office (Excel, Visio, Power Point), MS Project, SharePoint, Jira, LexisNexis, KYC Utilities.

Confidential 

Business Analyst

As a BA in DB Chief Data Office (CDO), participated in Data Quality and Data Sourcing projects related to IHC launch and US Regulatory Reporting for IHC.

Reviewed and analyzed FBO data and processing states to determine US regulatory deficiencies. Performed data flow analysis to establish reporting data lineage and golden sources within the bank. Facilitated DQ solutions development and deployment of newly designed data/work flows to meet FED and ECB reporting requirements.

Participated in Business Engagement Forums to determine approach and scope of data remediation. Worked with stakeholders to agree on DQ rules and remediation timelines. Analyzed DQ issues to determine themes, trends and categories. Created custom dashboards and Power Point presentations for review and prioritization by Data Councils.

Performed Y9C Report Schedule HI data reconciliation, adjustments generation and posting. Performed root cause analysis of BRR exceptions, identified data sourcing gaps and processing breaks. Collaborated with CCAR, Basel, and Product Control Teams to determine DQ issues resolutions. Review QA results, performed UAT and production implementation verifications.

Tech environment: MS Office (Excel, Visio, Power Point), MS Project, SharePoint, CODA, Jira, Datamer, FDW, Axiom.

Confidential

Project Manager

Managed Client Data Remediation project. Collaborated with Legal and Compliance to develop Client On-Boarding rules, processes, and templates. Reviewed and verified Know Your Client key operating procedures to ensure complete and verifiable client data as to legal entities, company principals and beneficiaries. Designed and implemented Customer Review Calendar. Facilitated Paper to Cloud initiative to digitalize client data.

Performed current state analysis of Legal Entity data. Identified data gaps, procedural breaks, inefficiencies and recommended solutions. Converted COB templates and checklists into data models. Developed and maintained projects documentation. Created and maintained defects inventory for tracking of remediation progress.

Tech environment: MS Office (Excel, Visio, Power Point), MS Project, SharePoint, Jira, LexisNexis, KYC Utilities.

Confidential

JC Business Analyst

Responsibilities:As a member of Confidential team supported origination, syndication, and sales of Investment Grade and High Yield bond issues. Project Manager and Business Analyst responsibilities varied depending on projects.

• Provided Bond Desk support functions and was primary point of contact for business users. Managed Change Request process for defects and new functionalities development. Gathered, analyzed and validated business requirements for processing improvements and bug fixes. Scoped and prioritized release contents with business, IT and vendors. Created Business and Functional Requirements documentation. Managed schedules, identified and mitigated conflicts and risks. Implemented PMO defined processes and procedures to insure compliance with SDLC project delivery methodology.

Developed custom financial reports and dashboards to enable review of orders, allocations, revenues, PnL and determine potential risk and compliance issues. Designed and implemented reporting framework to ensure compliance with US, HK and Canadian market regulators. Lead system integration analysis and requirements gathering for cross company regulatory and compliance projects.

Collaborated with CCAR and Basel teams in Confidential data mining and evaluation. Created data sourcing requirements and managed data feeds implementation. Performed daily data reconciliation reviews. Participated in Stress Test runs.

Supported cross company strategic reference data projects. Performed gap analysis, developed new data mappings, created data dictionaries, participated in old data cleansing and enrichment before migration to new processing platforms for Legal Entities, Sales Persons and Issuers.

Tech environment: iPreo IssueNet, iDeal Debt, iSynd Book, Symphony, Storm Bond, Bloomberg, MS Office, Visio, Project, SQL, Toad, SharePoint, Quality Center, MicroStrategy.

Confidential

Business Analyst / Product Master

As a member of Project Management Office team was involved in initial phase of Enterprise Product Master project, strategic initiative to create product reference data platform for Middle Office operations.

Conducted interviews with diverse group of stakeholders and SMEs to discover, investigate and document inefficient, duplicate and redundant processes. Performed root cause analysis of trade processing breaks caused by bad/missing securities reference data. Developed solutions to minimize manual intervention and increase trades STP rates.

Performed current/future state analysis for securities risk classification to insure proper data feeds into Risk Systems. Developed data sourcing requirements to enable across enterprise risk aggregation for each security. Modified existing data models to include additional data attributes/indicators required for DFA/Basel reporting.

Reviewed market data feeds current state to determine data quality, availability and costs. Performed Impact and Gap analysis based on new/modified workflows and dataflows. Developed EPM business case, Roadmap and Milestones. Performed buy vs build analysis. Participated in transition to EPM vendor’s solution.

Tech environment: MS Office, Visio, Project, SharePoint, Comapping, Bloomberg, Reuters, Informatica MDM.

Confidential

Business Analyst / Client Reference Data

As a member of Front Office Client Technology Solutions team participated in design, development, and production deployment of Reference Data Hub, CS strategic solution for golden source of client reference data. Responsible for Standing Settlement Instructions component with first rollout of US Equity SSIs, followed by US Fixed Income SSIs and Global FX SSIs rollouts.

Gathered, analyzed and evaluated stakeholder’s needs, wants, and must-haves to create clear and concise business requirements. Analyzed old mainframe programs to distil current system functionalities. Performed legacy data gap and quality analysis. Documented As-Is and To-Be processing states. Performed functional gap analysis to determined variances between business requirements, systems current state and vendor systems capabilities to reconcile business requirements and IT deliverables.

Developed and run SQL queries to analyze data quality and completeness, performed data cleansing and scrubbing. Developed cross systems data mappings, transformation and enrichment rules for SSI data conversion and migration. Coordinated development of various data feeds into the Hub. Analyzed and documented downstream interfaces and interdependencies to ensure downstream systems data integrity and uninterrupted STP processes.

Worked on adoption of EMEA/APAC Equity and Fixed Income SSIs into the Hub. Conducted interviews, moderated focus groups, and facilitated workshops with geographically dispersed stakeholders to discover and distill business needs into requirements. Negotiated with Business, Strategic Change and IT stakeholders on project scope, acceptance criteria and deliverables. Evaluated requirements to determine must vs nice haves. Identified and documented project risks to perform qualitative and quantitative analysis and planed risk responses. Created and maintained project artifacts (traceability matrix, scope baseline, work breakdown structure, risk register).

Provided SME support to SSI BAU. Compiled, analyzed, and established SSI Golden Copy rules for generation of Equities, Fixed Income, and FX SSIs. Designed and implemented data flow framework to ensure compliance with FED, SWIFT, and ISO standards and regulations.

Tech environment: Omgeo Alert, iMeta Assassin, Asset Control, MS Office, Visio, Project, UML, Rapid SQL, BO Reports.

Confidential

Systems Analyst

As a member of Fidelity Institutional Products Group supported Trading P&L system.Responsible for Realized and Unrealized P&L generation for Intra Company and Prime Broker accounts. Collected, documented, and analyzed requirements for new trading products, SEC and FINRA regulations. Developed and run SQL queries to create data dumps and custom financial reports. Participated in daily account balances, positions, and P&L reconciliation activities.

Enhanced TPL system with Equities Cost to Carry functionality. Identified, analyzed and designed processes for CTC rates calculation by Symbol, Cusip, ISIN. Managed CTC enhancement development, testing and production release.

Converted overnight batch TPL processing into Intraday TPL system. Reviewed and analyzed current and future processing requirements. Participated in logical and physical data model designs. Developed and run SQL queries to discover data availability and establish data quality. Determined data mappings, validation rules and sourcing requirements to insure intraday P&L functionality feasibility. Designed and managed implementation of interfaces between new ITPL system and Margin, Securities Lending, and Risk Management applications based on intraday updates to accounts balances and positions.

From start to end managed Equities Real Time Pricing (RTP) project. Conducted research on pricing data availability, performed cost-benefit analysis for real and delayed pricing methods. Coordinated Bloomberg, Thompson and internal Product Master data feeds integration to allow P&L calculations based on different pricing sources. Developed and executed SQL queries to retrieve pricing data for analysis, review, and verification.

Participated in International ITPL project. Gathered and analyzed business practices and workflows for FX and Non-US FI trading by Prime Broker clients to document current and future P&L processing models. Managed integration of FX P&L functionality into ITPL system.

Produced data dumps and financial reports for internal risk and product control teams. Participated in daily balances and positions P&L reconciliation activities. Generated FINRA monthly regulatory reports.

Created Disaster Recovery guidelines, plans and procedures for intraday and overnight TPL system failures.

Tech environment: Bloomberg, Reuters, MS Office, Visio, Oracle, DB2, SQL, CICS, MQ, XML.

Confidential

JC Business Analyst

Responsibilities:As Project Manager was responsible for integration of Trade Signals and Trade Execution systems into one Technical Analysis Trading System (TATS). Managed requirements gathering, analysis and translation into specifications. Developed and maintained Project Plan and various project artifacts. Directed project team through development, testing, user acceptance, and production rollout. Supervised subsequent incremental TATS software releases.

As Business Analyst conducted and negotiated requirements for TATS modifications. Created use cases, sequence and workflow diagrams, business requirements and functional specifications. Created and run SQL queries for test data extracts and loads. Performed TATS trading strategies back testing and historic results verification.

Tech environment: MS Office, Access, SQL, Bloomberg, TradeStation.

Confidential

JC Programmer Data Analyst 

Was responsible for daily transactions collection for interest, dividends, gain, loss calculations, and account balances and positions generation. Served as SME for validation of transactions processing and accounts data reconciliation between General Ledger and Statements applications.

Managed Multi-Currency Financial Statement project. Integrated USD and Non-USD processing for Equities and Fixed Income products into one streamlined process. Designed and developed Base Currency functionality to calculate and display multi-currency data in singular base currency format selected by client.

Involved in full software development life cycle of One Financial Statement project to combine domestic and international statements. Developed USD equivalent data generation functionality for Non-USD denominated securities.

From start to end participated in all SDLC phases of Y2K project.

Participated in EURO Conversion project. Performed Fixed Income processing modifications to address sovereign currencies replacement and changes in interest/dividend/coupon calculations for products denominated in legacy European currencies.

Performed post 9/11 full system disaster recovery. Restored and reloaded trade and reference data. Reinstalled applications software. Rerun missing daily transactions postings. Reconciled client accounts balances and positions.

Tech environment: MS Office, Cobol-II, JCL, VSAM, CICS, MQ, DB2, SQL, AFP.

Confidential

Sr. Programmer / Retail Banking

Provided 24/7 on-call production support for transactions processing, interest calculations, and General Ledger financial postings for Time Investment Products (Savings and CDs). Modified TIP software to fix defects and implement processing enhancements. Analyzed posting systems performance and storage utilization to develop and deploy critical path improvement solutions.

Performed installation and deployment of Early Warning business intelligence reporting platform for newly opened credit card accounts. Designed and developed customized integration interfaces for filtering and formatting various data feeds into vendor’s software package.

Tech environment: MS Office, Cobol-II, JCL, VSAM, CICS, DB2, SQL, File-Aid, Xpeditor.

Confidential

NJ Programmer Analyst / Settlements

Participated in Interactive Institutional Delivery System project to replace T+5 batch software with online T+3 processing to meet new settlement cycle regulations. Developed online programs/screens to facilitate intraday trade confirmation and affirmation data flows. Designed, developed and installed intra-day FTP data transfers between PW and DTCC. Created SQL queries to select data for end-of-day summary reports.Tech environment: MS Office, Cobol-II, VSAM, CICS, DB2.

Confidential

NJ Programmer / Paid Eligibility System

Modified Paid Eligibility system software to process various insurance claims utilizing new Cobol II/CICS platform.

Converted old Cobol programs into new Cobol II batch and CICS online modules. Performed legacy data migration.

Tech environment: Cobol, Cobol-II, JCL, VSAM, CICS.

Confidential

St. Petersburg Russia Software Engineer

Involved in development, testing, implementation and production support of Global Information System, predecessor to current GPS systems.

Tech environment: FORTRAN, PL1, IMS.