Michelle Harvey
Data Engineer
Dunlap,TN
Summary
Detailed-oriented Data Engineer who possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Highly skilled with SQL, Snowflake, ETL and ELT Processes (SSIS, DBT and ADF) as well as multiple reporting tools including SSRS, Tableau and Power BI. Equally confident working independently and collaboratively as needed.
Overview
26
26
years of professional experience
Work History
Data Engineer
CAQH
11.2022 - Current
- Worked with Architecture team to design data model for new data warehouse in Snowflake.
- Successfully built Azure Data Factory Pipeline to source data from Azure SQL into Snowflake. Additionally, modified existing Azure Data Factory to greatly reduce run time.
- Handled large JSON structured data for consumption into Snowflake database via Azure Data Factory.
- Participated in implementation of data warehouse, centralizing organizational data for more efficient analysis and reporting capabilities.
- Streamlined query performance by optimizing SQL scripts.
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Provided technical guidance to other team members, fostering a collaborative learning environment within the organization.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Streamlined development processes by implementing Agile methodologies and utilizing project management tools like JIRA.
- Designed visually appealing reports and dashboards using Power BI for informed decision making.
- Helped set up security for new Snowflake database.
- Worked closely with Quality Assurance teams throughout development to ensure a high level of code quality and adherence to requirements.
- Developed complex SQL queries to satisfy data needs by internal and external customers to answer business questions as well as presented findings to executive leadership.
Data Analyst
CAQH
03.2022 - Current
- Developed tables, stored procedures using SQL.
- Designed SSIS package to combine data from multiple, varied data sources such as Excel, CRM, SQL.
- Completed basic ad hoc and recurring data and report requests to support business needs.
- Identified process improvements to reduce billing process by 75%.
- Utilized data visualization tools such as SSRS, Tableau and Excel to effectively communicate business insights.
- Responded to specific data requests, creating data sets and/or reports with requested information in easily understandable formats.
- Developed and updated databases to handle customer data.
- Prepared monthly ad hoc reporting in alignment with client needs.
Senior Database Engineer
Skillsoft
01.2021 - 03.2022
- Developed, implemented and optimized stored procedures and functions using T-SQL to support Skillsoft training applications.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Developed and implemented changes to SSIS ETL packages to extract and process data between multiple servers.
- Reviewed and interpreted business report requirements to address user needs.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
Reporting Analyst II
Blue Cross Blue Shield of Tennessee
02.2020 - 12.2020
- Communicate with internal business users, gather requirements and accurately produce reports and data analysis.
- Conduct meetings with management and internal business users to ensure needs are met and trust is earned.
- Designed new process and database objects for data error reporting, generate team productivity measurements accurately and reduced SSIS runtime by 80%.
- Identify database challenges and define areas for improvement. Initiated standards development to design more streamlined database and incorporate database practices such as normalization, indexes, functions and reduce access view usage.
- Design and develop SSRS reports with drill multiple drill through options, multiple dynamic parameters. Significantly reduced additional manual work by providing more usable reports that could be sorted and filtered from SSRS Report Manager.
- Identified areas for improvement in Work Front application process for request intake as well as work prioritization.
- Provide one time data pulls as well as determine what can be automated to avoid additional manual work.
Application Developer
Raymond James Financial
01.2016 - 02.2020
- Designed, developed and maintained SQL database and ETL processes that supported Raymond James Securities Based lending system. This application generated data and calculations for loan eligibility decisions. Loans in this system totaled over $1 billion.
- Database modeling and design including tables, views and triggers.
- Implemented indexes to achieve faster data retrieval.
- Developed SSIS packages to extract data from different sources into destination targets, like SQL Server, Flat file, Excel.
- Designed and developed reports including drill through reports drill down reports based on business requirement using SSRS.
- Developed and delivered releases adhering to Agile SCRUM methodology.
- GIT and Team Foundation Server source control.
- Collaborated with multidisciplinary teams to layout, design, and unfold new technology features. Played major role in layout modifications to improve functionality.
- Collaborated with engineers, system analysts, and programmers regarding project capabilities and limitations to deliver optimal functionality.
- Worked closely with other team members as well as QA team in such tasks as troubleshooting and debugging.
- Automated processes for end users that reduced workload for certain tasks by 80-90 %.
Business Reporting Analyst
Blue Cross Blue Shield Of Tennesee
10.2015 - 01.2016
- Successfully developed SSRS reports for Information Delivery management use featuring charts and drill through as well as linked reports.
- Reviewed and analyzed systems functions and reporting processes for accuracy.
- Set up SSRS report subscriptions and security by SSRS folder.
- Worked with data from multiple platforms such SAS, Teradata and SQL Server.
- Communicated and led projects with upper management to ensure reporting needs were met and with accuracy.
Business Intelligence Analyst / Team Lead
U.S. Xpress Enterprises Inc.
09.2010 - 10.2015
- Designed Business Intelligence processes and standards. Maintained SSRS report server.
- Gather requirements for reporting needs, developing reports and stored procedures and SSIS.
- Team Lead responsibilities include successfully develop, test and implement SSRS reports and SSIS packages and ensure standards are adhered to and results are accurate.
- Routinely perform detailed system analysis of complex databases and system integration using SQL server.
- SQL Server stored procedures, necessary indexes, functions and triggers.
- SSRS and SSIS design, development and implementation.
- Defined BI standards for SSRS, SSIS and reporting security.
- Used SSAS to begin development for better reporting using data cubes. Defined facts, dimensions and how needed to present data for best usage.
- Defined and assigned work to team members.
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Assisted multiple departments and staff to improve client satisfaction.
- Worked closely with software development and testing team members to design and develop solutions to meet client requirements for functionality, scalability and performance.
- Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues.
- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements.
- Led Business Intelligence team as Subject Matter Expert and primary point-of-contact for internal customers and management.
- Collected, defined and translated user requirements into project designs and implementation plans.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Developed custom database objects, stored procedures and delivered application support.
- Generated, debugged and enhanced existing reports with introduction of new system features.
- Reviewed and interpreted business report requirements to address user needs.
- Drove data analysis, resolving complex business issues and proposing long-term system solutions.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Worked with Informatica to identify where ETL errors occurred and identify changes for additional data needs or improvements.
- Drafted quarterly and yearly reports on company financial metrics to assess successes and account for deficiencies. Reduced manual work for end users by 50% and increased end user satisfaction and integrity.
Programmer Analyst
Southern Champion Tray
04.2007 - 09.2010
- Utilized .Net and RPG skills to integrate iSeries with .Net applications to support manufacturing and sales applications.
- SSIS, SSRS, SQL stored procedures, RPG applications and iSeries SQL applications and stored procedures.
- Design, development, testing and implementation of system applications using SSRS, VB.Net, ADO.Net, SQL Server and RPG.
- Successfully converted multiple DTS to SSIS Packages.
- Responsible for development of applications to process data between iSeries and .Net applications using ADO.Net for iSeries.
Programmer Analyst
U.S. Xpress Enterprises Inc.
03.1998 - 01.2007
- Progressed quickly from junior programmer to key contributor to IT Department, independently handling full life cycle application development, enhancements and technical support.
- Successfully led in design and development of transportation system conversion from iSeries to .Net utilizing VB.Net, Web Services and iSeries stored procedures.
- Complex program development, defining information systems requirements and application design.
- Experience in Financial Reporting, Accounts Receivable, Accounts Payable, Payable, General Ledger and Human Resources applications.
- Designed and developed Imaging system conversion for Driver Trip information and Accounts Payable. Also included setting up bar code scanning and data imports into iSeries and SQL server.
- Assisted with design, development and implementation of new Trailer Management system.
- Performed project management and analytical duties 3 months after becoming Junior Programmer.
Education
Associate of Science - Accounting
Chattanooga State Technical Community College
Chattanooga, TN 01.1989 - 1994.05
Skills
SQL Server, Snowflake, Oracle
undefinedReferences
Paula Ledbetter
Technology Director
Raymond James Bank
256-599-0289 Cell
1165 County Road 174
Flat Rock, AL 35966
paula.ledbetter@raymondjames.com
David Ramey
Senior Database Specialist
Blue Cross Blue Shield of Tennessee
423-503-5845
7415 Irongate Dr
Hixson, TN 37343
david_ramey@bcbst.com
Todd Johnson
Enterprise Architect
CAQH
423-401-0199
mtjohnso1@live.com
Timeline
Data Engineer
CAQH
11.2022 - Current
Data Analyst
CAQH
03.2022 - Current
Senior Database Engineer
Skillsoft
01.2021 - 03.2022
Reporting Analyst II
Blue Cross Blue Shield of Tennessee
02.2020 - 12.2020
Application Developer
Raymond James Financial
01.2016 - 02.2020
Business Reporting Analyst
Blue Cross Blue Shield Of Tennesee
10.2015 - 01.2016
Business Intelligence Analyst / Team Lead
U.S. Xpress Enterprises Inc.
09.2010 - 10.2015
Programmer Analyst
Southern Champion Tray
04.2007 - 09.2010
Programmer Analyst
U.S. Xpress Enterprises Inc.
03.1998 - 01.2007
Associate of Science - Accounting
Chattanooga State Technical Community College
01.1989 - 1994.05
Similar Profiles
Samuel AdaeSamuel Adae
Chief Manager, Information Security at CAQHChief Manager, Information Security at CAQH
Michelle ToscanoMichelle Toscano
Business Development Executive at CAQHBusiness Development Executive at CAQH
Marissa BrooksMarissa Brooks
Product Lead & UX Manager at CAQHProduct Lead & UX Manager at CAQH