PROFESSIONAL SUMMARY:

• My most recent experiences have been related to development, programming, and training in Cognos, an SQL based business intelligence software.
• I have a solid background in support, programming, and use of applications for the PC, and mainframe.
• Most of my experience with PC networks is in the Microsoft Windows environment, although I also have experience with OS/2 and Netware. My mainframe experience consists of MVS/TSO, VM/CMS, and CICS.

PROFESSIONAL EXPERIENCE:

Senior Cognos Developer

Arlington, VA

Confidential

Responsibilities:

• Created a snowflake schema to use as a basis for the framework model.
• Created and maintained framework manager to allow reports related to the project to be created.
• Work with clients to determine business needs and translate the information into useful reports.
• Train users in basic reporting skills.
• Used TOAD to access Oracle databases to find and verify data to be used in the project.
• Create active reports and portal pages to use as an access point for users.
• Demonstrate how the new system works to various user/management groups.
• Update newly created reports as needed.
• Track changes in TFS.

Tax Specialist

Canton, OH

Confidential

Responsibilities:

• Prepare federal, state, and local taxes for clients.
• Enroll non - profit organizations in H&R Block’s fundraising program.
• Discuss tax scenarios with clients to improve future tax year outcomes.
• Explain changes in various tax laws to improve the client’s ability to choose financial options that are right for them.

Cognos Developer

Kirtland, OH

Confidential

Responsibilities:

• Update framework manager with changes necessary for reporting changes, as needed.
• Document requirements for reporting changes.
• Use Cognos 10 to create reports as needed for reporting project.
• Work with clients to determine business needs and translate the information into useful reports.
• Train users in basic reporting skills.
• Use Banner to verify data being used in Cognos reporting.
• Used Argos to verify data being used in Cognos reporting.
• Used TOAD to access Oracle databases to find and verify data to be used in Cognos project.

Cognos Developer

Dallas, TX

Confidential

Responsibilities:

• Update/maintain framework manager as needed.
• Gather requirements for full Cognos system upgrade
• Participate in upgrade process
• Use Cognos 10 to create reports as needed for various projects.
• Work with clients to determine business needs and translate the information into useful reports/applications.
• Maintain existing reports/cubes/dashboards.

Cognos/SSIS/SQL Developer

Warrensville Heights, OH

Confidential

Responsibilities:

• Using Visual Source Safe to complete part of a multi-developer project, allowing SQL scripts to be shared amongst the associates involved in the development.
• Work with other developers sharing documentation via SharePoint.
• Used Microsoft Visual Studio 2005/2008 to create applications.
• Used SQL Server2008 R2 Management Studio to create, edit, and test SQL scripts.
• Use Cognos 10 to create reports as needed for various projects.

Cognos Developer

Westlake, OH

Confidential

Responsibilities:

• Work with client to determine requirements for completing the project.
• Work with client to determine the best course of action to convert reports from various mainframe data sources to Cognos.
• Work with client to determine how data should be joined within Framework Manager to allow a series of reports to be able to be created using data from multiple sources to meet the project requirements.
• Create reports to allow users access to previously unavailable data combinations within individual reports rather than multiple reports, as used previously.

Cognos Developer

Commerce, CA

Confidential

Responsibilities:

• Converting multiple reports from an older version of Cognos to version 8.
• Create and publish powercubes using transformer.
• Update framework manager as needed.
• Add tabs to the Cognos portal
• Maintain users and report security

Cognos Developer

Baltimore, MD

Confidential

Responsibilities:

• Working with client to determine necessary time requirements to create needed reports.
• Informing client of product capabilities to facilitate some future reporting needs.
• Creating reports for a new installation of Cognos version 10.

Cognos Developer

Homestead, PA

 Confidential

Responsibilities:

• Converting multiple reports from an older version of Cognos to version 8.4.

Cognos Developer

Akron, Ohio

Confidential

Responsibilities:

• Converted multiple reports from mainframe systems to Cognos reports.
• Updated framework manager as needed to allow for additional data sources.

Cognos Developer

Canton, Ohio

Confidential

Responsibilities:

• Understanding of best practice systems implementation methodologies and successful experiences in BI reporting projects.
• Strengths in communication/facilitation/interpersonal skills with both business and technical personnel.
• Maintain system functionality on both business critical and non-critical systems.
• Expertise in Cognos 8 BI (Cognos connection, Report Studio, Analysis Studio, Query Studio, Framework Manager).
• Created dimensions, hierarchies, measures, calculations, star schema groupings from relational data source for OLAP analysis in different business areas.
• Developed and maintained reports and cubes using the Cognos software package
• Maintained and supported 500+ financial, production, and business analysis reports
• Managed, developed and supported 30+ OLAP cubes
• Largest cubes were 40+ dimensions containing over 1 million records
• Experienced writing SQL queries
• Experienced working with databases of over 800GB.
• Converted financial reporting system from SAS to Cognos.
• Part of implementation team for new scrap surcharge recovery system using Cognos.
• Converted Cognos reports/cubes for each version change from 4.0 up through 8.3
• Converted multiple reports from mainframe systems to Cognos reports/cubes.
• Participated in multiple upgrades from version 4 through version 8.4.