James Mission, CBIP
Head of Data Analytics at Flipside Crypto- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
CBIP - Certified Business Intelligence Professional, Specialty in Data Analysis and Design
The Data Warehousing InstituteAug, 2012- Nov, 2024
Experience
-
Flipside
-
United States
-
Data Infrastructure and Analytics
-
1 - 100 Employee
-
Head of Data Analytics
-
Jun 2021 - Present
Built out a world class analytics team from 1 full-time employee to close to 20. Leveraged a modern data stack(Snowflake, DBT, Tableau, and AWS) to curate 16+ different blockchains and serving Web3's best blockchain data in the world. Helped put in processes and infrastructure in place that allowed us to develop in house talent and have production grade data pipelines. Built out a world class analytics team from 1 full-time employee to close to 20. Leveraged a modern data stack(Snowflake, DBT, Tableau, and AWS) to curate 16+ different blockchains and serving Web3's best blockchain data in the world. Helped put in processes and infrastructure in place that allowed us to develop in house talent and have production grade data pipelines.
-
-
-
Mitek Systems
-
United States
-
Software Development
-
300 - 400 Employee
-
Head of Data Engineering and Analytics
-
Apr 2018 - May 2021
Helped grow a team with no prior data engineering/analytics experience to build a server less cloud analytics platform from scratch using AWS technologies (Kinesis, Lambdas, Glue, Athena) that was deployed with proper CI/CD pipelines using Git/Jenkins/Cloud Formation. Also incorporated Tableau online from scratch with over 100 users with an active monthly usage rate of 70%. Created and maintained a request process in JIRA to handle tickets and requests while using a Kanban best practices. Worked with many departments to help evangelize data and to create a Data Driven culture throughout the company. Helped streamline processes by creating tools that enabled end users to self serve and to help eliminate old and slow legacy archaic processes. Show less
-
-
-
Pluralsight
-
United States
-
E-Learning Providers
-
700 & Above Employee
-
Lead Data Engineer
-
Sep 2014 - Apr 2018
- Projects completed - Helped with POC to determine which Hadoop Environment we'd use (Cloudera vs Hortonworks) - Google Adwords to sql server automation with python - SQL Server to Google Big Query - Google Calendar to sql server for PTO tracking tool - SFTP to SQL Server (paylocity and radius HR data) - Relational DB to Hadoop library (FeastMode) - Custom Salesforce to hadoop Python Library - Custom Zuora to hadoop Python Library - Consuming Rabbit MQ messages - Built Company KPI's, Billings Dataset, Subscriber Snapshot dataset - Set Up Airflow workflow tool and used it for job automation - pulled S3 data to Hadoop - Searchlight, Wootric, Desk and other Rest API's with Python - Kafka to hadoop and hadoop to kafka python libraries - Created company wide hourly office fitness slack channel automated with python - Created python library that used slack for etl alerts Show less
-
-
-
Bridgepoint Education
-
United States
-
Education Management
-
700 & Above Employee
-
Lead Business Intelligence Engineer
-
Jan 2014 - Sep 2014
As a Lead Engineer, was in charge of migrating new internally created lead flow system data source into existing Data Warehouse as well as removing existing data sources that were eventually going to be sun setted. Optimized a Data Mart that has very high usage and visibility within the business, ETL speed by 50% cutting down the 6 hour ETL time to 3 hours. Was in charge of a Vertica P.O.C. Implementation that consisted of upgrading SQL Server Databases/tableau extracts to live Vertica connections. Did numerous presentations with stake holders and departments of what Data Warehousing is and it's importance within a company. Show less
-
-
-
Teradata
-
United States
-
Software Development
-
700 & Above Employee
-
Professional Services Business Intelligence Consultant
-
Dec 2012 - Jan 2014
Worked in the Communications Media Entertainment and Utilities companies for the west coast division of Teradata. Worked at Kaiser Permanente as a BI consultant helping with testing the system upgrade from Teradata 12 to Teradata 14. Created and ran scripts that saw query performance pre and post upgrade. Created automated query scripts using Kex Code. Helped tune queries that end users would have issues with post upgrade. Used multiple statistics that were stored in the DBQL Log tables to check CPU performance post upgrade. Show less
-
-
-
Bridgepoint Education
-
United States
-
Education Management
-
700 & Above Employee
-
Senior Business Intelligence Engineer
-
Aug 2011 - Dec 2012
Created an enterprise-wide Data Warehouse using the Microsoft SQL Stack that revolved around Online Education data using a SCRUM Agile development environment. Developed 3 star-schema based enterprise data marts using best practices and techniques, whose data was being used by thousands of end users within the company ranging from executives to admissions counselors. ETL processes used SSIS to pull source data from multiple data sources including, MySQL databases, SQL Server Databases, SharePoint Lists, Flat Files, and Excel Files etc. using a stage, cleansed, integrated, and load workflow. There was an auditing framework as well as an error handing framework built into the process. The data was on used on BI applications by the end users whom we trained and created templates for them to use, which included Tableau, SSRS, and Excel etc. Created SSAS cubes that fed off the data marts. Improved processes and cut down ETL time by using custom C# script tasks as well as advanced SSIS techniques, for example like using batch updates and source filtering before doing a merge-join. Added complete SCD1 auditing to certain dimensions by incorporating triggers on the batch update tables. Was a Tableau server administrator, maintained user/group access and licensing, maintenance of all of the jobs and extract refreshes. Did numerous demos, prototypes, and training sessions with the Tableau desktop application. Designated scrum master for the agile process during development sprints, ran daily scrum meetings, sprint planning, sprint retrospectives, and other scrum master tasks. Show less
-
-
-
UC San Diego Health
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Data Manager/Business Intelligence Specialist
-
Aug 2010 - Aug 2011
Worked in the Planning Department and strategically designed and implemented BI software and systems, including integration with databases and data warehouses dealing with hospital information that were millions of records in size. Selected, blueprinted, gathered requirements, designed, developed, tested, documented, and rolled out BI solutions to end users, which were Business Developers, Chief Officers, and Department Chairs. Maintained security and access rights for those users for dynamic SSRS reports that contained HIPAA compliant data. Merged different BI platforms from multiple data sources to a central data mart housed on a server that I maintained. Used automated ETL processes to keep information up to date and that scrubbed/cleaned the data. Worked directly and trained end users on using the BI Tools. Received feedback to whether the tools met business requirements for project completion, as well as provide technical support. Troubleshot BI tools, systems, and software; performance-tuned these applications as necessary. Researched the latest technologies to use on reports, used GIS maps that were integrated into SQL Server 2008 R2 for spatial data needed to map specific regions that tied to the hospital information for a visual representation of the data. Also worked with the Space Management team to create databases and reports for space planning. Show less
-
-
-
CareFusion
-
United States
-
Medical Equipment Manufacturing
-
700 & Above Employee
-
Analyst, Clinical Specialty
-
Nov 2008 - Aug 2010
Analyzed Giga-Bytes of hospital data using SQL and Excel. Used custom SQL queries and pivot tables to create reports. Dealt with infusion data, medicine station data, and other medical devices data. Went over these packets with hospital’s Director of Pharmacy, Chief Nursing Officers, Risk Managers, and other hospital management to show key takeaways, navigation, and data calculations from the report. Has created over 500+ reports and was in charge of 150+ hospitals. Also helped automate the report making process by using languages such as JavaScript and C#. Also helps develop production applications using c# and ASP.net. Was the SME for Infusion Analytics at Carefusion. Has traveled and flown to regions of the country to do presentations in from of dozens of hospitals regarding Infusion Analytics reports. As well as doing hundreds of web teleconference calls. Created, planned out, and developed a CRM database housing all Alaris customer data using SQL Server 2008 and ASP.net with a Web Interface that was used in production. The project was part of a Lean Six Sigma project to improve the reporting process for Infusion Analytics. Did Software QA testing for the Pyxis Med Analytics as well as the Alaris Infusion Analytics. Show less
-
-
-
Mitchell International
-
United States
-
Software Development
-
700 & Above Employee
-
Quality Software Engineer, Intern
-
Jan 2008 - Nov 2008
As an intern at Mitchell, helped create and analyze data for the Integration department. Worked with test plans and created test data in accordance with that plan. As a side project was given the task of developing/maintaining the website for the EIG QA department, which used Flash with Adobe Flash CS3 and ASP.net and HTML to develop on Visual Studio 2005. As an intern at Mitchell, helped create and analyze data for the Integration department. Worked with test plans and created test data in accordance with that plan. As a side project was given the task of developing/maintaining the website for the EIG QA department, which used Flash with Adobe Flash CS3 and ASP.net and HTML to develop on Visual Studio 2005.
-
-
Education
-
2003 - 2007
San Diego State University-California State University
BS, Computer Engineering
Community
