SUMMARY:

• Senior Business Intelligence specialist leverages experience from requirements solicitation, data analysis, solution implementation, and client support to identify and fulfill business intelligence needs.
• Skilled at interfacing between business clients and technical resources.
• Accomplished in and creating technical documentation for both users and support personnel.
• Knowledgeable in Enterprise Operations Accounting, Call Center Technology, Consumer/Industrial Products Supply Chain, Travel & Expense Tracking/Auditing, Live Event Technical Support & Coordination.

TECHNICAL SKILLS:

Business Intelligence Tools and Software Development: - Oracle Business Intelligence Enterprise Edition (OBIEE) v.10/11/12c; Oracle Fusion Middleware; Oracle WebLogic Server; SQL Developer; Discoverer 4/4i - Crystal Reports Professional/Enterprise 6/7.5/8.5/9.0/10.0/ XIR2; Seagate Info/Crystal Decisions 7/7.5/9.0 - Microsoft Visual Studio; Visual Basic for Applications; WinZip; Tortoise SVN version control Productivity Suites, Operating Systems, and Databases - Microsoft Excel, Word, PowerPoint, Access, FrontPage, Outlook, Project, Visio - Windows NT, XP, Vista, 7, 8; Windows 2000 Workstation; Windows 2000 Server; Android 3/4 - Microsoft SQL 6.5/2005 & Enterprise Manager/Management Studio; Oracle 8i/10g/11g/12g; SQL Plus Communications, Internet and Remote Access - Microsoft Outlook 2010/2013; Lotus Notes 6.5; Internet Explorer v.7/8/9/10/11 - Citrix v.9.15; Microsoft Terminal Server v.4; Cisco VPN Client v.5; PCAnywhere32; Carbon Copy v.5.5 - Wireless Office Professional v.4 automated paging and messaging distribution

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Senior Business Intelligence Analyst, IT Solutions Delivery

Responsibilities:

• Managed a complete Oracle Business Intelligence enterprise implementation.
• Core infrastructure installation across 3 Linux OS environments (development, test, production). Security design - compliant with corporate HR data standards. Business requirements acquisition and conversion to technical specifications. Architecture execution - metadata mapping, repository configuration, user reports. User - curriculum development and delivery.
• Developed 9 functional subject areas: Accounting - AP/AR (Oracle EBS), Business Development, Finance (Essbase cube source), Human Resources, OBSDATA (operations field metrics data/SCADA), Procurement, Safety, Service Requests (Maximo data source), Ticketing (operations activity).

Confidential, Norcross, GA

Senior Business Intelligence Consultant, JD Edwards Practice

Responsibilities:

• Primary consultant for 9 clients on business processes and accounting practices to customize Oracle BI implementations based on JD Edwards enterprise systems.
• Designed and delivered client-specific BI system user and administrator .
• Mentored junior consultants in BI practice standards and client interaction.

Confidential, Alpharetta, GA

Senior EDW Reporting Analyst, Corporate Standardization Initiative (CSI)

Responsibilities:

• Built a customer satisfaction survey process for commercial business installations, using OBIEE reporting to create survey candidate lists, web-based tools to deliver surveys and gather responses, and Visual Basic to automate retrieval, storage, and reporting of results.
• Initiated a general audit of the corporate reporting system after discovering errors in metadata formulae.
• Designed and implemented an emergency reporting disaster recovery plan when the enterprise data warehouse corrupted.
• Migrated a system processing over 15.8 million calls per month (2010) from legacy ASP/web-based performance metrics, real-time statistics, and operational business reporting to the new Oracle Business Intelligence (OBIEE) platform.
• Constructed a Lead Generation management reporting system for a new Contact Center revenue initiative, including creating a Lab Guidebook and client’s Business Analyst to support the system.
• Designed and implemented a 3-tiered online user help system within OBIEE using interactive JavaScript and HTML embedded in XML.

Confidential, Northridge, CA

Buyer/Seller of Food Commodities

Responsibilities:

• Purchased branded food inventories (excess stock, close-outs, packaging changes, and short shelf life products) from the largest U.S. food manufacturers, selling to a select group of secondary market retailers in strict compliance with manufacturers’ geographic and channel restrictions.

Confidential, Atlanta, GA

Crystal Reports Developer

Responsibilities:

