Summary of Qualifications:

• Proficient with Cognos 8.x and 10.x including Framework Manager, Cognos Connection, Report Studio, Query Studio, and Analysis Studio
• Proficient with Cognos Business Intelligence BI and OLAP software ver 6.0, 6.5, and Series 7 7.0, 7.1, 7.3, and 7.4 including Impromptu, Impromptu Web Reports IWR , Transformer, PowerPlay and PowerPlay Web, Access Manager, Upfront, Cognos Query CQ , Architect, Visualizer, and ReportNet 1.1 MR1
• Experience with Business Objects 6.1a including Infoview, Designer, and Supervisor
• Experience with MicroStrategy 5 6 decision support software including DSS Agent, Server, Broadcaster, and Web
• Experience with Solaris 10 Unix and Microsoft Windows OS 8, 7, Vista, XP, 2000, and Win NT and MS Office Access, Excel, Outlook, Word, PowerPoint, and Visio
• Familiarity with Agile software development concept
• Graduated from Virginia Polytechnic Institute State University - Bachelor's Degree B.S.
• Held 'SECRET' and Public Trust security clearances with various military, law enforcement, and federal clients

Professional Experience:

Confidential

Sr. Business Intelligence Consultant

• Served as a senior Cognos 10.2.1 developer/administrator for the OASIS II contract with Department of Homeland Security-Transportation Security Administration DHS-TSA
• Provide recommendations for capacity planning, installation, and configuration of IBM Cognos software
• Performed quality assurance testing to ensure reporting requirements met
• Responsible for maintaining the Cognos web environment and, in conjunction with other departments, to stop and start Cognos services via Oracle WebLogic Console during network maintenance periods
• Created TSA formatted documentation, test scripts, and maintained change management/version control of documentation via CollabNet
• Assisted in creating backups of reporting environment metadata environment in Framework Manager
• Created Cognos Connection web portal customization using TSA authorized color scheme and branding
• Log and track IBM Support trouble tickets PMRs for issues that arise which are not addressed in documentation or other online technical resources

Confidential Sr. Business Intelligence Consultant

• Served as a senior Cognos 8.4 report developer for the Office of HeadStart the U.S. Dept. of Health and Human Services HHS
• Performed quality assurance testing to ensure reporting requirements are met
• Helped to create summary-detail reporting by implementing multidimensional cubes as an alternative to prompted reports
• Assisted in managing metadata environment in Framework Manager
• Maintained change management/ version control of reports as revisions to reports are made

Confidential Associate

• Hired by Booz Allen Hamilton for the purpose of augmenting Business Intelligence staff in anticipation of DoD contract being awarded
• After waiting two months, no billable work was assigned a position with another company was accepted

Confidential Sr. Business Intelligence Consultant

• Served as a senior Cognos 8.3 report developer for the Drug Enforcement Strategic Target Analysis Review DrugSTAR contract for the U.S. Drug Enforcement Administration DEA
• Assisted in creating reports for the INSPECT project which provides summary level information of key performance indicators on drug enforcement activity across multiple dimensions user class security would ensure data retrieved is consistent with privileges assigned to login credentials reports will provide drill thru capability to transactional data
• Assisted in metadata development within Framework Manager
• Performed SQL validation in Toad to ensure the records displayed in reports are consistent with those in data warehouse
• Performed quality assurance testing to ensure requirements are met
• Created documentation as a deliverable that outlined the functionality and procedures for using the reporting application

Confidential Sr. Business Intelligence Consultant

• Developed Cognos 8.2 reports for the Security Technology Integrated Program STIP contract with the Transportation Security Administration TSA which would provide real time analysis of baggage scans throughout a network of 450 domestic airports and the TSA.
• Performed deployment to Cognos Connection of previously developed Cognos 8 reports via Cognos 8 Administration
• Collaborated with management team and DBAs on designing a data warehouse and content store optimized for reporting
• Maintained version control of reports during development by saving report specifications to Rational ClearQuest
• Helped to create documentation for Cognos 8 reporting and administration

Confidential Sr. Business Intelligence Consultant

• Worked for Defense Technical Information Center DTIC as senior report developer and Cognos administrator responsible for Cognos 8.2 report development via Report Studio/Query Studio
• Assisted in performance tuning reports pulling billions of records from multiple SQL Server 2005 databases
• Administered daily scheduled reports designed to push reports to email accounts to users across DTIC enterprise
• Assisted in maintaining Cognos 8.2 metadata environment via Framework Manager including creation of query subjects, and publishing of packages
• Worked with end users and database administrators to validate reports before deploying to DTIC production environment

Confidential Sr. Business Intelligence Consultant

• Worked for DHS/Immigration and Customs Enforcement ICE Office of Investigations/Executive Information Unit
• Provided technical expertise in the development of ICE reporting applications in Cognos Impromptu, Transformer, and PowerPlay
• Created role based security model for Cognos web portal and batch process script to restore/administer user privileges
• Provided recommendations on streamlining reporting process thru the use of multi-dimensional OLAP reports with drill thru and creating an automated process for running reports via Cognos Scheduler and refreshing PowerPlay cubes
• Served as senior developer for reports used by the Asst. Secretary of Homeland Security to provide Congress historical/statistical information on the effectiveness of law enforcement on immigration and customs related matters

