Ahren Hollis
Pittsburgh,PA
Summary
Results-driven Systems Administrator with a strong background at Carnegie Mellon University in data integration and management. Expertise in Salesforce development and process automation, leveraging tools like Tableau, Snowflake, and SQL for impactful reporting and insights. Committed to fostering collaboration among teams, optimizing processes, and ensuring system reliability across multiple departments.
Overview
25
25
years of professional experience
Work History
Systems Administrator
Carnegie Mellon University
Pittsburgh, PA
01.2003 - Current
- Led HR, Finance, and Student Systems data integrations into Fusion Risk Management, BioRAFT, and CMU’s Emergency Notification System, driving cross-functional collaboration to enhance data accuracy and system reliability.
- Analyzed large datasets using statistical methods, delivering actionable insights through dashboards and reports in Tableau, Excel, Conga, Snowflake, SQL and Microsoft SQL Report Builder.
- Monitored operations and reviewed metrics to assess company performance.
- Administered the Salesforce platform by managing user roles, access permissions, and automating workflows.
- Designed tailored solutions, including Flows and Lightning apps, to fulfill departmental needs.
- Implemented strategies for process automation across the organization.
Administrative Assistant
University of Pittsburgh Physicians
PITTSBURGH, PA
01.2001 - 11.2003
- Executed general administrative duties for Finance and Reporting Services departments.
- Authored Crystal reports utilizing EPIC data to enhance departmental operations.
Education
Associate Degree - Specialized Technology
Art Institute of Pittsburgh
01.1998
Skills
- Data integration and management
- Salesforce development and administration
- Reporting and dashboards
- Business analysis and requirements documentation
- Website design and content management
- Process automation with flows
- REST APIs and SQL proficiency
- Snowflake data warehousing
- Excel and Tableau expertise
- Conga document generation
- ServiceNow platform knowledge
Hobbies and Interests
- Outdoor Adventures: Living the salt life, trail maps, and the perfect campfire playlist.
- Sci-Fi & Storytelling: Star Wars vs Star Trek.
- Gaming Enthusiast: Enjoys Sudoku and competitive jigsaw puzzles.
Mission Values
Committed to leveraging technology to create inclusive, accessible, and impactful solutions. Fostering partnerships across teams to achieve shared goals. Promoting digital equity and meeting accessibility standards.
Merging functionality with aesthetics to create user-centric designs. Leveraging creative problem-solving to enhance system efficiency and user experience. Partnered with cross-functional teams to deliver impactful results.
Timeline
Systems Administrator
Carnegie Mellon University
01.2003 - Current
Administrative Assistant
University of Pittsburgh Physicians
01.2001 - 11.2003
Associate Degree - Specialized Technology
Art Institute of Pittsburgh
Similar Profiles
Phillip PearsonPhillip Pearson
Biochemistry at Carnegie Mellon University/Emerald cloud labBiochemistry at Carnegie Mellon University/Emerald cloud lab
Mary Catherine WardMary Catherine Ward
Chief Strategy Officer at Carnegie Mellon University – Software Engineering Institute (SEI) - A Federally Funded Research & Development CenterChief Strategy Officer at Carnegie Mellon University – Software Engineering Institute (SEI) - A Federally Funded Research & Development Center
Andy ChuAndy Chu
Intern at Carnegie Mellon UniversityIntern at Carnegie Mellon University
Grace SwatsworthGrace Swatsworth
Research Assistant at Rule Lab (Carnegie Mellon University)Research Assistant at Rule Lab (Carnegie Mellon University)
JUSTIN BAIERLJUSTIN BAIERL
Financial Advisor at Kades MargolisFinancial Advisor at Kades Margolis