Crystal Jackson
Piney Flats
Summary
Secret Security Clearance - Active
Experienced SQL and BI Developer with 8 years of experience in MS SQL, databases, and application programming. Committed to creating tailored technical solutions that align with operational requirements and objectives. Possesses a deep understanding of intricate T-SQL coding scenarios. Recognized as a critical thinker, analyst, and problem solver who consistently delivers high-quality products in diverse business settings.
Overview
8
8
years of professional experience
Work History
BI Developer Analyst
Edfinancial Services
07.2021 - Current
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Responded to specific BI requests from corporate personnel, creating data packets with requested information in easily understandable formats.
- Created data analysis tools to allow teams to query acquired information for unique details.
- Collected data from wide-ranging sources.
- Implemented business intelligence solutions to increase operational efficiency.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Collaborated with stakeholders to identify business needs and data sources.
- Developed and implemented data governance policies and procedures.
- Developed and maintained data warehouses and data marts to support business operations.
- Generated standard and custom reports to provide insights into business performance.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
Business Application Analyst
Ballad Health
06.2018 - 07.2021
- Maintained and developed applications for the Revenue Cycle and Business Financial teams
- Extensive, in-depth development and analysis of SQL queries, tables, triggers, indexes and archiving for data flow and reporting with Oracle and MS SQL
- Worked primarily with SSIS for implementation of ETL packages and automation using C# and T-SQL
- Developed an automated ETL process that involves multiple facilities and is used daily for vendor database updates on patient data spanning back 10+ years
- Generated historical archives and global-oriented scripting for ease of manual analysis/troubleshooting
- Maintained and developed processes and workflows in a job automation scripting software (UC4)
- Worked collaboratively in team environment
- Resolved all issues professionally and in a timely manner
ERP Analyst/Software Developer
Crown Laboratories, Inc.
05.2017 - 09.2018
- Created and maintained front end web resources for consumer use on CrownLaboratories.com and BlueLizard.net
- Created and maintained internal web-based applications for production logistics and database management through an ERP system
- Created an R&D database and archive for laboratory patents, approvals, and versions of tested and developed products
- Designed a front-facing UI with ASP.net and an MVC framework to interface with the database
- Created phishing monitor with php for internal use
- Collaborated alongside graphic design for full modular implementation of products' consumer facing websites
Education
Bachelor of Science - Computer Science
East Tennessee State University
Johnson City, TN12.2017
Bachelor of Allied Health - Cardiopulmonary Science
East Tennessee State University
Johnson City, TN05.2011
Skills
- T-SQL
- PL/SQL
- Microsoft SQL Server Management Studio
- SSIS
- Agile methodologies
- HTML
- Data migration
- CSS
- Data modeling
- JavaScript
- Data validation
- Data analysis and reporting
- Php
- MySQL
- C#
- ASPnet
- MVC
- Business analysis
- Data warehousing
- Data visualization
- BI model development
- ETL development
- Business intelligence
- Performance tuning
- Relational databases
- Database design
- Code debugging
- Database development
Timeline
BI Developer Analyst
Edfinancial Services
07.2021 - Current
Business Application Analyst
Ballad Health
06.2018 - 07.2021
ERP Analyst/Software Developer
Crown Laboratories, Inc.
05.2017 - 09.2018
Bachelor of Allied Health - Cardiopulmonary Science
East Tennessee State University
Bachelor of Science - Computer Science
East Tennessee State University
Similar Profiles
Joel SantagadoJoel Santagado
IT Support Technician at EdFinancial ServicesIT Support Technician at EdFinancial Services
Zamir TurnerZamir Turner
Senior Human Resources Generalist at Edfinancial ServicesSenior Human Resources Generalist at Edfinancial Services
Claire HolidayClaire Holiday
Specialty Casework Processor at Edfinancial ServicesSpecialty Casework Processor at Edfinancial Services