SUMMARY:

• In - depth understanding and extensive experience in Software Development Life Cycle (SDLC) in conjunction with Project Management activities including planning, scheduling, activities prioritization, risks management, tracking and reporting. Effective collaborator with all levels of management/business/IT stakeholders.
• Broad hands-on experience in applications and processes re-engineering in Front, Middle and Back Office environments utilizing Waterfall, Rational, and Agile software delivery methodologies. Knowledgeable in variety of project artifacts like Roadmap, Vision, Business Case, Project Plan, Scope, WBS, RACI and Traceability Matrixes, Business and User Requirements, Functional Requirements and Technical Specifications, Use Cases, Statement of Work, Service Level Agreements, Remediation and Test Plans, Acceptance and Rollout/Implementation Plans. Proficient in creating UML diagrams like Use Case diagrams, State, Transition, Dataflow, Activity, Sequence, Workflow, Process flow and Deployment Diagrams.
• Team player dedicated to meeting deadlines, strong negotiator, when needed, always committed to on-time on-budget deliverables.

TECHNICAL SKILLS:

MS Office: (World, Excel, PowerPoint, Project, Visio, Access), SQL, Toad, SharePoint, JIRA, 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.

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Business Analyst

Responsibilities:

• Prioritize and plan with senior management projects in Client Onboarding (COB) and Know Your Client (KYC) space with focus on handling client data. Track status and turnaround times of deliverables.
• Prepare problem definition, use cases and requirements documentation. Generate functional and technical specifications for the solution of business problems. Organize testing efforts, develop test cases and test plans, supervise QAT and conduct UAT. Review and validate production changes.
• Partner with COB Team to ensure account opening documents collected, verified, cross-checked and properly stored. Partner with Accounts Control team to ensure KYC reviews performed according to Client Review Calendar. Monitor review and approval processes of new clients as well as re- process for existing clients.

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

Confidential, NYC

Business Analyst

• Involved in in Data Quality and Data Sourcing projects related to Bank Regulatory Reporting for Confidential . Participated in Y9C Schedule HI reporting data reconciliation, adjustments generation and posting. Performed root cause analysis of BRR exceptions, identified data sourcing gaps and processing breaks. Collaborated with CCAR, Basel III, and Product Control Teams on DQ issues resolutions. Coordinated IT systems enhancements and business processes improvements. Performed UAT and production implementation verifications.
• Engaged in execution of strategic initiatives in Data Quality space aligned with DB USA Intermediate Holding Company launch activities. Reviewed and analyzed current data and processing states to determine regulatory data deficiencies. Performed data flow analysis to establish reporting data lineage and reg data golden sources within the bank. Facilitated DQ solutions development and deployment of redesigned 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 data cleansing rules and remediation timelines. Created and maintained project artifacts and various Trackers. Collected, reviewed and cataloged data sourcing documentation. Analyzed DQ issues to determine themes, trends, categories and presented results for review and prioritization by Data Council.

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

Confidential, NYC

Project Manager

• Managed Client Data Remediation project. Collaborated with Legal and Compliance to develop Client On-Boarding guidelines, rules 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. Facilitated stakeholders buy-in, ensured appropriate scoping and requirements traceability. Developed and maintained project documentation. Tracked and reported defects inventory and remediation progress.

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

Confidential, NYC

Project Manager BA

• Defined projects scopes and milestones with business, technology, and vendor partners. Reviewed, documented, tracked and reported projects progress. Managed schedules, identified and mitigated conflicts and risks. Implemented PMO defined processes and procedures to insure compliance with SDLC project delivery methodology.
• Provided Bond Desk support functions and was primary point of contact for business users to assist them in being more productive and successful in their business activities. Managed Change Requests and new development requests. Built and maintained client relationships with software vendors to ensure service levels are met. Investigated and resolved business concerns and issues. Gathered, analyzed and validated business requirements for processing improvements and bug fixes. Scoped and prioritized release contents with business and IT stakeholders. Created Business and Functional Requirements documentation. Maintained RACI and Traceability Matrixes. Created Testing, Acceptance, and Production Deployments Plans. Managed software releases. Updated PMO Best practices and lessons learned.
• Collaborated with CCAR/Basel team in Capital Markets data mining and evaluation. Created BRD/FRD for daily data extracts creation. Oversaw data feeds implementation, performed daily data reconciliation reviews. Participated in CCAR/Stress Test dry runs. Lead system integration analysis and requirements gathering with business, compliance and technical stakeholders for cross company regulatory projects (Reg W, Reg S, Reg M). Created data sourcing requirements. Developed set of financial reports, metrics, dashboards that enabled senior management to examine 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.
• Supported cross company reference data projects. Modified existing and created new work and data flows for issuers and investors to comply with Legal Entity, AML and KYC data requirements. Performed data gap analysis, developed new data mappings, created data dictionaries, participated in old data cleansing, scrubbing, validation, and enrichment before migration to new processing platforms.

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

Confidential, NYC

Sr. Business Analyst / Product Master

• 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, NYC

Business Analyst

• 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, NYC

Systems Analyst / Product Control

• 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 ad-hoc 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, NYC

Project Manager BA

• 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 / Financial Statements

• Was responsible for daily transactions collection, interest, dividends, gain, loss calculations, 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.