SUMMARY:

• I have over 25 years of hands - on experience in management consulting, functional and system architecture across several industry segments and verticals including Financial Services, Capital Markets and Master Data Management (MDM) / Data Management. I was responsible for Analysis, Design and Quality Assurance of Business Intelligence Data Warehouse solutions and participated in the delivery of Information Architecture Gap Analysis, Roadmaps and Future State Architecture proposals. As a Project Manager, I was responsible for delivering project results within schedule, cost and performance constraints.
• Capital Markets (Trade Order Management, Pre- trade / Post-trade Analytics)
• MDM / Data
• Analysis and Design of the Bloomberg, Telekurs, S&P and LoanIQ feeds.
• Analysis of Compliance and AML reporting data requirements
• Analysis of business requirements for Syndicated Loans, TaxLots and BRM.
• Logical and Physical Data Modeling in support of the market feeds and data vendor feeds.
• Data analysis of incoming feeds for completeness
• Information Architecture Strategies and Roadmaps, Gap Analysis data requirements analysis for Counterparty and Products
• Data Warehousing, Star Schemas, EDW, Dimensional Modeling, Business Intelligence
• Current State - Future State Analysis and Documentation
• Gap and data analysis. Data integration. Statistical Analysis.
• Process Modeling (BPM), Data Modeling
• Metadata Management, Data Dictionaries and Repositories
• Data and Process Architecture
• Data Quality Analysis / Data Profiling
• Relational (RDBMS), Multidimensional and OLAP/ROLAP
• Project Management
• Project / Engagement Management
• Data Quality Management, Data Quality Metrics
• Relationship Management (Business and IT)
• Offshore team management
• Status Meetings with on-shore / off-shore team members as well as senior management
• Life Cycle Methodologies (SDLC)

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Using the data mapping and data lineage documents put together SQL queries that would validate and reconcile defined Critical Data Elements (CDEs).
• Work with source systems and Actimize SMEs in order to define and/or confirm the transformation and filtering rules;
• Properly document the queries, findings and suggestions.
• Document source systems Data Flows.

Technical Environment: Oracle, Teradata, SQL, SQL Assistant, Data Warehouse, Excel.

Confidential

Data Analysts / Business Analyst / Data Architect

Responsibilities:

• Provided Data Mapping documents for Investran - the major data supplier as well as the TPAs (State Street and Burgiss);
• Provided Data Lineage for all measures and dimensions added to the Data Warehouse;
• Worked with business users and ETL developers on Data Scrubbing (Data Cleansing) ;
• Translated business requirements into functional specifications and database design in a BI environment supporting various business units
• Put together an MDM (Master Data Management) approach and proposed it to a Data Steward Council;
• Provided test plans and created test queries to validate the data load processes;
• Documented both test approach and test results.

Technical Environment: MS SQL Server, SQL, Data Warehouse, ShareFile, Excel, Visio, PowerPoint.

Confidential

Business Analyst / Data Analysts / Data Architect

Responsibilities:

• Reviewed BRDs with Business Users, understand the final deliverables (reports, analytics, ad-hoc queries);
• Questioning Business Users and fully understand the real need for requested reports and analytics
• Worked closely with Data Modeling team to
• Define target entities in Core layer of the Data Warehouse. If none exist, propose the DM extension and work with Data Modeling team on it.
• Created Data Mapping document, data lineage and ETL specs;
• Review data with Data Group in order to identify “conformed” data elements;
• Continually communicate with Requirements team, Data Modeling team, Data team and the ETL team in order to address and re-review all the changes occurring along the way;
• Worked with ETL developers on Data Quality issues moving data from the Acquisition layer to a Core Layer.
• Source Data Profiling and thorough Data Analysis for Completeness, Validity, Uniqueness, Conformity, Consistency, etc

Technical Environment: Oracle, Teradata, SQL, SQL Assistant, Data Warehouse, Excel.

Confidential

Technical Business Analyst

Responsibilities:

• Created Product Data Dictionary for all data elements from Reuters and Bloomberg files;
• Data Hub Architecture and transformation logic
• Analysis of other vendor files and their integration into CS MDM database;
• UI design, functionality and navigation for a Product context of Data Glossary.
• Interfacing with various business and IT groups to solicit their “pain points” and desires for a Data Glossary application.
• Created a Functional Requirements document for a Product context of Data Glossary.

Confidential

