SUMMARY:

Information Technology professional with extensive experience in Business Intelligence and Analysis. Proven ability to act as a liaison between clients and programmers. Adept at programming and Cognos report writing and administration. Expertise in customer service and system conversion. Self motivated, multi tasking, detail oriented with experience on small to medium projects in a government/military/business/clinical setting.

TECHNICAL SKILLS:

8.4, 10.1.1, 11.0.5 (Cognos Analytics)

SQL, Oracle SQL

Report Studio, Query Studio, PowerPlay Studio

Crystal Reports

Framework Manager

Access

Transformer, Powerplay

Toad (SQL tool)

PROFESSIONAL EXPERIENCE:

Confidential

Cognos Developer/Support/Training

• Developed reports/charts/graphs from Business Objects to 11/Cognos Analytics to support migration.
• Trained coworkers familiar with Business Objects.
• Performed Data Analysis utilizing Excel (pivot tables).
• Developed/Modified Cognos reports in 10.
• Performed Data Reporting and analysis utilizing Access.
• Reconciled databases.
• Installed/configured Cognos Transformer (cubes) 10.
• Assisted with installation/configuration of Cognos 10.
• Maintaining Cognos 8.4 production issues utilizing Oracle 10.
• Implemented cube conversion across operating systems from 7 to 8.4.
• Worked with users on Help Desk Incidents.

Confidential

Cognos Support

• Served in various permanent and contract as a COGNOS positions including: Conversion Analyst, Reporting Analyst, Business Analyst, Cognos Administrator, Report Writer at First Citizens Bank, Raleigh, NC; Pergo, Raleigh, NC; Equifirst/TSG, Charlotte, NC; SAIC/TEKSystems, Oak Ridge, TN; AT&T, Research Triangle Park, NC; BASF, Research Triangle Park, NC
• Converted web based Crystal reports utilizing reverse engineering to Cognos web base.
• Extracted & analyzed customer data, assembled reports using Cognos Transformer, Impromptu & Powerplay. Experience with report bursting and drill through reports.
• Converted reports to Cognos Impromptu, obtaining specifications from Crystal reports.
• Supported and administrated 8 server CRN/PowerPlay Cognos environment.
• Administrated Active Directory & Access Manager security.
• Administrated Framework Manager modeling various databases for 500+ users.
• Provided technical support to user community.
• Provided Administrative support during the absence of the administrator.
• Analyzed and modified complex sales reporting systems.
• Authored ad hoc requests from multiple data warehouses using multiple query techniques.

Confidential, Welcome, NC

Cognos Administrator/ Report Writer

• Wrote, supported and administrated Cognos ReportNet (CRN) reports & 7.3 PowerPlay cubes.
• Installed, configured, administered and supported single server CRN/PowerPlay Cognos environment.
• Administrated Access Manager security for 50+ users.
• Set up and supported Query Studio and Report Studio users.
• Administrated Framework Manager model.

Confidential, Raleigh, NC

Business Analyst/Programmer

• Organized IT project for small corporate data warehouse which consisted of bill claims and referral tracking. This included coordination of contract work and support of system. This data warehouse was expanded into the Sybase data warehouse. This system provided hourly turnaround analyzing costs in minutes instead of days as well as allowing non - technical people to access this system.
• Assisted installation of Fee Tracking System including successful coordination with multiple departments. Organized printing phase of billing in medical office.
• Installed and supported in-house Physician Applicant Tracking System to speed up letter processing and improve Recruiters’ ability to keep up with their tasks.
• Organized conversion of Physician Time and Benefit Balance Tracking System including coordination of contract work, analyzing workflow, quality assurance testing and support of system. Providers gained access to timely leave benefit information and added significant accuracy to Payroll System.
• Saved significant amounts of time planning conversion of physician’s Credentialing System for Medical Group so tasks were streamlined.
• Clinical Project/Analytical
• Set up Immunization post card system which increased NC childhood immunization rates to best of 12 Kaiser regions.
• Set up Women’s Health System which increased on-line patient health record information.

Business Consultant

• Provided consulting services to customers including investigating business problems; developing alternate business solutions; evaluating technical risk, operational impact, quality assurance testing and cost/benefits; provided recommendations to the business organization regarding technical solutions in conjunction with cost/benefit analysis.
• Developed functional specifications in coordination with other departments for new software applications as well as enhancements to existing systems in mainframe and LAN environments. Coordinated with programming staff or contractors as needed to successfully implement changes.

Customer Help

• Assisted, as necessary, with critical software application questions, first and second level troubleshooting. Implemented and supervised changes as necessary. Areas included medical offices (Appointment System, Quality Assurance, Immunization, Advice, Medical Records and Pharmacy) and medical group (Human Resources, Applicant Tracking and Credentialing Systems).