Jonah Johnson Email & Phone Number

Mclean, Va, Us

Leveraging 15 years of experience in technology and process improvement, I serve as a Consultant to clients spanning multiple industries as well as the public sector.I specialize in Tableau and Tableau CRM (Einstein Analytics).

San Francisco, California, Us

I provide reporting and analytics on the metadata which produces the bank’s risk and regulatory reports. While I have advanced technical skills, I am an even stronger business leader and process designer. - Built visibility into the data supply chain - Created a method to project the completion date of 500 international reports - Identified and resolved gaps in the Risk & Control framework

Charlotte, Nc, Us

I lead a team of Tableau developers which supports four feature teams within the bank’s Wholesale Credit division. The team includes a highly distributed onshore/offshore team.• Data Controls: I co-designed a reporting framework which allows the bank to define, execute, and monitor a variety of data controls. These controls include periodic manual attestations, automated data quality checks, summarized data movement controls, and timeliness controls. The toolset includes Tableau, MicroStrategy, Oracle, and Hadoop. The controls are applied to dozens of systems of record and follow the data as it is transformed and distributed to downstream consumers and regulatory entities.

Charlotte, Nc, Us

I am volunteering my time and data analysis/visualization skills to help end lead poisoning in the city of Oakland. I built a data model which combines disparate sets of data to identify homes which are likely suffering from lead contamination. I perform solution design, ETL, descriptive analytics, predictive analytics, and data visualization.In a few short months and in partnership with community activists, I have built a revolutionary BI solution which will have a lasting impact on the city of Oakland. This solution is poised to spread throughout the country.

Chicago, Illinois, Us

Established a consistent and predictable delivery schedule of Essbase, Hyperion Planning, and HFM enhancements using an Agile framework. Assisting in the conversion from BO and Crystal reports to OBIEE.Agile Methodology• I lead a daily stand-up meeting in which scrum team members provide time-boxed commitments for their work and bring attention to blockers.• I facilitate a weekly backlog grooming session with product owners and agile team members to groom the backlog, clarify requirements, and reprioritize user stories.• I work with the agile team members to plan sprints in terms of relative effort• After each sprint, I lead a sprint review, in which the work which was deliver, and not delivered is discussed.• I help improve the velocity and morale of the team by facilitating a monthly sprint retrospective, in which successes and opportunities for improvement are discussed.Establish Framework• Designed a cross-file transfer system to help Bank of the West and BNP Paribas securely exchange files.• Assisted the Hyperion system administrator in designing and implementing a disaster recovery strategy.• Creating technical documentation for Oracle’s Hyperion Suite (Essbase, Planning, HFM, FDMEE, DRM, and Financial Reports)Business Objects to OBIEE Conversion• Designed data models for foreign currency exchange business unit and Small Business Administration lending group.• Coach business analysts to move beyond tabular reports into data visualization and analysis.• Assisting with the design and testing of OBIEE and BI Publisher reports.Working on creating and managing project plans for the report conversion of the two business units listed above.

Walnut Creek, Ca, Us

Data Modeling• After learning about relevant business objectives, I gathered data from multiple source systems, such as Oracle, SQLServer, Hive, and CSV files.• I built data models in Tableau to define relationships between multiple data sources.Tableau Report and Dashboard Design• I built a set of dashboards to help the Usage-Based Insurance team understand the driving habits of a group of AAA drivers• I built a dashboard to help executives understand how all IT staff allocate their time and how the time is funded.• I built a BI solution to explain how all incidents, problems, change requests, and releases are handled.• I built an "Application Availability" BI suite to demonstrate how several hundred software applications perform.• I built a webpage which embeds reports designed to be accessed through a large touchscreen monitor.Tableau Administration• I worked with the system administrators to install Tableau Server in a virtual environment. This allowed me to share the reports with 50 other users.• I performed BI admin tasks such as monitoring, scheduling, and access provisioning.Telematics• I helped improve the company’s usage-based insurance product by identifying trends in customer experience, device fulfillment and operational anomalies.• I leveraged data from a variety of sources including a Hadoop/Hive environment, Cognos, Excel, and relational databases to provide actionable insights to the telematics strategy team.I designed and deployed a large touchscreen data visualization which encourages people in our lobby to interact with Telematics data. This involved data extraction from Hive, Tableau report design, video editing, website design, and data security measures.

Jacksonville, Florida, Us

Responsible for the design and development of a Pentaho BI platform which is offered commercially to several hundred clients in the form of SaaS. The platform presents information from all aspects of the healthcare equipment supply chain and enables improved spending power through proper data aggregation.• Evaluated multiple BI vendors to select the most appropriate tool-set• Performed data modeling for an extensive data warehouse• Responsible for BI implementation and development with small team• Interact with internal and external customers to develop and sell the BI suite

Phoenix, Az, Us

Began as an entry-level clerk and received at least one promotion per year to end up as a senior BI analyst. • Automated accounting processes to decrease operational expense and improve accuracy• Managed direct reports to improve performance and productivity• Created custom BI solution to reduce and recover bad debt• Designed enterprise data strategy for BI platform• Assisted in defining corporate standards (lexicon and governance) for data objects