BUSINESS INTELLIGENCE DATA WAREHOUSING BUSINESS DATA ANALYST DATABASE ADMINISTRATOR

Information technology professional with more than ten years of experience with Business Intelligence products and Data Warehousing along with more than twenty years in Database Administration. Ability to work closely with the Business and various technical teams. Strong desire to work in a position which will enable use of various technical skills and work with both IT and Business teams. Proven team leader as well as team player with ability to adapt quickly to change, multi-task, and welcome challenges.

• Databases: IBM DB2 UDB AIX and zOS , ORACLE, MICROSOFT SQL SERVER, IMS DB/DC, TERADATA
• Operating Systems: MS Windows 2007/XP/2000/NT, UNIX - Sun Solaris, AIX, zOS and MVS/ESA
• Industries: Manufacturing, Food, Telecom, Travel, Software, Consulting Services, Healthcare, Banking

Post Sales, Data Analyst, Business Analyst, Database Administrator, Data Architect, Team Lead

PROFESSIONAL EXPERIENCE Confidential

Senior Consultant Contract

Data Reporting Analyst on a SAP America business team responsible for consolidating financial data from applications for reporting. Will utilize Business Objects for reporting.

Confidential

Data Analyst Contract

• Responsible for successful sourcing of data from various AT T databases to the EDW, DataLake and Operational Data Stores.
• Central point of contact responsible for coordinating data transfer and quality with the Data Stewards, SMEs and ETL teams and ensures appropriate data goes to T.Data analytics database.

Confidential

Senior Consultant Independent

• Work closely with business reviewing reporting environment and make recommendations.
• Perform a variety of roles in for BI / EDW environments.

Confidential

BI Functional Analyst SA

• Worked closely with business reviewing reporting environment and make recommendations.
• Performed a variety of roles in IT for BI / EDW environment.

Confidential

Business Intelligence BI Team, Systems Analyst SA Business Analyst BA / Data Analyst DA

• Interviewed the Business and gathered and documented all data, business and report requirements.
• Completed deliverables used by Data Architects DA as a starting point to create the data models.
• Coordinate all activities between the Business Intelligence BI and Informatica ETL technical development groups, Data Architects, the project manager, and the business user community.

Confidential

Supply Chain Core Architect Team, IT Lead

• Worked with team phasing out Cognos and Hyperion BI products and move to an in-house BI tool and Business Objects BO reducing license fees.
• Implemented and learned second generation BI tool, QlikView, for new reporting by the business.
• Worked with SAP BW Master Data MDM team documenting Metadata and reviewing tools for detailed descriptions.
• Coordinated an effort to consolidate data from numerous Supply Chain applications into a common near real-time Data Warehouse EDW database for reporting. This included requirements gathering BA , data mapping DA , and information to aid with a Star Schema data model.
• Lead status meetings with business and appropriate IT groups in international locations.

Confidential

Senior Data Analyst DA , Contractor

• Completed a Logical Data Model for new system to enable the business to easily create reports.
• Performed Data Analyst DA role gathering and documenting the SENIOR ADMINISTRATOR, Data Integration Requirements in TopTeam for tables in an existing application along with data changes made in a new application while they co-exist.

Confidential

Systems Engineer, Professional Services Post Sales

• Provided Post Sales services for four projects which involved three separate clients. The tasks included product installations, certifications, problem resolution, and other services depending on the client's requirements. The products included interfaces to the Bank Core Systems, ATMs and Point of Sale POS systems. Coordinated weekly calls with clients, management and IT departments, and with other vendors, to identify, prioritize and assign new and open issues as well as customer concerns that may have existed. Confidential Senior Database Administrator DBA / Developer, Knowledge Management BI
• Worked closely communicating with the business groups in a role gathering and documenting data requirements for reporting.
• Performed the Data Analysis DA , Star Schema database design, definition of Metadata, and the implementation of a new SQL Server Datamart Star Schema model enabling the Women and Children's Health reporting by user community.
• Documented the Data Integration rules and developed new Informatica ETL processes which populated tables for a new Enterprise Master Patient Index EMPI application.

