Created the organizations first automated omni channel view of sales for US & European markets updated daily with comps to both Last Year and AOP totals, delivered daily via Tableau.Responsible for interviewing and translating requirements from subject matter experts and stakeholders; obtaining data from various sources such as Cognos BI, SQL databases, excel and flat files in order to visualize the information into actionable and impactful dashboards.Work with business users and analysts to train and assist them with Tableau.Proactively identify data issues and provide solutions/options to decision makers for implementation into dashboards/data sources.

• Built a daily dashboard which served as the source of truth for all KPIs regarding Walmart.com marketing performance.• Utilized Tableau to productionalize a Revenue Attribution tool which measured and evaluated the overall contribution of Visits, Conversion Rates and Average Order Value to Walmart.com.• Developed custom Hive queries to manipulate data into functional data sources for consumption into dashboard tools.• Worked with marketing and division stakeholders to create customized dashboard solutions to automate KPI reporting to the larger enterprise.• Initiated knowledge transfer sessions with new team members to facilitate domain knowledge specific to Walmart Marketing.

• Created dashboards and tools utilizing Tableau to transform current reporting needs into interactive data visualizations which identified trends and integrated with current Salesforce apps.• Built and modified complex SQL scripts to load, transform and map data into usable frameworks for analytics purposes.• Collaborated closely with data architects and developers to identify relevant data attributes and measures within the available sources and integrate these into an ongoing data warehouse development.

• Primary functions included requirements gathering, identifying and obtaining access to data sources, designing data models, building ETL pipelines (SSIS) to ingest data, and producing final dashboards/ visualizations to support Kaiser Network Service Engineering and PMO teams in a variety of areas.• Created a project estimation tool utilizing Tableau that enabled managers within the Network Services organization to accurately estimate the total labor hours by job role for projects based on historical data.• Functioned as the team DBA and worked on optimization of SQL jobs, scripts and ETL pipelines• Built monitoring tools in Tableau to assist with visibility into dashboard availability and data dependencies.

• Delivered information regarding the status of marketing campaigns on Wells Fargo’s public and secure websites using Tableau to create dashboards and worksheets which provided visibility into the data and identified trends within user experience.• Led weekly meetings with business stakeholders reviewing Marketing campaign performance for the website.• Created a simple and repeatable ETL pipeline using stored procedures in Teradata and orchestrated data pulls using SSIS into a localized data mart for ad-hoc and ongoing data enrichment.• Regularly monitored upstream data dependencies and created a suite of Tableau dashboards which systematically identified problematic or suspect data loads; these findings could be quickly communicated to partners who were responsible for the upstream systems of record.

• Built and maintained Tableau and Qlikview dashboards supporting report and analytics needs for enterprise customers.• Worked with physicians and service line program managers to collect requirements and acquire domain knowledge to deliver apps with actionable and useful insights.• Designed and developed pipelines to load disparate EMR and billing data into a centralized Data Warehouse.• Implemented a batch job processing architecture leveraging SQL and SQL Agent to monitor ETL processing & schedules.• Regularly built and optimized stored procedures to support companies growing data needs and diverse data sources.• Performed data analysis to mitigate potential issues, data cleanup and automation of tasks using SQL/SSIS.

• Responsible for the maintenance and development of new ETL pipelines on TRUECar’s production data warehouse, which supplied Truecar.com websites and APIs.• Completed documentation on the architecture and data dependencies of the entire production data warehouse, including all jobs, SSIS packages, Python scripts, Scheduled tasks and Hadoop tasks which either pushed or pulled data out of SQL Server.• Responsible for understanding internal and external data sources, translating into physical data models and documenting corresponding data dictionaries.

• Responsible for producing a monthly dashboard for internal lines of business, which measured sales activity initiated by Global Banking for Trade, Loan & Cross Sell product lines.• Simplified ETLs into systematic and logged processes with an emphasis on improving data quality from six (6) heterogeneous databases.• Implemented a dimensional model approach to the Global Banking data which incorporated a bottom-up design to support existing report deliverables.• Regularly created stored procedures and documentation for hand-off to production support team in India.• Primary Ad-Hoc report developer tasked with obtaining and analyzing the latest KPIs and delivering insights to internal team members.

• Developed multiple SSIS packages to move and transform multiple Terabytes of data from numerous Oracle databases into a single SQL Server instance.• Created database audit process to log results and track the SSIS packages progress, identifying any potential issues during execution.• Outlined a partition table strategy to improve data load performance which increased performance once the data was migrated to the new destination.• Implemented a Sliding Window partitioning solution to purge data older than three years without Server downtime.

Principal Architect for Data Warehouse

Database Administrator @ eLogic

Formerly ProcessClaims