Tracy A. Email and Phone Number

Architect and build data pipelines for the intake of health care data, including medical and pharmacy claims data and CMS Stars Ratings data.

Develop Python and PySpark scripts for data collection and analysis. Develop Terraform scripts to build and launch on demand EC2 instances and EMR clusters, using custom AMI’s and writing shell scripts to bootstrap instances. Build and maintain resources within AWS services, including S3, EC2, VPC, and EMR. Design, create, and update Talend ETL jobs to import and transform data to an AWS Redshift data warehouse.

Lead the teams responsible for reporting and internal business operations for the organization. Gather requirements for reporting from all business units, including C-level executives. Design and write multiple reports against reference database and ODS. Provide reports and data analysis for business units across the organization. Design and create all sales and marketing reports and dashboards in Salesforce. Integral part of Code42’s Salesforce implementation team, responsible for all data migration from source systems. Assist in design of operational data store and internal reporting tool.

Create and update Pentaho jobs and shell scripts to import, extract and transform data forexternal clients. Work with business analysts to develop and implement processes for customer implementations, customer renewals, and data integrations. Work with technical operations to implement and support software based solutions. Played an integral role in annual customerrenewal project.

Create and update AWK, Perl, and shell scripts and MySQL stored procedures for transforming and integrating data from multiple sources into reference database. Regularly audit reference database and write scripts/stored procedures to correct data as needed. Develop reports and processes to measure product impact and accuracy for individual clients. Design, build, and test methods to improve product impact and accuracy. Assist in daily loads and weekly migrations of data. Research, analyze, and audit potential new sources for data. Assist in modeling and updating reference database tables as new sources of data acquired. Worked with Enclarity executive team on discovery and played key role in decision-making on several company and data acquisitions.

● Design and DevelopmentDesign and write reports off of the data warehouse for internal users in multiple departments and for external clients, using Cognos Impromptu. Design and write programs to automate daily data warehouse functions. Work with executives to write reports that enable analysis of key business metrics. Played an integral role in two-year project to migrate data from legacy source system to PeopleSoft Staffing.● Data Warehouse OperationsWrite and maintain extract and load programs and PL/SQL stored procedures for a financials-based Oracle 9i data warehouse and multiple data marts. Oversee the production schedule of the data warehouse. Maintain data warehouse security and access. Maintain statistics and quality checks on the data warehouse. Analyze data and support users as issues arise.

● Data Warehouse OperationsWrite and maintain extract and load programs, shell scripts, and stored procedures for the data warehouse. Oversee the production schedule of the data warehouse. Maintain statistics and quality checks on the data warehouse. Act as liaison for data warehouse users’ issues and concerns. Analyze data, write fix programs, and support users as issues arise.● Design and DevelopmentWrite design specification documents and programs for systems integration after company acquisition. Write design specification documents and programs for scrubbing incoming data. Write programs for custom client audit extracts.

Hired, trained, supervised, and reviewed employees in full-time, part-time and seasonal positions. Forecasted and managed sales and payroll budgets for store with over $2million in annual revenue, increasing productivity for three consecutive years asmanager. Oversaw mail-order operation generating $2 million in revenue. Conductedweekly sales and training meetings. Created sales incentives to coordinate with catalogand store promotions. Created Office Manager guide, used in training new associates.