Lead Business Analysis/Functional Team, project manager

Noel Brown

Westfield, NJ *****

H-908-***-****: C-908-***-****

Email: see above

Sr. Business Analyst / Manager

INTRODUCTION

A consultant with over 10 years of business analysis experiences in fortune 500 companies in the financial, telecom, medical, retail, and vendor sectors. These experiences include; business analyst/lead, business consultant, project manager, relationship manager, as well as programmer. Proficient in requirements gathering, using an array of templates to document, communicate, verify, and translate into functional specifications for subsequent developmental efforts. In using this discovery process, I fully understand the importance of on-going communications between user/stake-holders, and the technology team for meeting project schedules while providing value added benefits.

Having both strong written and interpersonal communications skills, I consider myself well adapted for contributing to your organizational success. Moreover, as an innovative thinker, and problem resolver, I am well positioned to drive your demanding business initiatives.

SELECTED AREAS OF ACHIEVEMENTS & SKILLS

• Business Analysis / Process Re-Engineering

 DOCUMENTATION: written business use cases, process flows, screen UI/wire frames, requirements traceability, detailed specifications as well as data, gap, process analysis.

 REQUIREMENTS: facilitation of JAD/JAR sessions and collaboration with off shore development teams.

 TESTING: used HP Quality Center/Mercury, test scripts, regression testing, and SQL queries

 TOOLS: used Excel, PPT, UML, Top Team, Visio, SharePoint, MS-PPT, SQL, Tele Logic-DOORS.

 BUSINESS MODELING:

 Business Impact Modeling (BIM): for quantifying benefits for CRM applications

 Master Data Management (MDM) analysis of reference data as a result of mergers/acquisitions, or poor data quality with entity solutions based on linage, definitions, and transactional source.

 Process Reengineering: using data modeling and modifying database design.

 Business Rules Discovery: using data mining, Pareto analysis, and OLAP tools to identify and quantify unknown relationships, as well as identify globally shared business evaluation rules.

• Project Management

 TOOLS & METHODOLOGY: MS-Project, Work Breakdown Structure, Rational Unified Process (RUP), Agile/Scrum, and SDLC

 FINANCIAL & MANAGEMENT: ROI, budgets, Earned Value Analysis, Total Cost of Ownership, resource cost accounting as well as managing risks by presenting weekly status reports.

• Business Intelligence and Data Mining

 SOFTWARE: programmed in SPSS/Clementine, Unix Shell, COBOL, RPG, and SQL

 ADVOCATE: previous Speaker and Chairman at national data warehousing & data mining conventions

 FUNCTIONALITY: clustering, regression, affinity, statistics, and decision trees

 OLAP TOOLS: TieNet, Business Objects, Cognos, Metaphor

• Database - Environments

 ERD/ DESIGN: Entity Relationship Diagrams, Star Schema, 3rd Normal Form, and data modeling.

 RDBMS: Teradata, Oracle, Access, LaserFiche Content/Document Management.

 QUALITY ASSURANCE: documented QA Plan as well as used HP Quality Center/Mercury.

 ENVIRONMENT: Data Warehousing, Data Marts, Operational Data Stores, and legacy systems.

 DATA ANALYSIS: Data mapping/cleansing, Meta data tools.

 ETL TOOLS: Informatica and Oracle Warehouse Builder, FIX, EDI, and XML.

• Brokerage / Financial

 Stock/Equity Plan Administration using Equity Edge software for FAS123 valuation, rights, and taxation.

 Financial & Trading: Series 7, 63, 65; trade settlement, back office operations, production support, customer service, Basel II, Mutual Funds, equities, bonds, options, stock options, and 401-K plans.

PROFESSIONAL HISTORY

1. NYC-DOE *Consultant* Lead: Functional Reqs. & Development

10/2008 – 7/2009 Brooklyn, NY

Managed 5 developers and 2 business analysts for requirements gathering and application development using a customizable governmental software tool call TieNet from Maximus in an Oracle client/server web environment. This NYC Department of Education project required the integration of disparate legacy systems into a consolidated data warehouse with an ASP.NET interface. I was hired to revamp the requirements gathering activities, since the project was behind schedule and the previous manager/lead was released. Accomplishments include:

 Completion of Release 1 development and transferred control to NYC-DOE

 Lead JAD/JAR sessions for requirements gathering.

 Responsible for updating project plan, weekly risk assessment, data governance and well as posting to MS/Project Collaboration and SharePoint.

 Developed templates and managed functional artifacts such as; use cases, data mappings, process flows, test cases, detailed specifications and traceability for both SharePoint and HP Quality Center.

2. LabCorp *Consultant* Lead Business Analyst

02/2008 – 09/2008 Stratford, CT

LabCorp is a major laboratory testing facility that recently purchased Dianon Labs. The proposed ERP environment consisted of marketing, accounting, lab processes, research, and scheduling. Systems infrastructure was based on conversion of multiple DEC Systems into a JAVA based Oracle data warehouse using Business Objects.. Accomplishments include:

 Provided over 30 use cases, several process flows, data mappings, and integration requirements.

 Managed the data mining research activities for clustering locations based on cancer levels.

 Lead JAD/JAR sessions for both CA based users and off shore developers

3. E*Trade Securities *FT Employee* Sr. Stock/Business Analyst

03/2006 - 02/2008 Jersey City, NJ

