SUMMARY:

• Results - oriented IT professional with strong analytical and business intelligence skills. Demonstrated ability to deliver robust, cost-effective, and timely business intelligence solutions to enable better business decisions. Core competencies include:
• Business Intelligence Analyst. Performed analyst role in gathering and identifying the business requirements driving the data warehouse projects. Responsibilities included gathering stakeholder needs and objectives, defining those objectives in technical terms; maintaining stakeholder support in project outcome; end-users on effective use of the tools. Confidential, creatively worked with vastly-overworked and under-informed end-users to define business needs and goals.
• Confidential Architect/Developer Schema specification and data model development; dataset/document/dashboard development, report tuning, data validation and troubleshooting. Create conceptual and logical data model, report and schema objects, and provided troubleshooting for data validation issues.

TECHNICAL SKILLS:

DBMSs: Teradata, DB2, Netezza, SQL Server

CASE tools: SQL Assistant, ERwin, TOAD

BI Tools: Confidential (up to v10.8), Microsoft SQL Server Management Console

PROFESSIONAL EXPERIENCE:

Confidential Architect & Developer/HR Senior Analyst

Confidential

Responsibilities:

• Served as Lead Confidential 10.8 Architect/Developer for Confidential HR Technology and Analytics supporting Store, District, Regional, Divisional, Corporate Human Resources and Store personnel. Developed Confidential schemas for two projects defining attrition, headcount, terms, learning, candidate quality pool, requisition-to-hire process, actual hours vs forecast, associate commitment, and other HR metrics. Developed dashboards for HR corporate, supply chain, and merchandising execution teams. Data sources include DB2, Teradata, and SQL Server.

BI Developer/Project Manager/Data Analyst

Confidential

Responsibilities:

• Served as Data Analyst/Project Manager/Developer Confidential a large telecommunications company, supporting the integration of numerous data warehouses and data sources into a single, conformed platform (multi-terabyte Teradata RDBMS). Also worked with data architecture to support streamlined reporting on various BI Analytical tools ( Confidential, Business Objects, etc.).

BI Project Manager/Developer/Data Analyst

Confidential

Responsibilities:

• Planned, managed, and lead a group of three in the installation/configuration of Confidential 9.4 on Red Hat Linux/DB2/Netezza platform, including implementation of Distribution Services and WAR file customization (website look and feel and external security mechanism). The business focus of the data warehouse/data mart was developing an integrated view of the client across all lines of business (commercial, mid-size business, global corporation, and investment banking).
• BI support for a Real Estate data warehouse. Supporting on-going development team in the Administration and Architect roles, with some FFSQL development. Effort includes reviewing data model to move freeform SQL reports to standard reports/documents, report tuning, creating Schema objects, adding users, object migration/duplication.

Senior BI Developer/Analyst

Confidential

Responsibilities:

• Developed mockups of dashboards for a marketing/leads management application that tracks performance of email, mail, and phone marketing programs into contacts, leads, and products sold for banking industry applications. Used Confidential 9 on SQL Server

Senior BI Developer/Analyst

Confidential

Responsibilities:

• Performed business requirements analysis, BI dashboard/document/report development, report tuning, data validation and defect analysis for the Sales, Labor, Inventory, and Operations divisions Confidential a large Atlanta-based home improvement retailer using Confidential 9 on Teradata and Oracle. Developed dashboards, report services documents, standard reports, and performed some schema object development for an Enterprise Data Warehouse.

Senior BI Developer/Analyst

Confidential

Responsibilities:

• Performed requirements analysis and development, BI report development, report tuning, intensive data validation and defect analysis for the retail division of the United States Postal Service using Confidential 8 on Teradata. Developed standard reports, Report Services documents, and HTML documents for a 28 TB retail data warehouse in a variety of subject areas. Also performed SQL tuning, report performance testing, and recommended data model changes to improve performance.

Senior Production Consultant

Confidential

Responsibilities:

• Provided consulting services for the design and implementation of Confidential BI platform using Confidential 8, including business requirements gathering, functional/technical specification development, data model development, report development and tuning, dashboard development, SDK customization, system installation, and overall project guidance and management. Industries worked with include yellow pages publishing, hospital supply chain/medical outcomes performance, and global distilled beverage retailer.

BI Developer / Developer

Confidential

Responsibilities:

• Provided business requirements analysis, report development, report tuning, specification development, and defect analysis/correction using Confidential 8 on Teradata for the retail division of the United States Postal Service. Developed standard reports, Report Services documents, and HTML documents for a 28 TB retail data warehouse in a variety of subject areas.

Co-owner

Confidential

Responsibilities:

• Provided operations management for a moderately sized veterinary hospital.

BI Business Analyst / Developer

Confidential

Responsibilities:

• Provided data warehouse design and development activities for a telecommunications company using Oracle 8i and Confidential .
• Gathered requirements from internal and external customers; designed, developed and tested reports; improved customer report interface and report validation; resolved data quality issues.

Instructor

Confidential

Responsibilities:

• Developed course materials and labs; provided in-class instruction for the following courses:
• Introductory UNIX / Linux with focus on shell scripting and basic Systems Administration tasks, Introductory C Development, and Fundamentals of Operating Systems.

BI Project Manager / Analyst / Developer

Confidential

Responsibilities:

• Project lead for the implementation of an eCRM solution for Travelocity utilizing real-time visitor profiling system and targeted advertising engine.
• Provided support for in-house data warehouse product development using Confidential, pre-sales requirements analysis, proposal development, and customer presentations.

BI Project Manager / Developer

Confidential

Responsibilities:

• Provided project management and development support for an ordering, provisioning, maintenance & repair performance measurements data warehouse using Confidential and supporting Bellsouth’s entry into the long-distance phone market.

BI Project Manager/Developer

Confidential

Responsibilities:

• Served as project lead on the implementation retail data warehouse and enterprise data warehouse for merchandising, category management, inventory, forecasting, customer relationship management, and loss prevention using Confidential on Informix. Also provided Confidential report development support for ongoing requirements.

Confidential

Responsibilities:

• Worked with defense contractors Logicon, Vitro Services, Raytheon Research and Development Labs, and NKF Engineering for the simulation, development and production of Confidential radar