PROFESSIONAL SUMMARY

• Extensive IT experience, wif the most recent 11 years being in Cognos Business Intelligence.
• Wif Keystone/LKQ Corporation for 21 years as we rose from 35 million to over 4 billion in revenue.
• Extensive training in and utilization of the entire range of BI tools, from Report Studio to Transformer.
• Solid technical, communication and interpersonal skills that have facilitated development through the entire software life cycle.

TECHNICAL SKILLS

• Cognos 10.1
• Cognos Report Studio
• Cognos Transformer
• Cognos Framework Manager
• Cognos Query Studio
• Cognos Analysis Studio
• Cognos Connection
• Cognos Access Manager
• Cognos Administration
• Cognos Metric Studio
• Banner by Ellucian
• Ellucian Degree Works
• TSO Focus
• MS SQL Server
• Oracle Developer
• MITS BI
• IBM Unidata
• UNIX, Informix
• SBS, BASIC
• COBOL, DOS.

PROFESSIONAL EXPERIENCE

Confidential, Riverside, CA

Senior Business Intelligence Developer

Responsibilities:

• Lead Cognos developer on the Cognos reporting team, responsible for converting hundreds of reports from TSO Focus and SQL to Cognos.
• Added tables to the existing packages to give UCR reporting abilities far beyond what was given to them in packages designed by Ellucian.
• Training report writers in some of the more complex Cognos concepts.
• Writing new reports for numerous departments and coleges such as Registration, Admissions, Financial Aid, Colege of Humanities, Arts and Social Sciences, Bourns Colege of Engineering and Colege of Natural and Agricultural Sciences, as well as off - campus entities.
• Am the Cognos representative to the coleges and departments as I train them in the simpler concepts of running the reports and creating report views.
• Designed UCRs Custom Student Data Reporting report which gives them the ability to choose among hundreds of filters and columns to design their own output.
• Tasked wif insuring the team adheres to Business Intelligence Competency Center standards.
• Created a dashboard for the Financial Aid department so they can keep an eye on daily progress.

Confidential, Orange, CA

Senior Reports Analyst

Responsibilities:

• In charge of leading and training the Cognos reporting team.
• Duplicated packages and reports wif new naming conventions as CashCall designed a new company.
• Introduced BICC reporting practices in order to standardize reporting across multiple departments.
• Designed a report library wif Layout Component References.
• Modified packages as needed to serve reporting needs.
• Incorporated pass-through SQL into the models.
• Consolidated reports to simplify the content store.
• Converted reports from Oracle to SQL Server.
• Requested and received access to Cognos from home to monitor issues.
• Documented all new reports and report modifications.
• In charge of report scheduling and maintenance.

Confidential, CA

Lead Cognos BI Developer / Data Architect

Responsibilities:

• Praised in Computerworld Magazine for increasing sales and eliminating overstock.
• Scheduled jobs and reports to burst to static PDF, and to e-mail.
• Used complex master/detail relationships for burst reporting.
• Enlisted style, page render, and block variables for dynamic prompts, output, and report views.
• Designed Dashboard used in all locations, saving 2 hours of labor per branch per day.
• Created “drill throughs” to drill down to reports wif more granularity.
• Inserted HTML items for report-specific flyover help.
• Conditionally displayed red, green, yellow .jpg images dependent on query value as like Metric Studio.
• Used layout component references to refer to objects in “report libraries”.
• Employed .jpg images to bring positive and negative metrics to the forefront.
• Responsible for the design and implementation of OLAP Sales and PO Cubes.
• Utilized star-schema grouping for less foreign keys, fewer joins, and quicker execution time.
• Adhered to Cognos best practice of a database layer, performance layer, and presentation layer.
• Concatenated dimensions to create unique MUNs and avoid uniqueness violations.
• Integral in upgrades to Cognos versions 8.3 and 8.4.
• Corrected execution issues wifin reports due to version differences.
• Standardized reports using Business Intelligence Competency Center best practices.
• In charge of enforcing and maintaining reporting standards.
• Applied member-based security to sales cube using custom views.
• Maintained user profiles in Access Manager to allow for single signon access.
• Used SQL to manually insert, update, or delete rows in security table to allow or deny report access.
• Maintained users, groups, and roles for security.
• Administered Motio CI versioning and regression testing software.
• Updated distribution lists and contacts as necessary for e-mailing reports dependent on CAMID.
• Organized cubes, jobs, master reports, packages, tabs, libraries, and reports using best practices.
• Created tabs, pages, and folders in a manner that creates the most fluid experience for users.
• Used SQL to select and join from various tables to troubleshoot reports and cubes at a datamart level.
• Trained and showed the potential of Analysis Studio to business decision makers.
• Produced emergency “Ad hoc” reports for executives.
• Trained new Cognos team members in using Cognos tools and company procedures.
• Was available for technical support to all users in the field.