Johnathan Brooks Email & Phone Number

California, United States

Mountain View, California, Us

Mountain View, California, Us

Mountain View, California, Us

Management & Leadership- Played an instrumental role in the growth of the organization from 3 employees to over 30, including starting both the data engineering and solutions architecture practices at the company- Co-managed both the data analytics and engineering departments, guiding and planning their personnel and technical growth plans as the combined teams grew from 2 members to over 15 today- Developed the internal analytics engineering philosophy at 4 Mile, including co-leading the launch of an analytics engineering practice, with a focus on architecting and implementing dbt- Led the hiring efforts for data engineers, solutions architects and department managers.- Started the partnership program and managed strategic technology partner relationships, including co-marketing and conference planning efforts- Acted as primary sales engineer by pitching new projects to our most strategic potential clientsTechnical- Designed, modeled and delivered enterprise data warehouse solutions built on Snowflake, BigQuery or Redshift for companies ranging in size from Fortune 100 to fast-growing startup- Built custom data extractors with Python to securely and reliably ingest data from multiple data sources into data lakes or warehouses- Orchestrated and productionized data processing and pipelines by implementing and deploying Apache Airflow for clients, designing and implementing CI/CD pipelines, and designing and launching SageMaker and MLOps- Delivered over 80% average query performance improvement results across multiple strategic data warehouse optimization projects, while implementing Kimball dimensional modeling and robust data quality testing- Collaborated with team members and clients on the deployment of over 100 Looker and dbt implementations- Led an IoT client's end-to-end migration to the cloud, including launching Kubernetes, architecture security, infrastructure as code via Terraform, data warehouse design, and Looker implementation and training

San Francisco, Ca, Us

Management & Leadership- Pitched and started the data analytics team, co-leading this new team to identify actionable KPIs through hypothesis testing (A/B testing) and building the foundational data model necessary to visualize outcomes with Power BI dashboards and Jupyter Notebooks.- Created specifications, analyzed usage data, and worked with key stakeholders and offshore developers, in an agile Scrum environment using JIRA, to drive development of new mission-critical audit application- Elected by management to create and lead internal analyst training in advanced database systems and SQLTechnical- Built mission-critical audit pricing system in SQL and Python which is used by the entire organization to price any medical claim based on any contract or payor in the United States. The system prices millions of claims and terabytes of data weekly, on average 95% faster than legacy systems, yielding over 15% increase in net revenue- Reduced IPPS & OPPS underpayment review process time by 70% by restructuring the data model, and acted as product manager to create a product backlog by working directly with heads of the Medicare department

San Francisco, Ca, Us

- Built, maintained and expanded audit pricing system using T-SQL that is used by the entire organization to identify underpaid claims. The pricing system prices millions of claims per week and is the primary revenue-driver for the company. Developed new pricing logic systems using T-SQL, performed query tuning optimization, indexing and scalability review, and managed the direction of SQL development. New pricing system is more efficient than prior system by a factor of over 100, bringing in millions for the organization.- Automated a pricing methodology using T-SQL that once took multiple days to price all volume by hand, now can be priced via three button clicks, saving hundreds of human hours.- Road-mapped, prioritized and coordinated with offshore and on-site C# developers to build the front-end desktop application implemented in the .NET framework with WPF. Solid understanding of XAML and working as a product manager in an agile Scrum environment.- Pitched and started new data analytics team, co-leading this new team to define and identify KPIs and begin implementing statistical computing into the audit platform.

San Francisco, Ca, Us

• Performed contract modeling, revenue cycle consulting, pricing audits, reimbursement analysis, and revenue recovery for Fortune 500 healthcare systems – generating over $20M in additional annual net revenue for clients.• Led Development and launched an algorithm performance analysis tool which returns raw data output on tool performance and identifies underperforming systems; built out in SQL, Access and Excel VBA using object oriented programming. • Engineered a machine learning random forest algorithm in Python for more efficiently and effectively identifying underpayments and developing predictive reimbursement trends.• Elected by management to lead training in advanced database systems and MS Access development.

• Development, consulting and supervising roles for a variety of small and medium-sized organizations, including services such as business intelligence analysis consulting, web application development with Node.JS and MongoDB (as well as PHP and MySQL), database security and upkeep, data science and data wrangling.• Consulted multiple organizations as a solutions architect in transitioning portions of their IT architecture to the Amazon Web Services (AWS) cloud - focusing on serverless implementations (Lambda, API Gateway) and database/storage solutions (DynamoDB, Redshift, S3).• Collaborated to build Support Vector Machine algorithm for image OCR, conducting algorithm modeling in MatLab/Octave and development in Python.• Renovated company websites and web applications via WordPress, Wix and Node.JS development, with consideration to interactive design for easy cellular viewing.• Consulted on database platform choice and structure, web security, MS Excel and Access development, and search engine optimization.

• Developed database applications in SQL Server, MySQL and MS Access - including back end databases for web applications and custom dashboards.• Conducted database administration processes, including security, backup, permissions, sharding, and interface development.• Installed mission critical servers, LANs, and back end systems for clients, working directly with in-house management and IT teams.• Worked directly with clients to make recommendations for network and IT solutions, including database structure and security consulting as well as software and hardware setup.• Implemented new in-house accounting system to significantly cut back on administrative time.

Los Angeles, Ca, Us

• Worked one-on-one with students of all writing abilities during 30-minute sessions to improve their argumentation, clarity, and organization. • Assisted students in formulating theses, synthesizing ideas and drafting research papers for classes in all majors and emphases at Occidental.• Assembled guides on the argumentation style, logical flow, syntax and general structure of papers written under the Mathematics and the Philosophy majors for all student body to use.• Doubled as an Economics and Mathematics Tutor as well.

• Assisted with server setup and software installation.• Acted as a resource to clients for IT support and Microsoft Office power user.• Delivered and repaired a variety of hardware for business clients.