SUMMARY

• Expertise in Investment Banking, Securities, Equities, Fixed Income, Repos, Foreign Exchange (FX), OTC Derivatives, Asset Management, Risk Management, and Securities ratings
• Extensive knowledgebase of market risk and credit risk and reference data including client and securities/instrument data, product, and pricing
• Detailed knowledge and adherence to Project Development Lifecycle (PDL) and Software Development Life Cycle (SDLC) for IT projects
• Provide leadership and unique insights in the analysis of customer business requirements that may cross multiple functional areas and/or multiple technical platforms leading to business process improvements
• Strong business and technical data warehousing skills, including expertise in business and data requirements, database design, sequence diagrams, SQL queries, Use Cases, Test cases, OLAP tools including ORACLE Discoverer, Business Objects and Cognos, VISIO, SAS, Easytrieve, UNIX, scripting, technical documentation writing, and working knowledge of Ab Initio and Informatica ETL development tools.
• Strong working knowledgebase of financial reference data including client, counterparty, and investment products related
• Strong analytical and technical capabilities, decision - making, oral and written communication, and problem-solving skills
• Project Management Professional
• Experienced in monitoring project flow including integration, scope, time and cost, quality management, human resource management, risk and issues monitoring, procurement, and change management
• Excellent at managing resources in a dynamic environment, with successfully completing tasks on a timely basis while managing through changing requirements and priorities
• Coordinate with developers and analysts to create functional business requirements for configuring, testing and supporting Front, Middle and Back office environments
• Experienced in writing functional business requirements and system functional requirements documentation for system implementation which can be shared with various business and technology groups.
• Creation of wireframe screen mockups for web-based user interface projects utilizing Agile project methodology
• Develop functional test plans and test cases for acceptance testing, system implementation and product rollout
• QA test flow procedures and processes using Mercury Quality Center for tracking of defects, requirement enhancements, and test cases
• Creation and maintenance of detailed database and data warehouse metadata including both business and technical information
• Analyze and document all fixed income product feeds to monitor credit risk and market risk
• External vendor communications and coordination management
• Expertise with Six Sigma projects and leading team in completing efficiency updates and implementations
• Expertise with general ledger and accounting principles including GAAP and IFRS
• Trained with extensive knowledgebase in Java J2EE technology and methodology, stored procedures, system architecture and flows, XML
• Create application training documentation and coach end users on final application rollout

TECHNICAL SKILLS

• EXCEL
• ACCESS
• POWERPOINT
• PROJECT
• VISIO
• OUTLOOK (email))
• SQL (Oracle
• DB2
• Sybase
• Informix
• MS ACCESS
• Business Objects
• Cognos)
• Mercury TOAD (SQL)
• Embarcadero SQL
• PL/SQL Developer
• XML/XSL knowledgebase
• Use Cases
• User Stories
• PENCIL Wireframe
• Easytrieve
• Lotus Notes
• Sharepoint
• SASJCL
• ORACLE Discoverer
• Hummingbird EXCEED
• UNIX
• AWK
• scripting
• Java J2EE
• COBOL
• CICS
• Waterfall
• Iterative
• Rational RUP
• Six Sigma projects

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Business Analyst

Responsibilities:

• Project Apollo was for the implementation of a new term life insurance product
• Business analysis of current state existing life insurance products
• Analysis for future state for the new product to be rolled out
• Creation of business and data flow diagrams depicting flow for this new life insurance product and its implementation
• Creation of Use cases for coordinating of UAT with developers and the business users
• Agreement was for a short 3 month project need duration
• Change management analysis of requirements and transposing into detailed requirements enhancements
• Analysis of data changes using SQL queries
• Updating and enhancing existing documentation

Confidential, NY

Senior Business Analyst

Responsibilities:

• Business Analyst and Solutions Analyst for Litigation Management project
• Liaison with business and development and architecture to acquire requirements, document, and design new web-based user interface to automate an existing mostly manual system for litigation management
• Creation of wire frame screen mockups for front end user interface
• Agile methodology utilized for project
• Create detailed specification documentation including business process map, data flows, data mappings, use cases and usage scenarios to corroborate with development team
• Created test strategy and test cases
• Support testing team and user acceptance testing
• Creation of detailed data mapping requirements for source data to target database data
• Design of database and enhancements to database design for wed-based application

Confidential, NY

Senior Business Analyst

Responsibilities:

• B/A role within long term project of system and data migration from Geneva to NY Enterprise Security Management system
• Create Business Requirement Documents (BRD)
• Create Functional Requirement Documents (FRD)
• Create comprehensive Use Cases
• Proficient in SQL and comfortable independently working with relational databases
• Collaborated with Architecture for ability to design and create Canonical data model involving use of XML and XSL
• Ability to perform analysis (SQL, Excel, MS ACCESS) on datasets to determine their quality, coverage, complexity
• Worked with developers using Informatica tool set to complete data quality frequency runs to determine data anomalies, or errors in source data files early in project
• Creation and maintaining of data mapping, metadata repository of all database related information
• Proficient knowledgebase and related concepts regarding Credit and Market Risk across all investment products
• Communicate business concepts and expected functional behavior to Developers
• Communicate with downstream data consumers and upstream data providers (IT, Business and Operations) to determine objectives including requirements, resolution of issues, solutions work
• Provide Subject Matter Expertise on Pricing Reference Data
• Proficient with Product and Pricing Reference Data, i.e. Asset Class Definition, Street Identifiers
• Technically proficient in Microsoft Suite including Project and Visio
• Strong analytical, problem solving and communication skills, both oral and written
• Capable of managing multiple tasks under tight deadlines
• Gather/Provide Status for reporting up to management
• Facilitate meetings with specific agenda and personnel, with PMP certification managed PM responsibilities during project

Confidential, NY

Senior Business Analyst

Responsibilities:

• Project work was around data centric data warehouse data quality verification for various investment products’ data using SQL
• Involved with metadata enhancements for database
• Collaboration with data modelers for database enhancements and maintenance
• Documenting query discoveries for overall data remediation for data warehouse DB migration
• Discovery was around data breaks reflecting source data feeds to data warehouse database
• QC data quality research and analysis for resolution of issues
• Facilitate meetings with key personnel for requirements gathering
• Extensive analysis of requirements for business and end users
• Write functional requirements documentation for use by the business and also development and architecture teams
• Involvement with internal audit group for gathering of their requirements and capturing within business requirements document

Confidential

Senior Business Analyst

Responsibilities:

• Write functional business requirement specification documents for development team related to Basel II data sourcing goals, including Equities, FX, Reference Data, derivatives, and Fixed Income
• Liaise with business and development groups to determine requirements for working towards data quality remediation.
• Track various investment product data sources through to implementation for resolution of data defects.
• Creation of test cases and testing SQL scripts for QA purposes covering equities, FI, FX, and derivatives
• Involvement with SIT, UAT, and cutover test planning and execution for investment products such as Equities, FI, derivatives, and FX
• Technical writing of functional requirements documents including flow diagrams using VISIO
• Facilitate meetings with business groups relating to the Basel II data requirements to satisfy the downstream user groups including Regulatory reporting
• SQL querying analysis against Oracle database, DB2, and Sybase
• Extensive use of MS ACCESS for importing various data sources to analyze and report on
• Building of EXCEL Pivot Tables from various data to analyze
• QC data quality research and analysis for resolution of issues raised in HP Quality Center application

Confidential

Senior Business Analyst and Project Manager

Responsibilities:

• Requirements gathering for investment product related reference data and creation of functional data requirements documentation
• Create test scripts and test SQL for querying of development and QA databases against project related reference tables and data tables
• Support of SIT, UAT, and cutover testing planning and execution
• Goal was to discover any data defects according to our test cases built for investment product data elements
• Enter, track, and resolve any discovered data defects entered into Mercury Quality Center with communication with specifically related project personnel such as the business, QA testers, and developers
• Determination of both credit and market risk
• Coordinated project milestones with program management and monitored project timelines according to project plan and schedule
• Facilitate meetings to gather project requirements to document into both business and technical data requirements
• Tracked and resolved all project risks and issues
• Reported project status to upper management
• Began work on remediation project related to back end business intelligence reporting improvements

Confidential

Project Management/Data Quality Business Analyst

Responsibilities:

• Collaborated with business, B/A’s, developers, and data architecture to import reference data, design database tables and elements specifically for customer and counterparty data enrichment
• Facilitate meetings with project personnel to work through keeping project milestones on track according to project plan and schedule which involved being PM lead with about 11 people in a matrix reporting environment
• Coordinated with developers and analysts with creation of functional business requirements and creation of functional software specifications documentation and related flow and sequence diagrams
• Lead B/A for creation of metadata information for entire database environment and also delegated work to several B/A’s throughout project
• Worked with Front, Middle and Back office processes for configuring, testing and supporting their groups
• Managed functional test plans for system implementation and product rollout
• Construction of test SQL and scripts and executing for testing results and defect tracking.
• Writing functional business requirements for system implementation to be shared with both the business and technology groups.
• Worked with business users through acceptance testing of all investment product data including all Basel-related reference data, market data, as well as related market risk and credit risk
• Analyzed and documented various investment product feeds to monitor/manage credit risk and market risk
• Gathering requirements regarding FIX communications protocol for equities and derivatives
• Document and maintain testing results and track defects through entries in Mercury Quality Center
• Worked directly with external LOBs to source, design, create, and maintain control tables, or reference data tables, used for counterparty customer and instrument reference data
• Corroborated with SMEs from source data environments and business users regarding information for general ledger and accounting standards related to Basel II which include GAAP principles

