System Administrator Resume Example

Lead System Architect, Developer and Administrator of DOMO business intelligence platform

• Designed, developed analyzed and tested ETL and business data-flow processes
• Proficient in Oracle SQL, MySQL, Redshift, Access, Excel
• Designed, automated, distributed and maintained executive level reports and dashboards
• Responsible for enforcing data integrity and quality across all systems and processes
• Project lead over data science implementation to predict employee flight risk and reduce turnover
• Combined, parsed and aggregated over 500 TB data from multiple systems producing a holistic view of human capital and key business metrics
• Strong business partnership with HRBP's and Field Directors
• Created DOMO pages, dashboards and business processes for all areas of HR including HR Analytics, HR Field, HRIS, Compensation, Payroll, Benefits, LOA, Compliance and Communications
• Created and modified programs, processes and API's to solve complex business problems
• Supervised team members and domo users in creating dataflows, datasets and visuals
• Validated reports and queries created by junior team members and business partners
• Mentored interdepartmental employees on SQL and database structure basics
• Primary contact for complex queries and ad-hoc reporting requests across all HR departments, automating and streamlining where possible
• Conducted interdepartmental training classes on SQL, DOMO and best practices regarding data structure and integrity
• Maintained robust library of SOP's, user guides and other business related documentation
• Served as technical subject matter expert on multiple interdepartmental projects
• Designed customized data collection models for specific visualization tasks
• Developed and managed dashboards using [Technology resource]
• Developed intelligence-sharing dashboards, providing company-wide access to collected data
• Collected data from wide-ranging sources, including [Type], [Type] and [Type]
• Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues
• Handled massive quantities of business intelligence data, personally managing as much as [Number] terabytes
• Generated reports, updated spreadsheets and presented results
• Queried [Type] and [Type] teams to define intelligence needs, structuring subsequent information gathering efforts accordingly
• Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes
• Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use
• Integrated BI assets into customer relationship management (CRM) tasks, improving service personnel's available intelligence
• Prepared detailed reports [Timeframe] on updates to project specifications, progress, identified conflicts and team activities
• Improved data gathering, analysis and visualization procedures with strategic optimizations
• Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications
• Responded to specific BI requests from [Type] personnel, creating data packets with requested information in easily understandable formats
• Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards
• Monitored and optimized SQL server performance
• Modified existing [Type] software to correct coding errors, upgrade interfaces and improve overall performance
• Led [Software] development initiative as Subject Matter Expert and primary point-of-contact for project management staff
• Wrote [Type] scripts for daily maintenance activities, including indexes and tables analyses

• 6 years of experience PeopleSoft IT Benefits functional data analyst
• Requirements gathering, functional and technical design documentation, unit testing
• Advanced Microsoft Access database design, development and configuration for custom Benefits billing, headcount reports, and reconciliation processes
• Identified system requirements and analyzed current and future business processes to develop complex data models, reports and queries
• Created custom comparison and reconciliation process to identify and report discrepancies between vendor files and PeopleSoft
• Troubleshoot and resolve BenAdmin job errors and issues in PeopleSoft
• Created functional and technical design specifications
• Conducted software demonstrations, training of end users and lead system integration testing
• Lead analyst to provide vendor management ensuring utilization and synchronization of relevant technology to support implementations, system enhancements, upgrades, patches and fixes
• Read and interpreted HIPAA EDI transaction sets in resolving interface file issues
• Researched and resolved issues regarding integrity of data flow into [Type] databases
• Documented business workflows for stakeholder review
• Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources
• Participated in requirements meetings and data mapping sessions to understand business needs
• Corrected any data entry error to prevent later issues such as duplication or data degradation
• Identified and documented detailed business rules and use cases based on requirements analysis