Consultant, Data Analytics and Tableau Developer Resume

PROFESSIONAL EXPERIENCE

Confidential

Consultant, Data Analytics and Tableau Developer

Responsibilities:

Provided key data and performance indicators to management through automated Tableau dashboards
Designed and developed revenue models, dashboards, and other visualizations in Tableau and published to company intranet site via Tableau Server (with data sourced from SQL custom queries)
Sourced management requirements and determined KPI’s through interviews with management
Developed and implemented project plan to build Data Mart for use with Tableau dashboards
Reconciled Data Mart to underlying tables and built testing process to validate data after migrations
Converted SSRS reports into Tableau dashboards by sourcing requirements from SQL stored procedures
Facilitated training and knowledge transfer by instructing staff on Tableau use

Confidential

Financial Analyst and Tableau Project Manager

Responsibilities:

Managed P&L for emerging mobile application product by monitoring and projecting revenue, COS, net income
Analyzed KPIs and presented trends and analysis to senior management
Built reports and visualizations in Tableau to enhance management understanding of KPIs
Automated data processes by transitioning manual data gathering to database that could be accessed by Tableau
Developed proforma income statements for remainder of year forecasting and future year forecasting
Created business case analysis for future projects

Confidential

Business Analyst /Database Developer

Responsibilities:

Increased productivity of firm’s analysts through implementations of software such as Tableau, Globalscape EFT, as well as other proprietary software
Rebuilt core firm data visualizations in Tableau
Managed project to automate manual data conditioning process by facilitating implementation of data warehouse and ETL process. Translated SPSS conditioning syntax into SQL for transformations. Conditioned data in proprietary software tool and loaded into MS SQL Server data warehouse
Analyzed and tested data warehouse through the writing of SQL queries, running processes, and designing tests
Translated analytic processes for higher education enrollment data into requirements for automated tools
Provided services to external clients by facilitating the setup and maintenance of online scholarship calculator application by acquiring yearly inputs, facilitating testing, anticipating client needs, and ensuring satisfaction
Managed updates and development of five proprietary analytic applications by managing project goals and scope, interpreting business needs, quality testing, and introducing shared accountability for achieving project milestones
Created documentation for technology tools and assisted in training of both analysts and external clients
Introduced project management methodology to effectively plan projects, develop resources, and test results
Produced documentation such as Scope, Work Breakdown Structure, and Requirements Traceability Matrix

Confidential

Senior Accountant

Responsibilities:

Assisted in implementation of major accounting information data warehouse by articulating specifications, testing, logging defects, and overseeing that system met business intelligence needs
Designed new reporting process by leveraging business intelligence tools such as Business Objects
Coordinated and assisted in conversion and automation of management reports into Crystal Reports
Revised and improved accounting reports and composition methodology
Built data files using advanced Excel and Access techniques, integrating basic VBA and SQL
Prepared investment related financial reports for both GAAP and Statutory Insurance Accounting filings
Informed management of key trends in the investment portfolio through delivery of reports