Confidential

Project Manager

Responsibilities:

• Managing projects across multiple areas including working closely with upper management, business and data analysts, development personnel, architecture team, DBA’s, and quality analysis testers, along with production release teams.
• Strong knowledgebase of OTC and structured derivative products, equity and fixed income products and trade flows, as well as Foreign Exchange (FX) products and involvement with all Basel-related reference and market data, as well as
• Coordinated creation of business requirements and functional specification for configuring, testing and supporting Front, Middle and Back office
• Worked with developers using Informatica tool set to run data quality frequencies to determine data anomalies and errors in source data files
• Worked with business users through acceptance testing including entry of test defects, tracking, and working through to resolution
• Corroborated with business and data source SMEs regarding information of general ledger and accounting
• Liaise with cross-platform personnel for sourcing of business related data, reference and market data, and related investment product data elements to deploy to Oracle data warehouse environment for down stream regulatory and compliancy reporting for the market and credit risk for the firm.
• Creation and maintaining of the metadata documentation and repository
• Hands on aiding business and data analysts with technical writing of requirement and detailed specifications documentation and involvement with detailed data analysis utilizing SQL expertise against an ORACLE database for purposes of determining data quality control during SIT and UAT testing phases.
• Set up and facilitated necessary meetings with the required personnel with planned agendas.
• As lead PM/BA on project tracked project testing defects, issues, and risks throughout project to resolution and closure utilizing Mercury Quality Control application
• Maintain a central repository for project documentation so all project members could access.
• Maintain project status reports on a weekly basis for meetings with program management.
• Issue and risk management working toward resolution
• Data warehouse expertise includes full working knowledge of project and software life cycle from project inception through to production release deployment with inclusion of metadata documentation and repository
• Great knowledge of data modeling and architecture design for databases.
• Detailed involvement with data quality verification and validation.

Confidential

Senior Business Analyst and Project Leader

Responsibilities:

• Used PKS as central repository for all artifacts created within the sub project.
• Management of project progress and communications to upper management.
• Key role within the overall Plan team for Basel II Capital Remediation project as a senior business analyst which involved analysis with multiple investment products such as Traditional Credit Products, including fixed income, equities, and OTC derivatives, along with Repo (Repurchase Agreements), and AFS/HTM products, including securitizations.
• Acted as liaison with the business personnel to derive and finalize requirements.
• Creation of detailed technical functional specifications documents and corroboration with the Build (development) team by reviewing the functional specifications for various investment products and obtaining sign off
• Led the task of requirements involving the design and creation and deployment of all required Basel II reference and market data to data warehouse for use in various data enrichments during processing.
• Knowledge of data extractions from market data including Bloomberg and Reuters as well as rating agencies such as S&P, Fitch, Moodys
• Key part of the team that constructed test plan, test scenarios and test cases for data and system testing of these investment products used within testing phase.
• Liaison to Front, Middle and Back office personnel
• Created application training documentation and coached end users
• Worked with business users through acceptance testing
• Usage of extensive SQL for data verification, validation and testing during shared SIT, QA, and UAT testing phases
• Usage of the OLAP tool Business Objects for SQL query generation along with creation of required business reports

Confidential

Data/Business Analysis Manager

Responsibilities:

• Collaborated with Card Services Information Data Warehouse Platform Champion and ETL developers to develop and implement standardized data analysis processes that enabled the firm to attain Capability Maturity Model Level 2 certification (October 2003).
• Implemented best-practice enhancements to the data analysis process that significantly reduced the number of faulty data specifications, contributing to a 50% reduction in overall defects needing to be addressed during User Acceptance Testing. Monitoring of internal controls and maintain data quality assurance.
• Collaborated with the Metadata Repository team to develop a mechanism for easily populating credit card business and technical information into a centralized metadata repository
• Captured and documented data element definitions and computations and ensured that business requirements were met.
• Led the data mapping effort for the acquisition of a multi-million dollar Providian credit card portfolio
• Manage the project for analysis resources in a fast-paced data warehouse environment who are responsible for business requirements gathering, technical data analysis, documenting and presenting of process and work flows, data mappings, detailed data requirements, metadata capturing, and involvement with User Acceptance Testing.
• Directly interface with a wide range of business units, including Risk Management, Business Support Center, Knowledge Management, Marketing, Decision Science, Loss Containment, and Finance. Participate in business requirements gathering and planning sessions and proactively identify opportunities to apply technology to advance the success of the business.
• Apply technical knowledge and experience to make key decisions about approach, tools, methodologies, and design direction, and have the technical background to work with data from diverse platforms in varying formats.
• Collaborate with application development managers and the software development team members involving requirements walk through sessions and coordinate with the quality assurance manager for UAT environment set up for IT projects