Our Stock Plan organization provides systems and infrastructure support for corporations to grant/award stock to their employees, as well as the integration to track/report trading activities. I provided hi-value leadership and business requirement/analysis supporting multiple development projects. Affected systems and protocols include; Restricted Stock, Stock Awards, Corporate Bonds, Commercial/Mortgage Loans, Mutual Funds, Equity Edge, FIX, SWIFT, GENIE, and Corporate Action systems. (E*Trade closed their NJ offices during a consolidation in 2008). Additional highlights of individual contributions include:

 Worked for the initial 8 months in the call center supporting trading activity for; equities, bonds, options, as well as support issues, mortgage loans and account management.

 Promoted to a BA position and wrote over 80 use cases with test scenarios for the various projects.

 Reduced the 48 hr lag time to less than 3hrs by providing XML transformation requirements and detailed specifications thru use cases, and work flows regarding mergers, acquisitions, spin-offs, tenders, global trading, and stock splits for the revised Corporate Action System.

 Mentored California and India based developers on understanding of business requirements and SEC compliance by facilitating JAD/JAR design meetings.

 Provided QA testing support regarding systems fixes using ClearQuest and ClearCase.

 Additional responsibility included forecasting weekly profit/loss statements.

4. Ernst & Young *Consultant* Financial Planner/Bus Analyst

01/2004 - 03/2006 Lyndhurst, NJ

Was responsible for financial analysis/services to senior executives (Fortune 200 companies) in the areas of; retirement/educational planning, debt management, stock options, mortgage re-finance, taxes (i.e., estate, income, stock), as well as asset allocation strategies for their investments. Specific responsibilities were:

 Researched, analyzed and documented calculation requirements and use cases for the new Resource Management Tool System which includes; Retirement/Estate Planning, Life/Health Insurance, Retirement Annuities’, Tax Projection, Asset Allocation, and Stock Options.

 Interviewed subject matter experts (SME) to document business requirements and interface to the Navi-Plan and Profiles standard financial planning software.

 Coordinated testing scripts, bug fixes, and user documentation, and interfaced with Cognos and SQL.

5. Wealth Planning Group *Consultant* Agent/Broker

07/2002 - 01/2004 Cranford, NJ

As a newly appointed registered representative I was responsible for sales/marketing of financial and insurance products and services. Primarily I assisted individuals and small business owners in financial planning through comprehensive analysis, asset allocation, financial/estate planning, 401K plans and insurance strategies.

6. Oracle Corporation/Financial Markets *FT-Employee* Project Manager

11/1998 - 05/2002 NYC

Served as a project manager for data warehousing (DW), Data Marts (DM), Operational Data Store (ODS), data mining, and web-based engagements, I managed a professional services team of diverse developers, an analyst at various NYC sites. (As a direct result of the 911 tragedy, this office was closed). Responsibilities include:

 Managed a team of 4 – 7 programmers, and 2 technical writers.

 Managed cost and project related task schedules

 Hands on SDLC management of major financial based projects. Managed a team of diverse developers at various client sites. Specifics projects included; (1) a web based portal for Merrill Lynch; (2) architectural re-design and quality assurance controls for a BONY DW accounting system; (3). Documented user requirements and systems specification for a Chase portfolio management system; as well as a (4) new marketing support system for CommerzBank.

 Sole responsibility for branch technical RFPs and RFI as well as gave presentations and demos to executives for data warehousing and data mining initiatives.

.

7. NCR Corporation *FT-Employee* Executive Business Consultant

05/1991 - 11/1998 Berkeley Heights, NJ

Had responsibility pre-sales support and securing executive relationships through demonstration and implementation of technical innovations and the resulting impact on their operations. Business Impact Modeling was implemented to provide a value assessment of CRM applications to the telecom and retail (Wal-Mart) sectors.

 Business Development: Established technical relationships with AT&T, Sprint, MerrilLynch, Citibank, Singapore Telecom as well as a channel partner with SPSS/Clementine for data mining projects.

 Business Requirements/Modeling: These engagements were primarily aimed at OLAP data models on CRM and FCC Reporting applications for Business Impact Modeling.

 Product Management: Frequent speaker and chairman at several data warehousing/data mining conferences. Also, provided requirements for the new Tera-Miner product

 Data Mining & Analysis: Performed data mining for CRM marketing projects with objected oriented business tools for clustering, statistics, decision trees, affinity relationships, and balanced scorecard.

8. Quotron/Citibank *FT-Employee* Technical Relationship Mgr.

08/1987 - 05/1991 NYC

Responsible for maintaining software/hardware/product relationships between clients, vendors, market data providers, support teams and product marketing. Quotron was the first automated financial market data provider.

 Recognition: Received the Quotron Award for 1990 for re-establishing an emergency mirror image of hardware/software, and market data entitlements as a result of a fire at a client’s location.

9. Dean Witter Reynolds *FT-Employee* Prog/Analyst Fixed Income

10/1984 - 08/1987 NYC

Major duties included leading the migration and conversion efforts from a standalone PC based environment to a UNIX server environment.

Professional Designations & Affiliations Brokerage: Series 7, 63, and 65 Insurance: life and health. Education: BS Mathematics Alabama A&M Univ.:: Operations Research Western Michigan Univ.(incmpl.)

Hobbies & Volunteer Services: Previous speaker/chairman at technical conferences 2009 guest speaker at a major civic event Golf, Jazz/Oldies Meals on Wheels public speaking in high schools

Contact this candidate