SUMMARY:

• Top Secret Security Clearances (Department of Defense, 1996)
• Proven problem analysis and resolution skills
• Goal - oriented, team-player
• Detail-oriented, assertive, flexible, strong self-initiative

TECHNICAL SKILLS:

Knowledge: Access, SQL Server, Oracle 9i, DB2, Cognos BI Suite (Versions 5, 6, 7 & 8) including ReportNet, Framework Manager, Impromptu, Data Manager, Powerplay, Access Manager, Upfront, PowerPlay Enterprise Server, Impromptu Web Reports, Transformer, Vizualizer, EnvisN, Lotus Notes, NT and Microsoft Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Cognos Administrator

Responsibilities:

• Developed ReportNet reports for a variety of Spherion clients in Test environment
• Developed and deployed cubes, Framework Manager projects/packages and reports from Development, Test and Production environments to Cognos Connection (DB2)
• Performed troubleshooting of reporting issues for Junior Developers
• Added users and maintain LDAP for external clients (SunOne)
• Validated security settings on packages and cubes
• Opened tickets with Cognos as needed
• Developed documents for external clients on how to set up their environment to run Cognos reports and queries
• “On-call” for customer support on Cognos-related issues

Confidential, Boise, ID

Cognos Administrator (Cognos 7.3 and Cognos8)

Responsibilities:

• Added users and maintain LDAP (Access Manager)
• Deployed cubes, packages, libraries from Development and Test environments to Cognos Connection (DB2 and Oracle)
• Validated security settings on packages and cubes
• Performed troubleshooting issues for Developers
• Scheduled deployment of Cognos hot sites to environments
• Tested hot sites and impact on environments
• Installed software for

Confidential

Business Intelligence Administrator (Cognos 7.3)

Responsibilities:

• Gathered requirements for reports/cubes
• Developed, tested and assigned security/views to cubes (Oracle 9i)
• Published cubes to Upfront
• Monitored Cognos Application Server
• Ensured nightly back-ups of Application Server
• Developed and maintained security using Access Manager
• Utilized Envisn (DocuVisn and AutoVisn) to plan upgrade and migration from Impromptu to ReportNet
• Prepared departmental-customized for intermediate users of Impromptu
• Prepared material for ReportNet community
• Planned implementation of ReportNet
• Developed, with DBA, Oracle tables to be brought into Cognos catalogs (and projects)
• POC for issues with PowerPlay, Upfront, Impromptu, ReportNet and Scheduler

Confidential

Cognos Instructor

Responsibilities:

• Installed ReportNet and configured SQL Server at facilities
• Instructed ReportNet and PowerPlay classes to a variety of clients throughout the US

Confidential, Orlando, FL

Cognos Consultant

Responsibilities:

• Developed a security and strategy for Landstars’ deployment of Cognos cubes over fractional T1

Confidential, Richmond, VA

Business Systems Analyst

Responsibilities:

• Created and updated catalogs (Cognos series 7)
• Developed Impromptu Web Reports (IWR) and PowerPlay cubes for Alternative Lending and Consumer Lending Services
• Validated reports using SQL queries against Oracle database to verify table joins

Confidential, San Diego, CA

Programmer Analyst

Responsibilities:

• Created catalogs, including prompts, filters and calculations for: CRM, Finance, Accounting and Operations Divisions (Cognos series 6 and 7)
• Tested reports using Siebel queries and SQL statements to verify data results (against Oracle database)
• Assigned User Classes and privileges in Access Manager for Development, Test and Production environments
• Developed Impromptu reports for CRM, Finance and Operations Division
• Deploy reports to Intranet via IWR
• Created PowerPlay cubes and reports as demonstrations for Division Managers
• Trained Business Process Analysts (BPAs) and end-users to use Cognos applications
• Recommended model changes to data mart

Confidential

Cognos Developer

Responsibilities:

• Assisted DBA in design and development of datamart
• Developed Cognos Impromptu Reports for Gold Crown Club International
• Created PowerPlay Transformer models and cubes for deployment to intranet
• Published reports and cubes in PowerPlay Enterprise Server to Upfront
• Created and assigned user classes and privileges in Access Manager