• Created and updated Crystal Reports XI content for embedded use within a telecommunications sales and service application, sourced from a Microsoft SQL 2005 database.

Confidential, Atlanta, GA

Crystal Reports Developer

Responsibilities:

• TravelSmart Expense Accounting - Updated a reports collection after functional application upgrade.
• Human Resources Workplace Fairness & Solutions - Created compliance auditing reports from Lotus Notes 6.5 database; Created user manual and technical support documentation.

Supply Chain Consultant

Confidential

Responsibilities:

• Coordinated $10M+ annual sales of Confidential North America special circumstance inventory (short shelf life, discontinued, excess, seasonal) to national secondary markets.
• Built ETL processes using Visual Basic for Applications to automate the selection and sales of special circumstance inventory to the secondary retail market.

Confidential, Atlanta, GA

Crystal Reports Developer

Responsibilities:

• Contributed to a team-built proprietary .NET enterprise web application by creating/integrating Crystal Reports 10 runtime components from XSD/XML schema and SQL Server 2000 database.
• Built an interactive Access to SQL Server interface for metadata testing and troubleshooting.
• Developed two metrics reporting and diagnostics tools with MS SQL Server and Crystal to monitor the usage and health of the primary scheduling application and custom .NET reporting framework.
• Coordinated and conducted two sessions of transition for internal application support personnel to maintain the proprietary .NET application with MS SQL, XML, and Crystal components.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Developed custom set of Crystal Reports v.8.5/9.0 for new paperless travel & expense accounting system.
• Conducted forensic auditing of database (Oracle 8i) to identify and resolve discrepancies.
• Coached in-house IT staff on architecting Crystal Enterprise 9 environment and security for internal clients.
• Supported Six Sigma project with statistical samplings of expense data.

Confidential, Alpharetta, GA

Business Applications Administrator

Responsibilities:

• Developed and maintained Seagate Info 7.5 web-enabled enterprise reporting system for 4 international call centers, processing 200k+ inbound contacts/year (2001) from a client base growing 100%+ annually.
• Directly serviced 12 clients by gathering requirements, creating logistical and financial reports, and providing ongoing support using Crystal Reports 7.5 in a mixed SQL Server 6.5/Oracle 8i environment.
• Created cost reduction opportunities by integrating accounting data with operations detail using Crystal Reports 7.5 and Maximo.
• Upgraded Seagate Info 7.0 system database from Microsoft Access to SQL Server 6.5.
• Upgraded Seagate Info 7.0 (single server) to 7.5 (3-server cluster) in Windows 2000 Server environment.

Confidential, Alpharetta, GA

Technical Consultant

Responsibilities:

• Initiated intranet-based client access to Seagate Info 6.0 system to accelerate information distribution.
• Developed data recording & analysis tools for conducting email-based Customer Satisfaction surveys.
• Developed Excel model to plan staffing requirements based upon anticipated call volume.
• Automated standard report generation using Visual Basic.

Confidential, Atlanta, GA

Technical Instructor

Responsibilities:

• Primary Atlanta instructor for A+ PC Technician, exceeding 97% pass ratio.
• Conducted internal “Train the Trainer” program to help grow the division to 13 centers nationally.

Confidential, Atlanta, GA

Operations Manager

Responsibilities:

• Planned and managed the company’s largest historical assemblage of personnel, equipment, and logistics to install and operate 13 venues during Atlanta’s 1996 Olympic Games.
• Full charge responsibility for all rental operations (employees, independent contractors, cross-rental negotiations, customer service supervision, billing verification, warehouse performance).

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Performed data integrity analyses for a PeopleSoft migration of the global accounting system, using Crystal Reports 6.0 to output results.

Information Systems Support

Confidential

Responsibilities:

• Supported $100 million in annual consumer production as data and logistics liaison with manufacturing partners, distribution centers, and finance departments.
• Reduced the production planning cycle time from 4+ hours to 20 minutes by automating manual steps with Visual Basic for Applications.
• Maintained and documented data flow between Optimal Planner and Master Scheduler (production and distribution modeling) and AS400 PRISM database, including monthly validation of demand forecast.

Geographic Information Systems Support

Confidential

Responsibilities:

• Created 4,000+ site maps for field auditors using MapInfo for the national Burger King QA project.