Mark Copley
Delaware,Ohio
Summary
Experienced IT professional with a strong background in SQL Server database development. Proficient in utilizing SQL BI tools like SSIS, SSAS, and SSRS to streamline data extraction, formatting, transformation, and transfer processes. Skilled in creating custom reports using SSRS and developing SQL stored procedures. Familiar with version control packages including GitHub, TortoiseSVN, TFS, and Subversion. Adept at gathering requirements, creating technical documents, and facilitating knowledge transfer. Additionally, experienced in participating in 24-hour support rotations. Knowledgeable [Desired Position] with solid background in designing, developing, and maintaining complex SQL databases. Successfully implemented optimized queries and stored procedures, enhancing database performance and reliability. Demonstrated expertise in database design and data modeling, with focus on ensuring data integrity and security. SQL development professional, prepared to bring expertise in database design, optimization, and management to team. Known for delivering high-quality solutions that improve database performance and reliability. Valued for collaboration skills and flexibility in adapting to dynamic project requirements. Proficient in SQL programming, query optimization, and data modeling, with strong commitment to achieving results.
Overview
14
14
years of professional experience
Work History
Senior SQL DEVELOPER
CAI
06.2024 - 11.2024
- Company Overview: Working for Trillium Healthcare out of North Carolina to help augment staff requirements
- Develop and maintain SSIS packages to import/export vendor data
- Provide database development
- Develop SQL scripts, stored procedures to improve processes
- Work on support tickets, maintenance tasks and assigned projects by IT Mgr
- Communicate with business units and other IT members to help coordinate efforts across teams and organizations
- Working for Trillium Healthcare out of North Carolina to help augment staff requirements
Senior BI DEVELOPER
ADVOCATE RCM
08.2021 - 06.2024
- Develop and maintain SSIS packages to import/export vendor data
- Provide database development and production support on SQL databases
- Provide automated reporting to clients
- Create and schedule SQL Agent jobs
- Develop SQL scripts, stored procedures to improve processes
- Work on support tickets, maintenance tasks and assigned projects by IT Mgr
- Communicate with business units and other IT members to help coordinate efforts across teams and organizations
DEVELOPER
JEGS Automotive
12.2020 - 08.2021
- Monitor and tune database resources and activities for SQL Server databases
- Create and schedule SQL Agent jobs and maintenance plans
- Provide database development and production support on SQL 2017 databases
- Develop SQL scripts, stored procedures to improve processes
- Develop and maintain SSIS packages to upload vendor data from landing zone to JEGS databases
- Monitor and maintain SQL backups as to adhere to company disaster recovery plan
CONSULTANT
TEK Systems
02.2020 - 09.2020
- Company Overview: OLA Healthcare Technology
- Develop SQL scripts to extract data from a PostgresSQL database to be the data source used by BI report(s)
- Backward engineer Hospital BI reports using Jaspersoft to create the reports while using SQL stored procedures as a data source to pull data from PostgresSQL db
- Kept all SQL stored procedures updated in Git version control
- Participated with project manager and team members on daily basis of progress and issues
- Used Microsoft Teams to conduct all meetings and to collaborate with other team members
- OLA Healthcare Technology
Senior BI Consultant
TARGIT Software
04.2019 - 01.2020
- Provide BI consulting and development for various companies mostly financial reporting
- Develop and maintained ETL packages to upload data into customers financial reporting cubes, work was done using Microsoft SSIS
- Develop and maintained financial reporting cubes, work was done using Microsoft SSAS
- Develop and maintained various company financial reports
SQL Developer / DBA
MICRO ELECTRONICS
05.2015 - 04.2019
- Monitor and tune database resources and activities for SQL Server databases
- Create and schedule SQL Agent jobs and maintenance plans
- Provide database development and production support on SQL databases
- Develop SQL scripts, stored procedures to improve processes
- Develop and maintain SSIS packages to upload vendor data from landing zone to Microcenter databases
- Monitor and maintain SQL backups as to adhere to company disaster recovery plan
- Work on support tickets, maintenance tasks and assigned projects as assigned by IT Mgr
- Connected to outside company API to pull employee data
- Provide database development and production support to production systems 24hr support rotation
DBA / DATABASE DEVELOPER
JP MORGAN CHASE
06.2012 - 05.2015
- Monitor and tune database resources and activities for SQL Server databases
- Provide database development and production support to Asset Management group
- Worked in planning, design, implementation, and deployment phases of Corporate Finance projects
- Develop SQL stored procedures to improve processes
- Develop and maintain SSIS packages that uploaded vendor data from landing zone to JEGS databases
- Develop SSRS reports and configure SSRS subscriptions per specs provided by internal clients
- Communicated with business units and other IT members to coordinate efforts across teams
DATABASE ANALYST
OHIO TUITION AND TRUST AUTHORITY
10.2010 - 06.2012
- Create and schedule SQL Agent jobs and maintenance plans
- Manage OTTA production SQL Server 2005/2008 databases
- Develop and maintain SSIS packages to upload vendor data from landing zone to Microcenter databases
- Work on support tickets, maintenance tasks and assigned projects as assigned by IT Mgr
- Develop SQL stored procedures to improve processes
- Monitor and maintain SQL backups as to adhere to company disaster recovery plan
- Prepare and update documentation of all OTTA processes and procedures
Education
Associate Degree - Applied Sciences
Shawnee State University
Portsmouth, OHSkills
- Microsoft SQL Server
- Microsoft BI Tools (SSIS, SSRS)
- ETL development using SSIS
- Custom Reporting using SSRS, SiSense Jaspersoft
- Stored Procedures
- Pentaho
Awards
Chairman's Award, 2006, In appreciation for outstanding performance from Cardinal Health
Military Service
United States Navy
Timeline
Senior SQL DEVELOPER
CAI
06.2024 - 11.2024
Senior BI DEVELOPER
ADVOCATE RCM
08.2021 - 06.2024
DEVELOPER
JEGS Automotive
12.2020 - 08.2021
CONSULTANT
TEK Systems
02.2020 - 09.2020
Senior BI Consultant
TARGIT Software
04.2019 - 01.2020
SQL Developer / DBA
MICRO ELECTRONICS
05.2015 - 04.2019
DBA / DATABASE DEVELOPER
JP MORGAN CHASE
06.2012 - 05.2015
DATABASE ANALYST
OHIO TUITION AND TRUST AUTHORITY
10.2010 - 06.2012
Associate Degree - Applied Sciences
Shawnee State University
Similar Profiles
David FoxDavid Fox
System Support Administrator at CAISystem Support Administrator at CAI
Darek LampkinDarek Lampkin
Service Desk Analyst at CAIService Desk Analyst at CAI
Arkajit DasArkajit Das
Technical Lead at CAITechnical Lead at CAI