Confidential, Ogden, Utah

Cognos Subject Matter Expert/Project Management

Responsibilities:

• Managed and coordinated Cognos-related development projects
• Developed and instructed customized Cognos classes
• Developed and documented emergency backup procedures
• Point of contact for all Cognos-related questions from other DoD agencies
• Applied security to user groups
• Deployed reports to Intranet

Confidential, Burlington, MA

Professional Services Consultant/Project Manager

Responsibilities:

• Designed, developed, tested and deployed:
• Customer Relationship Management (CRM) applications using SQL for Cognos partners
• Tracking applications using teradata
• Installed and configured Cognos BI applications
• Set Customer expectations
• Prepared customized for clients (CBTs)
• Instructed classes on all core Cognos BI applications (Impromptu, IWR,PowerPlay Client and Web, and PowerPlay Transformation Server)
• Catalogs, reports and multidimensional cubes using Cognos Suite Web and Client development tools Reports to Intranet Data marts to be used with Business Intelligence

Confidential, Falls Church, VA

Senior Consultant - OLAP

Responsibilities:

• Analyzed and manipulated Department of Defense (DoD) medical data from a SQL server database
• Designed multidimensional cubes and created database catalogs using Cognos tools - Impromptu and PowerPlay
• Coordinated deliverables with DoD vendors
• Published Intranet and Excel reports to support executives in their BI decision making process
• Communicated with web and Visual Basic developers to apply Cognos Suite Web development tools
• Set expectations for external and internal clients

Confidential, Westminster, CA

Business Analyst (Finance)

Responsibilities:

• Managed financial data
• Projected departmental budgets for Y2K
• Developed requirements for Human Resource Department
• Converted historical information into manageable spreadsheets

Confidential, Lexington, KY

Business Analyst/Project Leader (Accounting)

Responsibilities:

• Utilized PeopleSoft (HRMS and Financial Modules)
• Utilized Cognos Suite of tools for ad hoc database querying, report writing, database analysis, and multidimensional OLAP analysis.
• Researched and targeted specific areas of the Intranet/Internet for securityMaintained General Ledger and identified subsidiary ledgers affected by transactions
• Served as technical trouble-shooter for hardware and software issues related to PeopleSoft and Cognos applications

Confidential, Indianapolis, IN

Managing Consultant

Responsibilities:

• Developed and integrated database information
• Analyzed and validated financial information
• Developed curriculum and provided hands-on instruction on the use of the web, including Confidential Intranet and Internet
• Liaison to staffing agency and Confidential headquarters for the purpose of hiring new consultants

Confidential, Fort Benjamin Harrison, IN

Business Analyst/Project Leader

Responsibilities:

• Identified, developed and executed the annual budget
• Developed Command Budget Estimates (CBE)
• Developed database for intranet reporting
• Designed and developed programs in Dbase III and IV to generate automated reports
• Developed input screens for Division Chiefs and Admin. Assistants to enter accounting-related requests
• Prepared and presented weekly budget reports and charts
• Prepared monthly, quarterly and annual reports from an automated accounting system
• Processed accounting-related requests according to Army Regulations and Division budget guidelines
• Built, developed and maintained project plans for Command and Operations' Divisions
• Leader, Developed modules on a variety of internally-created software applications
• Instructed classes on software applications
• Provided hands-on to associates on how to merge databases
• Management Analyst, Researched and analyzed business rules
• Prepared and maintained reports
• Prepared and presented briefings to executives
• Identified developing trends in accounting expenditures

Confidential, Fort Benjamin Harrison, IN

Management Assistant

Responsibilities:

• Developed and maintained internal accounting software detailing accounting expenditures for Task Force
• Prepared budget proposal based on fiscal year project plans
• Prepared and presented briefings to executives

Confidential, IndianapolisIN

Accounting Technician (Payable and Receivable)

Responsibilities:

• Researched and analyzed accounts payable and receivable
• Developed accounting spreadsheet to assist Junior Technicians compute interest
• Tested CAPS-W (Commercial Accounts Payable for Windows) software
• Recommended modifications for CAPS-W
• Assisted in development of detailed accounting reports