Project Manager / Business Analyst / Data Analyst

Responsibilities:

• Analysis of various source systems and levels of granularity the data is stored there;
• Running various Data Profiles and Analyzed the results in order to support or reject a particular data source;
• Source to Target Data Mapping:
• Based on particular release / iteration of deliverables, utilizing Agile methodology, identified the target tables and columns;
• For each target column identified source tables and columns based on the required level of granularity;
• Provided filtering and DW transformation rules;
• Participating in Data Model and ETL Process Flow design;
• As a Project Manager:
• Preparing Weekly Status Reports and conducted meetings with Client and Consulting company management teams;
• Conducting weekly knowledge transfer meetings with an off-shore Center of Excellence (CoE) team;
• Coordinating efforts of on-shore and off-shore teams.

Technical Environment: MS SQL Server, SQL, Business Objects, Data Warehouse, SharePoint, Excel, Visio.

Confidential

Business Analyst / Data Analysts / Project Manager

Responsibilities:

• Reviewed various FRDs (Core and Loans) with Business Users and the IT and made changes to a GL Corrections FRD;
• Reviewed and updating Data Mapping for Loan portion of GENESIS;
• Reviewed GL Corrections BRD with Business Users and the IT staff and assured it is in line with Citi standards;
• Reviewed Genesis Data Model, Data Flow and Process Flow and proposed alternatives;
• Reviewed the Landing Pad and ETL processes and proposed changes.
• Proposed alternative Data flow (Local. Global, DW) for corrections and loans processes.

Technical Environment: Oracle, SQL, Netezza, Data Warehouse, SharePoint.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Worked on Analysis of existing Fixed Income feeds from Telekurs;
• Worked on compliance reporting data requirements (ex: FINRA);
• Worked with a Data Modeling team on Proposed Data Model changes for Telekurs feeds;
• Reviewed Bloomberg, FINRA and Telekurs feeds in order to document data requirements and derivation / data integration logic ;
• Heavy data profiling of various data sources feeding existing systems;
• Created mapping documents from the Telekurs source files to RVR (staging) area;
• Created mapping documents from RVR (staging) area to TnT (transformed) area;
• Documented transformation rules and developed functional specifications for the IT team;
• Created a High Level Design Document (HLD);
• Created various SQL queries to analyze existing Fixed Income data vs. Telekurs Feeds;

Technical Environment: Oracle, DB2, Excel, Visio.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Interviewed major stakeholders and worked closely with IT personnel to analyze Product and Counterparty data requirements from various sources of the data warehouse: Syndicated Loans, Prime Brokerage, BRM, Commodities, Repos, OTC Trades and Taxlots
• Performed Data Gap Analysis between the business work stream requirements and existing Golden Sources
• Analyzed business requirements and developed functional specifications for the IT team
• Reviewed new data mapping for the Data Warehouse and proposed database changes.
• Provided Data Modeling changes relative to a new product added to a Security Master ( Corporate Loans, Commodities);
• Created test cases for data QA testing;
• Analyzed data quality in Security Master for a Fixed Income products and Corporate Loans;
• Heavy interface with various business areas involved.

Technical Environment: DB2 UDB, SQL, Excel, Visio, DBArtisan, Erwin.

For BASF, Corp

Business Analyst

Responsibilities:

• Managed technical deliverables along with relationship with business communities
• Liaise between Business (Stakeholders) and IT communities in order to develop the roadmap and architectural alternatives for data distribution, replication strategies, data integration approach and capacity planning
• Designed Business and Reporting layers of the DW as well as nightly and monthly ETL processes
• Data analysis and validation utilizing Oracle SQL queries, SAP queries and BEx Reporting
• Created mapping documents between SAP / R3, Oracle DW and SAP BW.
• Documented each component utilizing Visio, Oracle Designer, MS Excel, MS Word
• Created testing approach and guidelines, use case scenarios and executing test plans utilizing SAP/R3 and BEx queries
• Assessed data quality and inconsistencies via SQL and SAP BW queries
• Worked on files integration and Data Governance issues
• Created data dictionary and metadata repository.

Technical Environment: Oracle, PL*SQL, SAP/R3, SAP BW, Bex Reporting, SQL queries, Toad, UNIX, C.

Confidential

Business Analyst

Responsibilities:

• Reverse engineered Confidential database schemas using Confidential Designer data modeling tool
• Produced logical and physical models for various reverse engineered databases within PARIS warehouse
• Conducting technical analysis and Documented the existing data flows from front-office to back-office environments
• Analyzed and Documented internal and external feeds, stored procedures
• Created data dictionary and metadata repository.

Technical Environment: Sybase, Confidential Designer, Transact*SQL, Cognos.

Confidential

Engagement Manager

Responsibilities:

• Participated in all phases of the SDLC including requirements definition workshops, design and deployment of surveillance scenarios such as Front-running, Spoofing and Marking to Close Buy / Sell.
• Negotiated contracts with external and internal market data providers.
• Evaluated NMS requirements for compliance and market data management groups.

Technical Environment: NASDAQ, Reuters RTCE and Bloomberg Market Data, Oracle, UNIX, C, PL*SQL.

Confidential

Project Manager / Program Manager

Responsibilities:

• Confidential MARKETING Information Integration systems
• Site Builder Development, Maintenance and Support systems

Technical Environment: Cognos, MS OLAP, Hyperion Essbase and Business Objects OLAP / ROLAP structures.

Confidential

Project Manager, Engagement Manager, Business Analyst and System / Data Architect

Responsibilities:

• Negotiated SOW and budget
• Liaised with Stakeholders and the IT staff in order to analyze and document current business processes
• Managed project scope, schedule and Change Control of concurrently running projects
• Defined Time Box deliverables and deployment plans
• Defined requirements for the Data Warehouse through series of Business User interviews
• Performed Data Gap Analysis across Multi-Asset Trading platforms supporting Equities, Derivatives and Foreign Exchange desks globally
• Data analysis and reconciliation of inconsistencies discovered between the SQL queries and presented user requirements
• Data profiling of various data sources feeding existing systems;
• Developed functional specifications for in-house and off-shore development teams
• Prepared business specifications dealing with various portions of Capital Markets: trades, adjustments, hard dollars and soft dollars revenue generators across all clients, execution - destination points, trade types, participating brokers and contra-brokers and various SEC rules (MS Excel, MS Word, PowerPoint).
• Designed the multistep DW ETL process, consisting of: pre-processing data and applying monthly adjustments to orders and executions load of the analytical tier to populate multi-dimensional cubes and the Executive Dashboard. The data was sourced from various Sybase, Oracle, SQL Server and mainframe systems.
• Oversaw data mapping for the Data Warehouse
• Defined Integrated System Test plans across multiple platforms and applications
• Kept major stakeholders and the IT updated on the project status and the budgetary issues:
• Prepared and tracked the project schedule using MS Project:
• Prepared status reports and conducted weekly Status Meetings with major stakeholders and IT management
• Coordinated efforts of various project teams
• Worked with ORACLE DBAs on performance issues
• Defined security requirements

Technical Environment: Oracle, Sybase, Cognos, UNIX, C, Java, Apache, PL*SQL, Bloomberg Market Data.

Confidential

Project Manager / Data Architect / QA Analyst

Responsibilities:

• Created the infrastructure for successful implementation of various letters (Notification, Reminder, Billing, etc.) in a complete vacuum of any requirements:
• Logical Data Model for a letter portion of a DB2, Oracle and Confidential databases consisting of over 100 tables using ERWIN toolset
• Designed front end that would allow entering letter text along with other system parameters into ADR Demut database
• Designed processes that would combine previously entered letter text with financial aspects of the company’s proposal along with rmation (name, address, etc).
• Was responsible for design and QA of the most complex application components of the Letter System. Created use case scenarios.
• Developed integration architecture with the Workflow subsystem.
• Designed auditing and reporting databases and associated processes.

Technical Environment: DB2 / SQL, SYBASE, VSAM, CICS, COBOL II, UNIX, C.

Confidential

Project Leader / Data Analyst / Data Architect

Responsibilities:

• Managed a team of developers in an effort of building Data Acquisition, Data Scrubbing and Data Transformation functions of the ICP Data Manager subsystem. Was responsible for resource allocation, Project scheduling, co-ordination with ICP PC developers as well as with other groups within the company.
• Participated in DB2 / Confidential logical and physical database design depicting the following business areas:
• POS, Processing, Claims Processing
• Benefits, Copay / Deductible, Contract Management
• Developed and published testing strategy for the Data Manager subsystem.

Technical Environment: 3 tier Client-Server architecture, DB2 / SQL, SYBASE, VSAM, CICS, COBOL II