SUMMARY:

Confidential is logical and energetic information technology professional with hands - on experience in project management, development, data modeling, analysis, and implementation. She has successfully produced BI vision, strategy and documentation with target completion dates; designed and developed BI data marts, reports, cubes and dashboards along with provided standard naming conventions, dashboard layout, and standard report layouts.

SKILL:

QlikView Version 11: Create dashboard documents, QVDs, and Scheduling

Cognos BI (Series 6 through Cognos 10) - Framework Manager, Report Studio, Analysis Studio, Dashboards, MS Office Suite, ETL Tool Decision Stream, Visio

MS Project, Program and Project Management, Senior Business Analytics

Excellent presentation, verbal and written communication

WORK EXPERIENCE:

Confidential, Bentonville, AR

BI Analyst - QlikView

Responsibilities:

• QlikView v11 - Dashboards, scripting, security, scheduling, building QVDs
• Data modeling
• SQL - SQL Server 2008, 2012

Confidential, Grapevine, TX

BI Consultant

Responsibilities:

• Develop Mobile reporting with drill-through for field management (Cognos 10).
• Perform analysis, Strategy and Plan documentation with target completion dates.
• Develop/Maintain Framework Manager models.
• Develop and implement Cognos BI 8.4 reports using Analysis Studio, Report Studio and Query Studio.
• Develop Dashboards by department - Store Operations, Loss Prevention, and Inventory Control.
• Convert models, reports, dashboards to Cognos 10 while supporting existing Cognos 8.4.1 reporting environment.

Confidential, Bentonville, AR

Lead Technical Consultant

Responsibilities:

• Produce BI Vision, Strategy and Plan documentation with target completion dates.
• Build Framework Manager model with TM1 9.5 as source.
• Develop and implement Cognos BI 8.4 reports using Analysis Studio, Report Studio and Query Studio.
• Develop Dashboards by department - Executive, Finance and Forecaster.

Confidential, Harrisburg, PA

Business Intelligence Consultant

Responsibilities:

• Evaluate data warehouse and current ETL, produce change documentation.
• Produce BI Vision, Strategy and Plan documentation with target completion dates.
• Develop and implement appropriate governance, policy and procedure.
• Interview stakeholders, develop gap analysis.
• Provide standard naming conventions, dashboard layout, and standard report layouts.
• Design and develop reports, cubes and dashboards for initial implementation.
• Develop dashboards based on business unit - Executive, Logistics, Receivables, Payables, IT, Purchasing and Sales.

Technical Environment: MS SQL 2005, Cognos 8.3 convert 8.4 (Feb, 2010), Framework Manager, Report Studio, SQL, Analysis Studio, data modeling

Confidential, Bentonville, AR

Senior Strategy Manager, Business Intelligence - OBIEE

Responsibilities:

• Led Business Intelligence initiative for Confidential .
• Acted as point of contact for customer initiative groups/business units, information systems associates, and consulting firm hired to develop Oracle BI business/presentation layers.
• Facilitated interviews as well as JAD sessions and made key contributions to processes.
• Developed standard attributes, naming conventions, and presentation layouts.
• Introduced core foundation data approach for company data warehouse, laying out data necessary for hierarchy structures and reporting.
• Designed and documented US Operations super center dashboards.
• Guided ISD, business associates, and upper management in multiple areas in new business intelligence process.

Technical Environment: Teradata, DB2, MS SQL 2005, Oracle, Informix, OBIEE/v10, Queryman, SQL, MS Project, MS Office, Clarity, VISIO, Access, Excel, IBM WebSphere, Star schema and dimensional modeling

Confidential, Indianapolis, IN

Senior Business Intelligence Specialist

Responsibilities:

