| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address John Ryland WaySpringfield, Virginia Street Address
EMAIL AVAILABLEPHONE NUMBER AVAILABLESummary of Qualifications:- Experience with data visualization tools such as Qlik Sense Server v 14.97.6, v 13.72.3, Qlik Cloud and Tableau 2019.4.1- Proficient with IBM Cognos Analytics (11.x. 10.x, 8.x, and ReportNet) including Framework Manager, Report Studio, Query Studio, Workspace (Business Insight), Analysis Studio, Event Studio and Cognos Administration- Experience with Toad, Databricks, SQL Server Management Studio (SSMS), and Oracle 11g relational database management system (RDBMS) utilities (SQL Plus/ SQL Developer) to perform data validation, data export, and ETL- Familiarity with Software Development Life Cycle (SDLC) and Agile development methodology- Active DoD SECRET (SF-86) and Public Trust (SF-85P) security clearancesProfessional Experience:Take2 ConsultingVienna, VASr. Business Intelligence Developer1/2023 - Present- Served as Qlik BI developer for three ADVANA projects: Security Cooperation Common Operating Picture (SC-COP), Basing & Logistics Analytics Data Environment (BLADE), and Community Space Leadership Team (CSLT)- Assisted with integration of existing SC-COP dashboard to the Qlik Production Application Standards (QPAS) template which serves as an ADVANA enterprise-wide reporting standard- Revised existing SC-COP dashboard to address immediate display and functionality concerns- Collaborated with SC-COP Qlik development team to develop a business process for parallel development to ensure changes being made by one developer were not overwritten by later changes that were published to the same Dev stream- Tasked with updating Qlik apps and templates for the BLADE project that pulled large volumes of data via On Demand App Generation (ODAG)- Coordinated validation efforts to ensure the data being displayed aligned with the counts the functional SMEs were expecting to see- Interfaced with CSLT leadership to gain access to CSLT Analytics Dev stream and to gather information on the content, layout, and functional requirements from which CSLT dashboards could be developed- After each completed app version was published and presented to CSLT leadership, feedback was used to refine the app through an iterative collaboration processNorthrop Grumman/PeratonFairfax, VASr. Business Intelligence Developer12/2019 12/2022- Served as BI developer for Army Planning, Programming and Budgeting Business Operating System (PPB BOS) project focusing on Tableau/OBIEE/Qlik Sense within an Agile engineering environment- All development occurred in AWS cloud environment requiring knowledge and proficiency with virtual servers and setup/configuration of PuTTY and remote desktop sessions to access reports- Migrated OBIEE reports to Tableau including the mapping of source data through the analysis of OBIEE query log SQL- Created Tableau data source files that mirrored WHERE clause conditions (joins/filters) contained in OBIEE query log SQL before publishing to Tableau Server- Developed reports in Tableau Desktop that emulated the layout, content, and functionality of OBIEE- Used Application Lifecycle Management (ALM) for version control/change management and GitHub to upload software code and instructions for the test team- Used Oracle SQL Developer to validate data appearing in Tableau coincided with the contents of the source tables/views- Created white papers documenting business processes and technical procedures pertaining to the steps a user would need to perform in order to access, complete, or achieve a specific outcome using BI software- Served as BI developer for ADVANA Defense Manpower Data Center (DMDC) assisting with migration of mainframe reports to Qlik Sense by translating SAS to SQL, validating SQL queries in Databricks then using the query as the Qlik data load script used to create reports before validating the results against the original report for accuracy- Created fully interactive dashboards within Qlik Sense as a self-service reporting interface replacing dedicated standardized reports; these dashboards enabled users to create ad hoc reports that illustrate how data for various dimensions relate with one another- Developed a business process for quality assurance testing (QA) to ensure reports being promoted from Dev to Prod were checked in a consistent mannerSwingtech/Blues SkiesFort Belvoir, VASr. Business Intelligence Consultant10/2016 12/2019- Served as lead engineer and subject matter expert (SME) on the integration of Cognos Analytics 11.0.6 within the Office of Chief of Army Reserve (OCAR) to address matters pertaining to strategic equipping of the U.S. Army Reserve- Assisted and facilitated the installation/configuration of IBM Cognos BI 11.0.6 and subsequent upgrade to 11.0.12- Established business process for data cleansing (ETL) for reporting from USAR's systems of record Army Equipping Enterprise System (AE2S) and Force Development Investment Information System (FDIIS)- Designed and developed reports/dashboards to assess the mission preparedness of the Army Reserve through its funding for equipment modernization and training via the Department of Defense budgeting process- Devised and implemented user class security regulating access to content within Cognos Analytics- Provided training and technical support for Cognos end users within OCAR- Documented all Problem Management Reports (PMR's) logged with IBM Support along with the processes for exporting AE2S and FDIIS data, the business process for the creation and periodic updates of data modules used for reporting, and disaster recovery for restoring reports from text files- Briefed senior OCAR leaders on the present/future state of reporting capabilities within the Strategic Equipping Division- Performed data analysis, requirements gathering, and exploring report delivery options on the layout, content, and functionality of reports within Qlik Sense for the Integrated Pay & Personnel System Army (IPPS-A)- Develop Qlik Sense prototypes containing charts, maps, drill thru KPI's, filters and other objects into customized and fully interactive dashboards (i.e. revising HTML and CSS files via Dev Hub) which facilitated the identification of data outliers and trends in the data that I cleansed, transformed and stagedHewlett Packard Enterprise/ActioNetWashington, DCSr. Cognos Developer/Trainer1/2015 9/2016- Served as the Cognos 10.2.2 developer/administrator at the US Department of Energy (DOE) Headquarters, Office of Energy Efficiency Renewable Energy (EERE)- Created and maintained queries, reports and dashboards in IBM Cognos Connection- Performed large scale Cognos Connection folder restructuring in Development and Production reporting environments- Responsible for change management of Framework Manager models in addition to publishing and promotion of packages between development and production environments- Assisted with loading data in SQL Server 2012 and monitoring database jobs to ensure timeliness and accuracy of data- Implemented and maintained detailed documentation of all development and administrative activities in SharePoint- Conducted training classes on the use of IBM Cognos Workspace Advanced where I created the syllabus, training schedule, and authored bi-weekly Tips & Tricks articles emailed to Cognos user communityLiberty IT Solutions (WarriorIT)Springfield, VASr. Business Intelligence Consultant10/2013 10/2014- Served as Cognos 10.2.1 developer/administrator for the OASIS II contract with Department of Homeland Security-Transportation Security Administration (DHS-TSA)- Provided recommendations for capacity planning, installation, and configuration of IBM Cognos software- Performed quality assurance testing to ensure reporting requirements are 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 change management/version control 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- Logged and tracked IBM Support trouble tickets (PMRs) for issues that arise which are not addressed in documentation or other online technical resourcesEagle TechnologiesRosslyn, VASr. Business Intelligence Consultant8/2010 9/2013- Served as a Cognos 8.4 report developer for the U.S. Dept. of Health and Human Services (HHS) Office of HeadStart- Performed quality assurance (QA) 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 madeBooz Allen HamiltonMcLean, VAAssociate6/2010 8/2010- Hired by Booz Allen Hamilton for the purpose of augmenting Business Intelligence staff in anticipation of DoD contract being awarded- After waiting two months with no billable work assigned, a position with another company was acceptedMicrosysPentagon City, VASr. Business Intelligence Consultant9/2009 5/2010- 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 applicationApplied Technologies Corporation (AT-Corp)Crystal City, VASr. Business Intelligence Consultant3/2009 8/2009- Developed Cognos 8.2 reports for the Security Technology Integrated Program (STIP) contract for the Transportation Security Administration (TSA) providing real time analysis of baggage scans across a network of 450 domestic airports- Performed deployment to Cognos Connection of previously developed Cognos 8 reports via Cognos 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- Created documentation for Cognos 8 reporting and administrationComputer Merchant Defense Technical Information CenterFt. Belvoir, VASr. Business Intelligence Consultant9/2008 2/2009- 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 environment3H Technology (Qinetiq North America)Washington, DCSr. Business Intelligence Consultant3/2008 8/2008- 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 mattersCACIArlington, VASr. Business Intelligence Consultant5/2007 3/2008- 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 personnelCB Richard Ellis Regions BankBirmingham, ALIndependent Contractor2/2007 5/2007- 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 performanceComputer Sciences CorporationLanham, MDIndependent Contractor8/2005 2/2007- Served as 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 IRSs Cognos production environment- 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 modelCGI-AMS (American Management Systems)Fairfax, VABusiness Intelligence Consultant5/2004 - 7/2005- 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 customers reporting requirements into new business opportunitiesIntegic Corporation (Northrop Grumman)Fairfax, VABusiness Intelligence Consultant2/2004 - 4/2004- 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 solutionCognos CorporationReston, VAPrincipal Consultant7/2000 - 1/2004- 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- Received Cognos certification in Impromptu, Transformer, PowerPlay, Impromptu Web Reports, and PowerPlay Web (Level I - BI Author and Level II - BI Admin)MicroStrategy IncMcLean, VATechnical Support Representative4/1999 7/2000- 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 staffEducation:Virginia Tech - College of Arts & SciencesB.S. PsychologyB.A. Political Science |
