Information Management Systems
Resume:
Catherine L Colalella
Aliquippa, PA 15001
************@*******.***
Professional Objective: My professional objective is to find a challenging and long-lasting career with a company willing to let me grow professionally and become a part of the company’s advancement and growth in their future.
Professional Experience:
Administrative Applications Analyst
Questeq - Carlynton School District
Pittsburgh, PA
March 2025 to Present
1.Collect, organize and report student data for analysis using multiple sources and data analysis tools. (ETL)
2.Responsible for leadership, management, process development, documentation and data
administration for districts student information systems, student registration and Federal and state regulatory reporting.
3.Collect, monitor and report data and documents in accordance with federal legislation requirements.
4.Assists in the management of the district student information system (Tyler SIS), the district data warehousing system and State Department of Education Information Systems.
5.Manages the collection of student data and reporting for Pennsylvania Department of Education Pennsylvania Information Management System (PIMS). submissions.
6.Trains appropriate personnel on the district student information system and Pennsylvania Information Management System (PIMS).
7.Read and interpret all Pennsylvania Information Management System (PIMS). manuals and guidelines concerning data requirements and communicating to appropriate district staff.
8.Management of district personnel involved in the Pennsylvania Information Management System (PIMS) reporting system.
9.Meet deadlines for data submission to the Pennsylvania Department of Education.
10.Understand and correctly interpret error reports related to the data movement process between district systems and the Pennsylvania Department of Education systems.
11.Communicate with representatives at the Pennsylvania Department of Education and Executive Council and District Administration in regard to state reporting and federal reporting.
12.Extensive data analysis to verify any discrepancies of data prior to state submission.
13.Microsoft SQL and BIDS development and system management.
14. Develops documentation and training for users related to data needed by the state
15. Development and testing of both the Student Application and ERP (Financial/HR) Systems.
16. Collect and analyze district data for CRDC submissions.
17. Build ad hoc reports for district staff as needed.
18. Analyze Student data for discrepancies and ensure data integrity.
19. Manage all administrative applications and systems.
20. Project management, budgeting, business analysis, implementation, process improvements.
Senior Data Analyst / ERP Administrator
Pocket Nurse
Monaca, PA
February 2020 to January 2025
1.Collaborate with business leaders to understand business processes and reporting and analysis needs.
2.Make recommendations and design solutions to ensure data is entered, stored, and managed in accordance with defined data architecture principles to ensure high data quality results.
3.Implementation of Microsoft SQL Server.
4.Perform data management tasks, such as data cleansing, manipulations, and transformations.
5.Design, build, and maintain a data warehouse and coordinate and schedule data refresh activities (ETL).
6.Design, build, and maintain data modeling and manipulation programs and scripts that support data reporting and analysis initiatives.
7.Create and manage database reports; assist with dashboard visualizations and designs.
8.Manage and maintain the performance, recoverability, versioning, and security of all corporate database systems (netsuite and Distribution One ERP, Progress database). Ensure database backups and replications are set up to mitigate the impact of a data breach.
9.Diagnose and troubleshoot database errors and data quality concerns.
10.Work directly with Supply Chain and Senior Management to merge data sets for consolidated reporting and analytics.
11. Proactively seek out and implement improvements to data quality.
12.Be aware of and understand current and evolving data trends and technologies.
13.Create and maintain documentation on all responsibilities.
14.Built databases to manage In Stock, Down Stock and warehouse employee performance to help better manage warehouse operations and support the Supply Chain and produce KPI measurables for senior management.
PIMS Administrator/ Sr. Business Systems Analyst
North Allegheny School District
Pittsburgh, PA
August 2014 to November 2019
1.Collect, organize and report student data for analysis using multiple sources and data analysis tools. (ETL)
2.Responsible for leadership, management, process development, documentation and data
3.administration for districts student information systems, student registration and Federal and state regulatory reporting.
4.Collect, monitor and report data and documents in accordance with federal legislation requirements.
5.Assists in the management of the district student information system (Tyler SIS), the district data warehousing system and State Department of Education Information Systems.
6.Manages the collection of student data and reporting for Pennsylvania Department of Education Pennsylvania Information Management System (PIMS). submissions.
7.Trains appropriate personnel on the district student information system and Pennsylvania Information Management System (PIMS).
8.Read and interpret all Pennsylvania Information Management System (PIMS). manuals and guidelines concerning data requirements and communicating to appropriate district staff.
9.Management of district personnel involved in the Pennsylvania Information Management System (PIMS) reporting system.
10.Meet deadlines for data submission to the Pennsylvania Department of Education.
11.Understand and correctly interpret error reports related to the data movement process between district systems and the Pennsylvania Department of Education systems.
12.Communicate with representatives at the Pennsylvania Department of Education and Executive Council and District Administration in regard to state reporting and federal reporting.
13.Extensive data analysis to verify any discrepancies of data prior to state submission.
14.Microsoft SQL and BIDS development and system management.
15.Develops documentation and training for users related to data needed by the state
16.Development and testing of both the Student Application and ERP (Financial/HR) Systems.
17.Collect and analyze district data for CRDC submissions.
18.Build ad hoc reports for district staff as needed.
19.Analyze Student data for discrepancies and ensure data integrity.
Novum Pharmaceutical Research
Position: Database Developer
Pittsburgh, PA
May 2012 – August 2014
1.Design, install, configure, and test software
2.Consults with departmental vice president or supervisor and end users to gather information about program intent, functions, features, data requirements, input requirements, output environment, and interfaces with other systems.
3.Defines user requirements and interfaces with developers and management team to ensure those requirements are met.
4.Creates, enhances and maintains Windows and Web applications and security features.
5.Conducts analysis, programming, testing, implementation, and documentation of applications. (Microsoft Access, SQL and Oracle ERP)
6.Maintains knowledge of the latest windows and web technologies and security practices.
7.Maintains documentation of configurations and changes.
8.Adheres to 21 CFR Part 11 standards for all regulated data or systems.
9.Support SQL server environment, build SQL databases, development of front-end applications using MS Access 2007.
10.Build reports using SSRS.
HyperActive Technologies (contract AC Coy)
Position: Portal Systems Administrator
Pittsburgh, PA
April 2012 – May 2012
1.Maintain operation of an existing portal which utilizes SSRS, Sharepoint and SQL Server
2.Monitor current processes and production jobs
3.Customize existing reports in SSRS
4.Ensure data propagation integrity
5.Support a SQL Server environment
Direct Energy Business
Position: Sr. Data Analyst
Pittsburgh, PA
April 2007 – April 2012
1.Maintaining data integrity for purposes of CA ISO regulatory & settlement reporting.
2.Building/maintaining databases to process daily files from Oracle ERP and SAP into SQL Server.
3.Reviewing and reporting any data issues to appropriate departments/utilities.
4.Implemented processes for data and operational improvement.
5.Work with other departments to resolve outstanding data or process issues.
6.Maintain and update weekly data received by ConEd for stratum variables.
7.Helped to implement change control in office to help resolve data issues.
8.Analyze/Maintain all Gas/Power customer sync lists monthly for data integrity purposes
9.Maintain Group Sharepoint site and manage access and files
10.Assist in enrollments and drops of customer accounts in billing systems for both Gas and Power
11.Build reports using SSRS through Visual Studios
12.Write SQL Stored Procedures and triggers (ETL)
13.Member of the Diversity Inclusion Council, plan and participate in company diversity events.
Per-Se Technologies (Contract Teksystems)
Position: Sr. Technical Analyst
Moon Twp, PA
December 2006 – March 2007
1.Trouble shoot customer issues with MailRx system (AIX Unix, Sybase)
2.Edit Stored procedures in customer’s UNIX environments
3.Liaison between development and customers
4.Documentation of support procedures, and issue solutions
5.Perform SQL queries and updates using T-SQL
6.Resolve outstanding support issues and enhancement requests
7.Documented change control for customer tracking on issues
Federal Home Loan Bank (Contract Pyramid Consulting)
Position: Database Consultant
Pittsburgh, PA
March 2006 – December 2006
1.Implementing SOX compliance on MS Access databases
2.Develop front-end applications for security purposes on MS Access databases
3.Assist in vendor selection for MS Office upgrade project
4.Assist in Project planning for MS Office upgrade project
5.Support MS Office upgrade issues
6.Support SOX compliance project
7.Consolidating End User applications
8.Documentation of all VBA coding used in applications
9.Documentation of all end user applications
10.Request system modifications through change control
11.Project tracking through Microsoft Project
12.Management of ODBC connections and linked database tables.
13.Provide business knowledge on the impact of changes to the application and data
BASF Chemical (Contract Adecco Technical)
Position: SFA Business Administrator
Evans City, PA
January 2006 – March 2006
1.Data transfer from Synth customer and quote database (MS Access 2000) and Oracle ERP and SAP to the SFA system
2.Development of various reports
3.Data cleanup of duplicated records
4.Assign sales reps to appropriate accounts in the SFA system
5.Provide support in report creation and distribution across business group
6.Data quality assurance
7.Reviewing duplicate accounts reports and approving accounts to be merged
8.Reviewing unassigned locations report and assigning locations to appropriate accounts
9.Monitor data quality, review results of testing, summarize/communicate findings
10.Maintain sales representative assignments
11.Review auto assigned sales rep numbers report to determine if the SAP system sales rep numbers are assigned correctly.
12.Assign SAP sales rep numbers when the system is unable to match them automatically
13.Approve new user access requests
14.Technical support and training of the system.
15.Request system modifications through change control
16.Provide business knowledge on the impact of changes to the application and data
17.Assist NTI group with application upgrade releases/testing
Sky Bank(Contract Teksystems)
Position: Application Support Specialist
East Liverpool, OH
July 2005 – December 2005
1.Worked primarily with the client groups of Item Processing, Lockbox, Positive Pay, Fraud, and Statement/Mail Processing to conceptualize, formulate, and refine business requirements as they apply to the design, development, and maintenance of the system
2.Maintaining the integrity of the databases (Oracle and SQL)
3.Importing and exporting data
4.Testing the system environment
5.Revising processes as needed
6.Fulfilling report requests and creating reports as needed
7.Copying, loading, and movement of data between database environments
8.Troubleshoots problems in any applications Leads implementation and works with other outside vendors as necessary
9.Assists in designing or setting up new processes for internal clients for process improvement, enhanced communications, and efficiency
10.Understands business needs for data Collaborates with vendor(s) for on-going updates and enhancements to the system and resolving any outstanding system issues
11.Coordinates with parties internal and external to determine develop and execute comprehensive project plans
12.Develops and documents operations support requirements, standard operating procedures, checklists, and other process-related documents to enable the team to support any reports or programs developed
Children’s Hospital of Pittsburgh
Position: Systems Analyst
Pittsburgh, PA
April 2004 – March 2005
1.Provide software and information systems knowledge to meet the defined needs of the end-users in the department(s) including complex system installments, enhancements and troubleshooting technical and application-based problems.
2.Evaluate and modify existing systems considering changes in system requirements, equipment configuration and production efficiencies. (Cerner and Oracle)
3.Install new systems and trains end-users.
4.Act as a liaison with vendors to determine end-users' needs relative to system requirements or modifications.
5.Update on weekly basis hospital charge codes.
6.Build new orderables for multiple departments as needed.
7.Regression, Integrated and Super Testing of any system updates.
Unger Freight Services, Inc
Position: Project Consultant
Moon Township, PA
February 2004 - September 2004
1.Proposed information technology project
2.Creation of baseline project plan, technical specifications, and statement of work
3.Project management, assigning resources, following time schedules, and costs
4.Purchasing new hardware requirements, server, workstations, network equipment, software
5.Database Development, and implementation, MS Access Front-end and SQL Back-end
6.Employee training on new system
7.Project wrap up
8.Project invoices
Community College of Beaver County
Position: Assistant Instructor
Monaca, PA
February 2001 - January 2004
1.Instructed Database Management Courses (MS Access 97, 2000, 2002, and Dbase)
2.Instructed COBOL and File Processing Courses (Micro Focus COBOL basics and advanced)
3.Instructed Introduction to Computers Courses (MS Office 97, 2000, 2002 basic application functions and procedures)
4.Instructed Microcomputer Applications Courses (MS Office 97, 2000, 2002 advanced application functions and procedures)
5.Continuing Education Instructor - Beyond the Internet (Basics of how to use the Internet: exp. Browsers, navigation, news groups, ISP setup, searching, HTML editors, email setup, and how to use email)
Sony Electronics, Inc. (Contract Sarcom)
Position: Database Consultant
Mt. Pleasant, PA
August 2003 - September 2003
1.Followed SDLC (System Development Life Cycle) methodology to develop Microsoft Access 97 and Access 2002 employee evaluation and payroll database.
2.Worked closely with Human Resources department to determine database needs.
3.Proposed database development plans to Human Resources management.
4.Performed data analysis to determine data sources and formats.
5.Extracted data from Peoplesoft, HR Workways, and Kronos software to build data warehouse. (ETL)
6.Developed user friendly and secure database interface using VBA for Sony management to evaluate employee performance bi-annually.
7.Built Management and Human Resources reports for reporting employee evaluation data.
8.Maintained database application during management training and made adjustments as needed.
9.Performed basic maintenance and additions to application after implementation.
10.Documented database application and procedures for additions to the system.
Siemens Business Services, Inc.
Position: Database Developer / Administrator
Pittsburgh, PA
July 2002 - May 2003
1.Followed SDLC (System Development Life Cycle) methodology to develop Microsoft Access 2000 Front-End and Microsoft SQL Server 2000 Back-End Asset Migration Project Database.
2.Maintained current Microsoft Access 2000 database, while starting development of new database system.
3.Worked closely with Siemens’ project employees and management, and PNC Bank employees to determine database needs.
4.Proposed database development plans to Siemens’ and PNC management.
5.Performed data analysis to determine data sources and formats.
6.Extracted asset network data by using ODBC from Oracle 9, also extracted Human Resources data and IBM asset lease data from Lotus Notes based databases to build MS SQL Server data warehouse. (ETL)
7.Analysis of project needs for improving the operation’s process, reporting, and data structure.
8.Developed user friendly and secure database interface using VBA for Siemens’ employees and management to update and track all project milestones.
9.Utilized complex macros within MS Access & MS Excel to ensure data integrity and data transfers.
10.Creation of complex financial and project reports for Siemens’ and PNC Bank management.
11.Implementation of SQL Server DTS Packages for updating data from Oracle ERP system.
12.Development of SQL Server Views and Queries for easy data viewing access.
13.Development of project billing program, to produce end of month bill for PNC Bank.
14.Windows 2000 Server Administration created user accounts, security levels, and maintained system performance, and backup performance.
15.Terminal Server Administration maintained user accounts, connectivity issues, licensing issues.
16.Trained Siemens’ employees on project processes and how to use project database efficiently.
17.SQL Server Administration maintained user accounts, database performance, additions to database.
Cutler Hammer (Contract Technical Data Services)
Position: Software Support Analyst
Moon Township, PA
September 2000 - October 2001
1.Supported all Cutler Hammer software for employees, distributors, and customers.
2.Problem solving for any data transfer issues for orders and authorized pricing.
3.Maintained software registration information.
4.MS Access 97 and SQL Server troubleshooting and maintenance.
5.24 Hour on-call support for domestic and international users.
6.Contribution to company’s knowledge base.
7.Trained new employees on helpdesk procedures and software.
8.Maintained company’s IT library and implemented MS Access database for library record keeping.
9.Applications supported: Citrix, Oracle, ODBC connectivity, Novell, Cognos, and Powerplay
ARL, Inc.
Position: Database Developer / Administrator
Moon Township, PA
March 1998 - March 2001
1.IBM RISC 6000 - AIX UNIX Administration, troubleshooting process issues, user administration.
2.HP 9000 - HPUX UNIX Administration, user administration, security issues, troubleshooting process issues.
3.HPUX C++ Script writing to run daily processes.
4.HPUX SB Client (SQL Language) Development of corporate General Accounting system.
5.Followed SDLC (System Development Life Cycle) methodology to develop Microsoft Access 97 database application to be used by field offices for daily operations.
6.Worked closely with field offices to determine database application needs.
7.Analysis of data structures needed for UNIX scripts to transfer data from MS Access application format to UNIX format.
8.Developed user friendly and secure database interface using VBA for field offices to perform daily operations.
9.Developed data transfer process to send daily batch files to corporate office to be imported to UNIX system.
10.Developed corporate Inventory, Comdata, Purchase, Payroll, Customer, Comp Activity, and 401K databases using MS Access 97.
11.Databases implemented helped the company become more time and cost efficient.
12.On-site training with the company’s 200 field offices to train on database application.
13.Assisted in the hiring process of new database developers.
14.Supported software applications for all company employees and field offices.
15.Trained new employees with MS Access 97, 2000 development, VBA, Development Studio, SQL Server.
16.Corporate software installations, PC Maintenance, and network troubleshooting.
Leadership:
School Board Director
Aliquippa School District
Aliquippa, PA
December 2015 to Present
1.Sets the district's direction with performance-based goals
2.Ensures alignment of strategies, resources (including the approved budget), policies, programs and processes with district goals
3.Assesses and accounts for student achievement using comprehensive data, thorough deliberation and open communication
4.Annually conducts a written performance assessment of the district superintendent
5.Leads the district, accentuating and reinforcing the positive while correcting the negative
6.Oversees the educational programs, personnel, and properties, with specific responsibilities to determine curriculum, employ a superintendent and approve a budget
7.Responsible for establishing goals, adopting policy and overseeing resources for the school district
8.Hold information, strategy and negotiation sessions related to the negotiation or arbitration of a collective bargaining agreement or, in the absence of a collective bargaining unit, related to labor relations and arbitration
9.Consider the purchase or lease of real property, up to the time an option to purchase or lease the real property is obtained or up to the time an agreement to purchase or lease such property is obtained if the agreement is obtained directly without an option
10.Consult with its attorney or other professional adviser regarding information or strategy in connection with litigation or with issues on which identifiable complaints are expected to be filed
11.Review and discuss agency business which, if conducted in public, would violate a lawful privilege or lead to the disclosure of information or confidentiality protected by law, including matters related to the initiation and conduct of investigations of possible or certain violations of the law and quasi-judicial deliberations
12.Chair of the district’s policy, education and technology committees
JOC Board Member
Beaver County Career and Technology Center
Monaca, PA
January 2018 to Present
1.Ensures alignment of strategies, resources (including the approved budget), policies, programs and processes with district goals
2.Assesses and accounts for student achievement using comprehensive data, thorough deliberation and open communication
3.Annually conducts a written performance assessment for the Executive Director
4.Oversees the educational programs, personnel, and properties, with specific responsibilities to determine curriculum, employ a director and approve a budget
5.Responsible for establishing goals, adopting policy and overseeing resources for the school
6.Hold information, strategy and negotiation sessions related to the negotiation or arbitration of a collective bargaining agreement or, in the absence of a collective bargaining unit, related to labor relations and arbitration
7.Consider the purchase or lease of real property, up to the time an option to purchase or lease the real property is obtained or up to the time an agreement to purchase or lease such property is obtained if the agreement is obtained directly without an option
8.Consult with its attorney or other professional advisor regarding information or strategy in connection with litigation or with issues on which identifiable complaints are expected to be filed
9.Review and discuss agency business which, if conducted in public, would violate a lawful privilege or lead to the disclosure of information or confidentiality protected by law, including matters related to the initiation and conduct of investigations of possible or certain violations of the law and quasi-judicial deliberations
10.Served as Treasurer of the board for 5 years
Awards:
2017 Beaver County Christians United – Martin Luther King Jr. Reconciliation Award
2017 Martin Luther King Jr. Celebration Committee – Community Leadership Award
Education:
Point Park College
Degree: Bachelors in Science
Major: Information Technology & Management
Graduated: 2006
Presidents List, National Honor Society
Community College of Beaver County
Degree: Associates in Applied Science
Major: Computer Information Systems
Minor: Telecommunications
Graduated: May 1999
References Available Upon Request
Contact this candidate