Confidential Sr. Business Intelligence Consultant

• Performed data modeling and created multidimensional OLAP reports for Army National Guard Bureau NGB reporting system
• Built standardized reports linked to NGB TROUPERS and DTMS
• Facilitated transition to DTMS and supported migration from Cognos Series 7 to Cognos 8
• Provided expertise to Army National Guard to provide a reporting application that could track the status of Pre-Mobilization training for individual soldiers as well as the deployment readiness status of units slated for overseas deployment
• Worked to implement viable strategies which Pre-Mobilization training could be recorded and tracked via data capture of Common Access Card CAC issued to Army personnel

Confidential Independent Contractor

• Performed disaster recovery measures to restore enterprise BI reporting environment including complete installation and configuration of Cognos software
• Recovered previously published reports and re-publish them to web portal
• Restored web security by creating a batch maintenance script which re-populated user login credentials and user class associations in Access manager
• Created macros used to schedule the refresh of cubes published to web portal
• Designed and deployed a customized web user interface
• Assisted in gathering requirements for new reports and streamlining the process for creating new reports from those requirements
• Conducted diagnostic system monitoring to optimize SQL and query performance

Confidential Independent Contractor

• Technical subject matter expert SME for Internal Revenue Service IRS PRIME Alliance contract for Enterprise Business Intelligence development and deployment
• Developed automated installation and configuration methodology for Cognos software running in IRS environment
• Performed enterprise software upgrade for IRS's Cognos production environment

Computer Sciences Corporation cont'd

• Developed multi-dimensional OLAP reports designed to monitor system performance of production servers using data collected from production servers at pre-determined intervals and staged in an enterprise datawarehouse
• Responsible for system monitoring and performing Cognos administration on development and production servers
• Analyzed IRS environment, data structure and reporting requirements to develop and provide maintenance for an enterprise system monitoring tool designed to track trends across multiple dimensions and measures
• Developed role based LDAP security model used in conjunction with Cognos Access Manager and maintained users and user class privileges via automated batch maintenance
• Created customized Upfront themes integrated with security model providing users a tailored web interface in both appearance and content based on the privileges granted within the security model

Confidential Senior Business Intelligence Consultant

• Developed and maintained enterprise web reporting solution for Center for Medicare and Medicaid Services CMS consisting of multi-dimensional OLAP, standard, and ad hoc reports
• Developed proof of concept reports illustrating BI software reporting capabilities to assist customer in defining reporting requirements
• Created test scripts for monitoring performance and validating data
• Maintained an automated cube build cycle to streamline data retrieval efficiency for multi-dimensional report analysis
• Developed Cognos Series 7 to ReportNet currently Cognos 8 migration strategy and outlined a systematic approach to enterprise-wide BI software upgrade
• Facilitated Cognos BI to ReportNet transition by implementing Series 7 security via Access Manager/LDAP in ReportNet and transitioning OLAP metadata development from Impromptu to Framework Manager
• Assisted and mentored junior level developers with guidance and supervision to optimize and maintain a multi-server Cognos reporting environment
• Assisted in translating customer's reporting requirements into new business opportunities

Confidential Business Intelligence Consultant

• Responsible for Human Resources web application development and deployment for Office of Personnel Management OPM using Business Objects 6.1a
• Performed data validation and product tuning to ensure compliance with customer's functional reporting requirements
• Created documentation outlining features and functionality of web reporting solution

Confidential Principal Consultant

• Performed information systems needs assessment, information gathering, and recommend appropriate business systems and IT infrastructure for Cognos BI reporting solution
• Recommended best practices for configuring customer's architecture and reporting environment as well as overseeing the deployment and administration of client and web based platform
• Responsible for application development, technical product assistance and product tuning to meet customer's performance and functional requirements
• Performed onsite training of Cognos client and web software
• Cognos certified in Impromptu, Transformer, PowerPlay, Impromptu Web Reports, and PowerPlay Web Level I - BI Author and Level II - BI Admin
• Federal and Dept. of Defense customers include:
• - U. S. Army - PERSCOM, EMILPO, USARC, 88th RSC, eArmyU, SOCOM, ATEC
• - U. S. Navy - NAVFAC, Office of General Counsel, NAVTRAN, Naval Research Lab, Port Hueneme, CA
• - U. S. Air Force - Keesler AFB, Wright-Patterson AFB, Bolling AFB
• - Dept. of Education, Dept. of Commerce, Dept. of Health and Human Services
• - Central Intelligence Agency CIA , National Institute of Health NIH , Defense Finance Administration Service DFAS

Confidential Technical Support Representative

• Provided technical support to licensed customers
• Performed software and database testing to troubleshoot reported problems
• Authored technical documents used as an online knowledge base resource
• Conducted weekly open forum meeting with technical support staff to gather updates on software releases and gather input to resolution of open calls
• Assisted in mentoring incoming technical support staff