SUMMARY:

• Challenging role in Information Technology (IT) / Business Intelligence (BI) where I can apply my extensive knowledge to manage and advance new and existing data opportunities, and partner with key stakeholders to evolve and scale information and analytic solutions.
• Information needs assessment
• Data Governance
• Gap Analysis
• Big Data Analytics
• BI Ecosystem Capacity
• Data Management practices and analytics
• Data - driven insight
• Data Analytic environment
• BI Ecosystem expansion / upgrades
• Business Analysis
• Systems Analysis
• Data Analysis
• Information Architecture
• Strategic Planning / Roadmap
• Program and Project Management
• Program Governance
• Interpersonal Communications
• Problem solving
• Market solutions to problems
• Team Development / Restructure
• Business Process Re-engineering
• Teaming/Partnering
• Continuous Process Improvement
• Vendor and Customer Relationship management
• BI Solution selection & implementation
• Operational Governance

TECHNICAL SKILLS:

Software/Programming Languages/Databases/Operating Systems: Cognos MicroStrategy Qlikview OBIEE SQL SAS Enterprise Guide Enterprise Reporter MS Project MS Excel MS PowerPoint MS Word VISIO Erwin Visual Basic COBOL DATATRIEVE FOCUS FORTRAN DCL JCL REXX CICS VSAM ISPF VAX TDMS DBQ ACMS RMS Teradata Oracle DB2 UDB VAX DBMS MS Access SQL Server IMS, RDB IDMS Unix Linux RS 6000 IBM SYSTEM/370 IBM SYSTEM/390 IBM AS/400 DEC ALPHA DEC VAX MVS/TSO OS/390 VM/CMS VMS OpenVMS OS 400 AIX

WORK EXPERIENCE:

Confidential, Culver City, CA

Data Architect Consultant

Responsibilities:

• Retained by Application Enterprise Architecture and Business Relationship to design and document solution founded on service-oriented architecture (SOA) for growing TV business to replace multiple legacy systems and reduce cost of development and maintenance. Created process flows showing how information moved to and from systems such as GPMS, ITSM, and Tigres. Also worked with Business Intelligence Architecture group to document process and procedures, as well as best practices implemented. Utilized Visio heavily to produce diagrams of proposed solutions.

Confidential, El Segundo, CA

BI Solutions Architect

Responsibilities:

• Assessing information needs of Business.
• Interviewed business customers and vendors to determine information gaps for campaign management program. Assessed data needed in Data Warehouse to insource campaign management.
• Documenting information requirements.
• Conducting data analysis using SQL, SAS, Excel, Cognos OBIEE and Informatica to determine accuracy and completeness of data.
• Architecting BI solutions to deliver information to Business.
• Developing prototypes to review solutions with Business.
• Participation in reviewing MDM specifications.
• Acting as program / project manager:
• Led initiative to provide to Finance complete cost of acquiring and servicing customer. This consisted of acquiring and integrating costs for sales orders, work orders, equipment, service and repair, as well as determining how this newly integrated data would be delivered to the business. Finance used the information to influence other Business units' customer care processes.
• Led initiative to provide solution that gave in-depth visibility to Finance of credits and discounts issued to customers. This information enabled Finance to reassess and adjust credit policies for various promotions.
• Led project team through three major infrastructure upgrades, which improved data deliverance by 150%.
• Led project to provide Sales and Marketing with information solution that gave visibility to customers responding to program up-sell initiatives.
• Led BI team and Sales and Marketing partners through insourcing of campaign management program, replacing four vendors with in-house resources skilled in use of SAS, and external vendor skilled in use of UNICA.
• Providing leadership guidance to data integrators to continually improve data integration solutions using Informatica and SQL.
• Implementing formal SLAs and measures to monitor and track to SLAs.
• Partnering with IT Operations group to improve monitoring and alerting tasks for production processes.
• Providing leadership and guidance to establish and maintain Big Data environment, using Cloudera Hadoop as data repository and Teradata Asterdata as big data analytic tool; resulting in reduction of at least $2 million expenditure for expanding enterprise Data Warehouse.
• Partnering with BI peers and IT Enterprise Systems Architect to provide data guidelines for Hadoop, which resulted in consistent guidelines for what data would go into Hadoop repository and what data would be housed in enterprise Data Warehouse.

Confidential, Hollywood, CA

Information Services Consultant

Responsibilities:

• Led Finance project to move sales data from MS Access database into company data warehouse, and design and develop BI solution to provide visibility to actual numbers versus budget versus forecast.
• Reviewed, analyzed and evaluated Sales and Marketing business models.
• Interviewed business units to determine requirements for data, reports, analyses, metadata and performance for resulting Datamart projects.
• Served as liaison between business units and Business Intelligence/Data Warehousing team.
• Formulated solutions to obtain business information that aligned with business goals and objectives.
• Conducted data analysis to align business rules with data acquisition.
• Developed technical designs, conceptual and logical data models, based on business requirements.
• Evaluated SAS Enterprise Guide and Enterprise Reporter software as replacement for MS Access reports.
• Developed MS Access front-end used by business to maintain user-managed information housed in DB2 UDB tables.
• Transformed requirements and technical designs into working applications.
• Used MS Excel and MS Access to create pseudo MDM to document internal and external data elements.

Confidential, El Segundo, CA

Senior Manager

Responsibilities:

• Gathering requirements for customized applications.
• Analyzing and resolving all problems related to Billing application.
• Designing system to track scheduled and completed for personnel, including requirements gathering.
• Designing application to track and generate metrics for problems resolved by problem maintenance team.
• Designing application to track personnel evaluations scheduled and completed.
• Developing applications designs using Visual Basic.

Confidential, Irvine, CA

Programming Supervisor

Responsibilities:

• Supervised five programmers and programmer analysts. In this capacity, provided technical and business direction to programming staff, scheduled and prioritized assignments, conducted design and code reviews, interviewed customers to gather requirements, and resolved operational issues. As working supervisor, designed and developed solutions for overflow problems.

Confidential, Pico Rivera, CA

Project Manager

Responsibilities:

• Worked as project manager and systems analyst for Contracts and Pricing computer support group. Led successful implementation of Spares Pricing System for the Contracts and Pricing organization. Completed project on time and within budget. Generated technical and detailed designs for Spares Pricing System.