Results-driven Database Analyst at Commonwealth University of Pennsylvania with expertise in SQL programming and problem-solving. Successfully migrated legacy databases, enhancing system functionality and minimizing downtime. Proficient in data warehousing and committed to ongoing professional development, fostering collaboration and efficiency within cross-functional teams.
Overview
8
8
years of professional experience
Work History
Database Analyst
Commonwealth University of Pennsylvania
10.2022 - Current
Troubleshot complex issues with databases, resolving problems quickly and effectively to minimize disruptions to end-users'' work.
Managed database security, development and access of input systems.
Assisted in migrating legacy databases to modern platforms, minimizing downtime during transitions.
Worked closely with IT staff to ensure seamless integration of database elements into new or existing applications, promoting optimal system functionality.
Proactively engaged in ongoing professional development to maintain expertise in current database management systems and practices.
Developed comprehensive documentation to facilitate knowledge transfer among team members and stakeholders.
Supported application development teams by providing expert advice on best practices for database integration and usage.
Increased efficiency by automating repetitive tasks using scripting languages such as SQL or Python.
Set up and controlled user access levels across databases to protect important data.
Applications Developer
Mansfield University of Pennsylvania
04.2018 - 10.2022
Conducted thorough quality assurance testing on all completed projects to ensure flawless functionality before deployment.
Troubleshot complex application issues, providing timely resolutions to maintain optimal system functionality.
Collaborated effectively with designers and product managers to create cohesive, user-centered applications that met both functional requirements and aesthetic expectations.
Developed customized solutions for clients based on their unique business needs and objectives.
Optimized application performance by identifying and rectifying coding inefficiencies.
Collaborated with cross-functional teams to deliver high-quality software solutions within tight deadlines.
Mentored junior developers, sharing knowledge and expertise to foster a collaborative work environment.
Updated technical documentation, product specifications, and technical training materials.
Wrote code for database applications.
Used ASP.NET, JavaScript and SQL Server to develop new applications.
Collaborated with multidisciplinary teams to design and implement new technology features.
Assisted with creation of user manuals.
Conducted scheduled system upgrades to maximize performance.
Coordinated deployments of new software, feature updates and fixes.
Junior System Administrator
First Citizens Community Bank
09.2017 - 04.2018
Reduced downtime during system upgrades by carefully planning and executing migration projects.
Managed user accounts, permissions, and access controls to maintain a secure computing environment.
Provided top-notch customer service by promptly addressing helpdesk tickets and user inquiries.
Implemented backup strategies to safeguard critical data and ensure business continuity.
Fostered a culture of teamwork within the IT department by actively participating in group projects and sharing expertise.
Provisioned new software and hardware for use, following established security policies.
Managed onboarding and offboarding of employees.
Managed life cycle replacement of hardware and software.
Identified computer hardware and network system issues, performing troubleshooting techniques for remediation.
Education
Bachelor of Science - Computer Science: Information Systems
Mansfield University of Pennsylvania
Mansfield, PA
05-2017
Skills
SQL and databases
Server administration
SQL server integration services
Data structures
Data visualization
Problem-solving
Attention to detail
Critical thinking
Adaptability
Data migration
Server management
Database administration
Accomplishments
Migrated legacy student information system to Banner.
Administrated reporting tool (Argos), while creating datablocks and reports.
Created Extract-Transform-Load integrations for vendor integration with student information system.
Administrated Windows servers, performing server maintenance and security updates.
Administrated information system servers; coordinating down times, testing backups, and maintaining production, development, and testing environments.
Administrated databases and their servers.
Timeline
Database Analyst
Commonwealth University of Pennsylvania
10.2022 - Current
Applications Developer
Mansfield University of Pennsylvania
04.2018 - 10.2022
Junior System Administrator
First Citizens Community Bank
09.2017 - 04.2018
Bachelor of Science - Computer Science: Information Systems
Mansfield University of Pennsylvania
Similar Profiles
Tessa LewisTessa Lewis
TriO Student Front Desk Worker at Commonwealth University Of PennsylvaniaTriO Student Front Desk Worker at Commonwealth University Of Pennsylvania