Confidential

Senior Consultant, Professional Services - Post Sales

• Performed Post Sales product installations, creation of data mappings, documentation of installation procedures and recommendations, and a transfer of knowledge to the client.
• Provided consulting services to clients and potential customers for the PowerExchange and PowerCenter products.

Confidential

Sr. Consultant, Data Analyst DA Winn Dixie

• Interviewed Sales Planners gathering and documenting data requirements used for Star Schema and Metadata definitions used with BI reports produced later for making business decisions.
• Developed and documented Use Cases for an existing Winn Dixie reporting application which used BRIO for reports and DB2 UDB stored procedures for thje repository.

Confidential

Contractor, Data Analyst DA SunTrust

Identified and documented data pertaining to the Enterprise Data Warehouse EDW project.

Confidential

Senior Administrator - Business Intelligence BI / Data Warehouse Architect DA / Database Administration DBA

• Reduced by 50 the amount of time developers spent developing reports by recommending and implementing the first Business Intelligence BI product which enabled the Business to create many of the reports they needed on their own.
• Provided analysis and guidance for the design of BUSINESS OBJECTS Universe which corresponded with the existing COGNOS environment being replaced.
• Coordinated the work done in the population of the SAP Business Warehouse SAP BW reporting tables with data extracted from 5 major ConAgra Poultry databases using INFORMATICA, COGNOS, and DB2 UDB utilities.
• Provided the SAP migration teams with COGNOS reports the ConAgra Poultry Data Warehouse EDW and the ConAgra production databases which allowed teams to validate the integrity of the data before loading into SAP.
• Team Leader for the successful design and implementation of the Enterprise Data Warehouse EDW, multiple Data Marts for Sales and Finance, and the COGNOS Business Intelligence environment OLAP Cubes, Metadata, etc.
• Performed Business Analyst BA and Data Analyst DA roles in gathering and documenting data requirements for reporting. Also involved close work with the Project Manager.
• Developed and Implemented Informatica ETL procedures and mappings for the population of Data Marts and later the Enterprise Data Warehouse.
• Provided support and assistance to the Credit department with the creation of BUSINESS OBJECTS reports from the ConAgra Foods Corporate Credit Services Data Mart.

Confidential

• Stabilized applications in the eight Poultry plants by replacing existing OS/2 servers with new servers running AIX and by replacing DB2/2 with a new version of DB2 UDB.
• Performed all Database Administration DBA for the ConAgra Poultry DB2 UDB Online Transaction OLTP databases on the AIX and the Mainframe platforms. Responsibilities included database design, implementation, backup and recovery, tuning and performance, and providing SQL guidelines developers.

Confidential

Sr. Database Administrator DBA

• Provided Database Administrator DBA support for OLTP, Decision Support, Marketing, and Security applications' DB2 UDB databases.
• Utilized the Platinum database tools for database changes and the BMC tools to monitor performance.

Confidential

Data Administrator DA , Database Administrator DBA, and Project Manager PM , Consultant

• Designed, developed, and supported a DB2 client server application saving the company two million dollars a week.
• Performed analysis of multiple Data Dictionaries and wrote the Business Case for the purchase of one.
• Project Manager PM / Tech Lead responsible for the successful implementation of the Dunn and Bradstreet General Ledger GL and Human Resources HR applications for all eight subsidiaries of the parent company, National Service Industries NSI .

Confidential

Sr. Database Administrator DBA

• Coordinated all DB2 Database Administrator DBA efforts between groups in Kansas City and Dallas allowing for the successful implementation of a multi-billion dollar government project.
• Provided Database Administration and Data Analyst support for a new Client Server Order Entry application.

Confidential

Sr. Database Administrator DBA

Database Administrator DBA for DB2 UDB and IMS DB/DC vendor and in-house applications.