• Held responsibility for creating enterprise data warehouse able to manage multiple currencies and languages, setting up dashboard for global sales division and providing reporting to sales/finance departments.
• Created base for enterprise data warehouse similar to dimension database, hiring contractor to code ETL using MS SQL 2005.
• Analyzed sales data and developed business layer in Cognos Framework Manager, creating star schemas for reporting and set up packages for multiple teams by geography. Oversaw project security.
• Completed enterprise dimension and sales data storage/reporting. Created sales dashboard using Cognos Report Studio in Cognos Connection.
• Presented first demo to company and sales executive management, displaying recent data as well as month-over-month, quarter numbers to date and information in different currencies to enable communication with diverse parties.

Technical Environment: MS SQL 2005, MS SharePoint, Navision, ROI, JDE, Cognos8 to 8.3, Framework Manager, Report Studio, Query Studio, Cognos Connection, Active Directory, SSIS, BIDS, SQL, MS Office, MS Project, VISIO, Access, Excel, Kimball, Star schema and dimensional modeling.

Confidential, Indianapolis, IN

Senior Business Intelligence Specialist

Responsibilities:

• Led BI specialists, setting standards, creating business/presentation layers, and developing standard reports.
• Contributed to production of standard reports for lease and accounting departments. Worked closely with DBA, ETL team, and business customers to create accurate and timely standard reports.
• Developed company data warehouse (CDW) . Provided consolidated data from disparate systems.
• Designed data mart, technical lead, Framework modeler, and report developer for new applications, including sales, general ledger transactions, and inventory/PO applications.
• Documented core applications, defining fields stored in CDW. Developed metadata repository with One Source of Truth concept. Created ad-hoc reporting environment and training materials.
• Generated standard company reports in HTML and PDF formats. Developed dashboards for upper and mid-level management. Trained IT personnel on BI reporting tool.
• Created and maintained Framework Manager models. Developed and migrated new reporting environment, replacing Notes database and reporting.
• Interviewed business owners, gathering requirements for reporting needs. Managed business owner expectations.

Technical Environment: DB2, MS SQL 2005, JDE, PeopleSoft, Cognos Decision Stream, Cognos8 to 8.3, Framework Manager, Report Studio, Query Studio, Analysis Studio, PowerPlay, Transformer, Active Directory, SQL, Lotus Notes, Excel, Access, Visio, MS Project

Confidential, Fort Worth, TX

Manager, Business Intelligence - Cognos 6, 7

Responsibilities:

• Managed team of 15 direct reports in four locations.
• Built creative dashboards for top advertisers.

Technical Environment: Teradata, Perl, Cognos Series 6 to Series 7 (Conversion), Impromptu Catalog and reporting, PowerPlay, Transformer, SQL, MS Project, Visio, Erwin, Access, Excel, WORD

Confidential, Carrollton, TX

Senior Front-End Developer

Responsibilities:

• Served as developer, analyzing existing data marts, creating as well as maintaining reporting standards, and overseeing document process.
• Led data warehouse development and production support for existing warehouse. Analyzed existing data marts, source systems, and business/technical needs to deliver solutions.
• Created Impromptu reports and PowerPlay cubes, distributed on web, performing management and client reporting using Cognos Series 6.
• Managed financials, geographical, statistical, productivity, on-demand, custom, and scheduled reporting. Acted as administrator of Cognos catalog and project lead for converting clients.
• Worked closely with data modelers and DBAs to ensure best practice for reporting needs. Acted as Impromptu catalog administrator. Served as technical and user documentation writer.
• Developed and maintained reporting standards. Mentored new business and technical team members. Acted as project lead for converting clients and adhering to Life Cycle methodology.
• Oversaw data warehouse development and production support of existing warehouse. Obtained knowledge of liability and workers’ compensation business rules. Created new Impromptu reports for new clients.
• Led major conversion initiatives to pull additional source systems into warehouse. Conducted performance modifications to standard and custom Impromptu reports.

Technical Environment: Oracle, Cognos 6 and 7, Impromptu Catalog, Impromptu reports, Cognos Query, Cognos Architect, Cognos Noticecast, PowerPlay, Transformer, SQL, MS Office, MS Project, Visio, Excel, WORD, Kimball methodology.