| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLE Leesburg, VA Street Address LinkedIn IBM Partner PlaceSENIOR BUSINESS INTELLIGENCE ARCHITECTInnovative 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 ManagementDynamic, 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 STRENGTHSBusiness Intelligence (BI) SQL DBA Continuous Process ImprovementRegulatory Compliance Agile Methodology / Scrum Quality AssuranceData Warehousing Solution Architecture Data ManagementChange Control / Risk Management Software Development & Testing Release ManagementETL DB tuning and optimizationsTECHNICAL PROFICIENCIESCRM & HR Systems: Talisma CRM, PeopleSoft CRM / CS EPM, ABRA HR Software, Avaya CRM, Genesis Call CenterBusiness 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, chatGPTPROFESSIONAL EXPERIENCEBusiness Analytics Engineering & Support Concur Technologies (SAP Concur) Reston, VA 4/2021 5/2024Transitioned into new role within Commercial Concur Analytics team for leading brand for integrated travel, expense, and invoice management solutions. Deployed, updated, supported, and administered Concurs 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 companys 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/2021Focused 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/2016Managed 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 EXPERIENCESystems Analyst Strayer University Arlington, VASystems Analyst Andrews Office Products Landover, MDSystems Analyst Farmtek Hartford, CTSystems Analyst Successories, Inc. Lombard, ILTech Support Alcyona Computer Consulting Hollywood, CAEDUCATIONComputer Science Coursework California State University Northridge Northridge, CAAssociate of Arts California College of the Canyons } Valencia, CACERTIFICATIONSDocker for Windows LinkedIn 7/2021Learning Access 2016 LinkedIn 1/2019Solutions Architect Associate (Exam Prep) Amazon } 11/2018Driven { Independent Structured ClearFit 3/2018IBM Cognos Analytics Administration Essentials 2017 IBM 3/2018IBM Certified Administrator Cognos 10 BI IBM 2/2018COMMUNITY DEVELOPMENTGeneral Member Board Softlyze 8/2018 3/2020RC |
