Chris Hagarman Email & Phone Number

United States

• Using SSIS components such as Foreach Loop, Merge Join, Sort, variable expressions, and Data Conversion to validate, optimize and deploy packages that involve various sources such as JSON, CSV, RTF files, Excel, and databases from the company’s servers.• Become involved in the DW Data Modeling processes in pre-development stages by attending Scrum meetings and additional, impromptu meetings with Colaberry Staff, including Data Scientists and Chief Officers.• Use SQL languages such as DDL and DML to create SELECT statements and Stored Procedures, along with SQL Integration Services (SSIS) to use ETL in loading data into Staging Databases, ODS Databases, and from an OLTP to an OLAP system. • Create parameterized reports that involve Sub-Reports, Drilldowns, Drill-throughs, as well as appropriate chart designs to provide instructive insight for Colaberry.• Responsible for creating Colaberry Dashboards that include clickable and interactive graphs, charts, and matrix reports.• Create auditing columns for tables that allow for when the table was last altered and by whom.• Be able to multitask and remain organized with workload involving high-email correspondence and keep up with the well-being of tables and databases that you are responsible for.

Irving, Texas, United States

• Daily tasks include running merge joins, INSERT/DELETE record tasks. Display knowledge inaggregates such as averages, Max, etc. • With little to no oversight, create compelling graph reports with SSRS for Marketing and Magazine meetings. Provide good and bad insight regarding possible trends in readership, magazine sales, and magazine product demand.• Respond to work orders by way of ticketing system so as to be alerted to magazine subscription errors. Be aware of deadline-driven tickets (i.e., 911 tickets) and respond according to priority in combination with attending weekly meetings to discuss additional issues that need resolving.• Help schedule monthly Crystal Reports that provide magazine subscription data for management and circulation department during the first week of the month.• Use WinSCP for ftp and sftp downloads.• With the help of Excel, create monthly reports regarding Scout Life and Scouting magazine circulation numbers and sales to submit for auditing.• Be well-versed with the magazine’s customer database so as to better research and navigate issues with customer history within the database (Slowly Changing Dimensions) and also occasionally provide expertise on customer searches for Magazine Editors, BSA Marketing and Member Care Staff*Improve and implement new and legacy ETL packages with mostly 2012 SQL Integration Services,including building different databases and data warehouses with star and snowflake schemas.

Dallas/Fort Worth Area

Acted in stage play "With This Ring"

B.S., Communications

Activities and Societies: Film Club

Education record

Activities and Societies: Film Club