Candidate Information Title ITS Senior Manager, Business Intelligence, Power BI Target Location US-OR-Remote	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Senior Associate Sales Manager Oakland, OR Senior UI Developer Remote Business Analyst Senior Winston, OR Senior Data Analyst Remote Senior Business Analyst Remote Manager of HL7 Interfaces Remote, GA Senior Editor Remote

Accomplished IT professional with extensive experience, including expertise in Business Intelligence and Data Warehousing. Spearheaded architecture and implementation of enterprise-level data solutions, enhancing reporting and analytics capabilities at BAE Systems / Ball Aerospace. Seeking a Senior Business Intelligence Developer role to leverage a strong background in ETL processes, data modeling, and system virtualization to drive business insights and strategic decision-making.Work ExperienceBAE Systems, Inc formally Ball Aerospace ITSSenior ITS Manager Lafayette, Colorado/Remote Oct 2018 - Apr 2024Developed an enterprise-level data warehouse, enhancing cross-system reporting and alleviating strain on OLTP systems by establishing Operation Data Stores as a reliable data reference for key systems.Instituted robust data security measures for the data warehouse, including Operational Data Store (ODS) and Data Mart information, while standardizing data modeling practices across reporting structures.Improved Analysis Services databases with refresh optimization and integrated new requirements, enabling Near Real-Time (NRT) data for more timely intraday reporting.Led business intelligence initiatives by managing the BI Data team and maintaining service ownership of multiple reporting and analytics tools, ensuring consistent data stewardship and integrity.Advanced the BI environment by implementing a citizen development program, establishing user training protocols, and streamlining the intake process for new requests, which included the migration of Data Virtualization towards a more exploratory model.Utilized Costpoint 7/8, Velocity, IFS, SharePoint as well as other pillar applications databases from COTS to Custom developed to create complex EDW and BI Reporting objects and data models.Ball Aerospace ITS (Tek Systems)Business Intelligence Developer, Senior Lafayette, Colorado Nov 2017 - Oct 2018Collaborated on the transition from SQL Server 2008R2 to 2017, which included architecting and developing the upgrade strategy, and providing guidance on best practices for virtualizing the Enterprise Data Warehouse.Facilitated the conversion of database components, Integration Services packages, and Analysis Services (OLAP) to SQL Server 2017, while adhering to standardized SDLC protocols and scripting automation to ensure a consistent upgrade process.Developed a standalone Windows application that enabled the seamless conversion of Analysis Services connections in over 20,000 personalized Excel workbooks to the updated 2017 server.CircadenceVirtualization Software Engineer Fort Collins, Colorado Sep 2017 - Nov 2017Developed and deployed Continuous Deployment/Continuous Integration (CD/CI) processes, improving the automation of updates, instantiation, and execution for a diverse virtual environment comprising over 240 machines.Authored comprehensive documentation to support the scalability and maintenance of CD/CI processes, enhancing product growth and lifecycle management.Otter Products, LLCSenior Developer Fort Collins, Colorado Jan 2012 - Sep 2017Managed and improved the availability and operation of Enterprise Data Warehouse (EDW) and reporting systems, ensuring adherence to service level agreements and fostering customer adoption across multiple departments.Executed a successful upgrade from SQL Server 2012 to SQL Server 2016, enhancing system performance and reliability.Designed and implemented a standardized SSIS Package template, improving the efficiency of ETL processes and enabling software engineers to concentrate on core development tasks.Conducted real-time support and performance optimization for the EDW, including database maintenance, log shipping, and replication, while integrating data from diverse sources such as CRM, web analytics, and ERP systems.CEESI (Strategic IT Staffing)Senior Developer / SQL Server DBA Nunn, Colorado Apr 2011 - Jan 2012Enhanced CEESI's Caltrac software by transitioning hard-coded SQL to Entity Framework 4.1, improving maintainability and automating testing procedures.Transitioned all HTML-based reports to SSRS SQL 2008 R2 and performed database modifications adhering to standard SDLC protocols for production deployment.CPS (Tek Systems)Senior Developer / SQL Server DBA Loveland, Colorado Feb 2011 - Apr 2011Transformed legacy Oracle-based ARS product to SQL Server 2008 R2, utilizing SSMA for migration, and streamlined the ETL processes for enhanced data integration, achieving a more efficient batch environment.Refined and optimized SQL and T-SQL scripts for SQL Server, ensuring smooth automation of data import tasks and facilitating sustainable system support by CPS staff.Managed Business Solutions, LLCSenior Developer / Business Intelligence Ft. Collins, Colorado Aug 2006 - Dec 2010Developed and deployed a Business Intelligence (BI) solution for state tax departments, enhancing visibility into taxpayer data, tax income, and mineral production metrics with month-to-date and year-to-date reporting features.Led a team in the creation of a BI platform for a Taft-Hartley organization, streamlining benefits and claims processing, and managing contributions and distributions efficiently.Collaborated in the design and launch of online applications for pension contribution submission and shareholder enrollment, improving operational efficiency through automated processing systems.Research Management Systems, INCSoftware Engineer Ft. Collins, Colorado Mar 2005 - Aug 2006Developed and implemented technical solutions, including comprehensive documentation and end-user support, ensuring seamless integration and user adoption.Enhanced and maintained a multi-state RFID animal identification system, improving data tracking and interfacing with USDA Premises ID registration.Designed and optimized SQL stored procedures and T-SQL scripts, contributing to the robust functionality of both web and desktop applications for GIS-based location tracking.Simple Software Systems, LLCSoftware / Security Consultant Loveland, Colorado Jul 2004 - Mar 2005Delivered comprehensive security consultancy, including network design and system configuration, strengthening the cybersecurity posture of diverse client organizations.Created and conducted educational presentations on security best practices, while also developing tailored desktop and web-based applications to enhance operational efficiency.BlueCross of Idaho (Comsys)Software Engineer Meridian, Idaho Jul 2004 - Jan 2005Developed custom scripts and T-SQL for efficient loading and reporting of Medicare membership updates, adhering to organizational standards for software and documentation.Created a tailored application using VB to facilitate the execution of Facets Run Book batch processes, optimizing operations on the application server within a Sybase 12.5 and Facets 4.01 environment.Bluelight Software, LLCSenior Software Engineer Loveland, Colorado Jul 1999 - Jul 2004Developed a new CRM software compatible with Windows, incorporating n-tier architecture for enhanced scalability and supporting diverse SQL environments, including PSQL, SQL, DB2, and Oracle.Implemented software integration strategies for an existing database, ensuring seamless transition and adoption across more tINChan 175 locations in the US and Canada.BlueCross and BlueShield of ColoradoSenior Software Engineer Ft. Collins / Denver, Colorado Oct 1996 - Jul 1999Developed a quoting system ensuring compliance with state and company underwriting standards, and served as System Administrator for critical servers, ensuring seamless data integration and system functionality.Directed the Data Integration department of 12 consultants, achieving a reduction in monthly overhead from $1.2 million to under $80,000, while improving service delivery and customer satisfaction; provided regular project updates to the Chief Information Officer.Thomas International CorporationSenior Software Engineer Berthoud, Colorado Jul 1994 - Oct 1996Designed and implemented an EDI system to manage the transition and processing of daily U-Haul orders, successfully integrating with the accounting system and streamlining manufacturing requests.Developed a comprehensive MRP system to track production stages from purchasing to sales, while providing technical support and managing raw material procurement for manufacturing.Kenwood Data Systems, INCSoftware Engineer R&D Greeley, Colorado Jul 1993 - Jul 1994Contributed to the realignment of the software and support department, leading to decreased expenses, enhanced revenue, and improved customer satisfaction.Designed and implemented WordPerfect Legal Interface and Medical Billing software, alongside developing a service and inventory control system to monitor hardware performance metrics.Fiscal Information, INCSenior Systems Analyst R & D Loveland, Colorado Feb 1986 - Jul 1993Managed a software support team, successfully reducing a significant backlog by over 92% within a six-month period, enhancing both team productivity and client satisfaction.Led the development of data communication and transfer subsystems for medical billing software, facilitating Medicare, Medicaid, and medical electronic transactions.Delivered robust PC terminal emulation software, facilitating its deployment across 1750 sites nationwide, and contributed to the support of hospital billing and accounting systems.Implemented an in-house time tracking system to streamline client billing processes and conducted comprehensive research and support for hardware and software upgrades.EducationColorado State POSTPOST Certified through AIMS Community College Credits Jul 2007Dale CarnegieManager Development Course, Development course for People Management skills. Fort Collins, CO Oct 1992AIMS CommunityFire Science, Received Fire Science credits through class work for Loveland Volunteer Fire Department. Instructed accredited wildfire courses for Red Card certifications. Fire Officer and Incident Command Loveland, CO Mar 1991Apple Computer CorpMacintosh Software Development, Certified Macintosh Developer California Jul 1988CertificationsColorado POST Larimer County Jul 2007Quality Award Ball Aerospace ITS Jun 2020Meritorious Service Award Larimer County Sheriff's Office Nov 2010Distinguished Service Award Larimer County Sheriff's Office Dec 2023Fire Fighter of the Year Loveland Volunteer Fire Dept Dec 1999SkillsSQL Development, ETL Processes, Data Warehousing, Business Intelligence, Data Analysis, SQL, T-SQL, C#, Pl/SQL,Ssis, Microsoft SQL Server (2019), Oracle, MySQL, Microsoft Power BI Reporting Services, Microsoft Power BIDesktop, SQL Server Data Tools