SABINA SHNAIDMAN

** ****** ***, ****** ******, NY 10314

917-***-****

adyzct@r.postjobfree.com

Overview

Technical Experience

Length

Business Experience

Length

Oracle (7-12g)

** *****

Banking

20 Years

Data Warehousing

15 Years

Finance

13 Years

Data Modeling

16 Years

Business Analysis

18 Years

Sybase

7 Years

Data Analysis

18 Years

Erwin

10 years

Use Case modeling

15 Years

RM Cobol, Pro* Cobol

10 Years

User Requirements Gathering

20 Years

Unix (AIX, Solaris, HP/UX)

15 Years

Requirements Elicitation

20 Years

C/Pro*C/C++

10 years

Business Objects tools

12 Years

Java

2 years

SharePoint

8 years

SQL (TOAD, SQL developer, SQL Server, DBeaver)

20 Years

MS Project

8 years

ORBUS (TOGAF) modeling

5 years

Xcelsius

2 years

SDLC/Agile (VersionOne, JIRA)

7 years

Summary

Over 25 years’ proven track record of leading digital transformation, driving major business benefits and cost savings. Defined the optimal technology program portfolio for the firm’s 2-billion-year technology spend through Portfolio Management and Technology Strategic planning. Lead re-imagining engagements for Alternative Investments, Corporate Actions, Payments, Billing, Client Onboarding with a collective cost-savings and revenue generation of over $80 million. Lead process review board with process owners defining opportunities for automation, consolidation and alignment to common services within and across processes. Build Proof of Concept (POC) business models for data engineering, architecture team and business operations. Strong areas of knowledge in banking are Securities and Pricing Masters, Derivative Master, Corporate Actions, Client and Account Onboarding, Billing, Invoicing, Regulatory and Compliance and good knowledge in order management, trading and settlement.

Experience

Bank of NY, Mellon and Pershing (BNYM) March 2018 – Present

Principal Enterprise Architect

Delivered CIO approved enterprise target states and road maps across all major business units

Projected $65MM for consolidation, reduction and integration of corporate actions with short term $15 million cost savings.

Lead application rationalization effort for 4K applications as part of Permission to Build, a part of Architecture Review Board.

Lead Process Review Board with process owners to quickly execute quick hit improvements in alignment with strategic areas for portfolio shaping.

Built interim and current state architecture models for Middle Office, Asset Services, Global Markets and Corporate Services Line of Businesses (LOBs) and their corresponding sub-LOBs, a foundation for multi-year roadmap. As a result, senior management and LOB owners have transparency to capabilities and services that they provide and opportunities to align to 40 common services and address areas of maturity across LOBs.

Built target state model to consolidate Corporate Actions across 4 LOBs: Fund Accounting, Pershing, Middle Office and Custody with confirmed savings of $15MM and potential $65MM cost savings over three years.

Responsible for application rationalization across all active applications (4K+) including new vendor applications comparatives with system architects, domain architects and application owners to minimize redundancy across the firm.

Lead member of Process Review Board - supported operations team from technology SME perspective to actively review each process with process owners and identify areas of automation within and across processes, define opportunities to align to shared services and re-orchestrate controls to minimize risk and redundancies. As a result of completing first 50 processes, engineering team is executing on smaller deliverables for this year and application owners have a roadmap for their strategic plan to divest, maintain or invest.

Revised Alternative Investment Services current and target models with business and operations to align onboarding and other common services to standard BNYM Model.

Business Architect owner for Corporate Services, a member of Architecture Review Board for Permission-To-Build Reviews.

Built and maintained TOGAF models for architecture in Orbus (iServer product for architects), POCs in SQL Server Studio, Oracle via API interfaces, with visuals in PowerBI and ThoughtSpot.

Coordinated and facilitated reimagining engagements using Design Thinking Workshop methodology for Regulatory Reporting, Billing, Onboarding with product managers, sales, operations and technology SMEs across related LOBs to define conceptual target state on the enterprise level from people/process/technology perspective. This included current and target state models, operational model (SDD-Service Delivery Diagrams), RACI, business outcomes, maturity model and a roadmap.

