SUMMARY:

• Over 20 years in IT.
• 13+ years’ experience with Cognos suite of tools.
• Experienced with all aspects of data modeling, report building, and system configuration of Cognos software including experience with
• PowerPlay, Impromptu, DecisionStream & Data Manager (ETL tools), ReportNet, Metrics Manager, Metrics Designer, Framework Manager, Transformer, Connection, UpFront, Configuration Manager, and security and administration tools.
• Experience in Cognos 5.5 through Cognos 10.1.
• Experienced with SQL; experience in database design using Oracle, MS Access & dBase III+
• Highly proficient in designing work processes and customer requirements gathering and routine Oracle database administration tasks
• Prior experience in Novell Network Administration; programming skills in Visual Basic
• Supervisory, Technical Management, and Project Management experience

SOFTWARE/HARDWARE SKILLS:

Cognos products (Decision Stream, Framework Manager, Analysis Studio, Report & Query Studios, PowerPlay, Impromptu, IWR, ReportNet, Cognos Metrics Manager and Metrics Designer, UpFront and Connection (access portal), Access Manager, other Cognos administration tools from version 5 to 10.1), Oracle Enterprise Manager and SQL Plus (versions 8 through 11), TOAD (Tool for Oracle Developers), Visual Basic & VBA, Source Safe, Crystal Reports, various custom control packages, MS Access, dBase III+ & IV.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Cognos Developer

Responsibilities:

• Responsible mentoring current GDIT junior Cognos developers; development of complex queries, ETL and data modeling; automation of scripts and reports; preparation for upgrade from Cognos 8.4 to Cognos 10.2; and server security mitigation issues in preparation of network migration to AFNET.

Confidential

Lead Developer

Responsibilities:

• Responsible for the rapid development and deployment of the Counterdrug Data Mart as a new component of the existing EDW serving ARNG Counterdrug leadership in all US states and territories.
• Working closely with the source system developers as well as with government user groups to gather requirements and request data needed to provide Cognos ad hoc reporting packages and dashboards to seven functional area groups.
• Responsible for deployment to the test environment and for submission of Design Specification (DS) and Software Version Description (SVD) documentation for both production and training implementations.
• Provide guidance and assistance to Cognos developers, testers, database administrators, technical writers and trainer.
• Deployment of this new data mart consists of 42 data tables, 5 reporting packages and over 20 Business Insight dashboards.

Confidential

Sr. Analyst/Lead Developer

Responsibilities:

• Responsible for the development, production and maintenance of business intelligence/decision support and reporting products for Confidential ’s Office of Special Investigation’s SMART - OSI Project (business intelligence and reporting).
• Responsible for requirements gathering, planning, development and testing of new reports, data cubes or other SMART-OSI products. Working closely with clients and users to ensure a complete understanding of expected products.
• Assisted with responsibilities for production (both classified and unclass systems) server maintenance, software upgrades, security, configuration, etc. Responsible for design and implementation of all Extract, Transform & Load (ETL) processes for data warehousing project to consolidate investigative data from various data sources into subject-oriented data marts for efficient reporting. Responsible for the integration of WebI2MS data into existing warehouse.
• Assisted with the day-to-day user assistance with report building and troubleshooting of the Cognos products.
• Provide Cognos training and/or project briefings and presentations to Detachment and Region Commanders as requested by the client.
• Responsible for modeling and framework design for ease of use by others in ad hoc querying. Assist in producing standard and ad hoc reports as requested by the client.

Confidential

Software Engineer

Responsibilities:

• Worked on a Confidential project to develop Access databases for test data and a VB based program to facilitate managerial tracking of information and appropriate notifications. Developed a Windows CE data entry application for Palm Pilot.

Confidential

Software Engineer

Responsibilities:

• Responsible for designing and coding Visual Basic screens to serve as a GUI front end to an IBM host serving all Confidential field offices nationwide
• Responsible for developing, implementing and performing test plans
• Responsible for meeting with clients to determine additional functionality and needs of system/users

Confidential

Office Manager & Proposal Production Manager

Responsibilities:

• Responsibilities included all office management function for an 8(a) company, including purchasing, personnel and benefits administration, proposal production and coordination
• Responsible for supervision of support staff
• Responsible for development and implementation of in-house systems and procedures
• Set up and implemented billing system and procedures for a physician’s office
• Client mailing list application for a self-employed CPA

Confidential

Admin Assist to VP of Marketing

Responsibilities:

• Designed, coded and implemented a menu-driven RFP/Proposal tracking system using dBaseIII+ to generate various reports and request letters