Business Intelligence Senior

Robert Camarda

703-***-**** ad74e7@r.postjobfree.com Leesburg, VA 20176 LinkedIn IBM Partner Place

SENIOR BUSINESS INTELLIGENCE ARCHITECT

Innovative Business Intelligence Expert Specializing in Cognos Deployment and Optimization Proven Track Record in Enhancing Analytics Solutions and Reducing Costs Through Strategic AWS and SQL Server Management

Dynamic, results-focused, innovative expert in deploying, updating, supporting, and administering Business Intelligence clients across multiple teams, resulting in optimized analytics solutions. Demonstrated expertise in deploying, updating, supporting, and administering Business Intelligence solutions across diverse teams, including commercial and government sectors. Passionate about optimizing ETL database functions and Cognos capabilities through Agile methodologies, leading to significant performance improvements and cost savings. Hold current Active Security Clearance.

KEY STRENGTHS

Business Intelligence (BI) SQL DBA Continuous Process Improvement

Regulatory Compliance Agile Methodology / Scrum Quality Assurance

Data Warehousing Solution Architecture Data Management

Change Control / Risk Management Software Development & Testing Release Management

ETL DB tuning and optimizations

TECHNICAL PROFICIENCIES

CRM & HR Systems: Talisma CRM, PeopleSoft CRM / CS – EPM, ABRA HR Software, Avaya CRM, Genesis Call Center

Business Intelligence Tools: Cognos BI (Cube Designer, Framework Manager, Report Studio (Relational & Dimensional, Event Studio, Cognos Administration, Workspace, Transformer, Analysis Studio, Cognos for Microsoft Office, Cognos Analysis for Excel); Motio (MotioCI, MotioPI).

Platforms: Universe (Unidata, Pick, AP, D3), Sun Unix, SCO Unix, Symbion, Amazon Web Services (AWS).

Other Tools: SAP Concur, Microsoft Office Suite, MS SQL, Oracle, JIRA, AI, chatGPT

PROFESSIONAL EXPERIENCE

Business Analytics Engineering & Support Concur Technologies (SAP Concur) Reston, VA 4/2021 – 5/2024

Transitioned into new role within Commercial Concur Analytics team for leading brand for integrated travel, expense, and invoice management solutions. Deployed, updated, supported, and administered Concur’s Cognos clients across various teams, including Cognos Engineering and Deployment, Commercial Report Authoring and Support, and Government Migration to next generation. Integral to ensuring seamless operation and evolution of company’s analytics solutions while addressing commercial and government requirements.

Oversaw deployment, updates, support, and administration of over 60,000 companies, 400K+ users, 18 Cognos instances, and over 250 AWS EC2 servers.

Reduced startup and recovery times, increasing customer satisfaction by moving Cognos installation to dedicated share, resulting in 5% reduction in EBS spend.

Pinpointed opportunities for cost savings by streamlining operations and reducing redundancy in Amazon Web Services, reducing annual AWS EBS storage spend by 10 – 15% (over $320K) by leveraging encrypted shared storage for 250+ EC2 instances (320 TB).

Consolidated 17 high cost Microsoft HA SQL Server clusters by moving non-critical data to dedicated standard server, resulting in projected 25% reduction in HA SQL costs and savings on AWS EC2 and Microsoft licenses.

Senior Software Design Engineer in Test – QA in Test Concur Technologies (SAP Concur) Vienna, VA 4/2016 – 4/2021

Focused on optimizing ETL database functions and Cognos Analytics, employing Agile methodology to drive quality testing, identify process improvements, and enhance report development efficiency. Established and recommended standards to maximize performance and efficiency of data warehouse ecosystem and incorporated architectural concepts to design scalable, manageable, and flexible solutions. Leveraged Cognos for data regression, monitored overnight data extracts to ensure more comprehensive issue testing, and maintained updated testing environments while coordinating daily with Scrum team. Implemented process improvements during Cognos Report deployments to minimize errors and reduce complexity.

Streamlined database patching process by creating SQL scripts to check version and reducing testing time, resulting in additional time for development in two-week Agile sprints.

Revitalized complex Cognos report and model deployment process, significantly reducing manual labor and deployment time and improving quality of life for development teams.

Information Architect Strayer University Herndon, VA 9/2003 – 4/2016

Managed entire lifecycle of business intelligence systems and oversaw development, user testing, and production environments of Cognos ecosystems. Installed, configured, and troubleshot multi-server installations. Maintained Sarbanes-Oxley compliance in coordination with auditors. Created and optimized reports using Business Workspace, Report Studio, Event Studio, Transformer, and Analysis Studio.

Built data warehouse from ground up with conformed dimensions and facts using Cognos Data Manager, incorporating slowly changing dimensions while ensuring compliance with regulatory requirements.

Enhanced Cognos ecosystem by integrating new functionalities, including configuring Windows servers, version control software (MotioCI), and SQL Server enterprise machines.

PREVIOUS EXPERIENCE

Systems Analyst Strayer University Arlington, VA

Systems Analyst Andrews Office Products Landover, MD

Systems Analyst Farmtek Hartford, CT

Systems Analyst Successories, Inc. Lombard, IL

Tech Support Alcyona Computer Consulting Hollywood, CA

EDUCATION

Computer Science Coursework California State University – Northridge Northridge, CA

Associate of Arts California College of the Canyons } Valencia, CA

CERTIFICATIONS

Docker for Windows LinkedIn 7/2021

Learning Access 2016 LinkedIn 1/2019

Solutions Architect – Associate (Exam Prep) Amazon } 11/2018

Driven { Independent Structured ClearFit 3/2018

IBM Cognos Analytics Administration Essentials – 2017 IBM 3/2018

IBM Certified Administrator – Cognos 10 BI IBM 2/2018

COMMUNITY DEVELOPMENT

General Member Board Softlyze 8/2018 – 3/2020

RC

Contact this candidate