Worked closely with the business and technology to define and maintain business capability model.

Automated business capability attestation with application owners to capture decomposition of their applications from both, business and infrastructure support perspectives.

Mapped business capabilities to shared services, technology products and applications, as part of a bigger initiative to understand alignment and usage across the firm and identify opportunities to reduce redundancies and define ownership for portfolio shaping.

Acted as a project manager to provide transparency into business operations across the firm. This included capturing and mapping manual processes, standard operating procedures, resources and roles, locations, business processes, supporting applications and alignment to business capabilities. Developed and built data sets and mapping in DBeaver (Oracle equivalent) analytics platform with ThoughtSpot for Business Operations KPIs. As a result, this triggered a process review board to minimize manual activities across the firm including price arbitration with clients, relocation of resources, and provide transparency to CIOs for areas of automation.

Trained over 1000 people in a structured training environment on Business Architecture and design-thinking based Digital Transformation.

Deutsche Bank February 2015-February 2018

Sr. Business Analyst

Technology: Oracle/ SQL Developer/ MS Project, SharePoint, JIRA

Client and Account Reference Data group responsible for Volcker regulatory deliverable and integrations with Fidessa

Instances. Migration of 5 downstream systems included: remediation of Client and Account Enterprise data, KYC review and approval process, enrichment with business unit specific requirements for departmental data and delivery to common distribution platform by Volcker mandate.

Delivered BRD/FRD for each system integration by interviewing downstream systems, operation teams responsible for KYC, enterprise and legacy platforms, middle office and Fidessa SMEs

Developed 3-4 system recons for each integration to represent settlement accounts and corresponding client linkages to be in-sync prior to client migration

Analyzed and managed remediation cycles with operations between Enterprise and Legacy gaps identified by the system recons

Automated evaluation of mandatory attributes for client migration for ease of approval by business owners

Reported daily progress, risks, issues to management and stake holders

Commissioned into Quorum from legacy OMS-3 regions, Sales Trader, Global Booking and Allocation static client reference data

On May 2017 promoted to lead position of the Americas Operations and oversee the team of 5 to support both, client and instrument reference data.

Citi Group August 2011 – January 2015

Sr. Business Analyst

Technology: Oracle/ SQL Developer, AbInitio, Java, MS Project, SharePoint, JIRA

