Profiles search
Cameron Loepker
CISSP, GSLC
Indianapolis, IN, United States
Details
Education:
Master of Business Administration - MBA
Concentration in Cybersecurity
Excelsior College
2014 : 2016
Bachelor of Arts - BA
History and Computer Science
Indiana University–Purdue University Indianapolis
2009 : 2013
Honors Diploma
Lafayette Catholic School System
2004 : 2008
Concentration in Cybersecurity
Excelsior College
2014 : 2016
Bachelor of Arts - BA
History and Computer Science
Indiana University–Purdue University Indianapolis
2009 : 2013
Honors Diploma
Lafayette Catholic School System
2004 : 2008
Experience:
2021 : Present
Indiana Department of Revenue
Information Security Manager
2020 : 2021
Indiana Department of Revenue
Senior Information Security Analyst
Scope : Data Governance, Data Modelling, Development, Technical Writing, Process Improvement, Agile Development, OBIEE Reports/Analysis, RPD, Data Warehousing, PL/SQL, Oracle Database, Business Intelligence Analysis, Tier 1 and 2 Support
Currently serving as Senior OBIEE developer with a present focus on the review of all current oracle OBIEE and BI Publisher reports. Already have produced multiple financial reports unique to the organization. Submerged in learning and understanding of all things data warehouse.
Select Contributions :
Developed data model, and reports in Oracle BI Publisher, as well as developed OBIEE analysis for department of revenue refund dashboard.
Administered RPD changes necessary to allow the creation of new and unique reports
Championed practice of Data Governance by implementing and overseeing compliance with data standards employed by data development team.
2019 : 2020
Indiana Department of Revenue
Senior OBIEE developer
Scope : SAGE 500 ERP, SQL Server, Data Governance, Data Modelling, Development, Technical Writing, Process Improvement, SSIS Administration
Served as SAGE 500 ERP administrator in SQL Server environment and held responsibility for monitoring database performance. Ensured data integrity, confidentiality, and availability while defining data, modeling, and migrating data. Provided Tier 2 database related support as needed.
Select Contributions :
Administered SQL Server Integration Services (SSIS) to extract, transform, replicate, and manipulate the flow of data from source to target.
Developed and optimized stored procedures, triggers, constraints, and functions supporting various data tasks while conducting periodic audits to review/analyze deployed code and identify opportunities for improvement.
Championed practice of Data Governance by implementing and overseeing compliance with data standards employed by data development team.
Built data models to facilitate the identification and analysis of data requirements ensuring well-informed decisions regarding technological business needs and processes.
Coordinated and participated in peer review process to ensure development work supported business goals and objectives in alignment with the organization’s technology roadmap.
Spearheaded creation of comprehensive knowledge base by thoroughly documenting all standard processes and procedures for business continuity and accelerated acclimation of new team members.
Accelerated the 'picking process' in warehouse automation by 30% improving efficiency through
2018 : 2019
BWGS
Database Administrator
Scope : SSIS, ERP, Enterprise Data Warehousing (EDW), Database Administration, Project Management
Operated as project lead on various successful projects in an Agile environment. Collaborated with business for requirements gathering and requirements analysis to facilitate selection and development of the most cost-effective technical solutions to meet operational needs, leveraging existing technologies where possible.
Select Contributions :
Developed and tuned stored procedures supporting an array of data warehouse tasks and employed SSIS to extract, transform, replicate, and manipulate the flow of data from source to target.
Participated in database performance enhancements, backups, upgrades, migrations, and consolidations -
Architected the framework behind ERP data marts inside the Enterprise Data Warehouse and carried out maintenance and operations surrounding those databases.
Lead as Scrum Master for six months
2015 : 2018
Community Health Network
Business Intelligence Architect
Indiana Department of Revenue
Information Security Manager
2020 : 2021
Indiana Department of Revenue
Senior Information Security Analyst
Scope : Data Governance, Data Modelling, Development, Technical Writing, Process Improvement, Agile Development, OBIEE Reports/Analysis, RPD, Data Warehousing, PL/SQL, Oracle Database, Business Intelligence Analysis, Tier 1 and 2 Support
Currently serving as Senior OBIEE developer with a present focus on the review of all current oracle OBIEE and BI Publisher reports. Already have produced multiple financial reports unique to the organization. Submerged in learning and understanding of all things data warehouse.
Select Contributions :
Developed data model, and reports in Oracle BI Publisher, as well as developed OBIEE analysis for department of revenue refund dashboard.
Administered RPD changes necessary to allow the creation of new and unique reports
Championed practice of Data Governance by implementing and overseeing compliance with data standards employed by data development team.
2019 : 2020
Indiana Department of Revenue
Senior OBIEE developer
Scope : SAGE 500 ERP, SQL Server, Data Governance, Data Modelling, Development, Technical Writing, Process Improvement, SSIS Administration
Served as SAGE 500 ERP administrator in SQL Server environment and held responsibility for monitoring database performance. Ensured data integrity, confidentiality, and availability while defining data, modeling, and migrating data. Provided Tier 2 database related support as needed.
Select Contributions :
Administered SQL Server Integration Services (SSIS) to extract, transform, replicate, and manipulate the flow of data from source to target.
Developed and optimized stored procedures, triggers, constraints, and functions supporting various data tasks while conducting periodic audits to review/analyze deployed code and identify opportunities for improvement.
Championed practice of Data Governance by implementing and overseeing compliance with data standards employed by data development team.
Built data models to facilitate the identification and analysis of data requirements ensuring well-informed decisions regarding technological business needs and processes.
Coordinated and participated in peer review process to ensure development work supported business goals and objectives in alignment with the organization’s technology roadmap.
Spearheaded creation of comprehensive knowledge base by thoroughly documenting all standard processes and procedures for business continuity and accelerated acclimation of new team members.
Accelerated the 'picking process' in warehouse automation by 30% improving efficiency through
2018 : 2019
BWGS
Database Administrator
Scope : SSIS, ERP, Enterprise Data Warehousing (EDW), Database Administration, Project Management
Operated as project lead on various successful projects in an Agile environment. Collaborated with business for requirements gathering and requirements analysis to facilitate selection and development of the most cost-effective technical solutions to meet operational needs, leveraging existing technologies where possible.
Select Contributions :
Developed and tuned stored procedures supporting an array of data warehouse tasks and employed SSIS to extract, transform, replicate, and manipulate the flow of data from source to target.
Participated in database performance enhancements, backups, upgrades, migrations, and consolidations -
Architected the framework behind ERP data marts inside the Enterprise Data Warehouse and carried out maintenance and operations surrounding those databases.
Lead as Scrum Master for six months
2015 : 2018
Community Health Network
Business Intelligence Architect
Company:
Indiana Department of Revenue
Years of Experience:
10
Skills
Business Analysis, Business Intelligence (BI), CISSP, Cloud-Native Architecture, Cloud Administration, Cloud Security, Databases, Data Warehousing, Extract, Transform, Load (ETL), Information Security, Leadership, Microsoft SQL Server, Network Security, OBIEE, Oracle Database, Oracle SQL Developer, PL/SQL, Project Management, Six Sigma, SQL, Technical Support