Provides data analytics and services to businesses.

Assessed business needs and defined requirements for data visualization tools and solutions.Create/used data maps to to create data models for storing data to be consumed by dashboards.Created and automated data pipeline scripts to migrate data to Hadoop data stack.Created and automated email alerts based on data: low inventory, project status, data anomalies.Assisted other teams members by providing visualization suggestions and coding help in various languages.Technologies used: React, Hack, Python, Tableau, SQL, Hadoop, Oracle, MySql, PHP and Javascript.

Discovered data migration issues in Hadoop DW using SQL and Excel, Created tickets in Jira to track issues to resolution.Assisted DB Architect resolve data migration issues by running queries against Oracle source DB and Hadoop DW.Built custom reports and templates in Jaspersoft reporting application to standardize reporting output for clients reports.integrated LDAP and TLS on Jaspersoft Web server so customers would have secure and single sign on access to reports.

Created scripts in Python to read, write, parse and analyze MS Excel and text files.Developed and documented process flows and procedures for internal teams and vendors.Wrote complex statements in SQL to discover and fix data caused by legacy lease terminations.Created graphs and charts in Tableau to visualize data into a story of leased assets past and present.Identified errors in vendor billing resulting in savings and credits close to $100K over a 6-month period.

Developed Web application enabling client’s customers to sign up for electronic delivery of documents. Built console application to distribute documents to clients email daily, weekly or individually.Utilized: VS 2012 w/TFS, C#, JavaScript, HTML, CSS, XML, Teradata DB, Web Services via WCF, DI/IOC

Worked with management to define key metrics to measure project efficiency for future process improvement.Developed and distributed (daily/weekly/monthly) dozens of reports supporting over 100 projects in flight.Normalized data from dozens of tables to views and tables for faster query speed making BI data accessible.Aggregated data via complex queries, scripts and stored procedures on Oracle 11g DB using SQL and PL/SQL.Created and supported dashboards, scorecards and other tools in Project and Portfolio Management tool (HP PPM) allowing leadership to monitor resources, budget, schedule and other data in their respective projects.Was ‘source of truth’ of financial reporting for projects with combined budget exceeding over $100M annually.Created web applications for more visual reporting of data using C#, XML, Flash and JavaScript on ASP.Net platform.