Information Securities Group is responsible to source from multiple vendors’ financial reference data to support over 100 Citi applications and multiple organizations in their trading and investment decisions. Financial data is sourced from over 40 vendors and based on subject matter expertise is consolidated into one enriched security master (SMC golden copy of indicative, pricing and account master data.

Delivered complex reference data solution to Sec Landing and Prime Broker system (PRIME) that supports 40 downstream systems including trade ordering systems, settlement and trade systems, Broadridge, FINRA and P&L reporting. Wrote SQL tools to recon between systems to support operations, client exceptions based on legacy systems and handled issue resolution with clients, legacy systems and primary vendors (Bloomberg, MOODYs, S&P, Reuters, DTCC, OCC, FOW, etc.)

This project was also a strategic stepping stone to decommission 2 major Securities Data Reference systems. Completed Business Rules and mapping for 300+ attributes between the 2 legacy and Strategic Security Master Console (SMC) systems by asset type and product hierarchy alignment.

Designed and delivered Securities Indicative data infrastructure to a Global Transactional Services HUB for re-distribution to multiple clients in Securities and Funds area.

To support management, created Data Distribution Infrastructure (DDI) process to standardize the Client on-boarding. This allowed quicker turnaround for client on-boarding, ensured requirement completeness in fraction of the time and hand-off the deliverable to the DDI team with minimal errors and issues. Converted new clients to corresponding CLOUD strategic solution for API and Subscriptions onboarding.

Standardized release management tasks for Interface Processing BA group to be leveraged for all client facing deliverables. This streamlined the releases in each environment to a day’s worth or less instead of weeks.

Designed and modeled utility for BAs that captures mapping, use cases and tracks auditability details via maker/checker (an in-house application). Approved by Managing Director as a BA strategic standard utility and is currently being developed.

Identified anomalies, errors and data modeling inconsistencies to the data warehousing team and security coding teams with the plan of improvement.

On-boarded successfully 4 clients with Securities Master Indicative Data and supported additional deliverables fulfilling strategic Information Securities plan to decommission legacy systems.

Managed client expectations, education in securities, data and deliverables.

Bank of Tokyo-Mitsubishi UFJ April 2010 – July 2011

Sr. Analyst/PMO Coordinator for US

Technology: dB2, SQL, AIX/Unix, SharePoint, MS Project 2010

Overseen data handler replacement with more robust global data collection and reporting capability to be delivered through ZEUS. Zeus project addresses BASEL II RWA calculation – Abolishment of 131 reports; data accuracy. Asset Evaluation & Assessment, Credit Risk Mgmt. – Ensured same BR rating across family, Produced Credit portfolio report within one-month, Timely capturing & sharing of overseas performance by capturing daily balance and monthly P/L, Overseas business management – Enable capturing global exposure and parent company info on a timely basis. This reduced number of reports to Tokyo Head Office by 40% supporting business promotion – profitability analysis. Responsibilities:

Oversee Coordination for US deliverables from SIT to Post production stage

Project Plan Management and resource allocation

Resolution of SIT and UAT issues with Business, IT leads and SMEs

Overseen quality by running code reviews, artifact reviews for SIT, UAT and Pre-Production

Progress tracking, management and Tokyo reporting

Designed Global Exposure Validation and reconciliation framework

Designed Exception handler for Zeus Help Desk support

Citigroup February 2007-April 2010

Project Lead/Sr. Analyst - December 2009 – April 2010

Technology: ORACLE, SQL, Toad, AbInitio, MicroStrategy, SharePoint

Transaction Analytics is a strategic global initiative for Citi to provide consolidated view of client business activities. Clients, regional and product managers would have a capability to view client dashboard with score card and KPI metrics in transaction volumes, STP, payments, receivables, billing, and address client top issues.

Responsibility included to onboard three ASIA disbursement systems into the warehouse. Coordinate with the ASIA business requirement gathering, define payment lifecycles, track questions and requirement changes, managing risks and issues, reporting status to stakeholders and management, engaging and overseeing offshore and onshore development teams to meet aggressive deliverable dates.

Project Lead/Manager - April 2009 – December 2009

Technology: ORACLE, SQL, AbInitio, PL/SQL, Informatica, Business Objects, MS Project, SharePoint

Global Information Warehouse (GIW) is one of the largest data repositories in Global Technology Services (GTS). GIW is a central data hub, provides data services to over 100 downstream systems.

As a lead for Master Data Management (MDM) implemented Data Governance, PMO engagement with Business to source, analyze and standardize reference data and improve business practices. Responsibilities included:

Implemented project controls for the Global Warehouse Reference Data Hub.

Improved Data integrity, governance and improved Data Quality and Coverage.

Documented system work-flows, data lineage, data metrics, and responsible for data cleansing

Reviewed and Approved all technical designs to improve restartability, manageability and maintainability

Assisted in major re-architecture of the reference data hub for global data warehouse.

Managed 38 projects within budget and schedule, including Work products, Cost and Resource Management, and Off-shore Vendor Management

Managed Reference Data Hub Performance Tuning.

Senior Lead Analyst/Project Leader May 2008 – April 2009

Technology: ORACLE, Ab-Initio, XML

Electronic Billing System provides corporate clients the consolidated statement delivery using the industry standard TWIST. World-wide billing systems were sourced to create a consolidated global statements with information on products, volumes, pricing and charges. This would allow the clients to measure trending, volumes and re-pricing and engage the client managers to focus on attrition and cross-sell. Responsibilities included:

Reaching out and engaging billing systems globally to provide billing and invoicing data.

Identifying different billing approaches used by regions to accurately map and report based on the required TWIST industry standards.

Designed, architected and modeled the Global Billing statement delivery process for 5 regions.

Engaged the client implementation team to help on-board 40 top-tier clients.

Project and Risk Managed 5 Projects.

Successfully delivered project on budget and on time.

Technology: ORACLE, Xcelsius, Business Objects, VersionOne

Securities and Fund Services (SFS) Client Experience Dashboard is a strategic business objective to measure client experience with SFS products and services, provide measurement tool for predictive business indicators and allow online analytics with a single click.

17 Key performance indicators were implemented for regional and client managers.

Project provided capability to view an overall client health by evaluating trending in revenue, Client requests, Satisfaction, Investigations, deals in the pipeline and empower management teams to take action upon the top 10 client requests and issues. Ranking, client grouping, benchmarking and STP indicators provided management the tools to prioritize, focus and address client service. Responsibilities included:

Gathered requirements from the business owner and stakeholders.

Negotiated with partner systems to source the supporting data.

Prototyped the dashboard design with the Business.

Researched the best SCRUM products on the market and implemented Agile methodology using VersionOne to track releases, iterations, tasks, teams and generate workflow and burn reports for management

Designed the data model and overseen development of the Xcelsius dashboard

Researched and engaged best Xcelsius practices and principles which resulted in 90% performance improvement.

Managed project plan, risks and issues using Microsoft Project and SharePoint tools

The implementation of this matrix was successfully rolled-out to over 600 users.

Citigroup Feb 2007 – May 2008

Sr. Lead Analyst/AVP

Technology: ORACLE, PL/SQL, Business Objects

Back to Basics initiatives was launched to improve the way we manage core business issues: Pricing, Attrition, Ramp-up, Change Orders, Cross-sell and Target Market Expansion. The application provided Product Managers a tool to focus on aligning client prices with their activity levels and recommend Client managers on the contractual arrangements to prevent price increases. It also helped identifying revenue decliners and products. Cash management market managers engaged with client managers to identify potential recovery for revenue decliners. The modules provided a repository to report on the causes and next steps to build attrition.

Solicited requirements from the business, stakeholders and regional source system.

Worked closely with business and stakeholders to build functional solution

Designed and architected the model for the warehouse and mart.

Oversaw 3 minor development projects in addition to 4 Large Projects

Prudential Financial, NJ Aug’05-Dec’06

DW Business Analyst/Data Analyst

Technology: ORACLE, UNIX, C

Worked on a Data Warehouse for Finance and Mutual Funds. Was part of the DW team for Finance and Mutual Funds. The Data Warehouse was mainly for reporting of Asset Management, Mutual Funds, Trust, Brokerage, Trading, Banking and Credit modules.

Conduct user interviews, gather and analyze business, functional, and non-functional requirements using RUP.

Conducted JAD sessions with business unit owners and portfolio team to capture business requirements and system behavior.

Research, identify, investigate, analyze, define and document business processes and Use Case Scenarios. Refined and realized Use Case models

Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Responsible for identifying and documenting business rules and creating detailed Use Case.

Worked with development, configuration and testing teams to accomplish timely release objectives.

Participated in the error review meetings to discuss outstanding issues with the QA team and developers.

Worked with the UAT team to validate that the developed application will meet the business requirements.

Developed timelines for project delivery, and managed projects and resources to successful completion.

Presented the application walk through and the business know how to upper

Management, business partners, and project managers.

Identifying and capturing potential risks in the Risk Management Database.

Provided post implementation support.

UPS, NJ Mar 2005 - Jul 2005

DW Business Analyst/Data Analyst

Technology: C, UNIX, ORACLE

Data Warehouse Project on central repository system for Volume and Revenue of Trade Direct Shipping Transactions.

Created software requirements specifications, use cases, business process flows for Trade Direct Shipping Transactions.

Collected history for Dun and Bradstreet world base indicators to reflect 18 months’ worth of data. Managed time and traceability matrices for functional elements, integrate individual functional element traceability matrices to produce an application-wide Trace Matrix. . Identify research, investigate, analyze, define and document business processes and Use Case Scenarios. . Refined Use Case models created UML diagrams to reflect use case text narratives. . Responsible for identifying and documenting business rules and creating detailed Use Case. . Worked with development, DBAs and subject manner experts to accomplish timely release objectives. Participated in the Change Control meetings to incorporate the changes and risk in the project.

Liaison between the Businesses and IS group in performing tasks to interpret the business requirements and then link them to the application and ensuring the technical solution satisfy the business requirements Identified and documented issues, risks, gaps and their impact to the project life cycle.

Provided recommendations and alternatives.

Maintained a good working relationship and communication with the customer and provided technical support throughout the product development

AT&T, NJ Aug 2002-Sep 2004

Account Manager/ Sr. Analyst

Technology: C, Pro*C, ORACLE, Autosys, CONTROL-M, UNIX

Worked with different stakeholders to gather business and functional requirements and converting them to technical requirements.

Produced Use Case, Domain Dictionary, UML Charts and diagrams. Obtained signoffs on functional requirements based upon business requirements.

Assisting in developing object models from the functional requirements and architecture using UML methodologies and modeling tools knowledge Rational Unified Process (RUP)

Developer sequence diagrams using UML methodologies.

Worked closely with subject method experts and developers to capture business

requirements according to RUP best practices to analyze and understand what kind of service requests were being received and serviced by the company’s helpdesks across geographies

Analyzed and documented the organizational service business processes in various regions

Identified and documented roles, normal and escalation workflow procedures for the as-is

To collect and document business requirements for the to-be helpdesk processes from various geographies

Create and maintain one Global document for the to-be processes

Delivered a consolidated global organization chart for Helpdesk operations

Southwestern Bell Communications, NJ May 99-Jan’02

Project Lead

Technology: C, JAVA, UNIX, ORACLE, MQ

Southwestern Bell Telephone Company a wholly owned subsidiary of SBC Communications Inc. provides landline telecommunications services in Texas, Missouri, Oklahoma, Kansas and Arkansas. The company provides local exchange services. Responsibilities:

Managed development team, worked closely with each e-Gateway SBC client on the project to plan and contribute to business decisions. Acted as a liaison among TELCORDIA, SBC clients, business analysts, testers, developers, architect and dba teams.

Business Analysis and Requirements gathering

Worked on data conversions and data loads using PL/SQL. Improved the performance of data loading procedures using Syncsort for UNIX.

Created Informatica mappings with PL/SQL procedures to build Most of the transformations were used like the Source Qualifier, Connected & Unconnected Lookups, Aggregators and Filters & Sequence.

Design and Development of Shell scripts for event automation and scheduling

Created Business Intelligence reports

Designed and developed a real time ordering system and Order Message Timer system, including ALERT system for expired or in jeopardy orders for e.Gateway

Product. This proactively searched for orders in jeopardy and sent alarms to the agents for that corresponded to the appropriate CLEC/ILEC. Project runs on IBM AIX utilizing, JAVA, C++, Orbix CORBA, Rogue Wave class libraries, PL/SQL and IBM message queues MQ Series.

Customized and maintained e.Gateway product for multiple clients.

Responsible for third party products releases including research and impact analysis

Automated system performance notification Patrol Message Monitor System. Developed all modules in JAVA using XML as a configuration file to define the events, time frames, and stored procedures.

Prepared several presentations and support documentation for knowledge transfer back to the client using Rational Rose and SODA reporting tools.

Populating the business rules using mappings into the Repository for Meta Data Management.

Data Quality Analysis to determine cleansing requirements.

Developed Maplets using corresponding Source, Targets and Transformations.

Created various UNIX Shell Scripts for job automation of data loads.

Migrated Mappings, Sessions and Common Objects from Development to Test and to

Production.

Optimized Informatica mappings for Performance at transformation level, mapping level and Session level.

AT&T, NJ Feb’98-May’99

Account Manager/Sr. Programmer Analyst

AT&T client for Financial Community Information Warehouse (FCIW) project, a family of systems designed to support the information needs of finance personnel.

Located and corrected a flaw in Autosys scheduler application and implemented a queue for File Acceptance and Logging sub-system.

Due to incompatibility of ORACLE ProCobol Precompiler, NCR/Unix and MFCOBOL built an interface between the Oracle precompiler and MFCOBOL compiler for each upgrade of MFCOBOL and/or ORACLE.

Acted as pivotal point-of-contact for all FCIW Y2K related issues, compatibility and Y2K compliance.

Designed and implemented a generic report-writer tool in awk to assist business analysts. This tremendously freed up the use of DB and CPU time. Approximately 12 different types of file formats were adapted into the tool for over 50 reports.

Provided day-to-day maintenance for scheduler, awk, and shell scripts, Pro*C and

Analysis/Design (Understand Initial Business Requirement, Flow diagram, Physical & Logical Data Model, Configuration Requirement);

Design/Development (Write/update program specifications per design documents, code/create modules using COBOL/COBOL II,SQL,JCL, MicroFocus COBOL, Pro*COBOL, C, Pro*C, PL/SQL, Stored Procedures and Functions and UNIX shell scripts);

Testing (Involved in entire QA Life Cycle: Design, Develop and Execute the entire QA Process; Created Test Plans, Test Cases, Test Procedures and Test Scripts; Used test methods like Unit, Functional, System, Integration, UAT, parallel, E2E, Pilot & Regression Testing; Extensively used Test Director for writing test cases, reporting defects and documenting test results; Used testing tools such as XML Spy, Sql*Plus, MS Access, TOAD, and UNIX shell );

Troubleshooting/Production Support (Prepare on-call schedules; Analyze and fix production problems)

Internal/External Technical Documentation (Write or Update Job Flow Manuals, User Guides and Production Control Job Guides);

As DMR account manager accepted responsibilities as a career advisor to DMR

Consultants and acted as a technical coordinator for the Clientele and FCIW team.

Citibank, NYC Sep’96-Feb’98

Project Lead/Sr. System Analyst

Technology: C,C++, Sybase, UNIX

Complete life cycle development for a Global Risk Rating (GRR), a system of central repository to collect, analyze and evaluate the risk taken to provide a loan to a specific country or government.

Performed heavy analysis for preparation of data warehousing.

Business analysis included continuous research and information gathering

Continuous sessions and daily meetings with the Bank’s specialists on the related matters as well as working with a group of Citibank’s Sr. business analysts

Data Modeling to reflect the effects of changes based on the multiple variables dictated by the business.

Data analysis ad-hoc queries on current system

Data evaluation and de-normalization of tables for OLAP

Worked closely with DW and Crystal Reporting teams to produce desired metadata and business reporting

Managed a development team and was a sole point-of-contact between the client and the team.

Toward the middle of the project was promoted to account manager position and

Responsible for managing a team of eight consultants at client’s site.

Analyzed and coded major portion of GRR system using C/Unix and SYBASE data

Manipulation using ISQUL and BCP utilities and creating filters in Syncsort.

Maintaining file puller program that is written in C++ that collected feeds from 90 countries, perform trailer check validation, and produce a set of extract files over three time zone intervals.

Responsible for RCS to PVCS conversion of the GRR product. Set up the PVCS GUI

Education

Baruch College: BBA in Computer Systems

Kingsborough Community College: AS in Mathematics

Training

Business Objects: BO Reporting and Universe Design

Xcelsius Training

SUN: JAVA Preparation for Programmer’s Certification

NETCOM: JAVA Preparation for Web Development Certification

NYU: C++ Parts 1 and 2 for Object Oriented Certification

Learning Tree: Developing with XML

Compulearn: Certification in PRO*JAVA

Contact this candidate