PROFESSIONAL SUMMARY:

A senior IT professional who has held various roles including: business systems analyst, data analyst, tester, technical writer, trainer, developer, and financial analyst. Over 28 years experience supporting the business needs and requests throughout the development process of data warehouses, mainframe, client server systems, and e - commerce web sites across a wide range of industries.

SKILLS, CORE KNOWLEDGE, & INDUSTRY EXPERIENCE:

Business Systems AnalystData WarehousingFinancial Industry

Data AnalystWriting RequirementsRetail

TesterData Mapping & Data AnalysisGovernment

Technical WriterInterviewing and CommunicationMortgage

DeveloperTroubleshootingE-Commerce

SOFTWARE & DATABASES:

DOORSORACLETeradata

MicroStrategyHPQCAgile

Rational Clear QuestSQL & PL/SQLAccess

VisioTraditional Microsoft ProductsRDW & RMS

PROJECT/WORK EXPERIENCE:

Confidential, San Francisco, CA

Business Analyst/Data Mapper

Responsibilities:

• Understanding data model (Oracle Financial Services Analytical Application) and regulatory lineage for product area.
• Data source analysis and recommendations
• Overseeing mapping of all non-GL data to OFSAA model for use in reporting
• Coordinating Master/Reference Data sourcing and conforming
• Creating documentation like Business Requirements Documents, Agile features and user stories.

Sr. Business Analyst

Confidential

Responsibilities:

• Primary duty was to bring in data from the Business Banking Group and prep it for delivery in to a downstream database as part of the Confidential Customer Due Diligence Consent Order.
• Other duties included: Writing Business Requirement Documents and Functional Specification Documents, mapping documents, writing test cases and performing testing.
• Data warehouse specializing in the Fraud Data Collection Store.
• Primary duty was to bring in data from different sources and blend it in to Teradata data warehouse.
• Business Enabler's role primarily a business and data analyst, along with some more technical duties as data modeler, writing pseudo ETL code, and testing.

Confidential, McLean, Virginia

Senior Business Analyst and UAT Tester

Responsibilities:

• Wrote and cleaned-up business requirements for MISMO changes to the Confidential Selling System software.
• Created test scenarios for delivery rules and standards for specific mortgage products and programs.
• Performed UAT testing on various parts of the client interface system. Tasks included setting up various loan states and contracts, tested imports and exports, tested various rules cases and SCC code breakout and recreation.

Confidential, Herndon, Virginia

Senior Business Analyst

Responsibilities:

• Main responsibilities include writing business requirements, process flows, context diagrams, and data mapping.
• Performed analysis and wrote impact statements for a number of key issues and defects.
• In charge of updating and managing the program’s Master Business Data Dictionary for each of my releases.

Confidential, Newport Beach, CA

Senior Business Analyst

Responsibilities:

• Main responsibilities include writing use cases, narratives, business requirements, data analysis and mapping.
• Created test plans, test cases, and scenarios for user interfaces and system processing.
• I am not only learning the technical parts of the system, but also learning about mortgages, accounting, SOX Compliancy and finance within the secondary mortgage industry.

Confidential, Rockville, Maryland

Senior Business/Data Analyst

Responsibilities:

• Designed Microstrategy report specifications, performing data analysis, data mapping, gathering requirements, running JAD sessions, writing queries for testing and troubleshooting, and documentation of POS ONE (Point Of Sale source) to Retail Data Mart (data warehouse) process (ETL) and transformations.
• Created reports to study and analyze retail spending habits, worker performance, and fraud.
• During this time, I spent four years on the Retail side of the warehouse and one year on the Accounting Data Mart (Sales Audit & General Ledger projects.)

Confidential, Phoenix, Arizona

Business Systems Analyst and Oracle Developer

Responsibilities:

• I was assigned to Sales Audit team where my duties as business systems analyst were to design PL/SQL procedures and Oracle reports.
• After the design phase was complete I was assigned to the build team to build the procedures and reports I designed.
• My duties ran from gathering business/user requirements, data analysis, developing detail design documents, developer and testing. I was able to gained experience working with Confidential RETEK Data Warehouse (RDW 9.0) and Retail Merchandising System (RMS).

Confidential, Scottsdale, Arizona

Business Systems Analyst/Developer

Responsibilities:

• As part of a small team, I was exposed to many of the technical issues and concerns (both hardware and software) that come with building an e-commerce web site.
• My duties included design and development of ASP web pages with a SQL database, dynamic HTML pages, site navigation and design.

Confidential, Scottsdale, Arizona

Business Analyst and Technical Writer

Responsibilities:

• Developed and wrote web-based contextual help sections and guides for the company’s new web site.
• The content needed to anticipate site-visitor needs across a broad Information Architecture and will address multiple audiences and Web sophistication levels.
• Developed test plans and scenarios for new web site and then lead one of the test teams.

Confidential, Foster City, California

Senior Business and Data Analyst

Responsibilities:

• Analysis work on Confidential clearing and settling processing and reporting systems.
• Was brought in to learn systems on my own and then identify discrepancies between two separate reporting systems.
• My work consisted of data mapping, system and data analysis.
• Assisted in the development of business processes, tools and desktop software for a major promotional venture.
• Technical advisor and analyst on the development of a worldwide co-branded card for a major airline.
• This role also called for writing requirements, running JAD sessions, system design, EDI design, data mapping, user acceptance testing, and user turnover documentation. Projects included:
• Conversion of non IV-D cases into IV-D case system. Had to analyze the 15 different county processes and data formats for conversion.
• Development of a State Case Registry entry system.
• Development of Workers Compensation Intercept. Designed and developed an electronic data interchange (EDI) process between state agencies to intercept workers compensation payments for delinquent child support.
• Worked on Arizona’s ATLAS project, developing and writing selected sections of the users’ batch documentation manual.
• Performed wide variety of functions such as: Writing requirements, system design & analysis, project leader, user acceptance testing, troubleshooting, training, client contact, data analysis.
• Other duties included stabilizing countries for overseas production, which included answering queries, documentation, designing training manuals and classes, and turnover planning.